Exemplo n.º 1
0
 public static ClsDataBase Instance()
 {
     if (clsCommond == null)
     {
         lock (lockHelper)
         {
             if (clsCommond == null)
             {
                 //if (ClsBaseClass.ClsBaseDataInfo.sDataBaseType.ToLower().Trim() == "sqlserver")
                 clsCommond = new ClsBaseClass.ClsSQLServerCommond();
             }
         }
     }
     return(clsCommond);
 }
Exemplo n.º 2
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));
        }
Exemplo n.º 3
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));
        }