public void Delete(AscmEmployee ascmEmployee) { try { //删除与用户的关联 string sql = "from AscmEmployeeCar where employeeId=" + ascmEmployee.id; IList<AscmEmployeeCar> ilistAscmEmployeeCar = YnDaoHelper.GetInstance().nHibernateHelper.Find<AscmEmployeeCar>(sql); if (ilistAscmEmployeeCar != null && ilistAscmEmployeeCar.Count > 0) { List<AscmEmployeeCar> list = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList<AscmEmployeeCar>(ilistAscmEmployeeCar); YnDaoHelper.GetInstance().nHibernateHelper.DeleteList(list); } ////删除与模块的关联 //sql = "from YnWebModuleRoleLink where ascmEmployee.id=" + ascmEmployee.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<AscmEmployee>(ascmEmployee); } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("删除失败(Delete AscmEmployee)", ex); throw ex; } }
public ContentResult EmployeeSave(AscmEmployee ascmEmployee_Model, int? id) { JsonObjectResult jsonObjectResult = new JsonObjectResult(); try { AscmEmployee ascmEmployee = null; if (id.HasValue) { ascmEmployee = AscmEmployeeService.GetInstance().Get(id.Value); } else { ascmEmployee = new AscmEmployee(); } if (ascmEmployee == null) throw new Exception("保存员工基本信息失败!"); if (ascmEmployee_Model.name == null || ascmEmployee_Model.name.Trim() == "") throw new Exception("员工名称不能为空!"); ascmEmployee.docNumber = ascmEmployee_Model.docNumber.Trim(); ascmEmployee.name = ascmEmployee_Model.name.Trim(); ascmEmployee.sex = ascmEmployee_Model.sex.Trim(); ascmEmployee.idNumber = ascmEmployee_Model.idNumber.Trim(); ascmEmployee.email = ascmEmployee_Model.email; ascmEmployee.officeTel = ascmEmployee_Model.officeTel; ascmEmployee.mobileTel = ascmEmployee_Model.mobileTel; ascmEmployee.memo = ascmEmployee_Model.memo; ascmEmployee.departmentId = ascmEmployee_Model.departmentId; if (!id.HasValue) { object object1 = YnDaoHelper.GetInstance().nHibernateHelper.GetObject("select count(*) from AscmEmployee where docNumber='" + ascmEmployee_Model.docNumber.Trim() + "'"); if (object1 == null) throw new Exception("查询异常!"); int iCount = 0; if (int.TryParse(object1.ToString(), out iCount) && iCount > 0) throw new Exception("已经存在此员工编号【" + ascmEmployee_Model.docNumber.Trim() + "】!"); object1 = YnDaoHelper.GetInstance().nHibernateHelper.GetObject("select count(*) from AscmEmployee where name='" + ascmEmployee_Model.name.Trim() + "'"); if (object1 == null) throw new Exception("查询异常!"); //int iCount = 0; if (int.TryParse(object1.ToString(), out iCount) && iCount > 0) throw new Exception("已经存在此员工姓名【" + ascmEmployee_Model.name.Trim() + "】!"); AscmEmployeeService.GetInstance().Save(ascmEmployee); } else { object object1 = YnDaoHelper.GetInstance().nHibernateHelper.GetObject("select count(*) from AscmEmployee where docNumber='" + ascmEmployee_Model.docNumber.Trim() + "' and id<>" + id.Value + ""); if (object1 == null) throw new Exception("查询异常!"); int iCount = 0; if (int.TryParse(object1.ToString(), out iCount) && iCount > 0) throw new Exception("已经存在此员工编号【" + ascmEmployee_Model.docNumber.Trim() + "】!"); object1 = YnDaoHelper.GetInstance().nHibernateHelper.GetObject("select count(*) from AscmEmployee where name='" + ascmEmployee_Model.name.Trim() + "' and id<>" + id.Value + ""); if (object1 == null) throw new Exception("查询异常!"); //int iCount = 0; if (int.TryParse(object1.ToString(), out iCount) && iCount > 0) throw new Exception("已经存在此员工姓名【" + ascmEmployee_Model.name.Trim() + "】!"); AscmEmployeeService.GetInstance().Update(ascmEmployee); } jsonObjectResult.result = true; jsonObjectResult.message = ""; jsonObjectResult.id = ascmEmployee.id.ToString(); jsonObjectResult.entity = ascmEmployee; } catch (Exception ex) { jsonObjectResult.message = ex.Message; } string sReturn = JsonConvert.SerializeObject(jsonObjectResult); return Content(sReturn); }
public void Update(AscmEmployee ascmEmployee) { int count = YnDaoHelper.GetInstance().nHibernateHelper.GetCount("select count(*) from AscmEmployee where id<>" + ascmEmployee.id + " and docNumber='" + ascmEmployee.docNumber + "'"); if (count == 0) { using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction()) { try { YnDaoHelper.GetInstance().nHibernateHelper.Update<AscmEmployee>(ascmEmployee); tx.Commit();//正确执行提交 } catch (Exception ex) { tx.Rollback();//回滚 YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmEmployee)", ex); throw ex; } } } else { throw new Exception("已经存在员工编号\"" + ascmEmployee.name + "\"!"); } }
/*private void SetDepartment(List<AscmEmployee> list) { if (list != null && list.Count > 0) { string ids = string.Empty; foreach (AscmEmployee ascmEmployee in list) { if (!string.IsNullOrEmpty(ids)) ids += ","; ids += "" + ascmEmployee.departmentId + ""; } string sql = "from YnFrame.Dal.Entities.YnDepartment where id in (" + ids + ")"; IList<YnFrame.Dal.Entities.YnDepartment> ilistYnDepartment = YnFrame.Dal.YnDaoHelper.GetInstance().nHibernateHelper.Find<YnFrame.Dal.Entities.YnDepartment>(sql); if (ilistYnDepartment != null && ilistYnDepartment.Count > 0) { List<YnFrame.Dal.Entities.YnDepartment> listYnDepartment = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList<YnFrame.Dal.Entities.YnDepartment>(ilistYnDepartment); foreach (AscmEmployee ascmEmployee in list) { ascmEmployee.ynDepartment = listYnDepartment.Find(e => e.id == ascmEmployee.departmentId); } } } }*/ public void Save(AscmEmployee ascmEmployee) { try { int count = YnDaoHelper.GetInstance().nHibernateHelper.GetCount("select count(*) from AscmEmployee where docNumber='" + ascmEmployee.docNumber + "'"); if (count == 0) { int maxId = YnDaoHelper.GetInstance().nHibernateHelper.GetMaxId("select max(id) from AscmEmployee"); using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction()) { try { maxId++; ascmEmployee.id = maxId; YnDaoHelper.GetInstance().nHibernateHelper.Save(ascmEmployee); tx.Commit();//正确执行提交 } catch (Exception ex) { tx.Rollback();//回滚 throw ex; } } } else { throw new Exception("已经存在员工编号\"" + ascmEmployee.name + "\"!"); } } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("保存失败(Save AscmEmployee)", ex); throw ex; } }