about Dataset?

Do you have a MSN? (mine is [email protected]) I can talk this with u through the MSN. the codes like this (most of the code is generated by Visual studio tools): using System; using System.ComponentModel; using System.Collections; using System.Diagnostics; using DataModel; using System.Data; namespace DataAccess { ///

/// DPartPurchase ?????? ///

public class DPartPurchase : System.ComponentModel.Component { private System.Data.SqlClient.SqlDataAdapter sqlDataAdapterItems; private System.Data.SqlClient.SqlCommand sqlSelectCommandItems; private System.Data.SqlClient.SqlCommand sqlInsertCommandItems; private System.Data.SqlClient.SqlCommand sqlUpdateCommandItems; private System.Data.SqlClient.SqlCommand sqlDeleteCommandItems; private System.Data.SqlClient.SqlCommand sqlCommandGetById; private System.Data.SqlClient.SqlDataAdapter sqlDataAdapterMain; private System.Data.SqlClient.SqlCommand sqlSelectCommandMain; private System.Data.SqlClient.SqlCommand sqlInsertCommandMain; private System.Data.SqlClient.SqlCommand sqlUpdateCommandMain; private System.Data.SqlClient.SqlCommand sqlDeleteCommandMain; private System.Data.SqlClient.SqlConnection sqlConnection; ///

/// ????????? ///

private System.ComponentModel.Container components = null; public DPartPurchase(System.ComponentModel.IContainer container) { /// /// Windows.Forms ???????????? /// container.Add(this); InitializeComponent(); this.sqlConnection.ConnectionString = Common.Const.ConnectionString; // // TODO: ? InitializeComponent ????????????? // } public DPartPurchase() { /// /// Windows.Forms ???????????? /// InitializeComponent(); this.sqlConnection.ConnectionString = Common.Const.ConnectionString; // // TODO: ? InitializeComponent ????????????? // } ///

/// ???????????? ///

protected override void Dispose( bool disposing ) { if( disposing ) { if(components != null) { components.Dispose(); } } base.Dispose( disposing ); } #region ?????????? ///

/// ?????????? - ??????????? /// ??????? ///

private void InitializeComponent() { this.sqlDataAdapterItems = new System.Data.SqlClient.SqlDataAdapter(); this.sqlDeleteCommandItems = new System.Data.SqlClient.SqlCommand(); this.sqlInsertCommandItems = new System.Data.SqlClient.SqlCommand(); this.sqlSelectCommandItems = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommandItems = new System.Data.SqlClient.SqlCommand(); this.sqlCommandGetById = new System.Data.SqlClient.SqlCommand(); this.sqlDataAdapterMain = new System.Data.SqlClient.SqlDataAdapter(); this.sqlSelectCommandMain = new System.Data.SqlClient.SqlCommand(); this.sqlInsertCommandMain = new System.Data.SqlClient.SqlCommand(); this.sqlUpdateCommandMain = new System.Data.SqlClient.SqlCommand(); this.sqlDeleteCommandMain = new System.Data.SqlClient.SqlCommand(); this.sqlConnection = new System.Data.SqlClient.SqlConnection(); // // sqlDataAdapterItems // this.sqlDataAdapterItems.DeleteCommand = this.sqlDeleteCommandItems; this.sqlDataAdapterItems.InsertCommand = this.sqlInsertCommandItems; this.sqlDataAdapterItems.SelectCommand = this.sqlSelectCommandItems; this.sqlDataAdapterItems.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "PartPurchaseItems", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("purItemID", "purItemID"), new System.Data.Common.DataColumnMapping("purID", "purID"), new System.Data.Common.DataColumnMapping("partID", "partID"), new System.Data.Common.DataColumnMapping("purCount", "purCount"), new System.Data.Common.DataColumnMapping("purUnitPrice", "purUnitPrice"), new System.Data.Common.DataColumnMapping("partSN", "partSN"), new System.Data.Common.DataColumnMapping("partName", "partName"), new System.Data.Common.DataColumnMapping("partSpec", "partSpec"), new System.Data.Common.DataColumnMapping("partUnit", "partUnit"), new System.Data.Common.DataColumnMapping("partPosition", "partPosition"), new System.Data.Common.DataColumnMapping("partWarehouse", "partWarehouse")})}); this.sqlDataAdapterItems.UpdateCommand = this.sqlUpdateCommandItems; // // sqlDeleteCommandItems // this.sqlDeleteCommandItems.CommandText = "[mt_Part_DeletePartPurchaseItem]"; this.sqlDeleteCommandItems.CommandType = System.Data.CommandType.StoredProcedure; this.sqlDeleteCommandItems.Connection = this.sqlConnection; this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purItemID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purItemID", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_partID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "partID", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_partName", System.Data.SqlDbType.NVarChar, 128, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "partName", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_partPosition", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "partPosition", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_partSN", System.Data.SqlDbType.NVarChar, 128, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "partSN", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_partSpec", System.Data.SqlDbType.NVarChar, 128, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "partSpec", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_partUnit", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "partUnit", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_partWarehouse", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "partWarehouse", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purCount", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purCount", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purID", System.Data.SqlDbType.VarChar, 16, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purID", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purUnitPrice", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purUnitPrice", System.Data.DataRowVersion.Original, null)); // // sqlInsertCommandItems // this.sqlInsertCommandItems.CommandText = "[mt_Part_InsertPartPurchaseItem]"; this.sqlInsertCommandItems.CommandType = System.Data.CommandType.StoredProcedure; this.sqlInsertCommandItems.Connection = this.sqlConnection; this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purID", System.Data.SqlDbType.VarChar, 16, "purID")); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@partID", System.Data.SqlDbType.Int, 4, "partID")); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purCount", System.Data.SqlDbType.Int, 4, "purCount")); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purUnitPrice", System.Data.SqlDbType.Money, 8, "purUnitPrice")); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@partSN", System.Data.SqlDbType.NVarChar, 128, "partSN")); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@partName", System.Data.SqlDbType.NVarChar, 128, "partName")); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@partSpec", System.Data.SqlDbType.NVarChar, 128, "partSpec")); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@partUnit", System.Data.SqlDbType.NVarChar, 20, "partUnit")); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@partPosition", System.Data.SqlDbType.NVarChar, 50, "partPosition")); this.sqlInsertCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@partWarehouse", System.Data.SqlDbType.NVarChar, 50, "partWarehouse")); // // sqlSelectCommandItems // this.sqlSelectCommandItems.CommandText = "[mt_Part_GetPartPurchaseItem]"; this.sqlSelectCommandItems.CommandType = System.Data.CommandType.StoredProcedure; this.sqlSelectCommandItems.Connection = this.sqlConnection; this.sqlSelectCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); this.sqlSelectCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purID", System.Data.SqlDbType.Char, 16)); // // sqlUpdateCommandItems // this.sqlUpdateCommandItems.CommandText = "[mt_Part_UpdatePartPurchaseItem]"; this.sqlUpdateCommandItems.CommandType = System.Data.CommandType.StoredProcedure; this.sqlUpdateCommandItems.Connection = this.sqlConnection; this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purID", System.Data.SqlDbType.VarChar, 16, "purID")); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@partID", System.Data.SqlDbType.Int, 4, "partID")); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purCount", System.Data.SqlDbType.Int, 4, "purCount")); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purUnitPrice", System.Data.SqlDbType.Money, 8, "purUnitPrice")); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@partSN", System.Data.SqlDbType.NVarChar, 128, "partSN")); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@partName", System.Data.SqlDbType.NVarChar, 128, "partName")); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@partSpec", System.Data.SqlDbType.NVarChar, 128, "partSpec")); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@partUnit", System.Data.SqlDbType.NVarChar, 20, "partUnit")); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@partPosition", System.Data.SqlDbType.NVarChar, 50, "partPosition")); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@partWarehouse", System.Data.SqlDbType.NVarChar, 50, "partWarehouse")); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purItemID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purItemID", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_partID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "partID", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_partName", System.Data.SqlDbType.NVarChar, 128, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "partName", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_partPosition", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "partPosition", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_partSN", System.Data.SqlDbType.NVarChar, 128, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "partSN", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_partSpec", System.Data.SqlDbType.NVarChar, 128, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "partSpec", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_partUnit", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "partUnit", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_partWarehouse", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "partWarehouse", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purCount", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purCount", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purID", System.Data.SqlDbType.VarChar, 16, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purID", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purUnitPrice", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purUnitPrice", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandItems.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purItemID", System.Data.SqlDbType.Int, 4, "purItemID")); // // sqlCommandGetById // this.sqlCommandGetById.CommandText = "[mt_Part_GetPartPurchaseByID]"; this.sqlCommandGetById.CommandType = System.Data.CommandType.StoredProcedure; this.sqlCommandGetById.Connection = this.sqlConnection; this.sqlCommandGetById.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); this.sqlCommandGetById.Parameters.Add(new System.Data.SqlClient.SqlParameter("@PurID", System.Data.SqlDbType.VarChar, 16)); // // sqlDataAdapterMain // this.sqlDataAdapterMain.DeleteCommand = this.sqlDeleteCommandMain; this.sqlDataAdapterMain.InsertCommand = this.sqlInsertCommandMain; this.sqlDataAdapterMain.SelectCommand = this.sqlSelectCommandMain; this.sqlDataAdapterMain.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] { new System.Data.Common.DataTableMapping("Table", "PartPurchase", new System.Data.Common.DataColumnMapping[] { new System.Data.Common.DataColumnMapping("purID", "purID"), new System.Data.Common.DataColumnMapping("custCustomerID", "custCustomerID"), new System.Data.Common.DataColumnMapping("purWarehouse", "purWarehouse"), new System.Data.Common.DataColumnMapping("purApplicant", "purApplicant"), new System.Data.Common.DataColumnMapping("purApprover", "purApprover"), new System.Data.Common.DataColumnMapping("purReceiveDate", "purReceiveDate"), new System.Data.Common.DataColumnMapping("purInputDate", "purInputDate"), new System.Data.Common.DataColumnMapping("purOperator", "purOperator"), new System.Data.Common.DataColumnMapping("purFlag", "purFlag"), new System.Data.Common.DataColumnMapping("custNumber", "custNumber"), new System.Data.Common.DataColumnMapping("custName", "custName"), new System.Data.Common.DataColumnMapping("conName", "conName"), new System.Data.Common.DataColumnMapping("conOfficeTel", "conOfficeTel")})}); this.sqlDataAdapterMain.UpdateCommand = this.sqlUpdateCommandMain; // // sqlSelectCommandMain // this.sqlSelectCommandMain.CommandText = "[mt_Part_GetPartPurchase]"; this.sqlSelectCommandMain.CommandType = System.Data.CommandType.StoredProcedure; this.sqlSelectCommandMain.Connection = this.sqlConnection; this.sqlSelectCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); // // sqlInsertCommandMain // this.sqlInsertCommandMain.CommandText = "[mt_Part_InsertPartPurchase]"; this.sqlInsertCommandMain.CommandType = System.Data.CommandType.StoredProcedure; this.sqlInsertCommandMain.Connection = this.sqlConnection; this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purID", System.Data.SqlDbType.VarChar, 16, System.Data.ParameterDirection.Output, false, ((System.Byte)(0)), ((System.Byte)(0)), "purID", System.Data.DataRowVersion.Current, null)); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@custCustomerID", System.Data.SqlDbType.Int, 4, "custCustomerID")); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purWarehouse", System.Data.SqlDbType.NVarChar, 50, "purWarehouse")); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purApplicant", System.Data.SqlDbType.NVarChar, 20, "purApplicant")); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purApprover", System.Data.SqlDbType.NVarChar, 20, "purApprover")); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purReceiveDate", System.Data.SqlDbType.DateTime, 8, "purReceiveDate")); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purInputDate", System.Data.SqlDbType.DateTime, 8, "purInputDate")); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purOperator", System.Data.SqlDbType.NVarChar, 20, "purOperator")); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purFlag", System.Data.SqlDbType.Int, 4, "purFlag")); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@custNumber", System.Data.SqlDbType.NVarChar, 128, "custNumber")); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@custName", System.Data.SqlDbType.NVarChar, 128, "custName")); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@conName", System.Data.SqlDbType.NVarChar, 128, "conName")); this.sqlInsertCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@conOfficeTel", System.Data.SqlDbType.NVarChar, 30, "conOfficeTel")); // // sqlUpdateCommandMain // this.sqlUpdateCommandMain.CommandText = "[mt_Part_UpdatePartPurchase]"; this.sqlUpdateCommandMain.CommandType = System.Data.CommandType.StoredProcedure; this.sqlUpdateCommandMain.Connection = this.sqlConnection; this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purID", System.Data.SqlDbType.VarChar, 16, "purID")); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@custCustomerID", System.Data.SqlDbType.Int, 4, "custCustomerID")); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purWarehouse", System.Data.SqlDbType.NVarChar, 50, "purWarehouse")); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purApplicant", System.Data.SqlDbType.NVarChar, 20, "purApplicant")); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purApprover", System.Data.SqlDbType.NVarChar, 20, "purApprover")); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purReceiveDate", System.Data.SqlDbType.DateTime, 8, "purReceiveDate")); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purInputDate", System.Data.SqlDbType.DateTime, 8, "purInputDate")); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purOperator", System.Data.SqlDbType.NVarChar, 20, "purOperator")); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@purFlag", System.Data.SqlDbType.Int, 4, "purFlag")); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@custNumber", System.Data.SqlDbType.NVarChar, 128, "custNumber")); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@custName", System.Data.SqlDbType.NVarChar, 128, "custName")); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@conName", System.Data.SqlDbType.NVarChar, 128, "conName")); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@conOfficeTel", System.Data.SqlDbType.NVarChar, 30, "conOfficeTel")); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purID", System.Data.SqlDbType.VarChar, 16, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purID", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_conName", System.Data.SqlDbType.NVarChar, 128, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "conName", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_conOfficeTel", System.Data.SqlDbType.NVarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "conOfficeTel", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_custCustomerID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "custCustomerID", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_custName", System.Data.SqlDbType.NVarChar, 128, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "custName", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_custNumber", System.Data.SqlDbType.NVarChar, 128, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "custNumber", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purApplicant", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purApplicant", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purApprover", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purApprover", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purFlag", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purFlag", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purInputDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purInputDate", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purOperator", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purOperator", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purReceiveDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purReceiveDate", System.Data.DataRowVersion.Original, null)); this.sqlUpdateCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purWarehouse", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purWarehouse", System.Data.DataRowVersion.Original, null)); // // sqlDeleteCommandMain // this.sqlDeleteCommandMain.CommandText = "[mt_Part_DeletePartPurchase]"; this.sqlDeleteCommandMain.CommandType = System.Data.CommandType.StoredProcedure; this.sqlDeleteCommandMain.Connection = this.sqlConnection; this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(0)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purID", System.Data.SqlDbType.VarChar, 16, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purID", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_conName", System.Data.SqlDbType.NVarChar, 128, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "conName", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_conOfficeTel", System.Data.SqlDbType.NVarChar, 30, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "conOfficeTel", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_custCustomerID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "custCustomerID", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_custName", System.Data.SqlDbType.NVarChar, 128, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "custName", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_custNumber", System.Data.SqlDbType.NVarChar, 128, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "custNumber", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purApplicant", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purApplicant", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purApprover", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purApprover", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purFlag", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purFlag", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purInputDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purInputDate", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purOperator", System.Data.SqlDbType.NVarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purOperator", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purReceiveDate", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purReceiveDate", System.Data.DataRowVersion.Original, null)); this.sqlDeleteCommandMain.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_purWarehouse", System.Data.SqlDbType.NVarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "purWarehouse", System.Data.DataRowVersion.Original, null)); // // sqlConnection // this.sqlConnection.ConnectionString = "workstation id=DNB;packet size=4096;user id=sa;data source=\".\";persist security i" + "nfo=False;initial catalog=BPMIS"; } #endregion public DataModel.PartPurchaseData GetPartPurchase() { DataModel.PartPurchaseData purchase=new DataModel.PartPurchaseData(); try { this.sqlDataAdapterMain.Fill(purchase,purchase.PartPurchase.TableName); /// ///fill the main info list,all the part purchase info. /// } catch { return null; } return purchase; } public DataModel.PartPurchaseData GetPartPurchaseById(string purID) { DataModel.PartPurchaseData purchase=new DataModel.PartPurchaseData(); this.sqlDataAdapterMain.SelectCommand=this.sqlCommandGetById; this.sqlDataAdapterMain.SelectCommand.Parameters["@purID"].Value=purID; //try //{ this.sqlDataAdapterMain.Fill(purchase,purchase.PartPurchase.TableName); /// ///fill the main info,a part purchase info /// this.sqlDataAdapterItems.SelectCommand.Parameters["@purID"].Value=purID; this.sqlDataAdapterItems.Fill(purchase,purchase.PartPurchaseItems.TableName); /// ///fill the items info /// //} //catch //{ // return null; //} return purchase; } public bool UpdatePartPurchase(DataModel.PartPurchaseData purchase) { try { /// ///Insert and Update the main table /// this.sqlDataAdapterMain.Update(purchase,purchase.PartPurchase.TableName ); purchase.PartPurchase.AcceptChanges(); /// ///Insert and Update the items table /// String tempID=purchase.PartPurchase.Rows[0]["purID"].ToString(); foreach(DataRow row in purchase.PartPurchaseItems.Rows) { if(row.RowState==DataRowState.Added ) { row.BeginEdit(); row["purID"]=tempID; row.EndEdit(); } } this.sqlDataAdapterItems.Update(purchase,purchase.PartPurchaseItems.TableName); purchase.PartPurchaseItems.AcceptChanges(); } catch { return false; } return true; } public bool DeletePartPurchase(PartPurchaseData purchase) { try { // //Delete a PartPurchase this.sqlDataAdapterMain.Update(purchase.PartPurchase); purchase.AcceptChanges(); } catch { return false; } return true; } } }