public bool UpdateOptionParameter(SysSystemParameter obj) { bool flag = false; string sql = string.Format("update sys_SystemParameter set ParameterName='{0}',ParameterValue='{1}',ParameterText='{2}',Description='{3}',State='{4}' where SystemParameterID={5}" , obj.ParameterName, obj.ParameterValue, obj.ParameterText, obj.Description, obj.State, obj.SystemParameterID); using (PersistentManager persistentManager = new PersistentManager()) { SysSystemParameterDao paraDao = new SysSystemParameterDao(); paraDao.SetData(sql); flag = true; } return(flag); }
public bool InsertOptionParameter(SysSystemParameter obj) { bool flag = false; string sql = string.Format("insert into sys_SystemParameter (ParameterName,ParameterValue,ParameterText,Description,State,ParameterType) values('{0}','{1}','{2}','{3}','{4}','{5}')" , obj.ParameterName, obj.ParameterValue, obj.ParameterText, obj.Description, obj.State, "1"); using (PersistentManager persistentManager = new PersistentManager()) { SysSystemParameterDao paraDao = new SysSystemParameterDao(); paraDao.SetData(sql); flag = true; } return(flag); }
public DataSet SearchParameter(SysSystemParameter obj) { string strSql = string.Format(" select SystemParameterID , ParameterName,ParameterValue , ParameterText," + " Description , State" + " from sys_SystemParameter where ParameterType='1' and ParameterName like '%{0}%'" + " and ParameterValue like '%{1}%'" + " and ParameterText like'%{2}%'" + " and Description like '%{3}%'" + " and State like '%{4}%' order by ParameterName ", obj.ParameterName, obj.ParameterValue, obj.ParameterText, obj.Description, obj.State); using (PersistentManager persistentManager = new PersistentManager()) { SysSystemParameterDao paraDao = new SysSystemParameterDao(); return(paraDao.GetData(strSql)); } }