void BindDropDownList()
{
//绑定项目阶段
Query q = Query.Build(new { SortFields = "CodeID" });
q.Add("CodeName", "ProjectPeriod");
dpProjectPeriod.Items.Clear();
dpProjectPeriod.Items.Add(new ListItem("==请选择==", ""));
IList <SysCode> slist = bc.GetSysCodeList(q);
if (slist.Count > 0)
{
foreach (SysCode sc in slist)
{
dpProjectPeriod.Items.Add(new ListItem(sc.CodeText, sc.CodeValue));
}
}
//绑定 专家，项目，联盟成员，团队成员
Query qe = Query.Build(new { SortFields = "ExpertID" });
Query qp = Query.Build(new { SortFields = "ProjectID" });
Query qm = Query.Build(new { SortFields = "MemberID" });
IList <Expert> elist = be.GetExpertsList(qe);
dpExpert.Items.Clear();
dpExpert.Items.Add(new ListItem("==请选择==", ""));
if (elist.Count > 0)
{
foreach (Expert e in elist)
{
dpExpert.Items.Add(new ListItem(e.EName, e.ExpertID.ToString()));
}
}
IList <Member> lmlist = bm.GetMembersList(qm).Where(t => t.MemberType == MemberType.联盟成员.ToString()).ToList();
dpLm.Items.Clear();
dpLm.Items.Add(new ListItem("==请选择==", ""));
if (lmlist.Count > 0)
{
foreach (Member m in lmlist)
{
dpLm.Items.Add(new ListItem(m.MemberName, m.MemberID.ToString()));
}
}
IList <Member> tdlist = bm.GetMembersList(qm).Where(t => t.MemberType == MemberType.团队成员.ToString()).ToList();
dpTd.Items.Clear();
dpTd.Items.Add(new ListItem("==请选择==", ""));
if (tdlist.Count > 0)
{
foreach (Member m in tdlist)
{
dpTd.Items.Add(new ListItem(m.MemberName, m.MemberID.ToString()));
}
}
}
private void BindDetail()
{
Query q = new Query();
q.OrderBy("Istop desc,sort");
q.Append("EIdentification='" + ExpertType.校内专家 + "'");
int rec = 0;
rplist.DataSource = be.GetExpertsList(q, AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, out rec);
rplist.DataBind();
AspNetPager1.RecordCount = rec;
}
void BindDropDownList()
{
//绑定 专家，项目，联盟成员，团队成员
Query qe = Query.Build(new { SortFields = "ExpertID" });
Query qp = Query.Build(new { SortFields = "ProjectID" });
Query qm = Query.Build(new { SortFields = "MemberID" });
IList <Expert> elist = be.GetExpertsList(qe);
dpExpert.Items.Clear();
dpExpert.Items.Add(new ListItem("==请选择==", ""));
if (elist.Count > 0)
{
foreach (Expert e in elist)
{
dpExpert.Items.Add(new ListItem(e.EName, e.ExpertID.ToString()));
}
}
IList <Project> plist = bp.GetProjectsList(qp);
dpProject.Items.Clear();
dpProject.Items.Add(new ListItem("==请选择==", ""));
if (plist.Count > 0)
{
foreach (Project p in plist)
{
dpProject.Items.Add(new ListItem(p.ProjectName, p.ProjectID.ToString()));
}
}
IList <Member> lmlist = bm.GetMembersList(qm).Where(t => t.MemberType == MemberType.联盟成员.ToString()).ToList();
dpLm.Items.Clear();
dpLm.Items.Add(new ListItem("==请选择==", ""));
if (lmlist.Count > 0)
{
foreach (Member m in lmlist)
{
dpLm.Items.Add(new ListItem(m.MemberName, m.MemberID.ToString()));
}
}
IList <Member> tdlist = bm.GetMembersList(qm).Where(t => t.MemberType == MemberType.团队成员.ToString()).ToList();
dpTd.Items.Clear();
dpTd.Items.Add(new ListItem("==请选择==", ""));
if (tdlist.Count > 0)
{
foreach (Member m in tdlist)
{
dpTd.Items.Add(new ListItem(m.MemberName, m.MemberID.ToString()));
}
}
}
public static IList <Expert> GetExpertsByPageIndex(string pageindex)
{
{
BExpert be = new BExpert();
Query q = new Query();
q.OrderBy("Istop desc,Sort");
int PageIndex = Utils.StrToInt(pageindex, 0);
int rec = 0;
IList <Expert> elist = be.GetExpertsList(q, PageIndex, 4, out rec);
foreach (Expert ex in elist)
{
ex.ESummary = Utils.CutString(ex.ESummary, 20);
}
return(elist);
}
}
private void BindingList()
{
Query qm = Query.Build(new { SortFields = "IsTop, Sort" });
string Name = PubCom.CheckString(txtExpertName.Text.Trim());
if (Title != "")
{
qm.Add("EName", Name);
}
string country = PubCom.CheckString(txtCountry.Text.Trim());
if (country != "")
{
qm.Add("ECountry", country);
}
if (dpIsTop.SelectedValue != "")
{
qm.Append(dpIsTop.SelectedValue == "0" ? "IsTop=0" : "IsTop=1 or IsTop is null");
}
int ret = 0;
rplist.DataSource = be.GetExpertsList(qm, AspNetPager1.CurrentPageIndex, AspNetPager1.PageSize, out ret);
rplist.DataBind();
AspNetPager1.RecordCount = ret;
// 插入日志 query
SysOperateLog log = new SysOperateLog();
log.LogID = StringHelper.getKey();
log.LogType = LogType.专家信息.ToString();
log.OperateUser = GetLogUserName();
log.OperateDate = DateTime.Now;
log.LogOperateType = "专家查询";
log.LogAfterObject = JsonHelper.Obj2Json <string>(qm.GetCondition(true));
bsol.Insert(log);
}
//还是通过ajax来做吧
private void BindDetail()
{
Query q = new Query();
q.OrderBy("Istop desc,Sort");
q.Append("EIdentification='" + ExpertType.普通专家 + "'");
IList <Expert> exlist = new List <Expert>();
int rec = 0;
rplist_new.DataSource = be.GetExpertsList(q, 1, 4, out rec);
rplist_new.DataBind();
hfrec.Value = rec.ToString();
hfPicFilePathV.Value = PicFilePathV;
if (rec <= 4)
{
showmore.Visible = false;
}
//显示四个静态数据
Query qn = new Query();
qn.OrderBy("SubmitTime desc");
qn.Append("StaticType='" + StaticType.知识建构理论 + "' or StaticType='" + StaticType.关于手段 + "' or StaticType='" +
StaticType.关于社区 + "' or StaticType='" + StaticType.关于观点 + "'");
IList <New> nlist = bn.GetNewsTitleList(qn);
New n1 = nlist.FirstOrDefault(p => p.StaticType == StaticType.知识建构理论.ToString());
hfnew1.Value = Utils.ObjectToStr(n1?.NewsID);
ltjgsummary.Text = Utils.CutString(n1?.summary, 500);
New n2 = nlist.FirstOrDefault(p => p.StaticType == StaticType.关于手段.ToString());
hfnew2.Value = Utils.ObjectToStr(n2?.NewsID);
New n3 = nlist.FirstOrDefault(p => p.StaticType == StaticType.关于观点.ToString());
hfnew3.Value = Utils.ObjectToStr(n3?.NewsID);
New n4 = nlist.FirstOrDefault(p => p.StaticType == StaticType.关于社区.ToString());
hfnew4.Value = Utils.ObjectToStr(n4?.NewsID);
}
void BindDropDownList()
{
// 绑定语言和类型
dpArticleType.Items.Clear();
dpArticleType.Items.Add(new ListItem("==请选择==", ""));
Query q = Query.Build(new { SortFields = "SortNo" });
q.Append("CodeName='ArticleType' or CodeName='Language'");
IList <SysCode> sclisttype = bsc.GetSysCodeList(q).Where(t => t.CodeName == "ArticleType").ToList();
IList <SysCode> sclistlan = bsc.GetSysCodeList(q).Where(t => t.CodeName == "Language").ToList();
if (sclisttype.Count > 0)
{
foreach (SysCode sc in sclisttype)
{
dpArticleType.Items.Add(new ListItem(sc.CodeText, sc.CodeValue));
}
}
dpLanguage.Items.Clear();
dpLanguage.Items.Add(new ListItem("==请选择==", ""));
if (sclistlan.Count > 0)
{
foreach (SysCode sc in sclistlan)
{
dpLanguage.Items.Add(new ListItem(sc.CodeText, sc.CodeValue));
}
}
//绑定 专家，项目，联盟成员，团队成员，普通学生
Query qe = Query.Build(new { SortFields = "ExpertID" });
Query qp = Query.Build(new { SortFields = "ProjectID" });
Query qm = Query.Build(new { SortFields = "MemberID" });
IList <Expert> elist = be.GetExpertsList(qe);
dpExpert.Items.Clear();
dpExpert.Items.Add(new ListItem("==请选择==", ""));
if (elist.Count > 0)
{
foreach (Expert e in elist)
{
dpExpert.Items.Add(new ListItem(e.EName, e.ExpertID.ToString()));
}
}
IList <Project> plist = bp.GetProjectsList(qp);
dpProject.Items.Clear();
dpProject.Items.Add(new ListItem("==请选择==", ""));
if (plist.Count > 0)
{
foreach (Project p in plist)
{
dpProject.Items.Add(new ListItem(p.ProjectName, p.ProjectID.ToString()));
}
}
IList <Member> lmlist = bm.GetMembersList(qm).Where(t => t.MemberType == MemberType.联盟成员.ToString()).ToList();
dpLm.Items.Clear();
dpLm.Items.Add(new ListItem("==请选择==", ""));
if (lmlist.Count > 0)
{
foreach (Member m in lmlist)
{
dpLm.Items.Add(new ListItem(m.MemberName, m.MemberID.ToString()));
}
}
IList <Member> tdlist = bm.GetMembersList(qm).Where(t => t.MemberType == MemberType.团队成员.ToString()).ToList();
dpTd.Items.Clear();
dpTd.Items.Add(new ListItem("==请选择==", ""));
if (tdlist.Count > 0)
{
foreach (Member m in tdlist)
{
dpTd.Items.Add(new ListItem(m.MemberName, m.MemberID.ToString()));
}
}
//新添加的博士啊，硕士啊
IList <Member> stulist = bm.GetMembersList(qm).Where(t => t.MemberType == MemberType.普通学生.ToString()).ToList();
dpstu.Items.Clear();
dpstu.Items.Add(new ListItem("==请选择==", ""));
if (stulist.Count > 0)
{
foreach (Member m in stulist)
{
dpstu.Items.Add(new ListItem(m.MemberName, m.MemberID.ToString()));
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
BindStu();
//绑定校内专家
Query q = new Query();
q.OrderBy("Istop desc,Sort");
q.Append("EIdentification='" + ExpertType.校内专家 + "'");
int rec = 0;
IList <Expert> elist = be.GetExpertsList(q, 1, 4, out rec);
ltexpertname1.Text = elist[0].EName;
ltcountry1.Text = elist[0].ECountry;
ltsummary1.Text = Utils.CutString(elist[0].ESummary, 20);
if (elist[0].EPicPath != null)
{
img1.Attributes["src"] = PicFilePathV + elist[0].EPicPath;
}
Query qatta1 = new Query();
qatta1.OrderBy("Views desc, Downloads desc");
qatta1.Append("e.ExpertID=" + elist[0].ExpertID);
int recatta1;
rplist1.DataSource = ba.GetArticlesList(qatta1, 1, 6, out recatta1);
rplist1.DataBind();
ltexpertname2.Text = elist[1].EName;
ltcountry2.Text = elist[1].ECountry;
ltsummary2.Text = Utils.CutString(elist[1].ESummary, 20);
if (elist[1].EPicPath != null)
{
img2.Attributes["src"] = PicFilePathV + elist[1].EPicPath;
}
Query qatta2 = new Query();
qatta2.OrderBy("Views desc, Downloads desc");
qatta2.Append("e.ExpertID=" + elist[1].ExpertID);
int recatta2;
rplist2.DataSource = ba.GetArticlesList(qatta2, 1, 6, out recatta2);
rplist2.DataBind();
ltexpertname3.Text = elist[2].EName;
ltcountry3.Text = elist[2].ECountry;
ltsummary3.Text = Utils.CutString(elist[2].ESummary, 20);
if (elist[2].EPicPath != null)
{
img3.Attributes["src"] = PicFilePathV + elist[2].EPicPath;
}
Query qatta3 = new Query();
qatta3.OrderBy("Views desc, Downloads desc");
qatta3.Append("e.ExpertID=" + elist[2].ExpertID);
int recatta3;
rplist3.DataSource = ba.GetArticlesList(qatta3, 1, 6, out recatta3);
rplist3.DataBind();
ltexpertname4.Text = elist[3].EName;
ltcountry4.Text = elist[3].ECountry;
ltsummary4.Text = Utils.CutString(elist[3].ESummary, 20);
if (elist[3].EPicPath != null)
{
img4.Attributes["src"] = PicFilePathV + elist[3].EPicPath;
}
Query qatta4 = new Query();
qatta4.OrderBy("Views desc, Downloads desc");
qatta4.Append("e.ExpertID=" + elist[3].ExpertID);
int recatta4;
rplist4.DataSource = ba.GetArticlesList(qatta4, 1, 6, out recatta4);
rplist4.DataBind();
}
}
