/// <summary> /// 删除指定的适用人群信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void lbtDelete_Command(object sender, CommandEventArgs e) { int productSexTypeId = Convert.ToInt32(e.CommandArgument); BLL.CommonClass.ChangeLogs cl_h_info = new BLL.CommonClass.ChangeLogs("ProductSexType", "ProductSexTypeID"); //Judge the ProductSexTypeId whether exist by Id before delete or update int isExistCount = SetParametersBLL.ProductSexTypeIdIsExist(productSexTypeId); if (isExistCount > 0) { //Judge the ProductSexTypeId whether has operation before delete by Id int getCount = SetParametersBLL.ProductSexTypeIdWhetherHasOperation(productSexTypeId); if (getCount > 0) { Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("002220", "对不起,该适用人群已经发生了业务,因此不能删除!"))); divProductSexType.Visible = false; return; } else { //Delete the ProductSexType information by productSexTypeId using (SqlConnection conn = new SqlConnection(DBHelper.connString)) { conn.Open(); using (SqlTransaction tran = conn.BeginTransaction()) { try { cl_h_info.AddRecordtran(tran, productSexTypeId.ToString()); SetParametersBLL.DelProductSexTypeByID(tran, productSexTypeId); language.RemoveTranslationRecord(tran, "ProductSexType", productSexTypeId); cl_h_info.DeletedIntoLogstran(tran, ChangeCategory.company28, Session["Company"].ToString(), ENUM_USERTYPE.objecttype9); tran.Commit(); } catch { tran.Rollback(); Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("002223", "删除适用人群失败,请联系管理员!"))); return; } Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("002222", "删除适用人群成功!"))); } } } } else { divProductSexType.Visible = false; Page.ClientScript.RegisterStartupScript(GetType(), "", Transforms.ReturnAlert(GetTran("002219", "对不起,该适用人群不存在或者已经被删除!"))); return; } DataBindProductSexType(); }
/// <summary> /// 删除发货单方法 /// </summary> /// <param name="storeId"></param> /// <returns></returns> public static Boolean DelGoodsOrder(string storeOrderID) { Boolean temp = true; string connString = DBHelper.connString; SqlTransaction tr = null; SqlConnection conn = new SqlConnection(connString); conn.Open(); tr = conn.BeginTransaction(); try { BLL.CommonClass.ChangeLogs cl_h_info = new BLL.CommonClass.ChangeLogs("StoreOrder", "storeOrderID"); cl_h_info.AddRecordtran(tr, storeOrderID); cl_h_info.DeletedIntoLogstran(tr, BLL.CommonClass.ChangeCategory.Order, storeOrderID, BLL.CommonClass.ENUM_USERTYPE.Company); StockDAL.DelGoodsOrder(tr, OrderDetailDAL.GetOrderDetail(storeOrderID), StoreOrderDAL.GetStoreIdByOrderId(storeOrderID)); //还原店库存 OrderDetailDAL.DelOrderDetailItem(tr, storeOrderID); //明细表删除失败回滚 StoreOrderDAL.DelStoreOrder(storeOrderID, tr); //订单表删除失败回滚 tr.Commit(); } catch { temp = false; tr.Rollback(); } finally { // tr.Connection.Close(); tr.Dispose(); conn.Close(); } return(temp); }
/// <summary> /// 删除复消单 /// </summary> public string DelOredrAgain(string orderId, double totalPv, string number, int except, string storeId) { double totalMoney = AddOrderDataDAL.GetTotalMoneyByOrderId(orderId); MemberOrderModel order = MemberOrderDAL.GetMemberOrder(orderId); string info = null; using (SqlConnection conn = new SqlConnection(DAL.DBHelper.connString)) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { BLL.CommonClass.ChangeLogs cl_h_info = new BLL.CommonClass.ChangeLogs("memberorder", "orderid"); //实例日志类 cl_h_info.AddRecordtran(tran, orderId); //添加日志,修改前记录原来数据 //如果该订单不存在 if (!BrowsememberordersDAL.CheckOrderIdExists(orderId)) { info = BLL.Translation.Translate("001661", "抱歉,该订单不存在!"); tran.Rollback(); conn.Close(); return(info); } if (order.DefrayState == 1) { if (totalMoney > 0) { D_AccountBLL.AddAccount(storeId, totalMoney, D_AccountSftype.StoreType, D_AccountKmtype.OrderDelete, DirectionEnum.AccountsIncreased, "会员【" + number + "】报单删除现金扣添加,订单号为【" + orderId + "】", tran); if (order.DefrayType == 2) { IsElecPay(tran, order); D_AccountBLL.AddAccount(order.Number, Convert.ToDouble(order.TotalMoney), D_AccountSftype.MemberType, D_AccountKmtype.OrderUpdateIn, DirectionEnum.AccountsIncreased, "会员【" + order.Number + "】报单删除现金扣添加,订单号为【" + order.OrderId + "】", tran); D_AccountBLL.AddAccount(order.StoreId, Convert.ToDouble(order.TotalMoney), D_AccountSftype.StoreType, D_AccountKmtype.OrderUpdateOut, DirectionEnum.AccountReduced, "会员【" + order.Number + "】报单删除现金添加扣,订单号为【" + order.OrderId + "】", tran, true); } } int result = addOrderDataDAL.Js_delfuxiao(number, totalPv, except, 1, tran); } //删除复消单 addOrderDataDAL.Del_Horder(tran, orderId, storeId, CommonDataBLL.OperateBh, CommonDataBLL.OperateIP); cl_h_info.DeletedIntoLogstran(tran, BLL.CommonClass.ChangeCategory.store1, orderId, BLL.CommonClass.ENUM_USERTYPE.objecttype5);//插入日志 tran.Commit(); } catch { info = BLL.Translation.Translate("000417", "删除失败!"); tran.Rollback(); } finally { conn.Close(); conn.Dispose(); } } return(info); }
/// <summary> /// 删除订单方法 /// </summary> /// <param name="storeId"></param> /// <returns></returns> public static Boolean DelStoreOrderItem(string storeOrderID) { Boolean temp = true; string connString = DBHelper.connString; SqlTransaction tr = null; SqlConnection conn = new SqlConnection(connString); conn.Open(); tr = conn.BeginTransaction(); try { BLL.CommonClass.ChangeLogs cl_h_info = new BLL.CommonClass.ChangeLogs("OrderGoods", "ordergoodsID"); cl_h_info.AddRecordtran(tr, storeOrderID); BLL.CommonClass.ChangeLogs cl_h_info2 = new BLL.CommonClass.ChangeLogs("OrderGoodsDetail", "ordergoodsID"); cl_h_info2.AddRecordtran(tr, storeOrderID); StoreOrderDAL.DelStoreOrderItemProc(tr, storeOrderID); //StockDAL.DelStoreOrder(tr, OrderDetailDAL.GetOrderGoodsDetail(storeOrderID), StoreOrderDAL.GetStoreIdByGoodsId(storeOrderID));//还原店库存 //OrderDetailDAL.DelOrderGoodsDetail(tr, storeOrderID);//明细表删除失败回滚 //StoreOrderDAL.DelOrderGoods(storeOrderID, tr); //订单表删除失败回滚 cl_h_info.AddRecordtran(tr, storeOrderID); cl_h_info.DeletedIntoLogstran(tr, BLL.CommonClass.ChangeCategory.store10, storeOrderID, BLL.CommonClass.ENUM_USERTYPE.objecttype2); cl_h_info2.AddRecordtran(tr, storeOrderID); cl_h_info2.DeletedIntoLogstran(tr, BLL.CommonClass.ChangeCategory.store10, storeOrderID, BLL.CommonClass.ENUM_USERTYPE.objecttype2); tr.Commit(); } catch { temp = false; tr.Rollback(); } finally { // tr.Connection.Close(); tr.Dispose(); conn.Close(); } return(temp); }
/// <summary> /// 删除报单信息 /// </summary> /// <param name="strId">报单编号</param> /// <param name="maxExcept">当前期数</param> /// <returns></returns> public string DelMembersDeclaration(string number, int maxExcept, string orderId, string storeId, double lackproductmoney) { OrderDAL orderDAL = new OrderDAL(); string info = null; MemberOrderModel order = MemberOrderDAL.GetMemberOrder(orderId); BLL.CommonClass.ChangeLogs cl_h_info = new BLL.CommonClass.ChangeLogs("memberinfo", "number"); //申明日志对象 BLL.CommonClass.ChangeLogs cl_h_order = new BLL.CommonClass.ChangeLogs("MemberOrder", "orderId"); //申明日志对象 using (SqlConnection conn = new SqlConnection(DBHelper.connString)) { conn.Open(); SqlTransaction tran = conn.BeginTransaction(); try { //判断会员下是否有安置 //全球统一可以删除有下级的会员,如果有两个下级则注销,有一个下级则紧缩 info = new AddOrderBLL().GetHavePlace(number, tran); if (info != null) { tran.Rollback(); conn.Close(); return(info); } ////判断会员下是否有推荐 info = new AddOrderBLL().GetHaveDirect(number, tran); if (info != null) { tran.Rollback(); conn.Close(); return(info); } int cnt = new AddOrderBLL().GetHaveStore(number, tran); if (cnt > 0) { info = this.GetTran("007097", "抱歉!该会员已经注册店铺,不可以删除!");// "抱歉!该会员有重复消费请先删除重复消费!"; tran.Rollback(); conn.Close(); return(info); } //判断该会员是否有复效单 int result = browsememberordersDAL.GetHasOrderAgain(number); if (result > 0) { info = this.GetTran("000976", "抱歉!该会员有重复消费请先删除重复消费!");// "抱歉!该会员有重复消费请先删除重复消费!"; tran.Rollback(); conn.Close(); return(info); } else { string electronicaccountid = order.ElectronicaccountId;; int defrayState = order.DefrayState; int defrayType = order.DefrayType; //if (defrayState == 1) //{ // if (lackproductmoney > 0) // { // int deliveryflag = BLL.Logistics.D_AccountBLL.GetDeliveryflag(orderId, tran); // if (deliveryflag == 0) // { // if (defrayType == 2) // { // IsElecPay(tran, order); // BLL.Logistics.D_AccountBLL.AddAccount(storeId, lackproductmoney, D_AccountSftype.StoreType, D_AccountKmtype.OrderDelete, DirectionEnum.AccountsIncreased, "会员【" + number + "】报单删除现金返还,订单号为【" + orderId + "】", tran); // BLL.Logistics.D_AccountBLL.AddAccount(electronicaccountid, lackproductmoney, D_AccountSftype.MemberType, D_AccountKmtype.OrderDelete, DirectionEnum.AccountsIncreased, "会员【" + number + "】报单删除现金返还,订单号为【" + orderId + "】", tran); // } // else if (defrayType == 1) // { // BLL.Logistics.D_AccountBLL.AddAccount(storeId, lackproductmoney, D_AccountSftype.StoreType, D_AccountKmtype.OrderDelete, DirectionEnum.AccountsIncreased, "会员【" + number + "】报单删除现金扣添加,订单号为【" + orderId + "】", tran); // } // } // } //} // cl_h_info.DeletedIntoLogstran(tran, CommonClass.ChangeCategory.Order, storeId, BLL.CommonClass.ENUM_USERTYPE.objecttype5); browsememberordersDAL.DelNew(number, maxExcept, tran); //添加日志 cl_h_info.AddRecordtran(tran, number); cl_h_order.AddRecordtran(tran, orderId); cl_h_order.DeletedIntoLogstran(tran, CommonClass.ChangeCategory.Order, storeId, BLL.CommonClass.ENUM_USERTYPE.objecttype5); addOrderDataDAL.Del_Horder(tran, orderId, storeId, CommonDataBLL.OperateBh, CommonDataBLL.OperateIP); ///删除后,把推荐或安置是他的err赋上值 int checkResult = addOrderDataDAL.Check_WhenDelete(tran, number); } tran.Commit(); } catch (Exception ext) { info = this.GetTran("000985", "抱歉!系统异常");// "抱歉!系统异常"; tran.Rollback(); conn.Close(); return(info); } finally { conn.Close(); conn.Dispose(); } } return(info); }