/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/mach/machapprovalstatus.aspx
69 строк
4 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="machapprovalstatus.aspx.vb" Inherits="mach_machapprovalstatus" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Mach approval status</title> <link href="../Styles/page.css" rel="stylesheet" /> </head> <body> <form id="form1" runat="server"> <div> <div class ="center"> Single ID: <asp:TextBox id="singleid" runat ="server" CssClass ="cemter" AutoPostBack="True" ></asp:TextBox> Process: <asp:DropDownList ID="process" runat ="server" AutoPostBack ="true" > <asp:ListItem Text="All" Value ="%" Selected ="True" ></asp:ListItem> <asp:ListItem Text="Register" Value ="REGISTER_SUBMIT" ></asp:ListItem> <asp:ListItem Text="Finish" Value ="FINISH_SUBMIT" ></asp:ListItem> </asp:DropDownList> <asp:ImageButton ID="refresh" runat ="server" ImageUrl ="~/Images/Refresh.png" /> </div> <hr /> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="id" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None"> <AlternatingRowStyle BackColor="White" ForeColor="#284775" /> <Columns> <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" ReadOnly="True" SortExpression="id" /> <asp:BoundField DataField="department" HeaderText="department" SortExpression="department" /> <asp:BoundField DataField="leader" HeaderText="leader" SortExpression="leader" /> <asp:BoundField DataField="name" HeaderText="name" SortExpression="name" /> <asp:BoundField DataField="step_seq" HeaderText="step_seq" SortExpression="step_seq" /> <asp:BoundField DataField="SINGLE_ID" HeaderText="SINGLE_ID" SortExpression="SINGLE_ID" /> <asp:BoundField DataField="PROCESS_TYPE" HeaderText="PROCESS_TYPE" SortExpression="PROCESS_TYPE" /> <asp:BoundField DataField="SUBMITED" HeaderText="SUBMITED" SortExpression="SUBMITED" /> <asp:BoundField DataField="v" HeaderText="v" SortExpression="v" /> </Columns> <EditRowStyle BackColor="#999999" /> <FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" /> <RowStyle BackColor="#F7F6F3" ForeColor="#333333" /> <SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" /> <SortedAscendingCellStyle BackColor="#E9E7E2" /> <SortedAscendingHeaderStyle BackColor="#506C8C" /> <SortedDescendingCellStyle BackColor="#FFFDF8" /> <SortedDescendingHeaderStyle BackColor="#6F8DAE" /> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ModMas %>" SelectCommand="select * from (select t1.id, t1.department, t1.leader, t1.name , t2.step_seq, t2.SINGLE_ID , t2.PROCESS_TYPE, (SELECT MAX(CONFIRMATION_DATETIME) FROM UserModules.[user].MACH_APPROVAL WHERE row_id = t2.row_id) as [SUBMITED],'' as v from UserModules.[user].MACH t1 left join UserModules.[user].MACH_APPROVAL t2 on t1.id = t2.ROW_ID where t2.ACTIVE_STEP = 'Y' and t2.APPROVAL_FINISHED = 'N' and t2.single_id like '%' + @singleid + '%' AND t2.process_type like '%' + @process + '%' ) tt order by tt.submited"> <SelectParameters> <asp:ControlParameter ControlID="singleid" DefaultValue="%" Name="singleid" PropertyName="Text" /> <asp:ControlParameter ControlID="process" DefaultValue="%" Name="process" PropertyName="SelectedValue" /> </SelectParameters> </asp:SqlDataSource> </div> </form> </body> </html>