private void CheckForMultiStock(string itemno, string itemname) { var bl = new BLSales(); var drstock = new BLSales().GetStockItem(itemno, "S"); var dprice = bl.GetDisctinctSprices(drstock); gridControl1.DataSource = drstock; }
bool CheckForMultiStock(string itemno,string itemname) { var bl = new BLSales(); var drstock = new BLSales().GetStockItem(itemno, "S"); var dprice = bl.GetDisctinctSprices(drstock); int cnt = dprice.Count(); var stk = new DsInventory.STOCKMASTERDataTable(); // var topRows = drstock.AsEnumerable().OrderBy(o => o.Field<int>("STOCKID")).Take(1).ToList().CopyToDataTable(); DataTable topRows = drstock.Rows.Cast<DataRow>().Take(1).CopyToDataTable(); // object[] topRows = drstock.Select( * ", "EXPDATE ASC "); DataRow dr = stk.NewRow(); foreach (DataRow drs in topRows.Rows) { drs["DQNTY"] = 1; dr.ItemArray = drs.ItemArray; } stk.Rows.Add(dr); AddMultipleItems(stk, itemname); if (cnt > 1) { onePing(); lblmutilpleprice.Visible = true; gridControl2.DataSource = drstock; } return cnt > 0; }