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