public virtual maindataset.billDataTable GetDataByBill(global::System.Nullable<int> billid, global::System.Nullable<int> userid, global::System.Nullable<int> mnbillId, global::System.Nullable<global::System.DateTime> billdate, string gcnumber, string chalannumber, string trucknumber, string goods, string bags, string tone, global::System.Nullable<decimal> rate, global::System.Nullable<decimal> amount, global::System.Nullable<global::System.DateTime> unloading, string billnumber) {
this.Adapter.SelectCommand = this.CommandCollection[2];
if ((billid.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(billid.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((userid.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[2].Value = ((int)(userid.Value));
}
else {
this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
}
if ((mnbillId.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[3].Value = ((int)(mnbillId.Value));
}
else {
this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
}
if ((billdate.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[4].Value = ((System.DateTime)(billdate.Value));
}
else {
this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value;
}
if ((gcnumber == null)) {
this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[5].Value = ((string)(gcnumber));
}
if ((chalannumber == null)) {
this.Adapter.SelectCommand.Parameters[6].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[6].Value = ((string)(chalannumber));
}
if ((trucknumber == null)) {
this.Adapter.SelectCommand.Parameters[7].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[7].Value = ((string)(trucknumber));
}
if ((goods == null)) {
this.Adapter.SelectCommand.Parameters[8].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[8].Value = ((string)(goods));
}
if ((bags == null)) {
this.Adapter.SelectCommand.Parameters[9].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[9].Value = ((string)(bags));
}
if ((tone == null)) {
this.Adapter.SelectCommand.Parameters[10].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[10].Value = ((string)(tone));
}
if ((rate.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[11].Value = ((decimal)(rate.Value));
}
else {
this.Adapter.SelectCommand.Parameters[11].Value = global::System.DBNull.Value;
}
if ((amount.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[12].Value = ((decimal)(amount.Value));
}
else {
this.Adapter.SelectCommand.Parameters[12].Value = global::System.DBNull.Value;
}
if ((unloading.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[13].Value = ((System.DateTime)(unloading.Value));
}
else {
this.Adapter.SelectCommand.Parameters[13].Value = global::System.DBNull.Value;
}
if ((billnumber == null)) {
this.Adapter.SelectCommand.Parameters[14].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[14].Value = ((string)(billnumber));
}
maindataset.billDataTable dataTable = new maindataset.billDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual maindataset.billDataTable GetSelectBillForReport(global::System.Nullable<int> mnbillid) {
this.Adapter.SelectCommand = this.CommandCollection[3];
if ((mnbillid.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(mnbillid.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
maindataset.billDataTable dataTable = new maindataset.billDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual maindataset.billDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
maindataset.billDataTable dataTable = new maindataset.billDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}