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