admincheck.aspx.cs

基于Asp.net、MS sql sever 2000、C# 汽车交易系统源码

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-29
	/// </summary>
	public class AdminCheck : 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 CheckFlag;//登陆判断
	
		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>";

		}


		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)
		{
			DataAccess MarketBase=new DataAccess();

			CheckInfo CheckBase=new CheckInfo();

			CheckFlag=CheckBase.LoginFlag();

			/*********************************1 表示SUCCESS 0表示failure***********************************/

			if(CheckFlag==0)

			{
				Response.Write("<script language='javascript'>alert('你不是系统管理员，要管理系统请先登陆！')</script>"); 

				Server.Transfer("index.aspx");


            
			}

			else if(CheckFlag==1)
			{
	
		  
				SqlConnection conn=new SqlConnection(MarketBase.SqlBase);


				conn.Open();


				GetMarketDt=MarketBase.DisPLayList_Dt("select * from goods where flag=0  order by protime desc",conn);

				if(GetMarketDt.Rows.Count==0)
				{
					Response.Write("<script>alert('暂时没有要审批的信息！')</script>");

					Server.Transfer("admin.aspx");


				}
				else
				{

					MarketPager.RecordCount=GetMarketDt.Rows.Count;

					MarketPagerTwo.RecordCount=GetMarketDt.Rows.Count;
            

					MarketDg.DataSource=GetMarketDt.DefaultView;


					MarketDg.DataBind();	

					this.bin_Msg();
				}
			}
			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.MarketDg.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.MarketDg_DeleteCommand);
			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(e.NewPageIndex==1)
			{
				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();
		}

		private void MarketPager_PageChanged(object src, Wuqi.Webdiyer.PageChangedEventArgs e)
		{
			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();
		}

		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);

			//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>");

					MarketDg.DataBind();



				}

					//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>");
			}
            

		}
	}
}