Ejemplo n.º 1
0
        private void frmjoborder_Load(object sender, EventArgs e)
        {
            DataSet dsType  = new mtypeCRUD().getData();
            DataSet dsDIV   = new mdivCRUD().getData();
            DataSet dsColor = new mcolorCRUD().getData();
            DataSet dsSize  = new msizeCRUD().getData();

            //teat
            // dtGrid.HeaderCell.Columns["hSizeID"].HeaderCell = datagridViewCheckBoxHeaderCell;
            SimpanTSB.Enabled = true;
            UbahTSB.Enabled   = false;
            dtGrid.Enabled    = true;

            cbTypeID.DataSource    = dsType.Tables[0];
            cbTypeID.DisplayMember = "DESCRIPTION";
            cbTypeID.ValueMember   = "TYPEID";

            cbDIV.DataSource    = dsDIV.Tables[0];
            cbDIV.DisplayMember = "DESCRIPTION";
            cbDIV.ValueMember   = "DIVID";
            DataGridViewComboBoxColumn SizeID  = dtGrid.Columns["hSizeID"] as DataGridViewComboBoxColumn;
            DataGridViewComboBoxColumn ColorID = dtGrid.Columns["hColorID"] as DataGridViewComboBoxColumn;

            SizeID.DataSource    = dsSize.Tables[0];
            SizeID.DisplayMember = "DESCRIPTION";
            SizeID.ValueMember   = "SIZEID";

            ColorID.DataSource    = dsColor.Tables[0];
            ColorID.DisplayMember = "DESCRIPTION";
            ColorID.ValueMember   = "COLORID";
        }
Ejemplo n.º 2
0
        private void frmuser_Load(object sender, EventArgs e)
        {
            SimpanTSB.Enabled = true;
            UbahTSB.Enabled   = false;
            dtGrid.Enabled    = false;

            DataSet dsDIV = new mdivCRUD().getData();

            cbDIV.DataSource    = dsDIV.Tables[0];
            cbDIV.DisplayMember = "DESCRIPTION";
            cbDIV.ValueMember   = "DIVID";
        }
Ejemplo n.º 3
0
        private void frmgrnCMT_Load(object sender, EventArgs e)
        {
            SimpanTSB.Enabled = true;
            UbahTSB.Enabled   = false;
            dtGrid.Enabled    = false;


            DataSet dsCost = new mcostCRUD().getData();
            //DataSet dsCurrency = new mcurrencyCRUD().getData();
            DataSet dsUOM     = new muomCRUD().getData();
            DataSet dsType    = new mtypeCRUD().getData();
            DataSet dsDIV     = new mdivCRUD().getData();
            DataSet dsCourier = new mcourierCRUD().getData();
            DataSet dsStore   = new mstoreCRUD().getData();

            cbStore.DataSource    = dsStore.Tables[0];
            cbStore.DisplayMember = "NAME";
            cbStore.ValueMember   = "STOREID";


            cbDIV.DataSource    = dsDIV.Tables[0];
            cbDIV.DisplayMember = "DESCRIPTION";
            cbDIV.ValueMember   = "DIVID";

            //cbCurrency.DataSource = dsCurrency.Tables[0];
            //cbCurrency.DisplayMember = "CURRENCYID";
            //cbCurrency.ValueMember = "CURRENCYID";

            DataGridViewComboBoxColumn Uom = dtGrid.Columns["hUom"] as DataGridViewComboBoxColumn;
            // DataGridViewComboBoxColumn CurrencyID = dtGrid.Columns["hCurrencyID"] as DataGridViewComboBoxColumn;
            DataGridViewComboBoxColumn UomPurchase = dtGrid.Columns["hUomPurchase"] as DataGridViewComboBoxColumn;

            Uom.DataSource    = dsUOM.Tables[0];
            Uom.DisplayMember = "DESCRIPTION";
            Uom.ValueMember   = "UOMID";

            UomPurchase.DataSource    = dsUOM.Tables[0];
            UomPurchase.DisplayMember = "DESCRIPTION";
            UomPurchase.ValueMember   = "UOMID";

            //CurrencyID.DataSource = dsCurrency.Tables[0];
            //CurrencyID.DisplayMember = "CURRENCYID";
            //CurrencyID.ValueMember = "CURRENCYID";
        }
Ejemplo n.º 4
0
        private void frmbcInput_Load(object sender, EventArgs e)
        {
            SimpanTSB.Enabled = true;
            UbahTSB.Enabled   = false;
            //dtGrid.Enabled = false;

            DataSet dsDIV = new mdivCRUD().getData();

            cbDIV.DataSource    = dsDIV.Tables[0];
            cbDIV.DisplayMember = "DESCRIPTION";
            cbDIV.ValueMember   = "DIVID";

            DataSet dsCurrency = new mcurrencyCRUD().getData();
            DataGridViewComboBoxColumn Currency = dtGrid.Columns["hCurrency"] as DataGridViewComboBoxColumn;

            Currency.DataSource    = dsCurrency.Tables[0];
            Currency.DisplayMember = "CURRENCYID";
            Currency.ValueMember   = "CURRENCYID";
        }
Ejemplo n.º 5
0
        private void frmcosting_Load(object sender, EventArgs e)
        {
            SimpanTSB.Enabled = true;
            UbahTSB.Enabled   = false;
            dtGrid.Enabled    = false;
            DataSet dsCost     = new mcostCRUD().getData();
            DataSet dsCurrency = new mcurrencyCRUD().getData();
            DataSet dsValueIn  = new mcurrencyCRUD().getData();
            DataSet dsUOM      = new muomCRUD().getData();
            DataSet dsType     = new mtypeCRUD().getData();
            DataSet dsDIV      = new mdivCRUD().getData();

            cbTypeID.DataSource    = dsType.Tables[0];
            cbTypeID.DisplayMember = "DESCRIPTION";
            cbTypeID.ValueMember   = "TYPEID";

            cbDIV.DataSource    = dsDIV.Tables[0];
            cbDIV.DisplayMember = "DESCRIPTION";
            cbDIV.ValueMember   = "DIVID";

            cbValueIn.DataSource    = dsValueIn.Tables[0];
            cbValueIn.DisplayMember = "CURRENCYID";
            cbValueIn.ValueMember   = "CURRENCYID";


            DataGridViewComboBoxColumn CostType = dtGrid.Columns["hCostType"] as DataGridViewComboBoxColumn;    //new DataGridViewComboBoxColumn();
            DataGridViewComboBoxColumn Uom      = dtGrid.Columns["hUom"] as DataGridViewComboBoxColumn;
            DataGridViewComboBoxColumn Currency = dtGrid.Columns["hCurrency"] as DataGridViewComboBoxColumn;

            CostType.DataSource    = dsCost.Tables[0];
            CostType.DisplayMember = "DESCRIPTION";
            CostType.ValueMember   = "COSTID";

            Uom.DataSource    = dsUOM.Tables[0];
            Uom.DisplayMember = "DESCRIPTION";
            Uom.ValueMember   = "UOMID";

            Currency.DataSource    = dsCurrency.Tables[0];
            Currency.DisplayMember = "CURRENCYID";
            Currency.ValueMember   = "CURRENCYID";

            cbValueIn.Text = "USD";
        }
Ejemplo n.º 6
0
        private void frmgin_Load(object sender, EventArgs e)
        {
            SimpanTSB.Enabled = true;
            UbahTSB.Enabled   = false;
            dtGrid.Enabled    = false;


            DataSet dsColor = new mcolorCRUD().getData();
            DataSet dsSize  = new msizeCRUD().getData();

            DataSet dsUOM   = new muomCRUD().getData();
            DataSet dsType  = new mtypeCRUD().getData();
            DataSet dsDIV   = new mdivCRUD().getData();
            DataSet dsStore = new mstoreCRUD().getData();

            cbStore.DataSource    = dsStore.Tables[0];
            cbStore.DisplayMember = "NAME";
            cbStore.ValueMember   = "STOREID";

            cbDIV.DataSource    = dsDIV.Tables[0];
            cbDIV.DisplayMember = "DESCRIPTION";
            cbDIV.ValueMember   = "DIVID";


            DataGridViewComboBoxColumn Uom     = dtGrid.Columns["hUom"] as DataGridViewComboBoxColumn;
            DataGridViewComboBoxColumn SizeID  = dtGrid.Columns["hSizeID"] as DataGridViewComboBoxColumn;
            DataGridViewComboBoxColumn ColorID = dtGrid.Columns["hColorID"] as DataGridViewComboBoxColumn;

            SizeID.DataSource    = dsSize.Tables[0];
            SizeID.DisplayMember = "DESCRIPTION";
            SizeID.ValueMember   = "SIZEID";

            ColorID.DataSource    = dsColor.Tables[0];
            ColorID.DisplayMember = "DESCRIPTION";
            ColorID.ValueMember   = "COLORID";

            Uom.DataSource    = dsUOM.Tables[0];
            Uom.DisplayMember = "DESCRIPTION";
            Uom.ValueMember   = "UOMID";
        }