public ArrayList GetLendBooks(string isbn)
{
ArrayList list = new ArrayList();
StringBuilder builder = new StringBuilder();
builder.Append("select ISBN,ClassID,BookTitle,PublishingHouse,Author,isnull(SumCopy,0) as SumCopy,isnull(LeaveCopy,0) as LeaveCopy from OA_Books_Storage where charindex(ISBN,'" + isbn + "')>0 ");
DataTable table = publicDbOpClass.DataTableQuary(builder.ToString());
if (table.Rows.Count > 0)
{
foreach (DataRow row in table.Rows)
{
OABooksLend lend = new OABooksLend {
BookTitle = row["BookTitle"].ToString(),
BorrowMan = "",
Copy = 1,
ISBN = row["ISBN"].ToString(),
LendDate = DateTime.Now,
LendState = "1",
PlanReturnDate = DateTime.Now,
RecordID = 0,
ReturnApplyDate = DateTime.Now,
ReturnDate = DateTime.Now
};
list.Add(lend);
}
}
return(list);
}
public OABooksLend GetModel(int ID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select * ");
builder.Append(" RecordID,BorrowMan,ISBN,BookTitle,Copy,LendDate,PlanReturnDate,ReturnApplyDate,ReturnDate,LendState ");
builder.Append(" from OA_Books_Lend ");
builder.Append(" where RecordID=" + ID);
OABooksLend lend = new OABooksLend();
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();
lend.ISBN = set.Tables[0].Rows[0]["ISBN"].ToString();
lend.BookTitle = set.Tables[0].Rows[0]["BookTitle"].ToString();
if (set.Tables[0].Rows[0]["Copy"].ToString() != "")
{
lend.Copy = int.Parse(set.Tables[0].Rows[0]["Copy"].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 Update(OABooksLend model)
{
StringBuilder builder = new StringBuilder();
builder.Append("update OA_Books_Lend set ");
builder.Append("RecordID=" + model.RecordID + ",");
builder.Append("BorrowMan='" + model.BorrowMan + "',");
builder.Append("ISBN='" + model.ISBN + "',");
builder.Append("BookTitle='" + model.BookTitle + "',");
builder.Append("Copy=" + model.Copy + ",");
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()));
}
public int Add(OABooksLend model)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into OA_Books_Lend(");
builder.Append("RecordID,BorrowMan,ISBN,BookTitle,Copy,LendDate,PlanReturnDate,ReturnApplyDate,ReturnDate,LendState");
builder.Append(")");
builder.Append(" values (");
builder.Append(model.RecordID + ",");
builder.Append("'" + model.BorrowMan + "',");
builder.Append("'" + model.ISBN + "',");
builder.Append("'" + model.BookTitle + "',");
builder.Append(model.Copy + ",");
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()));
}
