form6.cs

CSHARP下编写的数据库设备管理系统 SQL SERVER

			// 
			this.sqlUpdateCommand5.CommandText = "UPDATE 厂商情况 SET 厂商 = @厂商, 电话 = @电话, 地址 = @地址, 联系人 = @联系人 WHERE (厂商 = @Original_厂商" +
				") AND (地址 = @Original_地址) AND (电话 = @Original_电话) AND (联系人 = @Original_联系人); SEL" +
				"ECT 厂商, 电话, 地址, 联系人 FROM 厂商情况 WHERE (厂商 = @厂商)";
			this.sqlUpdateCommand5.Connection = this.sqlConnection1;
			this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@厂商", System.Data.SqlDbType.VarChar, 10, "厂商"));
			this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@电话", System.Data.SqlDbType.VarChar, 10, "电话"));
			this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@地址", System.Data.SqlDbType.VarChar, 30, "地址"));
			this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@联系人", System.Data.SqlDbType.VarChar, 10, "联系人"));
			this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_厂商", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "厂商", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_地址", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "地址", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_电话", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电话", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_联系人", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "联系人", System.Data.DataRowVersion.Original, null));
			// 
			// sqlDeleteCommand5
			// 
			this.sqlDeleteCommand5.CommandText = "DELETE FROM 厂商情况 WHERE (厂商 = @Original_厂商) AND (地址 = @Original_地址) AND (电话 = @Ori" +
				"ginal_电话) AND (联系人 = @Original_联系人)";
			this.sqlDeleteCommand5.Connection = this.sqlConnection1;
			this.sqlDeleteCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_厂商", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "厂商", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_地址", System.Data.SqlDbType.VarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "地址", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_电话", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "电话", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand5.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_联系人", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "联系人", System.Data.DataRowVersion.Original, null));
			// 
			// ee1
			// 
			this.ee1.DataSetName = "ee";
			this.ee1.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// sqlDataAdapter6
			// 
			this.sqlDataAdapter6.DeleteCommand = this.sqlDeleteCommand6;
			this.sqlDataAdapter6.InsertCommand = this.sqlInsertCommand6;
			this.sqlDataAdapter6.SelectCommand = this.sqlSelectCommand6;
			this.sqlDataAdapter6.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("Table", "设备折旧表", new System.Data.Common.DataColumnMapping[] {
																																																			   new System.Data.Common.DataColumnMapping("设备号", "设备号"),
																																																			   new System.Data.Common.DataColumnMapping("原值", "原值"),
																																																			   new System.Data.Common.DataColumnMapping("折旧值", "折旧值")})});
			this.sqlDataAdapter6.UpdateCommand = this.sqlUpdateCommand6;
			// 
			// ff1
			// 
			this.ff1.DataSetName = "ff";
			this.ff1.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// sqlSelectCommand6
			// 
			this.sqlSelectCommand6.CommandText = "SELECT 设备号, 原值, 折旧值 FROM 设备折旧表";
			this.sqlSelectCommand6.Connection = this.sqlConnection1;
			// 
			// sqlInsertCommand6
			// 
			this.sqlInsertCommand6.CommandText = "INSERT INTO 设备折旧表(设备号, 原值, 折旧值) VALUES (@设备号, @原值, @折旧值); SELECT 设备号, 原值, 折旧值 FRO" +
				"M 设备折旧表 WHERE (设备号 = @设备号)";
			this.sqlInsertCommand6.Connection = this.sqlConnection1;
			this.sqlInsertCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@设备号", System.Data.SqlDbType.VarChar, 10, "设备号"));
			this.sqlInsertCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@原值", System.Data.SqlDbType.Int, 4, "原值"));
			this.sqlInsertCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@折旧值", System.Data.SqlDbType.Int, 4, "折旧值"));
			// 
			// sqlUpdateCommand6
			// 
			this.sqlUpdateCommand6.CommandText = "UPDATE 设备折旧表 SET 设备号 = @设备号, 原值 = @原值, 折旧值 = @折旧值 WHERE (设备号 = @Original_设备号) AND" +
				" (原值 = @Original_原值) AND (折旧值 = @Original_折旧值); SELECT 设备号, 原值, 折旧值 FROM 设备折旧表 W" +
				"HERE (设备号 = @设备号)";
			this.sqlUpdateCommand6.Connection = this.sqlConnection1;
			this.sqlUpdateCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@设备号", System.Data.SqlDbType.VarChar, 10, "设备号"));
			this.sqlUpdateCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@原值", System.Data.SqlDbType.Int, 4, "原值"));
			this.sqlUpdateCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@折旧值", System.Data.SqlDbType.Int, 4, "折旧值"));
			this.sqlUpdateCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_设备号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "设备号", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_原值", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "原值", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_折旧值", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "折旧值", System.Data.DataRowVersion.Original, null));
			// 
			// sqlDeleteCommand6
			// 
			this.sqlDeleteCommand6.CommandText = "DELETE FROM 设备折旧表 WHERE (设备号 = @Original_设备号) AND (原值 = @Original_原值) AND (折旧值 = " +
				"@Original_折旧值)";
			this.sqlDeleteCommand6.Connection = this.sqlConnection1;
			this.sqlDeleteCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_设备号", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "设备号", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_原值", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "原值", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand6.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_折旧值", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "折旧值", System.Data.DataRowVersion.Original, null));
			// 
			// Form6
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(292, 273);
			this.Controls.Add(this.dataGrid1);
			this.Menu = this.mainMenu1;
			this.Name = "Form6";
			this.Text = "Form6";
			((System.ComponentModel.ISupportInitialize)(this.a1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.b1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.c1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dd1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.ee1)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.ff1)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void menuItem2_Click(object sender, System.EventArgs e)
		{
		
		}

		private void menuItem3_Click(object sender, System.EventArgs e)
		{
			Form form2 =new Form2();
					
			form2.ShowDialog();
				  
			this.Close();
			
		}

		private void menuItem5_Click(object sender, System.EventArgs e)
		{
			MessageBox.Show("指导老师鲁晓锋\n设计人员刘丹吕雅琳张行方盖阔 ","设计人员",MessageBoxButtons.OK);
		}

		private void menuItem8_Click(object sender, System.EventArgs e)
		{
			sqlDataAdapter1.Fill(a1,"设备表");
			dataGrid1.SetDataBinding(a1,"设备表");

		}

		private void menuItem12_Click(object sender, System.EventArgs e)
		{
			sqlDataAdapter5.Fill(ee1,"厂商情况");
			dataGrid1.SetDataBinding(ee1,"厂商情况");

		}

		private void menuItem6_Click(object sender, System.EventArgs e)
		{
			MessageBox.Show("基于SQLC#的设备管理系统 ","系统本身",MessageBoxButtons.OK);
		}

		private void menuItem7_Click(object sender, System.EventArgs e)
		{
			MessageBox.Show("查询手册 ","帮助",MessageBoxButtons.OK);
		}

		private void menuItem9_Click(object sender, System.EventArgs e)
		{
			sqlDataAdapter2.Fill(b1,"部门表");
			dataGrid1.SetDataBinding(b1,"部门表");

		}

		private void menuItem10_Click(object sender, System.EventArgs e)
		{
			sqlDataAdapter3.Fill(c1,"维修表");
			dataGrid1.SetDataBinding(c1,"维修表");

		}

		private void menuItem11_Click(object sender, System.EventArgs e)
		{
				sqlDataAdapter4.Fill(dd1,"维护表");
			dataGrid1.SetDataBinding(dd1,"维护表");

			
		}

		private void menuItem13_Click(object sender, System.EventArgs e)
		{
			sqlDataAdapter6.Fill(ff1,"设备折旧表");
			dataGrid1.SetDataBinding(ff1,"设备折旧表");

		}
	}
}