public IList<HYPDM.Entities.PDM_DOCUMENT> GetQueryResult(string queryStr)
{
IList<HYPDM.Entities.PDM_DOCUMENT> list = null;
HYPDM.Entities.PDM_DOCUMENT doc;
DataTable dtTemp = getDataTableBySql("PDM_DOCUMENT.* ", "WHERE DEL_FLAG='N' AND PDM_Params_DETAIL.MASTER_TABLE_NAME='PDM_DOCUMENT' AND DOCID=PK_VALUE AND " + queryStr, "PDM_DOCUMENT,PDM_Params_DETAIL");
if (dtTemp == null || dtTemp.Rows.Count == 0)
{
return null;
}
else
{
list = new List<HYPDM.Entities.PDM_DOCUMENT>();
}
foreach (DataRow dr in dtTemp.Rows)
{
doc = new Entities.PDM_DOCUMENT();
doc.DOCID = dr["DOCID"].ToString();
doc.DOCNAME = dr["DOCNAME"].ToString();
doc.DOCNO = dr["DOCNO"].ToString();
doc.DOCSTATUS = dr["DOCSTATUS"].ToString();
doc.DOCTYPE = dr["DOCTYPE"].ToString();
doc.LASTUPDATEDATE = dr["LASTUPDATEDATE"].ToString();
doc.LASTUPDATEUSER = dr["LASTUPDATEUSER"].ToString();
doc.REMARK = dr["REMARK"].ToString();
doc.VERSION = dr["VERSION"].ToString();
doc.CREATEDATE = dr["CREATEDATE"].ToString();
doc.CREATEUSER = dr["CREATEUSER"].ToString();
doc.DEL_FLAG = dr["DEL_FLAG"].ToString();
doc.DESCRIPTION = dr["DESCRIPTION"].ToString();
list.Add(doc);
}
return list;
}
public IList <HYPDM.Entities.PDM_DOCUMENT> GetQueryResult(string queryStr)
{
IList <HYPDM.Entities.PDM_DOCUMENT> list = null;
HYPDM.Entities.PDM_DOCUMENT doc;
DataTable dtTemp = getDataTableBySql("PDM_DOCUMENT.* ", "WHERE DEL_FLAG='N' AND PDM_Params_DETAIL.MASTER_TABLE_NAME='PDM_DOCUMENT' AND DOCID=PK_VALUE AND " + queryStr, "PDM_DOCUMENT,PDM_Params_DETAIL");
if (dtTemp == null || dtTemp.Rows.Count == 0)
{
return(null);
}
else
{
list = new List <HYPDM.Entities.PDM_DOCUMENT>();
}
foreach (DataRow dr in dtTemp.Rows)
{
doc = new Entities.PDM_DOCUMENT();
doc.DOCID = dr["DOCID"].ToString();
doc.DOCNAME = dr["DOCNAME"].ToString();
doc.DOCNO = dr["DOCNO"].ToString();
doc.DOCSTATUS = dr["DOCSTATUS"].ToString();
doc.DOCTYPE = dr["DOCTYPE"].ToString();
doc.LASTUPDATEDATE = dr["LASTUPDATEDATE"].ToString();
doc.LASTUPDATEUSER = dr["LASTUPDATEUSER"].ToString();
doc.REMARK = dr["REMARK"].ToString();
doc.VERSION = dr["VERSION"].ToString();
doc.CREATEDATE = dr["CREATEDATE"].ToString();
doc.CREATEUSER = dr["CREATEUSER"].ToString();
doc.DEL_FLAG = dr["DEL_FLAG"].ToString();
doc.DESCRIPTION = dr["DESCRIPTION"].ToString();
list.Add(doc);
}
return(list);
}
