jinhuobaobiao.h

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

			__mcTemp__2[1] = new System::Data::Common::DataColumnMapping(S"NAME", S"NAME");
			__mcTemp__2[2] = new System::Data::Common::DataColumnMapping(S"STATUS", S"STATUS");
			__mcTemp__2[3] = new System::Data::Common::DataColumnMapping(S"SEX", S"SEX");
			__mcTemp__2[4] = new System::Data::Common::DataColumnMapping(S"COMPANY", S"COMPANY");
			__mcTemp__2[5] = new System::Data::Common::DataColumnMapping(S"UPWORK", S"UPWORK");
			__mcTemp__2[6] = new System::Data::Common::DataColumnMapping(S"DATACHA", S"DATACHA");
			__mcTemp__1[0] = new System::Data::Common::DataTableMapping(S"Table", S"登入表", __mcTemp__2);
			this->oleDbDataAdapter1->TableMappings->AddRange(__mcTemp__1);
			this->oleDbDataAdapter1->UpdateCommand = this->oleDbUpdateCommand1;
			// 
			// oleDbConnection1
			// 
			this->oleDbConnection1->ConnectionString = S"Integrated Security=SSPI;Packet Size=4096;Data Source=4B2E371A2A9F47E;Tag with co" 
				S"lumn collation when possible=False;Initial Catalog=超市收银数据库;Use Procedure for Pre" 
				S"pare=1;Auto Translate=True;Persist Security Info=False;Provider=\"SQLOLEDB.1\";Wor" 
				S"kstation ID=4B2E371A2A9F47E;Use Encryption for Data=False";
			// 
			// oleDbDataAdapter2
			// 
			this->oleDbDataAdapter2->DeleteCommand = this->oleDbDeleteCommand2;
			this->oleDbDataAdapter2->InsertCommand = this->oleDbInsertCommand2;
			this->oleDbDataAdapter2->SelectCommand = this->oleDbSelectCommand2;
			System::Data::Common::DataTableMapping* __mcTemp__3[] = new System::Data::Common::DataTableMapping*[1];
			System::Data::Common::DataColumnMapping* __mcTemp__4[] = new System::Data::Common::DataColumnMapping*[10];
			__mcTemp__4[0] = new System::Data::Common::DataColumnMapping(S"WID", S"WID");
			__mcTemp__4[1] = new System::Data::Common::DataColumnMapping(S"WNAME", S"WNAME");
			__mcTemp__4[2] = new System::Data::Common::DataColumnMapping(S"MODEL", S"MODEL");
			__mcTemp__4[3] = new System::Data::Common::DataColumnMapping(S"PRODUCER", S"PRODUCER");
			__mcTemp__4[4] = new System::Data::Common::DataColumnMapping(S"SELLPRICE", S"SELLPRICE");
			__mcTemp__4[5] = new System::Data::Common::DataColumnMapping(S"STOCKPRICE", S"STOCKPRICE");
			__mcTemp__4[6] = new System::Data::Common::DataColumnMapping(S"STOCK", S"STOCK");
			__mcTemp__4[7] = new System::Data::Common::DataColumnMapping(S"LASTSTOCK", S"LASTSTOCK");
			__mcTemp__4[8] = new System::Data::Common::DataColumnMapping(S"MAXSTOCK", S"MAXSTOCK");
			__mcTemp__4[9] = new System::Data::Common::DataColumnMapping(S"STOCKCHA", S"STOCKCHA");
			__mcTemp__3[0] = new System::Data::Common::DataTableMapping(S"Table", S"物品表", __mcTemp__4);
			this->oleDbDataAdapter2->TableMappings->AddRange(__mcTemp__3);
			this->oleDbDataAdapter2->UpdateCommand = this->oleDbUpdateCommand2;
			// 
			// oleDbDataAdapter3
			// 
			this->oleDbDataAdapter3->DeleteCommand = this->oleDbDeleteCommand3;
			this->oleDbDataAdapter3->InsertCommand = this->oleDbInsertCommand3;
			this->oleDbDataAdapter3->SelectCommand = this->oleDbSelectCommand3;
			System::Data::Common::DataTableMapping* __mcTemp__5[] = new System::Data::Common::DataTableMapping*[1];
			System::Data::Common::DataColumnMapping* __mcTemp__6[] = new System::Data::Common::DataColumnMapping*[7];
			__mcTemp__6[0] = new System::Data::Common::DataColumnMapping(S"IID", S"IID");
			__mcTemp__6[1] = new System::Data::Common::DataColumnMapping(S"INAME", S"INAME");
			__mcTemp__6[2] = new System::Data::Common::DataColumnMapping(S"IPRODUCER", S"IPRODUCER");
			__mcTemp__6[3] = new System::Data::Common::DataColumnMapping(S"ISTOCKPRICE", S"ISTOCKPRICE");
			__mcTemp__6[4] = new System::Data::Common::DataColumnMapping(S"DATES", S"DATES");
			__mcTemp__6[5] = new System::Data::Common::DataColumnMapping(S"YID", S"YID");
			__mcTemp__6[6] = new System::Data::Common::DataColumnMapping(S"YNAME", S"YNAME");
			__mcTemp__5[0] = new System::Data::Common::DataTableMapping(S"Table", S"采购表", __mcTemp__6);
			this->oleDbDataAdapter3->TableMappings->AddRange(__mcTemp__5);
			this->oleDbDataAdapter3->UpdateCommand = this->oleDbUpdateCommand3;
			// 
			// oleDbDataAdapter4
			// 
			this->oleDbDataAdapter4->InsertCommand = this->oleDbInsertCommand4;
			this->oleDbDataAdapter4->SelectCommand = this->oleDbSelectCommand4;
			System::Data::Common::DataTableMapping* __mcTemp__7[] = new System::Data::Common::DataTableMapping*[1];
			System::Data::Common::DataColumnMapping* __mcTemp__8[] = new System::Data::Common::DataColumnMapping*[7];
			__mcTemp__8[0] = new System::Data::Common::DataColumnMapping(S"IID", S"IID");
			__mcTemp__8[1] = new System::Data::Common::DataColumnMapping(S"INAME", S"INAME");
			__mcTemp__8[2] = new System::Data::Common::DataColumnMapping(S"IPRODUCER", S"IPRODUCER");
			__mcTemp__8[3] = new System::Data::Common::DataColumnMapping(S"ISTOCKPRICE", S"ISTOCKPRICE");
			__mcTemp__8[4] = new System::Data::Common::DataColumnMapping(S"DATES", S"DATES");
			__mcTemp__8[5] = new System::Data::Common::DataColumnMapping(S"YID", S"YID");
			__mcTemp__8[6] = new System::Data::Common::DataColumnMapping(S"YNAME", S"YNAME");
			__mcTemp__7[0] = new System::Data::Common::DataTableMapping(S"Table", S"进货表", __mcTemp__8);
			this->oleDbDataAdapter4->TableMappings->AddRange(__mcTemp__7);
			// 
			// button3
			// 
			this->button3->Location = System::Drawing::Point(368, 24);
			this->button3->Name = S"button3";
			this->button3->Size = System::Drawing::Size(40, 23);
			this->button3->TabIndex = 8;
			this->button3->Text = S"插入";
			this->button3->Click += new System::EventHandler(this, button3_Click);
			// 
			// textBox3
			// 
			this->textBox3->Location = System::Drawing::Point(240, 304);
			this->textBox3->Name = S"textBox3";
			this->textBox3->TabIndex = 9;
			this->textBox3->Text = S"0";
			// 
			// dataGrid3
			// 
			this->dataGrid3->DataMember = S"";
			this->dataGrid3->HeaderForeColor = System::Drawing::SystemColors::ControlText;
			this->dataGrid3->Location = System::Drawing::Point(24, 72);
			this->dataGrid3->Name = S"dataGrid3";
			this->dataGrid3->Size = System::Drawing::Size(384, 64);
			this->dataGrid3->TabIndex = 10;
			// 
			// label3
			// 
			this->label3->Location = System::Drawing::Point(16, 56);
			this->label3->Name = S"label3";
			this->label3->Size = System::Drawing::Size(120, 16);
			this->label3->TabIndex = 11;
			this->label3->Text = S"物品信息：";
			this->label3->TextAlign = System::Drawing::ContentAlignment::MiddleCenter;
			// 
			// label4
			// 
			this->label4->Location = System::Drawing::Point(16, 144);
			this->label4->Name = S"label4";
			this->label4->Size = System::Drawing::Size(100, 16);
			this->label4->TabIndex = 12;
			this->label4->Text = S"进货报表：";
			this->label4->TextAlign = System::Drawing::ContentAlignment::MiddleCenter;
			// 
			// oleDbSelectCommand3
			// 
			this->oleDbSelectCommand3->CommandText = S"SELECT IID, INAME, IPRODUCER, ISTOCKPRICE, DATES, YID, YNAME FROM 采购表";
			this->oleDbSelectCommand3->Connection = this->oleDbConnection1;
			// 
			// oleDbInsertCommand3
			// 
			this->oleDbInsertCommand3->CommandText = S"INSERT INTO 采购表(IID, INAME, IPRODUCER, ISTOCKPRICE, DATES, YID, YNAME) VALUES (\?," 
				S" \?, \?, \?, \?, \?, \?)";
			this->oleDbInsertCommand3->Connection = this->oleDbConnection1;
			this->oleDbInsertCommand3->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"IID", System::Data::OleDb::OleDbType::VarChar, 10, S"IID"));
			this->oleDbInsertCommand3->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"INAME", System::Data::OleDb::OleDbType::VarChar, 20, S"INAME"));
			this->oleDbInsertCommand3->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"IPRODUCER", System::Data::OleDb::OleDbType::VarChar, 20, S"IPRODUCER"));
			this->oleDbInsertCommand3->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"ISTOCKPRICE", System::Data::OleDb::OleDbType::Integer, 4, S"ISTOCKPRICE"));
			this->oleDbInsertCommand3->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"DATES", System::Data::OleDb::OleDbType::DBTimeStamp, 8, S"DATES"));
			this->oleDbInsertCommand3->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"YID", System::Data::OleDb::OleDbType::VarChar, 10, S"YID"));
			this->oleDbInsertCommand3->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"YNAME", System::Data::OleDb::OleDbType::VarChar, 10, S"YNAME"));
			// 
			// oleDbUpdateCommand3
			// 
			this->oleDbUpdateCommand3->CommandText = S"UPDATE 采购表 SET IID = \?, INAME = \?, IPRODUCER = \?, ISTOCKPRICE = \?, DATES = \?, YID" 
				S" = \?, YNAME = \? WHERE (IID = \?)";
			this->oleDbUpdateCommand3->Connection = this->oleDbConnection1;
			this->oleDbUpdateCommand3->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"IID", System::Data::OleDb::OleDbType::VarChar, 10, S"IID"));
			this->oleDbUpdateCommand3->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"INAME", System::Data::OleDb::OleDbType::VarChar, 20, S"INAME"));
			this->oleDbUpdateCommand3->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"IPRODUCER", System::Data::OleDb::OleDbType::VarChar, 20, S"IPRODUCER"));
			this->oleDbUpdateCommand3->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"ISTOCKPRICE", System::Data::OleDb::OleDbType::Integer, 4, S"ISTOCKPRICE"));
			this->oleDbUpdateCommand3->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"DATES", System::Data::OleDb::OleDbType::DBTimeStamp, 8, S"DATES"));
			this->oleDbUpdateCommand3->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"YID", System::Data::OleDb::OleDbType::VarChar, 10, S"YID"));
			this->oleDbUpdateCommand3->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"YNAME", System::Data::OleDb::OleDbType::VarChar, 10, S"YNAME"));
			this->oleDbUpdateCommand3->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_IID", System::Data::OleDb::OleDbType::VarChar, 10, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"IID", System::Data::DataRowVersion::Original, 0));
			// 
			// oleDbDeleteCommand3
			// 
			this->oleDbDeleteCommand3->CommandText = S"DELETE FROM 采购表 WHERE (IID = \?)";
			this->oleDbDeleteCommand3->Connection = this->oleDbConnection1;
			this->oleDbDeleteCommand3->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_IID", System::Data::OleDb::OleDbType::VarChar, 10, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"IID", System::Data::DataRowVersion::Original, 0));
			// 
			// oleDbSelectCommand4
			// 
			this->oleDbSelectCommand4->CommandText = S"SELECT IID, INAME, IPRODUCER, ISTOCKPRICE, DATES, YID, YNAME FROM 进货表";
			this->oleDbSelectCommand4->Connection = this->oleDbConnection1;
			// 
			// oleDbInsertCommand4
			// 
			this->oleDbInsertCommand4->CommandText = S"INSERT INTO 进货表(IID, INAME, IPRODUCER, ISTOCKPRICE, DATES, YID, YNAME) VALUES (\?," 
				S" \?, \?, \?, \?, \?, \?)";
			this->oleDbInsertCommand4->Connection = this->oleDbConnection1;
			this->oleDbInsertCommand4->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"IID", System::Data::OleDb::OleDbType::VarChar, 10, S"IID"));
			this->oleDbInsertCommand4->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"INAME", System::Data::OleDb::OleDbType::VarChar, 20, S"INAME"));
			this->oleDbInsertCommand4->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"IPRODUCER", System::Data::OleDb::OleDbType::VarChar, 20, S"IPRODUCER"));
			this->oleDbInsertCommand4->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"ISTOCKPRICE", System::Data::OleDb::OleDbType::Integer, 4, S"ISTOCKPRICE"));
			this->oleDbInsertCommand4->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"DATES", System::Data::OleDb::OleDbType::VarChar, 10, S"DATES"));
			this->oleDbInsertCommand4->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"YID", System::Data::OleDb::OleDbType::VarChar, 10, S"YID"));
			this->oleDbInsertCommand4->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"YNAME", System::Data::OleDb::OleDbType::VarChar, 20, S"YNAME"));
			// 
			// oleDbSelectCommand1
			// 
			this->oleDbSelectCommand1->CommandText = S"SELECT NID, NAME, STATUS, SEX, COMPANY, UPWORK, DATACHA FROM 登入表";
			this->oleDbSelectCommand1->Connection = this->oleDbConnection1;
			// 
			// oleDbInsertCommand1
			// 
			this->oleDbInsertCommand1->CommandText = S"INSERT INTO 登入表(NID, NAME, STATUS, SEX, COMPANY, UPWORK, DATACHA) VALUES (\?, \?, \?" 
				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"DATACHA", System::Data::OleDb::OleDbType::VarChar, 10, S"DATACHA"));
			// 
			// oleDbUpdateCommand1
			// 
			this->oleDbUpdateCommand1->CommandText = S"UPDATE 登入表 SET NID = \?, NAME = \?, STATUS = \?, SEX = \?, COMPANY = \?, UPWORK = \?, D" 
				S"ATACHA = \? WHERE (NID = \?)";
			this->oleDbUpdateCommand1->Connection = this->oleDbConnection1;
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NID", System::Data::OleDb::OleDbType::VarChar, 10, S"NID"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NAME", System::Data::OleDb::OleDbType::VarChar, 20, S"NAME"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"STATUS", System::Data::OleDb::OleDbType::VarChar, 20, S"STATUS"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SEX", System::Data::OleDb::OleDbType::VarChar, 5, S"SEX"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"COMPANY", System::Data::OleDb::OleDbType::VarChar, 20, S"COMPANY"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"UPWORK", System::Data::OleDb::OleDbType::VarChar, 20, S"UPWORK"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"DATACHA", System::Data::OleDb::OleDbType::VarChar, 10, S"DATACHA"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_NID", System::Data::OleDb::OleDbType::VarChar, 10, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"NID", System::Data::DataRowVersion::Original, 0));
			// 
			// oleDbDeleteCommand1
			// 
			this->oleDbDeleteCommand1->CommandText = S"DELETE FROM 登入表 WHERE (NID = \?)";
			this->oleDbDeleteCommand1->Connection = this->oleDbConnection1;
			this->oleDbDeleteCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_NID", System::Data::OleDb::OleDbType::VarChar, 10, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"NID", System::Data::DataRowVersion::Original, 0));
			// 
			// oleDbSelectCommand2
			// 
			this->oleDbSelectCommand2->CommandText = S"SELECT WID, WNAME, MODEL, PRODUCER, SELLPRICE, STOCKPRICE, STOCK, LASTSTOCK, MAXS" 
				S"TOCK, STOCKCHA FROM 物品表";
			this->oleDbSelectCommand2->Connection = this->oleDbConnection1;
			// 
			// oleDbInsertCommand2
			// 
			this->oleDbInsertCommand2->CommandText = S"INSERT INTO 物品表(WID, WNAME, MODEL, PRODUCER, SELLPRICE, STOCKPRICE, STOCK, LASTST" 
				S"OCK, MAXSTOCK, STOCKCHA) VALUES (\?, \?, \?, \?, \?, \?, \?, \?, \?, \?)";
			this->oleDbInsertCommand2->Connection = this->oleDbConnection1;
			this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"WID", System::Data::OleDb::OleDbType::VarChar, 10, S"WID"));
			this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"WNAME", System::Data::OleDb::OleDbType::VarChar, 30, S"WNAME"));
			this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"MODEL", System::Data::OleDb::OleDbType::VarChar, 10, S"MODEL"));
			this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"PRODUCER", System::Data::OleDb::OleDbType::VarChar, 20, S"PRODUCER"));