/// <summary> /// 列表数据获取 /// </summary> /// <param name="page"></param> /// <param name="sid"></param> /// <returns></returns> public List<ProInvoiceModel> DataGet(int page,QueryModel queryModel) { //分页助手 PageHelper parameter = GetPageParameterInfo(); //ViewBag.SearchModel = model; ViewBag.PageParameter = parameter; string sid = queryModel.Sid; DataTable dt = new DataTable(); List<ProInvoiceModel> list = new List<ProInvoiceModel>(); using (SqlHelper sqlhelper = new SqlHelper()) { string sql = "select * from proinvoice where 1=1 "; if (!string.IsNullOrWhiteSpace(sid)) sql += " and sid like '" + sid + "%'"; if (!string.IsNullOrWhiteSpace(queryModel.Randnum)) sql += " and randnum like '" + queryModel.Randnum + "%'"; parameter.SqlScript =sql; parameter.OrderBy = string.IsNullOrWhiteSpace(parameter.OrderBy) ? " AddTime desc " : parameter.OrderBy; parameter.RecordCount = TypeParse.StrToInt( sqlhelper.ExecuteScalar(string.Format("select count(1) from {0}", parameter.SqlScript)), 0); dt = sqlhelper.ExecuteSql(parameter.ToString()); if (dt == null) return null; if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { ProInvoiceModel model = new ProInvoiceModel(); model.SID = (int) dt.Rows[i]["sid"]; model.ReceiveMan = dt.Rows[i]["receiveman"].ToString(); model.AddTime = (DateTime) dt.Rows[i]["addtime"]; model.BusinessId = (int) dt.Rows[i]["BusinessId"]; model.InvoiceTypeId = (int) dt.Rows[i]["InvoiceTypeId"]; model.Randnum = dt.Rows[i]["Randnum"].ToString(); model.Randint = (int) dt.Rows[i]["Randint"]; list.Add(model); } } } return list; }
/// <summary> /// 分页数据获取 /// </summary> /// <param name="page"></param> /// <param name="sid"></param> public void PageGet(int page,QueryModel model) { //分页助手 PageHelper parameter = GetPageParameterInfo(); ViewBag.PageParameter = parameter; string sid = model.Sid; DataTable dt = new DataTable(); List<ProInvoiceModel> list = new List<ProInvoiceModel>(); using (SqlHelper sqlhelper = new SqlHelper()) { string sql = "select * from proinvoice"; if (!string.IsNullOrWhiteSpace(sid)) sql += " where sid like '" + sid + "%'"; if (!string.IsNullOrWhiteSpace(model.Randnum)) sql += " and randnum like '" + model.Randnum + "%'"; parameter.SqlScript = sql; parameter.OrderBy = string.IsNullOrWhiteSpace(parameter.OrderBy) ? " AddTime desc " : parameter.OrderBy; parameter.RecordCount = TypeParse.StrToInt( sqlhelper.ExecuteScalar(string.Format("select count(1) from {0}", parameter.SqlScript)), 0); } }
// // GET: /Pagewidget/ public ActionResult Index(QueryModel model,int page = 1) { ViewBag.queryModel = model; if (string.IsNullOrWhiteSpace(Request.Form["idCard"])) ViewBag.idCard = string.Empty; else ViewBag.idCard = Request.Form["idCard"] + GetValidateCode(Request.Form["idCard"]); return View(DataGet(page, model)); }