Example #1
0
        private void btManRefresh_Click(object sender, EventArgs e)
        {
            string name = this.ManufacturerlookUpEdit.Text;

            if (name.Length == 0)
            {
                return;
            }

            if (name.Length > 3)
            {
                name = name.Substring(0, 3);
            }

            try
            {
                MDataSet.ManufacturerDataTable _tmp = new MDataSet.ManufacturerDataTable();

                (this.ParentForm as FormDialog).MainForm.manufacturerTableAdapter.FillByName(_tmp, name);
                this.mDataSet.Manufacturer.Merge(_tmp);
            }

            catch (Exception err)
            {
                MessageBox.Show(err.Message);
            }
        }
Example #2
0
 public virtual MDataSet.ManufacturerDataTable GetDataNew() {
     this.Adapter.SelectCommand = this.CommandCollection[3];
     MDataSet.ManufacturerDataTable dataTable = new MDataSet.ManufacturerDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
Example #3
0
 public virtual MDataSet.ManufacturerDataTable GetDataByName(string name) {
     this.Adapter.SelectCommand = this.CommandCollection[1];
     if ((name == null)) {
         this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = ((string)(name));
     }
     MDataSet.ManufacturerDataTable dataTable = new MDataSet.ManufacturerDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
Example #4
0
 public virtual MDataSet.ManufacturerDataTable GetDataByReceiptMasterRef(System.Nullable<int> ReceiptMasterRef) {
     this.Adapter.SelectCommand = this.CommandCollection[2];
     if ((ReceiptMasterRef.HasValue == true)) {
         this.Adapter.SelectCommand.Parameters[1].Value = ((int)(ReceiptMasterRef.Value));
     }
     else {
         this.Adapter.SelectCommand.Parameters[1].Value = System.DBNull.Value;
     }
     MDataSet.ManufacturerDataTable dataTable = new MDataSet.ManufacturerDataTable();
     this.Adapter.Fill(dataTable);
     return dataTable;
 }
Example #5
0
        private void btManRefresh_Click(object sender, EventArgs e)
        {
            string name = this.ManufacturerlookUpEdit.Text;

            if (name.Length == 0) return;

            if (name.Length > 3)
                name = name.Substring(0, 3);
            
            try
            {
                MDataSet.ManufacturerDataTable _tmp = new MDataSet.ManufacturerDataTable();

                (this.ParentForm as FormDialog).MainForm.manufacturerTableAdapter.FillByName(_tmp,name);
                this.mDataSet.Manufacturer.Merge(_tmp);
             }

            catch (Exception err)
            {

                MessageBox.Show(err.Message);
            }
            
        }