/// <summary>
/// 递归获取到公司级全路径
/// </summary>
/// <param name="ParentId"></param>
/// <returns></returns>
public static string getCzlxDG1(string ParentId, ref string result)
{
//SysGroup group = SysGroup.TryFind(ParentId);
//Modify By WGM 8/9
string SQL = "select * from FL_PortalHR..SysGroup where GroupID='" + ParentId + "'";
SQL = SQL.Replace("FL_PortalHR", Global.AimPortalDB);
//SysGroup group = JsonHelper.GetObject<SysGroup>(JsonHelper.GetJsonString(DataHelper.QueryDictList(SQL).FirstOrDefault()));
EasyDictionary group = DataHelper.QueryDictList(SQL).FirstOrDefault();
if (group == null)
{
return("");
}
else if (group["ParentID"] + "" != "" && !(group["Name"] + "").Contains("公司"))
{
result = (group["Name"] + "") + '/' + result;
return(getCzlxDG1(group["ParentID"] + "", ref result));
}
else
{
result = (group["Name"] + "") + "/" + result;
return(result.TrimEnd('/'));
}
}
public void When_creating_easy_dictionary_with_key_selector_comparer_and_collection()
{
var collection = Enumerable.Range(1, 5).Select(n => new Person(n.ToString(), n)).ToList();
var comparer = StringComparer.OrdinalIgnoreCase;
Func <Person, string> selector = p => p.Id;
EasyDictionary <string, Person> dic = new EasyDictionary <string, Person>(
selector, collection, comparer);
dic.ShouldNotBeNull();
dic.KeySelector.ShouldBe(selector);
dic.Count.ShouldBe(5);
dic.Keys.ShouldNotBeEmpty();
dic.Values.ShouldNotBeEmpty();
dic.IsReadOnly.ShouldBeFalse();
dic.Comparer.ShouldNotBe(EqualityComparer <string> .Default);
dic.Comparer.ShouldBe(comparer);
dic.Keys.ShouldBe(new[] { "1", "2", "3", "4", "5" });
dic.Values.ShouldBe(collection);
dic.ContainsKey("1").ShouldBeTrue();
dic.Contains(collection[0]).ShouldBeTrue();
dic["1"].Age.ShouldBe(1);
dic.ContainsKey("0").ShouldBeFalse();
}
/// <summary>
/// 由枚举编码获取Enum字典
/// </summary>
/// <param name="enums"></param>
/// <returns></returns>
public static EasyDictionary GetEnumDict(string code)
{
SysEnumeration tent = SysEnumeration.Get(code);
EasyDictionary dict = tent.GetDict();
return(dict);
}
public void When_getting_enumerator_as_easy_dictionary()
{
var p1 = new Person("A", 1);
var p2 = new Person("B", 2);
EasyDictionary <string, Person> dic = new EasyDictionary <string, Person>(p => p.Id)
{
p1,
p2
};
using (var enumerator = dic.GetEnumerator())
{
enumerator.ShouldNotBeNull();
enumerator.MoveNext().ShouldBeTrue();
enumerator.Current.ShouldBe(p1);
enumerator.MoveNext().ShouldBeTrue();
enumerator.Current.ShouldBe(p2);
enumerator.MoveNext().ShouldBeFalse();
}
}
/// <summary>
/// 基本津贴
/// </summary>
/// <param name="workno">工号</param>
/// <returns></returns>
public string GetTravelBaseMoney(string workno)
{
EasyDictionary DicBase = SysEnumeration.GetEnumDict("WorkYearMoney");
string BaseMoney_One = DicBase["<1年"] + "";
string BaseMoney_two = DicBase[">1年"] + "";
string sql = @"select WorkMoney As Total
from
(
select top 1
case
when charindex('正式工',psnclassname)>0 and year(Indutydate)>1 then {2}
else {1}
end As WorkMoney ,
psnclassname
from FL_PortalHR..sysuser As A
left join HR_OA_MiddleDB..fld_rylb As B
on B.pk_fld_rylb=A.Pk_rylb
where workno='{0}'
) As T" ;
sql = string.Format(sql, workno, BaseMoney_One.Replace("NULL", "0"), BaseMoney_two);
sql = sql.Replace("HR_OA_MiddleDB", Global.HR_OA_MiddleDB);
sql = sql.Replace("FL_PortalHR", Global.AimPortalDB);
return(DataHelper.QueryValue(sql) + "");
}
public void When_adding_or_replacing_items()
{
var p1 = new Person("A", 1);
var p2 = new Person("A", 11);
EasyDictionary <string, Person> dic = new EasyDictionary <string, Person>(p => p.Id);
dic.Count.ShouldBe(0);
dic.AddOrReplace(p1).ShouldBeTrue();
dic.Count.ShouldBe(1);
dic["A"].ShouldBe(p1);
dic.AddOrReplace(p1).ShouldBeFalse();
dic.Count.ShouldBe(1);
dic["A"].ShouldBe(p1);
dic.AddOrReplace(p2).ShouldBeTrue();
dic.Count.ShouldBe(1);
dic["A"].ShouldNotBe(p1);
dic["A"].ShouldBe(p2);
}
private void DoSelect()
{
IList <EasyDictionary> dics = new List <EasyDictionary>();
sql = "select distinct Year from BJKY_Examine..ExamYearResult order by Year asc";
IList <EasyDictionary> yearDics = DataHelper.QueryDictList(sql);
foreach (EasyDictionary yearDic in yearDics)
{
EasyDictionary dic = new EasyDictionary();
dic.Add("Year", yearDic.Get <string>("Year"));
sql = @"select count(Id) from BJKY_Examine..ExamYearResult where ApproveLevel is not null and Year='" + yearDic.Get <string>("Year") + "'";
decimal t = DataHelper.QueryValue <int>(sql);
dic.Add("Total", t);
sql = @"select count(Id) from BJKY_Examine..ExamYearResult where Year='" + yearDic.Get <string>("Year") + "' and (ApproveLevel='优秀' or AppealLevel='优秀')";
decimal q1 = DataHelper.QueryValue <int>(sql);
dic.Add("优秀", q1);
dic.Add("优秀占比", Math.Round(q1 * 100 / t, 2));
sql = @"select count(Id) from BJKY_Examine..ExamYearResult where Year='" + yearDic.Get <string>("Year") + "' and (ApproveLevel='良好' or AppealLevel='良好')";
decimal q2 = DataHelper.QueryValue <int>(sql);
dic.Add("良好", q2);
dic.Add("良好占比", Math.Round(q2 * 100 / t, 2));
sql = @"select count(Id) from BJKY_Examine..ExamYearResult where Year='" + yearDic.Get <string>("Year") + "' and (ApproveLevel='称职' or AppealLevel='称职')";
decimal q3 = DataHelper.QueryValue <int>(sql);
dic.Add("称职", q3);
dic.Add("称职占比", Math.Round(q3 * 100 / t, 2));
sql = @"select count(Id) from BJKY_Examine..ExamYearResult where Year='" + yearDic.Get <string>("Year") + "' and (ApproveLevel='不称职' or AppealLevel='不称职')";
decimal q4 = DataHelper.QueryValue <int>(sql);
dic.Add("不称职", q4);
dic.Add("不称职占比", Math.Round(q4 * 100 / t, 2));
dics.Add(dic);
}
PageState.Add("DataList", dics);
}
private void DoSelect()
{
if (op != "c" && op != "cs")
{
if (!String.IsNullOrEmpty(id))
{
ent = ExamineStage.Find(id);
}
SetFormData(ent);
sql = @"select A.*,B.BeUserNames,B.UpLevelUserNames,B.SameLevelUserNames,B.DownLevelUserNames,B.RelationName,
C.IndicatorName from BJKY_Examine..ExamineStageDetail as A
left join BJKY_Examine..DeptExamineRelation as B on A.ExamineRelationId=B.Id
left join BJKY_Examine..ExamineIndicator as C on C.Id=A.ExamineIndicatorId
where A.ExamineStageId='" + id + "'";
PageState.Add("DataList", DataHelper.QueryDictList(sql));
}
if (op == "c")
{
var obj = new
{
ExamineType = ExamineType,
LaunchUserName = UserInfo.Name,
LaunchUserId = UserInfo.UserID
};
SetFormData(obj);
}
sql = @"select Id,GroupName from BJKY_Examine..PersonConfig
where (ClerkIds like '%{0}%' or SecondLeaderIds like '%{0}%' or FirstLeaderIds like '%{0}%') and (GroupType='职能服务部门' or GroupType='经营目标单位')";
sql = string.Format(sql, UserInfo.UserID);
EasyDictionary dic1 = DataHelper.QueryDict(sql, "Id", "GroupName");
PageState.Add("enumDept", dic1);
PageState.Add("EnumYear", SysEnumeration.GetEnumDict("Year"));
}
public void When_creating_easy_dictionary_with_key_selector_comparer_and_dictionary()
{
var comparer = StringComparer.OrdinalIgnoreCase;
var somePerson = new Person("A", 1);
var someDic = new Dictionary <string, Person> {
["B"] = somePerson
};
Func <Person, string> selector = p => p.Id;
EasyDictionary <string, Person> dic = new EasyDictionary <string, Person>(
selector, someDic, comparer);
dic.ShouldNotBeNull();
dic.KeySelector.ShouldBe(selector);
dic.Count.ShouldBe(1);
dic.Keys.ShouldNotBeEmpty();
dic.Values.ShouldNotBeEmpty();
dic.IsReadOnly.ShouldBeFalse();
dic.Comparer.ShouldNotBe(EqualityComparer <string> .Default);
dic.Comparer.ShouldBe(comparer);
dic.Keys.ShouldBe(new[] { "A" });
dic.Values.ShouldBe(new[] { somePerson });
dic.ContainsKey("A").ShouldBeTrue();
dic.Contains(somePerson).ShouldBeTrue();
dic.ContainsKey("B").ShouldBeFalse();
dic["A"].Age.ShouldBe(1);
}
protected void Page_Load(object sender, EventArgs e)
{
switch (RequestActionString)
{
case "GetResultByUserId":
string userId = RequestData.Get <string>("userId");
IList <ExamYearResult> eyrEnts = ExamYearResult.FindAllByProperty("Year", "UserId", userId);
IList <EasyDictionary> dics = new List <EasyDictionary>();
foreach (ExamYearResult eyrEnt in eyrEnts)
{
EasyDictionary dic = new EasyDictionary();
dic.Add("YearQuarter", eyrEnt.Year + "-1");
dic.Add("Score", eyrEnt.FirstQuarterScore);
dics.Add(dic);
dic = new EasyDictionary();
dic.Add("YearQuarter", eyrEnt.Year + "-2");
dic.Add("Score", eyrEnt.SecondQuarterScore);
dics.Add(dic);
dic = new EasyDictionary();
dic.Add("YearQuarter", eyrEnt.Year + "-3");
dic.Add("Score", eyrEnt.ThirdQuarterScore);
dics.Add(dic);
dic = new EasyDictionary();
dic.Add("YearQuarter", eyrEnt.Year + "-4");
dic.Add("Score", eyrEnt.FourthQuarterScore);
dics.Add(dic);
}
PageState.Add("Result", dics);
break;
default:
DoSelect();
break;
}
}
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;
}
}
/// <summary>
/// 由给出的编码列表获取枚举字典列表
/// </summary>
/// <returns></returns>
public static EasyDictionary <string, EasyDictionary> GetEnumDicts(params string[] codes)
{
EasyDictionary <string, EasyDictionary> rtndict = new EasyDictionary <string, EasyDictionary>();
SysEnumeration[] tents = SysEnumeration.FindAll(Expression.In(SysEnumeration.Prop_Code, codes));
string[] pids = tents.Select(tent => tent.EnumerationID).ToArray();
IEnumerable <SysEnumeration> subents = SysEnumeration.FindAll(Expression.In(SysEnumeration.Prop_ParentID, pids));
subents = subents.OrderBy(tsubtent => tsubtent.SortIndex).ThenBy(tsubtent => tsubtent.CreatedDate);
foreach (SysEnumeration tent in tents)
{
EasyDictionary dict = new EasyDictionary();
IEnumerable <SysEnumeration> tsubents = subents.Where(ttent => ttent.ParentID == tent.EnumerationID);
foreach (SysEnumeration tsubent in tsubents)
{
dict.Set(tsubent.Value, tsubent.Name);
}
rtndict.Set(tent.Code, dict);
}
return(rtndict);
}
/// <summary>
/// 查询
/// </summary>
private void DoSelect()
{
EasyDictionary dic = SysEnumeration.GetEnumDict("EmpAppeal");
dic.Add("%%", "请选择...");
PageState.Add("AppealTypeName", dic);
//问卷角色或管理员
CommPowerSplit Role = new CommPowerSplit();
if (Role.IsAppealRole(UserInfo.UserID, UserInfo.LoginName))
{
ents = UsrAppealList.FindAll(SearchCriterion);
this.PageState.Add("UsrAppealListList", ents);
}
else
{
StringBuilder strb = new StringBuilder();
if (Session["CompanyId"] != null) //判断公司登陆
{
SearchCriterion.SetSearch(UsrAppealList.Prop_CompanyId, Session["CompanyId"]);
ents = UsrAppealList.FindAll(SearchCriterion);
this.PageState.Add("UsrAppealListList", ents);
}
else
{
var UsrEnt = SysUser.Find(UserInfo.UserID);
SearchCriterion.SetSearch(UsrAppealList.Prop_CompanyId, UsrEnt.Pk_corp);
ents = UsrAppealList.FindAll(SearchCriterion);
this.PageState.Add("UsrAppealListList", ents);
}
}
}
private void DoSelect()
{
sql = @"select Id as IndicatorFirstId ,IndicatorFirstName from BJKY_Examine..IndicatorFirst
where ExamineIndicatorId = '" + ExamineIndicatorId + "' order by SortIndex asc ";
EasyDictionary dic = DataHelper.QueryDict(sql, "IndicatorFirstId", "IndicatorFirstName");
PageState.Add("IndictorFirstEnum", dic);//Combo数据集
if (op != "c" && op != "cs")
{
if (!String.IsNullOrEmpty(id))
{
ent = IndicatorSecond.Find(id);
}
SetFormData(ent);
SearchCriterion.AddSearch(ScoreStandard.Prop_IndicatorSecondId, id);
SearchCriterion.SetOrder("SortIndex", true);
ents = ScoreStandard.FindAll(SearchCriterion);
PageState.Add("DataList", ents);
}
else
{
if (!string.IsNullOrEmpty(IndicatorFirstId))
{
IndicatorFirst ifEnt = IndicatorFirst.Find(IndicatorFirstId);
sql = "select isnull(max(SortIndex),0) from BJKY_Examine..IndicatorSecond where IndicatorFirstId='" + IndicatorFirstId + "'";
var obj = new
{
SortIndex = DataHelper.QueryValue <int>(sql) + 1,
ExamineIndicatorId = ExamineIndicatorId
};
SetFormData(obj);
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
string action = Request["action"];
switch (action)
{
case "create":
create();
break;
case "update":
obj = Request["obj"];
ent = JsonHelper.GetObject <SupervisionJianBao>(obj);
SupervisionJianBao oldEnt = SupervisionJianBao.Find(ent.Id);
EasyDictionary dic = JsonHelper.GetObject <EasyDictionary>(obj);
ent = DataHelper.MergeData <SupervisionJianBao>(oldEnt, ent, dic.Keys);
ent.DoUpdate();
break;
case "Load":
string Id = Request["Id"];
ent = SupervisionJianBao.Find(Id);
string str = JsonHelper.GetJsonString(ent);
Response.Write("{success: true ,data:" + str + "}");
Response.End();
break;
case "PNameCombo":
PNameCombo();
break;
}
}
public void When_getting_enumerator_as_ienumerable()
{
var p1 = new Person("A", 1);
var p2 = new Person("B", 2);
IEnumerable dic = new EasyDictionary <string, Person>(p => p.Id)
{
p1,
p2
};
var enumerator = dic.GetEnumerator();
enumerator.ShouldNotBeNull();
enumerator.MoveNext().ShouldBeTrue();
((KeyValuePair <string, Person>)enumerator.Current).Key.ShouldBe("A");
((KeyValuePair <string, Person>)enumerator.Current).Value.ShouldBe(p1);
enumerator.MoveNext().ShouldBeTrue();
((KeyValuePair <string, Person>)enumerator.Current).Key.ShouldBe("B");
((KeyValuePair <string, Person>)enumerator.Current).Value.ShouldBe(p2);
enumerator.MoveNext().ShouldBeFalse();
}
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"];
Id = Request["Id"];
switch (action)
{
case "Create":
Create();
break;
case "Update":
string obj = Request["json"];
ent = JsonHelper.GetObject <DelegateInfo>(obj);
DelegateInfo ori_Ent = DelegateInfo.Find(Id);
EasyDictionary dic = JsonHelper.GetObject <EasyDictionary>(obj);
ori_Ent = DataHelper.MergeData <DelegateInfo>(ori_Ent, ent, dic.Keys);
ori_Ent.DoUpdate();
break;
case "SelectEdit":
SelectEdit();
break;
}
}
private void Update()
{
obj = Request["obj"];
ent = JsonHelper.GetObject <SupervisionRiZhi>(obj);
SupervisionRiZhi oldEnt = SupervisionRiZhi.Find(ent.Id);
EasyDictionary dic = JsonHelper.GetObject <EasyDictionary>(obj);
ent = DataHelper.MergeData <SupervisionRiZhi>(oldEnt, ent, dic.Keys);
ent.DoUpdate();
}
/// <summary>
/// 查询
/// </summary>
private void DoSelect()
{
SearchCriterion.SetSearch(UsrAppealList.Prop_UserId, UserInfo.UserID);
ents = UsrAppealList.FindAll(SearchCriterion);
this.PageState.Add("UsrAppealListList", ents);
EasyDictionary dic = SysEnumeration.GetEnumDict("EmpAppeal");
dic.Add("%%", "请选择...");
PageState.Add("AppealTypeName", dic);
}
/// <summary>
/// 获取服务年限+基本津贴
/// </summary>
/// <param name="workno">工号</param>
/// <returns></returns>
public string GetTravelAllMoney(string workno)
{
EasyDictionary Dic = SysEnumeration.GetEnumDict("BaseMoney");
string One = Dic[">1<5"] + "";
string Two = Dic[">=5<10"] + "";
string Three = Dic[">=10<15"] + "";
string Four = Dic[">=15<20"] + "";
EasyDictionary LimitDate = SysEnumeration.GetEnumDict("TravelLimitDate");
string limitDateStr = string.Empty;
if ((LimitDate["LimitDate"] + "").ToUpper() == "2L") //2 月最后一天
{
limitDateStr = "'" + GetLastDayOfMonth(DateTime.Now.Year, 2).ToString("yyyy-MM-dd") + "'";
}
else
{
string prefix = LimitDate["LimitDate"] + "";
limitDateStr = "'" + DateTime.Now.Year + "-" + prefix + "'";
}
EasyDictionary DicBase = SysEnumeration.GetEnumDict("WorkYearMoney");
string BaseMoney_One = DicBase["<1年"] + "";
string BaseMoney_two = DicBase[">1年"] + "";
string sql = @"select YearMoney + WorkMoney As Total
from
(
select top 1
case
when 1<datediff(year, Indutydate,getdate())and datediff(year,Indutydate,getdate())<5 then {1}
when 5<=datediff(year,Indutydate,getdate())and datediff(year,Indutydate,getdate())<10 then {2}
when 10<=datediff(year,Indutydate,getdate())and datediff(year,Indutydate,getdate())<15 then {3}
when 15<=datediff(year,Indutydate,getdate())and datediff(year,Indutydate,getdate())<20 then {4}
else 0
end As YearMoney,
case
when charindex('正式工',psnclassname)>0 and year(Indutydate)>1 then {6}
else {5}
end As WorkMoney ,
psnclassname
from FL_PortalHR..sysuser As A
left join HR_OA_MiddleDB..fld_rylb As B
on B.pk_fld_rylb=A.Pk_rylb
where workno='{0}'
) As T" ;
sql = sql.Replace("getdate()", limitDateStr);
sql = string.Format(sql, workno, One, Two, Three, Four, BaseMoney_One.Replace("NULL", "0"), BaseMoney_two);
sql = sql.Replace("HR_OA_MiddleDB", Global.HR_OA_MiddleDB);
sql = sql.Replace("FL_PortalHR", Global.AimPortalDB);
return(DataHelper.QueryValue(sql) + "");
}
public void When_creating_easy_dictionary_with_key_selector_and_capacity()
{
Func <Person, string> selector = p => p.Id;
EasyDictionary <string, Person> dic = new EasyDictionary <string, Person>(selector, 10);
dic.ShouldNotBeNull();
dic.KeySelector.ShouldBe(selector);
dic.Count.ShouldBe(0);
dic.Keys.ShouldBeEmpty();
dic.Values.ShouldBeEmpty();
dic.IsReadOnly.ShouldBeFalse();
dic.Comparer.ShouldBe(EqualityComparer <string> .Default);
}
protected void Page_Load(object sender, EventArgs e)
{
BeiAn_Project bap_Ent = null;
IList <BeiAn_Project> bap_Ents = null;
string action = Request["action"];
string projectid = Request["ProjectId"];
string sql = "";
switch (action)
{
case "loadform":
sql = "select a.*,b.ProjectName from NCRL_SP..BeiAn_Project 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);
Response.Write("{success:true,data:" + JsonHelper.GetJsonString(pEnt) + "}");
}
Response.End();
break;
case "update":
bap_Ents = BeiAn_Project.FindAllByProperty(BeiAn_Project.Prop_ProjectId, projectid);
string json = Request["json"];
BeiAn_Project ent_new = JsonHelper.GetObject <BeiAn_Project>(json);
if (bap_Ents.Count > 0)
{
bap_Ent = bap_Ents[0];
EasyDictionary dic = JsonHelper.GetObject <EasyDictionary>(json);
bap_Ent = DataHelper.MergeData <BeiAn_Project>(bap_Ent, ent_new, dic.Keys);
bap_Ent.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}");
Response.End();
break;
}
}
/// <summary>
/// 由编码获取Enumeration字典
/// </summary>
/// <param name="code"></param>
/// <returns></returns>
public static EasyDictionary <string, SysEnumeration> Get(params string[] codes)
{
EasyDictionary <string, SysEnumeration> enums = new EasyDictionary <string, SysEnumeration>();
IEnumerable <SysEnumeration> tents = SysEnumeration.FindAll(Expression.In(SysEnumeration.Prop_Code, codes));
tents = tents.OrderBy(tent => tent.SortIndex).ThenBy(tent => tent.CreatedDate);
foreach (SysEnumeration tent in tents)
{
enums.Set(tent.Code, tent);
}
return(enums);
}
public static IList <EasyDictionary> DataTableToDictList(DataTable dt)
{
IList <EasyDictionary> list = new List <EasyDictionary>();
foreach (DataRow row in dt.Rows)
{
EasyDictionary item = new EasyDictionary();
foreach (DataColumn column in dt.Columns)
{
item.Set(column.ColumnName, row[column]);
}
list.Add(item);
}
return(list);
}
public void When_comparing_easy_dictionaries()
{
IReadOnlyDictionary <string, Person> left = new EasyDictionary <string, Person>(p => p.Id);
IReadOnlyDictionary <string, Person> right = new EasyDictionary <string, Person>(p => p.Id);
DictionaryExtensions.Equals(left, right).ShouldBeTrue();
((IEasyDictionary <string, Person>)left).Add(new Person("A", 1));
DictionaryExtensions.Equals(left, right).ShouldBeFalse();
((IEasyDictionary <string, Person>)right).Add(new Person("A", 1));
DictionaryExtensions.Equals(left, right).ShouldBeTrue();
DictionaryExtensions.Equals(((IDictionary <int, string>)null), null).ShouldBeTrue();
}
public void When_getting_key_and_values_as_ienumerable()
{
var p1 = new Person("A", 1);
var p2 = new Person("B", 2);
IReadOnlyDictionary <string, Person> dic = new EasyDictionary <string, Person>(p => p.Id)
{
p1,
p2
};
dic.Count.ShouldBe(2);
dic.Keys.ShouldBe(new [] { "A", "B" });
dic.Values.ShouldBe(new [] { p1, p2 });
}
private void DoSelect()
{
//问题浏览项次数+1
string UpdateSql = "update FL_Culture..EmpVoiceAskQuestion set ViewCount=ViewCount+1 where Id='{0}' ";
UpdateSql = string.Format(UpdateSql, Question);
DataHelper.ExecSql(UpdateSql);
//
if (string.IsNullOrEmpty(Question))
{
return;
}
string SQL = @"select A.Id, A.Contents,A.Anonymity,A.Category,A.AnswerCount,A.ViewCount,A.NikeName,A.IsCheck,A.CreateTime,A.AcceptAnswerId,
B.Id as A_Id, B.Answer,B.Anonymity As A_Anonymity,B.ParentId,B.IsLeaf,B.IsCheck As A_IsCheck,B.NikeName As A_NikeName,
B.ReplyCount, B.CreateTime As A_CreateTime
from FL_Culture..EmpVoiceAskQuestion As A
left join FL_Culture..EmpVoiceAnswerInfo As B
on A.AcceptAnswerId=B.Id where A.Id='{0}' ";
SQL = string.Format(SQL, Question);
EasyDictionary EDic = DataHelper.QueryDictList(SQL).FirstOrDefault();
this.SetFormData(EDic);
SQL = @"select * from FL_Culture..EmpVoiceAnswerInfo where QuestionId='{0}' and ( IsCheck='1' or IsCheck is null) ";
SQL = string.Format(SQL, Question);
this.PageState.Add("Comment", GegPgComment(SQL, 1, 10));
//添加用户基本信息
string UserInfoSQL = @"select A.UserID ,A.Name As UserName,B.Nickname
from FL_PortalHR..SysUser As A
left join FL_Culture..EmpVoiceMyBaseInfo As B
on A.UserID=B.UserID
where A.UserID='{0}'" ;
UserInfoSQL = UserInfoSQL.Replace("FL_PortalHR", Global.AimPortalDB);
UserInfoSQL = string.Format(UserInfoSQL, UserInfo.UserID);
var Ent = DataHelper.QueryDictList(UserInfoSQL);
this.PageState.Add("UserInfoEnt", Ent);
SQL = @"select * from FL_Culture..EmpVoiceAnswerInfo where id in( select AcceptAnswerId from FL_Culture..EmpVoiceAskQuestion where id='{0}') ";
SQL = string.Format(SQL, Question);
this.PageState.Add("topDate", DataHelper.QueryDataTable(SQL));
}
private void Update()
{
string obj = Request["data"];
string ProfessionType = Request["ProfessionType"];
string MajorName = Request["MajorName"];
ent = JsonHelper.GetObject <Expert>(obj);
Expert ori_Ent = Expert.Find(ent.Id);
EasyDictionary dic = JsonHelper.GetObject <EasyDictionary>(obj);
ent = DataHelper.MergeData <Expert>(ori_Ent, ent, dic.Keys);
ent.MajorCode = MajorName;
ent.MajorName = MajorName;
ent.ProfessionType = ProfessionType;
ent.DoUpdate();
}
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"];
UserId = Request["UserId"];
switch (action)
{
case "Create":
obj = Request["json"];
ent = JsonHelper.GetObject <SysUser>(obj);
MD5Encrypt encrypt = new MD5Encrypt();
ent.Server_IAGUID = "267";
ent.Server_Seed = "江西瑞林工程咨询有限公司";
ent.LoginName = ent.IDNumber;
ent.Status = 1;
ent.Password = encrypt.GetMD5FromString(ent.LoginName);
ent.DoCreate();
break;
case "Update":
obj = Request["json"];
ent = JsonHelper.GetObject <SysUser>(obj);
SysUser ori_Ent = SysUser.Find(ent.UserID);
EasyDictionary dic = JsonHelper.GetObject <EasyDictionary>(obj);
ent = DataHelper.MergeData <SysUser>(ori_Ent, ent, dic.Keys);
ent.DoUpdate();
break;
case "SelectEdit":
SelectEdit();
break;
case "check":
Check();
break;
}
}
private void DoSelect()
{
IList <EasyDictionary> dics = new List <EasyDictionary>();
sql = "select distinct Year from BJKY_Examine..ExamYearResult order by Year asc";
IList <EasyDictionary> yearDics = DataHelper.QueryDictList(sql);
foreach (EasyDictionary yearDic in yearDics)
{
EasyDictionary dic = new EasyDictionary();
dic.Add("Year", yearDic.Get <string>("Year"));
sql = @"select count(Id) from BJKY_Examine..ExamYearResult where Year='" + yearDic.Get <string>("Year") + "'";
decimal t = DataHelper.QueryValue <int>(sql);
dic.Add("Total", t);
sql = @"select count(Id) from BJKY_Examine..ExamYearResult where Year='" + yearDic.Get <string>("Year") + "' and IntegrationScore>=95";
decimal q1 = DataHelper.QueryValue <int>(sql);
dic.Add("95->100", q1);
dic.Add("95->100占比", Math.Round(q1 * 100 / t, 2));
sql = @"select count(Id) from BJKY_Examine..ExamYearResult where Year='" + yearDic.Get <string>("Year") + "' and IntegrationScore>=90 and IntegrationScore < 95";
decimal q2 = DataHelper.QueryValue <int>(sql);
dic.Add("90->94", q2);
dic.Add("90->94占比", Math.Round(q2 * 100 / t, 2));
sql = @"select count(Id) from BJKY_Examine..ExamYearResult where Year='" + yearDic.Get <string>("Year") + "' and IntegrationScore>=85 and IntegrationScore < 90";
decimal q3 = DataHelper.QueryValue <int>(sql);
dic.Add("85->89", q3);
dic.Add("85->89占比", Math.Round(q3 * 100 / t, 2));
sql = @"select count(Id) from BJKY_Examine..ExamYearResult where Year='" + yearDic.Get <string>("Year") + "' and IntegrationScore>=80 and IntegrationScore < 85";
decimal q4 = DataHelper.QueryValue <int>(sql);
dic.Add("80->84", q4);
dic.Add("80->84占比", Math.Round(q4 * 100 / t, 2));
sql = @"select count(Id) from BJKY_Examine..ExamYearResult where Year='" + yearDic.Get <string>("Year") + "' and IntegrationScore>=75 and IntegrationScore < 80";
decimal q5 = DataHelper.QueryValue <int>(sql);
dic.Add("75->79", q5);
dic.Add("75->79占比", Math.Round(q5 * 100 / t, 2));
sql = @"select count(Id) from BJKY_Examine..ExamYearResult where Year='" + yearDic.Get <string>("Year") + "' and IntegrationScore>=70 and IntegrationScore < 75";
decimal q6 = DataHelper.QueryValue <int>(sql);
dic.Add("70->74", q6);
dic.Add("70->74占比", Math.Round(q6 * 100 / t, 2));
sql = @"select count(Id) from BJKY_Examine..ExamYearResult where Year='" + yearDic.Get <string>("Year") + "' and IntegrationScore>=0 and IntegrationScore < 70";
decimal q7 = DataHelper.QueryValue <int>(sql);
dic.Add("0->69", q7);
dic.Add("0->69占比", Math.Round(q7 * 100 / t, 2));
dics.Add(dic);
}
PageState.Add("DataList", dics);
}
