protected void GrdMvtos_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
{
GrdMvtos.EditIndex = -1; DSSM = (DataSet)ViewState["DSSM"]; GrdMvtos.DataSource = DSSM.Tables[2]; GrdMvtos.DataBind();
}
//**************** Ejecutar ***********************************
protected void BindEjecutar()
{
Idioma = (DataTable)ViewState["TablaIdioma"];
try
{
if (DdlPN.Text.Trim().Equals(""))
{
GrdStokAlma.DataSource = null; GrdStokAlma.DataBind(); return;
}
Cnx.SelecBD();
using (SqlConnection sqlConB = new SqlConnection(Cnx.GetConex()))
{
string VbPn = DdlPN.Text.Trim();
string VbSn = DdlSN.Text.Trim();
string VbLot = DdlLote.Text.Trim();
if (CkbAlterno.Checked == true)
{
VbPn = ""; VbSn = ""; VbLot = "";
}
CsTypExportarIdioma CursorIdioma = new CsTypExportarIdioma();
CursorIdioma.Alimentar("CURDATOSCONSULTA1", Session["77IDM"].ToString().Trim());
string VbTxtSql = "EXEC SP_TablasLogistica 5, @Rf,@Pn,@Sn,@Lt,'','','','','CURDATOSCONSULTA1',0,0,@ExpVlr,1,@Idm,@ICC,'01-01-1','02-01-1','03-01-1'";
sqlConB.Open();
using (SqlCommand SC = new SqlCommand(VbTxtSql, sqlConB))
{
SC.Parameters.AddWithValue("@Rf", ViewState["CodReferencia"]);
SC.Parameters.AddWithValue("@Pn", VbPn);
SC.Parameters.AddWithValue("@Sn", VbSn);
SC.Parameters.AddWithValue("@Lt", VbLot);
SC.Parameters.AddWithValue("@ExpVlr", ViewState["VblCE4"]);
SC.Parameters.AddWithValue("@Idm", Session["77IDM"]);
SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]);
using (SqlDataAdapter SDA = new SqlDataAdapter())
{
using (DataSet DSSM = new DataSet())
{
SDA.SelectCommand = SC;
SDA.Fill(DSSM);
DSSM.Tables[0].TableName = "Stock";
DSSM.Tables[1].TableName = "StockActual";
DSSM.Tables[2].TableName = "Mvtos";
DSSM.Tables[3].TableName = "Exprtr";
ViewState["DSSM"] = DSSM;
GrdStokAlma.DataSource = DSSM.Tables[0]; GrdStokAlma.DataBind();
TxtStockActual.Text = DSSM.Tables[1].Rows[0]["CantTtl"].ToString().Trim();
GrdMvtos.DataSource = DSSM.Tables[2]; GrdMvtos.DataBind();
}
}
}
}
}
catch (Exception Ex)
{
DataRow[] Result = Idioma.Select("Objeto= 'MensIncovCons'");
foreach (DataRow row in Result)
{
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "alert", "alert('" + row["Texto"].ToString() + "');", true);
} //
Cnx.UpdateErrorV2(Session["C77U"].ToString(), ViewState["PFileName"].ToString().Trim(), "UPDATE Detalle PPT", Ex.StackTrace.Substring(Ex.StackTrace.Length > 300 ? Ex.StackTrace.Length - 300 : 0, 300), Ex.Message, Session["77Version"].ToString(), Session["77Act"].ToString());
}
}
//**************** Detalle Movimeintos ***********************************
protected void GrdMvtos_RowEditing(object sender, GridViewEditEventArgs e)
{
GrdMvtos.EditIndex = e.NewEditIndex; DSSM = (DataSet)ViewState["DSSM"]; GrdMvtos.DataSource = DSSM.Tables[2]; GrdMvtos.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();
}
}
}
}
}
}
