public bool insertNewEntity(SalesOut s)
{
int rowsAffected = 0;
float num2 = float.Parse("0.00");
List <VSalesOutDetail> list = new SalesOutDetailDAL().getBySalesOutID(s.SalesOutID);
for (int i = 0; i < list.Count; i++)
{
VSalesOutDetail detail = list[i];
num2 += (detail.Price * detail.Quantity) * (1f - (detail.DiscountRate / 100f));
}
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SalesOutID", SqlDbType.NVarChar), new SqlParameter("@SalesOrderID", SqlDbType.NVarChar), new SqlParameter("@CreateDate", SqlDbType.NVarChar), new SqlParameter("@Consignee", SqlDbType.NVarChar), new SqlParameter("@TradeDate", SqlDbType.NVarChar), new SqlParameter("@TotalPrice", SqlDbType.Float), new SqlParameter("@Deposits", SqlDbType.Float), new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@Description", SqlDbType.NVarChar), new SqlParameter("@State", SqlDbType.Int), new SqlParameter("@DeliveryID", SqlDbType.Int), new SqlParameter("@AccountsID", SqlDbType.NVarChar) };
parameters[0].Value = s.SalesOutID;
parameters[1].Value = s.SalesOrderID;
parameters[2].Value = s.CreateDate;
parameters[3].Value = s.Consignee;
parameters[4].Value = s.TradeDate;
parameters[5].Value = num2;
parameters[6].Value = s.Deposits;
parameters[7].Value = s.UserName;
parameters[8].Value = s.Description;
parameters[9].Value = s.State;
parameters[10].Value = s.DeliveryID;
parameters[11].Value = s.AccountsID;
SQLHelper.RunProcedure("p_SalesOut_insertNewEntity", parameters, out rowsAffected);
if (rowsAffected == 1)
{
new SalesOrderDAL().updateSate(2, s.SalesOrderID);
}
return(1 == rowsAffected);
}
protected void Button1_Click(object sender, EventArgs e)
{
SalesOut s = new SalesOut();
SalesOrder so = new SalesOrder();
s.Consignee = Consignee.Text.ToString();
s.CreateDate = CreateDate.Text.ToString();
s.DeliveryID = int.Parse(DeliveryID.SelectedValue.ToString());
s.Description = Description.Text.ToString();
s.SalesOutID = SalesOutID.Text.ToString();
s.UserName = getUserName();
s.TradeDate = TradeDate.Text.ToString();
s.SalesOrderID = SalesOrderID.Text.ToString();
so.CustomerArea = CustomerArea.Value.ToString();
so.CustomerID = CustomerIDType.Value + CustomerID.Text.ToString();
so.CustomerName = CustomerName.Text.ToString();
so.CustomerPost = CustomerPost.Text.ToString();
so.CustomerTel = CustomerTel.Text.ToString();
so.Discount = float.Parse(Discount.Text.ToString());
so.AttachPay = float.Parse(AttachPay.Text.ToString());
so.SalesOrderID = SalesOrderID.Text.ToString();
so.PlatformID = int.Parse(Platform.SelectedValue.ToString());
if (Leyp.SQLServerDAL.Sales.Factory.getSalesOrderDAL().updateCustomerInfo(so)) //顾客信息更新成功
{
Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().updataEntity(s);
Jscript.RefreshParent("Manager_SalesOutOrder.aspx");
Jscript.CloseWindow();
}
}
protected void init()
{
string action = Request.Form["action"].ToString();
if (action.Equals("add"))
{
string str0 = Request.Form["SalesOutID"].ToString();
string str1 = Request.Form["SalesOrderID"].ToString();
string str2 = Request.Form["CreateDate"].ToString();
string str3 = Request.Form["Consignee"].ToString();
// string str4=Request.Form["TradePlace"].ToString();
string str5 = Request.Form["DeliveryID"].ToString();
string str6 = Request.Form["AccountsID"].ToString();
string str7 = Request.Form["TradeDate"].ToString();
string str8 = Request.Form["Deposits"].ToString();
string str9 = Request.Form["Description"].ToString();
SalesOut s = new SalesOut();
s.Consignee = str3;
s.CreateDate = str2;
// s.TradePlace = str4;
s.DeliveryID = int.Parse(str5);
s.TradeDate = str7;
s.Deposits = float.Parse(str8);
s.Description = str9;
s.UserName = getUserName();
s.State = 0;
s.SalesOutID = str0;
s.SalesOrderID = str1;
s.AccountsID = str6;
Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().insertNewEntity(s);
Response.Write("00");
Response.End();
}
else if (action.Equals("delete"))
{
string str0 = Request.Form["SalesOutID"].ToString();
VSalesOut v = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().getByID(str0);
if (v.UserName.Equals(getUserName()))
{
Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().deleteEitity(str0);
Response.Write("00");
Response.End();
}
}
else if (action.Equals("testAdd"))//临时添加详细
{
string str0 = Request.Form["SalesOutID"].ToString();
string str1 = Request.Form["SalesOrderID"].ToString();
Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().insertSalesDetailFrist(str1, str0);
Response.Write("00");
Response.End();
}
}
public bool updataEntity(SalesOut s)
{
int rowsAffected = 0;
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SalesOutID", SqlDbType.NVarChar), new SqlParameter("@CreateDate", SqlDbType.NVarChar), new SqlParameter("@Consignee", SqlDbType.NVarChar), new SqlParameter("@TradeDate", SqlDbType.NVarChar), new SqlParameter("@UserName", SqlDbType.NVarChar), new SqlParameter("@Description", SqlDbType.NVarChar), new SqlParameter("@DeliveryID", SqlDbType.Int) };
parameters[0].Value = s.SalesOutID;
parameters[1].Value = s.CreateDate;
parameters[2].Value = s.Consignee;
parameters[3].Value = s.TradeDate;
parameters[4].Value = s.UserName;
parameters[5].Value = s.Description;
parameters[6].Value = s.DeliveryID;
SQLHelper.RunProcedure("p_SalesOut_updataEntity", parameters, out rowsAffected);
if (rowsAffected == 1)
{
}
return(1 == rowsAffected);
}
/// <summary>
///
/// </summary>
private void kuaiShenhe(string SalesOrderID)
{
VSalesOrder vs = Leyp.SQLServerDAL.Sales.Factory.getSalesOrderDAL().getByID(SalesOrderID);
if (vs == null)
{
return;
}
SalesOut s = new SalesOut();
s.UserName = getUserName();
s.Consignee = "未知";
s.CreateDate = DateTime.Now.ToString("yyyy-MM-dd");
s.SalesOrderID = vs.SalesOrderID;
s.SalesOutID = "SO" + StrHelper.GetRamCode();
s.Description = "无";
s.DeliveryID = Leyp.SQLServerDAL.Sales.Factory.getSalesPlatformDAL().getList()[0].PlatformID;
}
/// <summary>
/// 根据SalesOrderID 快速生成
/// </summary>
/// <param name="SalesOrderID"></param>
private void buildNode(string SalesOrderID, int DeliveryID)
{
bool result = true;
VSalesOrder vo = Leyp.SQLServerDAL.Sales.Factory.getSalesOrderDAL().getByID(SalesOrderID);
if (vo == null)
{
Response.Write("订单号：" + SalesOrderID + " 有误<br>");
return;
}
if (vo.State != 1)//订单没有审核
{
Response.Write("订单号：" + SalesOrderID + " 没有审核或已经处理<br>");
return;
}
string SalesOutID = getSalesOutID();
// int DeliveryID = Leyp.SQLServerDAL.Factory.getDeliveryDAL().getDefaultEitity().DeliveryID;//得到默认得
SalesOut s = new SalesOut();
s.Consignee = "未知";
s.CreateDate = DateTime.Now.ToString("yyyy-MM-dd");
s.DeliveryID = DeliveryID;
s.TradeDate = DateTime.Now.ToString("yyyy-MM-dd");
s.Deposits = float.Parse("0.00");
s.Description = "无";
s.UserName = getUserName();
s.State = 0;
s.SalesOutID = SalesOutID;
s.SalesOrderID = SalesOrderID;
s.AccountsID = "无";
Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().insertSalesDetailFrist(SalesOrderID, SalesOutID);//临时添加详细
List <VSalesOutDetail> list = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDetailDAL().getBySalesOutIDinit(SalesOutID);
for (int i = 0; i < list.Count; i++)
{
if (result == false)
{
break;
}
VSalesOutDetail v = list[i];
int ProductsID = v.ProductsID;
List <VProductsStock> list0 = Leyp.SQLServerDAL.Factory.getProductsStockDAL().getStockList(ProductsID); //寻找库存
if (list0 == null || list0.Count == 0) //没有库存
{
result = false;
break;
}
VProductsStock vp = null;
for (int j = 0; j < list0.Count; j++)
{
VProductsStock vps = list0[j];
if (vps.Num >= v.Quantity)//有库存 并且数量合理
{
vp = vps;
break;
}
}
if (vp == null)//没有库存 失败！
{
result = false;
break;
}
SalesOutDetail d = new SalesOutDetail();
d.SalesOutID = v.SalesOutID;
d.ProductsID = v.ProductsID;
d.Price = v.Price;
d.Quantity = v.Quantity;
d.DiscountRate = v.DiscountRate;
d.Description = v.Description;
d.DetailID = v.DetailID;
d.StoreHouseID = vp.HouseID;
d.HouseDetailID = vp.HouseDetailID;
Leyp.SQLServerDAL.Sales.Factory.getSalesOutDetailDAL().updateEitity(d);
}
if (result == true)
{
if (Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().insertNewEntity(s))
{
Response.Write("单号：" + SalesOrderID + " --生成成功<br>");
}
}
else
{
Response.Write("订单号：" + SalesOrderID + " 不能生成，可能库存不足<br>");
}
}
