/// <summary>
/// 增加一条数据
/// </summary>
public void Add(Garfield.Model.CRM_order_details model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into CRM_order_details(");
strSql.Append("order_id,product_id,product_name,price,quantity,unit,amount)");
strSql.Append(" values (");
strSql.Append("@order_id,@product_id,@product_name,@price,@quantity,@unit,@amount)");
SqlParameter[] parameters =
{
new SqlParameter("@order_id", SqlDbType.Int, 4),
new SqlParameter("@product_id", SqlDbType.Int, 4),
new SqlParameter("@product_name", SqlDbType.VarChar, 250),
new SqlParameter("@price", SqlDbType.Float, 8),
new SqlParameter("@quantity", SqlDbType.Int, 4),
new SqlParameter("@unit", SqlDbType.VarChar, 250),
new SqlParameter("@amount", SqlDbType.Float, 8)
};
parameters[0].Value = model.order_id;
parameters[1].Value = model.product_id;
parameters[2].Value = model.product_name;
parameters[3].Value = model.price;
parameters[4].Value = model.quantity;
parameters[5].Value = model.unit;
parameters[6].Value = model.amount;
DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Garfield.Model.CRM_order_details model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update CRM_order_details set ");
strSql.Append("order_id=@order_id,");
strSql.Append("product_id=@product_id,");
strSql.Append("product_name=@product_name,");
strSql.Append("price=@price,");
strSql.Append("quantity=@quantity,");
strSql.Append("unit=@unit,");
strSql.Append("amount=@amount");
strSql.Append(" where ");
SqlParameter[] parameters =
{
new SqlParameter("@order_id", SqlDbType.Int, 4),
new SqlParameter("@product_id", SqlDbType.Int, 4),
new SqlParameter("@product_name", SqlDbType.VarChar, 250),
new SqlParameter("@price", SqlDbType.Float, 8),
new SqlParameter("@quantity", SqlDbType.Int, 4),
new SqlParameter("@unit", SqlDbType.VarChar, 250),
new SqlParameter("@amount", SqlDbType.Float, 8)
};
parameters[0].Value = model.order_id;
parameters[1].Value = model.product_id;
parameters[2].Value = model.product_name;
parameters[3].Value = model.price;
parameters[4].Value = model.quantity;
parameters[5].Value = model.unit;
parameters[6].Value = model.amount;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
