protected void Traerdatos(string Prmtr, string Accion)
{
Idioma = (DataTable)ViewState["TablaIdioma"];
if (Accion.Equals("UPDATE"))
{
Cnx.SelecBD();
using (SqlConnection sqlConB = new SqlConnection(Cnx.GetConex()))
{
string VbTxtSql = "EXEC SP_PANTALLA_Bodega 4,'','','','SELECT',@Prmtr,0,0,@ICC,'01-1-2009','01-01-1900','01-01-1900'";
sqlConB.Open();
using (SqlCommand SC = new SqlCommand(VbTxtSql, sqlConB))
{
SC.Parameters.AddWithValue("@Prmtr", Prmtr);
SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]);
using (SqlDataAdapter SDA = new SqlDataAdapter())
{
using (DataSet DSTDet = new DataSet())
{
SDA.SelectCommand = SC;
SDA.Fill(DSTDet);
DSTDet.Tables[0].TableName = "Bodega";
DSTDet.Tables[1].TableName = "Tercero";
DSTDet.Tables[2].TableName = "Consult";
ViewState["DSTDet"] = DSTDet;
}
}
}
}
}
DSTDet = (DataSet)ViewState["DSTDet"];
string VbCodAnt = DdlBusq.Text.Trim();
DdlBusq.DataSource = DSTDet.Tables[0];
DdlBusq.DataTextField = "CodBodega";
DdlBusq.DataValueField = "CodidBodega";
DdlBusq.DataBind();
DdlBusq.Text = VbCodAnt.Equals("0") ? @Prmtr : VbCodAnt;
DdlCliente.DataSource = DSTDet.Tables[1];
DdlCliente.DataTextField = "RazonSocial";
DdlCliente.DataValueField = "IdTercero";
DdlCliente.DataBind();
DataRow[] Result = DSTDet.Tables[2].Select("CodidBodega = " + DdlBusq.Text.Trim());
foreach (DataRow DR in Result)
{
TxtCod.Text = HttpUtility.HtmlDecode(DR["CodBodega"].ToString().Trim());
TxtNombre.Text = HttpUtility.HtmlDecode(DR["Nombre"].ToString().Trim());
DdlCliente.Text = HttpUtility.HtmlDecode(DR["CodTercero"].ToString().Trim());
}
}
private void GetClients()
{
SqlLogicDb DataBase = new SqlLogicDb();
DataTable Tabla = new DataTable();
Tabla = DataBase.ConsultarNameCliente();
DdlCliente.DataSource = Tabla;
DdlCliente.DataTextField = "NombreCliente";
DdlCliente.DataValueField = "CodCli";
DdlCliente.DataBind();
DdlCliente.Items.Insert(0, new ListItem("Seleccione", "0", true));
}
protected void BindDDdl(string Accion)
{
if (Accion.Equals("UPDATE"))
{
Cnx.SelecBD();
using (SqlConnection sqlConB = new SqlConnection(Cnx.GetConex()))
{
string VbTxtSql = "EXEC SP_PANTALLA_Sal_consignacion 5,'','','','',0,0,0,@ICC,'01-1-2009','01-01-1900','01-01-1900'";
sqlConB.Open();
using (SqlCommand SC = new SqlCommand(VbTxtSql, sqlConB))
{
SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]);
using (SqlDataAdapter SDA = new SqlDataAdapter())
{
using (DataSet DSTDdl = new DataSet())
{
SDA.SelectCommand = SC;
SDA.Fill(DSTDdl);
DSTDdl.Tables[0].TableName = "Bodega";
DSTDdl.Tables[1].TableName = "Cliente";
ViewState["DSTDdl"] = DSTDdl;
}
}
}
}
}
DSTDdl = (DataSet)ViewState["DSTDdl"];
DdlBodega.DataSource = DSTDdl.Tables[0];
DdlBodega.DataTextField = "Bodega";
DdlBodega.DataValueField = "CodBodega";
DdlBodega.DataBind();
DdlCliente.DataSource = DSTDdl.Tables[1];
DdlCliente.DataTextField = "RazonSocial";
DdlCliente.DataValueField = "CodTercero";
DdlCliente.DataBind();
}
