public List <T_Doc> GetDocAll()
{
List <T_Doc> tl = new List <T_Doc>();
DataTable dt = gt.GetTableBySQL("SELECT * from T_Doc");
foreach (DataRow item in dt.Rows) //loop through the columns.
{
T_Doc TDoc = new T_Doc();
TDoc.Id = int.Parse(item["Id"].ToString());
TDoc.DocTitle = item["DocTitle"].ToString();
TDoc.Doc = item["Doc"].ToString();
TDoc.FullDoc = item["FullDoc"].ToString();
TDoc.CreateDate = item["CreateDate"].ToString();
TDoc.InsetDate = item["InsetDate"].ToString();
TDoc.UserID = item["UserID"].ToString();
TDoc.Address = item["Address"].ToString();
TDoc.Keywords = item["Keywords"].ToString();
TDoc.DOCTREE_ID = int.Parse(item["DOCTREE_ID"].ToString());
tl.Add(TDoc);
}
return(tl);
}
public List <PS_VERB_FA> GetAll()
{
List <PS_VERB_FA> tl = new List <PS_VERB_FA>();
DataTable dt = gt.GetTableBySQL("SELECT ID,VAL1 FROM PS_Dictionary_FA");
foreach (DataRow item in dt.Rows) //loop through the columns.
{
var x = new PS_VERB_FA();
x.Val1 = item["VAL1"].ToString();
tl.Add(x);
}
return(tl);
}
public List <T_PARA> GetParaByDoc(T_Doc TDOC)
{
List <T_PARA> tl = new List <T_PARA>();
DataTable dt = gt.GetTableBySQL("SELECT * from T_PARA where T_DOC_ID =" + TDOC.Id + "");
foreach (DataRow item in dt.Rows) //loop through the columns.
{
T_PARA TPARA = new T_PARA();
TPARA.Id = int.Parse(item["Id"].ToString());
TPARA.T_DOC_ID = int.Parse(item["T_DOC_ID"].ToString());
TPARA.PARA = item["PARA"].ToString();
TPARA.SORT_ID = int.Parse(item["SORT_ID"].ToString());
tl.Add(TPARA);
}
return(tl);
}
public List <PS_Dictionary_FA> GetAll()
{
List <PS_Dictionary_FA> tl = new List <PS_Dictionary_FA>();
DataTable dt = gt.GetTableBySQL("select * from PS_Dictionary_FA");
foreach (DataRow item in dt.Rows) //loop through the columns.
{
PS_Dictionary_FA RSC_DIC_FA = new PS_Dictionary_FA();
RSC_DIC_FA.Id = int.Parse(item["Id"].ToString());
RSC_DIC_FA.Val1 = item["Val1"].ToString();
RSC_DIC_FA.Sundex = item["sundex"].ToString();
tl.Add(RSC_DIC_FA);
}
return(tl);
}
public List <T_DocTree> GetDocTreeByPID(string PID)
{
List <T_DocTree> tl = new List <T_DocTree>();
DataTable dt = gt.GetTableBySQL("SELECT * from T_DocTree where PID=" + PID);
foreach (DataRow item in dt.Rows) //loop through the columns.
{
T_DocTree TDocTree = new T_DocTree();
TDocTree.Id = int.Parse(item["Id"].ToString());
TDocTree.PId = int.Parse(item["pId"].ToString());
TDocTree.NodeTitle = item["NodeTitle"].ToString();
TDocTree.NodeType = int.Parse(item["NodeType"].ToString());
tl.Add(TDocTree);
}
return(tl);
}