private void DoSelect()
{
string where = "";
foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches)
{
if (!string.IsNullOrEmpty(item.Value.ToString()))
{
switch (item.PropertyName)
{
//case "StartTime":
// where += " and StartTime>'" + item.Value + "' ";
// break;
//case "EndTime":
// where += " and EndTime<='" + (item.Value.ToString()).Replace(" 0:00:00", " 23:59:59") + "' ";
// break;
default:
where += " and " + item.PropertyName + " like '%" + item.Value + "%'";
break;
}
}
}
sql = @"select *,(select count(Id) from BJKY_Examine..CustomIndicator where IndicatorSecondId=IndicatorScore.IndicatorSecondId
and Year='{0}' and StageType='{1}' and CreateId='{2}') as SubQuan
from BJKY_Examine..IndicatorScore where ExamineTaskId='{3}' " + where;
ExamineTask etEnt = ExamineTask.Find(TaskId);
ExamineStage esEnt = ExamineStage.Find(etEnt.ExamineStageId);
sql = string.Format(sql, esEnt.Year, esEnt.StageType, etEnt.BeUserId, TaskId);
PageState.Add("DataList", GetPageData(sql, SearchCriterion));
PageState.Add("TaskInfo", etEnt);
}
protected void Page_Load(object sender, EventArgs e)
{
ExamineStageId = RequestData.Get <string>("ExamineStageId");
ToUserId = RequestData.Get <string>("ToUserId");
if (!string.IsNullOrEmpty(ExamineStageId))
{
esEnt = ExamineStage.Find(ExamineStageId);
}
switch (RequestActionString)
{
case "delete":
IList <string> taskIds = RequestData.GetList <string>("taskIds");
foreach (string taskId in taskIds)
{
ExamineTask etEnt = ExamineTask.Find(taskId);
etEnt.DoDelete();
}
esEnt.TaskQuan = esEnt.TaskQuan - taskIds.Count;
esEnt.DoUpdate();
break;
default:
DoSelect();
break;
}
}
private void DoSelect()
{
string where = "";
foreach (CommonSearchCriterionItem item in SearchCriterion.Searches.Searches)
{
if (!string.IsNullOrEmpty(item.Value.ToString()))
{
switch (item.PropertyName)
{
//case "StartTime":
// where += " and StartTime>'" + item.Value + "' ";
// break;
//case "EndTime":
// where += " and EndTime<='" + (item.Value.ToString()).Replace(" 0:00:00", " 23:59:59") + "' ";
// break;
default:
where += " and " + item.PropertyName + " like '%" + item.Value + "%'";
break;
}
}
}
sql = @"select A.*,B.PersonFirstIndicatorName,B.Weight,B.IndicatorType,B.SortIndex from BJKY_Examine..CustomFirstIndicatorScore as A
left join BJKY_Examine..PersonFirstIndicator as B on A.PersonFirstIndicatorId=B.Id
where ExamineTaskId='{0}' " + where;
ExamineTask etEnt = ExamineTask.Find(TaskId);
sql = string.Format(sql, TaskId);
PageState.Add("DataList", DataHelper.QueryDictList(sql));
PageState.Add("TaskInfo", etEnt);
}
private void SubmitTask()
{
IList <string> taskIds = RequestData.GetList <string>("taskIds");
if (taskIds.Count > 0)
{
foreach (string str in taskIds)
{
ExamineTask etEnt = ExamineTask.Find(str);
etEnt.State = "2";
etEnt.DoUpdate();
}
}
}
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 + "日";
}
private void SaveSubScore()
{
string ExamineTaskId = RequestData.Get <string>("ExamineTaskId");
ExamineTask etEnt = ExamineTask.Find(ExamineTaskId);
string IndicatorSecondId = RequestData.Get <string>("IndicatorSecondId");
decimal SubScore = RequestData.Get <decimal>("SubScore");
//decimal Score = RequestData.Get<decimal>("Score");
IList <IndicatorScore> insEnts = IndicatorScore.FindAllByProperties(IndicatorScore.Prop_ExamineTaskId, ExamineTaskId, IndicatorScore.Prop_IndicatorSecondId, IndicatorSecondId);
if (insEnts.Count > 0)//更新
{
insEnts[0].SubScore = SubScore;
insEnts[0].DoUpdate();
}
else//创建
{
IndicatorScore insEnt = new IndicatorScore();
IndicatorSecond isEnt = IndicatorSecond.Find(IndicatorSecondId);
IndicatorFirst ifEnt = IndicatorFirst.Find(isEnt.IndicatorFirstId);
string tooltip = "!" + ifEnt.CustomColumn + "#" + isEnt.ToolTip;//加入#号前面的字符是为了标识该指标下有自定义指标，有明细分
insEnt.ExamineTaskId = ExamineTaskId;
insEnt.IndicatorFirstId = isEnt.IndicatorFirstId;
insEnt.IndicatorFirstName = isEnt.IndicatorFirstName;
insEnt.FirstMaxScore = ifEnt.MaxScore;
insEnt.FirstSortIndex = ifEnt.SortIndex;
insEnt.IndicatorSecondId = isEnt.Id;
insEnt.IndicatorSecondName = isEnt.IndicatorSecondName;
insEnt.SecondMaxScore = isEnt.MaxScore;
insEnt.SecondSortIndex = isEnt.SortIndex;
insEnt.SubScore = SubScore;
insEnt.ToolTip = tooltip;
insEnt.DoCreate();
}
sql = "select isnull(SUM(SubScore),0) FROM BJKY_Examine..IndicatorScore WHERE ExamineTaskId = '" + ExamineTaskId + "'";
etEnt.Score = DataHelper.QueryValue <decimal>(sql);
etEnt.DoUpdate();
PageState.Add("Score", etEnt.Score);
}
private void SaveSubScore()
{
string ExamineTaskId = RequestData.Get <string>("ExamineTaskId");
ExamineTask etEnt = ExamineTask.Find(ExamineTaskId);
string IndicatorSecondId = RequestData.Get <string>("IndicatorSecondId");
decimal SubScore = RequestData.Get <decimal>("SubScore");
decimal Score = RequestData.Get <decimal>("Score");
IList <IndicatorScore> insEnts = IndicatorScore.FindAllByProperties(IndicatorScore.Prop_ExamineTaskId, ExamineTaskId, IndicatorScore.Prop_IndicatorSecondId, IndicatorSecondId);
if (insEnts.Count > 0)//更新
{
insEnts[0].SubScore = SubScore; insEnts[0].DoUpdate();
}
else//创建
{
IndicatorScore insEnt = new IndicatorScore();
IndicatorSecond isEnt = IndicatorSecond.Find(IndicatorSecondId);
IndicatorFirst ifEnt = IndicatorFirst.Find(isEnt.IndicatorFirstId);
string tooltip = "!" + ifEnt.InsteadColumn + "#" + isEnt.ToolTip;//加入#号前面的字符是为了验证经营开发正职 部分要素分是由人力资源部打的
insEnt.ExamineTaskId = ExamineTaskId;
insEnt.IndicatorFirstId = isEnt.IndicatorFirstId;
insEnt.IndicatorFirstName = isEnt.IndicatorFirstName;
insEnt.FirstMaxScore = ifEnt.MaxScore;
insEnt.FirstSortIndex = ifEnt.SortIndex;
insEnt.IndicatorSecondId = isEnt.Id;
insEnt.IndicatorSecondName = isEnt.IndicatorSecondName;
insEnt.SecondMaxScore = isEnt.MaxScore;
insEnt.SecondSortIndex = isEnt.SortIndex;
insEnt.SubScore = SubScore;
insEnt.ToolTip = tooltip;
insEnt.DoCreate();
etEnt.Score = Score;
etEnt.DoUpdate();
}
etEnt.Score = Score;
etEnt.DoUpdate();
}
private void DoSelect()
{
sql = @"select A.Id,A.PersonFirstIndicatorId, A.PersonSecondIndicatorName,A.Weight,A.SortIndex, A.ToolTip,A.SelfRemark,
B.IndicatorType,B.PersonFirstIndicatorName, B.Weight as FirstWeight, B.SortIndex as FirstIndex ,C.Summary,
(select top 1 CustomScore from BJKY_Examine..CustomFirstIndicatorScore where ExamineTaskId='{5}' and PersonFirstIndicatorId=B.Id) as Score
from BJKY_Examine..PersonSecondIndicator as A
left join BJKY_Examine..PersonFirstIndicator as B on A.PersonFirstIndicatorId=B.Id
left join BJKY_Examine..CustomIndicator as C on B.CustomIndicatorId=C.Id
where C.CreateId='{0}' and C.Year='{1}' and C.StageType='{2}' and C.DeptId='{3}' and C.IndicatorSecondId='{4}' and C.Result='同意'
order by B.IndicatorType desc ,B.Id asc,A.SortIndex asc";
ExamineTask etEnt = ExamineTask.Find(ExamineTaskId);
ExamineStage esEnt = ExamineStage.Find(etEnt.ExamineStageId);
sql = string.Format(sql, etEnt.BeUserId, esEnt.Year, esEnt.StageType, esEnt.LaunchDeptId, IndicatorSecondId, ExamineTaskId);
IList <EasyDictionary> dics0 = DataHelper.QueryDictList(sql);
IList <EasyDictionary> dics1 = new List <EasyDictionary>();
string temp = "";
foreach (EasyDictionary dic0 in dics0)
{
EasyDictionary dic1 = new EasyDictionary();
if (temp != dic0.Get <string>("PersonFirstIndicatorId"))
{
temp = dic0.Get <string>("PersonFirstIndicatorId");
dic1.Add("PersonFirstIndicatorId", dic0.Get <string>("PersonFirstIndicatorId"));
dic1.Add("IndicatorType", dic0.Get <string>("IndicatorType"));
dic1.Add("PersonFirstIndicatorName", dic0.Get <string>("PersonFirstIndicatorName"));
dic1.Add("FirstWeight", dic0.Get <string>("FirstWeight"));
dic1.Add("Id", dic0.Get <string>("Id"));
dic1.Add("PersonSecondIndicatorName", dic0.Get <string>("PersonSecondIndicatorName"));
dic1.Add("Weight", dic0.Get <string>("Weight"));
dic1.Add("ToolTip", dic0.Get <string>("ToolTip"));
dic1.Add("SelfRemark", dic0.Get <string>("SelfRemark"));
dic1.Add("Score", dic0.Get <string>("Score"));
dic1.Add("Summary", dic0.Get <string>("Summary"));
}
else
{
dic1.Add("PersonFirstIndicatorId", "");
dic1.Add("IndicatorType", "");
dic1.Add("PersonFirstIndicatorName", "");
dic1.Add("FirstWeight", "");
dic1.Add("Id", dic0.Get <string>("Id"));
dic1.Add("PersonSecondIndicatorName", dic0.Get <string>("PersonSecondIndicatorName"));
dic1.Add("Weight", dic0.Get <string>("Weight"));
dic1.Add("ToolTip", dic0.Get <string>("ToolTip"));
dic1.Add("SelfRemark", dic0.Get <string>("SelfRemark"));
dic1.Add("Score", "");
dic1.Add("Summary", dic0.Get <string>("Summary"));
}
dics1.Add(dic1);
}
PageState.Add("DataList", dics1);
IndicatorSecond isEnt = IndicatorSecond.Find(IndicatorSecondId);
var obj = new
{
DeptName = etEnt.BeDeptName,
IndicatorSecondName = isEnt.IndicatorSecondName,
MaxScore = isEnt.MaxScore,
BeUserName = etEnt.BeUserName
};
PageState.Add("BaseInfo", obj);
}
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;
}
}
private void DoSelect()
{
if (Index == "0")
{
sql = @"select * from BJKY_Examine..ExamineTask where State='1' and
ExamineStageId='{0}' and ToUserId='{1}' and ExamineRelationId='{2}' order by BeDeptName,BeUserName ";
sql = string.Format(sql, ExamineStageId, UserInfo.UserID, ExamineRelationId);
}
if (Index == "1")
{
sql = @"select * from BJKY_Examine..ExamineTask where State='2' and
ExamineStageId='{0}' and ToUserId='{1}' and ExamineRelationId='{2}' order by BeDeptName,BeUserName";
sql = string.Format(sql, ExamineStageId, UserInfo.UserID, ExamineRelationId);
}
if (Index == "2")
{
sql = @"select * from BJKY_Examine..ExamineTask where State='3' and
ExamineStageId='{0}' and ToUserId='{1}' and ExamineRelationId='{2}' order by BeDeptName,BeUserName";
sql = string.Format(sql, ExamineStageId, UserInfo.UserID, ExamineRelationId);
}
if (!string.IsNullOrEmpty(id))//单任务查看明细
{
ExamineTask etEnt = ExamineTask.Find(id);
ExamineStageId = etEnt.ExamineStageId;
sql = @"select * from BJKY_Examine..ExamineTask where Id='" + id + "'";
}
IList <EasyDictionary> dics = DataHelper.QueryDictList(sql);//找到所有符合条件的任务
if (dics.Count > 0)
{
if (Index != "2")
{
DataTable dt = new DataTable();
DataColumn dc = new DataColumn("Id"); dt.Columns.Add(dc);
dc = new DataColumn("BeUserName"); dt.Columns.Add(dc);
dc = new DataColumn("BeDeptName"); dt.Columns.Add(dc);
dc = new DataColumn("Score"); dt.Columns.Add(dc);
dc = new DataColumn("Tag"); dt.Columns.Add(dc);
DataTable dt1 = new DataTable();//这个表专门用来存储一级指标名称和各2级指标数量
DataColumn dc1 = new DataColumn("IndicatorFirstName"); dt1.Columns.Add(dc1);
dc1 = new DataColumn("SecondCount"); dt1.Columns.Add(dc1);
ExamineIndicator eiEnt = ExamineIndicator.Find(dics[0].Get <string>("ExamineIndicatorId"));
IList <IndicatorFirst> ifEnts = IndicatorFirst.FindAllByProperty("SortIndex", IndicatorFirst.Prop_ExamineIndicatorId, eiEnt.Id);
foreach (IndicatorFirst ifEnt in ifEnts)
{
IList <IndicatorSecond> isEnts = IndicatorSecond.FindAllByProperty("SortIndex", IndicatorSecond.Prop_IndicatorFirstId, ifEnt.Id);
DataRow dr1 = dt1.NewRow();
dr1["IndicatorFirstName"] = ifEnt.IndicatorFirstName + "(" + ifEnt.MaxScore + ")";
dr1["SecondCount"] = isEnts.Count;
if (isEnts.Count > 0)
{
dt1.Rows.Add(dr1);//防止只有一级指标无2级指标。
}
foreach (IndicatorSecond isEnt in isEnts)
{
string standard = "!" + ifEnt.InsteadColumn + "#" + isEnt.ToolTip; //加入#号前面的字符是为了验证经营开发正职 部分要素分是由人力资源部打的
dc = new DataColumn(isEnt.Id + isEnt.IndicatorSecondName + "(" + isEnt.MaxScore + ")" + standard); //列名有多种信息组合而成。便于前台取对应的值
dt.Columns.Add(dc); //循环2级指标构建剩余列
}
}
IList <EasyDictionary> secDics = null;
if (dics.Count > 0)//通过任务的指标Id找到其下所有 的二级指标
{
sql = @"select A.Id, a.IndicatorSecondName,B.InsteadColumn,A.ToolTip,A.MaxScore from BJKY_Examine..IndicatorSecond A
left join BJKY_Examine..IndicatorFirst B on A.IndicatorFirstId=B.Id
where B.ExamineIndicatorid='{0}' " ;
sql = string.Format(sql, dics[0].Get <string>("ExamineIndicatorId"));
secDics = DataHelper.QueryDictList(sql);
}
foreach (EasyDictionary dic in dics)//通过任务构建行记录
{
DataRow dr = dt.NewRow();
dr["Id"] = dic.Get <string>("Id");
dr["BeUserName"] = dic.Get <string>("BeUserName");
dr["BeDeptName"] = dic.Get <string>("BeDeptName");
dr["Score"] = dic.Get <string>("Score");
dr["Tag"] = dic.Get <string>("Tag");
foreach (EasyDictionary secDic in secDics)
{
string standard = "!" + secDic.Get <string>("InsteadColumn") + "#" + secDic.Get <string>("ToolTip");
IList <IndicatorScore> insEnts = IndicatorScore.FindAllByProperties(IndicatorScore.Prop_ExamineTaskId, dic.Get <string>("Id"), IndicatorScore.Prop_IndicatorSecondId, secDic.Get <string>("Id"));
if (insEnts.Count > 0)
{
dr[secDic.Get <string>("Id") + secDic.Get <string>("IndicatorSecondName") + "(" + secDic.Get <string>("MaxScore") + ")" + standard] = insEnts[0].SubScore;
}
//if (standard.IndexOf("T") > 0)
//{
// sql = @"select Top 1 Score from BJKY_Examine..ExamineTask where BeUserId='{0}' and ToUserId='D2564369-7FFE-45A5-8830-14EE3A8833F7'";
// sql = string.Format(sql, dic.Get<string>("BeUserId"));
// dr[secDic.Get<string>("Id") + secDic.Get<string>("IndicatorSecondName") + "(" + secDic.Get<string>("MaxScore") + ")" + standard] = DataHelper.QueryValue<decimal>(sql);
//}
}
dt.Rows.Add(dr);
}
PageState.Add("DataList", dt);
PageState.Add("ColumnData", dt.Columns);
PageState.Add("DataList1", dt1);
}
else
{
InitialHistoryScore(dics);
}
ExamineStage esEnt = ExamineStage.Find(ExamineStageId);
string stageType = "";
if (esEnt.StageType != "4")
{
stageType = "第" + esEnt.StageType + "季度";
}
else
{
stageType = "年度";
}
PageState.Add("Title", esEnt.Year + stageType + "考核评分表");
}
}