protected void BindSrvcSinCrear(string Accion)
{
Idioma = (DataTable)ViewState["TablaIdioma"];
if (Accion.Equals("UPDATE"))
{
Cnx.SelecBD();
using (SqlConnection sqlConB = new SqlConnection(Cnx.GetConex()))
{
string VbTxtSql = "EXEC DetalleServiciosSinCrear @ICC";
sqlConB.Open();
using (SqlCommand SC = new SqlCommand(VbTxtSql, sqlConB))
{
// SC.Parameters.AddWithValue("@Us", Session["C77U"].ToString());
SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]);
using (SqlDataAdapter SDA = new SqlDataAdapter())
{
using (DataSet DS = new DataSet())
{
SDA.SelectCommand = SC;
SDA.Fill(DS);
DS.Tables[0].TableName = "SvcSinC";
DS.Tables[1].TableName = "SvcElem";
DS.Tables[2].TableName = "SvcHK";
ViewState["DS"] = DS;
}
}
}
}
}
DS = (DataSet)ViewState["DS"];
GrdDet.DataSource = DS.Tables[0]; GrdDet.DataBind();
}
protected void GrdDet_Sorting(object sender, GridViewSortEventArgs e)
{
if (ViewState["TblDetalle"] != null)
{
TblDetalle = (DataTable)ViewState["TblDetalle"];
DataView DV = new DataView(TblDetalle);
DV.Sort = e.SortExpression;
GrdDet.DataSource = DV;
GrdDet.DataBind();
}
}
protected void GrdBusq_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Asignar"))
{
Page.Title = ViewState["PageTit"].ToString().Trim();
Idioma = (DataTable)ViewState["TablaIdioma"];
GridViewRow RowG = (GridViewRow)(((ImageButton)e.CommandSource).NamingContainer);
GridViewRow gvr = (GridViewRow)((Control)e.CommandSource).NamingContainer;
Cnx.SelecBD();
using (SqlConnection sqlCon = new SqlConnection(Cnx.GetConex()))
{
sqlCon.Open();
using (SqlTransaction Transac = sqlCon.BeginTransaction())
{
string VBQuery = "EXEC SP_TablasMRO 17,@Dsc, @Us,@Ctd,'','','','','','',@ISv,@PP,@IDPS,0,0,@CC,'01-01-1','02-01-1','03-01-1'";
using (SqlCommand SC = new SqlCommand(VBQuery, sqlCon, Transac))
{
try
{
SC.Parameters.AddWithValue("@Dsc", ((TextBox)RowG.FindControl("TxtNomSvc")).Text.ToString().Trim());
SC.Parameters.AddWithValue("@Us", Session["C77U"].ToString());
SC.Parameters.AddWithValue("@Ctd", GrdBusq.DataKeys[gvr.RowIndex].Values["CodContador"].ToString());
SC.Parameters.AddWithValue("@ISv", GrdBusq.DataKeys[gvr.RowIndex].Values["IdSrvManto"].ToString());
SC.Parameters.AddWithValue("@PP", ViewState["PPT"]);
SC.Parameters.AddWithValue("@IDPS", ViewState["IdDetPropSrv"]);
SC.Parameters.AddWithValue("@CC", Session["!dC!@"]);
using (SqlDataAdapter SDA = new SqlDataAdapter())
{
using (DataSet DS = new DataSet())
{
Transac.Commit();
SDA.SelectCommand = SC;
SDA.Fill(DS);
DS.Tables[0].TableName = "SvcSinC";
DS.Tables[1].TableName = "SvcElem";
DS.Tables[2].TableName = "SvcHK";
ViewState["DS"] = DS;
}
DS = (DataSet)ViewState["DS"];
GrdDet.DataSource = DS.Tables[0]; GrdDet.DataBind();
MultVw.ActiveViewIndex = 0;
}
}
catch (Exception) { Transac.Rollback(); }
}
}
}
}
}
protected void IbtDesAprAll_Click(object sender, ImageClickEventArgs e)
{
Page.Title = ViewState["PageTit"].ToString().Trim();
if (ViewState["TblDetalle"] != null)
{
TblDetalle = (DataTable)ViewState["TblDetalle"];
if (TblDetalle.Rows.Count > 0)
{
foreach (DataRow Dtll in TblDetalle.Rows)
{
if (Dtll["TieneDoc"].ToString().Equals("N"))
{
Dtll["Aprobacion"] = "0";
}
}
}
}
GrdDet.DataSource = TblDetalle; GrdDet.DataBind();
}
protected void BindCuadroComprt(string Accion)
{
Idioma = (DataTable)ViewState["TablaIdioma"];
Cnx.SelecBD();
using (SqlConnection sqlCon = new SqlConnection(Cnx.GetConex()))
{
string VbTipoDoc = "SP", VbSDoc = "", VbPN = "", VbCotiza = "", VbPEPR = "0";
double NumPR_PT = 0;
bool VbRslt = double.TryParse(TxtBusqueda.Text.Trim(), out NumPR_PT);
VbSDoc = NumPR_PT.ToString();
VbPN = TxtBusqPN.Text.Trim();
if (RdbBusqCot.Checked == true)
{
VbTipoDoc = "CT"; VbCotiza = TxtBusqueda.Text.Trim();
}
if (RdbBusqSP.Checked == true)
{
VbTipoDoc = "SP"; VbCotiza = TxtBusqueda.Text.Trim();
}
if (RdbBusqPet.Checked == true)
{
VbTipoDoc = "PE"; VbPEPR = VbSDoc.Trim();
}
if (RdbBusqPPT.Checked == true)
{
VbTipoDoc = "PR"; VbPEPR = VbSDoc.Trim();
}
if (RdbBusqPN.Checked == true)
{
VbTipoDoc = "PN"; VbPN = TxtBusqPN.Text.Trim();
}
if (Accion.Equals("UPD"))
{
Cnx.SelecBD();
using (SqlConnection sqlConB = new SqlConnection(Cnx.GetConex()))
{
string VbTxtSql = "EXEC Consultas_General_Logistica 29, @Pn, @Doc, @TC, @DPEPR,@Idm,@ICC,'01-01-1','01-01-1'";
sqlConB.Open();
using (SqlCommand SC = new SqlCommand(VbTxtSql, sqlConB))
{
TblDetalle.Clear();
SC.Parameters.AddWithValue("@Pn", VbPN);
SC.Parameters.AddWithValue("@TC", VbTipoDoc);
SC.Parameters.AddWithValue("@Doc", VbCotiza.Trim());
SC.Parameters.AddWithValue("@DPEPR", VbPEPR.Trim());
SC.Parameters.AddWithValue("@Idm", Session["77IDM"]);
SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]);
SqlDataAdapter SDA = new SqlDataAdapter();
SDA.SelectCommand = SC;
SDA.Fill(TblDetalle);
ViewState["TblDetalle"] = TblDetalle;
}
}
}
}
TblDetalle = (DataTable)ViewState["TblDetalle"];
int VbNumReg = TblDetalle.Rows.Count;
if (TblDetalle.Rows.Count > 0)
{
GrdDet.DataSource = TblDetalle;
}
else
{
GrdDet.DataSource = null;
}
GrdDet.DataBind();
}
