Default.aspx
using
System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
namespace WebApplication1
... {
public partial class _Default : System.Web.UI.Page
...{
protected void Page_Load(object sender, EventArgs e)
...{
if (!IsPostBack)
...{
this.labPage.Text = "1";
this.contrlRepeater();
}
}
//Repeater分页控制显示方法
public void contrlRepeater()
...{
DataSet ds = Portfolio.GetHistory(23);
PagedDataSource pds = new PagedDataSource();
pds.DataSource = ds.Tables[0].DefaultView;
pds.AllowPaging = true;
pds.PageSize = 2;
pds.CurrentPageIndex = Convert.ToInt32(this.labPage.Text) - 1;
rpPortfolioHistory.DataSource = pds;
LabCountPage.Text = pds.PageCount.ToString();
labPage.Text = (pds.CurrentPageIndex + 1).ToString();
this.lbtnpritPage.Enabled = true;
this.lbtnFirstPage.Enabled = true;
this.lbtnNextPage.Enabled = true;
this.lbtnDownPage.Enabled = true;
if (pds.CurrentPageIndex < 1)
...{
this.lbtnpritPage.Enabled = false;
this.lbtnFirstPage.Enabled = false;
}
if (pds.CurrentPageIndex == pds.PageCount - 1)
...{
this.lbtnNextPage.Enabled = false;
this.lbtnDownPage.Enabled = false;
}
rpPortfolioHistory.DataBind();
}
//获取指字符个数的字符
public string cuts(string aa, int bb)
...{
if (aa.Length <= bb) ...{ return aa; }
else ...{ return aa.Substring(0, bb); }
}
protected void lbtnpritPage_Click(object sender, EventArgs e)
...{
this.labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) - 1);
this.contrlRepeater();
}
protected void lbtnFirstPage_Click(object sender, EventArgs e)
...{
this.labPage.Text = "1";
this.contrlRepeater();
}
protected void lbtnDownPage_Click(object sender, EventArgs e)
...{
this.labPage.Text = this.LabCountPage.Text;
this.contrlRepeater();
}
protected void lbtnNextPage_Click(object sender, EventArgs e)
...{
this.labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) + 1);
this.contrlRepeater();
}
//protected void Page_Load(object sender, EventArgs e)
//{
// DataSet ds = Portfolio.GetHistory(23);
// if (ds != null && ds.Tables[0] != null)
// {
// rpPortfolioHistory.DataSource = ds.Tables[0];
// rpPortfolioHistory.DataBind();
// }
//}
protected string FormatType(int TransactionType)
...{
if (TransactionType == 1)
return "观察";
else if (TransactionType == 2)
return "申购";
else if (TransactionType == 3)
return "申购";
else if (TransactionType == 4)
return "赎回";
else if (TransactionType == 5)
return "买入";
else if (TransactionType == 6)
return "卖出";
else if (TransactionType == 7)
return "现金分红";
else if (TransactionType == 8)
return "拆分";
else if (TransactionType == 9)
return "红利再投资";
else
return "未知交易";
}
}
}
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
namespace WebApplication1
... {
public partial class _Default : System.Web.UI.Page
...{
protected void Page_Load(object sender, EventArgs e)
...{
if (!IsPostBack)
...{
this.labPage.Text = "1";
this.contrlRepeater();
}
}
//Repeater分页控制显示方法
public void contrlRepeater()
...{
DataSet ds = Portfolio.GetHistory(23);
PagedDataSource pds = new PagedDataSource();
pds.DataSource = ds.Tables[0].DefaultView;
pds.AllowPaging = true;
pds.PageSize = 2;
pds.CurrentPageIndex = Convert.ToInt32(this.labPage.Text) - 1;
rpPortfolioHistory.DataSource = pds;
LabCountPage.Text = pds.PageCount.ToString();
labPage.Text = (pds.CurrentPageIndex + 1).ToString();
this.lbtnpritPage.Enabled = true;
this.lbtnFirstPage.Enabled = true;
this.lbtnNextPage.Enabled = true;
this.lbtnDownPage.Enabled = true;
if (pds.CurrentPageIndex < 1)
...{
this.lbtnpritPage.Enabled = false;
this.lbtnFirstPage.Enabled = false;
}
if (pds.CurrentPageIndex == pds.PageCount - 1)
...{
this.lbtnNextPage.Enabled = false;
this.lbtnDownPage.Enabled = false;
}
rpPortfolioHistory.DataBind();
}
//获取指字符个数的字符
public string cuts(string aa, int bb)
...{
if (aa.Length <= bb) ...{ return aa; }
else ...{ return aa.Substring(0, bb); }
}
protected void lbtnpritPage_Click(object sender, EventArgs e)
...{
this.labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) - 1);
this.contrlRepeater();
}
protected void lbtnFirstPage_Click(object sender, EventArgs e)
...{
this.labPage.Text = "1";
this.contrlRepeater();
}
protected void lbtnDownPage_Click(object sender, EventArgs e)
...{
this.labPage.Text = this.LabCountPage.Text;
this.contrlRepeater();
}
protected void lbtnNextPage_Click(object sender, EventArgs e)
...{
this.labPage.Text = Convert.ToString(Convert.ToInt32(labPage.Text) + 1);
this.contrlRepeater();
}
//protected void Page_Load(object sender, EventArgs e)
//{
// DataSet ds = Portfolio.GetHistory(23);
// if (ds != null && ds.Tables[0] != null)
// {
// rpPortfolioHistory.DataSource = ds.Tables[0];
// rpPortfolioHistory.DataBind();
// }
//}
protected string FormatType(int TransactionType)
...{
if (TransactionType == 1)
return "观察";
else if (TransactionType == 2)
return "申购";
else if (TransactionType == 3)
return "申购";
else if (TransactionType == 4)
return "赎回";
else if (TransactionType == 5)
return "买入";
else if (TransactionType == 6)
return "卖出";
else if (TransactionType == 7)
return "现金分红";
else if (TransactionType == 8)
return "拆分";
else if (TransactionType == 9)
return "红利再投资";
else
return "未知交易";
}
}
}
Portfolio.cs
using
System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace WebApplication1
... {
public class Portfolio
...{
public static DataSet GetHistory(int portfolioid)
...{
SqlParameter[] parameters = ...{
new SqlParameter("@PortfolioId",SqlDbType.Int)
};
parameters[0].Value = portfolioid;
return DbHelperSQL.RunProcedure("sp_GetportfolioHistory", parameters, "result");
}
}
}
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Data.SqlClient;
namespace WebApplication1
... {
public class Portfolio
...{
public static DataSet GetHistory(int portfolioid)
...{
SqlParameter[] parameters = ...{
new SqlParameter("@PortfolioId",SqlDbType.Int)
};
parameters[0].Value = portfolioid;
return DbHelperSQL.RunProcedure("sp_GetportfolioHistory", parameters, "result");
}
}
}