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