chuqinchaxun.h

采用VC++.net做的超市收银管理系统

			this->label5->TextAlign = System::Drawing::ContentAlignment::MiddleCenter;
			// 
			// oleDbDataAdapter1
			// 
			this->oleDbDataAdapter1->DeleteCommand = this->oleDbDeleteCommand1;
			this->oleDbDataAdapter1->InsertCommand = this->oleDbInsertCommand1;
			this->oleDbDataAdapter1->SelectCommand = this->oleDbSelectCommand1;
			System::Data::Common::DataTableMapping* __mcTemp__2[] = new System::Data::Common::DataTableMapping*[1];
			System::Data::Common::DataColumnMapping* __mcTemp__3[] = new System::Data::Common::DataColumnMapping*[8];
			__mcTemp__3[0] = new System::Data::Common::DataColumnMapping(S"NID", S"NID");
			__mcTemp__3[1] = new System::Data::Common::DataColumnMapping(S"NAME", S"NAME");
			__mcTemp__3[2] = new System::Data::Common::DataColumnMapping(S"STATUS", S"STATUS");
			__mcTemp__3[3] = new System::Data::Common::DataColumnMapping(S"SEX", S"SEX");
			__mcTemp__3[4] = new System::Data::Common::DataColumnMapping(S"COMPANY", S"COMPANY");
			__mcTemp__3[5] = new System::Data::Common::DataColumnMapping(S"UPWORK", S"UPWORK");
			__mcTemp__3[6] = new System::Data::Common::DataColumnMapping(S"DOWNWORK", S"DOWNWORK");
			__mcTemp__3[7] = new System::Data::Common::DataColumnMapping(S"DATACHA", S"DATACHA");
			__mcTemp__2[0] = new System::Data::Common::DataTableMapping(S"Table", S"工资表", __mcTemp__3);
			this->oleDbDataAdapter1->TableMappings->AddRange(__mcTemp__2);
			this->oleDbDataAdapter1->UpdateCommand = this->oleDbUpdateCommand1;
			// 
			// oleDbInsertCommand1
			// 
			this->oleDbInsertCommand1->CommandText = S"INSERT INTO 工资表(NID, NAME, STATUS, SEX, COMPANY, UPWORK, DOWNWORK, DATACHA) VALUE" 
				S"S (\?, \?, \?, \?, \?, \?, \?, \?)";
			this->oleDbInsertCommand1->Connection = this->oleDbConnection1;
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NID", System::Data::OleDb::OleDbType::VarChar, 10, S"NID"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NAME", System::Data::OleDb::OleDbType::VarChar, 20, S"NAME"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"STATUS", System::Data::OleDb::OleDbType::VarChar, 20, S"STATUS"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SEX", System::Data::OleDb::OleDbType::VarChar, 5, S"SEX"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"COMPANY", System::Data::OleDb::OleDbType::VarChar, 20, S"COMPANY"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"UPWORK", System::Data::OleDb::OleDbType::VarChar, 20, S"UPWORK"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"DOWNWORK", System::Data::OleDb::OleDbType::VarChar, 20, S"DOWNWORK"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"DATACHA", System::Data::OleDb::OleDbType::VarChar, 10, S"DATACHA"));
			// 
			// oleDbSelectCommand1
			// 
			this->oleDbSelectCommand1->CommandText = S"SELECT NID, NAME, STATUS, SEX, COMPANY, UPWORK, DOWNWORK, DATACHA FROM 工资表";
			this->oleDbSelectCommand1->Connection = this->oleDbConnection1;
			// 
			// textBox1
			// 
			this->textBox1->Location = System::Drawing::Point(56, 27);
			this->textBox1->Name = S"textBox1";
			this->textBox1->Size = System::Drawing::Size(144, 21);
			this->textBox1->TabIndex = 31;
			this->textBox1->Text = S"";
			// 
			// button2
			// 
			this->button2->Font = new System::Drawing::Font(S"宋体", 9, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point, (System::Byte)134);
			this->button2->Location = System::Drawing::Point(224, 59);
			this->button2->Name = S"button2";
			this->button2->Size = System::Drawing::Size(72, 32);
			this->button2->TabIndex = 35;
			this->button2->Text = S"查询";
			this->button2->Click += new System::EventHandler(this, button2_Click);
			// 
			// textBox2
			// 
			this->textBox2->Location = System::Drawing::Point(56, 67);
			this->textBox2->Name = S"textBox2";
			this->textBox2->Size = System::Drawing::Size(144, 21);
			this->textBox2->TabIndex = 34;
			this->textBox2->Text = S"";
			// 
			// label2
			// 
			this->label2->Font = new System::Drawing::Font(S"宋体", 10.5F, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point, (System::Byte)134);
			this->label2->Location = System::Drawing::Point(8, 67);
			this->label2->Name = S"label2";
			this->label2->Size = System::Drawing::Size(56, 23);
			this->label2->TabIndex = 33;
			this->label2->Text = S"姓名：";
			this->label2->TextAlign = System::Drawing::ContentAlignment::MiddleCenter;
			// 
			// button1
			// 
			this->button1->Font = new System::Drawing::Font(S"宋体", 9, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point, (System::Byte)134);
			this->button1->Location = System::Drawing::Point(224, 19);
			this->button1->Name = S"button1";
			this->button1->Size = System::Drawing::Size(72, 32);
			this->button1->TabIndex = 32;
			this->button1->Text = S"查询";
			this->button1->Click += new System::EventHandler(this, button1_Click);
			// 
			// label1
			// 
			this->label1->Font = new System::Drawing::Font(S"宋体", 10.5F, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point, (System::Byte)134);
			this->label1->Location = System::Drawing::Point(24, 27);
			this->label1->Name = S"label1";
			this->label1->Size = System::Drawing::Size(40, 23);
			this->label1->TabIndex = 30;
			this->label1->Text = S"ID：";
			this->label1->TextAlign = System::Drawing::ContentAlignment::MiddleCenter;
			// 
			// chuqinchaxun
			// 
			this->AutoScaleBaseSize = System::Drawing::Size(6, 14);
			this->ClientSize = System::Drawing::Size(512, 382);
			this->Controls->Add(this->comboBox1);
			this->Controls->Add(this->label5);
			this->Controls->Add(this->textBox1);
			this->Controls->Add(this->button2);
			this->Controls->Add(this->textBox2);
			this->Controls->Add(this->label2);
			this->Controls->Add(this->button1);
			this->Controls->Add(this->label1);
			this->Controls->Add(this->dataGrid1);
			this->Controls->Add(this->button3);
			this->Name = S"chuqinchaxun";
			this->StartPosition = System::Windows::Forms::FormStartPosition::CenterScreen;
			this->Text = S"出勤查询";
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataGrid1))->EndInit();
			this->ResumeLayout(false);

		}		
	private: System::Void button1_Click(System::Object *  sender, System::EventArgs *  e)
			 {String *NID=this->textBox1->Text->Trim();
		 oleDbSelectCommand1->CommandText=String::Concat(S"select NID as 用户ID,NAME as 姓名,STATUS as 身份证,SEX as 性别,COMPANY as 所属部门,UPWORK as 登入时间,DOWNWORK as 退出时间,DATACHA as 日期  from  工资表 where ",S"NID='",NID,S"'" );
         oleDbConnection1->Open();
		 oleDbSelectCommand1->ExecuteNonQuery();
		 oleDbConnection1->Close();
		 DataTable *table1=new DataTable();
            oleDbDataAdapter1->Fill(table1);
			this->dataGrid1->DataSource=table1;
			 }

private: System::Void button2_Click(System::Object *  sender, System::EventArgs *  e)
		 {String *NAME=this->textBox2->Text->Trim();
		 oleDbSelectCommand1->CommandText=String::Concat(S"select NID as 用户ID,NAME as 姓名,STATUS as 身份证,SEX as 性别,COMPANY as 所属部门,UPWORK as 登入时间,DOWNWORK as 退出时间,DATACHA as 日期 from  工资表 where ",S"NAME='",NAME,S"'" );
         oleDbConnection1->Open();
		 oleDbSelectCommand1->ExecuteNonQuery();
		 oleDbConnection1->Close();
		 DataTable *table1=new DataTable();
            oleDbDataAdapter1->Fill(table1);
			this->dataGrid1->DataSource=table1;
		 }

private: System::Void button3_Click(System::Object *  sender, System::EventArgs *  e)
		 {String *COMPANY=this->comboBox1->Text->Trim();
		 oleDbSelectCommand1->CommandText=String::Concat(S"select NID as 用户ID,NAME as 姓名,STATUS as 身份证,SEX as 性别,COMPANY as 所属部门,UPWORK as 登入时间,DOWNWORK as 退出时间,DATACHA as 日期 from  工资表 where ",S"COMPANY='",COMPANY,S"'" );
         oleDbConnection1->Open();
		 oleDbSelectCommand1->ExecuteNonQuery();
		 oleDbConnection1->Close();
		 DataTable *table1=new DataTable();
            oleDbDataAdapter1->Fill(table1);
			this->dataGrid1->DataSource=table1;
		 }

};
}