public VOutStock getByID(string OutID) { string s = ""; VOutStock stock = new VOutStock(); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@OutID", SqlDbType.NVarChar) }; parameters[0].Value = OutID; SqlDataReader reader = SQLHelper.RunProcedure("p_OutStock_getByID", parameters); while (reader.Read()) { s = reader.GetValue(reader.GetOrdinal("AlreadyPay")).ToString(); stock.AlreadyPay = float.Parse(s); stock.OutID = reader.GetString(reader.GetOrdinal("OutID")); stock.CreateDate = reader.GetString(reader.GetOrdinal("CreateDate")); stock.RealName = reader.GetString(reader.GetOrdinal("RealName")); stock.Description = reader.GetString(reader.GetOrdinal("Description")); stock.OutType = reader.GetInt32(reader.GetOrdinal("OutType")); stock.HouseDetailID = reader.GetInt32(reader.GetOrdinal("HouseDetailID")); stock.StoreHouseID = reader.GetInt32(reader.GetOrdinal("StoreHouseID")); s = reader.GetValue(reader.GetOrdinal("TotalPrice")).ToString(); stock.TotalPrice = float.Parse(s); stock.SubareaName = reader.GetString(reader.GetOrdinal("SubareaName")); stock.HouseName = reader.GetString(reader.GetOrdinal("HouseName")); stock.TradeDate = reader.GetString(reader.GetOrdinal("TradeDate")); stock.UserName = reader.GetString(reader.GetOrdinal("UserName")); } reader.Close(); return(stock); }
public List <VOutStock> getSearchList(string beginDate, string endDate, int sideState) { string s = ""; List <VOutStock> list = new List <VOutStock>(); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@beginDate", SqlDbType.NVarChar), new SqlParameter("@endDate", SqlDbType.NVarChar), new SqlParameter("@sideState", SqlDbType.Int) }; parameters[0].Value = beginDate; parameters[1].Value = endDate; parameters[2].Value = sideState; SqlDataReader reader = SQLHelper.RunProcedure("p_OutStock_getSearchList", parameters); while (reader.Read()) { VOutStock item = new VOutStock(); s = reader.GetValue(reader.GetOrdinal("AlreadyPay")).ToString(); item.AlreadyPay = float.Parse(s); item.OutID = reader.GetString(reader.GetOrdinal("OutID")); item.CreateDate = reader.GetString(reader.GetOrdinal("CreateDate")); item.RealName = reader.GetString(reader.GetOrdinal("RealName")); item.Description = reader.GetString(reader.GetOrdinal("Description")); item.OutType = reader.GetInt32(reader.GetOrdinal("OutType")); item.HouseDetailID = reader.GetInt32(reader.GetOrdinal("HouseDetailID")); item.StoreHouseID = reader.GetInt32(reader.GetOrdinal("StoreHouseID")); s = reader.GetValue(reader.GetOrdinal("TotalPrice")).ToString(); item.TotalPrice = float.Parse(s); item.SubareaName = reader.GetString(reader.GetOrdinal("SubareaName")); item.HouseName = reader.GetString(reader.GetOrdinal("HouseName")); 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); }
public void init() { string str0 = Request.QueryString["OutID"].ToString(); VOutStock vb = Leyp.SQLServerDAL.Stock.Factory.getOutStockDAL().getByID(str0); if (vb == null) { Response.Write("没有你要的数据"); Response.End(); } OutID.Text = vb.OutID; CreateDate.Text = vb.CreateDate; RealName.Text = vb.RealName; HouseName.Text = vb.HouseName + "----" + vb.SubareaName; TradeDate.Text = vb.TradeDate; Description.Text = vb.Description; State.Text = changString(vb.State.ToString()); TotalPrice.Text = vb.TotalPrice.ToString(); Label1.Text = changString0(vb.OutType.ToString()); }
public bool AuditingOutStockOrder(string OutStockID) { bool flag = false; try { VOutStock stock = new VOutStock(); List <VOutStockDetail> list = new List <VOutStockDetail>(); ProductsStockDAL kdal = new ProductsStockDAL(); stock = new OutStockDAL().getByID(OutStockID); list = new OutStockDetailDAL().getListByOutID(OutStockID); for (int i = 0; i < list.Count; i++) { ProductsStock stock2; OutStockDetail detail = list[i]; if (kdal.isHaveEitity(stock.HouseDetailID, detail.ProductsID)) { stock2 = new ProductsStock(); stock2.HouseDetailID = stock.HouseDetailID; stock2.ProductsID = detail.ProductsID; stock2.Num = detail.Quantity; kdal.updateCutNum(stock2); } else { stock2 = new ProductsStock(); stock2.HouseDetailID = stock.HouseDetailID; stock2.ProductsID = detail.ProductsID; stock2.Num = -detail.Quantity; kdal.insertNewEitity(stock2); } } flag = true; } catch { } return(flag); }