Server/_User.asmx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using TeamTask.Model;

namespace TeamTask.Server
{
    /// <summary>
    /// _User 的摘要说明
    /// </summary>
    [WebService(Namespace = "http://tempuri.org/")]
    [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
    [System.ComponentModel.ToolboxItem(false)]
    // 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务，请取消注释以下行。 
    [System.Web.Script.Services.ScriptService]
    public class _User : System.Web.Services.WebService
    {
        public _User()
        {
            Common.Helper.Validate(Context);
        }

        [WebMethod(true)]
        public dynamic search(int rows, int page, string sidx, string sord, string name, string fullName)
        {
            dynamic result = null;
            using (var db = new DBContext())
            {
                var objContext = ((System.Data.Entity.Infrastructure.IObjectContextAdapter)db).ObjectContext;
                var all = objContext.CreateObjectSet<User>();
                //排序
                var whereList = all.OrderBy(string.Format("it.{0} {1}", sidx, sord)).AsQueryable();
                //条件

                if (name != "")
                    whereList = whereList.Where(m => m.Name.Contains(name));
                if (fullName != "")
                    whereList = whereList.Where(m => m.FullName.Contains(fullName));
                //结果
                var records = whereList.Count();
                result = new
                {
                    rows =
                    (from i in whereList.Skip((page - 1) * rows).Take(rows).AsEnumerable()
                     select new
                     {
                         i.ID,
                         i.Name,
                         i.FullName,
                         i.Gendar,
                         ModifyDate = i.ModifyDate.ToString("yyyy-MM-dd HH:mm:ss"),
                         CreateDate = i.CreateDate.ToString("yyyy-MM-dd HH:mm:ss")
                     }).ToList(),
                    records = records,
                    page = page,
                    total = records / rows + (records % rows != 0 ? 1 : 0)
                };
            }