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 CoreFS.CA06; using System.Collections; using Core.Mes.Client.Comm.Tool; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Control; using Core.StlMes.Client.ZGMil.Entity; using Core.StlMes.Client.ZGMil.Signature; using Core.StlMes.Client.ZGMil.ResultConrtrol; using Core.StlMes.Client.ZGMil.Common; using Infragistics.Win.UltraWinGrid; using com.steering.mes.zgmil.entity; using Core.Mes.Client.Comm.Format; namespace Core.StlMes.Client.ZGMil.Report { public partial class FrmStraighten : FrmBase { private string departm = ""; private string plineCode = ""; private string[] plineCodes = { }; public FrmStraighten() { InitializeComponent(); this.IsLoadUserView = true; } private void FrmStraighten_Load(object sender, EventArgs e) { cmbDate.Value = DateTime.Parse(DateTime.Today.ToString()); NativeMethodNew na = new NativeMethodNew(this.ob); departm = UserInfo.GetDepartment(); plineCode = na.GetPCode(departm);//获取 用户 对应的产线 plineCodes = BaseMethod.GetPlineCode(ValidDataPurviewIds, ob); cmbEndDate.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 20:59:59")); cmbDate.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 21:00:00")); TubeRoll.SetComboItemHeight(cmbBc); TubeRoll.SetComboItemHeight(cmbBz); } /// /// 重写基类方法 /// /// /// public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "Query": doQuery(); break; case "Save": doSave(); break; case "Export": doExport(); break; case "DoExport": doExport2(); break; case "Close": this.Close(); break; } } private void chkDate_CheckedChanged(object sender, EventArgs e) { if (chkDate.Checked) { cmbDate.Enabled = true; } else { cmbDate.Enabled = false; } if (chkBc.Checked) { cmbBc.Enabled = true; } else { cmbBc.Enabled = false; } if (chkBz.Checked) { cmbBz.Enabled = true; } else { cmbBz.Enabled = false; } if (chkJudgeStoveNo.Checked) { uteJudgeStoveNo.Enabled = true; } else { uteJudgeStoveNo.Enabled = false; } } private void doQuery() { ArrayList list = new ArrayList(); string date = ""; string endDate = ""; string bc = ""; string bz = ""; string JudgeStoveNo = ""; if (chkDate.Checked) { if (DataTimeUtil.JudgeTime(DateTime.Parse(cmbDate.Value.ToString()), DateTime.Parse(cmbEndDate.Value.ToString())) == 0) { MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择!"); return; } else { date = cmbDate.Value.ToString(); endDate = cmbEndDate.Value.ToString(); } } if (chkBz.Checked) { if (cmbBz.Text.Trim() == "") { // MessageUtil.ShowTips("班组不能为空!"); // return; bz = ""; } else { bz = cmbBz.Value.ToString(); } } if (chkBc.Checked) { if (cmbBc.Text.Trim() == "") { //MessageUtil.ShowTips("班次不能为空!"); //return; bc = ""; } else { bc = cmbBc.Value.ToString(); } } if (chkJudgeStoveNo.Checked) { if (uteJudgeStoveNo.Text.Trim() == "") { JudgeStoveNo = ""; } else { JudgeStoveNo = uteJudgeStoveNo.Value.ToString(); } } DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.report.FrmStraighten.queryMinResult", new Object[] { date, endDate, bc, bz,JudgeStoveNo, plineCodes }, this.ob); GridHelper.CopyDataToDatatable(dt, this.dataTable1, true); GridHelper.RefreshAndAutoSize(this.ultraGrid1); } /// /// 修改 /// private void doSave() { this.ultraGrid1.UpdateData(); IQueryable checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'"); if (checkMagRows.Count() == 0) { MessageUtil.ShowTips("请选择需要修改的信息!"); return; } ArrayList parm = new ArrayList(); foreach (UltraGridRow uRow in checkMagRows) { FeedSawResultEntity matZcTity = new FeedSawResultEntity(); matZcTity.JudgeStoveNo = uRow.Cells["JUDGE_STOVE_NO"].Text.ToString(); matZcTity.PlineCode = uRow.Cells["PLINE_CODE"].Text.ToString(); if (uRow.Cells["COL_SHIFT"].Value.ToString().Equals("早班")) { matZcTity.ColShift = "1"; } else if (uRow.Cells["COL_SHIFT"].Value.ToString().Equals("中班")) { matZcTity.ColShift = "2"; } else if (uRow.Cells["COL_SHIFT"].Value.ToString().Equals("夜班")) { matZcTity.ColShift = "3"; } else if (uRow.Cells["COL_SHIFT"].Value.ToString().Equals("常白班")) { matZcTity.ColShift = "0"; } else { matZcTity.ColShift = uRow.Cells["COL_SHIFT"].Value.ToString(); } if (uRow.Cells["COL_GROUP"].Value.ToString().Equals("甲")) { matZcTity.ColGroup = "1"; } else if (uRow.Cells["COL_GROUP"].Value.ToString().Equals("乙")) { matZcTity.ColGroup = "2"; } else if (uRow.Cells["COL_GROUP"].Value.ToString().Equals("丙")) { matZcTity.ColGroup = "3"; } else if (uRow.Cells["COL_GROUP"].Value.ToString().Equals("丁")) { matZcTity.ColGroup = "4"; } else { matZcTity.ColGroup = uRow.Cells["COL_GROUP"].Value.ToString(); } matZcTity.StartTime = uRow.Cells["START_TIME"].Text.ToString(); matZcTity.ColUser = uRow.Cells["COL_USER"].Text.ToString(); matZcTity.Remark = "矫直"; string matTity = JSONFormat.Format(matZcTity); parm.Add(matTity); } if (MessageUtil.ShowYesNoAndQuestion("是否确认修改?") == DialogResult.No) return; CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.zgmil.report.FrmFeedSaw"; ccp.MethodName = "doSave"; ccp.ServerParams = new object[] { parm }; ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { if (ccp.ReturnInfo.Equals("修改成功!")) { doQuery(); MessageUtil.ShowTips(ccp.ReturnInfo); } else { MessageUtil.ShowTips(ccp.ReturnInfo); } } } /// /// 导出 /// private void doExport2() { GridHelper.ulGridToExcel(ultraGrid1, "矫直台账"); } /// /// 打印 /// private void doExport() { string date = ""; string endDate = ""; string bc = ""; string bz = ""; string judgeStoveNo = ""; //if (!chkDate.Checked) //{ // MessageUtil.ShowTips("请选择生产日期!"); // return; //} if (!chkBz.Checked) { MessageUtil.ShowTips("请选择班组!"); return; } if (!chkBc.Checked) { MessageUtil.ShowTips("请选择班次!"); return; } if (chkDate.Checked) { if (DataTimeUtil.JudgeTime(DateTime.Parse(cmbDate.Value.ToString()), DateTime.Parse(cmbEndDate.Value.ToString())) == 0) { MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择!"); return; } else { date = cmbDate.Value.ToString(); endDate = cmbEndDate.Value.ToString(); } } if (chkBz.Checked) { if (cmbBz.Text.Trim() == "") { //MessageUtil.ShowTips("班组不能为空!"); //return; bz=""; } else { bz = cmbBz.Value.ToString(); } } if (chkBc.Checked) { if (cmbBc.Text.Trim() == "") { //MessageUtil.ShowTips("班次不能为空!"); //return; bc = ""; } else { bc = cmbBc.Value.ToString(); } } if (chkJudgeStoveNo.Checked && uteJudgeStoveNo.Text != "") { judgeStoveNo = uteJudgeStoveNo.Text; } doQuery(); ColUserName colU = new ColUserName(); colU.Ob = this.ob; colU.PlineCode = plineCode; colU.ColGroup = bz; colU.ColOrder = bc; colU.JudgeStoveNo = judgeStoveNo; colU.StationId = "7"; if (plineCode.Equals("C017")) { colU.Url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult460.cpt&format=pdf&__bypagesize__=false"; } else if (plineCode.Equals("C010")) { colU.Url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult168.cpt&format=pdf&__bypagesize__=false"; } else if (plineCode.Equals("C009")) { colU.Url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult258.cpt&format=pdf&__bypagesize__=false"; } else if (plineCode.Equals("C008")) { colU.Url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult250.cpt&format=pdf&__bypagesize__=false"; } else if (plineCode.Equals("C072")) { colU.Url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult508.cpt&__bypagesize__=false"; } //colU.Url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult.cpt&format=pdf&__bypagesize__=false"; colU.StartTim = date; colU.EndTim = endDate; colU.StrText = "矫直报表"; colU.Flag = "0"; colU.ShowDialog(); //string url = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult.cpt&__bypagesize__=false&SHIFT=" + bc + "&GROUP=" + bz + "&DATE=" + date + "&DATE2=" + endDate + "&PLINECODE=" + plineCode; //FrmRepExcel fre = new FrmRepExcel(this.ob,url); ////fre.AutoSize = true; //fre.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); //fre.Text = "管排锯台账"; //fre.ShowDialog(); } } }