/// <summary>
/// 获取上级部门信息主管/副主管/助理
/// </summary>
/// <param name="DeptID">部门编号</param>
/// <param name="HostName">[Host]主管,[SubHosts]副经理，[Assistants]助理</param>
/// <returns></returns>
public static string GetParentDeptHost(int DeptID, string HostName)
{
string userid = "";
WX.Model.Department.MODEL dept = WX.Model.Department.NewDataModel(DeptID);
if (dept.ParentID.ToInt32() > 0)
{
userid = ULCode.QDA.XSql.GetValue("select " + HostName + " from TE_Departments where ID=" + dept.ParentID.ToString()).ToString();
}
WX.Model.User.MODEL user = WX.Model.User.NewDataModel(userid);
if (userid == "" || user == null || user.State.ToInt32() < 10 || user.State.ToInt32() >= 40)
{
userid = ULCode.QDA.XSql.GetValue("UserID", "select top 1 * from TU_Users where DepartmentID=" + dept.ParentID.ToString() + " and State>=10 and State<40 order by Grade desc").ToString();
user = WX.Model.User.NewDataModel(userid);
if (user != null)
{
return(user.UserID.ToString());
}
}
else
{
return(user.UserID.ToString());
}
return("");
}
private string GetSysVariable(string Vname)
{
string returnstr = "";
WX.WXUser cu = WX.Main.CurUser;
WX.Flow.Model.Process.MODEL pmodel = WX.Flow.Model.Process.GetModel("select top 1 * from TE_VarDefine where Title='" + Vname + "'");
string name = "";
if (pmodel != null && pmodel.Name.value != null)
{
name = pmodel.Name.value.ToString();
}
switch (name)
{
case "PRCS_Z_UserName":
cu.LoadUserModel(false);
returnstr = cu.UserModel.RealName.value.ToString();
break;
case "PRCS_Z_UserDuty":
cu.LoadDutyUser();
returnstr = cu.DutyUser.Name.value.ToString();
break;
case "PRCS_Z_UserDept":
cu.LoadUserModel(false);
WX.Model.Department.MODEL dept = WX.Model.Department.GetCache(cu.UserModel.DepartmentID.ToInt32());
//WX.Model.Department.GetModel("select * from TE_Departments where ID=" + cu.EmployeeUser.DepartmentID.value.ToString());
returnstr = dept.Name.value.ToString();
break;
case "PRCS_Z_UserSupDept":
cu.LoadUserModel(false);
WX.Model.Department.MODEL dept2 = WX.Model.Department.GetCache(cu.UserModel.DepartmentID.ToInt32());
//WX.Model.Department.GetModel("select * from TE_Departments where ID=" + cu.EmployeeUser.DepartmentID.value.ToString());
dept2 = WX.Model.Department.GetCache(dept2.ParentID.ToInt32());
//WX.Model.Department.GetModel("select * from TE_Departments where ID=" + dept2.ParentID.value.ToString());
returnstr = dept2.Name.value.ToString();
break;
case "PRCS_ID": returnstr = Request["id"]; break;
case "Datetime_Now": returnstr = DateTime.Now.ToString("yyyy-MM-dd"); break;
default: break;
}
return(returnstr);
}
/// <summary>
/// 获取单个服务器变量
/// </summary>
/// <param name="Vname"></param>
/// <returns></returns>
private string GetConditionSql_GetSysVariable(string name)
{
string returnstr = "";
WX.WXUser cu = WX.Public.CurUser;
//WX.Flow.Model.Process.MODEL pmodel = WX.Flow.Model.Process.GetModel("select top 1 * from TE_VarDefine where Title='" + Vname + "'");
//string name = "";
//if (pmodel != null && pmodel.Name.value != null)
//{
// name = pmodel.Name.value.ToString();
//}
switch (name)
{
case "PRCS_Z_UserName":
cu.LoadUserModel(false);
returnstr = cu.UserModel.RealName.value.ToString();
break;
case "PRCS_Z_UserDuty":
cu.LoadDutyUser();
returnstr = cu.DutyUser.Name.value.ToString();
break;
case "PRCS_Z_UserDept":
cu.LoadEmployeeUser();
cu.LoadMyDepartment();
returnstr = cu.MyDepartMent.Name.ToString();
break;
case "PRCS_Z_UserSupDept":
cu.LoadEmployeeUser();
cu.LoadMyDepartment();
WX.Model.Department.MODEL dept2 = WX.Model.Department.GetCache(cu.MyDepartMent.ParentID.ToInt32());
//WX.Model.Department.GetModel("select * from TE_Departments where ID=" + cu.MyDepartMent.ParentID.ToString());
returnstr = dept2.Name.value.ToString();
break;
case "PRCS_ID": returnstr = Convert.ToInt32(HttpContext.Current.Request.QueryString["Step_Id"]).ToString(); break;
case "Datetime_Now": returnstr = DateTime.Now.ToString("yyyy-MM-dd"); break;
default: break;
}
return(returnstr);
}
public static int GetParentDeptID(int id)
{
WX.Model.Department.MODEL deptmodel = WX.Model.Department.NewDataModel(id);
bool flag = true;
int deptid = deptmodel.ID.ToInt32();
int parent = deptmodel.ParentID.ToInt32();
while (flag)
{
if (parent == 0)
{
flag = false;
}
else
{
WX.Model.Department.MODEL dmodel = WX.Model.Department.NewDataModel(parent);
deptid = dmodel.ID.ToInt32();
parent = dmodel.ParentID.ToInt32();
}
}
return(deptid);
}
public static int GetParentDeptID()
{
WX.Main.CurUser.LoadUserModel(true);
WX.Main.CurUser.LoadMyDepartment();
bool flag = true;
int deptid = WX.Main.CurUser.MyDepartMent.ID.ToInt32();
int parent = WX.Main.CurUser.MyDepartMent.ParentID.ToInt32();
while (flag)
{
if (parent == 0)
{
flag = false;
}
else
{
WX.Model.Department.MODEL dmodel = WX.Model.Department.NewDataModel(parent);
deptid = dmodel.ID.ToInt32();
parent = dmodel.ParentID.ToInt32();
}
}
return(deptid);
}
protected void btnSave_Click(object sender, EventArgs e)
{
//1.验证用户权限
if (!this.Master.A_Edit)
{
Response.Write("你没有权限访问此功能！");
Response.End();
return;
}
//2.获取用户变量
string companyId = this.ddlCompany.Value;
string departmentNO = this.txtDepartmentNO.Text;
string departmentName = this.txtDepartmentName.Text;
string telephone = this.txtPhone.Text;
string fax = this.txtFax.Text;
string parentId = this.ddlParentId.Text;
string address = this.txtAddress.Text;
string sort = this.txtSort.Text;
string content = this.txtContent.Text;
int isSubOrgan = Convert.ToInt32(this.chkIsSubOrgan.Checked);
string host = this.hidden_txtHost.Value;
string subHosts = this.hidden_txtSubHosts.Value;
string assistants = this.hidden_txtAssistants.Value;
string upHost = this.hidden_txtUpHost.Value;
string upSubHosts = this.hidden_txtUpSubHosts.Value;
//3.验证用户变量
//4.处理业务
WX.Model.Department.MODEL department = WX.Model.Department.NewDataModel();
department.CompanyID.value = companyId;
department.NO.value = departmentNO;
department.ParentID.value = parentId;
department.Name.value = departmentName;
department.Tel.value = telephone;
department.Fax.value = fax;
department.Address.value = address;
department.Content.value = content;
department.IsSubOrgan.value = isSubOrgan;
if (!string.IsNullOrEmpty(host))
{
department.Host.value = host;
}
department.SubHosts.value = subHosts;
department.Assistants.value = assistants;
if (!string.IsNullOrEmpty(upHost))
{
department.UpHost.value = upHost;
}
department.UpSubHosts.value = upSubHosts;
int row = department.Insert(true);
//5.（用户及业务对象）统计与状态
if (row > 0)
{
department.SaveIntoCaches();
//6.登记日志
WX.Main.AddLog(LogType.Default, "部门信息添加成功！", "");
//7.跳转页面
Debug.Confirm(this, "部门信息添加成功！是否继续添加?？", this.Request.RawUrl, "Dept_DepartmentList.aspx?companyId=11");
}
else
{
Debug.Alert(this, "部门信息添加失败！可能是重复添加！");
}
}
