/// <summary> /// 获取通用单据的详细信息 /// </summary> /// <param name="commonNoteFlow"></param> /// <returns></returns> public CommonNoteEntity GetDetailCommonNote(string commonNoteFlow) { try { CommonNoteEntity commonNoteEntity = new CommonNoteEntity(); SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("@CommonNoteFlow", SqlDbType.VarChar, 50) }; sqlParams[0].Value = commonNoteFlow; DataSet dataTableElement = m_app.SqlHelper.ExecuteDataSet("EMR_CommonNote.usp_GetDetailCommonNote", sqlParams, CommandType.StoredProcedure); commonNoteEntity = DataTableToList <CommonNoteEntity> .ConvertToModelOne(dataTableElement.Tables[0]); commonNoteEntity.CommonNote_TabList = DataTableToList <CommonNote_TabEntity> .ConvertToModel(dataTableElement.Tables[1]); List <CommonNote_ItemEntity> commonNote_ItemList = new List <CommonNote_ItemEntity>(); commonNote_ItemList = DataTableToList <CommonNote_ItemEntity> .ConvertToModel(dataTableElement.Tables[2]); SetCommonNoteTabByItem(commonNoteEntity, commonNote_ItemList); SetCommonNoteSiteOne(commonNoteEntity); return(commonNoteEntity); } catch (Exception ex) { throw ex; } }
/// <summary> /// 通过流水号获取数据元 /// </summary> /// <param name="dataElementFlow"></param> /// <returns></returns> public DataElementEntity GetDataElement(string dataElementFlow) { SqlParameter[] sqlParams = new SqlParameter[] { new SqlParameter("@ElementFlow", SqlDbType.VarChar, 50) }; sqlParams[0].Value = dataElementFlow; DataTable dataTableElement = m_app.SqlHelper.ExecuteDataTable("EMR_CommonNote.usp_GetDateElementOne", sqlParams, CommandType.StoredProcedure); DataElementEntity dataElementEntity = DataTableToList <DataElementEntity> .ConvertToModelOne(dataTableElement); return(dataElementEntity); }
/// <summary> /// 通用单据匹配使用 /// </summary> /// <param name="commnoteflow"></param> /// <returns></returns> public static CommonNoteCountEntity GetCommonNoteCount(string commnoteflow) { try { string sqlStr = string.Format(@"select * from commonnotecount c where c.commonnoteflow='{0}'", commnoteflow); DataTable dt = DrectSoft.DSSqlHelper.DS_SqlHelper.ExecuteDataTable(sqlStr, CommandType.Text); CommonNoteCountEntity commonNoteCountEntity = DataTableToList <CommonNoteCountEntity> .ConvertToModelOne(dt); return(commonNoteCountEntity); } catch (Exception ex) { throw ex; } }
/// <summary> /// 通过流水号获取配置单 /// </summary> /// <param name="commonNoteFlow"></param> /// <returns></returns> public CommonNoteEntity GetSimpleCommonNoteByflow(string commonNoteFlow) { try { string sql = string.Format("select * from commonnote where commonnote.commonnoteflow='{0}';", commonNoteFlow); DataTable dtCommonNote = m_app.SqlHelper.ExecuteDataTable(sql, CommandType.Text); CommonNoteEntity commonNoteEntity = DataTableToList <CommonNoteEntity> .ConvertToModelOne(dtCommonNote); SetCommonNoteSiteOne(commonNoteEntity); return(commonNoteEntity); } catch (Exception ex) { throw ex; } }