📄 wupinxiaofei.h
字号:
this->oleDbUpdateCommand1->Connection = this->oleDbConnection1;
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SID", System::Data::OleDb::OleDbType::VarChar, 10, S"SID"));
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SNAME", System::Data::OleDb::OleDbType::VarChar, 20, S"SNAME"));
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SMODEL", System::Data::OleDb::OleDbType::VarChar, 10, S"SMODEL"));
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SPRODUCER", System::Data::OleDb::OleDbType::VarChar, 20, S"SPRODUCER"));
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SSELLPRICE", System::Data::OleDb::OleDbType::Double, 8, S"SSELLPRICE"));
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SQUANTITY", System::Data::OleDb::OleDbType::Integer, 4, S"SQUANTITY"));
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SWNAME", System::Data::OleDb::OleDbType::VarChar, 20, S"SWNAME"));
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SDATE", System::Data::OleDb::OleDbType::DBTimeStamp, 8, S"SDATE"));
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"YID", System::Data::OleDb::OleDbType::VarChar, 10, S"YID"));
this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_SID", System::Data::OleDb::OleDbType::VarChar, 10, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"SID", System::Data::DataRowVersion::Original, 0));
//
// textBox7
//
this->textBox7->Location = System::Drawing::Point(544, 24);
this->textBox7->Name = S"textBox7";
this->textBox7->Size = System::Drawing::Size(72, 21);
this->textBox7->TabIndex = 43;
this->textBox7->Text = S"";
//
// button5
//
this->button5->Font = new System::Drawing::Font(S"宋体", 9, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point, (System::Byte)134);
this->button5->Location = System::Drawing::Point(448, 136);
this->button5->Name = S"button5";
this->button5->Size = System::Drawing::Size(80, 24);
this->button5->TabIndex = 42;
this->button5->Text = S"找零";
this->button5->Click += new System::EventHandler(this, button5_Click);
//
// 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(336, 16);
this->button2->Name = S"button2";
this->button2->Size = System::Drawing::Size(80, 32);
this->button2->TabIndex = 39;
this->button2->Text = S"移/除";
this->button2->Click += new System::EventHandler(this, button2_Click);
//
// 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(240, 16);
this->button1->Name = S"button1";
this->button1->Size = System::Drawing::Size(80, 32);
this->button1->TabIndex = 38;
this->button1->Text = S"增/添";
this->button1->Click += new System::EventHandler(this, button1_Click);
//
// dataGrid1
//
this->dataGrid1->DataMember = S"";
this->dataGrid1->HeaderForeColor = System::Drawing::SystemColors::ControlText;
this->dataGrid1->Location = System::Drawing::Point(8, 176);
this->dataGrid1->Name = S"dataGrid1";
this->dataGrid1->Size = System::Drawing::Size(672, 344);
this->dataGrid1->TabIndex = 37;
this->dataGrid1->CurrentCellChanged += new System::EventHandler(this, dataGrid1_CurrentCellChanged);
//
// textBox6
//
this->textBox6->Location = System::Drawing::Point(104, 144);
this->textBox6->Name = S"textBox6";
this->textBox6->Size = System::Drawing::Size(312, 21);
this->textBox6->TabIndex = 36;
this->textBox6->Text = S"";
//
// textBox5
//
this->textBox5->Location = System::Drawing::Point(280, 104);
this->textBox5->Name = S"textBox5";
this->textBox5->Size = System::Drawing::Size(136, 21);
this->textBox5->TabIndex = 35;
this->textBox5->Text = S"";
//
// textBox4
//
this->textBox4->Location = System::Drawing::Point(104, 104);
this->textBox4->Name = S"textBox4";
this->textBox4->TabIndex = 34;
this->textBox4->Text = S"";
//
// textBox3
//
this->textBox3->Location = System::Drawing::Point(280, 64);
this->textBox3->Name = S"textBox3";
this->textBox3->Size = System::Drawing::Size(136, 21);
this->textBox3->TabIndex = 33;
this->textBox3->Text = S"";
//
// textBox2
//
this->textBox2->Location = System::Drawing::Point(104, 64);
this->textBox2->Name = S"textBox2";
this->textBox2->TabIndex = 32;
this->textBox2->Text = S"";
//
// textBox1
//
this->textBox1->Location = System::Drawing::Point(104, 24);
this->textBox1->Name = S"textBox1";
this->textBox1->TabIndex = 31;
this->textBox1->Text = S"";
//
// label6
//
this->label6->Font = new System::Drawing::Font(S"宋体", 9, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point, (System::Byte)134);
this->label6->Location = System::Drawing::Point(40, 144);
this->label6->Name = S"label6";
this->label6->Size = System::Drawing::Size(56, 23);
this->label6->TabIndex = 30;
this->label6->Text = S"生产商：";
this->label6->TextAlign = System::Drawing::ContentAlignment::MiddleCenter;
//
// label5
//
this->label5->Font = new System::Drawing::Font(S"宋体", 9, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point, (System::Byte)134);
this->label5->Location = System::Drawing::Point(224, 104);
this->label5->Name = S"label5";
this->label5->Size = System::Drawing::Size(48, 23);
this->label5->TabIndex = 29;
this->label5->Text = S"数量：";
this->label5->TextAlign = System::Drawing::ContentAlignment::MiddleCenter;
//
// label4
//
this->label4->Font = new System::Drawing::Font(S"宋体", 9, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point, (System::Byte)134);
this->label4->Location = System::Drawing::Point(24, 104);
this->label4->Name = S"label4";
this->label4->Size = System::Drawing::Size(72, 23);
this->label4->TabIndex = 28;
this->label4->Text = S"销售价格：";
this->label4->TextAlign = System::Drawing::ContentAlignment::MiddleCenter;
//
// label3
//
this->label3->Font = new System::Drawing::Font(S"宋体", 9, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point, (System::Byte)134);
this->label3->Location = System::Drawing::Point(224, 64);
this->label3->Name = S"label3";
this->label3->Size = System::Drawing::Size(48, 23);
this->label3->TabIndex = 27;
this->label3->Text = S"型号：";
this->label3->TextAlign = System::Drawing::ContentAlignment::MiddleCenter;
//
// label2
//
this->label2->Font = new System::Drawing::Font(S"宋体", 9, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point, (System::Byte)134);
this->label2->Location = System::Drawing::Point(24, 64);
this->label2->Name = S"label2";
this->label2->Size = System::Drawing::Size(72, 23);
this->label2->TabIndex = 26;
this->label2->Text = S"物品名称：";
this->label2->TextAlign = System::Drawing::ContentAlignment::MiddleCenter;
//
// label1
//
this->label1->Font = new System::Drawing::Font(S"宋体", 9, System::Drawing::FontStyle::Bold, System::Drawing::GraphicsUnit::Point, (System::Byte)134);
this->label1->Location = System::Drawing::Point(40, 24);
this->label1->Name = S"label1";
this->label1->Size = System::Drawing::Size(56, 23);
this->label1->TabIndex = 25;
this->label1->Text = S"物品ID：";
this->label1->TextAlign = System::Drawing::ContentAlignment::MiddleCenter;
//
// dataGrid2
//
this->dataGrid2->DataMember = S"";
this->dataGrid2->HeaderForeColor = System::Drawing::SystemColors::ControlText;
this->dataGrid2->Location = System::Drawing::Point(392, 344);
this->dataGrid2->Name = S"dataGrid2";
this->dataGrid2->Size = System::Drawing::Size(96, 64);
this->dataGrid2->TabIndex = 49;
//
// textBox10
//
this->textBox10->Location = System::Drawing::Point(408, 256);
this->textBox10->Name = S"textBox10";
this->textBox10->TabIndex = 50;
this->textBox10->Text = S"0";
//
// 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*[7];
__mcTemp__4[0] = new System::Data::Common::DataColumnMapping(S"NID", S"NID");
__mcTemp__4[1] = new System::Data::Common::DataColumnMapping(S"NAME", S"NAME");
__mcTemp__4[2] = new System::Data::Common::DataColumnMapping(S"STATUS", S"STATUS");
__mcTemp__4[3] = new System::Data::Common::DataColumnMapping(S"SEX", S"SEX");
__mcTemp__4[4] = new System::Data::Common::DataColumnMapping(S"COMPANY", S"COMPANY");
__mcTemp__4[5] = new System::Data::Common::DataColumnMapping(S"UPWORK", S"UPWORK");
__mcTemp__4[6] = new System::Data::Common::DataColumnMapping(S"DATACHA", S"DATACHA");
__mcTemp__3[0] = new System::Data::Common::DataTableMapping(S"Table", S"登入表", __mcTemp__4);
this->oleDbDataAdapter2->TableMappings->AddRange(__mcTemp__3);
this->oleDbDataAdapter2->UpdateCommand = this->oleDbUpdateCommand2;
//
// oleDbDeleteCommand2
//
this->oleDbDeleteCommand2->CommandText = S"DELETE FROM 登入表 WHERE (NID = \?)";
this->oleDbDeleteCommand2->Connection = this->oleDbConnection1;
this->oleDbDeleteCommand2->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));
//
// oleDbInsertCommand2
//
this->oleDbInsertCommand2->CommandText = S"INSERT INTO 登入表(NID, NAME, STATUS, SEX, COMPANY, UPWORK, DATACHA) VALUES (\?, \?, \?"
S", \?, \?, \?, \?)";
this->oleDbInsertCommand2->Connection = this->oleDbConnection1;
this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NID", System::Data::OleDb::OleDbType::VarChar, 10, S"NID"));
this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NAME", System::Data::OleDb::OleDbType::VarChar, 20, S"NAME"));
this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"STATUS", System::Data::OleDb::OleDbType::VarChar, 20, S"STATUS"));
this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SEX", System::Data::OleDb::OleDbType::VarChar, 5, S"SEX"));
this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"COMPANY", System::Data::OleDb::OleDbType::VarChar, 20, S"COMPANY"));
this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"UPWORK", System::Data::OleDb::OleDbType::VarChar, 20, S"UPWORK"));
this->oleDbInsertCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"DATACHA", System::Data::OleDb::OleDbType::VarChar, 10, S"DATACHA"));
//
// oleDbSelectCommand2
//
this->oleDbSelectCommand2->CommandText = S"SELECT NID, NAME, STATUS, SEX, COMPANY, UPWORK, DATACHA FROM 登入表";
this->oleDbSelectCommand2->Connection = this->oleDbConnection1;
//
// oleDbUpdateCommand2
//
this->oleDbUpdateCommand2->CommandText = S"UPDATE 登入表 SET NID = \?, NAME = \?, STATUS = \?, SEX = \?, COMPANY = \?, UPWORK = \?, D"
S"ATACHA = \? WHERE (NID = \?)";
this->oleDbUpdateCommand2->Connection = this->oleDbConnection1;
this->oleDbUpdateCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NID", System::Data::OleDb::OleDbType::VarChar, 10, S"NID"));
this->oleDbUpdateCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"NAME", System::Data::OleDb::OleDbType::VarChar, 20, S"NAME"));
this->oleDbUpdateCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"STATUS", System::Data::OleDb::OleDbType::VarChar, 20, S"STATUS"));
this->oleDbUpdateCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SEX", System::Data::OleDb::OleDbType::VarChar, 5, S"SEX"));
this->oleDbUpdateCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"COMPANY", System::Data::OleDb::OleDbType::VarChar, 20, S"COMPANY"));
this->oleDbUpdateCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"UPWORK", System::Data::OleDb::OleDbType::VarChar, 20, S"UPWORK"));
this->oleDbUpdateCommand2->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"DATACHA", System::Data::OleDb::OleDbType::VarChar, 10, S"DATACHA"));
this->oleDbUpdateCommand2->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));
//
// 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*[10];
__mcTemp__6[0] = new System::Data::Common::DataColumnMapping(S"WID", S"WID");
__mcTemp__6[1] = new System::Data::Common::DataColumnMapping(S"WNAME", S"WNAME");
__mcTemp__6[2] = new System::Data::Common::DataColumnMapping(S"MODEL", S"MODEL");
__mcTemp__6[3] = new System::Data::Common::DataColumnMapping(S"PRODUCER", S"PRODUCER");
__mcTemp__6[4] = new System::Data::Common::DataColumnMapping(S"SELLPRICE", S"SELLPRICE");
__mcTemp__6[5] = new System::Data::Common::DataColumnMapping(S"STOCKPRICE", S"STOCKPRICE");
__mcTemp__6[6] = new System::Data::Common::DataColumnMapping(S"STOCK", S"STOCK");
__mcTemp__6[7] = new System::Data::Common::DataColumnMapping(S"LASTSTOCK", S"LASTSTOCK");
__mcTemp__6[8] = new System::Data::Common::DataColumnMapping(S"MAXSTOCK", S"MAXSTOCK");
__mcTemp__6[9] = new System::Data::Common::DataColumnMapping(S"STOCKCHA", S"STOCKCHA");
__mcTemp__5[0] = new System::Data::Common::DataTableMapping(S"Table", S"物品表", __mcTemp__6);
this->oleDbDataAdapter3->TableMappings->AddRange(__mcTemp__5);
this->oleDbDataAdapter3->UpdateCommand = this->oleDbUpdateCommand3;
//
// oleDbDeleteCommand3
//
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -