查询

lu

2025-03-21 5572195c2d91b1145a3360f0e3651aa67ea425db

 DevApp/Gs.DevApp/UserControl/ShowFilter.cs

@@ -240,51 +240,55 @@
        }
        private void BtnSqlTable_Click(object sender, EventArgs e)
        {
            //System.Text.StringBuilder sb = new System.Text.StringBuilder();
            //var list = txt_table.Properties.Items.GetCheckedValues();
            //foreach (var obj in list)
            //{
            //    if (sb.Length > 0)
            //        sb.Append(",");
            //    sb.Append(_getTableName(obj.ToString()));

            //}

            //if (sb.Length < 0)
            //{
            //    Gs.DevApp.ToolBox.MsgHelper.Warning("请选择关联表！");
            //    txt_table.Focus();
            //    return;
            //}

            //var _obj = new
            //{
            //    guid = UtilityHelper.ToGuid(lbGuid.Text.Trim()), //主建
            //    djlx = djlx,//单据类型
            //    salesId = _sqGuid,//销售单号
            //    inRemark = FNote.Trim(),//备注
            //    list = new List<dynamic>(),
            //};
            //try
            //{
            //    string strJson = UtilityHelper.HttpPost("", _webServiceName + "EditModel", JsonConvert.SerializeObject(_obj));
            //    ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
            //    ToolBox.MsgHelper.Warning("提示：" + _rtn.rtnMsg);
            //    if (_rtn.rtnCode > 0)
            //    {
            //        lbGuid.Text = _rtn.rtnData.outGuid;
            //        txt_billNo.Text = _rtn.rtnData.outNo;
            //        toolBarMenu1.isSetBtn = true;
            //        List<DevExpress.XtraGrid.Views.Grid.GridView> gvList = new List<DevExpress.XtraGrid.Views.Grid.GridView>();
            //        gvList.Add(gvMx1);
            //        UtilityHelper.ChangeEnableByControl(this.layoutMx1.Controls, false, gvList);
            //        toolBarMenu1.currentAction = "";
            //    }
            //}
            //catch (Exception ex)
            //{
            //    ToolBox.MsgHelper.Warning("提示：" + ex.Message);
            //}
            if (string.IsNullOrEmpty(_fullName))
            {
                Gs.DevApp.ToolBox.MsgHelper.Warning("请选择页面！");
                return;
            }
            var _obj = new
            {
                formPath = _fullName,
                list = new List<dynamic>(),
            };
            gvTable.CloseEditor();
            gvTable.UpdateCurrentRow();
            if (gvTable.DataRowCount <= 0)
            {
                MsgHelper.ShowError("明细不能为空，请选择你的明细！");
                return;
            }
            for (var i = 0; i < gvTable.DataRowCount; i++)
            {
                var row = gvTable.GetDataRow(i);
                if (row != null)
                {
                    string _msl = row["tableOtherName"].ToString();
                    if (string.IsNullOrEmpty(_msl))
                    {
                        MsgHelper.ShowError("别名不能为空！");
                        return;
                    }
                    _obj.list.Add(new
                    {
                        tableName = (row["tableName"].ToString()),
                        tableOtherName = row["tableOtherName"].ToString(),
                    });
                }
            }
            try
            {
                string strJson = UtilityHelper.HttpPost("", "Fm/EditQuery", JsonConvert.SerializeObject(_obj));
                ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
                ToolBox.MsgHelper.Warning("提示：" + _rtn.rtnMsg);
                if (_rtn.rtnCode > 0)
                {
                    getPageListQuery();
                }
            }
            catch (Exception ex)
            {
                ToolBox.MsgHelper.Warning("提示：" + ex.Message);
            }

        }
        private void getPageListQuery()
@@ -312,6 +316,14 @@
                    "Fm/GetQuery", JsonConvert.SerializeObject(_obj));
                ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
                JObject _job = JObject.Parse(strJson);
                //读前选择
                JArray array00 = new JArray();
                foreach (var a in _job["rtnData"]["list3"])
                {
                    array00.Add(a);
                }
                DataTable dt00 = JsonConvert.DeserializeObject<DataTable>(array00.ToString());
                this.repositoryItemSearchLookUpEdit1.DataSource = dt00;
                ////////////
                JArray array = new JArray();
                foreach (var a in _job["rtnData"]["list"])
@@ -319,9 +331,17 @@
                    array.Add(a);
                }
                DataTable dt = JsonConvert.DeserializeObject<DataTable>(array.ToString());
                if (dt.Rows.Count > 0)
                {
                gcTable.BindingContext = new BindingContext();
                gcTable.DataSource = dt;
                gcTable.ForceInitialize();
                    gvTable.BestFitColumns();
                }
                else
                {
                    Gs.DevApp.ToolBox.UtilityHelper.SetDefaultTable(gcTable, gvTable);
                }
                ////////////
                JArray array2 = new JArray();
                foreach (var a in _job["rtnData"]["list2"])
@@ -332,12 +352,65 @@
                gcQuery.BindingContext = new BindingContext();
                gcQuery.DataSource = dt2;
                gcQuery.ForceInitialize();
                gvQuery.BestFitColumns();
            }
            catch (Exception ex)
            {
                MsgHelper.Warning("提示：" + ex.Message);
            }
        }

        private void repositoryItemSearchLookUpEdit1_EditValueChanged(object sender, EventArgs e)
        {
            SearchLookUpEdit LookupEdit = sender as SearchLookUpEdit;
            DataRowView SelectedDataRow = (DataRowView)LookupEdit.GetSelectedDataRow();
            gvTable.SetFocusedRowCellValue("tableName", SelectedDataRow["tableName"].ToString());
            gvTable.SetFocusedRowCellValue("tableCap", SelectedDataRow["tableCap"].ToString());
            gvTable.CloseEditor();
            gvTable.PostEditor();
            gvTable.UpdateCurrentRow();
        }
        private void repositoryItemButtonEdit2_ButtonClick(object sender, ButtonPressedEventArgs e)
        {
            var rowhandle = gvTable.FocusedRowHandle;
            if (rowhandle < 0)
                return;
            if (e.Button.Index == 0)
            {
                var dr = gvTable.GetDataRow(rowhandle);
                var mxGuid = dr["guid"].ToString();
                if (!MsgHelper.AskQuestion("你选择了1条数据，确定删除吗？"))
                    return;
                if (string.IsNullOrEmpty(mxGuid))
                {
                    gvTable.DeleteRow(rowhandle);
                    return;
                }
                var _obj = new
                {
                    guid = mxGuid,
                };
                try
                {
                    var strJson = UtilityHelper.HttpPost("",
                        "Fm/DeleteQuery",
                        JsonConvert.SerializeObject(_obj));
                    var _rtn = UtilityHelper.ReturnToDynamic(strJson);
                    if (_rtn.rtnCode > 0)
                    {
                        if (_rtn.rtnCode > 0) getPageListQuery();
                    }
                    MsgHelper.Warning("提示：" + _rtn.rtnMsg);
                }
                catch (Exception ex)
                {
                    MsgHelper.Warning("提示：" + ex.Message);
                }
            }
        }

        #endregion


    }
}