Beispiel #1
0
        public string DoSalesItemDelete(DsInventory.SALESINVDETAILRow dr)
        {
            SqlTransaction tran = null;
            var retval = "0";
            try
            {
                var cn = new SqlConnection(_constr);
                cn.Open();
                tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);
                var dt = new DsInventory.SALESINVDETAIL_DELDataTable();

                var tastock = new DsInventoryTableAdapters.STOCKMASTERTableAdapter();
                var tasalede = new DsInventoryTableAdapters.SALESINVDETAIL_DELTableAdapter();
               // var tasales = new DsInventoryTableAdapters.SALESINVDETAILTableAdapter();


                tastock.AssignConnection(cn, tran);
                tasalede.AssignConnection(cn, tran);
              //  tasales.AssignConnection(cn,tran);

                var dr1 = (DsInventory.SALESINVDETAIL_DELRow)dt.NewRow();
                dr1.SINVNO = dr.SINVNO;
                dr1.ITEMNO = dr.ITEMNO;
                dr1.BARCODE = dr.BARCODE;
                dr1.QTY = dr.QTY;
                dr1.INVRATE = dr.INVRATE;
                dr1.SPRICE = dr.SPRICE;
                dr1.CPRICE = dr.CPRICE;
                if (!dr.IsEXPDATENull())
                    dr1.EXPDATE = dr.EXPDATE;
                dr1.STOCKID = dr.STOCKID;
                dr1.STOCK = dr.STOCK;
                dr1.DOCTORID = dr.DOCTORID;
                dr1.ITEMNAME = dr.ITEMNAME;
                dr1.COMPANY = Utils.Company;
                dr1.TRANDATE = DateTime.Now;
                dr1.USERID = Utils.Userid;
                dr1.ISRETURN = dr.ISRETURN;
                dt.Rows.Add(dr1);
                //tasalede.Insert(dr.SINVNO, dr.ITEMNO, dr.BARCODE, dr.QTY, dr.INVRATE, dr.SPRICE, dr.CPRICE, dr.EXPDATE,
                //                dr.STOCKID, dr.STOCK, dr.DOCTORID, dr.ITEMNAME, Utils.Company, DateTime.Now, Utils.Userid,dr.ISRETURN);
                tasalede.Update(dr1);
                if (dr.STOCKID > 0)
                {
                   if(dr.ISRETURN)
                        tastock.UpdateSaleQtyByStockid((-1* dr.QTY), dr.STOCKID);
                    else
                        tastock.UpdateSaleQtyByStockid(dr.QTY, dr.STOCKID);
                }
               // tasales.Update(salesinvdetail);
                
                tran.Commit();
                retval = "1";
            }
            catch (Exception ex)
            {
                retval = ex.ToString();
                tran.Rollback();
            }
            return retval;
        }
Beispiel #2
0
        public void DoSalesItemDelete(DsInventory.SALESINVDETAILRow dRow, ref SqlConnection cn, ref SqlTransaction tran)
        {
        // tran = cn.BeginTransaction(IsolationLevel.ReadUncommitted);

            var dt = new DsInventory.SALESINVDETAIL_DELDataTable();
            var tastock = new DsInventoryTableAdapters.STOCKMASTERTableAdapter();
            var tasalede = new DsInventoryTableAdapters.SALESINVDETAIL_DELTableAdapter();
            tastock.AssignConnection(cn, tran);
            tasalede.AssignConnection(cn, tran);
            var dr = (DsInventory.SALESINVDETAIL_DELRow) dt.NewRow();
            dr.SINVNO = dRow.SINVNO;
            dr.ITEMNO = dRow.ITEMNO;
            dr.BARCODE = dRow.BARCODE;
            dr.QTY = dRow.QTY;
            dr.INVRATE = dRow.INVRATE;
            dr.SPRICE = dRow.SPRICE;
            dr.CPRICE = dRow.CPRICE;
            if(!dRow.IsEXPDATENull())
                dr.EXPDATE =  dRow.EXPDATE;
            dr.STOCKID = dRow.STOCKID;
            dr.STOCK = dRow.STOCK;
            dr.DOCTORID = dRow.DOCTORID;
            dr.ITEMNAME = dRow.ITEMNAME;
            dr.COMPANY = Utils.Company;
            dr.TRANDATE = DateTime.Now;
            dr.USERID = Utils.Userid;
            tasalede.Update(dr);
            if (dr.STOCKID > 0)
            {
                if (dr.ISRETURN)
                    tastock.UpdateSaleQtyByStockid(-dr.QTY, dr.STOCKID);
                else
                    tastock.UpdateSaleQtyByStockid(dr.QTY, dr.STOCKID);
            }
            //if (dRow.STOCKID > 0)
            //{
            //   // tastock.UpdateQtyByStockID(dRow.QTY, dRow.STOCKID);
            //    tastock.UpdateSaleQtyByStockid(dRow.QTY, dRow.STOCKID);
            //}
        }