/// <summary> /// 删除表格 /// </summary> /// <param name="tableCode"></param> /// <returns></returns> public int DeleteTableInfo(string tableCode) { int affectRows = 0; SqlHelper svc = null; try { List <DacParm> lstParm = new List <DacParm>(); svc = new SqlHelper(EnumBiz.onlineDB); EntityEmrTableFieldInfo fieldVo = new EntityEmrTableFieldInfo(); fieldVo.tableCode = tableCode; lstParm.Add(svc.GetDelParm(fieldVo, EntityEmrTableFieldInfo.Columns.tableCode)); EntityEmrTableBasicInfo tableVo = new EntityEmrTableBasicInfo(); tableVo.tableCode = tableCode; lstParm.Add(svc.GetDelParm(tableVo, EntityEmrTableBasicInfo.Columns.tableCode)); affectRows = svc.Commit(lstParm); } catch (Exception ex) { ExceptionLog.OutPutException(Function.GetExceptionCaption(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message)); affectRows = -1; } finally { svc = null; } return(affectRows); }
/// <summary> /// 删除表格 /// </summary> /// <param name="tableCode"></param> /// <returns></returns> public int DeleteTableInfo(string tableCode) { int affectRows = 0; SqlHelper svc = null; try { List <DacParm> lstParm = new List <DacParm>(); svc = new SqlHelper(EnumBiz.onlineDB); EntityEmrTableFieldInfo fieldVo = new EntityEmrTableFieldInfo(); fieldVo.tableCode = tableCode; lstParm.Add(svc.GetDelParm(fieldVo, EntityEmrTableFieldInfo.Columns.tableCode)); EntityEmrTableBasicInfo tableVo = new EntityEmrTableBasicInfo(); tableVo.tableCode = tableCode; lstParm.Add(svc.GetDelParm(tableVo, EntityEmrTableBasicInfo.Columns.tableCode)); affectRows = svc.Commit(lstParm); } catch (Exception e) { ExceptionLog.OutPutException(e); affectRows = -1; } finally { svc = null; } return(affectRows); }
/// <summary> /// 表格明细 /// </summary> /// <param name="tableCode"></param> /// <returns></returns> public List <EntityEmrTableFieldInfo> GetTableFieldInfo(string tableCode) { List <EntityEmrTableFieldInfo> data = new List <EntityEmrTableFieldInfo>(); EntityEmrTableFieldInfo vo = null; SqlHelper svc = null; try { svc = new SqlHelper(EnumBiz.onlineDB); vo = new EntityEmrTableFieldInfo(); vo.tableCode = tableCode; DataTable dt = svc.Select(vo, EntityEmrTableFieldInfo.Columns.tableCode); DataView dv = new DataView(dt); dv.Sort = "sortNo"; data = EntityTools.ConvertToEntityList <EntityEmrTableFieldInfo>(dv.ToTable()); } catch (Exception ex) { ExceptionLog.OutPutException(Function.GetExceptionCaption(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message)); } finally { svc = null; } return(data); }
/// <summary> /// 表格明细 /// </summary> /// <param name="tableCode"></param> /// <returns></returns> public List <EntityEmrTableFieldInfo> GetTableFieldInfo(string tableCode) { List <EntityEmrTableFieldInfo> data = new List <EntityEmrTableFieldInfo>(); EntityEmrTableFieldInfo vo = null; SqlHelper svc = null; try { svc = new SqlHelper(EnumBiz.onlineDB); vo = new EntityEmrTableFieldInfo(); vo.tableCode = tableCode; DataTable dt = svc.Select(vo, EntityEmrTableFieldInfo.Columns.tableCode); DataView dv = new DataView(dt); dv.Sort = "sortNo"; data = EntityTools.ConvertToEntityList <EntityEmrTableFieldInfo>(dv.ToTable()); } catch (Exception e) { ExceptionLog.OutPutException(e); } finally { svc = null; } return(data); }
/// <summary> /// 保存表格 /// </summary> /// <param name="tableVo"></param> /// <param name="lstTableField"></param> /// <returns></returns> public int SaveTableInfo(EntityEmrTableBasicInfo tableVo, List <EntityEmrTableFieldInfo> lstTableField) { int affectRows = 0; SqlHelper svc = null; try { bool haveFields = (lstTableField != null && lstTableField.Count > 0 ? true : false); svc = new SqlHelper(EnumBiz.onlineDB); List <DacParm> lstParm = new List <DacParm>(); if (!string.IsNullOrEmpty(tableVo.origTableCode)) { if (tableVo.origTableCode == tableVo.tableCode) { lstParm.Add(svc.GetUpdateParmByPk(tableVo)); EntityEmrTableFieldInfo vo2 = new EntityEmrTableFieldInfo(); vo2.tableCode = tableVo.tableCode; lstParm.Add(svc.GetDelParm(vo2, EntityEmrTableFieldInfo.Columns.tableCode)); } else { EntityEmrTableBasicInfo vo1 = new EntityEmrTableBasicInfo(); vo1.tableCode = tableVo.origTableCode; lstParm.Add(svc.GetDelParmByPk(vo1)); lstParm.Add(svc.GetInsertParm(tableVo)); EntityEmrTableFieldInfo vo2 = new EntityEmrTableFieldInfo(); vo2.tableCode = tableVo.origTableCode; lstParm.Add(svc.GetDelParm(vo2, EntityEmrTableFieldInfo.Columns.tableCode)); } if (haveFields) { lstParm.Add(svc.GetInsertParm(lstTableField.ToArray())); } } else { lstParm.Add(svc.GetInsertParm(tableVo)); if (haveFields) { lstParm.Add(svc.GetInsertParm(lstTableField.ToArray())); } } affectRows = svc.Commit(lstParm); } catch (Exception ex) { ExceptionLog.OutPutException(Function.GetExceptionCaption(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message)); affectRows = -1; } finally { svc = null; } return(affectRows); }