factorialclass.h

来自「Visual_C++.NET实用编程百例」· C头文件 代码 · 共 168 行

// factorialClass.h

#pragma once

using namespace System;
using namespace System::Web;
using namespace System::Web::Services;

namespace factorial
{
	/// 警告: 如果您更改该类的名称，则需要更改 
	///          与该类所依赖的所有 .resx 文件关联的托管资源编译器工具的 
	///          “资源文件名”属性。  否则，
	///          设计器将不能与此窗体关联的
	///          本地化资源正确交互。
    public __gc 
        class factorialClass : public System::Web::Services::WebService
    {
        
    public:
		factorialClass()
		{
			InitializeComponent();
		}
	protected:
		void Dispose(Boolean disposing)
		{
			if (disposing && components)
			{
				components->Dispose();
			}
			__super::Dispose(disposing);
		}
	private: System::Data::OleDb::OleDbCommand *  oleDbSelectCommand1;
	private: System::Data::OleDb::OleDbCommand *  oleDbInsertCommand1;
	private: System::Data::OleDb::OleDbCommand *  oleDbUpdateCommand1;
	private: System::Data::OleDb::OleDbCommand *  oleDbDeleteCommand1;
	private: System::Data::OleDb::OleDbConnection *  oleDbConnection1;
	private: System::Data::OleDb::OleDbDataAdapter *  oleDbDataAdapter1;
	private: System::Windows::Forms::DataGrid *  dataGrid1;

	private:
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		System::ComponentModel::Container * components;

		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		void InitializeComponent()
		{
			this->oleDbSelectCommand1 = new System::Data::OleDb::OleDbCommand();
			this->oleDbInsertCommand1 = new System::Data::OleDb::OleDbCommand();
			this->oleDbUpdateCommand1 = new System::Data::OleDb::OleDbCommand();
			this->oleDbDeleteCommand1 = new System::Data::OleDb::OleDbCommand();
			this->oleDbConnection1 = new System::Data::OleDb::OleDbConnection();
			this->oleDbDataAdapter1 = new System::Data::OleDb::OleDbDataAdapter();
			this->dataGrid1 = new System::Windows::Forms::DataGrid();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataGrid1))->BeginInit();
			// 
			// oleDbSelectCommand1
			// 
			this->oleDbSelectCommand1->CommandText = S"SELECT Literary, Math, Name, NO, Total FROM grade";
			this->oleDbSelectCommand1->Connection = this->oleDbConnection1;
			// 
			// oleDbInsertCommand1
			// 
			this->oleDbInsertCommand1->CommandText = S"INSERT INTO grade(Literary, Math, Name, NO, Total) VALUES (\?, \?, \?, \?, \?)";
			this->oleDbInsertCommand1->Connection = this->oleDbConnection1;
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Literary", System::Data::OleDb::OleDbType::Single, 0, S"Literary"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Math", System::Data::OleDb::OleDbType::Single, 0, S"Math"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Name", System::Data::OleDb::OleDbType::VarWChar, 50, S"Name"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NO", System::Data::OleDb::OleDbType::Integer, 0, S"NO"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Total", System::Data::OleDb::OleDbType::Single, 0, S"Total"));
			// 
			// oleDbUpdateCommand1
			// 
			this->oleDbUpdateCommand1->CommandText = S"UPDATE grade SET Literary = \?, Math = \?, Name = \?, NO = \?, Total = \? WHERE (NO = " 
				S"\?) AND (Literary = \? OR \? IS NULL AND Literary IS NULL) AND (Math = \? OR \? IS NU" 
				S"LL AND Math IS NULL) AND (Name = \? OR \? IS NULL AND Name IS NULL) AND (Total = \?" 
				S" OR \? IS NULL AND Total IS NULL)";
			this->oleDbUpdateCommand1->Connection = this->oleDbConnection1;
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Literary", System::Data::OleDb::OleDbType::Single, 0, S"Literary"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Math", System::Data::OleDb::OleDbType::Single, 0, S"Math"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Name", System::Data::OleDb::OleDbType::VarWChar, 50, S"Name"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NO", System::Data::OleDb::OleDbType::Integer, 0, S"NO"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Total", System::Data::OleDb::OleDbType::Single, 0, S"Total"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_NO", System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"NO", System::Data::DataRowVersion::Original, 0));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Literary", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Literary", System::Data::DataRowVersion::Original, 0));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Literary1", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Literary", System::Data::DataRowVersion::Original, 0));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Math", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Math", System::Data::DataRowVersion::Original, 0));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Math1", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Math", System::Data::DataRowVersion::Original, 0));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Name", System::Data::OleDb::OleDbType::VarWChar, 50, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Name", System::Data::DataRowVersion::Original, 0));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Name1", System::Data::OleDb::OleDbType::VarWChar, 50, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Name", System::Data::DataRowVersion::Original, 0));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Total", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Total", System::Data::DataRowVersion::Original, 0));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Total1", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Total", System::Data::DataRowVersion::Original, 0));
			// 
			// oleDbDeleteCommand1
			// 
			this->oleDbDeleteCommand1->CommandText = S"DELETE FROM grade WHERE (NO = \?) AND (Literary = \? OR \? IS NULL AND Literary IS N" 
				S"ULL) AND (Math = \? OR \? IS NULL AND Math IS NULL) AND (Name = \? OR \? IS NULL AND" 
				S" Name IS NULL) AND (Total = \? OR \? IS NULL AND Total IS NULL)";
			this->oleDbDeleteCommand1->Connection = this->oleDbConnection1;
			this->oleDbDeleteCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_NO", System::Data::OleDb::OleDbType::Integer, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"NO", System::Data::DataRowVersion::Original, 0));
			this->oleDbDeleteCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Literary", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Literary", System::Data::DataRowVersion::Original, 0));
			this->oleDbDeleteCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Literary1", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Literary", System::Data::DataRowVersion::Original, 0));
			this->oleDbDeleteCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Math", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Math", System::Data::DataRowVersion::Original, 0));
			this->oleDbDeleteCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Math1", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Math", System::Data::DataRowVersion::Original, 0));
			this->oleDbDeleteCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Name", System::Data::OleDb::OleDbType::VarWChar, 50, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Name", System::Data::DataRowVersion::Original, 0));
			this->oleDbDeleteCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Name1", System::Data::OleDb::OleDbType::VarWChar, 50, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Name", System::Data::DataRowVersion::Original, 0));
			this->oleDbDeleteCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Total", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Total", System::Data::DataRowVersion::Original, 0));
			this->oleDbDeleteCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_Total1", System::Data::OleDb::OleDbType::Single, 0, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"Total", System::Data::DataRowVersion::Original, 0));
			// 
			// oleDbConnection1
			// 
			this->oleDbConnection1->ConnectionString = S"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database L" 
				S"ocking Mode=1;Data Source=\"G:\\C++\\example\\testdb.mdb\";Jet OLEDB:Engine Type=5;Pr" 
				S"ovider=\"Microsoft.Jet.OLEDB.4.0\";Jet OLEDB:System database=;Jet OLEDB:SFP=False;" 
				S"persist security info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:" 
				S"Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don\'t Co" 
				S"py Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User I" 
				S"D=Admin;Jet OLEDB:Global Bulk Transactions=1";
			// 
			// oleDbDataAdapter1
			// 
			this->oleDbDataAdapter1->DeleteCommand = this->oleDbDeleteCommand1;
			this->oleDbDataAdapter1->InsertCommand = this->oleDbInsertCommand1;
			this->oleDbDataAdapter1->SelectCommand = this->oleDbSelectCommand1;
			System::Data::Common::DataTableMapping* __mcTemp__1[] = new System::Data::Common::DataTableMapping*[1];
			System::Data::Common::DataColumnMapping* __mcTemp__2[] = new System::Data::Common::DataColumnMapping*[5];
			__mcTemp__2[0] = new System::Data::Common::DataColumnMapping(S"Literary", S"Literary");
			__mcTemp__2[1] = new System::Data::Common::DataColumnMapping(S"Math", S"Math");
			__mcTemp__2[2] = new System::Data::Common::DataColumnMapping(S"Name", S"Name");
			__mcTemp__2[3] = new System::Data::Common::DataColumnMapping(S"Expr1003", S"Expr1003");
			__mcTemp__2[4] = new System::Data::Common::DataColumnMapping(S"Total", S"Total");
			__mcTemp__1[0] = new System::Data::Common::DataTableMapping(S"Table", S"grade", __mcTemp__2);
			this->oleDbDataAdapter1->TableMappings->AddRange(__mcTemp__1);
			this->oleDbDataAdapter1->UpdateCommand = this->oleDbUpdateCommand1;
			// 
			// dataGrid1
			// 
			this->dataGrid1->DataMember = S"";
			this->dataGrid1->HeaderForeColor = System::Drawing::SystemColors::ControlText;
			this->dataGrid1->Location = System::Drawing::Point(19, 60);
			this->dataGrid1->Name = S"dataGrid1";
			this->dataGrid1->TabIndex = 0;
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataGrid1))->EndInit();

		}	

		// WEB 服务示例
		// HelloWorld() 示例服务返回字符串 "Hello, World!"。
		// 若要测试此 Web 服务，请确保在项目属性中，将调试 HTTP URL
		// 设置成为部署路径中的.asmx 文件，
		//并按 F5 键。

	public:
        [System::Web::Services::WebMethod] 
        String __gc* HelloWorld();

        // TODO: 在此添加 Web 服务的方法
       [System::Web::Services::WebMethod(Description="Get the factorial of integer n(n<32)")] 
		long nFactorial(long n);
	};
}