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