public SqlDataReader BalanceClienteReporteSUMA()
{
string sql = String.Format("SELECT CONVERT(varchar,CAST(SUM(CL_CAPITAL) AS MONEY),1) AS CAPITAL FROM clientes where CL_ACTUAL>0");
SqlDataReader dtp = dbc.query_single(sql);
return(dtp);
}
public void Load(string gid)
{
SqlDataReader q = dbc.query_single(String.Format("SELECT * FROM gastos where GASTOID={0}", gid));
if (q.Read())
{
FECHA = q["FECHA"].ToString();
GASTOID = int.Parse(q["GASTOID"].ToString());
DETALLE = q["DETALLE"].ToString();
CONCEPTO = q["CONCEPTO"].ToString();
CANTIDAD = Double.Parse(q["CANTIDAD"].ToString());
}
q.Close();
}
public void Recibo(string reciboID)
{
string today = DateTime.Now.Day + "-" + DateTime.Now.Month + "-" + DateTime.Now.Year;
SqlDataReader q = dbc.query_single("SELECT c.CL_NOMBRE, r.RECIBOID ,r.PRESTAMOID ,CONVERT(VARCHAR(15), r.HE_FECHA, 105) AS FECHA ,r.CL_CODIGO ,(r.HE_MONTO + r.HE_DESC + r.HE_MORA) As CUOTA ,r.HE_CONCEP FROM recibos r inner join clientes c on (c.CL_CODIGO=r.CL_CODIGO ) where RECIBOID=" + reciboID);
if (q.Read())
{
rlines[0] = company;
rlines[1] = String.Format("{0} \t\t\t\t\t Fecha: {1}", address, q["FECHA"].ToString());
rlines[2] = string.Format("Tel.: {0}, Cel.: {1}", phone, cell);
rlines[3] = "____________________________________________ ";
rlines[4] = "\t\t\tRecibo De Ingreso ";
rlines[5] = "Recibo No.: " + q["RECIBOID"].ToString() + " Fecha.: " + q["FECHA"].ToString() + " Prestamo.: " + q["PRESTAMOID"].ToString() + " Cliente.: " + q["CL_CODIGO"].ToString();
rlines[6] = "Nombre.......: " + q["CL_NOMBRE"].ToString();
string[] cuotastr = q["CUOTA"].ToString().Split('.'); // split the quota into whole amount and cents
long monto = long.Parse(cuotastr[0]);
string montocent = cuotastr[1];
rlines[7] = String.Format("Monto Ingreso: {0}Pesos Con {1}/100", Number2Word(monto), montocent).ToUpper();
rlines[8] = "RD$..........: " + q["CUOTA"].ToString();
rlines[9] = "Concepto.....: " + q["HE_CONCEP"].ToString();
rlines[10] = "Valido Si Esta Debidamente Firmado y Cellado\t\t\t____________________";
rlines[11] = "1. Original Cliente / 2. Caja Ingreso / 3. Expediente Cliente";
/// print data
PrintDocument pd = new PrintDocument();
// set printing document margins
pd.DefaultPageSettings.Margins.Top = 25;
pd.DefaultPageSettings.Margins.Left = 25;
pd.DefaultPageSettings.Margins.Right = 25;
pd.PrintPage += new PrintPageEventHandler(Recibo_PrintPage);
// Print the document.
pd.Print();
pd.Dispose();
}
q.Close();
// return lines;
}
public SqlDataReader Info(string pid)
{
SqlDataReader q = dbc.query_single("SELECT c.CL_NOMBRE, p.PRESTAMOID , p.CO_FECHA AS FECHA ,p.CL_CODIGO,p.CO_CAPITAL, p.CO_INTERES,p.CO_CANPAG, p.CO_TIPPAG FROM prestamos p inner join clientes c on (c.CL_CODIGO=p.CL_CODIGO ) where p.PRESTAMOID=" + pid);
return(q);
}
public void ModificarCliente()
{
dbc.query_single(String.Format("UPDATE clientes SET CL_NOMBRE='{1}', CL_DIREC1='{2}', CL_DIREC2='{3}',CL_TELEF1='{4}',CL_TELEF2='{5}',CL_TELEF3='{6}',CL_RAZON='{7}',ZO_CODIGO='{8}' WHERE CL_CODIGO='{0}'", CODIGO, NOMBRE, DIREC1, DIREC2, TELEF1, TELEF2, TELEF3, RAZON, Z_CODIGO));
}
