public int Insert(PromotionItemProductInfo oParam)
{
string sql = @"INSERT INTO Promotion_Item_Product
(
PromotionItemGroupSysNo, ProductSysNo, PromotionDiscount, OrderNum
)
VALUES (
@PromotionItemGroupSysNo, @ProductSysNo, @PromotionDiscount, @OrderNum
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramPromotionItemGroupSysNo = new SqlParameter("@PromotionItemGroupSysNo", SqlDbType.Int, 4);
SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4);
SqlParameter paramPromotionDiscount = new SqlParameter("@PromotionDiscount", SqlDbType.Decimal, 9);
SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.PromotionItemGroupSysNo != AppConst.IntNull)
{
paramPromotionItemGroupSysNo.Value = oParam.PromotionItemGroupSysNo;
}
else
{
paramPromotionItemGroupSysNo.Value = System.DBNull.Value;
}
if (oParam.ProductSysNo != AppConst.IntNull)
{
paramProductSysNo.Value = oParam.ProductSysNo;
}
else
{
paramProductSysNo.Value = System.DBNull.Value;
}
if (oParam.PromotionDiscount != AppConst.DecimalNull)
{
paramPromotionDiscount.Value = oParam.PromotionDiscount;
}
else
{
paramPromotionDiscount.Value = System.DBNull.Value;
}
if (oParam.OrderNum != AppConst.IntNull)
{
paramOrderNum.Value = oParam.OrderNum;
}
else
{
paramOrderNum.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramPromotionItemGroupSysNo);
cmd.Parameters.Add(paramProductSysNo);
cmd.Parameters.Add(paramPromotionDiscount);
cmd.Parameters.Add(paramOrderNum);
return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo));
}
private void map(PromotionItemProductInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.PromotionItemGroupSysNo = Util.TrimIntNull(tempdr["PromotionItemGroupSysNo"]);
oParam.ProductSysNo = Util.TrimIntNull(tempdr["ProductSysNo"]);
oParam.PromotionDiscount = Util.TrimDecimalNull(tempdr["PromotionDiscount"]);
oParam.OrderNum = Util.TrimIntNull(tempdr["OrderNum"]);
}
public PromotionItemProductInfo LoadItemProduct(int sysNo)
{
string sql = "select * from Promotion_Item_Product where sysno =" + sysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (!Util.HasMoreRow(ds))
{
return(null);
}
PromotionItemProductInfo oItemProductInfo = new PromotionItemProductInfo();
map(oItemProductInfo, ds.Tables[0].Rows[0]);
return(oItemProductInfo);
}
public int Update(PromotionItemProductInfo oParam)
{
string sql = @"UPDATE Promotion_Item_Product SET
PromotionItemGroupSysNo=@PromotionItemGroupSysNo, ProductSysNo=@ProductSysNo,
PromotionDiscount=@PromotionDiscount, OrderNum=@OrderNum
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramPromotionItemGroupSysNo = new SqlParameter("@PromotionItemGroupSysNo", SqlDbType.Int, 4);
SqlParameter paramProductSysNo = new SqlParameter("@ProductSysNo", SqlDbType.Int, 4);
SqlParameter paramPromotionDiscount = new SqlParameter("@PromotionDiscount", SqlDbType.Decimal, 9);
SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4);
if (oParam.SysNo != AppConst.IntNull)
{
paramSysNo.Value = oParam.SysNo;
}
else
{
paramSysNo.Value = System.DBNull.Value;
}
if (oParam.PromotionItemGroupSysNo != AppConst.IntNull)
{
paramPromotionItemGroupSysNo.Value = oParam.PromotionItemGroupSysNo;
}
else
{
paramPromotionItemGroupSysNo.Value = System.DBNull.Value;
}
if (oParam.ProductSysNo != AppConst.IntNull)
{
paramProductSysNo.Value = oParam.ProductSysNo;
}
else
{
paramProductSysNo.Value = System.DBNull.Value;
}
if (oParam.PromotionDiscount != AppConst.DecimalNull)
{
paramPromotionDiscount.Value = oParam.PromotionDiscount;
}
else
{
paramPromotionDiscount.Value = System.DBNull.Value;
}
if (oParam.OrderNum != AppConst.IntNull)
{
paramOrderNum.Value = oParam.OrderNum;
}
else
{
paramOrderNum.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramPromotionItemGroupSysNo);
cmd.Parameters.Add(paramProductSysNo);
cmd.Parameters.Add(paramPromotionDiscount);
cmd.Parameters.Add(paramOrderNum);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public void UpdateItemProduct(PromotionItemProductInfo oParm)
{
new PromotionItemProductDac().Update(oParm);
}
public void InsertItemProduct(PromotionItemProductInfo oParam)
{
new PromotionItemProductDac().Insert(oParam);
}
