public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
int PageSize = Convert.ToInt32(context.Request.Params["pagesize"]);
int currentpage = Convert.ToInt32(context.Request.Params["page"]);
string sWhere = "";
WhereFilter QF = null;
//条件
if (context.Request.Params["where"] != null)
{
QF = new JavaScriptSerializer().Deserialize <WhereFilter>(context.Request.Params["where"]);
//sWhere = QF.GetWhere();
}
//排序
if (context.Request.Params["sortorder"] != null)
{
string sortname = context.Request.Params["sortname"];
string sortorder = context.Request.Params["sortorder"];
sWhere += " order by " + sortname + " " + sortorder;
}
M_Data_Paging <M_CustomerInfo> lstMCusPage = SQLDBHelper.CreateDBClass <M_CustomerInfo_DB>().Query(QF, (currentpage - 1) * PageSize, currentpage * PageSize);
//分页
var griddata = new { Rows = lstMCusPage.lstTObj, Total = lstMCusPage.RowCount };
string str = new JavaScriptSerializer().Serialize(griddata);
context.Response.Write(str);
}
catch (Exception ex)
{
}
}
public M_Data_Paging <M_CustomerInfo> Query(WhereFilter wherefilter, int iSIndex, int iEIndex)
{
using (DBHelperContext dbcon = new DBHelperContext())
{
//动态分配条件
var predicate = PredicateBuilder.True <M_CustomerInfo>();
if (wherefilter != null)
{
foreach (Rules rule in wherefilter.rules)
{
if (rule.field.Equals("CusCode"))
{
predicate = predicate.And(p => p.CusCode.Contains(rule.value));
}
if (rule.field.Equals("CusName"))
{
predicate = predicate.And(p => p.CusName.Contains(rule.value));
}
}
}
var mcus = dbcon.M_CustomerInfos.Where(predicate.Compile());
int iRowCount = mcus.Count();
var mcusb = mcus.OrderBy(p => p.CusCode).Skip(iSIndex).Take(iEIndex - iSIndex).ToList();
M_Data_Paging <M_CustomerInfo> mdp_Ccus = new M_Data_Paging <M_CustomerInfo>()
{
RowCount = iRowCount,
lstTObj = mcusb,
};
return(mdp_Ccus);
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
int PageSize = Convert.ToInt32(context.Request.Params["pagesize"]);
int currentpage = Convert.ToInt32(context.Request.Params["page"]);
string sWhere = "";
WhereFilter QF = null;
//条件
if (context.Request.Params["where"] != null)
{
QF = new JavaScriptSerializer().Deserialize <WhereFilter>(context.Request.Params["where"]);
//sWhere = QF.GetWhere();
}
//排序
if (context.Request.Params["sortorder"] != null)
{
string sortname = context.Request.Params["sortname"];
string sortorder = context.Request.Params["sortorder"];
sWhere += " order by " + sortname + " " + sortorder;
}
//M_User m = new M_User
//{
// UserID = "a",
// UserName = "******",
// UserPwd = "s",
// UserPermission = "1,2",
// UserState = 1,
// Remark = "abc",
//};
//bool i = SQLDBHelper.CreateDBClass<M_User_DB>().Add(m);
M_Data_Paging <M_User> lstMUserPage = SQLDBHelper.CreateDBClass <M_User_DB>().Query(QF, (currentpage - 1) * PageSize, currentpage * PageSize);
//分页
var griddata = new { Rows = lstMUserPage.lstTObj, Total = lstMUserPage.RowCount };
string str = new JavaScriptSerializer().Serialize(griddata);
context.Response.Write(str);
}
catch (Exception ex)
{
}
}
public ActionResult Export(string id)
{
try
{
string sWhere = "";
//条件
WhereFilter QF = null;
if (!string.IsNullOrEmpty(Request.Params["where"]))
{
QF = new JavaScriptSerializer().Deserialize <WhereFilter>(Request.Params["where"]);
//sWhere = QF.GetWhere();
}
//DataTable dt = SQLDBHelper.MUser.QueryDT(sWhere, 1, int.MaxValue);
M_Data_Paging <M_User> lstMUserPage = SQLDBHelperClient.CreateUser().Query(QF, 1, int.MaxValue);
Stream stream = NPOIExcel.RenderDataTableToExcelHSS(lstMUserPage.lstTObj);
ViewBag.Succ = "1";
ViewBag.Msg = "数据下载成功!";
return(File(stream, "application/vnd.ms-excel", DateTime.Now.Ticks + ".xls"));
}
catch (Exception ex)
{
return(View("Query"));
}
}
public M_Data_Paging <M_User> Query(WhereFilter wherefilter, int iSIndex, int iEIndex)
{
using (DBHelperContext dbcon = new DBHelperContext())
{
//动态分配条件
var predicate = PredicateBuilder.True <M_User>();
//List<MemberInfo> lstM =typeof(M_User).GetMembers().ToList();
//var lstC=(from c in lstM
// select new {
// colName=c.Name,
// }).ToList();
//foreach (MemberInfo m in lstM)
//{
// modifyEntity.Property(m.Name).IsModified = true;
//}
if (wherefilter != null)
{
foreach (Rules rule in wherefilter.rules)
{
if (rule.field.Equals("UserID"))
{
predicate = predicate.And(p => p.UserID.Contains(rule.value));
}
if (rule.field.Equals("UserName"))
{
predicate = predicate.And(p => p.UserName.Contains(rule.value));
}
}
}
//if (string.IsNullOrEmpty(wherefilter.UserID))
//{
// predicate = predicate.And(p => p.UserID.Contains(wherefilter.UserID));
//}
//if (string.IsNullOrEmpty(wherefilter.UserName))
//{
// predicate = predicate.And(p => p.UserName.Contains(wherefilter.UserName));
//}
//predicate = predicate.And(p => p.UserActive.Equals(wherefilter.UserActive));
//if (string.IsNullOrEmpty(wherefilter.Remark))
//{
// predicate = predicate.And(p => p.Remark.Contains(wherefilter.Remark));
//}
var musers = dbcon.M_Users.Where(predicate.Compile());
int iRowCount = musers.Count();
var muserb = musers.OrderBy(p => p.UserID).Skip(iSIndex).Take(iEIndex - iSIndex).ToList();
M_Data_Paging <M_User> mdp_Users = new M_Data_Paging <M_User>()
{
RowCount = iRowCount,
lstTObj = muserb,
};
return(mdp_Users);
}
}
