protected void init()
{
string str0 = Request.QueryString["ReceiptOrderID"].ToString();
string str1 = Request.QueryString["ReceiptOrderDate"].ToString();
string str2 = Request.QueryString["StoreHouseID"].ToString();
string str3 = Request.QueryString["HouseDetailID"].ToString();
string str4 = Request.QueryString["BuyOrderID"].ToString();
string str5 = Request.QueryString["Identitys"].ToString();
string str6 = Request.QueryString["TradeDate"].ToString();
string str7 = Request.QueryString["Description"].ToString();
BuyReceipt b = new BuyReceipt();
b.BuyOrderID = str4;
b.Description = str7;
b.HouseDetailID = int.Parse(str3);
b.Identitys = int.Parse(str5);
b.ReceiptOrderDate = str1;
b.ReceiptOrderID = str0;
b.StoreHouseID = int.Parse(str2);
b.TradeDate = str6;
b.UserName = "******";
if (Leyp.SQLServerDAL.Buy.Factory.getBuyReceiptDAL().insertNewEntity(b))
{
Response.Write("0");
Response.End();
}
else
{
Response.Write("1");
Response.End();
}
}
public BuyReceipt getByID(string ReceiptOrderID)
{
string s = "";
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@ReceiptOrderID", SqlDbType.NVarChar) };
parameters[0].Value = ReceiptOrderID;
BuyReceipt receipt = new BuyReceipt();
SqlDataReader reader = SQLHelper.RunProcedure("p_BuyReceipt_getByID", parameters);
if (reader.Read())
{
receipt.ReceiptOrderDate = reader.GetString(reader.GetOrdinal("ReceiptOrderDate"));
receipt.ReceiptOrderID = reader.GetString(reader.GetOrdinal("ReceiptOrderID"));
receipt.BuyOrderID = reader.GetString(reader.GetOrdinal("BuyOrderID"));
receipt.Description = reader.GetString(reader.GetOrdinal("Description"));
receipt.HouseDetailID = reader.GetInt32(reader.GetOrdinal("HouseDetailID"));
receipt.Identitys = reader.GetInt32(reader.GetOrdinal("Identitys"));
receipt.TradeDate = reader.GetString(reader.GetOrdinal("TradeDate"));
receipt.State = reader.GetInt32(reader.GetOrdinal("State"));
s = reader.GetValue(reader.GetOrdinal("TotalPrice")).ToString();
receipt.TotalPrice = float.Parse(s);
s = reader.GetValue(reader.GetOrdinal("AlreadyPay")).ToString();
receipt.AlreadyPay = float.Parse(s);
receipt.StoreHouseID = reader.GetInt32(reader.GetOrdinal("StoreHouseID"));
receipt.UserName = reader.GetString(reader.GetOrdinal("UserName"));
}
reader.Close();
return(receipt);
}
protected void init()
{
string str0 = Request.QueryString["ReceiptOrderID"].ToString();
string username = "******";///////////////////////////////////////////////？？？
BuyReceipt b = new BuyReceipt();
b = Leyp.SQLServerDAL.Buy.Factory.getBuyReceiptDAL().getByID(str0);
if (b.UserName.Equals(username))
{
if (Leyp.SQLServerDAL.Buy.Factory.getBuyReceiptDAL().deleteEitity(str0))
{
Panel1.Visible = true;
}
else
{
Response.Write("操作失败");
Response.End();
}
}
else
{
Response.Write("操作失败!没有权限");
Response.End();
}
}
protected void init()
{
string action = Request.QueryString["action"].ToString();
if (action.Equals("shenhe"))
{
string AuditingId = Request.QueryString["AuditingId"].ToString();
StringBuilder sb = new StringBuilder();
string[] a = AuditingId.Split('#');
Leyp.SQLServerDAL.Buy.BuyReceiptDAL bl = new Leyp.SQLServerDAL.Buy.BuyReceiptDAL();
int num = 0;
for (int i = 0; i < a.Length; i++)
{
BuyReceipt b = new BuyReceipt();
b = bl.getByID(a[i]);
if (b.State == 1)//已经审核
{
sb.Append("订单号：" + a[i] + " 已经审核不能再审核 <br/>");
}
else
{
bl.AuditingBuyReceiptOrder(a[i]);
num++;
}
}
sb.Append("成功审核入库 " + num + "条 <a href=\"Manager_BuyReceipOrder.aspx\">返回列表</a>");
Response.Write(sb.ToString());
}
else if (action.Equals("delete"))
{
string AuditingId = Request.QueryString["AuditingId"].ToString();
StringBuilder sb = new StringBuilder();
string[] a = AuditingId.Split('#');
Leyp.SQLServerDAL.Buy.BuyReceiptDAL bl = new Leyp.SQLServerDAL.Buy.BuyReceiptDAL();
int num = 0;
for (int i = 0; i < a.Length; i++)
{
BuyReceipt b = new BuyReceipt();
b = bl.getByID(a[i]);
if (b.State == 1) //已经审核
{
sb.Append("订单号：" + a[i] + " 已经审核不能删除 <br/>");
}
else
{
bl.deleteEitity(a[i]);
num++;
}
}
sb.Append("成功删除 " + num + "条 <a href=\"Manager_BuyReceipOrder.aspx\">返回列表</a>");
Response.Write(sb.ToString());
}
}
public void init()
{
object action = Request.QueryString["action"].ToString();
if (action == null)
{
}
else if (action.ToString().Equals("BuyPayLoad"))///在添加采购付款是使用
{
string str0 = Request.QueryString["BuyReceiptID"].ToString();
float Total = float.Parse("0.00");
List <VBuyPay> list = new List <VBuyPay>();
BuyReceipt vb = new BuyReceipt();
vb = Leyp.SQLServerDAL.Buy.Factory.getBuyReceiptDAL().getByID(str0);
list = Leyp.SQLServerDAL.Buy.Factory.getBuyPayDAL().getByBuyReceiptID(str0);
for (int i = 0; i < list.Count; i++)
{
VBuyPay b = list[i];
Total = Total + b.RealPay;
}
Response.Write(vb.TotalPrice + "$$$" + Total.ToString());
Response.End();
}
else if (action.ToString().Equals("BuyPayLoadAdd"))//添加一个采购单
{
string str0 = Request.QueryString["BuyReceiptID"].ToString();
string str1 = Request.QueryString["Ticket"].ToString();
string str2 = Request.QueryString["CreateDate"].ToString();
string str3 = Request.QueryString["PayType"].ToString();
string str4 = Request.QueryString["RealPay"].ToString();
string str5 = Request.QueryString["AttachPay"].ToString();
string str6 = Request.QueryString["Description"].ToString();
BuyPay b = new BuyPay();
b.BuyReceiptID = str0;
b.Ticket = str1;
b.CreateDate = str2;
b.PayType = str3;
b.RealPay = float.Parse(str4);
b.AttachPay = float.Parse(str5);
b.Description = str6;
b.UserName = "******";
Leyp.SQLServerDAL.Buy.Factory.getBuyPayDAL().insertNewEntity(b);
Response.Write("添加成功");
Response.End();
}
}
protected void init()
{
object action = Request.QueryString["action"];
if (action != null)
{
if (action.ToString().Equals("date"))
{
string str0 = Request.QueryString["baginData"].ToString();
string str1 = Request.QueryString["endData"].ToString();
if (str0.Equals(""))
{
str0 = "1000";
}
if (str1.Equals(""))
{
str1 = "3000";
}
List <VBuyReceipt> list = new List <VBuyReceipt>();
list = Leyp.SQLServerDAL.Buy.Factory.getBuyReceiptDAL().getAdminBuyReceiptOrderList(str0, str1, 2);
CollectionPager1.DataSource = list;
CollectionPager1.BindToControl = OrderList;
OrderList.DataSource = CollectionPager1.DataSourcePaged;
}
else
{
string id = Request.QueryString["ID"].ToString();
BuyReceipt o = new BuyReceipt();
o = Leyp.SQLServerDAL.Buy.Factory.getBuyReceiptDAL().getByID(id);
Jscript.CloseWindowReturnValues(o.ReceiptOrderID + "$$$" + o.StoreHouseID + "$$$" + o.HouseDetailID);
return;
}
}
else //初始化页面
{
List <VBuyReceipt> list = new List <VBuyReceipt>();
list = Leyp.SQLServerDAL.Buy.Factory.getBuyReceiptDAL().getAdminBuyReceiptOrderList("1000", "3000", 2);
CollectionPager1.DataSource = list;
CollectionPager1.BindToControl = OrderList;
OrderList.DataSource = CollectionPager1.DataSourcePaged;
}
}
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);
}
public bool AuditingBuyReceiptOrder(string ReceiptOrderID)
{
bool flag = false;
try
{
BuyReceipt receipt = new BuyReceipt();
List <VBuyReceiptDetail> list = new List <VBuyReceiptDetail>();
ProductsStockDAL kdal = new ProductsStockDAL();
receipt = new BuyReceiptDAL().getByID(ReceiptOrderID);
list = new BuyReceiptDetailDAL().getBuyReceiptDetailByReceiptOrderID(ReceiptOrderID);
for (int i = 0; i < list.Count; i++)
{
ProductsStock stock;
BuyReceiptDetail detail = list[i];
if (kdal.isHaveEitity(receipt.HouseDetailID, detail.ProductsID))
{
stock = new ProductsStock();
stock.HouseDetailID = receipt.HouseDetailID;
stock.ProductsID = detail.ProductsID;
stock.Num = detail.Quantity;
kdal.updateAddNum(stock);
}
else
{
stock = new ProductsStock();
stock.HouseDetailID = receipt.HouseDetailID;
stock.ProductsID = detail.ProductsID;
stock.Num = detail.Quantity;
kdal.insertNewEitity(stock);
}
}
flag = true;
}
catch
{
}
return(flag);
}
