private void Buscar()
{
int total = 0;
try
{
IProveedor prov = ProveedorFactory.GetProveedor();
DsProveedor ds = prov.GetProveedoresConsultaDataSet();
string filtro = "Documento LIKE '" + this.documento + "%' AND RazonSocial LIKE '" + this.razonSocial + "%'";
//Agregar que si no le paso una agencia actual, no la tenga que buscar.
if (this.proveedorActual != null && this.proveedorActual.Length > 0)
{
filtro += " AND ProveedorID <> " + this.proveedorActual;
}
DsProveedor.DatosRow[] drLista = (DsProveedor.DatosRow[])ds.Datos.Select(filtro);
total = drLista.Length;
if (total > 0)
{
if (total == 1)
{
DsProveedor.DatosRow dr = drLista[0];
this.txtProveedorID.Text = dr.ProveedorID.ToString();
this.txtDocumento.Text = dr.Documento;
this.txtRazonSocial.Text = dr.RazonSocial;
this.txtErrorMsg.Text = "";
this.txtOpen.Text = "";
}
else
{
this.txtDocumento.Text = this.documento;
this.txtRazonSocial.Text = this.razonSocial;
this.txtOpen.Text = "S";
this.txtFiltro.Text = this.filtroEspecial;
this.txtProveedorActual.Text = this.proveedorActual;
}
}
else
{
this.txtProveedorID.Text = "";
this.txtErrorMsg.Text = "No se encontraron datos.";
this.txtOpen.Text = "";
}
}
catch (Exception ex)
{
this.txtErrorMsg.Text = "Error al consultar datos de agencias: " + ex.Message;
}
}
public void Consultar()
{
try
{
DsProveedor ds = new DsProveedor();
SqlParameter pProveedorId = new SqlParameter("@ProveedorID", Utiles.BaseDatos.IntToSql(ProveedorID));
Config.Conexion.LlenarTypeDataSet(ds.Datos, System.Data.CommandType.StoredProcedure, "ProveedorONE", pProveedorId);
if (ds.Datos.Count == 1)
{
DsProveedor.DatosRow dr = ds.Datos.FindByProveedorID(ProveedorID);
RazonSocial = dr.RazonSocial;
Documento = dr.Documento;
}
}
catch (Exception ex)
{
throw ex;
}
}
private void dtgProveedores_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
if (e.CommandName == "Select")
{
int indice = e.Item.DataSetIndex;
BindGrid();
DsProveedor.DatosRow[] drLista = (DsProveedor.DatosRow[])dtgProveedores.DataSource;
if (drLista == null)
{
return;
}
if (drLista.Length == 0)
{
return;
}
DsProveedor.DatosRow dr = drLista[indice];
if (dr == null)
{
return;
}
int proveedorID = dr.ProveedorID;
string documento = dr.Documento;
string razonSocial = dr.RazonSocial;
StringBuilder scriptString = new StringBuilder();
scriptString.Append("<script language='javascript'>\n");
scriptString.Append("window.dialogArguments.ProveedorID = '" + proveedorID.ToString() + "';\n");
scriptString.Append("window.dialogArguments.Documento = '" + documento + "';\n");
scriptString.Append("window.dialogArguments.RazonSocial = '" + razonSocial + "';\n");
scriptString.Append("window.returnValue = true;\n");
scriptString.Append("window.close();\n");
scriptString.Append("</script>");
Page.RegisterClientScriptBlock("scriptModalProveedor", scriptString.ToString());
}
}
