public void init() { string str0 = Request.QueryString["SalesReturnID"].ToString(); VSalesReturn vb = Leyp.SQLServerDAL.Sales.Factory.getSalesReturnDAL().getByID(str0); if (vb == null) { Response.Write("没有你要的数据"); Response.End(); } SalesReturnID.Text = vb.SalesReturnID; SalesOutID.Text = vb.SalesOutID; ReturnType.Text = vb.ReturnType; RealName.Text = vb.RealName; TradeDate.Text = vb.TradeDate; CreateDate.Text = vb.CreateDate; Description.Text = vb.Description; Deposits.Text = vb.Deposits.ToString(); Label1.Text = vb.TotalPrice.ToString(); State.Text = changString(vb.State.ToString()); }
public List <VSalesReturn> getSearchListByID(string SalesReturnID) { string s = ""; List <VSalesReturn> list = new List <VSalesReturn>(); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SalesReturnID", SqlDbType.NVarChar) }; parameters[0].Value = SalesReturnID; SqlDataReader reader = SQLHelper.RunProcedure("p_SalesReturn_getSearchListByID", parameters); while (reader.Read()) { VSalesReturn item = new VSalesReturn(); s = reader.GetValue(reader.GetOrdinal("TotalPrice")).ToString(); item.TotalPrice = float.Parse(s); item.AuditingUser = reader.GetString(reader.GetOrdinal("AuditingUser")); item.ReturnType = reader.GetString(reader.GetOrdinal("ReturnType")); item.CreateDate = reader.GetString(reader.GetOrdinal("CreateDate")); s = reader.GetValue(reader.GetOrdinal("Deposits")).ToString(); item.Deposits = float.Parse(s); item.Description = reader.GetString(reader.GetOrdinal("Description")); item.HouseDetailID = reader.GetInt32(reader.GetOrdinal("HouseDetailID")); item.HouseName = reader.GetString(reader.GetOrdinal("HouseName")); item.RealName = reader.GetString(reader.GetOrdinal("RealName")); item.SalesReturnID = reader.GetString(reader.GetOrdinal("SalesReturnID")); item.SalesOutID = reader.GetString(reader.GetOrdinal("SalesOutID")); item.State = reader.GetInt32(reader.GetOrdinal("State")); item.SubareaName = reader.GetString(reader.GetOrdinal("SubareaName")); item.TradeDate = reader.GetString(reader.GetOrdinal("TradeDate")); item.UserName = reader.GetString(reader.GetOrdinal("UserName")); item.State = reader.GetInt32(reader.GetOrdinal("State")); list.Add(item); } reader.Close(); return(list); }
protected void Page_Load(object sender, EventArgs e) { string str0 = Request.QueryString["SalesReturnID"].ToString(); VSalesReturn v = new VSalesReturn(); v = Leyp.SQLServerDAL.Sales.Factory.getSalesReturnDAL().getByID(str0); if (v.UserName.Equals(getUserName())) { Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().deleteEitity(str0); Response.Write("成功删除:" + str0); Response.End(); } }
protected void init() { string action = Request.Form["action"].ToString(); if (action.Equals("add")) { string str0 = Request.Form["SalesReturnID"].ToString(); string str1 = Request.Form["SalesOutID"].ToString(); string str2 = Request.Form["CreateDate"].ToString(); string str3 = Request.Form["ReturnType"].ToString(); string str5 = Request.Form["StoreHouseID"].ToString(); string str6 = Request.Form["HouseDetailID"].ToString(); string str7 = Request.Form["TradeDate"].ToString(); string str8 = Request.Form["Deposits"].ToString(); string str9 = Request.Form["Description"].ToString(); SalesReturn s = new SalesReturn(); s.ReturnType = str3; s.CreateDate = str2; s.StoreHouseID = int.Parse(str5); s.HouseDetailID = int.Parse(str6); s.TradeDate = str7; s.Deposits = float.Parse(str8); s.Description = str9; s.UserName = getUserName(); s.State = 0; s.SalesOutID = str1; s.SalesReturnID = str0; Leyp.SQLServerDAL.Sales.Factory.getSalesReturnDAL().insertNewEntity(s); Response.Write("00"); Response.End(); } else if (action.Equals("delete")) { string str0 = Request.Form["SalesReturnID"].ToString(); VSalesReturn v = new VSalesReturn(); v = Leyp.SQLServerDAL.Sales.Factory.getSalesReturnDAL().getByID(str0); if (v.UserName.Equals(getUserName())) { Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().deleteEitity(str0); Response.Write("00"); Response.End(); } } }
public bool AuditingSalesOutOrder(string SalesReturnID) { bool flag = false; try { VSalesReturn return2 = new VSalesReturn(); List <VSalesReturnDetail> list = new List <VSalesReturnDetail>(); ProductsStockDAL kdal = new ProductsStockDAL(); return2 = new SalesReturnDAL().getByID(SalesReturnID); list = new SalesReturnDetailDAL().getBySalesReturnID(SalesReturnID); for (int i = 0; i < list.Count; i++) { ProductsStock stock; SalesReturnDetail 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.updateAddNum(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); }