using System; using System.Collections.Generic; using System.Data; using System.Threading.Tasks; using System.Windows.Forms; using DevExpress.XtraEditors; using DevExpress.XtraGrid.Views.Grid; using Gs.DevApp.Entity; using Gs.DevApp.ToolBox; using Gs.DevApp.UserControl; using MES.Service.Modes; using Newtonsoft.Json; using Newtonsoft.Json.Linq; namespace Gs.DevApp.DevFrm.QC { public partial class Frm_MesQmCheckitemDt : XtraForm { private List _filterList = new List(); private readonly string _webServiceName = "MesQmCheckitemManager/"; public Frm_MesQmCheckitemDt() { InitializeComponent(); toolBarMenu1.btnAddClick += ToolBarMenu1_btnAddClick; toolBarMenu1.btnEdtClick += ToolBarMenu1_btnEdtClick; toolBarMenu1.btnSaveClick += ToolBarMenu1_btnSaveClick; toolBarMenu1.btnLoadClick += ToolBarMenu1_btnLoadClick; toolBarMenu1.btnDelClick += ToolBarMenu1_btnDelClick1; toolBarMenu1.btnEscClick += ToolBarMenu1_btnEscClick; toolBarMenu1.btnQueryClick += ToolBarMenu1_btnQueryClick; toolBarMenu1.btnChkClick += ToolBarMenu1_btnChkClick; toolBarMenu1.btnPiZhunClick += ToolBarMenu1_btnPiZhunClick; this.toolBarMenu1.getXmlConfig(); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx1); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameter(gridView1, picCheckBox, this, "foneChecked", "", (value) => { Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 0); }); Gs.DevApp.ToolBox.UtilityHelper.SetTabParameter(gridView1, xtraTabControl1, pageBar1, (value) => { getModel(value); }, (value) => { getPageList(this.pageBar1.CurrentPage); }); getPageList(1); pageBar1.PagerEvent += PageBar1_PagerEvent; _setIno(); btnSelect.Click += (s, e) => { var frm = new SelectCheckDt("jyxm"); frm.UpdateParent += (ss, ee) => { var lst = ee.DynamicList; var json = JsonConvert.SerializeObject(lst); DataTable _newTable = (DataTable)JsonConvert.DeserializeObject(json, (typeof(DataTable))); DataTable _oldTable = (DataTable)gridControl2.DataSource; DataRow[] sourceRows = _newTable.Select(); for (int i = 0; i < sourceRows.Length; i++) { _oldTable.ImportRow(sourceRows[i]); } gridControl2.BindingContext = new BindingContext(); gridControl2.DataSource = _oldTable; gridControl2.ForceInitialize(); }; frm.ShowDialog(); }; btnSave.Click += BtnSave_Click; } private void GridView1_ColumnFilterChanged(object sender, EventArgs e) { 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); frm.UpdateParent += Frm_UpdateParent; frm.ShowDialog(); } /// /// 查询回调 /// /// /// private void Frm_UpdateParent(object sender, UpdateParentEventArgs e) { _filterList = e.FilterList; getPageList(1); } /// /// 批准 /// /// /// private void ToolBarMenu1_btnPiZhunClick(object sender, EventArgs e) { _toolCk(2); } /// /// 审核事件 /// /// /// private void ToolBarMenu1_btnChkClick(object sender, EventArgs e) { _toolCk(1); } /// /// 取消事件 /// /// /// private void ToolBarMenu1_btnEscClick(object sender, EventArgs e) { Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 1); } /// /// 删除事件 /// /// /// private void ToolBarMenu1_btnDelClick1(object sender, EventArgs e) { _toolCk(-1); } /// /// 刷新事件 /// /// /// 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_btnEdtClick(object sender, EventArgs e) { string rowGuid = "", rowName = ""; (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_itemNo, gridView1); if (string.IsNullOrEmpty(rowGuid)) { MsgHelper.Warning("请先选择你要操作的行!"); return; } Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 3); if (xtraTabControl1.SelectedTabPageIndex == 1) { getModel(rowGuid); } else { List gvList = new List(); gvList.Add(gvMx1); gvList.Add(gridView2); UtilityHelper.ChangeEnableByControl(this.layoutMx1.Controls, true, gvList); } } /// /// 新增事件 /// /// /// private void ToolBarMenu1_btnAddClick(object sender, EventArgs e) { lbGuid.Text = ""; Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 4); var gridViews = new List(); gridViews.Add(gvMx1); gridViews.Add(gridView2); UtilityHelper.CleanValueByControl(this.layoutMx1.Controls, true, gridViews); UtilityHelper.SetDefaultTable(gcMx1, gvMx1); xtraTabPageCopy.PageEnabled = false; } /// /// 保存事件 /// /// /// private void ToolBarMenu1_btnSaveClick(object sender, EventArgs e) { toolBarMenu1.isSetBtn = false; string _ItemId = txt_itemId.GetId(); if (string.IsNullOrEmpty(_ItemId)) { MsgHelper.Warning("请选择物料!"); txt_itemId.Focus(); return; } gvMx1.CloseEditor(); gvMx1.PostEditor(); gvMx1.UpdateCurrentRow(); if (gvMx1.DataRowCount <= 0) { MsgHelper.Warning("项目明细不能为空!"); return; } try { var lst = new List(); for (var i = 0; i < gvMx1.DataRowCount; i++) { var row = gvMx1.GetDataRow(i); if (row != null) { if (string.IsNullOrEmpty(row["forder"].ToString())) { MsgHelper.ShowError("顺序不能为空!"); return; } if (string.IsNullOrEmpty(row["FcheckItem"].ToString())) { MsgHelper.ShowError("检验项目不能为空!"); return; } if (string.IsNullOrEmpty(row["FcheckTool"].ToString())) { MsgHelper.ShowError("检验工具不能为空!"); return; } if (string.IsNullOrEmpty(row["SampleSizeNo"].ToString())) { MsgHelper.ShowError("检验标准不能为空!"); return; } if (string.IsNullOrEmpty(row["FcheckLevel"].ToString())) { MsgHelper.ShowError("检验水平不能为空!"); return; } if (string.IsNullOrEmpty(row["FacLevel"].ToString())) { MsgHelper.ShowError("接受水平不能为空!"); return; } string _Fstand = row["Fstand"].ToString(); string _FupAllow = row["FupAllow"].ToString(); string _FdownAllow = row["FdownAllow"].ToString(); //假如三个都为空通过 if (string.IsNullOrEmpty(_Fstand) && string.IsNullOrEmpty(_FupAllow) && string.IsNullOrEmpty(_FdownAllow)) { } else { if (!string.IsNullOrEmpty(_Fstand) && !string.IsNullOrEmpty(_FupAllow) && !string.IsNullOrEmpty(_FdownAllow)) { decimal _Fstand_f = Gs.DevApp.ToolBox.UtilityHelper.ToDecimal(_Fstand); decimal _FupAllow_f = Gs.DevApp.ToolBox.UtilityHelper.ToDecimal(_FupAllow); decimal _FdownAllow_f = Gs.DevApp.ToolBox.UtilityHelper.ToDecimal(_FdownAllow); if (_Fstand_f >= _FdownAllow_f && _Fstand_f <= _FupAllow_f) { } else { MsgHelper.ShowError("标准值必须在上限和下限之间!"); return; } } else { MsgHelper.ShowError("请填写正确的上限,标准值,下限!"); return; } } lst.Add(new MesQmCheckitemDt { Guid = UtilityHelper.ToGuid(row["guid"].ToString()), Forder = int.Parse(row["forder"].ToString()), FcheckItem = row["FcheckItem"].ToString(), SampleSizeNo = row["SampleSizeNo"].ToString(), FcheckTool = row["FcheckTool"].ToString(), FcheckLevel = row["FcheckLevel"].ToString(), Fstand = Gs.DevApp.ToolBox.UtilityHelper.GetDecimal(row["Fstand"].ToString()), FacLevel = row["FacLevel"].ToString(), FspecRequ = row["FspecRequ"].ToString(), Memo = row["memo"].ToString(), FupAllow = Gs.DevApp.ToolBox.UtilityHelper.GetDecimal(row["FupAllow"].ToString()), FdownAllow = Gs.DevApp.ToolBox.UtilityHelper.GetDecimal(row["FdownAllow"].ToString()), }); } } var _obj = new MesQmCheckitem { Guid = UtilityHelper.ToGuid(lbGuid.Text.Trim()), ItemId = long.Parse(_ItemId), Memo = txt_memo.Text.Trim(), ItemNo = txt_itemNo.Text.Trim(), Ftype = "1", Fversion = Gs.DevApp.ToolBox.UtilityHelper.ToLong(txt_fversion.Text.Trim()), list = lst }; try { var strJson = UtilityHelper.HttpPost("", _webServiceName + "EditModel", JsonConvert.SerializeObject(_obj)); var _rtn = UtilityHelper.ReturnToDynamic(strJson); MsgHelper.Warning("提示:" + _rtn.rtnMsg); if (_rtn.rtnCode > 0) { lbGuid.Text = _rtn.rtnData; toolBarMenu1.isSetBtn = true; var gridViews = new List(); gridViews.Add(gvMx1); gridViews.Add(gridView2); UtilityHelper.ChangeEnableByControl(this.layoutMx1.Controls, false, gridViews); } } catch (Exception ex) { MsgHelper.Warning("提示:" + ex.Message); } } catch (Exception ex) { MsgHelper.ShowError("提示:" + ex.Message); } } /// /// /// 第几页 /// 每页几条 private void getPageList(int curPage) { var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList); _sbSqlWhere += " and b.guid is not null"; var pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "org.FNumber asc ,b.item_no asc,a.FVERSION desc", "", "", _sbSqlWhere.ToString()); var json = JsonConvert.SerializeObject(pgq); try { var strReturn = UtilityHelper.HttpPost("", _webServiceName + "GetListPage", json); var dd = UtilityHelper.ReturnToTablePage(strReturn); if (dd.rtnCode > 0) { gcMain1.DataSource = null; 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(); } else UtilityHelper.SetDefaultTable(gcMain1, gridView1); gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged; pageBar1.TotalPages = dd.rtnData.pages;//总页 pageBar1.CurrentPage = curPage;//当前页 pageBar1.RecordCount = dd.rtnData.total;//总记录数 } else { MsgHelper.ShowError("提示:" + dd.rtnMsg); } } catch (Exception ex) { MsgHelper.Warning("提示:" + 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.Warning("请先选择你要操作的行!"); return; } xtraTabPageCopy.PageEnabled = !isEdit; var _obj = new { guid = strGuid //主建 }; try { var strJson = UtilityHelper.HttpPost("", _webServiceName + "GetModel", JsonConvert.SerializeObject(_obj)); var _rtn = UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 0) { var dy = _rtn.rtnData; lbGuid.Text = strGuid; var gvList = new List(); gvList.Add(gvMx1); UtilityHelper.SetValueByObj(this.layoutMx1.Controls, dy, isEdit, gvList); var _job = JObject.Parse(strJson); var array = new JArray(); foreach (var a in _job["rtnData"]["list"]) array.Add(a); var dt = JsonConvert.DeserializeObject(array.ToString()); if (dt.Rows.Count > 0) { gcMx1.BindingContext = new BindingContext(); gcMx1.DataSource = dt; gcMx1.ForceInitialize(); gvMx1.BestFitColumns(); } else { UtilityHelper.SetDefaultTable(gcMx1, gvMx1); } UtilityHelper.SetDefaultTable(gridControl2, gridView2); } else { MsgHelper.Warning("提示:" + _rtn.rtnMsg); } } catch (Exception ex) { MsgHelper.Warning("提示:" + ex.Message); } } /// /// 工具条事件 /// /// private void _toolCk(int _inFieldValue) { string strMsg = ""; switch (_inFieldValue) { case -1: strMsg = "删除"; break; case 1: strMsg = "审核"; break; case 2: strMsg = "批准"; break; }; toolBarMenu1.guidKey = ""; string rowGuid, rowName; (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_itemNo, gridView1, "itemNo"); 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 + "EditModelSubmit", JsonConvert.SerializeObject(_obj)); var _rtn = UtilityHelper.ReturnToDynamic(strJson); MsgHelper.Warning(_rtn.rtnData.outMsg.ToString()); if (_rtn.rtnCode > 0 && _rtn.rtnData.outSum * 1 > 0) { if (xtraTabControl1.SelectedTabPageIndex == 1) { getModel(lbGuid.Text.Trim()); UtilityHelper.SetCheckIco(gridView1, "foneChecked", "foneCheckor", "foneCheckdate", picCheckBox, this, _inFieldValue>0?"1":"0"); } else { //注意,这里和其它页面有点不一样 getPageList(this.pageBar1.CurrentPage); int rowHandle = gridView1.LocateByValue("guid", rowGuid); gridView1.FocusedRowHandle = rowHandle; } } } catch (Exception ex) { MsgHelper.Warning("提示:" + ex.Message); } } #region 以下为种种下拉 private void _setIno() { this.txt_fSubsidiary.EditChanged += (s, e) => { string _orgId = txt_fSubsidiary.GetId(); if (string.IsNullOrEmpty(_orgId)) return; txt_itemId.getSuppler(_orgId); //txt_gg.Text =""; //txt_itemNo.Text = ""; }; txt_itemId.EditChanged += (s, e) => { if (!string.IsNullOrEmpty(this.txt_itemId.GetModel())) txt_gg.Text = this.txt_itemId.GetModel(); if (!string.IsNullOrEmpty(this.txt_itemId.GetCode())) txt_itemNo.Text = this.txt_itemId.GetCode(); }; _getListJyxm(); _getListJygj(); _getListJybz(); _getListJssp(); _getListJysp(); } /// /// 读取检验项目 /// private void _getListJyxm() { var json = JsonConvert.SerializeObject("QCITEM"); try { var strReturn = UtilityHelper.HttpPost("", "MesSysLookupTypesManager/GetItemList", json); var dd = UtilityHelper.ReturnToList(strReturn); var dt = dd.rtnData; foreach (DataRow dr in dt.Rows) { rptJYXM.Items.Add(dr["lookUpName"].ToString()); } } catch (Exception ex) { MsgHelper.Warning("提示:" + ex.Message); } } /// /// 读取检验工具 /// private void _getListJygj() { var json = JsonConvert.SerializeObject("QATOOLS"); try { var strReturn = UtilityHelper.HttpPost("", "MesSysLookupTypesManager/GetItemList", json); var dd = UtilityHelper.ReturnToList(strReturn); var dt = dd.rtnData; foreach (DataRow dr in dt.Rows) { rptJYGJ.Items.Add(dr["lookUpName"].ToString()); } } catch (Exception ex) { MsgHelper.Warning("提示:" + ex.Message); } } /// /// 读取检验标准 /// private void _getListJybz() { var pgq = new PageQueryModel(1, 999999, "CREATE_DATE", "asc", "", " and 1=1"); var json = JsonConvert.SerializeObject(pgq); try { var strReturn = UtilityHelper.HttpPost("", "MesQmAql1Manager/GetListPage", json); var rtn = UtilityHelper.ReturnToTablePage(strReturn); var dt = rtn.rtnData.list; foreach (DataRow dr in dt.Rows) { rptJYBZ.Items.Add((new CboItemEntity(dr["SampleSizeNo"].ToString(), dr["SampleSizeName"].ToString()))); //rptJYBZ.Items.Add((new CboItemEntity(dr["SampleSizeNo"].ToString(), dr["SampleSizeName"].ToString()))); //string ddddd = dr["SampleSizeName"].ToString(); } } catch (Exception ex) { MsgHelper.Warning("提示:" + ex.Message); Close(); Application.Exit(); } } /// /// 读取接受水平 /// private void _getListJssp() { rptJSSP.Items.AddRange(new string[] { "0.010---(AQL_0_0010)" , "0.015---(AQL_0_0015)" , "0.025---(AQL_0_0025)" ,"0.040---(AQL_0_0040)" ,"0.065---(AQL_0_0065)" ,"0.10---(AQL_0_010)" ,"0.15---(AQL_0_015)" ,"0.25---(AQL_0_025)" ,"0.40---(AQL_0_040)" ,"0.65---(AQL_0_065)" ,"1.00---(AQL_0_100)" ,"1.50---(AQL_0_150)" ,"2.00---(AQL_0_200)" ,"2.50---(AQL_0_250)" }); } /// /// 读取检验水平 /// private void _getListJysp() { rptJYSP.Items.AddRange(new string[] { "1.一般检验水平(I)" , "2.一般检验水平(II)" ,"3.一般检验水平(III)" ,"4.特殊检验水平(S1)" ,"5.特殊检验水平(S2)" ,"6.特殊检验水平(S3)" ,"7.特殊检验水平(S4)" }); } /// /// 关联检验标准名称 /// /// /// 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.UpdateCurrentRow(); gvMx1.SetRowCellValue(dataIndex, "sampleSizeNo", _val); gvMx1.SetRowCellValue(dataIndex, "sampleSizeName", _txt); } } private void repositoryItemButtonEdit1_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { gvMx1.CloseEditor(); gvMx1.UpdateCurrentRow(); 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 strJson = ""; var lst = new List(); lst.Add(mxGuid); try { strJson = UtilityHelper.HttpPost("", _webServiceName + "DeleteModelMx", JsonConvert.SerializeObject(lst)); var _rtn = UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 0) getModel(lbGuid.Text); MsgHelper.Warning("提示:" + _rtn.rtnMsg); } catch (Exception ex) { MsgHelper.Warning("提示:" + ex.Message); } } } #endregion /// /// 删除复制项 /// /// /// private void repositoryItemButtonEdit3_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { gridView2.CloseEditor(); gridView2.UpdateCurrentRow(); var rowhandle = gridView2.FocusedRowHandle; if (rowhandle < 0) return; if (e.Button.Index == 0) { var dr = gridView2.GetDataRow(rowhandle); if (!MsgHelper.AskQuestion("你选择了1条数据,确定删除吗?")) return; gridView2.DeleteRow(rowhandle); return; } } /// /// 提交物料复制 /// /// /// /// private void BtnSave_Click(object sender, EventArgs e) { int _rows = gridView2.RowCount; if (_rows <= 0) { MsgHelper.ShowInformation("请选择你需要复制的物料!"); return; } if (!MsgHelper.AskQuestion("你选择了" + _rows.ToString() + "条数据,确定保存吗?")) return; System.Text.StringBuilder _sbGuids = new System.Text.StringBuilder(); for (var i = 0; i < gridView2.DataRowCount; i++) { var row = gridView2.GetDataRow(i); if (_sbGuids.Length > 0) _sbGuids.Append(","); Guid? _guid = UtilityHelper.ToGuid(row["guid"].ToString()); _sbGuids.Append(_guid.ToString()); } var _obj = new { sourceGuid = UtilityHelper.ToGuid(lbGuid.Text.Trim()), itemGuids = _sbGuids.ToString() }; try { var strJson = UtilityHelper.HttpPost("", _webServiceName + "ItemsComyMx", JsonConvert.SerializeObject(_obj)); var _rtn = UtilityHelper.ReturnToDynamic(strJson); MsgHelper.Warning("提示:" + _rtn.rtnMsg); if (_rtn.rtnCode > 0) { UtilityHelper.SetDefaultTable(gridControl2, gridView2); } } catch (Exception ex) { MsgHelper.Warning("提示:" + ex.Message); } } } }