//------------------------------------------------------------------------------
//
// 이 코드는 도구를 사용하여 생성되었습니다.
// 런타임 버전:4.0.30319.42000
//
// 파일 내용을 변경하면 잘못된 동작이 발생할 수 있으며, 코드를 다시 생성하면
// 이러한 변경 내용이 손실됩니다.
//
//------------------------------------------------------------------------------
#pragma warning disable 1591
namespace ResultView {
///
///Represents a strongly typed in-memory cache of data.
///
[global::System.Serializable()]
[global::System.ComponentModel.DesignerCategoryAttribute("code")]
[global::System.ComponentModel.ToolboxItem(true)]
[global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedDataSetSchema")]
[global::System.Xml.Serialization.XmlRootAttribute("DataSet1")]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
public partial class DataSet1 : global::System.Data.DataSet {
private K4EE_Component_Reel_ResultDataTable tableK4EE_Component_Reel_Result;
private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public DataSet1() {
this.BeginInit();
this.InitClass();
global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
base.Tables.CollectionChanged += schemaChangedHandler;
base.Relations.CollectionChanged += schemaChangedHandler;
this.EndInit();
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
protected DataSet1(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
base(info, context, false) {
if ((this.IsBinarySerialized(info, context) == true)) {
this.InitVars(false);
global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler1 = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
this.Tables.CollectionChanged += schemaChangedHandler1;
this.Relations.CollectionChanged += schemaChangedHandler1;
return;
}
string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
if ((this.DetermineSchemaSerializationMode(info, context) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
global::System.Data.DataSet ds = new global::System.Data.DataSet();
ds.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
if ((ds.Tables["K4EE_Component_Reel_Result"] != null)) {
base.Tables.Add(new K4EE_Component_Reel_ResultDataTable(ds.Tables["K4EE_Component_Reel_Result"]));
}
this.DataSetName = ds.DataSetName;
this.Prefix = ds.Prefix;
this.Namespace = ds.Namespace;
this.Locale = ds.Locale;
this.CaseSensitive = ds.CaseSensitive;
this.EnforceConstraints = ds.EnforceConstraints;
this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
this.InitVars();
}
else {
this.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema)));
}
this.GetSerializationData(info, context);
global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
base.Tables.CollectionChanged += schemaChangedHandler;
this.Relations.CollectionChanged += schemaChangedHandler;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.Browsable(false)]
[global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
public K4EE_Component_Reel_ResultDataTable K4EE_Component_Reel_Result {
get {
return this.tableK4EE_Component_Reel_Result;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.BrowsableAttribute(true)]
[global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Visible)]
public override global::System.Data.SchemaSerializationMode SchemaSerializationMode {
get {
return this._schemaSerializationMode;
}
set {
this._schemaSerializationMode = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
public new global::System.Data.DataTableCollection Tables {
get {
return base.Tables;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)]
public new global::System.Data.DataRelationCollection Relations {
get {
return base.Relations;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
protected override void InitializeDerivedDataSet() {
this.BeginInit();
this.InitClass();
this.EndInit();
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public override global::System.Data.DataSet Clone() {
DataSet1 cln = ((DataSet1)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return cln;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
protected override bool ShouldSerializeTables() {
return false;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
protected override bool ShouldSerializeRelations() {
return false;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
protected override void ReadXmlSerializable(global::System.Xml.XmlReader reader) {
if ((this.DetermineSchemaSerializationMode(reader) == global::System.Data.SchemaSerializationMode.IncludeSchema)) {
this.Reset();
global::System.Data.DataSet ds = new global::System.Data.DataSet();
ds.ReadXml(reader);
if ((ds.Tables["K4EE_Component_Reel_Result"] != null)) {
base.Tables.Add(new K4EE_Component_Reel_ResultDataTable(ds.Tables["K4EE_Component_Reel_Result"]));
}
this.DataSetName = ds.DataSetName;
this.Prefix = ds.Prefix;
this.Namespace = ds.Namespace;
this.Locale = ds.Locale;
this.CaseSensitive = ds.CaseSensitive;
this.EnforceConstraints = ds.EnforceConstraints;
this.Merge(ds, false, global::System.Data.MissingSchemaAction.Add);
this.InitVars();
}
else {
this.ReadXml(reader);
this.InitVars();
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
protected override global::System.Xml.Schema.XmlSchema GetSchemaSerializable() {
global::System.IO.MemoryStream stream = new global::System.IO.MemoryStream();
this.WriteXmlSchema(new global::System.Xml.XmlTextWriter(stream, null));
stream.Position = 0;
return global::System.Xml.Schema.XmlSchema.Read(new global::System.Xml.XmlTextReader(stream), null);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
internal void InitVars() {
this.InitVars(true);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
internal void InitVars(bool initTable) {
this.tableK4EE_Component_Reel_Result = ((K4EE_Component_Reel_ResultDataTable)(base.Tables["K4EE_Component_Reel_Result"]));
if ((initTable == true)) {
if ((this.tableK4EE_Component_Reel_Result != null)) {
this.tableK4EE_Component_Reel_Result.InitVars();
}
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
private void InitClass() {
this.DataSetName = "DataSet1";
this.Prefix = "";
this.Namespace = "http://tempuri.org/DataSet1.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableK4EE_Component_Reel_Result = new K4EE_Component_Reel_ResultDataTable();
base.Tables.Add(this.tableK4EE_Component_Reel_Result);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
private bool ShouldSerializeK4EE_Component_Reel_Result() {
return false;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
private void SchemaChanged(object sender, global::System.ComponentModel.CollectionChangeEventArgs e) {
if ((e.Action == global::System.ComponentModel.CollectionChangeAction.Remove)) {
this.InitVars();
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
DataSet1 ds = new DataSet1();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public delegate void K4EE_Component_Reel_ResultRowChangeEventHandler(object sender, K4EE_Component_Reel_ResultRowChangeEvent e);
///
///Represents the strongly named DataTable class.
///
[global::System.Serializable()]
[global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")]
public partial class K4EE_Component_Reel_ResultDataTable : global::System.Data.TypedTableBase {
private global::System.Data.DataColumn columnidx;
private global::System.Data.DataColumn columnSTIME;
private global::System.Data.DataColumn columnETIME;
private global::System.Data.DataColumn columnPDATE;
private global::System.Data.DataColumn columnJTYPE;
private global::System.Data.DataColumn columnJGUID;
private global::System.Data.DataColumn columnSID;
private global::System.Data.DataColumn columnSID0;
private global::System.Data.DataColumn columnRID;
private global::System.Data.DataColumn columnRID0;
private global::System.Data.DataColumn columnRSN;
private global::System.Data.DataColumn columnQR;
private global::System.Data.DataColumn columnZPL;
private global::System.Data.DataColumn columnPOS;
private global::System.Data.DataColumn columnLOC;
private global::System.Data.DataColumn columnANGLE;
private global::System.Data.DataColumn columnQTY;
private global::System.Data.DataColumn columnQTY0;
private global::System.Data.DataColumn columnVNAME;
private global::System.Data.DataColumn columnPRNATTACH;
private global::System.Data.DataColumn columnPRNVALID;
private global::System.Data.DataColumn columnwdate;
private global::System.Data.DataColumn columnVLOT;
private global::System.Data.DataColumn columnBATCH;
private global::System.Data.DataColumn columnqtymax;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public K4EE_Component_Reel_ResultDataTable() {
this.TableName = "K4EE_Component_Reel_Result";
this.BeginInit();
this.InitClass();
this.EndInit();
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
internal K4EE_Component_Reel_ResultDataTable(global::System.Data.DataTable table) {
this.TableName = table.TableName;
if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
this.CaseSensitive = table.CaseSensitive;
}
if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
this.Locale = table.Locale;
}
if ((table.Namespace != table.DataSet.Namespace)) {
this.Namespace = table.Namespace;
}
this.Prefix = table.Prefix;
this.MinimumCapacity = table.MinimumCapacity;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
protected K4EE_Component_Reel_ResultDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) :
base(info, context) {
this.InitVars();
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn idxColumn {
get {
return this.columnidx;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn STIMEColumn {
get {
return this.columnSTIME;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn ETIMEColumn {
get {
return this.columnETIME;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn PDATEColumn {
get {
return this.columnPDATE;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn JTYPEColumn {
get {
return this.columnJTYPE;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn JGUIDColumn {
get {
return this.columnJGUID;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn SIDColumn {
get {
return this.columnSID;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn SID0Column {
get {
return this.columnSID0;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn RIDColumn {
get {
return this.columnRID;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn RID0Column {
get {
return this.columnRID0;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn RSNColumn {
get {
return this.columnRSN;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn QRColumn {
get {
return this.columnQR;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn ZPLColumn {
get {
return this.columnZPL;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn POSColumn {
get {
return this.columnPOS;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn LOCColumn {
get {
return this.columnLOC;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn ANGLEColumn {
get {
return this.columnANGLE;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn QTYColumn {
get {
return this.columnQTY;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn QTY0Column {
get {
return this.columnQTY0;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn VNAMEColumn {
get {
return this.columnVNAME;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn PRNATTACHColumn {
get {
return this.columnPRNATTACH;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn PRNVALIDColumn {
get {
return this.columnPRNVALID;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn wdateColumn {
get {
return this.columnwdate;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn VLOTColumn {
get {
return this.columnVLOT;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn BATCHColumn {
get {
return this.columnBATCH;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataColumn qtymaxColumn {
get {
return this.columnqtymax;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.Browsable(false)]
public int Count {
get {
return this.Rows.Count;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public K4EE_Component_Reel_ResultRow this[int index] {
get {
return ((K4EE_Component_Reel_ResultRow)(this.Rows[index]));
}
}
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public event K4EE_Component_Reel_ResultRowChangeEventHandler K4EE_Component_Reel_ResultRowChanging;
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public event K4EE_Component_Reel_ResultRowChangeEventHandler K4EE_Component_Reel_ResultRowChanged;
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public event K4EE_Component_Reel_ResultRowChangeEventHandler K4EE_Component_Reel_ResultRowDeleting;
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public event K4EE_Component_Reel_ResultRowChangeEventHandler K4EE_Component_Reel_ResultRowDeleted;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void AddK4EE_Component_Reel_ResultRow(K4EE_Component_Reel_ResultRow row) {
this.Rows.Add(row);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public K4EE_Component_Reel_ResultRow AddK4EE_Component_Reel_ResultRow(
System.DateTime STIME,
System.DateTime ETIME,
string PDATE,
string JTYPE,
string JGUID,
string SID,
string SID0,
string RID,
string RID0,
string RSN,
string QR,
string ZPL,
string POS,
string LOC,
double ANGLE,
int QTY,
int QTY0,
string VNAME,
bool PRNATTACH,
bool PRNVALID,
System.DateTime wdate,
string VLOT,
string BATCH,
int qtymax) {
K4EE_Component_Reel_ResultRow rowK4EE_Component_Reel_ResultRow = ((K4EE_Component_Reel_ResultRow)(this.NewRow()));
object[] columnValuesArray = new object[] {
null,
STIME,
ETIME,
PDATE,
JTYPE,
JGUID,
SID,
SID0,
RID,
RID0,
RSN,
QR,
ZPL,
POS,
LOC,
ANGLE,
QTY,
QTY0,
VNAME,
PRNATTACH,
PRNVALID,
wdate,
VLOT,
BATCH,
qtymax};
rowK4EE_Component_Reel_ResultRow.ItemArray = columnValuesArray;
this.Rows.Add(rowK4EE_Component_Reel_ResultRow);
return rowK4EE_Component_Reel_ResultRow;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public K4EE_Component_Reel_ResultRow FindByidx(int idx) {
return ((K4EE_Component_Reel_ResultRow)(this.Rows.Find(new object[] {
idx})));
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public override global::System.Data.DataTable Clone() {
K4EE_Component_Reel_ResultDataTable cln = ((K4EE_Component_Reel_ResultDataTable)(base.Clone()));
cln.InitVars();
return cln;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
protected override global::System.Data.DataTable CreateInstance() {
return new K4EE_Component_Reel_ResultDataTable();
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
internal void InitVars() {
this.columnidx = base.Columns["idx"];
this.columnSTIME = base.Columns["STIME"];
this.columnETIME = base.Columns["ETIME"];
this.columnPDATE = base.Columns["PDATE"];
this.columnJTYPE = base.Columns["JTYPE"];
this.columnJGUID = base.Columns["JGUID"];
this.columnSID = base.Columns["SID"];
this.columnSID0 = base.Columns["SID0"];
this.columnRID = base.Columns["RID"];
this.columnRID0 = base.Columns["RID0"];
this.columnRSN = base.Columns["RSN"];
this.columnQR = base.Columns["QR"];
this.columnZPL = base.Columns["ZPL"];
this.columnPOS = base.Columns["POS"];
this.columnLOC = base.Columns["LOC"];
this.columnANGLE = base.Columns["ANGLE"];
this.columnQTY = base.Columns["QTY"];
this.columnQTY0 = base.Columns["QTY0"];
this.columnVNAME = base.Columns["VNAME"];
this.columnPRNATTACH = base.Columns["PRNATTACH"];
this.columnPRNVALID = base.Columns["PRNVALID"];
this.columnwdate = base.Columns["wdate"];
this.columnVLOT = base.Columns["VLOT"];
this.columnBATCH = base.Columns["BATCH"];
this.columnqtymax = base.Columns["qtymax"];
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
private void InitClass() {
this.columnidx = new global::System.Data.DataColumn("idx", typeof(int), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnidx);
this.columnSTIME = new global::System.Data.DataColumn("STIME", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnSTIME);
this.columnETIME = new global::System.Data.DataColumn("ETIME", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnETIME);
this.columnPDATE = new global::System.Data.DataColumn("PDATE", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnPDATE);
this.columnJTYPE = new global::System.Data.DataColumn("JTYPE", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnJTYPE);
this.columnJGUID = new global::System.Data.DataColumn("JGUID", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnJGUID);
this.columnSID = new global::System.Data.DataColumn("SID", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnSID);
this.columnSID0 = new global::System.Data.DataColumn("SID0", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnSID0);
this.columnRID = new global::System.Data.DataColumn("RID", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnRID);
this.columnRID0 = new global::System.Data.DataColumn("RID0", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnRID0);
this.columnRSN = new global::System.Data.DataColumn("RSN", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnRSN);
this.columnQR = new global::System.Data.DataColumn("QR", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnQR);
this.columnZPL = new global::System.Data.DataColumn("ZPL", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnZPL);
this.columnPOS = new global::System.Data.DataColumn("POS", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnPOS);
this.columnLOC = new global::System.Data.DataColumn("LOC", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnLOC);
this.columnANGLE = new global::System.Data.DataColumn("ANGLE", typeof(double), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnANGLE);
this.columnQTY = new global::System.Data.DataColumn("QTY", typeof(int), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnQTY);
this.columnQTY0 = new global::System.Data.DataColumn("QTY0", typeof(int), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnQTY0);
this.columnVNAME = new global::System.Data.DataColumn("VNAME", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnVNAME);
this.columnPRNATTACH = new global::System.Data.DataColumn("PRNATTACH", typeof(bool), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnPRNATTACH);
this.columnPRNVALID = new global::System.Data.DataColumn("PRNVALID", typeof(bool), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnPRNVALID);
this.columnwdate = new global::System.Data.DataColumn("wdate", typeof(global::System.DateTime), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnwdate);
this.columnVLOT = new global::System.Data.DataColumn("VLOT", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnVLOT);
this.columnBATCH = new global::System.Data.DataColumn("BATCH", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnBATCH);
this.columnqtymax = new global::System.Data.DataColumn("qtymax", typeof(int), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnqtymax);
this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
this.columnidx}, true));
this.columnidx.AutoIncrement = true;
this.columnidx.AutoIncrementSeed = -1;
this.columnidx.AutoIncrementStep = -1;
this.columnidx.AllowDBNull = false;
this.columnidx.ReadOnly = true;
this.columnidx.Unique = true;
this.columnSTIME.AllowDBNull = false;
this.columnPDATE.MaxLength = 10;
this.columnJTYPE.MaxLength = 10;
this.columnJGUID.MaxLength = 50;
this.columnSID.MaxLength = 20;
this.columnSID0.MaxLength = 20;
this.columnRID.MaxLength = 50;
this.columnRID0.MaxLength = 50;
this.columnRSN.MaxLength = 10;
this.columnQR.MaxLength = 100;
this.columnZPL.MaxLength = 1000;
this.columnPOS.MaxLength = 10;
this.columnLOC.MaxLength = 1;
this.columnVNAME.MaxLength = 100;
this.columnwdate.AllowDBNull = false;
this.columnVLOT.MaxLength = 100;
this.columnBATCH.MaxLength = 100;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public K4EE_Component_Reel_ResultRow NewK4EE_Component_Reel_ResultRow() {
return ((K4EE_Component_Reel_ResultRow)(this.NewRow()));
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
return new K4EE_Component_Reel_ResultRow(builder);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
protected override global::System.Type GetRowType() {
return typeof(K4EE_Component_Reel_ResultRow);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowChanged(e);
if ((this.K4EE_Component_Reel_ResultRowChanged != null)) {
this.K4EE_Component_Reel_ResultRowChanged(this, new K4EE_Component_Reel_ResultRowChangeEvent(((K4EE_Component_Reel_ResultRow)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowChanging(e);
if ((this.K4EE_Component_Reel_ResultRowChanging != null)) {
this.K4EE_Component_Reel_ResultRowChanging(this, new K4EE_Component_Reel_ResultRowChangeEvent(((K4EE_Component_Reel_ResultRow)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleted(e);
if ((this.K4EE_Component_Reel_ResultRowDeleted != null)) {
this.K4EE_Component_Reel_ResultRowDeleted(this, new K4EE_Component_Reel_ResultRowChangeEvent(((K4EE_Component_Reel_ResultRow)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleting(e);
if ((this.K4EE_Component_Reel_ResultRowDeleting != null)) {
this.K4EE_Component_Reel_ResultRowDeleting(this, new K4EE_Component_Reel_ResultRowChangeEvent(((K4EE_Component_Reel_ResultRow)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void RemoveK4EE_Component_Reel_ResultRow(K4EE_Component_Reel_ResultRow row) {
this.Rows.Remove(row);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) {
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
DataSet1 ds = new DataSet1();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "K4EE_Component_Reel_ResultDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace)) {
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) {
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length)) {
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length)
&& (s1.ReadByte() == s2.ReadByte())); ) {
;
}
if ((s1.Position == s1.Length)) {
return type;
}
}
}
}
finally {
if ((s1 != null)) {
s1.Close();
}
if ((s2 != null)) {
s2.Close();
}
}
}
xs.Add(dsSchema);
return type;
}
}
///
///Represents strongly named DataRow class.
///
public partial class K4EE_Component_Reel_ResultRow : global::System.Data.DataRow {
private K4EE_Component_Reel_ResultDataTable tableK4EE_Component_Reel_Result;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
internal K4EE_Component_Reel_ResultRow(global::System.Data.DataRowBuilder rb) :
base(rb) {
this.tableK4EE_Component_Reel_Result = ((K4EE_Component_Reel_ResultDataTable)(this.Table));
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public int idx {
get {
return ((int)(this[this.tableK4EE_Component_Reel_Result.idxColumn]));
}
set {
this[this.tableK4EE_Component_Reel_Result.idxColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public System.DateTime STIME {
get {
return ((global::System.DateTime)(this[this.tableK4EE_Component_Reel_Result.STIMEColumn]));
}
set {
this[this.tableK4EE_Component_Reel_Result.STIMEColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public System.DateTime ETIME {
get {
try {
return ((global::System.DateTime)(this[this.tableK4EE_Component_Reel_Result.ETIMEColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("\'K4EE_Component_Reel_Result\' 테이블의 \'ETIME\' 열의 값이 DBNull입니다.", e);
}
}
set {
this[this.tableK4EE_Component_Reel_Result.ETIMEColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public string PDATE {
get {
if (this.IsPDATENull()) {
return string.Empty;
}
else {
return ((string)(this[this.tableK4EE_Component_Reel_Result.PDATEColumn]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.PDATEColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public string JTYPE {
get {
if (this.IsJTYPENull()) {
return string.Empty;
}
else {
return ((string)(this[this.tableK4EE_Component_Reel_Result.JTYPEColumn]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.JTYPEColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public string JGUID {
get {
if (this.IsJGUIDNull()) {
return string.Empty;
}
else {
return ((string)(this[this.tableK4EE_Component_Reel_Result.JGUIDColumn]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.JGUIDColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public string SID {
get {
if (this.IsSIDNull()) {
return string.Empty;
}
else {
return ((string)(this[this.tableK4EE_Component_Reel_Result.SIDColumn]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.SIDColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public string SID0 {
get {
if (this.IsSID0Null()) {
return string.Empty;
}
else {
return ((string)(this[this.tableK4EE_Component_Reel_Result.SID0Column]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.SID0Column] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public string RID {
get {
if (this.IsRIDNull()) {
return string.Empty;
}
else {
return ((string)(this[this.tableK4EE_Component_Reel_Result.RIDColumn]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.RIDColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public string RID0 {
get {
if (this.IsRID0Null()) {
return string.Empty;
}
else {
return ((string)(this[this.tableK4EE_Component_Reel_Result.RID0Column]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.RID0Column] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public string RSN {
get {
if (this.IsRSNNull()) {
return string.Empty;
}
else {
return ((string)(this[this.tableK4EE_Component_Reel_Result.RSNColumn]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.RSNColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public string QR {
get {
if (this.IsQRNull()) {
return string.Empty;
}
else {
return ((string)(this[this.tableK4EE_Component_Reel_Result.QRColumn]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.QRColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public string ZPL {
get {
if (this.IsZPLNull()) {
return string.Empty;
}
else {
return ((string)(this[this.tableK4EE_Component_Reel_Result.ZPLColumn]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.ZPLColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public string POS {
get {
if (this.IsPOSNull()) {
return string.Empty;
}
else {
return ((string)(this[this.tableK4EE_Component_Reel_Result.POSColumn]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.POSColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public string LOC {
get {
if (this.IsLOCNull()) {
return string.Empty;
}
else {
return ((string)(this[this.tableK4EE_Component_Reel_Result.LOCColumn]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.LOCColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public double ANGLE {
get {
if (this.IsANGLENull()) {
return -1D;
}
else {
return ((double)(this[this.tableK4EE_Component_Reel_Result.ANGLEColumn]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.ANGLEColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public int QTY {
get {
if (this.IsQTYNull()) {
return -1;
}
else {
return ((int)(this[this.tableK4EE_Component_Reel_Result.QTYColumn]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.QTYColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public int QTY0 {
get {
if (this.IsQTY0Null()) {
return -1;
}
else {
return ((int)(this[this.tableK4EE_Component_Reel_Result.QTY0Column]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.QTY0Column] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public string VNAME {
get {
if (this.IsVNAMENull()) {
return string.Empty;
}
else {
return ((string)(this[this.tableK4EE_Component_Reel_Result.VNAMEColumn]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.VNAMEColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool PRNATTACH {
get {
if (this.IsPRNATTACHNull()) {
return false;
}
else {
return ((bool)(this[this.tableK4EE_Component_Reel_Result.PRNATTACHColumn]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.PRNATTACHColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool PRNVALID {
get {
if (this.IsPRNVALIDNull()) {
return false;
}
else {
return ((bool)(this[this.tableK4EE_Component_Reel_Result.PRNVALIDColumn]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.PRNVALIDColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public System.DateTime wdate {
get {
return ((global::System.DateTime)(this[this.tableK4EE_Component_Reel_Result.wdateColumn]));
}
set {
this[this.tableK4EE_Component_Reel_Result.wdateColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public string VLOT {
get {
if (this.IsVLOTNull()) {
return string.Empty;
}
else {
return ((string)(this[this.tableK4EE_Component_Reel_Result.VLOTColumn]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.VLOTColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public string BATCH {
get {
if (this.IsBATCHNull()) {
return string.Empty;
}
else {
return ((string)(this[this.tableK4EE_Component_Reel_Result.BATCHColumn]));
}
}
set {
this[this.tableK4EE_Component_Reel_Result.BATCHColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public int qtymax {
get {
try {
return ((int)(this[this.tableK4EE_Component_Reel_Result.qtymaxColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("\'K4EE_Component_Reel_Result\' 테이블의 \'qtymax\' 열의 값이 DBNull입니다.", e);
}
}
set {
this[this.tableK4EE_Component_Reel_Result.qtymaxColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsETIMENull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.ETIMEColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetETIMENull() {
this[this.tableK4EE_Component_Reel_Result.ETIMEColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsPDATENull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.PDATEColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetPDATENull() {
this[this.tableK4EE_Component_Reel_Result.PDATEColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsJTYPENull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.JTYPEColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetJTYPENull() {
this[this.tableK4EE_Component_Reel_Result.JTYPEColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsJGUIDNull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.JGUIDColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetJGUIDNull() {
this[this.tableK4EE_Component_Reel_Result.JGUIDColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsSIDNull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.SIDColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetSIDNull() {
this[this.tableK4EE_Component_Reel_Result.SIDColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsSID0Null() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.SID0Column);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetSID0Null() {
this[this.tableK4EE_Component_Reel_Result.SID0Column] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsRIDNull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.RIDColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetRIDNull() {
this[this.tableK4EE_Component_Reel_Result.RIDColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsRID0Null() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.RID0Column);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetRID0Null() {
this[this.tableK4EE_Component_Reel_Result.RID0Column] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsRSNNull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.RSNColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetRSNNull() {
this[this.tableK4EE_Component_Reel_Result.RSNColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsQRNull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.QRColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetQRNull() {
this[this.tableK4EE_Component_Reel_Result.QRColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsZPLNull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.ZPLColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetZPLNull() {
this[this.tableK4EE_Component_Reel_Result.ZPLColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsPOSNull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.POSColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetPOSNull() {
this[this.tableK4EE_Component_Reel_Result.POSColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsLOCNull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.LOCColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetLOCNull() {
this[this.tableK4EE_Component_Reel_Result.LOCColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsANGLENull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.ANGLEColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetANGLENull() {
this[this.tableK4EE_Component_Reel_Result.ANGLEColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsQTYNull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.QTYColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetQTYNull() {
this[this.tableK4EE_Component_Reel_Result.QTYColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsQTY0Null() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.QTY0Column);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetQTY0Null() {
this[this.tableK4EE_Component_Reel_Result.QTY0Column] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsVNAMENull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.VNAMEColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetVNAMENull() {
this[this.tableK4EE_Component_Reel_Result.VNAMEColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsPRNATTACHNull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.PRNATTACHColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetPRNATTACHNull() {
this[this.tableK4EE_Component_Reel_Result.PRNATTACHColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsPRNVALIDNull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.PRNVALIDColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetPRNVALIDNull() {
this[this.tableK4EE_Component_Reel_Result.PRNVALIDColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsVLOTNull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.VLOTColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetVLOTNull() {
this[this.tableK4EE_Component_Reel_Result.VLOTColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsBATCHNull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.BATCHColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetBATCHNull() {
this[this.tableK4EE_Component_Reel_Result.BATCHColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool IsqtymaxNull() {
return this.IsNull(this.tableK4EE_Component_Reel_Result.qtymaxColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public void SetqtymaxNull() {
this[this.tableK4EE_Component_Reel_Result.qtymaxColumn] = global::System.Convert.DBNull;
}
}
///
///Row event argument class
///
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public class K4EE_Component_Reel_ResultRowChangeEvent : global::System.EventArgs {
private K4EE_Component_Reel_ResultRow eventRow;
private global::System.Data.DataRowAction eventAction;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public K4EE_Component_Reel_ResultRowChangeEvent(K4EE_Component_Reel_ResultRow row, global::System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public K4EE_Component_Reel_ResultRow Row {
get {
return this.eventRow;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public global::System.Data.DataRowAction Action {
get {
return this.eventAction;
}
}
}
}
}
namespace ResultView.DataSet1TableAdapters {
///
///Represents the connection and commands used to retrieve and save data.
///
[global::System.ComponentModel.DesignerCategoryAttribute("code")]
[global::System.ComponentModel.ToolboxItem(true)]
[global::System.ComponentModel.DataObjectAttribute(true)]
[global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" +
", Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
public partial class K4EE_Component_Reel_ResultTableAdapter : global::System.ComponentModel.Component {
private global::System.Data.SqlClient.SqlDataAdapter _adapter;
private global::System.Data.SqlClient.SqlConnection _connection;
private global::System.Data.SqlClient.SqlTransaction _transaction;
private global::System.Data.SqlClient.SqlCommand[] _commandCollection;
private bool _clearBeforeFill;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public K4EE_Component_Reel_ResultTableAdapter() {
this.ClearBeforeFill = true;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
protected internal global::System.Data.SqlClient.SqlDataAdapter Adapter {
get {
if ((this._adapter == null)) {
this.InitAdapter();
}
return this._adapter;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
internal global::System.Data.SqlClient.SqlConnection Connection {
get {
if ((this._connection == null)) {
this.InitConnection();
}
return this._connection;
}
set {
this._connection = value;
if ((this.Adapter.InsertCommand != null)) {
this.Adapter.InsertCommand.Connection = value;
}
if ((this.Adapter.DeleteCommand != null)) {
this.Adapter.DeleteCommand.Connection = value;
}
if ((this.Adapter.UpdateCommand != null)) {
this.Adapter.UpdateCommand.Connection = value;
}
for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
if ((this.CommandCollection[i] != null)) {
((global::System.Data.SqlClient.SqlCommand)(this.CommandCollection[i])).Connection = value;
}
}
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
internal global::System.Data.SqlClient.SqlTransaction Transaction {
get {
return this._transaction;
}
set {
this._transaction = value;
for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) {
this.CommandCollection[i].Transaction = this._transaction;
}
if (((this.Adapter != null)
&& (this.Adapter.DeleteCommand != null))) {
this.Adapter.DeleteCommand.Transaction = this._transaction;
}
if (((this.Adapter != null)
&& (this.Adapter.InsertCommand != null))) {
this.Adapter.InsertCommand.Transaction = this._transaction;
}
if (((this.Adapter != null)
&& (this.Adapter.UpdateCommand != null))) {
this.Adapter.UpdateCommand.Transaction = this._transaction;
}
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
protected global::System.Data.SqlClient.SqlCommand[] CommandCollection {
get {
if ((this._commandCollection == null)) {
this.InitCommandCollection();
}
return this._commandCollection;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool ClearBeforeFill {
get {
return this._clearBeforeFill;
}
set {
this._clearBeforeFill = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
private void InitAdapter() {
this._adapter = new global::System.Data.SqlClient.SqlDataAdapter();
global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping();
tableMapping.SourceTable = "Table";
tableMapping.DataSetTable = "K4EE_Component_Reel_Result";
tableMapping.ColumnMappings.Add("idx", "idx");
tableMapping.ColumnMappings.Add("STIME", "STIME");
tableMapping.ColumnMappings.Add("ETIME", "ETIME");
tableMapping.ColumnMappings.Add("PDATE", "PDATE");
tableMapping.ColumnMappings.Add("JTYPE", "JTYPE");
tableMapping.ColumnMappings.Add("JGUID", "JGUID");
tableMapping.ColumnMappings.Add("SID", "SID");
tableMapping.ColumnMappings.Add("SID0", "SID0");
tableMapping.ColumnMappings.Add("RID", "RID");
tableMapping.ColumnMappings.Add("RID0", "RID0");
tableMapping.ColumnMappings.Add("RSN", "RSN");
tableMapping.ColumnMappings.Add("QR", "QR");
tableMapping.ColumnMappings.Add("ZPL", "ZPL");
tableMapping.ColumnMappings.Add("POS", "POS");
tableMapping.ColumnMappings.Add("LOC", "LOC");
tableMapping.ColumnMappings.Add("ANGLE", "ANGLE");
tableMapping.ColumnMappings.Add("QTY", "QTY");
tableMapping.ColumnMappings.Add("QTY0", "QTY0");
tableMapping.ColumnMappings.Add("VNAME", "VNAME");
tableMapping.ColumnMappings.Add("PRNATTACH", "PRNATTACH");
tableMapping.ColumnMappings.Add("PRNVALID", "PRNVALID");
tableMapping.ColumnMappings.Add("wdate", "wdate");
tableMapping.ColumnMappings.Add("VLOT", "VLOT");
tableMapping.ColumnMappings.Add("BATCH", "BATCH");
tableMapping.ColumnMappings.Add("-1", "qtymax");
tableMapping.ColumnMappings.Add("qtymax", "qtymax");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::System.Data.SqlClient.SqlCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = "DELETE FROM [K4EE_Component_Reel_Result] WHERE (([idx] = @Original_idx) AND ([STI" +
"ME] = @Original_STIME) AND ((@IsNull_ETIME = 1 AND [ETIME] IS NULL) OR ([ETIME] " +
"= @Original_ETIME)) AND ((@IsNull_PDATE = 1 AND [PDATE] IS NULL) OR ([PDATE] = @" +
"Original_PDATE)) AND ((@IsNull_JTYPE = 1 AND [JTYPE] IS NULL) OR ([JTYPE] = @Ori" +
"ginal_JTYPE)) AND ((@IsNull_JGUID = 1 AND [JGUID] IS NULL) OR ([JGUID] = @Origin" +
"al_JGUID)) AND ((@IsNull_SID = 1 AND [SID] IS NULL) OR ([SID] = @Original_SID)) " +
"AND ((@IsNull_SID0 = 1 AND [SID0] IS NULL) OR ([SID0] = @Original_SID0)) AND ((@" +
"IsNull_RID = 1 AND [RID] IS NULL) OR ([RID] = @Original_RID)) AND ((@IsNull_RID0" +
" = 1 AND [RID0] IS NULL) OR ([RID0] = @Original_RID0)) AND ((@IsNull_RSN = 1 AND" +
" [RSN] IS NULL) OR ([RSN] = @Original_RSN)) AND ((@IsNull_QR = 1 AND [QR] IS NUL" +
"L) OR ([QR] = @Original_QR)) AND ((@IsNull_ZPL = 1 AND [ZPL] IS NULL) OR ([ZPL] " +
"= @Original_ZPL)) AND ((@IsNull_POS = 1 AND [POS] IS NULL) OR ([POS] = @Original" +
"_POS)) AND ((@IsNull_LOC = 1 AND [LOC] IS NULL) OR ([LOC] = @Original_LOC)) AND " +
"((@IsNull_ANGLE = 1 AND [ANGLE] IS NULL) OR ([ANGLE] = @Original_ANGLE)) AND ((@" +
"IsNull_QTY = 1 AND [QTY] IS NULL) OR ([QTY] = @Original_QTY)) AND ((@IsNull_QTY0" +
" = 1 AND [QTY0] IS NULL) OR ([QTY0] = @Original_QTY0)) AND ((@IsNull_VNAME = 1 A" +
"ND [VNAME] IS NULL) OR ([VNAME] = @Original_VNAME)) AND ((@IsNull_PRNATTACH = 1 " +
"AND [PRNATTACH] IS NULL) OR ([PRNATTACH] = @Original_PRNATTACH)) AND ((@IsNull_P" +
"RNVALID = 1 AND [PRNVALID] IS NULL) OR ([PRNVALID] = @Original_PRNVALID)) AND ([" +
"wdate] = @Original_wdate) AND ((@IsNull_VLOT = 1 AND [VLOT] IS NULL) OR ([VLOT] " +
"= @Original_VLOT)) AND ((@IsNull_BATCH = 1 AND [BATCH] IS NULL) OR ([BATCH] = @O" +
"riginal_BATCH)) AND ((@IsNull_qtymax = 1 AND [qtymax] IS NULL) OR ([qtymax] = @O" +
"riginal_qtymax)))";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_idx", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "idx", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_STIME", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "STIME", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_ETIME", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ETIME", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_ETIME", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ETIME", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_PDATE", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PDATE", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_PDATE", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PDATE", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_JTYPE", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JTYPE", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JTYPE", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JTYPE", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_JGUID", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JGUID", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JGUID", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JGUID", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_SID", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "SID", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_SID", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "SID", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_SID0", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "SID0", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_SID0", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "SID0", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_RID", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "RID", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_RID", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "RID", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_RID0", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "RID0", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_RID0", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "RID0", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_RSN", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "RSN", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_RSN", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "RSN", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_QR", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "QR", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_QR", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "QR", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_ZPL", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ZPL", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_ZPL", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ZPL", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_POS", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "POS", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_POS", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "POS", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_LOC", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "LOC", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_LOC", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "LOC", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_ANGLE", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ANGLE", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_ANGLE", global::System.Data.SqlDbType.Float, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ANGLE", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_QTY", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "QTY", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_QTY", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "QTY", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_QTY0", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "QTY0", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_QTY0", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "QTY0", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_VNAME", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "VNAME", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_VNAME", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "VNAME", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_PRNATTACH", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PRNATTACH", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_PRNATTACH", global::System.Data.SqlDbType.Bit, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PRNATTACH", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_PRNVALID", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PRNVALID", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_PRNVALID", global::System.Data.SqlDbType.Bit, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PRNVALID", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_wdate", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "wdate", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_VLOT", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "VLOT", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_VLOT", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "VLOT", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_BATCH", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "BATCH", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_BATCH", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "BATCH", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_qtymax", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "qtymax", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_qtymax", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "qtymax", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.InsertCommand = new global::System.Data.SqlClient.SqlCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = @"INSERT INTO [K4EE_Component_Reel_Result] ([STIME], [ETIME], [PDATE], [JTYPE], [JGUID], [SID], [SID0], [RID], [RID0], [RSN], [QR], [ZPL], [POS], [LOC], [ANGLE], [QTY], [QTY0], [VNAME], [PRNATTACH], [PRNVALID], [wdate], [VLOT], [BATCH], [qtymax]) VALUES (@STIME, @ETIME, @PDATE, @JTYPE, @JGUID, @SID, @SID0, @RID, @RID0, @RSN, @QR, @ZPL, @POS, @LOC, @ANGLE, @QTY, @QTY0, @VNAME, @PRNATTACH, @PRNVALID, @wdate, @VLOT, @BATCH, @qtymax);
SELECT idx, STIME, ETIME, PDATE, JTYPE, JGUID, SID, SID0, RID, RID0, RSN, QR, ZPL, POS, LOC, ANGLE, QTY, QTY0, VNAME, PRNATTACH, PRNVALID, wdate, VLOT, BATCH, qtymax FROM Component_Reel_Result WHERE (idx = SCOPE_IDENTITY()) ORDER BY wdate DESC";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@STIME", global::System.Data.SqlDbType.DateTime, 8, global::System.Data.ParameterDirection.Input, 0, 0, "STIME", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ETIME", global::System.Data.SqlDbType.DateTime, 8, global::System.Data.ParameterDirection.Input, 0, 0, "ETIME", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PDATE", global::System.Data.SqlDbType.VarChar, 10, global::System.Data.ParameterDirection.Input, 0, 0, "PDATE", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JTYPE", global::System.Data.SqlDbType.VarChar, 10, global::System.Data.ParameterDirection.Input, 0, 0, "JTYPE", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JGUID", global::System.Data.SqlDbType.VarChar, 50, global::System.Data.ParameterDirection.Input, 0, 0, "JGUID", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@SID", global::System.Data.SqlDbType.VarChar, 20, global::System.Data.ParameterDirection.Input, 0, 0, "SID", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@SID0", global::System.Data.SqlDbType.VarChar, 20, global::System.Data.ParameterDirection.Input, 0, 0, "SID0", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@RID", global::System.Data.SqlDbType.VarChar, 50, global::System.Data.ParameterDirection.Input, 0, 0, "RID", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@RID0", global::System.Data.SqlDbType.VarChar, 50, global::System.Data.ParameterDirection.Input, 0, 0, "RID0", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@RSN", global::System.Data.SqlDbType.VarChar, 10, global::System.Data.ParameterDirection.Input, 0, 0, "RSN", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@QR", global::System.Data.SqlDbType.VarChar, 100, global::System.Data.ParameterDirection.Input, 0, 0, "QR", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ZPL", global::System.Data.SqlDbType.VarChar, 1000, global::System.Data.ParameterDirection.Input, 0, 0, "ZPL", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@POS", global::System.Data.SqlDbType.VarChar, 10, global::System.Data.ParameterDirection.Input, 0, 0, "POS", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@LOC", global::System.Data.SqlDbType.VarChar, 1, global::System.Data.ParameterDirection.Input, 0, 0, "LOC", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ANGLE", global::System.Data.SqlDbType.Float, 8, global::System.Data.ParameterDirection.Input, 0, 0, "ANGLE", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@QTY", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 0, 0, "QTY", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@QTY0", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 0, 0, "QTY0", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@VNAME", global::System.Data.SqlDbType.VarChar, 100, global::System.Data.ParameterDirection.Input, 0, 0, "VNAME", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PRNATTACH", global::System.Data.SqlDbType.Bit, 1, global::System.Data.ParameterDirection.Input, 0, 0, "PRNATTACH", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PRNVALID", global::System.Data.SqlDbType.Bit, 1, global::System.Data.ParameterDirection.Input, 0, 0, "PRNVALID", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@wdate", global::System.Data.SqlDbType.DateTime, 8, global::System.Data.ParameterDirection.Input, 0, 0, "wdate", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@VLOT", global::System.Data.SqlDbType.VarChar, 100, global::System.Data.ParameterDirection.Input, 0, 0, "VLOT", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@BATCH", global::System.Data.SqlDbType.VarChar, 100, global::System.Data.ParameterDirection.Input, 0, 0, "BATCH", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@qtymax", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 0, 0, "qtymax", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand = new global::System.Data.SqlClient.SqlCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = "UPDATE [K4EE_Component_Reel_Result] SET [STIME] = @STIME, [ETIME] = @ETIME, [PDAT" +
"E] = @PDATE, [JTYPE] = @JTYPE, [JGUID] = @JGUID, [SID] = @SID, [SID0] = @SID0, [" +
"RID] = @RID, [RID0] = @RID0, [RSN] = @RSN, [QR] = @QR, [ZPL] = @ZPL, [POS] = @PO" +
"S, [LOC] = @LOC, [ANGLE] = @ANGLE, [QTY] = @QTY, [QTY0] = @QTY0, [VNAME] = @VNAM" +
"E, [PRNATTACH] = @PRNATTACH, [PRNVALID] = @PRNVALID, [wdate] = @wdate, [VLOT] = " +
"@VLOT, [BATCH] = @BATCH, [qtymax] = @qtymax WHERE (([idx] = @Original_idx) AND (" +
"[STIME] = @Original_STIME) AND ((@IsNull_ETIME = 1 AND [ETIME] IS NULL) OR ([ETI" +
"ME] = @Original_ETIME)) AND ((@IsNull_PDATE = 1 AND [PDATE] IS NULL) OR ([PDATE]" +
" = @Original_PDATE)) AND ((@IsNull_JTYPE = 1 AND [JTYPE] IS NULL) OR ([JTYPE] = " +
"@Original_JTYPE)) AND ((@IsNull_JGUID = 1 AND [JGUID] IS NULL) OR ([JGUID] = @Or" +
"iginal_JGUID)) AND ((@IsNull_SID = 1 AND [SID] IS NULL) OR ([SID] = @Original_SI" +
"D)) AND ((@IsNull_SID0 = 1 AND [SID0] IS NULL) OR ([SID0] = @Original_SID0)) AND" +
" ((@IsNull_RID = 1 AND [RID] IS NULL) OR ([RID] = @Original_RID)) AND ((@IsNull_" +
"RID0 = 1 AND [RID0] IS NULL) OR ([RID0] = @Original_RID0)) AND ((@IsNull_RSN = 1" +
" AND [RSN] IS NULL) OR ([RSN] = @Original_RSN)) AND ((@IsNull_QR = 1 AND [QR] IS" +
" NULL) OR ([QR] = @Original_QR)) AND ((@IsNull_ZPL = 1 AND [ZPL] IS NULL) OR ([Z" +
"PL] = @Original_ZPL)) AND ((@IsNull_POS = 1 AND [POS] IS NULL) OR ([POS] = @Orig" +
"inal_POS)) AND ((@IsNull_LOC = 1 AND [LOC] IS NULL) OR ([LOC] = @Original_LOC)) " +
"AND ((@IsNull_ANGLE = 1 AND [ANGLE] IS NULL) OR ([ANGLE] = @Original_ANGLE)) AND" +
" ((@IsNull_QTY = 1 AND [QTY] IS NULL) OR ([QTY] = @Original_QTY)) AND ((@IsNull_" +
"QTY0 = 1 AND [QTY0] IS NULL) OR ([QTY0] = @Original_QTY0)) AND ((@IsNull_VNAME =" +
" 1 AND [VNAME] IS NULL) OR ([VNAME] = @Original_VNAME)) AND ((@IsNull_PRNATTACH " +
"= 1 AND [PRNATTACH] IS NULL) OR ([PRNATTACH] = @Original_PRNATTACH)) AND ((@IsNu" +
"ll_PRNVALID = 1 AND [PRNVALID] IS NULL) OR ([PRNVALID] = @Original_PRNVALID)) AN" +
"D ([wdate] = @Original_wdate) AND ((@IsNull_VLOT = 1 AND [VLOT] IS NULL) OR ([VL" +
"OT] = @Original_VLOT)) AND ((@IsNull_BATCH = 1 AND [BATCH] IS NULL) OR ([BATCH] " +
"= @Original_BATCH)) AND ((@IsNull_qtymax = 1 AND [qtymax] IS NULL) OR ([qtymax] " +
"= @Original_qtymax)));\r\nSELECT idx, STIME, ETIME, PDATE, JTYPE, JGUID, SID, SID0" +
", RID, RID0, RSN, QR, ZPL, POS, LOC, ANGLE, QTY, QTY0, VNAME, PRNATTACH, PRNVALI" +
"D, wdate, VLOT, BATCH, qtymax FROM K4EE_Component_Reel_Result WITH (nolock) WHER" +
"E (idx = @idx) ORDER BY wdate DESC";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@STIME", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "STIME", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ETIME", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ETIME", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PDATE", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PDATE", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JTYPE", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JTYPE", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@JGUID", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JGUID", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@SID", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "SID", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@SID0", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "SID0", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@RID", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "RID", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@RID0", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "RID0", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@RSN", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "RSN", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@QR", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "QR", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ZPL", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ZPL", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@POS", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "POS", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@LOC", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "LOC", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ANGLE", global::System.Data.SqlDbType.Float, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ANGLE", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@QTY", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "QTY", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@QTY0", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "QTY0", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@VNAME", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "VNAME", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PRNATTACH", global::System.Data.SqlDbType.Bit, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PRNATTACH", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@PRNVALID", global::System.Data.SqlDbType.Bit, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PRNVALID", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@wdate", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "wdate", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@VLOT", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "VLOT", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@BATCH", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "BATCH", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@qtymax", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "qtymax", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_idx", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "idx", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_STIME", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "STIME", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_ETIME", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ETIME", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_ETIME", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ETIME", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_PDATE", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PDATE", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_PDATE", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PDATE", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_JTYPE", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JTYPE", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JTYPE", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JTYPE", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_JGUID", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JGUID", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_JGUID", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "JGUID", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_SID", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "SID", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_SID", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "SID", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_SID0", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "SID0", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_SID0", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "SID0", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_RID", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "RID", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_RID", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "RID", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_RID0", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "RID0", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_RID0", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "RID0", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_RSN", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "RSN", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_RSN", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "RSN", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_QR", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "QR", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_QR", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "QR", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_ZPL", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ZPL", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_ZPL", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ZPL", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_POS", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "POS", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_POS", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "POS", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_LOC", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "LOC", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_LOC", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "LOC", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_ANGLE", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ANGLE", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_ANGLE", global::System.Data.SqlDbType.Float, 0, global::System.Data.ParameterDirection.Input, 0, 0, "ANGLE", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_QTY", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "QTY", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_QTY", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "QTY", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_QTY0", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "QTY0", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_QTY0", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "QTY0", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_VNAME", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "VNAME", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_VNAME", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "VNAME", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_PRNATTACH", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PRNATTACH", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_PRNATTACH", global::System.Data.SqlDbType.Bit, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PRNATTACH", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_PRNVALID", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PRNVALID", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_PRNVALID", global::System.Data.SqlDbType.Bit, 0, global::System.Data.ParameterDirection.Input, 0, 0, "PRNVALID", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_wdate", global::System.Data.SqlDbType.DateTime, 0, global::System.Data.ParameterDirection.Input, 0, 0, "wdate", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_VLOT", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "VLOT", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_VLOT", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "VLOT", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_BATCH", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "BATCH", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_BATCH", global::System.Data.SqlDbType.VarChar, 0, global::System.Data.ParameterDirection.Input, 0, 0, "BATCH", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@IsNull_qtymax", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "qtymax", global::System.Data.DataRowVersion.Original, true, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@Original_qtymax", global::System.Data.SqlDbType.Int, 0, global::System.Data.ParameterDirection.Input, 0, 0, "qtymax", global::System.Data.DataRowVersion.Original, false, null, "", "", ""));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@idx", global::System.Data.SqlDbType.Int, 4, global::System.Data.ParameterDirection.Input, 0, 0, "idx", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
private void InitConnection() {
this._connection = new global::System.Data.SqlClient.SqlConnection();
this._connection.ConnectionString = global::ResultView.Properties.Settings.Default.cs;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
private void InitCommandCollection() {
this._commandCollection = new global::System.Data.SqlClient.SqlCommand[1];
this._commandCollection[0] = new global::System.Data.SqlClient.SqlCommand();
this._commandCollection[0].Connection = this.Connection;
this._commandCollection[0].CommandText = @"SELECT idx, STIME, ETIME, PDATE, JTYPE, JGUID, SID, SID0, RID, RID0, RSN, QR, ZPL, POS, LOC, ANGLE, QTY, QTY0, VNAME, PRNATTACH, PRNVALID, wdate, VLOT, BATCH, qtymax
FROM K4EE_Component_Reel_Result WITH (nolock)
WHERE (MC = @mc) AND (CONVERT(varchar(10), wdate, 120) BETWEEN @sd AND @ed) AND (ISNULL(QR, '') LIKE @search)
ORDER BY wdate DESC";
this._commandCollection[0].CommandType = global::System.Data.CommandType.Text;
this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@mc", global::System.Data.SqlDbType.VarChar, 10, global::System.Data.ParameterDirection.Input, 0, 0, "MC", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@sd", global::System.Data.SqlDbType.VarChar, 1024, global::System.Data.ParameterDirection.Input, 0, 0, "", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@ed", global::System.Data.SqlDbType.VarChar, 1024, global::System.Data.ParameterDirection.Input, 0, 0, "", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
this._commandCollection[0].Parameters.Add(new global::System.Data.SqlClient.SqlParameter("@search", global::System.Data.SqlDbType.VarChar, 1024, global::System.Data.ParameterDirection.Input, 0, 0, "", global::System.Data.DataRowVersion.Current, false, null, "", "", ""));
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]
public virtual int Fill(DataSet1.K4EE_Component_Reel_ResultDataTable dataTable, string mc, string sd, string ed, string search) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((mc == null)) {
throw new global::System.ArgumentNullException("mc");
}
else {
this.Adapter.SelectCommand.Parameters[0].Value = ((string)(mc));
}
if ((sd == null)) {
throw new global::System.ArgumentNullException("sd");
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = ((string)(sd));
}
if ((ed == null)) {
throw new global::System.ArgumentNullException("ed");
}
else {
this.Adapter.SelectCommand.Parameters[2].Value = ((string)(ed));
}
if ((search == null)) {
throw new global::System.ArgumentNullException("search");
}
else {
this.Adapter.SelectCommand.Parameters[3].Value = ((string)(search));
}
if ((this.ClearBeforeFill == true)) {
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)]
public virtual DataSet1.K4EE_Component_Reel_ResultDataTable GetData(string mc, string sd, string ed, string search) {
this.Adapter.SelectCommand = this.CommandCollection[0];
if ((mc == null)) {
throw new global::System.ArgumentNullException("mc");
}
else {
this.Adapter.SelectCommand.Parameters[0].Value = ((string)(mc));
}
if ((sd == null)) {
throw new global::System.ArgumentNullException("sd");
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = ((string)(sd));
}
if ((ed == null)) {
throw new global::System.ArgumentNullException("ed");
}
else {
this.Adapter.SelectCommand.Parameters[2].Value = ((string)(ed));
}
if ((search == null)) {
throw new global::System.ArgumentNullException("search");
}
else {
this.Adapter.SelectCommand.Parameters[3].Value = ((string)(search));
}
DataSet1.K4EE_Component_Reel_ResultDataTable dataTable = new DataSet1.K4EE_Component_Reel_ResultDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
public virtual int Update(DataSet1.K4EE_Component_Reel_ResultDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
public virtual int Update(DataSet1 dataSet) {
return this.Adapter.Update(dataSet, "K4EE_Component_Reel_Result");
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
public virtual int Update(global::System.Data.DataRow dataRow) {
return this.Adapter.Update(new global::System.Data.DataRow[] {
dataRow});
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
public virtual int Update(global::System.Data.DataRow[] dataRows) {
return this.Adapter.Update(dataRows);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)]
public virtual int Delete(
int Original_idx,
System.DateTime Original_STIME,
global::System.Nullable Original_ETIME,
string Original_PDATE,
string Original_JTYPE,
string Original_JGUID,
string Original_SID,
string Original_SID0,
string Original_RID,
string Original_RID0,
string Original_RSN,
string Original_QR,
string Original_ZPL,
string Original_POS,
string Original_LOC,
global::System.Nullable Original_ANGLE,
global::System.Nullable Original_QTY,
global::System.Nullable Original_QTY0,
string Original_VNAME,
global::System.Nullable Original_PRNATTACH,
global::System.Nullable Original_PRNVALID,
System.DateTime Original_wdate,
string Original_VLOT,
string Original_BATCH,
global::System.Nullable Original_qtymax) {
this.Adapter.DeleteCommand.Parameters[0].Value = ((int)(Original_idx));
this.Adapter.DeleteCommand.Parameters[1].Value = ((System.DateTime)(Original_STIME));
if ((Original_ETIME.HasValue == true)) {
this.Adapter.DeleteCommand.Parameters[2].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[3].Value = ((System.DateTime)(Original_ETIME.Value));
}
else {
this.Adapter.DeleteCommand.Parameters[2].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[3].Value = global::System.DBNull.Value;
}
if ((Original_PDATE == null)) {
this.Adapter.DeleteCommand.Parameters[4].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[5].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[4].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[5].Value = ((string)(Original_PDATE));
}
if ((Original_JTYPE == null)) {
this.Adapter.DeleteCommand.Parameters[6].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[7].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[6].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[7].Value = ((string)(Original_JTYPE));
}
if ((Original_JGUID == null)) {
this.Adapter.DeleteCommand.Parameters[8].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[9].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[8].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[9].Value = ((string)(Original_JGUID));
}
if ((Original_SID == null)) {
this.Adapter.DeleteCommand.Parameters[10].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[11].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[10].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[11].Value = ((string)(Original_SID));
}
if ((Original_SID0 == null)) {
this.Adapter.DeleteCommand.Parameters[12].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[13].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[12].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[13].Value = ((string)(Original_SID0));
}
if ((Original_RID == null)) {
this.Adapter.DeleteCommand.Parameters[14].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[15].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[14].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[15].Value = ((string)(Original_RID));
}
if ((Original_RID0 == null)) {
this.Adapter.DeleteCommand.Parameters[16].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[17].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[16].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[17].Value = ((string)(Original_RID0));
}
if ((Original_RSN == null)) {
this.Adapter.DeleteCommand.Parameters[18].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[19].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[18].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[19].Value = ((string)(Original_RSN));
}
if ((Original_QR == null)) {
this.Adapter.DeleteCommand.Parameters[20].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[21].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[20].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[21].Value = ((string)(Original_QR));
}
if ((Original_ZPL == null)) {
this.Adapter.DeleteCommand.Parameters[22].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[23].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[22].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[23].Value = ((string)(Original_ZPL));
}
if ((Original_POS == null)) {
this.Adapter.DeleteCommand.Parameters[24].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[25].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[24].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[25].Value = ((string)(Original_POS));
}
if ((Original_LOC == null)) {
this.Adapter.DeleteCommand.Parameters[26].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[27].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[26].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[27].Value = ((string)(Original_LOC));
}
if ((Original_ANGLE.HasValue == true)) {
this.Adapter.DeleteCommand.Parameters[28].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[29].Value = ((double)(Original_ANGLE.Value));
}
else {
this.Adapter.DeleteCommand.Parameters[28].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[29].Value = global::System.DBNull.Value;
}
if ((Original_QTY.HasValue == true)) {
this.Adapter.DeleteCommand.Parameters[30].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[31].Value = ((int)(Original_QTY.Value));
}
else {
this.Adapter.DeleteCommand.Parameters[30].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[31].Value = global::System.DBNull.Value;
}
if ((Original_QTY0.HasValue == true)) {
this.Adapter.DeleteCommand.Parameters[32].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[33].Value = ((int)(Original_QTY0.Value));
}
else {
this.Adapter.DeleteCommand.Parameters[32].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[33].Value = global::System.DBNull.Value;
}
if ((Original_VNAME == null)) {
this.Adapter.DeleteCommand.Parameters[34].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[35].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[34].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[35].Value = ((string)(Original_VNAME));
}
if ((Original_PRNATTACH.HasValue == true)) {
this.Adapter.DeleteCommand.Parameters[36].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[37].Value = ((bool)(Original_PRNATTACH.Value));
}
else {
this.Adapter.DeleteCommand.Parameters[36].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[37].Value = global::System.DBNull.Value;
}
if ((Original_PRNVALID.HasValue == true)) {
this.Adapter.DeleteCommand.Parameters[38].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[39].Value = ((bool)(Original_PRNVALID.Value));
}
else {
this.Adapter.DeleteCommand.Parameters[38].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[39].Value = global::System.DBNull.Value;
}
this.Adapter.DeleteCommand.Parameters[40].Value = ((System.DateTime)(Original_wdate));
if ((Original_VLOT == null)) {
this.Adapter.DeleteCommand.Parameters[41].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[42].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[41].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[42].Value = ((string)(Original_VLOT));
}
if ((Original_BATCH == null)) {
this.Adapter.DeleteCommand.Parameters[43].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[44].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[43].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[44].Value = ((string)(Original_BATCH));
}
if ((Original_qtymax.HasValue == true)) {
this.Adapter.DeleteCommand.Parameters[45].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[46].Value = ((int)(Original_qtymax.Value));
}
else {
this.Adapter.DeleteCommand.Parameters[45].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[46].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open)) {
this.Adapter.DeleteCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)]
public virtual int Insert(
System.DateTime STIME,
global::System.Nullable ETIME,
string PDATE,
string JTYPE,
string JGUID,
string SID,
string SID0,
string RID,
string RID0,
string RSN,
string QR,
string ZPL,
string POS,
string LOC,
global::System.Nullable ANGLE,
global::System.Nullable QTY,
global::System.Nullable QTY0,
string VNAME,
global::System.Nullable PRNATTACH,
global::System.Nullable PRNVALID,
System.DateTime wdate,
string VLOT,
string BATCH,
global::System.Nullable qtymax) {
this.Adapter.InsertCommand.Parameters[0].Value = ((System.DateTime)(STIME));
if ((ETIME.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[1].Value = ((System.DateTime)(ETIME.Value));
}
else {
this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((PDATE == null)) {
this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[2].Value = ((string)(PDATE));
}
if ((JTYPE == null)) {
this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[3].Value = ((string)(JTYPE));
}
if ((JGUID == null)) {
this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[4].Value = ((string)(JGUID));
}
if ((SID == null)) {
this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[5].Value = ((string)(SID));
}
if ((SID0 == null)) {
this.Adapter.InsertCommand.Parameters[6].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[6].Value = ((string)(SID0));
}
if ((RID == null)) {
this.Adapter.InsertCommand.Parameters[7].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[7].Value = ((string)(RID));
}
if ((RID0 == null)) {
this.Adapter.InsertCommand.Parameters[8].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[8].Value = ((string)(RID0));
}
if ((RSN == null)) {
this.Adapter.InsertCommand.Parameters[9].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[9].Value = ((string)(RSN));
}
if ((QR == null)) {
this.Adapter.InsertCommand.Parameters[10].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[10].Value = ((string)(QR));
}
if ((ZPL == null)) {
this.Adapter.InsertCommand.Parameters[11].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[11].Value = ((string)(ZPL));
}
if ((POS == null)) {
this.Adapter.InsertCommand.Parameters[12].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[12].Value = ((string)(POS));
}
if ((LOC == null)) {
this.Adapter.InsertCommand.Parameters[13].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[13].Value = ((string)(LOC));
}
if ((ANGLE.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[14].Value = ((double)(ANGLE.Value));
}
else {
this.Adapter.InsertCommand.Parameters[14].Value = global::System.DBNull.Value;
}
if ((QTY.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[15].Value = ((int)(QTY.Value));
}
else {
this.Adapter.InsertCommand.Parameters[15].Value = global::System.DBNull.Value;
}
if ((QTY0.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[16].Value = ((int)(QTY0.Value));
}
else {
this.Adapter.InsertCommand.Parameters[16].Value = global::System.DBNull.Value;
}
if ((VNAME == null)) {
this.Adapter.InsertCommand.Parameters[17].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[17].Value = ((string)(VNAME));
}
if ((PRNATTACH.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[18].Value = ((bool)(PRNATTACH.Value));
}
else {
this.Adapter.InsertCommand.Parameters[18].Value = global::System.DBNull.Value;
}
if ((PRNVALID.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[19].Value = ((bool)(PRNVALID.Value));
}
else {
this.Adapter.InsertCommand.Parameters[19].Value = global::System.DBNull.Value;
}
this.Adapter.InsertCommand.Parameters[20].Value = ((System.DateTime)(wdate));
if ((VLOT == null)) {
this.Adapter.InsertCommand.Parameters[21].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[21].Value = ((string)(VLOT));
}
if ((BATCH == null)) {
this.Adapter.InsertCommand.Parameters[22].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[22].Value = ((string)(BATCH));
}
if ((qtymax.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[23].Value = ((int)(qtymax.Value));
}
else {
this.Adapter.InsertCommand.Parameters[23].Value = global::System.DBNull.Value;
}
global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State;
if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open)) {
this.Adapter.InsertCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
this.Adapter.InsertCommand.Connection.Close();
}
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(
System.DateTime STIME,
global::System.Nullable ETIME,
string PDATE,
string JTYPE,
string JGUID,
string SID,
string SID0,
string RID,
string RID0,
string RSN,
string QR,
string ZPL,
string POS,
string LOC,
global::System.Nullable ANGLE,
global::System.Nullable QTY,
global::System.Nullable QTY0,
string VNAME,
global::System.Nullable PRNATTACH,
global::System.Nullable PRNVALID,
System.DateTime wdate,
string VLOT,
string BATCH,
global::System.Nullable qtymax,
int Original_idx,
System.DateTime Original_STIME,
global::System.Nullable Original_ETIME,
string Original_PDATE,
string Original_JTYPE,
string Original_JGUID,
string Original_SID,
string Original_SID0,
string Original_RID,
string Original_RID0,
string Original_RSN,
string Original_QR,
string Original_ZPL,
string Original_POS,
string Original_LOC,
global::System.Nullable Original_ANGLE,
global::System.Nullable Original_QTY,
global::System.Nullable Original_QTY0,
string Original_VNAME,
global::System.Nullable Original_PRNATTACH,
global::System.Nullable Original_PRNVALID,
System.DateTime Original_wdate,
string Original_VLOT,
string Original_BATCH,
global::System.Nullable Original_qtymax,
int idx) {
this.Adapter.UpdateCommand.Parameters[0].Value = ((System.DateTime)(STIME));
if ((ETIME.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[1].Value = ((System.DateTime)(ETIME.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((PDATE == null)) {
this.Adapter.UpdateCommand.Parameters[2].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[2].Value = ((string)(PDATE));
}
if ((JTYPE == null)) {
this.Adapter.UpdateCommand.Parameters[3].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(JTYPE));
}
if ((JGUID == null)) {
this.Adapter.UpdateCommand.Parameters[4].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(JGUID));
}
if ((SID == null)) {
this.Adapter.UpdateCommand.Parameters[5].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[5].Value = ((string)(SID));
}
if ((SID0 == null)) {
this.Adapter.UpdateCommand.Parameters[6].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[6].Value = ((string)(SID0));
}
if ((RID == null)) {
this.Adapter.UpdateCommand.Parameters[7].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[7].Value = ((string)(RID));
}
if ((RID0 == null)) {
this.Adapter.UpdateCommand.Parameters[8].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[8].Value = ((string)(RID0));
}
if ((RSN == null)) {
this.Adapter.UpdateCommand.Parameters[9].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[9].Value = ((string)(RSN));
}
if ((QR == null)) {
this.Adapter.UpdateCommand.Parameters[10].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[10].Value = ((string)(QR));
}
if ((ZPL == null)) {
this.Adapter.UpdateCommand.Parameters[11].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[11].Value = ((string)(ZPL));
}
if ((POS == null)) {
this.Adapter.UpdateCommand.Parameters[12].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[12].Value = ((string)(POS));
}
if ((LOC == null)) {
this.Adapter.UpdateCommand.Parameters[13].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[13].Value = ((string)(LOC));
}
if ((ANGLE.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[14].Value = ((double)(ANGLE.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[14].Value = global::System.DBNull.Value;
}
if ((QTY.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[15].Value = ((int)(QTY.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[15].Value = global::System.DBNull.Value;
}
if ((QTY0.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[16].Value = ((int)(QTY0.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[16].Value = global::System.DBNull.Value;
}
if ((VNAME == null)) {
this.Adapter.UpdateCommand.Parameters[17].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[17].Value = ((string)(VNAME));
}
if ((PRNATTACH.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[18].Value = ((bool)(PRNATTACH.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[18].Value = global::System.DBNull.Value;
}
if ((PRNVALID.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[19].Value = ((bool)(PRNVALID.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[19].Value = global::System.DBNull.Value;
}
this.Adapter.UpdateCommand.Parameters[20].Value = ((System.DateTime)(wdate));
if ((VLOT == null)) {
this.Adapter.UpdateCommand.Parameters[21].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[21].Value = ((string)(VLOT));
}
if ((BATCH == null)) {
this.Adapter.UpdateCommand.Parameters[22].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[22].Value = ((string)(BATCH));
}
if ((qtymax.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[23].Value = ((int)(qtymax.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[23].Value = global::System.DBNull.Value;
}
this.Adapter.UpdateCommand.Parameters[24].Value = ((int)(Original_idx));
this.Adapter.UpdateCommand.Parameters[25].Value = ((System.DateTime)(Original_STIME));
if ((Original_ETIME.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[26].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[27].Value = ((System.DateTime)(Original_ETIME.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[26].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[27].Value = global::System.DBNull.Value;
}
if ((Original_PDATE == null)) {
this.Adapter.UpdateCommand.Parameters[28].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[29].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[28].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[29].Value = ((string)(Original_PDATE));
}
if ((Original_JTYPE == null)) {
this.Adapter.UpdateCommand.Parameters[30].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[31].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[30].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[31].Value = ((string)(Original_JTYPE));
}
if ((Original_JGUID == null)) {
this.Adapter.UpdateCommand.Parameters[32].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[33].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[32].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[33].Value = ((string)(Original_JGUID));
}
if ((Original_SID == null)) {
this.Adapter.UpdateCommand.Parameters[34].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[35].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[34].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[35].Value = ((string)(Original_SID));
}
if ((Original_SID0 == null)) {
this.Adapter.UpdateCommand.Parameters[36].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[37].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[36].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[37].Value = ((string)(Original_SID0));
}
if ((Original_RID == null)) {
this.Adapter.UpdateCommand.Parameters[38].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[39].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[38].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[39].Value = ((string)(Original_RID));
}
if ((Original_RID0 == null)) {
this.Adapter.UpdateCommand.Parameters[40].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[41].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[40].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[41].Value = ((string)(Original_RID0));
}
if ((Original_RSN == null)) {
this.Adapter.UpdateCommand.Parameters[42].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[43].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[42].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[43].Value = ((string)(Original_RSN));
}
if ((Original_QR == null)) {
this.Adapter.UpdateCommand.Parameters[44].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[45].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[44].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[45].Value = ((string)(Original_QR));
}
if ((Original_ZPL == null)) {
this.Adapter.UpdateCommand.Parameters[46].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[47].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[46].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[47].Value = ((string)(Original_ZPL));
}
if ((Original_POS == null)) {
this.Adapter.UpdateCommand.Parameters[48].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[49].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[48].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[49].Value = ((string)(Original_POS));
}
if ((Original_LOC == null)) {
this.Adapter.UpdateCommand.Parameters[50].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[51].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[50].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[51].Value = ((string)(Original_LOC));
}
if ((Original_ANGLE.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[52].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[53].Value = ((double)(Original_ANGLE.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[52].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[53].Value = global::System.DBNull.Value;
}
if ((Original_QTY.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[54].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[55].Value = ((int)(Original_QTY.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[54].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[55].Value = global::System.DBNull.Value;
}
if ((Original_QTY0.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[56].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[57].Value = ((int)(Original_QTY0.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[56].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[57].Value = global::System.DBNull.Value;
}
if ((Original_VNAME == null)) {
this.Adapter.UpdateCommand.Parameters[58].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[59].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[58].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[59].Value = ((string)(Original_VNAME));
}
if ((Original_PRNATTACH.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[60].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[61].Value = ((bool)(Original_PRNATTACH.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[60].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[61].Value = global::System.DBNull.Value;
}
if ((Original_PRNVALID.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[62].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[63].Value = ((bool)(Original_PRNVALID.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[62].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[63].Value = global::System.DBNull.Value;
}
this.Adapter.UpdateCommand.Parameters[64].Value = ((System.DateTime)(Original_wdate));
if ((Original_VLOT == null)) {
this.Adapter.UpdateCommand.Parameters[65].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[66].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[65].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[66].Value = ((string)(Original_VLOT));
}
if ((Original_BATCH == null)) {
this.Adapter.UpdateCommand.Parameters[67].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[68].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[67].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[68].Value = ((string)(Original_BATCH));
}
if ((Original_qtymax.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[69].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[70].Value = ((int)(Original_qtymax.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[69].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[70].Value = global::System.DBNull.Value;
}
this.Adapter.UpdateCommand.Parameters[71].Value = ((int)(idx));
global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open)) {
this.Adapter.UpdateCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(
System.DateTime STIME,
global::System.Nullable ETIME,
string PDATE,
string JTYPE,
string JGUID,
string SID,
string SID0,
string RID,
string RID0,
string RSN,
string QR,
string ZPL,
string POS,
string LOC,
global::System.Nullable ANGLE,
global::System.Nullable QTY,
global::System.Nullable QTY0,
string VNAME,
global::System.Nullable PRNATTACH,
global::System.Nullable PRNVALID,
System.DateTime wdate,
string VLOT,
string BATCH,
global::System.Nullable qtymax,
int Original_idx,
System.DateTime Original_STIME,
global::System.Nullable Original_ETIME,
string Original_PDATE,
string Original_JTYPE,
string Original_JGUID,
string Original_SID,
string Original_SID0,
string Original_RID,
string Original_RID0,
string Original_RSN,
string Original_QR,
string Original_ZPL,
string Original_POS,
string Original_LOC,
global::System.Nullable Original_ANGLE,
global::System.Nullable Original_QTY,
global::System.Nullable Original_QTY0,
string Original_VNAME,
global::System.Nullable Original_PRNATTACH,
global::System.Nullable Original_PRNVALID,
System.DateTime Original_wdate,
string Original_VLOT,
string Original_BATCH,
global::System.Nullable Original_qtymax) {
return this.Update(STIME, ETIME, PDATE, JTYPE, JGUID, SID, SID0, RID, RID0, RSN, QR, ZPL, POS, LOC, ANGLE, QTY, QTY0, VNAME, PRNATTACH, PRNVALID, wdate, VLOT, BATCH, qtymax, Original_idx, Original_STIME, Original_ETIME, Original_PDATE, Original_JTYPE, Original_JGUID, Original_SID, Original_SID0, Original_RID, Original_RID0, Original_RSN, Original_QR, Original_ZPL, Original_POS, Original_LOC, Original_ANGLE, Original_QTY, Original_QTY0, Original_VNAME, Original_PRNATTACH, Original_PRNVALID, Original_wdate, Original_VLOT, Original_BATCH, Original_qtymax, Original_idx);
}
}
///
///TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update scenarios
///
[global::System.ComponentModel.DesignerCategoryAttribute("code")]
[global::System.ComponentModel.ToolboxItem(true)]
[global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD" +
"esigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")]
public partial class TableAdapterManager : global::System.ComponentModel.Component {
private UpdateOrderOption _updateOrder;
private K4EE_Component_Reel_ResultTableAdapter _k4EE_Component_Reel_ResultTableAdapter;
private bool _backupDataSetBeforeUpdate;
private global::System.Data.IDbConnection _connection;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public UpdateOrderOption UpdateOrder {
get {
return this._updateOrder;
}
set {
this._updateOrder = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" +
"ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3" +
"a", "System.Drawing.Design.UITypeEditor")]
public K4EE_Component_Reel_ResultTableAdapter K4EE_Component_Reel_ResultTableAdapter {
get {
return this._k4EE_Component_Reel_ResultTableAdapter;
}
set {
this._k4EE_Component_Reel_ResultTableAdapter = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public bool BackupDataSetBeforeUpdate {
get {
return this._backupDataSetBeforeUpdate;
}
set {
this._backupDataSetBeforeUpdate = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.Browsable(false)]
public global::System.Data.IDbConnection Connection {
get {
if ((this._connection != null)) {
return this._connection;
}
if (((this._k4EE_Component_Reel_ResultTableAdapter != null)
&& (this._k4EE_Component_Reel_ResultTableAdapter.Connection != null))) {
return this._k4EE_Component_Reel_ResultTableAdapter.Connection;
}
return null;
}
set {
this._connection = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
[global::System.ComponentModel.Browsable(false)]
public int TableAdapterInstanceCount {
get {
int count = 0;
if ((this._k4EE_Component_Reel_ResultTableAdapter != null)) {
count = (count + 1);
}
return count;
}
}
///
///Update rows in top-down order.
///
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
private int UpdateUpdatedRows(DataSet1 dataSet, global::System.Collections.Generic.List allChangedRows, global::System.Collections.Generic.List allAddedRows) {
int result = 0;
if ((this._k4EE_Component_Reel_ResultTableAdapter != null)) {
global::System.Data.DataRow[] updatedRows = dataSet.K4EE_Component_Reel_Result.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent);
updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows);
if (((updatedRows != null)
&& (0 < updatedRows.Length))) {
result = (result + this._k4EE_Component_Reel_ResultTableAdapter.Update(updatedRows));
allChangedRows.AddRange(updatedRows);
}
}
return result;
}
///
///Insert rows in top-down order.
///
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
private int UpdateInsertedRows(DataSet1 dataSet, global::System.Collections.Generic.List allAddedRows) {
int result = 0;
if ((this._k4EE_Component_Reel_ResultTableAdapter != null)) {
global::System.Data.DataRow[] addedRows = dataSet.K4EE_Component_Reel_Result.Select(null, null, global::System.Data.DataViewRowState.Added);
if (((addedRows != null)
&& (0 < addedRows.Length))) {
result = (result + this._k4EE_Component_Reel_ResultTableAdapter.Update(addedRows));
allAddedRows.AddRange(addedRows);
}
}
return result;
}
///
///Delete rows in bottom-up order.
///
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
private int UpdateDeletedRows(DataSet1 dataSet, global::System.Collections.Generic.List allChangedRows) {
int result = 0;
if ((this._k4EE_Component_Reel_ResultTableAdapter != null)) {
global::System.Data.DataRow[] deletedRows = dataSet.K4EE_Component_Reel_Result.Select(null, null, global::System.Data.DataViewRowState.Deleted);
if (((deletedRows != null)
&& (0 < deletedRows.Length))) {
result = (result + this._k4EE_Component_Reel_ResultTableAdapter.Update(deletedRows));
allChangedRows.AddRange(deletedRows);
}
}
return result;
}
///
///Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first
///
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
private global::System.Data.DataRow[] GetRealUpdatedRows(global::System.Data.DataRow[] updatedRows, global::System.Collections.Generic.List allAddedRows) {
if (((updatedRows == null)
|| (updatedRows.Length < 1))) {
return updatedRows;
}
if (((allAddedRows == null)
|| (allAddedRows.Count < 1))) {
return updatedRows;
}
global::System.Collections.Generic.List realUpdatedRows = new global::System.Collections.Generic.List();
for (int i = 0; (i < updatedRows.Length); i = (i + 1)) {
global::System.Data.DataRow row = updatedRows[i];
if ((allAddedRows.Contains(row) == false)) {
realUpdatedRows.Add(row);
}
}
return realUpdatedRows.ToArray();
}
///
///Update all changes to the dataset.
///
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "17.0.0.0")]
public virtual int UpdateAll(DataSet1 dataSet) {
if ((dataSet == null)) {
throw new global::System.ArgumentNullException("dataSet");
}
if ((dataSet.HasChanges() == false)) {
return 0;
}
if (((this._k4EE_Component_Reel_ResultTableAdapter != null)
&& (this.MatchTableAdapterConnection(this._k4EE_Component_Reel_ResultTableAdapter.Connection) == false))) {
throw new global::System.ArgumentException("TableAdapterManager에서 관리하는 모든 TableAdapter에는 동일한 연결 문자열을 사용해야 합니다.");
}
global::System.Data.IDbConnection workConnection = this.Connection;
if ((workConnection == null)) {
throw new global::System.ApplicationException("TableAdapterManager에 연결 정보가 없습니다. 각 TableAdapterManager TableAdapter 속성을 올바른 Tabl" +
"eAdapter 인스턴스로 설정하십시오.");
}
bool workConnOpened = false;
if (((workConnection.State & global::System.Data.ConnectionState.Broken)
== global::System.Data.ConnectionState.Broken)) {
workConnection.Close();
}
if ((workConnection.State == global::System.Data.ConnectionState.Closed)) {
workConnection.Open();
workConnOpened = true;
}
global::System.Data.IDbTransaction workTransaction = workConnection.BeginTransaction();
if ((workTransaction == null)) {
throw new global::System.ApplicationException("트랜잭션을 시작할 수 없습니다. 현재 데이터 연결에서 트랜잭션이 지원되지 않거나 현재 상태에서 트랜잭션을 시작할 수 없습니다.");
}
global::System.Collections.Generic.List allChangedRows = new global::System.Collections.Generic.List();
global::System.Collections.Generic.List allAddedRows = new global::System.Collections.Generic.List();
global::System.Collections.Generic.List adaptersWithAcceptChangesDuringUpdate = new global::System.Collections.Generic.List();
global::System.Collections.Generic.Dictionary