📄 departmentmanage.aspx.cs
字号:
/*
* 作者：吴高发
* 日期：03-11-13
* 修改者：
* 修改模块：
*/
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 Microsoft.Web.UI.WebControls;
using OI.DatabaseOper ;
using System.Data.SqlClient;
namespace OI.Manage
{
/// <summary>
/// DepartmentManage 的摘要说明。
/// </summary>
public class DepartmentManage : OI.PageBase
{
protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
protected System.Web.UI.WebControls.TextBox DepName;
protected System.Web.UI.WebControls.TextBox tel1;
protected System.Web.UI.WebControls.TextBox tel2;
protected System.Web.UI.WebControls.TextBox fax;
protected Microsoft.Web.UI.WebControls.TreeView TreeViewDepart;
protected System.Web.UI.WebControls.Label a1;
protected System.Web.UI.WebControls.Label a2;
protected System.Web.UI.WebControls.Label a3;
protected System.Web.UI.WebControls.Label a4;
protected System.Web.UI.WebControls.TextBox TextBoxSaveButton;
protected System.Web.UI.WebControls.ImageButton ButtonAdd;
protected System.Web.UI.WebControls.ImageButton ButtonModi;
protected System.Web.UI.WebControls.ImageButton ButtonSave;
protected System.Web.UI.WebControls.ImageButton state;
protected System.Web.UI.WebControls.ImageButton ImageButton_Delete;
private DatabaseConnect dc;
private ArrayList pid=new ArrayList();
protected System.Web.UI.WebControls.CheckBox checkboxReceive;
protected System.Web.UI.WebControls.Label a6;
protected System.Web.UI.WebControls.CheckBox checkboxTransmit;
protected System.Web.UI.WebControls.Label lablestep;
protected System.Web.UI.WebControls.Button btnorderBy;
private TreeNode nodeTemp=new TreeNode();
private void Page_Load(object sender, System.EventArgs e)
{
if (Session["userid"]==null)
{
Response.Write ("<script>alert('超时,请重新登录');top.location.href='../userpass.aspx';</script>");
return ;
}
ImageButton_Delete.Attributes["OnClick"]="return confirm('你是否确定要删除该部门');";
dc=new DatabaseConnect ();
if(!this.IsPostBack )
{
this.DispComp (false);
// CreateDataSource();
create();
creatnode();
CreateChildDepartment();
}
// }
}
/// <summary>
/// 判断部门名称是否为不确定
/// </summary>
/// <returns></returns>
private bool SelectDepartmentname()
{
string sql="select departmentname from departments where departmentid="+Convert.ToInt32(Session["departmentid"]) +" order by displayorder";
dc=new DatabaseConnect();
string departmentame=dc.GetObjectBySql(sql).ToString();
if(departmentame=="不确定")
{
return true;
}
else
return false;
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.TreeViewDepart.SelectedIndexChange += new Microsoft.Web.UI.WebControls.SelectEventHandler(this.changeSelected);
this.TreeViewDepart.Check += new Microsoft.Web.UI.WebControls.ClickEventHandler(this.clickSelected);
this.ButtonAdd.Click += new System.Web.UI.ImageClickEventHandler(this.ButtonAdd_Click);
this.ButtonModi.Click += new System.Web.UI.ImageClickEventHandler(this.ButtonModi_Click);
this.ButtonSave.Click += new System.Web.UI.ImageClickEventHandler(this.ButtonSave_Click);
this.state.Click += new System.Web.UI.ImageClickEventHandler(this.state_Click);
this.ImageButton_Delete.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton_Delete_Click);
this.btnorderBy.Click += new System.EventHandler(this.btnorderBy_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void ButtonAdd_Click(object sender, System.EventArgs e)
{
ButtonAdd.Visible =false;
ButtonModi.Visible =false;
state.Visible =false;
ImageButton_Delete.Visible=false;
ButtonSave.Visible =true;
TextBoxSaveButton.Text ="增加";
this.dispInput (true);
}
private void DispComp(bool isDisp)
{
ButtonAdd.Visible =isDisp;
ButtonModi.Visible =isDisp;
state.Visible =isDisp;
ButtonSave.Visible =isDisp;
ImageButton_Delete.Visible=isDisp;
DepName.Visible =isDisp;
tel1.Visible =isDisp;
tel2.Visible =isDisp;
fax.Visible =isDisp;
checkboxReceive.Visible =isDisp;
checkboxTransmit.Visible =isDisp;
a1.Visible =isDisp;
a2.Visible =isDisp;
a3.Visible =isDisp;
a4.Visible =isDisp;
a6.Visible =isDisp;
lablestep.Visible =isDisp;
}
private void dispInput(bool isDisp)
{
DepName.Visible =isDisp;
tel1.Visible =isDisp;
tel2.Visible =isDisp;
fax.Visible =isDisp;
checkboxReceive.Visible =isDisp;
checkboxTransmit.Visible =isDisp;
a1.Visible =isDisp;
a2.Visible =isDisp;
a3.Visible =isDisp;
a4.Visible =isDisp;
a6.Visible =isDisp;
lablestep.Visible =isDisp;
ButtonSave.Visible =isDisp;
}
private void dispDepartment_SelectedIndexChanged(object sender, System.EventArgs e)
{
TreeNode tempTN=TreeViewDepart.GetNodeFromIndex (TreeViewDepart.SelectedNodeIndex );
string sql="SELECT departmentName,tel1,tel2,fax,isPublic FROM departments WHERE DepartmentID='"+ tempTN.ID +"'order by displayorder";
ArrayList al=dc.getData (sql);
state.Visible =true;
this.dispButton (false,true);
if(al.Count >0)
{
DepName.Text =al[0].ToString ();
tel1.Text =al[1].ToString ();
tel2.Text =al[2].ToString ();
fax.Text =al[3].ToString ();
bool tempState=Convert.ToBoolean (al[4].ToString ().Trim ());
if(tempState)
{
state.ImageUrl ="../images/jy.gif";
this.enableControler (true);
}
else if(!tempState)
{
state.ImageUrl ="../images/qy.gif";
this.enableControler (false);
}
}
}
private void emptyData()
{
DepName.Text ="";
tel1.Text ="";
tel2.Text ="";
fax.Text ="";
}
private void dispButton(bool isAdd,bool isModi)
{
//ButtonCancel.Visible =isAdd;
if(TreeViewDepart.GetNodeFromIndex (TreeViewDepart.SelectedNodeIndex ).ID.Trim ().Equals ("0"))
ButtonAdd.Visible =false;
else
ButtonAdd.Visible =isAdd;
ButtonModi.Visible =isModi;
state.Visible =isModi;
ImageButton_Delete.Visible=isModi;
}
private void enableControler(bool isDisp)
{
//ButtonModi.Visible =isDisp;
DepName.Enabled =isDisp;
tel1.Enabled =isDisp;
tel2.Enabled =isDisp;
fax.Enabled =isDisp;
}
private void ButtonModi_Click(object sender, System.EventArgs e)
{
ButtonAdd.Visible =false;
ButtonModi.Visible =false;
state.Visible =false;
ButtonSave.Visible =true;
TextBoxSaveButton.Text ="修改";
this.dispInput (true);
this.emptyData ();
TreeNode tempTN=TreeViewDepart.GetNodeFromIndex (TreeViewDepart.SelectedNodeIndex );
string sql="SELECT DepartmentName,Tel1,Tel2,Fax FROM Departments WHERE DepartmentID='"+tempTN.ID .Trim ()+"' order by displayorder";
ArrayList al=dc.getData (sql);
if(al.Count >0)
{
DepName.Text =al[0].ToString ();
tel1.Text =al[1].ToString ();
tel2.Text =al[2].ToString ();
fax.Text =al[3].ToString ();
}
}
private void state_Click(object sender, System.EventArgs e)
{
TreeNode tempTN=TreeViewDepart.GetNodeFromIndex (TreeViewDepart.SelectedNodeIndex );
if(state.ImageUrl =="../images/jy.gif")
{
this.enableControler (false);
state.ImageUrl ="../images/qy.gif";
string sql="UPDATE departments SET isPublic=0"+
"WHERE departmentID='"+tempTN.ID +"'";
dc.updateData (sql);
}
else if(state.ImageUrl =="../images/qy.gif")
{
this.enableControler (true);
state.ImageUrl ="../images/jy.gif";
string sql="UPDATE departments SET isPublic=1"+
"WHERE departmentID='"+tempTN.ID +"'";
dc.updateData (sql);
}
//this.CreateDataSource ();
}
private void ButtonDel_Click(object sender, System.EventArgs e)
{
TreeNode tempTN=TreeViewDepart.GetNodeFromIndex (TreeViewDepart.SelectedNodeIndex );
string sql="DELETE FROM departments WHERE departmentID='"+tempTN.ID +"'";
dc.deleteData (sql);
this.CreateDataSource ();
}
// private void CreateDataSource()
// {
// TreeViewDepart.Nodes .Clear ();
// TreeNode node=new TreeNode ();
// node.Text ="开始";
// node.ID ="0";
// CreateDataSource("0",ref node);
// TreeViewDepart.Nodes .Add (node);
// }
private void state_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
TreeNode tempTN=TreeViewDepart.GetNodeFromIndex (TreeViewDepart.SelectedNodeIndex );
if(state.ImageUrl =="../images/jy.gif")
{
this.enableControler (false);
state.ImageUrl ="../images/qy.gif";
string sql="UPDATE departments SET isPublic=0"+
"WHERE departmentID='"+tempTN.ID +"'";
dc.updateData (sql);
}
else if(state.ImageUrl =="../images/qy.gif")
{
this.enableControler (true);
state.ImageUrl ="../images/jy.gif";
string sql="UPDATE departments SET isPublic=1"+
"WHERE departmentID='"+tempTN.ID +"'";
dc.updateData (sql);
}
}
/// <summary>
/// 改变收文人员
/// </summary>
private void ChangeReceiveMan()
{
}
private void ButtonSave_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
TreeNode tempTN=TreeViewDepart.GetNodeFromIndex (TreeViewDepart.SelectedNodeIndex );
checkDepartment cd=new checkDepartment ();
string departmentname=DepName.Text.Trim ().Replace ("'","''");
if(TextBoxSaveButton.Text .Trim ()=="增加")
{
if (cd.ExistDepartment(departmentname))
{
Page.RegisterStartupScript ("","<script>alert('"+departmentname+"己经存在!');Form1.TextBoxUserName.focus();</script>");
return;
}
int departmentid=GetDepartmentID(tempTN.ID);
if(departmentid>0)
{
if (checkboxReceive.Checked)
{ checkUser cu=new checkUser ();
string username=DepName.Text .Trim ()+"收文人员";
if(!cu.ExistUser(username))//不存在
{
string sql="insert into Accounts_Users(username,password,departmentid,";
sql+="ispublic,Birthday,Sex,School,Speciality,IsMarried,Nationality,";
sql+="NativePlace,PoliticalFeature,IDCard,";
sql+="Telephone,Mobile,Email,ZipCode,Address,State,Content,ProfessionalLevelID,JobLevelID)";
sql+="values( '"+DepName.Text .Trim ()+"收文人员',1111,"+departmentid+",1,2000/1/1,1,'','',1,'','','团员','','','','','','',0,'',1,1)";
dc.ExecuteSQL(sql);
sql ="select userid from accounts_users where username='"+DepName.Text .Trim ()+"收文人员'";
object o= dc.GetObjectBySql (sql);
if (o!=null)
{
OI.cs.createDefaultPower cp=new OI.cs.createDefaultPower ();
cp.createUserRole(o.ToString (),"收文用户") ;
}
}
else
{
Page.RegisterStartupScript ("","<script>alert('己经存在一个同名的收文人员，请在\"用户信息中\"手动为该部门增加收文人员');</script>");
}
}
this.emptyData ();
Page.RegisterStartupScript ("","<script>alert('部门增加成功');window.location='DepartMentManage.aspx';</script>");
}
else
{
Page.RegisterStartupScript("","<script>alert('该部门已经存在');window.location='DepartMentManage.aspx';</script>");
}
// string sql="INSERT INTO departments(ParentDepartmentID,departmentName,tel1,tel2,fax,isPublic)"+
// "VALUES('"+tempTN.ID +"','"+DepName.Text .Trim ()+"','"+tel1.Text .Trim ()+"','"+tel2.Text .Trim ()+"','"+fax.Text .Trim ()+"',1)";
// dc.addData (sql);
// this.emptyData ();
// Page.RegisterStartupScript ("","<script>alert('增加成功')</script>");
// Response.Redirect("DepartMentManage.aspx");
}
if(TextBoxSaveButton.Text .Trim ()=="修改" &&tempTN.ID !="0")
{
if(tempTN.ID .Trim ()=="0")
return;
if (cd.ExistDepartment (departmentname,int.Parse (tempTN.ID)))
{
Page.RegisterStartupScript ("","<script>alert('"+departmentname+"己经存在!');Form1.TextBoxUserName.focus();</script>");
return;
}
string []sqls=new string [4];
sqls[0]=" update receiveWait set ReseverDepartmentZ='"+DepName.Text.Trim() ;
sqls[0]+="' where ReseverDepartmentZ=(select departmentname from departments where departmentid="+tempTN.ID +")";
sqls[1]=" update receiveWait set ReseverDepartmentC='"+DepName.Text.Trim() ;
sqls[1]+="' where ReseverDepartmentC=(select departmentname from departments where departmentid="+tempTN.ID +")";
string IsStepPass="0";
if (checkboxTransmit.Checked )
{
IsStepPass="1";
}
sqls[2]="UPDATE departments SET DepartmentName='"+DepName.Text .Trim ()+"',Tel1='"+tel1.Text .Trim ()+"',Tel2='"+tel2.Text .Trim ()+"',Fax='"+fax.Text .Trim ()+"'"+
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -