using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Format; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.PnCost.Models; using CoreFS.CA06; using Infragistics.Win.UltraWinGrid; 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; namespace Core.StlMes.Client.PnCost { public partial class frmBaseProcessBzcost : FrmBase { #region 定义变量 public frmBaseProcessBzcost() { InitializeComponent(); } private DataTable dtpline; #endregion #region 初始化 private void frmBaseProcesscost_Load(object sender, EventArgs e) { this.ultraGrid1.DisplayLayout.Bands[0].Columns["ORD_NO"].MergedCellStyle = MergedCellStyle.Always; Query(); } #endregion #region 方法 public override void ToolBar_Click(object sender, string ToolbarKey) { base.ToolBar_Click(sender, ToolbarKey); switch (ToolbarKey) { case "Query": Query(); break; case "doCs": doCS(); break; case "Calculate": Calculate(); break; case "doSee": DoSee(); break; case "Export": GridHelper.ulGridToExcel(ultraGrid1, "钢级信息"); break; case "Close": this.Close(); break; } } /// 查询方法 /// /// 查询方法 /// private void Query() { //eginDate.ToString("yyyyMMdd") #region 条件验证 string httext = this.htText.Text.Trim(); string startTime = this.dateTimePicker1.Value.ToString("yyyyMMdd"); string endTime = this.dateTimePicker2.Value.ToString("yyyyMMdd"); string askplanIdText = this.askplanIdText.Text.Trim(); #endregion DataTable data = ServerHelper.GetData("com.steering.mes.cost.FrmBalance.Query", new object[] { httext, startTime, endTime, askplanIdText,this.CustomInfo }, ob); dataTable1.Clear(); GridHelper.CopyDataToDatatable(data, dataTable1, true); if (ultraGrid1.Rows.Count == 0) { return; } ultraGrid1.UpdateData(); ultraGrid1.ActiveRow = ultraGrid1.Rows[0]; } private void Calculate() { try { ultraGrid1.UpdateData(); UltraGridRow row = ultraGrid1.ActiveRow; if (row == null) return; string tiaoshu = ""; if(this.ultraCheckEditor1.Checked && this.comboBox1.Text != ""){ tiaoshu = this.comboBox1.Text; } if (tiaoshu == null && tiaoshu.Equals("")) { MessageUtil.ShowError("请选择测算的条数"); } ServerHelper.SetData("com.steering.mes.cost.FrmBalance.CalculateAll", new object[] { this.UserInfo.GetUserName(), tiaoshu,this.CustomInfo }, ob); } catch (Exception ex) { MessageUtil.ShowError("测算失败" + ex.Message + "'"); return; } MessageUtil.ShowTips("测算成功!"); Query(); } /// 保存方法 /// /// 保存方法 /// private void doCS() { try { ultraGrid1.UpdateData(); UltraGridRow row = ultraGrid1.ActiveRow; if (row == null) return; foreach (UltraGridRow item in ultraGrid1.Rows) { if (Convert.ToBoolean(item.Cells["CHECK"].Text) == true) { string ordNo = item.Cells["ORD_NO"].Value.ToString().Trim(); string ordSeq = item.Cells["ORD_SEQ"].Value.ToString().Trim(); string spetkey = item.Cells["SPETKEY"].Value.ToString().Trim(); string steelName = item.Cells["STEELNAME"].Value.ToString().Trim(); string askplanId = item.Cells["ASKPLAN_ID"].Value.ToString().Trim(); string kx = item.Cells["MODEL_DESC"].Value.ToString().Trim(); string waijin = item.Cells["WAIJIN"].Value.ToString().Trim(); string bihou = item.Cells["BIHOU"].Value.ToString().Trim(); string stoveNo = item.Cells["STOVE_NO"].Value.ToString().Trim(); string id = item.Cells["ID"].Value.ToString().Trim(); string money = item.Cells["MONEY"].Value.ToString().Trim(); string userName = this.UserInfo.GetUserName(); ServerHelper.SetData("com.steering.mes.cost.FrmBalance.Calculate", new object[] { ordNo, ordSeq, userName, steelName, spetkey, askplanId, kx, waijin, bihou, stoveNo, id,this.CustomInfo,money }, ob); } } } catch (Exception ex) { MessageUtil.ShowError("测算失败" + ex.Message + "'"); return; } MessageUtil.ShowTips("测算成功!"); Query(); } /// 删除方法 /// /// 删除方法 /// private void DoSee() { this.ultraGrid1.UpdateData(); IQueryable checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHECK = 'True'"); if (checkMagRows.Count() > 1) { MessageUtil.ShowTips("选择的条数有误!"); return; } string strurl = ""; foreach (UltraGridRow uRow in checkMagRows) { string processCode = uRow.Cells["PROCESS_CODE"].Value.ToString(); strurl = "http://172.16.2.137:8081/webroot/decision/view/report?viewlet=tqnqd06bz.cpt" + "&processCode=" + processCode; //+ "&BILL_NO=" + BillNo + "&NAME=" + this.UserInfo.GetUserName(); FrmRepExcel fBug = new FrmRepExcel(ob, strurl); fBug.AutoSize = true; fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height); fBug.WindowState = FormWindowState.Maximized; fBug.Text = "标准成本测算"; fBug.Show(); } } private void ultraCheckEditor1_CheckedChanged(object sender, EventArgs e) { comboBox1.Enabled = this.ultraCheckEditor1.Checked; } } #endregion }