public JsonResult GetCustomers()
{
DatatablesResult<CustomerVO> result = new DatatablesResult<CustomerVO>();
try
{
int start = NullHelper.Convert<int>(Request[Constants.PAGE_START], 0);
int length = NullHelper.Convert<int>(Request[Constants.PAGE_LENGTH], 10);
int draw = NullHelper.Convert<int>(Request[Constants.REQ_DRAW], 1);
string sortOrder = NullHelper.Convert<string>(Request[Constants.SORT_ORDER], "asc");
int sortIdx = NullHelper.Convert<int>(Request[Constants.SORT_IDX], 0);
string columnKey = string.Format(Constants.SORT_NAME, sortIdx);
string sortName = NullHelper.Convert<string>(Request[columnKey], "Name");
string name = NullHelper.Convert<string>(Request["Name"], "");
string icNo = NullHelper.Convert<string>(Request["ICNo"], "");
string mobileNo = NullHelper.Convert<string>(Request["MobileNo"], "");
int cardFlag = NullHelper.Convert<int>(Request["CardFlag"], -1);
CustomerQueryEntity filter = new CustomerQueryEntity(){
Start = start,
Length = length,
SortOrder = sortOrder,
SortName = sortName,
Name = name,
ICNo = icNo,
MobileNo = mobileNo,
CardFlag = cardFlag
};
var mocker = new BizMocker();
var list = mocker.GetCustomers(filter);
int recordsTotal = list.Count;
foreach (var item in list)
{
item.DT_RowId = item.CustomerID.ToString();
if (item.CardFlag == 1)
{
item.CardFlagDesc = "<i class='fa fa-check fa-lg' style='color:green;'></i>";
item.ClubCardDesc = "<a href='javascript:void(0)'><i class='fa fa-search'></i> 查看</a>";
}
else
{
item.CardFlagDesc = "<i class='fa fa-times fa-lg red' style='color:red;'></i>";
item.ClubCardDesc = "<a href='javascript:void(0)'> <i class='fa fa-credit-card'></i> 开卡</a>";
}
item.CarDesc = "<a href='javascript:void(0)'><i class='fa fa-search'></i> 查看</a>";
item.Operation = "<a href='javascript:void(0)' onclick='Customer.Edit("
+ item.DT_RowId + ")'><i class='fa fa-pencil'></i> 编辑</a> | <a href='javascript:void(0)' onclick='Package.Del("
+ item.DT_RowId + ")'><i class='fa fa-times'></i> 删除</a>";
}
result.draw = draw;
result.recordsTotal = recordsTotal;
result.recordsFiltered = recordsTotal;
result.data = list;
}
catch (Exception ex)
{
LogHandler.Error(ex.Message.ToString());
}
return Json(result, JsonRequestBehavior.AllowGet);
}
public JsonResult GetCludCardList()
{
DatatablesResult<ClubCardVO> result = new DatatablesResult<ClubCardVO>();
try{
int start = NullHelper.Convert<int>(Request[Constants.PAGE_START], 0);
int length = NullHelper.Convert<int>(Request[Constants.PAGE_LENGTH], 10);
int draw = NullHelper.Convert<int>(Request[Constants.REQ_DRAW], 1);
string sortOrder = NullHelper.Convert<string>(Request[Constants.SORT_ORDER], "asc");
int sortIdx = NullHelper.Convert<int>(Request[Constants.SORT_IDX], 0);
string columnKey = string.Format(Constants.SORT_NAME, sortIdx);
string sortName = NullHelper.Convert<string>(Request[columnKey], "ClubcardNO");
string cardno = NullHelper.Convert<string>(Request["ClubcardNO"], "");
int cardtype = NullHelper.Convert<int>(Request["ClubcardType"], -1);
string custName = NullHelper.Convert<string>(Request["CustomerName"], "");
string mobileNo = NullHelper.Convert<string>(Request["MobileNo"], "");
int cardstatus = NullHelper.Convert<int>(Request["CardStatus"], -1);
string storename = NullHelper.Convert<string>(Request["SaleCardStore"], "");
if(sortName=="MobileNo"||sortName=="CardStatusDesc")
{
sortName="ClubcardNO";
}
ClubCardTypeMgm clucardbMgm = new ClubCardTypeMgm();
ClubCardTypeVO clubcardtype = clucardbMgm.GetCardTypeByID(cardtype);
IClubCardMgm clubcardMgm = new ClubCardMgm();
ClubCardQueryEntity filter = new ClubCardQueryEntity()
{
Start = start, Length = length, SortOrder= sortOrder,SortName=sortName, ClubCardNo = cardno,
ClubCardTypeID = cardtype,ClubCardTypeName ="", MobileNo=mobileNo, Name=custName,
StoreName = storename,CardStatus = cardstatus
};
var list = clubcardMgm.GetClubCards(filter);
int recordsTotal = clubcardMgm.GetClubCardRecordCount(filter);
list.ForEach(i => i.MobileNo = new CustomerMgm().GetCustomerByID(i.CustomerID).MobileNO);
foreach (var item in list)
{
item.DT_RowId = item.ClubCardID.ToString();
switch(item.CardStatus)
{
case (int)ClubCardStatus.OpenCard: item.CardStatusDesc = "已开卡";
break;
case (int)ClubCardStatus.Froze: item.CardStatusDesc = "已冻结";
break;
case (int)ClubCardStatus.ReportLoss: item.CardStatusDesc = "已挂失";
break;
case (int)ClubCardStatus.LogOff: item.CardStatusDesc = "已注销";
break;
case (int)ClubCardStatus.Expire: item.CardStatusDesc = "已过期";
break;
}
item.Operation = " <div class='btn-group'><button onclick='ClubCard.Operation("
+ item.DT_RowId + ")' class='btn blue dropdown-toggle' type='button' data-toggle='dropdown'>操作 <i class='fa fa-angle-down'></i></button> <ul class='dropdown-menu pull-right' role='menu'><li><a href='" + @Url.Action("ClubCardDetails", "ClubCard") + "?type=card&id=" + item.DT_RowId + "'>查看</a></li><li><a href='#'>套餐余额</a></li><li><a href='" + @Url.Action("ResetPassword", "ClubCard") + "?id=" + item.DT_RowId + "'>修改密码</a></li><li class='divider'></li><li><a href='" + @Url.Action("SetCardStatus", "ClubCard") + "?id=" + item.DT_RowId + "'>挂失/冻结</a></li>{0}<li><a href='" + @Url.Action("Index", "Recharge") + "?id=" + item.DT_RowId + "'>会员充值</a></li> <li><a href=''>会员消费</a></li><li><a href=''>已完结套餐查询</a></li></ul></div>";
string strChangeno = "<li><a href='javascript:;' onclick='alert(\"该会员卡不处于挂失状态，不能补办会员卡\")' >补办会员卡</a></li>";
if (item.CardStatus == 1)
{
strChangeno = "<li><a href='" + @Url.Action("ChangeCardNo", "ClubCard") + "?id=" + item.DT_RowId + "'>补办会员卡</a></li>";
}
item.Operation = string.Format(item.Operation, strChangeno);
}
result.draw = draw;
result.recordsTotal = recordsTotal;
result.recordsFiltered = recordsTotal;
result.data = list;
}
catch (Exception ex)
{
result.data = new List<ClubCardVO>();
LogHandler.Error(ex.Message.ToString());
result.error = ex.ToString();
}
return Json(result, JsonRequestBehavior.AllowGet);
}
public JsonResult GetCludCardList()
{
DatatablesResult <ClubCardVO> result = new DatatablesResult <ClubCardVO>();
try{
int start = NullHelper.Convert <int>(Request[Constants.PAGE_START], 0);
int length = NullHelper.Convert <int>(Request[Constants.PAGE_LENGTH], 10);
int draw = NullHelper.Convert <int>(Request[Constants.REQ_DRAW], 1);
string sortOrder = NullHelper.Convert <string>(Request[Constants.SORT_ORDER], "asc");
int sortIdx = NullHelper.Convert <int>(Request[Constants.SORT_IDX], 0);
string columnKey = string.Format(Constants.SORT_NAME, sortIdx);
string sortName = NullHelper.Convert <string>(Request[columnKey], "ClubcardNO");
string cardno = NullHelper.Convert <string>(Request["ClubcardNO"], "");
int cardtype = NullHelper.Convert <int>(Request["ClubcardType"], -1);
string custName = NullHelper.Convert <string>(Request["CustomerName"], "");
string mobileNo = NullHelper.Convert <string>(Request["MobileNo"], "");
int cardstatus = NullHelper.Convert <int>(Request["CardStatus"], -1);
string storename = NullHelper.Convert <string>(Request["SaleCardStore"], "");
if (sortName == "MobileNo" || sortName == "CardStatusDesc")
{
sortName = "ClubcardNO";
}
ClubCardTypeMgm clucardbMgm = new ClubCardTypeMgm();
ClubCardTypeVO clubcardtype = clucardbMgm.GetCardTypeByID(cardtype);
IClubCardMgm clubcardMgm = new ClubCardMgm();
ClubCardQueryEntity filter = new ClubCardQueryEntity()
{
Start = start, Length = length, SortOrder = sortOrder, SortName = sortName, ClubCardNo = cardno,
ClubCardTypeID = cardtype, ClubCardTypeName = "", MobileNo = mobileNo, Name = custName,
StoreName = storename, CardStatus = cardstatus
};
var list = clubcardMgm.GetClubCards(filter);
int recordsTotal = clubcardMgm.GetClubCardRecordCount(filter);
list.ForEach(i => i.MobileNo = new CustomerMgm().GetCustomerByID(i.CustomerID).MobileNO);
foreach (var item in list)
{
item.DT_RowId = item.ClubCardID.ToString();
switch (item.CardStatus)
{
case (int)ClubCardStatus.OpenCard: item.CardStatusDesc = "已开卡";
break;
case (int)ClubCardStatus.Froze: item.CardStatusDesc = "已冻结";
break;
case (int)ClubCardStatus.ReportLoss: item.CardStatusDesc = "已挂失";
break;
case (int)ClubCardStatus.LogOff: item.CardStatusDesc = "已注销";
break;
case (int)ClubCardStatus.Expire: item.CardStatusDesc = "已过期";
break;
}
item.Operation = " <div class='btn-group'><button onclick='ClubCard.Operation("
+ item.DT_RowId + ")' class='btn blue dropdown-toggle' type='button' data-toggle='dropdown'>操作 <i class='fa fa-angle-down'></i></button> <ul class='dropdown-menu pull-right' role='menu'><li><a href='" + @Url.Action("ClubCardDetails", "ClubCard") + "?type=card&id=" + item.DT_RowId + "'>查看</a></li><li><a href='#'>套餐余额</a></li><li><a href='" + @Url.Action("ResetPassword", "ClubCard") + "?id=" + item.DT_RowId + "'>修改密码</a></li><li class='divider'></li><li><a href='" + @Url.Action("SetCardStatus", "ClubCard") + "?id=" + item.DT_RowId + "'>挂失/冻结</a></li>{0}<li><a href='" + @Url.Action("Index", "Recharge") + "?id=" + item.DT_RowId + "'>会员充值</a></li> <li><a href=''>会员消费</a></li><li><a href=''>已完结套餐查询</a></li></ul></div>";
string strChangeno = "<li><a href='javascript:;' onclick='alert(\"该会员卡不处于挂失状态，不能补办会员卡\")' >补办会员卡</a></li>";
if (item.CardStatus == 1)
{
strChangeno = "<li><a href='" + @Url.Action("ChangeCardNo", "ClubCard") + "?id=" + item.DT_RowId + "'>补办会员卡</a></li>";
}
item.Operation = string.Format(item.Operation, strChangeno);
}
result.draw = draw;
result.recordsTotal = recordsTotal;
result.recordsFiltered = recordsTotal;
result.data = list;
}
catch (Exception ex)
{
result.data = new List <ClubCardVO>();
LogHandler.Error(ex.Message.ToString());
result.error = ex.ToString();
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
public void GetAllMsgList()
{
try
{
var reult = new ListMsgWithCount()
{
Count = 0
};
var currentLoginUser = Session[MXKeys.SESSION_ADMIN_INFO] as Model.manager;
if (currentLoginUser == null)
{
throw new Exception("用户未登陆！");
}
List <MessageDto> result = new List <MessageDto>();
int index = 1;
int draw = MyCommFun.QueryString("draw").ToInt();
int start = MyCommFun.QueryString("start").ToInt();
int length = MyCommFun.QueryString("length").ToInt();
string search = MyCommFun.QueryString("search.value");
var returnData = new DatatablesResult <List <MessageDto> >();
//获取短消息
var userDto = _userService.Get(currentLoginUser);
var list = _msgService.GetAllLastNewMsg(userDto);
if (list != null && list.Any())
{
var newList = list.Select(c => new MessageDto()
{
Number = index++,
Id = c.Msg.Id,
Title = String.Format("{0}条新消息", c.Count),
Content = c.Msg.Content,
CreateTime = c.Msg.CreateTime,
FromUserId = c.Msg.FromUserId,
FromUserName = c.Msg.FromUser.DisplayName
}).ToList();
result.AddRange(newList);
}
;
returnData.RecordsTotal = result.Count();
returnData.RecordsFiltered = returnData.RecordsTotal;
if (string.IsNullOrEmpty(search))
{
returnData.Data = result.Skip(start).Take(length).ToList();
}
else
{
returnData.Data = result.Where(c =>
c.FromUserName.Contains(search)
// ||c.Content.Contains(search)
).Skip(start).Take(length).ToList();
}
returnData.Draw = draw;
Context.Response.Write(AjaxResult.Success(returnData).ToCamelString());
}
catch (UnAuthException jsEx)
{
Context.Response.Write(AjaxResult.Error(jsEx.RedirectUrl, jsEx.Code).ToCamelString());
}
catch (Exception ex)
{
Context.Response.Write(AjaxResult.Error(ex.Message).ToCamelString());
}
}
public JsonResult GetCustomers()
{
DatatablesResult <CustomerVO> result = new DatatablesResult <CustomerVO>();
try
{
int start = NullHelper.Convert <int>(Request[Constants.PAGE_START], 0);
int length = NullHelper.Convert <int>(Request[Constants.PAGE_LENGTH], 10);
int draw = NullHelper.Convert <int>(Request[Constants.REQ_DRAW], 1);
string sortOrder = NullHelper.Convert <string>(Request[Constants.SORT_ORDER], "desc");
int sortIdx = NullHelper.Convert <int>(Request[Constants.SORT_IDX], 0);
string columnKey = string.Format(Constants.SORT_NAME, sortIdx);
string sortName = NullHelper.Convert <string>(Request[columnKey], "CustomerID");
if (sortName == "CardFlagDesc" || sortName == "ClubCardDesc" || sortName == "CarDesc" || sortName == "Operation")
{
sortName = "CustomerID";
}
string name = NullHelper.Convert <string>(Request["Name"], "");
string icNo = NullHelper.Convert <string>(Request["ICNo"], "");
string mobileNo = NullHelper.Convert <string>(Request["MobileNo"], "");
int cardFlag = NullHelper.Convert <int>(Request["CardFlag"], -1);
CustomerQueryEntity filter = new CustomerQueryEntity()
{
Start = start,
Length = length,
SortOrder = sortOrder,
SortName = sortName,
Name = name,
ICNo = icNo,
MobileNo = mobileNo,
CardFlag = cardFlag
};
ICustomerMgm coustomer = new CustomerMgm();
var list = coustomer.GetCustomers(filter);
if (list == null)
{
list = new List <CustomerVO>();
}
int recordsTotal = coustomer.GetRecordCount(filter);
foreach (var item in list)
{
item.DT_RowId = item.CustomerID.ToString();
if (item.CardFlag == 1)
{
item.CardFlagDesc = "<i class='fa fa-check fa-lg' style='color:green;'></i>";
item.ClubCardDesc = "<a href='javascript:void(0)' onclick='Customer.EditClubcard(" + item.DT_RowId + ")'><i class='fa fa-search'></i> 查看</a>";
}
else
{
item.CardFlagDesc = "<i class='fa fa-times fa-lg red' style='color:red;'></i>";
item.ClubCardDesc = "<a href='javascript:void(0)' onclick='Customer.AddCludcard(" + item.DT_RowId + ")'> <i class='fa fa-credit-card'></i> 开卡</a>";
}
item.CarDesc = "<a href='javascript:void(0)' onclick='Customer.EditCar(" + item.DT_RowId + ")'><i class='fa fa-search'></i> 查看</a>";
item.Operation = "<a href='javascript:void(0)' onclick='Customer.Edit("
+ item.DT_RowId + ")'><i class='fa fa-pencil'></i> 编辑</a> | <a href='javascript:void(0)' onclick='Customer.Del("
+ item.DT_RowId + ")'><i class='fa fa-times'></i> 删除</a>";
}
result.draw = draw;
result.recordsTotal = recordsTotal;
result.recordsFiltered = recordsTotal;
result.data = list;
}
catch (Exception ex)
{
result.data = new List <CustomerVO>();
LogHandler.Error(ex.Message.ToString());
result.error = ex.ToString();
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
