public static List <tbl_UserTransportation> GetUseTransMoney()
{
List <tbl_UserTransportation> list = new List <tbl_UserTransportation>();
DataTable dt = DALUserPermission.GetUseTransMoney();
if (dt == null || dt.Rows.Count <= 0)
{
tbl_UserTransportation model1 = new tbl_UserTransportation();
model1.Rank = 1;
tbl_UserTransportation model2 = new tbl_UserTransportation();
model2.Rank = 2;
tbl_UserTransportation model3 = new tbl_UserTransportation();
model3.Rank = 3;
tbl_UserTransportation model4 = new tbl_UserTransportation();
model4.Rank = 4;
list.Add(model1);
list.Add(model2);
list.Add(model3);
list.Add(model4);
}
else
{
foreach (DataRow dr in dt.Rows)
{
tbl_UserTransportation item = new tbl_UserTransportation(dr);
list.Add(item);
}
}
return(list);
}
public ActionResult Edit(int id, int memberGradeId = 0)
{
var memberBll = new MemberService();
var memberGradeList = memberBll.GetMembershipsGradeList();
ViewBag.MemberGrade = memberGradeList;
ViewBag.CheckCycle = CheckCycleDllList();
ViewBag.PermissionType = PermissionTypeDllList();
if (id <= 0)
{
ViewBag.Title = "添加用户权益信息";
return(View(new UserPermissionModel()
{
MembershipsGradeId = memberGradeId
}));
}
else
{
ViewBag.Title = "编辑用户权益信息";
var model = DALUserPermission.GetModelById(id);
if (model == null)
{
model = new UserPermissionModel();
}
return(View(model));
}
}
public JsonResult Edit(UserPermissionModel model)
{
if (model == null)
{
return(Json(new { result = 0, msg = "无法获取数据对象" }));
}
var result = 0;
if (string.IsNullOrWhiteSpace(model.EndVersion))
{
model.EndVersion = "9.9.9";
}
model.LastUpdateBy = HttpContext.User.Identity.Name;
if (model.Id <= 0)
{
model.CreateBy = model.LastUpdateBy;
result = DALUserPermission.Add(model);
}
else
{
model.LastUpdateDateTime = DateTime.Now;
result = DALUserPermission.Update(model);
}
var oprLog = new Tuhu.Provisioning.DataAccess.Entity.OprLog
{
ObjectID = model.Id,
ObjectType = "UserPermission",
Author = HttpContext.User.Identity.Name,
Operation = model.Id > 0 ? "更新" : "新增" + "UserLivingRights配置"
};
var operLogManager = new Business.OprLogManagement.OprLogManager();
return(Json(new { result = result, msg = "操作成功" }));
}
public ActionResult Edit(int id, int membershipsGradeId, string memberGradeName)
{
if (membershipsGradeId > 0)
{
var queryModel = new UserPermissionModel()
{
MembershipsGradeId = membershipsGradeId
};
//获取对应的生活权益(当前可观的时间范围内，相同等级下的会员权益不会超过100条)
var userPermissionList = DALUserPermission.QueryPageList(queryModel, 1, 100);
ViewBag.UserPermissionList = userPermissionList;
}
if (ViewBag.UserPermissionList == null)
{
ViewBag.UserPermissionList = new List <UserPermissionModel>();
}
ViewBag.MembershipsGradeId = membershipsGradeId;
ViewBag.MemberGradeName = memberGradeName;
if (id <= 0)
{
ViewBag.Title = "添加权益奖励信息";
return(View(new UserPromotionCodeModel()));
}
else
{
ViewBag.Title = "编辑权益奖励信息";
var model = DALUserPromotionCode.GetModelById(id);
if (model == null)
{
model = new UserPromotionCodeModel();
}
return(View(model));
}
}
public JsonResult DeleteById(string ids)
{
try
{
if (string.IsNullOrWhiteSpace(ids))
{
return(Json(new { data = 0, msg = "未能获取数据" }));
}
var operLogManager = new Business.OprLogManagement.OprLogManager();
var result = 0;
foreach (var strId in ids.Split(','))
{
if (string.IsNullOrWhiteSpace(strId))
{
continue;
}
var id = int.Parse(strId);
result += DALUserPermission.Delete(id);
var oprLog = new Tuhu.Provisioning.DataAccess.Entity.OprLog
{
ObjectID = id,
ObjectType = "UserPermission",
Author = HttpContext.User.Identity.Name,
Operation = "删除UserPermission配置"
};
operLogManager.AddOprLogAsync(oprLog);
}
return(Json(new { data = result, msg = "删除成功" }));
}
catch (Exception e)
{
return(Json(new { data = -1, msg = "删除异常：" + e.ToString() }));
}
}
public static int Delete(string id)
{
if (string.IsNullOrEmpty(id))
{
return(0);
}
return(DALUserPermission.Delete(id));
}
public static IEnumerable <UserPermissionModel> SelectUserPermissionByPage(int page, int pageSize)
{
var dt = DALUserPermission.SelectUserPermissionByPage(page, pageSize);
if (dt == null || dt.Rows.Count <= 0)
{
return(new UserPermissionModel[0]);
}
return(dt.Rows.Cast <DataRow>().Select(row => new UserPermissionModel(row)));
}
public static IEnumerable <UserPermissionModel> SelectAllUserPermission()
{
var dt = DALUserPermission.SelectAllUserPermission();
if (dt == null || dt.Rows.Count <= 0)
{
return(new UserPermissionModel[0]);
}
return(dt.Rows.Cast <DataRow>().Select(row => new UserPermissionModel(row)));
}
public static UserPermissionActivityProduct GetActivityProduct(string pkID)
{
var dt = DALUserPermission.GetActivityProduct(pkID);
if (dt == null || dt.Rows.Count <= 0)
{
return(null);
}
return(new UserPermissionActivityProduct(dt.Rows[0]));
}
public static bool DeletePromotion(string id)
{
if (string.IsNullOrEmpty(id))
{
return(false);
}
else
{
return(DALUserPermission.DeletePromotion(id));
}
}
public static UserPermissionModel GetUserPermission(string id)
{
if (string.IsNullOrEmpty(id))
{
return(null);
}
else
{
return(DALUserPermission.GetUserPermission(id));
}
}
public static bool EditTask(tbl_UserTask model)
{
if (model.ID <= 0)
{
return(DALUserPermission.AddTask(model));
}
else
{
return(DALUserPermission.UpdateTask(model));
}
}
/// <summary>
/// 添加商品
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public static bool AddByActivityProduct(UserPermissionActivityProduct model)
{
if (model.PKID == 0)
{
return(DALUserPermission.AddByActivityProduct(model));
}
else
{
return(DALUserPermission.UpdateByActivityProduct(model));
}
}
public static bool EditPromotion(tbl_UserPromotionCode model)
{
if (model.ID <= 0)
{
return(DALUserPermission.AddPromotion(model));
}
else
{
return(DALUserPermission.UpdatePromotion(model));
}
}
public static IEnumerable <tbl_UserPromotionCode> GetPromotionList(string userRank)
{
DataTable dt = DALUserPermission.GetPromotionList(userRank);
if (dt == null || dt.Rows.Count <= 0)
{
return(new List <tbl_UserPromotionCode>());
}
else
{
return(dt.Rows.Cast <DataRow>().Select(row => new tbl_UserPromotionCode(row)));
}
}
public static IEnumerable <tbl_UserTask> GetTaskList(string appType)
{
DataTable dt = DALUserPermission.GetTaskList(appType);
if (dt == null || dt.Rows.Count <= 0)
{
return(new List <tbl_UserTask>());
}
else
{
return(dt.Rows.Cast <DataRow>().Select(row => new tbl_UserTask(row)));
}
}
/// <summary>
/// 获取产品列表
/// </summary>
/// <param name="activityID"></param>
/// <returns></returns>
public static IEnumerable <UserPermissionActivityProduct> GetActivityProductList(string activityID)
{
Guid guid;
if (Guid.TryParse(activityID, out guid))
{
DataTable dt = DALUserPermission.GetActivityProductList(activityID);
return(dt.Rows.Cast <DataRow>().Select(row => new UserPermissionActivityProduct(row)));
}
else
{
return(null);
}
}
public static tbl_UserPromotionCode GetPromotion(string id)
{
if (string.IsNullOrEmpty(id))
{
return(new tbl_UserPromotionCode());
}
else
{
DataTable dt = DALUserPermission.GetPromotion(id);
if (dt != null && dt.Rows.Count > 0)
{
return(new tbl_UserPromotionCode(dt.Rows[0]));
}
else
{
return(new tbl_UserPromotionCode());
}
}
}
public async Task <JsonResult> GetUserPermissionByPage(UserPermissionRequest request)
{
var returnValue = new List <UserPermissionViewModel>();
if (request == null)
{
return(Json(new { code = -1, msg = "无参数信息", count = 0, data = returnValue }, JsonRequestBehavior.AllowGet));
}
if (request.Page <= 0)
{
request.Page = 1;
}
if (request.Limit <= 0)
{
request.Limit = 50;
}
var memberBll = new MemberService();
var requestModel = new UserPermissionModel {
Name = request.PermissionName,
MembershipsGradeId = request.MembershipsGradeId
};
var count = DALUserPermission.QueryPageCount(requestModel);
var dataResult = DALUserPermission.QueryPageList(requestModel, request.Page, request.Limit);
var memberGradeList = await memberBll.GetMembershipsGradeListAsync();
if (memberGradeList != null && memberGradeList.Count > 0 && dataResult != null && dataResult.Count > 0)
{
foreach (var userPermission in dataResult)
{
var viewModel = ObjectMapper.ConvertTo <UserPermissionModel, UserPermissionViewModel>(userPermission);
var gradeModel = memberGradeList.Find(t => t.PKID == userPermission.MembershipsGradeId);
viewModel.LastUpdateDateTime = userPermission.LastUpdateDateTime.ToString("yyyy-MM-dd HH:mm:ss");
viewModel.CreateDatetime = userPermission.CreateDatetime.ToString("yyyy-MM-dd HH:mm:ss");
if (gradeModel != null)
{
viewModel.MembershipsGradeName = gradeModel.GradeName;
}
returnValue.Add(viewModel);
}
}
return(Json(new { code = 0, msg = "加载成功", count = count, data = returnValue.OrderByDescending(t => t.Id) }, JsonRequestBehavior.AllowGet));
}
public static bool SaveTransMoney(List <tbl_UserTransportation> list)
{
try
{
foreach (var item in list)
{
if (DALUserPermission.Exist(item.Rank.ToString()))
{
DALUserPermission.UpdateTrans(item);
}
else
{
DALUserPermission.AddUseTrans(item);
}
}
return(true);
}
catch (Exception em)
{
return(false);
}
}
public static bool DeleteByActivityProduct(string activityID, string pkid)
{
return(DALUserPermission.DeleteByActivityProduct(activityID, pkid));
}
public static int Add(UserPermissionModel model)
{
int i = DALUserPermission.AddUserPermission(model);
return(i);
}
public static int Update(UserPermissionModel model)
{
int i = DALUserPermission.UpdateUserPermission(model);
return(i);
}
public BLLUserPermission()
{
_DALUserPermission = new DAL.DALUserPermission();
}
public static int GetRowCount()
{
return(DALUserPermission.GetRowCount());
}
