public IActionResult Put(int id, [FromBody] Model.Department updateDepartment)
{
updateDepartment.Id = id;
var retval = repo.Update(updateDepartment);
return(StatusCode(StatusCodes.Status200OK, retval));
}
public override ActionResult Add(DriverForCar driverForCar)
{
try
{
Model.User user = this.service.User.Query().Where(u => u.IsUsed && (u.UserType == Model.Enums.UserType.Driver || u.UserType == Model.Enums.UserType.MixerDriver) && u.TrueName == driverForCar.UserID).FirstOrDefault();
if (user == null)
{
Model.Department department = this.service.GetGenericService <Department>().Query().Where(d => d.DepartmentName == "车队").FirstOrDefault();
if (department == null)
{
department = this.service.GetGenericService <Department>().All().FirstOrDefault();
}
if (department != null)
{
driverForCar.User.DepartmentID = department.ID ?? 0;
}
user = this.service.User.AddDrive(driverForCar.User);
}
driverForCar.UserID = user.ID;
return(base.Add(driverForCar));
}
catch (Exception ex)
{
if (ex.InnerException != null)
{
ex = ex.InnerException;
}
log.Error(ex.Message, ex);
return(HandleExceptionResult(ex));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Team10ADModel context = new Team10ADModel();
string requisitionid = (string)Session["requisitiondetail"];
int reqid = Convert.ToInt32(requisitionid);
Requisition req = RayBizLogic.GetRequisitionById(requisitionid);
var qry = from r in context.RequisitionDetails where r.RequisitionID == reqid select new { r.ItemCode, r.Catalogue.Description, r.QuantityRequested, r.QuantityRetrieved };
dgvRequisitionDetail.DataSource = qry.ToList();
dgvRequisitionDetail.DataBind();
dgvRequisitionDetail.AllowPaging = true;
Model.Employee emp = context.Employees.Where(x => x.EmployeeID == req.RequestorID).First();
Model.Department dept = context.Departments.Where(x => x.DepartmentCode == emp.DepartmentCode).First();
ReqIDTextBox.Text = req.RequisitionID.ToString();
StatusTextBox.Text = req.Status;
DeptNameTextBox.Text = dept.DepartmentName;
DeptCodeTextBox.Text = dept.DepartmentCode;
NameTextBox.Text = emp.Name;
EmployeePhoneTextBox.Text = emp.Phone.ToString();
EmailTextBox.Text = emp.Email;
}
}
/// <summary>
/// 修改部门
/// </summary>
public bool EditDepartment(Model.Department department)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tbDepartment set ");
strSql.Append("DepartmentName=@DepartmentName,Sort=@Sort ");
strSql.Append("where Id=@Id");
SqlParameter[] paras =
{
new SqlParameter("@DepartmentName", department.DepartmentName),
new SqlParameter("@Sort", department.Sort),
new SqlParameter("@Id", department.Id)
};
object obj = DriveMgr.Common.SqlHelper.ExecuteNonQuery(DriveMgr.Common.SqlHelper.connStr, CommandType.Text, strSql.ToString(), paras);
if (Convert.ToInt32(obj) > 0)
{
return(true);
}
else
{
return(false);
}
}
public ActionResult GetDepartment(string DepartmentID, string DepartmentName, string ParentDepartmentId)
{
IList <DepartmentDTO> result = new List <DepartmentDTO>();
DepartmentDTO Depart = new DepartmentDTO();
Depart.DepartmentID = DepartmentID;
Depart.DepartmentName = DepartmentName;
Depart.ParentDepartmentId = ParentDepartmentId;
Model.Department dep = DepartmentDTOMapper.MapFromDTO(Depart);
IList list = ManagerFactory.DepartmentManager.GetByCondition(dep);
int sIndex = int.Parse(this.Request.Params["start"] == null ? "0" : this.Request.Params["start"]);
int pageSize = int.Parse(this.Request.Params["limit"] == null ? list.Count.ToString() : this.Request.Params["limit"]);
for (int i = 0; i < pageSize && (sIndex + i) < list.Count; i++)
{
Department obj = (Department)list[sIndex + i];
result.Add(DepartmentDTOMapper.MapToDTO(obj));
}
// 组装返回结果
Dictionary <String, Object> resultMap = new Dictionary <String, Object>();
// 记录条数
resultMap.Add("total", list.Count);
// root
resultMap.Add("root", result);
return(this.Json(resultMap));
}
/// <summary>
/// 添加部门（确定按钮）
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ImageButton1_Click(object sender, EventArgs e)
{
try
{
if (TextBox1.Text.Trim() != "")
{
Maticsoft.Model.Department bumen = new Model.Department();
bumen.departmentname = TextBox1.Text.Trim();
bumen.Beizhu = TextBox2.Text.Trim();
int a = dep.Add(bumen);
if (a > 0)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('添加成功！');</script>");
bind(sql);
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('添加失败！');</script>");
bind(sql);
}
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('部门名称不能为空！');</script>");
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>javascript:showDiv1();</script>");
}
}
catch (Exception ee)
{
//Response.Write("<script>alert('确定异常 " + ee.Message + "')</script>");
ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('确定异常 " + ee.Message + "');</script>");
}
}
public EditForm(Model.Department Department)
: this()
{
this.employee = new Book.Model.Employee();
this.employee.EmployeeId = Guid.NewGuid().ToString();
this.employee.Department = Department;
tag = 1;
}
public bool ExistsExcept(Model.Department e)
{
Hashtable paras = new Hashtable();
paras.Add("newId", e.Id);
paras.Add("oldId", Get(e.DepartmentId) == null?null:Get(e.DepartmentId).Id);
return(sqlmapper.QueryForObject <bool>("Department.existsexcept", paras));
}
public void MyClick(ref ChooseItem item)
{
ChooseDepartmentForm f = new ChooseDepartmentForm();
if (f.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
Model.Department department = f.SelectedItem as Model.Department;
item = new ChooseItem(department, department.Id, department.DepartmentName);
}
}
public PrivilegeManagement.Model.Department Add(PrivilegeManagement.Model.Department entity)
{
Model.Department dept = new Model.Department();
dept.Description = entity.Description;
dept.Id = entity.Id;
dept.Name = entity.Name;
dept.Status = entity.Status;
_context.Departments.Create(dept);
return(_context.CreateProxy(entity));
}
public DepartmentData(Model.Department department)
{
if (department == null)
{
return;
}
ID = department.ID;
Name = department.Name;
Organization = new OrganizationData(department.Organization);
}
protected void btnInsert_Click(object sender, EventArgs e)
{
if (Request["DeptID"] == null)
{
if (VaildateNull())
{
DataTable dt = BLL.Department.GetDepartmentInfo(" and DeptName='" + txtDepartmentName.Text + "'");
if (dt.Rows.Count > 0)
{
lblDeptName.Text = "部门名称已存在！—_—";
lblManager.Text = "";
}
else
{
Model.Department d = new Model.Department();
d.DeptName = txtDepartmentName.Text;
d.ManagerID = ddlManager.SelectedValue;
d.DeptInfo = txtDepartmentInfo.Text;
if (BLL.Department.AddDepartmentInfo(d))
{
//表示添加成功
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加成功！');window.parent.location='/DepartmentList.aspx';", true);
}
else
{
//表示添加失败
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('添加失败！');", true);
}
}
}
}
else
{
if (VaildateNull())
{
Model.Department d = new Model.Department();
d.DeptID = int.Parse(Request["DeptID"].ToString());
d.DeptName = txtDepartmentName.Text;
d.ManagerID = ddlManager.SelectedValue;
d.DeptInfo = txtDepartmentInfo.Text;
if (BLL.Department.UpdateDepartmentInfo(d))
{
//表示修改成功
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('修改成功！');window.parent.location='/DepartmentList.aspx';", true);
}
else
{
//表示修改失败
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('修改失败！');", true);
}
}
}
}
private void bindingSourceDepartment_CurrentChanged(object sender, EventArgs e)
{
if (this.radioGroup1.SelectedIndex == 0)
{
this.department = this.bindingSourceDepartment.Current as Model.Department;
this.bindingSource1.DataSource = this.employeeManager.Select(department);
}
if (this.radioGroup1.SelectedIndex == 1)
{
this.bindingSource1.DataSource =this.employeeManager.SelectbyPinYin( this.bindingSourceDepartment.Current.ToString());
}
this.gridControl1.RefreshDataSource();
}
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "editt")
{
Div1.Style["display"] = "inline";
int xy = Convert.ToInt32(e.CommandArgument);
Button9.Text = "确定";
GridView1.Visible = false;
if (GridView1.Visible == true)
{
Button1.Visible = true;
Button4.Visible = true;
Button5.Visible = true;
ListBox1.Visible = true;
TextBox5.Visible = true;
}
else if (GridView1.Visible == false)
{
Button1.Visible = false;
Button4.Visible = false;
Button5.Visible = false;
ListBox1.Visible = false;
TextBox5.Visible = false;
}
TextBox1.Text = GridView1.Rows[xy].Cells[1].Text;
TextBox2.Text = GridView1.Rows[xy].Cells[2].Text;
//TextBox3.Text = GridView1.Rows[xy].Cells[3].Text;
//TextBox4.Text = GridView1.Rows[xy].Cells[4].Text;
Model.Department de = new Model.Department();
Model.staff st = new Model.staff();
de = new DAL.DepartmentDAO().getDepartById(GridView1.Rows[xy].Cells[3].Text);
st = new DAL.StaffDAO().getStaffByNum(GridView1.Rows[xy].Cells[4].Text);
TextBox3.Text = de.DepartName;
TextBox4.Text = st.StaffName;
Image11.Visible = true;
Image11.ImageUrl = "~/Image/对号.png";
Image12.Visible = true;
Image12.ImageUrl = "~/Image/对号.png";
Image1.Visible = true;
Image1.ImageUrl = "~/Image/对号.png";
Image2.Visible = true;
Image2.ImageUrl = "~/Image/对号.png";
rl.Refresh3("departId", "departName", "Department", TextBox1.Text, ListBox2);
}
if (e.CommandName == "deletee")
{
ideas.Style["display"] = "inline";
int x = Convert.ToInt32(e.CommandArgument);
Session["e"] = x;
}
}
public void DepartmentAdd()
{
if (SystemClass.CheckConnection())
{
try
{
using (var db = new ImusCityHallEntities())
{
if (!String.IsNullOrEmpty(txtCode.Text) && !String.IsNullOrEmpty(txtName.Text))
{
if (db.Departments.Any(m => m.DepartmentCode == txtCode.Text))
{
MessageBox.Show("Department code is already used");
}
else
{
Model.Department d = new Model.Department();
d.DepartmentCode = txtCode.Text;
d.DepartmentName = txtName.Text;
d.IsActive = true;
db.Departments.Add(d);
db.SaveChanges();
var audit = new AuditTrailModel
{
Activity = "Added new department in the database. DEPT CODE: " + txtCode.Text,
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
MessageBox.Show("Department added successfully", "System Success!", MessageBoxButton.OK, MessageBoxImage.Information);
TextClear();
}
}
else
{
MessageBox.Show("Fill up necessary fields.", "System Information!", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
}
catch (Exception ex)
{
MessageBox.Show("Something went wrong." + Environment.NewLine + ex.Message, "System Warning!", MessageBoxButton.OK, MessageBoxImage.Warning);
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
public void MyLeave(ref ChooseItem item)
{
BL.DepartmentManager manager = new Book.BL.DepartmentManager();
Model.Department department = manager.GetById(item.ButtonText);
if (department != null)
{
item.EditValue = department;
item.LabelText = department.DepartmentName;
item.ButtonText = department.Id;
}
else
{
item.ErrorMessage = Properties.Resources.ChooseDepartmentError;
}
}
public bool CheckPasswordPlocies(string password, int depid)
{
Model.Department _dep = new Model.Department();
tkv.Utility.XmlHelper _xml = new tkv.Utility.XmlHelper();
_dep = _dep.GetDepartments(null, depid).FirstOrDefault();
if (_dep != null && _dep.Setting != null)
{
var settings = _dep.Setting;
Settings _setting = _xml.DeserializeEntity <Settings>(_dep.Setting, new Settings());
if (_setting != null)
{
Password _pass = _setting.Password;
if (_pass == null)
{
return(true);
}
bool retval = true;
//+ indicate one or more accurance
if (_pass.LowerLtter)
{
retval = retval && Regex.IsMatch(password, "[a-z]+");
}
if (_pass.Number)
{
retval = retval && Regex.IsMatch(password, "[0-9]+");
}
if (_pass.UpperLetter)
{
retval = retval && Regex.IsMatch(password, "[A-Z]+");
}
if (_pass.Signs)
{
retval = retval && Regex.IsMatch(password, @"[^a-zA-Z0-9\s]+");//[] character group as single char OR CAN BE [^\w\s]
}
if (!string.IsNullOrEmpty(_pass.MinimumChar))
{
retval = retval && password.Length >= _pass.MinimumChar.ToInt32() ? true :false;
}
return(retval);
}
else
{
return(true);
}
}
return(true);
}
/// <summary>
/// 添加部门
/// </summary>
public int AddDepartment(Model.Department department)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tbDepartment(DepartmentName,ParentId,Sort)");
strSql.Append(" values ");
strSql.Append("(@DepartmentName,@ParentId,@Sort)");
strSql.Append(";SELECT @@IDENTITY"); //返回插入用户的主键
SqlParameter[] paras =
{
new SqlParameter("@DepartmentName", department.DepartmentName),
new SqlParameter("@ParentId", department.ParentId),
new SqlParameter("@Sort", department.Sort)
};
return(Convert.ToInt32(DriveMgr.Common.SqlHelper.ExecuteScalar(DriveMgr.Common.SqlHelper.connStr, CommandType.Text, strSql.ToString(), paras)));
}
protected void GvDepartmentInfo_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DeleteUserInfo")
{
Model.Department u = new Model.Department();
u.DeptID = int.Parse(e.CommandArgument.ToString());
if (BLL.Department.DelDepartmentInfo(u))
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('删除成功！');window.parent.location='/DepartmentList.aspx';", true);
}
else
{
this.ClientScript.RegisterStartupScript(this.GetType(), "", "alert('删除失败！');", true);
}
}
}
/// <summary>
/// Change collection point according to Dept
/// </summary>
/// <param name="DeptID">Department ID</param>
/// <param name="CPID">Collection Point ID</param>
/// <returns>true if the </returns>
public bool updateCollectionPoint(string DeptID, string CPID)
{
bool result = true;
Model.Department dept = (from c in ctx.Department
where c.DeptID == DeptID
select c).First();
dept.CPID = Convert.ToInt32(CPID);
try
{
ctx.SaveChanges();
}
catch
{
result = false;
}
return(result);
}
protected void Button200_Click(object sender, EventArgs e)
{
Model.Department delete = new Model.Department();
int x = Convert.ToInt32(Session["e"]);
delete.DepartId = GridView1.Rows[x].Cells[1].Text;
bool yy = new DAL.DepartmentDAO().deleteDepartById(GridView1.Rows[x].Cells[1].Text);
if (yy)
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除成功！');", true);
Server.Transfer("管理部门.aspx");
}
else
{
ClientScript.RegisterClientScriptBlock(this.GetType(), "msg", "alert('删除失败！');", true);
}
}
public ActionResult UpdateDepart(DepartmentDTO Depart)
{
var rdto = new ResultDTO();
Model.Department dep = DepartmentDTOMapper.MapFromDTO(Depart);
try
{
ManagerFactory.DepartmentManager.UpdateDepartment(dep);
rdto.Message = "更新成功";
rdto.Result = true;
}
catch
{
rdto.Message = "更新失败";
rdto.Result = false;
}
return(this.Json(rdto));
}
public ActionResult AddDepart(DepartmentDTO Depart)
{
var rdto = new ResultDTO();
Model.Department dep = DepartmentDTOMapper.MapFromDTO(Depart);
try
{
ManagerFactory.DepartmentManager.SaveDepartment(dep);
rdto.Message = "登录成功";
rdto.Result = true;
}
catch (Exception ex)
{
rdto.Message = "登录失败:" + ex.Message;
rdto.Result = false;
}
return(this.Json(rdto));
}
/// <summary>
/// 修改弹窗赋值
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void LinkButton1_Click(object sender, EventArgs e)
{
try
{
//获取button 控件
LinkButton lb = (LinkButton)sender;
//获取传过来的commwntid
int id = Convert.ToInt32(lb.CommandArgument);
Model.Department po = dep.GetModel(id);
Label1.Text = po.id.ToString();
TextBox4.Text = po.departmentname;
TextBox5.Text = po.Beizhu;
ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>javascript:showDiv2();</script>");
}
catch (Exception ee)
{
//Response.Write("<script>alert('确定异常 " + ee.Message + "')</script>");
ClientScript.RegisterClientScriptBlock(this.GetType(), "this", "<script language=javascript>alert('修改弹窗异常 " + ee.Message + "');</script>");
}
}
protected void Button30_Click(object sender, EventArgs e)
{
Button btn = (Button)sender;
Model.Department delete = new Model.Department();
GridViewRow row = (GridViewRow)btn.NamingContainer;
delete.DepartId = row.Cells[0].Text;
int xx = new DAL.DepartmentDAO().updateParentDepartName(delete);
bool yy = new DAL.DepartmentDAO().deleteDepartById(delete.DepartId);
if (yy && xx > 0)
{
Response.Write("<script>alert('删除成功，并将其下属部门的上级部门重置！')</script>");
Refreshs("");
}
else
{
Response.Write("<script>alert('删除失败!')</script>");
}
}
public IList <Book.Model.Employee> Select(Model.Department department)
{
return(sqlmapper.QueryForList <Model.Employee>("Employee.select_byDepartment", department.DepartmentId));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "application/json";
string action = context.Request.Params["action"];
ZGZY.Model.UserOperateLog userOperateLog = null; //操作日志对象
try
{
ZGZY.Model.User user = ZGZY.Common.UserHelper.GetUser(context); //获取cookie里的用户对象
userOperateLog = new Model.UserOperateLog();
userOperateLog.UserIp = context.Request.UserHostAddress;
userOperateLog.UserName = user.UserId;
switch (action)
{
case "getall":
context.Response.Write(new ZGZY.BLL.Department().GetAllDepartment("1=1"));
break;
case "search":
string strJson = new ZGZY.BLL.Department().GetAllDepartment(null);
context.Response.Write(strJson);
userOperateLog.OperateInfo = "查询部门";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "查询条件：1=1";
ZGZY.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
break;
case "searchDepartmentUser":
string userDepartmentIds = context.Request.Params["departmentId"];
string sortDepartmentUser = context.Request.Params["sort"]; //排序列
string orderDepartmentUser = context.Request.Params["order"]; //排序方式 asc或者desc
int pageindexDepartmentUser = int.Parse(context.Request.Params["page"]);
int pagesizeDepartmentUser = int.Parse(context.Request.Params["rows"]);
string strJsonDepartmentUser = new ZGZY.BLL.Department().GetPagerDepartmentUser(userDepartmentIds, sortDepartmentUser + " " + orderDepartmentUser, pagesizeDepartmentUser, pageindexDepartmentUser);
context.Response.Write(strJsonDepartmentUser);
userOperateLog.OperateInfo = "查询部门用户";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "查询部门Id：" + userDepartmentIds + " 排序：" + sortDepartmentUser + " " + orderDepartmentUser + " 页码/每页大小：" + pageindexDepartmentUser + " " + pagesizeDepartmentUser;
ZGZY.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
break;
case "add":
if (user != null && new ZGZY.BLL.Authority().IfAuthority("department", "add", user.Id))
{
ZGZY.Model.Department departmentAdd = new Model.Department();
departmentAdd.DepartmentName = context.Request.Params["ui_department_departmentname_add"] ?? "";
departmentAdd.Sort = Convert.ToInt32(context.Request.Params["ui_department_sort_add"]);
if (context.Request.Params["ui_department_parentid_add"] != null && context.Request.Params["ui_department_parentid_add"] != "")
{
departmentAdd.ParentId = Convert.ToInt32(context.Request.Params["ui_department_parentid_add"]);
}
else
{
departmentAdd.ParentId = 0; //根节点
}
int departmentId = new ZGZY.BLL.Department().AddDepartment(departmentAdd);
if (departmentId > 0)
{
userOperateLog.OperateInfo = "添加部门";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "添加成功，部门主键：" + departmentId;
context.Response.Write("{\"msg\":\"添加成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "添加部门";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "添加失败";
context.Response.Write("{\"msg\":\"添加失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "添加部门";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":true}");
}
ZGZY.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
break;
case "edit":
if (user != null && new ZGZY.BLL.Authority().IfAuthority("department", "edit", user.Id))
{
ZGZY.Model.Department departmentEdit = new Model.Department();
departmentEdit.Id = Convert.ToInt32(context.Request.Params["id"]);
departmentEdit.DepartmentName = context.Request.Params["ui_department_departmentname_edit"] ?? "";
departmentEdit.Sort = Convert.ToInt32(context.Request.Params["ui_department_sort_edit"]);
bool result = new ZGZY.BLL.Department().EditDepartment(departmentEdit);
if (result)
{
userOperateLog.OperateInfo = "修改部门";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "修改成功，部门主键：" + departmentEdit.Id;
context.Response.Write("{\"msg\":\"修改成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "修改部门";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "修改失败，部门主键：" + departmentEdit.Id;
context.Response.Write("{\"msg\":\"修改失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "修改部门";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
ZGZY.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
break;
case "delete":
if (user != null && new ZGZY.BLL.Authority().IfAuthority("department", "delete", user.Id))
{
string departmentIds = context.Request.Params["id"];
if (new ZGZY.BLL.Department().DeleteDepartment(departmentIds))
{
userOperateLog.OperateInfo = "删除部门";
userOperateLog.IfSuccess = true;
userOperateLog.Description = "删除成功，部门主键：" + departmentIds;
context.Response.Write("{\"msg\":\"删除成功！\",\"success\":true}");
}
else
{
userOperateLog.OperateInfo = "删除部门";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "删除失败，部门主键：" + departmentIds;
context.Response.Write("{\"msg\":\"删除失败！\",\"success\":false}");
}
}
else
{
userOperateLog.OperateInfo = "删除部门";
userOperateLog.IfSuccess = false;
userOperateLog.Description = "无权限，请联系管理员";
context.Response.Write("{\"msg\":\"无权限，请联系管理员！\",\"success\":false}");
}
ZGZY.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
break;
default:
context.Response.Write("{\"msg\":\"参数错误！\",\"success\":false}");
break;
}
}
catch (Exception ex)
{
context.Response.Write("{\"msg\":\"" + ZGZY.Common.JsonHelper.StringFilter(ex.Message) + "\",\"success\":false}");
userOperateLog.OperateInfo = "部门功能异常";
userOperateLog.IfSuccess = false;
userOperateLog.Description = ZGZY.Common.JsonHelper.StringFilter(ex.Message);
ZGZY.BLL.UserOperateLog.InsertOperateInfo(userOperateLog);
}
}
/// <summary>
/// 修改部门
/// </summary>
public bool EditDepartment(Model.Department department)
{
return(dal.EditDepartment(department));
}
/// <summary>
/// 添加部门
/// </summary>
public int AddDepartment(Model.Department department)
{
return(dal.AddDepartment(department));
}
public IList <Book.Model.RoleAuditing> GetByDate(DateTime startDate, DateTime endDate, Model.Department department, Model.Employee emp0, Model.Operators oper, bool isNoAudit, bool isHasAudit)
{
SqlParameter[] parames = { new SqlParameter("@startdate", DbType.DateTime), new SqlParameter("@enddate", DbType.DateTime), new SqlParameter("@OperatorsId", SqlDbType.VarChar, 50), new SqlParameter("@employee0id", SqlDbType.VarChar, 50) };
parames[0].Value = startDate;
parames[1].Value = endDate;
parames[2].Value = oper.OperatorsId;
if (emp0 == null)
{
parames[3].Value = DBNull.Value;
}
else
{
parames[3].Value = emp0.EmployeeId;
}
StringBuilder sql = new StringBuilder();
sql.Append("SELECT r.*,(select e.EmployeeName from Employee e where e.EmployeeId = r.Employee0Id ) as Employee0Name,(select e.EmployeeName from Employee e where e.EmployeeId = r.Employee1Id ) as Employee1Name from RoleAuditing r where inserttime between @startdate and @enddate");
if (emp0 != null)
{
sql.Append(" and employee0id=@employee0id");
}
if (oper != null)
{
sql.Append(" and (NextAuditRoleId IN(select RoleId from OperationRole where OperatorsId = @OperatorsId and IsHold=1) or NextAuditRoleId is null)");
}
if (!isNoAudit || !isHasAudit)
{
if (isNoAudit)
{
sql.Append(" and auditstate<>3 ");
}
if (isHasAudit)
{
sql.Append(" and auditstate=3 ");
}
}
sql.Append(" order by inserttime desc ");
return(this.DataReaderBind <Model.RoleAuditing>(sql.ToString(), parames, CommandType.Text));
}
