private void InitAdapter() { this._adapter = new global::System.Data.SqlServerCe.SqlCeDataAdapter(); global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping(); tableMapping.SourceTable = "Table"; tableMapping.DataSetTable = "Programa"; tableMapping.ColumnMappings.Add("programa_id", "programa_id"); tableMapping.ColumnMappings.Add("fecha_programada", "fecha_programada"); tableMapping.ColumnMappings.Add("estado", "estado"); this._adapter.TableMappings.Add(tableMapping); this._adapter.DeleteCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.DeleteCommand.Connection = this.Connection; this._adapter.DeleteCommand.CommandText = "DELETE FROM [Programa] WHERE (([programa_id] = @p1))"; this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "programa_id", global::System.Data.DataRowVersion.Original, null)); this._adapter.InsertCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.InsertCommand.Connection = this.Connection; this._adapter.InsertCommand.CommandText = "INSERT INTO [Programa] ([programa_id], [fecha_programada], [estado]) VALUES (@p1," + " @p2, @p3)"; this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "programa_id", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "fecha_programada", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p3", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "estado", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.UpdateCommand.Connection = this.Connection; this._adapter.UpdateCommand.CommandText = "UPDATE [Programa] SET [programa_id] = @p1, [fecha_programada] = @p2, [estado] = @" + "p3 WHERE (([programa_id] = @p4))"; this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "programa_id", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "fecha_programada", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p3", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "estado", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p4", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "programa_id", global::System.Data.DataRowVersion.Original, null)); }
private void InitAdapter() { this._adapter = new global::System.Data.SqlServerCe.SqlCeDataAdapter(); global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping(); tableMapping.SourceTable = "Table"; tableMapping.DataSetTable = "Client"; tableMapping.ColumnMappings.Add("Nom", "Nom"); tableMapping.ColumnMappings.Add("Prenom", "Prenom"); tableMapping.ColumnMappings.Add("Code ", "Code "); this._adapter.TableMappings.Add(tableMapping); }
private void InitAdapter() { this._adapter = new global::System.Data.SqlServerCe.SqlCeDataAdapter(); global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping(); tableMapping.SourceTable = "Table"; tableMapping.DataSetTable = "Options"; tableMapping.ColumnMappings.Add("Name", "Name"); tableMapping.ColumnMappings.Add("Value", "Value"); this._adapter.TableMappings.Add(tableMapping); this._adapter.DeleteCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.DeleteCommand.Connection = this.Connection; this._adapter.DeleteCommand.CommandText = "DELETE FROM [Options] WHERE (([Name] = @p1))"; this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text; global::System.Data.SqlServerCe.SqlCeParameter param = new global::System.Data.SqlServerCe.SqlCeParameter(); param.ParameterName = "@p1"; param.IsNullable = true; param.SourceColumn = "Name"; param.SourceVersion = global::System.Data.DataRowVersion.Original; this._adapter.DeleteCommand.Parameters.Add(param); this._adapter.InsertCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.InsertCommand.Connection = this.Connection; this._adapter.InsertCommand.CommandText = "INSERT INTO [Options] ([Name], [Value]) VALUES (@p1, @p2)"; this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text; param = new global::System.Data.SqlServerCe.SqlCeParameter(); param.ParameterName = "@p1"; param.IsNullable = true; param.SourceColumn = "Name"; this._adapter.InsertCommand.Parameters.Add(param); param = new global::System.Data.SqlServerCe.SqlCeParameter(); param.ParameterName = "@p2"; param.IsNullable = true; param.SourceColumn = "Value"; this._adapter.InsertCommand.Parameters.Add(param); this._adapter.UpdateCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.UpdateCommand.Connection = this.Connection; this._adapter.UpdateCommand.CommandText = "UPDATE [Options] SET [Name] = @p1, [Value] = @p2 WHERE (([Name] = @p3))"; this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text; param = new global::System.Data.SqlServerCe.SqlCeParameter(); param.ParameterName = "@p1"; param.IsNullable = true; param.SourceColumn = "Name"; this._adapter.UpdateCommand.Parameters.Add(param); param = new global::System.Data.SqlServerCe.SqlCeParameter(); param.ParameterName = "@p2"; param.IsNullable = true; param.SourceColumn = "Value"; this._adapter.UpdateCommand.Parameters.Add(param); param = new global::System.Data.SqlServerCe.SqlCeParameter(); param.ParameterName = "@p3"; param.IsNullable = true; param.SourceColumn = "Name"; param.SourceVersion = global::System.Data.DataRowVersion.Original; this._adapter.UpdateCommand.Parameters.Add(param); }
private void InitAdapter() { this._adapter = new global::System.Data.SqlServerCe.SqlCeDataAdapter(); global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping(); tableMapping.SourceTable = "Table"; tableMapping.DataSetTable = "PRODUCTS"; tableMapping.ColumnMappings.Add("ID_PRODUCT", "ID_PRODUCT"); tableMapping.ColumnMappings.Add("REFERENCE", "REFERENCE"); tableMapping.ColumnMappings.Add("EXPIRING_DATE", "EXPIRING_DATE"); tableMapping.ColumnMappings.Add("DT_CRE", "DT_CRE"); tableMapping.ColumnMappings.Add("USER_CRE", "USER_CRE"); tableMapping.ColumnMappings.Add("DT_MOD", "DT_MOD"); tableMapping.ColumnMappings.Add("USER_MOD", "USER_MOD"); this._adapter.TableMappings.Add(tableMapping); }
private void InitAdapter() { this._adapter = new global::System.Data.SqlServerCe.SqlCeDataAdapter(); global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping(); tableMapping.SourceTable = "Table"; tableMapping.DataSetTable = "Products"; tableMapping.ColumnMappings.Add("Reference", "Reference"); tableMapping.ColumnMappings.Add("Name", "Name"); tableMapping.ColumnMappings.Add("Picture", "Picture"); tableMapping.ColumnMappings.Add("ExpiryDate", "ExpiryDate"); this._adapter.TableMappings.Add(tableMapping); this._adapter.DeleteCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.DeleteCommand.Connection = this.Connection; this._adapter.DeleteCommand.CommandText = "DELETE FROM [Products] WHERE (([Reference] = @p1))"; this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Reference", global::System.Data.DataRowVersion.Original, null)); this._adapter.InsertCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.InsertCommand.Connection = this.Connection; this._adapter.InsertCommand.CommandText = "INSERT INTO [Products] ([Reference], [Name], [Picture], [ExpiryDate]) VALUES (@p1" + ", @p2, @p3, @p4)"; this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Reference", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Name", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p3", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Picture", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p4", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ExpiryDate", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.UpdateCommand.Connection = this.Connection; this._adapter.UpdateCommand.CommandText = "UPDATE [Products] SET [Reference] = @p1, [Name] = @p2, [Picture] = @p3, [ExpiryDa" + "te] = @p4 WHERE (([Reference] = @p5))"; this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Reference", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Name", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p3", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Picture", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p4", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ExpiryDate", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p5", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Reference", global::System.Data.DataRowVersion.Original, null)); }
private void InitAdapter() { this._adapter = new global::System.Data.SqlServerCe.SqlCeDataAdapter(); global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping(); tableMapping.SourceTable = "Table"; tableMapping.DataSetTable = "DocsBinTbl"; tableMapping.ColumnMappings.Add("Barcode", "Barcode"); tableMapping.ColumnMappings.Add("DocId", "DocId"); tableMapping.ColumnMappings.Add("Priority", "Priority"); tableMapping.ColumnMappings.Add("Quantity", "Quantity"); tableMapping.ColumnMappings.Add("RePriceDate", "RePriceDate"); tableMapping.ColumnMappings.Add("ReturnDate", "ReturnDate"); tableMapping.ColumnMappings.Add("Shablon", "Shablon"); tableMapping.ColumnMappings.Add("Text1", "Text1"); tableMapping.ColumnMappings.Add("Text2", "Text2"); tableMapping.ColumnMappings.Add("Text3", "Text3"); this._adapter.TableMappings.Add(tableMapping); this._adapter.DeleteCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.DeleteCommand.Connection = this.Connection; this._adapter.DeleteCommand.CommandText = "DELETE FROM [DocsBinTbl] WHERE (([Barcode] = @p1) AND ([DocId] = @p2))"; this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Original, null)); this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "DocId", global::System.Data.DataRowVersion.Original, null)); this._adapter.InsertCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.InsertCommand.Connection = this.Connection; this._adapter.InsertCommand.CommandText = "INSERT INTO [DocsBinTbl] ([Barcode], [DocId], [Priority], [Quantity], [RePriceDat" + "e], [ReturnDate], [Shablon], [Text1], [Text2], [Text3]) VALUES (@p1, @p2, @p3, @" + "p4, @p5, @p6, @p7, @p8, @p9, @p10)"; this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "DocId", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p3", global::System.Data.SqlDbType.SmallInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Priority", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p4", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Quantity", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p5", global::System.Data.SqlDbType.SmallInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "RePriceDate", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p6", global::System.Data.SqlDbType.SmallInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ReturnDate", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p7", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Shablon", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p8", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Text1", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p9", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Text2", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p10", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Text3", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.UpdateCommand.Connection = this.Connection; this._adapter.UpdateCommand.CommandText = "UPDATE [DocsBinTbl] SET [Barcode] = @p1, [DocId] = @p2, [Priority] = @p3, [Quanti" + "ty] = @p4, [RePriceDate] = @p5, [ReturnDate] = @p6, [Shablon] = @p7, [Text1] = @" + "p8, [Text2] = @p9, [Text3] = @p10 WHERE (([Barcode] = @p11) AND ([DocId] = @p12)" + ")"; this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "DocId", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p3", global::System.Data.SqlDbType.SmallInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Priority", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p4", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Quantity", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p5", global::System.Data.SqlDbType.SmallInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "RePriceDate", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p6", global::System.Data.SqlDbType.SmallInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ReturnDate", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p7", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Shablon", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p8", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Text1", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p9", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Text2", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p10", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Text3", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p11", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Original, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p12", global::System.Data.SqlDbType.VarBinary, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "DocId", global::System.Data.DataRowVersion.Original, null)); }
private void InitAdapter() { this._adapter = new global::System.Data.SqlServerCe.SqlCeDataAdapter(); global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping(); tableMapping.SourceTable = "Table"; tableMapping.DataSetTable = "DocsTbl"; tableMapping.ColumnMappings.Add("Barcode", "Barcode"); tableMapping.ColumnMappings.Add("DocType", "DocType"); tableMapping.ColumnMappings.Add("DocId", "DocId"); tableMapping.ColumnMappings.Add("WorkMode", "WorkMode"); tableMapping.ColumnMappings.Add("Priority", "Priority"); tableMapping.ColumnMappings.Add("Quantity", "Quantity"); tableMapping.ColumnMappings.Add("RePriceDate", "RePriceDate"); tableMapping.ColumnMappings.Add("ReturnDate", "ReturnDate"); tableMapping.ColumnMappings.Add("LabelCode", "LabelCode"); tableMapping.ColumnMappings.Add("MusicCode", "MusicCode"); tableMapping.ColumnMappings.Add("VibroCode", "VibroCode"); tableMapping.ColumnMappings.Add("Text1", "Text1"); tableMapping.ColumnMappings.Add("Text2", "Text2"); tableMapping.ColumnMappings.Add("Text3", "Text3"); this._adapter.TableMappings.Add(tableMapping); this._adapter.DeleteCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.DeleteCommand.Connection = this.Connection; this._adapter.DeleteCommand.CommandText = "DELETE FROM [DocsTbl] WHERE (([Barcode] = @p1) AND ([DocId] = @p2) AND ([DocType]" + " = @p3))"; this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Original, null)); this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "DocId", global::System.Data.DataRowVersion.Original, null)); this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p3", global::System.Data.SqlDbType.TinyInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "DocType", global::System.Data.DataRowVersion.Original, null)); this._adapter.InsertCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.InsertCommand.Connection = this.Connection; this._adapter.InsertCommand.CommandText = @"INSERT INTO [DocsTbl] ([Barcode], [DocId], [DocType], [WorkMode], [Priority], [Quantity], [RePriceDate], [ReturnDate], [LabelCode], [MusicCode], [VibroCode], [Text1], [Text2], [Text3]) VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7, @p8, @p9, @p10, @p11, @p12, @p13, @p14)"; this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "DocId", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p3", global::System.Data.SqlDbType.TinyInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "DocType", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p4", global::System.Data.SqlDbType.TinyInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "WorkMode", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p5", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Priority", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p6", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Quantity", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p7", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "RePriceDate", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p8", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ReturnDate", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p9", global::System.Data.SqlDbType.TinyInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "LabelCode", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p10", global::System.Data.SqlDbType.TinyInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "MusicCode", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p11", global::System.Data.SqlDbType.TinyInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "VibroCode", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p12", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Text1", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p13", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Text2", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p14", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Text3", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.UpdateCommand.Connection = this.Connection; this._adapter.UpdateCommand.CommandText = @"UPDATE [DocsTbl] SET [Barcode] = @p1, [DocId] = @p2, [DocType] = @p3, [WorkMode] = @p4, [Priority] = @p5, [Quantity] = @p6, [RePriceDate] = @p7, [ReturnDate] = @p8, [LabelCode] = @p9, [MusicCode] = @p10, [VibroCode] = @p11, [Text1] = @p12, [Text2] = @p13, [Text3] = @p14 WHERE (([Barcode] = @p15) AND ([DocId] = @p16) AND ([DocType] = @p17))"; this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "DocId", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p3", global::System.Data.SqlDbType.TinyInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "DocType", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p4", global::System.Data.SqlDbType.TinyInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "WorkMode", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p5", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Priority", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p6", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Quantity", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p7", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "RePriceDate", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p8", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ReturnDate", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p9", global::System.Data.SqlDbType.TinyInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "LabelCode", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p10", global::System.Data.SqlDbType.TinyInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "MusicCode", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p11", global::System.Data.SqlDbType.TinyInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "VibroCode", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p12", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Text1", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p13", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Text2", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p14", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Text3", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p15", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Original, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p16", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "DocId", global::System.Data.DataRowVersion.Original, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p17", global::System.Data.SqlDbType.TinyInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "DocType", global::System.Data.DataRowVersion.Original, null)); }
private void InitAdapter() { this._adapter = new global::System.Data.SqlServerCe.SqlCeDataAdapter(); global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping(); tableMapping.SourceTable = "Table"; tableMapping.DataSetTable = "ProductsTbl"; tableMapping.ColumnMappings.Add("Barcode", "Barcode"); tableMapping.ColumnMappings.Add("ProductName", "ProductName"); tableMapping.ColumnMappings.Add("Article", "Article"); tableMapping.ColumnMappings.Add("Country", "Country"); tableMapping.ColumnMappings.Add("NavCode", "NavCode"); tableMapping.ColumnMappings.Add("Structure", "Structure"); tableMapping.ColumnMappings.Add("OldPrice", "OldPrice"); tableMapping.ColumnMappings.Add("NewPrice", "NewPrice"); tableMapping.ColumnMappings.Add("Message", "Message"); this._adapter.TableMappings.Add(tableMapping); this._adapter.DeleteCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.DeleteCommand.Connection = this.Connection; this._adapter.DeleteCommand.CommandText = "DELETE FROM [ProductsTbl] WHERE (([Barcode] = @p1))"; this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Original, null)); this._adapter.InsertCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.InsertCommand.Connection = this.Connection; this._adapter.InsertCommand.CommandText = "INSERT INTO [ProductsTbl] ([Barcode], [ProductName], [Article], [Country], [NavCo" + "de], [Structure], [OldPrice], [NewPrice], [Message]) VALUES (@p1, @p2, @p3, @p4," + " @p5, @p6, @p7, @p8, @p9)"; this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ProductName", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p3", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Article", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p4", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Country", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p5", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "NavCode", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p6", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Structure", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p7", global::System.Data.SqlDbType.Real, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "OldPrice", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p8", global::System.Data.SqlDbType.Real, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "NewPrice", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p9", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Message", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.UpdateCommand.Connection = this.Connection; this._adapter.UpdateCommand.CommandText = "UPDATE [ProductsTbl] SET [Barcode] = @p1, [ProductName] = @p2, [Article] = @p3, [" + "Country] = @p4, [NavCode] = @p5, [Structure] = @p6, [OldPrice] = @p7, [NewPrice]" + " = @p8, [Message] = @p9 WHERE (([Barcode] = @p10))"; this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ProductName", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p3", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Article", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p4", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Country", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p5", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "NavCode", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p6", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Structure", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p7", global::System.Data.SqlDbType.Real, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "OldPrice", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p8", global::System.Data.SqlDbType.Real, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "NewPrice", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p9", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Message", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p10", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Original, null)); }
private void InitAdapter() { this._adapter = new global::System.Data.SqlServerCe.SqlCeDataAdapter(); global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping(); tableMapping.SourceTable = "Table"; tableMapping.DataSetTable = "MoveResultsTbl"; tableMapping.ColumnMappings.Add("Barcode", "Barcode"); tableMapping.ColumnMappings.Add("MoveId", "MoveId"); tableMapping.ColumnMappings.Add("ScannedQuantity", "ScannedQuantity"); tableMapping.ColumnMappings.Add("PrintedQuantity", "PrintedQuantity"); this._adapter.TableMappings.Add(tableMapping); this._adapter.DeleteCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.DeleteCommand.Connection = this.Connection; this._adapter.DeleteCommand.CommandText = "DELETE FROM [MoveResultsTbl] WHERE (([Barcode] = @p1) AND ([MoveId] = @p2))"; this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Original, null)); this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "MoveId", global::System.Data.DataRowVersion.Original, null)); this._adapter.InsertCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.InsertCommand.Connection = this.Connection; this._adapter.InsertCommand.CommandText = "INSERT INTO [MoveResultsTbl] ([Barcode], [MoveId], [ScannedQuantity], [PrintedQua" + "ntity]) VALUES (@p1, @p2, @p3, @p4)"; this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "MoveId", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p3", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ScannedQuantity", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p4", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "PrintedQuantity", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.UpdateCommand.Connection = this.Connection; this._adapter.UpdateCommand.CommandText = "UPDATE [MoveResultsTbl] SET [Barcode] = @p1, [MoveId] = @p2, [ScannedQuantity] = " + "@p3, [PrintedQuantity] = @p4 WHERE (([Barcode] = @p5) AND ([MoveId] = @p6))"; this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "MoveId", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p3", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ScannedQuantity", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p4", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "PrintedQuantity", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p5", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Original, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p6", global::System.Data.SqlDbType.NVarChar, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "MoveId", global::System.Data.DataRowVersion.Original, null)); }
private void InitAdapter() { this._adapter = new global::System.Data.SqlServerCe.SqlCeDataAdapter(); global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping(); tableMapping.SourceTable = "Table"; tableMapping.DataSetTable = "ScannedBarcodes"; tableMapping.ColumnMappings.Add("Barcode", "Barcode"); tableMapping.ColumnMappings.Add("ActionCode", "ActionCode"); tableMapping.ColumnMappings.Add("ScannedDate", "ScannedDate"); tableMapping.ColumnMappings.Add("PrintedQuantity", "PrintedQuantity"); tableMapping.ColumnMappings.Add("ScannedQuantity", "ScannedQuantity"); this._adapter.TableMappings.Add(tableMapping); this._adapter.DeleteCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.DeleteCommand.Connection = this.Connection; this._adapter.DeleteCommand.CommandText = "DELETE FROM [ScannedBarcodes] WHERE (([Barcode] = @p1) AND ([ActionCode] = @p2) A" + "ND ([ScannedDate] = @p3))"; this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Original, null)); this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.TinyInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ActionCode", global::System.Data.DataRowVersion.Original, null)); this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p3", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ScannedDate", global::System.Data.DataRowVersion.Original, null)); this._adapter.InsertCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.InsertCommand.Connection = this.Connection; this._adapter.InsertCommand.CommandText = "INSERT INTO [ScannedBarcodes] ([Barcode], [ActionCode], [ScannedDate], [PrintedQu" + "antity], [ScannedQuantity]) VALUES (@p1, @p2, @p3, @p4, @p5)"; this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.TinyInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ActionCode", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p3", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ScannedDate", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p4", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "PrintedQuantity", global::System.Data.DataRowVersion.Current, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p5", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ScannedQuantity", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand = new global::System.Data.SqlServerCe.SqlCeCommand(); this._adapter.UpdateCommand.Connection = this.Connection; this._adapter.UpdateCommand.CommandText = "UPDATE [ScannedBarcodes] SET [Barcode] = @p1, [ActionCode] = @p2, [ScannedDate] =" + " @p3, [PrintedQuantity] = @p4, [ScannedQuantity] = @p5 WHERE (([Barcode] = @p6) " + "AND ([ActionCode] = @p7) AND ([ScannedDate] = @p8))"; this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p1", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p2", global::System.Data.SqlDbType.TinyInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ActionCode", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p3", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ScannedDate", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p4", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "PrintedQuantity", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p5", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ScannedQuantity", global::System.Data.DataRowVersion.Current, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p6", global::System.Data.SqlDbType.BigInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "Barcode", global::System.Data.DataRowVersion.Original, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p7", global::System.Data.SqlDbType.TinyInt, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ActionCode", global::System.Data.DataRowVersion.Original, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlServerCe.SqlCeParameter("@p8", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, true, 0, 0, "ScannedDate", global::System.Data.DataRowVersion.Original, null)); }