//[HttpPatch("{id}")]
public bool Patch([FromBody] SYS_PLACEINFO value)
{
if (!ModelState.IsValid)
{
return(false);
}
if (string.IsNullOrEmpty(value.ID))
{
return(false);
}
bool _result = false;
DataTable dt = new DataTable("MyTable");
string sql = @" UPDATE `SYS_PLACEINFO` " +
" `ClubName` = @ClubName ," +
" SET `placename` = @Placename, " +
" `placedesc` = @Placedesc, " +
" `fromdate` = @Fromdate, " +
" `todate` = @Todate, " +
" `max` = @Max, " +
" `accpet` = @Accpet, " +
" `level` = @Level, " +
" `creator` = @Creator, " +
" `creatorid` = @Creatorid, " +
" `updatedate` = @Updatedate " +
" WHERE `id` = @Id ";
if (value.FromDate >= value.ToDate)
{
return(false);
}
try
{
using (MySqlConnection conn = new MySqlConnection())
{
conn.ConnectionString = DBCnstr;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.Parameters.Add(new MySqlParameter("@Id", value.ID));
cmd.Parameters.Add(new MySqlParameter("@ClubName", value.ClubName));
cmd.Parameters.Add(new MySqlParameter("@Placename", value.PlaceName));
cmd.Parameters.Add(new MySqlParameter("@Placedesc", value.PlaceDesc));
cmd.Parameters.Add(new MySqlParameter("@Fromdate", value.FromDate));
cmd.Parameters.Add(new MySqlParameter("@Todate", value.ToDate));
cmd.Parameters.Add(new MySqlParameter("@Max", value.Max));
cmd.Parameters.Add(new MySqlParameter("@Accpet", 'Y'));
cmd.Parameters.Add(new MySqlParameter("@Level", value.Level));
cmd.Parameters.Add(new MySqlParameter("@Creator", value.Creator));
cmd.Parameters.Add(new MySqlParameter("@Creatorid", value.CreatorID));
cmd.Parameters.Add(new MySqlParameter("@Updatedate", DateTime.Now));
int effectRow = cmd.ExecuteNonQuery();
cmd.Clone();
cmd.Dispose();
if (effectRow > 0)
{
_result = true;
}
}
}
catch (Exception ex)
{
//發信
}
return(_result);
}
public bool Post([FromBody] SYS_PLACEINFO value)
{
//驗證輸入結構是否符合
if (!ModelState.IsValid)
{
return(false);
}
bool _result = false;
DataTable dt = new DataTable("MyTable");
string sql = " Insert Into `SYS_PLACEINFO` " +
" (`Id`, " +
" `ClubName` , " +
" `Placename`, " +
" `Placedesc`, " +
" `Fromdate`, " +
" `Todate`, " +
" `Max`, " +
" `Accpet`, " +
" `Level`, " +
" `Creator`, " +
" `Creatorid`, " +
" `Updatedate`) " +
" Values (@Id, " +
" @ClubName , " +
" @Placename, " +
" @Placedesc, " +
" @Fromdate, " +
" @Todate, " +
" @Max, " +
" @Accpet, " +
" @Level, " +
" @Creator, " +
" @Creatorid, " +
" @Updatedate) ";
try
{
using (MySqlConnection conn = new MySqlConnection())
{
conn.ConnectionString = DBCnstr;
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
MySqlCommand cmd = new MySqlCommand(sql, conn);
cmd.Parameters.Add(new MySqlParameter("@Id", Guid.NewGuid().ToString()));
cmd.Parameters.Add(new MySqlParameter("@ClubName", value.ClubName));
cmd.Parameters.Add(new MySqlParameter("@Placename", value.PlaceName));
cmd.Parameters.Add(new MySqlParameter("@Placedesc", value.PlaceDesc));
cmd.Parameters.Add(new MySqlParameter("@Fromdate", value.FromDate));
cmd.Parameters.Add(new MySqlParameter("@Todate", value.ToDate));
cmd.Parameters.Add(new MySqlParameter("@Max", value.Max));
cmd.Parameters.Add(new MySqlParameter("@Accpet", "Y"));
cmd.Parameters.Add(new MySqlParameter("@Level", value.Level));
cmd.Parameters.Add(new MySqlParameter("@Creator", value.Creator));
cmd.Parameters.Add(new MySqlParameter("@Creatorid", value.CreatorID));
cmd.Parameters.Add(new MySqlParameter("@Updatedate", DateTime.Now));
int effectRow = cmd.ExecuteNonQuery();
cmd.Clone();
cmd.Dispose();
if (effectRow > 0)
{
_result = true;
}
}
}
catch (Exception ex)
{
//發信
}
return(_result);
}
