public static BG_Department GetBG_DepartmentByDepID(int depID)
{
string sql = "SELECT * FROM BG_Department WHERE DepID = @DepID";
try
{
SqlParameter para = new SqlParameter("@DepID", depID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_Department bG_Department = new BG_Department();
bG_Department.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"];
bG_Department.DepLev = dt.Rows[0]["DepLev"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepLev"];
bG_Department.FaDepID = dt.Rows[0]["FaDepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["FaDepID"];
bG_Department.DepCode = dt.Rows[0]["DepCode"] == DBNull.Value ? "" : (string)dt.Rows[0]["DepCode"];
bG_Department.DepName = dt.Rows[0]["DepName"] == DBNull.Value ? "" : (string)dt.Rows[0]["DepName"];
bG_Department.DepQua = dt.Rows[0]["DepQua"] == DBNull.Value ? "" : (string)dt.Rows[0]["DepQua"];
bG_Department.DepSta = dt.Rows[0]["DepSta"] == DBNull.Value ? "" : (string)dt.Rows[0]["DepSta"];
bG_Department.DepRem = dt.Rows[0]["DepRem"] == DBNull.Value ? "" : (string)dt.Rows[0]["DepRem"];
return(bG_Department);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_ReimAppendix GetBG_ReimAppendixByRADID(int rADID)
{
string sql = "SELECT * FROM BG_ReimAppendix WHERE RADID = @RADID";
try
{
SqlParameter para = new SqlParameter("@RADID", rADID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_ReimAppendix bG_ReimAppendix = new BG_ReimAppendix();
bG_ReimAppendix.RADID = dt.Rows[0]["RADID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["RADID"];
bG_ReimAppendix.ARID = dt.Rows[0]["ARID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["ARID"];
bG_ReimAppendix.ARType = dt.Rows[0]["ARType"] == DBNull.Value ? "" : (string)dt.Rows[0]["ARType"];
bG_ReimAppendix.ARName = dt.Rows[0]["ARName"] == DBNull.Value ? "" : (string)dt.Rows[0]["ARName"];
bG_ReimAppendix.ARContent = dt.Rows[0]["ARContent"] == DBNull.Value ? "" : (string)dt.Rows[0]["ARContent"];
bG_ReimAppendix.ARTime = dt.Rows[0]["ARTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["ARTime"];
return(bG_ReimAppendix);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_DataRecord GetBG_DataRecordByDRID(int dRID)
{
string sql = "SELECT * FROM BG_DataRecord WHERE DRID = @DRID";
try
{
SqlParameter para = new SqlParameter("@DRID", dRID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_DataRecord bG_DataRecord = new BG_DataRecord();
bG_DataRecord.DRID = dt.Rows[0]["DRID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DRID"];
bG_DataRecord.DRType = dt.Rows[0]["DRType"] == DBNull.Value ? "" : (string)dt.Rows[0]["DRType"];
bG_DataRecord.DRTime = dt.Rows[0]["DRTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["DRTime"];
bG_DataRecord.DRName = dt.Rows[0]["DRName"] == DBNull.Value ? "" : (string)dt.Rows[0]["DRName"];
bG_DataRecord.IsBackUp = dt.Rows[0]["IsBackUp"] == DBNull.Value ? "" : (string)dt.Rows[0]["IsBackUp"];
return(bG_DataRecord);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_BudItemHis GetBG_BudItemHisByBudHisID(int budHisID)
{
string sql = "SELECT * FROM BG_BudItemHis WHERE BudHisID = @BudHisID";
try
{
SqlParameter para = new SqlParameter("@BudHisID", budHisID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_BudItemHis bG_BudItemHis = new BG_BudItemHis();
bG_BudItemHis.BudHisID = dt.Rows[0]["BudHisID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["BudHisID"];
bG_BudItemHis.BudID = dt.Rows[0]["BudID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["BudID"];
bG_BudItemHis.BIProType = dt.Rows[0]["BIProType"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIProType"];
bG_BudItemHis.BIFunSub = dt.Rows[0]["BIFunSub"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIFunSub"];
bG_BudItemHis.BICode = dt.Rows[0]["BICode"] == DBNull.Value ? "" : (string)dt.Rows[0]["BICode"];
bG_BudItemHis.PPID = dt.Rows[0]["PPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PPID"];
bG_BudItemHis.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
bG_BudItemHis.BIPlanHz = dt.Rows[0]["BIPlanHz"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIPlanHz"];
bG_BudItemHis.BIStaTime = dt.Rows[0]["BIStaTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["BIStaTime"];
bG_BudItemHis.BIEndTime = dt.Rows[0]["BIEndTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["BIEndTime"];
bG_BudItemHis.BICharger = dt.Rows[0]["BICharger"] == DBNull.Value ? "" : (string)dt.Rows[0]["BICharger"];
bG_BudItemHis.BIAttr = dt.Rows[0]["BIAttr"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIAttr"];
bG_BudItemHis.BIAppReaCon = dt.Rows[0]["BIAppReaCon"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIAppReaCon"];
bG_BudItemHis.BIExpGistExp = dt.Rows[0]["BIExpGistExp"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIExpGistExp"];
bG_BudItemHis.BILongGoal = dt.Rows[0]["BILongGoal"] == DBNull.Value ? "" : (string)dt.Rows[0]["BILongGoal"];
bG_BudItemHis.BIYearGoal = dt.Rows[0]["BIYearGoal"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIYearGoal"];
bG_BudItemHis.BIMon = dt.Rows[0]["BIMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BIMon"];
bG_BudItemHis.BIAppConMon = dt.Rows[0]["BIAppConMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BIAppConMon"];
bG_BudItemHis.BIMonSou = dt.Rows[0]["BIMonSou"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIMonSou"];
bG_BudItemHis.BIFinAllo = dt.Rows[0]["BIFinAllo"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BIFinAllo"];
bG_BudItemHis.BILastYearCarry = dt.Rows[0]["BILastYearCarry"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BILastYearCarry"];
bG_BudItemHis.BIOthFun = dt.Rows[0]["BIOthFun"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BIOthFun"];
bG_BudItemHis.BIOthExpProb = dt.Rows[0]["BIOthExpProb"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIOthExpProb"];
bG_BudItemHis.BIBudSta = dt.Rows[0]["BIBudSta"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIBudSta"];
bG_BudItemHis.BudSta = dt.Rows[0]["BudSta"] == DBNull.Value ? "" : (string)dt.Rows[0]["BudSta"];
bG_BudItemHis.BICause = dt.Rows[0]["BICause"] == DBNull.Value ? "" : (string)dt.Rows[0]["BICause"];
bG_BudItemHis.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"];
bG_BudItemHis.BIProName = dt.Rows[0]["BIProName"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIProName"];
bG_BudItemHis.BIReportTime = dt.Rows[0]["BIReportTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["BIReportTime"];
bG_BudItemHis.BIConNum = dt.Rows[0]["BIConNum"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BIConNum"];
bG_BudItemHis.BIProDescrip = dt.Rows[0]["BIProDescrip"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIProDescrip"];
bG_BudItemHis.BIProCategory = dt.Rows[0]["BIProCategory"] == DBNull.Value ? "" : (string)dt.Rows[0]["BIProCategory"];
bG_BudItemHis.BIYear = dt.Rows[0]["BIYear"] == DBNull.Value ? 0 : (int)dt.Rows[0]["BIYear"];
return(bG_BudItemHis);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
/// <summary>
/// 根据部门ID查询一条记录
/// </summary>
/// <param name="depid">部门ID</param>
/// <returns>BGDepartment</returns>
public static BG_Department GetDepBydepid(string depid)
{
BG_Department dep = new BG_Department();
try
{
string sqlStr = "select * from BG_Department where DepID='{0}'";
sqlStr = string.Format(sqlStr, depid);
DataTable dt = DBUnity.AdapterToTab(sqlStr);
if (dt.Rows.Count > 0)
{
dep.DepID = (int)dt.Rows[0]["DepID"];
dep.DepLev = (int)dt.Rows[0]["DepLev"];
dep.FaDepID = (int)dt.Rows[0]["FaDepID"];
dep.DepCode = dt.Rows[0]["DepCode"].ToString();
dep.DepName = dt.Rows[0]["DepName"].ToString();
dep.DepQua = dt.Rows[0]["DepQua"].ToString();
dep.DepSta = dt.Rows[0]["DepSta"].ToString();
dep.DepRem = dt.Rows[0]["DepRem"].ToString();
}
}
catch (Exception ex)
{
dep = new BG_Department();
Log.WriteLog(ex.Message, "BGDepartmentService--GetDepBydepid");
}
return(dep);
}
public static BG_OutlayCK GetBG_OutlayCKByOAID(int oAID)
{
string sql = "SELECT * FROM BG_OutlayCK WHERE OAID = @OAID";
try
{
SqlParameter para = new SqlParameter("@OAID", oAID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_OutlayCK bG_OutlayCK = new BG_OutlayCK();
bG_OutlayCK.OAID = dt.Rows[0]["OAID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["OAID"];
bG_OutlayCK.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
bG_OutlayCK.PPID = dt.Rows[0]["PPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PPID"];
bG_OutlayCK.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"];
bG_OutlayCK.OACkMon = dt.Rows[0]["OACkMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["OACkMon"];
bG_OutlayCK.OATime = dt.Rows[0]["OATime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["OATime"];
bG_OutlayCK.OACkType = dt.Rows[0]["OACkType"] == DBNull.Value ? "" : (string)dt.Rows[0]["OACkType"];
return(bG_OutlayCK);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_Supplementary GetBG_SupplementaryBySuppID(int suppID)
{
string sql = "SELECT * FROM BG_Supplementary WHERE SuppID = @SuppID";
try
{
SqlParameter para = new SqlParameter("@SuppID", suppID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_Supplementary bG_Supplementary = new BG_Supplementary();
bG_Supplementary.SuppID = dt.Rows[0]["SuppID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["SuppID"];
bG_Supplementary.SuppMon = dt.Rows[0]["SuppMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["SuppMon"];
bG_Supplementary.Year = dt.Rows[0]["Year"] == DBNull.Value ? 0 : (int)dt.Rows[0]["Year"];
return(bG_Supplementary);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_MonPayPlanRemark GetBG_MonPayPlanRemarkByPRID(int pRID)
{
string sql = "SELECT * FROM BG_MonPayPlanRemark WHERE PRID = @PRID";
try
{
SqlParameter para = new SqlParameter("@PRID", pRID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_MonPayPlanRemark bG_MonPayPlanRemark = new BG_MonPayPlanRemark();
bG_MonPayPlanRemark.PRID = dt.Rows[0]["PRID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PRID"];
bG_MonPayPlanRemark.DeptID = dt.Rows[0]["DeptID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DeptID"];
bG_MonPayPlanRemark.MATime = dt.Rows[0]["MATime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["MATime"];
bG_MonPayPlanRemark.MASta = dt.Rows[0]["MASta"] == DBNull.Value ? "" : (string)dt.Rows[0]["MASta"];
bG_MonPayPlanRemark.MACause = dt.Rows[0]["MACause"] == DBNull.Value ? "" : (string)dt.Rows[0]["MACause"];
bG_MonPayPlanRemark.MAUser = dt.Rows[0]["MAUser"] == DBNull.Value ? "" : (string)dt.Rows[0]["MAUser"];
bG_MonPayPlanRemark.MATimes = dt.Rows[0]["MATimes"] == DBNull.Value ? 0 : (int)dt.Rows[0]["MATimes"];
return(bG_MonPayPlanRemark);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_PayProject GetBG_PayProjectByPPID(int pPID)
{
string sql = "SELECT * FROM BG_PayProject WHERE PPID = @PPID";
try
{
SqlParameter para = new SqlParameter("@PPID", pPID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_PayProject bG_PayProject = new BG_PayProject();
bG_PayProject.PPID = dt.Rows[0]["PPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PPID"];
bG_PayProject.PayPrjName = dt.Rows[0]["PayPrjName"] == DBNull.Value ? "" : (string)dt.Rows[0]["PayPrjName"];
bG_PayProject.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
return(bG_PayProject);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_IncomeAna GetBG_IncomeAnaByIAID(int iAID)
{
string sql = "SELECT * FROM BG_IncomeAna WHERE IAID = @IAID";
try
{
SqlParameter para = new SqlParameter("@IAID", iAID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_IncomeAna bG_IncomeAna = new BG_IncomeAna();
bG_IncomeAna.IAID = dt.Rows[0]["IAID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["IAID"];
bG_IncomeAna.EIID = dt.Rows[0]["EIID"] == DBNull.Value ? "" : (string)dt.Rows[0]["EIID"];
bG_IncomeAna.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? "" : (string)dt.Rows[0]["DepID"];
bG_IncomeAna.IABudMon = dt.Rows[0]["IABudMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["IABudMon"];
bG_IncomeAna.IAAudMon = dt.Rows[0]["IAAudMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["IAAudMon"];
bG_IncomeAna.IACkMon = dt.Rows[0]["IACkMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["IACkMon"];
bG_IncomeAna.IAYear = dt.Rows[0]["IAYear"] == DBNull.Value ? 0 : (int)dt.Rows[0]["IAYear"];
return(bG_IncomeAna);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_EstimatesAllocation GetBG_EstimatesAllocationByBEAID(int bEAID)
{
string sql = "SELECT * FROM BG_EstimatesAllocation WHERE BEAID = @BEAID";
try
{
SqlParameter para = new SqlParameter("@BEAID", bEAID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_EstimatesAllocation bG_EstimatesAllocation = new BG_EstimatesAllocation();
bG_EstimatesAllocation.BEAID = dt.Rows[0]["BEAID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["BEAID"];
bG_EstimatesAllocation.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"];
bG_EstimatesAllocation.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
bG_EstimatesAllocation.BEAMon = dt.Rows[0]["BEAMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BEAMon"];
bG_EstimatesAllocation.BEAYear = dt.Rows[0]["BEAYear"] == DBNull.Value ? 0 : (int)dt.Rows[0]["BEAYear"];
return(bG_EstimatesAllocation);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_PreviewData GetBG_PreviewDataByPSID(int pSID)
{
string sql = "SELECT * FROM BG_PreviewData WHERE PSID = @PSID";
try
{
SqlParameter para = new SqlParameter("@PSID", pSID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_PreviewData bG_PreviewData = new BG_PreviewData();
bG_PreviewData.PSID = dt.Rows[0]["PSID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PSID"];
bG_PreviewData.PSType1 = dt.Rows[0]["PSType1"] == DBNull.Value ? "" : (string)dt.Rows[0]["PSType1"];
bG_PreviewData.PSType2 = dt.Rows[0]["PSType2"] == DBNull.Value ? "" : (string)dt.Rows[0]["PSType2"];
bG_PreviewData.PSName = dt.Rows[0]["PSName"] == DBNull.Value ? "" : (string)dt.Rows[0]["PSName"];
bG_PreviewData.PDBaseData = dt.Rows[0]["PDBaseData"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PDBaseData"];
bG_PreviewData.PDBaseLYData = dt.Rows[0]["PDBaseLYData"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PDBaseLYData"];
bG_PreviewData.PDProjectData = dt.Rows[0]["PDProjectData"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PDProjectData"];
bG_PreviewData.PDProjectLYData = dt.Rows[0]["PDProjectLYData"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["PDProjectLYData"];
return(bG_PreviewData);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_PayIncome GetBG_PayIncomeByPIID(int pIID)
{
string sql = "SELECT * FROM BG_PayIncome WHERE PIID = @PIID";
try
{
SqlParameter para = new SqlParameter("@PIID", pIID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_PayIncome bG_PayIncome = new BG_PayIncome();
bG_PayIncome.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
bG_PayIncome.PIEcoSubCoding = dt.Rows[0]["PIEcoSubCoding"] == DBNull.Value ? "" : (string)dt.Rows[0]["PIEcoSubCoding"];
bG_PayIncome.PIEcoSubLev = dt.Rows[0]["PIEcoSubLev"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIEcoSubLev"];
bG_PayIncome.PIEcoSubParID = dt.Rows[0]["PIEcoSubParID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIEcoSubParID"];
bG_PayIncome.PIEcoSubName = dt.Rows[0]["PIEcoSubName"] == DBNull.Value ? "" : (string)dt.Rows[0]["PIEcoSubName"];
bG_PayIncome.PIType = dt.Rows[0]["PIType"] == DBNull.Value ? "" : (string)dt.Rows[0]["PIType"];
bG_PayIncome.ISSign = dt.Rows[0]["ISSign"] == DBNull.Value ? 0 : (int)dt.Rows[0]["ISSign"];
return(bG_PayIncome);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_ProPay GetBG_ProPayByProPID(int proPID)
{
string sql = "SELECT * FROM BG_ProPay WHERE ProPID = @ProPID";
try
{
SqlParameter para = new SqlParameter("@ProPID", proPID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_ProPay bG_ProPay = new BG_ProPay();
bG_ProPay.ProPID = dt.Rows[0]["ProPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["ProPID"];
bG_ProPay.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"];
bG_ProPay.ProPYear = dt.Rows[0]["ProPYear"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["ProPYear"];
bG_ProPay.PPID = dt.Rows[0]["PPID"] == DBNull.Value ? "" : (string)dt.Rows[0]["PPID"];
bG_ProPay.ProPA0M = dt.Rows[0]["ProPA0M"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["ProPA0M"];
return(bG_ProPay);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_PrjJonSub GetBG_PrjJonSubByPSID(int pSID)
{
string sql = "SELECT * FROM BG_PrjJonSub WHERE PSID = @PSID";
try
{
SqlParameter para = new SqlParameter("@PSID", pSID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_PrjJonSub bG_PrjJonSub = new BG_PrjJonSub();
bG_PrjJonSub.PSID = dt.Rows[0]["PSID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PSID"];
bG_PrjJonSub.PPID = dt.Rows[0]["PPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PPID"];
bG_PrjJonSub.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
return(bG_PrjJonSub);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_BudControl GetBG_BudControlByBCID(int bCID)
{
string sql = "SELECT * FROM BG_BudControl WHERE BCID = @BCID";
try
{
SqlParameter para = new SqlParameter("@BCID", bCID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_BudControl bG_BudControl = new BG_BudControl();
bG_BudControl.BCID = dt.Rows[0]["BCID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["BCID"];
bG_BudControl.BCName = dt.Rows[0]["BCName"] == DBNull.Value ? "" : (string)dt.Rows[0]["BCName"];
bG_BudControl.BCType = dt.Rows[0]["BCType"] == DBNull.Value ? "" : (string)dt.Rows[0]["BCType"];
bG_BudControl.BCMon = dt.Rows[0]["BCMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BCMon"];
bG_BudControl.BCAdjust = dt.Rows[0]["BCAdjust"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BCAdjust"];
return(bG_BudControl);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_IncomeCPay GetBG_IncomeCPayByICPID(int iCPID)
{
string sql = "SELECT * FROM BG_IncomeCPay WHERE ICPID = @ICPID";
try
{
SqlParameter para = new SqlParameter("@ICPID", iCPID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_IncomeCPay bG_IncomeCPay = new BG_IncomeCPay();
bG_IncomeCPay.ICPID = dt.Rows[0]["ICPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["ICPID"];
bG_IncomeCPay.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"];
bG_IncomeCPay.InComeSouce = dt.Rows[0]["InComeSouce"] == DBNull.Value ? "" : (string)dt.Rows[0]["InComeSouce"];
bG_IncomeCPay.InComeMon = dt.Rows[0]["InComeMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["InComeMon"];
bG_IncomeCPay.ICPTime = dt.Rows[0]["ICPTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["ICPTime"];
return(bG_IncomeCPay);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_MonPayPlan GetBG_MonPayPlanByCPID(int cPID)
{
string sql = "SELECT * FROM BG_MonPayPlan WHERE CPID = @CPID";
try
{
SqlParameter para = new SqlParameter("@CPID", cPID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_MonPayPlan bG_MonPayPlan = new BG_MonPayPlan();
bG_MonPayPlan.CPID = dt.Rows[0]["CPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CPID"];
bG_MonPayPlan.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
bG_MonPayPlan.MPFunding = dt.Rows[0]["MPFunding"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MPFunding"];
bG_MonPayPlan.DeptID = dt.Rows[0]["DeptID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DeptID"];
bG_MonPayPlan.MPTime = dt.Rows[0]["MPTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["MPTime"];
bG_MonPayPlan.MPRemark = dt.Rows[0]["MPRemark"] == DBNull.Value ? "" : (string)dt.Rows[0]["MPRemark"];
bG_MonPayPlan.MPFundingAdd = dt.Rows[0]["MPFundingAdd"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MPFundingAdd"];
bG_MonPayPlan.MPFundingAddTimes = dt.Rows[0]["MPFundingAddTimes"] == DBNull.Value ? 0 : (int)dt.Rows[0]["MPFundingAddTimes"];
return(bG_MonPayPlan);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_Policy GetBG_PolicyByPLID(int pLID)
{
string sql = "SELECT * FROM BG_Policy WHERE PLID = @PLID";
try
{
SqlParameter para = new SqlParameter("@PLID", pLID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_Policy bG_Policy = new BG_Policy();
bG_Policy.PLID = dt.Rows[0]["PLID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PLID"];
bG_Policy.PTitle = dt.Rows[0]["PTitle"] == DBNull.Value ? "" : (string)dt.Rows[0]["PTitle"];
bG_Policy.PContent = dt.Rows[0]["PContent"] == DBNull.Value ? "" : (string)dt.Rows[0]["PContent"];
bG_Policy.PTime = dt.Rows[0]["PTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["PTime"];
bG_Policy.PFrom = dt.Rows[0]["PFrom"] == DBNull.Value ? "" : (string)dt.Rows[0]["PFrom"];
bG_Policy.POrder = dt.Rows[0]["POrder"] == DBNull.Value ? 0 : (int)dt.Rows[0]["POrder"];
bG_Policy.PType = dt.Rows[0]["PType"] == DBNull.Value ? "" : (string)dt.Rows[0]["PType"];
bG_Policy.PStatus = dt.Rows[0]["PStatus"] == DBNull.Value ? "" : (string)dt.Rows[0]["PStatus"];
return(bG_Policy);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_IncomeGather GetBG_IncomeGatherByIGID(int iGID)
{
string sql = "SELECT * FROM BG_IncomeGather WHERE IGID = @IGID";
try
{
SqlParameter para = new SqlParameter("@IGID", iGID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_IncomeGather bG_IncomeGather = new BG_IncomeGather();
bG_IncomeGather.IGID = dt.Rows[0]["IGID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["IGID"];
bG_IncomeGather.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"];
bG_IncomeGather.IcoMon = dt.Rows[0]["IcoMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["IcoMon"];
bG_IncomeGather.IcoType = dt.Rows[0]["IcoType"] == DBNull.Value ? "" : (string)dt.Rows[0]["IcoType"];
bG_IncomeGather.IcoYear = dt.Rows[0]["IcoYear"] == DBNull.Value ? 0 : (int)dt.Rows[0]["IcoYear"];
return(bG_IncomeGather);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_EcoIncome GetBG_EcoIncomeByEIID(int eIID)
{
string sql = "SELECT * FROM BG_EcoIncome WHERE EIID = @EIID";
try
{
SqlParameter para = new SqlParameter("@EIID", eIID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_EcoIncome bG_EcoIncome = new BG_EcoIncome();
bG_EcoIncome.EIID = dt.Rows[0]["EIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["EIID"];
bG_EcoIncome.EICoding = dt.Rows[0]["EICoding"] == DBNull.Value ? "" : (string)dt.Rows[0]["EICoding"];
bG_EcoIncome.EILev = dt.Rows[0]["EILev"] == DBNull.Value ? "" : (string)dt.Rows[0]["EILev"];
bG_EcoIncome.EIParID = dt.Rows[0]["EIParID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["EIParID"];
bG_EcoIncome.EIName = dt.Rows[0]["EIName"] == DBNull.Value ? "" : (string)dt.Rows[0]["EIName"];
return(bG_EcoIncome);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_Amount GetBG_AmountByBGAMID(int bGAMID)
{
string sql = "SELECT * FROM BG_Amount WHERE BGAMID = @BGAMID";
try
{
SqlParameter para = new SqlParameter("@BGAMID", bGAMID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_Amount bG_Amount = new BG_Amount();
bG_Amount.BGAMID = dt.Rows[0]["BGAMID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["BGAMID"];
bG_Amount.BGAMMon = dt.Rows[0]["BGAMMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BGAMMon"];
bG_Amount.BGAMIncome = dt.Rows[0]["BGAMIncome"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BGAMIncome"];
bG_Amount.BGAMYear = dt.Rows[0]["BGAMYear"] == DBNull.Value ? 0 : (int)dt.Rows[0]["BGAMYear"];
bG_Amount.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"];
bG_Amount.CBID = dt.Rows[0]["CBID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CBID"];
return(bG_Amount);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_UserPurview GetBG_UserPurviewByUPID(int uPID)
{
string sql = "SELECT * FROM BG_UserPurview WHERE UPID = @UPID";
try
{
SqlParameter para = new SqlParameter("@UPID", uPID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_UserPurview bG_UserPurview = new BG_UserPurview();
bG_UserPurview.UPID = dt.Rows[0]["UPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["UPID"];
bG_UserPurview.UPName = dt.Rows[0]["UPName"] == DBNull.Value ? "" : (string)dt.Rows[0]["UPName"];
bG_UserPurview.Remark = dt.Rows[0]["Remark"] == DBNull.Value ? "" : (string)dt.Rows[0]["Remark"];
return(bG_UserPurview);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_BudAppendix GetBG_BudAppendixByAPID(int aPID)
{
string sql = "SELECT * FROM BG_BudAppendix WHERE APID = @APID";
try
{
SqlParameter para = new SqlParameter("@APID", aPID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_BudAppendix bG_BudAppendix = new BG_BudAppendix();
bG_BudAppendix.APID = dt.Rows[0]["APID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["APID"];
bG_BudAppendix.BudID = dt.Rows[0]["BudID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["BudID"];
bG_BudAppendix.APPath = dt.Rows[0]["APPath"] == DBNull.Value ? "" : (string)dt.Rows[0]["APPath"];
bG_BudAppendix.ApName = dt.Rows[0]["ApName"] == DBNull.Value ? "" : (string)dt.Rows[0]["ApName"];
bG_BudAppendix.ApTime = dt.Rows[0]["ApTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["ApTime"];
return(bG_BudAppendix);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_ChangePwd GetBG_ChangePwdByPwdID(int pwdID)
{
string sql = "SELECT * FROM BG_ChangePwd WHERE PwdID = @PwdID";
try
{
SqlParameter para = new SqlParameter("@PwdID", pwdID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_ChangePwd bG_ChangePwd = new BG_ChangePwd();
bG_ChangePwd.PwdID = dt.Rows[0]["PwdID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PwdID"];
bG_ChangePwd.UserID = dt.Rows[0]["UserID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["UserID"];
bG_ChangePwd.OldPwd = dt.Rows[0]["OldPwd"] == DBNull.Value ? "" : (string)dt.Rows[0]["OldPwd"];
bG_ChangePwd.NewPwd = dt.Rows[0]["NewPwd"] == DBNull.Value ? "" : (string)dt.Rows[0]["NewPwd"];
bG_ChangePwd.CrTime = dt.Rows[0]["CrTime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["CrTime"];
bG_ChangePwd.UserName = dt.Rows[0]["UserName"] == DBNull.Value ? "" : (string)dt.Rows[0]["UserName"];
bG_ChangePwd.DepName = dt.Rows[0]["DepName"] == DBNull.Value ? "" : (string)dt.Rows[0]["DepName"];
return(bG_ChangePwd);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_MonPayPlanA GetBG_MonPayPlanAByCAID(int cAID)
{
string sql = "SELECT * FROM BG_MonPayPlanA WHERE CAID = @CAID";
try
{
SqlParameter para = new SqlParameter("@CAID", cAID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_MonPayPlanA bG_MonPayPlanA = new BG_MonPayPlanA();
bG_MonPayPlanA.CAID = dt.Rows[0]["CAID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CAID"];
bG_MonPayPlanA.CPID = dt.Rows[0]["CPID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CPID"];
bG_MonPayPlanA.MABasicExp = dt.Rows[0]["MABasicExp"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MABasicExp"];
bG_MonPayPlanA.MAProExp = dt.Rows[0]["MAProExp"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MAProExp"];
bG_MonPayPlanA.MATotal = dt.Rows[0]["MATotal"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MATotal"];
bG_MonPayPlanA.MATime = dt.Rows[0]["MATime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["MATime"];
bG_MonPayPlanA.MAFunding = dt.Rows[0]["MAFunding"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["MAFunding"];
return(bG_MonPayPlanA);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_IncomeCK GetBG_IncomeCKByIKID(int iKID)
{
string sql = "SELECT * FROM BG_IncomeCK WHERE IKID = @IKID";
try
{
SqlParameter para = new SqlParameter("@IKID", iKID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_IncomeCK bG_IncomeCK = new BG_IncomeCK();
bG_IncomeCK.IKID = dt.Rows[0]["IKID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["IKID"];
bG_IncomeCK.EIID = dt.Rows[0]["EIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["EIID"];
bG_IncomeCK.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"];
bG_IncomeCK.IACkMon = dt.Rows[0]["IACkMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["IACkMon"];
bG_IncomeCK.IATime = dt.Rows[0]["IATime"] == DBNull.Value ? DateTime.MinValue : (DateTime)dt.Rows[0]["IATime"];
return(bG_IncomeCK);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_PreviewDevide GetBG_PreviewDevideByPDID(int pDID)
{
string sql = "SELECT * FROM BG_PreviewDevide WHERE PDID = @PDID";
try
{
SqlParameter para = new SqlParameter("@PDID", pDID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_PreviewDevide bG_PreviewDevide = new BG_PreviewDevide();
bG_PreviewDevide.PDID = dt.Rows[0]["PDID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PDID"];
bG_PreviewDevide.DepID = dt.Rows[0]["DepID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["DepID"];
bG_PreviewDevide.PSID = dt.Rows[0]["PSID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PSID"];
bG_PreviewDevide.DevMon = dt.Rows[0]["DevMon"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["DevMon"];
return(bG_PreviewDevide);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_Caliber GetBG_CaliberByCaliberID(int caliberID)
{
string sql = "SELECT * FROM BG_Caliber WHERE CaliberID = @CaliberID";
try
{
SqlParameter para = new SqlParameter("@CaliberID", caliberID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_Caliber bG_Caliber = new BG_Caliber();
bG_Caliber.CaliberID = dt.Rows[0]["CaliberID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CaliberID"];
bG_Caliber.CaliberName = dt.Rows[0]["CaliberName"] == DBNull.Value ? "" : (string)dt.Rows[0]["CaliberName"];
bG_Caliber.ParentID = dt.Rows[0]["ParentID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["ParentID"];
bG_Caliber.CbLever = dt.Rows[0]["CbLever"] == DBNull.Value ? 0 : (int)dt.Rows[0]["CbLever"];
return(bG_Caliber);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
public static BG_BudgetConCell GetBG_BudgetConCellByBCCID(int bCCID)
{
string sql = "SELECT * FROM BG_BudgetConCell WHERE BCCID = @BCCID";
try
{
SqlParameter para = new SqlParameter("@BCCID", bCCID);
DataTable dt = DBUnity.AdapterToTab(sql, para);
if (dt.Rows.Count > 0)
{
BG_BudgetConCell bG_BudgetConCell = new BG_BudgetConCell();
bG_BudgetConCell.BCCID = dt.Rows[0]["BCCID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["BCCID"];
bG_BudgetConCell.PIID = dt.Rows[0]["PIID"] == DBNull.Value ? 0 : (int)dt.Rows[0]["PIID"];
bG_BudgetConCell.BCCName = dt.Rows[0]["BCCName"] == DBNull.Value ? "" : (string)dt.Rows[0]["BCCName"];
bG_BudgetConCell.BCCStan = dt.Rows[0]["BCCStan"] == DBNull.Value ? 0 : (decimal)dt.Rows[0]["BCCStan"];
bG_BudgetConCell.BCCUseSta = dt.Rows[0]["BCCUseSta"] == DBNull.Value ? "" : (string)dt.Rows[0]["BCCUseSta"];
return(bG_BudgetConCell);
}
else
{
return(null);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
}
