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);
}
}
