using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Threading; using System.Collections; using System.Reflection; using CoreFS.CA06; namespace Core.StlMes.Client.Sale.UI.Balance.BalanceDetail { public partial class FrmBalanceDetailAccept : Core.StlMes.Client.Sale.Common.FrmStyleBase.FrmUIBase { DataSet dsMain = new DataSet(); Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Trans.YdmZcLoadVehicleMatMgt ydmZcLoadVehicleMatMgt = null; public FrmBalanceDetailAccept() { InitializeComponent(); } private void FrmBalanceDetailAccept_Load(object sender, EventArgs e) { this.checkBox1.Checked = true; ydmZcLoadVehicleMatMgt = new Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Trans.YdmZcLoadVehicleMatMgt(this.ob); dsMain = base.GetDataSetByColumnName(this.GetGrid1DataStructTg(), new Hashtable(), this.GetColumnAndCaption()); this.ultraGrid1.DataSource = dsMain; HidenColumn(); base.SetGridStyle(ref this.ultraGrid1); } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case ToolbarKey_Query: { if (this.checkBox1.Checked) this.Query(); else this.QueryVirtual(); break; } case "Accept": { this.Accept(); break; } case ToolbarKey_Close: { this.Close(); break; } } } private void Query() { // this.dsMain.Clear(); dsMain = base.GetDataSetByColumnName(this.GetGrid1DataStructTg(), new Hashtable(), this.GetColumnAndCaption()); this.ultraGrid1.DataSource = this.dsMain; HidenColumn(); base.SetGridStyle(ref this.ultraGrid1); // 获取所有关闭的提单 DataSet ds = this.ydmZcLoadVehicleMatMgt.GetCanAcceptMatInfo(); // 如果有查询条件，在原有记录中模糊查找 if (this.textBox7.Text.Length > 0) ds = Util.UtilDataSet.GetDataSetWithRowFilterWithApproximateMatch(ds, this._BILL_NO, this.textBox7.Text.Trim()); // 分组数据显示 ds = Util.UtilDataSet.GetDateSetByGroupColumnAndStaticsColumnName(ds, this.GetGroupByName(), this.GetShowName(), this.GetStaticsName()); // 填充数据到数据源显示 Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref dsMain,ds); SetRoudWgt(); } private void HidenColumn() { try { foreach (string s in GetHideName()) { this.ultraGrid1.DisplayLayout.Bands[0].Columns[s].Hidden = true; } } catch { } } private void SetRoudWgt() { try { foreach (DataRow dr in dsMain.Tables[0].Rows) { dr[_ACT_WEIGHT] = Math.Round(Convert.ToDouble(dr[_ACT_WEIGHT]), 4); } } catch { } } private void QueryVirtual() { DataSet dsShow = base.GetDataSetByColumnName(this.GetGrid1DataStructTgVirtualBillno(), new Hashtable(), this.GetColumnAndCaption()); // 获取所有关闭的提单 DataSet ds = this.ydmZcLoadVehicleMatMgt.GetUnAcceptVirtulYdmZcBillM(); // 如果有查询条件，在原有记录中模糊查找 if (this.textBox7.Text.Length > 0) ds = Util.UtilDataSet.GetDataSetWithRowFilterWithApproximateMatch(ds, this._BILL_NO, this.textBox7.Text.Trim()); // 填充数据到数据源显示 Util.UtilDataSet.SetDataSetByMergeSameColumnName(ref dsShow, ds); this.ultraGrid1.DataSource = dsShow; } private void Accept() { if (this.ultraGrid1.Rows.Count == 0) return; if (this.ultraGrid1.Rows.Count == 1) this.ultraGrid1.Rows[0].Selected = true; // this.ultraGrid1.ActiveRow.Selected = true; ArrayList listBillNo = new ArrayList(); string billNo = ""; if (this.ultraGrid1.Selected.Rows.Count == 0) { Core.StlMes.Client.Sale.Util.MessageUtil.ShowError("请选择需要接收的行"); return; } foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugr in this.ultraGrid1.Selected.Rows) { billNo = ugr.Cells[_BILL_NO].Value.ToString(); if (!listBillNo.Contains(billNo)) { listBillNo.Add(billNo); } } string errMsg = ""; foreach (string s in listBillNo) { this.ydmZcLoadVehicleMatMgt.AcceptSignle(s,out errMsg); if (errMsg.Length > 0) { return; } else { DataRow[] drs = this.dsMain.Tables[0].Select(string.Format(" BILL_NO = '{0}' ",s)); foreach (DataRow dr in drs) { this.dsMain.Tables[0].Rows.Remove(dr); } } } Core.StlMes.Client.Sale.Util.MessageUtil.ShowTips("操作成功"); if (this.checkBox1.Checked) this.Query(); else this.QueryVirtual(); } private string[] GetKeys() { try { return base.QueryStrings; } catch { return new string[] { }; } } private string[] GetGrid1DataStructTg() { return new string[] { this._BILL_NO, // this._BILL_NO_XH, this._ORDER_NO, this._ORDER_SEQ, this._ORDER_SEQ_NO, this._ACT_COUNT, this._ACT_WEIGHT, _ACT_THEORY_WEIGHT, this._STEELNAME, this._GRADENAME, this._STD_STYLE_DESC, this._SPEC_NAME, this._MODEL_DESC, this._PLINE_NAME, this._ACT_DIMATER, this._ACT_HEIGHT // this._ACT_LEN }; } private string[] GetGrid1DataStructTgVirtualBillno() { return new string[] { this._BILL_NO, // this._BILL_NO_XH, this._ORDER_NO, this._ORDER_SEQ, "DELIVERY_NO", "PLAN_WT", "PLAN_NUM", "SPEC_NAME", "STATION_NM", "SPCL_LN_NM", "SALE_ORG_DESC", "CUSTOMER_NM", "RECEIV_NM", "STEELNAME", "MEMO" }; } private List GetGroupByName() { List list = new List(); list.Add(_BILL_NO); // list.Add(_BILL_NO_XH); list.Add(_ORDER_NO); list.Add(_ORDER_SEQ); list.Add(_ORDER_SEQ_NO); return list; } private List GetStaticsName() { List list = new List(); list.Add(this._ACT_COUNT); list.Add(this._ACT_WEIGHT); list.Add(_ACT_THEORY_WEIGHT); return list; } private List GetShowName() { List list = new List(GetGrid1DataStructTg()); return list; } private List GetHideName() { List list = new List(new string[]{ this._GRADENAME, this._STD_STYLE_DESC, this._SPEC_NAME,_PLINE_NAME}); return list; } private string[] GetGrid1DataStruct() { return new string[] { "ASKPLAN_ID", "TRANSTYPE", "PICKSTORAGETIME", "QUANTITY", "WEIGHT", "TRAINWAGON", "SHIPNO", "BUYERCODE", "STATIONCODE", "INCEPTCORPCODE", "ACCEPT_STATUS" } ; } private string[] GetGrid2DataStruct() { return new string[] { "SERIALNUMBER", "ORDERNO", "PLY", "WIDTH", "LENGTH", "WEIGHT", "STEELCODE", "STOVENO", } ; } private Hashtable GetColumnAndCaption() { if (GetKeys().Length > 0) { if (this.GetKeys()[0] == "0") return GetColumnAndCaptionForSlab(); else return GetColumnAndCaptionForTube(); } return GetColumnAndCaptionForTube(); } /// /// 钢管重命名 /// /// private Hashtable GetColumnAndCaptionForTube() { Hashtable hs = new Hashtable(); hs.Add("QUANTITY", "支数"); hs.Add("WEIGHT", "重量"); hs.Add("SHIPNO", "船号"); hs.Add("PLY", "壁厚"); hs.Add("WIDTH", "外径"); hs.Add("ACCEPT_STATUS", "接收结果"); hs.Add("SERIALNUMBER", "序号"); hs.Add(_BILL_NO, "提单号"); hs.Add(_BILL_NO_XH, "序号"); hs.Add(_ORDER_NO, "合同号"); hs.Add(_ORDER_SEQ, "行号"); hs.Add(_ORDER_SEQ_NO, "交货行"); hs.Add(_ACT_COUNT, "支数"); hs.Add(_ACT_WEIGHT, "重量"); hs.Add(_ACT_THEORY_WEIGHT, "理论重量"); hs.Add(_STEELNAME, "钢级(牌号)"); hs.Add(_GRADENAME, "钢种名称"); hs.Add(_STD_STYLE_DESC, "标准类别"); hs.Add(_SPEC_NAME, "产品规格"); hs.Add(_MODEL_DESC, "扣型"); hs.Add(_PLINE_NAME, "产线"); hs.Add(_ACT_DIMATER, "外径"); hs.Add(_ACT_HEIGHT, "壁厚"); hs.Add(_ACT_LEN, "长度"); hs.Add("STATION_NM", "到站"); hs.Add("SPCL_LN_NM", "专用线"); hs.Add("SALE_ORG_DESC", "销售组织"); hs.Add("CUSTOMER_NM", "订货单位"); hs.Add("RECEIV_NM", "收货单位"); hs.Add("PLAN_NUM", "支数"); hs.Add("PLAN_WT", "重量"); hs.Add("MEMO", "备注"); hs.Add("DELIVERY_NO", "交货行"); return hs; } /// /// 其他 /// /// private Hashtable GetColumnAndCaptionForSlab() { Hashtable hs = new Hashtable(); hs.Add("QUANTITY", "支数"); hs.Add("WEIGHT", "重量"); hs.Add("SHIPNO", "船号"); hs.Add("ACCEPT_STATUS", "接收结果"); hs.Add("SERIALNUMBER", "序号"); return hs; } protected override Hashtable GetGridColumnLength() { Hashtable hs = new Hashtable(); hs.Add("SHIPNO",80); hs.Add(_BILL_NO, 120); hs.Add(_BILL_NO_XH, 80); hs.Add(_ORDER_NO, 100); hs.Add(_ORDER_SEQ, 60); hs.Add(_ORDER_SEQ_NO, 60); hs.Add(_ACT_COUNT, 60); hs.Add(_ACT_WEIGHT, 60); hs.Add(_ACT_THEORY_WEIGHT, 60); hs.Add(_STEELNAME, 80); hs.Add(_GRADENAME, 80); hs.Add(_STD_STYLE_DESC, 120); hs.Add(_SPEC_NAME,120); hs.Add(_MODEL_DESC, 80); hs.Add(_PLINE_NAME, 80); hs.Add(_ACT_DIMATER, 60); hs.Add(_ACT_HEIGHT, 60); hs.Add(_ACT_LEN, 60); return hs; } private string _LOADVEHICLE_SQE = "LOADVEHICLE_SQE"; private string _LOADVEHICLE_NO = "LOADVEHICLE_NO"; private string _BILL_NO = "BILL_NO"; private string _BILL_NO_XH = "BILL_NO_XH"; private string _TALLYSHEET_NO = "TALLYSHEET_NO"; private string _VEHICLE_NO = "VEHICLE_NO"; private string _ORDER_NO = "ORDER_NO"; private string _ORDER_SEQ = "ORDER_SEQ"; private string _ORDER_SEQ_NO = "ORDER_SEQ_NO"; private string _PRO_ORDER_NO = "PRO_ORDER_NO"; private string _MAT_NO = "MAT_NO"; private string _LOT_NO = "LOT_NO"; private string _JUDGE_STOVE_NO = "JUDGE_STOVE_NO"; private string _BATCH_NO = "BATCH_NO"; private string _GROUP_NO = "GROUP_NO"; private string _STOVE_NO = "STOVE_NO"; private string _MATERIAL_NO = "MATERIAL_NO"; private string _MATERIAL_NAME = "MATERIAL_NAME"; private string _PRODUCCODE = "PRODUCCODE"; private string _PRODUCNAME = "PRODUCNAME"; private string _STD_CODE = "STD_CODE"; private string _STD_NAME = "STD_NAME"; private string _GRADECODE = "GRADECODE"; private string _GRADENAME = "GRADENAME"; private string _STEELCODE = "STEELCODE"; private string _STEELNAME = "STEELNAME"; private string _STD_STYLE = "STD_STYLE"; private string _STD_STYLE_DESC = "STD_STYLE_DESC"; private string _SPEC_CODE = "SPEC_CODE"; private string _SPEC_NAME = "SPEC_NAME"; private string _MODEL_CODE = "MODEL_CODE"; private string _MODEL_DESC = "MODEL_DESC"; private string _PROCESS_CDOE = "PROCESS_CDOE"; private string _PROCESS_DESC = "PROCESS_DESC"; private string _PLINE_CODE = "PLINE_CODE"; private string _PLINE_NAME = "PLINE_NAME"; private string _ACT_DIMATER = "ACT_DIMATER"; private string _ACT_HEIGHT = "ACT_HEIGHT"; private string _ACT_LEN = "ACT_LEN"; private string _ACT_LEN_MIN = "ACT_LEN_MIN"; private string _ACT_LEN_MAX = "ACT_LEN_MAX"; private string _ACT_COUNT = "ACT_COUNT"; private string _ACT_WEIGHT = "ACT_WEIGHT"; private string _ACT_THEORY_WEIGHT = "ACT_THEORY_WEIGHT"; private string _JUDGE_RESULT_CODE = "JUDGE_RESULT_CODE"; private string _PRO_BC = "PRO_BC"; private string _PRO_BZ = "PRO_BZ"; private string _RPO_TIME = "RPO_TIME"; private string _SEN_BC = "SEN_BC"; private string _SEN_BZ = "SEN_BZ"; private string _SEN_TIME = "SEN_TIME"; private string _ZBS_BH = "ZBS_BH"; private string _SALE_ORG = "SALE_ORG"; private string _SALE_ORG_DESC = "SALE_ORG_DESC"; private string _SALE_AREA = "SALE_AREA"; private string _STORAGE_TYPE_NO = "STORAGE_TYPE_NO"; private string _STORAGE_TYPE_NAME = "STORAGE_TYPE_NAME"; private string _MANAGEMENT_NO = "MANAGEMENT_NO"; private string _MANAGEMENT_NAME = "MANAGEMENT_NAME"; private string _UPLOAD_WEB_FLAG = "UPLOAD_WEB_FLAG"; private string _STORAGE_NO = "STORAGE_NO"; private string _LOCATION_NO = "LOCATION_NO"; private string _LARY_NO = "LARY_NO"; private string _LOC_NO = "LOC_NO"; private string _TRANS_TPE = "TRANS_TPE"; private string _RECEIV_NO = "RECEIV_NO"; private string _RECEIV_NM = "RECEIV_NM"; private string _STATION_NO = "STATION_NO"; private string _STATION_NM = "STATION_NM"; private string _SPCL_LN_NO = "SPCL_LN_NO"; private string _SPCL_LN_NM = "SPCL_LN_NM"; private string _PORT = "PORT"; private string _PLANT = "PLANT"; private string _PLANT_DESC = "PLANT_DESC"; private string _VSTEL = "VSTEL"; private string _VSTEL_DESC = "VSTEL_DESC"; private string _CARRY_COMPANY_CODE = "CARRY_COMPANY_CODE"; private string _CARRY_COMPANY_NAME = "CARRY_COMPANY_NAME"; private string _OUT_STOCK_CODE = "OUT_STOCK_CODE"; private string _DELIVY_PLACE_CODE = "DELIVY_PLACE_CODE"; private string _DELIVY_PLACE_NAME = "DELIVY_PLACE_NAME"; private string _STLMT_UNIT_NO = "STLMT_UNIT_NO"; private string _STLMT_UNIT_NM = "STLMT_UNIT_NM"; private string _DELIVY_TIME = "DELIVY_TIME"; private string _MEMO = "MEMO"; private string _VALIDFLAG = "VALIDFLAG"; private string _CREATE_NAME = "CREATE_NAME"; private string _CREATE_TIME = "CREATE_TIME"; private string _UPDATE_NAME = "UPDATE_NAME"; private string _UPDATE_TIME = "UPDATE_TIME"; private string _DELETE_NAME = "DELETE_NAME"; private string _DELETE_TIME = "DELETE_TIME"; } }