/*******************************************************************************
* Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential
* 类的信息:
* 1.程序名称:F_RPT_030103_1.cs
* 2.功能描述:出窑数量汇总表
* 编辑履历:
* 作者 日期 版本 修改内容
* 袁新成 2015/4/14 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_030103_1 : DKDockPanelBase
{
#region 成员变量
// 窗体的单例模式
private static F_RPT_030103_1 _instance;
//实体类
private RPT030103_SE rptse = new RPT030103_SE();
//默认清空工序,重置回用户当前权限工序
private string _currentUserPurview = null;
//默认清空生产线,重置回用户当前权限生产线
private string _currentUserLinePuview = null;
#endregion
#region 构造函数
public F_RPT_030103_1()
{
InitializeComponent();
// 窗体显示的Title
this.Text = FormTitles.F_RPT_030103;
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;
}
#endregion
#region 单例模式
///
/// 单例模式,防止重复创建窗体
///
public static F_RPT_030103_1 Instance
{
get
{
if (_instance == null || _instance.IsDisposed)
{
_instance = new F_RPT_030103_1();
}
return _instance;
}
}
#endregion
#region 事件处理
///
/// 窗体加载事件
///
///
///
private void F_RPT_030103_1_Load(object sender, EventArgs e)
{
try
{
// 加载权限
FormPermissionManager.FormPermissionControl(this.Name, this,
LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData, LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
//绑定下了列表
BindPage();
// 设置表格不自动创建列
this.dgvRptProcedureDetail.AutoGenerateColumns = false;
this.dgvRptProcedure.AutoGenerateColumns = false;
this.dkproductionLineSearchBox.IsEnablePurview = true;
this.dkProcedureSearchBox.IsEnablePurview = true;
this.dropRptProcedure.Focus();
// 初始化时间控件为当前日期
this.dtpOverDateStart.Value = DateTime.Now.Date;
this.dtpOverDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.dtpOutDateStart.Value = DateTime.Now.Date;
this.dtpOutDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.dtpDDateStart.Value = DateTime.Now.Date;
this.dtpDDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.dtpGDateStart.Value = DateTime.Now.Date;
this.dtpGDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.chkTestMouldFlag.AllItemCheck();
// lsq modify 财年默认为空
//begin
////财年默认本年
//this.txtFyear.Text = DateTime.Now.Year.ToString();
//end
getPurview();
getPurviewLine();
//实验单
DataTable dtTest = new DataTable();
dtTest.Columns.Add("TestFormFlagid", typeof(int));
dtTest.Columns.Add("TestFormFlagname", typeof(string));
DataRow drTest = dtTest.NewRow();
drTest["TestFormFlagid"] = 0;
drTest["TestFormFlagname"] = "全部";
dtTest.Rows.Add(drTest);
drTest = dtTest.NewRow();
drTest["TestFormFlagid"] = 1;
drTest["TestFormFlagname"] = "实验单";
dtTest.Rows.Add(drTest);
drTest = dtTest.NewRow();
drTest["TestFormFlagid"] = 2;
drTest["TestFormFlagname"] = "研发实验单";
dtTest.Rows.Add(drTest);
drTest = dtTest.NewRow();
drTest["TestFormFlagid"] = 3;
drTest["TestFormFlagname"] = "非研发实验单";
dtTest.Rows.Add(drTest);
this.dropTestFormFlag.DataSource = dtTest;
this.dropTestFormFlag.ValueMember = "TestFormFlagid";
this.dropTestFormFlag.DisplayMember = "TestFormFlagname";
}
catch (Exception ex)
{
// 对异常进行共通处理
ExceptionManager.HandleEventException(this.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
}
}
///
/// 自动适应列宽
///
///
///
private void tsbtnAdaptive_Click(object sender, EventArgs e)
{
if (this.tblReportModule.SelectedIndex == Constant.INT_IS_ZERO)
{
this.dgvRptProcedure.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
else
{
this.dgvRptProcedureDetail.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
}
///
/// 窗体关闭事件
///
///
///
private void F_RPT_030103_1_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.dropRptProcedure.Text))
{
this.dropRptProcedure.Focus();
MessageBox.Show("数据源是必选项,请选择数据源!", this.Text,
MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrEmpty(this._currentUserPurview))
{
// 提示未查找到数据
MessageBox.Show(Messages.MSG_CMN_I002, this.Text,
MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
CreateSearchCondition();
if (this.tblReportModule.SelectedIndex == Constant.INT_IS_ZERO)//出窑数量汇总查询
{
this.dgvRptProcedure.DataSource = null;
this.dgvRptProcedure.DataSource = this.GetSearchTotalData();
}
else //出窑数量明细查询
{
this.dgvRptProcedureDetail.DataSource = null;
this.dgvRptProcedureDetail.DataSource = this.GetSearchDetailData();
}
}
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 btnClearCondition_Click(object sender, EventArgs e)
{
this.scbGoods.ClearValue();
this.scbGoodsType.ClearValue();
this.dkProcedureSearchBox.ClearControl();
this.dkproductionLineSearchBox.ClearControl();
this.dkUserInfoSearchBox.ClearControl();
this.dropKilnCode.SelectedValue = Constant.CBO_SELECT_ALL_VALUE;
//this.dkProcedureSearchBox.ProcedureIDS = this._currentUserPurview;
this.dkProcedureSearchBox.ProcedureIDS = this._currentUserPurview;
this.dkproductionLineSearchBox.ProductionLineIDS = this._currentUserLinePuview;
this.txtGroutingUserCode.Clear();
this.txtKcode.Clear();
this.txtFyear.Clear();
this.chkOver.Checked = false;
this.chkOut.Checked = true;
this.dtpOutDateStart.Value = DateTime.Now.Date;
this.dtpOutDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.chkDDate.Checked = false;
this.chkGDate.Checked = false;
this.chkspecialrepairflag.Checked = false;
this.chkPUserCode.Checked = true;
this.chkTestMouldFlag.AllItemCheck();
this.dropTestFormFlag.SelectedIndex = 0;
}
///
/// 双击单元格事件
///
///
///
private void dgvRptProcedure_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
try
{
//判断是否为空
if (this.dgvRptProcedure.CurrentRow == null ||
this.dgvRptProcedure.CurrentRow.Index < 0)
{
return;
}
//获取数据信息
DataGridViewRow dgvr = dgvRptProcedure.CurrentRow;
string goodsId = dgvr.Cells["GoodsId"].Value.ToString();
string userId = dgvr.Cells["Userid"].Value.ToString();
string procedureId = dgvr.Cells["ProcedureId"].Value.ToString();
//判断是否选择统计行
if (!goodsId.Equals("--"))
{
this.dgvRptProcedureDetail.DataSource = null;
this.tblReportModule.SelectTab(1);
//获取条件
CreateSearchCondition();
this.rptse.KilnID = Convert.ToInt32(dgvr.Cells["Kilnid"].Value.ToString());
this.rptse.GoodsIDS = goodsId.ToString();
this.rptse.RptTProcedureIDS = procedureId.ToString();
this.rptse.UserIDS = userId.ToString();
this.dgvRptProcedureDetail.DataSource = null;
this.dgvRptProcedureDetail.DataSource = GetSearchDetailData();
}
else
{
if (string.IsNullOrEmpty(procedureId))
{
this.dgvRptProcedureDetail.DataSource = null;
this.tblReportModule.SelectTab(1);
//获取条件
CreateSearchCondition();
this.dgvRptProcedureDetail.DataSource = null;
this.dgvRptProcedureDetail.DataSource = GetSearchDetailData();
}
else
{
this.dgvRptProcedureDetail.DataSource = null;
this.tblReportModule.SelectTab(1);
//获取条件
CreateSearchCondition();
this.rptse.RptTProcedureIDS = procedureId.ToString();
this.dgvRptProcedureDetail.DataSource = null;
this.dgvRptProcedureDetail.DataSource = GetSearchDetailData();
}
}
}
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 chkOver_CheckedChanged(object sender, EventArgs e)
{
if (this.chkOver.Checked)
{
this.dtpOverDateStart.Enabled = true;
this.dtpOverDateEnd.Enabled = true;
}
else
{
this.dtpOverDateStart.Enabled = false;
this.dtpOverDateEnd.Enabled = false;
this.dtpOverDateStart.Value = DateTime.Now.Date;
this.dtpOverDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
}
}
private void chkOut_CheckedChanged(object sender, EventArgs e)
{
if (this.chkOut.Checked)
{
this.dtpOutDateStart.Enabled = true;
this.dtpOutDateEnd.Enabled = true;
}
else
{
this.dtpOutDateStart.Enabled = false;
this.dtpOutDateEnd.Enabled = false;
this.dtpOutDateStart.Value = DateTime.Now.Date;
this.dtpOutDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
}
}
private void chkDDate_CheckedChanged(object sender, EventArgs e)
{
if (this.chkDDate.Checked)
{
this.dtpDDateStart.Enabled = true;
this.dtpDDateEnd.Enabled = true;
}
else
{
this.dtpDDateStart.Enabled = false;
this.dtpDDateEnd.Enabled = false;
this.dtpDDateStart.Value = DateTime.Now.Date;
this.dtpDDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
}
}
private void chkGDate_CheckedChanged(object sender, EventArgs e)
{
if (this.chkGDate.Checked)
{
this.dtpGDateStart.Enabled = true;
this.dtpGDateEnd.Enabled = true;
}
else
{
this.dtpGDateStart.Enabled = false;
this.dtpGDateEnd.Enabled = false;
this.dtpGDateStart.Value = DateTime.Now.Date;
this.dtpGDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
}
}
#endregion
#region 私有方法
///
/// 搜索条件
///
///
private void CreateSearchCondition()
{
rptse = new RPT030103_SE();
this.rptse.RptProcedureID = Convert.ToInt32(this.dropRptProcedure.SelectedValue);
//获取数据来源工序Id
ServiceResultEntity srerptsproc = DoAsync(() =>
{
return ReportModuleProxy.Service.GetRptSourceProcedureModule(this.rptse.RptProcedureID);
}
);
this.rptse.RptSProcedureID =
Convert.ToInt32(srerptsproc.Data.Tables[Constant.INT_IS_ZERO].Rows[Constant.INT_IS_ZERO]["Procedureid"].ToString());
this.rptse.RptTProcedureIDS = this.dkProcedureSearchBox.ProcedureIDS;
this.rptse.ProductionLineID = this.dkproductionLineSearchBox.ProductionLineID;
this.rptse.UserIDS = this.dkUserInfoSearchBox.UserIDS;
this.rptse.GoodsIDS = scbGoods.CheckedPKMember;
this.rptse.GoodsTypeIDS = scbGoodsType.SearchedValue + "";
if (!this.dropKilnCode.Text.Equals(Constant.CBO_SELECT_ALL_NAME))
{
this.rptse.KilnID = Convert.ToInt32(this.dropKilnCode.SelectedValue);
}
if (this.chkOver.Checked)
{
this.rptse.CreateTimeStart = DateTime.Parse(this.dtpOverDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
this.rptse.CreateTimeEnd = DateTime.Parse(this.dtpOverDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
}
if (this.chkOut.Checked)
{
this.rptse.OutTimeStart = DateTime.Parse(this.dtpOutDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
this.rptse.OutTimeEnd = DateTime.Parse(this.dtpOutDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
}
if (this.chkDDate.Checked)
{
this.rptse.DTimeStart = DateTime.Parse(this.dtpDDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
this.rptse.DTimeEnd = DateTime.Parse(this.dtpDDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
}
if (this.chkGDate.Checked)
{
this.rptse.GTimeStart = DateTime.Parse(this.dtpGDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
this.rptse.GTimeEnd = DateTime.Parse(this.dtpGDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
}
if (this.dropTestFormFlag.SelectedValue != null)
{
this.rptse.TestFormFlag = Convert.ToInt32(this.dropTestFormFlag.SelectedValue);
}
this.rptse.Specialrepairflag = this.chkspecialrepairflag.Checked;
this.rptse.GroutingUserCode = this.txtGroutingUserCode.Text.Trim();
this.rptse.Kcode = this.txtKcode.Text.Trim();
this.rptse.Fyear = this.txtFyear.Text.Trim();
this.rptse.DisPUserCode = this.chkPUserCode.Checked;
object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues;
if (testMouldFlags.Length == 1)
{
rptse.TestMouldFlag = testMouldFlags[0].ToString();
}
}
///
/// 查询出窑数量汇总表
///
private DataTable GetSearchTotalData()
{
try
{
// 调用服务器端获取数据集
ServiceResultEntity sre = DoAsync(() =>
{
return ReportModuleProxy.Service.GetRPT030103SData(rptse);
}
);
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 DataTable GetSearchDetailData()
{
try
{
// 调用服务器端获取数据集
ServiceResultEntity sre = DoAsync(() =>
{
return ReportModuleProxy.Service.GetRPT030103IData(rptse);
}
);
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 BindPage()
{
//绑定数据来源下来列表
ServiceResultEntity sresource = DoAsync(() =>
{
return ReportModuleProxy.Service.GetRptProcedureModule();
}
);
this.dropRptProcedure.DataSource = sresource.Data.Tables[Constant.INT_IS_ZERO];
this.dropRptProcedure.ValueMember = "Rptprocedureid";
this.dropRptProcedure.DisplayMember = "Rptprocedurename";
ServiceResultEntity srekiln = DoAsync(() =>
{
byte byFlage = Convert.ToByte(Constant.ValueFlag.Invalid);
return ReportModuleProxy.Service.GetKilnData(byFlage);
}
);
DataTable dtKilnInfo = srekiln.Data.Tables[Constant.INT_IS_ZERO];
DataRow newRowDic = dtKilnInfo.NewRow();
newRowDic["KilnID"] = Constant.CBO_SELECT_ALL_VALUE;
newRowDic["KilnCode"] = Constant.CBO_SELECT_ALL_NAME;
dtKilnInfo.Rows.InsertAt(newRowDic, Constant.INT_IS_ZERO);
this.dropKilnCode.DataSource = dtKilnInfo;
this.dropKilnCode.ValueMember = "KilnID";
this.dropKilnCode.DisplayMember = "KilnCode";
}
///
/// 获取权限(生产线)
///
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;
}
}
///
/// 获取权限
///
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;
}
}
#endregion
private void lblKcode_Click(object sender, EventArgs e)
{
}
private void txtKcode_TextChanged(object sender, EventArgs e)
{
}
private void txtGroutingUserCode_TextChanged(object sender, EventArgs e)
{
}
}
}