public int InsertItem(SaleRuleItemInfo oParam) { string sql = @"INSERT INTO SaleRule_Item ( SaleRuleSysNo, ProductSysNo, Quantity, Discount ) VALUES ( @SaleRuleSysNo, @ProductSysNo, @Quantity, @Discount )"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramSaleRuleSysNo = new SqlParameter("@SaleRuleSysNo", SqlDbType.Int, 4); SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4); SqlParameter paramQuantity = new SqlParameter("@Quantity", SqlDbType.Int, 4); SqlParameter paramDiscount = new SqlParameter("@Discount", SqlDbType.Decimal, 9); SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime); if (oParam.SaleRuleSysNo != AppConst.IntNull) { paramSaleRuleSysNo.Value = oParam.SaleRuleSysNo; } else { paramSaleRuleSysNo.Value = System.DBNull.Value; } if (oParam.ProductSysNo != AppConst.IntNull) { paramProductSysNo.Value = oParam.ProductSysNo; } else { paramProductSysNo.Value = System.DBNull.Value; } if (oParam.Quantity != AppConst.IntNull) { paramQuantity.Value = oParam.Quantity; } else { paramQuantity.Value = System.DBNull.Value; } if (oParam.Discount != AppConst.DecimalNull) { paramDiscount.Value = oParam.Discount; } else { paramDiscount.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSaleRuleSysNo); cmd.Parameters.Add(paramProductSysNo); cmd.Parameters.Add(paramQuantity); cmd.Parameters.Add(paramDiscount); return(SqlHelper.ExecuteNonQuery(cmd)); }
public int UpdateItem(SaleRuleItemInfo oParam) { string sql = @"UPDATE SaleRule_Item SET ProductSysNo=@ProductSysNo,Quantity=@Quantity,Discount=@Discount WHERE SysNo=@SysNo"; SqlCommand cmd = new SqlCommand(sql); SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4); SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4); SqlParameter paramQuantity = new SqlParameter("@Quantity", SqlDbType.Int, 4); SqlParameter paramDiscount = new SqlParameter("@Discount", SqlDbType.Decimal, 9); //SqlParameter paramCreateTime = new SqlParameter("@CreateTime", SqlDbType.DateTime); if (oParam.SysNo != AppConst.IntNull) { paramSysNo.Value = oParam.SysNo; } else { paramSysNo.Value = System.DBNull.Value; } if (oParam.ProductSysNo != AppConst.IntNull) { paramProductSysNo.Value = oParam.ProductSysNo; } else { paramProductSysNo.Value = System.DBNull.Value; } if (oParam.Quantity != AppConst.IntNull) { paramQuantity.Value = oParam.Quantity; } else { paramQuantity.Value = System.DBNull.Value; } if (oParam.Discount != AppConst.DecimalNull) { paramDiscount.Value = oParam.Discount; } else { paramDiscount.Value = System.DBNull.Value; } cmd.Parameters.Add(paramSysNo); cmd.Parameters.Add(paramProductSysNo); cmd.Parameters.Add(paramQuantity); cmd.Parameters.Add(paramDiscount); return(SqlHelper.ExecuteNonQuery(cmd)); }