[HttpGet]// /admin/department/tabledataks public void tabledataks() { try { Response.Clear(); StringBuilder sb = new StringBuilder(); sb.Append("companyID=" + adminLogin.companyID.ToString()); string bmid = Request.QueryString["bmid"]; if (!string.IsNullOrEmpty(bmid)) { if (Convert.ToInt32(bmid) != -1) { sb.Append(" and bmID=" + bmid); } } Models.paging pag = new Models.paging() { table = "v_bmks", order = "createTime desc", field = "ksID[id],bm,ks,must,number,createTime,isExam,valid", pageSize = Convert.ToInt32(Request.QueryString["limit"]), pageNo = Convert.ToInt32(Request.QueryString["page"]), where = sb.ToString() }; Response.Write(BLL.pagingBLL.runLaypage(pag)); } catch (Exception m) { Response.Write(m.Message); } finally { Response.End(); } }
public void tabledata() { try { Response.Clear(); string wherestr = "companyID=" + adminLogin.companyID.ToString(); string jbid = Request.QueryString["jbid"]; if (!string.IsNullOrEmpty(jbid)) { if (Convert.ToInt32(jbid) != -1) { wherestr += " and levelID=" + jbid; } } Models.paging pag = new Models.paging() { table = "JobInfo a left join subjectLevel b on a.levelID=b.ID", order = "createTime desc", field = "a.id,b.name[jb],jobName[name],createTime,a.valid", pageSize = Convert.ToInt32(Request.QueryString["limit"]), pageNo = Convert.ToInt32(Request.QueryString["page"]), where = wherestr }; Response.Write(BLL.pagingBLL.runLaypage(pag)); } catch (Exception m) { Response.Write(m.Message); } finally { Response.End(); } }
public static string runpage(Models.paging pag, string format) { using (DAL.pagingDAL dal = new DAL.pagingDAL()) { using (Common.JsonParse jp = new Common.JsonParse()) { int count = 0; DataTable dt = dal.execPaging(pag, out count); return(jp.ToTablePage(dt, count, format)); } } }
public void listdata() { try { Response.Clear(); StringBuilder sb = new StringBuilder(); sb.Append("[State]=1"); string wherejson = Request.QueryString["wherejson"]; if (!string.IsNullOrEmpty(wherejson)) { Models.subFind m = JsonConvert.DeserializeObject <Models.subFind>(wherejson); if (m.sid != 0) { sb.Append(" and SubjectClassID in (select id from f_getChildren(" + m.sid + "))"); } if (m.title != "") { sb.Append(" and Title like '%" + m.title.Trim() + "%'"); } if (m.inputState != -1) { sb.Append(" and inputState=" + m.inputState); } if (m.mindate != "") { sb.Append(" and k.createTime>='" + m.mindate.Trim() + "'"); } if (m.maxdate != "") { sb.Append(" and k.createTime<='" + m.maxdate.Trim() + " 23:59:59'"); } } Models.paging pag = new Models.paging() { table = "LSSubject k join subjectClass s on k.SubjectClassID=s.ID", order = "k.createTime desc", field = "k.id,s.name[sname],title,result,k.createTime[date],inputState[state]", pageSize = Convert.ToInt32(Request.QueryString["limit"]), pageNo = Convert.ToInt32(Request.QueryString["page"]), where = sb.ToString() }; Response.Write(BLL.pagingBLL.runLaypage(pag)); } catch (Exception m) { Response.Write(m.Message); } finally { Response.End(); } }
/// <summary> /// 我的题库table /// </summary>/subject/tablelearnsubject public void tablelearnsubject() { try { Response.Clear(); Models.paging pag = new Models.paging() { table = "v_learnSubject", order = "createTime desc", field = "id,[sid],sname,[level],createTime,learns,counts,total,inlearn", pageSize = 50, pageNo = 1, where = "eid='" + employeeLogin.eid + "'" }; Response.Write(BLL.pagingBLL.runLaypage(pag)); } catch (Exception m) { Response.Write(m.Message); } finally { Response.End(); } }
/// <summary> /// 执行分页存储过程 /// </summary> /// <param name="entity">分页实体</param> /// <param name="total">记录总数</param> /// <returns>DataTable</returns> public DataTable execPaging(Models.paging entity, out int total) { SqlParameter[] pars = { new SqlParameter("@viewName",SqlDbType.VarChar,800), new SqlParameter("@fieldName",SqlDbType.VarChar,800), new SqlParameter("@orderString",SqlDbType.VarChar,200), new SqlParameter("@whereString",SqlDbType.VarChar,800), new SqlParameter("@pageSize",SqlDbType.Int), new SqlParameter("@pageNo",SqlDbType.Int), new SqlParameter("@recordTotal",SqlDbType.Int) }; pars[0].Value = entity.table; pars[1].Value = entity.field; pars[2].Value = entity.order; pars[3].Value = entity.where; pars[4].Value = entity.pageSize; pars[5].Value = entity.pageNo; pars[6].Direction = ParameterDirection.Output; DataTable dt = SqlHelper.RunProcedure("[sp_paging]", pars); total = Convert.ToInt32(pars[6].Value); return dt; }
public void getdata() { try { Response.Clear(); Models.paging pag = new Models.paging() { table = "replacegif", order = "id desc", field = "*", pageSize = Convert.ToInt32(Request.QueryString["limit"]), pageNo = Convert.ToInt32(Request.QueryString["page"]), where = "1=1" }; Response.Write(BLL.pagingBLL.runLaypage(pag)); } catch (Exception m) { Response.Write(m.Message); } finally { Response.End(); } }
/// <summary> /// 获得评论 /// </summary>/subject/commentdata public void commentdata() { try { Response.Clear(); string sb = "valid=1 and [sid]=" + Request.QueryString["sid"].ToString(); Models.paging pag = new Models.paging() { table = "v_comment", order = "createTime desc", field = "photo,ename,content,evaluate,createTime,reply", pageSize = 10, pageNo = Convert.ToInt32(Request.QueryString["page"]), where = sb }; Response.Write(BLL.pagingBLL.runpage(pag, "yyyy-MM-dd HH:mm:ss")); } catch (Exception m) { Response.Write(m.Message); } finally { Response.End(); } }
// 获得意见反馈 public void tabledata() { try { Response.Clear(); string sb = "display=1"; Models.paging pag = new Models.paging() { table = "v_feedback", order = "replyTime desc,[date] desc", field = "photo,name,[date],content,isdispose,reply", pageSize = 10, pageNo = Convert.ToInt32(Request.QueryString["page"]), where = sb }; Response.Write(BLL.pagingBLL.runpage(pag, "yyyy-MM-dd HH:mm:ss")); } catch (Exception m) { Response.Write(m.Message); } finally { Response.End(); } }
[HttpGet]// /admin/department/tabledatabm public void tabledatabm() { try { Response.Clear(); string wherestr = "[type]=1 and companyID=" + adminLogin.companyID.ToString(); Models.paging pag = new Models.paging() { table = "(select * from department where [type]=1) a left join(select bmID,COUNT(*)[kss] from v_bmks group by bmID) b on a.ID=b.bmID", order = "createTime desc", field = "id,name,isnull(kss,0)[kss],createTime,valid", pageSize = Convert.ToInt32(Request.QueryString["limit"]), pageNo = Convert.ToInt32(Request.QueryString["page"]), where = wherestr }; Response.Write(BLL.pagingBLL.runLaypage(pag)); } catch (Exception m) { Response.Write(m.Message); } finally { Response.End(); } }
public void tabledata() { try { Response.Clear(); StringBuilder sb = new StringBuilder(); sb.Append("valid=1 and companyID=" + adminLogin.companyID.ToString()); string wherejson = Request.QueryString["wherejson"]; if (!string.IsNullOrEmpty(wherejson)) { employeeListFindwhere m = JsonConvert.DeserializeObject <employeeListFindwhere>(wherejson); if (m.ename != "") { sb.Append(" and name like '%" + m.ename.Trim() + "%'"); } if (m.sex != -1) { sb.Append(" and sexID=" + m.sex); } if (m.idcard != "") { sb.Append(" and idcard like '%" + m.idcard.Trim() + "%'"); } if (m.bm != -1) { sb.Append(" and departmentID=" + m.bm); } if (m.ks != -1) { sb.Append(" and officesID=" + m.ks); } if (m.jb != -1) { sb.Append(" and levelID=" + m.jb); } if (m.zc != -1) { sb.Append(" and jobInfoID=" + m.zc); } if (m.minreg != "") { sb.Append(" and registerTime>='" + m.minreg.Trim() + "'"); } if (m.maxreg != "") { sb.Append(" and registerTime<='" + m.maxreg.Trim() + " 23:59:59'"); } if (m.state != -1) { sb.Append(" and state=" + m.state); } } Models.paging pag = new Models.paging() { table = "v_employeeList", order = "applyTime desc,registerTime desc", field = "id,name,sex,idcard,phone,registerTime,department,offices,[level],jobInfo,[state]", pageSize = Convert.ToInt32(Request.QueryString["limit"]), pageNo = Convert.ToInt32(Request.QueryString["page"]), where = sb.ToString() }; Response.Write(BLL.pagingBLL.runLaypage(pag, null)); } catch (Exception m) { Response.Write(m.Message); } finally { Response.End(); } }