public DataSet SelectBillNo(string CarrierCode, string Date, string CompanyCode)

    {

        System.Collections.ArrayList aryParams = new System.Collections.ArrayList();

        aryParams.Add(CarrierCode);

        aryParams.Add(Date);

        aryParams.Add(CompanyCode);

        return CommonData.ExecuteStoreProcedure("ProcNamne", aryParams);

    }

public static DataSet ExecuteStoreProcedure(string procedureName, ArrayList ary)

    {

        Database db = DatabaseFactory.CreateDatabase(connstring);

        DbConnection conn = db.CreateConnection();

        try

        {

            conn.Open();

            object[] paramsObject = new object[ary.Count];

            for (int i = ; i < ary.Count; i++)

            {

                paramsObject[i] = ary[i];

            }

            return db.ExecuteDataSet(procedureName, paramsObject);

        }

        finally

        {

            conn.Close();

            conn = null;

        }

    }

 public static void ExeQuery1(string Cmd)

    {

        //SqlConnection conn = new SqlConnection(connstring_TMS);

        Database db = DatabaseFactory.CreateDatabase(connstring_TMS);

        SqlConnection conn = (SqlConnection)db.CreateConnection();

        conn.Open();

        SqlCommand cmd = new SqlCommand(Cmd, conn);

        SqlDataReader reader = cmd.ExecuteReader();

        cmd.CommandTimeout = ;

        while (reader.Read())

        {

            //reader[1]：读取表中第2列的数据

            string sss = reader[].ToString();

        }

        reader.Close();

        conn.Close();

    }