protected void BtnConfirm_Click(object sender, EventArgs e) { eFileLend eFileLend = new eFileLend(); DataTable dataTable = (DataTable)this.Session["eFileInfoDT"]; for (int i = 0; i < dataTable.Rows.Count; i++) { eFileLend.AuditState = -1; eFileLend.BorrowMan = this.Session["yhdm"].ToString(); eFileLend.FileRecordID = Convert.ToInt32(dataTable.Rows[i]["RecordID"].ToString()); eFileLend.LendDate = DateTime.Now; if (dataTable.Rows[i]["SecretLevel"].ToString() == "1") { eFileLend.LendState = "0"; } else { eFileLend.LendState = "1"; } eFileLend.PlanReturnDate = Convert.ToDateTime(dataTable.Rows[i]["PlanReturnDate"]); eFileLend.RecordID = Guid.NewGuid(); this.efla.Add(eFileLend); } this.Page.ClientScript.RegisterStartupScript(base.GetType(), "ok", "returnValue=true;window.close();", true); }
public int LendStateUpdate(eFileLend model) { StringBuilder builder = new StringBuilder(); builder.Append("update OA_eFile_Lend set "); builder.Append("LendState='" + model.LendState + "'"); builder.Append(" where RecordID='" + model.RecordID + "'"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
protected void BtnSave_Click(object sender, EventArgs e) { eFileLend eFileLend = new eFileLend(); eFileLend.ReturnDate = Convert.ToDateTime(this.DBReturnDate.Text); eFileLend.RecordID = this.rid; if (this.efla.ReturnUpdate(eFileLend) == 1) { this.JS.Text = "alert('保存成功!');returnValue=true;window.close();"; return; } this.JS.Text = "alert('保存失败!');"; }
protected void BtnApply_Click(object sender, EventArgs e) { eFileLend eFileLend = new eFileLend(); eFileLend.LendState = "1"; eFileLend.RecordID = new Guid(this.HdnRecoreId.Value); if (this.efla.LendStateUpdate(eFileLend) == 1) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "ok", "alert('已提交借阅申请!');", true); this.GVeFileLend.DataBind(); return; } this.Page.ClientScript.RegisterStartupScript(base.GetType(), "ok", "alert('提交借阅申请失败!');", true); }
protected void btnBorrow_Click(object sender, EventArgs e) { eFileLend eFileLend = new eFileLend(); eFileLend.LendDate = DateTime.Now; eFileLend.LendState = "2"; eFileLend.RecordID = new Guid(this.HdnRecoreId.Value); if (this.efla.BorrowUpdate(eFileLend) == 1) { this.JS.Text = "alert('确认成功!');"; this.GVeFileLend.DataBind(); return; } this.JS.Text = "alert('确认失败!');"; }
protected void BtnPlanReturn_Click(object sender, EventArgs e) { eFileLend eFileLend = new eFileLend(); eFileLend.ReturnDate = DateTime.Now; eFileLend.LendState = "4"; eFileLend.ReturnType = 1; eFileLend.RecordID = new Guid(this.HdnRecoreId.Value); if (this.efla.ReturnUpdate(eFileLend) == 1) { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "ok", "alert('归还成功!');", true); this.GVeFileLend.DataBind(); return; } this.Page.ClientScript.RegisterStartupScript(base.GetType(), "ok", "alert('归还失败!');", true); }
public int Update(eFileLend model) { StringBuilder builder = new StringBuilder(); builder.Append("update OA_eFile_Lend set "); builder.Append("AuditState=" + model.AuditState + ","); builder.Append("BorrowMan='" + model.BorrowMan + "',"); builder.Append("FileRecordID=" + model.FileRecordID + ","); builder.Append("LendDate='" + model.LendDate + "',"); builder.Append("PlanReturnDate='" + model.PlanReturnDate + "',"); builder.Append("ReturnApplyDate='" + model.ReturnApplyDate + "',"); builder.Append("ReturnDate='" + model.ReturnDate + "',"); builder.Append("LendState='" + model.LendState + "'"); builder.Append(" where RecordID=" + model.RecordID); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
protected void btnReturn_Click(object sender, EventArgs e) { eFileLend eFileLend = new eFileLend(); eFileLend.LendDate = DateTime.Now; eFileLend.LendState = "4"; eFileLend.ReturnType = 2; eFileLend.RecordID = new Guid(this.HdnRecoreId.Value); if (this.efla.CompelReturnUpdate(eFileLend) == 1) { this.JS.Text = "alert('强制归还成功!');"; this.GVeFileLend.DataBind(); return; } this.JS.Text = "alert('强制归还失败!');"; }
public eFileLend GetModel(Guid RecordID) { StringBuilder builder = new StringBuilder(); builder.Append("select "); builder.Append(" RecordID,AuditState,BorrowMan,FileRecordID,LendDate,PlanReturnDate,ReturnApplyDate,ReturnDate,LendState "); builder.Append(" from OA_eFile_Lend "); builder.Append(" where RecordID='" + RecordID + "'"); eFileLend lend = new eFileLend(); DataSet set = publicDbOpClass.DataSetQuary(builder.ToString()); if (set.Tables[0].Rows.Count <= 0) { return(null); } if (set.Tables[0].Rows[0]["RecordID"].ToString() != "") { lend.RecordID = new Guid(set.Tables[0].Rows[0]["RecordID"].ToString()); } if (set.Tables[0].Rows[0]["AuditState"].ToString() != "") { lend.AuditState = int.Parse(set.Tables[0].Rows[0]["AuditState"].ToString()); } lend.BorrowMan = set.Tables[0].Rows[0]["BorrowMan"].ToString(); if (set.Tables[0].Rows[0]["FileRecordID"].ToString() != "") { lend.FileRecordID = int.Parse(set.Tables[0].Rows[0]["FileRecordID"].ToString()); } if (set.Tables[0].Rows[0]["LendDate"].ToString() != "") { lend.LendDate = DateTime.Parse(set.Tables[0].Rows[0]["LendDate"].ToString()); } if (set.Tables[0].Rows[0]["PlanReturnDate"].ToString() != "") { lend.PlanReturnDate = DateTime.Parse(set.Tables[0].Rows[0]["PlanReturnDate"].ToString()); } if (set.Tables[0].Rows[0]["ReturnApplyDate"].ToString() != "") { lend.ReturnApplyDate = DateTime.Parse(set.Tables[0].Rows[0]["ReturnApplyDate"].ToString()); } if (set.Tables[0].Rows[0]["ReturnDate"].ToString() != "") { lend.ReturnDate = DateTime.Parse(set.Tables[0].Rows[0]["ReturnDate"].ToString()); } lend.LendState = set.Tables[0].Rows[0]["LendState"].ToString(); return(lend); }
public int Add(eFileLend model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into OA_eFile_Lend("); builder.Append("RecordID,AuditState,BorrowMan,FileRecordID,PlanReturnDate,LendState,ReturnType"); builder.Append(")"); builder.Append(" values ("); builder.Append("'" + model.RecordID + "',"); builder.Append(model.AuditState + ","); builder.Append("'" + model.BorrowMan + "',"); builder.Append(model.FileRecordID + ","); builder.Append("'" + model.PlanReturnDate + "',"); builder.Append("'" + model.LendState + "',"); builder.Append(model.ReturnType); builder.Append(")"); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
private void PageBind() { userManageDb userManageDb = new userManageDb(); eFileLend model = this.efa.GetModel(this.InstanceCode); if (model.LendDate.ToString().Substring(0, 4) != "0001") { this.LbLendDate.Text = model.LendDate.ToString("yyyy-MM-dd"); } this.LbPlanReturnDate.Text = model.PlanReturnDate.ToString("yyyy-MM-dd"); this.LbBorrowMan.Text = userManageDb.GetUserName(model.BorrowMan); eFileInfo model2 = this.eff.GetModel(this.rid); this.LbUserName.Text = userManageDb.GetUserName(model2.UserCode); this.LbFileTitle.Text = model2.FileTitle; this.LbFileCode.Text = model2.FileCode; this.LbSaveLimit.Text = model2.SaveLimit; this.LbSubmitMan.Text = userManageDb.GetUserName(model2.SubmitMan); string secretLevel; if ((secretLevel = model2.SecretLevel) != null) { if (!(secretLevel == "1")) { if (!(secretLevel == "2")) { if (secretLevel == "3") { this.LbSecretLevel.Text = "绝密"; } } else { this.LbSecretLevel.Text = "机密"; } } else { this.LbSecretLevel.Text = "秘密"; } } string fileCopy; if ((fileCopy = model2.FileCopy) != null) { if (!(fileCopy == "M")) { if (!(fileCopy == "U")) { if (fileCopy == "F") { this.LbFileCopy.Text = "正式电子文件"; } } else { this.LbFileCopy.Text = "非正式电子文件"; } } else { this.LbFileCopy.Text = "草稿性电子文件"; } } string fileType; switch (fileType = model2.FileType) { case "T": this.LbFileType.Text = "文本文件"; return; case "I": this.LbFileType.Text = "图像文件"; return; case "G": this.LbFileType.Text = "图形文件"; return; case "V": this.LbFileType.Text = "影像文件"; return; case "A": this.LbFileType.Text = "声音文件"; return; case "M": this.LbFileType.Text = "多媒体文件"; return; case "P": this.LbFileType.Text = "计算机程序"; return; case "D": this.LbFileType.Text = "数据文件"; break; return; } }