예제 #1
0
        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) + "}"));
        }
예제 #2
0
        public void GetInfoneCustomerInfo(HttpContext context, Guid Id)
        {
            var bll = new InfoneCustomer();

            context.Response.Write(ResResult.ResJsonString(true, "", JsonConvert.SerializeObject(bll.GetModel(Id))));
        }