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); }