internal static SupplierInvoiceJournalItem FindSIJournalItemlistForPayment(MySql.Data.MySqlClient.MySqlCommand cmd, int supinvItemID)
{
cmd.CommandText = SupplierInvoiceJournalItem.GetByIDSQL(supinvItemID);
MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader();
SupplierInvoiceJournalItem result = SupplierInvoiceJournalItem.TransformReader(r);
r.Close();
cmd.CommandText = SupplierInvoiceJournal.GetByIDSQL(result.EVENT_JOURNAL.ID);
r = cmd.ExecuteReader();
result.EVENT_JOURNAL = SupplierInvoiceJournal.TransformReader(r);
r.Close();
cmd.CommandText = Currency.GetByIDSQLStatic(result.CURRENCY.ID);
r = cmd.ExecuteReader();
result.CURRENCY = Currency.GetCurrency(r);
r.Close();
cmd.CommandText = TermOfPayment.GetByIDSQLStatic(result.TOP.ID);
r = cmd.ExecuteReader();
result.TOP = TermOfPayment.GetTOP(r);
r.Close();
cmd.CommandText = Employee.GetByIDSQLStatic(result.EMPLOYEE.ID);
r = cmd.ExecuteReader();
result.EMPLOYEE = Employee.GetEmployee(r);
r.Close();
return(result);
}
internal static CustomerOutStandingInvoiceItem FindCOIItemlistForReceipt(MySql.Data.MySqlClient.MySqlCommand cmd, int supinvItemID)
{
cmd.CommandText = CustomerOutStandingInvoiceItem.GetByIDSQL(supinvItemID);
MySql.Data.MySqlClient.MySqlDataReader r = cmd.ExecuteReader();
CustomerOutStandingInvoiceItem result = CustomerOutStandingInvoiceItem.TransformReader(r);
r.Close();
cmd.CommandText = CustomerOutStandingInvoice.GetByIDSQL(result.EVENT_JOURNAL.ID);
r = cmd.ExecuteReader();
result.EVENT_JOURNAL = CustomerOutStandingInvoice.TransformReader(r);
r.Close();
cmd.CommandText = Currency.GetByIDSQLStatic(result.CURRENCY.ID);
r = cmd.ExecuteReader();
result.CURRENCY = Currency.GetCurrency(r);
r.Close();
cmd.CommandText = TermOfPayment.GetByIDSQLStatic(result.TOP.ID);
r = cmd.ExecuteReader();
result.TOP = TermOfPayment.GetTOP(r);
r.Close();
cmd.CommandText = Employee.GetByIDSQLStatic(result.EMPLOYEE.ID);
r = cmd.ExecuteReader();
result.EMPLOYEE = Employee.GetEmployee(r);
r.Close();
return(result);
}
private TermOfPayment getCommonTOP()
{
m_command.CommandText = TermOfPayment.GetByCodeStaticSQL("COD");
MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader();
TermOfPayment re = TermOfPayment.GetTOP(r);
r.Close();
return(re);
}
public IList FindSIbyPartAndPONo(string find, IList exceptPOI, int supplierID, DateTime trDate)
{
StringBuilder poisSB = new StringBuilder();
foreach (int i in exceptPOI)
{
poisSB.Append(i.ToString());
poisSB.Append(',');
}
string pois = poisSB.ToString();
pois = exceptPOI.Count > 0?pois.Substring(0, pois.Length - 1):"";
m_command.CommandText = CustomerInvoiceItem.GetSearchByPartAndPONo(find, supplierID, pois, trDate);
MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader();
IList result = CustomerInvoiceItem.TransformReaderList(r);
r.Close();
foreach (CustomerInvoiceItem t in result)
{
m_command.CommandText = CustomerInvoice.GetByIDSQL(t.EVENT.ID);
r = m_command.ExecuteReader();
t.EVENT = CustomerInvoice.TransformReader(r);
r.Close();
m_command.CommandText = Part.GetByIDSQLStatic(t.PART.ID);
r = m_command.ExecuteReader();
t.PART = Part.GetPart(r);
r.Close();
m_command.CommandText = Unit.GetByIDSQLstatic(t.UNIT.ID);
r = m_command.ExecuteReader();
t.UNIT = Unit.GetUnit(r);
r.Close();
m_command.CommandText = TermOfPayment.GetByIDSQLStatic(((CustomerInvoice)t.EVENT).TOP.ID);
r = m_command.ExecuteReader();
((CustomerInvoice)t.EVENT).TOP = TermOfPayment.GetTOP(r);
r.Close();
m_command.CommandText = Warehouse.GetByIDSQLStatic(t.WAREHOUSE.ID);
r = m_command.ExecuteReader();
t.WAREHOUSE = Warehouse.GetWarehouse(r);
r.Close();
m_command.CommandText = Unit.GetByIDSQLstatic(t.PART.UNIT.ID);
r = m_command.ExecuteReader();
t.PART.UNIT = Unit.GetUnit(r);
r.Close();
}
return(result);
}
public static TermOfPayment GetTOP(MySql.Data.MySqlClient.MySqlDataReader aReader)
{
TermOfPayment top = null;
while (aReader.Read())
{
top = new TermOfPayment();
top.ID = Convert.ToInt32(aReader[0]);
top.CODE = aReader[1].ToString();
top.NAME = aReader[2].ToString();
top.DAYS = Convert.ToInt16(aReader[3]);
top.MODIFIED_BY = aReader["modified_by"].ToString();
top.MODIFIED_DATE = Convert.ToDateTime(aReader["modified_date"].ToString());
top.MODIFIED_COMPUTER_NAME = aReader["modified_computer"].ToString();
}
return(top);
}
public IList GetAll(MySql.Data.MySqlClient.MySqlDataReader aReader)
{
IList result = new ArrayList();
while (aReader.Read())
{
TermOfPayment top = new TermOfPayment();
top.ID = Convert.ToInt32(aReader[0]);
top.CODE = aReader[1].ToString();
top.NAME = aReader[2].ToString();
top.DAYS = Convert.ToInt16(aReader[3]);
top.MODIFIED_BY = aReader["modified_by"].ToString();
top.MODIFIED_DATE = Convert.ToDateTime(aReader["modified_date"].ToString());
top.MODIFIED_COMPUTER_NAME = aReader["modified_computer"].ToString();
result.Add(top);
}
return(result);
}
public IList FindSIJournalItemlistForPayment(string find, int ccyID, int supplier, DateTime trdate, IList notIn)
{
StringBuilder poisSB = new StringBuilder();
foreach (int i in notIn)
{
poisSB.Append(i.ToString());
poisSB.Append(',');
}
string pois = poisSB.ToString();
pois = notIn.Count > 0 ? pois.Substring(0, pois.Length - 1) : "";
m_command.CommandText = SupplierInvoiceJournalItem.GetSearchForPayment(find, ccyID, supplier, pois, trdate);
MySql.Data.MySqlClient.MySqlDataReader r = m_command.ExecuteReader();
IList result = SupplierInvoiceJournalItem.TransformReaderList(r);
r.Close();
foreach (SupplierInvoiceJournalItem t in result)
{
m_command.CommandText = SupplierInvoiceJournal.GetByIDSQL(t.EVENT_JOURNAL.ID);
r = m_command.ExecuteReader();
t.EVENT_JOURNAL = SupplierInvoiceJournal.TransformReader(r);
r.Close();
m_command.CommandText = Currency.GetByIDSQLStatic(t.CURRENCY.ID);
r = m_command.ExecuteReader();
t.CURRENCY = Currency.GetCurrency(r);
r.Close();
m_command.CommandText = TermOfPayment.GetByIDSQLStatic(t.TOP.ID);
r = m_command.ExecuteReader();
t.TOP = TermOfPayment.GetTOP(r);
r.Close();
m_command.CommandText = Employee.GetByIDSQLStatic(t.EMPLOYEE.ID);
r = m_command.ExecuteReader();
t.EMPLOYEE = Employee.GetEmployee(r);
r.Close();
}
return(result);
}
