Site blog

by 97213529 郭益銘 - Sunday, 11 January 2009, 10:16 PM
Anyone in the world
virtual abstract

override new

base.X();

static

protected public private

try{} catch(Exception ex){}

int dog2;
public int dog1 { set { dog2 = value; } get { return dog2; } }

int a, b;
CallRef(ref a, ref b);
public static void CallRef(ref int x, ref int y){...}







Tags:
 
by 97213529 郭益銘 - Monday, 22 December 2008, 2:39 AM
Anyone in the world

using System;
using System.Collections.Generic;
using System.Text;
using System.Collections;

namespace ConvertTest
{
    class zzz
    {
        public double to10(string value, int based)
        {
            double sum = 0.0;
            int count = 0;
            if (value.Contains("."))
                count = value.IndexOf('.') - 1;
            else
                count = value.Length - 1;
            for (int i = 0; i < value.Length; i++) //n=>10
                if (value[i] != '.')
                {
                    if (char.Parse(value[i].ToString().ToUpper()) >='A')
                        sum += (char.Parse(value[i].ToString().ToUpper())-'A'+10) * Math.Pow(based, count--);
                    else
                    sum += Int32.Parse(value[i].ToString()) * Math.Pow(based, count--);
                }
            return sum;
        }
        public void TentoN(double sum,int gg)
        {
            string[] arr = sum.ToString().Split('.');
            ArrayList dog1 = new ArrayList();
            int left = Int32.Parse(arr[0]);
            while (left != 0)
            {
                dog1.Add(left % gg);
                left /= gg;
            }
            dog1.Reverse();
            if (sum.ToString().Contains("."))
            {
                dog1.Add(".");
                double right = double.Parse("0." + arr[1].ToString());
                for (int i = 0; i < 10; i++)
                {
                    if (Math.Floor(right) == Math.Ceiling(right))
                        break;
                    right = right * gg;
                    dog1.Add(Math.Floor(right));
                    right = right - Math.Floor(right);
                }
            }
            for (int i = 0; i < dog1.Count; i++)
            {
                if (Int32.Parse(dog1[i].ToString())>9)
                    Console.Write((char)('A' + 10 - Int32.Parse(dog1[i].ToString())));
                else
                    Console.Write(dog1[i]);
            }
        }
    }
    class Program
    {
        static void Main(string[] args)
        {
            Console.Write("請輸入數值:");
            string value = Console.ReadLine();
            Console.Write("請輸入基底:");
            int based = Int32.Parse(Console.ReadLine());
            zzz dog = new zzz();
            double sum = dog.to10(value,based);
            Console.WriteLine("10進位是 " + sum);//10
            //=========================TO 10==================
            Console.Write("請輸入基底:");
            int gg = Int32.Parse(Console.ReadLine());
            //int a=Convert.ToInt32(arr[0]);
            dog.TentoN(sum, gg);
            Console.ReadKey();
        }
    }
}

Tags:
 
by 97213529 郭益銘 - Tuesday, 9 December 2008, 10:22 AM
Anyone in the world

select dog.Provider_no from provider dog
where dog.Provider_no not in



(select distinct Provider.Provider_no from



(
SELECT Provider.Provider_no,p1.Item_No
FROM Provide p1,Provider
where p1.Provider_no='001' and Provider.Provider_no not in
(SELECT provide.Provider_no FROM Provider INNER JOIN provide ON Provider.Provider_no = provide.Provider_no where p1.Item_no = provide.Item_no)
)



)
Tags:
 

  
RSS