default.aspx.cs

这是自己曾经参与开发的轻纺管理系统B/S版,有一定的研究价值!

using System;
using WebBase;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
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.Web.Security;

namespace TextileManager
{
	public partial class Default : WebBase.GsDataPage
	{
	
		protected void Page_Load(object sender, System.EventArgs e){
			if (!IsPostBack) {
				TextBoxUserName.Text="Emily"; TextBoxPassword.Text="emily";
				ButtonConfirm_Click(null,null);
			}
		
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			
			InitializeComponent();
			base.OnInit(e);
		}
		
		private void InitializeComponent()
		{    

		}
		#endregion

		protected void ButtonConfirm_Click(object sender, System.EventArgs e) {
			Db.DataSource="GS1"; string password=TextBoxPassword.Text;
			Gbl.MainPage=this; Db.InitialCatalog="Textile";
#if DEBUG
			if (password=="" && TextBoxUserName.Text=="Emily") password="emily";
#endif
			Db.CreateConnection(TextBoxUserName.Text.Trim(),password);
			if (Db.OpenCnn()) {
				FormsAuthentication.RedirectFromLoginPage(TextBoxUserName.Text.Trim(),false);//告诉应用程序该用户已经通过证书检验
				string sql="SELECT 姓名,部门 FROM 员工表 WHERE 代码='"+TextBoxUserName.Text+"'";
				SqlDataReader dr=WebBase.Sql.RunReader(sql);
				if (!dr.Read()) {
					Gbl.ShowErrorMsg("非本单位员工，登陆失败！");
					dr.Close(); Db.CloseCnn(); return;
				}
				Session["UserName"]=Db.CaoZuoYuan=dr["姓名"].ToString();
				Session["Department"]=dr["部门"].ToString();
				//Session["Purview"]=dr["权限"].ToString();
				dr.Close(); Db.CaoZuoYuanGroup=0; Db.CaoZuoYuanCode=TextBoxUserName.Text;
				dr=Sql.RunReader("EXEC sp_helpuser '"+Session["UserName"]+"'");
				while (dr.Read()) {
					switch ((string)dr["GroupName"]) {
					case "db_owner": Db.CaoZuoYuanGroup|=Qx.管理员组; Db.CaoZuoYuanQuanXianFix|=Qx.管理权限; break;
					case "完全权限组": Db.CaoZuoYuanGroup|=Qx.完全权限组; Db.CaoZuoYuanQuanXianFix|=Qx.完全权限; break;
					case "财务组": Db.CaoZuoYuanGroup|=Qx.财务组; Db.CaoZuoYuanQuanXianFix|=Qx.财务权限; break;
					case "业务组": Db.CaoZuoYuanGroup|=Qx.业务组; Db.CaoZuoYuanQuanXianFix|=Qx.业务权限; break;
					case "操作员组": Db.CaoZuoYuanGroup|=Qx.操作员组; Db.CaoZuoYuanQuanXianFix|=Qx.操作权限; break;
					case "查询组": Db.CaoZuoYuanGroup|=Qx.查询组; Db.CaoZuoYuanQuanXianFix|=Qx.查询权限; break;
					}
				} dr.Close();
				Response.Redirect("SystemPage.aspx");
			}
			else
				Gbl.ShowErrorMsg("密码或用户名错误!");
					//Response.Redirect("ErrorPage.aspx?ErrorText='密码或用户名错误'");
			
		}

	}
}