?? awardmanager.cs
字號:
using System;
using System.Data.OleDb;
using StudentsMIS.DataAccess;
namespace StudentsMIS.Business
{
/// <summary>
/// AwardManager實現了Awards表的選、增、刪、改。
/// </summary>
public class AwardManager
{
public AwardManager()
{
}
public void Insert(IEntity obj)
{
AwardEntity entity = (AwardEntity)obj;
/*
OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Select * From students Where student_ID=@StudentID");
objCommand.Parameters.Add("@StudentID",entity.AwardStudentID);
if(!objCommand.ExecuteReader().HasRows)
{
CommandCloser.CloseOleDbCommand(objCommand);
return 0;
}
*/
OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Insert Into awards(award_studentID,award_content,award_reason,award_date) Values(@AwardStudentID,@AwardContent,@AwardReason,@AwardDate)");
objCommand.Parameters.Add("@AwardStudentID",entity.AwardStudentID);
objCommand.Parameters.Add("@AwardContent",entity.AwardContent);
objCommand.Parameters.Add("@AwardReason",entity.AwardReason);
objCommand.Parameters.Add("@AwardDate",entity.AwardDate);
objCommand.ExecuteNonQuery();
CommandCloser.CloseOleDbCommand(objCommand);
}
public void Delete(string id)
{
OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Delete From awards Where award_ID=@AwardID");
objCommand.Parameters.Add("@AwardID",id);
objCommand.ExecuteNonQuery();
CommandCloser.CloseOleDbCommand(objCommand);
}
public void Update(IEntity obj)
{
AwardEntity entity = (AwardEntity)obj;
OleDbCommand objCommand = CommandBuilder.BuildOleDbCommand("Update awards Set award_content=@AwardContent,award_reason=@AwardReason Where awards_ID=@AwardsID");
objCommand.Parameters.Add("@AwardContent",entity.AwardContent);
objCommand.Parameters.Add("@AwardReason",entity.AwardReason);
objCommand.Parameters.Add("@AwardID",entity.AwardID);
objCommand.ExecuteNonQuery();
CommandCloser.CloseOleDbCommand(objCommand);
}
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -