public ModeloBEList GETListarModelos(ModeloBE ent)
{
ModeloBEList lista = new ModeloBEList();
IDataReader DReader = null;
try
{
using (Database db = new Database())
{
db.ProcedureName = "SRC_SPS_SEL_MODELO";
db.AddParameter("@co_modelo", DbType.String, ParameterDirection.Input, ent.co_modelo);
db.AddParameter("@no_modelo", DbType.String, ParameterDirection.Input, ent.no_modelo);
db.AddParameter("@nid_marca", DbType.String, ParameterDirection.Input, int.Parse(ent.nid_marca.ToString().Trim()));
db.AddParameter("@co_negocio", DbType.String, ParameterDirection.Input, ent.co_negocio);
db.AddParameter("@co_familia", DbType.String, ParameterDirection.Input, ent.co_familia);
db.AddParameter("@Estado", DbType.String, ParameterDirection.Input, ent.estado);
DReader = db.GetDataReader();
}
while (DReader.Read())
{
lista.Add(CrearEntidad_Parametros(DReader));
}
DReader.Close();
}
catch (Exception)
{
if (DReader != null && !DReader.IsClosed)
{
DReader.Close();
}
throw;
}
return(lista);
}
protected void btnBuscarWarrant_Click(object sender, ImageClickEventArgs e)
{
hf_exportaexcel.Value = "";
objEnt.co_modelo = txt_codmodelo.Text.Trim();
objEnt.no_modelo = txt_nommodelo.Text.Trim();
objEnt.nid_marca = int.Parse(ddl_marca.SelectedValue.ToString().Trim());
objEnt.co_negocio = ddl_negocio.SelectedValue.ToString().Trim();
objEnt.co_familia = ddl_familia.SelectedValue.ToString();
objEnt.estado = cboEstado.SelectedValue.ToString().Trim();
Session["MaestroModeloBE_FILTRO"] = objEnt;
Session["objEnt_bus"] = objEnt;
//---------
this.oMaestroModeloBEList = objNeg.GETListarModelos(objEnt);
if (oMaestroModeloBEList == null || oMaestroModeloBEList.Count == 0)
{
Session["MaestroModeloBE_FILTRO"] = null;
objEnt = null;
objEnt = new ModeloBE();
oMaestroModeloBEList.Add(objEnt);
}
else
{
hf_exportaexcel.Value = "1";
}
this.gdModelos.DataSource = oMaestroModeloBEList;
this.gdModelos.DataBind();
Session["ModeloBEList"] = oMaestroModeloBEList;
}
public ModeloBEList GetAllBandejas(Int32 idMarca, String codModelo, String nomModelo, String codEstado, Int32 idUsuario)
{
ModeloBEList lista = new ModeloBEList();
IDataReader DReader = null;
try
{
using (Database db = new Database())
{
db.ProcedureName = "sgsnet_sps_bandeja_modelo";
db.AddParameter("@vi_in_id_marca", DbType.Int32, ParameterDirection.Input, idMarca);
db.AddParameter("@vi_ch_cod_modelo", DbType.String, ParameterDirection.Input, codModelo);
db.AddParameter("@vi_va_nom_modelo", DbType.String, ParameterDirection.Input, nomModelo);
db.AddParameter("@vi_ch_cod_estado", DbType.String, ParameterDirection.Input, codEstado);
DReader = db.GetDataReader();
}
while (DReader.Read())
{
lista.Add(CrearEntidadBandeja(DReader));
}
DReader.Close();
}
catch
{
if (DReader != null && !DReader.IsClosed)
{
DReader.Close();
}
throw;
}
return(lista);
}
protected void gvModelo_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
oModelosBEList = (ModeloBEList)ViewState["oModelosBEList"];
this.gvModelo.DataSource = oModelosBEList;
this.gvModelo.PageIndex = e.NewPageIndex;
this.gvModelo.DataBind();
this.txhIdModelo.Value = String.Empty;
}
private void InicializaModelo()
{
this.oModelosBEList = new ModeloBEList();
this.oModelosBEList.Add(new ModeloBE());
ViewState["oModelosBEList"] = this.oModelosBEList;
this.gvModelo.DataSource = this.oModelosBEList;
this.gvModelo.DataBind();
this.cboEstadoModelo.SelectedValue = ConstanteBE.FL_ESTADO_ACTIVO;
}
protected void btnExcel_Click(object sender, ImageClickEventArgs e)
{
try
{
ModeloBL oMaestroModeloBL = new ModeloBL();
oMaestroModeloBL.ErrorEvent += new ModeloBL.ErrorDelegate(Master.Transaction_ErrorEvent);
objEnt.co_modelo = txt_codmodelo.Text.Trim();
objEnt.no_modelo = txt_nommodelo.Text.Trim();
objEnt.nid_marca = int.Parse(ddl_marca.SelectedValue.ToString().Trim());
objEnt.co_negocio = ddl_negocio.SelectedValue.ToString().Trim();
objEnt.co_familia = ddl_familia.SelectedValue.ToString();
objEnt.estado = cboEstado.SelectedValue.ToString().Trim();
this.oMaestroModeloBEList = oMaestroModeloBL.GETListarModelos(objEnt);
const string RUTA_DOCUMENTOS = ConstanteBE.RUTA_MANTENIMIENTO_SRC;
String carpeta = String.Empty, nombre = String.Empty, RutaFinal = String.Empty;
String ruta = Convert.ToString(ConfigurationManager.AppSettings["FileServerPath"]) + RUTA_DOCUMENTOS;
ruta = Utility.CrearCarpetaFileServer(ruta);
String fl_Ruta = ConstanteBE.FLAT_EXCEL_SRC;
ExportarExcelXml oExportarExcelXml = new ExportarExcelXml();
String archivo = oExportarExcelXml.GenerarExcelExportarModelo(this.oMaestroModeloBEList, ruta);
if (!archivo.Equals("-1"))
{
nombre = archivo;
carpeta = Utility.ObtenerCarpetaFileServer(nombre);
archivo = Convert.ToString(ConfigurationManager.AppSettings["FileServerPath"]) + RUTA_DOCUMENTOS + carpeta + @"\" + Convert.ToString(nombre.Trim());
if (File.Exists(archivo))
{
this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), String.Empty, "<script> window.open('../SGS_Comunes/SGS_VerExcelExpotable.aspx?nombreArchivo=" + nombre + "&flatRuta=" + fl_Ruta + "')</script>");
}
}
else
{
JavaScriptHelper.Alert(this, "'Problemas al generar el excel, consulte con el administrador.'", String.Empty);
}
}
catch (Exception ex)
{
Master.Web_ErrorEvent(this, ex);
JavaScriptHelper.Alert(this, ex.Message.ToString(), String.Empty);
}
}
private void CargarEntidad()
{
ModeloBEList objBEList = new ModeloBEList();
objBEList = (ModeloBEList)(Session["ModeloBEList"]);
if (objBEList != null)
{
for (int i = 0; i < objBEList.Count; i++)
{
if (objBEList[i].nid_modelo.ToString().Trim().Equals(Session["txh_nid_modelo"].ToString().Trim()))
{
objEnt = objBEList[i];
}
}
}
}
private void Inicializa()
{
CargarEstados();
CargarMarcas();
CargarNegocios(ddl_marca.SelectedValue.ToString().Trim());
objEnt.co_negocio = ddl_negocio.SelectedValue.ToString().Trim();
CargarFamiliaByNegocio(objEnt);
//-------------------------------------------------------------
//INICIALIZANDO EL GRIDVIEW
this.oMaestroModeloBEList = new ModeloBEList();
this.oMaestroModeloBEList.Add(new ModeloBE());
Session["ModeloBEList"] = oMaestroModeloBEList;
this.gdModelos.DataSource = this.oMaestroModeloBEList;
this.gdModelos.DataBind();
}
protected void btnBuscarModelo_Click(object sender, ImageClickEventArgs e)
{
ModeloBL oModelosBL = new ModeloBL();
oModelosBL.ErrorEvent += new ModeloBL.ErrorDelegate(Master.Transaction_ErrorEvent);
String codModelo = this.txtCodModelo.Text;
String nomModelo = this.txtNomModelo.Text;
String codEstado = this.cboEstadoModelo.SelectedValue;
this.oModelosBEList = oModelosBL.GetAllBandeja(this.idMarca, codModelo, nomModelo, codEstado, Profile.Usuario.Nid_usuario);
if (this.oModelosBEList == null || this.oModelosBEList.Count == 0)
{
JavaScriptHelper.Alert(this, Message.keyNoRegistros, "");
this.oModelosBEList.Add(new ModeloBE());
}
this.gvModelo.DataSource = this.oModelosBEList;
this.gvModelo.DataBind();
ViewState["oModelosBEList"] = this.oModelosBEList;
this.txhIdModelo.Value = String.Empty;
}
protected void gvModelo_Sorting(object sender, GridViewSortEventArgs e)
{
this.oModelosBEList = (ModeloBEList)ViewState["oModelosBEList"];
SortDirection indOrden = (SortDirection)ViewState["ordenLista"];
if (oModelosBEList != null)
{
if (indOrden == SortDirection.Ascending)
{
oModelosBEList.Ordenar(e.SortExpression, direccionOrden.Descending);
ViewState["ordenLista"] = SortDirection.Descending;
}
else
{
oModelosBEList.Ordenar(e.SortExpression, direccionOrden.Ascending);
ViewState["ordenLista"] = SortDirection.Ascending;
}
}
this.gvModelo.DataSource = oModelosBEList;
this.gvModelo.DataBind();
ViewState["oModelosBEList"] = oModelosBEList;
this.txhIdModelo.Value = String.Empty;
}
protected void gdModelos_Sorting(object sender, GridViewSortEventArgs e)
{
ModeloBEList oMaestroModeloBEList = (ModeloBEList)(Session["ModeloBEList"]);
SortDirection indOrden = (SortDirection)(Session["ordenGridTalleres"]);
txh_nid_modelo.Value = String.Empty;
if (oMaestroModeloBEList != null)
{
if (indOrden == SortDirection.Ascending)
{
oMaestroModeloBEList.Ordenar(e.SortExpression, direccionOrden.Descending);
Session["ordenGridTalleres"] = SortDirection.Descending;
}
else
{
oMaestroModeloBEList.Ordenar(e.SortExpression, direccionOrden.Ascending);
Session["ordenGridTalleres"] = SortDirection.Ascending;
}
}
gdModelos.DataSource = oMaestroModeloBEList;
gdModelos.DataBind();
Session["ModeloBEList"] = oMaestroModeloBEList;
}
protected void Page_PreRender(object sender, EventArgs e)
{
//Bandeja de perfiles
ModeloBEList oMaestroModeloBEList = (ModeloBEList)(Session["ModeloBEList"]);
if (oMaestroModeloBEList != null &&
this.gdModelos != null &&
this.gdModelos.Rows.Count > 0 &&
this.gdModelos.PageCount > 1)
{
GridViewRow oRow = this.gdModelos.BottomPagerRow;
if (oRow != null)
{
Label oTotalReg = new Label();
oTotalReg.Text = String.Format("Total Reg. {0}", (oMaestroModeloBEList.Count));
oRow.Cells[0].Controls.AddAt(0, oTotalReg);
Table oTablaPaginacion = (Table)oRow.Cells[0].Controls[1];
oTablaPaginacion.CellPadding = 0;
oTablaPaginacion.CellSpacing = 0;
}
}
}
