public JsonResult getAllSearch(string code, string thetype, string name, string nametype, string note, string notetype) { List <PARTYLEVELTITLE_OBJ> li = null; PARTYLEVELTITLE_BUS bus = new PARTYLEVELTITLE_BUS(); List <fieldpara> lipa = new List <fieldpara>(); lipa.Add(new fieldpara("UNIVERSITYCODE", ses.gUNIVERSITYCODE, 0)); if (!string.IsNullOrEmpty(code)) { lipa.Add(new fieldpara("CODEVIEW", name, (int)(thetype.ToUpper() == "TRUE" ? searchType.NONE : searchType.LIKE))); } if (!string.IsNullOrEmpty(name)) { lipa.Add(new fieldpara("NAME", name, (int)(nametype.ToUpper() == "TRUE" ? searchType.NONE : searchType.LIKE))); } if (!string.IsNullOrEmpty(note)) { lipa.Add(new fieldpara("NOTE", note, (int)(notetype.ToUpper() == "TRUE" ? searchType.NONE : searchType.LIKE))); } //order by theorder, with pagesize and the page li = bus.getAllBy2(" THEORDER ", lipa.ToArray()); bus.CloseConnection(); //li = li.Skip((page - 1) * pageSize).Take(pageSize).ToList(); return(Json(new { lst = li, //Danh sách ret = 0 //ok }, JsonRequestBehavior.AllowGet)); }
public JsonResult getAll(string thetype) { List <PARTYLEVELTITLE_OBJ> li = null; PARTYLEVELTITLE_BUS bus = new PARTYLEVELTITLE_BUS(); List <fieldpara> lipa = new List <fieldpara>(); lipa.Add(new fieldpara("UNIVERSITYCODE", ses.gUNIVERSITYCODE, 0)); //lipa.Add(new fieldpara("THETYPE", thetype)); //order by theorder, with pagesize and the page li = bus.getAllBy2(" THEORDER ", lipa.ToArray()); bus.CloseConnection(); //li = li.Skip((page - 1) * pageSize).Take(pageSize).ToList(); return(Json(new { lst = li, //Danh sách ret = 0 //ok }, JsonRequestBehavior.AllowGet)); }