//将待办事项数据加入到集合中 private void AddEntryViewToList(List <QuickEntryViewModel> ltEntry, IQueryable <WFInstance> instances) { var uuList = UserInfoBll.GetList <long>(u => true).ToList(); if (instances != null && instances.Count() > 0) { foreach (var item in instances) { string rejectBy = item.SubBy + ""; var subBy = uuList.Where(uu => uu.UserId == long.Parse(rejectBy)).FirstOrDefault(); if (item.InstanceState == 2) { //已完成 continue; } else if (item.InstanceState == 1) { //驳回 rejectBy = item.WFStep.OrderByDescending(s => s.StepId).FirstOrDefault().SubBy.ToString(); } ltEntry.Add(new QuickEntryViewModel() { InstanceId = item.InstanceId, InstanceTitle = item.InstanceTitle, InstanceState = item.InstanceState, SubBy = subBy.RealName != null && subBy.RealName != "" ? subBy.RealName : subBy.Username }); } } }
//获取分页数据 public ActionResult GetApprove() { long searchId; bool isId = long.TryParse(Request["searchId"], out searchId); string searchName = string.IsNullOrEmpty(Request["searchName"]) ? string.Empty : Request["searchName"]; DateTime from, to; bool fromIsDate = DateTime.TryParse(Request["from"], out from); bool toIsDate = DateTime.TryParse(Request["to"], out to); string fromStr = from.ToString("yyyy-MM-dd HH:mm:ss"); string toStr = to.ToString("yyyy-MM-dd") + " 23:59:59"; int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1; int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5; int totalCount; var stepList = WFStepBll.GetPageList <long>(s => (s.NextId == UserLogin.UserId) && (s.IsEnd == 0) && (isId ? s.InstanceId == searchId : true) && (searchName != string.Empty ? s.WFInstance.InstanceTitle.Contains(searchName) : true) && (fromIsDate ? fromStr.CompareTo(s.WFInstance.SubTime) <= 0 : true) && (toIsDate ? toStr.CompareTo(s.WFInstance.SubTime) >= 0 : true), s => s.InstanceId, false, pageIndex, pageSize, out totalCount); var uList = UserInfoBll.GetList <int>(us => true); var result = from i in stepList from uu in uList where i.SubBy == uu.UserId select new { StepId = i.StepId, InstanceId = i.InstanceId, InstanceTitle = i.WFInstance.InstanceTitle, Details = i.WFInstance.Details, Remark = i.WFInstance.Remark, SubTime = i.SubTime, SubBy = uu.RealName != null && uu.RealName != "" ? uu.RealName : uu.Username }; return(Json(new { total = totalCount, rows = result }, JsonRequestBehavior.AllowGet)); }
private void button1_Click(object sender, EventArgs e) { if (htmlDoc == null) { MessageBox.Show("没有获取到网页内容!"); this.webBrowser1.Url = new Uri("http://www.haiguan.info/onlinesearch/gateway/Gatewaystate.aspx"); //等待加载完毕 while (webBrowser1.ReadyState < WebBrowserReadyState.Complete) { Application.DoEvents(); } htmlDoc = this.webBrowser1.Document; return; } try { list = miBll.GetList(); } catch (Exception ex) { MessageBox.Show("数据库连接异常!" + ex);; } button1.Enabled = false; timer1.Interval = 2000; timer1.Enabled = true; timer1.Tick += new EventHandler(timer1EventProcessor);//添加事件 timer2.Interval = 2000; timer2.Enabled = true; timer2.Tick += new EventHandler(timer2EventProcessor);//添加事件 timer2.Stop(); }
//获取分页数据 public ActionResult GetPageList() { long searchId; bool isId = long.TryParse(Request["searchId"], out searchId); string searchName = string.IsNullOrEmpty(Request["searchName"]) ? string.Empty : Request["searchName"]; DateTime from, to; bool fromIsDate = DateTime.TryParse(Request["from"], out from); bool toIsDate = DateTime.TryParse(Request["to"], out to); bool showAll = !string.IsNullOrEmpty(Request["show"]); int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1; int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5; int totalCount; WhereHelper <WFInstance> wh = new WhereHelper <WFInstance>(); //wh.Equal("IsDeleted", (byte)0); if (!showAll) { wh.Equal("SubBy", UserLogin.UserId); } if (isId) { wh.Equal("InstanceId", searchId); } if (searchName != string.Empty) { wh.Contains("InstanceTitle", searchName); } if (fromIsDate) { wh.StrGreater("SubTime", from.ToString("yyyy-MM-dd HH:mm:ss")); } if (toIsDate) { wh.StrLess("SubTime", to.ToString("yyyy-MM-dd") + " 23:59:59"); } var InstanceList = WFInstanceBll.GetPageList <long>(wh.GetExpression(), i => i.InstanceId, false, pageIndex, pageSize, out totalCount); var uList = UserInfoBll.GetList <int>(us => true); var result = from i in InstanceList from uu in uList where i.SubBy == uu.UserId select new { UserId = UserLogin.UserId, SubId = i.SubBy, InstanceId = i.InstanceId, InstanceTitle = i.InstanceTitle, InstanceState = i.InstanceState, Details = i.Details, Remark = i.Remark, SubTime = i.SubTime, SubBy = uu.RealName != null && uu.RealName != "" ? uu.RealName : uu.Username, RejectMsg = i.RejectMsg }; return(Json(new { total = totalCount, rows = result }, JsonRequestBehavior.AllowGet)); }
//获取分页数据 public ActionResult GetPageList() { //预处理搜索条件 long searchId; bool isId = long.TryParse(Request["searchId"], out searchId); string searchName = string.IsNullOrEmpty(Request["searchName"]) ? string.Empty : Request["searchName"]; DateTime from, to; bool fromIsDate = DateTime.TryParse(Request["from"], out from); bool toIsDate = DateTime.TryParse(Request["to"], out to); int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1; int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5; //进行分页查询 int totalCount; WhereHelper <ActionInfo> wh = new WhereHelper <ActionInfo>(); wh.Equal("IsDeleted", (byte)0); if (isId) { wh.Equal("ActionId", searchId); } if (searchName != string.Empty) { wh.Contains("ActionTitle", searchName); } if (fromIsDate) { wh.StrGreater("AddTime", from.ToString("yyyy-MM-dd HH:mm:ss")); } if (toIsDate) { wh.StrLess("AddTime", to.ToString("yyyy-MM-dd") + " 23:59:59"); } var actionList = ActionInfoBll.GetPageList <long>(wh.GetExpression(), a => a.ActionId, false, pageIndex, pageSize, out totalCount); var uList = UserInfoBll.GetList <int>(us => true); //构造新匿名对象防止导航属性循环引用 var result = from a in actionList from uu in uList where a.SubBy == uu.UserId select new { ActionId = a.ActionId, ActionTitle = a.ActionTitle, IsMenu = a.IsMenu, ControllerName = a.ControllerName, ActionName = a.ActionName, Remark = a.Remark, AddTime = a.AddTime, ModifiedTime = a.ModifiedTime, SubBy = uu.RealName != null && uu.RealName != "" ? uu.RealName : uu.Username }; return(Json(new { total = totalCount, rows = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult CheckExist(string uName) { string result = "no"; var temp = UserInfoBll.GetList <long>(u => (u.IsDeleted == 0) && (u.Username == uName)).FirstOrDefault(); if (temp == null) { result = "ok"; } return(Content(result)); }
//获取分页数据 public ActionResult GetPageList() { long searchId; bool isId = long.TryParse(Request["searchId"], out searchId); string searchName = string.IsNullOrEmpty(Request["searchName"]) ? string.Empty : Request["searchName"]; DateTime from, to; bool fromIsDate = DateTime.TryParse(Request["from"], out from); bool toIsDate = DateTime.TryParse(Request["to"], out to); int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1; int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5; int totalCount; WhereHelper <RoleInfo> wh = new WhereHelper <RoleInfo>(); wh.Equal("IsDeleted", (byte)0); if (isId) { wh.Equal("RoleId", searchId); } if (searchName != string.Empty) { wh.Contains("RoleName", searchName); } if (fromIsDate) { wh.StrGreater("AddTime", from.ToString("yyyy-MM-dd HH:mm:ss")); } if (toIsDate) { wh.StrLess("AddTime", to.ToString("yyyy-MM-dd") + " 23:59:59"); } var roleList = RoleInfoBll.GetPageList <long>(wh.GetExpression(), u => u.RoleId, false, pageIndex, pageSize, out totalCount); //var roleList = RoleInfoBll.GetPageList<long>(r => (r.IsDeleted == 0) && (isId ? r.RoleId == searchId : true) && (searchName != string.Empty ? r.RoleName.Contains(searchName) : true) && (formIsDate ? from.CompareTo(r.AddTime) < 0 : true) && (toIsDate ? to.CompareTo(r.AddTime) > 0 : true), r => r.RoleId, false, pageIndex, pageSize, out totalCount); var uList = UserInfoBll.GetList <int>(us => true); var result = from r in roleList from uu in uList where r.SubBy == uu.UserId select new RoleViewModel { RoleId = r.RoleId, RoleName = r.RoleName, Remark = r.Remark, AddTime = r.AddTime, ModifiedTime = r.ModifiedTime, SubBy = uu.RealName != null && uu.RealName != "" ? uu.RealName : uu.Username }; return(Json(new { total = totalCount, rows = result })); }
//获取分页数据 public ActionResult GetPageList() { long searchId; bool isId = long.TryParse(Request["searchId"], out searchId); string searchName = string.IsNullOrEmpty(Request["searchName"]) ? string.Empty : Request["searchName"]; DateTime from, to; bool fromIsDate = DateTime.TryParse(Request["from"], out from); bool toIsDate = DateTime.TryParse(Request["to"], out to); int pageIndex = Request["page"] != null?int.Parse(Request["page"]) : 1; int pageSize = Request["rows"] != null?int.Parse(Request["rows"]) : 5; int totalCount; WhereHelper <WFModel> wh = new WhereHelper <WFModel>(); wh.Equal("IsDeleted", (byte)0); if (isId) { wh.Equal("ModelId", searchId); } if (searchName != string.Empty) { wh.Contains("ModelTitle", searchName); } if (fromIsDate) { wh.StrGreater("AddTime", from.ToString("yyyy-MM-dd HH:mm:ss")); } if (toIsDate) { wh.StrLess("AddTime", to.ToString("yyyy-MM-dd") + " 23:59:59"); } var modelList = WFModelBll.GetPageList <long>(wh.GetExpression(), m => m.ModelId, false, pageIndex, pageSize, out totalCount); var uList = UserInfoBll.GetList <int>(us => true); var result = from m in modelList from uu in uList where m.SubBy == uu.UserId select new WFViewModel { ModelId = m.ModelId, ModelTitle = m.ModelTitle, ControllerName = m.ControllerName, ActionName = m.ActionName, Remark = m.Remark, AddTime = m.AddTime, ModifiedTime = m.ModifiedTime, SubBy = uu.RealName != null && uu.RealName != "" ? uu.RealName : uu.Username }; return(Json(new { total = totalCount, rows = result }, JsonRequestBehavior.AllowGet)); }
//绑定列表数据 protected void BindRpt() { int totalRecord = 0; //总记录条数 int pageIndex = Request["pageindex"] == null ? 1 : Convert.ToInt32(Request["pageindex"]); //当前页码 int pageSize = 15; //每页条数 string parms = ""; //传递给下一页的条件 string sql = GetSql(out parms); //传递给SQL的查询条件 UserInfoBll bll = new UserInfoBll(); DataTable list = bll.GetList(pageIndex, pageSize, sql, out totalRecord); PagingHelper pa = new PagingHelper(pageIndex, pageSize, totalRecord, "UserList.aspx", parms, 10); pagetext = pa.CreatePageHtml();//生成分页html if (list != null) { this.rptList.DataSource = list; this.rptList.DataBind(); } }
//验证输入合法性 public ActionResult CheckInput() { string result = "no"; if (string.IsNullOrEmpty(Request["regId"])) { string ifyCode = Request["ifyCode"] == null ? string.Empty : Request["ifyCode"].ToLower(); if (ifyCode.Equals(Session["RegValidCode"].ToString(), StringComparison.InvariantCultureIgnoreCase)) { result = "ok"; } } else if (string.IsNullOrEmpty(Request["ifyCode"])) { string regId = Request["regId"]; if (UserInfoBll.GetList <int>(u => (u.IsDeleted == 0) && (u.Username == regId)).FirstOrDefault() == null) { result = "ok"; } } return(Content(result)); }