readme.txt

一个详细功能齐全的档案管理信息系统 跟大家分享一下。这是老师给的光盘里带的

 "SELECT FilesContent.Status as \"状态\",FilesContent.FileId as \"档案编号\",FilesContent.Fname " +
        "as \"名称\",FilesContent.Contents as \"内容\",FilesContent.CabinetId as \"档案柜号\",Filescabinet.cbname as \"档案柜\",FilesContent.Ftime " +
        "as \"建档日期\",FilesContent.Remarks as \"备注\" FROM DaglSys.dbo.FilesContent,FilesCategory,FilesCabinet where " +
        "filescontent.categoryid=filescategory.categoryid and filescabinet.cabinetid=filescontent.cabinetid" +
        " and filescategory.cgname='" +
        CategoryName + "'";


sp_UpdateFContent
delete from filescontent  where fileid=?";
view_FilesContent
view_FBorrow
view_FReturn