/// <summary> /// Add a record /// </summary> public int Add(string Keyname, string Value, string Description, ColoPay.Model.SysManage.ApplicationKeyType KeyType) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SA_Config_System("); strSql.Append("Keyname,Value,Description,KeyType)"); strSql.Append(" values ("); strSql.Append("@Keyname,@Value,@Description,@KeyType)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Keyname", SqlDbType.NVarChar, 50), new SqlParameter("@Value", SqlDbType.NVarChar, -1), new SqlParameter("@Description", SqlDbType.NVarChar, 200), new SqlParameter("@KeyType", SqlDbType.Int) }; parameters[0].Value = Keyname; parameters[1].Value = Value; parameters[2].Value = Description; parameters[3].Value = (int)(KeyType); object obj = DBHelper.DefaultDBHelper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(1); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// Update a record /// </summary> public bool Update(string Keyname, string Value, ColoPay.Model.SysManage.ApplicationKeyType KeyType) { StringBuilder strSql = new StringBuilder(); strSql.Append("UPDATE SA_Config_System SET "); strSql.Append("Value=@Value"); strSql.Append(" WHERE Keyname=@Keyname AND KeyType=@KeyType"); SqlParameter[] parameters = { new SqlParameter("@Keyname", SqlDbType.NVarChar, 50), new SqlParameter("@Value", SqlDbType.NVarChar, -1), new SqlParameter("@KeyType", SqlDbType.Int) }; parameters[0].Value = Keyname; parameters[1].Value = Value; parameters[2].Value = (int)(KeyType); return(DBHelper.DefaultDBHelper.ExecuteSql(strSql.ToString(), parameters) > 0); }