public IList SearchActivePartByBarcode(string barcode, bool active)
{
try
{
OpenConnection();
MySql.Data.MySqlClient.MySqlCommand aCommand = new MySql.Data.MySqlClient.MySqlCommand();
aCommand.Connection = m_connection;
MySql.Data.MySqlClient.MySqlDataReader aReader;
aCommand.CommandText = UnitConversion.GetAllByBarcodeSQL(barcode);
aReader = aCommand.ExecuteReader();
IList unv = UnitConversion.GetAllStatic(aReader);
aReader.Close();
IList result = new ArrayList();
foreach (UnitConversion c in unv)
{
c.PART = PartRepository.GetByID(aCommand, c.PART.ID);
c.CONVERSION_UNIT = PartRepository.GetUnitByID(aCommand, c.CONVERSION_UNIT.ID);
c.PART.UNIT_BY_SEARCH = c.CONVERSION_UNIT;
c.PART.SELL_PRICE_BY_SEARCH = c.SELL_PRICE;
c.PART.COST_PRICE_BY_SEARCH = c.COST_PRICE;
result.Add(c.PART);
}
return(result);
}
catch (Exception x)
{
throw new Exception(getErrorMessage(x));
}
finally
{
m_connection.Close();
}
}
public DataSet GetStockReport(bool allPart, string partStart, string partEnd, bool allGroup,
string groupStart, string groupEnd, DateTime asOfDate)
{
DataSet ds = new DataSet();
m_cmd.CommandText = "delete from table_temp";
m_cmd.ExecuteNonQuery();
m_cmd.CommandText = Part.GetStockReport(allPart, partStart, partEnd, allGroup, groupStart, groupEnd);
MySql.Data.MySqlClient.MySqlDataReader rdr = m_cmd.ExecuteReader();
IList result = Part.GetAllStaticForReport(rdr);
rdr.Close();
//IList stockcards = new ArrayList();
foreach (Part p in result)
{
p.UNIT = PartRepository.GetUnitByID(m_cmd, p.UNIT.ID);
p.PART_GROUP = PartRepository.GetPartGroupByID(m_cmd, p.PART_GROUP.ID);
StockCard sc = new StockCard(p, null, null);
m_cmd.CommandText = StockCardEntry.FindByStockCardEntryByPart(p.ID, new DateTime(2000, 1, 1), asOfDate);
rdr = m_cmd.ExecuteReader();
sc.STOCK_CARD_ENTRIES = StockCardEntry.TransformReaderList(rdr);
rdr.Close();
foreach (StockCardEntry e in sc.STOCK_CARD_ENTRIES)
{
if (e.STOCK_CARD_ENTRY_TYPE == StockCardEntryType.SupplierInvoice)
{
m_cmd.CommandText = SupplierInvoiceItem.GetByIDSQL(e.EVENT_ITEM.ID);
rdr = m_cmd.ExecuteReader();
e.EVENT_ITEM = SupplierInvoiceItem.TransformReader(rdr);
rdr.Close();
}
if (e.STOCK_CARD_ENTRY_TYPE == StockCardEntryType.CustomerInvoice)
{
m_cmd.CommandText = CustomerInvoiceItem.GetByIDSQL(e.EVENT_ITEM.ID);
rdr = m_cmd.ExecuteReader();
e.EVENT_ITEM = CustomerInvoiceItem.TransformReader(rdr);
rdr.Close();
}
}
sc.recalculateAvailable();
m_cmd.CommandText = string.Format(@"insert into table_temp
(
string1,string2,string3,double1,double2
)
values
(
'{0}','{1}','{2}',{3},{4}
)",
p.PART_GROUP.NAME + " ~ " + p.PART_GROUP.CODE,
p.CODE,
p.UNIT.NAME,
sc.BALANCE_AVAILABLE,
p.MINIMUM_STOCK
);
m_cmd.ExecuteNonQuery();
//stockcards.Add(sc);
}
return(ds);
}