protected void Grid1_RowCommand(object sender, GridCommandEventArgs e)
{
int deptID = GetSelectedDataKeyID(Grid1);
if (e.CommandName == "Delete")
{
// 在操作之前进行权限检查
if (!CheckPower("CoreDeptDelete"))
{
CheckPowerFailWithAlert();
return;
}
int userCount = DB.Users.Where(u => u.Dept.ID == deptID).Count();
if (userCount > 0)
{
Alert.ShowInTop("删除失败！需要先清空属于此部门的用户！");
return;
}
int childCount = DB.Depts.Where(d => d.Parent.ID == deptID).Count();
if (childCount > 0)
{
Alert.ShowInTop("删除失败！请先删除子部门！");
return;
}
DB.Depts.Delete <Dept>(d => d.ID == deptID);
DeptHelper.Reload();
BindGrid();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DeptHelper.InitDeptDPTree(trDpt.Nodes, "0", "", "");
}
}
public Index()
{
InitializeComponent();
_deptHelper = new DeptHelper();
_companyHelper = new CompanyHelper();
_assetCategoryHelper = new AssetCategoryHelper();
_assetHelper = new AssetHelper();
}
protected void Page_Load(object sender, EventArgs e)
{
Page.Title = "部门权限范围配置";
if (Request["USER_ID"] != null)
{
userid = Request["USER_ID"];
}
if (Request["ROLE_ID"] != null)
{
roleid = Request["ROLE_ID"];
}
if (!IsPostBack)
{
tvDept.ShowCheckBoxes = TreeNodeTypes.All;
DeptHelper.InitDeptDPTree(tvDept.Nodes, "0", userid, roleid);
if (userid != "")
{
SYS_USERDATA val = new SYS_USERDATA();
val.USER_ID = decimal.Parse(userid);
val.DATA_TYPE = date_type;
List <SYS_USERDATA> lst = BLLTable <SYS_USERDATA> .Factory(conn).Select(new SYS_USERDATA(), val);
if (lst.Count == 1 && lst[0].DATA_ID == "0")
{
ckAll.Checked = true;
}
}
if (roleid != "")
{
SYS_ROLEDATA val = new SYS_ROLEDATA();
val.ROLE_ID = decimal.Parse(roleid);
val.DATA_TYPE = date_type;
List <SYS_ROLEDATA> lst = BLLTable <SYS_ROLEDATA> .Factory(conn).Select(new SYS_ROLEDATA(), val);
if (lst.Count == 1 && lst[0].DATA_ID == "0")
{
ckAll.Checked = true;
}
}
}
}
protected void btnOK_Click(object sender, EventArgs e)
{
#region//备用变量声明
string gotoUrl = "../../OK.aspx?p=0";
int re = 0;
string msg = "新增记录";
HR_DEPT valObj = new HR_DEPT();
#endregion
valObj.DEPT_NAME = txtDeptName.Value;
//树结构操作
if (keyid != "")
{
valObj.P_DEPT_ID = wucSelDept1.DEPT_ID;
valObj.DEPT_ID = keyid;
re = DeptHelper.EditDept(valObj);// BLLTable<HR_DEPT>.Factory(conn).Update(valObj, HR_DEPT.Attribute.DEPT_ID);
}
#region//执行结果处理
if (re > 0)
{
if (Request["tree"] != null)
{
StringBuilder sb = new StringBuilder("");
if (Request["toEdit"] == null)
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.reShowSubNodes(true);location.href='" + gotoUrl + "';", false);
}
else
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.reShowSubNodes(true);location.href='" + gotoUrl + "';", false);
}
}
else
{
ScriptHelper.AlertAndGo(Page, msg + "成功！", gotoUrl);
}
}
else
{
ScriptHelper.AlertAndGo(Page, msg + "失败！", gotoUrl);
}
#endregion
}
public async Task <IActionResult> OnPostDept_DoPostBackAsync(string[] Grid1_fields, string actionType, int?deletedRowID)
{
if (actionType == "delete")
{
// 在操作之前进行权限检查
if (!CheckPower("CoreDeptDelete"))
{
CheckPowerFailWithAlert();
return(UIHelper.Result());
}
int userCount = await DB.Users.Where(u => u.Dept.ID == deletedRowID.Value).CountAsync();
if (userCount > 0)
{
Alert.ShowInTop("删除失败！需要先清空属于此部门的用户！");
return(UIHelper.Result());
}
int childCount = await DB.Depts.Where(d => d.Parent.ID == deletedRowID.Value).CountAsync();
if (childCount > 0)
{
Alert.ShowInTop("删除失败！请先删除子部门！");
return(UIHelper.Result());
}
var dept = await DB.Depts.Where(d => d.ID == deletedRowID.Value).FirstOrDefaultAsync();
DB.Depts.Remove(dept);
await DB.SaveChangesAsync();
}
DeptHelper.Reload();
UIHelper.Grid("Grid1").DataSource(DeptHelper.Depts, Grid1_fields);
return(UIHelper.Result());
}
protected void Grid1_RowCommand(object sender, GridCommandEventArgs e)
{
int deptID = GetSelectedDataKeyID(Grid1);
if (e.CommandName == "Delete")
{
// 在操作之前进行权限检查
if (!CheckPower("CoreDeptDelete"))
{
CheckPowerFailWithAlert();
return;
}
IList <ICriterion> qryListUser = new List <ICriterion>();
qryListUser.Add(Expression.Eq("DeptID", deptID));
int userCount = Core.Container.Instance.Resolve <IServiceUsers>().GetRecordCountByFields(qryListUser);
//int userCount = DB.Users.Where(u => u.Dept.ID == deptID).Count();
if (userCount > 0)
{
Alert.ShowInTop("删除失败！需要先清空属于此部门的用户！");
return;
}
IList <ICriterion> qryList = new List <ICriterion>();
qryList.Add(Expression.Eq("ParentID", deptID));
int childCount = Core.Container.Instance.Resolve <IServiceDepts>().GetRecordCountByFields(qryList);
//int childCount = DB.Depts.Where(d => d.Parent.ID == deptID).Count();
if (childCount > 0)
{
Alert.ShowInTop("删除失败！请先删除子部门！");
return;
}
Core.Container.Instance.Resolve <IServiceDepts>().Delete(deptID);
DeptHelper.Reload();
BindGrid();
}
}
protected void Window1_Close(object sender, EventArgs e)
{
DeptHelper.Reload();
BindGrid();
}
protected void btnOK_Click(object sender, EventArgs e)
{
#region//备用变量声明
string gotoUrl = "../../OK.aspx?p=0";
if (pid != "")
{
gotoUrl += "&PID=" + pid;
}
int re = 0;
string msg = "新增记录";
HR_DEPT valObj = new HR_DEPT();
#endregion
#region//实例对象赋值
valObj.DEPT_NAME = txtDeptName.Value;
valObj.SORT_NO = Convert.ToInt32(txtSortNum.Value);
valObj.ORG_ID = wucSelORG1.ORG_ID;
if (txtSNAME.Value != "")
{
valObj.SNAME = Convert.ToString(txtSNAME.Value);
}
if (txtRNAME.Value != "")
{
valObj.RNAME = Convert.ToString(txtRNAME.Value);
}
if (txtEXP1.Value != "")
{
valObj.EXP1 = Convert.ToString(txtEXP1.Value);
}
if (txtEXP2.Value != "")
{
valObj.EXP2 = Convert.ToString(txtEXP2.Value);
}
if (txtEXP3.Value != "")
{
valObj.EXP3 = Convert.ToString(txtEXP3.Value);
}
#endregion
#region//执行修改或新增
if (keyid != "")
{
valObj.P_DEPT_ID = wucSelDept1.DEPT_ID;
valObj.DEPT_ID = keyid;
re = DeptHelper.EditDept(valObj);// BLLTable<HR_DEPT>.Factory(conn).Update(valObj, HR_DEPT.Attribute.DEPT_ID);
}
else
{
if (ntype == "org")
{
valObj.P_DEPT_ID = "0";
}
else
{
valObj.P_DEPT_ID = pid;
}
keyid = DeptHelper.AddDept(valObj, valObj.P_DEPT_ID);
re = keyid != "" ? 1 : 0;
}
#endregion
#region//执行结果处理
if (re > 0)
{
if (Request["tree"] != null)
{
StringBuilder sb = new StringBuilder("{");
sb.Append("rid:'").Append(pid).Append("',id:'");
sb.Append(keyid).Append("',pid:'").Append(pid).Append("',no:").Append(valObj.SORT_NO).Append(",sc:1,name:'");
sb.Append(valObj.DEPT_NAME).Append("',ntype:'dept'}");
if (Request["toEdit"] == null)
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.addSubNodeForOprPage(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
else
{
AgileFrame.Core.ScriptHelper.ResponseScript(Page, "parent.editNodeForOprPage(\"" + sb.ToString() + "\");location.replace('" + gotoUrl + "');", false);
}
}
else
{
ScriptHelper.AlertAndGo(Page, msg + "成功！", gotoUrl);
}
}
else
{
ScriptHelper.AlertAndGo(Page, msg + "失败！", gotoUrl);
}
#endregion
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//显示子节点
if (Request["ShowSubNodes"] != null)
{
string nodetype = Request["ntype"];
StringBuilder sb = new StringBuilder("[");
string pid = Request["id"];//orgid/deptid/taskid
if (nodetype == "org")
{
#region
HR_ORG obj = new HR_ORG();
HR_ORG val = new HR_ORG();
obj.P_ORG_ID = pid;
val.OrderBy(HR_ORG.Attribute.SORT_NO, Order.Asc);
List <HR_ORG> lst = BLLTable <HR_ORG> .Factory(conn).Select(val, obj);
if (lst != null && lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
decimal subcount = lst[i].SUB_NUM;// lst[i].SUB_NUM > 0 ? lst[i].SUB_NUM : 1;
sb.Append("{id:'").Append(lst[i].ORG_ID);
sb.Append("',pid:'").Append(lst[i].P_ORG_ID.ToString()).Append("',no:'").Append(lst[i].SORT_NO);
sb.Append("',sc:").Append(subcount.ToString());
sb.Append(",name:'").Append(lst[i].ORG_NAME).Append("',ntype:'org'}");
}
}
#endregion
}
if (nodetype == "org" || nodetype == "dept")
{
#region
HR_DEPT obj = new HR_DEPT();
HR_DEPT val = new HR_DEPT();
if (nodetype == "org")
{
obj.ORG_ID = pid;
obj.P_DEPT_ID = "0";
}
else
{
obj.P_DEPT_ID = pid;
}
val.OrderBy(HR_DEPT.Attribute.SORT_NO, Order.Asc);
List <HR_DEPT> lst = BLLTable <HR_DEPT> .Factory(conn).Select(val, obj);
if (lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
int subcount = BLLTable <HR_DEPT> .Factory(conn).Select(HR_DEPT.Attribute.P_DEPT_ID, lst[i].DEPT_ID).Count;
sb.Append("{rid:'").Append(lst[i].P_DEPT_ID).Append("',id:'").Append(lst[i].DEPT_ID.ToString());
sb.Append("',pid:'").Append(lst[i].P_DEPT_ID.ToString()).Append("',no:'").Append(lst[i].SORT_NO);
sb.Append("',sc:").Append(subcount.ToString());
sb.Append(",name:'").Append(lst[i].DEPT_NAME).Append("',ntype:'dept'}");
}
}
#endregion
}
sb.Append("]");
Response.Write(sb.ToString());
}
//删除群组
if (Request["deleteNode"] != null)
{
string keyid = Request["id"];
int re = DeptHelper.DelDept(keyid);// BLLTable<HR_DEPT>.Factory(conn).Delete(HR_DEPT.Attribute.DEPT_ID, keyid);
Response.Write("{re:" + re + ",msg:'删除成功'}");
}
//修改序号
if (Request["UpdateSort"] != null)
{
string chgid1 = Request["chgid1"];
string chgsort1 = Request["chgsort1"].ToString();
string chgid2 = Request["chgid2"];
string chgsort2 = Request["chgsort2"].ToString();
try
{
// int re=BllTable.UpdateCol(sys_ModuleInfo.Attribute.SortNum, chgsort1, sys_ModuleInfo.Attribute.ModuleID, chgid1, 1);
//re=BllTable.UpdateCol(sys_ModuleInfo.Attribute.SortNum, chgsort2, sys_ModuleInfo.Attribute.ModuleID, chgid2, 1);
int re = BLLTable <HR_DEPT> .Factory(conn).Update(HR_DEPT.Attribute.DEPT_ID, chgid1, HR_DEPT.Attribute.SORT_NO, chgsort1);
re = BLLTable <HR_DEPT> .Factory(conn).Update(HR_DEPT.Attribute.DEPT_ID, chgid2, HR_DEPT.Attribute.SORT_NO, chgsort2);
Response.Write(re.ToString());
}
catch {
Response.Write("0");
}
}
UserBaseExd userExd = new UserBaseExd(userBase);
//显示子节点
if (Request["getSubNodes"] != null)
{
string mypaths = null;//
if (SysSetting.TaskLog.SendTaskLimit)
{
mypaths = "," + userExd.GetMyManageDeptIDS(true) + "," + userExd.GetMyDeptPathIDS() + ",";
}
if (Request["look"] != null)
{
string user_data_ids = UserHelper.GetUserDataIDS(userBase, HR_DEPT.Attribute.DEPT_ID);
mypaths += user_data_ids + "," + userExd.GetMyDeptPathIDS() + ",";
}
if (Request["treepower"] != null)
{
string user_data_ids = UserHelper.GetUserDataIDS(userBase, HR_DEPT.Attribute.DEPT_ID);
mypaths += user_data_ids + "," + userExd.GetMyDeptPathIDS() + ",";
}
if (Request["all"] != null)
{
mypaths = null;
}
string nodetype = Request["ntype"];
StringBuilder sb = new StringBuilder("[");
string pid = Request["id"];//orgid/deptid/taskid
if (nodetype == "root" || nodetype == "")
{
#region
HR_ORG obj = new HR_ORG();
HR_ORG val = new HR_ORG();
obj.P_ORG_ID = pid;
val.OrderBy(HR_ORG.Attribute.SORT_NO, Order.Asc);
List <HR_ORG> lst = BLLTable <HR_ORG> .Factory(conn).Select(val, obj);
if (lst.Count != null)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
decimal subcount = lst[i].SUB_NUM > 0 ? lst[i].SUB_NUM : 1;
sb.Append("{id:'").Append(lst[i].ORG_ID);
sb.Append("',pid:'").Append(lst[i].P_ORG_ID.ToString()).Append("',no:").Append(lst[i].SORT_NO);
sb.Append(",sc:").Append(subcount.ToString());
sb.Append(",name:'").Append(lst[i].ORG_NAME).Append("',ntype:'org'}");
}
}
#endregion
}
if (nodetype == "org" || nodetype == "dept")
{
#region
HR_DEPT objDept = new HR_DEPT();
HR_DEPT valDept = new HR_DEPT();
if (nodetype == "org")
{
objDept.ORG_ID = pid;
objDept.P_DEPT_ID = "0";
}
else
{
objDept.P_DEPT_ID = pid;
}
//if (Request["my"] != null)
//{
// mydepts += mydepts == "" ? userBase.DeptID : "," + userBase.DeptID;
// objDept.In(HR_DEPT.Attribute.DEPT_ID, mydepts);
//}
valDept.OrderBy(HR_DEPT.Attribute.SORT_NO, Order.Asc);
List <HR_DEPT> lstDept = BLLTable <HR_DEPT> .Factory(conn).Select(valDept, objDept);
if (lstDept.Count != null)
{
for (int i = 0; i < lstDept.Count; i++)
{
if (mypaths == null || mypaths.IndexOf("," + lstDept[i].DEPT_ID + ",") != -1)
{
if (sb.Length > 2)
{
sb.Append(",");
}
decimal subcount = lstDept[i].SUB_NUM > 0 ? lstDept[i].SUB_NUM : 1;
sb.Append("{id:'").Append(lstDept[i].DEPT_ID);
sb.Append("',pid:'").Append(lstDept[i].P_DEPT_ID.ToString()).Append("',no:").Append(lstDept[i].SORT_NO);
sb.Append(",sc:").Append(subcount.ToString());
sb.Append(",name:'").Append(lstDept[i].DEPT_NAME).Append("',ntype:'dept'}");
}
}
}
#endregion
}
sb.Append("]");
Response.Write(sb.ToString());
}
Response.End();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//显示子节点
if (Request["ShowSubNodes"] != null)
{
string nodetype = Request["ntype"];
StringBuilder sb = new StringBuilder("[");
string pid = Request["id"];//orgid/deptid/taskid
if (nodetype == "org")
{
#region
HR_ORG obj = new HR_ORG();
HR_ORG val = new HR_ORG();
obj.P_ORG_ID = pid;
val.OrderBy(HR_ORG.Attribute.SORT_NO, Order.Asc);
List <HR_ORG> lst = BLLTable <HR_ORG> .Factory(conn).Select(val, obj);
if (lst.Count != null)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
decimal subcount = lst[i].SUB_NUM;// lst[i].SUB_NUM > 0 ? lst[i].SUB_NUM : 1;
sb.Append("{id:'").Append(lst[i].ORG_ID);
sb.Append("',pid:'").Append(lst[i].P_ORG_ID.ToString()).Append("',no:'").Append(lst[i].SORT_NO);
sb.Append("',sc:").Append(subcount.ToString());
sb.Append(",name:'").Append(lst[i].ORG_NAME).Append("',ntype:'org'}");
}
}
#endregion
}
if (nodetype == "org" || nodetype == "dept")
{
#region
HR_DEPT obj = new HR_DEPT();
HR_DEPT val = new HR_DEPT();
if (nodetype == "org")
{
obj.ORG_ID = pid;
obj.P_DEPT_ID = "0";
}
else
{
obj.P_DEPT_ID = pid;
}
val.OrderBy(HR_DEPT.Attribute.SORT_NO, Order.Asc);
List <HR_DEPT> lst = BLLTable <HR_DEPT> .Factory(conn).Select(val, obj);
if (lst.Count > 0)
{
for (int i = 0; i < lst.Count; i++)
{
if (sb.Length > 2)
{
sb.Append(",");
}
int subcount = BLLTable <HR_DEPT> .Factory(conn).Select(HR_DEPT.Attribute.P_DEPT_ID, lst[i].DEPT_ID).Count;
sb.Append("{rid:'").Append(lst[i].P_DEPT_ID).Append("',id:'").Append(lst[i].DEPT_ID.ToString());
sb.Append("',pid:'").Append(lst[i].P_DEPT_ID.ToString()).Append("',no:'").Append(lst[i].SORT_NO);
sb.Append("',sc:").Append(subcount.ToString());
sb.Append(",name:'").Append(lst[i].DEPT_NAME).Append("',ntype:'dept'}");
}
}
#endregion
}
sb.Append("]");
Response.Write(sb.ToString());
}
//删除群组
if (Request["DelNodeID"] != null)
{
string keyid = Request["id"];
int re = DeptHelper.DelDept(keyid);// BLLTable<HR_DEPT>.Factory(conn).Delete(HR_DEPT.Attribute.DEPT_ID, keyid);
Response.Write(re.ToString());
}
//修改序号
if (Request["UpdateSort"] != null)
{
string chgid1 = Request["chgid1"];
string chgsort1 = Request["chgsort1"].ToString();
string chgid2 = Request["chgid2"];
string chgsort2 = Request["chgsort2"].ToString();
try
{
// int re=BllTable.UpdateCol(sys_ModuleInfo.Attribute.SortNum, chgsort1, sys_ModuleInfo.Attribute.ModuleID, chgid1, 1);
//re=BllTable.UpdateCol(sys_ModuleInfo.Attribute.SortNum, chgsort2, sys_ModuleInfo.Attribute.ModuleID, chgid2, 1);
int re = BLLTable <HR_DEPT> .Factory(conn).Update(HR_DEPT.Attribute.DEPT_ID, chgid1, HR_DEPT.Attribute.SORT_NO, chgsort1);
re = BLLTable <HR_DEPT> .Factory(conn).Update(HR_DEPT.Attribute.DEPT_ID, chgid2, HR_DEPT.Attribute.SORT_NO, chgsort2);
Response.Write(re.ToString());
}
catch {
Response.Write("0");
}
}
Response.End();
}
}
public void SetSelDpts(string dptids)
{
hidDptIDS.Value = dptids;
litEmps.Text = DeptHelper.ShowSelDptHTML(dptids, false);
}
