发票前台

<%@ Control Language="C#" Inherits="Modules.AGL_FP_DSR_KF_TONGJI.ViewAGL_FP_DSR_KF_TONGJI"
AutoEventWireup="true" CodeBehind="ViewAGL_FP_DSR_KF_TONGJI.ascx.cs" %>
<%@ Register Assembly="C1.Web.Wijmo.Controls.4" Namespace="C1.Web.Wijmo.Controls.C1GridView" TagPrefix="wijmo" %>
<%@ Register Assembly="C1.Web.Wijmo.Controls.4" Namespace="C1.Web.Wijmo.Controls.C1Expander" TagPrefix="C1Expander" %>
<link href="/DesktopModules/AGL_FP_DSR_KF_TONGJI/css/IRB_main.css" rel="stylesheet" />
<link href="/DesktopModules/AGL_FP_DSR_KF_TONGJI/css/IRB_plugins.css" rel="stylesheet" />
<link href="/DesktopModules/AGL_FP_DSR_KF_TONGJI/css/IRB_plugins.css" rel="stylesheet" />
<link href="/DesktopModules/AGL_FP_DSR_KF_TONGJI/css/IRB_themes.css" rel="stylesheet" />
<head></head>
<style type="text/css">
.wijmo-wijgrid-headertext {
font-size:12px
}
.wijmo-wijgrid-innercell {
font-size:12px
}

</style>
<style>
.divcss5
{
1110px;
height: 230px;
/*border: 1px solid #000;*/
/*background-color:black;*/
}
</style>
<style>
.wijmo-wijgrid-headertext
{
text-align: center;
}
</style>
<style type="text/css">
/* CSS Document */

body
{
font: normal 11px auto "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
color: #4f6b72;
background: #E6EAE9;
}

a
{
color: #c75f3e;
}

#mytable,#Table2
{
1000px;
padding: 0;
margin: 0;
}

caption
{
left:0px;
position:relative;
padding: 0 0 5px 0;
100%;
font: italic 11px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
text-align: left;
color:black;
background-color:white;
}

th
{
font: bold 11px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
color: #4f6b72;
border-right: 1px solid #C1DAD7;
border-bottom: 1px solid #C1DAD7;
border-top: 1px solid #C1DAD7;
letter-spacing: 2px;
text-transform: uppercase;
text-align: left;
padding: 6px 6px 6px 12px;
background: #CAE8EA no-repeat;
200px;
}
/*power by www.winshell.cn*/
th.nobg
{
border-top: 0;
border-left: 0;
border-right: 1px solid #C1DAD7;
background: none;
}

td
{
border-right: 1px solid #C1DAD7;
border-bottom: 1px solid #C1DAD7;
background: #fff;
font-size: 11px;
padding: 6px 6px 6px 12px;
color: #4f6b72;
height:20px;
}
/*power by www.winshell.cn*/

td.alt
{
background: #F5FAFA;
color: #797268;
}

th.spec
{
border-left: 1px solid #C1DAD7;
border-top: 0;
background: #fff no-repeat;
font: bold 10px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
}

th.specalt
{
border-left: 1px solid #C1DAD7;
border-top: 0;
background: #f5fafa no-repeat;
font: bold 10px "Trebuchet MS", Verdana, Arial, Helvetica, sans-serif;
color: #797268;
}
/*---------for IE 5.x bug*/
html > body td
{
font-size: 11px;
}

body, td, th
{
font-family: 宋体, Arial;
font-size: 12px;
}
.wuxian
{
border:0px;
height:20px;100%;
}
th{
text-align:center;
text-align:justify;
text-justify:distribute-all-lines;
text-align-last:justify
}
tr{
height:40px;
}
.wuxian1 {
border: 0px;
text-align:right
}

.billID {
display:none;
}
</style>
<asp:TextBox ID="txtbillnumberid" runat="server" Width="100%" ReadOnly="True" Visible="false" CssClass="wuxian"></asp:TextBox>
<C1Expander:C1Expander runat="server" ID="Expander1" Expanded="False" CssClass="block-title" EnableTheming="False">
<header><caption style="font-size: 14px; font-weight: 600">客户发票信息</caption></header>
<Content>
<div class="form-group" style="padding-top: 10px">
<div style="margin-top: 10px; margin-bottom: 10px; height: 34px;line-height:34px">
<div style=" 50%; float: left;">
<label style=" 30%; text-align: right; font-size: 14px;letter-spacing:5px" class="col-md-3 control-label" for="example-text-input">客户名称:</label>
<div class="col-md-9" style=" 60%;">
<input type="text" id="TextBox10" runat="server" name="TextBox10" style=" 100%" class="form-control">
</div>
</div>
<div style=" 50%; float: right;">
<label style=" 30%; text-align: right; font-size: 14px; letter-spacing: 5px;" class="col-md-3 control-label" for="example-text-input">操   作:</label>
<div class="col-md-9" style=" 60%;">
<input type="text" id="txtkhmc" runat="server" name="txtkhmc" readonly="true" style=" 100%" class="form-control">
</div><div style="position:absolute;top:35px;right:98px">
<asp:Button ID="Button8" runat="server" Style=" 100px; text-align: center;height:32px;border:0px" Text="选择客户信息" OnClick="Button8_Click" />     
<asp:Button ID="Button11" Style=" 100px; text-align: center;height:32px;border:0px" runat="server" Text="清空客户信息" OnClick="Button8_Click1" />
</div>
</div>
</div>
<div style="margin-top: 10px; margin-bottom: 10px; height: 34px;line-height:34px">
<div style=" 50%; float: left;">
<label style=" 30%; text-align: right; font-size: 14px; letter-spacing: 5px;" class="col-md-3 control-label" for="example-text-input">公司名称:</label>
<div class="col-md-9" style=" 60%;">
<input type="text" id="TextBox11" runat="server" name="TextBox11" style=" 100%" class="form-control">
</div>
</div>
<div style=" 50%; float: right;">
<label style=" 30%; text-align: right; font-size: 14px; letter-spacing: 5px;" class="col-md-3 control-label" for="example-text-input">纳税人号:</label>
<div class="col-md-9" style=" 60%;">
<input type="text" id="TextBox17" runat="server" name="TextBox17" style=" 100%" class="form-control">
</div>
</div>
</div>
<div style="margin-top: 10px; margin-bottom: 10px; height: 34px;line-height:34px">
<div style=" 50%; float: left;">
<label style=" 30%; text-align: right; font-size: 14px; letter-spacing: 5px;" class="col-md-3 control-label" for="example-text-input">开户行:</label>
<div class="col-md-9" style=" 60%;">
<input type="text" id="TextBox14" runat="server" name="TextBox14" style=" 100%" class="form-control">
</div>
</div>
<div style=" 50%; float: right;">
<label style=" 30%; text-align: right; font-size: 14px; letter-spacing: 5px;" class="col-md-3 control-label" for="example-text-input">账   号:</label>
<div class="col-md-9" style=" 60%;">
<input type="text" id="TextBox16" runat="server" name="TextBox16" style=" 100%" class="form-control">
</div>
</div>
</div>
<div style="margin-top: 10px; margin-bottom: 10px; height: 34px;line-height:34px">
<div style=" 50%; float: left;">
<label style=" 30%; text-align: right; font-size: 14px; letter-spacing: 5px;" class="col-md-3 control-label" for="example-text-input">地   址:</label>
<div class="col-md-9" style=" 60%;">
<input type="text" id="TextBox13" runat="server" name="TextBox13" style=" 100%" class="form-control">
</div>
</div>
<div style=" 50%; float: right;">
<label style=" 30%; text-align: right; font-size: 14px; letter-spacing: 5px;" class="col-md-3 control-label" for="example-text-input">电   话:</label>
<div class="col-md-9" style=" 60%;">
<input type="text" id="TextBox15" runat="server" name="TextBox15" style=" 100%" class="form-control">
</div>
</div>
</div>

<div style="margin-top: 10px; margin-bottom: 10px;line-height:34px">
<div style=" 50%; float: left;">
<label style=" 30%; text-align: right; font-size: 14px; letter-spacing: 5px;" class="col-md-3 control-label" for="example-text-input">发票类型:</label>
<div class="col-md-9" style=" 60%;">
<select id="Select1" runat="server" class="form-control" size="1">
<option value="1">增值税专用发票</option>
<option value="2">增值税普通发票</option>
</select>
</div>
</div>
<div style=" 50%; float: right;">
<label class="col-md-3 control-label" for="example-text-input" style=" 30%; text-align: right; font-size: 14px; letter-spacing: 5px;">结算类型:</label>
<div class="col-md-9" style=" 60%;">
<select id="Select2" runat="server" class="form-control" size="1">
<option value="1">固定月结</option>
<option value="2">实次次结</option>
<option value="3">临时次结</option>
</select>
</div>
</div>
<div style="clear: both;"></div>
</div>
</div>
<%-- <table id="mytable" cellspacing="0">

<tr>
<th scope="col" id="Buttonl61">管家婆客户名称：</th>
<td class="row"><asp:TextBox ID="TextBox10" runat="server" Width="100%" ReadOnly="True" CssClass="wuxian"></asp:TextBox></td>
<th scope="col">操作：</th>
<td class="row" contenteditable="true" style="400px;"><asp:Button ID="Button8" runat="server" Text="选择客户信息" OnClick="Button8_Click" />     
<asp:Button ID="Button11" runat="server" Text="清空客户信息" OnClick="Button8_Click1" /></td>
</tr>
<tr>
<th scope="col" id="Buttonl71">公司名称：</th>
<td class="row" style="300px;"><asp:TextBox ID="TextBox11" runat="server" Width="100%" CssClass="wuxian"></asp:TextBox></td>

<th scope="col" id="Button151">纳税人识别号：</th>
<td id="Td1" class="row" runat="server" style="400px;"><asp:TextBox ID="TextBox17" runat="server" Width="100%" CssClass="wuxian"></asp:TextBox></td>
</tr>
<tr>
<th scope="col" id="Button101">开户行：</th>
<td class="row" style="300px;"><asp:TextBox ID="TextBox14" runat="server" Width="100%" CssClass="wuxian"></asp:TextBox></td>
<th scope="col" id="Button121">账号：</th>
<td class="row" style="400px;"><asp:TextBox ID="TextBox16" runat="server" Width="100%" CssClass="wuxian"></asp:TextBox></td>
</tr>
<tr>
<th scope="col" id="Button91">地址：</th>
<td class="row" style="400px;"><asp:TextBox ID="TextBox13" runat="server" Width="100%" CssClass="wuxian"></asp:TextBox></td>
<th scope="col" id="Button111">电话：</th>
<td class="row" style="300px;"><asp:TextBox ID="TextBox15" runat="server" Width="100%" CssClass="wuxian"></asp:TextBox></td>
</tr>
<tr>
<th scope="col" id="Button131">发票类型：</th>
<td class="row"style="300px;">
<select id="Select1" runat="server">
<option value="1">增值税专用发票</option>
<option value="2">增值税普通发票</option>
</select></td>
<th scope="col" id="Button141">结算类型：</th>
<td class="row" style="400px;">
<select id="Select2" runat="server">
<option value="1">固定月结</option>
<option value="2">实次次结</option>
<option value="3">临时次结</option>
</select></td>
</tr>
</table>--%>
<br />
<br />
<asp:TextBox ID="TextBox12" runat="server" Width="100%" Visible="false"></asp:TextBox><%--客户ID--%>
<asp:TextBox ID="TextBox19" runat="server" Width="100%" Visible="false"></asp:TextBox><%--时间--%>
<asp:TextBox ID="TextBox32" runat="server" Visible="false"></asp:TextBox>
<asp:TextBox ID="TextBox34" runat="server" Visible="false"></asp:TextBox>
<div id="Div1" runat="server" style="text-align: center">
<asp:Button ID="Button9" runat="server" Text="点击保存" Width="150px" OnClick="Button9_Click1" />
</div>

<div runat="server" id="SCTEST" visible="false" style="padding-top:20px;">
<%--style="display:none"--%><%--style="display:block"--%>
<asp:Label ID="Label4" runat="server" Text="管家婆客户名称：" Visible="true"></asp:Label>
<asp:TextBox ID="TextBox4" runat="server" Width="250px"></asp:TextBox>   &nbsp
<asp:Button ID="Button4" runat="server" Text="查询" OnClick="Button4_Click" Visible="true" />
<br />
<br />
<wijmo:C1GridView ID="C1GridView2" runat="server" ScrollMode="Auto" AutoGenerateColumns="False" EnableEventValidation ="false"
ShowRowHeader="true" AllowPaging="true" AllowColMoving="false" PageSize="10" OnPageIndexChanging="C1GridView2_PageIndexChanging" ><%--DataSourceID="SqlDataSourceSC"DataKeyNames="id"--%>
<alternatingrowstyle backcolor="White" forecolor="#284775" />
<pagersettings mode="NumericFirstLast" />
<%--<callbacksettings action="All"></callbacksettings>--%>
<columns>
<wijmo:C1BoundField DataField="id" HeaderText="id" SortExpression="id" Visible="false"></wijmo:C1BoundField>
<wijmo:C1BoundField DataField="name" HeaderText="管家婆客户名称" SortExpression="name" Visible="false">
<HeaderStyle Width="25%"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" Width="25%"></ItemStyle>
</wijmo:C1BoundField>
<wijmo:C1BoundField DataField="FullName" HeaderText="客户全称" SortExpression="FullName">
<HeaderStyle Width="50%"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" Width="50%"></ItemStyle>
</wijmo:C1BoundField>
<wijmo:C1TemplateField HeaderText="操作">
<ItemTemplate>
<asp:Button runat="server" ID="button2" Style=" 50px;" CommandArgument='<%#Eval("FullName") %>' Text="选择" OnClick="Button2_Click" />
</ItemTemplate>
<HeaderStyle Width="10%"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" Width="10%" />
</wijmo:C1TemplateField>
</columns>
<emptydatatemplate>
<div style="color: Red; text-align: center; 100%;height:80px">
没有符合条件的客户
</div>
</emptydatatemplate>
<rowstyle horizontalalign="Center" verticalalign="Middle" />
</wijmo:C1GridView>

</div>
</Content>
</C1Expander:C1Expander>
<div runat="server" id="Div7">
</div>
</div>
<hr />
<asp:TextBox ID="TextBox24" runat="server" Visible="false"></asp:TextBox>
<asp:TextBox ID="TextBox25" runat="server" Visible="false"></asp:TextBox>
<asp:TextBox ID="TextBox26" runat="server" Visible="false"></asp:TextBox>
<asp:TextBox ID="TextBox27" runat="server" Visible="false"></asp:TextBox>
<asp:TextBox ID="TextBox28" runat="server" Visible="false"></asp:TextBox>
<asp:TextBox ID="TextBox29" runat="server" Visible="false"></asp:TextBox>
<asp:TextBox ID="TextBox30" runat="server" Visible="false"></asp:TextBox>
<asp:TextBox ID="TextBox31" runat="server" Visible="false"></asp:TextBox>
<asp:TextBox ID="TextBox23" runat="server" Visible="false"></asp:TextBox>
<asp:TextBox ID="TextBox22" runat="server" Visible="false"></asp:TextBox>
<asp:TextBox ID="TextBox6" runat="server" Visible="false"></asp:TextBox>
<C1Expander:C1Expander runat="server" ID="C1Expander2" CssClass="block-title" EnableTheming="False">
<header><caption style="font-size: 14px; font-weight: 600">临时发票申请</caption></header>
<Content>
<div class="form-group" style="padding-top: 10px">
<div style="margin-top: 10px; margin-bottom: 10px; height: 34px;line-height:34px">
<div style=" 50%; float: left;">
<label style=" 30%; text-align: right; font-size: 14px; " class="col-md-3 control-label" for="example-text-input">客户名称:</label>
<div class="col-md-9" style=" 60%;">
<input type="text" id="TextBox21" runat="server" name="txthtmc" style=" 100%" class="form-control">
</div>
</div>
<div style=" 50%; float: right;">
<label style=" 30%; text-align: right; font-size: 14px; letter-spacing: 5px;" class="col-md-3 control-label" for="example-text-input">操作:</label>
<div class="col-md-9" style=" 60%;">
<input type="text" id="Text8" runat="server" name="txtkhmc" readonly="true" style=" 100%" class="form-control">
</div><div style="position:absolute;top:35px;right:98px">
<asp:Button ID="Button14" runat="server" Text="选择客户信息" OnClick="Buttonkehu_Click" Style=" 100px; text-align: center;height:32px;border:0px"/>     
<asp:Button ID="Button10" runat="server" Text="订单详情" OnPreRender="Button10_Click" Style=" 100px; text-align: center;height:32px;border:0px"/>
</div>
</div>
</div>

</div>

</div>
</div>

<div style="margin-top: 10px; margin-bottom: 10px;line-height:34px">
<div style=" 100%;">
<label style=" 15%; text-align: right; font-size: 14px; letter-spacing: 3px;" class="col-md-3 control-label" for="example-text-input">补充说明:</label>
<div class="col-md-9" style=" 85%;text-align:left">
<textarea runat="server" id="beiz" style=" 94%;border-radius:4px; height: 100px; resize: none;"></textarea>
</div>
</div>

<div style="clear: both;"></div>
</div>
</div>
<%-- <table id="Table2" cellspacing="0">
<tr>
<th scope="col" id="Th1">管家婆客户名称：</th>
<td class="row" style="300px;"><asp:TextBox ID="TextBox21" runat="server" Width="100%" ReadOnly="True" CssClass="wuxian"></asp:TextBox></td>
<th scope="col" style="200px">操作：</th>
<td class="row" style="400px;"> <asp:Button ID="Button14" runat="server" Text="选择客户信息" OnClick="Buttonkehu_Click" />     
<asp:Button ID="Button10" runat="server" Text="订单详情" OnPreRender="Button10_Click" /></td>
</tr>
<tr>
<th scope="col" id="Th3" >公司名称：</th>
<td class="row" style="300px;"><asp:TextBox ID="TextBox1" runat="server" Width="100%" ReadOnly="True" CssClass="wuxian"></asp:TextBox></td>
<th scope="col" id="Th2">金额：</th>
<td class="row" style="400px;"><asp:TextBox ID="TextBox18" runat="server" Width="100%" CssClass="wuxian"></asp:TextBox></td>

</tr>
<tr>
<th scope="col" id="Label7" >发票类型：</th>
<td class="row" style="300px;">
<asp:DropDownList ID="DropDownList3" runat="server">
<asp:ListItem Value="1">增值税专用发票</asp:ListItem>
<asp:ListItem Value="2">增值税普通发票</asp:ListItem>
</asp:DropDownList>
</td>
<th scope="col" id="lbl5" rowspan="2">备注：</th>
<td class="row" style="400px;" rowspan="2">
<textarea runat="server" id="beiz" style=" 300px; height: 50px; resize: none"></textarea>
</td>
</tr>
<tr>
<th scope="col" id="Th11" >订单号：</th>
<td class="row" style="300px;"><asp:TextBox ID="TextBox35" runat="server" Width="100%" CssClass="wuxian"></asp:TextBox>(使用,分隔例 XK-JSDJY-ZY-200-01-01-0001,XK-JSDJY-ZY-200-01-01-0002)</td>

</tr>
</table>--%>
<div style="height:40px;100%"></div>
<div style=" 100%; height: 8px; padding-left: 481px;bottom:10px;position:relative">
<asp:Button ID="Button13" runat="server" CssClass="fl" Text="点击保存" Width="150px" OnClick="Buttonbaocun_Click1" />
</div>
<div runat="server" id="Div12" visible="false">
<br />
<br />
<br />
<asp:Label ID="Label8" runat="server" Text="管家婆客户名称：" Visible="true"></asp:Label>
<asp:TextBox ID="TextBox33" runat="server" Width="250px"></asp:TextBox>       
<asp:Button ID="Button16" runat="server" Text="查询" OnClick="Button16_Click" Visible="true" />
<br />
<br />
<wijmo:C1GridView ID="C1GridView5" runat="server" ScrollMode="Auto" AutoGenerateColumns="False" OnRowDataBound="C1GridView5_RowDataBound"
ShowRowHeader="true" AllowPaging="true" PageSize="10" CallbackSettings-Action="All" OnPageIndexChanging="C1GridView5_PageIndexChanging" AllowColMoving="false">
<alternatingrowstyle backcolor="White" forecolor="#284775" />
<pagersettings mode="NumericFirstLast" />
<%--<callbacksettings action="All"></callbacksettings>--%>
<columns>
<wijmo:C1BoundField DataField="id" HeaderText="id" SortExpression="id" Visible="false"></wijmo:C1BoundField>
<wijmo:C1BoundField DataField="fullName" HeaderText="管家婆客户名称" SortExpression="fullName" Visible="true">
<HeaderStyle Width="25%"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" Width="25%"></ItemStyle>
</wijmo:C1BoundField>
<wijmo:C1BoundField DataField="company" HeaderText="公司名称" SortExpression="company">
<HeaderStyle Width="50%"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" Width="50%"></ItemStyle>
</wijmo:C1BoundField>
<wijmo:C1BoundField DataField="identity_number" HeaderText="纳税人识别号" SortExpression="identity_number" Visible="false"></wijmo:C1BoundField>

<wijmo:C1BoundField DataField="statement" HeaderText="结算类型" SortExpression="statement" Visible="false"></wijmo:C1BoundField>
<%--5--%>
<wijmo:C1BoundField DataField="fp_type" HeaderText="发票类型" SortExpression="fp_type" Visible="false"></wijmo:C1BoundField>
<wijmo:C1BoundField DataField="customer_id" HeaderText="customer_id" SortExpression="customer_id" Visible="false"></wijmo:C1BoundField>
<wijmo:C1BoundField DataField="account_bank" HeaderText="开户行" SortExpression="account_bank" Visible="false"></wijmo:C1BoundField>
<wijmo:C1BoundField DataField="account_number" HeaderText="账号" SortExpression="account_number" Visible="false"></wijmo:C1BoundField>
<wijmo:C1BoundField DataField="identity_number" HeaderText="纳税人识别号" SortExpression="identity_number" Visible="true"></wijmo:C1BoundField>
<%--10--%>
<wijmo:C1BoundField DataField="address" HeaderText="地址" SortExpression="address" Visible="false"></wijmo:C1BoundField>
<wijmo:C1BoundField DataField="telephone" HeaderText="电话" SortExpression="telephone" Visible="false"></wijmo:C1BoundField>
<wijmo:C1BoundField DataField="company" HeaderText="company" SortExpression="company" Visible="false"></wijmo:C1BoundField>
<wijmo:C1TemplateField HeaderText="操作" Visible="true">
<ItemTemplate>
<asp:Button runat="server" ID="button15" Style=" 50px;" Text="选择" CommandArgument='<%#Eval("fullName") %>' OnClick="Buttonkehuxz_Click" />
</ItemTemplate>
<HeaderStyle Width="10%"></HeaderStyle>
<ItemStyle HorizontalAlign="Center" Width="10%" />
</wijmo:C1TemplateField>
</columns>
<emptydatatemplate>
<div style="color: Red; text-align: center; 100%;height:80px">
没有符合条件的客户
</div>
</emptydatatemplate>
<rowstyle horizontalalign="Center" verticalalign="Middle" />
</wijmo:C1GridView>
</div>
</Content>
</C1Expander:C1Expander>
<hr />
<C1Expander:C1Expander runat="server" ID="C1Expander1" Expanded="False" CssClass="block-title" EnableTheming="False">
<header><caption style="font-size: 14px; font-weight: 600">申请发票台账</caption></header>
<Content>
<div runat="server" id="Div4" visible="true">
<asp:Label ID="Label3" runat="server" Text="公司名称："></asp:Label>
<asp:TextBox ID="TextBox8" runat="server"></asp:TextBox>
&nbsp&nbsp&nbsp&nbsp
<asp:Button ID="Button7" runat="server" Text="查询" OnClick="Button7_Click" />
&nbsp&nbsp&nbsp&nbsp
<asp:Label ID="Label6" runat="server" Text="状态："></asp:Label>
<asp:DropDownList ID="DropDownList4" runat="server" OnSelectedIndexChanged="DropDownList4_SelectedIndexChanged" AutoPostBack="True">
<asp:ListItem Value="0">未处理</asp:ListItem>
<asp:ListItem Value="1">已处理</asp:ListItem>
<asp:ListItem Value="2">已领取</asp:ListItem>
</asp:DropDownList>
</div>
<div style=" 100%; height: 5px;"></div>

<asp:PlaceHolder id="PlaceHolder1" runat="server" Visible="False">
<div class="form-group" style="padding-top: 10px">
<div style="margin-top: 10px; margin-bottom: 10px; height: 34px;line-height:34px">
<div style=" 50%; float: left;">
<label style=" 30%; text-align: right; font-size: 14px; letter-spacing: 5px;" class="col-md-3 control-label" for="example-text-input">管家婆名称:</label>
<div class="col-md-9" style=" 60%;">
<input type="text" id="TextBox2" runat="server" name="TextBox2" style=" 100%" readonly="true" class="form-control">
<asp:Label ID="Label12" runat="server" Text="" CssClass="billID"></asp:Label>
</div>
</div>
<div style=" 50%; float: right;">
<label style=" 30%; text-align: right; font-size: 14px; letter-spacing: 5px;" class="col-md-3 control-label" for="example-text-input">公司名称:</label>
<div class="col-md-9" style=" 60%;">
<input type="text" id="TextBox3" runat="server" name="TextBox3" readonly="true" style=" 100%" class="form-control">
</div>
</div>
</div>

</div>

<%--<table id="Table1" cellspacing="0">--%>
<%-- <tr>
<th scope="col" id="Th4">管家婆客户名称：</th>
<td class="row" style="300px;"><asp:TextBox ID="TextBox2" runat="server" Width="100%" ReadOnly="True" CssClass="wuxian"></asp:TextBox><asp:Label ID="Label12" runat="server" Text="" CssClass="billID"></asp:Label></td>
<th scope="col" style="200px">公司名称：</th>
<td class="row" style="400px;"><asp:TextBox ID="TextBox3" runat="server" Width="100%" ReadOnly="True" CssClass="wuxian"></asp:TextBox></td>
</tr>--%>
<%-- <tr>

<th scope="col" id="Th5">开户行：</th>
<td class="row" style="400px;"><asp:TextBox ID="TextBox7" runat="server" ReadOnly="True" Width="100%" CssClass="wuxian"></asp:TextBox></td>

<th scope="col" id="Th9" >账号：</th>
<td class="row" style="300px;">
<asp:TextBox ID="TextBox9" runat="server" Width="100%" ReadOnly="True" CssClass="wuxian"></asp:TextBox></td>
</tr>--%>
<%-- <tr>
<th scope="col" id="Th7" >发票类型：</th>
<td class="row" style="300px;">
<asp:DropDownList ID="DropDownList1" runat="server" ReadOnly="True">
<asp:ListItem Value="1">增值税专用发票</asp:ListItem>
<asp:ListItem Value="2">增值税普通发票</asp:ListItem>
</asp:DropDownList>
</td>
<th scope="col" id="Th6">金额：</th>
<td class="row" style="400px;"><asp:TextBox ID="TextBox5" runat="server" Width="100%" CssClass="wuxian"></asp:TextBox></td>

</tr>--%>
<%-- <tr>
<th scope="col" id="Th12">订单号：</th>
<td class="row" style="400px;"><asp:TextBox ID="TextBox36" runat="server" Width="100%" CssClass="wuxian"></asp:TextBox>(使用,分隔例 400001,400002,400003)</td>

<div style="margin-top: 10px; margin-bottom: 10px; height: 34px;line-height:34px">
<div style=" 50%; float: left;">
<label style=" 30%; text-align: right; font-size: 14px; letter-spacing: 5px;" class="col-md-3 control-label" for="example-text-input">开户行:</label>
<div class="col-md-9" style=" 60%;">
<asp:Button ID="Button1" runat="server" Text="修改" OnClick="xiugaifp_Click"></asp:Button>
<asp:Button ID="Button3" runat="server" Text="取消" OnClick="quxiaofp_Click"></asp:Button>
</div>
</div>
<div style=" 50%; float: right;">
<label style=" 30%; text-align: right; font-size: 14px; letter-spacing: 5px;" class="col-md-3 control-label" for="example-text-input"></label>
<div class="col-md-9" style=" 60%;">
</div>
</div>
</div>
<%-- <tr><td></td><td></td></tr>
</table>--%>
</asp:PlaceHolder>
<%--列表区--%>
<wijmo:C1GridView ID="C1GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="id" OnRowDataBound="C1GridView1_RowDataBound" OnRowCommand="C1GridView1_RowCommand"
EnableModelValidation="false" Width="100%" ScrollMode="Auto" Height="200px" visible="true" AllowColMoving="false">
<alternatingrowstyle backcolor="White" forecolor="#284775"></alternatingrowstyle>
<pagersettings mode="NumericFirstLast" />
<%--<callbacksettings action="All"></callbacksettings>--%>
<columns>
<wijmo:C1TemplateField HeaderText="序" Width="60px">
<ItemTemplate>
<asp:Label runat="server" ID="Lable_Number" Text="<%#Container.DataItemIndex+1%>"><%#Container.DataItemIndex+1%></asp:Label>
</ItemTemplate>
<ItemStyle Width="5%" HorizontalAlign="Center" VerticalAlign="Middle" />
</wijmo:C1TemplateField>

<wijmo:C1BoundField DataField="customer_id" HeaderText="customer_id" SortExpression="customer_id" Visible="false"></wijmo:C1BoundField>
<wijmo:C1BoundField DataField="fullname" Width="200px" HeaderText="管家婆客户名称" SortExpression="fullname" Visible="true">
<HeaderStyle Width="9%" />
<ItemStyle HorizontalAlign="Center" />
</wijmo:C1BoundField>
<wijmo:C1TemplateField HeaderText="公司名称">
<ItemTemplate>
<asp:Button ID="Button5" runat="server" Text='<%#Eval("company") %>' OnClick="Button5_Click1" CssClass="btn"></asp:Button>
</ItemTemplate>
<ItemStyle Width="5%" HorizontalAlign="Center" VerticalAlign="Middle" />
</wijmo:C1TemplateField>
<wijmo:C1BoundField DataField="identity_number" HeaderText="纳税人号" SortExpression="identity_number" Visible="true">
<HeaderStyle Width="10%" />
<ItemStyle HorizontalAlign="Center" />
</wijmo:C1BoundField>
<%--4--%>

<wijmo:C1BoundField DataField="company" HeaderText="公司名称" SortExpression="company" Visible="false">
<HeaderStyle Width="5%" />
<ItemStyle HorizontalAlign="Center" />
</wijmo:C1BoundField>
<wijmo:C1BoundField DataField="address" HeaderText="地址" SortExpression="address" Visible="false">
<HeaderStyle Width="15%" />
<ItemStyle HorizontalAlign="Center" />
</wijmo:C1BoundField>
<wijmo:C1BoundField DataField="account_bank" HeaderText="开户行" SortExpression="account_bank" Visible="false">
<HeaderStyle Width="7%" />
<ItemStyle HorizontalAlign="Center" />
</wijmo:C1BoundField>
<%--7--%>
<wijmo:C1BoundField DataField="fp_type" HeaderText="发票类型" SortExpression="fp_type" Visible="true">
<HeaderStyle Width="8%" />
<ItemStyle HorizontalAlign="Center" />
</wijmo:C1BoundField>
<wijmo:C1BoundField DataField="statement" HeaderText="结算类型" SortExpression="statement" Visible="true">
<HeaderStyle Width="6%" />
<ItemStyle HorizontalAlign="Center"/>
</wijmo:C1BoundField>
<wijmo:C1BoundField DataField="beizhu" HeaderText="备注" SortExpression="beizhu" Visible="false" ></wijmo:C1BoundField>

<wijmo:C1BoundField DataField="id" HeaderText="id" SortExpression="id" Visible="false"></wijmo:C1BoundField>
<%--11--%>
<wijmo:C1BoundField DataField="telephone" HeaderText="电话" SortExpression="telephone" Visible="false">
<HeaderStyle Width="9%" />
<ItemStyle HorizontalAlign="Center" />
</wijmo:C1BoundField>
<wijmo:C1BoundField DataField="account_number" HeaderText="账号" SortExpression="account_number" Visible="false">
<HeaderStyle Width="15%" />
<ItemStyle HorizontalAlign="Center" />
</wijmo:C1BoundField>
<wijmo:C1TemplateField HeaderText="时间(日)" Visible="false" >
<ItemTemplate>
<asp:DropDownList ID="DropDownList12" runat="server" AutoPostBack="false" >
</asp:DropDownList>
</ItemTemplate>
</wijmo:C1TemplateField>
<wijmo:C1BoundField DataField="amount" HeaderText="金额" SortExpression="amount" Visible="false" ></wijmo:C1BoundField>

<%--15--%>

<wijmo:C1TemplateField DataField="amount" HeaderText="金额" SortExpression="amount" Visible="true" >
<ItemTemplate>
<asp:TableCell Width="10%"><%--金额--%>
<asp:TextBox ID="TextBox411" runat="server" Width="100%" Cssclass="wuxian1" ReadOnly="true" Text='<%#Eval("amount")%>'></asp:TextBox>
</asp:TableCell>

</ItemTemplate>
</wijmo:C1TemplateField>
<wijmo:C1BoundField DataField="fengzFlag" HeaderText="发票状态" SortExpression="fengzFlag" Visible="true"></wijmo:C1BoundField>
<wijmo:C1BoundField DataField="state" HeaderText="领取状态" SortExpression="state" Visible="true"></wijmo:C1BoundField>
<wijmo:C1TemplateField DataField="beizhu" HeaderText="备注" SortExpression="beizhu" Visible="false" >
<ItemTemplate>
<asp:TableCell Width="10%"><%--备注--%>
<asp:TextBox ID="TextBox20" runat="server" Width="100%"></asp:TextBox>
</asp:TableCell>

</ItemTemplate>
</wijmo:C1TemplateField>

<wijmo:C1BoundField DataField="statement_ci" HeaderText="是否次结" SortExpression="statement_ci" Visible="false">
<HeaderStyle Width="8%" />
<ItemStyle HorizontalAlign="Center"/>
</wijmo:C1BoundField>

<wijmo:C1BoundField DataField="state" HeaderText="state" SortExpression="state" Visible="false"></wijmo:C1BoundField>

<wijmo:C1TemplateField HeaderText="操作" Visible="false">
<ItemTemplate>
<asp:Button runat="server" ID="buttonEdit" Style=" 60px;" Text="提交" />
<asp:Button runat="server" ID="buttonDel" Style=" 60px;" Text="详情" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="10%"/>
</wijmo:C1TemplateField>
<%--22--%>
<wijmo:C1TemplateField HeaderText="操作">
<ItemTemplate>
<asp:Button runat="server" ID="udpbuttonupd" Style=" 60px;" CommandArgument='<%# Eval("linshiid") %>' CommandName='cupd' Text="修改" />
<asp:Button runat="server" ID="udpbuttondel" Style=" 60px;" CommandArgument='<%# Eval("linshiid") %>' CommandName='cdel' Text="删除" />
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" Width="4%"/>
</wijmo:C1TemplateField>

</columns>
<emptydatatemplate>
<div style="color: Red; text-align: center; 100%;height:80px">
没有客户发票信息
</div>
</emptydatatemplate>
<rowstyle horizontalalign="Center" verticalalign="Middle" />
<editrowstyle backcolor="#999999"></editrowstyle>
<footerstyle backcolor="#006699" font-bold="True" forecolor="White"></footerstyle>
<headerstyle backcolor="#006699" font-bold="True" forecolor="White" height="30px"></headerstyle>
<rowstyle backcolor="#F7F6F3" forecolor="#333333" height="30px"></rowstyle>
<selectedrowstyle backcolor="#E2DED6" font-bold="True" forecolor="#333333"></selectedrowstyle>

</wijmo:C1GridView>

<%--<asp:SqlDataSource runat="server" ID="SqlDataSource1" ConnectionString='<%$ ConnectionStrings:SiteSqlServer %>' SelectCommand="SELECT inv.customer_id, inv.account_bank, inv.account_number, inv.id, inv.statement,inv.statement_ci,inv.identity_number,inv.address,inv.telephone,inv.fp_type,inv.state,c.fullname,inv.company,inv.amount FROM Invoices inv left join customer c on c.id = inv.customer_id WHERE inv.statement='1' and LEFT(CAST(inv.creat_date AS DATE),7)=LEFT(CAST(GETDATE() AS DATE), 7) and inv.portal_id=@portal_id union SELECT inv.customer_id, inv.account_bank, inv.account_number, inv.id, inv.statement,inv.statement_ci,inv.identity_number,inv.address,inv.telephone,inv.fp_type,inv.state,c.fullname,inv.company,inv.amount FROM Invoices inv left join customer c on c.id = inv.customer_id where LEFT(CAST(inv.creat_date AS DATE),7)=LEFT(CAST(GETDATE() AS DATE), 7) and inv.portal_id=@portal_id--%>
<asp:SqlDataSource runat="server" ID="SqlDataSource1" ConnectionString='<%$ ConnectionStrings:SiteSqlServer %>' SelectCommand="SELECT inv.customer_id, inv.account_bank, inv.account_number, inv.id, inv.statement,inv.statement_ci,inv.identity_number,inv.address,inv.telephone,inv.fp_type,inv.state,c.fullname,inv.company,inv.amount,inv.FPSHIJIAN FROM Invoices inv left join customer c on c.id = inv.customer_id WHERE inv.statement='1' and LEFT(CAST(inv.creat_date AS DATE),7)=LEFT(CAST(GETDATE() AS DATE), 7) and inv.portal_id=@portal_id union SELECT inv.customer_id, inv.account_bank, inv.account_number, inv.id, inv.statement,inv.statement_ci,inv.identity_number,inv.address,inv.telephone,inv.fp_type,inv.state,c.fullname,inv.company,inv.amount ,inv.FPSHIJIAN FROM Invoices inv left join customer c on c.id = inv.customer_id where LEFT(CAST(inv.creat_date AS DATE),7)=LEFT(CAST(GETDATE() AS DATE), 7) and inv.portal_id=@portal_id">
<SelectParameters>
<asp:Parameter Name="portal_id" Type="Int32" DefaultValue="" />
</SelectParameters>
</asp:SqlDataSource>

<%--<asp:SqlDataSource runat="server" ID="SqlDataSource2" ConnectionString='<%$ ConnectionStrings:SiteSqlServer %>' SelectCommand="SELECT [id], [name], [FullName] FROM [view_selectCustomerWithGjp] where Fullname like @name AND portal_id=@portal_id and id not in (select customer_id from Invoices WHERE portal_id=@portal_id)">--%>

<asp:SqlDataSource runat="server" ID="SqlDataSource2" ConnectionString='<%$ ConnectionStrings:SiteSqlServer %>' SelectCommand=" select id,name,FullName from view_selectCustomerWithGjp WHERE FullName LIKE '@name' ">

</Content>
</C1Expander:C1Expander>

<asp:SqlDataSource ID="SqlDataSourceSC" runat="server" ConnectionString="<%$ ConnectionStrings:SiteSqlServer %>"
SelectCommand=" select id,name,FullName from view_selectCustomerWithGjp where FullName like @name">
<SelectParameters>
<asp:Parameter Name="name" Type="String" />
</SelectParameters>
</asp:SqlDataSource>