/******************************************************************************* * 类的信息: * 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 } }