/// <summary>
/// 初始化
/// </summary>
public TaiwanAirController()
{
_Service = new TaiwanAir();
_Result = new Result();
_RequestModel = new Request_TaiwanAirModel();
_Response = new Base_Response();
}
public int Delete(TaiwanAir DBModel, ref Result Result)
{
string sql = @"
DELETE FROM [dbo].[TaiwanAir]
WHERE [TaiwanAir_ID] = @TaiwanAir_ID";
return(ExecuteNonQuery(sql, DBModel, out Result));
}
public int Insert(TaiwanAir DBModel, ref Result Result)
{
string sql = @"
INSERT INTO [dbo].[TaiwanAir]
([TaiwanAir_SiteName], [TaiwanAir_County], [TaiwanAir_Status])
VALUES (@TaiwanAir_SiteName, @TaiwanAir_County, @TaiwanAir_Status)";
return(ExecuteNonQuery(sql, DBModel, out Result));
}
public int Update(TaiwanAir DBModel, ref Result Result)
{
string sql = @"
UPDATE [dbo].[TaiwanAir]
SET [TaiwanAir_SiteName] = @TaiwanAir_SiteName,
[TaiwanAir_County] = @TaiwanAir_County,
[TaiwanAir_Status] = @TaiwanAir_Status
WHERE [TaiwanAir_ID] = @TaiwanAir_ID";
return(ExecuteNonQuery(sql, DBModel, out Result));
}
public Request_TaiwanAirModel()
{
SearchModel = new SearchModel();
TaiwanAir = new TaiwanAir();
}
