public void InsertDoc(T_Doc Tdoc)
{
string sql = string.Empty;
sql = "insert into t_doc (DocTitle,Doc,CreateDate,InsetDate,UserID,Address,Keywords,DOCTREE_ID,FullDoc)" +
" values(" +
"'" + Tdoc.DocTitle + "','" + Tdoc.Doc + "','" + Tdoc.CreateDate + "','" + Tdoc.InsetDate +
"','" + Tdoc.UserID + "','" + Tdoc.Address + "','" + Tdoc.Keywords + "','" + Tdoc.DOCTREE_ID + "','" +
Tdoc.FullDoc + "')";
gt.SetBySQL(sql);
if (Tdoc.blobDoc != null)
{
sql = "Update t_doc SET blobData = @img where ID=" + gt.GetLastInsertID("T_Doc");
gt.SetBlob(sql, Tdoc.blobDoc);
}
}
public int AddNodeAndGetId(T_DocTree DT)
{
// string sql = "SELECT last_insert_rowid()";
gt.SetBySQL("INSERT INTO T_DOCTREE (ID,PID, NodeTitle, NodeType)VALUES (null,"+ DT.PId + ",' " + DT.NodeTitle + "', '" + DT.NodeType.ToString() + "')");
return(int.Parse(gt.GetLastInsertID("T_DOCTREE")));
}
