/// <summary> /// 批量操作券码 /// </summary> /// <param name="data"></param> /// <returns></returns> public bool BatchOperatorCouponCodeConfig(List <MaPaiVipModel> data) { var result = false; try { dbScopeManager.Execute(conn => { foreach (var item in data) { var info = DALMaPaiVip.SelectContinentalConfigInfoByCouponCode(conn, item.UniquePrivilegeCode); if (info != null) { result = DALMaPaiVip.UpdateConfigByCouponCode(conn, item.UniquePrivilegeCode, item.IsDeleted) > 0; } else { result = DALMaPaiVip.InsertContinentalConfig(conn, item.UniquePrivilegeCode, item.IsDeleted) > 0; } } }); result = true; } catch (Exception ex) { logger.Log(Level.Error, ex, "BatchInsertCouponCodeConfig"); } return(result); }
/// <summary> /// 获取券码 /// </summary> /// <param name="keyword"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <returns></returns> public List <MaPaiVipModel> GetContinentalActivityList(string keyword, int pageIndex, int pageSize) { var result = new List <MaPaiVipModel>(); try { result = dbScopeReadManager.Execute(conn => DALMaPaiVip.SelectContinentalActivityList(conn, keyword, pageIndex, pageSize)); } catch (Exception ex) { logger.Log(Level.Error, ex, "GetContinentalActivityList"); } return(result); }
/// <summary> /// 批量删除券码 /// </summary> /// <param name="pkidStr"></param> /// <returns></returns> public bool BatchDeleteConfig(string pkidStr) { var result = false; try { result = dbScopeManager.Execute(conn => DALMaPaiVip.DeletedContinentalConfig(conn, pkidStr)) > 0; } catch (Exception ex) { logger.Log(Level.Error, ex, "BatchDeleteConfig"); } return(result); }
/// <summary> /// 根据券码查询信息 /// </summary> /// <param name="couponCode"></param> /// <returns></returns> public MaPaiVipModel SelectContinentalConfigInfoByCouponCode(string couponCode) { MaPaiVipModel result = null; try { if (!string.IsNullOrEmpty(couponCode)) { result = dbScopeReadManager.Execute(conn => DALMaPaiVip.SelectContinentalConfigInfoByCouponCode(conn, couponCode)); } } catch (Exception ex) { logger.Log(Level.Error, ex, "SelectContinentalConfigInfoByCouponCode"); } return(result); }
/// <summary> /// 更新券码状态 /// </summary> /// <param name="pkid"></param> /// <param name="status"></param> /// <param name="user"></param> /// <returns></returns> public bool UpdateContinentalConfigStatus(long pkid, int status, string user) { var result = false; try { result = dbScopeManager.Execute(conn => DALMaPaiVip.UpdateContinentalConfigStatus(conn, pkid, status)) > 0; if (result) { InsertLog("UpdateContinentalConfigStatus", pkid.ToString(), $"IsDeleted:{status}", result ? "更新成功" : "更新成功", user); } } catch (Exception ex) { logger.Log(Level.Error, ex, "UpdateContinentalConfigStatus"); } return(result); }
/// <summary> /// 增加券码 /// </summary> /// <param name="couponCode"></param> /// <param name="user"></param> /// <returns></returns> public bool InsertCouponCodeConfig(string couponCode, string user) { var result = false; try { var pkid = dbScopeManager.Execute(conn => DALMaPaiVip.InsertContinentalConfig(conn, couponCode, false)); result = pkid > 0; if (result) { InsertLog("InsertCouponCodeConfig", pkid.ToString(), $"CouponCode:{couponCode}", result ? "添加成功" : "添加失败", user); } } catch (Exception ex) { logger.Log(Level.Error, ex, "InsertCouponCodeConfig"); } return(result); }
/// <summary> /// 验证上传券码的信息 /// </summary> /// <param name="data"></param> /// <returns></returns> public Tuple <List <MaPaiVipModel>, List <MaPaiVipModel>, string> VerifyData(List <MaPaiVipModel> data) { List <MaPaiVipModel> successData = new List <MaPaiVipModel>(); List <MaPaiVipModel> errorData = new List <MaPaiVipModel>(); var msg = string.Empty; try { if (data != null && data.Any()) { data = data.GroupBy(_ => _.UniquePrivilegeCode).Select(x => x.FirstOrDefault()).ToList(); if (data.GroupBy(_ => _.IsDeleted).Count() > 1) { msg = "上传的数据仅支持单向操作,即全增或全删"; } else { dbScopeReadManager.Execute(conn => { if (data.FirstOrDefault().IsDeleted) { foreach (var item in data) { var info = DALMaPaiVip.SelectContinentalConfigInfoByCouponCode(conn, item.UniquePrivilegeCode); if (info != null && !info.IsDeleted) { successData.Add(item); } else { msg = "该批次的券码在现有表中正常状态的券码中没有查找到数据,删除该券码后重新操作"; errorData.Add(item); } } } else { foreach (var item in data) { var info = DALMaPaiVip.SelectContinentalConfigInfoByCouponCode(conn, item.UniquePrivilegeCode); if (info != null) { msg = "该批次的券码与表中现有券码重复,请删除该券码后重新操作"; errorData.Add(item); } else { successData.Add(item); } } } }); } } } catch (Exception ex) { logger.Log(Level.Error, ex, "VerifyData"); } return(Tuple.Create(successData, errorData, msg)); }