/// <summary> /// 根据Faid查询到一条BGFixAssetPurchase记录 /// </summary> /// <param name="faid">FAID</param> /// <returns>BGFixAssetPurchase</returns> public static BG_FixAssetPurchase GetFAPByFaid(int faid) { BG_FixAssetPurchase fap = new BG_FixAssetPurchase(); string sqlStr = "select * from BG_FixAssetPurchase where FAID={0}"; sqlStr = string.Format(sqlStr, faid); try { SqlDataReader dr = DBUnity.ExecuteReader(CommandType.Text, sqlStr, null); while (dr.Read()) { fap.FAID = common.IntSafeConvert(dr["FAID"]); fap.BudID = common.IntSafeConvert(dr["BudID"]); fap.FAName = dr["FAName"].ToString(); fap.FAModel = dr["FAModel"].ToString(); fap.FABrand = dr["FABrand"].ToString(); fap.FAPrice = ParseUtil.ToDecimal(dr["FAPrice"].ToString(), 0); fap.FANum = common.IntSafeConvert(dr["FANum"]); fap.FAMon = ParseUtil.ToDecimal(dr["FAMon"].ToString(), 0); fap.FAIsGovPur = dr["FAIsGovPur"].ToString(); fap.FAConfig = dr["FAConfig"].ToString(); fap.FARemark = dr["FARemark"].ToString(); fap.FATime = ParseUtil.ToDateTime(dr["FATime"].ToString(), DateTime.Now); } dr.Close(); } catch (Exception ex) { fap = null; Log.WriteLog(ex.Message, "BGFixAssetPurchaseService--GetFAPByFaid"); } return(fap); }
/// <summary> /// 根据Budid获取单条BGBudItems记录 /// </summary> /// <param name="biid"></param> /// <returns></returns> public static BG_BudItems GetBudItemsByBudid(int Budid) { BG_BudItems budItems = new BG_BudItems(); string sqlStr = "select * from BG_BudItems where BudID=@BudID"; SqlParameter[] Pars = new SqlParameter[] { new SqlParameter("@BudID", Budid) }; try { SqlDataReader dr = DBUnity.ExecuteReader(CommandType.Text, sqlStr, Pars); while (dr.Read()) { budItems.BudID = common.IntSafeConvert(dr["BudID"]); budItems.BIProType = dr["BIProType"].ToString(); budItems.BIFunSub = dr["BIFunSub"].ToString(); budItems.BICode = dr["BICode"].ToString(); budItems.PPID = common.IntSafeConvert(dr["PPID"]); budItems.PIID = common.IntSafeConvert(dr["PIID"]); budItems.BIPlanHz = dr["BIPlanHz"].ToString(); budItems.BIStaTime = ParseUtil.ToDateTime(dr["BIStaTime"].ToString(), DateTime.Now); budItems.BIEndTime = ParseUtil.ToDateTime(dr["BIEndTime"].ToString(), DateTime.Now); budItems.BICharger = dr["BICharger"].ToString(); budItems.BIAttr = dr["BIAttr"].ToString(); budItems.BIAppReaCon = dr["BIAppReaCon"].ToString(); budItems.BIExpGistExp = dr["BIExpGistExp"].ToString(); budItems.BILongGoal = dr["BILongGoal"].ToString(); budItems.BIYearGoal = dr["BIYearGoal"].ToString(); budItems.BIMon = ParseUtil.ToDecimal(dr["BIMon"].ToString(), 0); budItems.BIAppConMon = ParseUtil.ToDecimal(dr["BIAppConMon"].ToString(), 0); budItems.BIMonSou = dr["BIMonSou"].ToString(); budItems.BIFinAllo = ParseUtil.ToDecimal(dr["BIFinAllo"].ToString(), 0); budItems.BILastYearCarry = ParseUtil.ToDecimal(dr["BILastYearCarry"].ToString(), 0); budItems.BIOthFun = ParseUtil.ToDecimal(dr["BIOthFun"].ToString(), 0); budItems.BIOthExpProb = dr["BIOthExpProb"].ToString(); budItems.BIBudSta = dr["BIBudSta"].ToString(); budItems.BudSta = dr["BudSta"].ToString(); budItems.BICause = dr["BICause"].ToString(); budItems.DepID = common.IntSafeConvert(dr["DepID"]); budItems.BIProName = dr["BIProName"].ToString(); budItems.BIReportTime = ParseUtil.ToDateTime(dr["BIReportTime"].ToString(), DateTime.Now); budItems.BIConNum = ParseUtil.ToDecimal(dr["BIConNum"].ToString(), 0); budItems.BIProDescrip = dr["BIProDescrip"].ToString(); budItems.BIProCategory = dr["BIProCategory"].ToString(); } dr.Close(); } catch (Exception ex) { budItems = null; Log.WriteLog(ex.Message, "BGBudItemsService--GetBudItemsByBiid"); } return(budItems); }