/// <summary>
/// 新增資料
/// </summary>
public int Add(Models.MAwardWinner mod)
{
SqlCommand cmd = new SqlCommand("STP_AwardWinnerAdd");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AwardID", SqlDbType.Int).Value = mod.AwardID;
cmd.Parameters.Add("@AwardTypeID", SqlDbType.Int).Value = SQLUtil.CheckDBValue(mod.AwardTypeID);
cmd.Parameters.Add("@Year", SqlDbType.Int).Value = mod.Year;
cmd.Parameters.Add("@Works", SqlDbType.NVarChar).Value = mod.Works;
//cmd.Parameters.Add("@WinnerID", SqlDbType.Int).Value = mod.WinnerID;
cmd.Parameters.Add("@WinnerName", SqlDbType.NVarChar).Value = mod.WinnerName;
cmd.Parameters.Add("@Photo", SqlDbType.Image).Value = SQLUtil.CheckDBValue(mod.Photo);
cmd.Parameters.Add("@Contents", SqlDbType.NVarChar).Value = mod.Contents;
//cmd.Parameters.Add("@WinnerTitle", SqlDbType.NVarChar).Value = SQLUtil.CheckDBValue(mod.WinnerTitle);
//cmd.Parameters.Add("@Experience", SqlDbType.NVarChar).Value = SQLUtil.CheckDBValue(mod.Experience);
//cmd.Parameters.Add("@Contribution", SqlDbType.NVarChar).Value = SQLUtil.CheckDBValue(mod.Contribution);
//cmd.Parameters.Add("@Draft", SqlDbType.Bit).Value = SQLUtil.CheckDBValue(mod.Draft);
cmd.Parameters.Add("@CreateUser", SqlDbType.NVarChar).Value = mod.CreateUser;
cmd.Parameters.Add("@LastUpdateUser", SqlDbType.NVarChar).Value = mod.LastUpdateUser;
object obj = SQLUtil.ExecuteScalar(cmd);
int intID = 0;
if (obj != null && int.TryParse(obj.ToString(), out intID))
{
mod.AwardWinnerID = intID;
}
return(intID);
}
/// <summary>
/// 修改資料
/// <summary>
public bool Edit(Models.MAwardWinner mod)
{
SqlCommand cmd = new SqlCommand("STP_AwardWinnerEdit");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AwardWinnerID", SqlDbType.Int).Value = mod.AwardWinnerID;
cmd.Parameters.Add("@AwardID", SqlDbType.Int).Value = mod.AwardID;
cmd.Parameters.Add("@AwardTypeID", SqlDbType.Int).Value = SQLUtil.CheckDBValue(mod.AwardTypeID);
cmd.Parameters.Add("@Year", SqlDbType.Int).Value = mod.Year;
cmd.Parameters.Add("@Works", SqlDbType.NVarChar).Value = mod.Works;
cmd.Parameters.Add("@WinnerName", SqlDbType.NVarChar).Value = mod.WinnerName;
cmd.Parameters.Add("@Photo", SqlDbType.Image).Value = SQLUtil.CheckDBValue(mod.Photo);
cmd.Parameters.Add("@Contents", SqlDbType.NVarChar).Value = mod.Contents;
cmd.Parameters.Add("@LastUpdateUser", SqlDbType.NVarChar).Value = mod.LastUpdateUser;
return(SQLUtil.ExecuteSql(cmd) > 0);
}
/// <summary>
/// 取得單筆資料
/// <summary>
public Models.MAwardWinner GetModel(int intAwardWinnerID)
{
SqlCommand cmd = new SqlCommand("STP_AwardWinnerGetByPK");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@AwardWinnerID", SqlDbType.Int).Value = intAwardWinnerID;
SqlDataReader dr = SQLUtil.QueryDR(cmd);
bool isHasRows = dr.HasRows;
Models.MAwardWinner mod = SetModel(dr);
dr.Close();
if (isHasRows)
{
return(mod);
}
else
{
return(null);
}
}
/// <summary>
/// 實體物件取得DataRow資料
/// </summary>
private Models.MAwardWinner SetModel(DataRow dr)
{
Models.MAwardWinner mod = new Models.MAwardWinner();
mod.AwardWinnerID = int.Parse(dr["AwardWinnerID"].ToString());
mod.AwardID = int.Parse(dr["AwardID"].ToString());
mod.AwardTypeID = SQLUtil.GetInt(dr["AwardTypeID"]);
mod.Year = int.Parse(dr["Year"].ToString());
mod.Works = dr["Works"].ToString();
mod.WinnerName = dr["WinnerName"].ToString();
if (dr["Photo"] != DBNull.Value)
{
mod.Photo = (Byte[])dr["Photo"];
}
mod.Contents = dr["Contents"].ToString();
mod.CreateUser = dr["CreateUser"].ToString();
mod.CreateDate = DateTime.Parse(dr["CreateDate"].ToString());
mod.LastUpdateUser = dr["LastUpdateUser"].ToString();
mod.LastUpdateDate = DateTime.Parse(dr["LastUpdateDate"].ToString());
return(mod);
}
/// <summary>
/// 修改資料
/// </summary>
public bool Edit(Models.MAwardWinner mod)
{
return(new DAL.DAwardWinner().Edit(mod));
}
/// <summary>
/// 新增資料
/// </summary>
public int Add(Models.MAwardWinner mod)
{
return(new DAL.DAwardWinner().Add(mod));
}
