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