protected void Page_Load(object sender, EventArgs e) { string action = Request["action"]; string projectid = Request["ProjectId"]; string sql = ""; IList <ShenChaReport_KanCha> scrkEnts = null; ShenChaReport_KanCha scrkEnt = null; switch (action) { case "loadform": sql = "select a.*,b.ProjectName from NCRL_SP..ShenChaReport_KanCha a left join NCRL_SP..Project b on a.ProjectId=b.Id where a.ProjectId='" + projectid + "'"; IList <EasyDictionary> dics = DataHelper.QueryDictList(sql); if (dics.Count > 0) { Response.Write("{success:true,data:" + JsonHelper.GetJsonString(dics[0]) + "}"); } else { Project pEnt = Project.Find(projectid); string opinion1 = "1、勘察报告提供的数据真实可靠;2、报建手续齐全;3、按规定盖有出图章和签署;4、工程基础含软基处理安全、可靠;5、见证材料符合《关于加强全省建设工程勘察外业工作的意见》(赣建字2013-2)要求。"; string opinion2 = "符合有关工程强制性标准规范"; string opinion3 = "符合要求"; string opinion4 = "该岩土工程勘察报告按照审查意见经回复整改后符合国家有关《工程建设标准强制性条文》及国家和本省的各种建设工程设计规范、标准要求。"; Response.Write("{success:true,data:{ProjectName:'" + pEnt.ProjectName + "',Opinion1:'" + opinion1 + "',Opinion2:'" + opinion2 + "',Opinion3:'" + opinion3 + "',Opinion4:'" + opinion4 + "'}}"); } Response.End(); break; case "update": try { scrkEnts = ShenChaReport_KanCha.FindAllByProperty(ShenChaReport_KanCha.Prop_ProjectId, projectid); string json = Request["json"]; ShenChaReport_KanCha ent_new = JsonHelper.GetObject <ShenChaReport_KanCha>(json); if (scrkEnts.Count > 0) { scrkEnt = scrkEnts[0]; EasyDictionary dic = JsonHelper.GetObject <EasyDictionary>(json); scrkEnt = DataHelper.MergeData <ShenChaReport_KanCha>(scrkEnt, ent_new, dic.Keys); scrkEnt.DoUpdate(); } else { ent_new.ProjectId = projectid; ent_new.CreateId = Aim.Portal.Web.WebPortalService.CurrentUserInfo.UserID; ent_new.CreateName = Aim.Portal.Web.WebPortalService.CurrentUserInfo.Name; ent_new.CreateTime = DateTime.Now; ent_new.DoCreate(); } Response.Write("{success:true}"); } catch { Response.Write("{success:false}"); } Response.End(); break; } }
protected void Page_Load(object sender, EventArgs e) { try { Aim.Portal.Web.WebPortalService.CheckLogon(); } catch { Response.Write("<script> window.parent.location.href = '/Login.aspx';</script>"); Response.End(); } string templatepath = ConfigurationManager.AppSettings["TemplatePath"].ToString(); string action = Request["action"]; string id = Request["id"]; Document srcDoc = null; BookmarkCollection marks = null; IList <EasyDictionary> dics = null; string filename = ""; if (!string.IsNullOrEmpty(id)) { pEnt = Project.Find(id); } switch (action) { case "loadproject": string ProjectName = Request["ProjectName"]; if (!string.IsNullOrEmpty(ProjectName)) { where = "and ProjectName like '%" + ProjectName + "%' "; } sql = @"select * from NCRL_SP..Project where BelongCmp = 'ZX' " + where; dt = DataHelper.QueryDataTable(GetPageSql(sql)); Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + ",total:" + totalProperty + "}"); Response.End(); break; case "delete": Delete(); break; case "Recycle": Recycle(); break; case "loadexportfile": sql = "select Id,Name,CreateTime from FileItem where ProjectId='" + id + "' and Path='导出' order by CreateTime asc"; dt = DataHelper.QueryDataTable(sql); Response.Write("{innerrows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}"); Response.End(); break; case "export_opinioncover": //意见封面 try { srcDoc = new Document(templatepath + "审查意见封面.doc"); marks = srcDoc.Range.Bookmarks; for (int j = 0; j < marks.Count; j++) { Bookmark mark = marks[j]; if (ContainProperty(pEnt, mark.Name)) { mark.Text = pEnt.GetValue(mark.Name) + ""; } } filename = pEnt.ProjectName.Replace("#", "") + "_审查意见封面.doc"; srcDoc.Save(@"D:\RW\Files\AppFiles\Portal\Default\" + filename); UpdateFileItem(filename); Response.Write("{success:true}"); } catch { Response.Write("{success:false}"); } Response.End(); break; case "exporthegeshu": srcDoc = new Document(templatepath + "审查合格书_市政工程_房屋建筑.doc"); marks = srcDoc.Range.Bookmarks; for (int j = 0; j < marks.Count; j++) { Bookmark mark = marks[j]; if (ContainProperty(pEnt, mark.Name)) { mark.Text = pEnt.GetValue(mark.Name) + ""; } } sql = @"select a.MajorName,(select top 1 SortIndex from SysEnumeration where ParentId='b640c40c-e2a9-41a8-bd28-d8ff9d71ff94' and Name=a.MajorName) as SortIndex from NCRL_SP..ProjectUser a where a.ProjectId='" + pEnt.Id + "' order by SortIndex asc"; dics = DataHelper.QueryDictList(sql); int i = 1; foreach (EasyDictionary dic in dics) { if (dic.Get <string>("MajorName") != "勘察") { if (marks["Major" + i] != null) { marks["Major" + i].Text = dic.Get <string>("MajorName"); } i++; } } filename = pEnt.ProjectName.Replace("#", "") + "_审查合格书.doc"; srcDoc.Save(@"D:\RW\Files\AppFiles\Portal\Default\" + filename); UpdateFileItem(filename); break; case "export_beiandengjibiao": try { srcDoc = new Document(templatepath + "附件10施工图设计文件审查备案登记表.doc"); marks = srcDoc.Range.Bookmarks; for (int j = 0; j < marks.Count; j++) { Bookmark mark = marks[j]; if (ContainProperty(pEnt, mark.Name)) { mark.Text = pEnt.GetValue(mark.Name) + ""; } } if (marks["Layer"] != null) { marks["Layer"].Text = "地上层数:" + pEnt.UpperLayers + (string.IsNullOrEmpty(pEnt.DownLayers) ? "" : "地下层数:" + pEnt.DownLayers); } if (marks["KanChaIfBeiAn"] != null) { marks["KanChaIfBeiAn"].Text = string.IsNullOrEmpty(pEnt.KanChaUnitBeiAnNo) ? "否" : "是"; } if (marks["SheJiIfBeiAn"] != null) { marks["SheJiIfBeiAn"].Text = string.IsNullOrEmpty(pEnt.SheJiUnitBeiAnNo) ? "否" : "是"; } sql = @"select a.*,(select top 1 SortIndex from NCRL_Portal..SysEnumeration where Name=a.MajorName and ParentId='b640c40c-e2a9-41a8-bd28-d8ff9d71ff94') as SortIndex from NCRL_SP..KanChaSheJi a where a.ProjectId='" + pEnt.Id + "' order by SortIndex asc"; dics = DataHelper.QueryDictList(sql); //勘察设计人员 int index = 1; foreach (EasyDictionary dic in dics) { if (dic.Get <string>("Position") == "注册土木工程师(岩土)") { if (marks["ZhuCeYanTuName"] != null) { marks["ZhuCeYanTuName"].Text = dic.Get <string>("UserName"); } if (marks["ZhuCeYanTuSealNo"] != null) { marks["ZhuCeYanTuSealNo"].Text = dic.Get <string>("SealNo"); } if (marks["ZhuCeYanTuShenFenZheng"] != null) { marks["ZhuCeYanTuShenFenZheng"].Text = dic.Get <string>("ShenFenZhengNo"); } } else if (dic.Get <string>("Position") == "一级注册建筑师") { if (marks["ZhuCeJianZaoShiName"] != null) { marks["ZhuCeJianZaoShiName"].Text = dic.Get <string>("UserName"); } if (marks["ZhuCeJianZaoShiSealNo"] != null) { marks["ZhuCeJianZaoShiSealNo"].Text = dic.Get <string>("SealNo"); } if (marks["ZhuCeJianZaoShiShenFenZheng"] != null) { marks["ZhuCeJianZaoShiShenFenZheng"].Text = dic.Get <string>("ShenFenZhengNo"); } } else if (dic.Get <string>("Position") == "一级注册结构师") { if (marks["ZhuCeJieGouShiName"] != null) { marks["ZhuCeJieGouShiName"].Text = dic.Get <string>("UserName"); } if (marks["ZhuCeJieGouShiSealNo"] != null) { marks["ZhuCeJieGouShiSealNo"].Text = dic.Get <string>("SealNo"); } if (marks["ZhuCeJieGouShiShenFenZheng"] != null) { marks["ZhuCeJieGouShiShenFenZheng"].Text = dic.Get <string>("ShenFenZhengNo"); } } else { if (marks["SheJi_MajorName" + index] != null) { marks["SheJi_MajorName" + index].Text = dic.Get <string>("MajorName"); } if (marks["SheJi_UserName" + index] != null) { marks["SheJi_UserName" + index].Text = dic.Get <string>("UserName"); } index++; } } sql = @"select a.*,(select top 1 SortIndex from NCRL_Portal..SysEnumeration where Name=a.MajorName and ParentId='b640c40c-e2a9-41a8-bd28-d8ff9d71ff94') as SortIndex ,b.StampNo as QianZhangStampNo,c.StampNo as ShenHeStampNo from NCRL_SP..ProjectUser a left join NCRL_SP..Expert b on b.Id=a.QianZhangId left join NCRL_SP..Expert c on c.Id=a.ShenHeId where a.ProjectId='" + pEnt.Id + "' order by SortIndex asc"; dics = DataHelper.QueryDictList(sql); index = 1; foreach (EasyDictionary dic in dics) { if (marks["ShenTu_MajorName" + index] != null) { marks["ShenTu_MajorName" + index].Text = dic.Get <string>("MajorName"); } if (marks["ShenTu_UserName" + index] != null) { marks["ShenTu_UserName" + index].Text = dic.Get <string>("QianZhangName"); } if (marks["ShenTu_SealNo" + index] != null) { marks["ShenTu_SealNo" + index].Text = dic.Get <string>("QianZhangStampNo"); } if (marks["FuHe_UserName" + index] != null) { marks["FuHe_UserName" + index].Text = dic.Get <string>("ShenHeName"); } if (marks["FuHe_SealNo" + index] != null) { marks["FuHe_SealNo" + index].Text = dic.Get <string>("ShenHeStampNo"); } index++; } //写入备案登记表信息 IList <BeiAn_Project> bapEnts = BeiAn_Project.FindAllByProperty(BeiAn_Project.Prop_ProjectId, pEnt.Id); if (bapEnts.Count > 0) { for (int j = 0; j < marks.Count; j++) { Bookmark mark = marks[j]; if (ContainProperty_Object(bapEnts[0], mark.Name)) { mark.Text = bapEnts[0].GetValue(mark.Name) + ""; } } } filename = pEnt.ProjectName.Replace("#", "") + "_审查备案登记表.doc"; srcDoc.Save(@"D:\RW\Files\AppFiles\Portal\Default\" + filename); UpdateFileItem(filename); Response.Write("{success:true}"); } catch { Response.Write("{success:false}"); } Response.End(); break; case "export_shenchabaogao": try { if (pEnt.ProjectType == "房屋建筑") { srcDoc = new Document(templatepath + "房屋建筑_审查报告.doc"); } if (pEnt.ProjectType == "市政工程") { srcDoc = new Document(templatepath + "市政工程_审查报告.doc"); } if (pEnt.ProjectType == "基坑支护") { srcDoc = new Document(templatepath + "基坑支护_审查报告.doc"); } marks = srcDoc.Range.Bookmarks; for (int j = 0; j < marks.Count; j++) { Bookmark mark = marks[j]; if (ContainProperty(pEnt, mark.Name)) { mark.Text = pEnt.GetValue(mark.Name) + ""; } } IList <ShenChaReport> scrEnts = ShenChaReport.FindAllByProperty(ShenChaReport.Prop_ProjectId, pEnt.Id); if (scrEnts.Count > 0) { for (int j = 0; j < marks.Count; j++) { Bookmark mark = marks[j]; if (ContainProperty_Object(scrEnts[0], mark.Name)) { mark.Text = scrEnts[0].GetValue(mark.Name) + ""; } } } if (marks["Layer"] != null) { marks["Layer"].Text = "地上层数:" + pEnt.UpperLayers + (string.IsNullOrEmpty(pEnt.DownLayers) ? "" : "地下层数:" + pEnt.DownLayers); } if (marks["ProjectName1"] != null) { marks["ProjectName1"].Text = pEnt.ProjectName; } if (marks["JianSheUnit1"] != null) { marks["JianSheUnit1"].Text = pEnt.JianSheUnit; } filename = pEnt.ProjectName.Replace("#", "") + "_审查报告.doc"; srcDoc.Save(@"D:\RW\Files\AppFiles\Portal\Default\" + filename); UpdateFileItem(filename); Response.Write("{success:true}"); } catch (Exception ex) { Response.Write("{success:false}"); } Response.End(); break; case "export_kanchashenchabaogao": try { srcDoc = new Document(templatepath + "江西省工程勘察审查报告书.doc"); marks = srcDoc.Range.Bookmarks; for (int j = 0; j < marks.Count; j++) { Bookmark mark = marks[j]; if (ContainProperty(pEnt, mark.Name)) { mark.Text = pEnt.GetValue(mark.Name) + ""; } } IList <ShenChaReport_KanCha> scrkEnts = ShenChaReport_KanCha.FindAllByProperty(ShenChaReport_KanCha.Prop_ProjectId, pEnt.Id); if (scrkEnts.Count > 0) { for (int j = 0; j < marks.Count; j++) { if (ContainProperty_Object(scrkEnts[0], marks[j].Name)) { marks[j].Text = scrkEnts[0].GetValue(marks[j].Name) + ""; } } } if (marks["ProjectName2"] != null) { marks["ProjectName2"].Text = pEnt.ProjectName; } if (marks["JianSheUnit2"] != null) { marks["JianSheUnit2"].Text = pEnt.JianSheUnit; } filename = pEnt.ProjectName.Replace("#", "") + "_工程勘察审查报告.doc"; srcDoc.Save(@"D:\RW\Files\AppFiles\Portal\Default\" + filename); UpdateFileItem(filename); Response.Write("{success:true}"); } catch (Exception ex) { Response.Write("{success:false}"); } Response.End(); break; case "exportqingkuangjilu": try { srcDoc = new Document(templatepath + "附件6房屋建筑和市政基础设施工程施工图设计文件审查情况记录.doc"); marks = srcDoc.Range.Bookmarks; for (int j = 0; j < marks.Count; j++) { Bookmark mark = marks[j]; if (ContainProperty(pEnt, mark.Name)) { mark.Text = pEnt.GetValue(mark.Name) + ""; } } filename = pEnt.ProjectName.Replace("#", "") + "_审查情况记录.doc"; srcDoc.Save(@"D:\RW\Files\AppFiles\Portal\Default\" + filename); UpdateFileItem(filename); Response.Write("{success:true}"); } catch (Exception ex) { Response.Write("{success:false}"); } Response.End(); break; case "export_shenchahuizong": try { srcDoc = new Document(templatepath + "审查情况汇总.doc"); marks = srcDoc.Range.Bookmarks; for (int j = 0; j < marks.Count; j++) { Bookmark mark = marks[j]; if (ContainProperty(pEnt, mark.Name)) { mark.Text = pEnt.GetValue(mark.Name) + ""; } } if (marks["ProjectType2"] != null) { marks["ProjectType2"].Text = pEnt.ProjectType; } if (marks["Layer"] != null) { marks["Layer"].Text = "地上层数:" + pEnt.UpperLayers + (string.IsNullOrEmpty(pEnt.DownLayers) ? "" : "地下层数:" + pEnt.DownLayers); } //找到项目人员 排除勘察专业的 sql = @"select a.*,(select top 1 SortIndex from NCRL_Portal..SysEnumeration where Name=a.MajorName and ParentId='b640c40c-e2a9-41a8-bd28-d8ff9d71ff94') as SortIndex from NCRL_SP..ProjectUser a where a.ProjectId='" + pEnt.Id + "' order by SortIndex asc"; dics = DataHelper.QueryDictList(sql); int index = 1; foreach (EasyDictionary dic in dics) { if (dic.Get <string>("MajorName") != "勘察") { if (marks["MajorName" + index] != null) { marks["MajorName" + index].Text = dic.Get <string>("MajorName"); } if (marks["QianZhangName" + index] != null) { marks["QianZhangName" + index].Text = dic.Get <string>("QianZhangName"); } index++; } } sql = @"select isnull(sum(QiangTiao),0) from NCRL_SP..ExamineOpinion where ExamineTaskId in ( select Id from NCRL_SP..ExamineTask where ProjectId='" + pEnt.Id + "')"; if (marks["QiangTiao"] != null) { marks["QiangTiao"].Text = DataHelper.QueryValue(sql) + ""; } filename = pEnt.ProjectName.Replace("#", "") + "_审查情况汇总.doc"; srcDoc.Save(@"D:\RW\Files\AppFiles\Portal\Default\" + filename); UpdateFileItem(filename); Response.Write("{success:true}"); } catch (Exception ex) { Response.Write("{success:false}"); } Response.End(); break; case "export_shenchahuizong_kancha": //审查情况汇总表_工程勘察 try { srcDoc = new Document(templatepath + "审查情况汇总表_工程勘察.doc"); marks = srcDoc.Range.Bookmarks; for (int j = 0; j < marks.Count; j++) { if (ContainProperty(pEnt, marks[j].Name)) { marks[j].Text = pEnt.GetValue(marks[j].Name) + ""; } } if (marks["QianZhangName"] != null) //找到勘察专业的签章专家 { IList <ProjectUser> puEnts = ProjectUser.FindAllByProperties(ProjectUser.Prop_ProjectId, pEnt.Id, ProjectUser.Prop_MajorName, "勘察"); if (puEnts.Count > 0) { marks["QianZhangName"].Text = puEnts[0].QianZhangName; } } if (marks["QiangTiao"] != null) //找到勘察专业的强条 { IList <ExamineTask> etEnts = ExamineTask.FindAllByProperties(ExamineTask.Prop_MajorName, "勘察", ExamineTask.Prop_ProjectId, pEnt.Id); if (etEnts.Count > 0) { sql = "select isnull(sum(QiangTiao),0) from NCRL_SP..ExamineOpinion where ExamineTaskId='" + etEnts[0].Id + "'"; marks["QiangTiao"].Text = DataHelper.QueryValue <Int32>(sql) + ""; } } filename = pEnt.ProjectName.Replace("#", "") + "_工程勘察审查情况汇总表.doc"; srcDoc.Save(@"D:\RW\Files\AppFiles\Portal\Default\" + filename); UpdateFileItem(filename); Response.Write("{success:true}"); } catch (Exception ex) { Response.Write("{success:false}"); } Response.End(); break; case "export_kangzhen": try { srcDoc = new Document(templatepath + "抗震设防监管表.doc"); marks = srcDoc.Range.Bookmarks; for (int j = 0; j < marks.Count; j++) { if (ContainProperty(pEnt, marks[j].Name)) { marks[j].Text = pEnt.GetValue(marks[j].Name) + ""; } } IList <KangZhen_Project> kzpEnts = KangZhen_Project.FindAllByProperty(KangZhen_Project.Prop_ProjectId, pEnt.Id); if (kzpEnts.Count > 0) { for (int j = 0; j < marks.Count; j++) { if (ContainProperty_Object(kzpEnts[0], marks[j].Name)) { marks[j].Text = kzpEnts[0].GetValue <string>(marks[j].Name); } } } if (pEnt.Property == "新建" && marks["XinJian"] != null) { marks["XinJian"].Text = "√"; } if (pEnt.Property == "改建" && marks["GaiJian"] != null) { marks["GaiJian"].Text = "√"; } if (pEnt.Property == "扩建" && marks["KuoJian"] != null) { marks["KuoJian"].Text = "√"; } filename = pEnt.ProjectName.Replace("#", "") + "_抗震设防专项审查监管表.doc"; srcDoc.Save(@"D:\RW\Files\AppFiles\Portal\Default\" + filename); UpdateFileItem(filename); Response.Write("{success:true}"); } catch (Exception ex) { Response.Write("{success:false}"); } Response.End(); break; case "export_zhongshenyijianbiao": try { srcDoc = new Document(templatepath + "附件5_终审意见表.doc"); marks = srcDoc.Range.Bookmarks; for (int j = 0; j < marks.Count; j++) { if (ContainProperty(pEnt, marks[j].Name)) { marks[j].Text = pEnt.GetValue(marks[j].Name) + ""; } } IList <ZhongShenOpinion_Project> zsopEnts = ZhongShenOpinion_Project.FindAllByProperty(ZhongShenOpinion_Project.Prop_ProjectId, pEnt.Id); if (zsopEnts.Count > 0) { for (int j = 0; j < marks.Count; j++) { if (ContainProperty_Object(zsopEnts[0], marks[j].Name)) { marks[j].Text = zsopEnts[0].GetValue(marks[j].Name) + ""; } } } filename = pEnt.ProjectName.Replace("#", "") + "_终审意见表.doc"; srcDoc.Save(@"D:\RW\Files\AppFiles\Portal\Default\" + filename); UpdateFileItem(filename); Response.Write("{success:true}"); } catch (Exception ex) { Response.Write("{success:false}"); } Response.End(); break; case "export_subproject": //导出子项 try { srcDoc = new Document(templatepath + "子项目明细表.doc"); marks = srcDoc.Range.Bookmarks; IList <SubProject> suEnts = SubProject.FindAllByProperty(SubProject.Prop_ProjectId, pEnt.Id); for (int j = 0; j < suEnts.Count; j++) { foreach (PropertyInfo pi in SubProject.AllProperties) { if (marks[pi.Name + (j + 1)] != null) { marks[pi.Name + (j + 1)].Text = suEnts[j].GetValue(pi.Name) + ""; } } } if (marks["ProjectName"] != null) { marks["ProjectName"].Text = pEnt.ProjectName; } filename = pEnt.ProjectName.Replace("#", "") + "_子项目明细表.doc"; srcDoc.Save(@"D:\RW\Files\AppFiles\Portal\Default\" + filename); UpdateFileItem(filename); Response.Write("{success:true}"); } catch (Exception ex) { Response.Write("{success:false}"); } Response.End(); break; } }