KIssU列表头合并
<%@ Page Title="" Language="C#" MasterPageFile="~/Layouts/List.Master" AutoEventWireup="true"
CodeBehind="CarInfoTotalList.aspx.cs" Inherits="QASupervision.Modules.AffairManager.CarManage.CarInfoTotalList" %>
<%@ Import Namespace="Common" %>
<%@ Import Namespace="Bingosoft.Modules.SecurityConsole.Common.Helper" %>
<asp:Content ID="idFormTitle" ContentPlaceHolderID="head" runat="server">
<title>车辆使用统计列表</title>
<link href="../../../App_Themes/default/Ajax.css" type="text/css" rel="stylesheet" />
<link href="../../../App_Themes/default/Dialog.css" type="text/css" rel="stylesheet" />
<link href="../../../App_Themes/default/ItemDetail.css" type="text/css" rel="stylesheet" />
<link href="../../../App_Themes/default/style.css" type="text/css" rel="stylesheet" />
<link href="../../../App_Themes/default/ValidatorStyle/validator.css" type="text/css"
rel="stylesheet" />
<link href="../../../App_Themes/default/WebPart.css" type="text/css" rel="stylesheet" />
<link href="../../../App_Themes/default/ValidatorStyle/validator.css" type="text/css"
rel="stylesheet" />
<link href="../../../Content/themes/base/jquery.ui.theme.css" rel="stylesheet" type="text/css"
id="themesLink" />
<link href="../../../Widgets/core/combotree/combotree.css" rel="stylesheet" type="text/css" />
<script src="../../../Scripts/DialogPopup/DialogPopup.js" type="text/javascript"></script>
<style>
.btnColor
{
display: inline-block;
padding: 0 5px;
margin: 5px 5px 0 0;
height: 20px;
line-height: 20px;
background: url(/App_Themes/blue/button_bg.png) repeat-x;
border: 1px solid #30A5FF;
text-decoration: none;
color: white;
font-weight: bold;
}
.td_total, .td_count
{
text-align: center;
font-size: 16px;
font-weight: bold;
color: Red;
}
</style>
<script src="../../../Scripts/jquery.js" type="text/javascript"></script>
<script src="../../../Scripts/jquery.utils.js" type="text/javascript"></script>
<script>
$(function () {
sumCount();
})
// 计算类型总数
function sumCount() {
var count = 0;
$.each($(".FixRefuelCount"), function () {
count += parseFloat($(this).text());
});
$("#sumFixRefuel").text(count);
count = 0;
$.each($(".FixRefuelMoneyCount"), function () {
count += parseFloat($(this).text());
});
$("#sumFixRefuelMoney").text(count);
count = 0;
$.each($(".OutlandRefuelCount"), function () {
count += parseFloat($(this).text());
});
$("#sumOutlandRefuel").text(count);
count = 0;
$.each($(".OutlandRefuelMoneyCount"), function () {
count += parseFloat($(this).text());
});
$("#sumOutlandRefuelMoney").text(count);
count = 0;
$.each($(".OtherRefuelCount"), function () {
count += parseFloat($(this).text());
});
$("#sumOtherRefuel").text(count);
count = 0;
$.each($(".OtherRefuelMoneyCount"), function () {
count += parseFloat($(this).text());
});
$("#sumOtherRefuelMoney").text(count);
count = 0;
$.each($(".KilometersCount"), function () {
count += parseFloat($(this).text());
});
$("#sumKilometers").text(count);
count = 0;
$.each($(".PerKilometersOilCount"), function () {
count += parseFloat($(this).text());
});
$("#sumPerKilometersOil").text(count);
count = 0;
$.each($(".RoadTollCount"), function () {
count += parseFloat($(this).text());
});
$("#sumRoadToll").text(count);
count = 0;
$.each($(".FoodSubsidiesCount"), function () {
count += parseFloat($(this).text());
});
$("#sumFoodSubsidies").text(count);
count = 0;
$.each($(".MaintenanceCount"), function () {
count += parseFloat($(this).text());
});
$("#sumMaintenance").text(count);
count = 0;
}
</script>
</asp:Content>
<asp:Content ID="idContent" ContentPlaceHolderID="Content" runat="server">
<div class="search" style="margin-top: 2px;">
<web:search ID="GridSearch" GridViewId="gvList" runat="server">
<SearchConditionTemplate>
<table cellspacing="0" cellpadding="0" width="100%">
<tr>
<th>
姓名：
</th>
<td>
<asp:TextBox ID="txtName" runat="server" Width="138px"></asp:TextBox>
</td>
<th>
车牌号：
</th>
<td>
<asp:TextBox ID="txtCarNum" runat="server" Width="138px"></asp:TextBox>
</td>
<th>
月份：
</th>
<td>
<web:DatePicker ID="dpApplyDate" Name="AddDateMonth" runat="server" enablecontrol="(0.*)"
SkinID="calender" DateTimeFormat="yyyy-MM" class="com_textbox com_datepicker"></web:DatePicker>
</td>
</tr>
</table>
</SearchConditionTemplate>
</web:search>
</div>
<div class="datalist">
<!-- 标题头 -->
<h2 style="height: 30px;">
车辆使用统计列表</h2>
<!-- 工具栏 -->
<div class="toolbar" style="height: 30px;">
<asp:LinkButton ID="LinkButton1" runat="server" OnClientClick="return openForm2(this, 'Insert');"
OnClick="Refresh">
<span>
<img id="Img1" alt="" runat="server" src="~/Images/icon_new.gif" style="border: 0px" />新建
</span>
</asp:LinkButton>
<asp:Button ID="btnRefresh" runat="server" OnClick="Refresh" ClientIDMode="Static"
Style="display: none" />
</div>
<web:SmartGridView ID="gvList" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" EnableModelValidation="True" DataSourceID="SmartDataSource1"
ClientIDMode="Static">
<FixRowColumnSettings MarginLeft="" MarginRight=""></FixRowColumnSettings>
<Columns>
<asp:BoundField HeaderText="序号" SortExpression="SortNum" DataField="SortNum" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField HeaderText="姓名" SortExpression="Name" DataField="Name" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField HeaderText="车牌号" SortExpression="CarNum" DataField="CarNum" ItemStyle-HorizontalAlign="Center" />
<asp:TemplateField HeaderText="日期" SortExpression="AddDate">
<ItemStyle HorizontalAlign="Center" />
<ItemTemplate>
<%#Convert.ToDateTime(Eval("AddDate")).ToString("yyyy-MM-dd")%>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField HeaderText="车型(排气量)" SortExpression="Displacement" DataField="Displacement"
ItemStyle-HorizontalAlign="Center" />
<asp:BoundField HeaderText="定点加油#数量(升)" SortExpression="FixRefuel" DataField="FixRefuel"
ItemStyle-CssClass="FixRefuelCount" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField HeaderText="定点加油#金额(元)" SortExpression="FixRefuelMoney" DataField="FixRefuelMoney"
ItemStyle-CssClass="FixRefuelMoneyCount" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField HeaderText="外地加油#数量(升)" SortExpression="OutlandRefuel" DataField="OutlandRefuel"
ItemStyle-CssClass="OutlandRefuelCount" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField HeaderText="外地加油#金额(元)" SortExpression="OutlandRefuelMoney" DataField="OutlandRefuelMoney"
ItemStyle-CssClass="OutlandRefuelMoneyCount" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField HeaderText="其他车加油#车牌号" SortExpression="OtherRefuelCarNum" DataField="OtherRefuelCarNum"
ItemStyle-HorizontalAlign="Center" />
<asp:BoundField HeaderText="其他车加油#数量(升)" SortExpression="OtherRefuel" DataField="OtherRefuel"
ItemStyle-CssClass="OtherRefuelCount" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField HeaderText="其他车加油#金额(元)" SortExpression="OtherRefuelMoney" DataField="OtherRefuelMoney"
ItemStyle-CssClass="OtherRefuelMoneyCount" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField HeaderText="月度公里数" SortExpression="Kilometers" DataField="Kilometers"
ItemStyle-CssClass="KilometersCount" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField HeaderText="每100公里(升)" SortExpression="PerKilometersOil" DataField="PerKilometersOil"
ItemStyle-CssClass="PerKilometersOilCount" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField HeaderText="路桥费(元)" SortExpression="RoadToll" DataField="RoadToll"
ItemStyle-CssClass="RoadTollCount" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField HeaderText="伙食补助(元)" SortExpression="FoodSubsidies" DataField="FoodSubsidies"
ItemStyle-CssClass="FoodSubsidiesCount" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField HeaderText="维修费(元)" SortExpression="Maintenance" DataField="Maintenance"
ItemStyle-CssClass="MaintenanceCount" ItemStyle-HorizontalAlign="Center" />
<asp:BoundField HeaderText="备注" SortExpression="Remarks" DataField="Remarks" ItemStyle-HorizontalAlign="Center" />
<asp:TemplateField HeaderText="操作">
<ItemStyle HorizontalAlign="Center" />
<HeaderStyle Wrap="False" HorizontalAlign="Center" />
<ItemTemplate>
<asp:ImageButton ID="ImageButton1" runat="server" ToolTip="编辑" _KeyID='<%#Eval("ReportID") %>'
ImageUrl="~/images/com/dg_edit.gif" CausesValidation="False" OnClick="Refresh"
OnClientClick=" return openForm2(this, 'Edit');"></asp:ImageButton>
<asp:ImageButton ID="ImageButton3" runat="server" ToolTip="删除" ImageUrl="~/images/com/dg_del.gif"
_KeyID='<%#Eval("ReportID") %>' CausesValidation="False" OnClientClick=" return confirm('您确认要删除吗?') "
OnClick="DeleteApplication"></asp:ImageButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<PagerTemplate>
<tr class="dg_itemstyle_s">
<td class="td_total">
</td>
<td class="td_count">
合计
</td>
<td class="td_count">
</td>
<td class="td_count">
</td>
<td class="td_count">
</td>
<td id="sumFixRefuel" class="td_count">
0
</td>
<td id="sumFixRefuelMoney" class="td_count">
0
</td>
<td id="sumOutlandRefuel" class="td_count">
0
</td>
<td id="sumOutlandRefuelMoney" class="td_count">
0
</td>
<td class="td_count">
</td>
<td id="sumOtherRefuel" class="td_count">
0
</td>
<td id="sumOtherRefuelMoney" class="td_count">
0
</td>
<td id="sumKilometers" class="td_count">
0
</td>
<td id="sumPerKilometersOil" class="td_count">
0
</td>
<td id="sumRoadToll" class="td_count">
0
</td>
<td id="sumFoodSubsidies" class="td_count">
0
</td>
<td id="sumMaintenance" class="td_count">
0
</td>
<td id="Remarks" class="td_count">
</td>
<td class="td_count">
</td>
</tr>
</PagerTemplate>
<CustomHeaderSettings AlwaysShowHeader="true" SplitHeader="true" /> //这里需要加上这个设置就可以表头合并
</web:SmartGridView>
</div>
<web:SmartSqlDataSource ID="SmartDataSource1" runat="server" SelectCommand="car_reports.list"
DefaultSortExpression="SortNum DESC">
</web:SmartSqlDataSource>
<script type="text/javascript">
var Global = {};
Global.contextPath = '<%= RequestHelper.GetContextPath(Request) %>';
function openForm2(_this, action) {
var url;
// FormViewMode : Insert/Edit/ReadOnly
var params = { FormViewMode: action }
if (action == "Insert") {
url = Global.contextPath + "/Modules/AffairManager/CarManage/CarInfoTotalEdit.aspx";
params.title = "新增车辆统计";
} else if (action == "Edit") {
url = Global.contextPath + "/Modules/AffairManager/CarManage/CarInfoTotalEdit.aspx";
params.title = "编辑车辆统计";
params.id = _this.attributes["_KeyID"].value;
}
var returnValue = ShowTopDialogPopup(buildUrl(url, params), params.title, 800, 470, function (e) {
window.location.reload();
});
return false;
}
</script>
</asp:Content>
//后台代码
public partial class CarInfoTotalList : System.Web.UI.Page
{
Car_ReportsBLL repBLL = new Car_ReportsBLL();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.SmartDataSource1.SelectParameters.Add(new Parameter("AddDateMonth", DbType.String, DateTime.Now.ToString("yyyy-MM")));
}
}
protected void DeleteApplication(object sender, EventArgs e)
{
ImageButton ctr = sender as ImageButton;
string delId = ctr.Attributes["_KeyID"];
repBLL.DelByID(delId);
this.gvList.DataBind();
}
protected void Refresh(object sender, EventArgs e)
{
this.gvList.DataBind();
}
}
//数据库脚本
<command key="car_reports.list">
<![CDATA[
select * from Car_Reports
where 1=1
{? AND ReportID = #ReportID#}
{? AND CarNum like '%$txtCarNum$%'}
{? AND Name like '%$txtName$%'}
{? AND DATEDIFF(mm,AddDate,cast('$AddDateMonth$' + '-01' as datetime))=0}
]]>
浙公网安备 33010602011771号