public IEnumerable <Ticket> Ticketlist(Detail data) { List <Ticket> results = new List <Ticket>(); try { IQueryable <DATA.TicketLE.VW_TICKET> View_Ticket; var seach = data.seach; var type = data.type; UserDataContext Con = new UserDataContext(); TicketLEDataContext db = new TicketLEDataContext(); List <Ticket> lstTicket = new List <Ticket>(); var User = (from xx in Con.MAS_USERs where xx.STCODE == data.STCODE select xx).FirstOrDefault(); using (TicketLEDataContext Context = new TicketLEDataContext()) { View_Ticket = Context.VW_TICKETs.Where(s => s.TICKETNO.Contains(seach) || s.DPCODE.Contains(seach) || s.NICKNAME.Contains(seach)).Where(s => s.FLAG == "1").OrderBy(s => s.STATUS); if (type != "") { View_Ticket = View_Ticket.Where(tik => tik.STATUS == type); } if (User.D_ID != 10) { View_Ticket = View_Ticket.Where(s => s.STCODE == data.STCODE); foreach (var item in View_Ticket) { Ticket ux = new Ticket(); ux.ID = item.ID; ux.TICKETNO = item.TICKETNO; ux.DETAIL = item.DETEIL; ux.CREATEDATE = DateTime.Parse(item.WORKDATE.ToString()).ToShortDateString(); ux.CREATETIME = DateTime.Parse(item.WORKDATE.ToString()).ToLongTimeString(); ux.CRE_NICKNAME = item.NICKNAME; ux.DEP = item.DPCODE; ux.SSID = Int32.Parse(item.STATUS); ux.SSNAME = item.SS_NAME; lstTicket.Add(ux); } } else { if (User.A_ID == 3) { View_Ticket = View_Ticket.Where(s => s.STCODE == data.STCODE); } else { View_Ticket = View_Ticket.Where(s => s.APPROVE_ID >= 2); } foreach (var item in View_Ticket) { Ticket ux = new Ticket(); ux.ID = item.ID; ux.TICKETNO = item.TICKETNO; ux.DETAIL = item.DETEIL; ux.CREATEDATE = DateTime.Parse(item.WORKDATE.ToString()).ToShortDateString(); ux.CREATETIME = DateTime.Parse(item.WORKDATE.ToString()).ToLongTimeString(); ux.CRE_NICKNAME = item.NICKNAME; ux.DEP = item.DPCODE; ux.SSID = Int32.Parse(item.STATUS); ux.SSNAME = item.SS_NAME; lstTicket.Add(ux); } } results = lstTicket; } } catch (Exception ex) { //AnsOP res = new AnsOP(); //res.status = "F"; //res.message = ex.Message; //results.Add(res); } return(results.ToArray()); }
// GET: Ticket public ActionResult Index(int page = 1, string seach = "", string type = "") { if (!chkSesionUser()) { return(RedirectToAction("Login", "Login", new { returnUrl = "~/Ticket/Index" })); } IQueryable <VW_TICKET> View_Ticket; //OnUser usr = new OnUser(); //usr = getUser(userOnline); seach = seach.Trim(); //NName = NName.Trim(); type = type.Trim(); //TicketModel TicketList = new TicketModel(); data_userDataContext Con = new data_userDataContext(); DB_LEDataContext db = new DB_LEDataContext(); ViewBag.Type = new SelectList(db.MAS_SSes, "SS_ID", "SS_NAME"); var User = (from xx in Con.MAS_USERs where xx.STCODE == userOnline select xx).FirstOrDefault(); ViewBag.DP = User.D_ID; ViewBag.A_ID = User.A_ID; List <Ticket> lstTicket = new List <Ticket>(); using (DB_LEDataContext Context = new DB_LEDataContext()) { View_Ticket = Context.VW_TICKETs.Where(s => s.TICKETNO.Contains(seach) || s.DPCODE.Contains(seach) || s.Recieve.Contains(seach)).Where(s => s.FLAG == "1").OrderByDescending(s => s.STATUS).ThenByDescending(s => s.ID); if (type != "") { View_Ticket = View_Ticket.Where(tik => tik.STATUS == type); } if (User.D_ID != 10) { View_Ticket = View_Ticket.Where(s => s.STCODE == userOnline); foreach (var item in View_Ticket) { Ticket ux = new Ticket(); ux.ID = item.ID; ux.TICKETNO = item.TICKETNO; ux.DETAIL = item.DETAIL; ux.CREATEDATE = DateTime.Parse(item.S_DATE.ToString()).ToShortDateString(); ux.CREATETIME = DateTime.Parse(item.E_DATE.ToString()).ToShortDateString(); ux.CRE_NICKNAME = item.CREATENAME; ux.DEP = item.DPCODE; ux.SSID = int.Parse(item.STATUS); ux.SSNAME = item.SS_NAME; ux.TicketName = item.TITLE; ux.TICKETRECIEVE = item.Recieve; if (item.F_DATE.ToString() != "") { ux.TICKETFDATE = DateTime.Parse(item.F_DATE.ToString()).ToShortDateString(); } lstTicket.Add(ux); } } else { if (User.A_ID == 3) { View_Ticket = View_Ticket.Where(s => s.STCODE == userOnline); } else { //View_Ticket = View_Ticket.Where(s => s.APPROVE_ID >= 2); } foreach (var item in View_Ticket) { Ticket ux = new Ticket(); ux.ID = item.ID; ux.TICKETNO = item.TICKETNO; ux.DETAIL = item.DETAIL; ux.CREATEDATE = DateTime.Parse(item.S_DATE.ToString()).ToShortDateString(); ux.CREATETIME = DateTime.Parse(item.E_DATE.ToString()).ToShortDateString(); ux.CRE_NICKNAME = item.CREATENAME; ux.DEP = item.DPCODE; ux.SSID = int.Parse(item.STATUS); ux.SSNAME = item.SS_NAME; ux.TicketName = item.TITLE; lstTicket.Add(ux); } } //TicketList.TicketDetail = lstTicket; } //return View(lstTicket); //return View(lstTicket.ToPagedList(page, 10)); ViewBag.WordSearch = seach; ViewBag.typeSearch = type; return(View(lstTicket.ToPagedList(page, 10))); }
public IEnumerable <Ticket> Ticketlist(Detail data) { List <Ticket> results = new List <Ticket>(); try { IQueryable <VW_TICKET> View_Ticket; var seach = data.seach.Trim(); var type = data.type.Trim(); TicketOPDataContext Context = new TicketOPDataContext(); UserDataContext C_user = new UserDataContext(); List <Ticket> lstTicket = new List <Ticket>(); //string a = userOnline; if (data.Pos == "1") { var queryX = Context.MAS_WHs.Where(x => x.WHCODE == data.STCODE).FirstOrDefault(); //ViewBag.BRAND = queryX.BRAND; View_Ticket = Context.VW_TICKETs .Where(tik => tik.WHCODE == data.STCODE) .Where(tik => tik.AREA.Contains(seach) || tik.WHNAME.Contains(seach) || tik.TICKETNO.Contains(seach)) .Where(tik => tik.FLAG == "0") .OrderBy(tik => tik.SS_ID); } else { var sql = C_user.VW_USER_ALLs.Where(x => x.STCODE == data.STCODE).FirstOrDefault(); //ViewBag.BRAND = sql.DPCODE; View_Ticket = Context.VW_TICKETs .Where(tik => tik.BRAND == sql.DPCODE) .Where(tik => tik.AREA.Contains(seach) || tik.WHNAME.Contains(seach) || tik.TICKETNO.Contains(seach)) .Where(tik => tik.FLAG == "0") .OrderBy(tik => tik.SS_ID); } if (type != "") { View_Ticket = View_Ticket.Where(tik => tik.TNAME == type); } foreach (var ux in View_Ticket) { Ticket _ticket = new Ticket(); _ticket.TK_ID = ux.TK_ID; _ticket.TICKETNO = ux.TICKETNO; _ticket.WHCODE = ux.WHCODE; _ticket.WHNAME = ux.WHNAME; _ticket.AREA = ux.AREA; _ticket.DETAIL = ux.DETAIL; _ticket.SS_ID = ux.SS_ID; _ticket.ST_NAME = ux.TNAME; _ticket.REC_NICKNAME = ux.NICKNAME; _ticket.CREATEDATE = DateTime.Parse(ux.CREATEDATE.ToString()).ToShortDateString(); _ticket.CREATETIME = ux.CREATETIME.ToString(); lstTicket.Add(_ticket); } results = lstTicket; } catch (Exception ex) { //AnsOP res = new AnsOP(); //res.status = "F"; //res.message = ex.Message; //results.Add(res); } return(results.ToArray()); }