| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300 |
- /*******************************************************************************
- * Copyright(c) 2016 DongkeSoft All rights reserved. / Confidential
- * 类的信息:
- * 1.程序名称:F_RPT_030113.cs
- * 2.功能描述:模具收发存汇总表
- * 编辑履历:
- * 作者 日期 版本 修改内容
- * 陈晓野 2017/12/26 1.00 新建
- *******************************************************************************/
- using System;
- using System.Collections.Generic;
- using System.Data;
- using System.Reflection;
- using System.Windows.Forms;
- using Dongke.IBOSS.PRD.Basics.BaseResources;
- 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
- {
- /// <summary>
- /// 模具收发存汇总表
- /// </summary>
- public partial class F_RPT_030113 : DKDockPanelBase
- {
- #region 成员变量
- private static F_RPT_030113 _instance = null;
- private ClientRequestEntity _sumCRE = null;
- #endregion
- #region 单例模式
- /// <summary>
- /// 单例模式,防止重复创建窗体
- /// </summary>
- public static F_RPT_030113 Instance
- {
- get
- {
- if (_instance == null)
- {
- _instance = new F_RPT_030113();
- }
- return _instance;
- }
- }
- #endregion
- #region 构造函数
- /// <summary>
- ///
- /// </summary>
- public F_RPT_030113()
- {
- InitializeComponent();
- this.Text = "模具收发存汇总表";
- this.tsbtnAdaptive.Text = ButtonText.TSBTN_ADAPTIVE;
- this.tsbtnClose.Text = ButtonText.TSBTN_CLOSE;
- this.dgvSum.AutoGenerateColumns = false;
- this.dgvIN.AutoGenerateColumns = false;
- this.dgvOUT.AutoGenerateColumns = false;
- }
- #endregion
- #region 控件事件
- /// <summary>
- /// 关闭
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void F_PC_1001_FormClosed(object sender, FormClosedEventArgs e)
- {
- _instance = null;
- }
- /// <summary>
- /// 画面加载
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void F_PC_1001_Load(object sender, System.EventArgs e)
- {
- try
- {
- this.dtpMonth1.Value = DateTime.Now.AddMonths(-1);
- this.dtpMonth2.Value = DateTime.Now;
- }
- catch (Exception ex)
- {
- // 对异常进行共通处理
- ExceptionManager.HandleEventException(this.ToString(),
- MethodBase.GetCurrentMethod().Name, this.Text, ex);
- }
- }
- /// <summary>
- /// 查询
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void tsbtnSearch_Click(object sender, EventArgs e)
- {
- try
- {
- this.QueryDataFromOther(this.tabControl1.SelectedIndex);
- }
- catch (Exception ex)
- {
- // 对异常进行共通处理
- ExceptionManager.HandleEventException(this.ToString(),
- MethodBase.GetCurrentMethod().Name, this.Text, ex);
- }
- }
- /// <summary>
- /// 清除条件
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void tsbtnClearCondition_Click(object sender, EventArgs e)
- {
- this.dtpMonth1.Value = DateTime.Now.AddMonths(-1);
- this.dtpMonth2.Value = DateTime.Now;
- this.scbGoods.ClearValue();
- this.scbGoodsType.ClearValue();
- }
- /// <summary>
- /// 自适应列宽
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void tsbtnAdaptive_Click(object sender, EventArgs e)
- {
- this.dgvSum.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
- this.dgvIN.AutoResizeColumns();
- this.dgvOUT.AutoResizeColumns();
- }
- /// <summary>
- /// 关闭画面
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void tsbtnClose_Click(object sender, EventArgs e)
- {
- this.Close();
- }
- /// <summary>
- /// 入出库明细
- /// </summary>
- /// <param name="sender"></param>
- /// <param name="e"></param>
- private void dgvSum_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
- {
- if (e.ColumnIndex < 0 || e.RowIndex < 0)
- {
- return;
- }
- try
- {
- string colName = this.dgvSum.Columns[e.ColumnIndex].Name;
- if (colName == "MI_1")
- {
- this.QueryDataFromOther(-1);
- this.tabControl1.SelectedIndex = 1;
- }
- else if (colName == "MO_1")
- {
- this.QueryDataFromOther(-2);
- this.tabControl1.SelectedIndex = 2;
- }
- }
- catch (Exception ex)
- {
- // 对异常进行共通处理
- ExceptionManager.HandleEventException(this.ToString(),
- MethodBase.GetCurrentMethod().Name, this.Text, ex);
- }
- }
- #endregion
- #region 私有方法
- /// <summary>
- /// 查询数据
- /// </summary>
- /// <param name="type">-2:Grid双击(出);-1:Grid双击(入);0:总单;1:入库;2:出库</param>
- private void QueryDataFromOther(int type)
- {
- try
- {
- this.tsrToolStrip1.Focus();
- ClientRequestEntity cre = new ClientRequestEntity();
- cre.NameSpace = "R03";
- cre.Name = "R030113";
- if (type < 0 && (this._sumCRE == null || this.dgvSum.CurrentCell == null))
- {
- type = 0;
- }
- if (type < 0)
- {
- DataRowView drv = this.dgvSum.CurrentRow.DataBoundItem as DataRowView;
- cre.Properties["YYYYMM"] = this._sumCRE.Properties["YYYYMM"];
- cre.Properties["DateBegin"] = this._sumCRE.Properties["DateBegin"];
- cre.Properties["DateEnd"] = this._sumCRE.Properties["DateEnd"];
- if (drv["GoodsID"] != DBNull.Value)
- {
- cre.Properties["GoodsID"] = drv["GoodsID"];
- }
- else if (this._sumCRE.Properties["GoodsID"] != null)
- {
- cre.Properties["GoodsID"] = this._sumCRE.Properties["GoodsID"];
- }
- else if (this._sumCRE.Properties["GoodsIDs"] != null)
- {
- cre.Properties["GoodsIDs"] = this._sumCRE.Properties["GoodsIDs"];
- }
- if (drv["GoodsTypeCode"] != DBNull.Value)
- {
- cre.Properties["GoodsTypeCode"] = drv["GoodsTypeCode"];
- }
- else
- {
- cre.Properties["GoodsTypeCode"] = this._sumCRE.Properties["GoodsTypeCode"];
- }
- cre.Properties["Type"] = 0 - type;
- }
- else
- {
- cre.Properties["YYYYMM"] = this.dtpMonth1.Value.Value.AddMonths(-1).ToString("yyyyMM");
- cre.Properties["DateBegin"] = this.dtpMonth1.Value.Value;
- cre.Properties["DateEnd"] = this.dtpMonth2.Value.Value.AddMonths(1);
- cre.Properties["GoodsTypeCode"] = scbGoodsType.SearchedValue + "";
- if (!string.IsNullOrWhiteSpace(this.scbGoods.Text))
- {
- if (this.scbGoods.CheckedPKMember.Contains(","))
- {
- cre.Properties["GoodsIDs"] = scbGoods.CheckedPKMember;
- }
- else
- {
- cre.Properties["GoodsID"] = scbGoods.SearchedPKMember;
- }
- }
- cre.Properties["Type"] = type;
- }
- if (type == 0)
- {
- this.dgvSum.DataSource = null;
- this._sumCRE = cre;
- }
- else if (type == 1 || type == -1)
- {
- this.dgvIN.DataSource = null;
- }
- else
- {
- this.dgvOUT.DataSource = null;
- }
- ServiceResultEntity sre = DoAsync<ServiceResultEntity>(() =>
- {
- return ReportModuleProxy.Service.DoRequest(cre);
- }
- );
- if (sre.Status == Constant.ServiceResultStatus.Success)
- {
- // 查询成功
- if (type == 0)
- {
- this.dgvSum.DataSource = sre.Data.Tables[0];
- }
- else if (type == 1 || type == -1)
- {
- this.dgvIN.DataSource = sre.Data.Tables[0];
- }
- else
- {
- this.dgvOUT.DataSource = sre.Data.Tables[0];
- }
- }
- }
- catch (Exception ex)
- {
- throw ex;
- }
- }
- #endregion
- }
- }
|