/******************************************************************************* * Copyright(c) 2016 dongke All rights reserved. / Confidential * 类的信息: * 1.程序名称:F_MST_1101.cs * 2.功能描述:工艺部门 * 编辑履历: * 作者 日期 版本 修改内容 * 王鑫 2016/07/19 1.00 新建 *******************************************************************************/ using System; using System.Data; using System.Windows.Forms; using Dongke.IBOSS.PRD.Basics.BaseResources; using Dongke.IBOSS.PRD.Basics.BaseControls; using Dongke.IBOSS.PRD.Client.CommonModule; using Dongke.IBOSS.PRD.Basics.Library; using Dongke.IBOSS.PRD.WCF.Proxys; namespace Dongke.IBOSS.PRD.Client.SystemModule { /// /// 工艺部门 /// public partial class F_MST_1101 : FormBase { #region 成员变量 // 窗体的单例模式 private static F_MST_1101 _instance; // 工艺数据源 private DataTable _dtSourse; // 工艺类别 private int _TypeFlagId = Constant.INT_IS_ZERO; #endregion #region 构造函数 /// /// 构造函数 /// public F_MST_1101() { InitializeComponent(); // 窗口标题 this.Text = FormTitles.F_MST_1101; // 按钮 this.btnSave.Text = ButtonText.BTN_SAVE; this.btnCancel.Text = ButtonText.BTN_CLOSE; } #endregion #region 单例模式 /// /// 单例模式,防止重复创建窗体 /// public static F_MST_1101 Instance { get { if (_instance == null) { _instance = new F_MST_1101(); } return _instance; } } #endregion #region 事件 /// /// 窗体加载 /// /// /// private void F_MST_0301_Load(object sender, System.EventArgs e) { try { // 设置datagridview不自动创建列 this.dgvTecDep.AutoGenerateColumns = false; // 加载工艺管理数据 this.GetAllTecDepInfo(); this.RefreshDataGridViewData(); // 绑定工艺数据源 DataTable dt = new DataTable(); dt.Columns.Add("TypeFlag"); dt.Columns.Add("TypeFlagName"); DataRow dr = dt.NewRow(); dr["TypeFlag"] = 0; dr["TypeFlagName"] = "中间工艺"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["TypeFlag"] = 1; dr["TypeFlagName"] = "开始工艺"; dt.Rows.Add(dr); dr = dt.NewRow(); dr["TypeFlag"] = 2; dr["TypeFlagName"] = "结束工艺"; dt.Rows.Add(dr); this.TypeFlag.ValueMember = "TypeFlag"; this.TypeFlag.DisplayMember = "TypeFlagName"; this.TypeFlag.DataSource = dt; this._TypeFlagId = 0; this.btnSave.Enabled = false; this.dgvTecDep.IsSetInputColumnsColor = true; this.dgvTecDep.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect; } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 点击右上角关闭按钮 /// /// /// private void F_MST_0301_FormClosing(object sender, FormClosingEventArgs e) { try { // 关闭的时候需要判断是否有数据变化 if (DataJudge.IsChange((DataTable)this.dgvTecDep.DataSource)) { DialogResult dialogResult = MessageBox.Show(Messages.MSG_CMN_Q001, this.Text, MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question); // 保存改变的数据 if (dialogResult == DialogResult.Yes) { DataGridViewRow row = dgvTecDep.CurrentRow; if (!row.IsNewRow) { //// 判断窑炉编码不能为空 //if (row.Cells["KilnCode"].Value == null // || string.IsNullOrEmpty(row.Cells["KilnCode"].Value + string.Empty)) //{ // // 错误消息 // MessageBox.Show(string.Format(Messages.MSG_CMN_W005, "窑炉编码"), // this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); // e.Cancel = true; // this.btnSave.Enabled = false; // return; //} // 判断名称不能为空 if (row.Cells["Name"].Value == null || string.IsNullOrEmpty(row.Cells["Name"].Value + string.Empty)) { // 单元格的错误消息 MessageBox.Show(string.Format(Messages.MSG_CMN_W005, "工艺名称"), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); e.Cancel = true; this.btnSave.Enabled = false; return; } // 判断类型不能为空 if (row.Cells["TypeFlag"].Value == null || string.IsNullOrEmpty(row.Cells["TypeFlag"].Value + string.Empty)) { // 单元格的错误消息 MessageBox.Show(string.Format(Messages.MSG_CMN_W005, "工艺类型"), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); e.Cancel = true; this.btnSave.Enabled = false; return; } // 顺序不能为空 if (row.Cells["DisplayNo"].Value == null || string.IsNullOrEmpty(row.Cells["DisplayNo"].Value + string.Empty)) { // 单元格的错误消息 MessageBox.Show(string.Format(Messages.MSG_CMN_W005, "显示顺序"), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); e.Cancel = true; this.btnSave.Enabled = false; return; } } // 异步处理 object result = DoAsync(new BaseAsyncMethod(SaveTecDepData)); ////存在相同的编码 //if (result.Equals(Constant.INT_IS_ONE)) //{ // MessageBox.Show(string.Format(Messages.MSG_CMN_W006, "窑炉编码"), // this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); // e.Cancel = true; // this.btnSave.Enabled = false; // return; //} // 工艺管理保存成功 if (Convert.ToInt32(result) > Constant.INT_IS_ZERO) { e.Cancel = true; MessageBox.Show(string.Format(Messages.MSG_CMN_I001, "工艺", "保存"), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); this.btnSave.Enabled = false; _dtSourse.AcceptChanges(); } //存在相同的工艺名称 else if (Convert.ToInt32(result) == (int)Constant.RETURN_IS_EXIST) { e.Cancel = true; MessageBox.Show(string.Format(Messages.MSG_CMN_W006, "工艺名称"), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } //工艺管理没有任何数据更新 else { e.Cancel = true; MessageBox.Show(string.Format(Messages.MSG_CMN_W001, "工艺", "保存"), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } } else if (dialogResult == DialogResult.Cancel) { e.Cancel = true; } } } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 窗体关闭后,释放单例资源 /// /// /// private void F_MST_0301_FormClosed(object sender, FormClosedEventArgs e) { _instance = null; } /// /// 选中新行时,设置默认值 /// /// /// private void dgvDataTonnage_DefaultValuesNeeded(object sender, DataGridViewRowEventArgs e) { // 设置有效属性为选中状态 e.Row.Cells["ValueFlag"].Value = Constant.INT_IS_ONE; e.Row.Cells["TypeFlag"].Value = _TypeFlagId; e.Row.Cells["DisplayNo"].Value = e.Row.Index + 1; e.Row.Cells["TECHNOLOGYFLAG"].Value = "1"; } /// /// 单元格验证,检查 /// /// /// private void dgvDataTonnage_CellValidating(object sender, DataGridViewCellValidatingEventArgs e) { try { if (this.ActiveControl != null && "btnClose".Equals(this.ActiveControl.Name)) { return; } //判断是否存在相同的编码 if (!dgvTecDep.CurrentRow.IsNewRow) { DataGridViewRow rowItem = dgvTecDep.Rows[e.RowIndex]; DataGridViewColumn columnItem = dgvTecDep.Columns[e.ColumnIndex]; object columnvalue = rowItem.Cells[columnItem.Name].EditedFormattedValue; //// 窑炉编码 //if ("KilnCode".Equals(columnItem.Name)) //{ // if (columnvalue != null && !string.IsNullOrEmpty(columnvalue + string.Empty)) // { // if (!Utility.IsUnique(columnvalue.ToString(), // dgvTecDep.CurrentRow.Index, this.dgvTecDep, "KilnCode")) // { // // 单元格的错误消息 // this.dgvTecDep.CurrentRow.ErrorText = string.Format( // Messages.MSG_CMN_W006, "窑炉编码"); // e.Cancel = true; // this.btnSave.Enabled = false; // return; // } // } //} // 清除单元格的错误消息 this.dgvTecDep.CurrentRow.ErrorText = string.Empty; } } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 根据数据是否变化,设置保存按钮的可用状态 /// /// /// private void dgvDataTonnage_CellValidated(object sender, DataGridViewCellEventArgs e) { try { this.SetSaveBtnStatus(); } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 行校验 /// /// /// private void dgvDataTonnage_RowValidating(object sender, DataGridViewCellCancelEventArgs e) { try { // 按Esc键时不校验 if (!dgvTecDep.IsCurrentRowDirty) { this.dgvTecDep.IsSetInputColumnsColor = true; return; } if (this.ActiveControl != null && "btnClose".Equals(this.ActiveControl.Name)) { // 清除单元格的错误消息 this.dgvTecDep.CurrentRow.ErrorText = string.Empty; return; } DataGridViewRow row = dgvTecDep.CurrentRow; //// 判断起窑炉编码能为空 //if (row.Cells["KilnCode"].Value == null // || string.IsNullOrEmpty(row.Cells["KilnCode"].Value + string.Empty)) //{ // // 单元格的错误消息 // this.dgvTecDep.CurrentRow.ErrorText = string.Format(Messages.MSG_CMN_W005, "窑炉编码"); // e.Cancel = true; // this.btnSave.Enabled = false; // return; //} // 判断名称不能为空 if (row.Cells["Name1"].Value == null || string.IsNullOrEmpty(row.Cells["Name1"].Value + string.Empty)) { // 单元格的错误消息 this.dgvTecDep.CurrentRow.ErrorText = string.Format(Messages.MSG_CMN_W005, "工艺名称"); e.Cancel = true; this.btnSave.Enabled = false; return; } // 判断工艺类别不能为空 if (row.Cells["TypeFlag"].Value == null || string.IsNullOrEmpty(row.Cells["TypeFlag"].Value + string.Empty)) { // 单元格的错误消息 this.dgvTecDep.CurrentRow.ErrorText = string.Format(Messages.MSG_CMN_W005, "工艺类别"); e.Cancel = true; this.btnSave.Enabled = false; return; } // 顺序不能为空 if (row.Cells["DisplayNo"].Value == null || string.IsNullOrEmpty(row.Cells["DisplayNo"].Value + string.Empty)) { // 单元格的错误消息 MessageBox.Show(string.Format(Messages.MSG_CMN_W005, "显示顺序"), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); e.Cancel = true; this.btnSave.Enabled = false; return; } // 清除单元格的错误消息 this.dgvTecDep.CurrentRow.ErrorText = string.Empty; } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 根据数据是否变化,设置保存按钮的可用状态 /// /// /// private void dgvDataTonnage_RowValidated(object sender, DataGridViewCellEventArgs e) { try { this.SetSaveBtnStatus(); } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 根据是否选中停用数据,加载数据 /// /// /// private void chkDisplayDisabledData_CheckedChanged(object sender, EventArgs e) { try { //得到窑炉数据 this.RefreshDataGridViewData(); this.SetSaveBtnStatus(); this.dgvTecDep.IsSetInputColumnsColor = true; } catch (Exception ex) { // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 单元格输入时,给自动生成的行设置颜色 /// /// /// private void dgvDataTonnage_UserAddedRow(object sender, DataGridViewRowEventArgs e) { this.dgvTecDep.IsSetInputColumnsColor = true; } /// /// 保存窑炉数据 /// /// /// private void btnSave_Click(object sender, EventArgs e) { try { //判断保存时单元格必输项不能为空 int results = Conservation(); //窑炉编码不能为空 //if (results == Constant.INT_IS_ONE) //{ // MessageBox.Show(string.Format(Messages.MSG_CMN_W005, "窑炉编码"), // this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); // this.btnSave.Enabled = false; // return; //} //工艺名称不能为空 if (results == Constant.INT_IS_TWO) { MessageBox.Show(string.Format(Messages.MSG_CMN_W005, "工艺名称"), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); this.btnSave.Enabled = false; return; } // 异步处理 this.btnSave.Enabled = false; this.btnCancel.Enabled = false; int result = (int)DoAsync(new BaseAsyncMethod(SaveTecDepData)); this.btnSave.Enabled = true; this.btnCancel.Enabled = true; // 窑炉数据保存成功 if (result == Constant.INT_IS_TWO) { MessageBox.Show(string.Format(Messages.MSG_CMN_I001, "工艺", "保存"), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Information); // 加载窑炉管理数据 _dtSourse.AcceptChanges(); this.btnSave.Enabled = false; } else if (result == Constant.INT_IS_ONE) { MessageBox.Show(string.Format(Messages.MSG_CMN_W006, "工艺名称"), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { MessageBox.Show(string.Format(Messages.MSG_CMN_W001, "工艺", "保存"), this.Text, MessageBoxButtons.OK, MessageBoxIcon.Warning); } this.dgvTecDep.IsSetInputColumnsColor = true; } catch (Exception ex) { this.btnSave.Enabled = true; this.btnCancel.Enabled = true; // 对异常进行共通处理 ExceptionManager.HandleEventException(this.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex); } } /// /// 点击关闭按钮 /// /// /// private void btnCancel_Click(object sender, EventArgs e) { this.Close(); } /// /// 设置排序时列表的颜色 /// private void dgvDataTonnage_Sorted(object sender, EventArgs e) { this.dgvTecDep.IsSetInputColumnsColor = true; } #endregion #region 私有方法 /// /// 获取工艺的全部数据 /// /// 用户信息 /// /// /// 2016.07.19 王鑫 新建 /// private void GetAllTecDepInfo() { try { DataSet dsResultAccount = (DataSet)DoAsync(new BaseAsyncMethod(() => { return SystemModuleProxy.Service.GetAllTecDepInfo(); })); this._dtSourse = dsResultAccount.Tables[0]; } catch (Exception ex) { throw ex; } } /// /// 得到窑炉数据信息 /// /// private void RefreshDataGridViewData() { try { //未选中停用标识,显示正常数据 if (this.chkDisplayDisabledData.Checked == false) { this._dtSourse.DefaultView.RowFilter = "ValueFlag=1"; } //选中时,显示全部数据 else { this._dtSourse.DefaultView.RowFilter = null; } this.dgvTecDep.DataSource = this._dtSourse; this.btnSave.Enabled = false; } catch (Exception ex) { throw ex; } } /// /// 保存工艺数据 /// /// 是否成功 private object SaveTecDepData() { try { // 获取当前datatKilnData数据源 DataTable datatKilnData = (DataTable)this.dgvTecDep.DataSource; int result = SystemModuleProxy.Service.SaveTecDepData(datatKilnData); return result; } catch (Exception ex) { throw ex; } } /// /// 设置保存按钮的可用状态 /// private void SetSaveBtnStatus() { if (DataJudge.IsChange((DataTable)this.dgvTecDep.DataSource)) { this.btnSave.Enabled = true; } else { this.btnSave.Enabled = false; } } /// /// 保存时单元格必输项不能为空 /// private int Conservation() { int isConservation = Constant.INT_IS_ZERO; DataTable datatKilnData = (DataTable)this.dgvTecDep.DataSource; foreach (DataRow drproductionData in datatKilnData.Rows) { ////判断窑炉编码,名称是否为空 //if (drproductionData["KilnCode"].ToString() == string.Empty) //{ // isConservation = Constant.INT_IS_ONE; // break; //} if (drproductionData["Name"].ToString() == string.Empty) { isConservation = Constant.INT_IS_TWO; break; } } return isConservation; } #endregion } }