コード例 #1
0
        /// <summary>
        /// 修改组织机构-用户帐号
        /// </summary>
        /// <param name="orgUserEntity"></param>

        public static int UpdateOrgUser(OrgUserEntity orgUserEntity)
        {
            string sqlCommand = string.Format(@"UPDATE  Base_OrgUser SET OrgID = '{0}',Status = '{1}' WHERE   Account = '{2}'", orgUserEntity.OrgID, (int)orgUserEntity.Status, orgUserEntity.Account);

            return(DbHelper.ExecuteNonQuery(sqlCommand));
        }
コード例 #2
0
        /// <summary>
        /// 5.3.8	修改绑定帐号
        /// </summary>
        /// <param name="loginID">登录ID</param>
        /// <param name="orgID">会员账户信息</param>
        /// <param name="account">微会员名</param>
        /// <param name="state">启用状态</param>
        /// <returns></returns>
        public ErrType UpdateOrgUser(string loginID, string orgID, string account, bool state)
        {
            try
            {
                OrgUserEntity orgUserEntity = new OrgUserEntity();
                orgUserEntity.OrgID = orgID;
                orgUserEntity.Account = account;
                orgUserEntity.Status = state ? Status.Enabled : Status.Disable;//Enabled=1,//启用
                EntityBase result = ManagerService.UpdateOrgUser(loginID, orgUserEntity);
                if (!result.Result)
                    return new ErrType(ERR.SERVICE, result.Desc);

                return GeneralErr.Success;
            }
            catch (TimeoutException te)
            {
                FileLog.WriteLog("", Assembly.GetExecutingAssembly().GetName().Name, this.GetType().Name, new StackTrace().GetFrame(0).GetMethod().Name, te.Message); return new ErrType(ERR.EXEPTION, ErrorText.TimeoutException);
            }
            catch (Exception ex)
            {
                FileLog.WriteLog("", Assembly.GetExecutingAssembly().GetName().Name, this.GetType().Name,
              new StackTrace().GetFrame(0).GetMethod().Name, ex.Message);
                return new ErrType(ERR.EXEPTION, ErrorText.OperationError);
            }
        }
コード例 #3
0
        /// <summary>
        /// 新增组织机构-用户帐号
        /// </summary>
        /// <param name="orgUserEntity"></param>
        /// <returns></returns>

        public static int AddOrgUser(OrgUserEntity orgUserEntity)
        {
            string sqlCommand = string.Format(@"INSERT INTO Base_OrgUser (OrgID,Account,Status)   VALUES ('{0}' ,'{1}' ,'{2}')", orgUserEntity.OrgID, orgUserEntity.Account, (int)orgUserEntity.Status);

            return(DbHelper.ExecuteNonQuery(sqlCommand));
        }