internal int InsertOrUpdate(B2b_com_roomtypeday model)
{
if (model.Id == 0)
{
string sql = @"INSERT INTO [EtownDB].[dbo].[b2b_com_roomtypeday]([dayprice],[dayavailablenum],[ReserveType],[daydate],[roomtypeid])
VALUES(@dayprice ,@dayavailablenum ,@ReserveType ,@daydate ,@roomtypeid);select @@identity;";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@dayprice", model.Dayprice);
cmd.AddParam("@dayavailablenum", model.Dayavailablenum);
cmd.AddParam("@ReserveType", model.ReserveType);
cmd.AddParam("@daydate", model.Daydate);
cmd.AddParam("@roomtypeid", model.Roomtypeid);
object obj = cmd.ExecuteScalar();
return(obj != null?int.Parse(obj.ToString()) : 0);
}
else
{
string sql = @" UPDATE [EtownDB].[dbo].[b2b_com_roomtypeday] SET [dayprice] = @dayprice ,[dayavailablenum] = @dayavailablenum ,[ReserveType] = @ReserveType ,[daydate] = @daydate ,[roomtypeid] =@roomtypeid WHERE id=@id";
var cmd = sqlHelper.PrepareTextSqlCommand(sql);
cmd.AddParam("@id", model.Id);
cmd.AddParam("@dayprice", model.Dayprice);
cmd.AddParam("@dayavailablenum", model.Dayavailablenum);
cmd.AddParam("@ReserveType", model.ReserveType);
cmd.AddParam("@daydate", model.Daydate);
cmd.AddParam("@roomtypeid", model.Roomtypeid);
int upnum = cmd.ExecuteNonQuery();
return(model.Id);
}
}
public int InsertOrUpdate(B2b_com_roomtypeday model)
{
using (var sql = new SqlHelper())
{
try
{
var internalData = new InternalB2b_com_roomtypeday(sql);
int result = internalData.InsertOrUpdate(model);
return(result);
}
catch
{
throw;
}
}
}
