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