/// <summary> /// 加载数据 /// </summary> /// <returns></returns> public string frmLoadData() { TOaArchivesBorrowVo objArchivesBorrow = new TOaArchivesBorrowVo(); objArchivesBorrow.ID = Request["id"].ToString(); objArchivesBorrow = new TOaArchivesBorrowLogic().Details(objArchivesBorrow); return(ToJson(objArchivesBorrow)); }
/// <summary> /// 修改数据 /// </summary> /// <returns></returns> public string frmUpdate() { TOaArchivesBorrowVo objArchivesBorrow = autoBindRequest(Request, new TOaArchivesBorrowVo()); objArchivesBorrow.ID = Request["id"].ToString(); objArchivesBorrow.REMARK1 = DateTime.Now.ToString(); bool isSuccess = new TOaArchivesBorrowLogic().Edit(objArchivesBorrow); if (isSuccess) { WriteLog("修改借出记录", "", LogInfo.UserInfo.USER_NAME + "修改借出记录" + objArchivesBorrow.ID + "成功!"); } return(isSuccess == true ? "1" : "0"); }
/// <summary> /// 获取档案文件借阅状态 /// </summary> /// <returns></returns> protected string getBorrowStatus() { //构建对象 TOaArchivesBorrowVo objArchivesBorrow = new TOaArchivesBorrowVo(); //文档ID objArchivesBorrow.DOCUMENT_ID = Request.QueryString["document_id"]; //取第一条数据即最后添加的数据 DataTable dtBorrow = new TOaArchivesBorrowLogic().SelectByTable(objArchivesBorrow); DataRow[] drBorrow = new TOaArchivesBorrowLogic().SelectByTable(objArchivesBorrow).Select("1=1", " ID desc"); if (drBorrow.Length > 0) { return(drBorrow[0]["LENT_OUT_STATE"].ToString()); } return(""); }
/// <summary> /// 增加数据 /// </summary> /// <returns></returns> public string frmAdd() { TOaArchivesBorrowVo objArchivesBorrow = autoBindRequest(Request, new TOaArchivesBorrowVo()); objArchivesBorrow.ID = GetSerialNumber("t_oa_archivesborrow"); objArchivesBorrow.LENT_OUT_STATE = "1"; objArchivesBorrow.REMARK1 = DateTime.Now.ToString(); //判断是否已借出 if (IsBorrow()) { return("2"); } bool isSuccess = new TOaArchivesBorrowLogic().Create(objArchivesBorrow); if (isSuccess) { WriteLog("添加借出记录", "", LogInfo.UserInfo.USER_NAME + "添加借出记录" + objArchivesBorrow.ID + "成功!"); } return(isSuccess == true ? "1" : "0"); }
/// <summary> /// 获取档案借阅管理 /// </summary> /// <returns></returns> protected string getDocumentBorrow() { int intTotalCount = 0; DataTable dt = new DataTable(); string strSortname = Request.Params["sortname"]; string strSortorder = Request.Params["sortorder"]; //当前页面 int intPageIndex = Convert.ToInt32(Request.Params["page"]); //每页记录数 int intPageSize = Convert.ToInt32(Request.Params["pagesize"]); TOaArchivesBorrowVo objBorrow = new TOaArchivesBorrowVo(); objBorrow.SORT_FIELD = strSortname; objBorrow.SORT_TYPE = strSortorder; objBorrow.DOCUMENT_ID = Request.QueryString["document_id"].ToString(); intTotalCount = new TOaArchivesBorrowLogic().GetSelectResultCountForSearch(objBorrow); dt = new TOaArchivesBorrowLogic().SelectByTableForSearch(objBorrow, intPageIndex, intPageSize); return(CreateToJson(dt, intTotalCount)); }