<%@ Page Language="C#" AutoEventWireup="true" CodeFile="" Inherits="webpage_ColPaymentInfo" %>
<%@ Register Assembly=".v7., Version=7.2.5.0, Culture=neutral, PublicKeyToken=9b171c9fd64da1d1"
Namespace="" TagPrefix="dxwgv" %>
<%@ Register Assembly=".v7.2, Version=7.2.5.0, Culture=neutral, PublicKeyToken=9b171c9fd64da1d1" Namespace="" TagPrefix="dxwgv" %>
<%@ Register Assembly=".v7.2, Version=7.2.5.0, Culture=neutral, PublicKeyToken=9b171c9fd64da1d1" Namespace="" TagPrefix="dxe" %>
<%@ Register Assembly=", Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Namespace="" TagPrefix="asp" %>
<%@ Register Src="../ascx/" TagName="SiteMap" TagPrefix="uc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http:///TR/xhtml1/DTD/">
<html xmlns="http:///1999/xhtml" >
<head runat="server">
<title>代收代付客户信息</title>
<link href="../css/" type="text/css" rel="stylesheet"/>
<link href="../css/" type="text/css" rel="Stylesheet"/>
<script src="../js/" language="javascript" type="text/javascript"></script>
</head>
<body style="margin:0px 0px 0px 5px">
<form runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<uc1:SiteMap ID="SiteMap1" runat="server" />
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<table width="800" cellpadding="0" cellspacing="0" border="0" style="line-height:25px">
<tr>
<td style="text-align:right">公司名称：</td>
<td colspan="3">
<asp:TextBox ID="tbCompanyName" runat="server" Width="410px"></asp:TextBox></td>
<td style="text-align:right">公司简称：</td>
<td>
<asp:TextBox ID="tbAbbName" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="text-align:right">公司地址：</td>
<td colspan="3">
<asp:TextBox ID="tbCompAddr" runat="server" Width="410px"></asp:TextBox></td>
<td style="text-align:right">公司性质：</td>
<td>
<asp:TextBox ID="tbCompNature" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="text-align:right">联系人：</td>
<td>
<asp:TextBox ID="tbContactPerson" runat="server"></asp:TextBox></td>
<td style="text-align:right">联系电话：</td>
<td>
<asp:TextBox ID="tbTel" runat="server"></asp:TextBox></td>
<td style="text-align:right">传真：</td>
<td>
<asp:TextBox ID="tbFax" runat="server"></asp:TextBox></td>
</tr>
<tr>
<td style="text-align:right">信用期限：</td>
<td>
<asp:TextBox ID="tbExpireDate" runat="server" style="width:100px"></asp:TextBox>
<button class="date_button" οnclick="Drop('tbExpireDate')" type="button" style="width:20px"><img src="../images/" /></button>
</td>
<td style="text-align:right">信用额度：</td>
<td>
<asp:TextBox ID="tbCreditLine" runat="server"></asp:TextBox></td>
<td></td>
<td></td>
</tr>
<tr style="padding-top:20px">
<td colspan="6" style="text-align:center; height: 41px;">
<asp:Button ID="btnAdd" runat="server" Text="添加" OnClick="btnAdd_Click" />
<asp:Button ID="btnEdit" runat="server" Text="修改" OnClick="btnEdit_Click" />
<asp:Button ID="btnSave" runat="server" Text="保存" OnClick="btnSave_Click" />
<asp:Button ID="btnDel" runat="server" Text="删除" OnClick="btnDel_Click" />
</td>
</tr>
</table>
<br />
<dxwgv:ASPxGridView
ID="ASPxGridView1"
Width="99%"
KeyFieldName="ID"
runat="server" AutoGenerateColumns="False" CssFilePath="~/App_Themes/Office2003 Olive/{0}/" CssPostfix="Office2003_Olive">
<Columns>
<dxwgv:GridViewDataTextColumn Caption="ID" FieldName="ID" Visible="False">
</dxwgv:GridViewDataTextColumn>
<dxwgv:GridViewDataTextColumn Caption="公司名称" FieldName="Customer" VisibleIndex="0">
<HeaderStyle HorizontalAlign="center" />
</dxwgv:GridViewDataTextColumn>
<dxwgv:GridViewDataTextColumn Caption="公司简称" FieldName="Abbv" VisibleIndex="1">
<HeaderStyle HorizontalAlign="center" />
</dxwgv:GridViewDataTextColumn>
<dxwgv:GridViewDataTextColumn Caption="公司地址" FieldName="Address" VisibleIndex="2">
<HeaderStyle HorizontalAlign="center" />
</dxwgv:GridViewDataTextColumn>
<dxwgv:GridViewDataTextColumn Caption="公司性质" FieldName="Nature" VisibleIndex="3">
<HeaderStyle HorizontalAlign="center" />
</dxwgv:GridViewDataTextColumn>
<dxwgv:GridViewDataTextColumn Caption="联系人" FieldName="ContactPerson" VisibleIndex="4">
<HeaderStyle HorizontalAlign="center" />
</dxwgv:GridViewDataTextColumn>
<dxwgv:GridViewDataTextColumn Caption="联系电话" FieldName="Tel" VisibleIndex="5">
<HeaderStyle HorizontalAlign="center" />
</dxwgv:GridViewDataTextColumn>
<dxwgv:GridViewDataTextColumn Caption="传真" FieldName="Fax" VisibleIndex="6">
<HeaderStyle HorizontalAlign="center" />
</dxwgv:GridViewDataTextColumn>
<dxwgv:GridViewDataTextColumn Caption="信用期限" FieldName="ExpiryDate" VisibleIndex="7">
<HeaderStyle HorizontalAlign="center" />
<PropertiesTextEdit DisplayFormatString="{0:d}"></PropertiesTextEdit>
</dxwgv:GridViewDataTextColumn>
<dxwgv:GridViewDataTextColumn Caption="信用额度" FieldName="CreditLine" VisibleIndex="8">
<HeaderStyle HorizontalAlign="center" />
<PropertiesTextEdit DisplayFormatString="{0:N2}"></PropertiesTextEdit>
</dxwgv:GridViewDataTextColumn>
</Columns>
<Settings ShowVerticalScrollBar="True" VerticalScrollableHeight="400" />
<SettingsPager>
<AllButton Text="All">
</AllButton>
<NextPageButton Text="Next >">
</NextPageButton>
<PrevPageButton Text="< Prev">
</PrevPageButton>
</SettingsPager>
<SettingsBehavior AllowFocusedRow="True" />
<Images ImageFolder="~/App_Themes/Office2003 Olive/{0}/">
<ExpandedButton Height="12px" Url="~/App_Themes/Office2003 Olive/GridView/"
Width="11px" />
<CollapsedButton Height="12px" Url="~/App_Themes/Office2003 Olive/GridView/"
Width="11px" />
<DetailCollapsedButton Height="12px" Url="~/App_Themes/Office2003 Olive/GridView/"
Width="11px" />
<DetailExpandedButton Height="12px" Url="~/App_Themes/Office2003 Olive/GridView/"
Width="11px" />
</Images>
<Styles CssFilePath="~/App_Themes/Office2003 Olive/{0}/" CssPostfix="Office2003_Olive">
<LoadingPanel ImageSpacing="10px">
</LoadingPanel>
<Header ImageSpacing="5px" SortingImageSpacing="5px">
</Header>
</Styles>
</dxwgv:ASPxGridView>
<dxwgv:ASPxGridViewExporter ID="ASPxGridViewExporter1" runat="server">
</dxwgv:ASPxGridViewExporter>
<asp:Button ID="btnExport" runat="server" Text="导出到Excel" OnClick="btnExport_Click" />
</ContentTemplate>
</asp:UpdatePanel>
<iframe style="display: none; left: 254px; position: absolute;
top: 1215px;" name="gToday:normal:" src="../js/date2/"
frameborder="0" scrolling="no"></iframe>
</form>
</body>
</html>
using System;
using ;
using ;
using ;
using ;
using ;
using ;
using ;
using ;
using ;
public partial class webpage_ColPaymentInfo :
{
public string strOp
{
get
{
object o = ViewState["op"];
return (o == null) ? "" : (string)o;
}
set
{
ViewState["op"] = value;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!)
{
BindDataToGridView();
}
if (Session["ColPaymentInfo"] != null)
{
this. = (Session["ColPaymentInfo"] as DataTable);
this.();
}
}
#region 新增
protected void btnAdd_Click(object sender, EventArgs e)
{
strOp = "Add";
}
#endregion
#region 修改
protected void btnEdit_Click(object sender, EventArgs e)
{
BindDataToPageForm();
strOp = "Edit";
}
#endregion
#region 保存
protected void btnSave_Click(object sender, EventArgs e)
{
string ID = this.(this., "ID").ToString();
if (())
{
(, "公司名称不能为空！");
return;
}
DataSet ds = new DataSet();
DataAccessManager dataaccess = new DataAccessManager();
if (("Add"))
{
("@ID", null);
}
else
{
("@ID",ID);
}
("@Customer", );
("@Abbv", () ? null : );
("@Address", () ? null : );
("@Nature", () ? null : );
("@Tel", () ? null : );
("@Fax", () ? null : );
("@ContactPerson", () ? null : );
("@Mobile", null);
("@ExpiryDate", () ? null : );
("@CreditLine", () ? null : );
("@op", strOp);
("P_SaveCollectionPaymentInfo", ref ds);
if ( > 0 && [0]. > 0)
{
(, [0].Rows[0][0].ToString());
}
BindDataToGridView();
}
#endregion
#region 删除
protected void btnDel_Click(object sender, EventArgs e)
{
string ID=this.(this.,"ID").ToString();
string sql=("delete from T_CollectionPaymentInfo where id='{0}'",ID);
int i = (sql);
BindDataToGridView();
}
#endregion
#region 绑定数据到GridView
public void BindDataToGridView()
{
string sql = "select * from T_CollectionPaymentInfo";
DataSet ds = new DataSet();
ds = (sql);
if ( > 0 && [0]. > 0)
{
Session["ColPaymentInfo"] = [0];
this. = (Session["ColPaymentInfo"] as DataTable);
this.();
}
}
#endregion
#region
public void BindDataToPageForm()
{
string ID=this.(this.,"ID").ToString();
string sql =("select * from T_CollectionPaymentInfo where ID='{0}'",ID);
dr = null;
dr=(sql);
if (())
{
= dr["Customer"].ToString();
= dr["Abbv"].ToString();
= dr["Address"].ToString();
= "";
= dr["ContactPerson"].ToString();
= (dr["CreditLine"].ToString()) ? null : (dr["CreditLine"].ToString()).ToString("#.##");
= dr["Tel"].ToString();
= dr["Fax"].ToString();
= (dr["ExpiryDate"].ToString()) ? null : (dr["ExpiryDate"].ToString()).ToString("d");
}
}
#endregion
#region 导出到Excel
protected void btnExport_Click(object sender, EventArgs e)
{
this.="ASPxGridView1";
this.();
}
#endregion
}