/// <summary> /// 2015-11-11 /// 通过项目Guid找到建设程序中证照批复的Guid /// </summary> /// <param name="ProjGuid"></param> /// <param name="fileSign"></param> /// <returns></returns> public string GetRefGuid(string ProjGuid, string fileSign) { string sql = ""; string strAffiliation = BuildProcedureInfo.GetProjAffiliation(ProjGuid); if (strAffiliation == "集中立项可研") { //判断是否是项目建议书、可行性研究报告 if (fileSign == "Busi_ProjProposal" || fileSign == "Busi_ProjFsbtyStudy") { //获取项目的TopGuid主键 string topGuid = "select TopGuid from Busi_ProjRegister where Guid='" + ProjGuid + "' and sysstatus<>-1 "; if (db.ExecuteScalar(topGuid).ToString() == "")//TopGuid为空是主项目 { sql = "SELECT TOP 1 Guid FROM " + fileSign + " WHERE ProjGuid='" + ProjGuid + "' AND SysStatus<>-1 ORDER BY tstamp DESC"; } else//子项目 { sql = "SELECT TOP 1 Guid FROM " + fileSign + " WHERE ProjGuid='" + db.ExecuteScalar(topGuid).ToString() + "' AND SysStatus<>-1 ORDER BY tstamp DESC"; } } else { sql = "SELECT TOP 1 Guid FROM " + fileSign + " WHERE ProjGuid='" + ProjGuid + "' AND SysStatus<>-1 ORDER BY tstamp DESC"; } } else if (strAffiliation == "集中批复立项可研概算") { //获取项目的TopGuid主键 string topGuid = "select TopGuid from Busi_ProjRegister where Guid='" + ProjGuid + "' and sysstatus<>-1 "; if (db.ExecuteScalar(topGuid).ToString() == "")//TopGuid为空是主项目 { sql = "SELECT TOP 1 Guid FROM " + fileSign + " WHERE ProjGuid='" + ProjGuid + "' AND SysStatus<>-1 ORDER BY tstamp DESC"; } else//子项目 { sql = "SELECT TOP 1 Guid FROM " + fileSign + " WHERE ProjGuid='" + db.ExecuteScalar(topGuid).ToString() + "' AND SysStatus<>-1 ORDER BY tstamp DESC"; } } else { sql = "SELECT TOP 1 Guid FROM " + fileSign + " WHERE ProjGuid='" + ProjGuid + "' AND SysStatus<>-1 ORDER BY tstamp DESC"; } string refGuid = ""; if (db.ExecuteScalar(sql) != null) { refGuid = db.ExecuteScalar(sql).ToString(); } return(refGuid); }
/// <summary> /// 根据投资类型和审批类型获取相对应的主要审批手续 /// </summary> /// <param name="ProjGuid">项目主键</param> /// <returns></returns> public static DataSet GetMainByType(string ProjGuid) { string MainSql = ""; //string ProjAffiliationSql = "";//获取该项目的项目主从关系 //DataSet AffiliationDs = new DataSet();//项目主从关系 string ProjAffiliation = BuildProcedureInfo.GetProjAffiliation(ProjGuid); //判断该项目是主项目还是子项目 int count = BuildProcedureInfo.GetProjTop(ProjGuid); //如果是主项目 if (count == 0) { // //判断主从关系是否是集中批复立项可研概算,子项目独立概算 if (ProjAffiliation == "集中批复立项可研概算") { //只显示集中批复立项可研概算 MainSql = "SELECT * FROM Busi_ApprovalConfig WHERE Type='主要审批手续' AND Code IN ('1','2','3','4','5','6','7','10','12') ORDER BY convert(INT, Code)"; } } //如果是子项目 else { // //判断主从关系是否是集中批复立项可研概算,子项目独立概算 if (ProjAffiliation == "集中批复立项可研概算") { //根据投资类型查询出相对应的审批手续 //加入集中批复立项可研概算 MainSql = "SELECT * FROM Busi_ApprovalConfig WHERE Type='主要审批手续' AND Code IN ('11') ORDER BY OrderCode"; } } DataSet MainDs = GetDatabase().ExecuteDataSet(MainSql); return(MainDs); }
/// <summary> /// 获取该项目的项目主从关系 /// </summary> /// <param name="ProjGuid"></param> /// <returns></returns> public static string GetProjAffiliation(string ProjGuid) { return(BuildProcedureInfo.GetProjAffiliation(ProjGuid)); }