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);
}
public bool insertNewEntity(SalesReturn s)
{
int rowsAffected = 0;
SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@SalesReturnID", SqlDbType.NVarChar), new SqlParameter("@SalesOutID", SqlDbType.NVarChar), new SqlParameter("@CreateDate", SqlDbType.NVarChar), new SqlParameter("@ReturnType", SqlDbType.NVarChar), new SqlParameter("@StoreHouseID", SqlDbType.Int), new SqlParameter("@HouseDetailID", SqlDbType.Int), 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) };
parameters[0].Value = s.SalesReturnID;
parameters[1].Value = s.SalesOutID;
parameters[2].Value = s.CreateDate;
parameters[3].Value = s.ReturnType;
parameters[4].Value = s.StoreHouseID;
parameters[5].Value = s.HouseDetailID;
parameters[6].Value = s.TradeDate;
parameters[7].Value = s.TotalPrice;
parameters[8].Value = s.Deposits;
parameters[9].Value = s.UserName;
parameters[10].Value = s.Description;
parameters[11].Value = s.State;
SQLHelper.RunProcedure("p_SalesReturn_insertNewEntity", parameters, out rowsAffected);
List <VSalesOutDetail> list = new List <VSalesOutDetail>();
SalesReturnDetailDAL ldal = new SalesReturnDetailDAL();
list = new SalesOutDetailDAL().getBySalesOutID(s.SalesOutID);
for (int i = 0; i < list.Count; i++)
{
VSalesOutDetail detail = list[i];
SalesReturnDetail b = new SalesReturnDetail();
b.Price = detail.Price;
b.ProductsID = detail.ProductsID;
b.Quantity = detail.Quantity;
b.Description = "";
b.SalesReturnID = s.SalesReturnID;
ldal.insertNewEitity(b);
}
return(1 == rowsAffected);
}
private void checkEdit(string SalesOutID)
{
#region
bool reslut = true;
List <VSalesOutDetail> list = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDetailDAL().getBySalesOutIDinit(SalesOutID);
for (int i = 0; i < list.Count; i++)
{
VSalesOutDetail v = list[i];
if (v.HouseDetailID < 1)
{
reslut = false;
}
}
if (reslut)
{
Response.Write("0");//编辑全部完成
Response.End();
}
else
{
Response.Write("1");//编辑没有完
Response.End();
}
#endregion
}
/// <summary>
/// 快递单打印
/// </summary>
/// <param name="ReceiptOrderID"></param>
protected void LoadDetailPrint(string SalesOutID)
{
#region
List <VSalesOutDetail> list = new List <VSalesOutDetail>();
list = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDetailDAL().getBySalesOutIDinit(SalesOutID);
float tatal = float.Parse("0.00");
StringBuilder sb = new StringBuilder();
sb.Append("<TABLE id=MyDataGrid class=\"MyDataGrid\"borderColor=black cellSpacing=0 cellPadding=0 rules=all align=center border=1><TBODY><TR style=\"FONT-WEIGHT: bold; BACKGROUND-COLOR: #b9c6ff\" align=middle><TD width=\"150\">商品编号</TD><TD width=\"250\" align=middle>商品名称</TD><TD width=\"100\" align=middle> 数量</TD><TD align=middle></TD></TR>");
//sb.Append(" </thead><tbody>");
for (int i = 0; i < list.Count; i++)
{
VSalesOutDetail v = list[i];
sb.Append("<TR onMouseOver=\"this.className='onmouseover'\" onmouseout=\"this.className=''\">");
sb.Append(" <td>" + v.ProductsID + "</td>");
sb.Append(" <td>" + v.ProductsName + "</td>");
sb.Append(" <td>" + v.Quantity + "</td>");
sb.Append(" <td></td>");
sb.Append("</TR >");
}
sb.Append("</table>");
Response.Write(sb.ToString());
Response.End();
#endregion
}
/// <summary>
/// 加载全部
/// </summary>
/// <param name="ReceiptOrderID"></param>
protected void loadinit(string SalesOutID)
{
#region
List <VSalesOutDetail> list = new List <VSalesOutDetail>();
list = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDetailDAL().getBySalesOutID(SalesOutID);
float tatal = float.Parse("0.00");
StringBuilder sb = new StringBuilder();
sb.Append("<table class=\"flexme2\"><thead><tr><th width=\"70\">操作</th><th width=\"80\">商品编号</th><th width=\"100\">商品名称</th><th width=\"80\">数量 </th><th width=\"80\">价格</th><th width=\"80\">折扣额 </th><th width=\"100\">金额 </th></tr>");
sb.Append(" </thead><tbody>");
for (int i = 0; i < list.Count; i++)
{
VSalesOutDetail v = new VSalesOutDetail();
v = list[i];
sb.Append("<tr><td ><img src=\"../images/tbtn_amend.gif\" onclick=\"editDetail(" + v.DetailID + ")\"; /> <img src=\"../images/tbtn_delete.gif\" onclick=\"javascript:if(!confirm('您确定要删除吗'))return false;deleteDetail(" + v.DetailID + ")\"; /> </td>");
sb.Append(" <td>" + v.ProductsID + "</td>");
sb.Append(" <td>" + v.ProductsName + "</td>");
sb.Append(" <td>" + v.Quantity + "</td>");
sb.Append(" <td>" + v.Price.ToString() + "</td>");
sb.Append(" <td>" + v.DiscountRate.ToString() + "</td>");
tatal = v.Quantity * v.Price - (v.Quantity * v.Price * v.DiscountRate / 100);
sb.Append(" <td>" + tatal.ToString() + "</td>");
sb.Append("</tr>");
}
sb.Append("</tbody></table>");
Response.Write(sb.ToString());
Response.End();
#endregion
}
/// <summary>
/// 输入一个实体节点
/// </summary>
public void getNode()
{
string str0 = Request.Form["DetailID"].ToString();
VSalesOutDetail s = new VSalesOutDetail();
s = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDetailDAL().getByID(int.Parse(str0));
Response.Write(s.DetailID + "$" + s.ProductsID + "$" + s.ProductsName + "$" + s.Price + "$" + s.Quantity + "$" + s.DiscountRate + "$" + s.Description + "$" + s.StoreHouseID + "$" + s.HouseDetailID);
Response.End();
}
private void init()
{
string checkDate = Request.QueryString["Data"].ToString();
List <VSalesOut> list = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDAL().selectProductsByImg(checkDate, 2); //等待发货
List <VSalesOutDetail> list0 = new List <VSalesOutDetail>(); //临时所有数据
List <VSalesOutDetail> listlist = new List <VSalesOutDetail>(); //存放最后数据
Leyp.SQLServerDAL.Sales.SalesOutDetailDAL dl = new Leyp.SQLServerDAL.Sales.SalesOutDetailDAL();
for (int i = 0; i < list.Count; i++)
{
List <VSalesOutDetail> lists = dl.getBySalesOutID(list[i].SalesOutID);
for (int j = 0; j < lists.Count; j++)
{
list0.Add(lists[j]);
}
}
for (int k = 0; k < list0.Count; k++)
{
bool reslut = false;
VSalesOutDetail v = list0[k];
if (listlist.Count == 0)
{
listlist.Add(v);
}
else
{
for (int h = 0; h < listlist.Count; h++)
{
VSalesOutDetail vi = listlist[h];
if (v.ProductsID == vi.ProductsID)//如果重复
{
listlist[h].Quantity = listlist[h].Quantity + v.Quantity;
reslut = true;
break;
}
}
if (!reslut)
{
listlist.Add(v);
}
}
}
DataList1.DataSource = listlist;
DataList1.DataBind();
}
/// <summary>
/// 加载全部没有编辑仓库
/// </summary>
/// <param name="ReceiptOrderID"></param>
protected void loadinitEdit(string SalesOutID)
{
#region
List <VSalesOutDetail> list = new List <VSalesOutDetail>();
list = Leyp.SQLServerDAL.Sales.Factory.getSalesOutDetailDAL().getBySalesOutIDinit(SalesOutID);
float tatal = float.Parse("0.00");
StringBuilder sb = new StringBuilder();
sb.Append("<table class=\"flexme2\"><thead><tr><th width=\"50\">操作</th><th width=\"60\">商品编号</th><th width=\"100\">商品名称</th><th width=\"80\">数量</th><th width=\"80\">库房号 </th><th width=\"80\">库区号 </th><th width=\"80\">价格</th><th width=\"80\">折扣额 </th><th width=\"100\">金额 </th></tr>");
sb.Append(" </thead><tbody>");
for (int i = 0; i < list.Count; i++)
{
VSalesOutDetail v = new VSalesOutDetail();
v = list[i];
sb.Append("<tr><td ><img src=\"../images/tbtn_amend.gif\" onclick=\"editDetail(" + v.DetailID + ")\"; /> </td>");
sb.Append(" <td>" + v.ProductsID + "</td>");
sb.Append(" <td>" + v.ProductsName + "</td>");
sb.Append(" <td>" + v.Quantity + "</td>");
sb.Append(" <td>" + getcheckNode(v.StoreHouseID) + "</td>");
sb.Append(" <td>" + getcheckNode(v.HouseDetailID) + "</td>");
sb.Append(" <td>" + v.Price.ToString() + "</td>");
sb.Append(" <td>" + v.DiscountRate.ToString() + "</td>");
tatal = v.Quantity * v.Price - (v.Quantity * v.Price * v.DiscountRate / 100);
sb.Append(" <td>" + tatal.ToString() + "</td>");
sb.Append("</tr>");
}
sb.Append("</tbody></table>");
Response.ClearContent();
Response.Write(sb.ToString());
Response.End();
#endregion
}
/// <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>");
}
}
