File manager - Edit - G:/PleskVhosts/fullscreenksa.com/Falafel.fullscreenksa.com/StoresReports/CostOfManuFacturing.aspx
Back
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage/Master_Page.Master" AutoEventWireup="true" CodeBehind="CostOfManuFacturing.aspx.cs" Inherits="Erp_TotalReport.StoresReports.CostOfManuFacturing" %> <%@ 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"> <div class="panel panel-default"> <div class="panel-heading"> <div align="center" ><font size="4" color="#2196f3">Stock Financial Report</font></div> <div align="center" ></div> <div align="center" > <table class="modal-full-width"> <tr> <td align="left" width="15%"> <font size="4" color="#ff9933">Export Mode : </font></td> <td align="left"><dx:ASPxComboBox ID="txtexport" runat="server" Theme="SoftOrange" HorizontalAlign="Center" Font-Bold="True" Font-Size="Medium"> <Items> <dx:ListEditItem Text="None" Value="None" /> <dx:ListEditItem Text="Expanded" Value="Expanded" /> <dx:ListEditItem Text="All" Value="All" /> </Items> </dx:ASPxComboBox> </td> </tr> </table> </div> </div> </div> <div class="panel panel-default"> <div class="panel-heading"> <table class="modal-full-width"> <tr> <td align="center"> <div class="panel-heading"> <div align="center" ><font size="4" color="black">Total Manufacturing Cost Report</font></div> </div> </td> </tr> <tr> <td> <table class="modal-full-width"> <tr> <td> <dx:ASPxGridView ID="grdSales" runat="server" Width="100%" AutoGenerateColumns="False" DataSourceID="DSTotalSales" EnableTheming="True" Theme="Office2010Black" KeyFieldName="CompID"> <SettingsDetail ShowDetailRow="True" ExportMode="Expanded" /> <Templates> <DetailRow> <dx:ASPxGridView ID="grdSalesType" runat="server" AutoGenerateColumns="False" DataSourceID="DSTotalSalesTypes" EnableTheming="True" Theme="DevEx" Width="100%" OnBeforePerformDataSelect="grdSalesType_BeforePerformDataSelect"> <Settings ShowFooter="True" AutoFilterCondition="Contains" ShowFilterBar="Visible" ShowFilterRow="True" ShowFilterRowMenu="True" /> <SettingsDataSecurity AllowDelete="False" AllowEdit="False" AllowInsert="False" /> <SettingsSearchPanel Visible="True" /> <Columns> <dx:GridViewDataTextColumn Caption="Cost Center" FieldName="company" Name="company" VisibleIndex="0"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#FFFFCC" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="January " FieldName="_1" Name="Jan" VisibleIndex="2"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="February " FieldName="_2" Name="February " VisibleIndex="3"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="March " FieldName="_3" Name="March " VisibleIndex="4"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="April " FieldName="_4" Name="April " VisibleIndex="5"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="May " FieldName="_5" Name="May " VisibleIndex="6"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="June " FieldName="_6" Name="June " VisibleIndex="7"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="July " FieldName="_7" Name="July " VisibleIndex="8"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="August " FieldName="_8" Name="August " VisibleIndex="9"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="September " FieldName="_9" Name="September " VisibleIndex="10"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="October " FieldName="_10" Name="October " VisibleIndex="11"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="November " FieldName="_11" Name="November " VisibleIndex="12"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="December " FieldName="_12" Name="December " VisibleIndex="13"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Total Cost" FieldName="total" Name="NetSales" VisibleIndex="14"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#CCFFFF" Font-Bold="True" ForeColor="#000066" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> </Columns> <TotalSummary> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_1" ShowInColumn="Jan" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_2" ShowInColumn="February " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_3" ShowInColumn="March " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_4" ShowInColumn="April " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_5" ShowInColumn="May " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_6" ShowInColumn="June " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_7" ShowInColumn="July " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_8" ShowInColumn="August " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_9" ShowInColumn="September " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_10" ShowInColumn="October " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_11" ShowInColumn="November " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_12" ShowInColumn="December " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="total" ShowInColumn="NetSales" SummaryType="Sum" /> </TotalSummary> </dx:ASPxGridView> </DetailRow> </Templates> <Settings ShowFooter="True" /> <SettingsDataSecurity AllowDelete="False" AllowEdit="False" AllowInsert="False" /> <Columns> <dx:GridViewDataTextColumn FieldName="CompID" Name="CompID" ShowInCustomizationForm="True" Visible="False" VisibleIndex="1"> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="BranchName" FieldName="company" Name="company" ShowInCustomizationForm="True" VisibleIndex="0"> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#CCFFFF" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="January " FieldName="_1" Name="Jan" ShowInCustomizationForm="True" VisibleIndex="2"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="February " FieldName="_2" Name="February " ShowInCustomizationForm="True" VisibleIndex="3"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="March " FieldName="_3" Name="March " ShowInCustomizationForm="True" VisibleIndex="4"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="April " FieldName="_4" Name="April " ShowInCustomizationForm="True" VisibleIndex="5"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="May " FieldName="_5" Name="May " ShowInCustomizationForm="True" VisibleIndex="6"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="June " FieldName="_6" Name="June " ShowInCustomizationForm="True" VisibleIndex="7"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="July " FieldName="_7" Name="July " ShowInCustomizationForm="True" VisibleIndex="8"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="August " FieldName="_8" Name="August " ShowInCustomizationForm="True" VisibleIndex="9"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="September " FieldName="_9" Name="September " ShowInCustomizationForm="True" VisibleIndex="10"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="October " FieldName="_10" Name="October " ShowInCustomizationForm="True" VisibleIndex="11"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="November " FieldName="_11" Name="November " ShowInCustomizationForm="True" VisibleIndex="12"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="December " FieldName="_12" Name="December " ShowInCustomizationForm="True" VisibleIndex="13"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> <dx:GridViewDataTextColumn Caption="Total Cost" FieldName="total" Name="Total Cost" ShowInCustomizationForm="True" VisibleIndex="14"> <PropertiesTextEdit DisplayFormatString="{0:N0}"> </PropertiesTextEdit> <HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True" /> <CellStyle BackColor="#FFFFCC" Font-Bold="True" ForeColor="#000066" HorizontalAlign="Center" VerticalAlign="Middle" Wrap="True"> </CellStyle> </dx:GridViewDataTextColumn> </Columns> <TotalSummary> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_1" ShowInColumn="Jan" SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_2" ShowInColumn="February " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_3" ShowInColumn="March " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_4" ShowInColumn="April " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_5" ShowInColumn="May " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_6" ShowInColumn="June " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_7" ShowInColumn="July " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_8" ShowInColumn="August " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_9" ShowInColumn="September " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_10" ShowInColumn="October " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_11" ShowInColumn="November " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="_12" ShowInColumn="December " SummaryType="Sum" /> <dx:ASPxSummaryItem DisplayFormat="{0:N0}" FieldName="total" ShowInColumn="NetSales" SummaryType="Sum" /> </TotalSummary> </dx:ASPxGridView> </td> <%-- <td valign="top" width="60"> <div ID="back_image"> <div ID="vertical-text" align="center" style="border: medium groove #800080"> المبيعات النقديه</div> </div> </td>--%> </tr> </table> </td> </tr> <tr> <td align="center"> <dx:ASPxGridViewExporter ID="ASPxGridViewExporter1" runat="server" GridViewID="grdSales"> </dx:ASPxGridViewExporter> <asp:ImageButton runat="server" ImageUrl="~/assets/export/Ex.png" Height="40px" Width="40px" ID="exl0" OnClick="exl_Click"></asp:ImageButton> <asp:SqlDataSource ID="DSTotalSales" runat="server" ConnectionString="<%$ ConnectionStrings:ErpCS %>" OnSelecting="SqlDataSource1_Selecting" SelectCommand="ManufacturingCostAroundYear" SelectCommandType="StoredProcedure"> </asp:SqlDataSource> <asp:SqlDataSource ID="DSTotalSalesTypes" runat="server" ConnectionString="<%$ ConnectionStrings:ErpCS %>" OnSelecting="SqlDataSource1_Selecting" SelectCommand="ManufacturingCostAroundYearByCompID" SelectCommandType="StoredProcedure"> <SelectParameters> <asp:SessionParameter Name="CompID" SessionField="CompID1" Type="Int32" /> </SelectParameters> </asp:SqlDataSource> </td> </tr> <tr> <td style="height: 20px"> </td> </tr> <tr> <td style="height: 20px" align="center"> </td> </tr> <tr> <td style="height: 20px" align="center"> </td> </tr> <%--<tr> <td style="height: 20px"> </td> </tr>--%> <tr> <td style="height: 20px" align="center"> </td> </tr> <tr> <td style="height: 20px" align="center"> </td> </tr> <tr> <td style="height: 20px" align="center"> </td> </tr> <tr> <td style="height: 20px" align="center"> </td> </tr> <tr> <td style="height: 20px" align="center"> </td> </tr> <tr> <td style="height: 20px"> </td> </tr> <tr> <td style="height: 20px" align="center"> </td> </tr> <tr> <td style="height: 20px" align="center"> </td> </tr> <tr> <td style="height: 20px"> </td> </tr> <tr> <td style="height: 20px"> </td> </tr> <tr> <td style="height: 20px"> </td> </tr> <tr> <td style="height: 20px" align="center"> </td> </tr> <tr> <td style="height: 20px"> <asp:SqlDataSource ID="DSTotalExpensesypes" runat="server" ConnectionString="<%$ ConnectionStrings:ErpCS %>" OnSelecting="SqlDataSource1_Selecting" SelectCommand="GenralAdministrativeExpensesByCompID" SelectCommandType="StoredProcedure"> <SelectParameters> <asp:SessionParameter Name="CompID" SessionField="CompID4" Type="Int32" /> </SelectParameters> </asp:SqlDataSource> </td> </tr> <tr> <td> </td> </tr> <tr> <td> </td> </tr> </table> </div> </div> </asp:Content>
| ver. 1.4 |
Github
|
.
| PHP 7.3.33 | Generation time: 0.09 |
proxy
|
phpinfo
|
Settings