private string GetList(HttpContext context)
{
int pageIndex = ObjectConvertHelper.ConvertToInt(context.Request["page"]);
int pageSize = ObjectConvertHelper.ConvertToInt(context.Request["limit"]);
string name = ObjectConvertHelper.ConvertToString(context.Request["txtName"]);
string strWhere = "";
if (!string.IsNullOrEmpty(name))
{
strWhere += " and (UserName like '%" + name + "%' or StaffName like '%" + name + "%' )";
}
StaffsBLL bll = new StaffsBLL();
List <Staffs> list = bll.GetList(strWhere, pageIndex, pageSize);
int count = bll.GetCount(strWhere);
var iso = new IsoDateTimeConverter();
iso.DateTimeFormat = "yyyy-MM-dd";
return(JsonConvert.SerializeObject(new
{
code = "0",
msg = "",
count = count,
data = list
}, iso));
}
private string GetList(HttpContext context)
{
int pageIndex = ObjectConvertHelper.ConvertToInt(context.Request["page"]);
int pageSize = ObjectConvertHelper.ConvertToInt(context.Request["limit"]);
string name = ObjectConvertHelper.ConvertToString(context.Request["txtName"]);
string strWhere = " and OrderType=1 ";
if (!string.IsNullOrEmpty(name))
{
strWhere += " and OrderType=1 and UserName like '%" + name + "%' ";
}
if (context.User != null)
{
OrdersBLL bll = new OrdersBLL();
List <Orders> list = bll.GetList(strWhere, pageIndex, pageSize);
var config = new MapperConfiguration(cfg => cfg.CreateMap <Orders, ViewOrders>()
.ForMember(dest => dest.Sex, opt => opt.MapFrom((src, des) => { if (src.Sex == 1)
{
return("男");
}
return("女"); }))
.ForMember(dest => dest.CreateTime, opt => opt.MapFrom((src, des) => src.CreateTime.ToString("yyyy-MM-dd HH:mm"))));
var mapper = config.CreateMapper();
List <ViewOrders> list2 = mapper.Map <List <Orders>, List <ViewOrders> >(list);
int count = bll.GetCount(strWhere);
return(JsonConvert.SerializeObject(new
{
code = "0",
msg = "",
count = count,
data = list2
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
code = "0",
msg = "",
count = 0,
data = ""
}));
}
}
private string GetList(HttpContext context)
{
int pageIndex = ObjectConvertHelper.ConvertToInt(context.Request["page"]);
int pageSize = ObjectConvertHelper.ConvertToInt(context.Request["limit"]);
string name = ObjectConvertHelper.ConvertToString(context.Request["txtName"]);
string strWhere = "";
if (!string.IsNullOrEmpty(name))
{
strWhere += " and Name like '%" + name + "%' ";
}
if (context.User != null)
{
SysMenuBLL bll = new SysMenuBLL();
List <SysMenu> list = bll.GetList(strWhere, pageIndex, pageSize);
int count = bll.GetCount(strWhere);
return(JsonConvert.SerializeObject(new
{
code = "0",
msg = "",
count = count,
data = list
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
code = "0",
msg = "",
count = 0,
data = ""
}));
}
}
private string GetOrderDetail(HttpContext context)
{
string orderNo = ObjectConvertHelper.ConvertToString(context.Request["OrderNo"]);
string strWhere = "";
if (!string.IsNullOrEmpty(orderNo))
{
strWhere += string.Format(" and orderNo='{0}'", orderNo);
}
if (context.User != null)
{
OrderDetailBLL bll = new OrderDetailBLL();
List <Models.OrderDetail> list = bll.GetList(strWhere);
var config = new MapperConfiguration(cfg => cfg.CreateMap <Models.OrderDetail, ViewOrderDetail>()
.ForMember(dest => dest.SPPaymentAge, opt => opt.MapFrom((src, des) => src.SPPaymentAge.ToString() + "年"))
.ForMember(dest => dest.SavingProduct, opt => opt.MapFrom((src, des) =>
{
if (src.ProductType == 1) //储蓄类
{
switch (src.SavingProduct)
{
case 1:
return("财富20");
case 2:
return("金瑞20");
default:
return("");
}
}
else //保障类
{
switch (src.SavingProduct)
{
case 10:
return("成人平安福");
case 20:
return("少儿平安福");
case 30:
return("大福星");
case 40:
return("小福星");
case 50:
return("福满分");
case 60:
return("爱满分");
default:
return("");
}
}
}))
.ForMember(dest => dest.CreateTime, opt => opt.MapFrom((src, des) => src.CreateTime.ToString("yyyy-MM-dd HH:mm"))));
var mapper = config.CreateMapper();
List <ViewOrderDetail> list2 = mapper.Map <List <Models.OrderDetail>, List <ViewOrderDetail> >(list);
int count = bll.GetCount(strWhere);
return(JsonConvert.SerializeObject(new
{
code = "0",
msg = "",
count = count,
data = list2
}));
}
else
{
return(JsonConvert.SerializeObject(new
{
code = "0",
msg = "",
count = 0,
data = ""
}));
}
}