wupinxiaofei.h

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

#pragma once

using namespace System;
using namespace System::ComponentModel;
using namespace System::Collections;
using namespace System::Windows::Forms;
using namespace System::Data;
using namespace System::Drawing;


namespace ruanjian
{
	/// <summary> 
	/// wupinxiaofei 摘要
	///
	/// 警告: 如果您更改该类的名称，则将需要更改 
	///          与该类所依赖的所有 .resx 文件关联的托管资源编译器工具的 
	///          “资源文件名”属性。  否则，
	///          设计器将不能与此窗体关联的
	///          本地化资源正确交互。
	/// </summary>
	public __gc class wupinxiaofei : public System::Windows::Forms::Form
	{
	public: 
		wupinxiaofei(void)
		{
			InitializeComponent();
		}
        
	protected: 
		void Dispose(Boolean disposing)
		{
			if (disposing && components)
			{
				components->Dispose();
			}
			__super::Dispose(disposing);
		}
	private: System::Windows::Forms::Label *  label9;
	private: System::Windows::Forms::Label *  label8;
	private: System::Windows::Forms::Label *  label7;
	private: System::Windows::Forms::TextBox *  textBox9;
	private: System::Windows::Forms::TextBox *  textBox8;
	private: System::Data::OleDb::OleDbDataAdapter *  oleDbDataAdapter1;





	private: System::Windows::Forms::TextBox *  textBox7;
	private: System::Windows::Forms::Button *  button5;


	private: System::Windows::Forms::Button *  button2;
	private: System::Windows::Forms::Button *  button1;
	private: System::Windows::Forms::DataGrid *  dataGrid1;
	private: System::Windows::Forms::TextBox *  textBox6;
	private: System::Windows::Forms::TextBox *  textBox5;
	private: System::Windows::Forms::TextBox *  textBox4;
	private: System::Windows::Forms::TextBox *  textBox3;
	private: System::Windows::Forms::TextBox *  textBox2;
	private: System::Windows::Forms::TextBox *  textBox1;
	private: System::Windows::Forms::Label *  label6;
	private: System::Windows::Forms::Label *  label5;
	private: System::Windows::Forms::Label *  label4;
	private: System::Windows::Forms::Label *  label3;

	private: System::Windows::Forms::Label *  label2;
	private: System::Windows::Forms::Label *  label1;
	private: System::Windows::Forms::DataGrid *  dataGrid2;
	private: System::Windows::Forms::TextBox *  textBox10;
	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 *  oleDbDataAdapter2;
	private: System::Data::OleDb::OleDbCommand *  oleDbSelectCommand2;
	private: System::Data::OleDb::OleDbCommand *  oleDbInsertCommand2;
	private: System::Data::OleDb::OleDbCommand *  oleDbUpdateCommand2;
	private: System::Data::OleDb::OleDbCommand *  oleDbDeleteCommand2;
	private: System::Data::OleDb::OleDbDataAdapter *  oleDbDataAdapter3;
	private: System::Data::OleDb::OleDbCommand *  oleDbSelectCommand3;
	private: System::Data::OleDb::OleDbCommand *  oleDbInsertCommand3;
	private: System::Data::OleDb::OleDbCommand *  oleDbUpdateCommand3;
	private: System::Data::OleDb::OleDbCommand *  oleDbDeleteCommand3;
	private: System::Data::OleDb::OleDbDataAdapter *  oleDbDataAdapter4;
	private: System::Data::OleDb::OleDbCommand *  oleDbSelectCommand4;
	private: System::Data::OleDb::OleDbCommand *  oleDbInsertCommand4;
	private: System::Windows::Forms::TextBox *  textBox11;
	private: System::Windows::Forms::Label *  label10;
	private: System::Windows::Forms::Label *  label11;




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

		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		void InitializeComponent(void)
		{
			this->label9 = new System::Windows::Forms::Label();
			this->label8 = new System::Windows::Forms::Label();
			this->label7 = new System::Windows::Forms::Label();
			this->textBox9 = new System::Windows::Forms::TextBox();
			this->textBox8 = new System::Windows::Forms::TextBox();
			this->oleDbDataAdapter1 = new System::Data::OleDb::OleDbDataAdapter();
			this->oleDbDeleteCommand1 = new System::Data::OleDb::OleDbCommand();
			this->oleDbConnection1 = new System::Data::OleDb::OleDbConnection();
			this->oleDbInsertCommand1 = new System::Data::OleDb::OleDbCommand();
			this->oleDbSelectCommand1 = new System::Data::OleDb::OleDbCommand();
			this->oleDbUpdateCommand1 = new System::Data::OleDb::OleDbCommand();
			this->textBox7 = new System::Windows::Forms::TextBox();
			this->button5 = new System::Windows::Forms::Button();
			this->button2 = new System::Windows::Forms::Button();
			this->button1 = new System::Windows::Forms::Button();
			this->dataGrid1 = new System::Windows::Forms::DataGrid();
			this->textBox6 = new System::Windows::Forms::TextBox();
			this->textBox5 = new System::Windows::Forms::TextBox();
			this->textBox4 = new System::Windows::Forms::TextBox();
			this->textBox3 = new System::Windows::Forms::TextBox();
			this->textBox2 = new System::Windows::Forms::TextBox();
			this->textBox1 = new System::Windows::Forms::TextBox();
			this->label6 = new System::Windows::Forms::Label();
			this->label5 = new System::Windows::Forms::Label();
			this->label4 = new System::Windows::Forms::Label();
			this->label3 = new System::Windows::Forms::Label();
			this->label2 = new System::Windows::Forms::Label();
			this->label1 = new System::Windows::Forms::Label();
			this->dataGrid2 = new System::Windows::Forms::DataGrid();
			this->textBox10 = new System::Windows::Forms::TextBox();
			this->oleDbDataAdapter2 = new System::Data::OleDb::OleDbDataAdapter();
			this->oleDbDeleteCommand2 = new System::Data::OleDb::OleDbCommand();
			this->oleDbInsertCommand2 = new System::Data::OleDb::OleDbCommand();
			this->oleDbSelectCommand2 = new System::Data::OleDb::OleDbCommand();
			this->oleDbUpdateCommand2 = new System::Data::OleDb::OleDbCommand();
			this->oleDbDataAdapter3 = new System::Data::OleDb::OleDbDataAdapter();
			this->oleDbDeleteCommand3 = new System::Data::OleDb::OleDbCommand();
			this->oleDbInsertCommand3 = new System::Data::OleDb::OleDbCommand();
			this->oleDbSelectCommand3 = new System::Data::OleDb::OleDbCommand();
			this->oleDbUpdateCommand3 = new System::Data::OleDb::OleDbCommand();
			this->oleDbDataAdapter4 = new System::Data::OleDb::OleDbDataAdapter();
			this->oleDbInsertCommand4 = new System::Data::OleDb::OleDbCommand();
			this->oleDbSelectCommand4 = new System::Data::OleDb::OleDbCommand();
			this->textBox11 = new System::Windows::Forms::TextBox();
			this->label10 = new System::Windows::Forms::Label();
			this->label11 = new System::Windows::Forms::Label();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataGrid1))->BeginInit();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataGrid2))->BeginInit();
			this->SuspendLayout();
			// 
			// label9
			// 
			this->label9->Location = System::Drawing::Point(608, 136);
			this->label9->Name = S"label9";
			this->label9->Size = System::Drawing::Size(32, 23);
			this->label9->TabIndex = 48;
			this->label9->Text = S"元";
			this->label9->TextAlign = System::Drawing::ContentAlignment::MiddleCenter;
			// 
			// label8
			// 
			this->label8->Location = System::Drawing::Point(608, 80);
			this->label8->Name = S"label8";
			this->label8->Size = System::Drawing::Size(32, 23);
			this->label8->TabIndex = 47;
			this->label8->Text = S"元";
			this->label8->TextAlign = System::Drawing::ContentAlignment::MiddleCenter;
			// 
			// label7
			// 
			this->label7->Anchor = (System::Windows::Forms::AnchorStyles)(System::Windows::Forms::AnchorStyles::Top | System::Windows::Forms::AnchorStyles::Right);
			this->label7->Location = System::Drawing::Point(608, 24);
			this->label7->Name = S"label7";
			this->label7->Size = System::Drawing::Size(32, 23);
			this->label7->TabIndex = 46;
			this->label7->Text = S"元";
			this->label7->TextAlign = System::Drawing::ContentAlignment::MiddleCenter;
			// 
			// textBox9
			// 
			this->textBox9->Location = System::Drawing::Point(544, 136);
			this->textBox9->Name = S"textBox9";
			this->textBox9->Size = System::Drawing::Size(72, 21);
			this->textBox9->TabIndex = 45;
			this->textBox9->Text = S"";
			// 
			// textBox8
			// 
			this->textBox8->Location = System::Drawing::Point(544, 80);
			this->textBox8->Name = S"textBox8";
			this->textBox8->Size = System::Drawing::Size(72, 21);
			this->textBox8->TabIndex = 44;
			this->textBox8->Text = S"";
			// 
			// 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*[9];
			__mcTemp__2[0] = new System::Data::Common::DataColumnMapping(S"SID", S"SID");
			__mcTemp__2[1] = new System::Data::Common::DataColumnMapping(S"SNAME", S"SNAME");
			__mcTemp__2[2] = new System::Data::Common::DataColumnMapping(S"SMODEL", S"SMODEL");
			__mcTemp__2[3] = new System::Data::Common::DataColumnMapping(S"SPRODUCER", S"SPRODUCER");
			__mcTemp__2[4] = new System::Data::Common::DataColumnMapping(S"SSELLPRICE", S"SSELLPRICE");
			__mcTemp__2[5] = new System::Data::Common::DataColumnMapping(S"SQUANTITY", S"SQUANTITY");
			__mcTemp__2[6] = new System::Data::Common::DataColumnMapping(S"SWNAME", S"SWNAME");
			__mcTemp__2[7] = new System::Data::Common::DataColumnMapping(S"SDATE", S"SDATE");
			__mcTemp__2[8] = new System::Data::Common::DataColumnMapping(S"YID", S"YID");
			__mcTemp__1[0] = new System::Data::Common::DataTableMapping(S"Table", S"出售表", __mcTemp__2);
			this->oleDbDataAdapter1->TableMappings->AddRange(__mcTemp__1);
			this->oleDbDataAdapter1->UpdateCommand = this->oleDbUpdateCommand1;
			// 
			// oleDbDeleteCommand1
			// 
			this->oleDbDeleteCommand1->CommandText = S"DELETE FROM 出售表 WHERE (SID = \?)";
			this->oleDbDeleteCommand1->Connection = this->oleDbConnection1;
			this->oleDbDeleteCommand1->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));
			// 
			// 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";
			// 
			// oleDbInsertCommand1
			// 
			this->oleDbInsertCommand1->CommandText = S"INSERT INTO 出售表(SID, SNAME, SMODEL, SPRODUCER, SSELLPRICE, SQUANTITY, SWNAME, SDA" 
				S"TE, YID) VALUES (\?, \?, \?, \?, \?, \?, \?, \?, \?)";
			this->oleDbInsertCommand1->Connection = this->oleDbConnection1;
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SID", System::Data::OleDb::OleDbType::VarChar, 10, S"SID"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SNAME", System::Data::OleDb::OleDbType::VarChar, 20, S"SNAME"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SMODEL", System::Data::OleDb::OleDbType::VarChar, 10, S"SMODEL"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SPRODUCER", System::Data::OleDb::OleDbType::VarChar, 20, S"SPRODUCER"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SSELLPRICE", System::Data::OleDb::OleDbType::Double, 8, S"SSELLPRICE"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SQUANTITY", System::Data::OleDb::OleDbType::Integer, 4, S"SQUANTITY"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SWNAME", System::Data::OleDb::OleDbType::VarChar, 20, S"SWNAME"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SDATE", System::Data::OleDb::OleDbType::DBTimeStamp, 8, S"SDATE"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"YID", System::Data::OleDb::OleDbType::VarChar, 10, S"YID"));
			// 
			// oleDbSelectCommand1
			// 
			this->oleDbSelectCommand1->CommandText = S"SELECT SID, SNAME, SMODEL, SPRODUCER, SSELLPRICE, SQUANTITY, SWNAME, SDATE, YID F" 
				S"ROM 出售表";
			this->oleDbSelectCommand1->Connection = this->oleDbConnection1;
			// 
			// oleDbUpdateCommand1
			// 
			this->oleDbUpdateCommand1->CommandText = S"UPDATE 出售表 SET SID = \?, SNAME = \?, SMODEL = \?, SPRODUCER = \?, SSELLPRICE = \?, SQU" 
				S"ANTITY = \?, SWNAME = \?, SDATE = \?, YID = \? WHERE (SID = \?)";