protected void BindPn(string CodHk)
{
string LtxtSql = string.Format("EXEC SP_PANTALLA_ADVICE 16,'','HIR','{0}','PN',0,0,0,{1},'01-1-2009','01-01-1900','01-01-1900'", CodHk.Trim(), Session["!dC!@"]);
DdlPN.DataSource = Cnx.DSET(LtxtSql);
DdlPN.DataTextField = "PN";
DdlPN.DataValueField = "Codigo";
DdlPN.DataBind();
}
protected void BindPn()
{
string LtxtSql = string.Format("EXEC SP_PANTALLA_ADVICE 16,'','','','PN',0,0,0,{0},'01-1-2009','01-01-1900','01-01-1900'", Session["!dC!@"]);
DdlPN.DataSource = Cnx.DSET(LtxtSql);
DdlPN.DataMember = "Datos";
DdlPN.DataTextField = "PN";
DdlPN.DataValueField = "Codigo";
DdlPN.DataBind();
}
protected void BindBDdlPN(string Pn)
{
DSTPSL = (DataSet)ViewState["DSTPSL"];
if (DSTPSL.Tables["PN"].Rows.Count > 0)
{
DdlPN.DataSource = DSTPSL.Tables[0];
DdlPN.DataTextField = "PN";
DdlPN.DataValueField = "Codigo";
DdlPN.DataBind();
}
}
protected void BindDataDdl(string Accion)
{
DST = (DataSet)ViewState["DST"];
string VbPrmtr = "";
if (!Accion.Equals(""))
{
VbPrmtr = TxtRef.Text;
}
DdlPN.DataSource = DST.Tables[3];
DdlPN.DataTextField = "PN";
DdlPN.DataValueField = "Codigo";
DdlPN.DataBind();
DdlPN.Text = ViewState["PN"].ToString().Trim();
}
protected void BindPn(string Tipo)
{
Cnx.SelecBD();
using (SqlConnection sqlCon = new SqlConnection(Cnx.GetConex()))
{
string LtxtSql = "EXEC SP_PANTALLA_ADVICE 16,'','HIRSC',@Tp,'PN',0,0,0,@ICC,'01-1-2009','01-01-1900','01-01-1900'";
sqlCon.Open();
using (SqlCommand SC = new SqlCommand(LtxtSql, sqlCon))
{
SC.Parameters.AddWithValue("@Tp", Tipo.Trim());
SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]);
SqlDataAdapter SDA = new SqlDataAdapter();
SDA.SelectCommand = SC;
SDA.Fill(DTPN);
ViewState["DTPN"] = DTPN;
DdlPN.DataSource = DTPN;
DdlPN.DataTextField = "PN";
DdlPN.DataValueField = "Codigo";
DdlPN.DataBind();
}
}
}
