/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="entity">实体对象</param> /// <returns></returns> public void SaveForm(string keyValue, HazardfactorsEntity entity, string UserName, string UserId) { //开始事物 var res = DbFactory.Base().BeginTrans(); try { string id = ""; if (!string.IsNullOrEmpty(keyValue)) { entity.Modify(keyValue); res.Update <HazardfactorsEntity>(entity); id = entity.Hid; } else { entity.Create(); res.Insert <HazardfactorsEntity>(entity); id = entity.Hid; } //先删除该危害因素下的所有人员 string sql = string.Format("delete from BIS_HAZARDFACTORUSER where hid='{0}'", id); res.ExecuteBySql(sql); //新增关联用户表 List <HazardfactoruserEntity> hulist = new List <HazardfactoruserEntity>(); string[] names = UserName.Split(','); string[] ids = UserId.Split(','); for (int i = 0; i < ids.Length; i++) { HazardfactoruserEntity hu = new HazardfactoruserEntity(); hu.Hid = id; hu.UserId = ids[i]; hu.UserName = names[i]; hu.Create(); hulist.Add(hu); } res.Insert <HazardfactoruserEntity>(hulist); res.Commit(); } catch (Exception ex) { res.Rollback(); throw ex; } }