/*******************************************************************************
* Copyright(c) 2016 DongkeSoft All rights reserved. / Confidential
* 类的信息:
* 1.程序名称:F_RPT_030110.cs
* 2.功能描述:半检信息汇总表
* 编辑履历:
* 作者 日期 版本 修改内容
* 王鑫 2016/07/11 1.00 新建
*******************************************************************************/
using System;
using System.Data;
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.WCF.DataModels;
using Dongke.IBOSS.PRD.WCF.Proxys;
using Dongke.IBOSS.PRD.WCF.Proxys.PMModuleService;
using Dongke.IBOSS.PRD.WCF.DataModels.PMModule;
namespace Dongke.IBOSS.PRD.Client.ReportModule
{
///
/// 半检信息汇总表
///
public partial class F_RPT_030110 : DockPanelBase
{
#region 成员变量
//单例模式
private static F_RPT_030110 _instance;
#endregion
#region 构造函数
///
/// 废弃一览构造
///
public F_RPT_030110()
{
InitializeComponent();
this.Text = FormTitles.F_RPT_030110;
this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE;
this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE;
this.btnSearch.Text = ButtonText.BTN_SEARCH;
this.btnClearCondition.Text = ButtonText.BTN_CLEARCONDITION;
}
#endregion
#region 单例模式
///
/// 单例模式,防止重复创建窗体
///
public static F_RPT_030110 Instance
{
get
{
if (_instance == null)
{
_instance = new F_RPT_030110();
}
return _instance;
}
}
#endregion
#region 事件
///
/// 查询事件
///
///
///
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
//if(!cbSemiCheck.Checked)
//{
// MessageBox.Show("半检时间必须填写.", this.Text,
// MessageBoxButtons.OK, MessageBoxIcon.Warning);
// return;
//}
DataSet dsSemiCheck = (DataSet)DoAsync(new AsyncMethod(() =>
{
return this.GetSemiCheck();
}));
if (dsSemiCheck != null)
{
if (dsSemiCheck.Tables[0].Rows.Count != Constant.INT_IS_ZERO)
{
this.dgvSemiCheck.DataSource = ((DataSet)dsSemiCheck).Tables[Constant.INT_IS_ZERO];
this.dgvSemiCheck.ReadOnly = true;
this.dgvSemiCheck.Rows[0].Selected = true;
}
else
{
this.dgvSemiCheck.DataSource = null;
// 提示未查找到数据
MessageBox.Show(Messages.MSG_CMN_I002, this.Text,
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
this.dgvSemiCheck.DataSource = null;
// 提示未查找到数据
MessageBox.Show(Messages.MSG_CMN_I002, this.Text,
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
// 对异常进行共通处理
ExceptionManager.HandleEventException(this.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
}
}
///
/// 时间有效性切换
///
///
///
private void cbCDateTime_CheckedChanged(object sender, EventArgs e)
{
this.txtCDateTimeStart.Enabled = this.cbCDateTime.Checked;
this.txtCDateTimeEnd.Enabled = this.cbCDateTime.Checked;
}
///
/// 清空条件
///
///
///
private void btnClearCondition_Click(object sender, EventArgs e)
{
this.dkCProcedureSearchBox.ClearControl();
this.cbCDateTime.Checked = false;
//this.txtCDateTimeStart.Value = DateTime.Now;
//this.txtCDateTimeEnd.Value = DateTime.Now;
this.txtCUserCode.Text = string.Empty;
this.scbGoodsType.ClearValue();
this.txtGoodsCode.Text = string.Empty;
this.txtGroutingUserCode.Text = string.Empty;
this.cbGroutingDate.Checked = false;
//this.txtGroutingDateTimeStart.Value = DateTime.Now;
//this.txtGroutingDateTimeEnd.Value = DateTime.Now;
this.cbDeliveryDate.Checked = false;
// this.txtDeliveryDateTimeStart.Value = DateTime.Now;
// this.txtDeliveryDateTimeEnd.Value = DateTime.Now;
this.chkSemiCheckType.SelectedValues = new object[] { -1 };
this.cbSemiCheck.Checked = true;
//this.txtSemiCheckDateTimeStart.Value = DateTime.Now;
//this.txtSemiCheckDateTimeEnd.Value = DateTime.Now;
this.txtSemiCheckUserCode.Text = string.Empty;
this.dkRProcedureSearchBox.ClearControl();
this.txtReworkUserCode.Text = string.Empty;
this.chkReSemiCheckType.SelectedValues = new object[] { -1 };
this.cbReSemiCheck.Checked = false;
//this.txtReSemiCheckDateTimeStart.Value = DateTime.Now;
//this.txtReSemiCheckDateTimeEnd.Value = DateTime.Now;
this.txtReSemiCheckUserCode.Text = string.Empty;
this.txtCDateTimeStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
this.txtCDateTimeEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.txtGroutingDateTimeStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
this.txtGroutingDateTimeEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.txtSemiCheckDateTimeStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
this.txtSemiCheckDateTimeEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.txtReSemiCheckDateTimeStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
this.txtReSemiCheckDateTimeEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.txtDeliveryDateTimeStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
this.txtDeliveryDateTimeEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
}
///
/// 关闭一览窗体
///
///
///
private void tsbtnClose_Click(object sender, EventArgs e)
{
this.Close();
}
///
/// 窗体关闭事件
///
///
///
private void F_RPT_030110_FormClosed(object sender, FormClosedEventArgs e)
{
_instance = null;
}
///
/// 自动列宽
///
///
///
private void tsbtnAdaptive_Click(object sender, EventArgs e)
{
this.dgvSemiCheck.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
///
/// 窗体加载
///
///
///
private void F_RPT_030110_Load(object sender, EventArgs e)
{
try
{
// 加载权限
FormPermissionManager.FormPermissionControl(this.Name, this,
Dongke.IBOSS.PRD.Client.DataModels.LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData,
Dongke.IBOSS.PRD.Client.DataModels.LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
this.dgvSemiCheck.AutoGenerateColumns = false;
// 设置日期控件默认值
this.txtCDateTimeStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
this.txtCDateTimeEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.txtGroutingDateTimeStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
this.txtGroutingDateTimeEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.txtSemiCheckDateTimeStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
this.txtSemiCheckDateTimeEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.txtReSemiCheckDateTimeStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
this.txtReSemiCheckDateTimeEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.txtDeliveryDateTimeStart.Value = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
this.txtDeliveryDateTimeEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
// 加载半检,复检状态数据源
DataSet dsGetSemiCheckType = SystemModuleProxy.Service.GetSemiCheckType();
if (dsGetSemiCheckType != null && dsGetSemiCheckType.Tables[0].Rows.Count > 0)
{
DataRow[] drSemiCheckType = dsGetSemiCheckType.Tables[0].Select("Semichecktype=1");
if (drSemiCheckType.Length > 0)
{
this.chkSemiCheckType.ValueMember = "Semichecktypeid";
this.chkSemiCheckType.DisplayMember = "Semichecktypename";
this.chkSemiCheckType.DataSource = drSemiCheckType.CopyToDataTable();
}
DataRow[] drReSemiCheckType = dsGetSemiCheckType.Tables[0].Select("Semichecktype=2");
if (drReSemiCheckType.Length > 0)
{
this.chkReSemiCheckType.ValueMember = "Semichecktypeid";
this.chkReSemiCheckType.DisplayMember = "Semichecktypename";
this.chkReSemiCheckType.DataSource = drReSemiCheckType.CopyToDataTable();
}
}
}
catch (Exception ex)
{
// 对异常进行共通处理
ExceptionManager.HandleEventException(this.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
}
}
///
/// 注浆时间复选框改变事件
///
///
///
private void cbGroutingDate_CheckedChanged(object sender, EventArgs e)
{
this.txtGroutingDateTimeStart.Enabled = this.cbGroutingDate.Checked;
this.txtGroutingDateTimeEnd.Enabled = this.cbGroutingDate.Checked;
}
///
/// 半检时间复选框改变事件
///
///
///
private void cbSemiCheck_CheckedChanged(object sender, EventArgs e)
{
this.txtSemiCheckDateTimeStart.Enabled = this.cbSemiCheck.Checked;
this.txtSemiCheckDateTimeEnd.Enabled = this.cbSemiCheck.Checked;
}
///
/// 复检时间复选框改变事件
///
///
///
private void cbReSemiCheck_CheckedChanged(object sender, EventArgs e)
{
this.txtReSemiCheckDateTimeStart.Enabled = this.cbReSemiCheck.Checked;
this.txtReSemiCheckDateTimeEnd.Enabled = this.cbReSemiCheck.Checked;
}
private void cbDeliveryDate_CheckedChanged(object sender, EventArgs e)
{
this.txtDeliveryDateTimeStart.Enabled = this.cbDeliveryDate.Checked;
this.txtDeliveryDateTimeEnd.Enabled = this.cbDeliveryDate.Checked;
}
#endregion
#region 私有方法
///
/// 根据界面查询条件获取数据集
///
private DataSet GetSemiCheck()
{
try
{
SemiCheckEntity entity = new SemiCheckEntity();
entity.CProcedureIDS = this.dkCProcedureSearchBox.ProcedureIDS;
if (cbCDateTime.Checked)
{
entity.CDateTimeStart = this.txtCDateTimeStart.Value;// DateTime.Parse(this.txtCDateTimeStart.Value.ToString("yyyy-MM-dd") + " 0:0:0");
entity.CDateTimeEnd = this.txtCDateTimeEnd.Value;// DateTime.Parse(this.txtCDateTimeEnd.Value.ToString("yyyy-MM-dd") + " 23:59:59");
}
entity.CUserCode = this.txtCUserCode.Text.Trim();
entity.GoodsTypeCode = scbGoodsType.SearchedValue + "";
entity.GoodsCode = this.txtGoodsCode.Text.Trim();
entity.GroutingUserCode = this.txtGroutingUserCode.Text.Trim();
if (cbGroutingDate.Checked)
{
entity.GroutingDateTimeStart = this.txtGroutingDateTimeStart.Value;// DateTime.Parse(this.txtGroutingDateTimeStart.Value.ToString("yyyy-MM-dd") + " 0:0:0");
entity.GroutingDateTimeEnd = this.txtGroutingDateTimeEnd.Value;// DateTime.Parse(this.txtGroutingDateTimeEnd.Value.ToString("yyyy-MM-dd") + " 23:59:59");
}
if (cbDeliveryDate.Checked)
{
entity.DeliveryDateTimeStart = this.txtDeliveryDateTimeStart.Value;// DateTime.Parse(this.txtDeliveryDateTimeStart.Value.ToString("yyyy-MM-dd") + " 0:0:0");
entity.DeliveryDateTimeEnd = this.txtDeliveryDateTimeEnd.Value;// DateTime.Parse(this.txtDeliveryDateTimeEnd.Value.ToString("yyyy-MM-dd") + " 23:59:59");
}
object[] objSemiCheckType = this.chkSemiCheckType.SelectedValues;
string strSemiCheckType = "";
if (objSemiCheckType.Length > 0)
{
for (int i = 0; i < objSemiCheckType.Length; i++)
{
strSemiCheckType += objSemiCheckType[i].ToString() + ",";
}
strSemiCheckType = strSemiCheckType.TrimEnd(',');
}
entity.SemiCheckType = strSemiCheckType;
if (cbSemiCheck.Checked)
{
entity.SemiCheckDateTimeStart = this.txtSemiCheckDateTimeStart.Value;// DateTime.Parse(this.txtSemiCheckDateTimeStart.Value.ToString("yyyy-MM-dd") + " 0:0:0");
entity.SemiCheckDateTimeEnd = this.txtSemiCheckDateTimeEnd.Value;// DateTime.Parse(this.txtSemiCheckDateTimeEnd.Value.ToString("yyyy-MM-dd") + " 23:59:59");
}
entity.SemiCheckUserCode = this.txtSemiCheckUserCode.Text.Trim();
entity.RProcedureIDS = this.dkRProcedureSearchBox.ProcedureIDS;
entity.ReworkUserCode = this.txtReworkUserCode.Text.Trim();
object[] objReSemiCheckType = this.chkReSemiCheckType.SelectedValues;
string strReSemiCheckType = "";
if (objReSemiCheckType.Length > 0)
{
for (int i = 0; i < objReSemiCheckType.Length; i++)
{
strReSemiCheckType += objReSemiCheckType[i].ToString() + ",";
}
strReSemiCheckType = strReSemiCheckType.TrimEnd(',');
}
entity.ReSemiCheckType = strReSemiCheckType;
if (cbReSemiCheck.Checked)
{
entity.ReSemiCheckDateTimeStart = this.txtReSemiCheckDateTimeStart.Value;// DateTime.Parse(this.txtReSemiCheckDateTimeStart.Value.ToString("yyyy-MM-dd") + " 0:0:0");
entity.ReSemiCheckDateTimeEnd = this.txtReSemiCheckDateTimeEnd.Value;// DateTime.Parse(this.txtReSemiCheckDateTimeEnd.Value.ToString("yyyy-MM-dd") + " 23:59:59");
}
entity.ReSemiCheckUserCode = this.txtReSemiCheckUserCode.Text.Trim();
ServiceResultEntity resultEntity = ReportModuleProxy.Service.GetRPT030110Data(entity);
return resultEntity.Data;
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
}
}