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; } } }