private void btnBuscar_Click(object sender, EventArgs e)
{
try
{
DataTable dtVFact = new DataTable();
dtVFact.Columns.Add("Name", typeof(String));
dtVFact.Columns.Add("CustNum", typeof(String));
dtVFact.Columns.Add("State", typeof(String));
dtVFact.Columns.Add("CantFact", typeof(Decimal));
dtVFact.Columns.Add("Total", typeof(Decimal));
BO.Metodo mt = new BO.Metodo();
DataTable dtFac = new DataTable();
dtFac = mt.factur();
DataRow dRow;
DataTable ds = new DataTable();
ds = mt.factur();
bool Existe = false;
if (ds.Rows.Count - 1 >= 0)
{
for (int i = 0; i <= ds.Rows.Count - 1; i++)
{
Existe = false;
if (dtVFact.Rows.Count - 1 >= 0)
{
for (int j = 0; j <= dtVFact.Rows.Count - 1; j++)
{
if (ds.Rows[i]["CustNum"].ToString() == dtVFact.Rows[j]["CustNum"].ToString())
{
Existe = true;
break;
}
}
}
if (!Existe)
{
decimal suma = 0;
decimal Contador = 0;
dRow = dtVFact.NewRow();
dRow["Name"] = ds.Rows[i]["Name"].ToString();
dRow["CustNum"] = ds.Rows[i]["CustNum"].ToString();
dRow["State"] = ds.Rows[i]["State"].ToString();
dRow["CustNum"] = Convert.ToInt32(ds.Rows[i]["CustNum"]);
for (int h = 0; h <= ds.Rows.Count - 1; h++)
{
if (ds.Rows[i]["CustNum"].ToString() == ds.Rows[h]["CustNum"].ToString())
{
Contador++;
suma = suma + Convert.ToDecimal(ds.Rows[i]["DocInvoiceAmt"]);
}
}
dRow["CantFact"] = Contador;
dRow["Total"] = suma;
dtVFact.Rows.Add(dRow);
}
}
dtVerDatos.DataSource = dtVFact;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnBuscar_Click(object sender, EventArgs e)
{
try
{
BO.Metodo mt = new BO.Metodo();
DataTable dt = (DataTable)mt.Datos();
DataRow row;
DataTable dtVer = new DataTable();
dtVer.Columns.Add("Name", typeof(String));
dtVer.Columns.Add("ResaleID", typeof(String));
dtVer.Columns.Add("DateQuote", typeof(DateTime));
dtVer.Columns.Add("QuoteNum", typeof(int));
dtVer.Columns.Add("PartNum", typeof(int));
dtVer.Columns.Add("LineDesc", typeof(String));
dtVer.Columns.Add("ListPrice", typeof(decimal));
dtVer.Columns.Add("Euro", typeof(decimal));
dtVer.Columns.Add("Dolar", typeof(decimal));
dtVer.Columns.Add("Cop", typeof(decimal));
DataRow dRow;
DataTable ds = new DataTable();
ds = mt.Datos();
bool Existe = false;
if (ds.Rows.Count - 1 >= 0)
{
for (int i = 0; i <= ds.Rows.Count - 1; i++)
{
Existe = false;
if (dtVer.Rows.Count - 1 >= 0)
{
for (int j = 0; j <= dtVer.Rows.Count - 1; j++)
{
if (ds.Rows[i]["ResaleID"].ToString() == dtVer.Rows[j]["ResaleID"].ToString())
{
Existe = true;
break;
}
}
}
if (!Existe)
{
decimal Euro = 0;
decimal Dolar = 0;
decimal Cop = 0;
dRow = dtVer.NewRow();
dRow["Name"] = ds.Rows[i]["Name"].ToString();
dRow["ResaleID"] = ds.Rows[i]["ResaleID"].ToString();
dRow["DateQuote"] = Convert.ToDateTime(ds.Rows[i]["DateQuoted"]);
dRow["QuoteNum"] = ds.Rows[i]["QuoteNum"].ToString();
dRow["PartNum"] = ds.Rows[i]["PartNum"].Equals(System.DBNull.Value);
dRow["LineDesc"] = ds.Rows[i]["LineDesc"].ToString();
for (int h = 0; h <= ds.Rows.Count - 1; h++)
{
if (ds.Rows[i]["QuoteNum"].ToString() == ds.Rows[h]["QuoteNum"].ToString())
{
if (ds.Rows[h]["Moneda"].ToString() == "EUR")
{
if (!string.IsNullOrEmpty(ds.Rows[h]["ListPrice"].ToString()))
{
Euro += Convert.ToDecimal(ds.Rows[h]["ListPrice"]);
}
}
if (ds.Rows[h]["Moneda"].ToString() == "USD")
{
if (!string.IsNullOrEmpty(ds.Rows[h]["ListPrice"].ToString()))
{
Dolar += Convert.ToDecimal(ds.Rows[h]["ListPrice"]);
}
}
if (ds.Rows[h]["Moneda"].ToString() == "COP")
{
if (!string.IsNullOrEmpty(ds.Rows[h]["ListPrice"].ToString()))
{
Cop += Convert.ToDecimal(ds.Rows[h]["ListPrice"]);
}
}
}
}
dRow["ListPrice"] = Convert.ToDecimal(ds.Rows[i]["ListPrice"]);
dRow["Euro"] = Euro;
dRow["Dolar"] = Dolar;
dRow["Cop"] = Cop;
dtVer.Rows.Add(dRow);
}
} //
dgVerDatos.DataSource = dtVer;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
