public int SearchDataDetail(string minID, string maxID, out System.Data.DataTable dtResult)
{
SYS_JournalDao dao = new SYS_JournalDao();
return(dao.SelectDataDetail(!CommonMethod.IsNullOrEmpty(minID) ? int.Parse(minID) : new Nullable <int>(),
!CommonMethod.IsNullOrEmpty(maxID) ? int.Parse(maxID) : new Nullable <int>(), out dtResult));
}
/// <summary>
/// Search Data in Sy_SystemJournals table
/// </summary>
/// <param name="selectDto">
/// Dto of MSSJ00Form
/// </param>
/// <param name="dtResult">
/// Out a Datatable that contains search result(all columns) in Sy_SystemJournals table
/// </param>
/// <returns>
/// 0: Search successful
/// others: Sql Error
/// </returns>
public int SearchData(IDto selectDto, out System.Data.DataTable dtResult)
{
SYS_JournalDao mSSJ00Dao = new SYS_JournalDao();
SYS_JournalDto dto = (SYS_JournalDto)selectDto;
int returnCode = CommonData.DbReturnCode.Succeed;
returnCode = mSSJ00Dao.SelectData(dto, out dtResult);
if (returnCode != CommonData.DbReturnCode.Succeed)
{
return(returnCode);
}
if (dtResult.Rows.Count > 0)
{
System.Data.DataTable dtTemp1 = new System.Data.DataTable();
returnCode = this.SearchDataDetail(dtResult.Rows[0][SYS_JournalKey.ID].ToString(), dtResult.Rows[dtResult.Rows.Count - 1][SYS_JournalKey.ID].ToString(), out dtTemp1);
if (returnCode != CommonData.DbReturnCode.Succeed)
{
return(returnCode);
}
System.Data.DataTable dtDetail = new System.Data.DataTable();
dtDetail.Columns.Add("ID", typeof(long));
dtDetail.Columns.Add("Name", typeof(string));
dtDetail.Columns.Add("Value", typeof(string));
System.Data.DataTable dtTemp2 = new System.Data.DataTable();
foreach (System.Data.DataRow r in dtResult.Rows)
{
dtTemp2 = this.SearchDataDetail(r[SYS_JournalKey.ID].ToString(), dtTemp1);
foreach (System.Data.DataRow rTemp in dtTemp2.Rows)
{
for (int i = 1; i <= 100; i++)
{
if (rTemp[SYS_JournalKey.FieldName + i].ToString() != CommonData.StringEmpty)
{
dtDetail.Rows.Add(rTemp[SYS_JournalKey.ParentID], rTemp[SYS_JournalKey.FieldName + i], rTemp[SYS_JournalKey.FieldValue + i]);
}
else
{
break;
}
}
}
}
System.Data.DataSet dataSet = new System.Data.DataSet();
dataSet.Tables.Add(dtResult);
dataSet.Tables.Add(dtDetail);
dataSet.Relations.Add(" ", dataSet.Tables[0].Columns[SYS_JournalKey.ID],
dataSet.Tables[1].Columns[SYS_JournalKey.ID]);
}
return(returnCode);
}
