Exemple #1
0
        /// <summary>
        /// 更新用户信息
        /// </summary>
        /// <param name="id"></param>
        /// <param name="userid"></param>
        /// <param name="pwd"></param>
        /// <param name="username"></param>
        /// <param name="telphone"></param>
        /// <param name="email"></param>
        /// <param name="remark"></param>
        /// <param name="by"></param>
        /// <returns></returns>
        public string UpdateUser(string id, string userid, string pwd, string username, string telphone, string email, string remark, string review, string by)
        {
            try
            {
                using (BFdbContext db = new BFdbContext())
                {
                    if (db.TBUSER.Any(p => p.USERID == userid && p.DELFLAG == "0" && p.ID != id))
                    {
                        return("已经存在相同用户");
                    }

                    TBUSER user = db.TBUSER.Find(id);
                    user.USERID     = userid;
                    user.USERNAME   = username;
                    user.PWD        = pwd;
                    user.EMAIL      = email;
                    user.REMARK     = remark;
                    user.TELEPHONE  = telphone;
                    user.UPDATEDATE = DateTime.Now;
                    user.UPDATEID   = by;
                    user.RE_REVIEW  = review;

                    return(db.Update <TBUSER>(user).ToString());
                }
            }
            catch (Exception ex)
            {
                log.Error(ex);
                throw GetFault(ex);
            }
        }
Exemple #2
0
        /// <summary>
        /// 删除用户
        /// </summary>
        /// <param name="id"></param>
        /// <param name="by"></param>
        /// <returns></returns>
        public string DelUser(string id, string by)
        {
            try
            {
                using (BFdbContext db = new BFdbContext())
                {
                    TBUSER user = db.TBUSER.FirstOrDefault(p => p.USERID == id && p.DELFLAG == "0");
                    user.DELFLAG    = "1";
                    user.UPDATEDATE = DateTime.Now;
                    user.UPDATEID   = by;

                    return(db.Update <TBUSER>(user).ToString());
                }
            }
            catch (Exception ex)
            {
                log.Error(ex);
                throw GetFault(ex);
            }
        }