public ActionResult Index(string snam, string orgid, string orgnam, int pageIndex = 1, int pageSize = 20)
{
ViewBag.SNAM = snam;
ViewBag.ORGID = orgid;
ViewBag.ORGNAM = orgnam;
var orgall = new SYS_USER_DAL().GetUserORG(UserState.UserID);
if (string.IsNullOrEmpty(orgid) && orgall != null)
{
orgid = orgall.FirstOrDefault(obj => obj.ORG_LEVEL == 4).ORG_ID;
}
ViewBag.UserORG = new SelectList(orgall.Where(obj => obj.ORG_LEVEL == 4)
, "ORG_ID", "ORG_NAM", orgid);
var orgs = orgall.Select(obj => obj.ORG_ID);
if (!string.IsNullOrEmpty(orgid))
{
orgs = orgs.Where(obj => obj == orgid);
if (null == orgs || orgs.Count() == 0)
{
orgs = new List <string> {
"-1"
};
}
}
var halllist = DaoHall.FindList("", "ORG_ID in", orgs);
var data = dao.GetList(pageIndex, pageSize, "Q_ID desc", "Q_SERIALNAME like", snam, "Q_SYSNO in", null == halllist ? null : halllist.Select(obj => obj.HALL_NO));
if (data != null && data.Items != null)
{
halllist = DaoHall.FindList();
var orglist = DaoOrganize.FindList();
foreach (var item in data.Items)
{
item.Hall = halllist.FirstOrDefault(obj => obj.HALL_NO == item.Q_SYSNO);
item.Org = orglist.FirstOrDefault(obj => obj.ORG_ID == item.Hall.ORG_ID);
}
}
return(View(data));
}
public ActionResult Index(string nam, string orgid, string orgnam, int?stafftype, int pageIndex = 1, int pageSize = 20)
{
ViewBag.NAM = nam;
ViewBag.ORGID = orgid;
ViewBag.ORGNAM = orgnam;
ViewBag.STAFFTYP = stafftype;
var orgall = new SYS_USER_DAL().GetUserORG(UserState.UserID);
if (string.IsNullOrEmpty(orgid) && orgall != null)
{
orgid = orgall.FirstOrDefault(obj => obj.ORG_LEVEL == 4).ORG_ID;
}
ViewBag.UserORG = new SelectList(orgall.Where(obj => obj.ORG_LEVEL == 4)
, "ORG_ID", "ORG_NAM", orgid);
GetCreateDT(orgid);
var orgs = orgall.Select(obj => obj.ORG_ID);
if (!string.IsNullOrEmpty(orgid))
{
orgs = orgs.Where(obj => obj == orgid);
if (null == orgs || orgs.Count() == 0)
{
orgs = new List <string> {
"-1"
};
}
}
var data = dao.GetList(pageIndex, pageSize, "", "STAFF_NAM like", nam
, "ORG_ID in", orgs, "STAFF_TYP", stafftype);
var orglist = DaoOrganize.FindList();
foreach (var item in data.Items)
{
item.ORG = orglist.FirstOrDefault(obj => obj.ORG_ID == item.ORG_ID);
}
return(View(data));
}