常用代码

//绑定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>条记录&nbsp;
      页次：
<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>页&nbsp;
<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>&nbsp;
      到
<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>