MES_Client/TGMES/Core.StlMes.Client.Sale.SaleFundMgt/FundUI/UIFrm/FrmFundBase.cs

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 Infragistics.Win.UltraWinGrid;
using System.Collections;


namespace Core.StlMes.Client.Sale.SaleFundMgt.FundUI.UIFrm
{
    public partial class FrmFundBase : Core.StlMes.Client.Sale.Common.FrmStyleBase.FrmUIBase
    {
        public FrmFundBase()
        {
            InitializeComponent();
        }


        public DataSet ExecuteReader(string sql)
        {
            FundDAL.BaseDAL.BaseDAL dal = new Core.StlMes.Client.Sale.SaleFundMgt.FundDAL.BaseDAL.BaseDAL(this.ob);
             return    dal.ExecuteReader(sql);
        }


        public string GetUserName()
        {
            return CoreFS.SA06.CoreUserInfo.UserInfo.GetUserName();
        }

        private ArrayList GetDateTimeColumn()
        {
            ArrayList list = new ArrayList();
            list.Add("IMPORTTIME");
            list.Add("LASTUPDATETIME");
            list.Add("INOUTTIME");
            list.Add("DELETETIME");
            list.Add("UPDATETIME");
            list.Add("TRANS_TIME");
            return list;
        }

        protected void SetGridTimeFormat(ref Infragistics.Win.UltraWinGrid.UltraGrid ugr)
        {
            if (ugr == null || ugr.Rows.Count == 0)
                return;
            ArrayList list = GetDateTimeColumn();
            ArrayList formatColumn = new ArrayList ();
            foreach (Infragistics.Win.UltraWinGrid.UltraGridColumn ugc in ugr.DisplayLayout.Bands[0].Columns)
            {
                if (list.Contains(ugc.Key))
                {
                    formatColumn.Add(ugc.Key);
 
                }
 
            }

            if (formatColumn.Count > 0)
            {
                foreach (Infragistics.Win.UltraWinGrid.UltraGridRow ugrr in ugr.Rows)
                {
                    foreach (string s in formatColumn)
                    {
                        if (ugrr.Cells[s].Value.ToString().Length > 0)
                        {
                            ugrr.Cells[s].Value = Getconvertformat(ugrr.Cells[s].Value.ToString());
                        }
                    }
                }
            }

        }

        private string Getconvertformat(string value)
        {
            System.Text.StringBuilder sb = new StringBuilder();
            if (value.Length == 0)
                return "";
            
            else if (value.Length == 8)
            {
                return sb.Append(value.Substring(0, 4)).Append("-").Append(value.Substring(4, 2)).Append("-").Append(value.Substring(6, 2)
                  ).ToString();
            }
            else if (value.Length == 14)
            {
                return sb.Append(value.Substring(0, 4)).Append("-").Append(value.Substring(4, 2)).Append("-").Append(value.Substring(6, 2)
                  ).Append(" ").Append(value.Substring(8, 2)).Append(":").Append(value.Substring(10, 2)).Append(":").Append(value.Substring(12, 2)).ToString();

            }
            else
                return value;
        }

        protected string GetSaleOrg()
        {
            string DeptID = CoreFS.SA06.CoreUserInfo.UserInfo.GetDeptid();
            if (DeptID.IndexOf("002001042002") >= 0)
            {
                return "100102";
            }
            if (DeptID.IndexOf("002001042001") >= 0)
            {
                return "100101";
            }
            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 "";

        }


        public string[] GetTbColumn_SEL_FUND_CUST_FUNDINOUT()
        {
            return new string[] 
            {
                "BUSISEQ",
                "BALANCESUBJECT",
                "BUYERCODE",
                "INOUTMONEY",
                "INOUTTIME",
                "FUNDTYPE",
                "BILLNO",
                "ISVALID",
                "ORDERNO",
                "REMARK",
                "IMPORTOR",
                "IMPORTTIME",
                "LEAVEMONEY",
                "SECONDACCOUNT",
                "AFFRIMPER",
                "AFFRIMDATE"
            };
           
        }

        public string[] GetTbColumn_SEL_FUND_CUST_ACCOUNT()
        {
            return new string[] 
            {
                "BALANCESUBJECT",
                "BUYERCODE",
                "TOTALMONEY",
                "LEAVEMONEY",
                "IMPORTOR",
                "IMPORTTIME",
                "UPDATETIME"
            };

        }

        public string[] GetTbColumn_SEL_FUND_SEC_ACCOUNT()
        {
            return new string[] 
            {
                "BALANCESUBJECT",
                "BUYERCODE",
                "SECONDACCOUNT",
                "TOTALMONEY",
                "LEAVEMONEY",
                "IMPORTOR",
                "IMPORTTIME",
                "UPDATETIME"
            };

        }

        protected  System.Collections.Hashtable GetFundColumnNameAndCaption()
        {
            System.Collections.Hashtable hs = new System.Collections.Hashtable();
            try
            {
                hs.Add("ASKPLAN_ID", "提单号");
                hs.Add("ASKPLAN_MONEY", "货物款");
                hs.Add("BALANCESUBJECT", "销售组织");
                hs.Add("BILLNO", "用途");
                hs.Add("BUSISEQ", "序列");
                hs.Add("BUSITYPE", "类型");
                hs.Add("BUYERCODE", "结算单位");
                hs.Add("DELETEOR", "删除");
                hs.Add("DELETETIME", "删除时间");
                hs.Add("FUNDTYPE", "类型");
                hs.Add("IMPORTOR", "录入人");
                hs.Add("IMPORTTIME", "录入时间");
                hs.Add("INOUTMONEY", "金额");
                hs.Add("INOUTTIME", "进出时间 ");
                hs.Add("INVOICE_MONEY", "金额");
                hs.Add("ISINVOINCE", "结算标志");
                hs.Add("ISMONEYVALID", "是否有效");
                hs.Add("ISUNUSUAL", "是否正常");
                hs.Add("ISVALID", "是否有效");
                hs.Add("LASTUPDATETIME", "更新时间");
                hs.Add("LEAVEMONEY", "剩余资金");
                hs.Add("MONEY", "发生金额");
                hs.Add("MONEY_TYPE", "类型");
                hs.Add("OTHERACCOUNT", "对方账户");
                hs.Add("PACTNO", "合同号");
                hs.Add("PACTNO_MONEY", "合同金额");
                hs.Add("PACT_BEGINDATE", "合同开始时间");
                hs.Add("PACT_REA_NAME", "映射名称");
                hs.Add("PACT_REA_NAME_SHOW", "映射名称");
                hs.Add("PRIORITY", "优先级");
                hs.Add("RELATION", "映射分类");
                hs.Add("REMARK", "备注");
                hs.Add("SECONDACCOUNT", "二级账户");
                hs.Add("TOTALMONEY", "总资金");
                hs.Add("TRANS_MONEY", "运费");
                hs.Add("TRANS_PERSON", "调拨人");
                hs.Add("TRANS_SEQ", "序列");
                hs.Add("TRANS_TIME", "时间");
                hs.Add("TRANS_TYPE", "类型");
                hs.Add("TYPE", "类型");
                hs.Add("USERID", "用户ID");
                hs.Add("UPDATETIME", "更新时间");
                hs.Add("WEIGHT", "重量");
                hs.Add("AFFRIMPER", "确认人");
                hs.Add("AFFRIMDATE", "确认时间");
                hs.Add("ORDERNO", "合同号");
                
                hs.Add("MONEY_DELIVER", "回款去向");
                hs.Add("PREBUYERCODE", "钢贸回款客户");



            }
            catch
            {

            }
            return hs;
        }

        protected   System.Collections.Hashtable GetGridColumnLengthDefine()
        {
            System.Collections.Hashtable hs = new System.Collections.Hashtable();
            try
            {
                hs.Add("BUYERCODE", 200);
                hs.Add("PREMONEY", 80);
                hs.Add("CURMONEY", 80);
                hs.Add("CUR_RECEIVE_MONEY", 80);
                hs.Add("DE_MONEY", 90);
                hs.Add("SALE_AREA_DESC", 80);
                hs.Add("MONEY", 80);
                hs.Add("PACTNO", 100);
                hs.Add("WEIGHT", 80);
                hs.Add("TRANS_TIME", 120);
                hs.Add("IMPORTTIME", 120);
                hs.Add("DELETETIME", 120);
                hs.Add("UPDATETIME", 120);
                hs.Add("INOUTTIME", 120);
                hs.Add("LASTUPDATETIME", 120);
            }
            catch
            { }
            return hs;
        }

        protected string balanceSubject = FundVariable.FundConstVariable.BalanceSubject_Xgxs;

        private string GetBalanceSubjectKey()
        {
            string[] tmpstr = this.Key.Split('@');
            if (tmpstr != null || tmpstr.Length > 1)
            {
                return tmpstr[1];
            }
            return "";


        }

        protected virtual string GetBalanceSubject()
        {
            return "1";
            //return FundBLL.FundBalanceSubjectMgt.BalanceSubjectMgt.GetBalanceSubject(balanceSubject);
        }

   

        /// <summary>
        /// 需要隐藏的列
        /// </summary>
        /// <returns></returns>
        protected virtual string[] HiddenColumn()
        {
            return new string[] { };
        }

        protected virtual string[] NotHiddenColumn()
        {
            return new string[] { _columnBalanceSubject,_columnBuyercode,_columnSecondaccount,_columnTotalMoney,_columnLeaveMoney,
            _columnPactno};
        }

        protected virtual int[] ColumnWidth()
        {
            return new int[] { };
        }

        protected virtual System.Collections.Hashtable ColumnNameAndWidht()
        {
            Hashtable hs = new Hashtable();
            hs.Add(_columnBuyercode, 100);
            hs.Add(_columnTotalMoney, 70);
            hs.Add(_columnLeaveMoney, 60);
            hs.Add(_columnPactno, 70);
            hs.Add(_columnSecondaccount, 70);
            return hs;
        }

        /// <summary>
        /// 需要汇总的列
        /// </summary>
        /// <returns></returns>
        protected virtual string[] TotalColumn()
        {
            return new string[] { this._columnTotalMoney, this._columnLeaveMoney };
        }

        protected virtual void InitGrid(ref UltraGrid grid)
        {
            Util.UltraGridUtil.SetGridWidth(ref grid, ColumnNameAndWidht());
            Util.UltraGridUtil.SetGridColumnHidden(ref grid, this.HiddenColumn());
            Util.UltraGridUtil.SetGridRowFilter(ref grid);
         //   Util.UltraGridUtil.InitUltraGridValueList(ref grid);

        }

        protected virtual void InitGrid(ref UltraGrid grid, Boolean nothiddenColumn)
        {
            Util.UltraGridUtil.SetGridWidth(ref grid, ColumnNameAndWidht());
            Util.UltraGridUtil.SetGridColumnHidden(ref grid, this.HiddenColumn());
            Util.UltraGridUtil.SetGridColumnHidden(ref grid, this.NotHiddenColumn(), nothiddenColumn);
            Util.UltraGridUtil.SetGridRowFilter(ref grid);
            Util.UltraGridUtil.InitUltraGridValueList(ref grid);
        }

        /// <summary>
        /// FundCustAccountMgt 实例
        /// </summary>
        /// <returns></returns>
        protected FundBLL.FundCustAccount.FundCustAccountMgt GetInstanceCustAccount()
        {
            return new FundBLL.FundCustAccount.FundCustAccountMgt(this.ob);
        }

        /// <summary>
        /// FundInAndOutMgt 实例
        /// </summary>
        /// <returns></returns>
        protected FundBLL.FundInAndOut.FundInAndOutMgt GetIInstanceCustInout()
        {
            return new FundBLL.FundInAndOut.FundInAndOutMgt(this.ob);
        }

        /// <summary>
        /// FundSecondlevelAccountMgt 实例
        /// </summary>
        /// <returns></returns>
        protected FundBLL.FundSecondLevelAccount.FundSecondlevelAccountMgt GetInstanceSecondLevelAccount()
        {
            return new  FundBLL.FundSecondLevelAccount.FundSecondlevelAccountMgt(this.ob);
        }

        /// <summary>
        /// FundPactAccountMgt
        /// </summary>
        /// <returns></returns>
        protected FundBLL.FundPactAccount.FundPactAccountMgt GetInstancePactAccount()
        {
            return new  FundBLL.FundPactAccount.FundPactAccountMgt(this.ob);
        }

        /// <summary>
        /// FundTransferMgt
        /// </summary>
        /// <returns></returns>
        protected FundBLL.FundTransferMgt.FundTransferMgt GetInstanceTransfer()
        {
            return new FundBLL.FundTransferMgt.FundTransferMgt(this.ob);
        }

     

        protected string _columnBalanceSubject = "BALANCESUBJECT";
        protected string _columnBuyercode = "BUYERCODE";
        protected string _columnSecondaccount = "SECONDACCOUNT";
        protected string _columnPactno = "PACTNO";
        protected string _columnTotalMoney = "TOTALMONEY";
        protected string _columnLeaveMoney = "LEAVEMONEY";
        protected string _columnPactBeginDate = "PACT_BEGINDATE";
        protected string _columnTRANS_TYPE = "TRANS_TYPE";
        protected string _columnMONEY = "MONEY";


        protected string _columnTRANS_SEQ = "TRANS_SEQ";
        protected string _columnISMONEYVALID = "ISMONEYVALID";
        protected string _columnIRemark = "REMARK";
        protected string _columnIUPDATETIME = "UPDATETIME";
        protected string _columnImportTime = "IMPORTTIME";
        protected string _columnUserid = "USERID";

        /// <summary>
        /// 操作成功提示信息
        /// </summary>
        protected string _successMsg = "操作成功";
        protected string _msgBalanceSubject = "结算单位:  ";
        protected string _dateTimeDefaultFormat = "yyyyMMddHHmmss";
        protected string _dateTimeFormatYyyyMmdd = "yyyyMMdd";


        protected string _keyQuery = "Query";
        protected string _keyClose = "Close";
        protected string _keyExport = "Export";
        protected string _keyAdd = "Add";
        protected string _keyEdit = "Edit";
        protected string _keyDelete = "Delete";

        protected string _msgNoBalanceSubject = "无结算单位，请正确设置登陆用户和结算单位关系";


        protected string[] GetNumberColumns()
        {
            return new string[] { 
            "PRE_MONEY",
            "INMONEY",
            "INVOICE_MONEY",
            "LST_MONEY",
            "ACT_WEIGHT",
            "BALNCE_PRICE",
            "WEIGHT1",
            "MONEY1", 
            "MONEY2"
            };
        }

        protected Hashtable GetNumberColumnHs()
        {
            Hashtable hs = new Hashtable();

            foreach (string s in GetNumberColumns())
            {
                if (hs.ContainsKey(s))
                {
                    hs.Remove(s);
                }
                hs.Add(s, "System.Decimal");
            }

            return hs;
 
        }

        protected System.Collections.Generic.List<string[]> GetDataStructCaption()
        {
            List<string[]> list = new List<string[]>();
            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[] { "ORDERNO", "合同号" });
            list.Add(new string[] { "ACT_WEIGHT", "提单在途量" });
            list.Add(new string[] { "BALNCE_PRICE", "提单在途金额" });
            list.Add(new string[] { "WEIGHT1", "出库未结量" });
            list.Add(new string[] { "MONEY1", "出库未结金额" });
            list.Add(new string[] { "MONEY2", "可发货金额" });
            return list;
        }
    }
}