using DevExpress.XtraEditors; using DevExpress.XtraGrid.Views.Grid; using Gs.DevApp.Entity; using Gs.DevApp.ToolBox; using Gs.DevApp.UserControl; using Newtonsoft.Json; using Newtonsoft.Json.Linq; using System; using System.Collections.Generic; using System.Data; using System.Threading.Tasks; using System.Windows.Forms; namespace Gs.DevApp.DevFrm { public partial class Frm_Wompba : DevExpress.XtraEditors.XtraForm { string _webServiceName = "WompbaManager/"; List _filterList = new List(); string _cjBm = "";//车间 public Frm_Wompba() { InitializeComponent(); this.toolBarMenu1.btnAddClick += ToolBarMenu1_btnAddClick; this.toolBarMenu1.btnEdtClick += ToolBarMenu1_btnEdtClick; this.toolBarMenu1.btnSaveClick += ToolBarMenu1_btnSaveClick; this.toolBarMenu1.btnLoadClick += ToolBarMenu1_btnLoadClick; this.toolBarMenu1.btnDelClick += ToolBarMenu1_btnDelClick1; this.toolBarMenu1.btnEscClick += ToolBarMenu1_btnEscClick; this.toolBarMenu1.btnQueryClick += ToolBarMenu1_btnQueryClick; toolBarMenu1.btnChkClick += ToolBarMenu1_btnChkClick; toolBarMenu1.btnFChkClick += ToolBarMenu1_btnFChkClick; toolBarMenu1.btnLogClick += ToolBarMenu1_btnLogClick; this.toolBarMenu1.getXmlConfig(); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx1); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameter(gridView1, null, null, null, "", (value) => { Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 0); }, tips, true, (strGuid) => { getModelList(strGuid); }); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameter(gridView1, picCheckBox, this, "fstatus", "", (value) => { Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 0); }, tips); Gs.DevApp.ToolBox.UtilityHelper.SetTabParameter(gridView1, xtraTabControl1, pageBar1, (value) => { getModel(value); }, (value) => { getPageList(this.pageBar1.CurrentPage); }, lbGuid); getPageList(1); pageBar1.PagerEvent += PageBar1_PagerEvent; //选存组织(变明细中的物料和车间) txt_erpSczz.EditChanged += (s, e) => { string _orgId = txt_erpSczz.GetId(); if (string.IsNullOrEmpty(_orgId)) return; txt_pba013.getSuppler(_orgId, _cjBm); _getListDepot(_orgId); }; // 选择车间(变明细中产线) txt_pba013.EditChanged += (s, e) => { string workGuid = this.txt_pba013.GetId(); _getListJybz(workGuid); }; //选择需要的明细 btnSelect.Click += (s, e) => { if (string.IsNullOrEmpty(this.txt_pba013.GetId())) { Gs.DevApp.ToolBox.MsgHelper.ShowError("请先选择车间,才能选择任务单!"); return; } var frm = new SelectWompba(this.txt_pba013.GetId()); //赋值给明细表 frm.UpdateParent += (ss, ee) => { try { var lst = new List(); lst = ee.StringList; var _obj = lst; var strReturn = UtilityHelper.HttpPost("", "WompbaManager/SelectPbaToView", JsonConvert.SerializeObject(_obj)); var dt = UtilityHelper.ReturnToList(strReturn); DataTable _newTable = dt.rtnData; DataTable _oldTable = (DataTable)gcMx1.DataSource; DataRow[] sourceRows = _newTable.Select(); for (int i = 0; i < sourceRows.Length; i++) { _oldTable.ImportRow(sourceRows[i]); } // 确保自动调拨相关列存在,便于下拉赋值 if (!_oldTable.Columns.Contains("dbDepotId")) _oldTable.Columns.Add("dbDepotId", typeof(string)); if (!_oldTable.Columns.Contains("depotName")) _oldTable.Columns.Add("depotName", typeof(string)); if (!_oldTable.Columns.Contains("dbDepotSections")) _oldTable.Columns.Add("dbDepotSections", typeof(string)); gcMx1.BindingContext = new BindingContext(); gcMx1.DataSource = _oldTable; gvMx1.CloseEditor(); gvMx1.PostEditor(); gvMx1.UpdateCurrentRow(); gcMx1.ForceInitialize(); gvMx1.BestFitColumns(); Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gvMx1); } catch (Exception ex) { MsgHelper.ShowError("提示:" + ex.Message); } }; frm.ShowDialog(); }; gvMx1.ShowingEditor += (s, e) => { if (gvMx1.FocusedColumn == gvMx1DepotSections) { string depotId = gvMx1.GetRowCellValue(gvMx1.FocusedRowHandle, "dbDepotId")?.ToString(); _getListDepotSections(depotId); } }; gvMx1.CellValueChanged += (s, e) => { if (e.RowHandle < 0) return; if (e.Column == gvMx1DepotName) { var depotId = gvMx1.GetRowCellValue(e.RowHandle, "dbDepotId")?.ToString(); // 清空库位并根据仓库ID加载库位下拉 gvMx1.SetRowCellValue(e.RowHandle, "dbDepotSections", null); _getListDepotSections(depotId); } }; } private void GridView1_ColumnFilterChanged(object sender, EventArgs e) { _filterList = Gs.DevApp.ToolBox.UtilityHelper.GetDilter(gridView1.Columns, gridView1); Task.Delay(100); getPageList(1); } /// /// 分页事件 /// /// /// private void PageBar1_PagerEvent(int curPage, int pageSize) { getPageList(curPage); } /// /// 查询事件 /// /// /// private void ToolBarMenu1_btnQueryClick(object sender, EventArgs e) { gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged; gridView1.ActiveFilter.Clear(); gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged; var frm = new ShowFilter(gridView1.Columns, _filterList, this.GetType().FullName); frm.UpdateParent += Frm_UpdateParent; frm.ShowDialog(); } /// /// 查询回调 /// /// /// private void Frm_UpdateParent(object sender, UpdateParentEventArgs e) { _filterList = e.FilterList; getPageList(1); } /// /// 日志 /// /// /// private void ToolBarMenu1_btnLogClick(object sender, EventArgs e) { toolBarMenu1.guidKey = ""; string rowGuid, rowName; (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_hNo, gridView1); toolBarMenu1.guidKey = rowGuid; } /// /// 取消事件 /// /// /// private void ToolBarMenu1_btnEscClick(object sender, EventArgs e) { Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 1); } /// /// 删除事件 /// /// /// private void ToolBarMenu1_btnDelClick1(object sender, EventArgs e) { string rowGuid = "", rowName = ""; (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_hNo, gridView1, "hNo"); if (string.IsNullOrEmpty(rowGuid)) { MsgHelper.ShowError("请先选择你要操作的行!"); return; } if (!MsgHelper.AskQuestion("你选择了【" + rowName + "】,确定删除吗?")) return; var _obj = new { guid = rowGuid, mxGuid = Guid.Empty.ToString(), }; try { var strJson = UtilityHelper.HttpPost("", _webServiceName + "DeleteModelOrMx", JsonConvert.SerializeObject(_obj)); var _rtn = UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 0) { MsgHelper.ShowInformation("提示:" + _rtn.rtnMsg); if (xtraTabControl1.SelectedTabPageIndex == 0) { } else Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 2); getPageList(this.pageBar1.CurrentPage); } else MsgHelper.ShowError("提示:" + _rtn.rtnMsg); } catch (Exception ex) { MsgHelper.ShowError("提示:" + ex.Message); } } /// /// 刷新事件 /// /// /// private void ToolBarMenu1_btnLoadClick(object sender, EventArgs e) { if (xtraTabControl1.SelectedTabPageIndex == 1) getModel(lbGuid.Text.Trim()); else { //_filterList.Clear(); //if (gridView1.ActiveFilter.Count > 0) //{ // gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged; // gridView1.ActiveFilter.Clear(); // gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged; //} //getPageList(1); getPageList(this.pageBar1.CurrentPage); } } /// /// 审核事件 /// /// /// private void ToolBarMenu1_btnChkClick(object sender, EventArgs e) { _toolCk(1, "EditModelSubmit"); } /// /// 反审核 /// /// /// /// private void ToolBarMenu1_btnFChkClick(object sender, EventArgs e) { _toolCk(0, "EditModelSubmitFSH"); } /// /// 修改事件 /// /// /// private void ToolBarMenu1_btnEdtClick(object sender, EventArgs e) { string rowGuid, rowName; (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_hNo, gridView1); if (string.IsNullOrEmpty(rowGuid)) { MsgHelper.ShowError("请先选择你要操作的行!"); return; } toolBarMenu1.currentAction = "edit"; Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 3); if (xtraTabControl1.SelectedTabPageIndex == 1) { getModel(rowGuid); } else { List gvList = new List(); gvList.Add(gvMx1); UtilityHelper.ChangeEnableByControl(this.layoutMx1.Controls, true, gvList); gvMx1DepotName.OptionsColumn.ReadOnly = false; gvMx1DepotName.OptionsColumn.AllowEdit = true; gvMx1DepotSections.OptionsColumn.ReadOnly = false; gvMx1DepotSections.OptionsColumn.AllowEdit = true; if (btnBatchSetDepotSections != null) btnBatchSetDepotSections.Enabled = true; } //2025/07/12加上修改状态下不能修改 txt_erpSczz.IsReadly = true; } /// /// 新增事件 /// /// /// private void ToolBarMenu1_btnAddClick(object sender, EventArgs e) { lbGuid.Text = ""; Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 4); List gridViews = new List(); gridViews.Add(gvMx1); UtilityHelper.CleanValueByControl(this.layoutMx1.Controls, true, gridViews); Gs.DevApp.ToolBox.UtilityHelper.SetDefaultTable(gcMx1, gvMx1); //增加时,默认组织 string deftOrg = UtilityHelper.GetFirstOrg(txt_erpSczz); } /// /// 保存事件 /// /// /// private void ToolBarMenu1_btnSaveClick(object sender, EventArgs e) { toolBarMenu1.isSetBtn = false; string workId = txt_pba013.GetId(); if (string.IsNullOrEmpty(workId.Trim())) { Gs.DevApp.ToolBox.MsgHelper.ShowError("请选择车间!"); txt_pba013.Focus(); return; } var _obj = new { guid = UtilityHelper.ToGuid(lbGuid.Text.Trim()), //主建 bz = txt_pba009.Text.Trim(), cjId = workId, list = new List(), }; gvMx1.CloseEditor(); gvMx1.PostEditor(); gvMx1.UpdateCurrentRow(); if (gvMx1.DataRowCount <= 0) { MsgHelper.ShowError("明细不能为空,请选择明细!"); return; } for (var i = 0; i < gvMx1.DataRowCount; i++) { var row = gvMx1.GetDataRow(i); if (row != null) { Guid? _guid = UtilityHelper.ToGuid(row["guid"].ToString()); if (string.IsNullOrEmpty(row["daa025"].ToString())) { MsgHelper.ShowError("生产类型不能为空!"); return; } string _LineId = row["daa015"].ToString(); if (string.IsNullOrEmpty(_LineId)) { MsgHelper.ShowError("线别不能为空!"); return; } if (Gs.DevApp.ToolBox.UtilityHelper.ToDecimal(row["daa008"].ToString()) <= 0) { MsgHelper.ShowError("请输入正确的排产数量!"); return; } string _Yjkgsj = row["mesStartProd"].ToString(); if (string.IsNullOrEmpty(_Yjkgsj)) { MsgHelper.ShowError("预计开工时间不能为空!"); return; } string _mesEndProd = row["mesEndProd"].ToString(); if (string.IsNullOrEmpty(_mesEndProd)) { MsgHelper.ShowError("预计完工时间不能为空!"); return; } var _isCheckObj = row["isCheck"]; bool _isAuto = false; if (_isCheckObj is bool _b) _isAuto = _b; else { var _s = _isCheckObj == null ? "" : _isCheckObj.ToString(); _isAuto = _s == "1" || string.Equals(_s, "true", System.StringComparison.OrdinalIgnoreCase); } if (_isAuto) { var _depotId = row["dbDepotId"] == null ? "" : row["dbDepotId"].ToString(); var _depotSections = row["dbDepotSections"] == null ? "" : row["dbDepotSections"].ToString(); if (string.IsNullOrWhiteSpace(_depotId)) { MsgHelper.ShowError("自动调拨仓库不能为空!"); return; } if (string.IsNullOrWhiteSpace(_depotSections)) { MsgHelper.ShowError("自动调拨库位不能为空!"); return; } } _obj.list.Add(new { Guid = _guid, AboutGuid = Gs.DevApp.ToolBox.UtilityHelper.ToGuid(row["caaGuid"].ToString()), LineId = row["daa015"].ToString(),//产线id Hxsj = row["daa025"].ToString(),//生产类型 Yjkgsj = (row["mesStartProd"].ToString()),//预计开工时间 Yjwgsj = row["mesEndProd"].ToString(),//预计完工时间 Pcsl = row["daa008"].ToString(),//排产数量 Bz = row["daa009"].ToString(),//备注 IsZddb = row["isCheck"].ToString(),//是否自动调拨 DepotId = row["dbDepotId"].ToString(),//仓库ID DepotSections = row["dbDepotSections"].ToString()//仓库库位 }); } } try { string strJson = UtilityHelper.HttpPost("", _webServiceName + "EditModel", JsonConvert.SerializeObject(_obj)); ReturnModel _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 0) { ToolBox.MsgHelper.ShowInformation("提示:" + _rtn.rtnMsg); lbGuid.Text = _rtn.rtnData.outGuid; txt_hNo.Text = _rtn.rtnData.outNo; toolBarMenu1.isSetBtn = true; List gvList = new List(); gvList.Add(gvMx1); UtilityHelper.ChangeEnableByControl(this.layoutMx1.Controls, false, gvList); toolBarMenu1.currentAction = ""; if (btnBatchSetDepotSections != null) btnBatchSetDepotSections.Enabled = false; Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 6); } else ToolBox.MsgHelper.ShowError("提示:" + _rtn.rtnMsg); } catch (Exception ex) { ToolBox.MsgHelper.ShowError("提示:" + ex.Message); } } private void btnBatchSetDepotSections_Click(object sender, EventArgs e) { var selected = gvMx1.GetSelectedRows(); if (selected == null || selected.Length == 0) { MsgHelper.ShowError("请先在最左侧选择需要批量赋值的行!"); return; } // 预加载仓库列表 string orgId = txt_erpSczz.GetId(); _getListDepot(orgId); // 构建弹框 var dlg = new DevExpress.XtraEditors.XtraForm(); dlg.Text = "批量赋值自动调拨库位"; dlg.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedDialog; dlg.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent; dlg.MaximizeBox = false; dlg.MinimizeBox = false; dlg.Width = 420; dlg.Height = 220; var lblDepot = new DevExpress.XtraEditors.LabelControl() { Text = "仓库名称:", Left = 15, Top = 20, Width = 80 }; var cboDepot = new DevExpress.XtraEditors.ComboBoxEdit() { Left = 100, Top = 16, Width = 280 }; cboDepot.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor; foreach (var item in this.rptDepotName.Items) { cboDepot.Properties.Items.Add(item); } var lblSection = new DevExpress.XtraEditors.LabelControl() { Text = "库位:", Left = 15, Top = 60, Width = 80 }; var cboSection = new DevExpress.XtraEditors.ComboBoxEdit() { Left = 100, Top = 56, Width = 280 }; cboSection.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor; var chkAuto = new DevExpress.XtraEditors.CheckEdit() { Left = 15, Top = 96, Width = 200, Text = "同时勾选自动调拨标识", Checked = true }; var btnOk = new DevExpress.XtraEditors.SimpleButton() { Left = 200, Top = 130, Width = 80, Text = "确定" }; var btnCancel = new DevExpress.XtraEditors.SimpleButton() { Left = 300, Top = 130, Width = 80, Text = "取消" }; cboDepot.SelectedIndexChanged += (s, ev) => { var itm = cboDepot.EditValue as CboItemEntity; var depotId = itm == null ? null : itm.Value?.ToString(); _getListDepotSections(depotId); cboSection.Properties.Items.Clear(); foreach (var sec in this.rptDepotSections.Items) { cboSection.Properties.Items.Add(sec); } cboSection.EditValue = null; }; btnCancel.Click += (s, ev) => { dlg.DialogResult = System.Windows.Forms.DialogResult.Cancel; dlg.Close(); }; btnOk.Click += (s, ev) => { var depotItem = cboDepot.EditValue as CboItemEntity; var sectionItem = cboSection.EditValue as CboItemEntity; if (depotItem == null) { MsgHelper.ShowError("请选择仓库名称!"); return; } if (sectionItem == null) { MsgHelper.ShowError("请选择库位!"); return; } var depotId = depotItem.Value?.ToString(); var depotName = depotItem.Text?.ToString(); var sectionCode = sectionItem.Text?.ToString(); gvMx1.BeginUpdate(); foreach (var handle in selected) { if (handle < 0) continue; gvMx1.SetRowCellValue(handle, "dbDepotId", depotId); gvMx1.SetRowCellValue(handle, "depotName", depotName); gvMx1.SetRowCellValue(handle, "dbDepotSections", sectionCode); gvMx1.SetRowCellValue(handle, "isCheck", true); } gvMx1.EndUpdate(); gvMx1.CloseEditor(); gvMx1.PostEditor(); gvMx1.UpdateCurrentRow(); dlg.DialogResult = System.Windows.Forms.DialogResult.OK; dlg.Close(); }; dlg.Controls.Add(lblDepot); dlg.Controls.Add(cboDepot); dlg.Controls.Add(lblSection); dlg.Controls.Add(cboSection); dlg.Controls.Add(chkAuto); dlg.Controls.Add(btnOk); dlg.Controls.Add(btnCancel); dlg.ShowDialog(this); } /// /// /// /// 第几页 /// 每页几条 private void getPageList(int curPage) { gcMain1.DataSource = null; System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder(); _sbSqlWhere.Append(" and a.ERP_SCZZ in"); _sbSqlWhere.Append(ToolBox.UtilityHelper.GetOrgWhere()); _sbSqlWhere.Append(UtilityHelper.GetSearchWhere(_filterList)); PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "create_date", "asc", "", _sbSqlWhere.ToString()); string json = JsonConvert.SerializeObject(pgq); try { var strReturn = UtilityHelper.HttpPost("", _webServiceName + "GetListPage", json); ReturnModel dd = UtilityHelper.ReturnToTablePage(strReturn); if (dd.rtnCode > 0) { DataTable dt = dd.rtnData.list; gcMain1.BindingContext = new BindingContext(); gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged; if (dt.Rows.Count > 0) { gcMain1.DataSource = dt; gcMain1.ForceInitialize(); gridView1.BestFitColumns(); Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gridView1); } else UtilityHelper.SetDefaultTable(gcMain1, gridView1); gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged; pageBar1.TotalPages = dd.rtnData.pages;//总页 pageBar1.CurrentPage = curPage;//当前页 pageBar1.RecordCount = dd.rtnData.total;//总记录数 } else { ToolBox.MsgHelper.ShowError("提示:" + dd.rtnMsg); } } catch (Exception ex) { ToolBox.MsgHelper.ShowError("提示:" + ex.Message); } } private void getModel(string strGuid) { bool isEdit = false; if (toolBarMenu1.currentAction == "add") return; if (toolBarMenu1.currentAction == "edit") isEdit = true; if (string.IsNullOrEmpty(strGuid)) { MsgHelper.ShowError("请先选择你要操作的行!"); return; } var _obj = new { guid = strGuid,//主建 }; try { string strJson = UtilityHelper.HttpPost("", _webServiceName + "GetModel", JsonConvert.SerializeObject(_obj)); ReturnModel _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 0) { dynamic dy = _rtn.rtnData; _cjBm = dy.pba013; lbGuid.Text = strGuid; List gvList = new List(); gvList.Add(gvMx1); UtilityHelper.SetValueByObj(this.layoutMx1.Controls, dy, isEdit, gvList); _cjBm = ""; JObject _job = JObject.Parse(strJson); JArray array = new JArray(); foreach (var a in _job["rtnData"]["list"]) { array.Add(a); } DataTable dt = JsonConvert.DeserializeObject(array.ToString()); if (dt.Rows.Count > 0) { if (!dt.Columns.Contains("DbDepotId")) dt.Columns.Add("DbDepotId", typeof(string)); if (!dt.Columns.Contains("DepotName")) dt.Columns.Add("DepotName", typeof(string)); if (!dt.Columns.Contains("DbDepotSections")) dt.Columns.Add("DbDepotSections", typeof(string)); gcMx1.BindingContext = new BindingContext(); gcMx1.DataSource = dt; gcMx1.ForceInitialize(); gvMx1.BestFitColumns(); Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gvMx1); if (btnBatchSetDepotSections != null) btnBatchSetDepotSections.Enabled = isEdit; } else { Gs.DevApp.ToolBox.UtilityHelper.SetDefaultTable(gcMx1, gvMx1); } } else ToolBox.MsgHelper.ShowError("提示:" + _rtn.rtnMsg); } catch (Exception ex) { ToolBox.MsgHelper.ShowError("提示:" + ex.Message); } } private void repositoryItemButtonEdit1_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { var rowhandle = gvMx1.FocusedRowHandle; if (rowhandle < 0) return; if (e.Button.Index == 0) { var dr = gvMx1.GetDataRow(rowhandle); var mxGuid = dr["guid"].ToString(); if (!MsgHelper.AskQuestion("你选择了1条数据,确定删除吗?")) return; if (string.IsNullOrEmpty(mxGuid)) { gvMx1.DeleteRow(rowhandle); return; } var _obj = new { guid = lbGuid.Text.Trim(), mxGuid = mxGuid, }; try { var strJson = UtilityHelper.HttpPost("", _webServiceName + "DeleteModelOrMx", JsonConvert.SerializeObject(_obj)); var _rtn = UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 0) { MsgHelper.ShowInformation("提示:" + _rtn.rtnMsg); getModel(lbGuid.Text); } else MsgHelper.ShowError("提示:" + _rtn.rtnMsg); } catch (Exception ex) { MsgHelper.ShowError("提示:" + ex.Message); } } } /// /// 根据车间读产线 /// /// private void _getListJybz(string workGuid) { rptJYBZ.Items.Clear(); if (string.IsNullOrEmpty(workGuid)) return; var _sbSqlWhere = " and 1=1 and dpt_id=" + workGuid; var pgq = new PageQueryModel(1, 999999, "a.line_no", "asc", "", _sbSqlWhere.ToString()); var json = JsonConvert.SerializeObject(pgq); try { var strReturn = UtilityHelper.HttpPost("", "MesWorkshopLineManager/GetListPage", json); var dd = UtilityHelper.ReturnToTablePage(strReturn); DataTable dt = dd.rtnData.list; foreach (DataRow dr in dt.Rows) { rptJYBZ.Items.Add((new CboItemEntity(dr["id"].ToString(), dr["name"].ToString()))); } } catch (Exception ex) { MsgHelper.ShowError("提示:" + ex.Message); } } private void rptJYBZ_SelectedIndexChanged(object sender, EventArgs e) { ComboBoxEdit comboBox = sender as ComboBoxEdit; if (comboBox != null) { GridView myView = (gcMx1.MainView as GridView); int dataIndex = myView.GetDataSourceRowIndex(myView.FocusedRowHandle); CboItemEntity _itm = comboBox.EditValue as CboItemEntity; string _val = _itm.Value.ToString(); string _txt = _itm.Text.ToString(); gvMx1.CloseEditor(); gvMx1.PostEditor(); gvMx1.UpdateCurrentRow(); gvMx1.SetRowCellValue(dataIndex, "daa015LineName", _txt); gvMx1.SetRowCellValue(dataIndex, "daa015", _val); } } private void rptDepotName_SelectedIndexChanged(object sender, EventArgs e) { ComboBoxEdit comboBox = sender as ComboBoxEdit; if (comboBox != null) { GridView myView = (gcMx1.MainView as GridView); int dataIndex = myView.GetDataSourceRowIndex(myView.FocusedRowHandle); CboItemEntity _itm = comboBox.EditValue as CboItemEntity; if (_itm == null) return; string depotId = _itm.Value.ToString(); string depotName = _itm.Text.ToString(); gvMx1.CloseEditor(); gvMx1.PostEditor(); gvMx1.UpdateCurrentRow(); gvMx1.SetRowCellValue(dataIndex, "dbDepotId", depotId); gvMx1.SetRowCellValue(dataIndex, "depotName", depotName); // 清空库位并根据仓库ID加载库位列表 gvMx1.SetRowCellValue(dataIndex, "dbDepotSections", null); _getListDepotSections(depotId); } } private void rptDepotSections_SelectedIndexChanged(object sender, EventArgs e) { ComboBoxEdit comboBox = sender as ComboBoxEdit; if (comboBox != null) { GridView myView = (gcMx1.MainView as GridView); int dataIndex = myView.GetDataSourceRowIndex(myView.FocusedRowHandle); CboItemEntity _itm = comboBox.EditValue as CboItemEntity; if (_itm == null) return; string sectionCode = _itm.Text.ToString(); gvMx1.CloseEditor(); gvMx1.PostEditor(); gvMx1.UpdateCurrentRow(); gvMx1.SetRowCellValue(dataIndex, "dbDepotSections", sectionCode); } } private void _getListDepot(string orgId) { try { var pgq = new PageQueryModel(1, 999999, "org.FNumber asc ,a.depot_code", "asc", "", " and is_ng='A'" + (string.IsNullOrEmpty(orgId) ? "" : (" and a.FSubsidiary='" + orgId + "'"))); var json = JsonConvert.SerializeObject(pgq); var strReturn = UtilityHelper.HttpPost("", "MesDepotsManager/GetListPage", json); var rtn = UtilityHelper.ReturnToTablePage(strReturn); var dt = rtn.rtnData.list; this.rptDepotName.Items.Clear(); foreach (System.Data.DataRow dr in dt.Rows) { this.rptDepotName.Items.Add(new CboItemEntity(dr["depotId"].ToString(), dr["depotName"].ToString())); } } catch (Exception ex) { MsgHelper.Warning("提示:" + ex.Message); } } private void _getListDepotSections(string depotId) { try { if (string.IsNullOrEmpty(depotId)) { this.rptDepotSections.Items.Clear(); return; } var pgq = new PageQueryModel(1, 999999, "b.xh", "asc", "", " and is_ng='A' and a.depot_id='" + depotId + "'" ); var json = JsonConvert.SerializeObject(pgq); var strReturn = UtilityHelper.HttpPost("", "MesDepotSectionsManager/GetListPage", json); var rtn = UtilityHelper.ReturnToTablePage(strReturn); var dt = rtn.rtnData.list; this.rptDepotSections.Items.Clear(); foreach (System.Data.DataRow dr in dt.Rows) { this.rptDepotSections.Items.Add(new CboItemEntity(dr["depotSectionCode"].ToString(), dr["depotSectionCode"].ToString())); } } catch (Exception ex) { MsgHelper.Warning("提示:" + ex.Message); } } /// /// 新增方法:列表显示 /// /// 主表id private void getModelList(string strGuid) { gcMxL1.DataSource = null; var _obj = new { guid = strGuid,//主建 }; try { string strJson = UtilityHelper.HttpPost("", _webServiceName + "GetModel", JsonConvert.SerializeObject(_obj)); ReturnModel _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 0) { dynamic dy = _rtn.rtnData; JArray array1 = new JArray(); foreach (var a in dy["list"]) { array1.Add(a); } DataTable dt1 = JsonConvert.DeserializeObject(array1.ToString()); if (dt1.Rows.Count > 0) { gcMxL1.BindingContext = new BindingContext(); gcMxL1.DataSource = dt1; gcMxL1.ForceInitialize(); gridView4.BestFitColumns(); Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gridView4); } else { Gs.DevApp.ToolBox.UtilityHelper.SetDefaultTable(gcMxL1, gridView4); } } else ToolBox.MsgHelper.Warning("提示:" + _rtn.rtnMsg); } catch (Exception ex) { ToolBox.MsgHelper.Warning("提示:" + ex.Message); } } /// /// 工具条事件 /// /// private void _toolCk(int _inFieldValue, string _mth) { string strMsg = ""; switch (_inFieldValue) { case 1: strMsg = "审核"; break; case 0: strMsg = "反审核"; break; } ; toolBarMenu1.guidKey = ""; string rowGuid, rowName; (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_hNo, gridView1, "hNo"); if (string.IsNullOrEmpty(rowGuid)) { MsgHelper.Warning("请先选择你要操作的行!"); return; } if (!MsgHelper.AskQuestion("你选择了【" + rowName + "】,确定" + strMsg + "吗?")) return; var _obj = new { guid = rowGuid, inFieldValue = _inFieldValue, }; try { var strJson = UtilityHelper.HttpPost("", _webServiceName + _mth, JsonConvert.SerializeObject(_obj)); var _rtn = UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 0 && _rtn.rtnData.outSum * 1 > 0) { MsgHelper.ShowInformation(_rtn.rtnData.outMsg.ToString()); if (xtraTabControl1.SelectedTabPageIndex == 1) { getModel(lbGuid.Text.Trim()); } int rowHandle = gridView1.LocateByValue(1, gridView1.Columns["guid"], rowGuid); gridView1.FocusedRowHandle = rowHandle; UtilityHelper.SetCheckIco(gridView1, "fstatus", "checkUser", "checkDate", picCheckBox, this, _inFieldValue.ToString()); } else MsgHelper.ShowError(_rtn.rtnData.outMsg.ToString()); } catch (Exception ex) { MsgHelper.ShowError("提示:" + ex.Message); } } /// /// 批量处理明细按钮点击事件 /// /// /// private void btnMultiSelect_Click(object sender, EventArgs e) { try { // 获取明细表格的GridView GridView myView = (gcMx1.MainView as GridView); if (myView == null) { MsgHelper.Warning("无法获取明细表格!"); return; } // 获取选中的行 int[] selectedRows = myView.GetSelectedRows(); if (selectedRows == null || selectedRows.Length == 0) { MsgHelper.Warning("请先选择要处理的明细行!"); return; } // 构建选中行的数据列表 var selectedData = new List(); foreach (int rowHandle in selectedRows) { if (rowHandle >= 0) // 确保是有效的数据行 { var rowData = new { guid = myView.GetRowCellValue(rowHandle, "guid")?.ToString(), daa002 = myView.GetRowCellValue(rowHandle, "daa002")?.ToString(), daa003 = myView.GetRowCellValue(rowHandle, "daa003")?.ToString(), daa005 = myView.GetRowCellValue(rowHandle, "daa005")?.ToString(), daa010 = myView.GetRowCellValue(rowHandle, "daa010")?.ToString() }; selectedData.Add(rowData); } } if (selectedData.Count == 0) { MsgHelper.Warning("没有有效的明细数据被选中!"); return; } // 确认操作 if (!MsgHelper.AskQuestion($"您选择了 {selectedData.Count} 条明细记录,确定要进行批量处理吗?")) return; // 构建API请求参数 var requestData = new { selectedDetails = selectedData, operationType = "BatchProcess", // 操作类型 operatorGuid = lbGuid.Text.Trim() // 当前操作的主单据GUID }; // 调用API(仿照现有的API调用模式) string apiUrl = "WompbaGxManager/BatchProcessDetails"; // API地址 var strJson = UtilityHelper.HttpPost("", apiUrl, JsonConvert.SerializeObject(requestData)); var _rtn = UtilityHelper.ReturnToDynamic(strJson); // 处理返回结果 MsgHelper.Warning(_rtn.rtnData.outMsg.ToString()); if (_rtn.rtnCode > 0 && _rtn.rtnData.outSum * 1 > 0) { // 成功后刷新明细数据 getModel(lbGuid.Text.Trim()); //MsgHelper.Information("批量处理完成!"); } } catch (Exception ex) { MsgHelper.Warning("批量处理失败:" + ex.Message); } } } }