Esempio n. 1
0
        public ActionResult RequireBidding(String id)
        {
            VMRequire Require = new VMRequire();
            var       list    = require.RequireAuditing(id);

            Require.InsShelftype     = list.InsShelftype;
            Require.InsTonnage       = list.InsTonnage;
            Require.InsTonUnit       = list.InsTonUnit;
            Require.Insplace         = list.Insplace;
            Require.InsStartDate     = list.InsStartDate;
            Require.InsCycle         = list.InsCycle;
            Require.InsCycleUnit     = list.InsCycleUnit;
            Require.InsHeight        = list.InsHeight;
            Require.InsHghUnit       = list.InsHghUnit;
            Require.InsBeamHgh       = list.InsBeamHgh;
            Require.InsStyHghUnit    = list.InsStyHghUnit;
            Require.InsAtticLayer    = list.InsAtticLayer;
            Require.InsForkExtension = list.InsForkExtension;
            Require.InsStretchCom    = list.InsStretchCom;
            Require.InsMoney         = list.InsMoney;
            Require.InsMoneyCom      = list.InsMoneyCom;
            Require.InsName          = list.InsName;
            Require.InsPhone         = list.InsPhone;
            Require.InsRemark        = list.InsRemark;
            Require.offerlist        = JsonConvert.SerializeObject(RequireMapper.Offerlist(require.RequireBidding(id)));
            Require.count            = require.RequiresBidding(id);
            Require.NowPage          = 0;
            Require.AllPage          = Pag.SumPage(Require.count, 10);
            Require.NewPage          = (Require.AllPage == 0) ? 0 : Require.NowPage + 1;
            return(View(Require));
        }
Esempio n. 2
0
        public IHttpActionResult PutPag(int id, Pag pag)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            if (id != pag.id)
            {
                return(BadRequest());
            }

            db.Entry(pag).State = EntityState.Modified;

            try
            {
                db.SaveChanges();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!PagExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(StatusCode(HttpStatusCode.NoContent));
        }
Esempio n. 3
0
        public ActionResult DeleteConfirmed(int codp, int annop)
        {
            Pag pag = db.Pag.Find(codp, annop);

            db.Pag.Remove(pag);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Esempio n. 4
0
        // GET: Pags/Details/5
        public ActionResult Details(int codp, int annop)
        {
            Pag pag = db.Pag.Find(codp, annop);

            if (pag == null)
            {
                return(HttpNotFound());
            }
            return(View(pag));
        }
Esempio n. 5
0
        public IHttpActionResult GetPag(int id)
        {
            Pag pag = db.Pags.Find(id);

            if (pag == null)
            {
                return(NotFound());
            }

            return(Ok(pag));
        }
Esempio n. 6
0
        public ActionResult SearchPost(VMRequire search)
        {
            VMRequire Require = new VMRequire();

            Require.OfferList = RequireMapper.Offerlist(require.RequireBidding(search.InstallID, search.NowPage));
            Require.count     = require.RequiresBidding(search.InstallID);
            Require.NowPage   = search.NowPage;
            Require.AllPage   = Pag.SumPage(Require.count, 10);
            Require.NewPage   = (Require.AllPage == 0) ? 0 : Require.NowPage + 1;
            return(Json(Require, JsonRequestBehavior.AllowGet));
        }
Esempio n. 7
0
        /// <summary>
        /// 查询日志列表
        /// </summary>
        /// <param name="filters"></param>
        /// <param name="start"></param>
        /// <param name="limit"></param>
        /// <returns></returns>
        public Pag <kh_examinesModel> GetMechExamList(List <Filter> filters, int start, int limit, int year, int month)
        {
            using (Entities db = new Entities())
            {
                string sql = @"SELECT exams.*, compan.companyname, contra.contractname, IFNULL(SUM(score.deduct),0) sumscore, users.displayname
FROM kh_examines exams LEFT JOIN yh_companys compan ON exams.companyid = compan.companyid LEFT JOIN yh_contracts contra ON exams.contractid = contra.contractid LEFT JOIN kh_scores score ON exams.examineid = score.examineid LEFT JOIN base_users users ON exams.createuserid = users.id
 where YEAR(exams.examinedate)=" + year + " and MONTH(exams.examinedate)=" + month + " GROUP BY exams.examineid";
                IEnumerable <kh_examinesModel> queryable = db.Database.SqlQuery <kh_examinesModel>(sql);
                if (filters != null && filters.Count > 0)
                {
                    foreach (Filter filter in filters)
                    {
                        string value = filter.value;
                        switch (filter.property)
                        {
                        case "companyname":
                            if (!string.IsNullOrEmpty(value))
                            {
                                queryable = queryable.Where(t => t.companyname == value);
                            }
                            break;

                        case "starttime":
                            if (!string.IsNullOrEmpty(value))
                            {
                                DateTime starttime = DateTime.Parse(value);
                                DateTime Etime     = starttime.AddDays(1);
                                queryable = queryable.Where(t => t.examinedate >= starttime && t.examinedate < Etime);
                            }
                            break;

                        case "endtime":
                            if (!string.IsNullOrEmpty(value))
                            {
                                DateTime endtime = DateTime.Parse(value);
                                DateTime Etime   = endtime.AddDays(1);
                                queryable = queryable.Where(t => t.examinedate >= endtime && t.examinedate < Etime);
                            }
                            break;

                        case "contractname":
                            if (!string.IsNullOrEmpty(value))
                            {
                                queryable = queryable.Where(t => t.contractname.Contains(value));
                            }
                            break;
                        }
                    }
                }
                IOrderedEnumerable <kh_examinesModel> temp = queryable.OrderByDescending(a => a.createtime);
                Pag <kh_examinesModel> rst = PagHelper.CreatPagList(temp, start, limit);
                return(rst);
            }
        }
Esempio n. 8
0
        public IHttpActionResult PostPag(Pag pag)
        {
            if (!ModelState.IsValid)
            {
                return(BadRequest(ModelState));
            }

            db.Pags.Add(pag);
            db.SaveChanges();

            return(CreatedAtRoute("DefaultApi", new { id = pag.id }, pag));
        }
Esempio n. 9
0
        public Pag <MonitorListModel> GetMonitorTableList(List <Filter> filters, int start, int limit, int unitid, string path)
        {
            using (Entities db = new Entities())
            {
                string sql = @"SELECT spe.unitid,
    unit.unitname,
    cam.cameraid,
	cam.cameraname,
	camt.cameratypename,
    cam.cameratypeid,
	spe.seq,
  unit.path,
unit.parentid
FROM
	fi_specialcameras spe
left JOIN fi_specialunits unit on spe.unitid=unit.unitid
LEFT JOIN fi_cameras cam ON spe.cameraid = cam.cameraid
LEFT JOIN fi_cameratypes camt ON cam.cameratypeid = camt.cameratypeid";

                string[] pathlist = path.Split('/');
                if (pathlist.Length == 3)
                {
                    if (pathlist[1] == "0")
                    {
                        sql += " where 1=1";
                    }
                    else
                    {
                        sql += " where unit.parentid=" + pathlist[1];
                    }
                }
                else if (unitid != 0)
                {
                    sql += " where spe.unitid=" + unitid;
                }
                else
                {
                    sql += "  where 1=1";
                }
                IEnumerable <MonitorListModel> queryable = db.Database.SqlQuery <MonitorListModel>(sql);
                if (filters != null && filters.Count > 0)
                {
                    foreach (Filter filter in filters)
                    {
                        string value = filter.value;
                    }
                }
                IOrderedEnumerable <MonitorListModel> temp = queryable.OrderByDescending(a => a.seq);
                Pag <MonitorListModel> rst = PagHelper.CreatPagList(temp, start, limit);
                return(rst);
            }
        }
Esempio n. 10
0
        public ActionResult Biding(String OfferID, String InstallID)
        {
            VMRequire Result = new VMRequire();

            require.RequireBiddingOffer(OfferID, OfferState.Yes);
            Result.msg       = "选择中标单位成功!";
            Result.OfferList = RequireMapper.Offerlist(require.RequireBidding(InstallID, 0));
            Result.count     = require.RequiresBidding(InstallID);
            Result.NowPage   = 0;
            Result.AllPage   = Pag.SumPage(Result.count, 10);
            Result.NewPage   = (Result.AllPage == 0) ? 0 : Result.NowPage + 1;
            return(Json(Result, JsonRequestBehavior.AllowGet));
        }
Esempio n. 11
0
        // GET: Pags/Delete/5
        public ActionResult Delete(int?codp, int?annop)
        {
            if (codp == null || annop == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Pag pag = db.Pag.Find(codp, annop);

            if (pag == null)
            {
                return(HttpNotFound());
            }
            return(View(pag));
        }
Esempio n. 12
0
        public IHttpActionResult DeletePag(int id)
        {
            Pag pag = db.Pags.Find(id);

            if (pag == null)
            {
                return(NotFound());
            }

            db.Pags.Remove(pag);
            db.SaveChanges();

            return(Ok(pag));
        }
Esempio n. 13
0
 public Pag <kh_scoresModel> getScoreList(int examineid, int start, int limit)
 {
     using (Entities db = new Entities())
     {
         IEnumerable <kh_scoresModel> queryable = from a in db.kh_scores
                                                  join b in db.base_users on a.deductuserid equals b.id
                                                  where a.examineid == examineid
                                                  select new kh_scoresModel
         {
             scoreid        = a.scoreid,
             deail          = a.deail,
             deduct         = a.deduct,
             deductuserid   = a.deductuserid,
             examinetime    = a.examinetime,
             examineid      = a.examineid,
             deductusername = b.displayname,
         };
         IOrderedEnumerable <kh_scoresModel> temp = queryable.OrderByDescending(a => a.examineid);
         Pag <kh_scoresModel> rst = PagHelper.CreatPagList(temp, start, limit);
         return(rst);
     }
 }
Esempio n. 14
0
        public ActionResult Create([Bind(Include = "CodP,AnnoP,Tiscr,Cat,Pagato,Dovuto,DatPag,DatReg,DatCassa,Tpag,Fuori,Lode,Carica,Sez,Sett,Pos,Ent,CodSocCol")] Pag pag)
        {
            if (ModelState.IsValid)
            {
                db.Pag.Add(pag);
                db.SaveChanges();
                UpdateDovuto(pag.AnnoP, pag.CodP);
                return(RedirectToAction("Edit", new { codp = pag.CodP, annop = pag.AnnoP }));
            }

            ViewBag.CodP   = new SelectList(db.Mem, "Cod", "Cod", pag.Mem.Cod);
            ViewBag.AnnoP  = new SelectList(db.TabCat, "AnnoCat", "AnnoCat", pag.AnnoP);
            ViewBag.Cat    = new SelectList(db.TabCat, "CodCat", "DescrCat", pag.Cat);
            ViewBag.Carica = new SelectList(db.TabCarica, "CodCarica", "DescrCarica", pag.Carica);
            ViewBag.Ent    = new SelectList(db.TabEnt, "CodEnt", "DescrEnt", pag.Ent);
            ViewBag.Pos    = new SelectList(db.TabPos, "CodPos", "DescrPos", pag.Pos);
            ViewBag.Sett   = new SelectList(db.TabSet, "CodSet", "DescrSet", pag.Sett);
            ViewBag.Sez    = new SelectList(db.TabSez, "CodSez", "DescrSez", pag.Sez);
            ViewBag.Tiscr  = new SelectList(db.TabTIscr, "CodTIscr", "DescrTIscr", pag.Tiscr);
            ViewBag.Tpag   = new SelectList(db.TabTPag, "CodTPag", "DescrTPag", pag.Tpag);
            return(View(pag));
        }
Esempio n. 15
0
        public Pag <basicinfoModel> GetBaseInfoList(List <Filter> filters, int start, int limit)
        {
            Pag <basicinfoModel> list = new Pag <basicinfoModel>();

            using (Entities db = new Entities())
            {
                string sql = string.Format(@"select * from fi_uvas t where t.isdelete=0");
                IEnumerable <basicinfoModel> queryable = db.Database.SqlQuery <basicinfoModel>(sql);
                if (filters != null && filters.Count > 0)
                {
                    foreach (Filter filter in filters)
                    {
                        string value = filter.value;
                        switch (filter.property)
                        {
                        case "ovanum":
                            if (!string.IsNullOrEmpty(value))
                            {
                                queryable = queryable.Where(t => t.ovanum.Contains(value));
                            }
                            break;

                        case "ovaname":
                            if (!string.IsNullOrEmpty(value))
                            {
                                queryable = queryable.Where(t => t.ovaname.Contains(value));
                            }
                            break;
                        }
                        ;
                    }
                }
                IOrderedEnumerable <basicinfoModel> temp = queryable.OrderByDescending(a => a.ovaid);
                list = PagHelper.CreatPagList(temp, start, limit);
            }
            return(list);
        }
Esempio n. 16
0
        public ActionResult Edit([Bind(Include = "CodP,AnnoP,Tiscr,Cat,Pagato,Dovuto,DatPag,DatReg,DatCassa,Tpag,Fuori,Lode,Carica,Sez,Sett,Pos,Ent,CodSocCol")] Pag pag)
        {
            if (ModelState.IsValid)
            {
                db.Entry(pag).State = EntityState.Modified;
                db.SaveChanges();
                UpdateDovuto(pag.AnnoP, pag.CodP);
                ViewBag.Cat        = new SelectList(db.TabCat.Where(m => m.AnnoCat == pag.AnnoP), "CodCat", "DescrCat", pag.Cat);
                ViewBag.Carica     = new SelectList(db.TabCarica, "CodCarica", "DescrCarica", pag.Carica);
                ViewBag.Ent        = new SelectList(db.TabEnt, "CodEnt", "DescrEnt", pag.Ent);
                ViewBag.Pos        = new SelectList(db.TabPos, "CodPos", "DescrPos", pag.Pos);
                ViewBag.Sett       = new SelectList(db.TabSet, "CodSet", "DescrSet", pag.Sett);
                ViewBag.Sez        = new SelectList(db.TabSez, "CodSez", "DescrSez", pag.Sez);
                ViewBag.Tiscr      = new SelectList(db.TabTIscr, "CodTIscr", "DescrTIscr", pag.Tiscr);
                ViewBag.Tpag       = new SelectList(db.TabTPag, "CodTPag", "DescrTPag", pag.Tpag);
                TempData["msg-ok"] = "Aggiornamento effettuato";
            }
            else
            {
                TempData["msg"] = "Aggiornamento non riuscito";
            }

            return(RedirectToAction("Edit", new { codp = pag.CodP, annop = pag.AnnoP }));
        }
Esempio n. 17
0
        // GET: Pags/Edit/5
        public ActionResult Edit(int?codp, int?annop)
        {
            if (codp == null || annop == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Pag pag = db.Pag.Find(codp, annop);

            if (pag == null)
            {
                return(HttpNotFound());
            }

            // anni dei pagamenti
            var anniPag = db.Pag.Where(d => d.CodP == codp && d.AnnoP != annop).Select(d => d.AnnoP.ToString()).ToList();

            if (anniPag.Any())
            {
                ViewBag.anniPag = anniPag;
            }

            // per le divisioni
            var divAlreadyPresent = db.Divisioni.Where(d => d.AnnoP == annop && d.CodP == codp).Select(d => d.CodDiv.ToString()).ToList();
            var listDiv           = db.TabDiv.Where(m => !divAlreadyPresent.Contains(m.CodDiv) && m.AnnoDiv == annop);

            if (listDiv.Any())
            {
                ViewBag.CodDiv = listDiv.Select(q => new SelectListItem {
                    Value = q.CodDiv, Text = q.DescrDiv
                }).ToList();
            }

            // per i gruppi
            var gruAlreadyPresent = db.Gruppi.Where(d => d.AnnoP == annop && d.CodP == codp).Select(d => d.CodGru).ToList();
            var listGru           = db.TabGru.Where(m => !gruAlreadyPresent.Contains(m.CodGru) && m.AnnoGru == annop);

            if (listGru.Any())
            {
                ViewBag.CodGru = listGru.Select(q => new SelectListItem {
                    Value = q.CodGru, Text = q.DescrGruppo
                }).ToList();
            }

            // per le Riviste
            var rivAlreadyPresent = db.Riviste.Where(d => d.AnnoP == annop && d.CodP == codp).Select(d => d.CodRiv).ToList();
            var listRiv           = db.TabRiv.Where(m => !rivAlreadyPresent.Contains(m.CodRiv) && m.AnnoRiv == annop);

            if (listRiv.Any())
            {
                ViewBag.CodRiv = listRiv.Select(q => new SelectListItem {
                    Value = q.CodRiv, Text = q.DescrRiv
                }).ToList();
            }

            // per le Convenzioni
            var convAlreadyPresent = db.Convenzioni.Where(d => d.AnnoP == annop && d.CodP == codp).Select(d => d.CodConv).ToList();
            var listConv           = db.TabConv.Where(m => !convAlreadyPresent.Contains(m.CodConv) && m.AnnoConv == annop);

            if (listConv.Any())
            {
                ViewBag.CodConv = listConv.Select(q => new SelectListItem {
                    Value = q.CodConv, Text = q.DescrConv
                }).ToList();
            }

            ViewBag.Cat    = new SelectList(db.TabCat.Where(m => m.AnnoCat == annop), "CodCat", "DescrCat", pag.Cat);
            ViewBag.Carica = new SelectList(db.TabCarica, "CodCarica", "DescrCarica", pag.Carica);
            ViewBag.Ent    = new SelectList(db.TabEnt, "CodEnt", "DescrEnt", pag.Ent);
            ViewBag.Pos    = new SelectList(db.TabPos, "CodPos", "DescrPos", pag.Pos);
            ViewBag.Sett   = new SelectList(db.TabSet, "CodSet", "DescrSet", pag.Sett);
            ViewBag.Sez    = new SelectList(db.TabSez, "CodSez", "DescrSez", pag.Sez);
            ViewBag.Tiscr  = new SelectList(db.TabTIscr, "CodTIscr", "DescrTIscr", pag.Tiscr);
            ViewBag.Tpag   = new SelectList(db.TabTPag, "CodTPag", "DescrTPag", pag.Tpag);
            return(View(pag));
        }
Esempio n. 18
0
        /// <summary>
        /// 获取行政许可待审批列表
        /// </summary>
        /// <param name="filter"></param>
        /// <param name="start"></param>
        /// <param name="limit"></param>
        /// <returns></returns>
        public Pag <LicenseModel> GetPendingCaseSourcesList(List <Filter> filters, int start, int limit, int userid)
        {
            Pag <LicenseModel> list = new Pag <LicenseModel>();

            using (Entities db = new Entities())
            {
                #region linq
                //IQueryable<LicenseModel> queryable = from a in db.xz_licensings
                //                                     join b_join in db.xzj_files.Where(t => t.source == 2) on a.licensingid equals b_join.sourceid into btmp
                //                                     from b in btmp.DefaultIfEmpty()
                //                                     where a.issh == 0
                //                                     orderby a.licensingid descending
                //                                     select new LicenseModel
                //                                     {
                //                                         licensingid = a.licensingid,
                //                                         sph = a.sph,
                //                                         xksx = a.xksx,
                //                                         splx = a.splx,
                //                                         b_address = a.b_address,
                //                                         sxmx = a.sxmx,
                //                                         sqr = a.sqr,
                //                                         cardtype = a.cardtype,
                //                                         card = a.card,
                //                                         contactphone = a.contactphone,
                //                                         s_address = a.s_address,
                //                                         processtime_start = a.processtime_start,
                //                                         processtime_end = a.processtime_end,
                //                                         processcontent = a.processcontent,
                //                                         processaddress = a.processaddress,
                //                                         geography = a.geography,
                //                                         createuserid = a.createuserid,
                //                                         createtime = a.createtime,
                //                                         shresult = a.shresult,
                //                                         shopinion = a.shopinion,
                //                                         shuser = a.shuser,
                //                                         issh = a.issh,
                //                                         shtime = a.shtime,
                //                                         firstImgUrl = b.filename,
                //                                     };
                #endregion
                string sql = string.Format(@"SELECT d.name, lic.*, zds.zd_name AS splxname, file.filepath AS firstImgUrl
FROM xz_licensings lic
	LEFT JOIN (SELECT *
		FROM xzj_files fi
		WHERE fi.source = 2
		GROUP BY fi.sourceid
		) file ON lic.licensingid = file.sourceid
	LEFT JOIN base_zds zds ON lic.splx = zds.zd_id
		AND zds.zd_type = 'type_splx'
	RIGHT JOIN (SELECT b.id, b.usertypeid, c.unitid, e.`name`
		FROM base_users b
			RIGHT JOIN (SELECT a.id, a.unitid
				FROM base_users a
				WHERE a.id = {0}
				) c ON b.unitid = c.unitid
				AND c.unitid BETWEEN 10 AND 17
			LEFT JOIN base_units e ON c.unitid = e.id
		) d ON lic.createuserid = d.id
WHERE lic.issh = 0", userid);
                //判断是否是队员
                string strsql = string.Format(@"select (case when Find_IN_SET (3,a.roleid)>0 then 1 else null end)mark from
(select users.id,users.displayname,GROUP_CONCAT(usroles.roleid) roleid
FROM base_users users LEFT JOIN base_userroles usroles ON users.id = usroles.userid
WHERE  users.id={0}) a;
", userid);
                IEnumerable <LicenseModel> sqlQueryable = db.Database.SqlQuery <LicenseModel>(sql);
                List <string> sqltest = db.Database.SqlQuery <string>(strsql).ToList();
                if (sqltest.FirstOrDefault() == null)
                {
                    return(list);
                }
                else
                {
                    foreach (LicenseModel model in sqlQueryable)
                    {
                        if (model != null && model.firstImgUrl != null)
                        {
                            List <string> filelist = new List <string>();
                            filelist.Add(model.firstImgUrl);
                            model.imgUrl = filelist;
                        }
                    }
                    if (filters != null && filters.Count > 0)
                    {
                        foreach (Filter filter in filters)
                        {
                            string value = filter.value;
                            switch (filter.property)
                            {
                            case "splx":
                                if (!string.IsNullOrEmpty(value))
                                {
                                    sqlQueryable = sqlQueryable.Where(t => t.splx.Contains(value));
                                }
                                break;

                            case "sqr":
                                if (!string.IsNullOrEmpty(value))
                                {
                                    sqlQueryable = sqlQueryable.Where(t => t.sqr.Contains(value));
                                }
                                break;

                            case "xksx":
                                if (!string.IsNullOrEmpty(value))
                                {
                                    sqlQueryable = sqlQueryable.Where(t => t.xksx.Contains(value));
                                }
                                break;

                            case "sph":
                                if (!string.IsNullOrEmpty(value))
                                {
                                    sqlQueryable = sqlQueryable.Where(t => t.sph.ToString().Contains(value));
                                }
                                break;

                            case "createtime":
                                if (!string.IsNullOrEmpty(value))
                                {
                                    DateTime createtime = Convert.ToDateTime(value);
                                    sqlQueryable = sqlQueryable.Where(t => t.createtime == createtime);
                                }
                                break;
                            }
                        }
                    }
                    IOrderedEnumerable <LicenseModel> temp = sqlQueryable.OrderByDescending(a => a.createtime);
                    list = PagHelper.CreatPagList(temp, start, limit);
                }
            }
            return(list);
        }
Esempio n. 19
0
        public IActionResult Index(string sortOrder, string currentFilter, string searchString, int?page)
        {
            ViewData["NombreSortParm"]      = String.IsNullOrEmpty(sortOrder) ? "nombre_desc" : "";
            ViewData["DescripcionSortParm"] = sortOrder == "descripcion_asc" ? "descripcion_desc" : "descripcion_asc";

            if (searchString != null)
            {
                page = 1;
            }
            else
            {
                searchString = currentFilter;
            }

            ViewData["CurrentFilter"] = searchString;
            ViewData["CurrentSort"]   = sortOrder;


            //db = new SQLTransaction();
            //data = db.GetData();
            //List<QueryOne> listData = new List<QueryOne>();
            //foreach (DataRow item in data.Tables[0].Rows)
            //{
            //    listData.Add(new QueryOne
            //    {
            //        Pedido =item["Pedido"].ToString(),
            //        Fecha=item["Fecha"].ToString(),
            //        Cliente_Nit= item["Cliente_Nit"].ToString(),
            //        Cliente_Suc= item["Cliente_Suc"].ToString(),
            //        Cliente= item["Cliente"].ToString(),
            //        Co_Id= item["Co_Id"].ToString(),
            //        Centro_Operacion= item["Centro_Operacion"].ToString(),
            //        Bodega_Id = item["Bodega_Id"].ToString(),
            //        Bodega= item["Bodega"].ToString(),
            //        Item_Id = Convert.ToInt32(item["Item_Id"]),
            //        Item = item["Item"].ToString(),
            //        Unidad_Pedida=item["Unidad_Pedida"].ToString(),
            //        Cantidad_Ped = Convert.ToInt32(item["Cantidad_Ped"]),
            //        Estado=item["Estado"].ToString(),
            //        Error = item["Error"].ToString()
            //    });
            //}

            var querys = from s in listData select s;

            ViewData["Data"] = querys;
            if (!String.IsNullOrEmpty(searchString))
            {
                querys = querys.Where(s => s.Cliente.Contains(searchString) || s.Cliente_Nit.Contains(searchString) || s.Pedido.Contains(searchString) || s.Fecha.Contains(searchString));
            }

            switch (sortOrder)
            {
            case "nombre_desc":
                querys = querys.OrderByDescending(s => s.Pedido);
                break;

            default:
                querys = querys.OrderBy(s => s.Pedido);
                break;
            }

            var queryfinal = querys.AsQueryable();
            int pageSize   = 20;

            return(View(Pag <QueryOne> .CreateAsync(queryfinal, page ?? 1, pageSize)));
        }