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