public int Insert(PrjItemFilterInfo oParam)
{
string sql = @"INSERT INTO prj_item_filter
(
PrjItemSysNo, Filter,PriceFrom,PriceTo
)
VALUES (
@PrjItemSysNo, @Filter,@PriceFrom,@PriceTo
);set @SysNo = SCOPE_IDENTITY();";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramPrjItemSysNo = new SqlParameter("@PrjItemSysNo", SqlDbType.Int, 4);
SqlParameter paramFilter = new SqlParameter("@Filter", SqlDbType.NVarChar, 2000);
SqlParameter paramPriceFrom = new SqlParameter("@PriceFrom", SqlDbType.Decimal, 9);
SqlParameter paramPriceTo = new SqlParameter("@PriceTo", SqlDbType.Decimal, 9);
paramSysNo.Direction = ParameterDirection.Output;
if (oParam.PrjItemSysNo != AppConst.IntNull)
{
paramPrjItemSysNo.Value = oParam.PrjItemSysNo;
}
else
{
paramPrjItemSysNo.Value = System.DBNull.Value;
}
if (oParam.Filter != AppConst.StringNull)
{
paramFilter.Value = oParam.Filter;
}
else
{
paramFilter.Value = System.DBNull.Value;
}
if (oParam.PriceFrom != AppConst.DecimalNull)
{
paramPriceFrom.Value = oParam.PriceFrom;
}
else
{
paramPriceFrom.Value = System.DBNull.Value;
}
if (oParam.PriceTo != AppConst.DecimalNull)
{
paramPriceTo.Value = oParam.PriceTo;
}
else
{
paramPriceTo.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramPrjItemSysNo);
cmd.Parameters.Add(paramFilter);
cmd.Parameters.Add(paramPriceFrom);
cmd.Parameters.Add(paramPriceTo);
return(SqlHelper.ExecuteNonQuery(cmd, out oParam.SysNo));
}
public int Update(PrjItemFilterInfo oParam)
{
string sql = @"UPDATE prj_item_filter SET
PrjItemSysNo=@PrjItemSysNo, Filter=@Filter,PriceFrom=@PriceFrom,PriceTo=@PriceTo
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramPrjItemSysNo = new SqlParameter("@PrjItemSysNo", SqlDbType.Int, 4);
SqlParameter paramFilter = new SqlParameter("@Filter", SqlDbType.NVarChar, 2000);
SqlParameter paramPriceFrom = new SqlParameter("@PriceFrom", SqlDbType.Decimal, 9);
SqlParameter paramPriceTo = new SqlParameter("@PriceTo", SqlDbType.Decimal, 9);
if (oParam.SysNo != AppConst.IntNull)
{
paramSysNo.Value = oParam.SysNo;
}
else
{
paramSysNo.Value = System.DBNull.Value;
}
if (oParam.PrjItemSysNo != AppConst.IntNull)
{
paramPrjItemSysNo.Value = oParam.PrjItemSysNo;
}
else
{
paramPrjItemSysNo.Value = System.DBNull.Value;
}
if (oParam.Filter != AppConst.StringNull)
{
paramFilter.Value = oParam.Filter;
}
else
{
paramFilter.Value = System.DBNull.Value;
}
if (oParam.PriceFrom != AppConst.DecimalNull)
{
paramPriceFrom.Value = oParam.PriceFrom;
}
else
{
paramPriceFrom.Value = System.DBNull.Value;
}
if (oParam.PriceTo != AppConst.DecimalNull)
{
paramPriceTo.Value = oParam.PriceTo;
}
else
{
paramPriceTo.Value = System.DBNull.Value;
}
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramPrjItemSysNo);
cmd.Parameters.Add(paramFilter);
cmd.Parameters.Add(paramPriceFrom);
cmd.Parameters.Add(paramPriceTo);
return(SqlHelper.ExecuteNonQuery(cmd));
}