/*******************************************************************************
* 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
}
}