/*******************************************************************************
* 类的信息:
* 1.程序名称:F_RPT_080117.cs
* 2.功能描述:QC检验计划分析明细表
* 编辑履历:
* 作者 日期 版本 修改内容
* 李士越 2024/6/17 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 System.Collections.Generic;
namespace Dongke.IBOSS.PRD.Client.ReportModule
{
///
/// QC检验计划分析明细表
///
public partial class F_RPT_080117 : DKDockPanelBase
{
#region 成员变量
// 窗体的单例模式
private static F_RPT_080117 _instance;
#endregion
#region 构造函数
public F_RPT_080117()
{
InitializeComponent();
// 窗体显示的Title
this.Text = "QC检验计划分析明细表";
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_080117 Instance
{
get
{
if (_instance == null || _instance.IsDisposed)
{
_instance = new F_RPT_080117();
}
return _instance;
}
}
#endregion
#region 事件处理
///
/// 窗体加载事件
///
///
///
private void F_RPT_080117_Load(object sender, EventArgs e)
{
try
{
// 加载权限
FormPermissionManager.FormPermissionControl(this.Name, this,
LogInUserInfo.CurrentUser.CurrentUserEntity.UserRightData,
LogInUserInfo.CurrentUser.CurrentUserEntity.FunctionData);
// 设置表格不自动创建列
this.dgvScrapTotalModule.AutoGenerateColumns = false;
this.dgvScrapTotalModuleDetail.AutoGenerateColumns = false;
// 注浆时间
this.dtpGDateStart.Value = DateTime.Now.Date;
this.dtpGDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.dtpGDateStart.Enabled = true;
this.dtpGDateEnd.Enabled = true;
//单选框原始数据
listBox1.DataSource = new List() { "A班次", "B班次", "全部" };
}
catch (Exception ex)
{
// 对异常进行共通处理
ExceptionManager.HandleEventException(this.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
}
}
///
/// 窗体关闭事件
///
///
///
private void F_RPT_080117_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.dgvScrapTotalModule.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
else
{
this.dgvScrapTotalModuleDetail.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
}
///
/// 查询按钮事件
///
///
///
private void btnSearch_Click(object sender, EventArgs e)
{
//班次
string classes = listBox1.Text == "全部" ? "" : listBox1.Text == "A班次" ? "A" : "B";
//开始时间
string startdata = dtpGDateStart.Text;
//结束时间
string enddata = dtpGDateEnd.Text;
//是否汇总
bool summary = chkSpecialRepairFlag.Checked;
try
{
if (this.tblScrapTotalModule.SelectedIndex == Constant.INT_IS_ZERO)
{
//QC检验计划分析明细汇总表
//创建查询连接
ServiceResultEntity sreByid = DoAsync(() =>
{
ClientRequestEntity cre = new ClientRequestEntity();
cre.NameSpace = "F_RPT_080117";
cre.Name = "huizhong";
cre.Properties["classes"] = classes;
cre.Properties["startdata"] = startdata;
cre.Properties["enddata"] = enddata;
cre.Properties["summary"] = summary;
return SystemModuleProxy.Service.DoRequest(cre);
});
//没有数据
if (sreByid.Data.Tables[0].Rows.Count == 0)
{
//调用弹窗提示
meaasge();
}
//清空页面数据
this.dgvScrapTotalModule.DataSource = null;
this.dgvScrapTotalModule.DataSource = sreByid.Data.Tables[0];
}
else //QC检验计划分析明细表
{
//清空页面数据
this.dgvScrapTotalModuleDetail.DataSource = null;
//调用查询
this.dgvScrapTotalModuleDetail.DataSource = GetSearchDetailData(new readdata()
{
classes = listBox1.Text == "全部" ? "" : listBox1.Text == "A班次" ? "A" : "B",
startdata = dtpGDateStart.Text,
enddata = dtpGDateEnd.Text,
});
}
}
catch (Exception ex)
{
this.btnSearch.Enabled = true;
// 对异常进行共通处理
ExceptionManager.HandleEventException(this.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
}
}
///
/// 弹窗提示
///
private void meaasge()
{ // 提示未查找到数据
MessageBox.Show("根据查询条件,没有相应的数据", this.Text,
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
///
/// 清空条件按钮事件
///
///
///
private void btnClearCondition_Click(object sender, EventArgs e)
{
this.chkSpecialRepairFlag.Checked = true;
// 注浆时间
this.dtpGDateStart.Value = DateTime.Now.Date;
this.dtpGDateEnd.Value = DateTime.Now.Date.AddDays(1).AddSeconds(-1);
this.dtpGDateStart.Enabled = true;
this.dtpGDateEnd.Enabled = true;
}
///
/// 双击单元格事件
///
///
///
private void dgvScrapTotalModule_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
//判断是否为空
if (this.dgvScrapTotalModule.CurrentRow == null)
{
return;
}
//获取数据信息
DataGridViewRow dgvr = dgvScrapTotalModule.CurrentRow;
//清空页面数据
this.dgvScrapTotalModuleDetail.DataSource = null;
//切换tab表
this.tblScrapTotalModule.SelectTab(1);
//获取条件
bool a = !string.IsNullOrEmpty(dgvr.Cells["GOODSID"].Value.ToString());
//调取查询
this.dgvScrapTotalModuleDetail.DataSource = GetSearchDetailData(new readdata()
{
GoodsID = a ==true?dgvr.Cells["GOODSID"].Value.ToString():null,
configtype = a == true?dgvr.Cells["configtype"].Value.ToString().Contains("总计") ? "" : dgvr.Cells["configtype"].Value.ToString().Contains("大件") ? "大件" : dgvr.Cells["configtype"].Value.ToString().Contains("小件") ? "小件" : "":null,
classes = listBox1.Text == "全部" ? "" : listBox1.Text == "A班次" ? "A" : "B",
startdata = dtpGDateStart.Text,
enddata = dtpGDateEnd.Text,
});
}
catch (Exception ex)
{
this.btnSearch.Enabled = true;
this.btnClearCondition.Enabled = true;
// 对异常进行共通处理
ExceptionManager.HandleEventException(this.ToString(),
System.Reflection.MethodBase.GetCurrentMethod().Name, this.Text, ex);
}
}
#endregion
#region 私有方法
///
/// 查询对象
///
public class readdata
{
///
/// 主键
///
public string GoodsID { get; set; }
///
/// 开始时间
///
public string startdata { get; set; }
///
/// 结束时间
///
public string enddata { get; set; }
///
/// 班次
///
public string classes { get; set; }
///
/// 大小件 总计
///
public string configtype { get; set; }
}
///
/// 查询QC检验计划分析明细表
///
private DataTable GetSearchDetailData(readdata ietm)
{
try
{
//创建查询连接
ServiceResultEntity sreByid = DoAsync(() =>
{
ClientRequestEntity cre = new ClientRequestEntity();
cre.NameSpace = "F_RPT_080117";
cre.Name = "mingxi";
cre.Properties["GOODSID"] = ietm.GoodsID;
cre.Properties["CLASSESTYPE"] = ietm.classes;
cre.Properties["configtype"] = ietm.configtype;
cre.Properties["startdata"] = ietm.startdata;
cre.Properties["enddata"] = ietm.enddata;
return SystemModuleProxy.Service.DoRequest(cre);
});
//没有数据时调用弹窗提示
if (sreByid.Data.Tables[0].Rows.Count == 0) { meaasge(); }
return sreByid.Data.Tables[0];
}
catch (Exception ex)
{
throw ex;
}
}
#endregion
}
}