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