예제 #1
0
        public IEnumerable <TicketModels> ApproveTicket(Detail data)
        {
            List <TicketModels> results = new List <TicketModels>();

            try
            {
                IQueryable <WebAPI.DATA.TicketLE.VW_TICKET> View_Ticket;
                var seach = data.seach;
                var type  = data.type;

                UserDataContext     Con = new UserDataContext();
                TicketLEDataContext db  = new TicketLEDataContext();

                TicketModels value = new TicketModels();

                //value.Type = new SelectList(db.MAS_SSes, "SS_ID", "SS_NAME");

                var User = (from xx in Con.MAS_USERs
                            join yy in Con.MAS_DEPs on xx.D_ID equals yy.DP_ID
                            where xx.STCODE == data.STCODE
                            select new { xx, yy }).FirstOrDefault();

                //value.DP = User.xx.D_ID;

                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.STATUS == "1").Where(s => s.FLAG == "1").Where(s => s.APPROVE_ID == 1).Where(s => s.DPCODE == User.yy.DPCODE).OrderBy(s => s.STATUS);

                    List <Ticket> ticketsAns = new List <Ticket>();

                    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;

                        ticketsAns.Add(ux);
                    }

                    value.TicketDetail = ticketsAns;
                }

                //value.WordSearch = seach;
                //value.typeSearch = type;

                results.Add(value);
            }
            catch (Exception ex)
            {
                //Detail res = new Detail();
                //res.status = "F";
                //res.message = ex.Message;
                //results.Add(res);
            }

            return(results.ToArray());
        }
예제 #2
0
        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());
        }