//绑定DropDownList
using(DbManager objManager = new DbManager())
{
DataAccess objAccess = new DataAccess(objManager);
DataSet objDataSet = new DataSet();
objAccess.QueryByWhere(ref objDataSet," WHERE 后的条件");
PubFun objFun = new PubFun();
objFun.BindDropDownList(this.ddlst,objDataSet,"显示文本","编号");
}
//绑定DataGrid
using(DbManager objDbManager = new DbManager())
{
try
{
DataAccess objAccess = new DataAccess(objDbManager);
DataSet objDataSet = new DataSet();
string strSQL = "SELECT * FROM TABLE";
objAccess.QueryBySql(ref objDataSet,strSQL);
PubFun objPub = new PubFun();
objPub.BindDataGrid(DataGrid,objDataSet,lblRecordCount,lblPageCount,lblCurrentIndex,lblPageRecordCount,btnFirst,btnNext,btnPrev,btnLast);
}
catch(Exception ex)
{
string strTemp = ex.Message;
}
}
//替代DataGrid某列的值
public string DisplayText(object myObect)
{
if(myObect == null)
return "";
try
{
int intMyObect = Convert.ToInt32(myObect.ToString());
switch(intMyObect)
{
case 1:return "状态1";
case 2:return "状态2";
case 3:return "状态3";
default:return "";
}
/*
另一中转换方法
string strText = "",strText1="";
strText1 = Convert.ToString(myObect);
for(int i = 0;i<this.ddlst.Items.Count;i++)
{
ddlst.SelectedIndex = i;
if(strText1 == ddlst.SelectedItem.Value)
{
strText = this.ddlst.SelectedItem.Text;
ddlst.SelectedIndex = 0;
break;
}
}
return strText;
*/
}
catch(Exception)
{return "<font style='COLOR: blue'>-</font>";}
}
/*
//一常用的DataGrid
<asp:datagrid id="DataGrid" runat="server" Width="100%" PageSize="10" BorderStyle="Outset" BorderWidth="1px"
BorderColor="Gray" GridLines="Horizontal" AutoGenerateColumns="False" AllowPaging="True" CellPadding="3"
PagerStyle-HorizontalAlign="Center" BackColor="White" Font-Size="10pt" ForeColor="Black" CssClass="unnamed2">
<SelectedItemStyle Font-Bold="True" ForeColor="#000033"></SelectedItemStyle>
<AlternatingItemStyle BackColor="#F0F0F0"></AlternatingItemStyle>
<HeaderStyle ForeColor="White" BackColor="#003CA0"></HeaderStyle>
<FooterStyle ForeColor="#4A3C8C" BackColor="#B5C7DE"></FooterStyle>
<Columns>
<asp:BoundColumn DataField="字段名" HeaderText="字段描述">
<ItemStyle Width="8%"></ItemStyle>
</asp:BoundColumn>
<asp:BoundColumn DataField="字段名" HeaderText="字段描述">
<ItemStyle Width="32%"></ItemStyle>
</asp:BoundColumn>
<asp:TemplateColumn HeaderText="字段描述">
<ItemStyle Width="8%"></ItemStyle>
<ItemTemplate>
<%# ConvertAuthor(DataBinder.Eval(Container.DataItem,"字段名")) %>
</ItemTemplate>
</asp:TemplateColumn>
</Columns>
<PagerStyle Visible="False" HorizontalAlign="Right" ForeColor="#4A3C8C" BackColor="#E7E7FF"
Mode="NumericPages"></PagerStyle>
</asp:datagrid>
//分页代码(HTML部分)
<asp:panel id="pnlCommon" runat="server" Width="100%" Font-Size="X-Small" Height="100%">共
<asp:Label id="lblRecordCount" runat="server" ForeColor="Blue" Font-Bold="True"></asp:Label>条记录
页次:
<asp:Label id="lblCurrentIndex" runat="server" ForeColor="Blue" Font-Bold="True"></asp:Label>/
<asp:Label id="lblPageCount" runat="server" ForeColor="Blue" Font-Bold="True"></asp:Label>页
<asp:Label id="lblPageRecordCount" runat="server" ForeColor="Blue" Font-Bold="True"></asp:Label>条/页
<asp:LinkButton id="btnFirst" οnclick="PagerButtonClick" runat="server" CommandArgument="0">[首页]</asp:LinkButton>
<asp:LinkButton id="btnPrev" οnclick="PagerButtonClick" runat="server" CommandArgument="Prev">[上一页]</asp:LinkButton>
<asp:LinkButton id="btnNext" οnclick="PagerButtonClick" runat="server" CommandArgument="Next">[下一页]</asp:LinkButton>
<asp:LinkButton id="btnLast" οnclick="PagerButtonClick" runat="server" CommandArgument="Last">[尾页]</asp:LinkButton>
到
<asp:DropDownList id="ddlPage" style="Z-INDEX: -1; POSITION: absolute" runat="server" AutoPostBack="True"></asp:DropDownList></asp:panel>
*/
#region 分页
public void PagerButtonClick(object sender, EventArgs e)
{
string arg = ((LinkButton)sender).CommandArgument.ToString();
switch(arg)
{
case "Next":
if (DataGrid.CurrentPageIndex < (DataGrid.PageCount - 1))
{
DataGrid.CurrentPageIndex += 1;
ddlPage.SelectedIndex = DataGrid.CurrentPageIndex;
}
break;
case "Prev":
if (DataGrid.CurrentPageIndex > 0)
{
DataGrid.CurrentPageIndex -= 1;
ddlPage.SelectedIndex = DataGrid.CurrentPageIndex;
}
break;
case "Last":
{
DataGrid.CurrentPageIndex = (DataGrid.PageCount - 1);
ddlPage.SelectedIndex = DataGrid.CurrentPageIndex;
}
break;
default:
{
DataGrid.CurrentPageIndex = System.Convert.ToInt32(arg);
ddlPage.SelectedIndex = DataGrid.CurrentPageIndex;
}
break;
}
BindDataGrid();
}
#endregion
private void DataGrid_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
DataGrid.CurrentPageIndex = e.NewPageIndex ;
BindDataGrid();
}
private void DataGrid_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemIndex>=0)
{
//鼠标放上去DataGrid变色---------------------------------
e.Item.Attributes.Add("onmouseover","MoveOver(this)");
e.Item.Attributes.Add("onmouseout","MoveOut(this)");
//-------------------------------------------------------
//鼠标单击DataGrid变色-----------------------------------
e.Item.Attributes.Add("onclick","Onclick(this)");
//-------------------------------------------------------
//e.Item.Attributes.Add("ondblclick","OnUpdate()");
}
}
/*
HTML页面编辑代码
function OnUpdate()
{
var objDataGrid,rol,Delcolor;
objDataGrid=document.getElementById("DataGrid");
for(var i=1;i<objDataGrid.rows.length;i++)
{
rol=objDataGrid.rows.item(i);
if(rol.style.backgroundColor=="#6699ff")
{
Delcolor="#6699ff";
var str="listEdit.aspx?strCode=" + Trim(rol.cells[0].innerText);
var strFeatures="dialogWidth:500px;dialogHeight:260px;status:off;help:no;scroll:no";
showModalDialog(str,"",strFeatures);
__doPostBack('btnRefresh', '');
}
}
if(Delcolor!="#6699ff")
{
//提示用户选择记录
}
}
/
编辑/新增页面
<HEAD>
<base target="_self">
</HEAD>
if(!IsPostBack)
{
Response.Expires = 0 ;
Response.Cache.SetNoStore() ;
Response.AppendHeader("Pragma", "no-cache") ;
//...........
}
//关闭窗体
RegisterStartupScript("on","<script language=/"javascript/">window.close();</script>");
*/
private void ddlPage_SelectedIndexChanged(object sender, System.EventArgs e)
{
DataGrid.CurrentPageIndex = ddlPage.SelectedIndex ;
BindDataGrid();
}
//更新数据后刷新页面
private void btnRefresh_Click(object sender, System.EventArgs e)
{
DataGrid.CurrentPageIndex = int.Parse(lblCurrentIndex.Text) - 1 ;
BindDataGrid();
}
//清空文本框
private void ClearAllTextBoxText(Control c)
{
if(c is TextBox)
{
((TextBox)c).Text = "";
}
else if(c.Controls.Count > 0)
{
foreach(Control cc in c.Controls)
{
ClearAllTextBoxText(cc);
}
}
}
//实体类的构造方法(实体类继承BaseAccess类)
#region 构造函数
public 类名(DbManager objDbManager) : base(objDbManager)
{
this._TableName = "表名";
this._PKName = "主健名";
}
#endregion
//Global.asax.cs类代码(获取配置文件里数据库连接字符信息)
protected void Application_Start(Object sender, EventArgs e)
{
Common.Config.OnApplicationStart(Context.Server.MapPath( Context.Request.ApplicationPath ));
}
//Web.config文件
<configSections>
<section name="ComConfig" type="Common.Config,Common"/>
</configSections>
<ComConfig>
<add key="ComConfig.DataAccess.ConnectionString" value="server=localhost;uid=sa;pwd=;database=50277"/>
</ComConfig>