public int Update(PrjItemInfo oParam)
{
string sql = @"UPDATE Prj_Item SET
PrjSysNo=@PrjSysNo, SlnItemSysNo=@SlnItemSysNo, DefaultProductSysNo=@DefaultProductSysNo, DefaultQty=@DefaultQty,
IsShowPic=@IsShowPic, Status=@Status
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramPrjSysNo = new SqlParameter("@PrjSysNo", SqlDbType.Int, 4);
SqlParameter paramSlnItemSysNo = new SqlParameter("@SlnItemSysNo", SqlDbType.Int, 4);
SqlParameter paramDefaultProductSysNo = new SqlParameter("@DefaultProductSysNo", SqlDbType.Int, 4);
SqlParameter paramDefaultQty = new SqlParameter("@DefaultQty", SqlDbType.Int, 4);
SqlParameter paramIsShowPic = new SqlParameter("@IsShowPic", SqlDbType.Int, 4);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
if (oParam.SysNo != AppConst.IntNull)
{
paramSysNo.Value = oParam.SysNo;
}
else
{
paramSysNo.Value = System.DBNull.Value;
}
if (oParam.PrjSysNo != AppConst.IntNull)
{
paramPrjSysNo.Value = oParam.PrjSysNo;
}
else
{
paramPrjSysNo.Value = System.DBNull.Value;
}
if (oParam.SlnItemSysNo != AppConst.IntNull)
{
paramSlnItemSysNo.Value = oParam.SlnItemSysNo;
}
else
{
paramSlnItemSysNo.Value = System.DBNull.Value;
}
if (oParam.DefaultProductSysNo != AppConst.IntNull)
{
paramDefaultProductSysNo.Value = oParam.DefaultProductSysNo;
}
else
{
paramDefaultProductSysNo.Value = System.DBNull.Value;
}
if (oParam.DefaultQty != AppConst.IntNull)
{
paramDefaultQty.Value = oParam.DefaultQty;
}
else
{
paramDefaultQty.Value = System.DBNull.Value;
}
if (oParam.IsShowPic != AppConst.IntNull)
{
paramIsShowPic.Value = oParam.IsShowPic;
}
else
{
paramIsShowPic.Value = System.DBNull.Value;
}
if (oParam.Status != AppConst.IntNull)
{
paramStatus.Value = oParam.Status;
}
else
{
paramStatus.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramPrjSysNo);
cmd.Parameters.Add(paramSlnItemSysNo);
cmd.Parameters.Add(paramDefaultProductSysNo);
cmd.Parameters.Add(paramDefaultQty);
cmd.Parameters.Add(paramIsShowPic);
cmd.Parameters.Add(paramStatus);
return(SqlHelper.ExecuteNonQuery(cmd));
}
public int Insert(PrjItemInfo oParam)
{
string sql = @"INSERT INTO Prj_Item
(
PrjSysNo, SlnItemSysNo, DefaultProductSysNo, DefaultQty, IsShowPic, Status
)
VALUES (
@PrjSysNo, @SlnItemSysNo, @DefaultProductSysNo, @DefaultQty, @IsShowPic, @Status
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramPrjSysNo = new SqlParameter("@PrjSysNo", SqlDbType.Int, 4);
SqlParameter paramSlnItemSysNo = new SqlParameter("@SlnItemSysNo", SqlDbType.Int, 4);
SqlParameter paramDefaultProductSysNo = new SqlParameter("@DefaultProductSysNo", SqlDbType.Int, 4);
SqlParameter paramDefaultQty = new SqlParameter("@DefaultQty", SqlDbType.Int, 4);
SqlParameter paramIsShowPic = new SqlParameter("@IsShowPic", SqlDbType.Int, 4);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int, 4);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.PrjSysNo != AppConst.IntNull)
{
paramPrjSysNo.Value = oParam.PrjSysNo;
}
else
{
paramPrjSysNo.Value = System.DBNull.Value;
}
if (oParam.SlnItemSysNo != AppConst.IntNull)
{
paramSlnItemSysNo.Value = oParam.SlnItemSysNo;
}
else
{
paramSlnItemSysNo.Value = System.DBNull.Value;
}
if (oParam.DefaultProductSysNo != AppConst.IntNull)
{
paramDefaultProductSysNo.Value = oParam.DefaultProductSysNo;
}
else
{
paramDefaultProductSysNo.Value = System.DBNull.Value;
}
if (oParam.DefaultQty != AppConst.IntNull)
{
paramDefaultQty.Value = oParam.DefaultQty;
}
else
{
paramDefaultQty.Value = System.DBNull.Value;
}
if (oParam.IsShowPic != AppConst.IntNull)
{
paramIsShowPic.Value = oParam.IsShowPic;
}
else
{
paramIsShowPic.Value = System.DBNull.Value;
}
if (oParam.Status != AppConst.IntNull)
{
paramStatus.Value = oParam.Status;
}
else
{
paramStatus.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramPrjSysNo);
cmd.Parameters.Add(paramSlnItemSysNo);
cmd.Parameters.Add(paramDefaultProductSysNo);
cmd.Parameters.Add(paramDefaultQty);
cmd.Parameters.Add(paramIsShowPic);
cmd.Parameters.Add(paramStatus);
return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo));
}
