using Gs.DevApp.DevFrm.QC; using Gs.DevApp.DevFrm.Rpt; 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.RkQC { public partial class RkDetect01 : DevExpress.XtraEditors.XtraUserControl { string _strTag = "N:不合格"; List _filterList = new List(); public string strType = "";//生产退料 type public RkDetect01(string _strType) { InitializeComponent(); strType = _strType; } protected override void OnCreateControl() { base.OnCreateControl(); if (Parent == null) return; this.toolBarMenu1.btnEdtClick += ToolBarMenu1_btnEdtClick; this.toolBarMenu1.btnSaveClick += ToolBarMenu1_btnSaveClick; this.toolBarMenu1.btnLoadClick += ToolBarMenu1_btnLoadClick; this.toolBarMenu1.btnEscClick += ToolBarMenu1_btnEscClick; this.toolBarMenu1.btnQueryClick += ToolBarMenu1_btnQueryClick; toolBarMenu1.btnLogClick += ToolBarMenu1_btnLogClick; toolBarMenu1.btnChkClick += ToolBarMenu1_btnChkClick; toolBarMenu1.btnFChkClick += ToolBarMenu1_btnFChkClick; this.toolBarMenu1.getXmlConfig(); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx1, tips); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx2); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx3); Form parentForm = this.FindForm(); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameter(gridView1, picCheckBox, parentForm, "fsubmitTxt", "", (value) => { Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 0); }, tips); Gs.DevApp.ToolBox.UtilityHelper.SetTabParameter(gridView1, xtraTabControl1, pageBar1, (value) => { getModel(value, "0"); }, (value) => { getPageList(this.pageBar1.CurrentPage); }, lbGuid); getPageList(1); pageBar1.PagerEvent += PageBar1_PagerEvent; txtJianYan.KeyDown += TxtJianYan_KeyDown; this.btnLoad.Click += BtnLoad_Click; xtraTabControl2.SelectedPageChanged += XtraTabControl2_SelectedPageChanged; gvMx1.FocusedRowChanged += GvMx1_FocusedRowChanged; btnIpt.Click += BtnIpt_Click; string rptName = ""; if (strType == QcSeason.生产退料入库检.ToString()) rptName = "rpt_SCTL"; else if (strType == QcSeason.其它入库检.ToString()) rptName = "rpt_Qtrk"; else if (strType == QcSeason.销售退货入库检.ToString()) rptName = "rpt_Xsth"; this.ucBtnPrint1.btnPrintClick += (s, e) => { ucBtnPrint1.guidKey = ""; string rowGuid = txt_aboutGuid.Text.Trim(); ucBtnPrint1.guidKey = rowGuid; if (!Gs.DevApp.ToolBox.UtilityHelper.IsNumeric3(txt_iCount_1.Text.Trim(), txt_yuliang_1.Text.Trim())) { Gs.DevApp.ToolBox.MsgHelper.ShowError("请输入正确的条码数量!"); txt_iCount_1.Focus(); this.ucBtnPrint1.rptParameter = "return false"; return; } if (!Gs.DevApp.ToolBox.UtilityHelper.IsNumeric3(txt_psnQty_1.Text.Trim())) { Gs.DevApp.ToolBox.MsgHelper.ShowError("请选择打印条码数量!"); txt_psnQty_1.Focus(); this.ucBtnPrint1.rptParameter = "return false"; return; } if (rowGuid.Length < 10) { Gs.DevApp.ToolBox.MsgHelper.ShowError("请选择打印的行!"); this.ucBtnPrint1.rptParameter = "return false"; return; } this.ucBtnPrint1.rptParameter = rptName + "{" + rowGuid.Trim() + "," + "" + "," + Gs.DevApp.ToolBox.UtilityHelper.ToDecimal(txt_yuliang_1.Text.Trim()) + "," + txt_iCount_1.Text.Trim() + "," + txt_psnQty_1.Text.Trim() + "}"; }; this.ucBtnPrint1.btnAllClick += (s, e) => { string rowGuid = txt_aboutGuid.Text.Trim(); SelectDeleteBar frm = new SelectDeleteBar(rowGuid, strType); string strCodeList = ""; frm.UpdateParent += (ss, ee) => { strCodeList = ee.StringSingle; }; frm.ShowDialog(); if (string.IsNullOrEmpty(strCodeList)) return; try { string rptParameter = rptName + "{" + "100" + "," + "" + "," + "" + "," + "" + "," + "" + "," + strCodeList + "}"; using (Form rpt = new RptPreview(rowGuid, rptParameter)) { rpt.ShowDialog(); } frm.Close(); } catch (Exception ex) { MsgHelper.ShowError(ex.Message); } }; //自动计算打印量 txt_psnQty_1.TextChanged += (s, e) => { Gs.DevApp.ToolBox.UtilityHelper.PrintJiSuan(txt_psnQty_1, txt_iCount_1, txt_kQty.Text.Trim(), radOut, txt_yuliang_1); }; radOut.SelectedIndexChanged += (s, e) => { Gs.DevApp.ToolBox.UtilityHelper.PrintAuto(txt_psnQty_1, txt_iCount_1, radOut, txt_yuliang_1); }; } /// /// 批量录入 /// /// /// /// private void BtnIpt_Click(object sender, EventArgs e) { bool bl = btnLoad.Enabled; Frm_MesQaItemsDetect01Input frm = new Frm_MesQaItemsDetect01Input(this.lbGuid.Text.Trim(), bl); frm.ShowDialog(); } private void GridView1_ColumnFilterChanged(object sender, EventArgs e) { _filterList = Gs.DevApp.ToolBox.UtilityHelper.GetDilter(gridView1.Columns, gridView1); Task.Delay(100); getPageList(1); } /// /// 5表焦点时,重新读取12表 /// /// /// private void GvMx1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { if (e.FocusedRowHandle >= 0) { DataRow row = gvMx1.GetDataRow(e.FocusedRowHandle); string rowGuid = row["guid"].ToString(); if (string.IsNullOrEmpty(rowGuid)) return; getList12(rowGuid); } } /// /// 重新加载检验 /// /// /// private void BtnLoad_Click(object sender, EventArgs e) { if (!MsgHelper.AskQuestion("该操作将会清空检验记录(包括样品检验记录),确定重新加载检验项目吗?")) return; string strGuid = lbGuid.Text.Trim(); if (string.IsNullOrEmpty(strGuid)) { ToolBox.MsgHelper.Warning("请先选择你要操作的行!"); return; } var _obj = new { guid = strGuid, }; try { string strJson = UtilityHelper.HttpPost("", "MesQaItemsDetect01Manager/ReloadModel5", JsonConvert.SerializeObject(_obj)); ReturnModel _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 0) { getModel(lbGuid.Text.Trim(), "0"); } else { Gs.DevApp.ToolBox.MsgHelper.ShowInformation(_rtn.rtnMsg); } } catch (Exception ex) { ToolBox.MsgHelper.Warning("提示:" + ex.Message); } } /// /// 输入检验事件 /// /// /// private void TxtJianYan_KeyDown(object sender, KeyEventArgs e) { int intHandle = this.gvMx1.FocusedRowHandle; if (intHandle < 0) { ToolBox.MsgHelper.Warning("提示:请选择检验项目!"); return; } if (e.KeyCode == Keys.Enter) { string guid5 = this.gvMx1.GetDataRow(intHandle)["guid"].ToString(); string _strCmd = txtJianYan.Text.Trim().ToUpper(); string _strOK = "OK"; string _strNG = "NG"; if (!(_strCmd.StartsWith(_strOK) || _strCmd.StartsWith(_strNG))) { Gs.DevApp.ToolBox.MsgHelper.ShowError("命令输入错误:请正确使用OK 或 NG 命令!"); return; } if (!_strCmd.Contains("-")) { Gs.DevApp.ToolBox.MsgHelper.ShowError("命令输入错误:请正确使用OK 或 NG 命令!"); return; } string[] _ary = _strCmd.Split('-'); if (_ary.Length != 2) { Gs.DevApp.ToolBox.MsgHelper.ShowError("命令输入错误:请正确使用OK 或 NG 命令!"); return; } var _obj = new { inOrderGuid1 = UtilityHelper.ToGuid(lbGuid.Text.Trim()), ////这是检验单guid inOrderGuid5 = guid5,//这是抽样的guid inP1 = _strCmd,//或者0k-19,或者ng-19 }; try { var strJson = UtilityHelper.HttpPost("", "MesQaItemsDetect01Manager/EdtModel12", JsonConvert.SerializeObject(_obj)); var _rtn = UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 0) { getModel(lbGuid.Text.Trim(), guid5); } else { Gs.DevApp.ToolBox.MsgHelper.ShowInformation(_rtn.rtnMsg); } txtJianYan.Text = ""; } catch (Exception ex) { MsgHelper.Warning("提示:" + ex.Message); } } } /// /// 分页事件 /// /// /// private void PageBar1_PagerEvent(int curPage, int pageSize) { getPageList(curPage); } /// /// 查询事件 /// /// /// private void ToolBarMenu1_btnQueryClick(object sender, EventArgs e) { Form parentForm; if (this.Parent is Form) parentForm = this.Parent as Form; else parentForm = this.Parent.Parent as Form; gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged; gridView1.ActiveFilter.Clear(); gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged; var frm = new ShowFilter(gridView1.Columns, _filterList, parentForm.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_releaseNo, gridView1); toolBarMenu1.guidKey = rowGuid; } private void ToolBarMenu1_btnChkClick(object sender, EventArgs e) { _toolCk("EditModelSubmit"); } private void ToolBarMenu1_btnFChkClick(object sender, EventArgs e) { _toolCk("EditModelSubmitZhiLiang"); } /// /// 取消事件 /// /// /// private void ToolBarMenu1_btnEscClick(object sender, EventArgs e) { Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 1); } /// /// 刷新事件 /// /// /// private void ToolBarMenu1_btnLoadClick(object sender, EventArgs e) { if (xtraTabControl1.SelectedTabPageIndex == 1) getModel(lbGuid.Text.Trim(), "0"); 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) { toolBarMenu1.currentAction = "edit"; string rowGuid = "", rowName = ""; (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_releaseNo, gridView1, "releaseNo"); if (string.IsNullOrEmpty(rowGuid)) { ToolBox.MsgHelper.Warning("请先选择你要操作的行!"); return; } Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 3); if (xtraTabControl1.SelectedTabPageIndex == 1) { getModel(rowGuid, "0"); } else { List gvList = new List(); gvList.Add(gvMx1); gvList.Add(gvMx2); UtilityHelper.ChangeEnableByControl(this.layoutMx1.Controls, true, gvList); this.setEable(true); } } /// /// 保存事件 /// /// /// private void ToolBarMenu1_btnSaveClick(object sender, EventArgs e) { toolBarMenu1.isSetBtn = false; string rkckid = txt_rkCkId.GetId(); if (string.IsNullOrEmpty(rkckid)) { Gs.DevApp.ToolBox.MsgHelper.ShowError("请选择仓库!"); txt_rkCkId.Focus(); return; } if (txt_fcheckResu.Text.Trim() == _strTag && string.IsNullOrEmpty(txt_fngDesc.TextTxt.Trim())) { Gs.DevApp.ToolBox.MsgHelper.ShowError("当检验结果不合格时,请填写备注说明!"); txt_fngDesc.Focus(); return; } var _obj = new { guid = UtilityHelper.ToGuid(lbGuid.Text.Trim()), //主建 fngDesc = txt_fngDesc.TextTxt.Trim(), ckId = rkckid }; try { string strJson = UtilityHelper.HttpPost("", "MesQaItemsDetect01Manager/EditModel", JsonConvert.SerializeObject(_obj)); ReturnModel _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 0) { ToolBox.MsgHelper.ShowInformation("提示:" + _rtn.rtnMsg); lbGuid.Text = _rtn.rtnData; toolBarMenu1.isSetBtn = true; UtilityHelper.ChangeEnableByControl(this.layoutMx1.Controls, false); this.setEable(false); 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); PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "release_no", "asc", "", " and a.order_type='" + strType + "' " + _sbSqlWhere.ToString()); string json = JsonConvert.SerializeObject(pgq); try { string strReturn = UtilityHelper.HttpPost("", "RkqcManager/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.Warning("提示:" + ex.Message); } } /// /// 读取实体 /// /// /// private void getModel(string strGuid, string guid5) { 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("", "RkqcManager/GetModel", JsonConvert.SerializeObject(_obj)); ReturnModel _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 0) { dynamic dy = _rtn.rtnData; lbGuid.Text = strGuid; List gvList = new List(); gvList.Add(gvMx1); UtilityHelper.SetValueByObj(this.layoutMx1.Controls, dy, isEdit, gvList); string strCk = dy.rkCkId; txt_rkCkId.getSuppler(txt_receiveOrgId.Text.Trim(), strCk); setEable(isEdit); txtQuantity.Text = dy["fbatchQty"].ToString(); txt_kQty.Text = dy["kdy"].ToString(); txtYdy.Text = dy["ydy"].ToString(); txt_psnQty_1.Text = dy["fbatchQty"].ToString(); JObject _job = JObject.Parse(strJson); JArray array = new JArray(); foreach (var a in _job["rtnData"]["list5"]) { array.Add(a); } DataTable dt = JsonConvert.DeserializeObject(array.ToString()); if (dt.Rows.Count > 0) { gcMx1.DataSource = null; gcMx1.BindingContext = new BindingContext(); gcMx1.DataSource = dt; gcMx1.ForceInitialize(); gvMx1.BestFitColumns(); Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gvMx1); ucUpFileList1.pGuid = lbGuid.Text.Trim(); if (guid5.Length > 10) { int rowHandle = 0; rowHandle = gvMx1.LocateByValue(1, gvMx1.Columns["guid"], guid5); if (rowHandle < 0) rowHandle = 0; gvMx1.FocusedRowHandle = rowHandle + 1; } // MessageBox.Show(rowHandle.ToString() + "**" + guid5); } else { Gs.DevApp.ToolBox.UtilityHelper.SetDefaultTable(gcMx1, gvMx1); } JArray array8 = new JArray(); foreach (var a in _job["rtnData"]["barCodeList"]) { array8.Add(a); } DataTable dt8 = JsonConvert.DeserializeObject(array8.ToString()); if (dt8.Rows.Count > 0) { gcMx8.DataSource = null; gcMx8.BindingContext = new BindingContext(); gcMx8.DataSource = dt8; gcMx8.ForceInitialize(); gvMx8.BestFitColumns(); Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gvMx8); } else { Gs.DevApp.ToolBox.UtilityHelper.SetDefaultTable(gcMx8, gvMx8); } } else ToolBox.MsgHelper.ShowError("提示:" + _rtn.rtnMsg); } catch (Exception ex) { ToolBox.MsgHelper.ShowError("提示:" + ex.Message); } } /// /// 选项卡切换 /// /// /// private void XtraTabControl2_SelectedPageChanged(object sender, DevExpress.XtraTab.TabPageChangedEventArgs e) { if (e.Page.Name == "tabMxPage2") { ucUpFileList1.getFileList(); } } /// /// 根据检验项目读取抽样结果 /// /// private void getList12(string guid5) { var _obj = new { parentGuid = UtilityHelper.ToGuid(lbGuid.Text.Trim()), //主建 guid = UtilityHelper.ToGuid(guid5), //主建 }; try { var strJson = UtilityHelper.HttpPost("", "MesQaItemsDetect01Manager/GetModel12", JsonConvert.SerializeObject(_obj)); 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()); gcMx2.BindingContext = new BindingContext(); gcMx2.DataSource = dt; gcMx2.ForceInitialize(); gvMx2.BestFitColumns(); JArray array1 = new JArray(); foreach (var a in _job["rtnData"]["list2"]) { array1.Add(a); } DataTable dt1 = JsonConvert.DeserializeObject(array1.ToString()); gcMx3.BindingContext = new BindingContext(); gcMx3.DataSource = dt1; gcMx3.ForceInitialize(); gvMx3.BestFitColumns(); } catch (Exception ex) { MsgHelper.Warning("提示:" + ex.Message); } } /// /// 禁用检验框+重新加载按钮 /// /// private void setEable(bool bl) { txtJianYan.ReadOnly = !bl; btnLoad.Enabled = bl; btnIpt.Text = (bl == true ? "录入样本" : "查看样本"); } /// /// 检验和反检验 /// /// private void _toolCk(string _meth) { string rowGuid, rowName; (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_releaseNo, gridView1, "releaseNo"); if (string.IsNullOrEmpty(rowGuid)) { MsgHelper.Warning("请先选择你要操作的行!"); return; } if (!MsgHelper.AskQuestion("你选择了【" + rowName + "】,确定操作吗?")) return; var _obj = new { guid = rowGuid, }; try { var strJson = UtilityHelper.HttpPost("", "MesQaItemsDetect01Manager/" + _meth, JsonConvert.SerializeObject(_obj)); var _rtn = UtilityHelper.ReturnToDynamic(strJson); MsgHelper.Warning("提示:" + _rtn.rtnData.outMsg); if (_rtn.rtnCode > 0 && _rtn.rtnData.outSum * 1 > 0) { if (xtraTabControl1.SelectedTabPageIndex == 1) { getModel(lbGuid.Text.Trim(), "0"); } Form parentForm = this.FindForm(); int rowHandle = gridView1.LocateByValue(1, gridView1.Columns["guid"], rowGuid); gridView1.FocusedRowHandle = rowHandle; int _inFieldValue = (_meth == "EditModelSubmit" ? 1 : -1); UtilityHelper.SetCheckIco(gridView1, "fsubmitTxt", "", "iqcDate", picCheckBox, parentForm, _inFieldValue.ToString()); } } catch (Exception ex) { MsgHelper.Warning("提示:" + ex.Message); } } } }