新增账号查询账号是否为开启自动补发，下行记录导出新增耗时字段

wangsheng

2021-09-15 8c1815a717bd38c2c453f1d61e666fce5c11311d

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
using System;
using System.Configuration;
using System.Text;
//using System.Security.Cryptography; //MD5
using Common;
namespace Common
{
  public abstract class PubConstant
  {
    public static string ConnectionString
    {
      get
      {
        try
        {
          string Text = ConfigurationManager.AppSettings["String"];
          if (ConfigurationManager.AppSettings["OpenFlag"] == "AF0BA3AD7F0E9A56")
            Text = DESEncrypt.Decrypt(Text);
          if (Text.Equals(""))
            Text = "Data Source=SMGW;User ID=smgw;Password=smgw!2#;";
          return Text;
        }
        catch
        {
          return "Data Source=SMGW;User ID=smgw;Password=smgw!2#;";
        }
      }
    }
 
    public static string Path
    {
      get
      {
        string Text = ConfigurationManager.AppSettings["Path"];
        if (ConfigurationManager.AppSettings["OpenFlag"] == "AF0BA3AD7F0E9A56")
          Text = DESEncrypt.Decrypt(Text);
        return Text;
      }
    }
 
    public static string Url
    {
      get
      {
        string Text = ConfigurationManager.AppSettings["Url"];
        if (ConfigurationManager.AppSettings["OpenFlag"] == "AF0BA3AD7F0E9A56")
          Text = DESEncrypt.Decrypt(Text);
        return Text;
      }
    }
 
    public static string AdminUrl
    {
      get
      {
        string Text = ConfigurationManager.AppSettings["AdminUrl"];
        if (ConfigurationManager.AppSettings["OpenFlag"] == "AF0BA3AD7F0E9A56")
          Text = DESEncrypt.Decrypt(Text);
        return Text;
      }
    }
 
      //新加授权程序
    //public static bool CheckToken()
    //{
    //    try
    //    {
    //        string privateKey = "PFJTQUtleVZhbHVlPjxNb2R1bHVzPjdjdVB6K1Jta0FjWHlZSjBDbWJyZ3VUT3JSajVsakRJbXJxUTZLeUtMZ2ZMTWNzcSt6cWFnMnF3NUlDZWNYalB5NGhsOU5vdHFyYTdxQVc3WmVtVkJuMHZ0NFVrYzdlTFhreEN0TGhsVUtSNHpCc3FEUW5QNnppKzFXejBockorV2RUM2MwSTgyK25SOWRHY2hIMnEwTCthL2IwK01jRjBkbnVHUmRReFl1MD08L01vZHVsdXM+PEV4cG9uZW50PkFRQUI8L0V4cG9uZW50PjxQPis5cHQ3RWk3K1dhTXF0ZDN6aExBYWJuQjBkdGxjWkdOVGlqakRYUVgwYXdWazk2RmZYL3FwbW1ZdmRVOE1obDRWTXZUZTI0QkY2aGc0Nk1wZzF6TUVRPT08L1A+PFE+OGJYZ2g4N1pObDJEUnFjdWlvT1U4N3lZamo4RjZZeUliaGg0S08xanJDdmpSV1VzYXpQaEdWaDh4R3FHN3pheE9zdmFSelI1dnFvcENWb1lGMEwxSFE9PTwvUT48RFA+QTE3SDY4cUpZV3dDNCtKZ1F3eXpNSGNBNWZzR24zOXdJYVNnYlRTcGdPL0psaUg3TFZQQjR4bzBwZzJ0Y1lvdnR3ckhPTGFmSXg3b3RRTWc4aFlTMFE9PTwvRFA+PERRPmJZalJWbG43ZnpLRFlnb3pBaHc4N1BOall0cldrQTdhYUtINEdmdng5anp4UWlwbUpiS2Q2SUY4RVBxQmFYZ3Nlb3VVd0QzY2lmWE1vT3RPRFlTUFZRPT08L0RRPjxJbnZlcnNlUT5uRU1HWEl0cVA0UmFlczZtTURCcmRBQzdNS2k1UmRGTjF4bUM1MWNwWmRFZkhHeTVNd05JS0hRQjhSZ0VhdStlNThyQVduRy9sQnk0MG00YlN3SmZyQT09PC9JbnZlcnNlUT48RD5pTTFPTy9TVFNKSzhEWksrUFdtK1hieFNabVR5MllQUk5LcldTUFZTUFc4QVovSVJGUjArM1JIWkdHd2lPdmVjMitQcGUvYTB4UHlCY3dWeExRMDNUTHR2b3h0TEF3NnNDNWpPSjlMWW1kamRRQjYwdkhockdIMlpGbUVsTVJJbUVhOWNWNFN5QkptZUxwYVpyeWY1Z3l0dERHc0pnQzgvZ2Y3eU5uc0VIRUU9PC9EPjwvUlNBS2V5VmFsdWU+";
    //        string machineID = HardwareHelper.GetMachineID();
    //        if (BitConverter.ToString(AlgHelper.Decrypt(privateKey, Convert.FromBase64String(ConfigurationManager.AppSettings["Validation"]))) != BitConverter.ToString(MD5.Create().ComputeHash(Encoding.Default.GetBytes(string.Format("{0}-{1}-{2}", "SMS", ConfigurationManager.AppSettings["CopyID"], machineID)))))
    //        {
    //            return false;
    //        }
    //    }
    //    catch
    //    {
    //        return false;
    //    }
    //    return true;
    //}
 
      //结束
 
 
 
    public static StringBuilder doOracleSql(int pageIndex, int pageSize, int recordcount, string sql)
    {
      return new StringBuilder().Append("select * from (select rownum r,t.* from (").Append(sql).Append(") t where rownum <= ").Append(pageIndex * pageSize > recordcount ? recordcount : pageIndex * pageSize).Append(") where r > ").Append((pageIndex - 1) * pageSize);
    }
 
    public static StringBuilder doOracleSql(int recordcount, string sql)
    {
      return new StringBuilder().Append("select * from (select rownum r,t.* from (").Append(sql).Append(") t where rownum <= ").Append(recordcount).Append(")");
    }
 
    public static string GetConnectionString(string configName)
    {
      try
      {
        string Text = ConfigurationManager.AppSettings[configName];
        if (ConfigurationManager.AppSettings["ConStringEncrypt"] == "true")
          Text = DESEncrypt.Decrypt(Text);
        if (Text.Equals(""))
          return "Data Source=.;User ID=smsdb;Password=smsdb123;Initial Catalog=smsdb;Pooling=true";
        return Text;
      }
      catch (Exception)
      {
        return "Data Source=.;User ID=smsdb;Password=smsdb123;Initial Catalog=smsdb;Pooling=true";
      }
    }
  }
}