Example #1
0
        public int UpdateSetting(t_sys_setting_cfg model)
        {
            string sql = $@"UPDATE [dbo].[t_sys_setting_cfg]
   SET [cfg_id] = {model.cfg_id}
      ,[cfg_info] = '{model.cfg_info}'
      ,[cfg_modify_time] = '{model.cfg_modify_time}'
      ,[remark] = '{model.remark}' where ID={model.ID}";

            return(ExecuteSqlCommand(sql));
        }
Example #2
0
 public int UpdateSetting(t_sys_setting_cfg model)
 {
     try
     {
         return(_dbFactory.setting_Cfg.UpdateSetting(model));
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
Example #3
0
        public int AddSetting(t_sys_setting_cfg model)
        {
            string sql = $@"INSERT INTO [dbo].[t_sys_setting_cfg]
           ([cfg_id]
           ,[cfg_info]
           ,[cfg_modify_time]
           ,[remark])
     VALUES
           ({model.cfg_id}
           ,'{model.cfg_info}'
           ,'{model.cfg_modify_time}'
           ,'{model.remark}')";

            return(ExecuteSqlCommand(sql));
        }