using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using Core.StlMes.Client.YdmPipeManage.Tool; using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Tool; using CoreFS.CA06; using Core.Mes.Client.Comm.Server; using Infragistics.Win.UltraWinGrid; namespace Core.StlMes.Client.YdmPipeReport { public partial class FrmOutBoundSum : FrmBase { private string[] _salgPermissions; public FrmOutBoundSum() { InitializeComponent(); } private void FrmOutBoundSum_Load(object sender, EventArgs e) { DateTime now = DateTime.Now; DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天 DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天 StartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00"); EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59"); BaseMethod.InitMonth(cmbMonth); BaseMethod.InitYear(cmbYear); cmbMonth.Value = string.Format("{0:00}", DateTime.Now.Month); cmbYear.Value = DateTime.Now.Year.ToString(); _salgPermissions = BaseMethod.InitPermissions(this.ValidDataPurviewIds, ob); } /// /// 重写基类方法 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": doQuery(); break; case "Export"://导出 GridHelper.ulGridToExcel(ultraGrid1, "出库明细汇总表"); break; case "Close": this.Close(); break; } } private void doQuery() { if (!ValidQuery()) return; string strStartTime = "";//开始时间 string strEntTime = "";//结束时间 string beginTime = ""; string order = ""; string juNo = ""; string supplyUnit = this.CustomInfo; if (ChcTime.Checked) { beginTime = cmbYear.Text.Trim() + cmbMonth.Text.Trim(); } if (chkJudge.Checked) { juNo = cmbJudge.Text.Trim(); } if (chkOrder.Checked) { order = cmbOrder.Text.Trim(); } if (ultraCheckEditor5.Checked) { strStartTime = StartTime.Value.ToString(); strEntTime = EndTime.Value.ToString(); } DataTable dt = ServerHelper.GetData("com.steering.pss.ydm.Report.FrmOutBoundSum.getGpDataB", new object[] { strStartTime, strEntTime, beginTime, juNo, order, _salgPermissions , supplyUnit }, ob); GridHelper.CopyDataToDatatable(dt, this.dataTable1, true); //UltraGridColumn[] col = new UltraGridColumn[] { ultraGrid1.DisplayLayout.Bands[0].Columns["MATERIAL_NAME"], ultraGrid1.DisplayLayout.Bands[0].Columns["STD_NAME"] }; //GridHelper.RefreshAndAutoSizeExceptColumns(ultraGrid1, col); } private void ultraCheckEditor5_CheckedChanged(object sender, EventArgs e) { if (ultraCheckEditor5.Checked) { StartTime.Enabled = true; EndTime.Enabled = true; } else { StartTime.Enabled = false; EndTime.Enabled = false; } if (ChcTime.Checked) { cmbYear.Enabled = true; cmbMonth.Enabled = true; } else { cmbYear.Enabled = false; cmbMonth.Enabled = false; } if (chkOrder.Checked) { cmbOrder.Enabled = true; } else { cmbOrder.Enabled = false; } if (chkJudge.Checked) { cmbJudge.Enabled = true; } else { cmbJudge.Enabled = false; } } /// /// 查询时验证必填项 /// /// private bool ValidQuery() { if (ultraCheckEditor5.Checked) { if (DataTimeUtil.JudgeTime(DateTime.Parse(StartTime.Value.ToString()), DateTime.Parse(EndTime.Value.ToString())) == 0) { MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择!"); return false; } } if (chkOrder.Checked && string.IsNullOrEmpty(cmbOrder.Text.Trim())) { MessageBox.Show("请输入合同号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } if (chkJudge.Checked && string.IsNullOrEmpty(cmbJudge.Text.Trim())) { MessageBox.Show("请输入炉号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); return false; } return true; } } }