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