예제 #1
0
        public string dtFileV()
        {
            string sSQL = @"
SELECT 
      [文件名称]
      ,[路径]
      ,[版本]
      ,[更新日期]
      ,[创建时间]
  FROM [XWSystemDB_FH].[dbo].[文件版本信息]
  order by iID
";

            ClsBaseClass.ClsDataBase clsSQL = ClsBaseClass.ClsDataBaseFactory.Instance();
            DataTable dt = clsSQL.ExecQuery(sSQL);

            return(Cls序列化.SerializeDataTableXml(dt));
        }
예제 #2
0
        public string dtDownFileVer(string sFileName)
        {
            string sSQL = @"
SELECT 
      [文件名称]
      ,[文件]
      ,[路径]
      ,[版本]
      ,[更新日期]
      ,[创建时间]
  FROM [XWSystemDB_FH].[dbo].[文件版本信息]
   where  [文件名称] = '111111'
  order by iID
";

            sSQL = sSQL.Replace("111111", sFileName);
            ClsBaseClass.ClsDataBase clsSQL = ClsBaseClass.ClsDataBaseFactory.Instance();
            DataTable dt = clsSQL.ExecQuery(sSQL);

            return(Cls序列化.SerializeDataTableXml(dt));
        }