protected void init()
{
string action = Request.Form["Action"].ToString();
string str0 = Request.Form["BuyOrderID"].ToString();
if (action.Equals("add"))
{
string str1 = Request.Form["ProductsID"].ToString();
string str2 = Request.Form["SupplierID"].ToString();
string str3 = Request.Form["Quantity"].ToString();
string str4 = Request.Form["TaxRate"].ToString();
string str5 = Request.Form["DiscountRate"].ToString();
string str6 = Request.Form["Descriptions"].ToString();
string str7 = Request.Form["Price"].ToString();
BuyOrderDetail b = new BuyOrderDetail();
b.BuyOrderID = str0;
b.ProductsID = int.Parse(str1);
b.SupplierID = int.Parse(str2);
b.Quantity = int.Parse(str3);
b.TaxRate = float.Parse(str4);
b.DiscountRate = float.Parse(str5);
b.Description = str6;
b.Price = float.Parse(str7);
if (Leyp.SQLServerDAL.Buy.Factory.getBuyOrderDetailDAL().insertNewEitity(b))
{
respAjax(str0);
}
else
{
respAjax(str0);
}
}
else if (action.Equals("del"))
{
string detailid = Request.Form["DetailID"].ToString();
Leyp.SQLServerDAL.Buy.Factory.getBuyOrderDetailDAL().deleteEitity(int.Parse(detailid));//delete
respAjax(str0);
}
else if (action.Equals("load"))
{
string BuyOrderID = Request.Form["BuyOrderID"].ToString();
respAjax(BuyOrderID);
}
else if (action.Equals("loadDetail"))
{
string BuyOrderID = Request.Form["BuyOrderID"].ToString();
respAjaxforDetail(BuyOrderID);
}
}
public bool updateEitity(BuyOrderDetail b)
{
int rowsAffected = 0;
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@DetailID", SqlDbType.Int), new SqlParameter("@ProductsID", SqlDbType.Int), new SqlParameter("@SupplierID", SqlDbType.Int), new SqlParameter("@Quantity", SqlDbType.Int), new SqlParameter("@Price", SqlDbType.Money), new SqlParameter("@TaxRate", SqlDbType.Float), new SqlParameter("@DiscountRate", SqlDbType.Float), new SqlParameter("@Description", SqlDbType.NVarChar) };
parameters[0].Value = b.DetailID;
parameters[1].Value = b.ProductsID;
parameters[2].Value = b.SupplierID;
parameters[3].Value = b.Quantity;
parameters[4].Value = b.Price;
parameters[5].Value = b.TaxRate;
parameters[6].Value = b.DiscountRate;
parameters[7].Value = b.Description;
SQLHelper.RunProcedure("p_BuyOrderDetail_updateEitity", parameters, out rowsAffected);
return(1 == rowsAffected);
}
public bool insertNewEntity(BuyReceipt b)
{
int rowsAffected = 0;
float num2 = float.Parse("0.00");
if (b.Identitys == 0)
{
BuyReceiptDetailDAL ldal = new BuyReceiptDetailDAL();
List <VBuyOrderDetail> list = new List <VBuyOrderDetail>();
list = new BuyOrderDetailDAL().getBuyOrderDetailByBuyOrderID(b.BuyOrderID);
for (int i = 0; i < list.Count; i++)
{
BuyReceiptDetail detail = new BuyReceiptDetail();
BuyOrderDetail detail2 = list[i];
detail.Description = detail2.Description;
detail.DiscountRate = detail2.DiscountRate;
detail.Price = detail2.Price;
detail.ProductsID = detail2.ProductsID;
detail.Quantity = detail2.Quantity;
detail.SupplierID = detail2.SupplierID;
detail.TaxRate = detail2.TaxRate;
detail.ReceiptOrderID = b.ReceiptOrderID;
ldal.insertNewEitity(detail);
num2 += (((detail.Quantity * detail.Price) * (100f + detail.TaxRate)) / 100f) - (((detail.Quantity * detail.Price) * detail.DiscountRate) / 100f);
}
}
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ReceiptOrderID", SqlDbType.NVarChar), new SqlParameter("@ReceiptOrderDate", SqlDbType.NVarChar), new SqlParameter("@StoreHouseID", SqlDbType.Int), new SqlParameter("@HouseDetailID", SqlDbType.Int), new SqlParameter("@BuyOrderID", 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.ReceiptOrderID;
parameters[1].Value = b.ReceiptOrderDate;
parameters[2].Value = b.StoreHouseID;
parameters[3].Value = b.HouseDetailID;
parameters[4].Value = b.BuyOrderID;
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_BuyReceipt_insertNewEntity", parameters, out rowsAffected);
return(0 < rowsAffected);
}
