public void Save(AscmWhTeamUser ascmWhTeamUser)
{
try
{
int count = YnDaoHelper.GetInstance().nHibernateHelper.GetCount("select count(*) from AscmWhTeamUser where teamId=" + ascmWhTeamUser.pk.teamId + " and userId='" + ascmWhTeamUser.pk.userId + "'");
if (count == 0)
{
using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction())
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Save(ascmWhTeamUser);
tx.Commit(); //正确执行提交
}
catch (Exception ex)
{
tx.Rollback(); //回滚
throw ex;
}
}
}
else
{
//throw new Exception("已经存在组别与用户的关联！");
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("保存失败(Save AscmWhTeamUser)", ex);
throw ex;
}
}
public void Delete(AscmWhTeamUser ascmWhTeamUser)
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Delete <AscmWhTeamUser>(ascmWhTeamUser);
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("删除失败(Delete AscmWhTeamUser)", ex);
throw ex;
}
}
public void Delete(int teamId, string userId)
{
try
{
AscmWhTeamUser ascmWhTeamUser = Get(teamId, userId);
Delete(ascmWhTeamUser);
}
catch (Exception ex)
{
throw ex;
}
}
public List <AscmUserInfo> GetList(int teamId)
{
List <AscmUserInfo> list = new List <AscmUserInfo>();
try
{
StringBuilder sql = new StringBuilder(" from AscmUserInfo a ");
StringBuilder userIds = new StringBuilder();
List <AscmWhTeamUser> listTeamUser = AscmWhTeamUserService.Instance.GetList(teamId);
if (listTeamUser == null || listTeamUser.Count == 0)
{
return(list);
}
for (int i = 0; i < listTeamUser.Count; i++)
{
userIds.Append("'" + listTeamUser[i].M_UserId + "'");
if (i < listTeamUser.Count - 1)
{
userIds.Append(",");
}
}
sql.AppendFormat(" where userId in ({0}) ", userIds);
sql.AppendFormat(" order by userId ");
var ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmUserInfo>(sql.ToString());
if (ilist != null)
{
list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmUserInfo>(ilist);
AscmWhTeamUser leader = listTeamUser.FirstOrDefault(a => a.isLeader == true);
if (leader != null)
{
foreach (var item in list)
{
if (item.userId == leader.M_UserId)
{
item.isLeader = true;
break;
}
}
}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Find YnUser)", ex);
throw ex;
}
return(list);
}
public void Update(AscmWhTeamUser ascmWhTeamUser)
{
using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction())
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Update <AscmWhTeamUser>(ascmWhTeamUser);
tx.Commit(); //正确执行提交
}
catch (Exception ex)
{
tx.Rollback(); //回滚
YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmWhTeamUser)", ex);
throw ex;
}
}
}
public AscmWhTeamUser Get(int teamId, string userId)
{
AscmWhTeamUser AscmTeamUser = null;
try
{
AscmTeamUser = YnDaoHelper.GetInstance().nHibernateHelper.Get <AscmWhTeamUser>(new AscmWhTeamUserPK {
teamId = teamId, userId = userId
});
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error(" 查询失败 (Get AscmTeamUser) ", ex);
throw ex;
}
return(AscmTeamUser);
}
