protected void Page_Load(object sender, EventArgs e)
{
string projectid = Request["ProjectId"];
Project pEnt = Project.Find(projectid);
lbProjectName.InnerHtml = pEnt.ProjectName;
lbBuildingArea.InnerHtml = pEnt.BuildingArea;
lbDetailLocation.InnerHtml = pEnt.DetailLocation;
lbEngineeringLevel.InnerHtml = pEnt.EngineeringLevel;
lbJianSheUnit.InnerHtml = pEnt.JianSheUnit;
lbJianSheUnitHead.InnerHtml = pEnt.JianSheUnitHead;
lbKanChaUnit.InnerHtml = pEnt.KanChaUnit;
lbKanChaUnitHead.InnerHtml = pEnt.KanChaUnitHead;
lbKanChaZZLevel.InnerHtml = pEnt.KanChaZZLevel;
lbKanChaUnitZSNo.InnerHtml = pEnt.KanChaUnitZSNo;
lbSheJiUnit.InnerHtml = pEnt.SheJiUnit;
lbSheJiUnitHead.InnerHtml = pEnt.SheJiUnitHead;
lbSheJiUnitGrade.InnerHtml = pEnt.SheJiUnitGrade;
lbSheJiUnitZSNo.InnerHtml = pEnt.SheJiUnitZSNo;
IList <KanChaSheJi> kcsjEnts = KanChaSheJi.FindAllByProperty(KanChaSheJi.Prop_ProjectId, projectid);
string zhucejiegoushi = "";
foreach (KanChaSheJi kcsjEnt in kcsjEnts)
{
if (kcsjEnt.MajorName == "注册结构师")
{
zhucejiegoushi = kcsjEnt.UserName;
}
}
lbZhuCeJiGouShi.InnerHtml = zhucejiegoushi;
lbIfChaoGao.InnerHtml = pEnt.IfChaoGao;
lbKangZhenLieDu.InnerHtml = pEnt.KangZhenLieDu;
lbProjectType.InnerHtml = pEnt.ProjectType;
lbLayer.InnerHtml = "地上：" + pEnt.UpperLayers + " 地下：" + pEnt.DownLayers;
lbFoundationType.InnerHtml = pEnt.FoundationType;
string property = pEnt.Property;
if (property == "新建")
{
lbXinJian.InnerHtml = "(√)";
}
if (property == "改建")
{
lbGaiJian.InnerHtml = "(√)";
}
if (property == "扩建")
{
lbKuoJian.InnerHtml = "(√)";
}
lbYear1.InnerHtml = DateTime.Now.Year + "";
lbMonth1.InnerHtml = DateTime.Now.Month + "";
lbDay1.InnerHtml = DateTime.Now.Day + "";
}
private void Delete()
{
string Id = Request["Id"];
if (!string.IsNullOrEmpty(Id))
{
ProjectUser.DeleteAll("ProjectId='" + Id + "'");
SubProject.DeleteAll("ProjectId='" + Id + "'");
KanChaSheJi.DeleteAll("ProjectId='" + Id + "'");
sql = "delete NCRL_SP..Project where Id='" + Id + "'";
DataHelper.ExecSql(sql);
}
}
private void IniPage()
{
JObject jo = new JObject();
string ZhuCeUsers = "";
string SheJiUsers = "";
string ExamineTaskId = Request["ExamineTaskId"];
eEnt = ExamineTask.Find(ExamineTaskId); //审查任务
Project pEnt = Project.Find(eEnt.ProjectId); //项目
ProjectUser puEnt = ProjectUser.Find(eEnt.ProjectUserId); //项目人员
IList <ExamineOpinion> eoEnts = ExamineOpinion.FindAllByProperty(ExamineOpinion.Prop_ExamineTaskId, ExamineTaskId); //看意见有几条
IList <KanChaSheJi> kEnts = KanChaSheJi.FindAllByProperties(KanChaSheJi.Prop_ProjectId, pEnt.Id, KanChaSheJi.Prop_MajorName, eEnt.MajorName); //勘察设计人员
foreach (KanChaSheJi kEnt in kEnts)
{
if (!string.IsNullOrEmpty(kEnt.SealNo))
{
ZhuCeUsers += kEnt.UserName;
}
else
{
SheJiUsers += kEnt.UserName;
}
}
IList <SysEnumeration> seEnts = SysEnumeration.FindAllByProperty("SortIndex", SysEnumeration.Prop_ParentID, "b640c40c-e2a9-41a8-bd28-d8ff9d71ff70");
jo.Add("ExamineTaskId", ExamineTaskId);
jo.Add("ZiXunCode", pEnt.ZiXunCode);
jo.Add("ProjectName", pEnt.ProjectName);
jo.Add("ZhuCeUsers", ZhuCeUsers);
jo.Add("SheJiUsers", SheJiUsers);
jo.Add("Stage", seEnts[eoEnts.Count].Name);
jo.Add("MajorName", eEnt.MajorName);
jo.Add("ShenChaUserId", eEnt.ProjectUserId);
jo.Add("ShenChaUserName", puEnt.UserName);
jo.Add("FuHeUserId", puEnt.ShenHeId);
jo.Add("FuHeUserName", puEnt.ShenHeName);
jo.Add("ShenChaOrganization", "江西瑞林工程咨询有限公司");
if (seEnts[eoEnts.Count].Name == "初审")
{
string StartTime = eEnt.CreateTime.ToString().Replace("}", "").Replace("{", "");
jo.Add("StartTime", StartTime);
}
string str = JsonHelper.GetJsonString(jo);
Response.Write("{success:true,data:" + str + " }");
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
string id = Request["id"];
ExamineOpinion eoEnt = ExamineOpinion.Find(id);
lbStage.InnerHtml = "(" + eoEnt.Stage + ")";
lbStartYear.InnerHtml = eoEnt.StartTime.Value.Year + "";
lbStartMonth.InnerHtml = eoEnt.StartTime.Value.Month + "";
lbStartDay.InnerHtml = eoEnt.StartTime.Value.Day + "";
ExamineTask etEnt = ExamineTask.Find(eoEnt.ExamineTaskId);
Project pEnt = Project.Find(etEnt.ProjectId);
lbZiXunCode.InnerHtml = pEnt.ZiXunCode;
lbMajorName.InnerHtml = etEnt.MajorName;
string ZhuCeUsers = "";
string SheJiUsers = "";
IList <KanChaSheJi> kcsjEnts = KanChaSheJi.FindAllByProperties(KanChaSheJi.Prop_ProjectId, pEnt.Id, KanChaSheJi.Prop_MajorName, etEnt.MajorName);
foreach (KanChaSheJi kcsjEnt in kcsjEnts)
{
if (!string.IsNullOrEmpty(kcsjEnt.SealNo))
{
ZhuCeUsers += (string.IsNullOrEmpty(ZhuCeUsers) ? "" : ",") + kcsjEnt.UserName;
}
else
{
SheJiUsers += (string.IsNullOrEmpty(SheJiUsers) ? "" : ",") + kcsjEnt.UserName;
}
}
lbZhuCeUsers.InnerHtml = ZhuCeUsers;
lbSheJiUsers.InnerHtml = SheJiUsers;
lbProjectName.InnerHtml = pEnt.ProjectName;
lbExamineOpinions.InnerHtml = eoEnt.ExamineOpinions;
lbQiangTiao.InnerHtml = eoEnt.QiangTiao + "";
lbJiangZhuSheJi.InnerHtml = eoEnt.JiangZhuSheJi + "";
lbFangHuo.InnerHtml = eoEnt.FangHuo + "";
lbSheBei.InnerHtml = eoEnt.SheBei + "";
lbJiChu.InnerHtml = eoEnt.JiChu + "";
lbJiGouSheJi.InnerHtml = eoEnt.JiGouSheJi + "";
lbKangZhenSheJi.InnerHtml = eoEnt.KangZhenSheJi + "";
lbJiaGu.InnerHtml = eoEnt.JiaGu + "";
lbShenChaUserName.InnerHtml = eoEnt.ShenChaUserName;
lbFuHeUserName.InnerHtml = eoEnt.FuHeUserName;
lbEndTime.InnerHtml = eoEnt.EndTime.Value.Year + "年" + eoEnt.EndTime.Value.Month + "月" + eoEnt.EndTime.Value.Day + "日";
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Aim.Portal.Web.WebPortalService.CheckLogon();
}
catch
{
Response.Write("<script> window.location.href = '/Login.aspx';</script>");
Response.End();
}
string action = Request["action"];
string sql = "";
DataTable dt = null;
Project pEnt = null;
Project oriEnt = null;
EasyDictionary dic = null;
string id = Request["id"];
if (!string.IsNullOrEmpty(id))
{
pEnt = Project.Find(id);
}
switch (action)
{
case "loadprojecttype":
sql = "select name from SysEnumeration where ParentId='f6845db5-6277-43b7-885d-031754bd51b0' order by SortIndex asc";
dt = DataHelper.QueryDataTable(sql);
Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
break;
case "loadlocationfirst":
sql = "select id,name from NCRL_SP..LocationFirst order by Id asc";
dt = DataHelper.QueryDataTable(sql);
Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
break;
case "loadlocationsecond":
if (!string.IsNullOrEmpty(Request["locationfirst"]))
{
sql = @"select id,name from NCRL_SP..LocationSecond where First_Id=(select top 1 Id from
NCRL_SP..LocationFirst where Name='" + Request["locationfirst"] + "') order by Id asc";
dt = DataHelper.QueryDataTable(sql);
Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
}
break;
case "loadchuangkou":
sql = "select id,DelegateName as name from NCRL_SP..DelegateInfo";
dt = DataHelper.QueryDataTable(sql);
Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
break;
case "loadgongchengleixing":
if (Request["prjleibiename"] == "市政工程")
{
sql = "select name from SysEnumeration where ParentId='120731f7-1ddd-4acc-a410-8bd39356863e' order by SortIndex asc";
}
else
{
sql = "select name from SysEnumeration where ParentId='110731f7-1ddd-4acc-a410-8bd39356863e' order by SortIndex asc";
}
dt = DataHelper.QueryDataTable(sql);
Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
break;
case "create":
pEnt = JsonHelper.GetObject <Project>(Request["formdata"]);
pEnt.BelongCmp = "ZX";
pEnt.Status = "已创建";
pEnt.CreateId = Aim.Portal.Web.WebPortalService.CurrentUserInfo.UserID;
pEnt.CreateName = Aim.Portal.Web.WebPortalService.CurrentUserInfo.Name;
pEnt.CreateTime = DateTime.Now;
pEnt.DoCreate();
Response.Write("{success:true,data:" + JsonHelper.GetJsonString(pEnt) + "}");
Response.End();
break;
case "update":
pEnt = JsonHelper.GetObject <Project>(Request["formdata"]);
dic = JsonHelper.GetObject <EasyDictionary>(Request["formdata"]);
oriEnt = Project.Find(pEnt.Id);
oriEnt = DataHelper.MergeData <Project>(oriEnt, pEnt, dic.Keys);
oriEnt.DoUpdate();
Response.Write("{success:true,data:" + JsonHelper.GetJsonString(oriEnt) + "}");
Response.End();
break;
case "loadform":
Response.Write("{success:true,data:" + JsonHelper.GetJsonString(pEnt) + "}");
Response.End();
break;
case "loadjiegouleixing":
sql = "select name from SysEnumeration where ParentId='28c731f7-1ddd-4acc-a410-8bd39356863e' order by SortIndex asc";
dt = DataHelper.QueryDataTable(sql);
Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
break;
case "update_gaikuang":
case "update_unit":
case "update_standard":
case "update_other":
pEnt = JsonHelper.GetObject <Project>(Request["formdata"]);
dic = JsonHelper.GetObject <EasyDictionary>(Request["formdata"]);
oriEnt = Project.Find(id);
oriEnt = DataHelper.MergeData <Project>(oriEnt, pEnt, dic.Keys);
oriEnt.DoUpdate();
Response.Write("{success:true,data:" + JsonHelper.GetJsonString(oriEnt) + "}");
Response.End();
break;
case "loadsubprj":
sql = "select * from NCRL_SP..SubProject where ProjectId='" + id + "'";
dt = DataHelper.QueryDataTable(sql);
Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
break;
case "loadkanchashejiuser":
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='" + id + "' order by SortIndex asc";
dt = DataHelper.QueryDataTable(sql);
Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
break;
case "loadprojectuser":
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='" + id + "' order by SortIndex asc";
dt = DataHelper.QueryDataTable(sql);
Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
break;
case "update_subprj":
IList <SubProject> spEnts = SubProject.FindAllByProperty(SubProject.Prop_ProjectId, id);
foreach (SubProject spEnt in spEnts)
{
spEnt.DoDelete();
}
spEnts = JsonHelper.GetObject <IList <SubProject> >(Request["subprjs"]);
foreach (SubProject spEnt in spEnts)
{
spEnt.ProjectId = id;
spEnt.DoCreate();
}
Response.Write("{success:true}");
Response.End();
break;
case "loadmajor":
sql = "select Name name from NCRL_Portal..SysEnumeration where ParentID = 'b640c40c-e2a9-41a8-bd28-d8ff9d71ff94' order by sortindex asc";
dt = DataHelper.QueryDataTable(sql);
Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
break;
case "update_kanchashejiuser":
IList <KanChaSheJi> kcsEnts = KanChaSheJi.FindAllByProperty(KanChaSheJi.Prop_ProjectId, id);
foreach (KanChaSheJi kcsEnt in kcsEnts)
{
kcsEnt.DoDelete();
}
kcsEnts = JsonHelper.GetObject <IList <KanChaSheJi> >(Request["kanchashejiuser"]);
foreach (KanChaSheJi kcsEnt in kcsEnts)
{
kcsEnt.ProjectId = id;
kcsEnt.DoCreate();
}
Response.Write("{success:true}");
Response.End();
break;
case "loadexpert_shentu":
if (!string.IsNullOrEmpty(Request["majorname"]))
{
sql = "select Id UserId,UserName from NCRL_SP..Expert where ProfessionType like '%审图专家%' and MajorName like '%" + Request["majorname"] + "%'";
dt = DataHelper.QueryDataTable(sql);
Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
}
break;
case "loadexpert_qianzhang":
if (!string.IsNullOrEmpty(Request["majorname"]))
{
sql = "select Id UserId,UserName from NCRL_SP..Expert where ProfessionType like '%签章专家%' and MajorName like '%" + Request["majorname"] + "%'";
dt = DataHelper.QueryDataTable(sql);
Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
}
break;
case "loadexpert_shenhe":
if (!string.IsNullOrEmpty(Request["majorname"]))
{
sql = "select Id UserId,UserName from NCRL_SP..Expert where ProfessionType like '%审核专家%' and MajorName like '%" + Request["majorname"] + "%'";
dt = DataHelper.QueryDataTable(sql);
Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
}
break;
case "update_projectexpert":
if (pEnt.Status == "已创建") //如果项目任务已经下达了，不允许再对专家信息进行修改，不然会造成后面数据错误
{
IList <ProjectUser> puEnts = ProjectUser.FindAllByProperty(ProjectUser.Prop_ProjectId, id);
foreach (ProjectUser puEnt in puEnts)
{
puEnt.DoDelete();
}
puEnts = JsonHelper.GetObject <IList <ProjectUser> >(Request["projectexpert"]);
foreach (ProjectUser puEnt in puEnts)
{
puEnt.ProjectId = id;
puEnt.DoCreate();
}
Response.Write("{success:true}");
Response.End();
}
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
string action = Request["action"];
string ExamineTaskId = Request["ExamineTaskId"];
string id = Request["id"];
string sql = "";
DataTable dt = null;
ExamineTask eEnt = null;
ExamineOpinion eoEnt = null;
Project pEnt = null;
JObject jo = null;
string ZhuCeUsers = "";
string SheJiUsers = "";
ProjectUser puEnt = null;
IList <KanChaSheJi> kEnts = null;
string templatepath = ConfigurationManager.AppSettings["TemplatePath"].ToString();
switch (action)
{
case "loadtimes":
IList <ExamineOpinion> eoEnts = ExamineOpinion.FindAllByProperty(ExamineOpinion.Prop_CreateTime, ExamineOpinion.Prop_ExamineTaskId, ExamineTaskId);
sql = "select Id,Stage from NCRL_SP..ExamineOpinion where ExamineTaskId='" + ExamineTaskId + "' order by CreateTime asc";
dt = DataHelper.QueryDataTable(sql);
jo = new JObject();
eEnt = ExamineTask.Find(ExamineTaskId); //审查任务
pEnt = Project.Find(eEnt.ProjectId); //项目
puEnt = ProjectUser.Find(eEnt.ProjectUserId); //项目人员
kEnts = KanChaSheJi.FindAllByProperties(KanChaSheJi.Prop_ProjectId, pEnt.Id, KanChaSheJi.Prop_MajorName, eEnt.MajorName); //勘察设计人员
foreach (KanChaSheJi kEnt in kEnts)
{
if (!string.IsNullOrEmpty(kEnt.SealNo))
{
ZhuCeUsers += kEnt.UserName;
}
else
{
SheJiUsers += kEnt.UserName;
}
}
jo.Add("ExamineTaskId", ExamineTaskId);
jo.Add("ZiXunCode", pEnt.ZiXunCode);
jo.Add("ProjectName", pEnt.ProjectName);
jo.Add("ZhuCeUsers", ZhuCeUsers);
jo.Add("SheJiUsers", SheJiUsers);
jo.Add("MajorName", eEnt.MajorName);
jo.Add("ShenChaUserId", eEnt.ProjectUserId);
jo.Add("ShenChaUserName", puEnt.UserName);
jo.Add("FuHeUserId", puEnt.ShenHeId);
jo.Add("FuHeUserName", puEnt.ShenHeName);
jo.Add("ShenChaOrganization", "江西瑞林工程咨询有限公司");
jo.Add("Id", eoEnts[0].Id);
jo.Add("Stage", eoEnts[0].Stage);
jo.Add("StartTime", eoEnts[0].StartTime.Value.ToString("yyyy-MM-dd"));
jo.Add("EndTime", eoEnts[0].EndTime.Value.ToString("yyyy-MM-dd"));
jo.Add("JiangZhuSheJi", eoEnts[0].JiangZhuSheJi);
jo.Add("FangHuo", eoEnts[0].FangHuo);
jo.Add("SheBei", eoEnts[0].SheBei);
jo.Add("JiGouSheJi", eoEnts[0].JiGouSheJi);
jo.Add("KangZhenSheJi", eoEnts[0].KangZhenSheJi);
jo.Add("JiaGu", eoEnts[0].JiaGu);
jo.Add("QiangTiao", eoEnts[0].QiangTiao);
jo.Add("ExamineOpinions", eoEnts[0].ExamineOpinions);
Response.Write("{success:true,formdata:" + JsonHelper.GetJsonString(jo) + ",rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
break;
case "loadopinion":
eoEnt = ExamineOpinion.Find(id);
jo = new JObject();
eEnt = ExamineTask.Find(eoEnt.ExamineTaskId); //审查任务
pEnt = Project.Find(eEnt.ProjectId); //项目
puEnt = ProjectUser.Find(eEnt.ProjectUserId); //项目人员
kEnts = KanChaSheJi.FindAllByProperties(KanChaSheJi.Prop_ProjectId, pEnt.Id, KanChaSheJi.Prop_MajorName, eEnt.MajorName); //勘察设计人员
foreach (KanChaSheJi kEnt in kEnts)
{
if (!string.IsNullOrEmpty(kEnt.SealNo))
{
ZhuCeUsers += kEnt.UserName;
}
else
{
SheJiUsers += kEnt.UserName;
}
}
jo.Add("ExamineTaskId", eEnt.Id);
jo.Add("ZiXunCode", pEnt.ZiXunCode);
jo.Add("ProjectName", pEnt.ProjectName);
jo.Add("ZhuCeUsers", ZhuCeUsers);
jo.Add("SheJiUsers", SheJiUsers);
jo.Add("MajorName", eEnt.MajorName);
jo.Add("ShenChaUserId", eEnt.ProjectUserId);
jo.Add("ShenChaUserName", puEnt.UserName);
jo.Add("FuHeUserId", puEnt.ShenHeId);
jo.Add("FuHeUserName", puEnt.ShenHeName);
jo.Add("ShenChaOrganization", "江西瑞林工程咨询有限公司");
jo.Add("Id", eoEnt.Id);
jo.Add("Stage", eoEnt.Stage);
jo.Add("StartTime", eoEnt.StartTime.Value.ToString("yyyy-MM-dd"));
jo.Add("EndTime", eoEnt.EndTime.Value.ToString("yyyy-MM-dd"));
jo.Add("JiangZhuSheJi", eoEnt.JiangZhuSheJi);
jo.Add("FangHuo", eoEnt.FangHuo);
jo.Add("SheBei", eoEnt.SheBei);
jo.Add("JiGouSheJi", eoEnt.JiGouSheJi);
jo.Add("KangZhenSheJi", eoEnt.KangZhenSheJi);
jo.Add("JiaGu", eoEnt.JiaGu);
jo.Add("QiangTiao", eoEnt.QiangTiao);
jo.Add("ExamineOpinions", eoEnt.ExamineOpinions);
Response.Write("{success:true,formdata:" + JsonHelper.GetJsonString(jo) + "}");
Response.End();
break;
case "saveopinion":
ExamineOpinion oriEnt = ExamineOpinion.Find(id);
eoEnt = JsonHelper.GetObject <ExamineOpinion>(Request["formdata"]);
EasyDictionary dic = JsonHelper.GetObject <EasyDictionary>(Request["formdata"]);
oriEnt = DataHelper.MergeData <ExamineOpinion>(oriEnt, eoEnt, dic.Keys);
oriEnt.DoUpdate();
Response.Write("{success:true}");
Response.End();
break;
case "export_shenchajilu":
try
{
eoEnt = ExamineOpinion.Find(id);
eEnt = ExamineTask.Find(eoEnt.ExamineTaskId);
pEnt = Project.Find(eEnt.ProjectId);
Document srcDoc = new Document(templatepath + "审查记录表.doc");
BookmarkCollection marks = srcDoc.Range.Bookmarks;
for (int j = 0; j < marks.Count; j++)
{
if (ContainProperty(eoEnt, marks[j].Name))
{
marks[j].Text = eoEnt.GetValue(marks[j].Name) + "";
}
}
if (marks["StartYear"] != null)
{
marks["StartYear"].Text = eoEnt.StartTime.Value.Year + "";
}
if (marks["StartMonth"] != null)
{
marks["StartMonth"].Text = eoEnt.StartTime.Value.Month + "";
}
if (marks["StartDay"] != null)
{
marks["StartDay"].Text = eoEnt.StartTime.Value.Day + "";
}
if (marks["EndYear"] != null)
{
marks["EndYear"].Text = eoEnt.EndTime.Value.Year + "";
}
if (marks["EndMonth"] != null)
{
marks["EndMonth"].Text = eoEnt.EndTime.Value.Month + "";
}
if (marks["EndDay"] != null)
{
marks["EndDay"].Text = eoEnt.EndTime.Value.Day + "";
}
kEnts = KanChaSheJi.FindAllByProperties(KanChaSheJi.Prop_ProjectId, pEnt.Id, KanChaSheJi.Prop_MajorName, eEnt.MajorName); //勘察设计人员
foreach (KanChaSheJi kEnt in kEnts)
{
if (!string.IsNullOrEmpty(kEnt.SealNo))
{
ZhuCeUsers += kEnt.UserName;
}
else
{
SheJiUsers += kEnt.UserName;
}
}
if (marks["MajorName"] != null)
{
marks["MajorName"].Text = eEnt.MajorName;
}
if (marks["ZhuCeName"] != null)
{
marks["ZhuCeName"].Text = ZhuCeUsers;
}
if (marks["SheJiName"] != null)
{
marks["SheJiName"].Text = SheJiUsers;
}
if (marks["ZiXunCode"] != null)
{
marks["ZiXunCode"].Text = pEnt.ZiXunCode;
}
if (marks["ProjectName"] != null)
{
marks["ProjectName"].Text = pEnt.ProjectName;
}
string filename = pEnt.ProjectName.Replace("#", "") + "_审查记录表_" + eEnt.MajorName + "_" + eoEnt.Stage + ".doc";
srcDoc.Save(@"D:\RW\Files\AppFiles\Portal\Default\" + filename);
UpdateFileItem(pEnt, filename);
Response.Write("{success:true}");
Response.End();
}
catch
{
Response.Write("{success:false}");
Response.End();
}
break;
case "delete":
string ExamineOpinionId = Request["ExamineOpinionId"];
sql = " delete from NCRL_SP..ExamineOpinion where ID='" + ExamineOpinionId + "'";
DataHelper.ExecSql(sql);
int ExamineOpinionCount = ExamineOpinion.FindAll().Where(S => S.ExamineTaskId == ExamineTaskId).Count();
Response.Write("{success:true,ExamineOpinionCount:" + ExamineOpinionCount + "}");
Response.End();
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
string projectid = Request["ProjectId"];
Project pEnt = Project.Find(projectid);
lbProjectName.InnerHtml = pEnt.ProjectName;
lbShenChaJiGou.InnerHtml = "江西瑞林工程咨询有限公司";
lbGongChengName.InnerHtml = pEnt.ProjectName;
lbDetailLocation.InnerHtml = pEnt.DetailLocation;
lbJianSheUnit.InnerHtml = pEnt.JianSheUnit;
lbBuildingArea.InnerHtml = pEnt.BuildingArea;
lbInvestment.InnerHtml = pEnt.Investment + "";
lbHeight.InnerHtml = pEnt.Height;
lbLayer.InnerHtml = "地上层数:" + pEnt.UpperLayers + (string.IsNullOrEmpty(pEnt.DownLayers) ? "" : "地下层数:" + pEnt.DownLayers);
lbStructureType.InnerHtml = pEnt.StructureType;
lbFoundationType.InnerHtml = pEnt.FoundationType;
lbKanChaGCLevel.InnerHtml = pEnt.KanChaGCLevel;
//pEnt.EngineeringLevel
lbJianZhuLeiXing.InnerHtml = pEnt.GongChengLeiXing;
lbKanChaUnit.InnerHtml = pEnt.KanChaUnit;
lbKanChaUnitHead.InnerHtml = pEnt.KanChaUnitHead;
lbKanChaZZLevel.InnerHtml = pEnt.KanChaZZLevel;
lbKanChaUnitZSNo.InnerHtml = pEnt.KanChaUnitZSNo;
lbKanChaIfBeiAn.InnerHtml = "否";
if (!string.IsNullOrEmpty(pEnt.KanChaUnitBeiAnNo))
{
lbKanChaIfBeiAn.InnerHtml = "是";
}
lbKanChaUnitBeiAnNo.InnerHtml = pEnt.KanChaUnitBeiAnNo;
lbSheJiUnit.InnerHtml = pEnt.SheJiUnit;
lbSheJiUnitHead.InnerHtml = pEnt.SheJiUnitHead;
lbSheJiUnitGrade.InnerHtml = pEnt.SheJiUnitGrade;
lbSheJiUnitZSNo.InnerHtml = pEnt.SheJiUnitZSNo;
lbSheJiIfBeiAn.InnerHtml = "否";
if (!string.IsNullOrEmpty(pEnt.SheJiUnitBeiAnNo))
{
lbSheJiIfBeiAn.InnerHtml = "是";
}
lbSheJiUnitBeiAnNo.InnerHtml = pEnt.SheJiUnitBeiAnNo;
literalSheJiUsers.Text = "";
IList <KanChaSheJi> kcsjEnts = KanChaSheJi.FindAllByProperty(KanChaSheJi.Prop_ProjectId, projectid);
literalSheJiUsers.Text += "<tr><td rowspan='" + kcsjEnts.Count + 1 + "' style='width:40px'>项</br>目</br>设</br>计</br>人</br>员</br>情</br>况</td><td style='width:150px'>专业</td><td style='width:190px'>姓名</td><td style='width:130px'>执业印章号码</td><td>身份证号码(外省单位)</td></tr>";
foreach (KanChaSheJi kcsjEnt in kcsjEnts)
{
if (kcsjEnt.Position == "注册土木工程师(岩土)")
{
lbKanChaUserName.InnerHtml = kcsjEnt.UserName;
lbKanChaYinZhangHao.InnerHtml = kcsjEnt.SealNo;
lbKanChaShenFenZheng.InnerHtml = kcsjEnt.ShenFenZhengNo;
}
else
{
literalSheJiUsers.Text += "<tr><td>" + kcsjEnt.MajorName + "</td><td>" + kcsjEnt.UserName + "</td><td>" + kcsjEnt.SealNo + "</td><td>" + kcsjEnt.ShenFenZhengNo + "</td></tr>";
}
}
string sql = @"select count(QiangTiao) from NCRL_SP..ExamineOpinion where ExamineTaskId in
(select Id from NCRL_SP..ExamineTask where ProjectId='" + projectid + "')";
lbIfYiCiPass.InnerHtml = "是";
if (DataHelper.QueryValue <int>(sql) > 0)
{
lbIfYiCiPass.InnerHtml = "否";
}
sql = @"select a.*,b.StampNo ShenChaYinZhangHao,c.StampNo as ShenHeYinZhangHao,
(select top 1 SortIndex from NCRL_Portal..SysEnumeration where ParentId='b640c40c-e2a9-41a8-bd28-d8ff9d71ff94' and Name=a.MajorName) as SortIndex from NCRL_SP..ProjectUser a
left join NCRL_SP..Expert b on a.QianZhangId=b.Id
left join NCRL_SP..Expert c on a.ShenHeId=c.Id where a.ProjectId='" + projectid + "' order by SortIndex asc ";
literal_shencha.Text = "";
IList <EasyDictionary> dics = DataHelper.QueryDictList(sql);
literal_shencha.Text += "<tr><td rowspan='" + (dics.Count + 1) + "' style='width:40px'>项<br />目<br />审<br />查<br />人<br />员<br />情<br />况</td><td style='width:95px'>专业</td><td style='width:110px'>审查人员姓名</td><td style='width:110px'>审查印章号码</td><td style='width:60px'>签名</td><td style='width:110px'>复核人员姓名</td><td style='width:110px'>审查印章号码</td><td style='width:60px'>签名</td></tr>";
foreach (EasyDictionary dic in dics)
{
if (dic.Get <string>("MajorName") != "勘察")
{
literal_shencha.Text += "<tr><td>" + dic.Get <string>("MajorName") + "</td><td>" + dic.Get <string>("QianZhangName") + "</td><td>" + dic.Get <string>("ShenChaYinZhangHao") + "</td><td></td><td>" + dic.Get <string>("ShenHeName") + "</td><td>" + dic.Get <string>("ShenHeYinZhangHao") + "</td><td></td></tr>";
}
}
IList <ShenChaReport> scrEnts = ShenChaReport.FindAllByProperty(ShenChaReport.Prop_ProjectId, projectid);
if (scrEnts.Count > 0)
{
lbJingBanYiJian.InnerHtml = scrEnts[0].Opinion7;
}
}
