/// <summary> /// 绑定列表 /// </summary> /// <returns></returns> public string ListBind() { string page = Request["page"]; string rows = Request["pagesize"]; string key = Request["key"]; string ajmc = Request["ajmc"]; string gh = Request["gh"]; string mc = Request["mc"]; int pageNumber = int.Parse(page); int pageSize = int.Parse(rows); string where = " and T.SFSC='N'"; object[] values = new object[6]; if (!string.IsNullOrEmpty(key)) { where += " and t.BMSAH like :BMSAH"; values[0] = "%" + key + "%"; } if (!string.IsNullOrEmpty(ajmc)) { where += " and AJMC like :AJMC"; values[1] = "%" + ajmc + "%"; } if (!string.IsNullOrEmpty(gh)) { where += " and GH like :GH"; values[2] = "%" + gh + "%"; } if (!string.IsNullOrEmpty(mc)) { where += " and MC like :MC"; values[3] = "%" + mc + "%"; } where += " and JDRGH = :JDRGH"; where += " and JDDWBM=:JDDWBM"; values[4] = UserInfo.GH; values[5] = UserInfo.DWBM; EDRS.BLL.YX_DZJZ_LSAJBD bll = new EDRS.BLL.YX_DZJZ_LSAJBD(this.Request); DataSet ds = bll.GetListByPage(where, "YJJSSJ desc,JDSJ desc", (pageSize * pageNumber) - pageSize + 1, (pageSize * pageNumber), values); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { //数据日志 OperateLog.AddLog(OperateLog.LogType.阅卷Web, "获取阅卷绑定列表成功", UserInfo, UserRole, this.Request); int count = bll.GetRecordCount(where, values); return("{\"Total\":" + count + ",\"Rows\":" + JsonHelper.JsonString(ds.Tables[0]) + "}"); } //数据日志 OperateLog.AddLog(OperateLog.LogType.阅卷Web, "获取阅卷绑定列表-未找到信息", UserInfo, UserRole, this.Request); return(ReturnString.JsonToString(Prompt.error, "未找到阅卷绑定信息", null)); }
/// <summary> /// 登录账号阅卷 /// </summary> /// <returns></returns> private string ReadLogin() { string where = string.Empty; string yjxh = Request["yjxh"]; where += " and YJXH='" + StringPlus.ReplaceSingle(yjxh) + "'"; object[] values = new object[0]; EDRS.BLL.YX_DZJZ_LSAJBD bll = new EDRS.BLL.YX_DZJZ_LSAJBD(Request); List <EDRS.Model.YX_DZJZ_LSAJBD> listmodel = bll.GetModelList(where, values); if (listmodel != null && listmodel.Count > 0) { return(JsonHelper.JsonString(listmodel)); } return(ReturnString.JsonToString(Prompt.error, "请确认阅卷时间是否未开始或者已结束", null)); }