private TripleValue getDataFromTransTable(int tid) { TripleValue resultObject = new TripleValue(); string sqlStr = "SELECT NW,METALTYPE,PCS,PCODE FROM TRANS WHERE TID = " + tid; OleDbDataReader reader = dbUtils.fetch(sqlStr); if (reader.HasRows) { while (reader.Read()) { resultObject.weight = reader.GetDouble(0); resultObject.purity = reader.GetString(1); resultObject.pcs = reader.GetInt16(2); resultObject.itemDesc = reader.GetString(3); } } reader.Close(); return(resultObject); }
private void getSalesLineItem(int svno, DataSet ds) { DataTable lineItem = getSalesLineItemTable(); lineItem.TableName = "SaleLineItemTable"; ds.Tables.Add(lineItem); string sqlQry = "SELECT * FROM SALESBILLDETAIL WHERE SVNO = " + svno; OleDbDataReader reader = dbUtils.fetch(sqlQry); string path = string.Empty; DataRow row; int i = 0; if (reader.HasRows) { while (reader.Read()) { row = lineItem.NewRow(); path = Application.StartupPath + "//Data//Images//" + reader.GetInt32(1) + ".jpg"; //photo if (File.Exists(path)) { row[2] = path; } else { row[2] = Application.StartupPath + "//Data//Images//blankImage.jpg"; //photo } row[0] = ++i; row[1] = reader.GetInt32(2); TripleValue valueObject = getDataFromTransTable(reader.GetInt32(1)); row[3] = valueObject.itemDesc; row[4] = valueObject.weight; row[5] = valueObject.purity; row[6] = reader.GetDouble(3); Dictionary <string, List <double> > diamondStoneDetail = getDiamondandStoneDetail(reader.GetInt32(1)); if (diamondStoneDetail.ContainsKey("D")) { List <double> diamondList = diamondStoneDetail["D"]; row[7] = diamondList[0]; row[8] = diamondList[1]; } else { row[7] = 0; row[8] = 0; } if (diamondStoneDetail.ContainsKey("S")) { List <double> stoneList = diamondStoneDetail["S"]; row[9] = stoneList[0]; row[10] = stoneList[1]; } else { row[9] = 0; row[10] = 0; } row[11] = valueObject.pcs; if (reader.GetDouble(10) > 0) { row[12] = reader.GetDouble(7).ToString() + Environment.NewLine + reader.GetDouble(10).ToString(); } else { row[12] = reader.GetDouble(7); } row[13] = double.Parse(row[7].ToString()) + double.Parse(row[9].ToString()) + reader.GetDouble(7) + reader.GetDouble(10) + reader.GetDouble(4); lineItem.Rows.Add(row); } } reader.Close(); }