using Core.StlMes.Client.GlBusiness.Dialog; using CoreFS.CA06; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using System.Collections; using Core.Mes.Client.Comm.Tool; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Control; using Infragistics.Win.UltraWinGrid; namespace Core.StlMes.Client.GlBusiness { public partial class orderManage : FrmBase { public orderManage() { InitializeComponent(); } private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e) { switch (e.Tool.Key) { case "Query": doQuery(); break; case "doConfirm": doConfirm(); break; case "Close": this.Close(); break; } } private string setCreateTimeStart(Object value) { DateTime time = Convert.ToDateTime(value); DateTime endtime = new DateTime(time.Year, time.Month, time.Day, 0, 0, 0); endtime.ToLongTimeString(); return endtime.ToString(); } private string setCreateTimeEnd(Object value) { DateTime time = Convert.ToDateTime(value); DateTime endtime = new DateTime(time.Year, time.Month, time.Day, 23, 59, 59); return endtime.ToString(); } private void doQuery() { this.orderHead.Clear(); ArrayList parm = new ArrayList(); if (uchkOrderNo.Checked == true) { parm.Add(utxtOrderNo.Text.Trim()); } if (uchkDate.Checked == true) { if (QcreateTime_Begin.Value != null)//创建开始时间 { parm.Add(setCreateTimeStart(QcreateTime_Begin.Value)); } if (QcreateTime_End.Value != null)//创建结束时间 { parm.Add(setCreateTimeEnd(QcreateTime_End.Value)); } } DataTable dt = ServerHelper.GetData("com.steering.pss.glbusiness.SlmGlAccrued.doQueryOrderHead", new Object[] { parm }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref this.orderHead, true); } private void doConfirm() { try { if (ultraGrid1.ActiveRow == null) { MessageUtil.ShowTips("请选择需要增加的数据!"); return; } if (MessageUtil.ShowYesNoAndQuestion("是否确定添加?") == DialogResult.No) { return; } ArrayList all = new ArrayList(); all.Add("BLyyyyMMdd00001");//结算单号 all.Add(ultraGrid1.ActiveRow.Cells["ORDER_NO"].Value.ToString());//合同号 all.Add(ultraGrid1.ActiveRow.Cells["ORDER_TYP"].Value.ToString());//合同类型编码 all.Add(ultraGrid1.ActiveRow.Cells["ORDER_TYP_DESC"].Value.ToString());//合同类型 if (ultraGrid1.ActiveRow.Cells["TRADE_TYPE"].Value.ToString().Equals("122301")) { all.Add("123401");//结算类型编码 all.Add("应收");//结算类型 } else if(ultraGrid1.ActiveRow.Cells["TRADE_TYPE"].Value.ToString().Equals("122302")){ all.Add("123402");//结算类型编码 all.Add("应付");//结算类型 } all.Add("123301");//费用类型编码 all.Add("货款");//费用类型 all.Add("0");//支付状态 //all.Add();//票据号 all.Add(ultraGrid1.ActiveRow.Cells["CUSTOMER_NO"].Value.ToString());//订货单位编码 all.Add(ultraGrid1.ActiveRow.Cells["CUSTOMER_NM"].Value.ToString());//订货单位 all.Add(ultraGrid1.ActiveRow.Cells["SUPPLY_UNIT"].Value.ToString());//供货单位(制造商) all.Add(ultraGrid1.ActiveRow.Cells["STLMT_UNIT_NO"].Value.ToString());//结算单位编码 all.Add(ultraGrid1.ActiveRow.Cells["STLMT_UNIT_NM"].Value.ToString());//结算单位 all.Add(ultraGrid1.ActiveRow.Cells["SIGN_DATE"].Value.ToString());//签订日期 all.Add(ultraGrid1.ActiveRow.Cells["ORDER_YEAR"].Value.ToString());//合同年度 all.Add(ultraGrid1.ActiveRow.Cells["MEMO"].Value.ToString());//备注 all.Add("1");//数据状态 all.Add(UserInfo.GetUserName()); all.Add(UserInfo.GetDepartment()); double price = 0; double sumPrice = 0; foreach (UltraGridRow ugr in ultraGrid2.Rows) { Double.TryParse(ugr.Cells["BALNCE_TOL_PRICE"].Value.ToString().Trim(), out price); sumPrice += price; } all.Add(sumPrice);//结算总金额 //all.Add();//多发票号 CoreClientParam ccp = new CoreClientParam(); ccp.ServerName = "com.steering.pss.glbusiness.SlmGlAccrued"; ccp.MethodName = "addBalance"; ccp.ServerParams = new object[] { all }; ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode == -1) return; MessageBox.Show("增加成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning); this.Close(); } catch (System.Exception ex) { MessageUtil.ShowTips("操作失败:" + ex.Message); } } private void uchkOrderNo_CheckedChanged(object sender, EventArgs e) { if (uchkOrderNo.Checked == true) { utxtOrderNo.ReadOnly = false; } else { utxtOrderNo.ReadOnly = true; } } private void uchkDate_CheckedChanged(object sender, EventArgs e) { if (uchkDate.Checked == true) { QcreateTime_Begin.ReadOnly = false; QcreateTime_End.ReadOnly = false; } else { QcreateTime_Begin.ReadOnly = true; QcreateTime_End.ReadOnly = true; } } private void orderManage_Load(object sender, EventArgs e) { QcreateTime_Begin.Value = DateTime.Now.AddDays(-7); QcreateTime_End.Value = DateTime.Now; GridHelper.SetAllColumnsActive(ultraGrid1); GridHelper.SetAllColumnsActive(ultraGrid2); } private void ultraGrid1_AfterRowActivate(object sender, EventArgs e) { this.orderLine.Clear(); ArrayList parm = new ArrayList(); parm.Add(ultraGrid1.ActiveRow.Cells["ORD_PK"].Value.ToString()); DataTable dt = ServerHelper.GetData("com.steering.pss.glbusiness.SlmGlAccrued.doQueryOrderLine", new Object[] { parm }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref this.orderLine, true); } } }