Esempio n. 1
0
        public void AddNewItemwithNegativeQty(DataRow d)
        {
            string wh = Utils.SalesStoreCode;
            const string storetype = "S";
            var ds = new DsInventory().STOCKMASTER;
            var ta = new DsInventoryTableAdapters.STOCKMASTERTableAdapter { Connection = { ConnectionString = _constr } };
            //ta.FillByItemNo(ds, d["ITEMNO"].ToString(), "S", Utils.Company);
            ta.FillByItemNoAll(ds, d["ITEMNO"].ToString(), Utils.Company);

            if (ds.Rows.Count > 0)
            {
                foreach (DsInventory.STOCKMASTERRow dr in ds.Rows)
                {
                    if (dr.SPRICE == decimal.Parse(d["SPRICE"].ToString()))
                    {
                        ta.UpdateSaleQtyByStockid(-int.Parse(d["DQNTY"].ToString()), dr.STOCKID);
                        return;
                    }
                }
            }
             ta.Insert(d["ITEMNO"].ToString(),
                       d["BARCODE"].ToString(),
                       0,
                      decimal.Parse(d["SPRICE"].ToString()),
                      decimal.Parse(d["CPRICE"].ToString()),
                      null, storetype, null, null, null, false, wh, Utils.Company, -int.Parse(d["DQNTY"].ToString()),null);
        }