📄 config.cs
字号:
if (File.Exists(Server.MapPath(img[j])))
{
File.Delete(Server.MapPath(img[j]));
}
}
}
}
string strDelSql="delete from "+tablename+" where "+id+"="+myLabel.Text;
ExeSql(strDelSql);
}
}
}
/// <summary>
/// 通过SqlCommandBuilder对象增加数据库记录
/// </summary>
/// <param name="sql">Select-SQL语句</param>
public void Builder(string sql)
{
myAdapter=new SqlDataAdapter(sql,myConnection);
myCommandBuilder=new SqlCommandBuilder(myAdapter);
ds=new DataSet();
myAdapter.Fill(ds);
dr=ds.Tables[0].NewRow();
}
/// <summary>
/// 通过SqlCommandBuilder对象修改数据库记录
/// </summary>
/// <param name="sql">Select-SQL语句</param>
public void BuilderEdit(string sql)
{
myAdapter=new SqlDataAdapter(sql,myConnection);
myCommandBuilder=new SqlCommandBuilder(myAdapter);
ds=new DataSet();
myAdapter.Fill(ds);
dr=ds.Tables[0].Rows[0];
}
// 2.——————————————————操作函数——————————————————————
/// <summary>
/// 在DataGrid控件中删除数据库记录时记录前面复选框的全选或全取消操作
/// </summary>
/// <param name="cb_Id">每条记录前CheckBox控件id值</param>
/// <param name="cb_SelectCancel">确定/取消功能CheckBox控件id值</param>
/// <param name="myDataGrid">DataGrid控件id值</param>
public void SelectCancel(string cb_Id,CheckBox cb_SelectCancel,DataGrid myDataGrid)
{
CheckBox myCheckBox;
for (int i=0;i<myDataGrid.Items.Count;i++)
{
myCheckBox=(CheckBox)myDataGrid.Items[i].FindControl(cb_Id);
if(cb_SelectCancel.Checked==true)
myCheckBox.Checked=true;
else
myCheckBox.Checked=false;
}
}
/// <summary>
/// Repeater控件中删除数据库记录时记录前面复选框的全选或全取消操作
/// </summary>
/// <param name="cb_Id">每条记录前CheckBox控件id值</param>
/// <param name="cb_SelectCancel">确定/取消功能CheckBox控件id值</param>
/// <param name="myDataGrid">DataGrid控件id值</param>
public void SelectCancel(string cb_Id,CheckBox cb_SelectCancel,Repeater myDataGrid)
{
CheckBox myCheckBox;
for (int i=0;i<myDataGrid.Items.Count;i++)
{
myCheckBox=(CheckBox)myDataGrid.Items[i].FindControl(cb_Id);
if(cb_SelectCancel.Checked==true)
myCheckBox.Checked=true;
else
myCheckBox.Checked=false;
}
}
// 3.——————————————————控件绑定函数——————————————————————
/// <summary>
/// 绑定DataGrid控件并显示数据
/// </summary>
/// <param name="str_Sql">Select-SQL语句</param>
/// <param name="mydatagrid">DataGrid控件id值</param>
public void BindDataGrid(string str_Sql,DataGrid mydatagrid)
{
Fill(str_Sql);
mydatagrid.DataSource=ds.Tables[0].DefaultView;
mydatagrid.DataBind();
myConnection.Close();
}
/// <summary>
/// 绑定DataList控件并显示数据
/// </summary>
/// <param name="sql">Select-SQL语句</param>
/// <param name="mydatalist">DataList控件id值</param>
public void BindDataList(string sql,DataList mydatalist)
{
Fill(sql);
mydatalist.DataSource=ds.Tables[0].DefaultView;
mydatalist.DataBind();
}
/// <summary>
/// 绑定Repeater控件并显示数
/// </summary>
/// <param name="sql">Select-SQL语句</param>
/// <param name="myrepeater">Repeater控件id值</param>
public void BindRepeater(string sql,Repeater myrepeater)
{
Fill(sql);
myrepeater.DataSource=ds.Tables[0].DefaultView;
myrepeater.DataBind();
}
/// <summary>
/// Repeater控件分页程序，首次加载第一页
/// </summary>
/// <param name="int_PageSize">每页加载数据库表的记录数,也就是每页显示几条记录,一般设为20</param>
/// <param name="str_Sql">Select-SQL语句</param>
/// <param name="lbl_PageMessage">每页信息，包括每页要显示记录数,总记录,当前页数,比如:[ 1 ] / [ 1 ], 总记录数:[ 1 ]</param>
/// <param name="lnkbtn_First">linkbotton控件id值,单击后连接到第一页</param>
/// <param name="lnkbtn_Prev">linkbotton控件id值,单击后连接到当前页的上一页</param>
/// <param name="lnkbtn_Next">linkbotton控件id值,单击后连接到当前页的下一页</param>
/// <param name="lnkbtn_Last">linkbotton控件id值,单击后连接到最后一页</param>
/// <param name="myRepeater">Repeater控件id值</param>
public void RepeaterPageLoad(string str_Sql,Label lbl_Pagesize,Label lbl_PageMessage,LinkButton lnkbtn_First,LinkButton lnkbtn_Prev,LinkButton lnkbtn_Next,LinkButton lnkbtn_Last,Repeater myRepeater)
{
ds=new DataSet();
SqlDataAdapter myAdapter1=new SqlDataAdapter(str_Sql,myConnection);
myAdapter1.Fill(ds,"pagecount");
int CurrentPage=1; // 当前的页数
int PageSize=int.Parse(lbl_Pagesize.Text); // 每页记录数
int int_RecordCount=ds.Tables[0].Rows.Count; // 总记录数
int int_PageCount; // 总页数
if (int_RecordCount!=0)
{
if (int_RecordCount%PageSize==0)
{
int_PageCount=int_RecordCount/PageSize; // 获得总页数
}
else
{
int_PageCount=int_RecordCount/PageSize+1; // 获得总页数
}
}
else
{
int_PageCount=1;
}
lbl_PageMessage.Text="[ "+(CurrentPage).ToString()+" ] / [ "+int_PageCount.ToString()+" ], 总记录数：[ "+int_RecordCount.ToString()+" ]";// 获得页信息
myAdapter1.Fill(ds,0,PageSize,"news");
myRepeater.DataSource=ds.Tables["news"].DefaultView;
myRepeater.DataBind();
if (CurrentPage==1)
{
lnkbtn_First.Enabled=false;
lnkbtn_Prev.Enabled=false;
}
else
{
lnkbtn_First.Enabled=true;
lnkbtn_Prev.Enabled=true;
}
if (int_PageCount==CurrentPage)
{
lnkbtn_Next.Enabled=false;
lnkbtn_Last.Enabled=false;
}
else
{
lnkbtn_Next.Enabled=true;
lnkbtn_Last.Enabled=true;
}
}
/// <summary>
/// RepeaterPageLoad控件分页程序，单击“下一页”，所做的显示
/// </summary>
/// <param name="str_Sql">Select-SQL语句</param>
/// <param name="lbl_PageMessage">每页信息，包括每页要显示记录数,总记录,当前页数,比如:[ 1 ] / [ 1 ], 总记录数:[ 1 ]</param>
/// <param name="lnkbtn_First">linkbotton控件id值,单击后连接到第一页</param>
/// <param name="lnkbtn_Prev">linkbotton控件id值,单击后连接到当前页的上一页</param>
/// <param name="lnkbtn_Next">linkbotton控件id值,单击后连接到当前页的下一页</param>
/// <param name="lnkbtn_Last">linkbotton控件id值,单击后连接到最后一页</param>
/// <param name="myRepeater">Repeater控件id值</param>
public void RepeaterPageNext(string str_Sql,Label lbl_Pagesize,Label lbl_PageMessage,LinkButton lnkbtn_First,LinkButton lnkbtn_Prev,LinkButton lnkbtn_Next,LinkButton lnkbtn_Last,Repeater myRepeater)
{
ds=new DataSet();
SqlDataAdapter myAdapter1=new SqlDataAdapter(str_Sql,myConnection);
int CurrentPage=int.Parse(GetTwoMiddleFirstStr(lbl_PageMessage.Text,"[","]")); // 当前的页数
CurrentPage=CurrentPage+1;
int int_RecordCount=int.Parse(GetTwoMiddleLastStr(lbl_PageMessage.Text,"[","]")); // 获得总记录数
int int_PageCount=int.Parse(GetTwoMiddleFirstStr(GetLastStr(lbl_PageMessage.Text,"/"),"[","]")); // 获得总页数
int startRecord = (CurrentPage-1)*int.Parse(lbl_Pagesize.Text);
lbl_PageMessage.Text="[ "+CurrentPage.ToString()+" ] / [ "+int_PageCount.ToString()+" ], 总记录数：[ "+int_RecordCount.ToString()+" ]";// 获得页信息
myAdapter1.Fill(ds,startRecord,int.Parse(lbl_Pagesize.Text),"news");
myRepeater.DataSource=ds.Tables["news"].DefaultView;
myRepeater.DataBind();
if (CurrentPage==1)
{
lnkbtn_First.Enabled=false;
lnkbtn_Prev.Enabled=false;
}
else
{
lnkbtn_First.Enabled=true;
lnkbtn_Prev.Enabled=true;
}
if (int_PageCount==CurrentPage)
{
lnkbtn_Next.Enabled=false;
lnkbtn_Last.Enabled=false;
}
else
{
lnkbtn_Next.Enabled=true;
lnkbtn_Last.Enabled=true;
}
}
/// <summary>
/// RepeaterPageLoad控件分页程序,单击"上一页",所做的显示
/// </summary>
/// <param name="str_Sql">Select-SQL语句</param>
/// <param name="lbl_PageMessage">每页信息，包括每页要显示记录数,总记录,当前页数,比如:[ 1 ] / [ 1 ], 总记录数:[ 1 ]</param>
/// <param name="lnkbtn_First">linkbotton控件id值,单击后连接到第一页</param>
/// <param name="lnkbtn_Prev">linkbotton控件id值,单击后连接到当前页的上一页</param>
/// <param name="lnkbtn_Next">linkbotton控件id值,单击后连接到当前页的下一页</param>
/// <param name="lnkbtn_Last">linkbotton控件id值,单击后连接到最后一页</param>
/// <param name="myRepeater">Repeater控件id值</param>
public void RepeaterPagePrev(string str_Sql,Label lbl_Pagesize,Label lbl_PageMessage,LinkButton lnkbtn_First,LinkButton lnkbtn_Prev,LinkButton lnkbtn_Next,LinkButton lnkbtn_Last,Repeater myRepeater)
{
ds=new DataSet();
SqlDataAdapter myAdapter1=new SqlDataAdapter(str_Sql,myConnection);
int CurrentPage=int.Parse(GetTwoMiddleFirstStr(lbl_PageMessage.Text,"[","]")); // 当前的页数
CurrentPage=CurrentPage-1;
int int_RecordCount=int.Parse(GetTwoMiddleLastStr(lbl_PageMessage.Text,"[","]")); // 获得总记录数
int int_PageCount=int.Parse(GetTwoMiddleFirstStr(GetLastStr(lbl_PageMessage.Text,"/"),"[","]")); // 获得总页数
int startRecord = (CurrentPage-1)*int.Parse(lbl_Pagesize.Text);
lbl_PageMessage.Text="[ "+CurrentPage.ToString()+" ] / [ "+int_PageCount.ToString()+" ], 总记录数：[ "+int_RecordCount.ToString()+" ]";// 获得页信息
myAdapter1.Fill(ds,startRecord,int.Parse(lbl_Pagesize.Text),"news");
myRepeater.DataSource=ds.Tables["news"].DefaultView;
myRepeater.DataBind();
if (CurrentPage==1)
{
lnkbtn_First.Enabled=false;
lnkbtn_Prev.Enabled=false;
}
else
{
lnkbtn_First.Enabled=true;
lnkbtn_Prev.Enabled=true;
}
if (int_PageCount==CurrentPage)
{
lnkbtn_Next.Enabled=false;
lnkbtn_Last.Enabled=false;
}
else
{
lnkbtn_Next.Enabled=true;
lnkbtn_Last.Enabled=true;
}
}
/// <summary>
/// RepeaterPageLoad控件分页程序，单击“首页”，所做的显示
/// </summary>
/// <param name="str_Sql">Select-SQL语句</param>
/// <param name="lbl_PageMessage">每页信息，包括每页要显示记录数,总记录,当前页数,比如:[ 1 ] / [ 1 ], 总记录数:[ 1 ]</param>
/// <param name="lnkbtn_First">linkbotton控件id值,单击后连接到第一页</param>
/// <param name="lnkbtn_Prev">linkbotton控件id值,单击后连接到当前页的上一页</param>
/// <param name="lnkbtn_Next">linkbotton控件id值,单击后连接到当前页的下一页</param>
/// <param name="lnkbtn_Last">linkbotton控件id值,单击后连接到最后一页</param>
/// <param name="myRepeater">Repeater控件id值</param>
public void RepeaterPageFirst(string str_Sql,Label lbl_Pagesize,Label lbl_PageMessage,LinkButton lnkbtn_First,LinkButton lnkbtn_Prev,LinkButton lnkbtn_Next,LinkButton lnkbtn_Last,Repeater myRepeater)
{
ds=new DataSet();
SqlDataAdapter myAdapter1=new SqlDataAdapter(str_Sql,myConnection);
int CurrentPage=1; // 当前的页数
int int_RecordCount=int.Parse(GetTwoMiddleLastStr(lbl_PageMessage.Text,"[","]")); // 获得总记录数
int int_PageCount=int.Parse(GetTwoMiddleFirstStr(GetLastStr(lbl_PageMessage.Text,"/"),"[","]")); // 获得总页数
lbl_PageMessage.Text="[ "+CurrentPage.ToString()+" ] / [ "+int_PageCount.ToString()+" ], 总记录数：[ "+int_RecordCount.ToString()+" ]";// 获得页信息
myAdapter1.Fill(ds,0,int.Parse(lbl_Pagesize.Text),"news");
myRepeater.DataSource=ds.Tables["news"].DefaultView;
myRepeater.DataBind();
if (CurrentPage==1)
{
lnkbtn_First.Enabled=false;
lnkbtn_Prev.Enabled=false;
}
else
{
lnkbtn_First.Enabled=true;
lnkbtn_Prev.Enabled=true;
}
if (int_PageCount==CurrentPage)
{
lnkbtn_Next.Enabled=false;
lnkbtn_Last.Enabled=false;
}
else
{
lnkbtn_Next.Enabled=true;
lnkbtn_Last.Enabled=true;
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -