| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926 |
- /*******************************************************************************
- * Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential
- * 类的信息:
- * 1.程序名称:F_RPT_030102_1.cs
- * 2.功能描述:产成品交接汇总表
- * 编辑履历:
- * 作者 日期 版本 修改内容
- * 袁新成 2015/4/14 1.00 新建
- *******************************************************************************/
- using System;
- using System.Data;
- using System.Text;
- using System.Windows.Forms;
- using Dongke.IBOSS.PRD.Basics.BaseResources;
- using Dongke.IBOSS.PRD.Basics.DockPanel;
- using Dongke.IBOSS.PRD.Client.CommonModule;
- using Dongke.IBOSS.PRD.Client.Controls;
- using Dongke.IBOSS.PRD.Client.DataModels;
- using Dongke.IBOSS.PRD.WCF.DataModels;
- using Dongke.IBOSS.PRD.WCF.Proxys;
- using Dongke.IBOSS.PRD.WCF.DataModels.PMModule;
- using Dongke.IBOSS.PRD.Basics.BaseControls;
- namespace Dongke.IBOSS.PRD.Client.ReportModule
- {
- public partial class F_RPT_030112 : DKDockPanelBase
- {
- #region 成员变量
- // 窗体的单例模式
- private static F_RPT_030112 _instance;
- //实体类
- private RPT030102_SE _rptse = null;
- private RPT030102_SE _rptse1 = null;
- // 存储查询条件
- private SearchFinishedProductEntity _orderEntity = null;
- //private SearchFinishedProductEntity _orderEntity2 = null;
- private SearchFinishedProductEntity _orderCRE = null;
- #endregion
- #region 构造函数
- public F_RPT_030112()
- {
- InitializeComponent();
- // 窗体显示的Title
- this.Text = FormTitles.F_RPT_030112;
- this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE;
- this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE;
- this.btnSearch.Text = ButtonText.BTN_SEARCH;
- this.btnClearCondition.Text = ButtonText.BTN_CLEARCONDITION;
- this.gbxCondition.Text = Constant.LABEL_QUERY_CONDITIONS;
- }
- #endregion
- #region 单例模式
- /// <summary>
- /// 单例模式,防止重复创建窗体
- /// </summary>
- public static F_RPT_030112 Instance
- {
- get
- {
- if (_instance == null || _instance.IsDisposed)
- {
- _instance = new F_RPT_030112();
- }
- return _instance;
- }
- }
- #endregion
- #region 事件处理
- /// <summary>
- /// 窗体加载事件
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void F_RPT_030102_1_Load(object sender, EventArgs e)
- {
- try
- {
- // 加载权限
- FormPermissionManager.FormPermissionControl(this.Name, this,
- LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData,
- LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
- // 设置表格不自动创建列
- this.dgvOrder.AutoGenerateColumns = false;
- this.dgvOrderDetail.AutoGenerateColumns = false;
- //this.dtpStartTime.Enabled = false;
- //this.dtpEndTime.Enabled = false;
- this.dtpStartTime.Value = DateTime.Now.Date;
- this.dtpEndTime.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
- this.chkTestMouldFlag.AllItemCheck();
- this.chkTemporarilyFlag.AllItemCheck();
- }
- catch (Exception ex)
- {
- // 对异常进行共通处理
- ExceptionManager.HandleEventException(this.ToString(),
- System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
- }
- }
- /// <summary>
- /// 窗体关闭事件
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void F_RPT_030102_1_FormClosed(object sender, FormClosedEventArgs e)
- {
- _instance = null;
- }
- /// <summary>
- /// 关闭按钮
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void tsbtnClose_Click(object sender, EventArgs e)
- {
- this.Close();
- }
- /// <summary>
- /// 自动适应列宽
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void tsbtnAdaptive_Click(object sender, EventArgs e)
- {
- if (this.tblScrapTotalModule.SelectedIndex == Constant.INT_IS_ZERO)
- {
- this.dgvOrder.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
- }
- else if(this.tblScrapTotalModule.SelectedIndex == Constant.INT_IS_ONE)
- {
- this.dgvOrderDetail.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
- }
- else if (this.tblScrapTotalModule.SelectedIndex == Constant.INT_IS_FOUR)
- {
- this.dgvtemporarily.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
- }
- else if (this.tblScrapTotalModule.SelectedIndex == Constant.INT_IS_FIVE)
- {
- this.dgvlc.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
- }
- else if (this.tblScrapTotalModule.SelectedIndex == Constant.INT_IS_SIX)
- {
- this.dgvlcDetail.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
- }
- }
- /// <summary>
- /// 查询按钮事件
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void btnSearch_Click(object sender, EventArgs e)
- {
- try
- {
- GetOrderEntityFromLayout();// 设置查询实体类
- if (this.tblScrapTotalModule.SelectedIndex == 0)//交接汇总查询
- {
- //this._orderEntity2 = this._orderEntity;
- //this.dgvOrder.DataSource = null;
- //this.dgvOrder.DataSource = this.GetSearchTotalData();
- _orderCRE = this._orderEntity;
- this.GetSearchTotalData();
- }
- else if (this.tblScrapTotalModule.SelectedIndex == 1)//交接明细查询
- {
- this.dgvOrderDetail.DataSource = null;
- this.dgvOrderDetail.DataSource = this.GetSearchDetailData();
- }
- else if (this.tblScrapTotalModule.SelectedIndex == 2)//交接数量查询
- {
- this.dgvNum.DataSource = null;
- ClientRequestEntity cre = new ClientRequestEntity();
- cre.NameSpace = "R03";
- cre.Name = "R030112Num";
- cre.Properties["OrderNo"] = this.txtOrderNo.Text.Trim();
- cre.Properties["FHUserCode"] = this.txtFHUserCode.Text.Trim();
- if (this.chkDateTime.Checked)
- {
- cre.Properties["FHTimeStart"] = this.dtpStartTime.Value;
- cre.Properties["FHTimeEnd"] = this.dtpEndTime.Value;
- }
- cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + "";
- cre.Properties["GoodsCode"] = this.txtGoodsCode.Text.Trim();
- cre.Properties["GoodsModel"] = this.txtGoodsModel.Text.Trim();
- cre.Properties["LogoIDS"] = this.dkLogoSearchBox1.LogoIDS;
- object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues;
- if (testMouldFlags.Length == 1)
- {
- cre.Properties["TestMouldFlag"] = testMouldFlags[0].ToString();
- }
- object[] temporarilyFlags = this.chkTemporarilyFlag.SelectedValues;
- if (temporarilyFlags.Length == 1)
- {
- cre.Properties["TemporarilyFlag"] = temporarilyFlags[0].ToString();
- }
- ServiceResultEntity resultEntity = DoAsync<ServiceResultEntity>(() =>
- {
- return ReportModuleProxy.Service.DoRequest(cre);
- });
- if (resultEntity == null || resultEntity.Data == null ||
- resultEntity.Data.Tables.Count == 0 ||
- resultEntity.Data.Tables[0].Rows.Count == 0)
- {
- this.dgvNum.AutoResizeColumns();
- return;
- }
- else
- {
- this.dgvNum.DataSource = resultEntity.Data.Tables[0];
- this.dgvNum.ReadOnly = true;
- this.dgvNum.Rows[0].Selected = true;
- this.dgvNum.AutoResizeColumns();
- }
- }
- else if (this.tblScrapTotalModule.SelectedIndex == 3)//型号数量查询
- {
- this.dgvGoodsNum.DataSource = null;
- ClientRequestEntity cre = new ClientRequestEntity();
- cre.NameSpace = "R03";
- cre.Name = "R030112GoodsNum";
- cre.Properties["OrderNo"] = this.txtOrderNo.Text.Trim();
- cre.Properties["FHUserCode"] = this.txtFHUserCode.Text.Trim();
- if (this.chkDateTime.Checked)
- {
- cre.Properties["FHTimeStart"] = this.dtpStartTime.Value;
- cre.Properties["FHTimeEnd"] = this.dtpEndTime.Value;
- }
- cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + "";
- cre.Properties["GoodsCode"] = this.txtGoodsCode.Text.Trim();
- cre.Properties["GoodsModel"] = this.txtGoodsModel.Text.Trim();
- cre.Properties["LogoIDS"] = this.dkLogoSearchBox1.LogoIDS;
- object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues;
- if (testMouldFlags.Length == 1)
- {
- cre.Properties["TestMouldFlag"] = testMouldFlags[0].ToString();
- }
- object[] temporarilyFlags = this.chkTemporarilyFlag.SelectedValues;
- if (temporarilyFlags.Length == 1)
- {
- cre.Properties["TemporarilyFlag"] = temporarilyFlags[0].ToString();
- }
- ServiceResultEntity resultEntity = DoAsync<ServiceResultEntity>(() =>
- {
- return ReportModuleProxy.Service.DoRequest(cre);
- });
- if (resultEntity == null || resultEntity.Data == null ||
- resultEntity.Data.Tables.Count == 0 ||
- resultEntity.Data.Tables[0].Rows.Count == 0)
- {
- this.dgvGoodsNum.AutoResizeColumns();
- return;
- }
- else
- {
- this.dgvGoodsNum.DataSource = resultEntity.Data.Tables[0];
- this.dgvGoodsNum.ReadOnly = true;
- this.dgvGoodsNum.Rows[0].Selected = true;
- this.dgvGoodsNum.AutoResizeColumns();
- }
- }
- else if (this.tblScrapTotalModule.SelectedIndex == 4)//暂存数据
- {
- this.dgvtemporarily.DataSource = null;
- ClientRequestEntity cre = new ClientRequestEntity();
- cre.NameSpace = "R03";
- cre.Name = "TemporarilyDetail";
- cre.Properties["OrderNo"] = this.txtOrderNo.Text.Trim();
- cre.Properties["FHUserCode"] = this.txtFHUserCode.Text.Trim();
- if (this.chkDateTime.Checked)
- {
- cre.Properties["FHTimeStart"] = this.dtpStartTime.Value;
- cre.Properties["FHTimeEnd"] = this.dtpEndTime.Value;
- }
- cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + "";
- cre.Properties["GoodsCode"] = this.txtGoodsCode.Text.Trim();
- cre.Properties["GoodsModel"] = this.txtGoodsModel.Text.Trim();
- cre.Properties["LogoIDS"] = this.dkLogoSearchBox1.LogoIDS;
- cre.Properties["MaterialCode"] = this.txtMaterialCode.Text.Trim();
-
- object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues;
- if (testMouldFlags.Length == 1)
- {
- cre.Properties["TestMouldFlag"] = testMouldFlags[0].ToString();
- }
- object[] temporarilyFlags = this.chkTemporarilyFlag.SelectedValues;
- if (temporarilyFlags.Length == 1)
- {
- cre.Properties["TemporarilyFlag"] = temporarilyFlags[0].ToString();
- }
- ServiceResultEntity resultEntity = DoAsync<ServiceResultEntity>(() =>
- {
- return ReportModuleProxy.Service.DoRequest(cre);
- });
- if (resultEntity == null || resultEntity.Data == null ||
- resultEntity.Data.Tables.Count == 0 ||
- resultEntity.Data.Tables[0].Rows.Count == 0)
- {
- this.dgvtemporarily.AutoResizeColumns();
- return;
- }
- else
- {
- this.dgvtemporarily.DataSource = resultEntity.Data.Tables[0];
- this.dgvtemporarily.IsSetInputColumnsColor = true;
- this.dgvtemporarily.AutoResizeColumns();
- }
- }
- else if (this.tblScrapTotalModule.SelectedIndex == 5)//裸瓷交接汇总 add by qq 20250605
- {
- this.dgvlc.DataSource = null;
- ClientRequestEntity cre = new ClientRequestEntity();
- cre.NameSpace = "R03";
- cre.Name = "LCData";
-
- cre.Properties["FHUserCode"] = this.txtFHUserCode.Text.Trim();
- if (this.chkDateTime.Checked)
- {
- cre.Properties["FHTimeStart"] = this.dtpStartTime.Value;
- cre.Properties["FHTimeEnd"] = this.dtpEndTime.Value;
- }
- cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + "";
- cre.Properties["GoodsCode"] = this.txtGoodsCode.Text.Trim();
- cre.Properties["GoodsModel"] = this.txtGoodsModel.Text.Trim();
- cre.Properties["LogoIDS"] = this.dkLogoSearchBox1.LogoIDS;
- object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues;
- if (testMouldFlags.Length == 1)
- {
- cre.Properties["TestMouldFlag"] = testMouldFlags[0].ToString();
- }
- object[] temporarilyFlags = this.chkTemporarilyFlag.SelectedValues;
- if (temporarilyFlags.Length == 1)
- {
- cre.Properties["TemporarilyFlag"] = temporarilyFlags[0].ToString();
- }
- ServiceResultEntity resultEntity = DoAsync<ServiceResultEntity>(() =>
- {
- return ReportModuleProxy.Service.DoRequest(cre);
- });
- if (resultEntity == null || resultEntity.Data == null ||
- resultEntity.Data.Tables.Count == 0 ||
- resultEntity.Data.Tables[0].Rows.Count == 0)
- {
- this.dgvlc.AutoResizeColumns();
- return;
- }
- else
- {
- this.dgvlc.DataSource = resultEntity.Data.Tables[0];
- this.dgvlc.ReadOnly = true;
- this.dgvlc.Rows[0].Selected = true;
- this.dgvlc.AutoResizeColumns();
- }
- }
- else if (this.tblScrapTotalModule.SelectedIndex == 6)//裸瓷交接明细表 add by qq 20250605
- {
- this.dgvlcDetail.DataSource = null;
- ClientRequestEntity cre = new ClientRequestEntity();
- cre.NameSpace = "R03";
- cre.Name = "LCDetail";
- cre.Properties["FHUserCode"] = this.txtFHUserCode.Text.Trim();
- if (this.chkDateTime.Checked)
- {
- cre.Properties["FHTimeStart"] = this.dtpStartTime.Value;
- cre.Properties["FHTimeEnd"] = this.dtpEndTime.Value;
- }
- cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + "";
- cre.Properties["GoodsCode"] = this.txtGoodsCode.Text.Trim();
- cre.Properties["GoodsModel"] = this.txtGoodsModel.Text.Trim();
- cre.Properties["LogoIDS"] = this.dkLogoSearchBox1.LogoIDS;
- object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues;
- if (testMouldFlags.Length == 1)
- {
- cre.Properties["TestMouldFlag"] = testMouldFlags[0].ToString();
- }
- object[] temporarilyFlags = this.chkTemporarilyFlag.SelectedValues;
- if (temporarilyFlags.Length == 1)
- {
- cre.Properties["TemporarilyFlag"] = temporarilyFlags[0].ToString();
- }
- ServiceResultEntity resultEntity = DoAsync<ServiceResultEntity>(() =>
- {
- return ReportModuleProxy.Service.DoRequest(cre);
- });
- if (resultEntity == null || resultEntity.Data == null ||
- resultEntity.Data.Tables.Count == 0 ||
- resultEntity.Data.Tables[0].Rows.Count == 0)
- {
- this.dgvlcDetail.AutoResizeColumns();
- return;
- }
- else
- {
- this.dgvlcDetail.DataSource = resultEntity.Data.Tables[0];
- this.dgvlcDetail.ReadOnly = true;
- this.dgvlcDetail.Rows[0].Selected = true;
- this.dgvlcDetail.AutoResizeColumns();
- }
- }
- }
- catch (Exception ex)
- {
- this.btnSearch.Enabled = true;
- // 对异常进行共通处理
- ExceptionManager.HandleEventException(this.ToString(),
- System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
- }
- }
- /// <summary>
- /// 清空条件按钮事件
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void btnClearCondition_Click(object sender, EventArgs e)
- {
- this.txtOrderNo.Clear();
- this.txtFHUserCode.Clear();
- this.chkDateTime.Checked = false;
- this.dtpStartTime.Value = DateTime.Now.Date;
- this.dtpEndTime.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
- this.scbGoodsType.ClearValue();
- this.txtGoodsCode.Clear();
- this.dkLogoSearchBox1.ClearControl();
- this.chkTestMouldFlag.AllItemCheck();
- this.chkTemporarilyFlag.AllItemCheck();
- }
- /// <summary>
- /// 双击单元格事件
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void dgvScrapTotalModule_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
- {
- try
- {
- //判断是否为空
- if (this.dgvOrder.CurrentRow == null)
- {
- return;
- }
- //获取数据信息
- DataRowView row = dgvOrder.CurrentRow.DataBoundItem as DataRowView;
- //this._orderEntity = _orderCRE;
- if (row["fhorderid"] == DBNull.Value)
- {
- this._orderCRE.OrderID = null;
- }
- else
- {
- this._orderCRE.OrderID = Convert.ToInt32(row["fhorderid"]);
- }
- if (row["goodsid"] == DBNull.Value)
- {
- this._orderCRE.GoodsID = null;
- }
- else
- {
- this._orderCRE.GoodsID = Convert.ToInt32(row["goodsid"]);
- }
- if (row["logoid"] == DBNull.Value)
- {
- this._orderCRE.LogoID = null;
- }
- else
- {
- this._orderCRE.LogoID = Convert.ToInt32(row["logoid"]);
- }
- this.dgvOrderDetail.DataSource = null;
- this.tblScrapTotalModule.SelectTab(1);
- this.dgvOrderDetail.DataSource = GetSearchDetailDataByDouble();
- }
- catch (Exception ex)
- {
- this.btnSearch.Enabled = true;
- this.btnClearCondition.Enabled = true;
- // 对异常进行共通处理
- ExceptionManager.HandleEventException(this.ToString(),
- System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
- }
- }
- /// <summary>
- /// 复选框按钮事件
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void chkDateTime_CheckedChanged(object sender, EventArgs e)
- {
- this.dtpStartTime.Enabled = chkDateTime.Checked;
- this.dtpEndTime.Enabled = chkDateTime.Checked;
- }
- #endregion
- #region 私有方法
- /// <summary>
- /// 搜索条件
- /// </summary>
- /// <returns></returns>
- private SearchFinishedProductEntity GetOrderEntityFromLayout()
- {
- this._orderEntity = new SearchFinishedProductEntity();
- this._orderEntity.OrderNo = this.txtOrderNo.Text.Trim();
- this._orderEntity.FHUserCode = this.txtFHUserCode.Text.Trim();
- if (this.chkDateTime.Checked)
- {
- this._orderEntity.FHTimeStart = this.dtpStartTime.Value;
- this._orderEntity.FHTimeEnd = this.dtpEndTime.Value;
- }
- this._orderEntity.GoodsTypeCode = scbGoodsType.SearchedValue + "";
- this._orderEntity.GoodsCode = this.txtGoodsCode.Text.Trim();
- this._orderEntity.BarCode = this.txtBarcode.Text.Trim();
- this._orderEntity.GoodsModel = this.txtGoodsModel.Text.Trim();
- this._orderEntity.LogoIDS = this.dkLogoSearchBox1.LogoIDS;
- object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues;
- if (testMouldFlags.Length == 1)
- {
- _orderEntity.TestMouldFlag = testMouldFlags[0].ToString();
- }
- object[] temporarilyFlag = this.chkTemporarilyFlag.SelectedValues;
- if (temporarilyFlag.Length == 1)
- {
- _orderEntity.TemporarilyFlag = temporarilyFlag[0].ToString();
- }
- return this._orderEntity;
- }
- /// <summary>
- /// 明细搜索条件
- /// </summary>
- /// <returns></returns>
- private void CreateSearchConditionDetail()
- {
- this._rptse = new RPT030102_SE();
- this._rptse.ProductionLineID = this._rptse1.ProductionLineID;
- this._rptse.GoodsTypeCode = this._rptse1.GoodsTypeCode;
- this._rptse.GoodsCode = this._rptse1.GoodsCode;
- this._rptse.ProcedureIDS = this._rptse1.ProcedureIDS;
- this._rptse.ScrapDateStart = this._rptse1.ScrapDateStart;
- this._rptse.ScrapDateEnd = this._rptse1.ScrapDateEnd;
- this._rptse.ResponProcedureIDS = this._rptse1.ResponProcedureIDS;
- this._rptse.ResponUserIDS = this._rptse1.ResponUserIDS;
- this._rptse.CreatUser = this._rptse1.CreatUser;
- this._rptse.AuditUser = this._rptse1.AuditUser;
- this._rptse.SpecialRepairFlag = this._rptse1.SpecialRepairFlag;
- }
- /// <summary>
- /// 查询损坏汇总表
- /// </summary>
- private DataTable GetSearchTotalData()
- {
- try
- {
- //// 调用服务器端获取数据集
- //ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
- //{
- // return ReportModuleProxy.Service.GetRPT0030112SData(this._orderEntity);
- //}
- //);
- //if (sre.Status == Constant.ServiceResultStatus.Success)
- //{
- // if (sre.Data.Tables[0].Rows.Count <= Constant.INT_IS_ZERO)
- // {
- // // 提示未查找到数据
- // MessageBox.Show(Messages.MSG_CMN_I002, this.Text,
- // MessageBoxButtons.OK, MessageBoxIcon.Warning);
- // //清空数据
- // return null;
- // }
- // return sre.Data.Tables[0];
- //}
- this.dgvOrder.DataSource = null;
- ClientRequestEntity cre = new ClientRequestEntity();
- cre.NameSpace = "R03";
- cre.Name = "R030112Sum";
- cre.Properties["OrderNo"] = this.txtOrderNo.Text.Trim();
- cre.Properties["FHUserCode"] = this.txtFHUserCode.Text.Trim();
- if (this.chkDateTime.Checked)
- {
- cre.Properties["FHTimeStart"] = this.dtpStartTime.Value;
- cre.Properties["FHTimeEnd"] = this.dtpEndTime.Value;
- }
- cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + "";
- cre.Properties["GoodsCode"] = this.txtGoodsCode.Text.Trim();
- cre.Properties["GoodsModel"] = this.txtGoodsModel.Text.Trim();
- cre.Properties["LogoIDS"] = this.dkLogoSearchBox1.LogoIDS;
- object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues;
- if (testMouldFlags.Length == 1)
- {
- cre.Properties["TestMouldFlag"] = testMouldFlags[0].ToString();
- }
- object[] temporarilyFlags = this.chkTemporarilyFlag.SelectedValues;
- if (temporarilyFlags.Length == 1)
- {
- cre.Properties["TemporarilyFlag"] = temporarilyFlags[0].ToString();
- }
- ServiceResultEntity resultEntity = DoAsync<ServiceResultEntity>(() =>
- {
- return ReportModuleProxy.Service.DoRequest(cre);
- });
- if (resultEntity == null || resultEntity.Data == null ||
- resultEntity.Data.Tables.Count == 0 ||
- resultEntity.Data.Tables[0].Rows.Count == 0)
- {
- this.dgvOrder.AutoResizeColumns();
- return null;
- }
- else
- {
- this.dgvOrder.DataSource = resultEntity.Data.Tables[0];
- this.dgvOrder.ReadOnly = true;
- this.dgvOrder.Rows[0].Selected = true;
- this.dgvOrder.AutoResizeColumns();
- }
- return null;
- }
- catch (Exception ex)
- {
- throw ex;
- }
- }
- /// <summary>
- /// 查询损坏明细表
- /// </summary>
- private DataTable GetSearchDetailData()
- {
- try
- {
- // 调用服务器端获取数据集
- ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
- {
- return ReportModuleProxy.Service.GetRPT0030112DetailSData(this._orderEntity);
- }
- );
- if (sre.Status == Constant.ServiceResultStatus.Success)
- {
- if (sre.Data.Tables[0].Rows.Count <= Constant.INT_IS_ZERO)
- {
- // 提示未查找到数据
- MessageBox.Show(Messages.MSG_CMN_I002, this.Text,
- MessageBoxButtons.OK, MessageBoxIcon.Warning);
- //清空数据
- return null;
- }
- return sre.Data.Tables[0];
- }
- return null;
- }
- catch (Exception ex)
- {
- throw ex;
- }
- }
- /// <summary>
- /// 查询损坏明细表
- /// </summary>
- private DataTable GetSearchDetailDataByDouble()
- {
- try
- {
- // 调用服务器端获取数据集
- ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
- {
- return ReportModuleProxy.Service.GetRPT0030112DetailSData(this._orderCRE);
- }
- );
- if (sre.Status == Constant.ServiceResultStatus.Success)
- {
- if (sre.Data.Tables[0].Rows.Count <= Constant.INT_IS_ZERO)
- {
- // 提示未查找到数据
- MessageBox.Show(Messages.MSG_CMN_I002, this.Text,
- MessageBoxButtons.OK, MessageBoxIcon.Warning);
- //清空数据
- return null;
- }
- return sre.Data.Tables[0];
- }
- return null;
- }
- catch (Exception ex)
- {
- throw ex;
- }
- }
- /// <summary>
- /// 同步
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void tsbtnSynLog_Click(object sender, EventArgs e)
- {
- try
- {
- DataTable dtBarcode = dgvtemporarily.DataSource as DataTable;
- if (dtBarcode == null)
- {
- return;
- }
- DataTable dtSelBarcode = dtBarcode.Copy();
- dtSelBarcode.DefaultView.RowFilter = "Sel = 1";
- dtSelBarcode = dtSelBarcode.DefaultView.ToTable();
- if (dtSelBarcode.Rows.Count == 0)
- {
- DKMessageBox.ShowDialog(this, DKMessageCode.W_CMN_S_004, "未选择任何数据");
- return;
- }
- DialogResult dr = MessageBox.Show("是否对所选数据进行同步?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
- if (dr != System.Windows.Forms.DialogResult.Yes)
- {
- return;
- }
- ClientRequestEntity cre = new ClientRequestEntity();
- cre.NameSpace = "R03";
- cre.Name = "SyncFinishDataLog";
-
- cre.Data = new DataSet();
- cre.Data.Tables.Add(dtSelBarcode);
- ServiceResultEntity sre = DoAsync(() =>
- {
- return ReportModuleProxy.Service.DoRequest(cre);
- });
- if (sre.OtherStatus > 0)
- {
- DKMessageBox.ShowDialog(this, DKMessageCode.I_CMN_S_002);
- btnSearch_Click(null, null);
- }
- else
- {
- MessageBox.Show(this, sre.Message);
- }
- }
- catch (Exception ex)
- {
- throw ex;
- }
- }
- /// <summary>
- /// 勾选事件
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void dgvtemporarily_CurrentCellDirtyStateChanged(object sender, EventArgs e)
- {
- try
- {
- DataGridViewCell eCell = this.dgvtemporarily.CurrentCell;
- string colName = this.dgvtemporarily.Columns[eCell.ColumnIndex].Name;
- if ("Sel" != colName)
- {
- return;
- }
- int rightFlag = Convert.ToInt32(eCell.EditedFormattedValue);
- DataRowView drv = this.dgvtemporarily.CurrentRow.DataBoundItem as DataRowView;
- if (drv != null)
- {
- drv["Sel"] = rightFlag;
- drv.EndEdit();
- }
-
- object finishedloadbatchno = this.dgvtemporarily.Rows[eCell.RowIndex].Cells["FINISHEDLOADBATCHNO"].Value;
- if (finishedloadbatchno == null || finishedloadbatchno == DBNull.Value)
- {
- return;
- }
-
- DataTable returnData = (DataTable)this.dgvtemporarily.DataSource;
- if (returnData != null)
- {
- DataRow[] rows = returnData.Select("FINISHEDLOADBATCHNO = '" + finishedloadbatchno.ToString()+"'");
- if (rows == null || rows.Length == 0)
- {
- return;
- }
- this.dgvtemporarily.Tag = 1;
- for (int i = 0; i < rows.Length; i++)
- {
- rows[i]["Sel"] = rightFlag;
- rows[i].EndEdit();
- }
- this.dgvtemporarily.Tag = null;
- }
- }
- catch (Exception ex)
- {
- this.dgvtemporarily.Tag = null;
- // 对异常进行共通处理
- ExceptionManager.HandleEventException(this.ToString(),
- System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
- }
- }
- /// <summary>
- /// 勾选事件
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void dgvtemporarily_CellClick(object sender, DataGridViewCellEventArgs e)
- {
- try
- {
- DataGridViewCell eCell = this.dgvtemporarily.CurrentCell;
- string colName = this.dgvtemporarily.Columns[eCell.ColumnIndex].Name;
- if ("Sel" != colName)
- {
- return;
- }
- int rightFlag = Convert.ToInt32(eCell.EditedFormattedValue);
- DataRowView drv = this.dgvtemporarily.CurrentRow.DataBoundItem as DataRowView;
- if (drv != null)
- {
- drv["Sel"] = rightFlag;
- drv.EndEdit();
- }
- object finishedloadbatchno = this.dgvtemporarily.Rows[eCell.RowIndex].Cells["FINISHEDLOADBATCHNO"].Value;
- if (finishedloadbatchno == null || finishedloadbatchno == DBNull.Value)
- {
- return;
- }
- DataTable returnData = (DataTable)this.dgvtemporarily.DataSource;
- if (returnData != null)
- {
- DataRow[] rows = returnData.Select("FINISHEDLOADBATCHNO = '" + finishedloadbatchno.ToString() + "'");
- if (rows == null || rows.Length == 0)
- {
- return;
- }
- this.dgvtemporarily.Tag = 1;
- for (int i = 0; i < rows.Length; i++)
- {
- rows[i]["Sel"] = rightFlag;
- rows[i].EndEdit();
- }
- this.dgvtemporarily.Tag = null;
- }
- }
- catch (Exception ex)
- {
- this.dgvtemporarily.Tag = null;
- // 对异常进行共通处理
- ExceptionManager.HandleEventException(this.ToString(),
- System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
- }
- }
- #endregion
- }
- }
|