private void LoadFileType()
{
string EnumID = Request["id"];
if (!string.IsNullOrEmpty(EnumID))
{
IList<SysEnumeration> seEnts = SysEnumeration.FindAllByProperty(SysEnumeration.Prop_SortIndex, SysEnumeration.Prop_ParentID, EnumID);
string result = "[";
int i = 0;
foreach (SysEnumeration seEnt in seEnts)
{
if (i != seEnts.Count - 1)
{
result += "{id:'" + seEnt.EnumerationID + "',Name:'" + seEnt.Name + "',leaf:" + (seEnt.IsLeaf.Value ? "true" : "false") + "},";
}
else
{
result += "{id:'" + seEnt.EnumerationID + "',Name:'" + seEnt.Name + "',leaf:" + (seEnt.IsLeaf.Value ? "true" : "false") + "}";
}
i++;
}
result += "]";
Response.Write(result);
Response.End();
}
}
private void Select()
{
id = Request["id"];
if (!string.IsNullOrEmpty(id))
{
IList <SysEnumeration> Ents = SysEnumeration.FindAllByProperty(SysEnumeration.Prop_SortIndex, SysEnumeration.Prop_ParentID, id);
string result = "[";
int i = 0;
foreach (SysEnumeration Ent in Ents)
{
if (i != Ents.Count - 1)
{
result += "{id:'" + Ent.EnumerationID + "',Name:'" + Ent.Name + "',Code:'" + Ent.Code + "',Value:'" + Ent.Value + "',ParentID:'" + Ent.ParentID + "',leaf:" + (Ent.IsLeaf.Value ? "true" : "false") + "},";
}
else
{
result += "{id:'" + Ent.EnumerationID + "',Name:'" + Ent.Name + "',Code:'" + Ent.Code + "',Value:'" + Ent.Value + "',ParentID:'" + Ent.ParentID + "',leaf:" + (Ent.IsLeaf.Value ? "true" : "false") + "}";
}
i++;
}
result += "]";
Response.Write("{children:" + result + "}");
Response.End();
}
}
private void DoSelect()
{
if (op != "c" && op != "cs")
{
if (!String.IsNullOrEmpty(id))
{
ent = Feedback.Find(id);
}
SetFormData(ent);
}
else
{
ExamYearResult eyrEnt = ExamYearResult.Find(ExamYearResultId);
string level = eyrEnt.AdviceLevel;
decimal? score = eyrEnt.IntegrationScore;
if (!string.IsNullOrEmpty(eyrEnt.ApproveLevel))
{
level = eyrEnt.ApproveLevel;
}
if (!string.IsNullOrEmpty(eyrEnt.AppealLevel))
{
level = eyrEnt.AppealLevel;
}
if (eyrEnt.ApproveScore > 0)
{
score = eyrEnt.ApproveScore;
}
if (eyrEnt.AppealScore > 0)
{
score = eyrEnt.AppealScore;
}
var obj = new
{
ExamYearResultId = ExamYearResultId,
ExamineStageId = eyrEnt.ExamineStageId,
UserId = eyrEnt.UserId,
UserName = eyrEnt.UserName,
//因为部门级考核没有被考核角色 和名称 所以要判断一下
BeRoleCode = !string.IsNullOrEmpty(eyrEnt.BeRoleCode) ? eyrEnt.BeRoleCode : "",
BeRoleName = !string.IsNullOrEmpty(eyrEnt.BeRoleCode) ? SysEnumeration.FindAllByProperty(SysEnumeration.Prop_Code, eyrEnt.BeRoleCode).First <SysEnumeration>().Name : "",
DeptId = eyrEnt.DeptId,
DeptName = eyrEnt.DeptName,
Year = eyrEnt.Year,
ExamineGrade = level,
IntegrationScore = score,
FirstQuarterScore = eyrEnt.FirstQuarterScore,
SecondQuarterScore = eyrEnt.SecondQuarterScore,
ThirdQuarterScore = eyrEnt.ThirdQuarterScore,
YearScore = eyrEnt.FourthQuarterScore
};
SetFormData(obj);
}
}
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();
}
private void DoSelect()
{
IList <ExamineRelation> ents = null;
if (!string.IsNullOrEmpty(id))
{
ents = ExamineRelation.FindAllByProperty("Id", id);
}
else
{
ents = ExamineRelation.FindAll(SearchCriterion);
}
PageState.Add("DataList", ents);
PageState.Add("BeRoleName", SysEnumeration.GetEnumDict("BeExamineObject")); //被考核
PageState.Add("ToRoleName", SysEnumeration.FindAllByProperty(SysEnumeration.Prop_Code, "ExamineObject").First().ChildNodes); //多选下拉框
}
private void Delete()
{
string EnumID = Request["EnumID"];
Ent = SysEnumeration.Find(EnumID);
SysEnumeration ent_parent = SysEnumeration.Find(Ent.ParentID);
Ent.DoDelete();
IList <SysEnumeration> ents_sysenumeration = SysEnumeration.FindAllByProperty(SysEnumeration.Prop_ParentID, ent_parent.EnumerationID);
if (ents_sysenumeration.Count == 0)
{
ent_parent.IsLeaf = true;
ent_parent.DoUpdate();
}
}
private void DoSelect()
{
if (op == "c")
{
if (!String.IsNullOrEmpty(ExamYearResultId))
{
ExamYearResult eyrEnt = ExamYearResult.Find(ExamYearResultId);
ExamineStage esEnt = ExamineStage.Find(eyrEnt.ExamineStageId);
IList <PersonConfig> pcEnts1 = PersonConfig.FindAllByProperty("GroupCode", "HRAppealAcceptor");
IList <PersonConfig> pcEnts2 = PersonConfig.FindAllByProperty("GroupCode", "HRAppealCharger");
IList <PersonConfig> pcEnts3 = PersonConfig.FindAllByProperty("Id", eyrEnt.DeptId);
var obj = new
{
ExamYearResultId = ExamYearResultId,
ExamineStageId = eyrEnt.ExamineStageId,
ExamineType = esEnt.ExamineType,
AppealUserId = eyrEnt.UserId,
AppealUserName = eyrEnt.UserName,
OriginalScore = eyrEnt.ApproveScore.HasValue ? eyrEnt.ApproveScore : eyrEnt.IntegrationScore,
OriginalLevel = String.IsNullOrEmpty(eyrEnt.ApproveLevel) ? eyrEnt.ApproveLevel : eyrEnt.AdviceLevel,
//有可能是部门级考核 没有角色编号和角色名称
BeRoleCode = !string.IsNullOrEmpty(eyrEnt.BeRoleCode) ? eyrEnt.BeRoleCode : "",
BeRoleName = !string.IsNullOrEmpty(eyrEnt.BeRoleCode) ? SysEnumeration.FindAllByProperty(SysEnumeration.Prop_Code, eyrEnt.BeRoleCode).First <SysEnumeration>().Name : "",
DeptId = eyrEnt.DeptId,
DeptName = eyrEnt.DeptName,
AppealTime = System.DateTime.Now.ToShortDateString(),
AcceptUserId = pcEnts1.Count > 0 ? pcEnts1[0].ClerkIds.Replace(",", "") : "",
AcceptUserName = pcEnts1.Count > 0 ? pcEnts1[0].ClerkNames : "",
DeptLeaderId = pcEnts3.Count > 0 ? pcEnts3[0].FirstLeaderIds.Replace(",", "") : "",
DeptLeaderName = pcEnts3.Count > 0 ? pcEnts3[0].FirstLeaderNames : "",
HrUserId = pcEnts2.Count > 0 ? pcEnts2[0].ClerkIds.Replace(",", "") : "",
HrUserName = pcEnts2.Count > 0 ? pcEnts2[0].ClerkNames : ""
};
SetFormData(obj);
}
}
else
{
if (!string.IsNullOrEmpty(id))
{
ent = ExamineAppeal.Find(id);
SetFormData(ent);
}
}
PageState.Add("ExamineLevel", SysEnumeration.GetEnumDict("ExamineLevel"));
}
protected void Page_Load(object sender, EventArgs e)
{
op = RequestData.Get <string>("op");
id = RequestData.Get <string>("id");
switch (RequestActionString)
{
case "update":
ent = GetMergedData <ExamineIndicator>();
seEnts = SysEnumeration.FindAllByProperty(SysEnumeration.Prop_Value, ent.BeRoleCode);
if (seEnts.Count > 0)
{
ent.BeRoleName = seEnts[0].Name;
}
ent.DoUpdate();
break;
case "create":
ent = GetPostedData <ExamineIndicator>();
seEnts = SysEnumeration.FindAllByProperty(SysEnumeration.Prop_Value, ent.BeRoleCode);
if (seEnts.Count > 0)
{
ent.BeRoleName = seEnts[0].Name;
}
ent.DoCreate();
break;
case "copy":
ent = GetPostedData <ExamineIndicator>();
ExamineIndicator eiNEnt = new ExamineIndicator(null, ent.IndicatorName, ent.BeRoleCode, ent.BeRoleName, ent.BelongDeptId, ent.BelongDeptName, ent.Remark, null, null, null);
eiNEnt.DoCreate();
DoCopy(eiNEnt, id);
break;
default:
DoSelect();
break;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Aim.Portal.Web.WebPortalService.CheckLogon();
}
catch
{
Response.Redirect("/Login.aspx");
}
action = Request["action"];
EnumID = Request["id"];
ParentID = Request["ParentID"];
switch (action)
{
case "select":
if (!string.IsNullOrEmpty(EnumID))
{
IList <SysEnumeration> seEnts = SysEnumeration.FindAllByProperty(SysEnumeration.Prop_SortIndex, SysEnumeration.Prop_ParentID, EnumID);
string result = "[";
int i = 0;
foreach (SysEnumeration seEnt in seEnts)
{
if (i != seEnts.Count - 1)
{
result += "{id:'" + seEnt.EnumerationID + "',Name:'" + seEnt.Name + "',Code:'" + seEnt.Code + "',Value:'" + seEnt.Value + "',ParentID:'" + seEnt.ParentID + "',leaf:" + (seEnt.IsLeaf.Value ? "true" : "false") + "},";
}
else
{
result += "{id:'" + seEnt.EnumerationID + "',Name:'" + seEnt.Name + "',Code:'" + seEnt.Code + "',Value:'" + seEnt.Value + "',ParentID:'" + seEnt.ParentID + "',leaf:" + (seEnt.IsLeaf.Value ? "true" : "false") + "}";
}
i++;
}
result += "]";
Response.Write(result);
Response.End();
}
break;
case "delete":
SysEnumeration ent_sysenumeration = SysEnumeration.Find(EnumID);
SysEnumeration ent_parent = SysEnumeration.Find(ent_sysenumeration.ParentID);
ent_sysenumeration.DoDelete();
IList <SysEnumeration> ents_sysenumeration = SysEnumeration.FindAllByProperty(SysEnumeration.Prop_ParentID, ent_parent.EnumerationID);
if (ents_sysenumeration.Count == 0)
{
ent_parent.IsLeaf = true;
ent_parent.DoUpdate();
}
//sql = @"delete sysenumeration where enumerationid='" + EnumID + "'";
//DataHelper.ExecSql(sql);
//string sql1 = "select * from sysenumeration where ParentID ='" + ParentID + "'";
//IList<EasyDictionary> dics = DataHelper.QueryDictList(sql1);
//if (dics.Count() == 0)
//{
// sql = "update sysenumeration set ISLEAF =1 where enumerationid='" + ParentID + "'";
// DataHelper.ExecSql(sql);
//}
//Response.Write("");
//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();
}
action = Request["action"];
EnumID = Request["id"];
ParentID = Request["ParentID"];
switch (action)
{
case "select":
if (!string.IsNullOrEmpty(EnumID))
{
IList <SysEnumeration> seEnts = SysEnumeration.FindAllByProperty(SysEnumeration.Prop_SortIndex, SysEnumeration.Prop_ParentID, EnumID);
string result = "[";
int i = 0;
string checkstr = "";
foreach (SysEnumeration seEnt in seEnts)
{
checkstr = seEnt.IsLeaf.Value == true ? "checked:false," : "";
if (i != seEnts.Count - 1)
{
result += "{id:'" + seEnt.EnumerationID + "',Name:'" + seEnt.Name + "'," + checkstr + "Value:'" + seEnt.Value + "',ParentID:'" + seEnt.ParentID + "',leaf:" + (seEnt.IsLeaf.Value ? "true" : "false") + "},";
}
else
{
result += "{id:'" + seEnt.EnumerationID + "',Name:'" + seEnt.Name + "'," + checkstr + "Value:'" + seEnt.Value + "',ParentID:'" + seEnt.ParentID + "',leaf:" + (seEnt.IsLeaf.Value ? "true" : "false") + "}";
}
i++; checkstr = "";
}
result += "]";
Response.Write(result);
Response.End();
}
break;
case "delete":
SysEnumeration ent_sysenumeration = SysEnumeration.Find(EnumID);
SysEnumeration ent_parent = SysEnumeration.Find(ent_sysenumeration.ParentID);
ent_sysenumeration.DoDelete();
IList <SysEnumeration> ents_sysenumeration = SysEnumeration.FindAllByProperty(SysEnumeration.Prop_ParentID, ent_parent.EnumerationID);
if (ents_sysenumeration.Count == 0)
{
ent_parent.IsLeaf = true;
ent_parent.DoUpdate();
}
break;
case "inigrid":
string typeids = Request["typeids"];
DataTable dt = new DataTable();
DataColumn dc = new DataColumn("Id");
dt.Columns.Add(dc);
dc = new DataColumn("ProjectName");
dt.Columns.Add(dc);
sql = "select EnumerationID Id,Name,PatIndex('%'+EnumerationID+'%','" + typeids + "') as SortIndex from SysEnumeration where '" + typeids + "' like '%'+EnumerationID+'%' order by SortIndex asc";
DataTable dt_enum = DataHelper.QueryDataTable(sql);
foreach (DataRow dr_enum in dt_enum.Rows)
{
dc = new DataColumn(dr_enum["Id"].ToString() + dr_enum["Name"]);
dt.Columns.Add(dc);
}
string where = "";
if (!string.IsNullOrEmpty(Request["belongdept"]))
{
where += " and BelongDeptId='" + Request["belongdept"] + "'";
}
sql = "select Id,ProjectName from NCRL_SP..Project where BelongCmp='JL' " + where + " order by CreateTime desc";
IList <EasyDictionary> dics = DataHelper.QueryDictList(sql);
foreach (EasyDictionary dic in dics)
{
DataRow dr = dt.NewRow();
dr["Id"] = dic.Get <string>("Id");
dr["ProjectName"] = dic.Get <string>("ProjectName");
foreach (DataRow dr_enum in dt_enum.Rows)
{
IList <FileItem> fiEnts = FileItem.FindAllByProperties(FileItem.Prop_ProjectId, dic.Get <string>("Id"), FileItem.Prop_SecondTypeId, dr_enum["Id"]);
if (fiEnts.Count > 0)
{
dr[dr_enum["Id"].ToString() + dr_enum["Name"]] = "√";
}
}
dt.Rows.Add(dr);
}
Response.Write("{success:true,rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
Response.End();
break;
case "loadgroup":
sql = "select GroupId id,replace(Name,'江西瑞林建设监理有限公司','') as name from SysGroup where ParentId='228' order by id asc";
dt = DataHelper.QueryDataTable(sql);
Response.Write("{rows:" + JsonHelper.GetJsonStringFromDataTable(dt) + "}");
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 action = Request["action"];
string groupid = Request["groupid"];
string projectId = Request["projectid"];
FileFolder ffEnt = null;
Project pEnt = null;
switch (action)
{
case "upload":
//如果是项目文档 上传项目编号文件夹 如果是部门文档上传到DEFAULT文件夹
if (!string.IsNullOrEmpty(projectId))
{
pEnt = Project.Find(projectId);
IList <FileFolder> ffEnts = FileFolder.FindAllByProperty(FileFolder.Prop_FolderKey, pEnt.ProjectCode);
if (ffEnts.Count == 0)
{
ffEnt = new FileFolder();
ffEnt.Name = pEnt.ProjectCode;
ffEnt.FolderKey = pEnt.ProjectCode;
ffEnt.Path = pEnt.ProjectCode;
ffEnt.ParentId = "1";
ffEnt.CreateTime = DateTime.Now;
ffEnt.ModuleId = "1";
ffEnt.DoCreate();
ffEnt.FullId = "1." + ffEnt.Id;
ffEnt.DoUpdate();
}
else
{
ffEnt = ffEnts[0];
}
if (!Directory.Exists(@"D:\RW\Files\AppFiles\Portal\" + pEnt.ProjectCode))
{
Directory.CreateDirectory(@"D:\RW\Files\AppFiles\Portal\" + pEnt.ProjectCode);
}
}
else
{
ffEnt = FileFolder.Find("1"); //如果是非项目文档，上传到默认文件夹
}
string formdata = Request["formdata"];
JObject json = Aim.JsonHelper.GetObject <JObject>(formdata);
FileItem fiEnt = new FileItem();
fiEnt.GroupId = groupid;
fiEnt.ProjectId = projectId;
fiEnt.FirstTypeId = json.Value <string>("FirstTypeId");
fiEnt.SecondTypeId = json.Value <string>("SecondTypeId");
HttpPostedFile postedFile = Request.Files["projectfile"]; //获取上传信息对象
string fileName = Path.GetFileName(postedFile.FileName);
fiEnt.Name = fileName;
fiEnt.FolderId = ffEnt.Id;
fiEnt.CreatorId = Aim.Portal.Web.WebPortalService.CurrentUserInfo.UserID;
fiEnt.CreatorName = Aim.Portal.Web.WebPortalService.CurrentUserInfo.Name;
fiEnt.CreateTime = DateTime.Now;
fiEnt.DoCreate();
// string filename = postedFile.FileName;//获取上传的文件路径
// string tempPath = System.Configuration.ConfigurationManager.AppSettings["NewsFolderPath"];//获取保存文件夹路径，我是设置在webconfig中了。
// string savepath = Server.MapPath(@"D:\RW\Files\AppFiles\Portal\" + pEnt.ProjectCode + "\\");//获取保存路径
// string sExtension = filename.Substring(filename.LastIndexOf('.'));//获取拓展名
//if (!Directory.Exists(savepath))
//Directory.CreateDirectory(savepath);
//string sNewFileName = DateTime.Now.ToString("yyyyMMddhhmmsfff"); + fiEnt.Id + "_"" + seEnt.IsLeaf + "
postedFile.SaveAs(@"D:\RW\Files\AppFiles\Portal\" + ffEnt.Path + @"/" + fiEnt.Id + "_" + fileName); //保存
Response.Write("{success:true}");
Response.End();
break;
case "loadfiletype":
string id = Request["id"];
if (string.IsNullOrEmpty(id))
{
id = "cf38bd7a-79d1-46fb-bf06-640b30f61654";
}
IList <SysEnumeration> seEnts = SysEnumeration.FindAllByProperty("SortIndex", SysEnumeration.Prop_ParentID, id);
int i = 0;
string result = "[";
foreach (SysEnumeration seEnt in seEnts)
{
if (i != seEnts.Count - 1)
{
result += "{'id':'" + seEnt.EnumerationID + "','text':'" + seEnt.Name + "','leaf':" + (seEnt.IsLeaf.Value ? "true" : "false") + ",'parentid':'" + seEnt.ParentID + "'},";
}
else
{
result += "{'id':'" + seEnt.EnumerationID + "','text':'" + seEnt.Name + "','leaf':" + (seEnt.IsLeaf.Value ? "true" : "false") + ",'parentid':'" + seEnt.ParentID + "'}";
}
i++;
}
result += "]";
Response.Write(result);
Response.End();
break;
case "getprojectname":
string temp = "{";
if (!string.IsNullOrEmpty(projectId))
{
pEnt = Project.Find(projectId);
temp += "ProjectName:'" + pEnt.ProjectName + "'";
}
if (!string.IsNullOrEmpty(groupid))
{
SysGroup sgEnt = SysGroup.Find(groupid);
temp += (temp.Length > 1 ? ",GroupName:'" : "GroupName:'") + sgEnt.Name + "'";
}
Response.Write(temp + "}");
Response.End();
break;
}
}