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));
}
public int UpdateSetting(t_sys_setting_cfg model)
{
try
{
return(_dbFactory.setting_Cfg.UpdateSetting(model));
}
catch (Exception ex)
{
throw ex;
}
}
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));
}