private void GetInfoneCustomerList(HttpContext context, int pageIndex, int pageSize, string keyword, string typeName, Guid parentId) { var bll = new InfoneCustomer(); if (typeName == "GetCustomersByProjectId" && parentId != Guid.Empty) { var cList = bll.GetCustomersByProjectId(parentId); context.Response.Write(ResResult.ResJsonString(true, "", "{\"total\":" + cList.Count + ",\"rows\":" + JsonConvert.SerializeObject(cList) + "}")); return; } int totalRecord = 0; StringBuilder sqlWhere = null; ParamsHelper parms = null; if (!string.IsNullOrWhiteSpace(keyword)) { parms = new ParamsHelper(); sqlWhere = new StringBuilder("and (c.Coded like @Keyword or c.Named like @Keyword or c.ShortName like @Keyword or c.ContactMan like @Keyword or c.ContactPhone like @Keyword) "); var parm = new SqlParameter("@Keyword", SqlDbType.NVarChar, 50); parm.Value = "%" + keyword + "%"; parms.Add(parm); } var list = bll.GetListByJoin(pageIndex, pageSize, out totalRecord, sqlWhere == null ? "" : sqlWhere.ToString(), parms == null ? null : parms.ToArray()); context.Response.Write(ResResult.ResJsonString(true, "", "{\"total\":" + totalRecord + ",\"rows\":" + JsonConvert.SerializeObject(list) + "}")); }
public void GetInfoneCustomerInfo(HttpContext context, Guid Id) { var bll = new InfoneCustomer(); context.Response.Write(ResResult.ResJsonString(true, "", JsonConvert.SerializeObject(bll.GetModel(Id)))); }