Exemplo n.º 1
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="ProjGuid">项目主键</param>
        /// <param name="NationType">审批类型</param>
        /// <param name="ProjCategory">项目类型</param>
        /// <param name="CityInvest">省级投资</param>
        /// <param name="CenterInvest">中央投资</param>
        ///<param name="DoneStatus"></param>
        static void ProjCheckRecordMileStone(string ProjGuid, string NationType, string ProjCategory, bool CityInvest, bool CenterInvest, DataSet DoneStatus)
        {
            //核准 A1816C6C-4433-4123-B7A4-EA166D2649A0   备案 F8913E85-1F23-4E9B-BF6E-594B9E070CA5
            string  DirectoryGuid = "";
            DataSet doc           = null;
            string  OthSql        = "";

            if (NationType == "A1816C6C-4433-4123-B7A4-EA166D2649A0")
            {
                OthSql += " and Name not in ('项目备案申请')";
            }
            if (NationType == "F8913E85-1F23-4E9B-BF6E-594B9E070CA5")
            {
                OthSql += " and Name not in ('项目核准申请报告')";
            }

            if (CityInvest && (!CenterInvest))
            {
                OthSql += " and Name not in ('资金申请报告')";
            }
            else if (CenterInvest && (!CityInvest))
            {
                OthSql += " and Name not in ('申请省级资金文件')";
            }
            else if (CenterInvest && CityInvest)
            {
                OthSql += "";
            }
            else
            {
                OthSql += " and Name not in ('资金申请报告','申请省级资金文件')";
            }

            #region  核准备案类非设备采购信息化

            if ((ProjCategory != "190749D5-0526-46FD-96FC-C96281AE926D") && (ProjCategory != "77A6EB3E-D90F-4372-B549-FFD36238B1EA"))
            {
                DirectoryGuid = "C607D211-DFDB-4AAB-8351-16C1FE4BD17C";
            }

            #endregion

            #region  核准备案类设备采购信息化

            if ((ProjCategory == "190749D5-0526-46FD-96FC-C96281AE926D") || (ProjCategory == "77A6EB3E-D90F-4372-B549-FFD36238B1EA"))
            {
                DirectoryGuid = "F5820CBC-8011-4643-A668-F8DF7083BB4F";

                if (ProjCategory == "190749D5-0526-46FD-96FC-C96281AE926D")
                {
                    OthSql += " and Name not in ('软件开发')";
                }

                if (ProjCategory == "77A6EB3E-D90F-4372-B549-FFD36238B1EA")
                {
                    OthSql += " and Name not in ('设备安装')";
                }
            }

            //林业工程(FE0E9C66-62D6-4109-9EB3-5167DB3EDBC6)、城市园林(BD5C451A-025D-45F2-BA9F-CC50DD029301)、水利工程(CDC1A7C3-23BA-4DC3-9B85-D046787441B6)
            if ((ProjCategory == "BD5C451A-025D-45F2-BA9F-CC50DD029301") || (ProjCategory == "CDC1A7C3-23BA-4DC3-9B85-D046787441B6") || (ProjCategory == "FE0E9C66-62D6-4109-9EB3-5167DB3EDBC6"))
            {
                OthSql += " and Name not in ('资金申请报告','基础工程','装修工程','规划验线')";
                //林业工程无设备安装
                if (ProjCategory == "FE0E9C66-62D6-4109-9EB3-5167DB3EDBC6" || ProjCategory == "BD5C451A-025D-45F2-BA9F-CC50DD029301")
                {
                    OthSql += " and Name not in ('设备安装')";
                }
            }
            else if (ProjCategory == "8F8499A3-BAD5-4051-BAB6-290CA5CF9520")
            {
                OthSql += " and Name not in ('基础工程','装修工程','设备安装')";
            }

            doc = IMCBaseInfo.GetMapGuidsByDirectoryGuid(DirectoryGuid, OthSql);

            if (doc != null && doc.Tables[0].Rows.Count > 0)
            {
                for (int i = 0; i < doc.Tables[0].Rows.Count; i++)
                {
                    IMCBaseInfo.InitialProjMileStone(ProjGuid, doc.Tables[0].Rows[i][0].ToString(), doc.Tables[0].Rows[i]["Mark"].ToString());
                }

                //InitMileStoneDoneStatus(ProjGuid, DoneStatus);
            }

            #endregion
        }
Exemplo n.º 2
0
        /// <summary>
        /// 只审批初步设计类型初始化里程碑信息
        /// </summary>
        /// <param name="ProjGuid">项目主键</param>
        /// <param name="TopGuid">项目的TopGuid</param>
        /// <param name="ProjCategory">项目类型</param>
        /// <param name="CityInvest">省级投资</param>
        /// <param name="CenterInvest">中央投资</param>
        ///<param name="DoneStatus"></param>
        static void ProjApproveMileStone1(string ProjGuid, string TopGuid, string ProjCategory, bool CityInvest, bool CenterInvest, DataSet DoneStatus)
        {
            DataSet doc             = null;
            string  DirectoryGuid   = "";
            string  OthSql          = " and Name not in ('项目建议书','可行性研究报告')";
            string  ProjAffiliation = "";//项目主从关系


            if (TopGuid != "")
            {
                ProjAffiliation = GetProjAffiliationByGuid(TopGuid);
                if (ProjAffiliation == "6921FF68-A789-4BDD-9AC1-6B8CA13B49C1")//项目主从关系为集中立项可研,子项目独立批复概算
                {
                    OthSql += " and Name not in ('项目建议书','可行性研究报告')";
                }
                if (ProjAffiliation == "FA173C37-BF98-4AAD-9997-817835165E29")//项目主从关系为集中批复立项可研概算,子项目独立概算
                {
                    OthSql += " and Name not in ('项目建议书','可行性研究报告','初步设计')";
                }
            }

            if (CityInvest && (!CenterInvest))
            {
                OthSql += " and Name not in ('资金申请报告')";
            }
            else if (CenterInvest && (!CityInvest))
            {
                OthSql += " and Name not in ('申请省级资金文件')";
            }
            else if (CenterInvest && CityInvest)
            {
                OthSql += "";
            }
            else
            {
                OthSql += " and Name not in ('资金申请报告','申请省级资金文件')";
            }

            #region  审批类非设备采购信息化

            if ((ProjCategory != "190749D5-0526-46FD-96FC-C96281AE926D") && (ProjCategory != "77A6EB3E-D90F-4372-B549-FFD36238B1EA"))
            {
                DirectoryGuid = "95445784-2D6E-47C0-88DA-63A7254FED4C";
            }

            #endregion

            #region  设备采购信息化

            if ((ProjCategory == "190749D5-0526-46FD-96FC-C96281AE926D") || (ProjCategory == "77A6EB3E-D90F-4372-B549-FFD36238B1EA"))
            {
                DirectoryGuid = "C2D82AC2-DBB6-4C58-BC13-8039A62B6335";
                if (ProjCategory == "190749D5-0526-46FD-96FC-C96281AE926D")
                {
                    OthSql += " and Name not in ('软件开发')";
                }

                if (ProjCategory == "77A6EB3E-D90F-4372-B549-FFD36238B1EA")
                {
                    OthSql += " and Name not in ('设备安装')";
                }
            }

            //林业工程(FE0E9C66-62D6-4109-9EB3-5167DB3EDBC6)、城市园林(BD5C451A-025D-45F2-BA9F-CC50DD029301)、水利工程(CDC1A7C3-23BA-4DC3-9B85-D046787441B6)
            if ((ProjCategory == "BD5C451A-025D-45F2-BA9F-CC50DD029301") || (ProjCategory == "CDC1A7C3-23BA-4DC3-9B85-D046787441B6") || (ProjCategory == "FE0E9C66-62D6-4109-9EB3-5167DB3EDBC6"))
            {
                OthSql += " and Name not in ('资金申请报告','基础工程','装修工程','规划验线')";
                //林业工程无设备安装
                if (ProjCategory == "FE0E9C66-62D6-4109-9EB3-5167DB3EDBC6" || ProjCategory == "BD5C451A-025D-45F2-BA9F-CC50DD029301")
                {
                    OthSql += " and Name not in ('设备安装')";
                }
            }
            else if (ProjCategory == "8F8499A3-BAD5-4051-BAB6-290CA5CF9520")
            {
                OthSql += " and Name not in ('基础工程','装修工程','设备安装')";
            }

            doc = IMCBaseInfo.GetMapGuidsByDirectoryGuid(DirectoryGuid, OthSql);
            if (doc != null && doc.Tables[0].Rows.Count > 0)
            {
                for (int i = 0; i < doc.Tables[0].Rows.Count; i++)
                {
                    IMCBaseInfo.InitialProjMileStone(ProjGuid, doc.Tables[0].Rows[i]["Guid"].ToString(), doc.Tables[0].Rows[i]["Mark"].ToString());
                }

                //InitMileStoneDoneStatus(ProjGuid, DoneStatus);
            }

            #endregion
        }