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