public bool AddItemImg(Entity.Goods.ItemImg model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into ItemImg(");
strSql.Append("ItemImgID,Created,Id,Position,Url");
strSql.Append(") values (");
strSql.Append("@ItemImgID,@Created,@Id,@Position,@Url");
strSql.Append(") ");
SqlParameter[] parameters =
{
new SqlParameter("@ItemImgID", SqlDbType.Int, 4),
new SqlParameter("@Created", SqlDbType.VarChar, 100),
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@Position", SqlDbType.Int, 4),
new SqlParameter("@Url", SqlDbType.VarChar, 200)
};
parameters[0].Value = model.ItemImgID;
parameters[1].Value = model.Created;
parameters[2].Value = model.Id;
parameters[3].Value = model.Position;
parameters[4].Value = model.Url;
int Ares = DBHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
if (Ares > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool UpdateItemImg(Entity.Goods.ItemImg model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update ItemImg set ");
strSql.Append(" Created = @Created , ");
strSql.Append(" Id = @Id , ");
strSql.Append(" Position = @Position , ");
strSql.Append(" Url = @Url ");
strSql.Append(" where ItemImgID=@ItemImgID");
SqlParameter[] parameters =
{
new SqlParameter("@ItemImgID", SqlDbType.Int, 4),
new SqlParameter("@Created", SqlDbType.VarChar, 100),
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@Position", SqlDbType.Int, 4),
new SqlParameter("@Url", SqlDbType.VarChar, 200)
};
parameters[1].Value = model.ItemImgID;
parameters[2].Value = model.Created;
parameters[3].Value = model.Id;
parameters[4].Value = model.Position;
parameters[5].Value = model.Url;
int Ares = DBHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters);
if (Ares > 0)
{
return(true);
}
else
{
return(false);
}
}
