コード例 #1
0
ファイル: logSale.cs プロジェクト: lexejs/ssmanagment
        public static void GiveBack(int buyerId, int sellerId, int itemId, float itemsCount, float cash, int sid)
        {
            var db = new ssmDataContext();

            logSale sale = db.logSales.FirstOrDefault(
                b => b.buyerId == buyerId && b.sellerId == sellerId && b.sid == sid && b.isGiveBack == false);

            if (sale != null)
            {
                sale.cash       = sale.cash - cash;
                sale.itemsCount = sale.itemsCount - itemsCount;
            }

            var logSale = new logSale
            {
                buyerId    = buyerId,
                sellerId   = sellerId,
                itemId     = itemId,
                itemsCount = itemsCount,
                date       = DateTime.Now,
                isGiveBack = true,
                cash       = cash,
                sid        = sid
            };

            db.logSales.InsertOnSubmit(logSale);
            db.SubmitChanges();
        }
コード例 #2
0
ファイル: logSale.cs プロジェクト: lexejs/ssmanagment
        public static void ApproveGiveBack(int id)
        {
            ssmDataContext db  = new ssmDataContext();
            logSale        log = db.logSales.FirstOrDefault(b => b.id == id);

            if (log != null && log.isGiveBack.Value && AppHelper.CurrentUser.isAdmin.Value)
            {
                item itm = db.items.FirstOrDefault(c => c.id == log.itemId);
                if (itm != null && itm.count != null)
                {
                    log.sellerId   = AppHelper.CurrentUser.id;
                    itm.count     += log.itemsCount;
                    log.itemsCount = 0;
                    db.SubmitChanges();
                }
            }
        }
コード例 #3
0
ファイル: logSale.cs プロジェクト: lexejs/ssmanagment
        public static void Sale(int buyerId, int sellerId, int itemId, float itemsCount, decimal?cash, int sid)
        {
            var db      = new ssmDataContext();
            var logSale = new logSale
            {
                buyerId    = buyerId,
                sellerId   = sellerId,
                itemId     = itemId,
                itemsCount = itemsCount,
                date       = DateTime.Now,
                isGiveBack = false,
                cash       = (double?)cash,
                sid        = sid
            };

            db.logSales.InsertOnSubmit(logSale);
            db.items.First(i => i.id == itemId).count -= itemsCount;
            db.SubmitChanges();
        }
コード例 #4
0
 partial void DeletelogSale(logSale instance);
コード例 #5
0
 partial void UpdatelogSale(logSale instance);
コード例 #6
0
 partial void InsertlogSale(logSale instance);