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