public List <IndentDetail> Search()
{
List <IndentDetail> indentDetailList = new List <IndentDetail>();
try
{
string errorMessage = string.Empty;
DataSet dSet = GetSelectedRecords(Common.ToXml(this), SP_INDENT_DETAIL_SEARCH, ref errorMessage);
//System.Data.DataTable dTable = GetSelectedRecords(Common.ToXml(this), SP_INDENT_DETAIL_SEARCH, ref errorMessage);
if (dSet == null | dSet.Tables[0].Rows.Count <= 0)
{
return(null);
}
foreach (System.Data.DataRow drow in dSet.Tables[0].Rows)
{
IndentDetail indentDetail = new IndentDetail();
indentDetail.CreateIndentDetailObject(drow);
indentDetail.GetPONO(dSet.Tables[1]);
indentDetail.GetTONO(dSet.Tables[2]);
indentDetailList.Add(indentDetail);
}
return(indentDetailList);
}
catch (Exception ex)
{
throw ex;
}
}
public List <IndentDetail> GetIndentDetail()
{
try
{
List <IndentDetail> _indentDetailList = new List <IndentDetail>();
string dbMessage = string.Empty;
DBParameterList dbParam = new DBParameterList();
dbParam.Add(new DBParameter("@IndentNo", this.IndentNo, DbType.String));
dbParam.Add(new DBParameter(Common.PARAM_OUTPUT, dbMessage, DbType.String, ParameterDirection.Output, Common.PARAM_OUTPUT_LENGTH));
using (DataTaskManager dt = new DataTaskManager())
{
System.Data.DataSet dSet = new DataSet();
dSet = dt.ExecuteDataSet(SP_GET_INDENT_DETAIL, dbParam);
if (dbMessage.Trim().Equals(string.Empty) && dSet != null && dSet.Tables.Count > 0 && dSet.Tables[0].Rows.Count > 0)
{
foreach (DataRow dr in dSet.Tables[0].Rows)
{
IndentDetail detail = new IndentDetail();
detail.CreateIndentDetailObject(dr);
detail.GetPONO(dSet.Tables[1]);
detail.GetTONO(dSet.Tables[2]);
_indentDetailList.Add(detail);
}
}
}
return(_indentDetailList);
}
catch (Exception ex)
{
throw ex;
}
}