public OABooksDiscardMain GetModel(Guid RecordID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select * ");
builder.Append(" RecordID,AuditState,UserCode,RecordDate,Remark,IsConfirm ");
builder.Append(" from OA_Books_DiscardMain ");
builder.Append(" where RecordID=" + RecordID);
OABooksDiscardMain main = new OABooksDiscardMain();
DataSet set = publicDbOpClass.DataSetQuary(builder.ToString());
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
if (set.Tables[0].Rows[0]["RecordID"].ToString() != "")
{
main.RecordID = new Guid(set.Tables[0].Rows[0]["RecordID"].ToString());
}
if (set.Tables[0].Rows[0]["AuditState"].ToString() != "")
{
main.AuditState = int.Parse(set.Tables[0].Rows[0]["AuditState"].ToString());
}
main.UserCode = set.Tables[0].Rows[0]["UserCode"].ToString();
if (set.Tables[0].Rows[0]["RecordDate"].ToString() != "")
{
main.RecordDate = DateTime.Parse(set.Tables[0].Rows[0]["RecordDate"].ToString());
}
main.Remark = set.Tables[0].Rows[0]["Remark"].ToString();
main.IsConfirm = set.Tables[0].Rows[0]["IsConfirm"].ToString();
return(main);
}
public int Update(OABooksDiscardMain model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update OA_Books_DiscardMain set ");
builder.Append("LibraryCode='" + model.LibraryCode + "',");
builder.Append("RecordDate='" + model.RecordDate + "',");
builder.Append("Remark='" + model.Remark + "'");
builder.Append(" where RecordID='" + model.RecordID + "' ");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public int Add(OABooksDiscardMain model)
{
StringBuilder builder = new StringBuilder();
builder.Append(" insert into OA_Books_DiscardMain( ");
builder.Append(" RecordID,AuditState,LibraryCode,UserCode,RecordDate,Remark,IsConfirm ");
builder.Append(" ) ");
builder.Append(" values ( ");
builder.Append(" '" + model.RecordID + "', ");
builder.Append(" '" + model.AuditState + "', ");
builder.Append(" '" + model.LibraryCode + "', ");
builder.Append(" '" + model.UserCode + "', ");
builder.Append(" '" + model.RecordDate + "', ");
builder.Append(" '" + model.Remark + "', ");
builder.Append(" '" + model.IsConfirm + "' ");
builder.Append(" ) ");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
