/// <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)); }
/// <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); } }
/// <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)); }