/// <summary> /// 读取组织机构-用户帐号 /// </summary> /// <param name="loginId">登录ID</param> /// <param name="account"></param> /// <returns></returns> public OrgUserEntity ReadOrgUser(string loginId, string account) { OrgUserEntity orgUserEntity = new OrgUserEntity(); if (ComFunction.ExistUserLoginID(loginId) == false) { orgUserEntity.Result = false; orgUserEntity.Desc = ResCode.UL003Desc; return orgUserEntity; } try { DataTable dt = ComFunction.ReadOrgUser(account); foreach (DataRow dr in dt.Rows) { orgUserEntity.Account = dr["Account"].ToString(); orgUserEntity.OrgID = dr["OrgID"].ToString(); orgUserEntity.Status = (Status)dr["Status"]; } orgUserEntity.Desc = "获取组织机构-用户帐号成功!"; orgUserEntity.Result = true; } catch (Exception ex) { orgUserEntity.Result = false; orgUserEntity.Desc = "获取组织机构-用户帐号记录出错,原因:" + ex.ToString(); ManagerLog.WriteErr(ex); } return orgUserEntity; }
/// <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); }
/// <summary> /// 修改用组织机构-用户帐号 /// </summary> /// <param name="loginId"></param> /// <param name="orgUserEntity"></param> /// <returns></returns> public EntityBase UpdateOrgUser(string loginId, OrgUserEntity orgUserEntity) { TradeUser TdUser = new TradeUser(); if (ComFunction.ExistUserLoginID(loginId, ref TdUser) == false) { return entityBase; } try { ComFunction.UpdateOrgUser(orgUserEntity); entityBase.Result = true; entityBase.Desc = "组织机构-用户帐号修改成功"; } catch (Exception ex) { SetException("组织机构-用户帐号修改失败,原因:", ex); } return entityBase; }
/// <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); }