/// <summary>
/// 實體物件取得DataRow資料
/// </summary>
private Models.MPaperSuggestion SetModel(DataRow dr)
{
Models.MPaperSuggestion mod = new Models.MPaperSuggestion();
mod.PaperSuggestionID = int.Parse(dr["PaperSuggestionID"].ToString());
mod.PaperID = int.Parse(dr["PaperID"].ToString());
mod.PaperSuggestion = dr["PaperSuggestion"].ToString();
mod.CreateDate = DateTime.Parse(dr["CreateDate"].ToString());
return(mod);
}
/// <summary>
/// 修改資料
/// <summary>
public bool Edit(Models.MPaperSuggestion mod)
{
SqlCommand cmd = new SqlCommand("STP_PaperSuggestionEdit");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@PaperSuggestionID", SqlDbType.Int).Value = mod.PaperSuggestionID;
cmd.Parameters.Add("@PaperID", SqlDbType.Int).Value = mod.PaperID;
cmd.Parameters.Add("@PaperSuggestion", SqlDbType.NVarChar).Value = mod.PaperSuggestion;
return(SQLUtil.ExecuteSql(cmd) > 0);
}
/// <summary>
/// 實體物件取得DataReader資料
/// </summary>
private Models.MPaperSuggestion SetModel(SqlDataReader dr)
{
Models.MPaperSuggestion mod = new Models.MPaperSuggestion();
while (dr.Read())
{
mod.PaperSuggestionID = int.Parse(dr["PaperSuggestionID"].ToString());
mod.PaperID = int.Parse(dr["PaperID"].ToString());
mod.PaperSuggestion = dr["PaperSuggestion"].ToString();
mod.CreateDate = DateTime.Parse(dr["CreateDate"].ToString());
}
return(mod);
}
/// <summary>
/// 新增資料
/// </summary>
public int Add(Models.MPaperSuggestion mod)
{
SqlCommand cmd = new SqlCommand("STP_PaperSuggestionAdd");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@PaperID", SqlDbType.Int).Value = mod.PaperID;
cmd.Parameters.Add("@PaperSuggestion", SqlDbType.NVarChar).Value = mod.PaperSuggestion;
object obj = SQLUtil.ExecuteScalar(cmd);
int intID = 0;
if (obj != null && int.TryParse(obj.ToString(), out intID))
{
mod.PaperSuggestionID = intID;
}
return(intID);
}
/// <summary>
/// 取得單筆資料
/// <summary>
public Models.MPaperSuggestion GetModel(int intPaperSuggestionID)
{
SqlCommand cmd = new SqlCommand("STP_PaperSuggestionGetByPK");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@PaperSuggestionID", SqlDbType.Int).Value = intPaperSuggestionID;
SqlDataReader dr = SQLUtil.QueryDR(cmd);
bool isHasRows = dr.HasRows;
Models.MPaperSuggestion mod = SetModel(dr);
dr.Close();
if (isHasRows)
{
return(mod);
}
else
{
return(null);
}
}
/// <summary>
/// 修改資料
/// </summary>
public bool Edit(Models.MPaperSuggestion mod)
{
return(new DAL.DPaperSuggestion().Edit(mod));
}
/// <summary>
/// 新增資料
/// </summary>
public int Add(Models.MPaperSuggestion mod)
{
return(new DAL.DPaperSuggestion().Add(mod));
}
