示例#1
0
        public bool insertNewEitity(BuyReturnDetail b)
        {
            int rowsAffected = 0;

            SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@BuyReturnID", SqlDbType.NVarChar), new SqlParameter("@ProductsID", SqlDbType.Int), new SqlParameter("@SupplierID", SqlDbType.Int), new SqlParameter("@Quantity", SqlDbType.Int), new SqlParameter("@Price", SqlDbType.Money), new SqlParameter("@Description", SqlDbType.NVarChar) };
            parameters[0].Value = b.BuyReturnID;
            parameters[1].Value = b.ProductsID;
            parameters[2].Value = b.SupplierID;
            parameters[3].Value = b.Quantity;
            parameters[4].Value = b.Price;
            parameters[5].Value = b.Description;
            SQLHelper.RunProcedure("p_BuyReturnDetail_insertNewEntity", parameters, out rowsAffected);
            return(1 == rowsAffected);
        }
示例#2
0
        public bool AuditingBuyReturnOrder(string BuyReturnID)
        {
            bool flag = false;

            try
            {
                List <VBuyReturnDetail> list = new List <VBuyReturnDetail>();
                ProductsStockDAL        kdal = new ProductsStockDAL();
                BuyReturn return2            = new BuyReturnDAL().getByID(BuyReturnID);
                if (return2 == null)
                {
                    return(false);
                }
                list = new BuyReturnDetailDAL().getBuyReturnDetailByBuyReturnID(BuyReturnID);
                for (int i = 0; i < list.Count; i++)
                {
                    ProductsStock   stock;
                    BuyReturnDetail detail = list[i];
                    if (kdal.isHaveEitity(return2.HouseDetailID, detail.ProductsID))
                    {
                        stock = new ProductsStock();
                        stock.HouseDetailID = return2.HouseDetailID;
                        stock.ProductsID    = detail.ProductsID;
                        stock.Num           = detail.Quantity;
                        kdal.updateCutNum(stock);
                    }
                    else
                    {
                        stock = new ProductsStock();
                        stock.HouseDetailID = return2.HouseDetailID;
                        stock.ProductsID    = detail.ProductsID;
                        stock.Num           = -detail.Quantity;
                        kdal.insertNewEitity(stock);
                    }
                }
                flag = true;
            }
            catch
            {
            }
            return(flag);
        }
示例#3
0
文件: BuyReturnDAL.cs 项目: cfmis/cfw
        public bool insertNewEntity(BuyReturn b)
        {
            int   rowsAffected = 0;
            float num2         = float.Parse("0.00");

            if (b.Identitys == 0)
            {
                BuyReturnDetailDAL       ldal = new BuyReturnDetailDAL();
                List <VBuyReceiptDetail> list = new List <VBuyReceiptDetail>();
                list = new BuyReceiptDetailDAL().getBuyReceiptDetailByReceiptOrderID(b.ReceiptOrderID);
                for (int i = 0; i < list.Count; i++)
                {
                    BuyReturnDetail   detail  = new BuyReturnDetail();
                    VBuyReceiptDetail detail2 = list[i];
                    detail.Description = detail2.Description;
                    detail.Price       = detail2.Price;
                    detail.ProductsID  = detail2.ProductsID;
                    detail.Quantity    = detail2.Quantity;
                    detail.SupplierID  = detail2.SupplierID;
                    detail.BuyReturnID = b.BuyReturnID;
                    ldal.insertNewEitity(detail);
                    num2 += detail.Quantity * detail.Price;
                }
            }
            SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@BuyReturnID", SqlDbType.NVarChar), new SqlParameter("@BuyReturnDate", SqlDbType.NVarChar), new SqlParameter("@StoreHouseID", SqlDbType.Int), new SqlParameter("@HouseDetailID", SqlDbType.Int), new SqlParameter("@ReceiptOrderID", SqlDbType.NVarChar), new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@TotalPrice", SqlDbType.Money), new SqlParameter("@TradeDate", SqlDbType.NVarChar), new SqlParameter("@Identitys", SqlDbType.Int), new SqlParameter("@AlreadyPay", SqlDbType.Money), new SqlParameter("@Description", SqlDbType.NVarChar), new SqlParameter("@State", SqlDbType.Int) };
            parameters[0].Value  = b.BuyReturnID;
            parameters[1].Value  = b.BuyReturnDate;
            parameters[2].Value  = b.StoreHouseID;
            parameters[3].Value  = b.HouseDetailID;
            parameters[4].Value  = b.ReceiptOrderID;
            parameters[5].Value  = b.UserName;
            parameters[6].Value  = num2;
            parameters[7].Value  = b.TradeDate;
            parameters[8].Value  = b.Identitys;
            parameters[9].Value  = b.AlreadyPay;
            parameters[10].Value = b.Description;
            parameters[11].Value = b.State;
            SQLHelper.RunProcedure("p_BuyReturn_insertNewEntity", parameters, out rowsAffected);
            return(1 == rowsAffected);
        }
    protected void init()
    {
        string action = Request.Form["action"].ToString();

        if (action.Equals("load"))
        {
            string str0 = Request.Form["BuyReturnID"].ToString();
            loadinit(str0);
        }
        else if (action.Equals("getNode"))
        {
            string str1 = Request.Form["DetailID"].ToString();
            getNode(int.Parse(str1));
        }
        else if (action.Equals("del"))
        {
            string str1 = Request.Form["DetailID"].ToString();
            deleteNode(int.Parse(str1));
        }
        else if (action.Equals("add"))
        {
            #region add
            string str0 = Request.Form["BuyReturnID"].ToString();
            string str1 = Request.Form["ProductsID"].ToString();
            string str2 = Request.Form["SupplierID"].ToString();
            string str3 = Request.Form["Quantity"].ToString();

            string          str6 = Request.Form["Descriptions"].ToString();
            string          str7 = Request.Form["Price"].ToString();
            BuyReturnDetail b    = new BuyReturnDetail();
            b.BuyReturnID = str0;
            b.ProductsID  = int.Parse(str1);
            b.SupplierID  = int.Parse(str2);
            b.Quantity    = int.Parse(str3);
            b.Description = str6;
            b.Price       = float.Parse(str7);
            if (Leyp.SQLServerDAL.Buy.Factory.getBuyReturnDetailDAL().insertNewEitity(b))
            {
                Response.Write("添加成功");
                Response.End();
            }
            else
            {
                Response.Write("添加失败");
                Response.End();
            }
            #endregion
        }
        else if (action.Equals("edit"))
        {
            #region
            string          str  = Request.Form["DetailID"].ToString();
            string          str0 = Request.Form["BuyReturnID"].ToString();
            string          str1 = Request.Form["ProductsID"].ToString();
            string          str2 = Request.Form["SupplierID"].ToString();
            string          str3 = Request.Form["Quantity"].ToString();
            string          str6 = Request.Form["Descriptions"].ToString();
            string          str7 = Request.Form["Price"].ToString();
            BuyReturnDetail b    = new BuyReturnDetail();
            b.DetailID    = int.Parse(str);
            b.BuyReturnID = str0;
            b.ProductsID  = int.Parse(str1);
            b.SupplierID  = int.Parse(str2);
            b.Quantity    = int.Parse(str3);
            b.Description = str6;
            b.Price       = float.Parse(str7);
            if (Leyp.SQLServerDAL.Buy.Factory.getBuyReturnDetailDAL().updateEitity(b))
            {
                Response.Write("修改成功");
                Response.End();
            }
            else
            {
                Response.Write("修改失败");
                Response.End();
            }

            #endregion
        }
    }