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