📄 admin.aspx.cs
字号:
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using WebDataAccess;
namespace Market.Admin
{
/// <summary>
/// write by yangyun
/// 2003-12-26
/// </summary>
public class Admin : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataGrid MarketDg;
protected Wuqi.Webdiyer.AspNetPager MarketPagerTwo;
protected Wuqi.Webdiyer.AspNetPager MarketPager;
public DataTable GetMarketDt=new DataTable();
protected System.Web.UI.WebControls.Panel Panel1;
public int StateTitle;//回复的操作状态
public int CheckFlag;//登陆判断
public int CheckPage=30;//***********************************分页常数30****************************
public string Replace(string ValBuySell)
{
string Result;
/*DataAccess GetChange=new DataAccess();
SqlConnection conn=new SqlConnection(GetChange.SqlBase);
conn.Open();
GetSort=GetChange.DisPLayList_Dt("select * from humor_type where type_id='"+ValSort+"'",conn);
if(GetSort.Rows.Count==0)
{
Result_Rep="未知类型";
}
else
{
Result_Rep=GetSort.Rows[0]["type_name"].ToString();
}*/
if(ValBuySell=="1")
{
Result="供";
}
else
{
Result="求";
}
return Result;
}
public string Limit(string ValContent)
{
string Result_Limit;
Result_Limit= ValContent.Substring(0,10);
return Result_Limit;
}
private void bin_Msg()
{
MarketDg.DataSource=GetMarketDt.DefaultView;
MarketDg.DataBind();
MarketPager.CustomInfoText="记录总数：<font color=\"blue\"><b>"+MarketPager.RecordCount.ToString()+"</b></font>";
MarketPager.CustomInfoText+=" 总页数：<font color=\"blue\"><b>"+MarketPager.PageCount.ToString()+"</b></font>";
MarketPager.CustomInfoText+=" 当前页：<font color=\"red\"><b>"+MarketPager.CurrentPageIndex.ToString()+"</b></font>";
}
private void bin_Msg_2()
{
MarketDg.DataSource=GetMarketDt.DefaultView;
MarketDg.DataBind();
MarketPagerTwo.CustomInfoText="记录总数：<font color=\"blue\"><b>"+MarketPagerTwo.RecordCount.ToString()+"</b></font>";
MarketPagerTwo.CustomInfoText+=" 总页数：<font color=\"blue\"><b>"+MarketPagerTwo.PageCount.ToString()+"</b></font>";
MarketPagerTwo.CustomInfoText+=" 当前页：<font color=\"red\"><b>"+MarketPagerTwo.CurrentPageIndex.ToString()+"</b></font>";
}
public string Checked(string ValBuySell)
{
string Result;
/*DataAccess GetChange=new DataAccess();
SqlConnection conn=new SqlConnection(GetChange.SqlBase);
conn.Open();
GetSort=GetChange.DisPLayList_Dt("select * from humor_type where type_id='"+ValSort+"'",conn);
if(GetSort.Rows.Count==0)
{
Result_Rep="未知类型";
}
else
{
Result_Rep=GetSort.Rows[0]["type_name"].ToString();
}*/
if(ValBuySell=="1")
{
Result="../images/checked.gif";
}
else
{
Result="../images/unchecked.gif";
}
return Result;
}
private void Page_Load(object sender, System.EventArgs e)
{
CheckInfo CheckBase=new CheckInfo();
CheckFlag=CheckBase.LoginFlag();
/*if(CheckFlag==0)
{
Response.Write("<script>alert('请你先登陆')<script>");
Server.Transfer("index.aspx");
}*/
/*********************************1 表示SUCCESS 0表示failure***********************************/
if(CheckFlag==0)
{
Response.Write("<script language='javascript'>alert('你不是系统管理员，要管理系统请先登陆！')</script>");
Server.Transfer("index.aspx");
}
else if(CheckFlag==1)
{
DataAccess MarketBase=new DataAccess();
SqlConnection conn=new SqlConnection(MarketBase.SqlBase);
conn.Open();
GetMarketDt=MarketBase.DisPLayList_Dt("select * from goods order by GoodsId desc",conn);
MarketPager.RecordCount=GetMarketDt.Rows.Count;
MarketPagerTwo.RecordCount=GetMarketDt.Rows.Count;
/**************************************************************************************************************************************/
if(GetMarketDt.Rows.Count<this.CheckPage)
{
MarketDg.PageSize=this.CheckPage;
}
/**************************************************************************************************************************************/
MarketDg.DataSource=GetMarketDt.DefaultView;
MarketDg.DataBind();
//this.bin_Msg();
bin_Msg_2();
}
else
{
Response.Write("<script language='javascript'>alert('系统出现未知的错误，请与系统管理员联系！')</script>");
}
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.MarketPagerTwo.PageChanged += new Wuqi.Webdiyer.PageChangedEventHandler(this.MarketPagerTwo_PageChanged);
this.MarketPager.PageChanged += new Wuqi.Webdiyer.PageChangedEventHandler(this.MarketPager_PageChanged);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void MarketPagerTwo_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
{
if(MarketDg.CurrentPageIndex==0)//点index=1时候保证PAGESIZE
{
MarketDg.PageSize=this.CheckPage;
}
/*****************************************************************************************************/
/*CheckPage=GetMarketDt.Rows.Count-MarketDg.CurrentPageIndex*MarketDg.PageSize;
if(CheckPage<MarketDg.PageSize)
{
MarketDg.PageSize=CheckPage;
//MarketPagerTwo.PageSize=CheckPage;
//MarketPager.PageSize=CheckPage;
}
else if(CheckPage>this.CheckPage)
{
MarketDg.PageSize=this.CheckPage;
MarketPagerTwo.PageSize=this.CheckPage;
MarketPager.PageSize=this.CheckPage;
}*/
/*****************************************************************************************************/
if(e.NewPageIndex==0)
{
MarketDg.CurrentPageIndex=0;
MarketPagerTwo.CurrentPageIndex=e.NewPageIndex ;
}
else
{
int tempint;
tempint=e.NewPageIndex;
//DataGrid1.CurrentPageIndex=e.NewPageIndex ;
MarketDg.CurrentPageIndex=tempint-1;
MarketPagerTwo.CurrentPageIndex=e.NewPageIndex ;
}
//ap.CurrentPageIndex=e.NewPageIndex;
//this.bin_Msg();
bin_Msg_2();
}
private void MarketPager_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
{
if(MarketDg.CurrentPageIndex==0)//点index=1时候保证PAGESIZE
{
MarketDg.PageSize=this.CheckPage;
}
/*****************************************************************************************************/
/*CheckPage=GetMarketDt.Rows.Count-(MarketDg.CurrentPageIndex+1)*MarketDg.PageSize;
if(CheckPage<MarketDg.PageSize)
{
MarketDg.PageSize=CheckPage;
//MarketPagerTwo.PageSize=CheckPage;
//MarketPager.PageSize=CheckPage;
}
else if(CheckPage>this.CheckPage)
{
MarketDg.PageSize=this.CheckPage ;
MarketPagerTwo.PageSize=this.CheckPage;
MarketPager.PageSize=this.CheckPage;
}*/
if(e.NewPageIndex==1)
{
MarketDg.CurrentPageIndex=0;
MarketPager.CurrentPageIndex=e.NewPageIndex ;
}
else
{
int tempint;
tempint=e.NewPageIndex;
//DataGrid1.CurrentPageIndex=e.NewPageIndex ;
MarketDg.CurrentPageIndex=tempint-1;
MarketPager.CurrentPageIndex=e.NewPageIndex ;
}
//ap.CurrentPageIndex=e.NewPageIndex;
//this.bin_Msg();
bin_Msg_2();
}
private void MarketDg_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
int id=int.Parse(e.Item.Cells[0].Text);
DataAccess MarketOp=new DataAccess();
SqlConnection conn=new SqlConnection(MarketOp.SqlBase);
conn.Open();
int State;
State= MarketOp.DelInfo("Delete From goods Where goodsid=' " +id+ "'",conn);
// if(conn.State.ToString()=="Close")
//{
conn.Open();
//}
StateTitle=MarketOp.DelInfo("Delete From titles Where goodsid=' " +id+ "'",conn);//对回复操作
//SqlParameter Paraconf=new SqlParameter("@conf",SqlDbType.Int,20);
//Paraconf.Value=int.Parse(typeid);
//typComm.Parameters.Add(Paraconf);
try
{
if(State==1)
{
Response.Write("<script language='javascript'>alert('操作成功')</script>");
}
//typConn.Open();
//typComm.ExecuteNonQuery();
//typConn.Close();
//upApplicatio();
//Dats();
//Response.Write(sSql11);
//Response.Write("<script language='javascript'>alert('操作成功')</script>");]
else
{
Response.Write("<script language='javascript'>alert('操作 失败！请与数据管理员联系！')</script>");
//MarketDg.DataBind();
}
}
catch(SqlException err)
{
Response.Write("<script language='javascript'>alert('"+err.Message +"')</script>");
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -