From ccc1b0d541d8f3bdd2bcb72dd0b5533e68b886d5 Mon Sep 17 00:00:00 2001 From: lu <99954486@qq.com> Date: 星期一, 09 六月 2025 09:53:37 +0800 Subject: [PATCH] 采购明细报表 --- DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQaItemsDetect01.cs | 279 +++++++++++++++++++++++-------------------------------- 1 files changed, 117 insertions(+), 162 deletions(-) diff --git a/DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQaItemsDetect01.cs b/DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQaItemsDetect01.cs index a0086e6..f27b4e3 100644 --- a/DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQaItemsDetect01.cs +++ b/DevApp/Gs.DevApp/DevFrm/QC/Frm_MesQaItemsDetect01.cs @@ -16,6 +16,7 @@ { public partial class Frm_MesQaItemsDetect01 : DevExpress.XtraEditors.XtraForm { + string _strTag = "N:涓嶅悎鏍�"; string _webServiceName = "MesQaItemsDetect01Manager/"; List<FilterEntity> _filterList = new List<FilterEntity>(); public Frm_MesQaItemsDetect01() @@ -28,31 +29,32 @@ this.toolBarMenu1.btnQueryClick += ToolBarMenu1_btnQueryClick; toolBarMenu1.btnLogClick += ToolBarMenu1_btnLogClick; toolBarMenu1.btnJianYanClick += ToolBarMenu1_btnJianYanClick; + toolBarMenu1.btnOutClick += ToolBarMenu1_btnOutClick; this.toolBarMenu1.getXmlConfig(); - Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx1); + Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx1, tips); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx2); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx3); - Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx4); Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameter(gridView1, picCheckBox, this, "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); + }, lbGuid); getPageList(1); pageBar1.PagerEvent += PageBar1_PagerEvent; txtJianYan.KeyDown += TxtJianYan_KeyDown; this.btnLoad.Click += BtnLoad_Click; - ucUpFile1.UpChanged += UcUpFile1_UpChanged; xtraTabControl2.SelectedPageChanged += XtraTabControl2_SelectedPageChanged; gvMx1.FocusedRowChanged += GvMx1_FocusedRowChanged; btnIpt.Click += BtnIpt_Click; + btnYcReport.Click += BtnYcReport_Click; } + /// <summary> /// 鎵归噺褰曞叆 /// </summary> @@ -62,7 +64,7 @@ private void BtnIpt_Click(object sender, EventArgs e) { bool bl = btnLoad.Enabled; - Frm_MesQaItemsDetect01Input frm = new Frm_MesQaItemsDetect01Input(this.lbGuid.Text.Trim(),bl); + Frm_MesQaItemsDetect01Input frm = new Frm_MesQaItemsDetect01Input(this.lbGuid.Text.Trim(), bl); frm.ShowDialog(); } @@ -72,6 +74,11 @@ Task.Delay(100); getPageList(1); } + /// <summary> + /// 5琛ㄧ劍鐐规椂锛岄噸鏂拌鍙�12琛� + /// </summary> + /// <param name="sender"></param> + /// <param name="e"></param> private void GvMx1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e) { if (e.FocusedRowHandle >= 0) @@ -90,7 +97,7 @@ /// <param name="e"></param> private void BtnLoad_Click(object sender, EventArgs e) { - if (!MsgHelper.AskQuestion("纭畾閲嶆柊鍔犺浇妫�楠岄」鐩悧锛岃鎿嶄綔灏嗕細娓呯┖涔嬪墠鐨勬楠岃褰曪紵")) + if (!MsgHelper.AskQuestion("璇ユ搷浣滃皢浼氭竻绌烘楠岃褰曪紙鍖呮嫭鏍峰搧妫�楠岃褰曪級锛岀‘瀹氶噸鏂板姞杞芥楠岄」鐩悧锛�")) return; string strGuid = lbGuid.Text.Trim(); if (string.IsNullOrEmpty(strGuid)) @@ -241,7 +248,7 @@ toolBarMenu1.guidKey = ""; string rowGuid, rowName; (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1, - lbGuid, txt_releaseNo, gridView1, "lotNo"); + lbGuid, txt_releaseNo, gridView1, "releaseNo"); toolBarMenu1.guidKey = rowGuid; if (string.IsNullOrEmpty(rowGuid)) { @@ -250,11 +257,11 @@ } if (!MsgHelper.AskQuestion("浣犻�夋嫨浜嗐��" + rowName + "銆戯紝纭畾鎻愪氦妫�楠屽悧锛�")) return; - if (txt_fcheckResu.Text.Trim() == "涓嶅悎鏍�") + if (txt_fcheckResu.Text.Trim() == _strTag) { - if (string.IsNullOrEmpty(txt_remarks.Text.Trim())) + if (string.IsNullOrEmpty(txt_fngDesc.TextTxt.Trim())) { - MsgHelper.Warning("鍗曟嵁涓轰笉鍚堟牸鏃讹紝璇峰~鍐欏娉ㄨ鏄庯紒"); + MsgHelper.Warning("鍗曟嵁涓轰笉鍚堟牸鏃讹紝璇峰~鍐欏紓甯稿娉ㄨ鏄庯紒"); return; } }; @@ -297,7 +304,62 @@ { Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 1); } - + /// <summary> + /// 瀵煎嚭 + /// </summary> + /// <param name="sender"></param> + /// <param name="e"></param> + /// <exception cref="NotImplementedException"></exception> + private void ToolBarMenu1_btnOutClick(object sender, EventArgs e) + { + 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; + using (FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog()) + { + folderBrowserDialog.Description = "閫夋嫨瀵煎嚭鏂囦欢鐨勪繚瀛樿矾寰�"; + DialogResult dialogResult = folderBrowserDialog.ShowDialog(); + if (dialogResult == DialogResult.OK) + { + string _folder = folderBrowserDialog.SelectedPath; + var _obj = new + { + guid = rowGuid, + }; + try + { + string strJson = UtilityHelper.HttpPost("", "XlsInOut/XlsOutIqc", JsonConvert.SerializeObject(_obj)); + ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson); + if (_rtn.rtnCode > 0) + { + string _file = _rtn.rtnData.fileUrl.ToString(); + string _folderName = _folder + "\\" + _file.Replace("down/", ""); + string _url = ConfigurationManager.AppSettings["WebApiUrl"].ToString() + _file; + using (WebClient client = new WebClient()) + { + client.DownloadFile(_url, _folderName); + } + ToolBox.MsgHelper.ShowInformation("瀵煎嚭鎴愬姛锛�"); + } + else + { + ToolBox.MsgHelper.ShowError("鎻愮ず锛�" + _rtn.rtnMsg); + } + } + catch (Exception ex) + { + ToolBox.MsgHelper.ShowError("鎻愮ず锛�" + ex.Message); + } + } + } + } /// <summary> /// 鍒锋柊浜嬩欢 @@ -359,23 +421,21 @@ private void ToolBarMenu1_btnSaveClick(object sender, EventArgs e) { toolBarMenu1.isSetBtn = false; - if (string.IsNullOrEmpty(txt_remarks.Text.Trim())) + if (txt_fcheckResu.Text.Trim() == _strTag && string.IsNullOrEmpty(txt_fngDesc.TextTxt.Trim())) { - Gs.DevApp.ToolBox.MsgHelper.Warning("澶囨敞鑳戒负绌猴紒"); - txt_remarks.Focus(); + Gs.DevApp.ToolBox.MsgHelper.Warning("褰撴楠岀粨鏋滀笉鍚堟牸鏃讹紝璇峰~鍐欏娉ㄨ鏄庯紒"); + txt_fngDesc.Focus(); return; } var _obj = new { guid = UtilityHelper.ToGuid(lbGuid.Text.Trim()), //涓诲缓 - fngDesc = "", - remarks = txt_remarks.Text.Trim(), + fngDesc = txt_fngDesc.TextTxt.Trim(), }; try { string strJson = UtilityHelper.HttpPost("", _webServiceName + "EditModel", JsonConvert.SerializeObject(_obj)); ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson); - ToolBox.MsgHelper.Warning("鎻愮ず锛�" + _rtn.rtnMsg); if (_rtn.rtnCode > 0) { @@ -385,6 +445,7 @@ this.setEable(false); toolBarMenu1.currentAction = ""; Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 6); + } } catch (Exception ex) @@ -400,8 +461,7 @@ /// <param name="pageSize">姣忛〉鍑犳潯</param> private void getPageList(int curPage) { - var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList); - // _sbSqlWhere += " and isnull(fsubmit,0)=0"; + gcMain1.DataSource = null;var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList); PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "release_no", "asc", "", _sbSqlWhere.ToString()); string json = JsonConvert.SerializeObject(pgq); try @@ -437,6 +497,11 @@ } } + /// <summary> + /// 璇诲彇瀹炰綋 + /// </summary> + /// <param name="strGuid"></param> + /// <param name="guid5"></param> private void getModel(string strGuid, string guid5) { bool isEdit = false; @@ -458,6 +523,7 @@ if (_rtn.rtnCode > 0) { dynamic dy = _rtn.rtnData; + btnYcReport.ToolTip = dy.toGuid.ToString(); lbGuid.Text = strGuid; List<DevExpress.XtraGrid.Views.Grid.GridView> gvList = new List<DevExpress.XtraGrid.Views.Grid.GridView>(); gvList.Add(gvMx1); @@ -477,7 +543,8 @@ gcMx1.DataSource = dt; gcMx1.ForceInitialize(); gvMx1.BestFitColumns(); - ucUpFile1.parentGuid = lbGuid.Text.Trim(); + Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gvMx1); + ucUpFileList1.pGuid = lbGuid.Text.Trim(); if (guid5.Length > 10) { int rowHandle = 0; @@ -512,48 +579,10 @@ { if (e.Page.Name == "tabMxPage2") { - getFileList(); + ucUpFileList1.getFileList(); } } - /// <summary> - /// 涓婁紶鍚庡埛鏂版枃浠跺垪琛� - /// </summary> - /// <param name="sender"></param> - /// <param name="e"></param> - private void UcUpFile1_UpChanged(object sender, EventArgs e) - { - getFileList(); - } - private void getFileList() - { - if (lbGuid.Text.Length <= 10) - return; - 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<PageListModel> dd = UtilityHelper.ReturnToTablePage(strReturn); - if (dd.rtnCode > 0) - { - DataTable dt = dd.rtnData.list; - gcMx4.BindingContext = new BindingContext(); - gcMx4.DataSource = dt; - gcMx4.ForceInitialize(); - gvMx4.BestFitColumns(); - } - else - { - ToolBox.MsgHelper.ShowError("鎻愮ず锛�" + dd.rtnMsg); - } - } - catch (Exception ex) - { - ToolBox.MsgHelper.Warning("鎻愮ず锛�" + ex.Message); - } - } + /// <summary> /// 鏍规嵁妫�楠岄」鐩鍙栨娊鏍风粨鏋� /// </summary> @@ -595,112 +624,38 @@ MsgHelper.Warning("鎻愮ず锛�" + ex.Message); } } - /// <summary> - /// 鍒犻櫎闄勪欢 + /// 绂佺敤妫�楠屾+閲嶆柊鍔犺浇鎸夐挳 /// </summary> - /// <param name="sender"></param> - /// <param name="e"></param> - private void repositoryItemButtonEdit1_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) + /// <param name="bl"></param> + private void setEable(bool bl) { - 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<string>(); - 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); - } - } - } - - /// <summary> - /// 娴忚闄勪欢 - /// </summary> - /// <param name="sender"></param> - /// <param name="e"></param> - 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); - } - - } - } - /// <summary> - /// 涓嬭浇闄勪欢 - /// </summary> - /// <param name="sender"></param> - /// <param name="e"></param> - 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 setEable(bool bl) { - txtJianYan.ReadOnly = !bl; btnLoad.Enabled = bl; - btnIpt.Text = ( bl==true?"褰曞叆鏍锋湰":"鏌ョ湅鏍锋湰"); + btnIpt.Text = (bl == true ? "褰曞叆鏍锋湰" : "鏌ョ湅鏍锋湰"); } + + #region 鎵撳紑鐖朵翰绐楀彛濮旀墭锛屾煡鐪嬪紓甯告姤鍛� + public event EventHandler<UpdateParentEventArgs> ToUpdateParent; + private void BtnYcReport_Click(object sender, EventArgs e) + { + string _toGuid = (btnYcReport.ToolTip == null ? "" : btnYcReport.ToolTip.ToString()); + if (string.IsNullOrEmpty(_toGuid)) + { + Gs.DevApp.ToolBox.MsgHelper.ShowInformation("璇ュ崟鏃犲紓甯告姤鍛婏紝鏌ョ湅澶辫触锛�"); + return; + } + if (ToUpdateParent != null) + { + List<string> lst = new List<string>(); + lst.Add("Gs.DevApp.DevFrm.QC.MesQcExceptional");//绫诲悕 + lst.Add(_toGuid);//寮傚父鎶ュ憡涓婚敭 + lst.Add("tab1");//鍏跺畠 + ToUpdateParent?.Invoke(this, + new UpdateParentEventArgs { StringList = lst }); + } + } + #endregion + } } \ No newline at end of file -- Gitblit v1.9.3