/// <summary>
///Encrypt 的摘要说明
/// </summary>
public class Encrypt
{

    //cookies加密密钥  
    public static string DES_Key = "12345678";

    #region DESEnCode DES加密
    /// <summary>
    /// 加密
    /// </summary>
    /// <param name="pToEncrypt"></param>
    /// <returns></returns>
    public static string DESEnCode(string pToEncrypt)
    {
        pToEncrypt = HttpContext.Current.Server.UrlEncode(pToEncrypt);
        DESCryptoServiceProvider des = new DESCryptoServiceProvider();
        byte[] inputByteArray = Encoding.GetEncoding("UTF-8").GetBytes(pToEncrypt);

        des.Key = ASCIIEncoding.ASCII.GetBytes(DES_Key);
        des.IV = ASCIIEncoding.ASCII.GetBytes(DES_Key);
        MemoryStream ms = new MemoryStream();
        CryptoStream cs = new CryptoStream(ms, des.CreateEncryptor(), CryptoStreamMode.Write);

        cs.Write(inputByteArray, 0, inputByteArray.Length);
        cs.FlushFinalBlock();

        StringBuilder ret = new StringBuilder();
        foreach (byte b in ms.ToArray())
        {
            ret.AppendFormat("{0:X2}", b);
        }
        ret.ToString();
        return ret.ToString();
    }
    #endregion

    #region DESDeCode DES解密
    /// <summary>
    /// 解密
    /// </summary>
    /// <param name="pToDecrypt"></param>
    /// <returns></returns>
    public static string DESDeCode(string pToDecrypt)
    {
        try
        {
            //    HttpContext.Current.Response.Write(pToDecrypt + "<br>" + sKey);  
            //    HttpContext.Current.Response.End();  
            DESCryptoServiceProvider des = new DESCryptoServiceProvider();

            byte[] inputByteArray = new byte[pToDecrypt.Length / 2];
            for (int x = 0; x < pToDecrypt.Length / 2; x++)
            {
                int i = (Convert.ToInt32(pToDecrypt.Substring(x * 2, 2), 16));
                inputByteArray[x] = (byte)i;
            }

            des.Key = ASCIIEncoding.ASCII.GetBytes(DES_Key);
            des.IV = ASCIIEncoding.ASCII.GetBytes(DES_Key);
            MemoryStream ms = new MemoryStream();
            CryptoStream cs = new CryptoStream(ms, des.CreateDecryptor(), CryptoStreamMode.Write);
            cs.Write(inputByteArray, 0, inputByteArray.Length);
            cs.FlushFinalBlock();

            StringBuilder ret = new StringBuilder();

            return HttpContext.Current.Server.UrlDecode(System.Text.Encoding.Default.GetString(ms.ToArray()));
        }
        catch (Exception)
        {

            return "";
        }

    }
    #endregion

}

  if MaxBianH is null then
    case
      when JiaoYLX = 'N' then
        MaxBianH := 'CONT' ||
                    to_char(to_date(riqi, 'yyyy-MM-dd'), 'yyyyMMdd') ||
                    '00001';
      when JiaoYLX = 'S' then
        MaxBianH := 'SETT' ||
                    to_char(to_date(riqi, 'yyyy-MM-dd'), 'yyyyMMdd') ||
                    '00001';
      when JiaoYLX = 'C' then
        MaxBianH := 'COMP' ||
                    to_char(to_date(riqi, 'yyyy-MM-dd'), 'yyyyMMdd') ||
                    '00001';
      when JiaoYLX = 'X' then
        MaxBianH := 'ORDER' ||
                    to_char(to_date(riqi, 'yyyy-MM-dd'), 'yyyyMMdd') ||
                    '00001';
      when JiaoYLX = 'Y' then
        MaxBianH := 'FLWUP' ||
                    to_char(to_date(riqi, 'yyyy-MM-dd'), 'yyyyMMdd') ||
                    '00001';
      when JiaoYLX = 'HBHK' then
        MaxBianH := 'HBHK' ||
                    to_char(to_date(riqi, 'yyyy-MM-dd'), 'yyyyMMdd') ||
                    '00001';
      when JiaoYLX = 'YJFL' then
        MaxBianH := 'YJFL' ||
                    to_char(to_date(riqi, 'yyyy-MM-dd'), 'yyyyMMdd') ||
                    '00001';
      when JiaoYLX = 'TB' then
        MaxBianH := 'TB' ||
                    to_char(to_date(riqi, 'yyyy-MM-dd'), 'yyyyMMdd') ||
                    '00001';
      when JiaoYLX = 'QR' then
        MaxBianH := 'QR' ||
                    to_char(to_date(riqi, 'yyyy-MM-dd'), 'yyyyMMdd') ||
                    '00001';
      when JiaoYLX = 'PZ' then
        MaxBianH := 'PZ' ||
                    to_char(to_date(riqi, 'yyyy-MM-dd'), 'yyyyMMdd') ||
                    '00001';
      when JiaoYLX = 'ZJMMXG' then
        MaxBianH := 'ZJMMXG' ||
                    to_char(to_date(riqi, 'yyyy-MM-dd'), 'yyyyMMdd') ||
                    '00001';
    end case;else
    case
      when JiaoYLX = 'N' then
        MaxBianH := 'CONT' ||
                    trim(to_char(to_Number(substr(MaxBianH,
                                                  5,
                                                  13)) + 1,
                                 '0000000000000'));
      when JiaoYLX = 'S' then
        MaxBianH := 'SETT' ||
                    trim(to_char(to_Number(substr(MaxBianH,
                                                  5,
                                                  13)) + 1,
                                 '0000000000000'));
      when JiaoYLX = 'C' then
        MaxBianH := 'COMP' ||
                    trim(to_char(to_Number(substr(MaxBianH,
                                                  5,
                                                  13)) + 1,
                                 '0000000000000'));
      when JiaoYLX = 'X' then
        MaxBianH := 'ORDER' ||
                    trim(to_char(to_Number(substr(MaxBianH,
                                                  6,
                                                  13)) + 1,
                                 '0000000000000'));
      when JiaoYLX = 'Y' then
        MaxBianH := 'FLWUP' ||
                    trim(to_char(to_Number(substr(MaxBianH,
                                                  6,
                                                  13)) + 1,
                                 '0000000000000'));
      when JiaoYLX = 'HBHK' then
        MaxBianH := 'HBHK' ||
                    trim(to_char(to_Number(substr(MaxBianH,
                                                  5,
                                                  13)) + 1,
                                 '0000000000000'));
      when JiaoYLX = 'YJFL' then
        MaxBianH := 'YJFL' ||
                  
                    trim(to_char(to_Number(substr(MaxBianH,
                                                  5,
                                                  13)) + 1,
                                 '0000000000000'));
      when JiaoYLX = 'TB' then
        MaxBianH := 'TB' ||
                    trim(to_char(to_Number(substr(MaxBianH,
                                                  3,
                                                  13)) + 1,
                                 '0000000000000'));
      when JiaoYLX = 'QR' then
        MaxBianH := 'QR' ||
                    trim(to_char(to_Number(substr(MaxBianH,
                                                  3,
                                                  13)) + 1,
                                 '0000000000000'));
      when JiaoYLX = 'PZ' then
        MaxBianH := 'PZ' ||
                    trim(to_char(to_Number(substr(MaxBianH,
                                                  3,
                                                  13)) + 1,
                                 '0000000000000'));
      when JiaoYLX = 'ZJMMXG' then
        MaxBianH := 'ZJMMXG' ||
                    trim(to_char(to_Number(substr(MaxBianH,
                                                  7,
                                                  13)) + 1,
                                 '0000000000000'));
    end case; end if;

  insert into MTJY_BianHTable
    (shangpbh, Charshj, Leix)
  values
    (MaxBianH, riqi || TO_char(sysdate, ' hh24:mi:ss'), JiaoYLX);

  commit;
  return MaxBianH;
exception
  when others then
    rollback;
    return MaxBianH;
end GetFtpSeqNO;


SYSID NUMBER 编号；SHANGPBH VARCHAR2(50) 商品编号；CHARSHJ  VARCHAR2(50) 插入时间；  LEIX VARCHAR2(50)类型 ；

   IF money < 0
   THEN
      l_sign := '负';
   ELSE
      l_sign := '';
   END IF;

   tmp := ROUND (l_money, 2) * 100;
   c_money := RTRIM (LTRIM (TO_CHAR (tmp, '999999999999')));
   len := LENGTH (c_money);
   is_zero := TRUE;
   z_count := 0;
   i := 0;

   WHILE i < len
   LOOP
      i := i + 1;
      n := SUBSTR (c_money,
                   i,
                   1
                  );

      IF n = '0'
      THEN
         IF len - i = 6 OR len - i = 2 OR len = i
         THEN
            IF is_zero
            THEN
               b_string := SUBSTR (b_string,
                                   1,
                                   LENGTH (b_string) - 1
                                  );
               is_zero := FALSE;
            END IF;

            IF len - i = 6
            THEN
               b_string := b_string || '万';
            END IF;

            IF len - i = 2
            THEN
               b_string := b_string || '元';
            END IF;

            IF len = i
            THEN
               b_string := b_string || '整';
            END IF;

            z_count := 0;
         ELSE
            IF z_count = 0
            THEN
               b_string := b_string || '零';
               is_zero := TRUE;
            END IF;

            z_count := z_count + 1;
         END IF;
      ELSE
         b_string :=
               b_string
            || SUBSTR (n_string,
                       TO_NUMBER (n),
                       1
                      )
            || SUBSTR (m_string,
                       len - i + 1,
                       1
                      );
         z_count := 0;
         is_zero := FALSE;
      END IF;
   END LOOP;

   b_string := l_sign || b_string;
   RETURN b_string;
EXCEPTION
   WHEN OTHERS
   THEN
      RETURN (SQLERRM);
END;

02 String path1=System.IO.Directory.GetCurrentDirectory();  

03 MessageBox.Show("获取应用程序的当前工作目录:"+path1);  

04   

05 //获取程序的基目录。  

06 String path2=System.AppDomain.CurrentDomain.BaseDirectory;  

07 MessageBox.Show("获取程序的基目录:"+path2);  

08   

09 //获取和设置包括该应用程序的目录的名称。  

10 String path3=System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase;  

11 MessageBox.Show("获取和设置包括该应用程序的目录的名称:"+path3);  

12   

13 //获取启动了应用程序的可执行文件的路径，不包括可执行文件的名称。  

14 String path4=System.Windows.Forms.Application.StartupPath;  

15 MessageBox.Show("获取启动了应用程序的可执行文件的路径，不包括可执行文件的名称:"+path4);  

16   

17 //获取启动了应用程序的可执行文件的路径及文件名  

18 String path5=System.Windows.Forms.Application.ExecutablePath;  

19 MessageBox.Show("获取启动了应用程序的可执行文件的路径及文件名:"+path5);

02         /// 去掉字符串中的数字  

03         /// </summary>  

04         /// <param name="key"></param>  

05         /// <returns></returns>  

06         public static string RemoveNumber(string key)  

07         {  

08             return Regex.Replace(key, @"\d", "");  

09         }        /// <summary>  

10         /// 去掉字符串中的非数字  

11         /// </summary>  

12         /// <param name="key"></param>  

13         /// <returns></returns>  

14         public static string RemoveNotNumber(string key)  

15         {  

16             return Regex.Replace(key, @"[^\d]*", "");  

17         }

 效果：输入"High：4"
第一个函数，输出结果是"High："
第二个函数，输出结果是"4"