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