public void Delete(AscmEmployeeCar ascmEmployeeCar)
{
try
{
////删除与用户的关联
//string sql = "from YnUserRoleLink where ids.roleId=" + ascmEmployeeCar.id;
//IList<YnUserRoleLink> ilistUserRoleLink = YnDaoHelper.GetInstance().nHibernateHelper.Find<YnUserRoleLink>(sql);
//if (ilistUserRoleLink != null && ilistUserRoleLink.Count > 0)
//{
// List<YnUserRoleLink> list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList<YnUserRoleLink>(ilistUserRoleLink);
// YnDaoHelper.GetInstance().nHibernateHelper.DeleteList(list);
//}
////删除与模块的关联
//sql = "from YnWebModuleRoleLink where ascmEmployeeCar.id=" + ascmEmployeeCar.id;
//IList<YnWebModuleRoleLink> ilistModuleRoleLink = YnDaoHelper.GetInstance().nHibernateHelper.Find<YnWebModuleRoleLink>(sql);
//if (ilistModuleRoleLink != null && ilistModuleRoleLink.Count > 0)
//{
// List<YnWebModuleRoleLink> list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList<YnWebModuleRoleLink>(ilistModuleRoleLink);
// YnDaoHelper.GetInstance().nHibernateHelper.DeleteList(list);
//}
YnDaoHelper.GetInstance().nHibernateHelper.Delete <AscmEmployeeCar>(ascmEmployeeCar);
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("删除失败(Delete AscmEmployeeCar)", ex);
throw ex;
}
}
public void Update(AscmEmployeeCar ascmEmployeeCar)
{
int count = YnDaoHelper.GetInstance().nHibernateHelper.GetCount("select count(*) from AscmEmployeeCar where id<>" + ascmEmployeeCar.id + " and plateNumber='" + ascmEmployeeCar.plateNumber + "'");
if (count == 0)
{
using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction())
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Update <AscmEmployeeCar>(ascmEmployeeCar);
tx.Commit();//正确执行提交
}
catch (Exception ex)
{
tx.Rollback();//回滚
YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmEmployeeCar)", ex);
throw ex;
}
}
}
else
{
throw new Exception("已经存在车辆牌号\"" + ascmEmployeeCar.plateNumber + "\"！");
}
}
public void Save(AscmEmployeeCar ascmEmployeeCar)
{
try
{
int count = YnDaoHelper.GetInstance().nHibernateHelper.GetCount("select count(*) from AscmEmployeeCar where plateNumber='" + ascmEmployeeCar.plateNumber + "'");
if (count == 0)
{
int maxId = YnDaoHelper.GetInstance().nHibernateHelper.GetMaxId("select max(id) from AscmEmployeeCar");
using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction())
{
try
{
maxId++;
ascmEmployeeCar.id = maxId;
YnDaoHelper.GetInstance().nHibernateHelper.Save(ascmEmployeeCar);
tx.Commit();//正确执行提交
}
catch (Exception ex)
{
tx.Rollback();//回滚
throw ex;
}
}
}
else
{
throw new Exception("已经存在车辆牌号\"" + ascmEmployeeCar.plateNumber + "\"！");
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("保存失败(Save AscmEmployeeCar)", ex);
throw ex;
}
}
private void SetBindDescription(List <AscmRfid> list)
{
if (list != null && list.Count > 0)
{
string ids_EmployeeCar = string.Empty;
foreach (AscmRfid ascmRfid in list)
{
if (ascmRfid.bindType == AscmRfid.BindTypeDefine.employeeCar && !string.IsNullOrEmpty(ascmRfid.bindId))
{
if (!string.IsNullOrEmpty(ids_EmployeeCar))
{
ids_EmployeeCar += ",";
}
ids_EmployeeCar += "" + ascmRfid.bindId + "";
}
}
if (ids_EmployeeCar != "")
{
string sql = "from AscmEmployeeCar where id in (" + ids_EmployeeCar + ")";
IList <AscmEmployeeCar> ilistAscmEmployeeCar = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmEmployeeCar>(sql);
if (ilistAscmEmployeeCar != null && ilistAscmEmployeeCar.Count > 0)
{
List <AscmEmployeeCar> listAscmEmployeeCar = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmEmployeeCar>(ilistAscmEmployeeCar);
AscmEmployeeCarService.GetInstance().SetEmployee(listAscmEmployeeCar);
foreach (AscmRfid ascmRfid in list)
{
AscmEmployeeCar ascmEmployeeCar = listAscmEmployeeCar.Find(e => e.id.ToString() == ascmRfid.bindId);
//if(ascmEmployeeCar!=null)
// ascmRfid._bindDescription = ascmEmployeeCar ._employeeName+"->"+ ascmEmployeeCar.plateNumber;
}
}
}
}
}
public void Save(bool _new, AscmEmployeeCar ascmEmployeeCar, AscmRfid ascmRfid_Old, AscmRfid ascmRfid_New_Update, AscmRfid ascmRfid_New_Save)
{
try
{
DateTime dtServerTime = MideaAscm.Dal.YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentDate("AscmEmployeeCar");
ascmEmployeeCar.modifyTime = dtServerTime.ToString("yyyy-MM-dd HH:mm:ss");
if (ascmRfid_Old != null)
{
ascmRfid_Old.modifyTime = dtServerTime.ToString("yyyy-MM-dd HH:mm:ss");
}
if (ascmRfid_New_Update != null)
{
ascmRfid_New_Update.modifyTime = dtServerTime.ToString("yyyy-MM-dd HH:mm:ss");
}
if (ascmRfid_New_Save != null)
{
ascmRfid_New_Save.modifyTime = dtServerTime.ToString("yyyy-MM-dd HH:mm:ss");
}
using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction())
{
try
{
if (_new)
{
ascmEmployeeCar.createTime = dtServerTime.ToString("yyyy-MM-dd HH:mm:ss");
YnDaoHelper.GetInstance().nHibernateHelper.Save(ascmEmployeeCar);
}
else
{
YnDaoHelper.GetInstance().nHibernateHelper.Update(ascmEmployeeCar);
}
if (ascmRfid_Old != null)
{
YnDaoHelper.GetInstance().nHibernateHelper.Update(ascmRfid_Old);
}
if (ascmRfid_New_Update != null)
{
YnDaoHelper.GetInstance().nHibernateHelper.Update(ascmRfid_New_Update);
}
if (ascmRfid_New_Save != null)
{
ascmRfid_New_Save.createTime = dtServerTime.ToString("yyyy-MM-dd HH:mm:ss");
YnDaoHelper.GetInstance().nHibernateHelper.Save(ascmRfid_New_Save);
}
tx.Commit();//正确执行提交
}
catch (Exception ex)
{
tx.Rollback();//回滚
throw ex;
}
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("保存失败(Save AscmEmployeeCar)", ex);
throw ex;
}
}
public void Delete(int id)
{
try
{
AscmEmployeeCar ascmEmployeeCar = Get(id);
Delete(ascmEmployeeCar);
}
catch (Exception ex)
{
throw ex;
}
}
public AscmEmployeeCar Get(int id)
{
AscmEmployeeCar ascmEmployeeCar = null;
try
{
ascmEmployeeCar = YnDaoHelper.GetInstance().nHibernateHelper.Get <AscmEmployeeCar>(id);
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmEmployeeCar)", ex);
throw ex;
}
return(ascmEmployeeCar);
}
public AscmEmployeeCar GetByRfid(string rfid)
{
AscmEmployeeCar ascmEmployeeCar = null;
try
{
IList <AscmEmployeeCar> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmEmployeeCar>("from AscmEmployeeCar where id in (select bindId from AscmRfid where id='" + rfid + "')");// and status='" + AscmRfid.StatusDefine.inUse + "'
if (ilist != null && ilist.Count > 0)
{
List <AscmEmployeeCar> list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmEmployeeCar>(ilist);
//SetEmployee(list);
return(list[0]);
}
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmEmployeeCar)", ex);
throw ex;
}
return(ascmEmployeeCar);
}
