/*******************************************************************************
* Copyright(c) 2015 DongkeSoft All rights reserved. / Confidential
* 类的信息:
* 1.程序名称:F_RPT_030102_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;
using Dongke.IBOSS.PRD.WCF.DataModels.PMModule;
namespace Dongke.IBOSS.PRD.Client.ReportModule
{
public partial class F_RPT_030112 : DKDockPanelBase
{
#region 成员变量
// 窗体的单例模式
private static F_RPT_030112 _instance;
//实体类
private RPT030102_SE _rptse = null;
private RPT030102_SE _rptse1 = null;
// 存储查询条件
private SearchFinishedProductEntity _orderEntity = null;
//private SearchFinishedProductEntity _orderEntity2 = null;
private SearchFinishedProductEntity _orderCRE = null;
#endregion
#region 构造函数
public F_RPT_030112()
{
InitializeComponent();
// 窗体显示的Title
this.Text = FormTitles.F_RPT_030112;
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_030112 Instance
{
get
{
if (_instance == null || _instance.IsDisposed)
{
_instance = new F_RPT_030112();
}
return _instance;
}
}
#endregion
#region 事件处理
///
/// 窗体加载事件
///
///
///
private void F_RPT_030102_1_Load(object sender, EventArgs e)
{
try
{
// 加载权限
FormPermissionManager.FormPermissionControl(this.Name, this,
LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData,
LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
// 设置表格不自动创建列
this.dgvOrder.AutoGenerateColumns = false;
this.dgvOrderDetail.AutoGenerateColumns = false;
//this.dtpStartTime.Enabled = false;
//this.dtpEndTime.Enabled = false;
this.dtpStartTime.Value = DateTime.Now.Date;
this.dtpEndTime.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.chkTestMouldFlag.AllItemCheck();
}
catch (Exception ex)
{
// 对异常进行共通处理
ExceptionManager.HandleEventException(this.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
}
}
///
/// 窗体关闭事件
///
///
///
private void F_RPT_030102_1_FormClosed(object sender, FormClosedEventArgs e)
{
_instance = null;
}
///
/// 关闭按钮
///
///
///
private void tsbtnClose_Click(object sender, EventArgs e)
{
this.Close();
}
///
/// 自动适应列宽
///
///
///
private void tsbtnAdaptive_Click(object sender, EventArgs e)
{
if (this.tblScrapTotalModule.SelectedIndex == Constant.INT_IS_ZERO)
{
this.dgvOrder.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
else
{
this.dgvOrderDetail.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
}
///
/// 查询按钮事件
///
///
///
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
GetOrderEntityFromLayout();// 设置查询实体类
if (this.tblScrapTotalModule.SelectedIndex == 0)//交接汇总查询
{
//this._orderEntity2 = this._orderEntity;
//this.dgvOrder.DataSource = null;
//this.dgvOrder.DataSource = this.GetSearchTotalData();
_orderCRE = this._orderEntity;
this.GetSearchTotalData();
}
else if (this.tblScrapTotalModule.SelectedIndex == 1)//交接明细查询
{
this.dgvOrderDetail.DataSource = null;
this.dgvOrderDetail.DataSource = this.GetSearchDetailData();
}
else if (this.tblScrapTotalModule.SelectedIndex == 2)//交接数量查询
{
this.dgvNum.DataSource = null;
ClientRequestEntity cre = new ClientRequestEntity();
cre.NameSpace = "R03";
cre.Name = "R030112Num";
cre.Properties["OrderNo"] = this.txtOrderNo.Text.Trim();
cre.Properties["FHUserCode"] = this.txtFHUserCode.Text.Trim();
if (this.chkDateTime.Checked)
{
cre.Properties["FHTimeStart"] = this.dtpStartTime.Value;
cre.Properties["FHTimeEnd"] = this.dtpEndTime.Value;
}
cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + "";
cre.Properties["GoodsCode"] = this.txtGoodsCode.Text.Trim();
cre.Properties["GoodsModel"] = this.txtGoodsModel.Text.Trim();
cre.Properties["LogoIDS"] = this.dkLogoSearchBox1.LogoIDS;
object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues;
if (testMouldFlags.Length == 1)
{
cre.Properties["TestMouldFlag"] = testMouldFlags[0].ToString();
}
ServiceResultEntity resultEntity = DoAsync(() =>
{
return ReportModuleProxy.Service.DoRequest(cre);
});
if (resultEntity == null || resultEntity.Data == null ||
resultEntity.Data.Tables.Count == 0 ||
resultEntity.Data.Tables[0].Rows.Count == 0)
{
this.dgvNum.AutoResizeColumns();
return;
}
else
{
this.dgvNum.DataSource = resultEntity.Data.Tables[0];
this.dgvNum.ReadOnly = true;
this.dgvNum.Rows[0].Selected = true;
this.dgvNum.AutoResizeColumns();
}
}
else if (this.tblScrapTotalModule.SelectedIndex == 3)//型号数量查询
{
this.dgvGoodsNum.DataSource = null;
ClientRequestEntity cre = new ClientRequestEntity();
cre.NameSpace = "R03";
cre.Name = "R030112GoodsNum";
cre.Properties["OrderNo"] = this.txtOrderNo.Text.Trim();
cre.Properties["FHUserCode"] = this.txtFHUserCode.Text.Trim();
if (this.chkDateTime.Checked)
{
cre.Properties["FHTimeStart"] = this.dtpStartTime.Value;
cre.Properties["FHTimeEnd"] = this.dtpEndTime.Value;
}
cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + "";
cre.Properties["GoodsCode"] = this.txtGoodsCode.Text.Trim();
cre.Properties["GoodsModel"] = this.txtGoodsModel.Text.Trim();
cre.Properties["LogoIDS"] = this.dkLogoSearchBox1.LogoIDS;
object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues;
if (testMouldFlags.Length == 1)
{
cre.Properties["TestMouldFlag"] = testMouldFlags[0].ToString();
}
ServiceResultEntity resultEntity = DoAsync(() =>
{
return ReportModuleProxy.Service.DoRequest(cre);
});
if (resultEntity == null || resultEntity.Data == null ||
resultEntity.Data.Tables.Count == 0 ||
resultEntity.Data.Tables[0].Rows.Count == 0)
{
this.dgvGoodsNum.AutoResizeColumns();
return;
}
else
{
this.dgvGoodsNum.DataSource = resultEntity.Data.Tables[0];
this.dgvGoodsNum.ReadOnly = true;
this.dgvGoodsNum.Rows[0].Selected = true;
this.dgvGoodsNum.AutoResizeColumns();
}
}
else
{
}
}
catch (Exception ex)
{
this.btnSearch.Enabled = true;
// 对异常进行共通处理
ExceptionManager.HandleEventException(this.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
}
}
///
/// 清空条件按钮事件
///
///
///
private void btnClearCondition_Click(object sender, EventArgs e)
{
this.txtOrderNo.Clear();
this.txtFHUserCode.Clear();
this.chkDateTime.Checked = false;
this.dtpStartTime.Value = DateTime.Now.Date;
this.dtpEndTime.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.scbGoodsType.ClearValue();
this.txtGoodsCode.Clear();
this.dkLogoSearchBox1.ClearControl();
this.chkTestMouldFlag.AllItemCheck();
}
///
/// 双击单元格事件
///
///
///
private void dgvScrapTotalModule_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
//判断是否为空
if (this.dgvOrder.CurrentRow == null)
{
return;
}
//获取数据信息
DataRowView row = dgvOrder.CurrentRow.DataBoundItem as DataRowView;
//this._orderEntity = _orderCRE;
if (row["fhorderid"] == DBNull.Value)
{
this._orderCRE.OrderID = null;
}
else
{
this._orderCRE.OrderID = Convert.ToInt32(row["fhorderid"]);
}
if (row["goodsid"] == DBNull.Value)
{
this._orderCRE.GoodsID = null;
}
else
{
this._orderCRE.GoodsID = Convert.ToInt32(row["goodsid"]);
}
if (row["logoid"] == DBNull.Value)
{
this._orderCRE.LogoID = null;
}
else
{
this._orderCRE.LogoID = Convert.ToInt32(row["logoid"]);
}
this.dgvOrderDetail.DataSource = null;
this.tblScrapTotalModule.SelectTab(1);
this.dgvOrderDetail.DataSource = GetSearchDetailDataByDouble();
}
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 chkDateTime_CheckedChanged(object sender, EventArgs e)
{
this.dtpStartTime.Enabled = chkDateTime.Checked;
this.dtpEndTime.Enabled = chkDateTime.Checked;
}
#endregion
#region 私有方法
///
/// 搜索条件
///
///
private SearchFinishedProductEntity GetOrderEntityFromLayout()
{
this._orderEntity = new SearchFinishedProductEntity();
this._orderEntity.OrderNo = this.txtOrderNo.Text.Trim();
this._orderEntity.FHUserCode = this.txtFHUserCode.Text.Trim();
if (this.chkDateTime.Checked)
{
this._orderEntity.FHTimeStart = this.dtpStartTime.Value;
this._orderEntity.FHTimeEnd = this.dtpEndTime.Value;
}
this._orderEntity.GoodsTypeCode = scbGoodsType.SearchedValue + "";
this._orderEntity.GoodsCode = this.txtGoodsCode.Text.Trim();
this._orderEntity.GoodsModel = this.txtGoodsModel.Text.Trim();
this._orderEntity.LogoIDS = this.dkLogoSearchBox1.LogoIDS;
object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues;
if (testMouldFlags.Length == 1)
{
_orderEntity.TestMouldFlag = testMouldFlags[0].ToString();
}
return this._orderEntity;
}
///
/// 明细搜索条件
///
///
private void CreateSearchConditionDetail()
{
this._rptse = new RPT030102_SE();
this._rptse.ProductionLineID = this._rptse1.ProductionLineID;
this._rptse.GoodsTypeCode = this._rptse1.GoodsTypeCode;
this._rptse.GoodsCode = this._rptse1.GoodsCode;
this._rptse.ProcedureIDS = this._rptse1.ProcedureIDS;
this._rptse.ScrapDateStart = this._rptse1.ScrapDateStart;
this._rptse.ScrapDateEnd = this._rptse1.ScrapDateEnd;
this._rptse.ResponProcedureIDS = this._rptse1.ResponProcedureIDS;
this._rptse.ResponUserIDS = this._rptse1.ResponUserIDS;
this._rptse.CreatUser = this._rptse1.CreatUser;
this._rptse.AuditUser = this._rptse1.AuditUser;
this._rptse.SpecialRepairFlag = this._rptse1.SpecialRepairFlag;
}
///
/// 查询损坏汇总表
///
private DataTable GetSearchTotalData()
{
try
{
//// 调用服务器端获取数据集
//ServiceResultEntity sre = DoAsync(() =>
//{
// return ReportModuleProxy.Service.GetRPT0030112SData(this._orderEntity);
//}
//);
//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];
//}
this.dgvOrder.DataSource = null;
ClientRequestEntity cre = new ClientRequestEntity();
cre.NameSpace = "R03";
cre.Name = "R030112Sum";
cre.Properties["OrderNo"] = this.txtOrderNo.Text.Trim();
cre.Properties["FHUserCode"] = this.txtFHUserCode.Text.Trim();
if (this.chkDateTime.Checked)
{
cre.Properties["FHTimeStart"] = this.dtpStartTime.Value;
cre.Properties["FHTimeEnd"] = this.dtpEndTime.Value;
}
cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + "";
cre.Properties["GoodsCode"] = this.txtGoodsCode.Text.Trim();
cre.Properties["GoodsModel"] = this.txtGoodsModel.Text.Trim();
cre.Properties["LogoIDS"] = this.dkLogoSearchBox1.LogoIDS;
object[] testMouldFlags = this.chkTestMouldFlag.SelectedValues;
if (testMouldFlags.Length == 1)
{
cre.Properties["TestMouldFlag"] = testMouldFlags[0].ToString();
}
ServiceResultEntity resultEntity = DoAsync(() =>
{
return ReportModuleProxy.Service.DoRequest(cre);
});
if (resultEntity == null || resultEntity.Data == null ||
resultEntity.Data.Tables.Count == 0 ||
resultEntity.Data.Tables[0].Rows.Count == 0)
{
this.dgvOrder.AutoResizeColumns();
return null;
}
else
{
this.dgvOrder.DataSource = resultEntity.Data.Tables[0];
this.dgvOrder.ReadOnly = true;
this.dgvOrder.Rows[0].Selected = true;
this.dgvOrder.AutoResizeColumns();
}
return null;
}
catch (Exception ex)
{
throw ex;
}
}
///
/// 查询损坏明细表
///
private DataTable GetSearchDetailData()
{
try
{
// 调用服务器端获取数据集
ServiceResultEntity sre = DoAsync(() =>
{
return ReportModuleProxy.Service.GetRPT0030112DetailSData(this._orderEntity);
}
);
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 GetSearchDetailDataByDouble()
{
try
{
// 调用服务器端获取数据集
ServiceResultEntity sre = DoAsync(() =>
{
return ReportModuleProxy.Service.GetRPT0030112DetailSData(this._orderCRE);
}
);
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;
}
}
#endregion
}
}