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(); } }