/******************************************************************************* * Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential * 类的信息: * 1.程序名称:F_PM_2112.cs * 2.功能描述:查询在产临时表数据 * 编辑履历: * 作者 日期 版本 修改内容 * 王鑫 2015/08/11 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; namespace Dongke.IBOSS.PRD.Client.PMModule { public partial class F_PM_2112 : DKDockPanelBase { #region 成员变量 // 窗体的单例模式 private static F_PM_2112 _instance; //默认清空工序,重置回用户当前权限工序 private string _currentUserPurview = null; //默认清空生产线,重置回用户当前权限生产线 private string _currentUserLinePuview = null; #endregion #region 构造函数 public F_PM_2112() { InitializeComponent(); //自动适应列宽 this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE; //关闭 this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE; //查询 this.btnSearch.Text = ButtonText.BTN_SEARCH; // 清除选择 this.tsbtnClearSelected.Text = ButtonText.TSBTN_CLEARSELECTED; //批量清除 this.tsbtnAllClear.Text = ButtonText.TSBTN_CLEARALL; //清空条件 this.btnClearCondition.Text = ButtonText.BTN_CLEARCONDITION; //查询条件 this.gbxCondition.Text = Constant.LABEL_QUERY_CONDITIONS; // 窗体显示的Title this.Text = FormTitles.F_PM_2112; //恢复数据 this.tsbtnResetData.Text = ButtonText.TSBTN_RESETDATA; this.tsbtnResetSelected.Text = ButtonText.TSBTN_RESETSELECTEDDATA; } #endregion #region 单例模式 /// /// 单例模式,防止重复创建窗体 /// public static F_PM_2112 Instance { get { if (_instance == null || _instance.IsDisposed) { _instance = new F_PM_2112(); } return _instance; } } #endregion #region 事件 /// /// 窗体加载事件 /// /// /// private void F_PM_2112_Load(object sender, EventArgs e) { try { // 加载权限 FormPermissionManager.FormPermissionControl(this.Name, this, LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData, LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData); this.tsbtnClearSelected.Visible = false; this.tsbtnAllClear.Visible = false; // 设置表格不自动创建列 this.dgvInProduction.AutoGenerateColumns = false; // 初始化时间控件为当前日期 this.dtpUpdateTimeStart.Value = DateTime.Now.Date; this.dtpUpdateTimeEnd.Value = DateTime.Now.Date; this.dtpScrapDate.Value = DateTime.Now.Date; this.dtpScrapDateEnd.Value = DateTime.Now.Date; this.dtpDeletedDateStart.Value = DateTime.Now.Date; this.dtpDeletedDateEnd.Value = DateTime.Now.Date; this.dtpScrapDate.Enabled = false; this.dtpScrapDateEnd.Enabled = false; this.dtpDeletedDateStart.Enabled = false; this.dtpDeletedDateEnd.Enabled = false; this.dtpUpdateTimeStart.Enabled = false; this.dtpUpdateTimeEnd.Enabled = false; this.dtpDeletedDateStart.Enabled = false; this.dtpDeletedDateEnd.Enabled = false; //绑定产品分级 BindGoodsType(); //绑定数据来源 BindComDataSource(); } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 窗体关闭事件 /// /// /// private void F_PM_2112_FormClosed(object sender, FormClosedEventArgs e) { _instance = null; } /// /// 关闭按钮事件 /// /// /// private void tsbtnClose_Click(object sender, EventArgs e) { this.Close(); } /// /// 查询按钮事件 /// /// /// private void btnSearch_Click(object sender, EventArgs e) { try { this.dgvInProduction.DataSource = null; this.dgvInProduction.DataSource = this.GetSearchData(); chkAll_CheckedChanged(null, null); } catch (Exception ex) { this.btnSearch.Enabled = true; this.btnClearCondition.Enabled = true; // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 自动适应列宽 /// /// /// private void tsbtnAdaptive_Click(object sender, EventArgs e) { this.dgvInProduction.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells); } /// /// 清空条件按钮事件 /// /// /// private void btnClearCondition_Click(object sender, EventArgs e) { //清空更多条件内容 this.dkProcedureSearchBox.ClearControl(); this.dkproductionLineSearchBox.ClearControl(); this.dtpUpdateTimeStart.Value = DateTime.Now.Date; this.dtpUpdateTimeEnd.Value = DateTime.Now.Date; this.dtpScrapDate.Value = DateTime.Now.Date; this.dtpScrapDateEnd.Value = DateTime.Now.Date; this.dtpDeletedDateStart.Value = DateTime.Now.Date; this.dtpDeletedDateEnd.Value = DateTime.Now.Date; this.comGoodsType.SelectedValue = -100; this.dkProcedureSearchBox.ProcedureIDS = this._currentUserPurview; this.dkproductionLineSearchBox.ProductionLineIDS = this._currentUserLinePuview; this.cmbDataSource.SelectedValue = 0; this.chkDateTime.Checked = false; this.chkScrapDate.Checked = false; this.chkDeletedate.Checked = false; this.txtBarcode.Text = ""; chkAll.Checked = false; } /// /// 清除选择按钮事件 /// /// /// private void tsbtnClearSelected_Click(object sender, EventArgs e) { try { DataTable dt = this.dgvInProduction.DataSource as DataTable; if (dt == null) { return; } dt.AcceptChanges(); DataRow[] dr = dt.Select("Sel=1"); if (dr.Length == 0) { MessageBox.Show("请选择清除在产临时数据", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } DialogResult dialogResult = MessageBox.Show("确认是否清除选中的在产临时数据?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult.Equals(DialogResult.No)) { return; } string barcodes = ""; foreach (DataRow r in dr) { barcodes += r["barcode"].ToString() + ","; } barcodes = barcodes.TrimEnd(','); // 清除 int result = (int)DoAsync(() => { return PMModuleProxy.Service.SaveClearInproductionTmp(barcodes); }); if (result > Constant.INT_IS_ZERO) { MessageBox.Show(string.Format(Messages.MSG_CMN_I001, "在产临时表", "清除数据"), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); // 刷新窗口数据 this.btnSearch_Click(sender, e); } else { MessageBox.Show(string.Format(Messages.MSG_CMN_W001, "在产临时表", "清除数据"), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 批量清除按钮事件 /// /// /// private void tsbtnAllClear_Click(object sender, EventArgs e) { try { F_PM_2113 frmPM2113 = new F_PM_2113(); DialogResult dialogResult = frmPM2113.ShowDialog(); // 重新加载GridView if (dialogResult == DialogResult.OK) { btnSearch_Click(sender, e); } } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 恢复数据按钮事件 /// /// /// private void tsbtnResetData_Click(object sender, EventArgs e) { try { F_PM_2114 frmPM2114 = new F_PM_2114(); DialogResult dialogResult = frmPM2114.ShowDialog(); // 重新加载GridView if (dialogResult == DialogResult.OK) { btnSearch_Click(sender, e); } } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } private void dgvInProduction_CurrentCellDirtyStateChanged(object sender, EventArgs e) { try { if (this.dgvInProduction.CurrentRow != null && this.dgvInProduction.IsCurrentCellDirty) { if ("Sel".Equals(this.dgvInProduction.Columns [this.dgvInProduction.CurrentCell.ColumnIndex].Name)) { this.dgvInProduction.CommitEdit(DataGridViewDataErrorContexts.Commit); } } } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 选定项改变事件 /// /// /// private void cmbDataSource_SelectedIndexChanged(object sender, EventArgs e) { if (cmbDataSource.SelectedIndex == 0) { this.dtpScrapDate.Enabled = false; this.dtpScrapDateEnd.Enabled = false; if (!this.chkDateTime.Checked) { this.dtpUpdateTimeStart.Enabled = false; this.dtpUpdateTimeEnd.Enabled = false; } this.chkScrapDate.Enabled = false; this.comGoodsType.SelectedValue = -100; this.comGoodsType.Enabled = false; this.chkScrapDate.Checked = false; } else { //this.dtpScrapDate.Enabled = true; //this.dtpScrapDateEnd.Enabled = true; //this.dtpUpdateTimeStart.Enabled = true; //this.dtpUpdateTimeEnd.Enabled = true; if (this.chkDateTime.Checked) { this.dtpUpdateTimeStart.Enabled = true; this.dtpUpdateTimeEnd.Enabled = true; } // this.chkDateTime.Checked = false; this.chkScrapDate.Enabled = true; this.comGoodsType.Enabled = true; } } /// /// 恢复选定数据按钮事件 /// /// /// private void tsbtnResetSelected_Click(object sender, EventArgs e) { try { DataTable dt = this.dgvInProduction.DataSource as DataTable; if (dt == null) { return; } dt.AcceptChanges(); DataRow[] dr = dt.Select("Sel=1"); if (dr.Length == 0) { MessageBox.Show("请选择恢复的数据", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Question); return; } DialogResult dialogResult = MessageBox.Show("确认是否恢复选中的在产临时数据?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialogResult.Equals(DialogResult.No)) { return; } string barcodes = ""; foreach (DataRow r in dr) { barcodes += r["barcode"].ToString() + ","; } barcodes = barcodes.TrimEnd(','); // 恢复 int returnValue = (int)DoAsync(new AsyncMethod(() => { return PMModuleProxy.Service.ResetSelectedBarCode(barcodes); })); if (returnValue == -1) { MessageBox.Show("此条码没有清除,不能恢复", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else if (returnValue == 0) { MessageBox.Show("没有可恢复的数据", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else if (returnValue > 0) { MessageBox.Show("恢复数据成功", this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); // 刷新窗口数据 this.btnSearch_Click(sender, e); } } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } private void chkDateTime_CheckedChanged(object sender, EventArgs e) { dtpUpdateTimeStart.Enabled = chkDateTime.Checked; dtpUpdateTimeEnd.Enabled = chkDateTime.Checked; } private void chkScrapDate_CheckedChanged(object sender, EventArgs e) { dtpScrapDate.Enabled = chkScrapDate.Checked; dtpScrapDateEnd.Enabled = chkScrapDate.Checked; } private void chkDeletedate_CheckedChanged(object sender, EventArgs e) { dtpDeletedDateStart.Enabled = chkDeletedate.Checked; dtpDeletedDateEnd.Enabled = chkDeletedate.Checked; } /// /// 全选改变事件 /// /// /// private void chkAll_CheckedChanged(object sender, EventArgs e) { try { DataTable dtInProduction = dgvInProduction.DataSource as DataTable; if (dtInProduction == null || dtInProduction.Rows.Count == 0) { return; } int isChoose = chkAll.Checked ? 1 : 0; foreach (DataRow row in dtInProduction.Rows) { row["Sel"] = isChoose; } } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } #endregion #region 私有方法 /// /// 根据界面查询条件获取数据集 /// private DataTable GetSearchData() { try { FPM2112_SE se = new FPM2112_SE(); se.ProductionLineIDS = dkproductionLineSearchBox.ProductionLineIDS; se.ProcedureIDS = dkProcedureSearchBox.ProcedureIDS; if (this.chkDateTime.Checked) { se.UpdateTimeStart = DateTime.Parse(this.dtpUpdateTimeStart.Value.ToString("yyyy-MM-dd") + " 0:0:0"); se.UpdateTimeEnd = DateTime.Parse(this.dtpUpdateTimeEnd.Value.ToString("yyyy-MM-dd") + " 23:59:59"); } if (this.chkScrapDate.Checked) { //报废日期 se.ScrapDataStart = DateTime.Parse(this.dtpScrapDate.Value.ToString("yyyy-MM-dd") + " 0:0:0"); se.ScrapDataEnd = DateTime.Parse(this.dtpScrapDateEnd.Value.ToString("yyyy-MM-dd") + " 0:0:0"); } if(this.chkDeletedate.Checked) { se.DeletedTimeStart = DateTime.Parse(this.dtpDeletedDateStart.Value.ToString("yyyy-MM-dd") + " 0:0:0"); se.DeletedTimeEnd = DateTime.Parse(this.dtpDeletedDateEnd.Value.ToString("yyyy-MM-dd") + " 23:59:59"); } se.GooddLevelTypeID = Convert.ToInt32(comGoodsType.SelectedValue); se.TrashFlag = Convert.ToInt32(cmbDataSource.SelectedValue); se.Barcode = this.txtBarcode.Text.Trim(); // 调用服务器端获取数据集 ServiceResultEntity sre = DoAsync(() => { return PMModuleProxy.Service.GetPM2112Data(se); } ); 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; } } /// /// 绑定产品分级 /// private void BindGoodsType() { DataTable dt = new DataTable(); dt.Columns.Add("GoodsLevelTypeID"); dt.Columns.Add("GoodsLevelTypeName"); DataRow dr = dt.NewRow(); dr["GoodsLevelTypeID"] = -100; dr["GoodsLevelTypeName"] = ""; dt.Rows.Add(dr); dr = dt.NewRow(); dr["GoodsLevelTypeID"] = 8; dr["GoodsLevelTypeName"] = "损坯"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["GoodsLevelTypeID"] = 7; dr["GoodsLevelTypeName"] = "次品"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["GoodsLevelTypeID"] = 3; dr["GoodsLevelTypeName"] = "废品"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["GoodsLevelTypeID"] = 13; dr["GoodsLevelTypeName"] = "不合格"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["GoodsLevelTypeID"] = 14; dr["GoodsLevelTypeName"] = "不合格(返)"; dt.Rows.Add(dr); this.comGoodsType.DataSource = dt; this.comGoodsType.DisplayMember = "GoodsLevelTypeName"; this.comGoodsType.ValueMember = "GoodsLevelTypeID"; } /// /// 绑定数据来源 /// private void BindComDataSource() { DataTable dt = new DataTable(); dt.Columns.Add("DataSourceID"); dt.Columns.Add("DataSourceName"); DataRow dr = dt.NewRow(); dr["DataSourceID"] = 0; dr["DataSourceName"] = "在产"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["DataSourceID"] = 1; dr["DataSourceName"] = "回收站"; dt.Rows.Add(dr); this.cmbDataSource.DataSource = dt; this.cmbDataSource.DisplayMember = "DataSourceName"; this.cmbDataSource.ValueMember = "DataSourceID"; } #endregion } }