protected void Sacar_Letras()
{
Interprete inter = new Interprete();
DataRow fila;
if (Request.QueryString["tipo"] == "C")
{
for (int i = 0; i < ((ArrayList)Session["facs"]).Count; i++)
{
double valor = Math.Round(Convert.ToDouble(DBFunctions.SingleData("SELECT mfac_valofact+mfac_valoiva FROM dbxschema.mfacturacliente WHERE pdoc_codigo='" + (((ArrayList)Session["facs"])[i].ToString().Split('-'))[0] + "' AND mfac_numedocu=" + (((ArrayList)Session["facs"])[i].ToString().Split('-'))[1] + "")), 2);
string letra = inter.Letras(valor.ToString());
if (tbLetras == null)
{
this.Preparar_tbLetras();
}
fila = tbLetras.NewRow();
fila[0] = (((ArrayList)Session["facs"])[i].ToString().Split('-'))[0];
fila[1] = Convert.ToInt32((((ArrayList)Session["facs"])[i].ToString().Split('-'))[1]);
fila[2] = valor;
fila[3] = letra;
tbLetras.Rows.Add(fila);
}
ds.Tables.Add(tbLetras);
ds.AcceptChanges();
}
else if (Request.QueryString["tipo"] == "P")
{
for (int i = 0; i < ((ArrayList)Session["facs"]).Count; i++)
{
double valor = Math.Round(Convert.ToDouble(DBFunctions.SingleData("SELECT mfac_valofact+mfac_valoiva FROM dbxschema.mfacturaproveedor WHERE pdoc_codiordepago='" + (((ArrayList)Session["facs"])[i].ToString().Split('-'))[0] + "' AND mfac_numeordepago=" + (((ArrayList)Session["facs"])[i].ToString().Split('-'))[1] + "")), 2);
string letra = inter.Letras(valor.ToString());
if (tbLetras == null)
{
this.Preparar_tbLetras();
}
fila = tbLetras.NewRow();
fila[0] = (((ArrayList)Session["facs"])[i].ToString().Split('-'))[0];
fila[1] = Convert.ToInt32((((ArrayList)Session["facs"])[i].ToString().Split('-'))[1]);
fila[2] = valor;
fila[3] = letra;
tbLetras.Rows.Add(fila);
}
ds.Tables.Add(tbLetras);
ds.AcceptChanges();
}
}
