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