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(); }