/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Lebi_Config model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [Lebi_Config](");
strSql.Append("[Name],[Value])");
strSql.Append(" values (");
strSql.Append("@Name,@Value)");
OleDbParameter[] parameters =
{
new OleDbParameter("@Name", model.Name),
new OleDbParameter("@Value", model.Value)
};
AccessUtils.Instance.TextExecuteNonQuery(strSql.ToString(), parameters);
return(1);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Lebi_Config model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update [Lebi_Config] set ");
strSql.Append("Name= @Name,");
strSql.Append("Value= @Value");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@Value", SqlDbType.NText)
};
parameters[0].Value = model.id;
parameters[1].Value = model.Name;
parameters[2].Value = model.Value;
SqlUtils.SqlUtilsInstance.TextExecuteNonQuery(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static int Add(Lebi_Config model)
{
return(D_Lebi_Config.Instance.Add(model));
}
/// <summary>
/// 更新一条数据
/// </summary>
public static void Update(Lebi_Config model)
{
D_Lebi_Config.Instance.Update(model);
}
/// <summary>
/// 安全方式绑定表单数据
/// </summary>
public static Lebi_Config SafeBindForm(Lebi_Config model)
{
return(D_Lebi_Config.Instance.SafeBindForm(model));
}
