1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212
|
Partial Class test
Inherits System.Web.UI.Page
Private dmCS As New DataManager("CS")
Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init
ChargeSDS()
End Sub
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
ConstruireGV()
AfficheTable("rien")
End Sub
Protected Sub gvCampagne_PageIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles gvCampagne.PageIndexChanged
ChargeSDS()
End Sub
Protected Sub gvCampagne_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles gvCampagne.RowCommand
Dim IdCell As TableCell
If IsNumeric(e.CommandArgument) Then
IdCell = CType(gvCampagne.Rows(Convert.ToInt32(e.CommandArgument)), GridViewRow).Cells(0)
Else
IdCell = gvCampagne.Rows(0).Cells(0)
AfficheTable("rien")
End If
Select Case e.CommandName
Case "first", "next", "last", "prev"
AfficheTable("rien")
ChargeSDS()
Case "Actif"
dmCS.ExecuterRequeteSimple("EXEC SPEC_Campagne_Actif " & IdCell.Text)
End Select
End Sub
Sub AfficheTable(ByVal tab As String)
If tab <> "rien" Then
CType(FormuModif.FindControl(tab), Table).Visible = True
End If
End Sub
Sub ConstruireGV()
Dim idcampagne, libelle, objet, regie, boolactif As New BoundField
With idcampagne
.HeaderText = "ID"
.DataField = "Id_Campagne"
End With
With libelle
.HeaderText = "Libellé"
.DataField = "Libelle"
.SortExpression = "Libelle"
End With
With objet
.HeaderText = "Objet"
.DataField = "Objet"
.SortExpression = "Objet"
End With
With regie
.HeaderText = "Régie"
.DataField = "Regie"
.SortExpression = "Regie"
End With
Dim apercu, actif As New TemplateField
With apercu
.ItemTemplate = New TemplatePopup(DataControlRowType.DataRow, "Id_Campagne", "Apercu")
.HeaderTemplate = New TemplatePopup(DataControlRowType.Header, "Aperçu", "Apercu")
End With
With actif
.ItemTemplate = New TemplatePopup(DataControlRowType.DataRow, "Actif", "Actif")
.HeaderTemplate = New TemplatePopup(DataControlRowType.Header, "Actif", "Actif")
End With
Dim test, envoi, segment, modif As New ButtonField
With test
.HeaderText = "Test"
.ButtonType = ButtonType.Image
.ImageUrl = "~/App_Themes/" & GetNomsite() & "/lettresinfo.png"
.CommandName = "Test"
End With
With envoi
.HeaderText = "Envoi"
.ButtonType = ButtonType.Image
.ImageUrl = "~/App_Themes/" & GetNomsite() & "/lettresinfo.png"
.CommandName = "Envoi"
End With
With segment
.HeaderText = "@"
.ButtonType = ButtonType.Image
.ImageUrl = "~/App_Themes/" & GetNomsite() & "/lettresinfo.png"
.CommandName = "Segment"
End With
With modif
.HeaderText = "Modif"
.ButtonType = ButtonType.Image
.ImageUrl = "~/App_Themes/" & GetNomsite() & "/modifier_16.png"
.CommandName = "Modif"
End With
Dim StatutEnvoi As New ImageField
With StatutEnvoi
.HeaderText = "Envoi"
.DataImageUrlField = "Envoi"
.DataImageUrlFormatString = "~/App_Themes/" & GetNomsite() & "/{0}.png"
End With
With gvCampagne
With .Columns
.Clear()
.Add(idcampagne)
.Add(libelle)
.Add(objet)
.Add(regie)
.Add(apercu)
'.Add(test)
'.Add(envoi)
'.Add(StatutEnvoi)
.Add(actif)
'.Add(modif)
End With
.DataSourceID = "sdsGvCampagne"
End With
End Sub
Sub ChargeSDS()
sdsGvCampagne.SelectCommand = "EXEC dbo.SPEC_ListeCampagne '" & GetApplicationGUID().ToString & "', '00000000-0000-0000-0000-000000000000', '00000000-0000-0000-0000-000000000000', 'deux', '', 0"
End Sub
Protected Sub gvCampagne_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles gvCampagne.RowDataBound
If e.Row.RowType = DataControlRowType.DataRow Then
If e.Row.RowType = DataControlRowType.DataRow Then
Dim lnk As HyperLink = CType(e.Row.FindControl("hlCamp" & CType(DataBinder.Eval(e.Row, "DataItem.Id_Campagne"), String)), HyperLink)
With lnk
.NavigateUrl = String.Format("JavaScript:test(' ceci vient du code : {0}');", CType(DataBinder.Eval(e.Row, "DataItem.Id_Campagne"), String))
.ImageUrl = "~/App_Themes/" & GetNomsite() & "/lettresinfo.png"
End With
Dim ibactif As ImageButton = CType(e.Row.FindControl("ibActif" & CType(DataBinder.Eval(e.Row, "DataItem.Id_Campagne"), String)), ImageButton)
With ibactif
AddHandler ibactif.Click, AddressOf actifCampagne
.ImageUrl = "~/App_Themes/" & GetNomsite() & "/" & CType(DataBinder.Eval(e.Row, "DataItem.Actif"), String) & ".png"
.CommandArgument = CType(DataBinder.Eval(e.Row, "DataItem.Id_Campagne"), String)
End With
End If
End If
End Sub
Sub actifCampagne(ByVal sender As Object, ByVal e As ImageClickEventArgs)
Dim ib As ImageButton = sender
Dim dt As DataTable = New DataManager("CS").ExecuterRequeteSimple("EXEC SPEC_ActifCampagne " & ib.CommandArgument)
LogageOW("je passe dans le actifCampagne avec le : " & ib.CommandArgument)
ConstruireGV()
End Sub
End Class
Public Class TemplatePopup
Implements ITemplate
Private templateType As DataControlRowType
Private columnName As String
Private controleName As String
Sub New(ByVal type As DataControlRowType, ByVal colname As String, ByVal ctrlName As String)
templateType = type
columnName = colname
controleName = ctrlName
End Sub
Sub InstantiateIn(ByVal container As System.Web.UI.Control) _
Implements ITemplate.InstantiateIn
Select Case templateType
Case DataControlRowType.Header
Dim lc As New Literal
lc.Text = "<b>" & columnName & "</b>"
container.Controls.Add(lc)
Case DataControlRowType.DataRow
Select Case controleName
Case "Apercu"
Dim hl As New HyperLink
AddHandler hl.DataBinding, AddressOf hl_DataBinding
container.Controls.Add(hl)
Case "Actif"
Dim ib As New ImageButton
AddHandler ib.DataBinding, AddressOf ib_DataBinding
container.Controls.Add(ib)
Case Else
End Select
Case Else
' Insert code to handle unexpected values.
End Select
End Sub
Private Sub hl_DataBinding(ByVal sender As Object, ByVal e As EventArgs)
Dim l As HyperLink = CType(sender, HyperLink)
Dim row As GridViewRow = CType(l.NamingContainer, GridViewRow)
l.Text = DataBinder.Eval(row.DataItem, "Id_Campagne").ToString()
l.ID = "hlCamp" & DataBinder.Eval(row.DataItem, "Id_Campagne").ToString()
End Sub
Private Sub ib_DataBinding(ByVal sender As Object, ByVal e As EventArgs)
Dim l As ImageButton = CType(sender, ImageButton)
Dim row As GridViewRow = CType(l.NamingContainer, GridViewRow)
l.ID = "ibActif" & DataBinder.Eval(row.DataItem, "Id_Campagne").ToString()
End Sub
End Class |