//将待办事项数据加入到集合中
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));
}
