// dataSet11
//
this.dataSet11.DataSetName = "DataSet1";
this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// sqlDataAdapter1
//
this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
new System.Data.Common.DataTableMapping("Table", "goods", new System.Data.Common.DataColumnMapping[] {
new System.Data.Common.DataColumnMapping("记录编号", "记录编号"),
new System.Data.Common.DataColumnMapping("物品编号", "物品编号"),
new System.Data.Common.DataColumnMapping("物品价格", "物品价格"),
new System.Data.Common.DataColumnMapping("购入时间", "购入时间"),
new System.Data.Common.DataColumnMapping("使用年限", "使用年限"),
new System.Data.Common.DataColumnMapping("记录人", "记录人"),
new System.Data.Common.DataColumnMapping("物品名称", "物品名称")})});
this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = @"DELETE FROM goods WHERE (ID = @Original_记录编号) AND (name = @Original_物品名称 OR @Original_物品名称 IS NULL AND name IS NULL) AND (name2 = @Original_记录人 OR @Original_记录人 IS NULL AND name2 IS NULL) AND (number = @Original_物品编号 OR @Original_物品编号 IS NULL AND number IS NULL) AND (price = @Original_物品价格 OR @Original_物品价格 IS NULL AND price IS NULL) AND (time1 = @Original_购入时间 OR @Original_购入时间 IS NULL AND time1 IS NULL) AND (time2 = @Original_使用年限 OR @Original_使用年限 IS NULL AND time2 IS NULL)";
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.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.sqlDeleteCommand1.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.sqlDeleteCommand1.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.sqlDeleteCommand1.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.sqlDeleteCommand1.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.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_购入时间", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "购入时间", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.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));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=CHANGTAO;packet size=4096;user id=qiky;integrated security=SSPI;da" +
"ta source=CHANGTAO;persist security info=False;initial catalog=tongle";
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = @"INSERT INTO goods(number, price, time1, time2, name2, name) VALUES (@number, @price, @time1, @time2, @name2, @name); SELECT ID AS 记录编号, number AS 物品编号, price AS 物品价格, time1 AS 购入时间, time2 AS 使用年限, name2 AS 记录人, name AS 物品名称 FROM goods WHERE (ID = @@IDENTITY)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@number", System.Data.SqlDbType.VarChar, 10, "物品编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@price", System.Data.SqlDbType.VarChar, 10, "物品价格"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@time1", System.Data.SqlDbType.DateTime, 8, "购入时间"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@time2", System.Data.SqlDbType.VarChar, 10, "使用年限"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@name2", System.Data.SqlDbType.VarChar, 10, "记录人"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.VarChar, 10, "物品名称"));
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = "SELECT ID AS 记录编号, number AS 物品编号, price AS 物品价格, time1 AS 购入时间, time2 AS 使用年限, n" +
"ame2 AS 记录人, name AS 物品名称 FROM goods";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
//
// sqlUpdateCommand1
//
this.sqlUpdateCommand1.CommandText = @"UPDATE goods SET number = @number, price = @price, time1 = @time1, time2 = @time2, name2 = @name2, name = @name WHERE (ID = @Original_记录编号) AND (name = @Original_物品名称 OR @Original_物品名称 IS NULL AND name IS NULL) AND (name2 = @Original_记录人 OR @Original_记录人 IS NULL AND name2 IS NULL) AND (number = @Original_物品编号 OR @Original_物品编号 IS NULL AND number IS NULL) AND (price = @Original_物品价格 OR @Original_物品价格 IS NULL AND price IS NULL) AND (time1 = @Original_购入时间 OR @Original_购入时间 IS NULL AND time1 IS NULL) AND (time2 = @Original_使用年限 OR @Original_使用年限 IS NULL AND time2 IS NULL); SELECT ID AS 记录编号, number AS 物品编号, price AS 物品价格, time1 AS 购入时间, time2 AS 使用年限, name2 AS 记录人, name AS 物品名称 FROM goods WHERE (ID = @记录编号)";
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@number", System.Data.SqlDbType.VarChar, 10, "物品编号"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@price", System.Data.SqlDbType.VarChar, 10, "物品价格"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@time1", System.Data.SqlDbType.DateTime, 8, "购入时间"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@time2", System.Data.SqlDbType.VarChar, 10, "使用年限"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@name2", System.Data.SqlDbType.VarChar, 10, "记录人"));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@name", System.Data.SqlDbType.VarChar, 10, "物品名称"));
this.sqlUpdateCommand1.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.sqlUpdateCommand1.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.sqlUpdateCommand1.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.sqlUpdateCommand1.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.sqlUpdateCommand1.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.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_购入时间", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "购入时间", System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.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.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@记录编号", System.Data.SqlDbType.Int, 4, "记录编号"));
//
// sqlCommand1
//
this.sqlCommand1.Connection = this.sqlConnection1;
//
// Form8
//
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(784, 334);
this.Controls.Add(this.dataGrid1);
this.Controls.Add(this.tabControl1);
this.Name = "Form8";
this.Text = "物品管理平台";
this.tabControl1.ResumeLayout(false);
this.tabPage1.ResumeLayout(false);
this.tabPage3.ResumeLayout(false);
this.tabPage2.ResumeLayout(false);
this.tabPage4.ResumeLayout(false);
this.tabPage5.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
this.ResumeLayout(false);
}
#endregion