示例#1
0
        /// <summary>
        ///  Create records to keep stock transaction (buy,sell...)
        ///  - transactions
        ///  - investorStock
        /// </summary>
        /// <param name="onDate"></param>
        /// <param name="type"></param>
        /// <param name="stockCode"></param>
        /// <param name="portfolio"></param>
        /// <param name="qty"></param>
        /// <param name="amt"></param>
        public static databases.baseDS.transactionsDataTable MakeTransaction(AppTypes.TradeActions type, string stockCode, string portfolioCode, int qty, decimal feePerc, out string errorText)
        {
            errorText = "";
            databases.baseDS.stockExchangeRow marketRow = databases.DbAccess.GetStockExchange(stockCode);
            if (marketRow == null)
            {
                return(null);
            }

            errorText = "";
            DateTime onTime = DateTime.Now;

            //Price
            databases.baseDS.priceDataRow priceRow = databases.DbAccess.GetLastPriceData(stockCode);
            if (priceRow == null)
            {
                errorText = Languages.Libs.GetString("cannotDoTransaction");
                return(null);
            }
            decimal amt    = qty * priceRow.closePrice * marketRow.priceRatio;
            decimal feeAmt = (decimal)Math.Round(feePerc * amt / 100, common.system.GetPrecisionFromMask(Settings.sysMaskLocalAmt));

            databases.baseDS.portfolioRow portfolioRow = databases.DbAccess.GetPortfolio(portfolioCode);
            if (portfolioRow == null)
            {
                errorText = String.Format(Languages.Libs.GetString("dataNotFound"), "[portfolio]");
                return(null);
            }
            switch (type)
            {
            case AppTypes.TradeActions.Buy:
            case AppTypes.TradeActions.Accumulate:
                portfolioRow.usedCapAmt += amt;
                portfolioRow.usedCapAmt += feeAmt;
                break;

            default:     //Sell
                portfolioRow.usedCapAmt -= amt;
                portfolioRow.usedCapAmt += feeAmt;
                break;
            }
            if (portfolioRow.startCapAmt - portfolioRow.usedCapAmt < 0)
            {
                portfolioRow.CancelEdit();
                errorText = String.Format(Languages.Libs.GetString("outOfMoney"), portfolioRow.startCapAmt - portfolioRow.usedCapAmt - amt - feeAmt);
                return(null);
            }

            //Create records to store data
            databases.baseDS.transactionsDataTable  transTbl         = new databases.baseDS.transactionsDataTable();
            databases.baseDS.investorStockDataTable investorStockTbl = new databases.baseDS.investorStockDataTable();
            databases.baseDS.transactionsRow        transRow;
            databases.baseDS.investorStockRow       stockRow;

            transRow = transTbl.NewtransactionsRow();
            databases.AppLibs.InitData(transRow);
            transRow.onTime    = onTime;
            transRow.tranType  = (byte)type;
            transRow.stockCode = stockCode;
            transRow.portfolio = portfolioCode;
            transRow.qty       = qty;
            transRow.amt       = amt;
            transRow.feeAmt    = feeAmt;
            transRow.status    = (byte)AppTypes.CommonStatus.Close;
            transTbl.AddtransactionsRow(transRow);

            //Update stock
            DateTime onDate = onTime.Date;

            switch (type)
            {
            case AppTypes.TradeActions.Buy:
            case AppTypes.TradeActions.Accumulate:
                investorStockTbl.Clear();
                databases.DbAccess.LoadData(investorStockTbl, stockCode, portfolioCode, onDate);
                if (investorStockTbl.Count == 0)
                {
                    stockRow = investorStockTbl.NewinvestorStockRow();
                    databases.AppLibs.InitData(stockRow);
                    stockRow.buyDate   = onDate;
                    stockRow.stockCode = stockCode;
                    stockRow.portfolio = portfolioCode;
                    investorStockTbl.AddinvestorStockRow(stockRow);
                }
                stockRow      = investorStockTbl[0];
                stockRow.qty += qty; stockRow.buyAmt += amt;
                break;

            default:     //Sell
                DateTime applicableDate = onDate.AddDays(-marketRow.minBuySellDay);
                investorStockTbl.Clear();
                databases.DbAccess.LoadData(investorStockTbl, stockCode, portfolioCode);
                decimal remainQty = qty;
                for (int idx = 0; idx < investorStockTbl.Count; idx++)
                {
                    if (investorStockTbl[idx].buyDate > applicableDate)
                    {
                        continue;
                    }
                    if (investorStockTbl[idx].qty >= remainQty)
                    {
                        investorStockTbl[idx].buyAmt = (investorStockTbl[idx].qty - remainQty) * (investorStockTbl[idx].qty == 0 ? 0 : investorStockTbl[idx].buyAmt / investorStockTbl[idx].qty);
                        investorStockTbl[idx].qty    = (investorStockTbl[idx].qty - remainQty);
                        remainQty = 0;
                    }
                    else
                    {
                        remainQty -= investorStockTbl[idx].qty;
                        investorStockTbl[idx].buyAmt = 0;
                        investorStockTbl[idx].qty    = 0;
                    }
                    if (remainQty == 0)
                    {
                        break;
                    }
                }
                if (remainQty > 0)
                {
                    errorText = String.Format(Languages.Libs.GetString("outOfQty"), qty - remainQty);
                    return(null);
                }
                break;
            }
            //Delete empty stock
            for (int idx = 0; idx < investorStockTbl.Count; idx++)
            {
                if (investorStockTbl[idx].qty != 0)
                {
                    continue;
                }
                investorStockTbl[idx].Delete();
            }

            //Update data with transaction support
            TransactionScopeOption tranOption;

            tranOption = (commonClass.SysLibs.sysUseTransactionInUpdate ? TransactionScopeOption.Required : TransactionScopeOption.Suppress);
            using (TransactionScope scope = new TransactionScope(tranOption))
            {
                databases.DbAccess.UpdateData(portfolioRow);
                databases.DbAccess.UpdateData(investorStockTbl);
                databases.DbAccess.UpdateData(transTbl);
                scope.Complete();
            }
            return(transTbl);
        }
示例#2
0
 public static databases.baseDS.investorStockRow UpdateData(databases.baseDS.investorStockRow row)
 {
     try
     {
         lock (myClient)
         {
             databases.baseDS.investorStockDataTable tbl = new databases.baseDS.investorStockDataTable();
             tbl.ImportRow(row);
             myClient.UpdateInvestorStock(ref tbl);
             row.AcceptChanges();
             return tbl[0];
         }
     }
     catch (Exception er)
     {
         if (OnError != null) OnError(er);
     }
     return null;
 }
 public databases.baseDS.investorStockDataTable GetOwnedStock_ByPortfolio(string portfolioCode)
 {
     try
     {
         databases.baseDS.investorStockDataTable tbl = new databases.baseDS.investorStockDataTable();
         databases.DbAccess.LoadData(tbl, portfolioCode);
         return tbl;
     }
     catch (Exception ex)
     {
         WriteSysLogLocal("WS036", ex);
     }
     return null;
 }
示例#4
0
 public bool UpdateInvestorStock(ref databases.baseDS.investorStockDataTable investorStockTbl)
 {
     return(base.Channel.UpdateInvestorStock(ref investorStockTbl));
 }
示例#5
0
        /// <summary>
        ///  Create records to keep stock transaction (buy,sell...) 
        ///  - transactions
        ///  - investorStock
        /// </summary>
        /// <param name="onDate"></param>
        /// <param name="type"></param>
        /// <param name="stockCode"></param>
        /// <param name="portfolio"></param>
        /// <param name="qty"></param>
        /// <param name="amt"></param>
        public static databases.baseDS.transactionsDataTable MakeTransaction(AppTypes.TradeActions type, string stockCode, string portfolioCode, int qty, decimal feePerc,out string errorText)
        {
            errorText="";
            databases.baseDS.stockExchangeRow marketRow = databases.DbAccess.GetStockExchange(stockCode);
            if (marketRow == null) return null;

            errorText="";
            DateTime onTime = DateTime.Now;
            //Price
            databases.baseDS.priceDataRow priceRow = databases.DbAccess.GetLastPriceData(stockCode);
            if (priceRow == null)
            {
                errorText = Languages.Libs.GetString("cannotDoTransaction");
                return null;
            }
            decimal amt = qty * priceRow.closePrice * marketRow.priceRatio;
            decimal feeAmt = (decimal)Math.Round(feePerc * amt / 100, common.system.GetPrecisionFromMask(Settings.sysMaskLocalAmt));

            databases.baseDS.portfolioRow portfolioRow = databases.DbAccess.GetPortfolio(portfolioCode);
            if (portfolioRow == null)
            {
                errorText = String.Format(Languages.Libs.GetString("dataNotFound"), "[portfolio]");
                return null;
            }
            switch (type)
            {
                case AppTypes.TradeActions.Buy:
                case AppTypes.TradeActions.Accumulate:
                    portfolioRow.usedCapAmt += amt;
                    portfolioRow.usedCapAmt += feeAmt;
                    break;
                default: //Sell
                    portfolioRow.usedCapAmt -= amt;
                    portfolioRow.usedCapAmt += feeAmt;
                    break;
            }
            if (portfolioRow.startCapAmt - portfolioRow.usedCapAmt < 0)
            {
                portfolioRow.CancelEdit();
                errorText = String.Format(Languages.Libs.GetString("outOfMoney"), portfolioRow.startCapAmt - portfolioRow.usedCapAmt - amt - feeAmt);
                return null;
            }

            //Create records to store data 
            databases.baseDS.transactionsDataTable transTbl = new databases.baseDS.transactionsDataTable();
            databases.baseDS.investorStockDataTable investorStockTbl = new databases.baseDS.investorStockDataTable();
            databases.baseDS.transactionsRow transRow;
            databases.baseDS.investorStockRow stockRow;

            transRow = transTbl.NewtransactionsRow();
            databases.AppLibs.InitData(transRow);
            transRow.onTime = onTime;
            transRow.tranType = (byte)type;
            transRow.stockCode = stockCode;
            transRow.portfolio = portfolioCode;
            transRow.qty = qty;
            transRow.amt = amt;
            transRow.feeAmt = feeAmt;
            transRow.status = (byte)AppTypes.CommonStatus.Close;
            transTbl.AddtransactionsRow(transRow);

            //Update stock
            DateTime onDate = onTime.Date;
            switch (type)
            {
                case AppTypes.TradeActions.Buy:
                case AppTypes.TradeActions.Accumulate:
                    investorStockTbl.Clear();
                    databases.DbAccess.LoadData(investorStockTbl, stockCode, portfolioCode, onDate);
                    if (investorStockTbl.Count == 0)
                    {
                        stockRow = investorStockTbl.NewinvestorStockRow();
                        databases.AppLibs.InitData(stockRow);
                        stockRow.buyDate = onDate;
                        stockRow.stockCode = stockCode;
                        stockRow.portfolio = portfolioCode;
                        investorStockTbl.AddinvestorStockRow(stockRow);
                    }
                    stockRow = investorStockTbl[0];
                    stockRow.qty += qty; stockRow.buyAmt += amt;
                    break;
                default: //Sell
                    DateTime applicableDate = onDate.AddDays(-marketRow.minBuySellDay);
                    investorStockTbl.Clear();
                    databases.DbAccess.LoadData(investorStockTbl, stockCode, portfolioCode);
                    decimal remainQty = qty;
                    for (int idx = 0; idx < investorStockTbl.Count; idx++)
                    {
                        if (investorStockTbl[idx].buyDate > applicableDate) continue;
                        if (investorStockTbl[idx].qty >= remainQty)
                        {
                            investorStockTbl[idx].buyAmt = (investorStockTbl[idx].qty - remainQty) * (investorStockTbl[idx].qty == 0 ? 0 : investorStockTbl[idx].buyAmt / investorStockTbl[idx].qty);
                            investorStockTbl[idx].qty = (investorStockTbl[idx].qty - remainQty);
                            remainQty = 0;
                        }
                        else
                        {
                            remainQty -= investorStockTbl[idx].qty;
                            investorStockTbl[idx].buyAmt = 0;
                            investorStockTbl[idx].qty = 0;
                        }
                        if (remainQty == 0) break;
                    }
                    if (remainQty > 0)
                    {
                        errorText =  String.Format(Languages.Libs.GetString("outOfQty"), qty - remainQty);
                        return null;
                    }
                    break;
            }
            //Delete empty stock
            for (int idx = 0; idx < investorStockTbl.Count; idx++)
            {
                if (investorStockTbl[idx].qty != 0) continue;
                investorStockTbl[idx].Delete();
            }

            //Update data with transaction support
            TransactionScopeOption tranOption;
            tranOption = (commonClass.SysLibs.sysUseTransactionInUpdate ? TransactionScopeOption.Required : TransactionScopeOption.Suppress);
            using (TransactionScope scope = new TransactionScope(tranOption))
            {
                databases.DbAccess.UpdateData(portfolioRow);
                databases.DbAccess.UpdateData(investorStockTbl);
                databases.DbAccess.UpdateData(transTbl);
                scope.Complete();
            }
            return transTbl;
        }