public IList <AssistBookUpdate> GetAssistBookUpdateBySelect(int assistbookID, string bookname, string person, DateTime begin, DateTime end, string updateobject)
{
IList <AssistBookUpdate> objList = new List <AssistBookUpdate>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_ASSIST_BOOK_UPDATE_S";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_assist_book_id", DbType.Int32, assistbookID);
db.AddInParameter(dbCommand, "p_book_name", DbType.String, bookname);
db.AddInParameter(dbCommand, "p_person", DbType.String, person);
db.AddInParameter(dbCommand, "p_begin_date", DbType.Date, begin);
db.AddInParameter(dbCommand, "p_end_date", DbType.Date, end);
db.AddInParameter(dbCommand, "p_update_object", DbType.String, updateobject);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
AssistBookUpdate obj = CreateModelObject(dataReader);
objList.Add(obj);
}
}
return(objList);
}
public AssistBookUpdate GetAssistBookUpdate(int ChapterUpdateId)
{
AssistBookUpdate BookChapter;
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_ASSIST_BOOK_UPDATE_G";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_assist_book_update_id", DbType.Int32, ChapterUpdateId);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
BookChapter = CreateModelObject(dataReader);
}
else
{
BookChapter = new AssistBookUpdate();
}
}
return(BookChapter);
}
public void UpdateAssistBookUpdate(AssistBookUpdate BookChapter)
{
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_ASSIST_BOOK_UPDATE_U";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_assist_book_update_id", DbType.Int32, BookChapter.AssistBookUpdateId);
db.AddInParameter(dbCommand, "p_assist_book_id", DbType.Int32, BookChapter.AssistBookId);
db.AddInParameter(dbCommand, "p_chapter_id", DbType.Int32, BookChapter.ChapterId);
db.AddInParameter(dbCommand, "p_update_person", DbType.String, BookChapter.updatePerson);
db.AddInParameter(dbCommand, "p_update_date", DbType.DateTime, BookChapter.updateDate);
db.AddInParameter(dbCommand, "p_update_cause", DbType.String, BookChapter.updateCause);
db.AddInParameter(dbCommand, "p_update_content", DbType.String, BookChapter.updateContent);
db.AddInParameter(dbCommand, "p_memo", DbType.String, BookChapter.Memo);
DbConnection connection = db.CreateConnection();
connection.Open();
DbTransaction transaction = connection.BeginTransaction();
try
{
db.ExecuteNonQuery(dbCommand, transaction);
transaction.Commit();
}
catch
{
transaction.Rollback();
}
connection.Close();
}
private void FillPage(int nBookUpdateID)
{
AssistBookUpdateBLL BookUpdateBLL = new AssistBookUpdateBLL();
AssistBookUpdate BookUpdate = BookUpdateBLL.GetAssistBookUpdate(nBookUpdateID);
if (BookUpdate != null)
{
lblPerson.Text = BookUpdate.updatePerson;
lblDate.Text = BookUpdate.updateDate.ToShortDateString();
txtCause.Text = BookUpdate.updateCause;
txtContent.Text = BookUpdate.updateContent;
txtMemo.Text = BookUpdate.Memo;
string strUpdateObject = Request.QueryString.Get("Object");
if (strUpdateObject == "delbook")
{
lblBookName.Text = BookUpdate.BookNameBak;
lblChapterName.Text = "删除辅导教材《" + BookUpdate.BookNameBak + "》";
}
else if (strUpdateObject == "delchapter")
{
lblBookName.Text = BookUpdate.BookName;
lblChapterName.Text = "删除辅导教材章节" + BookUpdate.ChapterNameBak;
}
else if (strUpdateObject == "insertchapterinfo")
{
lblBookName.Text = BookUpdate.BookName;
lblChapterName.Text = "新增《" + BookUpdate.ChapterNameBak + "》辅导教材章节基本信息";
}
else if (strUpdateObject == "bookinfo")
{
lblChapterName.Text = PrjPub.ASSISTBOOKUPDATEOBJECT_BOOKINFO;
}
else if (strUpdateObject == "bookcover")
{
lblChapterName.Text = PrjPub.ASSISTBOOKUPDATEOBJECT_BOOKCOVER;
lblBookName.Text = BookUpdate.BookName;
}
else if (strUpdateObject == "updatechapterinfo")
{
lblChapterName.Text = "修改《" + BookUpdate.ChapterNameBak + "》辅导教材章节基本信息";
lblBookName.Text = BookUpdate.BookName;
}
else if (strUpdateObject == "chaptercontent")
{
lblChapterName.Text = "《" + BookUpdate.ChapterNameBak + "》" + PrjPub.ASSISTBOOKUPDATEOBJECT_CHAPTERCONTENT;
lblBookName.Text = BookUpdate.BookName;
}
}
ViewState["AddFlag"] = 0;
}
public IList <AssistBookUpdate> GetAssistBookUpdateByChapterID(int chapterID, int assistBookID)
{
IList <AssistBookUpdate> objList = new List <AssistBookUpdate>();
Database db = DatabaseFactory.CreateDatabase();
string sqlCommand = "USP_ASSIST_BOOK_UPDATE_Q";
DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);
db.AddInParameter(dbCommand, "p_chapter_id", DbType.Int32, chapterID);
db.AddInParameter(dbCommand, "p_assist_book_id", DbType.Int32, assistBookID);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
AssistBookUpdate obj = CreateModelObject(dataReader);
objList.Add(obj);
}
}
return(objList);
}
protected void SaveButton_Click(object sender, EventArgs e)
{
AssistBookUpdateBLL BookUpdateBLL = new AssistBookUpdateBLL();
AssistBookUpdate BookUpdate = new AssistBookUpdate();
string strUpdateObject = Request.QueryString.Get("Object");
if (txtCause.Text == string.Empty)
{
SessionSet.PageMessage = "更改原因不能为空！";
return;
}
if (txtContent.Text == string.Empty)
{
SessionSet.PageMessage = "更改内容不能为空！";
return;
}
if (ViewState["AddFlag"].ToString() == "1") //新增
{
AssistBookBLL objBookBll = new AssistBookBLL();
BookUpdate.AssistBookId = int.Parse(ViewState["BookID"].ToString());
BookUpdate.ChapterId = int.Parse(ViewState["ChapterID"].ToString());
BookUpdate.updatePerson = lblPerson.Text;
BookUpdate.updateDate = DateTime.Parse(lblDate.Text);
BookUpdate.updateCause = txtCause.Text;
BookUpdate.updateContent = txtContent.Text;
BookUpdate.Memo = txtMemo.Text;
BookUpdate.BookNameBak = objBookBll.GetAssistBook(Convert.ToInt32(ViewState["BookID"].ToString())).BookName;
if (ViewState["ChapterID"].ToString() != "0")
{
AssistBookChapterBLL objChapterBll = new AssistBookChapterBLL();
BookUpdate.ChapterNameBak =
objChapterBll.GetAssistBookChapter(Convert.ToInt32(ViewState["ChapterID"].ToString())).ChapterName;
}
if (strUpdateObject == "insertchapterinfo")
{
BookUpdate.ChapterNameBak = Server.UrlDecode(Request.QueryString.Get("newchaptername"));
BookUpdate.UpdateObject = PrjPub.ASSISTBOOKUPDATEOBJECT_INSERTCHAPTERINFO;
}
else if (strUpdateObject == "updatechapterinfo")
{
BookUpdate.UpdateObject = PrjPub.ASSISTBOOKUPDATEOBJECT_UPDATECHAPTERINFO;
}
else if (strUpdateObject == "chaptercontent")
{
BookUpdate.UpdateObject = PrjPub.ASSISTBOOKUPDATEOBJECT_CHAPTERCONTENT;
}
else if (strUpdateObject == "delbook")
{
BookUpdate.UpdateObject = PrjPub.ASSISTBOOKUPDATEOBJECT_DELBOOK;
}
else if (strUpdateObject == "delchapter")
{
BookUpdate.UpdateObject = PrjPub.ASSISTBOOKUPDATEOBJECT_DELCHAPTER;
}
else
{
BookUpdate.UpdateObject = lblChapterName.Text;
}
BookUpdateBLL.AddAssistBookUpdate(BookUpdate);
Response.Write("<script>top.returnValue='true';window.close();</script>");
}
else //修改
{
BookUpdate.AssistBookId = int.Parse(ViewState["BookID"].ToString());
BookUpdate.ChapterId = int.Parse(ViewState["ChapterID"].ToString());
BookUpdate.updatePerson = lblPerson.Text;
BookUpdate.updateDate = DateTime.Parse(lblDate.Text);
BookUpdate.updateCause = txtCause.Text;
BookUpdate.updateContent = txtContent.Text;
BookUpdate.Memo = txtMemo.Text;
BookUpdate.AssistBookUpdateId = int.Parse(Request.QueryString.Get("id"));
BookUpdateBLL.UpdateAssistBookUpdate(BookUpdate);
Response.Write("<script>window.opener.form1.RefreshGrid.value='true';window.opener.form1.submit();window.close();</script>");
}
}
public void UpdateAssistBookUpdate(AssistBookUpdate BookUpdate)
{
dal.UpdateAssistBookUpdate(BookUpdate);
}
public void AddAssistBookUpdate(AssistBookUpdate BookUpdate)
{
dal.AddAssistBookUpdate(BookUpdate);
}
