/// <summary>
/// 取得單筆資料
/// <summary>
public Models.MOnSiteRegistration GetModel(int intOnSiteRegistrationID)
{
SqlCommand cmd = new SqlCommand("STP_OnSiteRegistrationGetByPK");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@OnSiteRegistrationID", SqlDbType.Int).Value = intOnSiteRegistrationID;
SqlDataReader dr = SQLUtil.QueryDR(cmd);
bool isHasRows = dr.HasRows;
Models.MOnSiteRegistration mod = SetModel(dr);
dr.Close();
if (isHasRows)
{
return(mod);
}
else
{
return(null);
}
}
/// <summary>
/// 修改資料
/// <summary>
public bool Edit(Models.MOnSiteRegistration mod)
{
SqlCommand cmd = new SqlCommand("STP_OnSiteRegistrationEdit");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@OnSiteRegistrationID", SqlDbType.Int).Value = mod.OnSiteRegistrationID;
cmd.Parameters.Add("@TWYear", SqlDbType.Int).Value = mod.TWYear;
cmd.Parameters.Add("@MemberID", SqlDbType.NVarChar).Value = mod.MemberID;
cmd.Parameters.Add("@MemberType", SqlDbType.NVarChar).Value = mod.MemberType;
cmd.Parameters.Add("@RegisterName", SqlDbType.NVarChar).Value = mod.RegisterName;
cmd.Parameters.Add("@Company", SqlDbType.NVarChar).Value = mod.Company;
cmd.Parameters.Add("@PayType", SqlDbType.NVarChar).Value = mod.PayType;
cmd.Parameters.Add("@Fee2", SqlDbType.Int).Value = mod.Fee2;
cmd.Parameters.Add("@Fee3", SqlDbType.Int).Value = mod.Fee3;
cmd.Parameters.Add("@Attend", SqlDbType.Bit).Value = mod.Attend;
cmd.Parameters.Add("@MealType", SqlDbType.NVarChar).Value = mod.MealType;
cmd.Parameters.Add("@CreateUser", SqlDbType.NVarChar).Value = mod.CreateUser;
cmd.Parameters.Add("@UpdateUser", SqlDbType.NVarChar).Value = mod.UpdateUser;
cmd.Parameters.Add("@FeeID", SqlDbType.Int).Value = SQLUtil.CheckDBValue(mod.FeeID);
return(SQLUtil.ExecuteSql(cmd) > 0);
}
/// <summary>
/// 實體物件取得DataRow資料
/// </summary>
private Models.MOnSiteRegistration SetModel(DataRow dr)
{
Models.MOnSiteRegistration mod = new Models.MOnSiteRegistration();
mod.OnSiteRegistrationID = int.Parse(dr["OnSiteRegistrationID"].ToString());
mod.TWYear = int.Parse(dr["TWYear"].ToString());
mod.MemberID = dr["MemberID"].ToString();
mod.MemberType = dr["MemberType"].ToString();
mod.RegisterName = dr["RegisterName"].ToString();
mod.Company = dr["Company"].ToString();
mod.PayType = dr["PayType"].ToString();
mod.Fee2 = int.Parse(dr["Fee2"].ToString());
mod.Fee3 = int.Parse(dr["Fee3"].ToString());
mod.Attend = bool.Parse(dr["Attend"].ToString());
mod.MealType = dr["MealType"].ToString();
mod.CreateUser = dr["CreateUser"].ToString();
mod.CreateDate = DateTime.Parse(dr["CreateDate"].ToString());
mod.UpdateUser = dr["UpdateUser"].ToString();
mod.UpdateDate = DateTime.Parse(dr["UpdateDate"].ToString());
mod.FeeID = SQLUtil.GetInt(dr["FeeID"]);
return(mod);
}
/// <summary>
/// 新增資料
/// </summary>
public int Add(Models.MOnSiteRegistration mod)
{
SqlCommand cmd = new SqlCommand();
StringBuilder sbTSQL = new StringBuilder();
sbTSQL.AppendLine("insert into [TB_OnSiteRegistration] ([TWYear],[MemberID],[MemberType],[RegisterName]");
sbTSQL.AppendLine(",[Company],[PayType],[Fee2],[Fee3],[Attend]");
sbTSQL.AppendLine(",[MealType],[CreateUser],[CreateDate],[UpdateUser],[UpdateDate],[FeeID])");
sbTSQL.AppendLine("values (@TWYear,@MemberID,@MemberType,@RegisterName");
sbTSQL.AppendLine(",@Company,@PayType,@Fee2,@Fee3,@Attend");
sbTSQL.AppendLine(",@MealType,@CreateUser,@CreateDate,@UpdateUser,@UpdateDate,@FeeID)");
sbTSQL.AppendLine(";select @@identity;");
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@TWYear", SqlDbType.Int).Value = mod.TWYear;
cmd.Parameters.Add("@MemberID", SqlDbType.NVarChar).Value = mod.MemberID;
cmd.Parameters.Add("@MemberType", SqlDbType.NVarChar).Value = mod.MemberType;
cmd.Parameters.Add("@RegisterName", SqlDbType.NVarChar).Value = mod.RegisterName;
cmd.Parameters.Add("@Company", SqlDbType.NVarChar).Value = mod.Company;
cmd.Parameters.Add("@PayType", SqlDbType.NVarChar).Value = mod.PayType;
cmd.Parameters.Add("@Fee2", SqlDbType.Int).Value = mod.Fee2;
cmd.Parameters.Add("@Fee3", SqlDbType.Int).Value = mod.Fee3;
cmd.Parameters.Add("@Attend", SqlDbType.Bit).Value = mod.Attend;
cmd.Parameters.Add("@MealType", SqlDbType.NVarChar).Value = mod.MealType;
cmd.Parameters.Add("@CreateUser", SqlDbType.NVarChar).Value = mod.CreateUser;
cmd.Parameters.Add("@CreateDate", SqlDbType.DateTime).Value = mod.CreateDate;
cmd.Parameters.Add("@UpdateUser", SqlDbType.NVarChar).Value = mod.UpdateUser;
cmd.Parameters.Add("@UpdateDate", SqlDbType.DateTime).Value = SQLUtil.CheckDBValue(mod.UpdateDate);
cmd.Parameters.Add("@FeeID", SqlDbType.Int).Value = SQLUtil.CheckDBValue(mod.FeeID);
cmd.CommandText = sbTSQL.ToString();
object obj = SQLUtil.ExecuteScalar(cmd);
int intID = 0;
if (obj != null && int.TryParse(obj.ToString(), out intID))
{
mod.OnSiteRegistrationID = intID;
}
return(intID);
}
/// <summary>
/// 修改資料
/// </summary>
public bool Edit(Models.MOnSiteRegistration mod)
{
return(new DAL.DOnSiteRegistration().Edit(mod));
}
/// <summary>
/// 新增資料
/// </summary>
public int Add(Models.MOnSiteRegistration mod)
{
return(new DAL.DOnSiteRegistration().Add(mod));
}
