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

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

		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		void InitializeComponent(void)
		{
			this->oleDbInsertCommand1 = new System::Data::OleDb::OleDbCommand();
			this->oleDbConnection1 = new System::Data::OleDb::OleDbConnection();
			this->dataGrid1 = new System::Windows::Forms::DataGrid();
			this->oleDbDeleteCommand1 = new System::Data::OleDb::OleDbCommand();
			this->oleDbUpdateCommand1 = new System::Data::OleDb::OleDbCommand();
			this->oleDbDataAdapter1 = new System::Data::OleDb::OleDbDataAdapter();
			this->oleDbSelectCommand1 = new System::Data::OleDb::OleDbCommand();
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataGrid1))->BeginInit();
			this->SuspendLayout();
			// 
			// oleDbInsertCommand1
			// 
			this->oleDbInsertCommand1->CommandText = S"INSERT INTO 物品表(WID, WNAME, MODEL, PRODUCER, SELLPRICE, STOCKPRICE, STOCK, LASTST" 
				S"OCK, MAXSTOCK, STOCKCHA) VALUES (\?, \?, \?, \?, \?, \?, \?, \?, \?, \?)";
			this->oleDbInsertCommand1->Connection = this->oleDbConnection1;
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"WID", System::Data::OleDb::OleDbType::VarChar, 10, S"WID"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"WNAME", System::Data::OleDb::OleDbType::VarChar, 30, S"WNAME"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"MODEL", System::Data::OleDb::OleDbType::VarChar, 10, S"MODEL"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"PRODUCER", System::Data::OleDb::OleDbType::VarChar, 20, S"PRODUCER"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SELLPRICE", System::Data::OleDb::OleDbType::Double, 8, S"SELLPRICE"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"STOCKPRICE", System::Data::OleDb::OleDbType::Double, 8, S"STOCKPRICE"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"STOCK", System::Data::OleDb::OleDbType::Integer, 4, S"STOCK"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"LASTSTOCK", System::Data::OleDb::OleDbType::Integer, 4, S"LASTSTOCK"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"MAXSTOCK", System::Data::OleDb::OleDbType::Integer, 4, S"MAXSTOCK"));
			this->oleDbInsertCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"STOCKCHA", System::Data::OleDb::OleDbType::Integer, 4, S"STOCKCHA"));
			// 
			// 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";
			// 
			// dataGrid1
			// 
			this->dataGrid1->DataMember = S"";
			this->dataGrid1->HeaderForeColor = System::Drawing::SystemColors::ControlText;
			this->dataGrid1->Location = System::Drawing::Point(8, 8);
			this->dataGrid1->Name = S"dataGrid1";
			this->dataGrid1->Size = System::Drawing::Size(400, 144);
			this->dataGrid1->TabIndex = 1;
			// 
			// oleDbDeleteCommand1
			// 
			this->oleDbDeleteCommand1->CommandText = S"DELETE FROM 物品表 WHERE (WID = \?)";
			this->oleDbDeleteCommand1->Connection = this->oleDbConnection1;
			this->oleDbDeleteCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_WID", System::Data::OleDb::OleDbType::VarChar, 10, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"WID", System::Data::DataRowVersion::Original, 0));
			// 
			// oleDbUpdateCommand1
			// 
			this->oleDbUpdateCommand1->CommandText = S"UPDATE 物品表 SET WID = \?, WNAME = \?, MODEL = \?, PRODUCER = \?, SELLPRICE = \?, STOCKP" 
				S"RICE = \?, STOCK = \?, LASTSTOCK = \?, MAXSTOCK = \?, STOCKCHA = \? WHERE (WID = \?)";
			this->oleDbUpdateCommand1->Connection = this->oleDbConnection1;
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"WID", System::Data::OleDb::OleDbType::VarChar, 10, S"WID"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"WNAME", System::Data::OleDb::OleDbType::VarChar, 30, S"WNAME"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"MODEL", System::Data::OleDb::OleDbType::VarChar, 10, S"MODEL"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"PRODUCER", System::Data::OleDb::OleDbType::VarChar, 20, S"PRODUCER"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"SELLPRICE", System::Data::OleDb::OleDbType::Double, 8, S"SELLPRICE"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"STOCKPRICE", System::Data::OleDb::OleDbType::Double, 8, S"STOCKPRICE"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"STOCK", System::Data::OleDb::OleDbType::Integer, 4, S"STOCK"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"LASTSTOCK", System::Data::OleDb::OleDbType::Integer, 4, S"LASTSTOCK"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"MAXSTOCK", System::Data::OleDb::OleDbType::Integer, 4, S"MAXSTOCK"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"STOCKCHA", System::Data::OleDb::OleDbType::Integer, 4, S"STOCKCHA"));
			this->oleDbUpdateCommand1->Parameters->Add(new System::Data::OleDb::OleDbParameter(S"Original_WID", System::Data::OleDb::OleDbType::VarChar, 10, System::Data::ParameterDirection::Input, false, (System::Byte)0, (System::Byte)0, S"WID", System::Data::DataRowVersion::Original, 0));
			// 
			// 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*[10];
			__mcTemp__2[0] = new System::Data::Common::DataColumnMapping(S"WID", S"WID");
			__mcTemp__2[1] = new System::Data::Common::DataColumnMapping(S"WNAME", S"WNAME");
			__mcTemp__2[2] = new System::Data::Common::DataColumnMapping(S"MODEL", S"MODEL");
			__mcTemp__2[3] = new System::Data::Common::DataColumnMapping(S"PRODUCER", S"PRODUCER");
			__mcTemp__2[4] = new System::Data::Common::DataColumnMapping(S"SELLPRICE", S"SELLPRICE");
			__mcTemp__2[5] = new System::Data::Common::DataColumnMapping(S"STOCKPRICE", S"STOCKPRICE");
			__mcTemp__2[6] = new System::Data::Common::DataColumnMapping(S"STOCK", S"STOCK");
			__mcTemp__2[7] = new System::Data::Common::DataColumnMapping(S"LASTSTOCK", S"LASTSTOCK");
			__mcTemp__2[8] = new System::Data::Common::DataColumnMapping(S"MAXSTOCK", S"MAXSTOCK");
			__mcTemp__2[9] = new System::Data::Common::DataColumnMapping(S"STOCKCHA", S"STOCKCHA");
			__mcTemp__1[0] = new System::Data::Common::DataTableMapping(S"Table", S"物品表", __mcTemp__2);
			this->oleDbDataAdapter1->TableMappings->AddRange(__mcTemp__1);
			this->oleDbDataAdapter1->UpdateCommand = this->oleDbUpdateCommand1;
			// 
			// oleDbSelectCommand1
			// 
			this->oleDbSelectCommand1->CommandText = S"SELECT WID, WNAME, MODEL, PRODUCER, SELLPRICE, STOCKPRICE, STOCK, LASTSTOCK, MAXS" 
				S"TOCK, STOCKCHA FROM 物品表";
			this->oleDbSelectCommand1->Connection = this->oleDbConnection1;
			// 
			// qiehuotixing
			// 
			this->AutoScaleBaseSize = System::Drawing::Size(6, 14);
			this->ClientSize = System::Drawing::Size(416, 158);
			this->Controls->Add(this->dataGrid1);
			this->Name = S"qiehuotixing";
			this->StartPosition = System::Windows::Forms::FormStartPosition::CenterScreen;
			this->Text = S"缺货提醒";
			this->Load += new System::EventHandler(this, qiehuotixing_Load);
			(__try_cast<System::ComponentModel::ISupportInitialize *  >(this->dataGrid1))->EndInit();
			this->ResumeLayout(false);

		}		
	private: System::Void qiehuotixing_Load(System::Object *  sender, System::EventArgs *  e)
			 {oleDbSelectCommand1->CommandText=String::Concat(S"select WID as 物品ID,WNAME as 物品名称,PRODUCER as 生产商,STOCK as 现存数量 from 物品表 where ",S"STOCK<=LASTSTOCK" );
         oleDbConnection1->Open();
		 oleDbSelectCommand1->ExecuteNonQuery();
		 oleDbConnection1->Close();
		 DataTable *table1=new DataTable();
            oleDbDataAdapter1->Fill(table1);
			 this->dataGrid1->DataSource=table1;
			 }

};
}