protected void btnrespforn_Click(object sender, EventArgs e)
{
DataAccess Conn = (DataAccess)Session["DBUserConn"];
QueryHelper QHS;
QHS = Conn.GetQueryHelper();
string filter;
if (userkind.SelectedValue == "1")
{
// Responsabili
filter = QHS.AppAnd(QHS.CmpEq("active", "S"), QHS.IsNotNull("userweb"), QHS.CmpNe("userweb", ""));
DataTable DT = Conn.RUN_SELECT("manager", "idman,title,userweb", "title asc", filter, null, false);
if (DT == null || DT.Rows.Count == 0)
{
return;
}
RenderManagersTable(DT);
}
if (userkind.SelectedValue == "2")
{
// Fornitori
string query = "select registryreference.idregistryreference as idregistryreference, registry.idreg as idreg,registry.title as Anagrafica, registryreference.referencename as Riferimento, registryreference.userweb as Login ";
query += " from registry join registryreference on (registry.idreg=registryreference.idreg) where registry.active='S' ";
query += " and userweb is not null and userweb <>''";
DataTable DT = Conn.SQLRunner(query);
if (DT == null || DT.Rows.Count == 0)
{
return;
}
RenderRegistryTable(DT);
}
}
