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); }
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 InsertUpdatePrjItemFilter(PrjItemFilterInfo oParam) { string sql = "select * from prj_item_filter where prjitemsysno = " + oParam.PrjItemSysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { oParam.SysNo = Util.TrimIntNull(ds.Tables[0].Rows[0]["sysno"]); return new PrjDac().Update(oParam); } else { return new PrjDac().Insert(oParam); } }
public PrjItemFilterInfo LoadPrjItemFilter(int PrjItemSysNo) { string sql = "select * from prj_item_filter where prjitemsysno=" + PrjItemSysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); PrjItemFilterInfo oParam = new PrjItemFilterInfo(); if (Util.HasMoreRow(ds)) mapPrjItemFilterInfo(oParam, ds.Tables[0].Rows[0]); else oParam = null; return oParam; }
private void mapPrjItemFilterInfo(PrjItemFilterInfo oParam, DataRow tempdr) { oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]); oParam.PrjItemSysNo = Util.TrimIntNull(tempdr["PrjItemSysNo"]); oParam.Filter = Util.TrimNull(tempdr["Filter"]); oParam.PriceFrom = Util.TrimDecimalNull(tempdr["PriceFrom"]); oParam.PriceTo = Util.TrimDecimalNull(tempdr["PriceTo"]); }