public void add(DepartmentDto department)
{
SqlConnection cn = null;
SqlTransaction tc = null;
try
{
cn = DbHelperSQL.getConnection();
tc=DbHelperSQL.startTransaction(cn);
//生成部门完整编号FullNo
if (department.ParentNo.Length > 0)
{
DepartmentDto parent = this.departmentDAL.getByDepartmentNo(cn,tc,department.ParentNo);
if (null == parent)
{
DbHelperSQL.rollBackTransaction(tc);
throw new MakeException(ExpSort.普通, "找不到上级部门" + department.ParentNo + "操作失败");
}
department.FullNo = parent.FullNo + department.DepartmentNo + '|';
}
else
{
department.FullNo = department.DepartmentNo + '|';
}
//检查部门编号是否重复
DepartmentDto oldDepartment = this.departmentDAL.getByDepartmentNo(cn,tc,department.DepartmentNo);
if (null != oldDepartment)
{
DbHelperSQL.rollBackTransaction(tc);
throw new MakeException(ExpSort.普通, "部门编号" + department.DepartmentNo + "已经存在，操作失败");
}
//执行新增写进数据库
this.departmentDAL.add(cn,tc,department);
DbHelperSQL.commitTransaction(tc);
}
catch (DalException dalEx)
{
DbHelperSQL.rollBackTransaction(tc);
throw new MakeException(ExpSort.数据库, dalEx.Message);
}
finally
{
DbHelperSQL.closeConnection(cn);
}
}
protected void btnNew_Click(object sender, EventArgs e)
{
department = MakeUtil.getRequestDataToModel<DepartmentDto>(Request, typeof(DepartmentDto), -1);
try
{
this.departmentEbi.add(department);
MakeUtil.addOperationNote(Request.UserHostAddress, SystemUser, "新增部门", department.DepartmentNo);
Script.alertMsg("新增成功", this.Page);
Script.scriptRedirect("Department-New.aspx", this.Page);
//Script.PageRedirect(this.Page);
}
catch (MakeException makeEx)
{
Script.alertMsg(makeEx.Message, this.Page);
this.DataBind();
}
}
protected void tvDepartment_SelectedNodeChanged(object sender, EventArgs e)
{
DepartmentDto department = new DepartmentDto
{
DepartmentNo = this.tvDepartment.SelectedNode.Value,
DepartmentName = this.tvDepartment.SelectedNode.Text
};
if (department.DepartmentNo.Length == 0)
department.DepartmentName = "";
this.selectedValue = department;
if (null != SelectChanged)
{
SelectChanged(this, new EventArgs());
}
}
protected void Page_Load(object sender, EventArgs e)
{
//if (!MakeUtil.checkSysConfirm(Session, Response)) return;
if (!this.Page.IsPostBack)
{
this.NavigationTree.create();
this.department = new DepartmentDto();
this.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
//if (!MakeUtil.checkSysConfirm(Session, Response)) return;
if (!this.Page.IsPostBack)
{
string departmentNo = MakeUtil.getStringFromRequestByName(Request, "departmentNo", -1).Trim();
try
{
this.department = this.departmentEbi.getByDepartmentNo(departmentNo);
if (null == this.department)
{
Script.alertMsg("找不到部门资料" + departmentNo, this.Page);
Script.closeDivWin(this.Page, "DepartmentModify" + departmentNo);
return;
}
this.NavigationTree.create();
this.bindAll();
this.setButtonsState();
}
catch (MakeException makeEx)
{
Script.alertMsg(makeEx.Message, this.Page);
return;
}
}
}
