/*******************************************************************************
* Copyright(c) 2014 dongke All rights reserved. / Confidential
* 类的信息:
* 1.程序名称:F_MST_0902.cs
* 2.功能描述:缺陷扣除数管理
* 编辑履历:
* 作者 日期 版本 修改内容
* 王鑫 2016/01/05 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;
using Dongke.IBOSS.PRD.Client.DataModels;
namespace Dongke.IBOSS.PRD.Client.SystemModule
{
public partial class F_MST_0902 : FormBase
{
#region 成员变量
// 窗体的单例模式
private static F_MST_0902 _instance;
// 工种数据源
private DataTable _dtSourse;
#endregion
#region 构造函数
///
/// 构造函数
///
public F_MST_0902()
{
InitializeComponent();
// 窗口标题
this.Text = FormTitles.F_MST_0902;
// 按钮
this.btnSave.Text = ButtonText.BTN_SAVE;
this.btnCancel.Text = ButtonText.BTN_CLOSE;
}
#endregion
#region 单例模式
///
/// 单例模式,防止重复创建窗体
///
public static F_MST_0902 Instance
{
get
{
if (_instance == null)
{
_instance = new F_MST_0902();
}
return _instance;
}
}
#endregion
#region 事件
///
/// 窗体加载
///
///
///
private void F_MST_0902_Load(object sender, System.EventArgs e)
{
try
{
// 设置datagridview不自动创建列
this.dgvDefectFineData.AutoGenerateColumns = false;
// 加载缺陷扣除数管理数据
this.GetAllDefectDeduction();
this.RefreshDataGridViewData();
this.dgvDefectFineData.IsSetInputColumnsColor = true;
FormPermissionManager.FormPermissionControl(this.Name, this,
LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData, LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
this.dgvDefectFineData.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
}
catch (Exception ex)
{
// 对异常进行共通处理
ExceptionManager.HandleEventException(this.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
}
}
///
/// 点击右上角关闭按钮
///
///
///
private void F_MST_0902_FormClosing(object sender, FormClosingEventArgs e)
{
try
{
// 关闭的时候需要判断是否有数据变化
if (DataJudge.IsChange((DataTable)this.dgvDefectFineData.DataSource))
{
DialogResult dialogResult = MessageBox.Show(Messages.MSG_CMN_Q001, this.Text,
MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
// 保存改变的数据
if (dialogResult == DialogResult.Yes)
{
DataGridViewRow row = dgvDefectFineData.CurrentRow;
if (!row.IsNewRow)
{
// 判断缺陷扣罚数不能为空
if (row.Cells["DefectDeductionNum"].Value == null
|| string.IsNullOrEmpty(row.Cells["DefectDeductionNum"].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(SaveDefectDeduction));
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;
this._dtSourse.AcceptChanges();
}
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_0902_FormClosed(object sender, FormClosedEventArgs e)
{
_instance = null;
}
///
/// 选中新行时,设置默认值
///
///
///
private void dgvDataJobs_DefaultValuesNeeded(object sender, DataGridViewRowEventArgs e)
{
// 设置有效属性为选中状态
e.Row.Cells["ValueFlag"].Value = Constant.INT_IS_ONE;
e.Row.Cells["DisplayNo"].Value = e.Row.Index + 1;
}
///
/// 工种管理信息输入格式控制
///
///
///
private void dgvDataJobs_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
{
try
{
// 只对文本框做控制
//if (e.Control is DataGridViewTextBoxEditingControl)
//{
// DataGridViewTextBoxEditingControl EditingControl = (DataGridViewTextBoxEditingControl)e.Control;
//}
TextBox tb = (e.Control as TextBox);
if (tb != null)
{
if ("DefectDeductionNum" == this.dgvDefectFineData.Columns[this.dgvDefectFineData.CurrentCell.ColumnIndex].Name)
{
tb.CharacterCasing = CharacterCasing.Upper;
}
else
{
tb.CharacterCasing = CharacterCasing.Normal;
}
}
}
catch (Exception ex)
{
// 对异常进行共通处理
ExceptionManager.HandleEventException(this.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
}
}
///
/// 单元格验证,检查
///
///
///
private void dgvDataJobs_CellValidating(object sender, DataGridViewCellValidatingEventArgs e)
{
try
{
if (this.ActiveControl != null && "btnClose".Equals(this.ActiveControl.Name))
{
return;
}
if (!dgvDefectFineData.CurrentRow.IsNewRow)
{
DataGridViewRow rowItem = dgvDefectFineData.Rows[e.RowIndex];
DataGridViewColumn columnItem = dgvDefectFineData.Columns[e.ColumnIndex];
object columnvalue = rowItem.Cells[columnItem.Name].Value;
// 缺陷扣除数
if ("DefectDeductionNum".Equals(columnItem.Name))
{
if (columnvalue != null && !string.IsNullOrEmpty(columnvalue + string.Empty))
{
if (!Utility.IsUnique(columnvalue.ToString(),
dgvDefectFineData.CurrentRow.Index, this.dgvDefectFineData, "DefectDeductionNum"))
{
// 单元格的错误消息
this.dgvDefectFineData.CurrentRow.ErrorText = string.Format(
Messages.MSG_CMN_W006, "缺陷扣除数");
e.Cancel = true;
this.btnSave.Enabled = false;
return;
}
}
}
// 清除单元格的错误消息
this.dgvDefectFineData.CurrentRow.ErrorText = string.Empty;
}
}
catch (Exception ex)
{
// 对异常进行共通处理
ExceptionManager.HandleEventException(this.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
}
}
///
/// 根据数据是否变化,设置保存按钮的可用状态
///
///
///
private void dgvDataJobs_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 dgvDataJobs_RowValidating(object sender, DataGridViewCellCancelEventArgs e)
{
try
{
// 按Esc键时不校验
if (!dgvDefectFineData.IsCurrentRowDirty)
{
this.dgvDefectFineData.IsSetInputColumnsColor = true;
return;
}
if (this.ActiveControl != null && "btnClose".Equals(this.ActiveControl.Name))
{
// 清除单元格的错误消息
this.dgvDefectFineData.CurrentRow.ErrorText = string.Empty;
return;
}
DataGridViewRow row = dgvDefectFineData.CurrentRow;
if (!row.IsNewRow)
{
// 判断缺陷扣罚数能为空
if (row.Cells["DefectDeductionNum"].Value == null
|| string.IsNullOrEmpty(row.Cells["DefectDeductionNum"].Value + string.Empty))
{
// 单元格的错误消息
this.dgvDefectFineData.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))
{
// 单元格的错误消息
this.dgvDefectFineData.CurrentRow.ErrorText = string.Format(Messages.MSG_CMN_W005, "显示顺序");
e.Cancel = true;
this.btnSave.Enabled = false;
return;
}
// 清除单元格的错误消息
this.dgvDefectFineData.CurrentRow.ErrorText = string.Empty;
}
}
catch (Exception ex)
{
// 对异常进行共通处理
ExceptionManager.HandleEventException(this.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
}
}
///
/// 根据数据是否变化,设置保存按钮的可用状态
///
///
///
private void dgvDataJobs_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.dgvDefectFineData.IsSetInputColumnsColor = true;
}
catch (Exception ex)
{
// 对异常进行共通处理
ExceptionManager.HandleEventException(this.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
}
}
///
/// 单元格输入时,给自动生成的行设置颜色
///
///
///
private void dgvDataJobs_UserAddedRow(object sender, DataGridViewRowEventArgs e)
{
this.dgvDefectFineData.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(SaveDefectDeduction));
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);
this._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.dgvDefectFineData.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 dgvDataJobs_Sorted(object sender, EventArgs e)
{
this.dgvDefectFineData.IsSetInputColumnsColor = true;
}
///
/// 点击关闭按钮
///
///
///
private void btnCancel_Click(object sender, EventArgs e)
{
this.Close();
}
#endregion
#region 私有方法
///
/// 加载工种管理数据
///
///
private DataSet GetJobsData()
{
try
{
byte valueFlag = Convert.ToByte(chkDisplayDisabledData.Checked);
return SystemModuleProxy.Service.GetJobsData(valueFlag);
}
catch (Exception ex)
{
throw ex;
}
}
///
/// 获取缺陷扣罚管理的全部数据
///
/// 用户信息
///
///
/// 2016.1.5 王鑫 新建
///
private void GetAllDefectDeduction()
{
try
{
DataSet dsResultAccount = (DataSet)DoAsync(new BaseAsyncMethod(() =>
{
return SystemModuleProxy.Service.GetAllDefectDeduction();
}));
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.dgvDefectFineData.DataSource = _dtSourse;
this.btnSave.Enabled = false;
}
catch (Exception ex)
{
throw ex;
}
}
///
/// 保存工种数据
///
/// 是否成功
private object SaveDefectDeduction()
{
try
{
// 获取当前datatJobsData数据源
DataTable datatJobsData = (DataTable)this.dgvDefectFineData.DataSource;
int result = SystemModuleProxy.Service.SaveDefectDeduction(datatJobsData);
return result;
}
catch (Exception ex)
{
throw ex;
}
}
///
/// 设置保存按钮的可用状态
///
private void SetSaveBtnStatus()
{
if (DataJudge.IsChange((DataTable)this.dgvDefectFineData.DataSource))
{
this.btnSave.Enabled = true;
}
else
{
this.btnSave.Enabled = false;
}
}
///
/// 保存时单元格必输项不能为空
///
private int Conservation()
{
int isConservation = Constant.INT_IS_ZERO;
DataTable datatJobsData = (DataTable)this.dgvDefectFineData.DataSource;
foreach (DataRow drproductionData in datatJobsData.Rows)
{
if (drproductionData["DefectDeductionNum"].ToString() == string.Empty)
{
isConservation = Constant.INT_IS_ONE;
break;
}
if (drproductionData["DisplayNo"].ToString() == string.Empty)
{
isConservation = Constant.INT_IS_TWO;
break;
}
}
return isConservation;
}
#endregion
}
}