driversmng.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;

namespace Views.Car
{
	/// <summary>
	/// DriversMng 的摘要说明。
	/// </summary>
	public class DriversMng : Views.CarModule.CarPage
	{
		protected System.Web.UI.WebControls.LinkButton LinkButton1;
		protected System.Web.UI.HtmlControls.HtmlTableRow trUserID;
		protected System.Web.UI.WebControls.LinkButton Linkbutton2;
		protected System.Web.UI.WebControls.CheckBox cbNewUser;
		protected System.Web.UI.WebControls.DropDownList ddlDriverType;
		protected System.Web.UI.WebControls.Label lblDriverID;
		protected System.Web.UI.WebControls.Label lblDriverName;
		protected System.Web.UI.WebControls.DropDownList ddlDriverName;
		protected System.Web.UI.WebControls.DataGrid dgDriver;
		protected System.Web.UI.WebControls.TextBox txtDriverMemo;
		private int m_iCurDriverID;
		protected Views.Car.Ascxs.PicDate dateStart;
		protected Views.Car.Ascxs.PicDate dateCheck;
	
		//
		//页面加载事件代理函数
		//
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			try
			{
				this.m_iCurDriverID=(int)this.ViewState["CurDriverID"];
			}
			catch
			{
				this.m_iCurDriverID=-1;
			}
		}
		//
		//页面预输出事件代理函数
		//
		private void Page_PreRender(object sender, System.EventArgs e)
		{
			if(!this.theUserInfo.IsAdmin)
			{
				this.Alert("对不起，您不是管理员，不能进行系统管理。");
				this.WriteJS("window.location='/';");
				return;
			}
			System.Data.DataView dvTmp;
			dvTmp=this.DB.DriversData.DefaultView;
			this.dgDriver.DataSource=dvTmp;
			this.dgDriver.DataKeyField="DriverID";
			this.dgDriver.DataBind();
			this.ddlDriverName.DataSource=this.DB.UsersData;
			this.ddlDriverName.DataTextField="UserName";
			this.ddlDriverName.DataValueField="UserID";
			this.ddlDriverName.DataBind();
			if(this.dgDriver.SelectedIndex>=0)
				this.m_iCurDriverID=(int)this.dgDriver.DataKeys[this.dgDriver.SelectedIndex];
			else
				this.m_iCurDriverID=-1;
			if(this.m_iCurDriverID>0)
			{
				dvTmp=this.DB.GetData("Drivers",1,"DriverID="+this.m_iCurDriverID.ToString(),null).DefaultView;
				this.lblDriverID.Text=dvTmp[0]["DriverID"].ToString();
				this.lblDriverName.Text=this.DB.RunScalar("UserName","Users","UserID="+dvTmp[0]["UserID"].ToString(),null).ToString();
				this.txtDriverMemo.Text=dvTmp[0]["Memo"].ToString();
				this.dateStart.DateString=((System.DateTime)dvTmp[0]["StartDate"]).ToLongDateString();
				this.dateCheck.DateString=((System.DateTime)dvTmp[0]["CheckDate"]).ToLongDateString();
				this.SetDefaultItem(this.ddlDriverType,dvTmp[0]["DriverType"].ToString());
				this.ddlDriverName.Visible=false;
				this.lblDriverName.Visible=true;
			}
			else
			{
				this.ddlDriverName.Visible=true;
				this.lblDriverName.Visible=false;
				this.ddlDriverName.DataSource=this.DB.GetData("UserID,UserName","Users",-1,"DeptID>0 And UserID not in (Select UserID From Drivers)",null);
				this.ddlDriverName.DataTextField="UserName";
				this.ddlDriverName.DataValueField="UserID";
				this.ddlDriverName.DataBind();
				this.trUserID.Visible=false;
				this.cbNewUser.Checked=true;
			}
			this.ViewState["CurDriverID"]=this.m_iCurDriverID;
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.cbNewUser.CheckedChanged += new System.EventHandler(this.cbNewUser_CheckedChanged);
			this.LinkButton1.Command += new System.Web.UI.WebControls.CommandEventHandler(this.btnUser_Command);
			this.Linkbutton2.Command += new System.Web.UI.WebControls.CommandEventHandler(this.btnUser_Command);
			this.dgDriver.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.dgDriver_ItemCommand);
			this.Load += new System.EventHandler(this.Page_Load);
			this.PreRender += new System.EventHandler(this.Page_PreRender);

		}
		#endregion

		//
		//添加新用户/更新已有用户CheckBox值改变事件代理函数
		//
		private void cbNewUser_CheckedChanged(object sender, System.EventArgs e)
		{
			this.cbNewUser.Enabled=false;
			this.dgDriver.SelectedIndex=-1;
		}

		//
		//用户列表命令代理函数
		//
		private void dgDriver_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			switch(e.CommandName)
			{
				case "USERINFO":
					this.dgDriver.SelectedIndex=e.Item.ItemIndex;
					this.cbNewUser.Checked=false;
					this.cbNewUser.Enabled=true;
					break;
				default:
					break;
			}
		}

		//
		//保存用户数据按钮事件代理函数
		//
		private void btnUser_Command(object sender, System.Web.UI.WebControls.CommandEventArgs e)
		{
			switch(e.CommandName)
			{
				case "SAVEUSER":
					string strMemo=this.txtDriverMemo.Text;
					int iUserID=Convert.ToInt32(this.ddlDriverName.SelectedItem.Value);
					string dtStart=this.dateStart.DateString;
					string dtCheck=this.dateCheck.DateString;
					string strDriverType=this.ddlDriverType.SelectedItem.Value;
					this.DB.UpdateDriver(this.m_iCurDriverID,iUserID,dtStart,dtCheck,strDriverType,strMemo);
					this.m_iCurDriverID=-1;
					this.dgDriver.SelectedIndex=-1;
					break;
				case "DELUSERS":
					string strDriverKeys="";
					int iCnt=this.dgDriver.Items.Count;
					for(int i=0;i<iCnt;i++)
					{
						if(((System.Web.UI.WebControls.CheckBox)this.dgDriver.Items[i].FindControl("cbDelUser")).Checked)
						{
							strDriverKeys+=","+this.dgDriver.DataKeys[i].ToString();
						}
						if(strDriverKeys.Length>0)
							this.DB.RunDelQuery("Drivers","DriverID In ("+strDriverKeys.Substring(1)+")");
					}
					break;
				default:
					break;
			}
		}
		protected string DriverName(string strUserID)
		{
			return this.DB.RunScalar("UserName","Users","UserID="+strUserID,null).ToString();
		}
		protected string DriverSex(string strUserID)
		{
			return Convert.ToBoolean(this.DB.RunScalar("Sex","Users","UserID="+strUserID,null))?"男":"女";
		}
	}
}