/*******************************************************************************
* Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential
* 类的信息:
* 1.程序名称:F_RPT_040110.cs
* 2.功能描述:产成品逐日出窑数值分析表
* 编辑履历:
* 作者 日期 版本 修改内容
* 陈晓野 2016/11/09 1.00 新建
*******************************************************************************/
using System;
using System.Collections.Generic;
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_040110 : DKDockPanelBase
{
#region 成员变量
// 窗体的单例模式
private static F_RPT_040110 _instance;
//private TreeNode tnGUsercode = new TreeNode("成型工号");
//private TreeNode tnGLType = new TreeNode("成型线类型");
#endregion
#region 构造函数
public F_RPT_040110()
{
InitializeComponent();
// 窗体显示的Title
//this.Text = FormTitles.F_RPT_040105;
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;
//tnGUsercode.Name = "成型工号";
//tnGUsercode.Text = "成型工号";
//tnGLType.Name = "成型线类型";
//tnGLType.Text = "成型线类型";
//this.treeView1.Nodes.Insert(1, tnGUsercode);
//this.treeView1.Nodes.Insert(2, tnGLType);
this.gusercode.Visible = false;
this.gltype.Visible = false;
}
#endregion
#region 单例模式
///
/// 单例模式,防止重复创建窗体
///
public static F_RPT_040110 Instance
{
get
{
if (_instance == null || _instance.IsDisposed)
{
_instance = new F_RPT_040110();
}
return _instance;
}
}
#endregion
#region 事件处理
///
/// 窗体加载事件
///
///
///
private void F_RPT_040104_Load(object sender, EventArgs e)
{
try
{
// 加载权限
FormPermissionManager.FormPermissionControl(this.Name, this,
LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData,
LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
//绑定下了列表
BindPage();
// 设置表格不自动创建列
this.dgvTQ.AutoGenerateColumns = false;
this.dropRptProcedure.Focus();
//回收标识默认选否
this.chkRecyclingFlag.FalseItemCheck();
// 初始化时间控件为当前日期
this.dtpAccountDateStart.Value = DateTime.Now.Date;
this.dtpAccountDateEnd.Value = this.dtpAccountDateStart.Value.AddDays(1).AddSeconds(-1);
}
catch (Exception ex)
{
// 对异常进行共通处理
ExceptionManager.HandleEventException(this.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
}
}
///
/// 自动适应列宽
///
///
///
private void tsbtnAdaptive_Click(object sender, EventArgs e)
{
this.dgvTQ.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
///
/// 窗体关闭事件
///
///
///
private void F_RPT_040104_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.dgvTQ.DataSource = null;
if (this.chkG.Checked)
{
this.gusercode.Visible = true;
this.gltype.Visible = true;
//if (!this.treeView1.Nodes.Contains(tnGUsercode))
//{
// this.treeView1.Nodes.Insert(1, tnGUsercode);
//}
//if (!this.treeView1.Nodes.Contains(tnGLType))
//{
// this.treeView1.Nodes.Insert(2, tnGLType);
//}
}
else
{
this.gusercode.Visible = false;
this.gltype.Visible = false;
//if (this.treeView1.Nodes.Contains(tnGUsercode))
//{
// this.treeView1.Nodes.Remove(tnGUsercode);
//}
//if (this.treeView1.Nodes.Contains(tnGLType))
//{
// this.treeView1.Nodes.Remove(tnGLType);
//}
}
DataSet dataSet = this.GetSearchData();
if (dataSet == null)
{
return;
}
this.dgvTQ.DataSource = dataSet.Tables[0];
}
catch (Exception ex)
{
this.btnSearch.Enabled = true;
this.btnClearCondition.Enabled = true;
this.dgvTQ.Enabled = true;
// 对异常进行共通处理
ExceptionManager.HandleEventException(this.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
}
finally
{
this.btnSearch.Enabled = true;
this.btnClearCondition.Enabled = true;
this.dgvTQ.Enabled = true;
}
}
///
/// 清空条件按钮事件
///
///
///
private void btnClearCondition_Click(object sender, EventArgs e)
{
this.dropKilnCode.SelectedIndex = 0;
this.dtpAccountDateStart.Value = DateTime.Now.Date;
this.dtpAccountDateEnd.Value = this.dtpAccountDateStart.Value.AddDays(1).AddSeconds(-1);
}
#endregion
#region 私有方法
///
/// 根据界面查询条件获取数据集
///
private DataSet GetSearchData()
{
try
{
RPT040110_SE se = new RPT040110_SE();
if (string.IsNullOrEmpty(this.dropRptProcedure.Text))
{
this.dropRptProcedure.Focus();
return null;
}
se.RptProcedureID = Convert.ToInt32(this.dropRptProcedure.SelectedValue);
//获取数据来源工序Id
ServiceResultEntity sre0 = this.DoAsync(() =>
{
return ReportModuleProxy.Service.GetRptSourceProcedureModule(se.RptProcedureID);
}
);
if (sre0.Data != null && sre0.Data.Tables.Count > 0)
{
se.RptSProcedureID = int.Parse(sre0.Data.Tables[0].Rows[Constant.INT_IS_ZERO]["Procedureid"].ToString());
}
//获取数据来源工序Id
if (!this.dropKilnCode.Text.Equals(Constant.CBO_SELECT_ALL_NAME))
{
se.KilnID = Convert.ToInt32(this.dropKilnCode.SelectedValue);
}
object[] testRecyclingFlags = this.chkRecyclingFlag.SelectedValues;
if (testRecyclingFlags.Length == 1)
{
se.RECYCLINGFLAG = Convert.ToInt32(testRecyclingFlags[0]);
}
se.CreateTimeStart = DateTime.Parse(this.dtpAccountDateStart.Value.ToString("yyyy-MM-dd HH:mm") + ":00");
se.CreateTimeEnd = DateTime.Parse(this.dtpAccountDateEnd.Value.ToString("yyyy-MM-dd HH:mm") + ":59");
se.IsShowG = this.chkG.Checked;
// 调用服务器端获取数据集
ServiceResultEntity sre = DoAsync(() =>
{
return ReportModuleProxy.Service.GetRPT040110SData(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;
}
return null;
}
catch (Exception ex)
{
throw ex;
}
}
///
/// 绑定下拉列表值
///
///
private void BindPage()
{
//绑定数据来源下拉列表
ServiceResultEntity sre1 = DoAsync(() =>
{
return ReportModuleProxy.Service.GetRptProcedureModule();
}
);
this.dropRptProcedure.DataSource = sre1.Data.Tables[Constant.INT_IS_ZERO];
this.dropRptProcedure.ValueMember = "Rptprocedureid";
this.dropRptProcedure.DisplayMember = "Rptprocedurename";
//绑定窑炉下来列表
ServiceResultEntity sre2 = DoAsync(() =>
{
byte byFlage = Convert.ToByte(Constant.ValueFlag.Invalid);
return ReportModuleProxy.Service.GetKilnData(byFlage);
}
);
DataTable dtKilnInfo = sre2.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";
}
#endregion
}
}