C# (CSharp) Open_Miracle UnitSP.UnitViewAll示例

示例#1

文件： frmStockJournal.cs 项目： jsoques/openmiracle

 /// <summary>
 /// Function to fill unit combobox
 /// </summary>
 public void UnitComboFill()
 {
     try
     {
         UnitSP spUnit = new UnitSP();
         DataTable dtblUnit = new DataTable();
         dtblUnit = spUnit.UnitViewAll();
         dgvcmbConsumptionunitId.DataSource = dtblUnit;
         dgvcmbConsumptionunitId.ValueMember = "unitId";
         dgvcmbConsumptionunitId.DisplayMember = "unitName";
         dgvcmbProductionunitId.DataSource = dtblUnit;
         dgvcmbProductionunitId.ValueMember = "unitId";
         dgvcmbProductionunitId.DisplayMember = "unitName";
     }
     catch (Exception ex)
     {
         MessageBox.Show("SJ:21" + ex.Message, "Open Miracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }

示例#2

文件： frmSalesInvoice.cs 项目： jsoques/openmiracle

 /// <summary>
 /// Grid Unit combofill, all are the unit fill here
 /// </summary>
 public void DgvUnitComboFill()
 {
     try
     {
         UnitSP spUnit = new UnitSP();
         DataTable dtblUnit = new DataTable();
         dtblUnit = spUnit.UnitViewAll();
         dgvtxtSalesInvoicembUnitName.DataSource = dtblUnit;
         dgvtxtSalesInvoicembUnitName.ValueMember = "unitId";
         dgvtxtSalesInvoicembUnitName.DisplayMember = "unitName";
     }
     catch (Exception ex)
     {
         MessageBox.Show("SI: 24" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }

示例#3

文件： frmSalesQuotation.cs 项目： jsoques/openmiracle

 /// <summary>
 /// Unit combo fill
 /// </summary>
 public void DGVUnitComboFill()
 {
     try
     {
         UnitSP spUnit = new UnitSP();
         DataTable dtblUnit = new DataTable();
         dtblUnit = spUnit.UnitViewAll();
         dgvcmbUnit.DataSource = dtblUnit;
         DataRow dr = dtblUnit.NewRow();
         dr[2] = "NA";
         dtblUnit.Rows.InsertAt(dr, 0);
         dgvcmbUnit.ValueMember = "unitId";
         dgvcmbUnit.DisplayMember = "unitName";
     }
     catch (Exception ex)
     {
         MessageBox.Show("SQ:07" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }

示例#4

文件： frmProductCreation.cs 项目： jsoques/openmiracle

 /// <summary>
 /// Function to fill unit combobox in grid
 /// </summary>
 public void UnitComboFill()
 {
     try
     {
         DataTable dtbl = new DataTable();
         UnitSP spUnit = new UnitSP();
         dtbl = spUnit.UnitViewAll();
         cmbUnit.DataSource = dtbl;
         cmbUnit.DisplayMember = "unitName";
         cmbUnit.ValueMember = "unitId";
         cmbUnit.SelectedValue = -1;
     }
     catch (Exception ex)
     {
         MessageBox.Show("PC:52" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }

示例#5

文件： frmPurchaseReturn.cs 项目： jsoques/openmiracle

 /// <summary>
 /// Function to fill DataGridView Unit combobox 
 /// </summary>
 public void DGVUnitComboFill()
 {
     TransactionsGeneralFill TransactionGeneralFillObj = new TransactionsGeneralFill();
     try
     {
         UnitSP spUnit = new UnitSP();
         DataTable dtblUnit = new DataTable();
         dtblUnit = spUnit.UnitViewAll();
         dgvcmbUnit.DataSource = dtblUnit;
         dgvcmbUnit.ValueMember = "unitId";
         dgvcmbUnit.DisplayMember = "unitName";
     }
     catch (Exception ex)
     {
         MessageBox.Show("PR:07" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
 }