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