using DevExpress.ClipboardSource.SpreadsheetML; using DevExpress.XtraEditors; using DevExpress.XtraEditors.Repository; using DevExpress.XtraPrinting.Native; 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.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using System.Windows.Media.Animation; namespace Gs.DevApp.DevFrm.JJGZ { public partial class Frm_MESJJERRORJS : DevExpress.XtraEditors.XtraForm { string _webServiceName = "MesJjgzErrorJs/"; List _filterList = new List(); public Frm_MESJJERRORJS() { InitializeComponent(); gridView2.CellValueChanged += gridView2_CellValueChanged; 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; this.toolBarMenu1.getXmlConfig(); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameter(gridView1, picCheckBox, this, "checkStatus", "", (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; //选择需要入库的明细 btnSelect.Click += (s, e) => { var frm = new SelectSTAFF(); //赋值给明细表 frm.UpdateParent += (ss, ee) => { try { var lst = new List(); lst = ee.StringList; var _obj = lst; var strReturn = UtilityHelper.HttpPost("", "MesJjgzErrorJs/SelectPbaToView", JsonConvert.SerializeObject(_obj)); ReturnModel _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strReturn); dynamic dy = _rtn.rtnData.list; JObject _job = JObject.Parse(strReturn); JArray array = new JArray(); foreach (var a in _job["rtnData"]["list"]) { array.Add(a); } DataTable _newTable = JsonConvert.DeserializeObject(array.ToString()); DataTable _oldTable = _newTable.Clone(); DataRow[] sourceRows = _newTable.Select(); for (int i = 0; i < sourceRows.Length; i++) { _oldTable.ImportRow(sourceRows[i]); } gridControl1.BindingContext = new BindingContext(); gridControl1.DataSource = _oldTable; gridControl1.ForceInitialize(); Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gridView2); } catch (Exception ex) { MessageBox.Show(ex.Message); } }; frm.ShowDialog(); }; GetWORKSHOPLINE(); } /// /// 获取下拉框数据 /// private void GetTimeType() { try { string strJson = UtilityHelper.HttpPost("", _webServiceName + "GetTimeType", ""); ReturnModel _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 0) { dynamic dy = _rtn.rtnData; 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()); txt_HourlyType.Properties.ValueMember = "计时类型"; txt_HourlyType.Properties.DisplayMember = "计时类型"; txt_HourlyType.Properties.ShowClearButton = false; txt_HourlyType.Properties.DataSource = dt; } else { ToolBox.MsgHelper.Warning("提示:" + _rtn.rtnMsg); } } catch (Exception ex) { ToolBox.MsgHelper.Warning("提示:" + ex.Message); } } /// /// 获取下拉框数据 /// private void GetWOMDAAInfo() { try { string strJson = UtilityHelper.HttpPost("", _webServiceName + "GetWOMDAAInfo", ""); ReturnModel _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 0) { dynamic dy = _rtn.rtnData; 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()); txt_DAA001.Properties.ValueMember = "工单号"; txt_DAA001.Properties.DisplayMember = "工单号"; txt_DAA001.Properties.ShowClearButton = false; txt_DAA001.Properties.DataSource = dt; } else { ToolBox.MsgHelper.Warning("提示:" + _rtn.rtnMsg); } } catch (Exception ex) { ToolBox.MsgHelper.Warning("提示:" + ex.Message); } } /// /// 获取下拉框数据 /// private void GetWORKSHOPLINE() { try { string strJson = UtilityHelper.HttpPost("", _webServiceName + "GetWORKSHOPLINE", ""); ReturnModel _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 0) { dynamic dy = _rtn.rtnData; 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()); this.repositoryItemSearchLookUpEdit1.ValueMember = "产线"; this.repositoryItemSearchLookUpEdit1.DisplayMember = "产线"; this.repositoryItemSearchLookUpEdit1.DataSource = dt; } else { ToolBox.MsgHelper.Warning("提示:" + _rtn.rtnMsg); } } catch (Exception ex) { ToolBox.MsgHelper.Warning("提示:" + ex.Message); } } private async void GridView1_ColumnFilterChanged(object sender, EventArgs e) { _filterList = Gs.DevApp.ToolBox.UtilityHelper.GetDilter(gridView1.Columns, gridView1); await 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_btnChkClick(object sender, EventArgs e) { _toolCk(1); } /// /// 反审核 /// /// /// /// private void ToolBarMenu1_btnFChkClick(object sender, EventArgs e) { _toolCk(0); } /// /// 取消事件 /// /// /// 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_Guid, gridView1, "guid"); if (string.IsNullOrEmpty(rowGuid)) { ToolBox.MsgHelper.Warning("请先选择你要操作的行!"); return; } if (!MsgHelper.AskQuestion("你选择了【" + rowName + "】,确定删除吗?")) return; List lst = new List(); lst.Add(rowGuid); var _obj = new { guid = rowGuid, mxGuid = Guid.Empty.ToString(), }; try { string strJson = UtilityHelper.HttpPost("", _webServiceName + "DeleteModel", JsonConvert.SerializeObject(_obj)); ReturnModel _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 0) { if (xtraTabControl1.SelectedTabPageIndex == 0) { } else Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 2); getPageList(this.pageBar1.CurrentPage); } ToolBox.MsgHelper.Warning("提示:" + _rtn.rtnMsg); } catch (Exception ex) { ToolBox.MsgHelper.Warning("提示:" + 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); GetTimeType(); GetWOMDAAInfo(); } } /// /// 新增事件 /// /// /// private void ToolBarMenu1_btnAddClick(object sender, EventArgs e) { lbGuid.Text = ""; Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 4); List gridViews = new List(); gridViews.Add(gridView1); gridViews.Add(gridView2); UtilityHelper.CleanValueByControl(this.layoutMx1.Controls, true, gridViews); Gs.DevApp.ToolBox.UtilityHelper.SetDefaultTable(gcMain1, gridView1); Gs.DevApp.ToolBox.UtilityHelper.SetDefaultTable(gridControl1, gridView2); txt_ErrorType.EditValue = "计时工时"; GetTimeType(); GetWOMDAAInfo(); } private void ToolBarMenu1_btnEdtClick(object sender, EventArgs e) { string rowGuid, rowName; (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_Guid, gridView1); if (string.IsNullOrEmpty(rowGuid)) { MsgHelper.Warning("请先选择你要操作的行!"); return; } Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 3); getModel(rowGuid); GetTimeType(); GetWOMDAAInfo(); } /// /// 保存事件 /// /// /// private void ToolBarMenu1_btnSaveClick(object sender, EventArgs e) { toolBarMenu1.isSetBtn = false; if (string.IsNullOrWhiteSpace( txt_HourlyType.Text)) { Gs.DevApp.ToolBox.MsgHelper.Warning("请选择计时类型!"); txt_HourlyType.Focus(); return; } if (string.IsNullOrWhiteSpace(txt_ErrorTime.Text)) { Gs.DevApp.ToolBox.MsgHelper.Warning("请选择生效日期!"); txt_ErrorTime.Focus(); return; } var _obj = new { guid = UtilityHelper.ToGuid(lbGuid.Text.Trim()), //主建 errorNo = txt_ErrorNo.Text.Trim(),//异常单号 hourlyType = txt_HourlyType.Text.Trim(),//计时类型 errorType = txt_ErrorType.Text.Trim(),//单据类型 errorTime = txt_ErrorTime.Text.Trim(),//异常日期 hourlySalary = txt_HourlySalary.Text.Trim(), remark = txt_Remark.Text.Trim(),//说明 DAA001 = txt_DAA001.Text.Trim(),//工单号 DAAType = txt_DAAType.Text.Trim(),//工单类型 list = new List(), }; gridView2.CloseEditor(); gridView2.PostEditor(); gridView2.UpdateCurrentRow(); if (gridView2.DataRowCount <= 0) { MsgHelper.ShowError("明细不能为空,请选择你的明细!"); return; } for (var i = 0; i < gridView2.DataRowCount; i++) { var row = gridView2.GetDataRow(i); if (row != null) { Guid? _guid = UtilityHelper.ToGuid(row["id"].ToString()); if (string.IsNullOrEmpty(row["staffId"].ToString())) { MsgHelper.ShowError("员工不能为空!"); return; } if (string.IsNullOrEmpty(row["hour"].ToString())) { MsgHelper.ShowError("时长不能为空!"); return; } if (string.IsNullOrEmpty(row["lineNo"].ToString())) { MsgHelper.ShowError("生产线不能为空!"); return; } if (string.IsNullOrEmpty(row["salary"].ToString())) { MsgHelper.ShowError("计时工资不能为空!"); return; } _obj.list.Add(new { Guid = _guid, ID = Gs.DevApp.ToolBox.UtilityHelper.ToGuid(row["id"].ToString()), Staff_Id = row["staffId"].ToString(), Staff_No = row["staffNo"].ToString(), Staff_Name = row["staffName"].ToString(), Hour = row["hour"].ToString(), //计时类型 Line_No = row["lineNo"].ToString(), Line_Name = row["lineName"].ToString(), Salary = row["salary"].ToString(), //计时工资 Remark = row["remark"].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; toolBarMenu1.isSetBtn = true; List gvList = new List(); UtilityHelper.ChangeEnableByControl(this.layoutMx1.Controls, false, gvList); toolBarMenu1.currentAction = ""; Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 6); } else ToolBox.MsgHelper.ShowError("提示:" + _rtn.rtnMsg); } catch (Exception ex) { ToolBox.MsgHelper.ShowError("提示:" + ex.Message); } } /// /// /// /// 第几页 /// 每页几条 private void getPageList(int curPage) { gcMain1.DataSource = null; var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList); var pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "", "", "", _sbSqlWhere.ToString()); var json = JsonConvert.SerializeObject(pgq); try { var strReturn = UtilityHelper.HttpPost("", _webServiceName + "GetListPage", json); var 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) { 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)) { ToolBox.MsgHelper.Warning("请先选择你要操作的行!"); 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; lbGuid.Text = strGuid; UtilityHelper.SetValueByObj(this.layoutMx1.Controls, dy, isEdit); // 控制明细表可编辑状态 List gvList = new List(); gvList.Add(gridView2); UtilityHelper.SetValueByObj(this.layoutMx1.Controls, dy, isEdit, gvList); 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) { gridControl1.BindingContext = new BindingContext(); gridControl1.DataSource = dt; gridControl1.ForceInitialize(); gridView2.BestFitColumns(); Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gridView2); } else { Gs.DevApp.ToolBox.UtilityHelper.SetDefaultTable(gridControl1, gridView2); } } else ToolBox.MsgHelper.Warning("提示:" + _rtn.rtnMsg); } catch (Exception ex) { ToolBox.MsgHelper.Warning("提示:" + ex.Message); } } /// /// 工具条事件 /// /// private void _toolCk(int _inFieldValue) { string strMsg = ""; switch (_inFieldValue) { case 1: strMsg = "审核"; break; case 0: strMsg = "反审核"; break; } ; toolBarMenu1.guidKey = ""; string rowGuid, rowName; (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_Guid, gridView1, "guid"); if (string.IsNullOrEmpty(rowGuid)) { MsgHelper.Warning("请先选择你要操作的行!"); return; } if (!MsgHelper.AskQuestion("你选择了【" + rowName + "】,确定" + strMsg + "吗?")) return; var _obj = new { guid = rowGuid, ckValue = _inFieldValue, parameter = "MES_JJGZ_ERRORJS,check_Date,check_Status,check_user" }; try { var strJson = UtilityHelper.HttpPost("", "General/GeneralCheck", JsonConvert.SerializeObject(_obj)); var _rtn = UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 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, "checkStatus", "checkBy", "checkDate", picCheckBox, this, _inFieldValue.ToString()); } else MsgHelper.ShowError(_rtn.rtnData.outMsg.ToString()); } catch (Exception ex) { MsgHelper.ShowError("提示:" + ex.Message); } } private void txt_HourlyType_EditValueChanged(object sender, EventArgs e) { SearchLookUpEdit LookupEdit = sender as SearchLookUpEdit; DataRowView SelectedDataRow = (DataRowView)LookupEdit.GetSelectedDataRow(); if (SelectedDataRow != null) { txt_HourlyType.EditValue = SelectedDataRow["计时类型"].ToString(); txt_HourlySalary.EditValue = SelectedDataRow["计时单价"]; } } private void repositoryItemSearchLookUpEdit1_EditValueChanged(object sender, EventArgs e) { SearchLookUpEdit LookupEdit = sender as SearchLookUpEdit; DataRowView SelectedDataRow = (DataRowView)LookupEdit.GetSelectedDataRow(); gridView2.SetFocusedRowCellValue("lineNo", SelectedDataRow["产线"]); gridView2.SetFocusedRowCellValue("lineName", SelectedDataRow["产线名称"]); } /// /// 移出明细 /// /// /// private void repositoryItemButtonEdit1_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { var rowhandle = gridView2.FocusedRowHandle; if (rowhandle < 0) return; if (e.Button.Index == 0) { if (!MsgHelper.AskQuestion("你选择了1条数据,确定删除吗?")) return; gridView2.DeleteRow(rowhandle); } } private void gridView2_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) { if (e.Column.FieldName == "hour") { var row = gridView2.GetDataRow(e.RowHandle); if (row != null) { decimal hourlySalary = 0; decimal hour = 0; // 获取计时单价 decimal.TryParse(txt_HourlySalary.Text, out hourlySalary); // 获取时长 decimal.TryParse(row["hour"]?.ToString(), out hour); // 计算计时工资 row["salary"] = hourlySalary * hour; } } } } }