void CreateInventoryReport() { var ds = new StockMaster().GetDististinctItemsInStockMaster(); int i = 0; var bl = new BlItemMaster(); var stk = new StockMaster(); var bls = new SalesManger(); foreach (DataRow stockmasterRow in ds.Rows) { var dr = (Ledgers.InventoryVariationRow) dt.NewRow(); dr[0] = i++; var itm = stockmasterRow["ITEMNO"].ToString(); dr.ITEMNO = itm; dr.ITEMNAME = bl.GetItemname(itm); dr.OPENING = bls.GetOpeningQty(itm); dr.RECEIVE = bls.GetReceivedQty(itm); dr.RETURN = bls.GetReturnQty(itm); dr.SALES = bls.GetSoldQty(itm); dr.TRANSFER = bls.GetTransferedQty(itm); dr.ADJQTY = bls.GetAdjQty(itm); dr.ACTUAL = (dr.OPENING + dr.ADJQTY + dr.RECEIVE + (-1* dr.RETURN)) - (dr.SALES + dr.TRANSFER); dr.INSTOCK = stk.GetAvailableQty(itm); // dr.STOCKID = int.Parse(stockmasterRow["STOCKID"].ToString()); dt.Rows.Add(dr); } inventoryVariationBindingSource.DataSource = dt; fixstkdiff = false; }
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); }
public static int CheckStockAvailable(int stockid) { var cls = new StockMaster(); return cls.GetAvailableQty(stockid); }