[global::System.Diagnostics.DebuggerNonUserCodeAttribute(), global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"), global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]public virtual int FillSearchResults(SPDataProxy.SPLookupDataTable dataTable, string SearchType, string SubType, string SearchFor, string SearchItem)
{
this.Adapter.SelectCommand = this.CommandCollection(0);
if (SearchType == null)
{
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[1].Value = System.Convert.ToString(SearchType);
}
if (SubType == null)
{
this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[2].Value = System.Convert.ToString(SubType);
}
if (SearchFor == null)
{
this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[3].Value = System.Convert.ToString(SearchFor);
}
if (SearchItem == null)
{
this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[4].Value = System.Convert.ToString(SearchItem);
}
if (this.ClearBeforeFill == true)
{
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute(), global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]public virtual int Update(SPDataProxy dataSet)
{
return this.Adapter.Update(dataSet, "SPPayMode");
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute(), global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"), global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]public virtual int FillPayMode(SPDataProxy.SPPayModeDataTable dataTable, global::System.Nullable<long> PayModeID)
{
this.Adapter.SelectCommand = this.CommandCollection(2);
if (PayModeID.HasValue == true)
{
this.Adapter.SelectCommand.Parameters[1].Value = (long) PayModeID.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if (this.ClearBeforeFill == true)
{
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute(), global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"), global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]public virtual int FillEmptyPayMode(SPDataProxy.SPPayModeDataTable dataTable)
{
this.Adapter.SelectCommand = this.CommandCollection(1);
if (this.ClearBeforeFill == true)
{
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute(), global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"), global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)]public virtual int FillAutoID(SPDataProxy.SPAutoIdDataTable dataTable, string Prefix, global::System.Nullable<DateTime> LastDate)
{
this.Adapter.SelectCommand = this.CommandCollection(0);
if (Prefix == null)
{
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[1].Value = System.Convert.ToString(Prefix);
}
if (LastDate.HasValue == true)
{
this.Adapter.SelectCommand.Parameters[2].Value = System.Convert.ToDateTime(LastDate.Value);
}
else
{
this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
}
if (this.ClearBeforeFill == true)
{
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute(), global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter"), global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, false)]public virtual int FillEmptyMaster(SPDataProxy.SPMasterDataTable dataTable, string TypeID)
{
this.Adapter.SelectCommand = this.CommandCollection(1);
if (TypeID == null)
{
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
else
{
this.Adapter.SelectCommand.Parameters[1].Value = System.Convert.ToString(TypeID);
}
if (this.ClearBeforeFill == true)
{
dataTable.Clear();
}
int returnValue = this.Adapter.Fill(dataTable);
return returnValue;
}
