public ActionResult Edit(string id, SysDepartment entity)
{
if (entity != null && ModelState.IsValid)
{ //数据校验
string currentPerson = GetCurrentPerson();
entity.UpdateTime = DateTime.Now;
entity.UpdatePerson = currentPerson;
string returnValue = string.Empty;
if (m_BLL.Edit(ref validationErrors, entity))
{
LogClassModels.WriteServiceLog(Suggestion.UpdateSucceed + "，部门信息的Id为" + id, "部门"
); //写入日志
return(Json(Suggestion.UpdateSucceed)); //提示更新成功
}
else
{
if (validationErrors != null && validationErrors.Count > 0)
{
validationErrors.All(a =>
{
returnValue += a.ErrorMessage;
return(true);
});
}
LogClassModels.WriteServiceLog(Suggestion.UpdateFail + "，部门信息的Id为" + id + "," + returnValue, "部门"
); //写入日志
return(Json(Suggestion.UpdateFail + returnValue)); //提示更新失败
}
}
return(Json(Suggestion.UpdateFail + "请核对输入的数据的格式")); //提示输入的数据的格式不对
}
protected void ZButton1_Click(object sender, EventArgs e)
{
SysDepartment sd = new SysDepartment();
sd.DepartmentID = bd.GetMaxID() + 1;
sd.DepartmentName = PubCom.CheckString(txtDepartmentName.Text.Trim());
sd.IsUse = cbIsUse.Checked;
if (bd.Insert(sd) != 1)
{
Message.ShowWrong(this, "添加失败");
return;
}
else
{
// 插入日志
SysOperateLog log = new SysOperateLog();
log.LogID = StringHelper.getKey();
log.LogType = LogType.部门信息.ToString();
log.LogObjectID = sd.DepartmentID.ToString();
log.LogObjectName = sd.DepartmentName;
log.OperateUser = GetLogUserName();
log.OperateDate = DateTime.Now;
log.LogOperateType = "部门添加";
log.LogAfterObject = JsonHelper.Obj2Json(sd);
bsol.Insert(log);
Message.ShowOK(this, "添加成功");
BindList();
}
}
/// <summary>
/// 编辑一个部门
/// </summary>
/// <param name="validationErrors">返回的错误信息</param>
/// <param name="db">数据上下文</param>
/// <param name="entity">一个部门</param>
/// <returns>是否编辑成功</returns>
public bool Edit(ref ValidationErrors validationErrors, SysEntities db, SysDepartment entity)
{ /*
* 不操作 原有 现有
* 增加 原没 现有
* 删除 原有 现没
*/
if (entity == null)
{
return(false);
}
int count = 1;
List <string> addSysDocumentId = new List <string>();
List <string> deleteSysDocumentId = new List <string>();
DataOfDiffrent.GetDiffrent(entity.SysDocumentId.GetIdSort(), entity.SysDocumentIdOld.GetIdSort(), ref addSysDocumentId, ref deleteSysDocumentId);
SysDepartment editEntity = repository.Edit(db, entity);
if (count == repository.Save(db))
{
return(true);
}
else
{
validationErrors.Add("编辑部门出错了");
}
return(false);
}
//编辑部门
public ActionResult EditDept(int deptId = 0, int parentId = 0)
{
SysDepartment dept = _deptManager.GetDeptById(deptId);
if (dept == null)
{
var parentName = CurrentTenant.TenantName;
if (parentId > 0)
{
var p = _deptManager.GetDeptById(parentId);
if (p != null)
{
parentName = p.DeptName;
}
else
{
parentId = 0;
}
}
dept = new SysDepartment()
{
ParentId = parentId, ParentName = parentName
};
}
else if (dept.ParentId == 0)
{
dept.ParentName = CurrentTenant.TenantName;
}
return(View(dept));
}
private void SaveData()
{
var user = new SysUser();
if (UserID > 0)
{
user.LoadByIdentity(UserID);
SetData(user);
user.Update();
}
else
{
SetData(user);
//学生初始化
user.UserType = (int)SysUserType.Student;
user.Password = SysConsts.InitPassword.MD5Hash().ToUpper();
user.RoleIDs = "1";
user.IsDeleted = false;
var deptId = Convert.ToInt32(tbxDepartmentID.SelectedValue);
var dept = new SysDepartment(deptId);
dept.Load();
user.DepartmentID = dept.ID;
user.DepartmentName = dept.Name;
user.BaseDeptID = dept.BaseDeptID;
user.BaseDeptName = dept.BaseDeptName;
user.DepartmentType = dept.DepartmentType;
user.Add();
}
}
/// <summary>
/// 将数据插入表
/// </summary>
/// <param name="M">赋值后的实体</param>
/// <returns></returns>
public static void Insert(SysDepartment M)
{
IDbHelper Sql = GetHelper();
StringBuilder sb = new StringBuilder();
sb.Append("insert into [SysDepartment]([DepartName]) values(");
sb.Append("N'" + M.DepartName + "'");
sb.Append(")");
if (DataBase.CmsDbType == DataBase.DbType.SqlServer)
{
sb.Append(";select @@Identity");
}
if (DataBase.CmsDbType == DataBase.DbType.SQLite)
{
sb.Append(";select last_insert_rowid()");
}
if (DataBase.CmsDbType == DataBase.DbType.MySql)
{
sb.Append(";select LAST_INSERT_ID()");
}
if (DataBase.CmsDbType == DataBase.DbType.Access)
{
sb.Append(";select max(ID) from SysDepartment");
}
if (DataBase.CmsDbType == DataBase.DbType.Oracle)
{
sb.Append(";select LAST_INSERT_ID()");
}
M.ID = Sql.ExecuteScalar(CommandType.Text, sb.ToString()).ToInt32();
}
private void SaveData()
{
var user = new SysUser();
if (UserID > 0)
{
user.LoadByIdentity(UserID);
SetData(user);
user.Update();
}
else
{
SetData(user);
//老师初始化
user.UserType = (int)SysUserType.Teacher;
user.Password = SysConsts.InitPassword.MD5Hash().ToUpper();
user.RoleIDs = "2";
user.IsDeleted = false;
var dept = new SysDepartment(SysConsts.TeacherDeptID);
dept.Load();
user.DepartmentID = dept.ID;
user.DepartmentName = dept.Name;
user.BaseDeptID = dept.BaseDeptID;
user.BaseDeptName = dept.BaseDeptName;
user.DepartmentType = dept.DepartmentType;
user.Add();
}
}
/// <summary>
/// 登陆
/// </summary>
public static BaseUser UserLogin(SysUser user)
{
var dept = new SysDepartment(user.DepartmentID);
dept.Load();
user.DepartmentName = dept.Name;
user.BaseDeptName = dept.BaseDeptName;
user.LastLoginTime = DateTime.Now;
user.UpdateTime = DateTime.Now;
user.Update();
return(new BaseUser
{
ID = user.ID,
UserName = user.UserName,
UserType = user.UserType,
RoleIDs = user.RoleIDs,
RealName = user.RealName,
Sex = user.Sex,
Binrthday = user.Binrthday,
Tel = user.Tel,
Mobile = user.Mobile,
Email = user.Email,
Duty = user.Duty,
BaseDeptID = user.BaseDeptID,
BaseDeptName = user.BaseDeptName,
DepartmentID = user.DepartmentID,
DepartmentName = user.DepartmentName,
DeptPath = user.DeptPath,
Status = user.Status,
});
}
/// <summary>
/// 修改
/// </summary>
private void updateDepartment()
{
try
{
SysDepartment department = new SysDepartment();
department.D_Code = D_Code.Text;
department.D_Name = D_Name.Text;
department.C_Code = C_Code.SelectedValue.ToString();
department.D_Remark = D_Remark.Text;
department.D_CreateBy = D_CreateBy.Text;
department.D_CreateDate = D_CreateDate.Value;
department.D_UpdateBy = D_UpdateBy.Text;
department.D_UpdateDate = D_UpdateDate.Value;
SysDepartmentBLL departmentbll = new SysDepartmentBLL();
if (departmentbll.Edit(department) > 0)
{
untCommon.InfoMsg("修改成功！");
frmParent.loadData();
}
else
{
untCommon.InfoMsg("修改失败！");
}
}
catch (Exception ex)
{
untCommon.ErrorMsg("部门管理更新数据异常：" + ex);
}
}
public ActionResult Create(SysDepartment entity)
{
if (entity != null && ModelState.IsValid)
{
string currentPerson = GetCurrentPerson();
entity.CreateTime = DateTime.Now;
entity.CreatePerson = currentPerson;
entity.Id = Result.GetNewId();
string returnValue = string.Empty;
if (m_BLL.Create(ref validationErrors, entity))
{
LogClassModels.WriteServiceLog(Suggestion.InsertSucceed + "，部门的信息的Id为" + entity.Id,"部门"
);//写入日志
return Json(Suggestion.InsertSucceed);
}
else
{
if (validationErrors != null && validationErrors.Count > 0)
{
validationErrors.All(a =>
{
returnValue += a.ErrorMessage;
return true;
});
}
LogClassModels.WriteServiceLog(Suggestion.InsertFail + "，部门的信息，" + returnValue,"部门"
);//写入日志
return Json(Suggestion.InsertFail + returnValue); //提示插入失败
}
}
return Json(Suggestion.InsertFail + "，请核对输入的数据的格式"); //提示输入的数据的格式不对
}
/// <summary>
/// 创建一个文档管理
/// </summary>
/// <param name="validationErrors">返回的错误信息</param>
/// <param name="db">数据库上下文</param>
/// <param name="entity">一个文档管理</param>
/// <returns></returns>
public bool Create(ref ValidationErrors validationErrors, SysEntities db, SysDocument entity)
{
int count = 1;
foreach (string item in entity.SysPersonId.GetIdSort())
{
SysPerson sys = new SysPerson {
Id = item
};
db.SysPerson.Attach(sys);
entity.SysPerson.Add(sys);
count++;
}
foreach (string item in entity.SysDepartmentId.GetIdSort())
{
SysDepartment sys = new SysDepartment {
Id = item
};
db.SysDepartment.Attach(sys);
entity.SysDepartment.Add(sys);
count++;
}
repository.Create(db, entity);
if (count == repository.Save(db))
{
return(true);
}
else
{
validationErrors.Add("创建出错了");
}
return(false);
}
protected void ZButton2_Click(object sender, EventArgs e)
{
for (int i = 0; i < rplist.Items.Count; i++)
{
SysDepartment sd = new SysDepartment();
sd.DepartmentID = int.Parse((rplist.Items[i].FindControl("zlsc") as ZLinkButton).CommandArgument);
sd.DepartmentName = PubCom.CheckString((rplist.Items[i].FindControl("tDepartmentName") as TextBox).Text.Trim());
sd.IsUse = (rplist.Items[i].FindControl("cIsUse") as CheckBox).Checked;
var olddepartment = JsonHelper.Obj2Json(bd.GetDepartmentByID(sd.DepartmentID));
bd.Update(sd);
if (olddepartment == JsonHelper.Obj2Json(sd))
{
// 插入日志
SysOperateLog log = new SysOperateLog();
log.LogID = StringHelper.getKey();
log.LogType = LogType.部门信息.ToString();
log.OperateUser = GetLogUserName();
log.OperateDate = DateTime.Now;
log.LogOperateType = "部门修改";
log.LogBeforeObject = olddepartment;
log.LogAfterObject = JsonHelper.Obj2Json(sd);
bsol.Insert(log);
}
}
BindList();
Message.ShowOK(this, "修改完成");
}
public JsonResult DeleteDept(int deptId)
{
SysDepartment dept = _deptManager.GetDeptById(deptId);
if (dept == null)
{
return(Json(new { result = 0, content = RetechWing.LanguageResources.TenantUI.TenantPost.CanNotFoundDeptForDel }, JsonRequestBehavior.AllowGet));
}
List <int> deptIds = new List <int>();
GetChildDeptIds(deptId, _deptManager.GetAllDept(CurrentTenant.TenantId), deptIds);
if (deptIds.Count > 0)
{
return(Json(new { result = 0, content = RetechWing.LanguageResources.TenantUI.TenantPost.SubForCanNotDel }, JsonRequestBehavior.AllowGet));
}
int total;
if (_userManager.GetUserList(out total, CurrentTenant.TenantId, "", "", "", "", new int[] { deptId }, new int[0], new int[0], -1, -1, "", 0, int.MaxValue).Count() > 0)
{
return(Json(new { result = 0, content = RetechWing.LanguageResources.TenantUI.TenantPost.PeopleForNotDel }, JsonRequestBehavior.AllowGet));
}
dept.Status = 1;
_deptManager.UpdateDept(dept);
return(Json(new { result = 1 }, JsonRequestBehavior.AllowGet));
}
public ActionResult GetOption()
{
List <Option> optionslist = new List <Option>();
Option option = null;
SysDepartment sysDepartments = m_BLL.GetAllMetadata(null).FirstOrDefault();
if (sysDepartments != null)
{
DataList dataList = new DataList();
dataList.id = sysDepartments.Id;
dataList.name = "部门";
dataList.title = sysDepartments.Name;
dataList.num = sysDepartments.SysPerson.Count().ToString();
dataList.children = sysDepartments.SysDepartment1.Any(a => a.ParentId == sysDepartments.Id) ? Datajson(sysDepartments.SysDepartment1.ToList()) : null;
List <Option> op = new List <Option>();
if (dataList.children != null)
{
optionslist = GetTs(dataList.children, ref op);
}
option = new Option();
option.Key = sysDepartments.Id;
option.Value = sysDepartments.Name;
optionslist.Add(option);
}
return(Json(optionslist));
}
private void SaveData()
{
var dept = new SysDepartment();
if (DeptID > 0)
{
dept.LoadByIdentity(DeptID);
SetData(dept);
dept.Update();
}
else
{
SetData(dept);
//班级初始化
dept.IsDeleted = false;
var rootDept = new SysDepartment(SysConsts.RootDeptID);
rootDept.Load();
dept.BaseDeptName = rootDept.Name;
dept.BaseDeptID = rootDept.ID;
dept.ParentID = rootDept.ID;
dept.ParentName = rootDept.Name;
dept.Add();
}
}
public UserView(SysUser mSysUser, SysDepartment mDepartment)
{
InitializeComponent();
this.DataContext = mSysUser;
Department = mDepartment;
this.departName.Text = mDepartment.DEPARTMENT_NAME;
}
private void treeList_SelectedItemChanged(object sender, DevExpress.Xpf.Grid.SelectedItemChangedEventArgs e)
{
if (this.treeList.SelectedItem != null && this.treeList.SelectedItem.ToString() != "False" &&
this.treeList.SelectedItem.ToString() != "True")
{
gbMenuContent.DataContext = this.treeList.SelectedItem as SysDepartment;
if (
_SDMService.UseService(
s =>
s.GetSysDepartments("")
.Where(c => c.PKNO == (this.treeList.SelectedItem as SysDepartment)
.PARENT_DEPARTMENT_PKNO))
.ToList()
.Count > 0)
{
SysDepartment m_SysDepartment =
_SDMService.UseService(
s =>
s.GetSysDepartments("")
.Where(c => c.PKNO == (this.treeList.SelectedItem as SysDepartment)
.PARENT_DEPARTMENT_PKNO))
.ToList()[0];
parentname.Text = m_SysDepartment.DEPARTMENT_NAME;
}
}
InitUser();
}
public ActionResult Create(SysDepartment entity)
{
if (entity != null && ModelState.IsValid)
{
string currentPerson = GetCurrentPerson();
entity.CreateTime = DateTime.Now;
entity.CreatePerson = currentPerson;
entity.Id = Result.GetNewId();
string returnValue = string.Empty;
if (m_BLL.Create(ref validationErrors, entity))
{
LogClassModels.WriteServiceLog(Suggestion.InsertSucceed + "，部门的信息的Id为" + entity.Id, "部门"
);//写入日志
return(Json(Suggestion.InsertSucceed));
}
else
{
if (validationErrors != null && validationErrors.Count > 0)
{
validationErrors.All(a =>
{
returnValue += a.ErrorMessage;
return(true);
});
}
LogClassModels.WriteServiceLog(Suggestion.InsertFail + "，部门的信息，" + returnValue, "部门"
); //写入日志
return(Json(Suggestion.InsertFail + returnValue)); //提示插入失败
}
}
return(Json(Suggestion.InsertFail + "，请核对输入的数据的格式")); //提示输入的数据的格式不对
}
/// <summary>
/// 获取部门人员
/// </summary>
private void InitUser()
{
SysDepartment m_SysDepartment = this.treeList.SelectedItem as SysDepartment;
List <SysUser> mSysUsers = _SDMService
.UseService(s => s.GetSysUsers(" USE_FLAG = 1 AND DEPARTMENT_CODE = " + m_SysDepartment.PKNO + "")).ToList();
UserDataGrid.ItemsSource = mSysUsers;
}
/// <summary>
/// 更新服务中心信息
/// </summary>
/// <param name="dept"></param>
public int UpdateDpet(SysDepartment dept)
{
if (dept == null)
{
return(0);
}
return(_dataAccess.UpdateEntity(dept));
}
/// <summary>
/// 根据关键字段的值获取记录
/// </summary>
/// <param name="Id">关键字段的值</param>
/// <returns>符合查询条件的记录</returns>
public SysDepartment GetSysDepartmentById(string Id)
{
using (ISysDepartmentBLL SysDepartmentBLL = BLLContainer.Resolve <ISysDepartmentBLL>())
{
SysDepartment model = SysDepartmentBLL.GetFirstOrDefault(Id);
return(model);
}
}
public ActionResult DeleteConfirmed(int id)
{
SysDepartment sysDepartment = db.SysDepartments.Find(id);
db.SysDepartments.Remove(sysDepartment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
/// <summary>
/// 编辑一个部门
/// </summary>
/// <param name="validationErrors">返回的错误信息</param>
/// <param name="db">数据上下文</param>
/// <param name="entity">一个部门</param>
/// <returns>是否编辑成功</returns>
public bool Edit(ref ValidationErrors validationErrors, SysEntities db, SysDepartment entity)
{ /*
* 不操作 原有 现有
* 增加 原没 现有
* 删除 原有 现没
*/
if (entity == null)
{
return(false);
}
int count = 1;
SysDepartment editEntity = repository.Edit(db, entity);
List <string> addSysDocumentId = new List <string>();
List <string> deleteSysDocumentId = new List <string>();
DataOfDiffrent.GetDiffrent(entity.SysDocumentId.GetIdSort(), entity.SysDocumentIdOld.GetIdSort(), ref addSysDocumentId, ref deleteSysDocumentId);
if (addSysDocumentId != null && addSysDocumentId.Count() > 0)
{
foreach (var item in addSysDocumentId)
{
SysDocument sys = new SysDocument {
Id = item
};
db.SysDocument.Attach(sys);
editEntity.SysDocument.Add(sys);
count++;
}
}
if (deleteSysDocumentId != null && deleteSysDocumentId.Count() > 0)
{
List <SysDocument> listEntity = new List <SysDocument>();
foreach (var item in deleteSysDocumentId)
{
SysDocument sys = new SysDocument {
Id = item
};
listEntity.Add(sys);
db.SysDocument.Attach(sys);
}
foreach (SysDocument item in listEntity)
{
editEntity.SysDocument.Remove(item);//查询数据库
count++;
}
}
if (count == repository.Save(db))
{
return(true);
}
else
{
validationErrors.Add("编辑部门出错了");
}
return(false);
}
public ActionResult UpdateTree(string id)
{
SysDepartment sysDepartment = m_BLL.GetById(id);
List <Option> op = new List <Option>();
if (sysDepartment == null)
{
return(null);
}
List <Option> optionslist = new List <Option>();
Option option = null;
List <DataList> departments = sysDepartment.SysDepartment1.Any(a => a.ParentId == sysDepartment.Id) ? Datajson(sysDepartment.SysDepartment1.ToList()) : null;
if (departments != null)
{
List <Option> options = GetTs(departments, ref op);
List <string> key = options.Select(s => s.Key).ToList();
key.Add(sysDepartment.Id);
List <SysDepartment> sysDepartments = m_BLL.GetAll().Where(m => !key.Contains(m.Id)).ToList();
foreach (SysDepartment item in sysDepartments)
{
option = new Option();
option.Key = item.Id;
option.Value = item.Name;
optionslist.Add(option);
}
}
else
{
List <SysDepartment> sysDepartments = m_BLL.GetAll().Where(m => m.Id != sysDepartment.Id).ToList();
foreach (SysDepartment item in sysDepartments)
{
option = new Option();
option.Key = item.Id;
option.Value = item.Name;
optionslist.Add(option);
}
}
return(Json(new treegrid
{
rows = new SysDepartment
{
Id = sysDepartment.Id,
Name = sysDepartment.Name,
ParentId = sysDepartment.ParentId,
Address = sysDepartment.Address,
Sort = sysDepartment.Sort,
Remark = sysDepartment.Remark,
CreateTime = sysDepartment.CreateTime,
CreatePerson = sysDepartment.CreatePerson,
UpdateTime = sysDepartment.UpdateTime,
UpdatePerson = sysDepartment.UpdatePerson,
Variables = optionslist
}
}));
}
//
// GET: /Platform/iDepartment/Edit/5
public ActionResult Edit(string id)
{
var item = new SysDepartment();
if (!string.IsNullOrEmpty(id))
{
item = _iDepartmentService.GetById(id);
}
return(View(item));
}
/// <summary>
/// </summary>
/// <param name="id">
/// </param>
/// <returns>
/// </returns>
public async Task <IActionResult> Edit(string id)
{
var item = new SysDepartment();
if (!string.IsNullOrEmpty(id))
{
item = await _iSysDepartmentService.FindAsync(id);
}
return(View(item));
}
public ActionResult Edit([Bind(Include = "Id,DepartmentName,DepartmentDesc")] SysDepartment sysDepartment)
{
if (ModelState.IsValid)
{
db.Entry(sysDepartment).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sysDepartment));
}
//
// GET: /Platform/SysDepartment/Edit/5
public ActionResult Edit(Guid?id)
{
var item = new SysDepartment();
if (id.HasValue)
{
item = _sysDepartmentService.GetById(id.Value);
}
return(View(item));
}
/// <summary>
/// 修改
/// </summary>
/// <param name="mSysDepartment">模型</param>
/// <returns>是否成功</returns>
public bool UpdateSysDepartment(SysDepartment mSysDepartment)
{
if (mSysDepartment == null)
{
return(false);
}
using (ISysDepartmentBLL SysDepartmentBLL = BLLContainer.Resolve <ISysDepartmentBLL>())
{
return(SysDepartmentBLL.Update(mSysDepartment));
}
}
public ActionResult Create([Bind(Include = "Id,DepartmentName,DepartmentDesc")] SysDepartment sysDepartment)
{
if (ModelState.IsValid)
{
db.SysDepartments.Add(sysDepartment);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(sysDepartment));
}
public void Department()
{
SysDepartment dep = new SysDepartment();
dep.CreateDate = dep.ModifiedDate = DateTime.Now;
dep.DepartmentDescription = "";
dep.DepartmentName = "softEngine";
dep.OrderBy = 1;
dep.ParentId = 0;
dep.Status = Convert.ToByte(new Random().Next(10));
Session.Save(dep);
}
public ActionResult Edit(string id, SysDepartment entity)
{
if (entity != null && ModelState.IsValid)
{ //数据校验
string currentPerson = GetCurrentPerson();
entity.UpdateTime = DateTime.Now;
entity.UpdatePerson = currentPerson;
string returnValue = string.Empty;
if (m_BLL.Edit(ref validationErrors, entity))
{
LogClassModels.WriteServiceLog(Suggestion.UpdateSucceed + "，部门信息的Id为" + id,"部门"
);//写入日志
return Json(Suggestion.UpdateSucceed); //提示更新成功
}
else
{
if (validationErrors != null && validationErrors.Count > 0)
{
validationErrors.All(a =>
{
returnValue += a.ErrorMessage;
return true;
});
}
LogClassModels.WriteServiceLog(Suggestion.UpdateFail + "，部门信息的Id为" + id + "," + returnValue, "部门"
);//写入日志
return Json(Suggestion.UpdateFail + returnValue); //提示更新失败
}
}
return Json(Suggestion.UpdateFail + "请核对输入的数据的格式"); //提示输入的数据的格式不对
}
public void AddToSysDepartment(SysDepartment sysDepartment)
{
base.AddObject("SysDepartment", sysDepartment);
}
public static SysDepartment CreateSysDepartment(int id)
{
SysDepartment sysDepartment = new SysDepartment();
sysDepartment.ID = id;
return sysDepartment;
}
