/// <summary>
/// 增加一条数据
/// </summary>
public int attr_Add(Model.attrshop.attr_shop model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into attr_shop(");
strSql.Append("attrname,attrcontext,attr_a,attr_b,attr_c)");
strSql.Append(" values (");
strSql.Append("@attrname,@attrcontext,@attr_a,@attr_b,@attr_c)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@attrname", SqlDbType.NVarChar, 50),
new SqlParameter("@attrcontext", SqlDbType.NVarChar, 250),
new SqlParameter("@attr_a", SqlDbType.NVarChar, 250),
new SqlParameter("@attr_b", SqlDbType.NVarChar, 250),
new SqlParameter("@attr_c", SqlDbType.NVarChar, 250)
};
parameters[0].Value = model.attrname;
parameters[1].Value = model.attrcontext;
parameters[2].Value = model.attr_a;
parameters[3].Value = model.attr_b;
parameters[4].Value = model.attr_c;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Model.attrshop.attr_shop model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update attr_shop set ");
strSql.Append("attrname=@attrname,");
strSql.Append("attrcontext=@attrcontext,");
strSql.Append("attr_a=@attr_a,");
strSql.Append("attr_b=@attr_b,");
strSql.Append("attr_c=@attr_c");
strSql.Append(" where attrid=@attrid");
SqlParameter[] parameters =
{
new SqlParameter("@attrname", SqlDbType.NVarChar, 50),
new SqlParameter("@attrcontext", SqlDbType.NVarChar, 250),
new SqlParameter("@attr_a", SqlDbType.NVarChar, 250),
new SqlParameter("@attr_b", SqlDbType.NVarChar, 250),
new SqlParameter("@attr_c", SqlDbType.NVarChar, 250),
new SqlParameter("@attrid", SqlDbType.Int, 4)
};
parameters[0].Value = model.attrname;
parameters[1].Value = model.attrcontext;
parameters[2].Value = model.attr_a;
parameters[3].Value = model.attr_b;
parameters[4].Value = model.attr_c;
parameters[5].Value = model.attrid;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
public int attr_add(Model.attrshop.attr_shop model)
{
return(dal.attr_Add(model));
}
