protected void BindSn(string PN)
{
Cnx.SelecBD();
using (SqlConnection sqlConB = new SqlConnection(Cnx.GetConex()))
{
string VbTxtSql = "EXEC SP_PANTALLA_ADVICE 16, @P,'','','SN',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("@P", PN.Trim());
SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]);
using (SqlDataAdapter SDA = new SqlDataAdapter())
{
using (DataSet DSTDdl = new DataSet())
{
SDA.SelectCommand = SC;
SDA.Fill(DSTDdl);
DdlSN.DataSource = DSTDdl.Tables[0];
DdlSN.DataTextField = "SN";
DdlSN.DataValueField = "Codigo";
DdlSN.DataBind();
}
}
}
}
}
protected void DdlPN_TextChanged(object sender, EventArgs e)
{
Cnx.SelecBD();
using (SqlConnection sqlConB = new SqlConnection(Cnx.GetConex()))
{
string VbTxtSql = "EXEC SP_PANTALLA_ADVICE 16, @P,'','','SN',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("@P", DdlPN.Text);
SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]);
using (SqlDataAdapter SDA = new SqlDataAdapter())
{
using (DataSet DSTDdl = new DataSet())
{
SDA.SelectCommand = SC;
SDA.Fill(DSTDdl);
DdlSN.DataSource = DSTDdl.Tables[0];
DdlSN.DataTextField = "SN";
DdlSN.DataValueField = "Codigo";
DdlSN.DataBind();
DdlModel.DataSource = DSTDdl.Tables[1];
DdlModel.DataTextField = "Descripcion";
DdlModel.DataValueField = "CodModelo";
DdlModel.DataBind();
}
}
}
}
}
protected void BindSn(string PN)
{
string LtxtSql = string.Format("EXEC SP_PANTALLA_ADVICE 16,'{0}','','','SN',0,0,0,{1},'01-1-2009','01-01-1900','01-01-1900'", PN.Trim(), Session["!dC!@"]);
DdlSN.DataSource = Cnx.DSET(LtxtSql);
DdlSN.DataTextField = "SN";
DdlSN.DataValueField = "Codigo";
DdlSN.DataBind();
}
protected void BindBDdlSN(string Pn, string Sn)
{
DSTPSL = (DataSet)ViewState["DSTPSL"];
if (DSTPSL.Tables["SN"].Rows.Count > 0)
{
DdlSN.DataSource = DSTPSL.Tables[1];
DdlSN.DataTextField = "SN";
DdlSN.DataValueField = "Codigo";
DdlSN.DataBind();
}
}
protected void BindBusPn(string PN)
{
DSTPSL = (DataSet)ViewState["DSTPSL"];
DataRow[] DR; DataTable DT = new DataTable();
GrdAlterno.DataSource = null; GrdAlterno.DataBind();
GrdStokAlma.DataSource = null; GrdStokAlma.DataBind();
GrdMvtos.DataSource = null; GrdMvtos.DataBind();
DR = DSTPSL.Tables[0].Select("Codigo ='" + PN + "'");
if (Cnx.ValidaDataRowVacio(DR))
{
DT = DR.CopyToDataTable();
TxtTipo.Text = DT.Rows[0]["DescTipo"].ToString().Trim();
TxtDescrPn.Text = DT.Rows[0]["Descripcion"].ToString().Trim();
ViewState["CodReferencia"] = DT.Rows[0]["CodReferencia"].ToString().Trim();
LblTitAlterno.Text = ViewState["IdimaPnALter"].ToString().Trim() + " [" + ViewState["CodReferencia"] + "]";
switch (DT.Rows[0]["Identf"].ToString().Trim())
{
case "SN":
DR = DSTPSL.Tables[1].Select("PN ='" + PN + "' OR Codigo = ''");
if (Cnx.ValidaDataRowVacio(DR))
{
DT = DR.CopyToDataTable();
DdlSN.DataSource = DT;
DdlSN.DataTextField = "SN";
DdlSN.DataValueField = "Codigo";
}
else
{
DdlSN.DataSource = null;
}
DdlSN.DataBind();
DR = DSTPSL.Tables[2].Select("Codigo = ''");
if (Cnx.ValidaDataRowVacio(DR))
{
DT = DR.CopyToDataTable();
DdlLote.DataSource = DT;
DdlLote.DataTextField = "LOTE";
DdlLote.DataValueField = "Codigo";
DdlLote.DataBind();
}
break;
case "LOTE":
DR = DSTPSL.Tables[2].Select("PN ='" + PN + "' OR Codigo = ''");
if (Cnx.ValidaDataRowVacio(DR))
{
DT = DR.CopyToDataTable();
DdlLote.DataSource = DT;
DdlLote.DataTextField = "LOTE";
DdlLote.DataValueField = "Codigo";
}
else
{
DdlLote.DataSource = null;
}
DdlLote.DataBind();
DR = DSTPSL.Tables[1].Select("Codigo = ''");
if (Cnx.ValidaDataRowVacio(DR))
{
DT = DR.CopyToDataTable();
DdlSN.DataSource = DT;
DdlSN.DataTextField = "SN";
DdlSN.DataValueField = "Codigo";
DdlSN.DataBind();
}
break;
default:
DR = DSTPSL.Tables[2].Select("Codigo = ''");
if (Cnx.ValidaDataRowVacio(DR))
{
DT = DR.CopyToDataTable();
DdlLote.DataSource = DT;
DdlLote.DataTextField = "LOTE";
DdlLote.DataValueField = "Codigo";
DdlLote.DataBind();
}
DR = DSTPSL.Tables[1].Select("Codigo = ''");
if (Cnx.ValidaDataRowVacio(DR))
{
DT = DR.CopyToDataTable();
DdlSN.DataSource = DT;
DdlSN.DataTextField = "SN";
DdlSN.DataValueField = "Codigo";
DdlSN.DataBind();
}
break;
}
Cnx.SelecBD();
using (SqlConnection sqlConB = new SqlConnection(Cnx.GetConex()))
{
string VbTxtSql = "EXEC SP_PANTALLA_ConsultaMovimiento 14,@CRf,'','','',0,0,@Idm,@ICC,'01-1-2009','01-01-1900','01-01-1900'";
sqlConB.Open();
using (SqlCommand SC = new SqlCommand(VbTxtSql, sqlConB))
{
SC.Parameters.AddWithValue("@CRf", ViewState["CodReferencia"]);
SC.Parameters.AddWithValue("@Idm", Session["77IDM"]);
SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]);
using (SqlDataAdapter SDA = new SqlDataAdapter())
{
using (DataTable DTA = new DataTable())
{
SDA.SelectCommand = SC;
SDA.Fill(DTA);
GrdAlterno.DataSource = DTA; GrdAlterno.DataBind();
}
}
}
}
}
}