public JsonResult SearchUserProfile(SearchUserProfileViewModel model) { JSonResult objResult = new JSonResult(); //BE.EPerfilUsuarios objEntParam; try { BE.MProfileUser MProfile = new BE.MProfileUser(); MProfile.ProfileId = model.ProfileId; MProfile.User = Extension.ToEmpty(model.User); MProfile.Name = Extension.ToEmpty(model.Name); objResult.data = new WebApiProfile().GetUsersUnAssigned(MProfile).Select(x => new ResultSearchUserProfileViewModelViewModel { ProfileId = model.ProfileId, UserId = x.UserId, User = x.User, Name = x.Name }).ToList(); } catch (Exception ex) { objResult.data = null; objResult.isError = true; objResult.message = string.Format(MessageResource.ControllerGetExceptionMessage, "Users"); } return(Json(objResult)); }
public JsonResult Search(DonorPartnerViewModel model) { JSonResult objResult = new JSonResult(); try { List <MDonorPartner> entList = new List <MDonorPartner>(); entList = new WebApiDonorPartner().GetDonorPartners(); model.DonorCode = model.DonorCode ?? ""; model.DonorName = model.DonorName ?? ""; if (!model.DonorCode.Equals("")) { entList = entList.Where(p => p.DonorCode.Contains(model.DonorCode)).ToList(); } if (!model.DonorName.Equals("")) { entList = entList.Where(p => p.DonorName.Contains(model.DonorName)).ToList(); } objResult.data = entList; } catch (Exception) { objResult.data = null; objResult.isError = true; objResult.message = string.Format(MessageResource.ControllerGetExceptionMessage, "Fund"); } return(Json(objResult)); }
public JsonResult Search(SearchUserViewModel model) { JSonResult objResult = new JSonResult(); try { BE.MUser MUser = new BE.MUser(); List <BE.MUser> MUsers = new List <BE.MUser>(); MUser.User = Extension.ToEmpty(model.User).Trim(); MUser.Name = Extension.ToEmpty(model.UserName).Trim(); MUsers = new WebApiUser().GetUsers(MUser); objResult.data = MUsers; } catch (Exception ex) { objResult.data = null; objResult.isError = true; objResult.message = string.Format(MessageResource.ControllerGetExceptionMessage, "User"); } return(Json(objResult)); }
public JsonResult ChangePassword(string id) { JSonResult objResult = new JSonResult(); string response = string.Empty; try { BE.MUser objEnt = new BE.MUser(); objEnt.UserId = Convert.ToInt32(id); response = new WebApiUser().ChangePassword(objEnt); //Falta crear el metodo de editar string statusCode = response.Split('|')[0]; string statusMessage = response.Split('|')[1]; objResult.isError = statusCode.Equals("2") ? true : false; objResult.message = statusCode.Equals("2") ? statusMessage : string.Format("Change password successful", "User");; } catch (Exception ex) { objResult.data = null; objResult.isError = true; objResult.message = MessageResource.ControllerDeleteExceptionMessage; } return(Json(objResult)); }
public JsonResult Delete(string id) { JSonResult objResult = new JSonResult(); string response = string.Empty; try { BE.MProfile objEnt = new BE.MProfile(); objEnt.ProfileId = Convert.ToInt32(id); response = new WebApiProfile().DeletMProfile(objEnt); //Falta crear el metodo de editar string statusCode = response.Split('|')[0]; string statusMessage = response.Split('|')[1]; objResult.isError = statusCode.Equals("2") ? true : false; objResult.message = statusCode.Equals("2") ? statusMessage : string.Format(MessageResource.RowDeleteOK, "User");; } catch (Exception ex) { objResult.data = null; objResult.isError = true; objResult.message = MessageResource.ControllerDeleteExceptionMessage; } return(Json(objResult)); }
public JsonResult Search(ProgramViewModel model) { JSonResult objResult = new JSonResult(); try { List <MProgramName> entList = new List <MProgramName>(); entList = new WebApiProgram().GetProgramNames(); model.ProjectCode = model.ProjectCode ?? ""; model.ProgramName = model.ProgramName ?? ""; if (!model.ProjectCode.Equals("")) { entList = entList.Where(p => p.ProjectCode.Contains(model.ProjectCode)).ToList(); } if (!model.ProgramName.Equals("")) { entList = entList.Where(p => p.ProgramName.Contains(model.ProgramName)).ToList(); } objResult.data = entList; } catch (Exception) { objResult.data = null; objResult.isError = true; objResult.message = string.Format(MessageResource.ControllerGetExceptionMessage, "Program Names"); } return(Json(objResult)); }
public ActionResult DeleteUser(string ProfileId, string UserId) { //BE.ERetorno objDbResult = null; JSonResult objResult = new JSonResult(); try { BE.MProfileUser MProfileUsers = new BE.MProfileUser(); MProfileUsers.ProfileId = ProfileId.ToInt32(); MProfileUsers.UserId = UserId.ToInt32(); string response = string.Empty; response = new WebApiProfile().DeleteUsersProfile(MProfileUsers); string statusCode = response.Split('|')[0]; string statusMessage = response.Split('|')[1]; string MessageResul = string.Format(MessageResource.SaveSuccess, "User Profile"); objResult.isError = statusCode.Equals("2") ? true : false; objResult.message = statusCode.Equals("2") ? statusMessage : MessageResul; } catch (Exception ex) { objResult.data = null; objResult.isError = true; objResult.message = MessageResource.ControllerDeleteExceptionMessage; } return(Json(objResult)); }
public JsonResult ListUsers(AddUserViewModel model) { JSonResult objResult = new JSonResult(); try { BE.MProfile MProfile = new BE.MProfile(); MProfile.ProfileId = model.ProfileId; List <BE.MProfileUser> lUsers = new List <BE.MProfileUser>(); lUsers = new WebApiProfile().GetUsersProfile(MProfile); objResult.data = (lUsers).Select(x => new ResultUserProfileViewModel { ProfileId = x.ProfileId, UserId = x.UserId, User = x.User, Name = x.Name }).ToList(); } catch (Exception ex) { objResult.data = null; objResult.isError = true; objResult.message = string.Format(MessageResource.ControllerGetExceptionMessage, "Profile"); } return(Json(objResult)); }
public JsonResult Search(FundViewModel model) { JSonResult objResult = new JSonResult(); try { List <MFund> entList = new List <MFund>(); entList = new WebApiFund().GetFunds(); model.FundCode = model.FundCode ?? ""; model.Description = model.Description ?? ""; if (!model.FundCode.Equals("")) { entList = entList.Where(p => p.FundCode == model.FundCode).ToList(); } if (!model.Description.Equals("")) { entList = entList.Where(p => p.Description == model.Description).ToList(); } objResult.data = entList; } catch (Exception) { objResult.data = null; objResult.isError = true; objResult.message = string.Format(MessageResource.ControllerGetExceptionMessage, "Fund"); } return(Json(objResult)); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/json"; int start = 0; int limit = 10; string sort = string.Empty; string dir = string.Empty; string query = string.Empty; if (!string.IsNullOrEmpty(context.Request["start"])) { start = int.Parse(context.Request["start"]); } if (!string.IsNullOrEmpty(context.Request["limit"])) { limit = int.Parse(context.Request["limit"]); } if (!string.IsNullOrEmpty(context.Request["sort"])) { sort = context.Request["sort"]; } if (!string.IsNullOrEmpty(context.Request["dir"])) { dir = context.Request["dir"]; } if (!string.IsNullOrEmpty(context.Request["query"])) { query = context.Request["query"]; } List <QueryFilter> filters = new List <QueryFilter>(); if (!string.IsNullOrEmpty(query)) { filters.Add(new QueryFilter(SPSClientWrapper.PROPERTY_NAME_NAME, query, FilterFunction.Contains)); } List <SPChannelWrapper> channels = SPChannelWrapper.FindAllByOrderByAndFilter(filters, "", true); //} try { JSonResult <SPChannelWrapper> results = new JSonResult <SPChannelWrapper>(channels); context.Response.Write(JSON.Serialize(results)); } catch (Exception e) { logger.Error("读取通道错误", e); } }
//Get the Taobao order number based on epc and sorting number. static public int getItemNumber(string order, string epc, out bool isItemDone) { string url = url_order + "sorting/getDistributionSortingItemsByOrderId.json"; string responseContent = ""; try { HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url); request.ContentType = "application/json"; request.Method = "POST"; request.CookieContainer = cookie; //input the parameters in body. InputPara input = new InputPara(); int orderNo; orderList.TryGetValue(order, out orderNo); input.sortingOrderId = orderNo; input.epc = order; //serialize the object to json string. string body = JsonHelper.SerializeObject(input); byte[] btBodys = Encoding.UTF8.GetBytes(body); request.ContentLength = btBodys.Length; request.GetRequestStream().Write(btBodys, 0, btBodys.Length); HttpWebResponse response = (HttpWebResponse)request.GetResponse(); //Process the response using (Stream resStream = response.GetResponseStream()) { using (StreamReader reader = new StreamReader(resStream, Encoding.UTF8)) { responseContent = reader.ReadToEnd().ToString(); } } } catch (WebException ex) { isItemDone = false; return(-1); } JSonResult result = JsonHelper.DeserializeJsonToObject <JSonResult>(responseContent); if (result.code == "1" && result.data != null) { ResultSoring data = (ResultSoring)result.data; isItemDone = data.finishFlag; return(data.serialNum); } isItemDone = false; return(-1); }
public ActionResult Register(UserViewModel model) { JSonResult objResult = new JSonResult(); string response = string.Empty; try { BE.MUser objEnt = new BE.MUser { UserId = model.UserId, User = model.User.Trim(), Password = "", Name = model.Name.Trim(), Type = 2, //USUARIO CMS Status = Convert.ToInt32(model.Status) }; if (model.UserId == 0) { response = new WebApiUser().InsertUser(objEnt); } else { response = new WebApiUser().UpdatetUser(objEnt); //Falta crear el metodo de editar } string statusCode = response.Split('|')[0]; string statusMessage = response.Split('|')[1]; string MessageResul = (model.UserId == 0) ? string.Format(MessageResource.SaveSuccess, "User") : string.Format(MessageResource.UpdateSuccess, "User"); objResult.isError = statusCode.Equals("2") ? true : false; objResult.message = statusCode.Equals("2") ? statusMessage : MessageResul; } catch (Exception ex) { objResult.isError = true; objResult.data = null; if (model.UserId == 0) { objResult.message = string.Format(MessageResource.SaveError, "User"); } else { objResult.message = string.Format(MessageResource.UpdateError, "User"); } } return(Json(objResult)); }
public ActionResult Register(LoadProjectsViewModel model, HttpPostedFileBase imageFile) { JSonResult objResult = new JSonResult(); string response = string.Empty; try { Session objSession = new Session() { UserId = AutenticationManager.GetUser().IdUsuario, }; List <MProject> entList = new List <MProject>(); List <ModelProjectResult> entListData = new List <ModelProjectResult>(); entListData = (List <ModelProjectResult>)Session["ListProjects"]; foreach (ModelProjectResult item in entListData) { MProject mProject = new MProject(); mProject.ProjectCode = item.ProjectCode; mProject.Description = item.Description; mProject.Type = item.Type; mProject.Status = item.Status; mProject.StartDate = Convert.ToInt32(Extension.ToFormatDateYYYYMMDD(item.StartDateStr)); mProject.EndDate = Convert.ToInt32(Extension.ToFormatDateYYYYMMDD(item.EndDateStr));//item.EndDate; mProject.Title = item.Title; mProject.AwardId = item.AwardId; mProject.AwardStatus = item.AwardStatus; entList.Add(mProject); } response = new WebApiProject().InsertProject(entList, objSession); string statusCode = response.Split('|')[0]; string statusMessage = response.Split('|')[1]; objResult.isError = statusCode.Equals("2"); objResult.message = string.Format(MessageResource.SaveSuccess, "Projects");; } catch (Exception ex) { objResult.message = string.Format(MessageResource.SaveError + "Error :" + ex.Message, "Projects"); } return(Json(objResult)); }
public ActionResult Register(LoadProgamViewModel model, HttpPostedFileBase imageFile) { JSonResult objResult = new JSonResult(); string response = string.Empty; try { Session objSession = new Session() { UserId = AutenticationManager.GetUser().IdUsuario, }; List <MProgramName> entList = new List <MProgramName>(); List <ModelProgramResult> entListData = new List <ModelProgramResult>(); entListData = (List <ModelProgramResult>)Session["ListPrograms"]; foreach (ModelProgramResult item in entListData) { MProgramName mFund = new MProgramName(); mFund.ProjectCode = item.ProjectCode; mFund.ProgramName = item.ProgramName; mFund.DonorCode = item.DonorCode; mFund.ProjectDetails = item.ProjectDetails; mFund.TaskManager = item.TaskManager; mFund.Sector = item.Sector; entList.Add(mFund); } response = new WebApiProgram().InsertProgramName(entList, objSession); string statusCode = response.Split('|')[0]; string statusMessage = response.Split('|')[1]; objResult.isError = statusCode.Equals("2"); objResult.message = string.Format(MessageResource.SaveSuccess, "Program Names");; } catch (Exception ex) { objResult.message = string.Format(MessageResource.SaveError + "Error :" + ex.Message, "Program Names"); } return(Json(objResult)); }
public JsonResult SearchLoad() { JSonResult objResult = new JSonResult(); try { List <ModelProjectResult> entList = new List <ModelProjectResult>(); entList = (List <ModelProjectResult>)Session["ListProjects"]; // Session["ListProjectFinancials"] = null; objResult.data = entList; } catch (Exception ex) { objResult.data = null; objResult.isError = true; objResult.message = string.Format(MessageResource.ControllerGetExceptionMessage, "Projects"); } return(Json(objResult)); }
public ActionResult Register(LoadFundsViewModel model, HttpPostedFileBase imageFile) { JSonResult objResult = new JSonResult(); string response = string.Empty; try { Session objSession = new Session() { UserId = AutenticationManager.GetUser().IdUsuario, }; List <MDonorPartner> entList = new List <MDonorPartner>(); List <ModelDonorPartnerResult> entListData = new List <ModelDonorPartnerResult>(); entListData = (List <ModelDonorPartnerResult>)Session["ListDonors"]; foreach (ModelDonorPartnerResult item in entListData) { MDonorPartner mDonorPartner = new MDonorPartner(); mDonorPartner.DonorCode = item.DonorCode; mDonorPartner.DonorName = item.DonorName; mDonorPartner.FundingPartner = item.FundingPartner; entList.Add(mDonorPartner); } response = new WebApiDonorPartner().InsertDonorPartner(entList, objSession); string statusCode = response.Split('|')[0]; string statusMessage = response.Split('|')[1]; objResult.isError = statusCode.Equals("2"); objResult.message = statusCode.Equals("2") ? statusMessage : string.Format(MessageResource.SaveSuccess, "Donors");; } catch (Exception ex) { objResult.message = string.Format(MessageResource.SaveError + "Error :" + ex.Message, "Donors"); } return(Json(objResult)); }
public JsonResult Search(SearchProfileViewModel model) { JSonResult objResult = new JSonResult(); try { //objResult.data = BN.NPerfiles.BuscarPerfil( // new BE.EPerfiles // { // LoginConexion = AutenticationManager.GetUser().Usuario, // NombreConexion = AutenticationManager.GetUser().NombreConexion, // IdEmpresa = AutenticationManager.GetUser().IdEmpresa, // Abreviatura = model.Codigo.ToEmpty(), // Descripcion = model.Nombre.ToEmpty() // }).Select(x => new BuscarPerfilesResultadoViewModel // { // IdPerfil = x.IdPerfil, // Codigo = x.Abreviatura, // Nombre = x.Descripcion // }).ToList(); BE.MProfile MProfile = new BE.MProfile(); List <BE.MProfile> MProfiles = new List <BE.MProfile>(); MProfile.Description = Extension.ToEmpty(model.Profile); MProfiles = new WebApiProfile().GetProfiles(MProfile); objResult.data = MProfiles; } catch (Exception ex) { objResult.data = null; objResult.isError = true; objResult.message = string.Format(MessageResource.ControllerGetExceptionMessage, "Profile"); } return(Json(objResult)); }
public JsonResult Search(ProjectViewModel model) { JSonResult objResult = new JSonResult(); try { List <MProject> entList = new List <MProject>(); MProject proj = new MProject(); proj.StartDate = 0; proj.EndDate = 0; proj.Title = ""; proj.Status = ""; entList = new WebApiProject().GetProjects(proj); model.ProjectCode = model.ProjectCode ?? ""; model.Description = model.Description ?? ""; if (!model.ProjectCode.Equals("")) { entList = entList.Where(p => p.ProjectCode == model.ProjectCode).ToList(); } if (!model.Description.Equals("")) { entList = entList.Where(p => p.Description == model.Description).ToList(); } objResult.data = entList; } catch (Exception) { objResult.data = null; objResult.isError = true; objResult.message = string.Format(MessageResource.ControllerGetExceptionMessage, "Project"); } return(Json(objResult)); }
//for user login static public Boolean userLogin(String userName, String password) { string url = url_system + "system/users/login.json?loginName=" + userName + "&password="******""; try { HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url); request.ContentType = "application/json"; request.Method = "POST"; request.CookieContainer = cookie; HttpWebResponse response = (HttpWebResponse)request.GetResponse(); //process the response message. using (Stream resStream = response.GetResponseStream()) { using (StreamReader reader = new StreamReader(resStream, Encoding.UTF8)) { responseContent = reader.ReadToEnd().ToString(); } } JSonResult result = JsonHelper.DeserializeJsonToObject <JSonResult>(responseContent); if (result.code == "1") { CookieCollection cookieheader = request.CookieContainer.GetCookies(new Uri(url_system + "system/users/getCurrentUser.json")); cookie.Add(cookieheader); return(true); } } catch (WebException we) { return(false); } return(false); }
public ActionResult Register(LoadFundsViewModel model, HttpPostedFileBase imageFile) { JSonResult objResult = new JSonResult(); string response = string.Empty; try { Session objSession = new Session() { UserId = AutenticationManager.GetUser().IdUsuario, }; List <MFund> entList = new List <MFund>(); List <ModelFundResult> entListData = new List <ModelFundResult>(); entListData = (List <ModelFundResult>)Session["ListFunds"]; foreach (ModelFundResult item in entListData) { MFund mFund = new MFund(); mFund.FundCode = item.FundCode; mFund.Description = item.Description; entList.Add(mFund); } response = new WebApiFund().InsertFund(entList, objSession); string statusCode = response.Split('|')[0]; string statusMessage = response.Split('|')[1]; objResult.isError = statusCode.Equals("2"); objResult.message = string.Format(MessageResource.SaveSuccess, "Funds");; } catch (Exception ex) { objResult.message = string.Format(MessageResource.SaveError + "Error :" + ex.Message, "Funds"); } return(Json(objResult)); }
public ActionResult LoadFile(LoadProjectsViewModel model, HttpPostedFileBase imageFile) { JSonResult objResult = new JSonResult(); string fileName = string.Empty; string Ext = string.Empty; byte[] imgData = null;//; new byte[0]; string path = string.Empty; string basePath; // basePath = "E:\\TFS_Fuentes\\UnitLite\\Fuentes CMS Net\\CMSWeb\\File"; basePath = Server.MapPath("~/File"); DataTable dt; var include = new[] { "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O" }; try { if (imageFile != null) { fileName = imageFile.FileName; Ext = Path.GetExtension(imageFile.FileName); // imgData = Extension.FileToByteArray(imageFile); path = string.Format("{0}\\{1}", basePath, imageFile.FileName); } if (!Directory.Exists(basePath)) { Directory.CreateDirectory(basePath); } imageFile.SaveAs(path); try { using (SpreadsheetDocument doc = SpreadsheetDocument.Open(path, false)) { //Read the first Sheet from Excel file. Sheet sheet = doc.WorkbookPart.Workbook.Sheets.GetFirstChild <Sheet>(); //Get the Worksheet instance. Worksheet worksheet = (doc.WorkbookPart.GetPartById(sheet.Id.Value) as WorksheetPart).Worksheet; //Fetch all the rows present in the Worksheet. IEnumerable <Row> rows = worksheet.GetFirstChild <SheetData>().Descendants <Row>(); dt = new DataTable(); //Loop through the Worksheet rows. foreach (Row row in rows) { //Use the first row to add columns to DataTable. if (row.RowIndex.Value == 2) { foreach (Cell cell in row.Descendants <Cell>()) { string cel = cell.CellReference; cel = cel.Substring(0, 1); if (include.Any(x => cel.Contains(x))) {//Continue adding the row to the table dt.Columns.Add(OpenXMLUtil.GetValue(doc, cell)); } } } else if (row.RowIndex.Value > 2) { //Add rows to DataTable. dt.Rows.Add(); int i = 0; foreach (Cell cell in row.Descendants <Cell>()) { string cel2 = cell.CellReference; cel2 = cel2.Substring(0, 1); if (include.Any(x => cel2.Contains(x))) { string val = OpenXMLUtil.GetValue(doc, cell); if (cel2.Contains("K") || cel2.Contains("L")) { try { DateTime date = DateTime.FromOADate(Convert.ToDouble(val)); val = date.ToString("dd/MM/yyyy"); } catch (Exception ex) { objResult.isError = true; objResult.message = string.Format("Error: Error in the date field please use format DD/MM/YYYY", "Project ERP "); return(Json(objResult)); } } dt.Rows[dt.Rows.Count - 1][i] = val; i++; } } } } } } catch (Exception ex) { objResult.isError = true; objResult.data = null; objResult.message = string.Format("Error: Please check the template for this upload ", "Projects"); return(Json(objResult)); } if (dt.Rows.Count <= 0) { objResult.isError = true; objResult.data = null; objResult.message = string.Format("The uploaded file has no rows", "Projects"); return(Json(objResult)); } try { var dtResultado = dt.Rows.Cast <DataRow>().Where(row => !Array.TrueForAll(row.ItemArray, value => { return(value.ToString().Length == 0); })); dt = dtResultado.CopyToDataTable(); List <ModelProjectResult> entlist = new List <ModelProjectResult>(); for (int i = 0; i < dt.Rows.Count; i++) { ModelProjectResult ent = new ModelProjectResult(); //ent.Department = Extension.ToEmpty(dt.Rows[i][0].ToString());//Convert.ToInt32(dt.Rows[i]["StudentId"]); ent.ProjectCode = Extension.ToEmpty(dt.Rows[i][1].ToString());//Convert.ToInt32(dt.Rows[i]["StudentId"]); ent.Description = Extension.ToEmpty(dt.Rows[i][2].ToString()); ent.Type = Extension.ToEmpty(dt.Rows[i][3].ToString()); ent.Status = Extension.ToEmpty(dt.Rows[i][4].ToString()); ent.StartDateStr = Extension.ToEmpty(dt.Rows[i][9].ToString()); ent.EndDateStr = Extension.ToEmpty(dt.Rows[i][10].ToString()); ent.AwardId = Extension.ToEmpty(dt.Rows[i][11].ToString()); ent.Title = Extension.ToEmpty(dt.Rows[i][12].ToString()); ent.AwardStatus = Extension.ToEmpty(dt.Rows[i][13].ToString()); ent.AlertMessage = string.Empty; ent.WithAlert = "N"; //if (ent.ProjectCode.Length > 10) //{ // ent.AlertMessage += "<tr><td> - the Project Code column must not must not exceed 10 characters </td></tr> "; //} //if (ent.ProjectCode.Length == 0) //{ // ent.AlertMessage += "<tr><td> - the Project Code column is required </td></tr> "; //} //if (ent.Description.Length > 255) //{ // ent.AlertMessage += "<tr><td> - the Description column must not must not exceed 255 characters </td></tr> "; //} //if (ent.Description.Length == 0) //{ // ent.AlertMessage += "<tr><td> - the Description column is required </td></tr> "; //} //if (ent.AlertMessage.Length > 0) //{ // ent.AlertMessage = "<table>" + ent.AlertMessage + "</table>"; // ent.WithAlert = "S"; //} entlist.Add(ent); } Session["ListProjects"] = entlist; objResult.data = entlist; } catch (Exception ex) { objResult.isError = true; objResult.data = null; objResult.message = "Projects :" + "Format error, check records"; return(Json(objResult)); } objResult.isError = false; objResult.message = null; // string.Format(MessageResource.SaveSuccess, "Load File save"); } catch (Exception ex) { objResult.isError = true; objResult.data = null; objResult.message = "Error loading Projects"; } return(Json(objResult)); }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/json"; int start = 0; int limit = 10; string sort = string.Empty; string dir = string.Empty; string query = string.Empty; if (!string.IsNullOrEmpty(context.Request["start"])) { start = int.Parse(context.Request["start"]); } if (!string.IsNullOrEmpty(context.Request["limit"])) { limit = int.Parse(context.Request["limit"]); } if (!string.IsNullOrEmpty(context.Request["sort"])) { sort = context.Request["sort"]; } if (!string.IsNullOrEmpty(context.Request["dir"])) { dir = context.Request["dir"]; } if (!string.IsNullOrEmpty(context.Request["query"])) { query = context.Request["query"]; } List<QueryFilter> filters = new List<QueryFilter>(); if (!string.IsNullOrEmpty(query)) { filters.Add(new QueryFilter(SPSClientWrapper.PROPERTY_NAME_NAME, query, FilterFunction.Contains)); } List<SPChannelWrapper> channels = SPChannelWrapper.FindAllByOrderByAndFilter(filters, "", true); //} try { JSonResult<SPChannelWrapper> results = new JSonResult<SPChannelWrapper>(channels); context.Response.Write(JSON.Serialize(results)); } catch (Exception e) { logger.Error("读取通道错误",e); } }