File manager - Edit - G:/PleskVhosts/fullscreenksa.com/Falafel.fullscreenksa.com/StoresReports/MergedItems.aspx
Back
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/Master_Page.Master" AutoEventWireup="true" CodeBehind="MergedItems.aspx.cs" Inherits="Erp_TotalReport.StoresReports.MergedItems" %> <%@ Register assembly="DevExpress.Web.v16.2, Version=16.2.6.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web" tagprefix="dx" %> <asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server"> <%-- <asp:UpdatePanel ID="UpdatePanel1" runat="server"> <ContentTemplate> </ContentTemplate> </asp:UpdatePanel>--%> <div class="panel panel-default"> <div class="panel-heading"> <div align="center" ><font size="4" color="#2196f3">Merged Items Report</font></div> </div> <div class="panel-body"> <dx:ASPxButton ID="ASPxButton1" runat="server" ValidationGroup="aly" Text="Show Data" OnClick="ASPxButton1_Click" Theme="iOS"></dx:ASPxButton> </div> </div> <div class="panel panel-default"> <div class="panel-heading"> <div align="center" ><font size="4" color="#2196f3"> Data</font></div> </div> <div class="panel-body" align="center" > <dx:ASPxGridViewExporter ID="ASPxGridViewExporter1" runat="server" GridViewID="ASPxGridView1" Landscape="True"> </dx:ASPxGridViewExporter> <dx:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="False" GridLines="Vertical" Theme="Metropolis" AllowSorting="true" ShowFooter="true" EmptyDataText="لا يوجد نتائج" EnableTheming="True" CssClass="dt-responsive " KeyFieldName="ItemID" Width="100%" EnablePagingCallbackAnimation="True"> <SettingsDetail ExportMode="All" ShowDetailRow="True" /> <Templates> <DetailRow> <dx:ASPxGridView ID="ASPxGridView2" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" EnableTheming="True" KeyFieldName="ItemID" OnBeforePerformDataSelect="ASPxGridView1_BeforePerformDataSelect" Theme="SoftOrange" Width="100%"> <SettingsPager Visible="False"> </SettingsPager> <Columns> <dx:GridViewDataTextColumn FieldName="ItemID" ReadOnly="True" VisibleIndex="0"> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn FieldName="ItemCode" VisibleIndex="1"> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn FieldName="ItemName" VisibleIndex="2"> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn FieldName="ClassDesc" ReadOnly="True" VisibleIndex="3"> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn FieldName="CategoryName" ReadOnly="True" VisibleIndex="4"> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn FieldName="SmallSellPrice1" VisibleIndex="5"> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn FieldName="SmallLastPrice" VisibleIndex="6"> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn FieldName="SmallAverageUnitPrice" VisibleIndex="7"> </dx:GridViewDataTextColumn> </Columns> </dx:ASPxGridView> </DetailRow> </Templates> <StylesContextMenu> <Row> <Style HorizontalAlign="Center" VerticalAlign="Middle"> </Style> </Row> </StylesContextMenu> <SettingsPager Mode="ShowAllRecords"> </SettingsPager> <Settings ShowFilterRow="True" ShowGroupPanel="True" AutoFilterCondition="Contains" ShowFilterRowMenu="True" ShowFooter="True" VerticalScrollableHeight="500" VerticalScrollBarMode="Visible" /> <SettingsDataSecurity AllowDelete="False" AllowEdit="False" AllowInsert="False" /> <Columns> <dx:GridViewDataTextColumn Caption="Category Name" FieldName="CategoryName" Name="CategoryName" VisibleIndex="5"> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> <ExportCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </ExportCellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Sell Price1" FieldName="SmallSellPrice1" Name="SmallSellPrice1" VisibleIndex="6"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> <ExportCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </ExportCellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Last Price" FieldName="SmallLastPrice" Name="SmallLastPrice" VisibleIndex="7"> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> <ExportCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </ExportCellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Item Name " FieldName="ItemName" Name="ItemName" VisibleIndex="2"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> <ExportCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </ExportCellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Item Code" FieldName="ItemCode" Name="ItemCode" VisibleIndex="1"> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <EditCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </EditCellStyle> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle Font-Size="Smaller" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> <ExportCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </ExportCellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Class Desc" FieldName="ClassDesc" VisibleIndex="3" Name="ClassDesc"> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> <ExportCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </ExportCellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="ItemID" FieldName="ItemID" VisibleIndex="0" Name="ItemID"> <EditFormCaptionStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </EditFormCaptionStyle> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> <GroupFooterCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </GroupFooterCellStyle> <ExportCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </ExportCellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Average UnitPrice" FieldName="SmallAverageUnitPrice" Name="SmallAverageUnitPrice" VisibleIndex="9"> <PropertiesTextEdit DisplayFormatString="{0:N}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> <GroupFooterCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </GroupFooterCellStyle> <ExportCellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </ExportCellStyle> </dx:GridViewDataTextColumn> </Columns> <%-- <TotalSummary> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="DeptAmount" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="CreditAmount" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="CurrentDeptBalance" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="CrrentCreditBalance" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="Start_BalanceDept" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N}" FieldName="Start_BalanceCredit" SummaryType="Sum" /> </TotalSummary>--%> <Styles> <Table HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </Table> <Row HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" BackColor="#CCFFFF" Font-Bold="True"> </Row> <DetailRow HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </DetailRow> </Styles> </dx:ASPxGridView> <div class="panel-heading"> <div align="center" > <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ErpCS %>" SelectCommandType="StoredProcedure" SelectCommand="GetMergedItemsByItemID"> <SelectParameters> <asp:SessionParameter SessionField="ItemID" Name="ItemID" Type="Int64"></asp:SessionParameter> </SelectParameters> </asp:SqlDataSource> <dx:ASPxRoundPanel ID="ASPxRoundPanel1" runat="server" ShowCollapseButton="true" Width="200px" HeaderText="Export Data" HorizontalAlign="Center"> <HeaderStyle Font-Bold="True" Font-Size="Small" ForeColor="#6600FF" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <PanelCollection> <dx:PanelContent runat="server"> <table class="nav-justified"> <tr> <td> <asp:ImageButton ID="exl" ImageUrl="~/assets/export/Ex.png" Height="40px" Width="40px" runat="server" OnClick="exl_Click" /></td> <td><asp:ImageButton ID="word" ImageUrl="~/assets/export/word.png" Height="40px" Width="40px" runat="server" OnClick="word_Click" /></td> <td><asp:ImageButton ID="pdf" ImageUrl="~/assets/export/pdf.png" Height="40px" Width="40px" runat="server" OnClick="pdf_Click" /></td> </tr> </table> </dx:PanelContent> </PanelCollection> </dx:ASPxRoundPanel> </div> </div> </div> </div> </asp:Content>
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.1 |
proxy
|
phpinfo
|
Settings