public int Update(OAFileLend model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update OA_File_Lend set ");
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 GVLend_RowDataBound(object sender, GridViewRowEventArgs e)
{
switch (e.Row.RowType)
{
case DataControlRowType.Header:
case DataControlRowType.DataRow:
e.Row.Cells[11].Style["display"] = "none";
break;
}
if (e.Row.RowIndex > -1)
{
OAFileLend oAFileLend = (OAFileLend)e.Row.DataItem;
e.Row.Attributes["onmouseover"] = "OnMouseOverRecord(this);";
e.Row.Attributes["onclick"] = "OnRecord(this);FileLendClickRow('" + oAFileLend.RecordID.ToString() + "');";
HtmlInputCheckBox htmlInputCheckBox = (HtmlInputCheckBox)e.Row.Cells[0].Controls[1];
htmlInputCheckBox.Value = oAFileLend.RecordID.ToString();
htmlInputCheckBox.Attributes["onclick"] = "CheckLendFileCode(this);";
e.Row.Cells[1].Text = oAFileLend.FileCatalog.FileCode;
e.Row.Cells[2].Text = oAFileLend.FileCatalog.FileName;
e.Row.Cells[3].Text = oAFileLend.FileCatalog.Volume.ToString();
e.Row.Cells[4].Text = oAFileLend.FileCatalog.FileNumber.ToString();
e.Row.Cells[5].Text = oAFileLend.FileCatalog.BoxNumber.ToString();
e.Row.Cells[6].Text = oAFileLend.FileCatalog.SavePlace;
e.Row.Cells[7].Text = oAFileLend.FileCatalog.PrjName;
e.Row.Cells[8].Text = oAFileLend.FileCatalog.Principal;
switch (oAFileLend.FileCatalog.SecretLevel)
{
case 1:
e.Row.Cells[9].Text = "密秘";
break;
case 2:
e.Row.Cells[9].Text = "机密";
break;
case 3:
e.Row.Cells[9].Text = "绝密";
break;
}
TextBox textBox = (TextBox)e.Row.Cells[10].Controls[1];
textBox.Attributes["onchange"] = "javascript:if(!isDate(this)) return false;";
textBox.Text = oAFileLend.PlanReturnDate.ToShortDateString();
textBox.ToolTip = "输入档案借阅日期!";
}
}
public OAFileLend GetModel(int RecordID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select * ");
builder.Append(" RecordID,BorrowMan,FileRecordID,LendDate,PlanReturnDate,ReturnApplyDate,ReturnDate,LendState ");
builder.Append(" from OA_File_Lend ");
builder.Append(" where RecordID=" + RecordID);
OAFileLend lend = new OAFileLend();
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 = int.Parse(set.Tables[0].Rows[0]["RecordID"].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(OAFileLend model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into OA_File_Lend(");
builder.Append("RecordID,BorrowMan,FileRecordID,LendDate,PlanReturnDate,ReturnApplyDate,ReturnDate,LendState");
builder.Append(")");
builder.Append(" values (");
builder.Append(model.RecordID + ",");
builder.Append("'" + model.BorrowMan + "',");
builder.Append(model.FileRecordID + ",");
builder.Append("'" + model.LendDate + "',");
builder.Append("'" + model.PlanReturnDate + "',");
builder.Append("'" + model.ReturnApplyDate + "',");
builder.Append("'" + model.ReturnDate + "',");
builder.Append("'" + model.LendState + "'");
builder.Append(")");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
