/// <summary>
/// 获取列表
/// </summary>
/// <param name="whereQuery"></param>
/// <returns></returns>
public List <ProjectInfo> GetList(string glBidRootNo)
{
string sql = @"WITH BidTree AS --递归查询所有广联标段树下面的项目
(
SELECT *
from ERP_Project.dbo.dtl_gl_projectorg b
where BidNo = @GlBidRootNo
UNION ALL
SELECT ERP_Project.dbo.dtl_gl_projectorg.*
from BidTree
JOIN ERP_Project.dbo.dtl_gl_projectorg on BidTree.BidNo = ERP_Project.dbo.dtl_gl_projectorg.ParentNo
)
SELECT P.*,B.BidName,B.Category,B.BidCode
FROM [ERP_Project].[Project].[Project] P
LEFT OUTER JOIN ERP_Project.dbo.dtl_gl_projectorg B ON P.ProjectNo = B.ProjectNo
WHERE P.ProjectNo IN(SELECT DISTINCT ProjectNo FROM BidTree WHERE ISNULL(ProjectNo, '') <> '')
ORDER BY B.BidCode";
List <CmdParameter> cmds = new List <CmdParameter>();
cmds.Add(new CmdParameter("@GlBidRootNo", glBidRootNo));
return(hdDbCmdManager.QueryForList <ProjectInfo>(sql, System.Data.CommandType.Text, cmds.ToArray()));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="whereQuery"></param>
/// <returns></returns>
public List <Contract> GetList(string whereQuery)
{
return(hdDbCmdManager.QueryForList <Contract>(@"SELECT * FROM [ERP_Contract].[dbo].[ctrct_contract] " + whereQuery, System.Data.CommandType.Text, null));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="whereQuery"></param>
/// <returns></returns>
public List <XMBProjectInfo> GetList(string whereQuery)
{
return(hdDbCmdManager.QueryForList <XMBProjectInfo>(@"SELECT * FROM [ERP_Project].[Project].[Project] " + whereQuery, System.Data.CommandType.Text, null));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="whereQuery"></param>
/// <returns></returns>
public List <Manager> GetList(string whereQuery)
{
return(hdDbCmdManager.QueryForList <Manager>(@"SELECT *
FROM ERP_Subpay.dbo.v_cmn_manager " + whereQuery, System.Data.CommandType.Text, null));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="whereQuery"></param>
/// <returns></returns>
public List <CtrctAgreement> GetList(string whereQuery)
{
return(hdDbCmdManager.QueryForList <CtrctAgreement>(@"SELECT * FROM [ERP_SalesMarketing].[dbo].[ctrct_prjagreement] " + whereQuery, System.Data.CommandType.Text, null));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="whereQuery"></param>
/// <returns></returns>
public List <XMBContractInfo> GetList(string whereQuery)
{
return(hdDbCmdManager.QueryForList <XMBContractInfo>(@"SELECT * FROM [ERP_SalesMarketing].[dbo].[ctrct_prjcontract] " + whereQuery, System.Data.CommandType.Text, null));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="whereQuery"></param>
/// <returns></returns>
public List <PrjAmountRpt> GetList(string whereQuery)
{
return(hdDbCmdManager.QueryForList <PrjAmountRpt>(@"SELECT * FROM [ERP_Subpay].[dbo].[v_rpt_prjamountrpt] " + whereQuery, System.Data.CommandType.Text, null));
}
/// <summary>
/// 获取列表
/// </summary>
/// <param name="whereQuery"></param>
/// <returns></returns>
public List <ProjectBid> GetList(string whereQuery)
{
return(hdDbCmdManager.QueryForList <ProjectBid>(@"SELECT * FROM [ERP_Project].[dbo].[dtl_gl_projectorg] " + whereQuery, System.Data.CommandType.Text, null));
}
