public OABooksDiscard GetModel(Guid DiscardRecordID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select * ");
builder.Append(" DiscardRecordID,DiscardBookISBN,DiscardCopy ");
builder.Append(" from OA_Books_Discard ");
builder.Append(" where DiscardRecordID=" + DiscardRecordID);
OABooksDiscard discard = new OABooksDiscard();
DataSet set = publicDbOpClass.DataSetQuary(builder.ToString());
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
if (set.Tables[0].Rows[0]["DiscardRecordID"].ToString() != "")
{
discard.DiscardRecordID = new Guid(set.Tables[0].Rows[0]["DiscardRecordID"].ToString());
}
discard.DiscardBookISBN = set.Tables[0].Rows[0]["DiscardBookISBN"].ToString();
if (set.Tables[0].Rows[0]["DiscardCopy"].ToString() != "")
{
discard.DiscardCopy = int.Parse(set.Tables[0].Rows[0]["DiscardCopy"].ToString());
}
return(discard);
}
public int Update(OABooksDiscard model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update OA_Books_Discard set ");
builder.Append("DiscardCopy=" + model.DiscardCopy);
builder.Append(" where DiscardRecordID='" + model.DiscardRecordID + "' ");
builder.Append(" and DiscardBookISBN='" + model.DiscardBookISBN + "' ");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public int Add(OABooksDiscard model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into OA_Books_Discard(");
builder.Append("DiscardRecordID,DiscardBookISBN,DiscardCopy");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + model.DiscardRecordID + "',");
builder.Append("'" + model.DiscardBookISBN + "',");
builder.Append(model.DiscardCopy);
builder.Append(")");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}