/// <summary>
/// 数据导出
/// </summary>
public void ExportExcel([DefaultValue(-1)] int Stuts, string Keyword, string Role)
{
Ho_PartnerUserBll bll = new Ho_PartnerUserBll();
var ListData = bll.GetPageList(Keyword, Role, Stuts);
var newlist = new List <Ho_PartnerUserNew>();
foreach (var item in ListData)
{
var model = new Ho_PartnerUserNew();
model.Address = item.Address;
model.CardCode = item.CardCode;
model.CreatTime = item.CreatTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
model.Account = item.Account;
model.Money = item.Money.Value.ToString("0.00");
model.Name = item.Name;
model.Remark = item.Remark;
model.StatusStr = item.StatusStr;
model.UserRole = item.UserRole;
newlist.Add(model);
}
string[] columns = new string[] { "姓名:Name", "身份证号:CardCode", "手机号:Account", "角色:UserRole",
"余额:Money", "地址:Address", "创建时间:CreatTime", "状态:StatusStr", "备注:Remark" };
DeriveExcel.ListToExcel <Ho_PartnerUserNew>(newlist, columns, "会员数据" + DateTime.Now.ToString("yyyyMMddHHmmss"));
}
/// <summary>
/// 搜索
/// </summary>
/// <returns></returns>
public ActionResult GridPageListJson(JqGridParam jqgridparam, string Role, string Keyword, [DefaultValue(-1)] int Stuts)
{
try
{
Stopwatch watch = CommonHelper.TimerStart();
Ho_PartnerUserBll bll = new Ho_PartnerUserBll();
var ListData = bll.GetPageList(ref jqgridparam, Keyword, Role, Stuts);
var JsonData = new
{
total = jqgridparam.total,
page = jqgridparam.page,
records = jqgridparam.records,
costtime = CommonHelper.TimerEnd(watch),
rows = ListData
};
return(Content(JsonData.ToJson()));
}
catch (Exception ex)
{
Base_SysLogBll.Instance.WriteLog("", OperationType.Query, "-1", "异常错误：" + ex.Message);
return(null);
}
}
