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;
}
}
