Ejemplo n.º 1
0
        private void ConsolidatedInventory_Load(object sender, EventArgs e)
        {
            LoadCombos();
            gridControl1.UseEmbeddedNavigator = true;
            comboBoxEdit1.SelectedIndex = 0;
            dateTimePicker1.Value = DateTime.Now.Date;
            dtcon = ClsGetData.GetConsolidateinventoryDataTable();
            cONSOLIDATEINVENTORYBindingSource.DataSource = dtcon;
            if (cONSOLIDATEINVENTORYBindingSource.Count > 0)
            {
                 simpleButton4.Text = "Re-Create";
                var storecnt = dtcon[0]["COLNAMES"].ToString().Split(',');
                SetGridVisibleIndex(storecnt);
                //int i = 6;
                //foreach (var s in storecnt)
                //{
                //    gridView1.Columns[i + 4].VisibleIndex = i;
                //    gridView1.Columns[i + 4].Visible = true;
                //    gridView1.Columns[i + 4].Caption = s;
                //    i++;
                //}
                dateTimePicker1.Value = Convert.ToDateTime(dtcon[0]["RUNDATE"].ToString());

            }
            dsPurchase1.Merge(new PrDataManager().GetPurchaseRequestList(null, true));
        }
Ejemplo n.º 2
0
        private void simpleButton4_Click(object sender, EventArgs e)
        {
            string clnm = string.Empty;
            ClsGetData.DelConsolidateinventoryDataTable();

            dtcon = ClsGetData.GetConsolidateinventoryDataTable();
            cONSOLIDATEINVENTORYBindingSource.DataSource = dtcon;
            gridControl1.ResetBindings();

            var storecnt = checkedComboBoxEdit1.Properties.GetCheckedItems().ToString().Split(',');
            clnm = GetStorenames(storecnt);
            SetGridVisibleIndex(storecnt);
            //colPRGEN.VisibleIndex = 0;
            //colItemname.VisibleIndex = 1;
            //colItemno.VisibleIndex = 2;
            //colbarcode.VisibleIndex = 3;
            //colTOTAL.VisibleIndex = 4;
            //colPURQTY.VisibleIndex = 5;
             
            
            //foreach (var s in storecnt)
            //{
            //    clnm += s + ",";
            //    gridView1.Columns[i+4].VisibleIndex = i;
            //    gridView1.Columns[i+4].Visible = true;
            //    gridView1.Columns[i+4].Caption = s;
            //    i++;
            //}
            var i = 0;
            DsReports.ITEMLISTFORCONSOLIDATEINVDataTable dsitems = null;
            if (lookUpEdit2.EditValue == null && txtbarcode.EditValue == null && LookupSupplier.EditValue ==null)
            {
                dsitems = ClsGetData.ItemListForConsolidateInv(0,string.Empty);
            }
            if (comboBoxEdit1.SelectedIndex == 0 && lookUpEdit2.EditValue!=null)
            {
                dsitems = ClsGetData.ItemListForConsolidateInv(1,lookUpEdit2.EditValue.ToString());
            }
            if (comboBoxEdit1.SelectedIndex == 1 && txtbarcode.EditValue != null)
            {
                dsitems = ClsGetData.ItemListForConsolidateInv(2, txtbarcode.Text);
            }
            if (comboBoxEdit1.SelectedIndex == 2 && LookupSupplier.EditValue != null)
            {
                dsitems = ClsGetData.ItemListForConsolidateInv(3, txtbarcode.Text);
            }
            repositoryItemProgressBar1.Maximum = dsitems.Count;

            int k = 1;
            var connew = Utils.Connectionstring.Split(';');
            var bl = new StockMaster();
            
            if (dsitems != null)
                foreach (DsReports.ITEMLISTFORCONSOLIDATEINVRow  d in dsitems.Rows)
                {
                    progressBar1.EditValue = k;
                    Application.DoEvents();

                    k++;
                    i = 10;
                    var dr =(DsReports.CONSOLIDATEINVENTORYRow) dtcon.NewRow();
                    if(!d.IsSUPPLIERNAMENull())
                     dr.Suppliername = d.SUPPLIERNAME;
                    else
                    {
                        dr.Suppliername = "---";
                    }
                    dr.Itemname = d.ITEMNAME;
                    dr.Itemno = d.ITEMNO;

                    dr.ItemCategory = d.GROUPNAME;
                    dr.barcode = d.BARCODE;
                    dr.PURQTY = 0;
                    dr.RUNDATE = DateTime.Now.Date;
                    dr.PRGEN = false; 
                    dr.COLNAMES = clnm;
                    var toqty = 0;
                    foreach (string ss in storecnt)
                    {
                        var str = connew[0] + ";" + "Initial Catalog =" + ss + ";" + connew[2] + ";"   + connew[3] + ";" + connew[4] + ";";
                        var qty = bl.GetAvailableQty(d.ITEMNO, str, true);
                        toqty += qty;
                        dr[i] = qty;
                        dr.TOTAL = toqty;
                        i++;
                    }
                    dtcon.Rows.Add(dr);
                }
            cONSOLIDATEINVENTORYBindingSource.DataSource = dtcon;
           // COMMON.ClsGetData.SaveCosolidateInventoryRun(dtcon); 
        }