protected void Page_Load(object sender, EventArgs e)
{
long queId = 0; long resDepId;
if (!string.IsNullOrEmpty(Request.QueryString["queId"]))
{
if (long.TryParse(Request.QueryString["queId"], out queId))
{
queue = depBll.GetQueue(queId);
}
}
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
if (long.TryParse(Request.QueryString["id"], out resDepId))
{
resDep = new DAL.sys_resource_department_dal().FindById(resDepId);
}
}
if (resDep != null)
{
isAdd = false;
queue = depBll.GetQueue(resDep.department_id);
}
if (queue == null)
{
Response.Write("<script>alert('未获取到相关队列信息');window.close();</script>");
}
}
/// <summary>
/// 删除队列
/// </summary>
public bool DeleteQueue(long queId, long userId, ref string faileReason)
{
sys_department thisQue = _dal.FindNoDeleteById(queId);
if (thisQue == null)
{
return(true);
}
if (thisQue.is_system == 1)
{
faileReason = "系统队列，不能删除";
return(false);
}
List <sys_resource_department> resDepList = GetResDepList(queId);
if (resDepList != null && resDepList.Count > 0)
{
faileReason = "队列下有多个联系人，不能删除";
return(false);
}
List <sdk_task> ticketList = _dal.FindListBySql <sdk_task>("SELECT * from sdk_task where delete_time =0 and type_id = 1809 and department_id = " + queId.ToString());
if (ticketList != null && ticketList.Count > 0)
{
faileReason = "队列被多个工单引用，不能删除";
return(false);
}
_dal.SoftDelete(thisQue, userId);
OperLogBLL.OperLogDelete <sys_department>(thisQue, thisQue.id, userId, OPER_LOG_OBJ_CATE.DEPARTMENT, "");
return(true);
}
public dynamic DeleteDepart(sys_department department)
{
if (departmentFactory.CreatService().DeleteDepart(department))
{
return "OK";
}
return "FAIL";
}
public ActionResult Save(sys_department dto)
{
var user = RequestHelper.AdminInfo();
dto.insert_id = user.Id;
dto.insert_time = DateTime.Now;
_deptApp.SaveDepartment(dto);
return(Success("保存成功"));
}
/// <summary>
/// 新增队列
/// </summary>
public bool AddQueue(sys_department queue, long userId)
{
queue.id = _dal.GetNextIdCom();
queue.create_time = queue.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
queue.create_user_id = queue.update_user_id = userId;
_dal.Insert(queue);
OperLogBLL.OperLogAdd <sys_department>(queue, queue.id, userId, OPER_LOG_OBJ_CATE.DEPARTMENT, "");
return(true);
}
public dynamic EditDepart(sys_department department)
{
if (departmentFactory.CreatService().EditDepart(department))
{
return "OK";
}
return "FAIL";
// return new RedirectResult("/user/index");
//return "<script>alert('123')</script>";
;
}
/// <summary>
/// 编辑队列
/// </summary>
public bool EditQueue(sys_department queue, long userId)
{
var oldQueue = _dal.FindNoDeleteById(queue.id);
if (oldQueue == null)
{
return(false);
}
queue.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
queue.update_user_id = userId;
_dal.Update(queue);
OperLogBLL.OperLogUpdate <sys_department>(queue, oldQueue, queue.id, userId, OPER_LOG_OBJ_CATE.DEPARTMENT, "");
return(true);
}
protected void save_close_Click(object sender, EventArgs e)
{
sys_department pageQueue = AssembleModel <sys_department>();
if (!string.IsNullOrEmpty(Request.Form["isActive"]) && Request.Form["isActive"] == "on")
{
pageQueue.is_active = 1;
}
else
{
pageQueue.is_active = 0;
}
if (!string.IsNullOrEmpty(Request.Form["isShow"]) && Request.Form["isShow"] == "on")
{
pageQueue.is_show = 1;
}
else
{
pageQueue.is_show = 0;
}
pageQueue.cate_id = (int)DTO.DicEnum.DEPARTMENT_CATE.SERVICE_QUEUE;
if (!isAdd)
{
queue.name = pageQueue.name;
queue.location_id = pageQueue.location_id;
queue.no = pageQueue.no;
queue.description = pageQueue.description;
queue.is_active = pageQueue.is_active;
queue.is_show = pageQueue.is_show;
queue.other_email = pageQueue.other_email;
queue.other_email2 = pageQueue.other_email2;
queue.other_email3 = pageQueue.other_email3;
queue.other_email4 = pageQueue.other_email4;
}
var result = false;
if (isAdd)
{
result = depBll.AddQueue(pageQueue, LoginUserId);
}
else
{
result = depBll.EditQueue(queue, LoginUserId);
}
ClientScript.RegisterStartupScript(this.GetType(), "提示信息", $"<script>alert('保存{(result ? "成功" : "失败")}!');window.close();</script>");
}
protected void Page_Load(object sender, EventArgs e)
{
locationDic = depBll.GetDownList();
long id = 0;
if (!string.IsNullOrEmpty(Request.QueryString["id"]))
{
if (long.TryParse(Request.QueryString["id"], out id))
{
queue = depBll.GetQueue(id);
}
}
if (queue != null)
{
isAdd = false; resDepList = depBll.GetResDepList(queue.id);
}
}
/// <summary>
/// 激活/失活 队列
/// </summary>
public bool ActiveQueue(long queId, long userId, bool isActive)
{
sys_department thisQue = _dal.FindNoDeleteById(queId);
if (thisQue == null)
{
return(false);
}
sbyte active = (sbyte)(isActive?1:0);
if (thisQue.is_active != active)
{
thisQue.is_active = active;
return(EditQueue(thisQue, userId));
}
return(true);
}
public void SaveDepartment(sys_department dto)
{
if (dto.parent_id == 0)
{
dto.department_level = 1;
}
else
{
dto.department_level = Sqldb.Select <sys_department>().Where(s => s.id == dto.parent_id).First(s => s.parent_id) + 1;
}
if (dto.id == 0)
{
Sqldb.Insert(dto).ExecuteAffrows();
}
else
{
Sqldb.Update <sys_department>().SetSource(dto).IgnoreColumns(s => new { s.insert_id, s.insert_time })
.Where(s => s.id == dto.id).ExecuteAffrows();
}
}
public ERROR_CODE Update(sys_department sd, long user_id)
{
var user = UserInfoBLL.GetUserInfo(user_id);
if (user == null)
{ // 查询不到用户，用户丢失
return(ERROR_CODE.USER_NOT_FIND);
}
var de = _dal.FindSignleBySql <sys_department>($"select * from sys_department where name='{sd.name}' and delete_time=0");
var old = _dal.FindSignleBySql <sys_department>($"select * from sys_department where id={sd.id} and delete_time=0");
if (de != null && de.id != sd.id)
{
return(ERROR_CODE.EXIST);
}
sd.update_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now);
sd.update_user_id = user_id;
sd.cate_id = (int)DEPARTMENT_CATE.DEPARTMENT;
var add_account_log = new sys_oper_log()
{
user_cate = "用户",
user_id = (int)user.id,
name = user.name,
phone = user.mobile == null ? "" : user.mobile,
oper_time = Tools.Date.DateHelper.ToUniversalTimeStamp(DateTime.Now),
oper_object_cate_id = (int)OPER_LOG_OBJ_CATE.DEPARTMENT, //部门
oper_object_id = sd.id, // 操作对象id
oper_type_id = (int)OPER_LOG_TYPE.UPDATE,
oper_description = _dal.CompareValue(old, sd),
remark = "修改部门信息"
}; // 创建日志
new sys_oper_log_dal().Insert(add_account_log); // 插入日志
if (!_dal.Update(sd))
{
return(ERROR_CODE.ERROR);
}
return(ERROR_CODE.SUCCESS);
}
protected void Page_Load(object sender, EventArgs e)
{
id = Convert.ToInt32(Request.QueryString["id"]);
//id = 875;
if (!IsPostBack)
{
DepartmentBLL sqbll = new DepartmentBLL();
this.location.DataTextField = "value";
this.location.DataValueField = "key";
this.location.DataSource = sqbll.GetDownList();
this.location.DataBind();
this.location.Items.Insert(0, new ListItem()
{
Value = "0", Text = " ", Selected = true
});
if (id > 0)
{//打开修改模式
sd = sqbll.GetOne(id);
this.department_name.Text = sd.name;
if (sd.no != null && !string.IsNullOrEmpty(sd.no.ToString()))
{
this.department_no.Text = sd.no.ToString();
}
if (sd.description != null && !string.IsNullOrEmpty(sd.description.ToString()))
{
this.Description.Text = sd.description.ToString();
}
if (sd.location_id != null && !string.IsNullOrEmpty(sd.location_id.ToString()))
{
this.location.SelectedValue = sd.location_id.ToString();
this.location_name.Text = this.location.SelectedItem.Text.ToString();
//获取时区
//this.time_zone.Text =sqbll.GetTime_zone(Convert.ToInt32(sd.location_id.ToString()));
}
table = sqbll.resourcelist(id);
worktable = sqbll.worklist(id);
}
}
}
/// <summary>
/// 编辑部门
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public dynamic EditDepart(sys_department department)
{
try
{
db.BeginTransaction();
var sql = String.Format(@"update sys_department
set DepartmentName=@0 ,Description=@1
where DepartmentID=@2 ");
// int result = (int)db.Insert("sys_role", "role.RoleName,", role.RoleName, role.Description);
db.Execute(sql, department.DepartmentName, department.Description, department.DepartmentID);
db.CompleteTransaction();
return true;
}
catch (Exception)
{
return false;
}
return false;
}
public dynamic AddDepart(sys_department department)
{
try
{
department.IsEnable = true;
department.CreateDate = DateTime.Now;
db.BeginTransaction();
// var sql = String.Format(@"insert sys_role(RoleName,Description) values (@0,@1) ");
// int result = (int)db.Insert("sys_role", "role.RoleName,", role.RoleName, role.Description);
var result = (int)db.Insert(department);
db.CompleteTransaction();
return true;
}
catch (Exception)
{
return false;
}
return false;
}