public static bool InsertBatteryBanner(SqlConnection conn, BatteryBanner model)
{
const string sql = @" INSERT INTO Tuhu_huodong..BatteryBanner
( SmallImage ,
Image ,
ShowTime ,
Province ,
City ,
Display ,
Available
)
VALUES (@SmallImage , -- SmallImage - nvarchar(1000)
@Image , -- Image - nvarchar(1000)
@ShowTime , -- ShowTime - datetime
@Province , -- Province - nvarchar(50)
@City , -- City - nvarchar(50)
@Display ,
@Available
)" ;
var sqlPrams = new SqlParameter[]
{
new SqlParameter("@Image", model.Image ?? string.Empty),
new SqlParameter("@SmallImage", model.SmallImage ?? string.Empty),
new SqlParameter("@ShowTime", model.ShowTime),
new SqlParameter("@Province", model.Province ?? string.Empty),
new SqlParameter("@City", model.City ?? string.Empty),
new SqlParameter("@Display", model.Display),
new SqlParameter("@Available", model.Available),
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlPrams) > 0);
}
public bool InsertBatteryBanner(BatteryBanner model)
{
try
{
return(handler.InsertBatteryBanner(model));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new DownloadAppException(1, "InsertBatteryBanner", ex);
Logger.Log(Level.Error, exception, "InsertBatteryBanner");
throw ex;
}
}
public bool InsertBatteryBanner(BatteryBanner model)
{
return(dbManager.Execute(conn => DALDownloadApp.InsertBatteryBanner(conn, model)));
}
public JsonResult AddBatteryBanner(BatteryBanner model)
{
return(Json(DownloadAppManager.InsertBatteryBanner(model)));
}
