/// <summary>
        ///更新对象属性到数据库中/// </summary>
        /// <param name="t">指定的对象</param>
        /// <param name="key">主键的值</param>
        /// <returns>执行成功返回<c>true</c>，否则为<c>false</c></returns>
        bool Update(T t, objectkey);/// <summary>
        ///更新对象属性到数据库中（异步）/// </summary>
        /// <param name="t">指定的对象</param>
        /// <param name="key">主键的值</param>
        /// <returns>执行成功返回<c>true</c>，否则为<c>false</c></returns>
        Task<bool> UpdateAsync(T t, objectkey);/// <summary>
        ///根据指定对象的ID,从数据库中删除指定对象/// </summary>
        /// <param name="id">对象的ID</param>
        /// <returns>执行成功返回<c>true</c>，否则为<c>false</c>。</returns>
        bool Delete(objectid);/// <summary>
        ///根据指定对象的ID,从数据库中删除指定对象（异步）/// </summary>
        /// <param name="id">对象的ID</param>
        /// <returns>执行成功返回<c>true</c>，否则为<c>false</c>。</returns>
        Task<bool> DeleteAsync(objectid);/// <summary>
        ///查询数据库,返回指定ID的对象/// </summary>
        /// <param name="id">ID主键的值</param>
        /// <returns>存在则返回指定的对象,否则返回Null</returns>
        T FindByID(objectid);/// <summary>
        ///查询数据库,返回指定ID的对象（异步）/// </summary>
        /// <param name="id">ID主键的值</param>
        /// <returns>存在则返回指定的对象,否则返回Null</returns>
        Task<T> FindByIDAsync(object id);

The argument types 'Edm.Int32' and 'Edm.String' are incompatible for this operation.

RoleInfo info = CallerFactory<IRoleService>.Instance.FindByID(currentID.ToInt32());if (info != null)

                    {

                        info=SetRoleInfo(info);

                        CallerFactory<IRoleService>.Instance.Update(info, info.ID);



                        RefreshTreeView();

                    }

        /// <summary>
        ///分页控件删除操作/// </summary>
        private void winGridViewPager1_OnDeleteSelected(objectsender, EventArgs e)

        {if (MessageDxUtil.ShowYesNoAndTips("您确定删除选定的记录么？") ==DialogResult.No)

            {return;

            }int[] rowSelected = this.winGridViewPager1.GridView1.GetSelectedRows();foreach (int iRow inrowSelected)

            {string ID = this.winGridViewPager1.GridView1.GetRowCellDisplayText(iRow, "ID");

                CallerFactory<IDistrictService>.Instance.Delete(ID.ToInt64());

            }



            BindData();

        }

        /// <summary>
        ///根据指定机构节点ID，获取其下面所有机构列表/// </summary>
        /// <param name="parentId">指定机构节点ID</param>
        /// <returns></returns>
        public List<OUInfo> GetAllOUsByParent(intparentId)

        {

            List<OUInfo> list = new List<OUInfo>();string sql = string.Format("Select * From {0} Where Deleted <> 1 Order By PID, Name", tableName);



            DataTable dt=SqlTable(sql);string sort = string.Format("{0} {1}", GetSafeFileName(sortField), isDescending ? "DESC" : "ASC");

            DataRow[] dataRows= dt.Select(string.Format("PID = {0}", parentId), sort);for (int i = 0; i < dataRows.Length; i++)

            {string id = dataRows[i]["ID"].ToString();

                list.AddRange(GetOU(id, dt));

            }returnlist;

        }private List<OUInfo> GetOU(stringid, DataTable dt)

        {

            List<OUInfo> list = new List<OUInfo>();



            OUInfo ouInfo= this.FindByID(id);

            list.Add(ouInfo);string sort = string.Format("{0} {1}", GetSafeFileName(sortField), isDescending ? "DESC" : "ASC");

            DataRow[] dChildRows= dt.Select(string.Format("PID={0}", id), sort);for (int i = 0; i < dChildRows.Length; i++)

            {string childId = dChildRows[i]["ID"].ToString();

                List<OUInfo> childList =GetOU(childId, dt);

                list.AddRange(childList);

            }returnlist;

        }

        /// <summary>
        ///根据指定机构节点ID，获取其下面所有机构列表/// </summary>
        /// <param name="parentId">指定机构节点ID</param>
        /// <returns></returns>
        public IList<Ou> GetAllOUsByParent(intparentId)

        {//递归获取指定PID及下面所有所有的OU
            var query = this.GetQueryable().Where(s => s.PID == parentId).Where(s => !s.Deleted.HasValue || s.Deleted == 0).OrderBy(s => s.PID).OrderBy(s =>s.Name);return query.ToList().Concat(query.ToList().SelectMany(t =>GetAllOUsByParent(t.ID))).ToList();

        }

        /// <summary>
        ///获取树形结构的机构列表/// </summary>
        public IList<OuNodeInfo>GetTree()

        {

            IList<OuNodeInfo> returnList = new List<OuNodeInfo>();

            IList<Ou> list = this.GetQueryable().Where(p => p.PID == -1).OrderBy(s => s.PID).OrderBy(s =>s.Name).ToList();if (list != null)

            {foreach (Ou info in list.Where(s => s.PID == -1))

                {

                    OuNodeInfo nodeInfo=GetNode(info);

                    returnList.Add(nodeInfo);

                }

            }returnreturnList;

        }

"0001-01-01 到 9999-12-31"（公元元年 1 月 1 日到公元 9999 年 12 月 31 日）

从 datetime2 数据类型到 datetime 数据类型的转换产生一个超出范围的值

    /// <summary>
    ///系统用户信息，数据实体对象/// </summary>
    public classUser

    {/// <summary>
        ///默认构造函数（需要初始化属性的在此处理）/// </summary>
        publicUser()

        {this.ID= 0;//从 datetime2 数据类型到 datetime 数据类型的转换产生一个超出范围的值//避免这个问题，可以初始化日期字段
            DateTime defaultDate = Convert.ToDateTime("1900-1-1");this.Birthday =defaultDate;this.LastLoginTime =defaultDate;this.LastPasswordTime =defaultDate;this.CurrentLoginTime =defaultDate;this.EditTime =DateTime.Now;this.CreateTime =DateTime.Now;

         }

        /// <summary>
        ///新增状态下的数据保存/// </summary>
        /// <returns></returns>
        public override boolSaveAddNew()

        {

            UserInfoinfo= tempInfo;//必须使用存在的局部变量，因为部分信息可能被附件使用
SetInfo(info);

            info.Creator=Portal.gc.UserInfo.FullName;

            info.Creator_ID=Portal.gc.UserInfo.ID.ToString();

            info.CreateTime=DateTime.Now;try{#region 新增数据

               bool succeed = CallerFactory<IUserService>.Instance.Insert(info);if(succeed)

                {//可添加其他关联操作

                    return true;

                }#endregion}catch(Exception ex)

            {

                LogTextHelper.Error(ex);

                MessageDxUtil.ShowError(ex.Message);

            }return false;

        }

        /// <summary>
        ///根据查询条件构造查询语句/// </summary> 
        privateExpressionNode GetConditionSql()

        {

            Expression<Func<UserInfo, bool>> expression = p => true;if (!string.IsNullOrEmpty(this.txtHandNo.Text))

            {

                expression= expression.And(x => x.HandNo.Equals(this.txtHandNo.Text));

            }if (!string.IsNullOrEmpty(this.txtName.Text))

            {

                expression= expression.And(x => x.Name.Contains(this.txtName.Text));

            }

.........................................//如果是公司管理员，增加公司标识
            if(Portal.gc.UserInRole(RoleInfo.CompanyAdminName))

            {

                expression= expression.And(x => x.Company_ID ==Portal.gc.UserInfo.Company_ID);

            }//如果是单击节点得到的条件，则使用树列表的，否则使用查询条件的
            if (treeCondition != null)

            {

                expression=treeCondition;

            }//如非选定，只显示正常用户
            if (!this.chkIncludeDelete.Checked)

            {

                expression= expression.And(x => x.Deleted == 0);

            }returnexpression.ToExpressionNode();

        }

ExpressionNode where =GetConditionSql();

            PagerInfo PagerInfo= this.winGridViewPager1.PagerInfo;

            IList<UserInfo> list = CallerFactory<IUserService>.Instance.FindWithPager(where, ref PagerInfo);this.winGridViewPager1.DataSource = new WHC.Pager.WinControl.SortableBindingList<UserInfo>(list);this.winGridViewPager1.PrintTitle = "系统用户信息报表";

        /// <summary>
        ///插入指定对象到数据库中/// </summary>
        /// <param name="info">指定的对象</param>
        /// <returns>执行操作是否成功。</returns>
        public virtual CommonResult Insert(T info, string token, string signature, string timestamp, string nonce, string appid)

            //如果用户token检查不通过，则抛出MyApiException异常。//检查用户是否有权限，否则抛出MyDenyAccessException异常
            base.CheckAuthorized(AuthorizeKey.InsertKey, token, signature, timestamp, nonce, appid);

        /// <summary>
        ///查询数据库,检查是否存在指定ID的对象/// </summary>
        /// <param name="id">对象的ID值</param>
        /// <returns>存在则返回指定的对象,否则返回Null</returns>
[HttpGet]public virtual T FindByID(string id, stringtoken)

        {//如果用户token检查不通过，则抛出MyApiException异常。//检查用户是否有权限，否则抛出MyDenyAccessException异常
            base.CheckAuthorized(AuthorizeKey.ViewKey, token);



            T info=baseBLL.FindByID(id);returninfo;

        }

        /// <summary>
        ///注册用户获取访问令牌接口/// </summary>
        /// <param name="username">用户登录名称</param>
        /// <param name="password">用户密码</param>
        /// <param name="signature">加密签名字符串</param>
        /// <param name="timestamp">时间戳</param>
        /// <param name="nonce">随机数</param>
        /// <param name="appid">应用接入ID</param>
        /// <returns></returns>
        TokenResult GetAccessToken(string username, stringpassword,string signature, string timestamp, string nonce, string appid);

                string appid = "myapi_123456";string appsecret = "mySecret_2856FB9DBE31";//使用API方式，需要在缓存里面设置特殊的信息
                var url = "http://localhost:9001/api/Auth/GetAccessToken" + GetSignatureUrl(appid, appsecret) + "&username=admin&password=";

                TokenResult result= JsonHelper<TokenResult>.ConvertJson(url);if(result == null)

                {

                    MessageDxUtil.ShowError("获取授权信息出错，请检查地址是否正确！");

                }

        public override bool Delete(stringkey)

        {var action = "Delete";string url = GetPostUrlWithToken(action) +string.Format("&id={0}", key);



            CommonResult result= JsonHelper<CommonResult>.ConvertJson(url);returnresult.Success;

        }public List<DictDataInfo> FindByTypeID(stringdictTypeId)

        {var action = "FindByTypeID";string url = GetTokenUrl(action) + string.Format("&dictTypeId={0}", dictTypeId);



            List<DictDataInfo> result = JsonHelper<List<DictDataInfo>>.ConvertJson(url);returnresult;

        }

DictDataInfo info = CallerFactory<IDictDataService>.Instance.FindByID(ID);if (info != null)

            {

                SetInfo(info);try{bool succeed = CallerFactory<IDictDataService>.Instance.Update(info, info.ID.ToString());returnsucceed;

                }catch(Exception ex)

                {

                    LogTextHelper.Error(ex);

                    MessageDxUtil.ShowError(ex.Message);

                }

            }

错误时微信会返回错误码等信息，JSON数据包示例如下（该示例为AppID无效错误）:



{"errcode":40013,"errmsg":"invalid appid"}

    /// <summary>
    ///接口返回的错误信息/// </summary>
    public classBaseResultJson

    {/// <summary>
        ///错误代码/// </summary>
        public int errcode { get; set; }/// <summary>
        ///如果不成功，返回的错误信息/// </summary>
        public string errmsg { get; set; }/// <summary>
        ///是否成功/// </summary>
        public bool success { get; set; }

    }

            //如果没有通过，则抛出异常，由异常过滤器统一处理
            if (!result.success)

            {throw newMyApiException(result.errmsg, result.errcode);

            }

    /// <summary>
    ///所有接口基类/// </summary>
[ExceptionHandling]public class BaseApiController : ApiController

    /// <summary>
    ///API自定义错误过滤器属性/// </summary>
    public classExceptionHandlingAttribute : ExceptionFilterAttribute

    {/// <summary>
        ///统一对调用异常信息进行处理，返回自定义的异常信息/// </summary>
        /// <param name="context">HTTP上下文对象</param>
        public override voidOnException(HttpActionExecutedContext context)

        {//自定义异常的处理
            MyApiException ex = context.Exception asMyApiException;if (ex != null)

            {throw new HttpResponseException(newHttpResponseMessage(HttpStatusCode.InternalServerError)

                {//封装处理异常信息，返回指定JSON对象
                    Content = new StringContent(new BaseResultJson(ex.Message, false, ex.errcode).ToJson()),

                    ReasonPhrase= "Exception"});



            }//记录关键的异常信息
Debug.WriteLine(context.Exception);//常规异常的处理
            string msg = string.IsNullOrEmpty(context.Exception.Message) ? "接口出现了错误，请重试或者联系管理员": context.Exception.Message;throw new HttpResponseException(newHttpResponseMessage(HttpStatusCode.InternalServerError)

            {

                Content= newStringContent(msg),

                ReasonPhrase= "Critical Exception"});

        }

    }

{"errcode":404,"errmsg":"请求的资源不支持 http 方法“POST”。","success":false}

            HttpHelper helper = newHttpHelper();

            helper.ContentType= "application/json";string content = helper.GetHtml(url, postData, true);

            VerifyErrorCode(content);



            T result= JsonConvert.DeserializeObject<T>(content);return result;

                BaseResultJson errorResult = JsonConvert.DeserializeObject<BaseResultJson>(content);//非成功操作才记录异常，因为有些操作是返回正常的结果（{"errcode": 0, "errmsg": "ok"}）
                if (errorResult != null && !errorResult.success)

                {string error = string.Format("请求发生错误！错误代码：{0}，说明：{1}", (int)errorResult.errcode, errorResult.errmsg);

                    LogTextHelper.Error(errorResult.ToJson());throw new Exception(error);//抛出错误
                }

    public static classWebApiConfig

    {public static voidRegister(HttpConfiguration config)

        {

    

            ..............



            config.MessageHandlers.Add(new CustomErrorMessageDelegatingHandler());

    /// <summary>
    ///API自定义错误消息处理委托类。///用于处理访问不到对应API地址的情况，对错误进行自定义操作。/// </summary>
    public classCustomErrorMessageDelegatingHandler : DelegatingHandler

    {protected override Task<HttpResponseMessage>SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)

        {return base.SendAsync(request, cancellationToken).ContinueWith<HttpResponseMessage>((responseToCompleteTask) =>{

                HttpResponseMessage response=responseToCompleteTask.Result;

                HttpError error= null;if (response.TryGetContentValue<HttpError>(outerror))

                {//添加自定义错误处理//error.Message = "Your Customized Error Message";
}if (error != null)

                {//获取抛出自定义异常，有拦截器统一解析
                    throw new HttpResponseException(newHttpResponseMessage(HttpStatusCode.NotFound)

                    {//封装处理异常信息，返回指定JSON对象
                        Content = new StringContent(new BaseResultJson(error.Message, false, 404).ToJson()),

                        ReasonPhrase= "Exception"});

                }else{returnresponse;

                }

            });

        }

    }

{"errcode":404,"errmsg":"找不到与请求 URI“http://localhost:9001/api/SystemType/Delete?signature=72f8d706c79dc14d70fc3f080d4706748d754021&timestamp=1443194061&nonce=0.650359861866666663&appid=website_9A39C2A8&token=eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiIxIiwiaWF0IjoxNDQzMTk0MDM4LCJqdGkiOiI1YmEyYmE5Ni0yZTA4LTQ1ZTgtYTAwNy01MmY3OTkzYTg2NzEiLCJuYW1lIjoiYWRtaW4iLCJjaGFubmVsIjoiMCIsInNoYXJlZGtleSI6IjEyMzRhYmNkIn0.RRXQmmSCJzDK5Or6rmBL5wjd-YIJoEQFc0pOzqhR6IU”匹配的 HTTP 资源。","success":false}

请求的资源不支持 http 方法“POST

        /// <summary>
        ///查询数据库,检查是否存在指定ID的对象/// </summary>
        /// <param name="id">对象的ID值</param>
        /// <returns>存在则返回指定的对象,否则返回Null</returns>
[HttpGet]public virtual T FindByID(string id, string token)

        /// <summary>
        ///插入指定对象到数据库中/// </summary>
        /// <param name="info">指定的对象</param>
        /// <returns>执行操作是否成功。</returns>
[HttpPost]public virtual CommonResult Insert(T info, string token, string signature, string timestamp, string nonce, string appid)

接口调用请求说明

http请求方式: POST（请使用https协议）

https://api.weixin.qq.com/cgi-bin/groups/update?access_token=ACCESS_TOKEN

POST数据格式：json

POST数据例子：{"group":{"id":108,"name":"test2_modify2"}}

        /// <summary>
        ///修改用户密码/// </summary>
        /// <param name="param">包含userName和userPassword的复合对象</param>
        /// <param name="token">用户访问令牌</param>
        /// <returns></returns>
[HttpPost]public CommonResult ModifyPassword(JObject param,  stringtoken)

        {//令牌检查,不通过则抛出异常
            CheckResult checkResult =CheckToken(token);dynamic obj =param;if (obj != null)

            {string userName =obj.userName;string userPassword =obj.userPassword;bool success = BLLFactory<User>.Instance.ModifyPassword(userName, userPassword);return newCommonResult(success);

            }else{throw new MyApiException("传递参数出现错误");

            }

        }

dynamic obj = param;

        /// <summary>
        ///调用Web API接口，修改用户密码/// </summary>
        /// <param name="userName">用户名称</param>
        /// <param name="userPassword">修改的密码</param>
        /// <returns>如果修改成功返回true，否则返回false</returns>
        public bool ModifyPassword(string userName, stringuserPassword)

        {var action = "ModifyPassword";var postData = new{

                userName=userName,

                userPassword=userPassword

            }.ToJson();string url =GetTokenUrl(action);



            CommonResult result= JsonHelper<CommonResult>.ConvertJson(url, postData);return (result != null) ? result.Success : false;

        }

            var postData = new{

                userName=userName,

                userPassword=userPassword

            }.ToJson();

        /// <summary>
        ///返回数据库所有的对象集合/// </summary>
        /// <returns>指定对象的集合</returns>
[HttpGet]public virtual List<T> GetAll(stringtoken)

        {//检查用户是否有权限，否则抛出MyDenyAccessException异常
            base.CheckAuthorized(AuthorizeKey.ListKey, token);



            List<T> list =baseBLL.GetAll();returnlist;

        }

        /// <summary>
        ///根据条件查询数据库,并返回对象集合(用于分页数据显示)/// </summary>
        /// <returns>指定对象的集合</returns>
[HttpPost]public virtual PagedList<T> FindWithPager(string condition, PagerInfo pagerInfo, string token)

    /// <summary>
    ///分页集合/// </summary>
    /// <typeparam name="T">对象</typeparam>
    public class PagedList<T>{/// <summary>
        ///返回记录的总数/// </summary>
        public int total_count { get; set; }/// <summary>
        ///列表集合/// </summary>
        public List<T> list { get; set; }

    }

        /// <summary>
        ///根据条件查询数据库,并返回对象集合(用于分页数据显示)/// </summary>
        /// <returns>指定对象的集合</returns>
[HttpPost]public virtual PagedList<T> FindWithPager(string condition, PagerInfo pagerInfo, stringtoken)

        {//检查用户是否有权限，否则抛出MyDenyAccessException异常
            base.CheckAuthorized(AuthorizeKey.ListKey, token);



            List<T> list =baseBLL.FindWithPager(condition, pagerInfo);//构造成Json的格式传递
            var result = new PagedList<T>() { total_count = pagerInfo.RecordCount, list =list };returnresult;

        }

        /// <summary>
        ///根据条件查询数据库,并返回对象集合(用于分页数据显示)/// </summary>
        /// <param name="condition">查询的条件</param>
        /// <param name="pagerInfo">分页实体</param>
        /// <returns>指定对象的集合</returns>
        public virtual List<T> FindWithPager(string condition, refPagerInfo pagerInfo)

        {var action = "FindWithPager";string url = GetTokenUrl(action) + string.Format("&condition={0}", condition);var postData =pagerInfo.ToJson();



            List<T> result = new List<T>();

            PagedList<T> list = JsonHelper<PagedList<T>>.ConvertJson(url, postData);if (list != null)

            {

pagerInfo.RecordCount= list.total_count;//修改总记录数

                result =list.list;

            }returnresult;

        }