/*******************************************************************************
* Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential
* 类的信息:
* 1.程序名称:F_RPT_010401.cs
* 2.功能描述:在产品明细表
* 编辑履历:
* 作者 日期 版本 修改内容
* 袁新成 2015/4/9 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.ReportModule
{
///
/// 在产产品数据
///
public partial class F_RPT_010401 : DKDockPanelBase
{
#region 成员变量
// 窗体的单例模式
private static F_RPT_010401 _instance;
//默认清空工序,重置回用户当前权限工序
private string _currentUserPurview = null;
//默认清空生产线,重置回用户当前权限生产线
private string _currentUserLinePuview = null;
#endregion
#region 构造函数
public F_RPT_010401()
{
InitializeComponent();
//自动适应列宽
this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE;
//关闭
this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE;
//查询
this.btnSearch.Text = ButtonText.BTN_SEARCH;
//清空条件
this.btnClearCondition.Text = ButtonText.BTN_CLEARCONDITION;
//查询条件
this.gbxCondition.Text = Constant.LABEL_QUERY_CONDITIONS;
// 窗体显示的Title
this.Text = FormTitles.F_RPT_010401;
}
#endregion
#region 单例模式
///
/// 单例模式,防止重复创建窗体
///
public static F_RPT_010401 Instance
{
get
{
if (_instance == null || _instance.IsDisposed)
{
_instance = new F_RPT_010401();
}
return _instance;
}
}
#endregion
#region 事件
///
/// 窗体加载事件
///
///
///
private void F_RPT_010401_Load(object sender, EventArgs e)
{
try
{
// 加载权限
FormPermissionManager.FormPermissionControl(this.Name, this,
LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData,
LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
// 设置表格不自动创建列
this.dgvInProduction.AutoGenerateColumns = false;
// 初始化时间控件为当前日期
this.dtpCreateTimeStart.Value = DateTime.Now.Date;
this.dtpCreateTimeEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.dkproductionLineSearchBox.IsEnablePurview = true;
this.dkProcedureSearchBox.IsEnablePurview = true;
this.dtpUpdateTimeStart.Value = DateTime.Now.Date;
this.dtpUpdateTimeEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
getPurview();
getPurviewLine();//
}
catch (Exception ex)
{
// 对异常进行共通处理
ExceptionManager.HandleEventException(this.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
}
}
///
/// 窗体关闭事件
///
///
///
private void F_RPT_010401_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
{
if (string.IsNullOrEmpty(this._currentUserPurview))
{
// 提示未查找到数据
MessageBox.Show(Messages.MSG_CMN_I002, this.Text,
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
this.dgvInProduction.DataSource = null;
this.dgvInProduction.DataSource = this.GetSearchData();
}
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.scbGoods.ClearValue();
scbGoodsType.ClearValue();
this.scbGMouldType.ClearValue();
this.scbGroutingLine.ClearValue();
this.dkProcedureSearchBox.ClearControl();
this.dkproductionLineSearchBox.ClearControl();
this.dkUserInfoSearchBox.ClearControl();
this.dtpCreateTimeStart.Value = DateTime.Now.Date;
this.dtpCreateTimeEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.dtpUpdateTimeStart.Value = DateTime.Now.Date;
this.dtpUpdateTimeEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.chkCreateTime.Checked = true;
this.chkUpdateTime.Checked = true;
this.txtBarCode.Text = string.Empty;
this.dkProcedureSearchBox.ProcedureIDS = this._currentUserPurview;
this.dkproductionLineSearchBox.ProductionLineIDS = this._currentUserLinePuview;
this.radAll.Checked = true;
this.radNormal.Checked = false;
this.radScrap.Checked = false;
}
///
/// 交坯日期
///
///
///
private void chkCreateTime_CheckedChanged(object sender, EventArgs e)
{
this.dtpCreateTimeStart.Enabled = this.chkCreateTime.Checked;
this.dtpCreateTimeEnd.Enabled = this.chkCreateTime.Checked;
}
private void chkUpdateTime_CheckedChanged(object sender, EventArgs e)
{
this.dtpUpdateTimeStart.Enabled = this.chkUpdateTime.Checked;
this.dtpUpdateTimeEnd.Enabled = this.chkUpdateTime.Checked;
}
#endregion
#region 私有方法
///
/// 根据界面查询条件获取数据集
///
private DataTable GetSearchData()
{
try
{
RPT010401_SE se = new RPT010401_SE();
se.Barcode = txtBarCode.Text.Trim();
se.ProductionLineIDS = dkproductionLineSearchBox.ProductionLineIDS;
se.ProcedureIDS = dkProcedureSearchBox.ProcedureIDS;
se.GoodsIDS = this.scbGoods.CheckedPKMember;
se.UserIDS = dkUserInfoSearchBox.UserIDS;
se.GroutingLineIDS = (this.scbGroutingLine.SearchedPKMember == 0 ? null : this.scbGroutingLine.SearchedPKMember.ToString());
se.GMouldTypeIDS = this.scbGMouldType.CheckedPKMember;
if (this.chkCreateTime.Checked == true)
{
//se.CreateTimeStart = DateTime.Parse(this.dtpCreateTimeStart.Value.ToString("yyyy-MM-dd") + " 0:0:0");
//se.CreateTimeEnd = DateTime.Parse(this.dtpCreateTimeEnd.Value.ToString("yyyy-MM-dd") + " 23:59:59");
se.CreateTimeStart = this.dtpCreateTimeStart.Value;
se.CreateTimeEnd = this.dtpCreateTimeEnd.Value;
}
if (this.chkUpdateTime.Checked == true)
{
//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");
se.UpdateTimeStart = this.dtpUpdateTimeStart.Value;
se.UpdateTimeEnd = this.dtpUpdateTimeEnd.Value;
}
se.inscrapflag = radAll.Checked ? 2 : radNormal.Checked ? 0 : 1;
se.IsReworkFlag = chkIsReworkFlag.Checked ? 1 : 0;
se.GoodsTypeCode = scbGoodsType.SearchedValue + "";
// 调用服务器端获取数据集
ServiceResultEntity sre = DoAsync(() =>
{
return ReportModuleProxy.Service.GetRPT010401SData(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;
}
}
///
/// 获取权限
///
protected void getPurview()
{
try
{
StringBuilder sbProcedurePurview = new StringBuilder();
//得到工序查看权限
DataSet dsProcedurePurview = (DataSet)DoAsync(new AsyncMethod(() =>
{
return SystemModuleProxy.Service.GetUserPurview(9, LogInUserInfo.CurrentUser.UserID);
}));
if (dsProcedurePurview != null)
{
DataRow[] drPurview = dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Select("PurviewID=-1");
if (drPurview.Length == 0)
{
foreach (DataRow dr in dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Rows)
{
sbProcedurePurview.Append(dr[Constant.INT_IS_ZERO].ToString() + ",");
}
if (sbProcedurePurview.Length != Constant.INT_IS_ZERO)
{
this.dkProcedureSearchBox.Purview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
this.dkProcedureSearchBox.ProcedureIDS = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
this._currentUserPurview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
}
}
else
{
SearchProductionLineEntity line = new SearchProductionLineEntity();
dsProcedurePurview = SystemModuleProxy.Service.GetProdureList(line);
foreach (DataRow dr in dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Rows)
{
sbProcedurePurview.Append(dr["ProcedureID"].ToString() + ",");
}
if (sbProcedurePurview.Length != Constant.INT_IS_ZERO)
{
this.dkProcedureSearchBox.Purview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
this.dkProcedureSearchBox.ProcedureIDS = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
this._currentUserPurview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
///
/// 获取权限(生产线)
///
protected void getPurviewLine()
{
try
{
StringBuilder sbProcedurePurview = new StringBuilder();
//得到工序查看权限
DataSet dsProcedurePurview = (DataSet)DoAsync(new AsyncMethod(() =>
{
return SystemModuleProxy.Service.GetUserPurview(7, LogInUserInfo.CurrentUser.UserID);
}));
if (dsProcedurePurview != null)
{
DataRow[] drPurview = dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Select("PurviewID=-1");
if (drPurview.Length == 0)
{
foreach (DataRow dr in dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Rows)
{
sbProcedurePurview.Append(dr[Constant.INT_IS_ZERO].ToString() + ",");
}
if (sbProcedurePurview.Length != Constant.INT_IS_ZERO)
{
this.dkproductionLineSearchBox.Purview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
this.dkproductionLineSearchBox.ProductionLineIDS = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
this._currentUserLinePuview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
}
}
else
{
ProductionLineEntity line = new ProductionLineEntity();
line.ValueFlags = new object[] { 1 };
dsProcedurePurview = (DataSet)DoAsync(() =>
{
return PCModuleProxy.Service.SearchProductionLine(line);
});
foreach (DataRow dr in dsProcedurePurview.Tables[Constant.INT_IS_ZERO].Rows)
{
sbProcedurePurview.Append(dr["productionlineID"].ToString() + ",");
}
if (sbProcedurePurview.Length != Constant.INT_IS_ZERO)
{
this.dkproductionLineSearchBox.Purview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
this.dkproductionLineSearchBox.ProductionLineIDS = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
this._currentUserLinePuview = sbProcedurePurview.ToString().Substring(Constant.INT_IS_ZERO, sbProcedurePurview.Length - 1);
}
}
}
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
}
}