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.Configuration; using System.Data; using System.Net; using System.Threading.Tasks; using System.Windows.Forms; namespace Gs.DevApp.DevFrm.QC { public partial class Frm_MesQaItemsDetect01Check : DevExpress.XtraEditors.XtraForm { string _webServiceName = "MesQaItemsDetect01Manager/"; List _filterList = new List(); public Frm_MesQaItemsDetect01Check() { InitializeComponent(); this.toolBarMenu1.btnSaveClick += ToolBarMenu1_btnSaveClick; this.toolBarMenu1.btnEscClick += ToolBarMenu1_btnEscClick; this.toolBarMenu1.btnEdtClick += ToolBarMenu1_btnEdtClick; this.toolBarMenu1.btnLoadClick += ToolBarMenu1_btnLoadClick; this.toolBarMenu1.btnQueryClick += ToolBarMenu1_btnQueryClick; this.toolBarMenu1.btnChkClick += ToolBarMenu1_btnZhiLiangChkClick; this.toolBarMenu1.btnFChkClick += ToolBarMenu1_btnZhiLiangFchkClick; this.toolBarMenu1.btnBoHuiClick += ToolBarMenu1_btnBoHuiClick; toolBarMenu1.btnReportClick += ToolBarMenu1_btnReportClick; toolBarMenu1.btnDesignClick += ToolBarMenu1_btnDesignClick; toolBarMenu1.btnLogClick += ToolBarMenu1_btnLogClick; this.toolBarMenu1.getXmlConfig(); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx1); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx2); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx4); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx3); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameter(gridView1, picCheckBox, this, "modifyFlagTxt", "", (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; ucUpFile1.UpChanged += UcUpFile1_UpChanged; xtraTabControl2.SelectedPageChanged += XtraTabControl2_SelectedPageChanged; gvMx1.FocusedRowChanged += GvMx1_FocusedRowChanged; } private void GridView1_ColumnFilterChanged(object sender, EventArgs e) { _filterList = Gs.DevApp.ToolBox.UtilityHelper.GetDilter(gridView1.Columns, gridView1); Task.Delay(100); getPageList(1); } private void GcMx1_MouseClick(object sender, MouseEventArgs e) { string rowGuid = Gs.DevApp.ToolBox.UtilityHelper.GetCurrentDoubleRow(gvMx1, e, "guid"); if (string.IsNullOrEmpty(rowGuid)) return; getList12(rowGuid); } 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 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_releaseNo, gridView1); toolBarMenu1.guidKey = rowGuid; } /// /// 取消事件 /// /// /// private void ToolBarMenu1_btnEscClick(object sender, EventArgs e) { Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 1); } /// /// 保存事件 /// /// /// private void ToolBarMenu1_btnSaveClick(object sender, EventArgs e) { toolBarMenu1.isSetBtn = false; if (txt_freceQty.SelectedIndex <= 0) { Gs.DevApp.ToolBox.MsgHelper.Warning("请选择判定结果!"); txt_freceQty.Focus(); return; } if (txt_freceQty.SelectedIndex == 1) { if ((txt_fmrmode.SelectedIndex > 0) || txt_fngHandle.SelectedIndex > 0) { Gs.DevApp.ToolBox.MsgHelper.Warning("你判定了合格,就不能再选择其它处理方式了!"); txt_fmrmode.Focus(); return; } } else { //当选择不合格时,要填写原因 if (txt_freceQty.SelectedIndex == 2) { if ((txt_fngHandle.SelectedIndex <= 0)) { Gs.DevApp.ToolBox.MsgHelper.Warning("请选择处理结果!"); txt_fngHandle.Focus(); return; } if (txt_fngHandle.SelectedIndex == 1) { if ((txt_fmrmode.SelectedIndex <= 0)) { Gs.DevApp.ToolBox.MsgHelper.Warning("请选择退料方式!"); txt_fmrmode.Focus(); return; } } else { if ((txt_fmrmode.SelectedIndex > 0)) { Gs.DevApp.ToolBox.MsgHelper.Warning("你选择了特采使用,就不能再选择退料方式了!"); txt_fmrmode.Focus(); return; } } } } string _fmrmode = txt_fmrmode.SelectedIndex>0? txt_fmrmode.Text.Trim():""; string _freceQty = txt_freceQty.SelectedIndex > 0 ? txt_freceQty.Text.Trim() : ""; string _fngHandle = txt_fngHandle.SelectedIndex > 0 ? txt_fngHandle.Text.Trim() : ""; var _obj = new { guid = UtilityHelper.ToGuid(lbGuid.Text.Trim()), //主建 freceQty= _freceQty, fngHandle = _fngHandle, fmrmode = _fmrmode, }; try { string strJson = UtilityHelper.HttpPost("", _webServiceName + "EditModel", JsonConvert.SerializeObject(_obj)); ReturnModel _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson); ToolBox.MsgHelper.Warning("提示:" + _rtn.rtnMsg); if (_rtn.rtnCode > 0) { lbGuid.Text = _rtn.rtnData; toolBarMenu1.isSetBtn = true; UtilityHelper.ChangeEnableByControl(this.layoutMx1.Controls, false); toolBarMenu1.currentAction = ""; Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 6); } } catch (Exception ex) { ToolBox.MsgHelper.Warning("提示:" + ex.Message); } } /// /// 修改事件 /// /// /// 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); } else { List gvList = new List(); gvList.Add(gvMx1); gvList.Add(gvMx2); UtilityHelper.ChangeEnableByControl(this.layoutMx1.Controls, true, gvList); } } private void ToolBarMenu1_btnDesignClick(object sender, EventArgs e) { string rowGuid, rowName; (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_itemName, gridView1); toolBarMenu1.guidKey = rowGuid; toolBarMenu1.rptParameter = "rpt_Detect01{}"; } private void ToolBarMenu1_btnReportClick(object sender, EventArgs e) { string rowGuid, rowName; (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_itemName, gridView1); toolBarMenu1.guidKey = rowGuid; this.toolBarMenu1.rptParameter = "rpt_Detect01{" + "1" + "," + "1" + "," + "1" + "," + "1" + "," + "1" + "}"; } /// /// 驳回 /// /// /// private void ToolBarMenu1_btnBoHuiClick(object sender, EventArgs e) { toolBarMenu1.guidKey = ""; _toolCk(-1); } /// /// 质量反审核 /// /// /// private void ToolBarMenu1_btnZhiLiangFchkClick(object sender, EventArgs e) { _toolCk(0); } /// /// 质量审核 /// /// /// private void ToolBarMenu1_btnZhiLiangChkClick(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 getPageList(int curPage) { var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList); _sbSqlWhere += " and isnull(fsubmit,0)=1"; PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "create_date", "asc", "", _sbSqlWhere.ToString()); string json = JsonConvert.SerializeObject(pgq); try { string 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.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)) { 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; List gvList = new List(); gvList.Add(gvMx1); UtilityHelper.SetValueByObj(this.layoutMx1.Controls, dy, isEdit, gvList); 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.BindingContext = new BindingContext(); gcMx1.DataSource = dt; gcMx1.ForceInitialize(); gvMx1.BestFitColumns(); ucUpFile1.parentGuid = lbGuid.Text.Trim(); getList12(dt.Rows[0]["guid"].ToString()); } else { Gs.DevApp.ToolBox.UtilityHelper.SetDefaultTable(gcMx1, gvMx1); } } else ToolBox.MsgHelper.Warning("提示:" + _rtn.rtnMsg); } catch (Exception ex) { ToolBox.MsgHelper.Warning("提示:" + ex.Message); } } /// /// 选项卡切换 /// /// /// private void XtraTabControl2_SelectedPageChanged(object sender, DevExpress.XtraTab.TabPageChangedEventArgs e) { if (e.Page.Name == "tabMxPage2") { getFileList(); } } /// /// 上传后刷新文件列表 /// /// /// private void UcUpFile1_UpChanged(object sender, EventArgs e) { getFileList(); } private void getFileList() { System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder(); _sbSqlWhere.Append(" and parent_Guid='" + lbGuid.Text.Trim() + "'"); PageQueryModel pgq = new PageQueryModel(1, 100, "create_date", "asc", "", _sbSqlWhere.ToString()); string json = JsonConvert.SerializeObject(pgq); try { string strReturn = UtilityHelper.HttpPost("", "MesFile/GetListPage", json); ReturnModel dd = UtilityHelper.ReturnToTablePage(strReturn); if (dd.rtnCode > 0) { DataTable dt = dd.rtnData.list; gcMx4.BindingContext = new BindingContext(); gcMx4.DataSource = dt; gcMx4.ForceInitialize(); } else { ToolBox.MsgHelper.ShowError("提示:" + dd.rtnMsg); } } catch (Exception ex) { ToolBox.MsgHelper.Warning("提示:" + ex.Message); } } /// /// 根据检验项目读取抽样结果 /// /// private void getList12(string guid5) { var _obj = new { parentGuid = UtilityHelper.ToGuid(lbGuid.Text.Trim()), //主建 guid = UtilityHelper.ToGuid(guid5), //主建 }; try { var strJson = UtilityHelper.HttpPost("", _webServiceName + "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()); gcMx4.BindingContext = new BindingContext(); gcMx4.DataSource = dt1; gcMx4.ForceInitialize(); gvMx4.BestFitColumns(); } catch (Exception ex) { MsgHelper.Warning("提示:" + ex.Message); } } /// /// 删除 /// /// /// private void repositoryItemButtonEdit1_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { var rowhandle = gvMx4.FocusedRowHandle; if (rowhandle < 0) return; if (e.Button.Index == 0) { var dr = gvMx4.GetDataRow(rowhandle); var mxGuid = dr["guid"].ToString(); if (!MsgHelper.AskQuestion("你选择了1条数据,确定删除吗?")) return; var strJson = ""; var lst = new List(); lst.Add(mxGuid); try { strJson = UtilityHelper.HttpPost("", "MesFile/DeleteModel", JsonConvert.SerializeObject(lst)); var _rtn = UtilityHelper.ReturnToDynamic(strJson); if (_rtn.rtnCode > 0) gvMx4.DeleteRow(rowhandle); MsgHelper.Warning("提示:" + _rtn.rtnMsg); } catch (Exception ex) { MsgHelper.Warning("提示:" + ex.Message); } } } /// /// 浏览 /// /// /// private void repositoryItemButtonEdit2_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { var rowhandle = gvMx4.FocusedRowHandle; if (rowhandle < 0) return; if (e.Button.Index == 0) { try { var dr = gvMx4.GetDataRow(rowhandle); var urlPath = dr["urlPath"].ToString(); Gs.DevApp.UserControl.ShowFile frm = new ShowFile(urlPath); frm.ShowDialog(); } catch (Exception ex) { Gs.DevApp.ToolBox.MsgHelper.ShowError(ex.Message); } } } /// /// 下载 /// /// /// private void repositoryItemButtonEdit3_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { var rowhandle = gvMx4.FocusedRowHandle; if (rowhandle < 0) return; if (e.Button.Index == 0) { try { var dr = gvMx4.GetDataRow(rowhandle); var urlPath = dr["urlPath"].ToString(); using (FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog()) { folderBrowserDialog.Description = "选择导出文件的保存路径"; DialogResult dialogResult = folderBrowserDialog.ShowDialog(); if (dialogResult == DialogResult.OK) { string _folder = folderBrowserDialog.SelectedPath; string _folderName = _folder + "\\" + urlPath; string _url = ConfigurationManager.AppSettings["WebApiUrl"].ToString() + "upload/" + urlPath; using (WebClient client = new WebClient()) { client.DownloadFile(_url, _folderName); } ToolBox.MsgHelper.ShowInformation("下载成功!"); } } } catch (Exception ex) { Gs.DevApp.ToolBox.MsgHelper.ShowError(ex.Message); } } } /// /// 工具条事件 /// /// private void _toolCk(int _inFieldValue) { string strMsg = ""; switch (_inFieldValue) { case 1: strMsg = "审核"; break; case 0: strMsg = "反审核"; break; case -1: strMsg = "驳回"; break; }; toolBarMenu1.guidKey = ""; string rowGuid, rowName; (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, lbGuid, txt_releaseNo, gridView1, "releaseNo"); if (string.IsNullOrEmpty(rowGuid)) { MsgHelper.Warning("请先选择你要操作的行!"); return; } if (!MsgHelper.AskQuestion("你选择了【" + rowName + "】,确定" + strMsg + "吗?")) return; if (_inFieldValue == 1) { if (txt_fcheckResu.Text == "不合格") { if (txt_fngHandle.Text.Trim().Length == 0) { MsgHelper.Warning("单据为不合格时请选择处理方式!"); return; } } } var _obj = new { guid = rowGuid, inFieldValue = _inFieldValue, }; try { var strJson = UtilityHelper.HttpPost("", _webServiceName + "EditModelSubmitZhiLiang", JsonConvert.SerializeObject(_obj)); var _rtn = UtilityHelper.ReturnToDynamic(strJson); MsgHelper.Warning(_rtn.rtnData.outMsg.ToString()); if (_rtn.rtnCode > 0 && _rtn.rtnData.outSum * 1 > 0) { if (_inFieldValue >= 0) { if (xtraTabControl1.SelectedTabPageIndex == 1) { getModel(lbGuid.Text.Trim()); } int rowHandle = gridView1.LocateByValue(1, gridView1.Columns["guid"], rowGuid); gridView1.FocusedRowHandle = rowHandle; UtilityHelper.SetCheckIco(gridView1, "modifyFlagTxt", "modify1By", "modify1Date", picCheckBox, this, _inFieldValue.ToString()); } else { //if (xtraTabControl1.SelectedTabPageIndex == 1) // getModel(lbGuid.Text.Trim()); //else // getPageList(this.pageBar1.CurrentPage); Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 1); getPageList(this.pageBar1.CurrentPage); } } } catch (Exception ex) { MsgHelper.Warning("提示:" + ex.Message); } } } }