public string SaveDepartmentData(DeptViewModel objDeptView)
{
try
{
Department objEnDept = new Department();
if (objDeptView != null)
{
objEnDept.DeptName = objDeptView.DeptName;
if (objDeptView.DeptId == 0)
{
empDb.Entry(objEnDept).State = EntityState.Added;
}
else
{
objEnDept.DeptId = objDeptView.DeptId;
empDb.Entry(objEnDept).State = EntityState.Modified;
empDb.Entry(objEnDept).Property(x => x.IsDelete).IsModified = false;
}
empDb.SaveChanges();
return("SavedSuccessfully");
}
else
{
return("SomethingWrong");
}
}
catch (Exception ex)
{
throw ex;
}
}
//***************************************************
//부서 및 학과 업데이트 result 1 이상 성공 0 실패
//***************************************************
public int UpdateDept(DeptViewModel data, string admin)
{
string sql = "update SASU_DEPT set dept_name = @name, datasys1 = now(),datasys2 = 'U',datasys3=@admin where DEPT_id = @id";
int result = 0;
try
{
connectionOpen();
cmd = new MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@name", data.DeptName);
cmd.Parameters.AddWithValue("@admin", admin);
cmd.Parameters.AddWithValue("@id", data.DeptId);
Console.WriteLine(cmd.CommandText);
result = cmd.ExecuteNonQuery();
Console.WriteLine("-------------성공");
}
catch (Exception e)
{
Console.WriteLine(e.ToString());
Console.WriteLine("-------------a-a");
result = 0;
}
finally
{
cmd = null;
conn.Close();
}
return(result);
}
//***************************************************
//관리자 정보 삭제
//***************************************************
#endregion
#region 부서 및 학과
//***************************************************
//부서 및 학과 생성 result 1 이상 성공 0 실패
//***************************************************
public int InsertDept(DeptViewModel data, string admin)
{
string sql = "insert into SASU_DEPT values(@id,@name,now(),'A',@admin)";
int result = 0;
try
{
connectionOpen();
cmd = new MySqlCommand(sql, conn);
cmd.Parameters.AddWithValue("@id", data.DeptId);
cmd.Parameters.AddWithValue("@name", data.DeptName);
cmd.Parameters.AddWithValue("@admin", admin);
result = cmd.ExecuteNonQuery();
} catch (Exception e)
{
Console.WriteLine(e.ToString());
result = 0;
}
finally
{
cmd = null;
conn.Close();
}
return(result);
}
public static List <DeptViewModel> getActivedDepts()
{
List <DeptViewModel> dtDept = new List <DeptViewModel>();
DeptAccess access = new DeptAccess();
DataTable dtResult = access.GetActivedDepartments();
foreach (DataRow dtr in dtResult.Rows)
{
DeptViewModel item = new DeptViewModel
{
DEPTCODE = dtr["DEPTCODE"].ToString(),
DEPTNAME = dtr["DEPTNAME"].ToString(),
DEPTPARENT = dtr["DEPTPARENT"].ToString(),
DEPTLEVEL = dtr["DEPTLEVEL"].ToString(),
ORDERINDEX = dtr["ORDERINDEX"].ToString(),
ISACTIVE = dtr["ISACTIVE"].ToString(),
REMARK = dtr["REMARK"].ToString(),
DEPTCODEOLD = dtr["DEPTCODEOLD"].ToString(),
COMPCODE = dtr["COMPCODE"].ToString(),
CREATE_UID = dtr["CREATE_UID"].ToString(),
CREATE_DT = dtr["CREATE_DT"].ToString(),
UPDATE_UID = dtr["UPDATE_UID"].ToString(),
UPDATE_DT = dtr["UPDATE_DT"].ToString()
};
dtDept.Add(item);
}
return(dtDept);
}
/// <summary>
/// 修改部门，若失败返回false
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool Edit(DeptViewModel model)
{
bool result = false;
var modelDept = model.Department;
try
{
var dept = context.Departments.Find(modelDept.Id);
if (modelDept.DeptCode != dept.DeptCode)
{
var depts = context.Departments.FirstOrDefault(dept => dept.DeptCode == modelDept.DeptCode);
if (depts != null)
{
return(result);
}
dept.DeptCode = modelDept.DeptCode;
}
dept.Subordinate = modelDept.Subordinate.Split(',')[0].Trim(',');
dept.DeptName = modelDept.DeptName;
dept.Description = modelDept.Description;
context.Departments.Update(dept);
context.SaveChanges();
logger.LogWarning("修改部门信息{LogType}{CustomProperty}", "Operate", JsonConvert.SerializeObject(modelDept));
result = true;
return(result);
}
catch (Exception ex)
{
logger.LogError("修改部门信息失败{LogType}{CustomProperty}", "Operate", JsonConvert.SerializeObject(modelDept));
throw ex;
}
}
public ActionResult Index()
{
var dvm = new DeptViewModel();
dvm.DNames = empService.GetNames();
return(View(dvm));
}
public ActionResult Edit(int id)
{
department dept = _deptRep.GetModelById(id);
DeptViewModel viewModel = new DeptViewModel();
Mapper.Map(dept, viewModel);
return(View(viewModel));
}
public IActionResult Create(DeptViewModel model)
{
if (ModelState.IsValid)
{
deptManager.Create(model);
}
return(RedirectToAction(nameof(Index)));
}
public ActionResult EditSave(DeptViewModel deptViewModel)
{
ResultModel result = new ResultModel();
department dept = _deptRep.GetModelById(deptViewModel.Id);
Mapper.Map(deptViewModel, dept);
result.IsSuccess = _deptRep.Update(dept) > 0;
return(Json(result));
}
public ActionResult AddNew(DeptViewModel deptViewModel)
{
ResultModel result = new ResultModel();
department dept = new department();
Mapper.Map(deptViewModel, dept);
result.IsSuccess = _deptRep.Add(dept) > 0;
return(Json(result));
}
public DeptViewModel Index(Department errorModel = null)
{
var model = new DeptViewModel();
model.Departments = Departments.ToList();
GetSubordinates(model);
logger.LogWarning("读取部门信息{LogType}", "Operate");
return(model);
}
/// <summary>
/// 赋值VM中部门list
/// </summary>
/// <param name="model">部门的ViewModel</param>
private static void GetSubordinates(DeptViewModel model)
{
var deptcodes = model.Departments.Select(dept => new { dept.DeptCode, dept.DeptName });
model.Subordinates.Add("0,顶层部门");
foreach (var deptcode in deptcodes)
{
model.Subordinates.Add($"{deptcode.DeptCode},{deptcode.DeptName}");
}
}
public IActionResult Edit(DeptViewModel model)
{
var result = deptManager.Edit(model);
if (!result)
{
return(RedirectToAction(nameof(Index), model.Department));
}
return(RedirectToAction(nameof(Index)));
}
public IActionResult Index()
{
var dEntity = _DepartmentRepo.GetAll();
var dvm = new DeptViewModel
{
Dept = dEntity
};
ViewBag.Dept = dvm;
return(View());
}
public void EditShouldBe_OK()
{
var model = new DeptViewModel();
model.Department.Id = 20;
model.Department.DeptCode = "112";
model.Department.DeptName = "测试部";
model.Department.Subordinate = "404,技术部";
model.Department.Description = "测试部门";
bool result = deptManager.Edit(model);
Assert.True(result);
}
public async Task <IActionResult> Index()
{
ViewData["Title"] = $"{_appSettings.Value.AppTitle}-{Subtitle.DepartmentList}";
var NoOfRowsSelItemLst = ExternalUtility.GetNoOfSelectItemList(_appSettings.Value.NoOfRowsOptions, _appSettings.Value.DefaultOptionRowSel);
var deptVM = new DeptViewModel()
{
Department1 = "",
SelState = _appSettings.Value.DefaultSelState,
States = await _stateSerice.GetStateSelectList(),
NoOfRows = NoOfRowsSelItemLst
};
return(View(deptVM));
}
protected override void OnStartup(StartupEventArgs e)
{
base.OnStartup(e);
Window win = new MainWindow();
Window win2 = new DetailsWindow();
DeptModel DM = new DeptModel();
DeptViewModel dmw = new DeptViewModel(DM);
win.DataContext = dmw;
win2.DataContext = dmw;
win.Show();
win2.Show();
}
public DataTable InsertDepartments(DeptViewModel deptViewModel)
{
OracleParameter[] param = new OracleParameter[9];
param[0] = new OracleParameter("pDEPTCODE", (object)deptViewModel.DEPTCODE ?? DBNull.Value);
param[1] = new OracleParameter("pDEPTNAME", (object)deptViewModel.DEPTNAME ?? DBNull.Value);
param[2] = new OracleParameter("pDEPTPARENT", (object)deptViewModel.DEPTPARENT ?? DBNull.Value);
param[3] = new OracleParameter("pDEPTLEVEL", (object)deptViewModel.DEPTLEVEL ?? DBNull.Value);
param[4] = new OracleParameter("pORDERINDEX", (object)deptViewModel.ORDERINDEX ?? DBNull.Value);
param[5] = new OracleParameter("pISACTIVE", (object)deptViewModel.ISACTIVE ?? DBNull.Value);
param[6] = new OracleParameter("pREMARK", (object)deptViewModel.REMARK ?? DBNull.Value);
param[7] = new OracleParameter("pCREATE_UID", (object)deptViewModel.CREATE_UID ?? DBNull.Value);
param[8] = new OracleParameter("pUPDATE_UID", (object)deptViewModel.UPDATE_UID ?? DBNull.Value);
return(DBHelper.getDataTable_SP("HR_DEPARTMENT.SP_INSERT_NEW_T_HR_DEPT", param));
}
public ActionResult Dept()
{
var vm = new DeptViewModel();
vm.Department = new DeptRepository().GetAll();
vm.DeptList = new List <SelectListItem>();
vm.Department.ForEach(x => vm.DeptList.Add(new SelectListItem()
{
Text = x.Name,
Value = x.Id.ToString()
}));
var m = new DeptRepository().GetAllDeptWithSubDept();
return(View(vm));
}
public async Task <IActionResult> QueryFAQ()
{
QueryFaqExtdViewModel faqVM = new QueryFaqExtdViewModel();
faqVM.FAQVMList = null;
List <DeptViewModel> depts = await api.PopulateDeptDropDown();
DeptViewModel dvm = new DeptViewModel();
dvm.DeptId = 0;
dvm.DeptName = "Select Department";
depts.Insert(0, dvm);
ViewData["DeptId"] = new SelectList(depts, "DeptId", "DeptName", dvm.DeptName);
return(View(faqVM));
}
public static DeptViewModel Recursive(DeptViewModel dept, List <DeptViewModel> deptList)
{
if (deptList.Where(c => c.DEPTPARENT == dept.DEPTCODE).Count() < 1)
{
return(dept);
}
else
{
List <DeptViewModel> newList = new List <DeptViewModel>();
foreach (DeptViewModel ca in deptList.Where(c => c.DEPTPARENT == dept.DEPTCODE))
{
newList.Add(Recursive(ca, deptList));
}
dept.DeptViewModels = newList;
return(dept);
}
}
public IHttpActionResult Put(DeptViewModel dept)
{
if (!ModelState.IsValid)
{
return(BadRequest("Not a valid model"));
}
using (var ctx = new EMSEntities())
{
try
{
var existingDept = ctx.DEPTs.Where(s => s.TRNNO == dept.TRNNO)
.FirstOrDefault <DEPT>();
if (existingDept != null)
{
existingDept.ABR = dept.ABR;
existingDept.DESCRIP = dept.DESCRIP;
existingDept.STATUS = dept.STATUS;
ctx.SaveChanges();
}
else
{
return(NotFound());
}
}
catch (DbEntityValidationException e)
{
foreach (var eve in e.EntityValidationErrors)
{
Console.WriteLine("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State);
foreach (var ve in eve.ValidationErrors)
{
Console.WriteLine("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage);
}
}
throw;
}
}
return(Ok());
}
//*********************************************
// 체크 버튼 클릭
//*********************************************
private void CheckButton_Click(object sender, RoutedEventArgs e)
{
DeptViewModel Data = (DeptViewModel)DeptInfo.DataContext;
//입력
if (Btn_state == 0)
{
DeptViewModel Temp = new DeptViewModel
{
DeptCode = "A",
DeptId = Data.DeptId,
DeptName = Data.DeptName,
DeptCreateAt = Data.DeptCreateAt
};
myViewModel.Insert(myViewModel.Count, Temp);
sql.InsertDept(Temp, AdminId);
}
//수정
if (Btn_state == 1)
{
//데이터가 변경된 경우
Console.WriteLine("----------------------");
Console.WriteLine(Data.DeptId);
Console.WriteLine(Data.DeptName);
if (selectArray[1] != Data.DeptName)
{
//입력 구분값 변경
if (Data.DeptCode == "S")
{
Data.DeptCode = "U";
}
Console.WriteLine(sql.UpdateDept(Data, AdminId));
}
Console.WriteLine("----------------------");
}
if (Btn_state == 2)
{
sql.DeleteDept(Data);
}
//바인딩 해제
DefaultState();
sql.SelectDept(myViewModel, string.Empty);
selectArray = new string[2];
resetText();
}
public void Create(DeptViewModel model)
{
var dept = model.Department;
try
{
dept.Subordinate = dept.Subordinate.Split(',')[0].Trim(',');
dept.DeptCode = model.ConfirmDeptCode;
context.Departments.Add(dept);
context.SaveChanges();
logger.LogWarning("添加部门{LogType}{CustomProperty}", "Operate", JsonConvert.SerializeObject(dept));
}
catch (Exception ex)
{
logger.LogWarning("添加部门失败{LogType}{CustomProperty}", "Operate", JsonConvert.SerializeObject(dept));
throw ex;
}
}
public HttpResponseMessage SaveDeptData(DeptViewModel objDeptView)
{
try
{
if (objDeptView != null)
{
return(Request.CreateErrorResponse(HttpStatusCode.OK, _departmentService.SaveDepartmentData(objDeptView)));
}
else
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Not Saved"));
}
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message));
}
}
public DataTable UpdateDepartments(DeptViewModel deptViewModel)
{
OracleParameter[] param = new OracleParameter[10];
param[0] = new OracleParameter("pDEPTCODE", (object)deptViewModel.DEPTCODE ?? DBNull.Value);
param[1] = new OracleParameter("pDEPTNAME", (object)deptViewModel.DEPTNAME ?? DBNull.Value);
param[2] = new OracleParameter("pDEPTPARENT", (object)deptViewModel.DEPTPARENT ?? DBNull.Value);
param[3] = new OracleParameter("pDEPTLEVEL", (object)deptViewModel.DEPTLEVEL ?? DBNull.Value);
param[4] = new OracleParameter("pORDERINDEX", (object)deptViewModel.ORDERINDEX ?? DBNull.Value);
param[5] = new OracleParameter("pISACTIVE", (object)deptViewModel.ISACTIVE ?? DBNull.Value);
param[6] = new OracleParameter("pREMARK", (object)deptViewModel.REMARK ?? DBNull.Value);
param[7] = new OracleParameter("pDEPTCODEOLD", (object)deptViewModel.DEPTCODEOLD ?? DBNull.Value);
//param[8] = new OracleParameter("pCOMPCODE", (object)deptViewModel.COMPCODE ?? DBNull.Value);
param[8] = new OracleParameter("pUPDATE_UID", (object)deptViewModel.UPDATE_UID ?? DBNull.Value);
param[9] = new OracleParameter("T_TABLE", OracleDbType.RefCursor)
{
Direction = ParameterDirection.Output
};
return(DBHelper.getDataTable_SP("HR_DEPARTMENT.SP_UPDATE_T_HR_DEPT", param));
}
public IActionResult OnGet(int? id)
{
DepartmentVM = new DeptViewModel()
{
Faculty = _facultyRepo.GetFacultyListOfDropDown(),
Department = new Department()
};
if (id != null)
{
var deptFromDb = _deptRepo.GetFisrtOrDefault(m => m.Id == id);
if (deptFromDb == null)
{
return NotFound();
}
DepartmentVM.Department = deptFromDb;
}
return Page();
}
public async Task <JsonResult> UpdateDepartment(DeptViewModel deptViewModel)
{
try
{
if (!ModelState.IsValid)
{
string message = "Please enter required data.";
TempData.Put("notify", new StatusResult()
{
Status = StatusText.Error.ToString(), StatusDetail = message
});
ModelState.AddModelError("", message);
return(Json(new { datas = "", tcount = 0, rcount = 0, status = "Error", message = "Error" }));
}
else
{
var dept = new Department()
{
Id = 0,
DeptBelongsTo = deptViewModel.SelState,
Deptartment = deptViewModel.Department1,
CreatedBy = _session.GetString("UserId"),
CreationDate = DateTime.Now
};
var result = await _deptService.SaveNewDepartment(dept);
if (result.Status == StatusText.Successful.ToString())
{
return(Json(new { datas = "", tcount = 0, rcount = 0, status = "Successful", message = result.StatusDetail }));
}
else
{
return(Json(new { datas = "", tcount = 0, rcount = 0, status = "Error", message = result.StatusDetail }));
}
}
}
catch (Exception ex)
{
Log.Logger.Error(ex.Message);
return(Json(new { datas = "", status = "Error", error = ex.Message }));
}
}
public IHttpActionResult PostNewBp(DeptViewModel dept)
{
if (!ModelState.IsValid)
{
return(BadRequest("Invalid data."));
}
using (var ctx = new EMSEntities())
{
int totalConunt = ctx.DEPTs.Count <DEPT>();
dept.TRNNO = totalConunt + 1;
ctx.DEPTs.Add(new DEPT()
{
TRNNO = (dept.TRNNO),
ABR = dept.ABR,
DESCRIP = dept.DESCRIP,
STATUS = dept.STATUS
});
try
{
ctx.SaveChanges();
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
}
}
return(Ok());
}
public ActionResult UpdateGeoOrganization(string deptCode, string deptParent, string deptName, bool active, string orderIndex)
{
DeptViewModel geoOrganization = new DeptViewModel();
geoOrganization.DEPTCODE = deptCode;
geoOrganization.DEPTPARENT = deptParent;
geoOrganization.DEPTNAME = deptName;
geoOrganization.DEPTLEVEL = deptCode.Substring(0, 1);
if (active)
{
geoOrganization.ISACTIVE = "1";
}
else
{
geoOrganization.ISACTIVE = "0";
}
geoOrganization.ORDERINDEX = orderIndex;
bDept.UpdateGeoOrganization(geoOrganization);
Session["geoorganization_tree"] = bDept.getDepts();
Session["geoorganizationreport_tree"] = bGeoReport.getTreeGeoDepts();
return(PartialView("GeoOrganizationInforPartial"));
}
