static void InitMileStoneDoneStatus(string ProjGuid, DataSet doc) { 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()); } }
/// <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 }
/// <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 }