protected void SetHeader()
{
int numRows = 2;
int numCells = 3;
//string logo=DBFunctions.SingleData("SELECT CEMP_LOGO FROM CEMPRESA;");
string logo = DBFunctions.SingleDataGlobal("SELECT GEMP_iCONO FROM GEMPRESA WHERE GEMP_NOMBRE='" + GlobalData.getEMPRESA() + "';");
for (int k = 0; k < numRows; k++)
{
TableRow r = new TableRow();
for (int m = 0; m < numCells; m++)
{
TableCell c = new TableCell();
if (k == 0 && m == 0)
{
c.VerticalAlign = VerticalAlign.Top;
if (logo.Length > 0)
{
//c.Text = "<IMG src=\"../rpt/"+logo+"\" border=\"0\">";
c.Text = "<IMG src=\"" + logo + "\" border=\"0\">";
}
else
{
c.Text = "<p> </p>";
}
}
if (k == 0 && m == 1)
{
c.Text = "<center>" + DBFunctions.SingleData("SELECT cemp_nombre FROM cempresa") + "</center>";
c.Text += "<center>NIT: " + DBFunctions.SingleData("SELECT mnit_nit FROM cempresa") + "</center>";
c.Text += "<center>" + DBFunctions.SingleData("SELECT mn.mnit_direccion FROM cempresa ce, mnit mn where ce.mnit_nit=mn.mnit_nit;") + "</center>";
c.Text += "<center>Ciudad: " + DBFunctions.SingleData("SELECT pc.pciu_nombre FROM cempresa ce, pciudad pc where ce.cemp_ciudad=pc.pciu_codigo;") + "</center>";
c.Text += "<center>PBX: " + DBFunctions.SingleData("SELECT mn.mnit_telefono FROM cempresa ce, mnit mn where ce.mnit_nit=mn.mnit_nit;") + "</center>";
}
if (k == 0 && m == 2)
{
c.Text = "<div style='text-align:right'>SC-PRO-001</div><p><div style='text-align:right'>DEFINICION DEL PROCESO</div></p>";
}
if (k == 1 && m == 0)
{
c.Text = "<p> </p>";
}
if (k == 1 && m == 1)
{
c.Text = "<center>" + DBFunctions.SingleData(SQLParser.GetTableNameDescription(table)) + "</center>";
}
//c.Text = "<center>"+DBFunctions.SingleData("SELECT remarks FROM SYSIBM.SYSTABLES WHERE name='"+table+"'")+"</center>";
if (k == 1 && m == 2)
{
c.Text = "<div style='text-align:right'>Procesado En : " + DateTime.Now.ToShortDateString() + "</div>";
}
c.Width = new Unit("33%");
r.Cells.Add(c);
}
tbFormHeader.Rows.Add(r);
}
phForm.Controls.Add(tbFormHeader);
}
protected void GetSchema()
{
//ds = DBFunctions.Request(ds, IncludeSchema.NO, "SELECT remarks, name, coltype, length, nulls, scale, default, generated FROM sysibm.syscolumns WHERE tbname='" +
// table + "'; SELECT fkcolnames, reftbname, pkcolnames FROM sysibm.sysrels WHERE tbname='" +
// table + "'");
ds = DBFunctions.Request(ds, IncludeSchema.NO, SQLParser.GetTableStructureExtended(table) +
";" + SQLParser.GetTableForeign(table));
ds = DBFunctions.Request(ds, IncludeSchema.NO, "SELECT * FROM " + table + " FETCH FIRST 1 ROWS ONLY ");
}
public void SendMail(Object Sender, ImageClickEventArgs E)
{
MailMessage MyMail = new MailMessage();
MyMail.From = ConfigurationManager.AppSettings["EmailFrom"];
MyMail.To = tbEmail.Text;
//MyMail.Subject = "Proceso : "+DBFunctions.SingleData("SELECT remarks FROM SYSIBM.SYSTABLES WHERE name='"+table+"'");
MyMail.Subject = "Proceso : " + DBFunctions.SingleData(SQLParser.GetTableNameDescription(table));
MyMail.Body = (RenderHtml());
MyMail.BodyFormat = MailFormat.Html;
try{
//SmtpMail.SmtpServer="ecasltda.com";
SmtpMail.Send(MyMail);
}
catch (Exception e) {
lbInfo.Text = e.ToString();
}
}
