示例#1
0
        //public override string[,] SetExcelRangeData(DataTable source)
        //{
        //    string[,] objData = new string[source.Rows.Count, 18];
        //    for (int i = 0; i < source.Rows.Count; i++)
        //    {
        //        System.Data.DataRow dr = source.Rows[i];
        //        objData[i, 0] = dr["AssetName"].ToString();
        //        objData[i, 1] = dr["RefNo"].ToString();
        //        objData[i, 2] = dr["PaperNo"].ToString();
        //        objData[i, 3] = dr["CardNo"].ToString();
        //        objData[i, 4] = ((DateTime)dr["StockDate"]).ToString("yyyy-MM-dd");
        //        objData[i, 5] = dr["OutContractNo"].ToString();
        //        objData[i, 6] = dr["InCorpName"].ToString();
        //        objData[i, 7] = dr["OutCorpName"].ToString();
        //        objData[i, 8] = dr["MUName"].ToString();
        //        objData[i, 9] = dr["inNetAmount"].ToString();
        //        objData[i, 10] = dr["ReceiptInGap"].ToString();
        //        objData[i, 11] = dr["inGapAmount"].ToString();
        //        objData[i, 12] = dr["inRate"].ToString();
        //        objData[i, 13] = dr["outNetAmount"].ToString();
        //        objData[i, 14] = dr["ReceiptOutGap"].ToString();
        //        objData[i, 15] = dr["outGapAmount"].ToString();
        //        objData[i, 16] = dr["outRate"].ToString();
        //        objData[i, 17] = dr["ProfitOrLoss"].ToString();
        //    }
        //    return objData;
        //}
        public override DataTable SetExcelRangeData(DataTable source)
        {
            string[] strs = new string[] { "AssetName", "RefNo", "PaperNo", "CardNo", "StockDate", "OutContractNo", "InCorpName", "OutCorpName", "MUName", "inNetAmount", "ReceiptInGap", "inGapAmount", "inRate", "outNetAmount", "ReceiptOutGap", "outGapAmount", "outRate", "ProfitOrLoss" };

            return source.ConvertDataTable(strs);
        }
示例#2
0
        //public override string[,] SetExcelRangeData(DataTable source)
        //{
        //    string[,] objData = new string[source.Rows.Count, 8];
        //    for (int i = 0; i < source.Rows.Count; i++)
        //    {
        //        System.Data.DataRow dr = source.Rows[i];
        //        objData[i, 0] = ((DateTime)dr["CustomsDate"]).ToString("yyyy-MM-dd");
        //        objData[i, 1] = dr["RefNo"].ToString();
        //        objData[i, 2] = dr["GrossWeight"].ToString();
        //        objData[i, 3] = dr["NetWeight"].ToString();
        //        objData[i, 4] = dr["MUName"].ToString();
        //        objData[i, 5] = dr["CorpName"].ToString();
        //        objData[i, 6] = dr["CurrencyName"].ToString();
        //        objData[i, 7] = dr["CustomsPrice"].ToString();
        //    }
        //    return objData;
        //}
        public override DataTable SetExcelRangeData(DataTable source)
        {
            string[] strs = new string[] { "CustomsDate", "RefNo", "GrossWeight", "NetWeight", "MUName", "CorpName", "CurrencyName", "CustomsPrice" };

            return source.ConvertDataTable(strs);
        }
示例#3
0
        //public override string[,] SetExcelRangeData(DataTable source)
        //{
        //    string[,] objData = new string[source.Rows.Count, 18];
        //    for (int i = 0; i < source.Rows.Count; i++)
        //    {
        //        System.Data.DataRow dr = source.Rows[i];
        //        objData[i, 0] = ((DateTime)dr["LogDate"]).ToString("yyyy-MM-dd");
        //        objData[i, 1] = dr["LogTypeName"].ToString();
        //        objData[i, 2] = dr["RefNo"].ToString();
        //        objData[i, 3] = dr["PaperNo"].ToString();
        //        objData[i, 4] = dr["AssetName"].ToString();
        //        objData[i, 5] = dr["BrandName"].ToString();
        //        objData[i, 6] = dr["CardNo"].ToString();
        //        objData[i, 7] = dr["CustomsTypeName"].ToString();
        //        objData[i, 8] = dr["DPName"].ToString();
        //        objData[i, 9] = dr["GrossAmount"].ToString();
        //        objData[i, 10] = dr["NetAmount"].ToString();
        //        objData[i, 11] = dr["MUName"].ToString();
        //        objData[i, 12] = dr["InCorpName"].ToString();
        //        objData[i, 13] = dr["OutCorpName"].ToString();
        //        objData[i, 14] = dr["SubNo"].ToString();
        //        objData[i, 15] = dr["TradeDirectionName"].ToString();
        //        objData[i, 16] = dr["AvgPrice"].ToString();
        //        objData[i, 17] = dr["CurrencyName"].ToString();
        //    }
        //    return objData;
        //}
        public override DataTable SetExcelRangeData(DataTable source)
        {
            string[] strs = new string[] { "LogDate", "LogTypeName", "RefNo", "PaperNo", "AssetName", "BrandName", "CardNo", "CustomsTypeName", "DPName", "GrossAmount", "NetAmount", "MUName", "InCorpName", "OutCorpName", "SubNo", "TradeDirectionName", "AvgPrice", "CurrencyName" };

            return source.ConvertDataTable(strs);
        }
示例#4
0
        //public override string[,] SetExcelRangeData(DataTable source)
        //{
        //    string[,] objData = new string[source.Rows.Count, 22];
        //    for (int i = 0; i < source.Rows.Count; i++)
        //    {
        //        System.Data.DataRow dr = source.Rows[i];
        //        objData[i, 0] = ((DateTime)dr["ContractDate"]).ToShortDateString();
        //        objData[i, 1] = dr["ContractNo"].ToString();
        //        objData[i, 2] = dr["OutContractNo"].ToString();
        //        objData[i, 3] = dr["InCorpName"].ToString();
        //        objData[i, 4] = dr["OutCorpName"].ToString();
        //        objData[i, 5] = dr["TradeDirectionName"].ToString();
        //        objData[i, 6] = dr["PriceModeName"].ToString();
        //        objData[i, 7] = dr["TradeBorderName"].ToString();
        //        objData[i, 8] = dr["AssetName"].ToString();
        //        objData[i, 9] = dr["MUName"].ToString();
        //        objData[i, 10] = dr["CurrencyName"].ToString();
        //        objData[i, 11] = dr["SignAmount"].ToString();
        //        objData[i, 12] = dr["InAmount"].ToString();
        //        objData[i, 13] = dr["OutAmount"].ToString();
        //        objData[i, 14] = dr["PricingWeight"].ToString();
        //        objData[i, 15] = dr["AvgPrice"].ToString();
        //        objData[i, 16] = dr["ProAmount"].ToString();
        //        objData[i, 17] = dr["ProBala"].ToString();
        //        objData[i, 18] = dr["FinAmount"].ToString();
        //        objData[i, 19] = dr["FinBala"].ToString();
        //        objData[i, 20] = dr["OutBala"].ToString();
        //        objData[i, 21] = dr["InBala"].ToString();
        //    }
        //    return objData;
        //}
        public override DataTable SetExcelRangeData(DataTable source)
        {
            string[] strs = new string[] { "ContractDate", "ContractNo", "OutContractNo", "InCorpName", "OutCorpName", "TradeDirectionName", "PriceModeName", "TradeBorderName", "AssetName", "MUName", "CurrencyName", "SignAmount", "InAmount", "OutAmount", "PricingWeight", "AvgPrice", "ProAmount", "ProBala", "FinAmount", "FinBala", "OutBala", "InBala" };

            return source.ConvertDataTable(strs);
        }
示例#5
0
文件: FundsBLL.cs 项目: weiliji/NFMT
        //public override string[,] SetExcelRangeData(DataTable source)
        //{
        //    string[,] objData = new string[source.Rows.Count, 10];
        //    for (int i = 0; i < source.Rows.Count; i++)
        //    {
        //        System.Data.DataRow dr = source.Rows[i];
        //        objData[i, 0] = dr["bgDate"].ToString();
        //        objData[i, 1] = dr["endDate"].ToString();
        //        objData[i, 2] = dr["outCorpName"].ToString();
        //        objData[i, 3] = dr["CurrencyName"].ToString();
        //        objData[i, 4] = dr["PreBala"].ToString();
        //        objData[i, 5] = dr["LastIssueBala"].ToString();
        //        objData[i, 6] = dr["LastCashInBala"].ToString();
        //        objData[i, 7] = dr["LastCollectBala"].ToString();
        //        objData[i, 8] = dr["LastPayBala"].ToString();
        //        objData[i, 9] = dr["LastBala"].ToString();
        //    }
        //    return objData;
        //}
        public override DataTable SetExcelRangeData(DataTable source)
        {
            string[] strs = new string[] { "bgDate", "endDate", "outCorpName", "CurrencyName", "PreBala", "LastIssueBala", "LastCashInBala", "LastCollectBala", "LastPayBala", "LastBala" };

            return source.ConvertDataTable(strs);
        }
示例#6
0
        //public override string[,] SetExcelRangeData(DataTable source)
        //{
        //    string[,] objData = new string[source.Rows.Count, 9];
        //    for (int i = 0; i < source.Rows.Count; i++)
        //    {
        //        System.Data.DataRow dr = source.Rows[i];
        //        objData[i, 0] = dr["BankName"].ToString();
        //        objData[i, 1] = dr["RefNo"].ToString();
        //        objData[i, 2] = dr["NetAmount"].ToString();
        //        objData[i, 3] = dr["ContractNo"].ToString();
        //        objData[i, 4] = ((DateTime)dr["ApplyTime"]).ToString("yyyy-MM-dd");
        //        objData[i, 5] = dr["Hands"].ToString();
        //        objData[i, 6] = dr["Price"].ToString();
        //        objData[i, 7] = ((DateTime)dr["ExpiringDate"]).ToString("yyyy-MM-dd");
        //        objData[i, 8] = dr["nowPledgeAmount"].ToString();
        //    }
        //    return objData;
        //}
        public override DataTable SetExcelRangeData(DataTable source)
        {
            string[] strs = new string[] { "BankName", "RefNo", "NetAmount", "ContractNo", "ApplyTime", "Hands", "Price", "ExpiringDate", "nowPledgeAmount" };

            return source.ConvertDataTable(strs);

            //dt.Columns.Add(source.Columns["BankName"]);
            //dt.Columns.Add(source.Columns["RefNo"]);
            //dt.Columns.Add(source.Columns["NetAmount"]);
            //dt.Columns.Add(source.Columns["ContractNo"]);
            //dt.Columns.Add(source.Columns["ApplyTime"]);
            //dt.Columns.Add(source.Columns["Hands"]);
            //dt.Columns.Add(source.Columns["Price"]);
            //dt.Columns.Add(source.Columns["ExpiringDate"]);
            //dt.Columns.Add(source.Columns["nowPledgeAmount"]);

            //return dt;
        }
示例#7
0
        //public override string[,] SetExcelRangeData(DataTable source)
        //{
        //    string[,] objData = new string[source.Rows.Count, 17];
        //    for (int i = 0; i < source.Rows.Count; i++)
        //    {
        //        System.Data.DataRow dr = source.Rows[i];
        //        objData[i, 0] = dr["PricingId"].ToString();
        //        objData[i, 1] = dr["ContractNo"].ToString();
        //        objData[i, 2] = dr["OutContractNo"].ToString();
        //        objData[i, 3] = dr["CorpName"].ToString();
        //        objData[i, 4] = dr["AssetName"].ToString();
        //        objData[i, 5] = dr["TradeCode"].ToString();
        //        objData[i, 6] = dr["ExchangeCode"].ToString();
        //        objData[i, 7] = dr["CurrencyName"].ToString();
        //        objData[i, 8] = dr["TurnoverHand"].ToString();
        //        objData[i, 9] = dr["Turnover"].ToString();
        //        objData[i, 10] = dr["PricingStyle"].ToString();
        //        objData[i, 11] = dr["SpotQP"].ToString();
        //        objData[i, 12] = dr["Spread"].ToString();
        //        objData[i, 13] = dr["Premium"].ToString();
        //        objData[i, 14] = dr["DelayFee"].ToString();
        //        objData[i, 15] = dr["OtherFee"].ToString();
        //        objData[i, 16] = dr["FinalPrice"].ToString();
        //    }
        //    return objData;
        //}
        public override DataTable SetExcelRangeData(DataTable source)
        {
            string[] strs = new string[] { "PricingId", "ContractNo", "OutContractNo", "CorpName", "AssetName", "TradeCode", "ExchangeCode", "CurrencyName", "TurnoverHand", "Turnover", "PricingStyle", "SpotQP", "Spread", "Premium", "DelayFee", "OtherFee", "FinalPrice" };

            return source.ConvertDataTable(strs);
        }
示例#8
0
        //public override string[,] SetExcelRangeData(DataTable source)
        //{
        //    string[,] objData = new string[source.Rows.Count, 9];
        //    for (int i = 0; i < source.Rows.Count; i++)
        //    {
        //        System.Data.DataRow dr = source.Rows[i];
        //        objData[i, 0] = dr["PledgeApplyNo"].ToString();
        //        objData[i, 1] = ((DateTime)dr["ApplyTime"]).ToString("yyyy-MM-dd");
        //        objData[i, 2] = dr["BankName"].ToString();
        //        objData[i, 3] = dr["AccountNo"].ToString();
        //        objData[i, 4] = dr["AssetName"].ToString();
        //        //objData[i, 5] = dr["SwitchBack"].ToString();
        //        objData[i, 5] = dr["SumNetAmount"].ToString();
        //        objData[i, 6] = dr["SumHands"].ToString();
        //        objData[i, 7] = dr["NodeName"].ToString();
        //        objData[i, 8] = dr["StatusName"].ToString();
        //    }
        //    return objData;
        //}
        public override DataTable SetExcelRangeData(DataTable source)
        {
            string[] strs = new string[] { "PledgeApplyNo", "ApplyTime", "BankName", "AccountNo", "AssetName", "SumNetAmount", "SumHands", "NodeName", "StatusName" };

            return source.ConvertDataTable(strs);
        }
示例#9
0
        //public override string[,] SetExcelRangeData(DataTable source)
        //{
        //    string[,] objData = new string[source.Rows.Count, 12];
        //    for (int i = 0; i < source.Rows.Count; i++)
        //    {
        //        System.Data.DataRow dr = source.Rows[i];
        //        objData[i, 0] = ((DateTime)dr["LogDate"]).ToString("yyyy-MM-dd");
        //        objData[i, 1] = dr["LogTypeName"].ToString();
        //        objData[i, 2] = dr["InCorpName"].ToString();
        //        objData[i, 3] = dr["InBankName"].ToString();
        //        objData[i, 4] = dr["InAccountNo"].ToString();
        //        objData[i, 5] = dr["OutCorpName"].ToString();
        //        objData[i, 6] = dr["OutBankName"].ToString();
        //        objData[i, 7] = dr["OutAccountNo"].ToString();
        //        objData[i, 8] = dr["PayModeName"].ToString();
        //        objData[i, 9] = dr["FundsBala"].ToString();
        //        objData[i, 10] = dr["CurrencyName"].ToString();
        //        objData[i, 11] = dr["IsVirtualPay"].ToString();
        //    }
        //    return objData;
        //}
        public override DataTable SetExcelRangeData(DataTable source)
        {
            string[] strs = new string[] { "LogDate", "LogTypeName", "InCorpName", "InBankName", "InAccountNo", "OutCorpName", "OutBankName", "OutAccountNo", "PayModeName", "FundsBala", "CurrencyName", "IsVirtualPay" };

            return source.ConvertDataTable(strs);
        }
示例#10
0
        //public override string[,] SetExcelRangeData(DataTable source)
        //{
        //    string[,] objData = new string[source.Rows.Count, 15];
        //    for (int i = 0; i < source.Rows.Count; i++)
        //    {
        //        System.Data.DataRow dr = source.Rows[i];
        //        objData[i, 0] = ((DateTime)dr["StockDate"]).ToString("yyyy-MM-dd");
        //        objData[i, 1] = dr["RefNo"].ToString();
        //        objData[i, 2] = dr["AssetName"].ToString();
        //        objData[i, 3] = dr["BrandName"].ToString();
        //        objData[i, 4] = dr["DPName"].ToString();
        //        objData[i, 5] = dr["CardNo"].ToString();
        //        objData[i, 6] = dr["InBalaOutCorpName"].ToString();
        //        objData[i, 7] = dr["InBalaInCorpName"].ToString();
        //        objData[i, 8] = dr["InBala"].ToString();
        //        objData[i, 9] = dr["OutBalaInCorpName"].ToString();
        //        objData[i, 10] = dr["OutBalaOutCorpName"].ToString();
        //        objData[i, 11] = dr["OutBala"].ToString();
        //        objData[i, 12] = dr["SIBala"].ToString();
        //        objData[i, 13] = dr["ProfitBala"].ToString();
        //        objData[i, 14] = dr["CurrencyName"].ToString();
        //    }
        //    return objData;
        //}
        public override DataTable SetExcelRangeData(DataTable source)
        {
            string[] strs = new string[] { "StockDate", "RefNo", "AssetName", "BrandName", "DPName", "CardNo", "InBalaOutCorpName", "InBalaInCorpName", "InBala", "OutBalaInCorpName", "OutBalaOutCorpName", "OutBala", "SIBala", "ProfitBala", "CurrencyName" };

            return source.ConvertDataTable(strs);
        }
示例#11
0
        //public override string[,] SetExcelRangeData(DataTable source)
        //{
        //    string[,] objData = new string[source.Rows.Count, 13];
        //    for (int i = 0; i < source.Rows.Count; i++)
        //    {
        //        System.Data.DataRow dr = source.Rows[i];
        //        objData[i, 0] = ((DateTime)dr["InvoiceDate"]).ToString("yyyy-MM-dd");
        //        objData[i, 1] = dr["InvoiceNo"].ToString();
        //        objData[i, 2] = dr["InvoiceName"].ToString();
        //        objData[i, 3] = dr["innerCorp"].ToString();
        //        objData[i, 4] = dr["outerCorp"].ToString();
        //        objData[i, 5] = dr["InvoiceDirection"].ToString();
        //        objData[i, 6] = dr["InvoiceType"].ToString();
        //        objData[i, 7] = dr["AssetName"].ToString();
        //        objData[i, 8] = dr["NetAmount"].ToString();
        //        objData[i, 9] = dr["MUName"].ToString();
        //        objData[i, 10] = dr["Bala"].ToString();
        //        objData[i, 11] = dr["CurrencyName"].ToString();
        //        objData[i, 12] = dr["RefNo"].ToString();
        //    }
        //    return objData;
        //}
        public override DataTable SetExcelRangeData(DataTable source)
        {
            string[] strs = new string[] { "InvoiceDate", "InvoiceNo", "InvoiceName", "innerCorp", "outerCorp", "InvoiceDirection", "InvoiceType", "AssetName", "NetAmount", "MUName", "Bala", "CurrencyName", "RefNo" };

            return source.ConvertDataTable(strs);
        }