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 System.Collections; namespace Core.StlMes.Client.Sale.Common.FrmStyleBase { public partial class FrmUIBase : FrmStyleBase { public FrmUIBase() { InitializeComponent(); } protected System.Collections.Generic.List GetDataStructCaption() { List list = new List(); list.Add(new string[] { "INVOICE_MONTH", "账本月" }); list.Add(new string[] { "INVOICE_ACCOUNT", "账本名" }); list.Add(new string[] { "BALANCESUBJECT", "销售组织" }); list.Add(new string[] { "SECONDACCOUNT", "区域" }); list.Add(new string[] { "BUYERCODE", "结算单位" }); list.Add(new string[] { "PRE_MONEY", "期初" }); list.Add(new string[] { "INMONEY", "本月进款" }); list.Add(new string[] { "INVOICE_MONEY", "本月结算" }); list.Add(new string[] { "LST_MONEY", "期末" }); list.Add(new string[] { "INVOICE_PERSON", "结转人" }); list.Add(new string[] { "UPDATE_PERSON", "修改人" }); list.Add(new string[] { "UPDATE_DATE", "修改时间" }); list.Add(new string[] { "INVOICE_STS", "结转状态" }); list.Add(new string[] { "INVOICE_DATE", "结转时间" }); list.Add(new string[] { "PACTNO", "合同头" }); list.Add(new string[] { "BUYERNAME", "结算单位" }); list.Add(new string[] { "SALE_AREA_DESC", "销售区域" }); list.Add(new string[] { "FST_DRAWEE_UNIT", "首次受票单位" }); list.Add(new string[] { "WEIGHT", "重量" }); list.Add(new string[] { "SHIPNO", "船号" }); list.Add(new string[] { "INCEPTCORPCODE", "收货单位" }); list.Add(new string[] { "QUANTITY", "支数" }); list.Add(new string[] { "WEIGHT", "重量" }); list.Add(new string[] { "MONEY", "金额" }); list.Add(new string[] { "OUTSTOCKMNY", "吊装费" }); list.Add(new string[] { "TRANSMNY", "运费" }); list.Add(new string[] { "ISPRECLOSE", "是否虚单" }); list.Add(new string[] { "ORD_NO", "合同号" }); list.Add(new string[] { "ORD_SEQ", "合同行" }); list.Add(new string[] { "ORD_LN_DLY", "交货行" }); list.Add(new string[] { "SPETKEY", "规格" }); list.Add(new string[] { "STEELCODEKEY", "钢级(牌号)" }); list.Add(new string[] { "PRICE", "单价" }); list.Add(new string[] { "AFFRIMPERSON", "末次确认人" }); list.Add(new string[] { "AFFIRMTIME", "末次确认时间" }); list.Add(new string[] { "BASEPRICE", "订单价" }); list.Add(new string[] { "FORECORPCODE", "子公司" }); list.Add(new string[] { "STATIONCODE", "到站" }); list.Add(new string[] { "TALLYSHEET_NO", "理货单" }); list.Add(new string[] { "BATCH_NO", "炉号" }); list.Add(new string[] { "PNO", "批号" }); list.Add(new string[] { "ACT_WGT", "重量" }); list.Add(new string[] { "TICKETTYPE", "类型" }); list.Add(new string[] { "TICKETNUM", "票据数" }); list.Add(new string[] { "TRANS_TYPE", "运输类型" }); list.Add(new string[] { "MOTORMANNAME", "承运公司" }); list.Add(new string[] { "REG_ID", "维护人" }); list.Add(new string[] { "REG_DTIME", "维护时间" }); list.Add(new string[] { "AFFRIM_ID", "确认人" }); list.Add(new string[] { "AFFRIM_TIME", "确认时间" }); list.Add(new string[] { "MONEY_TYPE", "费用类型" }); list.Add(new string[] { "ASKPLAN_ID", "提单号" }); list.Add(new string[] { "TRANS_TYPE_NAME", "运输方式" }); list.Add(new string[] { "REALINVOICENO_ORG", "首次真实发票号" }); list.Add(new string[] { "REALINVOICENO", "末次真实发票号" }); list.Add(new string[] { "INVOICENO", "末次结算单号" }); list.Add(new string[] { "MONEY_ORG", "首次结算金额" }); list.Add(new string[] { "PRICE_ORG", "首次单价" }); list.Add(new string[] { "INVOICENO_ORG", "首次结算单号" }); list.Add(new string[] { "INVOICENO_SEQ_ORG", "序号" }); list.Add(new string[] { "TICKETPERSON", "确认人" }); list.Add(new string[] { "TICKETDATE", "确认时间" }); list.Add(new string[] { "CATEGORY", "品名" }); list.Add(new string[] { "SPEC_ABBSYMNAME", "标准" }); list.Add(new string[] { "STD_STYLE_DESC", "标准类别" }); list.Add(new string[] { "MODEL_DESC", "扣型" }); list.Add(new string[] { "ORDER_UNIT", "计量单位" }); list.Add(new string[] { "SALE_AREA_DESC", "销售区域" }); list.Add(new string[] { "SEND_NUM", "实发量" }); list.Add(new string[] { "RECEIV_ADDR", "指定地址" }); list.Add(new string[] { "DELVRY_ADDR", "交货地点" }); list.Add(new string[] { "AGENCY_FL", "是否代办" }); list.Add(new string[] { "ISREALCLOSE", "虚单关闭状态" }); list.Add(new string[] { "TICKETSTATUS", "提单是否确认" }); list.Add(new string[] { "INVOICEPERSON_ORG", "首次编单人" }); list.Add(new string[] { "INVOICEPERSON", "末次编单人" }); list.Add(new string[] { "INVOICEDATE", "末次编单时间" }); list.Add(new string[] { "CONTAIN_TAX", "是否含税" }); list.Add(new string[] { "BALNCE_PRICE_STS", "首次价格有效性" }); list.Add(new string[] { "BALNCE_PRICE_ORG_STS", "末次价格有效性" }); list.Add(new string[] { "REALINVOICENO_DATE1", "末次发票时间" }); list.Add(new string[] { "REALINVOICENO_DATE", "末次发票时间" }); list.Add(new string[] { "REALINVOICENO_DATE_ORG1", "首次发票时间" }); list.Add(new string[] { "PACTINDEX", "钢种" }); list.Add(new string[] { "INOUTMONEY", "金额" }); list.Add(new string[] { "ACT_COUNT", "支数" }); list.Add(new string[] { "ACT_WEIGHT", "重量" }); list.Add(new string[] { "INOUTMONEY", "金额" }); list.Add(new string[] { "TOTALMONEY", "金额" }); list.Add(new string[] { "BATCHNO", "炉号" }); list.Add(new string[] { "INVOICE_MONTH", "月份" }); list.Add(new string[] { "REALINVOICENO_DATE_ORG", "首次发票时间" }); return list; } public DataSet ExecuteReader(string sql) { Core.StlMes.Client.Sale.DbHelp.DbExecute dbExecute = new Core.StlMes.Client.Sale.DbHelp.DbExecute(this.ob); DataSet ds = dbExecute.ExecuteQuery(sql); return ds; } public override void ToolBar_Click(object sender, string ToolbarKey) { if (ToolbarKey == "Query") { Query(); } else if (ToolbarKey == "Close") { this.Close(); } else if (ToolbarKey == "Exit") { this.Close(); } else if (ToolbarKey == "Add") { Add(); } else if (ToolbarKey == "Delete") { Delete(); } else if (ToolbarKey == "Update") { Update(); } else if (ToolbarKey == "Affrim") { Affrim(); } else if (ToolbarKey == "UnAffrim") { UnAffrim(); } else if (ToolbarKey == "Export") { Export(); } else if (ToolbarKey == "Send") { this.Send(); } else if (ToolbarKey == "Send1") { this.Send1(); } else if (ToolbarKey == "UnSend") { this.UnSend(); } else if (ToolbarKey == "ImportTemplate") { this.ImportTemplate(); } else if (ToolbarKey == "Import") { this.Import(); } else { } } public virtual void Query() { } public virtual void Add() { } public virtual void Delete() { } public virtual void Update() { } public virtual void Affrim() { } public virtual void UnAffrim() { } public virtual void Export() { } public virtual void Send() { } public virtual void Send1() { } public virtual void UnSend() { } public virtual void ImportTemplate() { } public virtual void Import() { } public void ExecuteNoReader(string sql) { Core.StlMes.Client.Sale.DbHelp.DbExecute dbExecute = new Core.StlMes.Client.Sale.DbHelp.DbExecute(this.ob); dbExecute.ExecuteNoQuery(sql); } public void ExecuteNoReader(ArrayList sqlList) { Core.StlMes.Client.Sale.DbHelp.DbExecute dbExecute = new Core.StlMes.Client.Sale.DbHelp.DbExecute(this.ob); if (sqlList == null || sqlList.Count == 0) return; StringBuilder sblist = new StringBuilder(); foreach (string s in sqlList) { sblist.Append(s).Append(" ;"); } StringBuilder sb = new StringBuilder(); sb.Append("declare"); sb.Append(" begin "); sb.Append(sblist.ToString()); sb.Append( " commit; "); sb.Append(" exception when others then rollback;"); sb.Append(" end ;"); string sql = sb.ToString(); dbExecute.ExecuteNoQuery(sql); } private void FrmUIBase_Load(object sender, EventArgs e) { this.IsLoadUserView = true; } protected string GetSaleOrg() { string DeptID = CoreFS.SA06.CoreUserInfo.UserInfo.GetDeptid(); if (DeptID.IndexOf("002002") >= 0) { return "100102"; } if (DeptID.IndexOf("002001004") >= 0) { return "100101"; } if (DeptID.IndexOf("002001005") >= 0) { return "100103"; } if (DeptID.IndexOf("002023001") >= 0) { return "100105"; } return "100101"; } protected string GetSaleOrgDesc() { string saleorg = GetSaleOrg(); if ("100101" == saleorg) return "国内贸易部"; else if("100102" == saleorg) return "国际贸易部"; else if ("100103" == saleorg) return "钢贸公司"; else if ("100105" == saleorg) return "天淮公司"; return ""; } protected string TextBoxValue = "Text"; protected const string UnConfirm = "0"; protected const string Confirm = "1"; protected const string OrderStatus_Input = "0"; protected const string OrderStatus_PendReview = "1"; protected const string OrderStatus_Declared = "2"; protected const string OrderStatus_SPass = "3"; protected const string OrderStatus_SUnPass = "-3"; protected const string OrderStatus_XPass = "5"; protected const string OrderStatus_XUnpass = "-5"; protected const string OrderStatus_Affrim = "6"; protected const string OrderStatus_Send = "7"; protected const string OrderStatus_SendClose = "8"; protected const string OrderStatus_OrderClose = "9"; protected const string ToolbarKey_Query = "Query"; protected const string ToolbarKey_Add = "Add"; protected const string ToolbarKey_Update = "Update"; protected const string ToolbarKey_Delete = "Delete"; protected const string ToolbarKey_unDelete = "unDelete"; protected const string ToolbarKey_Export = "Export"; protected const string ToolbarKey_Affrim = "Affrim"; protected const string ToolbarKey_Declare = "Declare"; protected const string ToolbarKey_UnDeclare = "UnDeclare"; protected const string Toolbarkey_UnAffrim = "UnAffrim"; protected const string ToolbarKey_Close = "Exit"; protected const string ToolbarKey_OrderClose = "Close"; protected const string ToolbarKey_OrderUnClose = "UnClose"; protected const string ToolbarKey_Select = "Select"; protected const string ToolbarKey_Save = "Save"; protected const string ToolbarKey_Send = "Send"; protected const string ToolbarKey_UnSend = "UnSend"; protected const string Choice_DeleteInfo = "请选择需要删除的信息"; protected const string Choice_UnDelteInfo = "请选择回退删除的信息"; protected const string Choice_UpdateInfo = "请选择需要修改的信息"; protected const string Choice_AffrimInfo = "请选择需要确认的合同"; protected const string Choice_DeclareAffrimInfo = "请选择需要评审的合同"; protected const string Choice_OrderUnAffrimInfo = "请选择需要撤销的合同"; protected const string Choice_OrderCloseInfo = "请选择订单发运关闭的信息"; protected const string Choice_OrderSendInfo = "请选择需要下发的订单"; protected const string Choice_OrderUnSendInfo = "请选择取消下发的订单信息"; protected const string Choice_SendRound = "请选择下发轮次"; protected const string ReturnInfo_Delte = "确定删除本条信息吗？"; protected const string RetrunInfo_Update = "确定修改本条信息吗？"; protected const string RetrunInfo_Exit = "确认关闭界面吗？"; protected const string RetrunInfo_Affrim = "是否合同确认？"; protected const string RetrunInfo_DeclareAffrim = "是否确认评审？"; protected const string ReturnInfo_OrderUnAffrim = "是否撤销合同确认？"; protected const string ReturnInfo_OrderClose = "是否确认关闭发运信息？"; protected const string ReturnInfo_OrderUnClose = "是否确认回退关闭发运信息？"; protected const string ReturnInfo_OrderSend = "是否确认下发订单"; protected const string ReturnInfo_OrderUnSend = "是否确认取消下发订单"; protected const string ReturnInfo_Save = "是否确认保存？"; protected const string RetrunInfo_Prompt = "提示"; protected const string NotDelete = "本条信息未删除"; protected const string Deleted = "本条信息已经被删除"; protected const string NotEditLoadNo = "不能修改到站编号"; protected const string NotEditOrderNo = "不能修改合同号"; protected const string NotDeleteOrderLineInfo = "合同下存在订单，不能删除"; protected const string NotDeleteOrderCreateName = "该合同不是由您创建，不能删除"; protected const string NotOrderDStatusPassOrPlan = "订单已生效或者资源已下发，不允许删除"; protected const string NotOrderUStatusPassOrPlan = "订单已生效或者资源已下发，不允许修改"; protected const string SendRount = "该订单已经下发"; protected const string NotSend = "该订单未下发"; protected const string LoadExisting = "到站名称已存在"; protected const string PortExisting = "港口名称已存在"; protected const string ForeCorpExisting = "子公司名称已存在"; protected const string Offic = "办事处"; protected const string Subsidiary = "子公司"; protected const string Snonentity = "子公司名称已存在"; protected const string Car = "101102"; protected const string Port = "101103"; /// /// 操作成功提示信息 /// protected string _MessageSuccess = "操作成功"; /// /// 过滤数据方法，按配置的部门数据权限在客户端过滤 /// /// /// /// protected DataSet GetDataSetByFilterDeptId(DataSet dsSource,string deptidColName) { Boolean isFilterData = true; //this.ValidDataPurviewIds if (this.ValidDataPurviewIds == null || this.ValidDataPurviewIds.Length == 0) return dsSource; if (!isFilterData) return dsSource; DataSet dsReturn = Util.UtilDataSet.GetDataSetWithRowFilter(dsSource, deptidColName, ValidDataPurviewIds); return dsReturn; } /// /// 客户端过滤数据，默认按字段为create_dept的值过滤 /// /// /// protected DataSet GetDataSetByFilterDeptId(DataSet dsSource) { return GetDataSetByFilterDeptId(dsSource, "CREATE_DEPT"); } #region ds 构造 protected DataSet GetDataSetByColumnName() { DataSet ds = new DataSet(); string[] columnName = GetDataSetColumnName(); List list = this.GetNumberColumn(); if(columnName.Length == 0) return ds; Hashtable hsColumn = GetTbColumnNameAndDataType(); Hashtable hsColumnCaption = TbColumnDefine.TbColumnAndCaptionDefine.GetInstance().GetTbColumnAndCaption(); DataTable dt = new DataTable(); if(GetTbName().Trim().Length > 0) dt.TableName = GetTbName().Trim(); DataColumn dc = null; foreach(String s in columnName) { dc = new DataColumn(s); if(hsColumn.ContainsKey(s.ToUpper())) { dc.DataType = System.Type.GetType(hsColumn[s.ToUpper()].ToString()); } else { dc.DataType = System.Type.GetType("System.String"); } if (list.Contains(s.ToUpper())) { dc.DataType = System.Type.GetType("System.Decimal"); } if(hsColumnCaption.ContainsKey(s.ToUpper())) { dc.Caption = hsColumnCaption[s.ToUpper()].ToString(); } // 自定义的重写caption if(GetDataSetColumnCaption().ContainsKey(s.ToUpper())) { dc.Caption = GetDataSetColumnCaption()[s.ToUpper()].ToString(); } try { dt.Columns.Add(dc); } catch { } } ds.Tables.Add(dt); return ds; } protected DataSet GetDataSetByColumnName(string[] columnName,Hashtable hsColumnType, Hashtable hsCaption) { DataSet ds = new DataSet(); if(columnName.Length == 0) return ds; Hashtable hsColumn = hsColumnType; Hashtable hsColumnCaption = TbColumnDefine.TbColumnAndCaptionDefine.GetInstance().GetTbColumnAndCaption(); DataTable dt = new DataTable(); DataColumn dc = null; List list = this.GetNumberColumn(); foreach(String s in columnName) { dc = new DataColumn(s); if( hsColumn != null && hsColumn.ContainsKey(s.ToUpper())) { dc.DataType = System.Type.GetType(hsColumn[s.ToUpper()].ToString()); } else { dc.DataType = System.Type.GetType("System.String"); } if (list.Contains(s.ToUpper())) { dc.DataType = System.Type.GetType("System.Decimal"); } // 如果是选择,表格编辑，表格删除按钮 if(s == SelectColumnName || s== EditColumnName || s == DeleteColumnName) { dc.DataType = System.Type.GetType("System.Boolean"); dc.DefaultValue = "FALSE"; dc.Caption = (s == SelectColumnName) ? SelectColumnCaption : ((s == EditColumnName) ? EditColumnCaption : DeleteColumnCaption); } // 自定义的重写caption if(hsCaption != null && hsCaption.ContainsKey(s.ToUpper())) { dc.Caption = hsCaption[s.ToUpper()].ToString(); } else { if(hsColumnCaption.ContainsKey(s.ToUpper())) { dc.Caption = hsColumnCaption[s.ToUpper()].ToString(); } } if (GetDataSetColumnCaption().ContainsKey(s.ToUpper())) { dc.Caption = GetDataSetColumnCaption()[s.ToUpper()].ToString(); } try { dt.Columns.Add(dc); } catch { } } ds.Tables.Add(dt); return ds; } protected virtual string GetTbName() { return ""; } protected virtual string[] GetDataSetColumnName() { return new string[] { }; } protected virtual string[] GetDataSetColumnType() { return new string[] { }; } protected virtual System.Collections.Hashtable GetTbColumnNameAndDataType() { return new System.Collections.Hashtable(); } protected virtual System.Collections.Hashtable GetDataSetColumnCaption() { return new System.Collections.Hashtable(); } #endregion #region Grid 相关操作 protected void SetGridStyle(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd) { try { SetGridStyleAll(ref ugrd); } catch { } } protected void SetGridStyle(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd1, ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd2) { try { SetGridStyle(ref ugrd1); } catch { } try { SetGridStyle(ref ugrd2); } catch { } } protected void SetGridStyle(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd1, ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd2, ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd3) { try { SetGridStyle(ref ugrd1, ref ugrd2); } catch { } try { SetGridStyle(ref ugrd3); } catch { } } protected void SetGridStyle(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd1, ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd2, ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd3, ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd4) { try { SetGridStyle(ref ugrd1, ref ugrd2, ref ugrd3); } catch { } try { SetGridStyle(ref ugrd4); } catch { } } protected void SetGridStyle(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd1, ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd2, ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd3, ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd4, ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd5) { try { SetGridStyle(ref ugrd1, ref ugrd2, ref ugrd3, ref ugrd4); } catch { } try { SetGridStyle(ref ugrd5); } catch { } } protected void SetGridStyle(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd1, ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd2, ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd3, ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd4, ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd5, ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd6) { try { SetGridStyle(ref ugrd1, ref ugrd2, ref ugrd3, ref ugrd4, ref ugrd5); } catch { } try { SetGridStyle(ref ugrd6); } catch { } } protected void SetGridStaticsSum(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd) { Util.UtilUltraGrid.SetStaticsInfoSum(ref ugrd, GetGridColumnForStaticsSum()); } protected void SetGridStaticsAvg(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd) { Util.UtilUltraGrid.SetStaticsInfoSum(ref ugrd, GetGridColumnForStaticsAvg()); } /// /// 求和列的列表 /// /// protected virtual ArrayList GetGridColumnForStaticsSum() { ArrayList list = new ArrayList(); list.Add("ACT_WGT"); list.Add("CAL_WGT"); list.Add("MONEY"); list.Add("MONEY_ORG"); list.Add("ORD_WGT"); list.Add("OUTSTOCKMNY"); list.Add("PRD_QTY"); list.Add("QUANTITY"); list.Add("SEND_NUM"); list.Add("TESTPRICE"); list.Add("TICKETNUM"); list.Add("TRANSMONEY"); list.Add("INOUTMONEY"); list.Add("TOTALMONEY"); list.Add("TRANS_MONEY"); list.Add("LEAVEMONEY"); list.Add("ASKPLAN_MONEY"); list.Add("WEIGHT"); list.Add("ACT_COUNT"); list.Add("ACT_WEIGHT"); list.Add("PRE_MONEY"); list.Add("INMONEY"); list.Add("INVOICE_MONEY"); list.Add("LST_MONEY"); list.Add("BALNCE_PRICE"); list.Add("WEIGHT1"); list.Add("MONEY1"); list.Add("MONEY2"); list.Add("STAMP_DUTY_MONEY"); return list; } /// /// 求平均值列表 /// /// protected virtual ArrayList GetGridColumnForStaticsAvg() { return new ArrayList(); } protected virtual Hashtable GetGridColumnHidden() { return new Hashtable(); } protected virtual List GetGridColumnListHidden() { return new List(); } protected void SetGridStyleAll(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd) { Hashtable hsLength = TbColumnDefine.TbColumnAndCaptionDefine.GetInstance().GetTbColumnAndShowLength(); Hashtable haHiddenColumn = GetGridColumnHidden(); Hashtable hsDefineLen = GetGridColumnLength(); List listHiddenColumn = GetGridColumnListHidden(); bool isExists = false; try { for(int i = 0; i < ugrd.DisplayLayout.Bands.Count; i++) { foreach(Infragistics.Win.UltraWinGrid.UltraGridColumn ugc in ugrd.DisplayLayout .Bands[i].Columns) { isExists = false; ugc.Width = columnLen; ugc.CellActivation = Infragistics.Win.UltraWinGrid.Activation.ActivateOnly; try { if (hsLength.ContainsKey(ugc.Key.ToUpper())) { ugc.Width = int.Parse(hsLength[ugc.Key.ToUpper()].ToString()); isExists = true; } if (hsDefineLen.Count > 0 && hsDefineLen.ContainsKey(ugc.Key.ToUpper())) { ugc.Width = int.Parse(hsDefineLen[ugc.Key.ToUpper()].ToString()); isExists = true; } } catch { } try { if(listHiddenColumn.Count > 0 && listHiddenColumn.Contains(ugc.Key.ToUpper())) { ugc.Hidden = true; } if(haHiddenColumn.Count > 0 && haHiddenColumn.ContainsKey(ugc.Key.ToUpper())) { ugc.Hidden = true; } } catch { } } } } catch { } SetShareGridStyle(ref ugrd); } private int columnLen = 100; protected void SetGridStyleAll(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd, Hashtable hsDefineLength) { Hashtable hsLength = TbColumnDefine.TbColumnAndCaptionDefine.GetInstance().GetTbColumnAndShowLength(); Hashtable haHiddenColumn = GetGridColumnHidden(); Hashtable hsDefineLen = hsDefineLength; List listHiddenColumn = GetGridColumnListHidden(); try { for(int i = 0; i < ugrd.DisplayLayout.Bands.Count; i++) { foreach(Infragistics.Win.UltraWinGrid.UltraGridColumn ugc in ugrd.DisplayLayout .Bands[i].Columns) { try { ugc.Width = columnLen; if(hsLength.ContainsKey(ugc.Key.ToUpper())) { ugc.Width = int.Parse(hsLength[ugc.Key.ToUpper()].ToString()); } if(hsDefineLen != null && hsDefineLen.Count > 0 && hsDefineLen.ContainsKey(ugc.Key.ToUpper())) { ugc.Width = int.Parse(hsDefineLen[ugc.Key.ToUpper()].ToString()); } } catch { } try { if(listHiddenColumn.Count > 0 && listHiddenColumn.Contains(ugc.Key.ToUpper())) { ugc.Hidden = true; } if(haHiddenColumn.Count > 0 && haHiddenColumn.ContainsKey(ugc.Key.ToUpper())) { ugc.Hidden = true; } } catch { } } } } catch { } SetShareGridStyle(ref ugrd); } private void SetShareGridStyle(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd) { SetChildGridHeaderApperance(ref ugrd); SetGridStaticsSum(ref ugrd); SetGridStaticsAvg(ref ugrd); SetGridTextAlign(ref ugrd); SetGridDateTypeColumnFormat(ref ugrd); } protected void SetChildGridHeaderApperance(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd) { // ugrd.Font.Bold = false; } protected void ResetGridFilterStyle(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd) { try { ugrd.DisplayLayout.Override.FilterUIType = Infragistics.Win.UltraWinGrid.FilterUIType.FilterRow; ugrd.DisplayLayout.Override.FilterOperatorDefaultValue = Infragistics.Win.UltraWinGrid.FilterOperatorDefaultValue.Contains; } catch { } } protected void SetGridTextAlign(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd) { List list = null; if (GetNumberTypeColulmn().Count > 0) { list = GetNumberTypeColulmn(); } else { list = TbColumnDefine.TbColumnAndCaptionDefine.GetInstance().GetNumberTypeColulmn(); } if (list == null || list.Count == 0) return; foreach (String s in list) { try { for (int i = 0; i < ugrd.DisplayLayout.Bands.Count; i++) { ugrd.DisplayLayout.Bands[i].Columns[s].CellAppearance.TextHAlign = Infragistics.Win.HAlign.Right; } } catch { } } } protected virtual List GetNumberTypeColulmn() { return new List(new string[]{ }); } /// /// 设置日期格式的显示时间 /// /// protected void SetGridDateTypeColumnFormat(ref Infragistics.Win.UltraWinGrid.UltraGrid ugrd) { try { string defaultFormat = "yyyy-MM-dd HH:mm:ss"; List list = TbColumnDefine.TbColumnAndCaptionDefine.GetInstance().GetDateTypeColulmn(); if (list == null || list.Count == 0) { } else { foreach (String s in list) { try { for (int i = 0; i < ugrd.DisplayLayout.Bands.Count; i++) { ugrd.DisplayLayout.Bands[i].Columns[s].Format = defaultFormat; } } catch { } } } } catch { } try { List listNumber = GetNumberColumn(); if (listNumber == null || listNumber.Count == 0) return; List listInteger = TbColumnDefine.TbColumnAndCaptionDefine.GetInstance().GetIntegerTypeColulmn(); List listPrice = TbColumnDefine.TbColumnAndCaptionDefine.GetInstance().GetPriceTypeColulmn(); foreach (String s in listNumber) { try { for (int i = 0; i < ugrd.DisplayLayout.Bands.Count; i++) { if (listInteger.Contains(s)) { ugrd.DisplayLayout.Bands[i].Columns[s].MaskInput = "-nnn,nnn,nnn,nnn,nnn"; } else if (listPrice.Contains(s)) { ugrd.DisplayLayout.Bands[i].Columns[s].MaskInput = "-nnn,nnn,nnn,nnn.nnnn"; } else { ugrd.DisplayLayout.Bands[i].Columns[s].MaskInput = "-nnn,nnn,nnn,nnn.nnn"; } ugrd.DisplayLayout.Bands[i].Columns[s].MaskDisplayMode = Infragistics.Win.UltraWinMaskedEdit.MaskMode.IncludeLiterals; } } catch { } } } catch { } } protected virtual List GetNumberColumn() { return new List(new string[]{ "SEND_NUM", "MONEY","STAMP_DUTY_MONEY", "WEIGHT", "QUANTITY", "ACT_WGT", "OUTSTOCKMNY", "TRANSMNY", "PRICE", "PRICE_ORG", "MONEY_ORG", "BALNCE_PRICE_ORG", "BALNCE_PRICE", "INOUTMONEY", "TOTALMONEY", "LEAVEMONEY", "ASKPLAN_MONEY", "TRANS_MONEY","ACT_COUNT","ACT_WEIGHT","SEND_NUM","PRE_MONEY","INMONEY","INVOICE_MONEY", "LST_MONEY", "INMONEY","INVOICE_MONEY","LST_MONEY","WEIGHT1","MONEY1","MONEY2" }); } protected virtual Hashtable GetGridColumnLength() { return new Hashtable(); } protected string SelectColumnName { get { return "SELECTEDCELL"; } } protected string EditColumnName { get { return "EDITCELL"; } } protected string DeleteColumnName { get { return "DELETEDCELL"; } } protected string SelectColumnCaption { get { return "选择"; } } protected virtual string EditColumnCaption { get { return "编辑"; } } protected virtual string DeleteColumnCaption { get { return "删除"; } } #endregion #region 表数据结构定义 protected string[] GetTbSlmOrderHeadDataSetColumnName() { return new string[] { "ORDER_NO", "CUSTOMER_NO", "CUSTOMER_NM", "MNY_ASK_TYP", "FORECORPCODE", "FORECORPNAME", "ORDER_WGT", "INPUT_WGT", "ORDER_MNY_TAX", "PRICE_FL", "ADVANCESCALE", "ADVANCEMONEY", "SIGN_DATE", "MNY_ASK_TYP", "ISIMPORTORDER", "ISDEV", "ISOUT", "ORDER_BDATE", "ORDER_EDATE", "CREATE_NAME", "CREATE_TIME", "APPROVAL_MAN", "APPROVAL_TIME", "MEMO" }; } protected string[] GetTbSlmOrderLineDataSetColumnName() { return new string[] { //"ORDER_NO", //"ORDER_SEQ", //"HEIGHT", //"WIDTH", //"LENGTH", //"ORDER_QTY", //"WEIGHT", //"ORDER_PRICE", //"FIXSIZE", //"WIDTH_MIN", //"WIDTH_MAX", //"LEN_MIN", //"LEN_MAX", //"NUCLEARSTEEL", //"KHIC", //"ISPOSTER", //"ORDER_SPECIAL_FL", //"VALIDFLAG", //"DELVRY_BDATE", //"DELVRY_EDATE", //"DELVRY_DATE", //"MEMO", //"PROD_LINE", //"SPEC_ABBSYM", //"STEEL_CODE", //"USED_CD", //"PRDNM_CD", //"TRANSIT_TYP", //"REGION_NO", //"DESTINATION", //"SPCL_LN_NO", //"ISOWNEDCAR", //"PORT_NO", //"INCEPTCORPCODE", //"REINCEPTCORP", //"CREATE_NAME", //"CREATE_TIME", //"UPDATE_NAME", //"UPDATE_TIME", //"DELETE_NAME", //"DELETE_TIME" "ORDER_NO", "ORDER_SEQ", "PROD_LINE", "STEEL_CODE", "USED_CD", "PRDNM_CD", "SPEC_ABBSYM", "ISALPHA", "HEIGHT", "WIDTH", "LENGTH", "ORDER_PRICE", "ORDER_QTY", "WEIGHT", "ORD_SEND_WGT", "ORD_INVOICE_WGT", "FIXSIZE", "LEN_MIN", "LEN_MAX", "WIDTH_MIN", "WIDTH_MAX", "SENDSTATUS", "ORDER_UNIT", "SPCL_LN_NO", "PRI", "DELVRY_RANGE_TPE", "DELVRY_RANGE_MIN", "DELVRY_RANGE_MAX", "ORDER_SPECIAL_FL", "TRANSIT_TYP", "DESTINATION", "DELVRY_BDATE", "DELVRY_EDATE", "DELVRY_DATE", "REGION_NO", "STATION_NO", "STATION_NM", "ISOWNEDCAR", "ISSHIPPING", "PORT_NO", "INCEPTCORPCODE", "REINCEPTCORP", "ISWELDED_HEAT", "NUCLEARSTEEL", "KHIC", "ISPOSTER", "FINAL_USER", "FINAL_USER_DESC", "QUALITY_DESIGH_RESULT", "QUALITY_DESIGH_ERRMSG", "QUALITY_DESIGH_NAME", "QUALITY_DESIGH_DATE", "ZBS", "TRANS_PRICE", "TEST_ID", "TEST_PRICE", "OUT_PRICE", "BALNCE_PRICE", "ORDER_LN_STATUS", "REVIEW_STATUS", "REVIEW_MSG", "REVIEW_DATE", "REVIEW_ENTRYDATE", "MEMO", "VALIDFLAG", "CREATE_NAME", "CREATE_TIME", "UPDATE_NAME", "UPDATE_TIME", "DELETE_NAME", "DELETE_TIME" }; } #endregion protected System.Drawing.Color GetEditColor() { return Color.FromArgb(255, 255, 128); } protected Hashtable ConvertListStringArrayToHashTable(List list) { Hashtable hs = new Hashtable(); if (list == null || list.Count == 0) return hs; foreach (string[] s in list) { if (hs.ContainsKey(s[0])) { hs.Remove(s[0]); } hs.Add(s[0],s[1]); } return hs; } } }