예제 #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));
        }
예제 #3
0
 public string ClsUserInfoQueryGetAllDt()
 {
     ClsU8.Query.ClsUserInfoQuery clsQuery = new ClsU8.Query.ClsUserInfoQuery();
     return(ClsDES.Encrypt(Cls序列化.SerializeDataTableXml(clsQuery.GetAllDt())));
 }
예제 #4
0
 public string ClsUserEditQueryGetUserRole(string sUid)
 {
     ClsU8.Query.ClsUserEditQuery clsQuery = new ClsU8.Query.ClsUserEditQuery();
     return(ClsDES.Encrypt(Cls序列化.SerializeDataTableXml(clsQuery.GetUserRole(ClsDES.Decrypt(sUid)))));
 }
예제 #5
0
 public string ClsRoleRightGetTreeInfo(string sPK)
 {
     ClsU8.Query.ClsRoleRight clsQuery = new ClsU8.Query.ClsRoleRight();
     return(ClsDES.Encrypt(Cls序列化.SerializeDataTableXml(clsQuery.GetTreeInfo(ClsDES.Decrypt(sPK)))));
 }
예제 #6
0
 public string ClsBuckUpDataBaseGetSerHostName()
 {
     ClsU8.Query.ClsBuckUpDataBase clsQuery = new ClsU8.Query.ClsBuckUpDataBase();
     return(ClsDES.Encrypt(Cls序列化.SerializeDataTableXml(clsQuery.GetSerHostName())));
 }