private void Frm我指派的任务预览_Load(object sender, EventArgs e) { this.searchLookUpEdit1.Properties.DataSource = EmpService.findAll(); List <String> empIds = this.customAppointment.Assignee; List <EmpDto> empDtos = EmpService.findByIds(empIds); List <String> empNames = new List <string>(); foreach (EmpDto empDto in empDtos) { empNames.Add(empDto.Name); } this.searchLookUpEdit1.EditValue = string.Join(",", empNames); // name this.searchLookUpEdit1.ToolTip = string.Join(",", empIds == null ? new List <String>() : empIds); // id var v = this.luValues.Find(b => b.FindText == this.searchLookUpEdit1.Properties.View.FindFilterText); if (v == null) { v = new LookUpMultSelectValues(); v.FindText = this.searchLookUpEdit1.Properties.View.FindFilterText; v.SelectedValues = new List <string>(); v.SelectedDisplays = new List <string>(); this.luValues.Add(v); } }
public ActionResult Edit(FormCollection form) { EmpService service = new EmpService(); Employee emp = new Employee(); var result = false; emp.EmpId = form["EmpId"]; emp.EmpName = form["EmpName"]; emp.Ext = form["Ext"]; emp.DepId = form["DepId"]; emp.Birthday = Convert.ToDateTime(form["Birthday"]); emp.ID = string.IsNullOrEmpty(form["ID"]) ? 0 : Convert.ToInt64(form["ID"]); try { if (emp.ID > 0) { result = service.EditEmployee(emp); } else { result = service.AddNewEmployee(emp); } } catch (Exception ex) { //可以處理要給前端的錯誤訊息/紀錄錯誤log throw ex; } return(RedirectToAction("Inquiry", "Emp")); //return View(); }
public ActionResult Index(string returnUrl) { //logger.Trace("進入首頁"); EmpService empService = new EmpService(); return(View(empService.Get())); }
/// <summary> /// 通过任务信息初始化任务预览 /// </summary> /// <param name="customAppointment"></param> /// <param name="empId"></param> /// <param name="isOwner">是否负责人</param> public Frm我指派的任务预览(Frm任务S frm, CustomAppointment customAppointment, String delegateId) { InitializeComponent(); this.customAppointment = customAppointment; this.delegateId = delegateId; // 补充参与者信息 CustomAppointmentService.buildAssignee(customAppointment); CustomAppointmentService.taskRead(customAppointment); this.frm = frm; this.frm.RefrashGridcontrol(); this.initViewData(); // 初始化视图的值 this.getTaskAchievement(); this.getTaskWorkIntensity(); // 工作强度 // 任务分解一览 this.treeListTask.DataSource = CustomAppointmentService.getAllById(customAppointment.TaskId); this.gridControl2.DataSource = this.GetDataTable(); // 业务委托人 //显示的数据 this.comboBoxDelegate.DisplayMember = "Name"; //name为类A的字段名 //隐藏的数据(对于多个数据,可以用逗号隔开。例:id,name) this.comboBoxDelegate.ValueMember = "Id"; //id为类A的字段名(对于隐藏对个数据,把数据放到一个字段用逗号隔开) this.comboBoxDelegate.DataSource = EmpService.findAll(); }
public EmployeeInfoDto Get() { var user = AuthService.GetCurrentUser(this.User).Result; var emp = EmpService.GetEmployeeWithCalculation(user.Id); return(Mapper.Map <EmployeeInfoDto>(emp)); }
private void simpleButton1_Click(object sender, EventArgs e) { if (this.isModified) // 修改 { DBUtil.ExecuteSQL("UPDATE project_plan SET plan_name ='" + this.jihuamingcheng.Text + "',start_time ='" + this.kaishishijian.Text + "' , end_time = '" + this.jieshushijian.Text + "' , emp_id = '" + EmpService.findEmpIdByName(this.empDtos, this.combo负责人.Text) + "' WHERE id = '" + planId + "'"); } else { String uuid = System.Guid.NewGuid().ToString("N"); //string str = this.dateEdit1.Text; //string str1 = this.dateEdit2.Text; DBUtil.ExecuteSQL("INSERT INTO project_plan(id,plan_name,start_time,end_time,emp_id) " + " VALUES ('" + uuid + "','" + this.jihuamingcheng.Text + "','" + this.kaishishijian.Text + "','" + this.jieshushijian.Text + "','" + EmpService.findEmpIdByName(this.empDtos, this.combo负责人.Text) + "')"); } this.frmbiao.refreshPlan(); this.Close(); }
/// <summary> /// 修改 /// </summary> /// <param name="id"></param> public Frm修改(Frm目录 frmbiao, String id) { this.initComponent(frmbiao); this.planId = id; this.initedit(); this.isModified = true; this.empDtos = EmpService.findAll(); }
public void TestFindByName() { var empService = new EmpService(); var employees = empService.FindByName("Sh"); foreach (var emp in employees) { Console.WriteLine(String.Format("{0}, {1}", emp.Emp_Id, emp.Name)); } }
public async Task <ActionResult> DeleteEmp(int id) { CustomModel.ResultModel customModel = new CustomModel.ResultModel() { Message = "刪除失敗" }; EmpService empService = new EmpService(); EMPLOYEE emp = empService.FindOne(id); var user = await UserManager.FindByNameAsync(emp.empaccount); var logins = user.Logins; var rolesForUser = await UserManager.GetRolesAsync(user.Id); var appDbContext = HttpContext.GetOwinContext().Get <ApplicationDbContext>(); using (var transaction = appDbContext.Database.BeginTransaction()) { try { foreach (var login in logins.ToList()) { await UserManager.RemoveLoginAsync(login.UserId, new UserLoginInfo(login.LoginProvider, login.ProviderKey)); } if (rolesForUser.Count() > 0) { foreach (var item in rolesForUser.ToList()) { // item should be the name of the role var result = await UserManager.RemoveFromRoleAsync(user.Id, item); } } await UserManager.DeleteAsync(user); empService.Delete(id); transaction.Commit(); customModel.Success = true; customModel.Message = "刪除成功"; return(Json(customModel)); } catch (DbEntityValidationException ex) { logger.Error(GetEntityErrorMsg(ex)); } catch (Exception ex) { logger.Error(ex.Message); transaction.Rollback(); } return(Json(customModel)); } }
private List <EmpDto> empDtos = new List <EmpDto>(); // 员工列表 /// <summary> /// 新增 /// </summary> /// <param name="frmbiao"></param> public Frm修改(Frm目录 frmbiao) { this.initComponent(frmbiao); this.isModified = false; this.empDtos = EmpService.findAll(); for (int i = 0; i < this.empDtos.Count; i++) { this.combo负责人.Properties.Items.Add(empDtos[i].Name.ToString()); // TODO } }
public void Shoul_Return_EmployeeList() { //Arrange //Act var List = EmpService.FetchEmployeeList(); //Assert Assert.Equal(10, List.Count); }
public ActionResult Delete(Emp model) { var result = EmpService.DeleteUser(model.No); if (result.Result == "1") { return(RedirectToAction("Index")); } return(View()); }
public ActionResult Edit(Emp model) { var result = EmpService.UpdateUser(model); if (result.Result == "1") { return(RedirectToAction("Index")); } return(View()); }
/// <summary> /// 废弃 /// </summary> /// <param name="frm"></param> public Frm新建申报(Frm目录 frm) { InitializeComponent(); this.form = frm; this.empDtos = EmpService.findAll(); for (int i = 0; i < this.empDtos.Count; i++) { this.combo负责人.Properties.Items.Add(empDtos[i].Name.ToString()); // TODO this.combo参与者.Properties.Items.Add(empDtos[i].Name.ToString()); // TODO } }
public ActionResult Delete(string no) { var result = EmpService.GetUser(no); if (result.Result == "1") { var model = result.ReturnList; return(View(model)); } return(View()); }
// GET: Emp public ActionResult Index() { var result = EmpService.GetAllEmp(); if (result.Result == "1") { var model = result.ReturnList; return(View(model)); } return(View()); }
public ActionResult Create(Emp model) { var result = EmpService.InsertUser(model); if (result.Result == "1") { TempData["AlertMessage"] = result.Message; return(RedirectToAction("Index")); } ViewData["ReturnMsg"] = result.Message; return(View(model)); }
public Frm新建申报(String taskId, String taskTemplateId) { InitializeComponent(); this.taskId = taskId; this.taskTemplateId = taskTemplateId; this.empDtos = EmpService.findAll(); for (int i = 0; i < this.empDtos.Count; i++) { this.combo负责人.Properties.Items.Add(empDtos[i].Name.ToString()); // TODO this.combo参与者.Properties.Items.Add(empDtos[i].Name.ToString()); // TODO } this.treeList1.ExpandAll(); }
public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } EmpService empService = new EmpService(); EMPLOYEE emp = empService.FindOne(id); var viewModel = empService.GetEditModel(emp); return(View(viewModel)); }
public async Task <ActionResult> Edit(EmpEditModel model) { if (!ModelState.IsValid) { return(View(model)); } else { //var user = UserManager.FindById(User.Identity.GetUserId()); EmpService empService = new EmpService(); EMPLOYEE emp = empService.FindOne(model.empno); var user = await UserManager.FindByNameAsync(emp.empaccount); user.Email = model.EMPEMAIL; user.PhoneNumber = model.emptel; if (!string.IsNullOrWhiteSpace(model.Newpwd)) { user.PasswordHash = UserManager.PasswordHasher.HashPassword(model.Newpwd); model.emppwd = user.PasswordHash; } using (var scope = new TransactionScope(TransactionScopeAsyncFlowOption.Enabled)) { try { var result = await UserManager.UpdateAsync(user); if (result.Succeeded) { empService.Update(model); scope.Complete(); return(RedirectToAction("Index", "Home", new { area = "Admin" })); } } catch (DbEntityValidationException ex) { logger.Error(GetEntityErrorMsg(ex)); } catch (Exception ex) { logger.Error(ex.Message); scope.Dispose(); } } } return(View(model)); }
public async Task <IActionResult> Grabar(string nombre , long salario , int edad , string perfil) { EmployeeBO employee = new EmployeeBO(); employee.edad = edad; employee.salario = salario; employee.nombre = nombre; employee.perfil = perfil; EmployeeBO emp = await EmpService.Insertar(employee); return(RedirectToAction("Index")); }
public void TestInsert() { Employee emp = new Employee { Emp_Id = 1001, Name = "Stone", Gender = "Male", Email = "*****@*****.**", Phone_Number = "138", City = "WUHAN" }; var empService = new EmpService(); int rv = empService.Insert(emp); Console.WriteLine(rv); }
public void TestUpdate() { Employee emp = new Employee { Emp_Id = 1001, Name = "Stone", Gender = "Male", Email = "*****@*****.**", Phone_Number = "138", City = "WUHAN" }; var empService = new EmpService(); int rv = empService.Update(emp); Assert.AreEqual(rv, 1); }
/// <summary> /// 根据部门取出上下级关系,构建部门和负责人kv /// </summary> /// <param name="departments"></param> private void generateCustomResource(List <String> departments) { Dictionary <String, List <EmpDto> > keyValuePairs = new Dictionary <String, List <EmpDto> >(); foreach (String department in departments) { keyValuePairs.Add( department , EmpService.findByDepartment(department) ); } // 部门和员工kv int i = 0; List <Color> Colors = new ResouceColorUtil().Colors; // 资源颜色工具类 foreach (string department in keyValuePairs.Keys) { foreach (EmpDto empDto in keyValuePairs[department]) { // 员工 if (this.departmentAndCustomResource.ContainsKey(department)) { // 更新 Boolean conflict = false; // id重复 foreach (CustomResource customResource in this.departmentAndCustomResource[department]) { if (empDto.Id.Equals(customResource.ResID)) { conflict = true; break; // 去重 } } if (!conflict) { this.departmentAndCustomResource[department].Add(new CustomResource(empDto.Id, empDto.Name, Colors[++i])); } } else { // 新增 BindingList <CustomResource> customResources = new BindingList <CustomResource>(); customResources.Add(new CustomResource(empDto.Id, empDto.Name, Colors[++i])); this.departmentAndCustomResource.Add(department, customResources); } } } }
private void button1_Click(object sender, EventArgs e) { try { EmpService.findByEmpNoAndPassword(textBox1.Text, textBox2.Text); //if ((textBox1.Text.ToString() == "abc") || (textBox2.Text.ToString() == "abc")) { //MessageBox.Show("登录成功"); this.Hide(); new Frm任务S(EmpService.findEmpIdByJobnum(textBox1.Text), this).Show(); //new Frm主界面(EmpService.findEmpIdByJobnum(textBox1.Text)).Show(); } } catch { MessageBox.Show("工号或密码错误"); } }
/** * 页面数据加载 */ public ActionResult getEmpList(String eid, String ename, String rid, String did) { Emp empQuery = new Emp(); empQuery.Eid = eid; empQuery.Ename = ename; if (rid != null && !rid.Equals("")) { empQuery.Rid = int.Parse(rid); } if (did != null && !did.Equals("")) { empQuery.Did = int.Parse(did); } EmpService empService = new EmpService(); List <Emp> list = empService.SelectEmps(empQuery); return(Json(list)); }
/// <summary> /// 刪除員工資料 /// </summary> /// <param name="id"></param> /// <returns></returns> public ActionResult Delete(int id) { EmpService service = new EmpService(); var result = false; try { if (id > 0) { result = service.RemoveEmployee(id); } } catch (Exception ex) { throw ex; } return(RedirectToAction("Inquiry", "Emp")); }
public Frm新建任务(Frm任务S form) { InitializeComponent(); this.form = form; this.owner_id = form.owner_id; RefrashGridcontrol(); this.chineseLocale(); // 选择任务模板的事件 this.repositoryItemComboBox1.SelectedIndexChanged += TaskTemplateSelectedIndexChanged; //显示的数据 this.comboBoxEmp.DisplayMember = "Name"; //name为类A的字段名 //隐藏的数据(对于多个数据,可以用逗号隔开。例:id,name) this.comboBoxEmp.ValueMember = "Id"; //id为类A的字段名(对于隐藏对个数据,把数据放到一个字段用逗号隔开) List <String> emps = new List <string>(); emps.Add(this.owner_id); this.comboBoxEmp.DataSource = EmpService.findByIds(emps); // 当没有选择模板 this.nextTaskTemplates = TaskTemplateService.getByFrontTaskTemplateId(this.parentTaskTemplateId); this.barTaskTemp.Enabled = true; if (this.nextTaskTemplates.Count > 0) { foreach (NextTaskTemplate nextTaskTemplate in this.nextTaskTemplates) { this.repositoryItemComboBox1.Items.Add(nextTaskTemplate.TaskTemplateName); } //this.barTaskTemplate.EditValue = this.nextTaskTemplates[0].TaskTemplateName; } // 初始化任务model this.appointmentModel = new AppointmentModel(); this.appointmentModel.build难度(1); /// 参与者 this.searchLookUpEdit1.EditValue = ""; // name this.searchLookUpEdit1.ToolTip = ""; // id }
private void Frm新建任务_Load(object sender, EventArgs e) { // 日期 this.edtStartDate.Text = DateTime.Now.ToShortDateString(); this.edtEndDate.Text = DateTime.Now.ToShortDateString(); // 参与者 this.searchLookUpEdit1.Properties.DataSource = EmpService.findAll(); // 任务级别 this.repositoryItem任务级别.Items.Add("公司级任务"); this.repositoryItem任务级别.Items.Add("部门任务"); this.repositoryItem任务级别.Items.Add("业务组任务"); this.repositoryItem任务级别.Items.Add("个人任务"); // 业务委托人 //显示的数据 this.comboBoxDelegate.DisplayMember = "Name"; //name为类A的字段名 //隐藏的数据(对于多个数据,可以用逗号隔开。例:id,name) this.comboBoxDelegate.ValueMember = "Id"; //id为类A的字段名(对于隐藏对个数据,把数据放到一个字段用逗号隔开) this.comboBoxDelegate.DataSource = EmpService.findAll(); }
public void initedit() { this.kaishishijian.Properties.DisplayFormat.FormatString = "yyyy-MM-dd HH:mm"; this.kaishishijian.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime; this.kaishishijian.Properties.EditFormat.FormatString = "yyyy-MM-dd HH:mm"; this.kaishishijian.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.DateTime; this.kaishishijian.Properties.Mask.EditMask = "yyyy-MM-dd HH:mm"; this.jieshushijian.Properties.DisplayFormat.FormatString = "yyyy-MM-dd HH:mm"; this.jieshushijian.Properties.DisplayFormat.FormatType = DevExpress.Utils.FormatType.DateTime; this.jieshushijian.Properties.EditFormat.FormatString = "yyyy-MM-dd HH:mm"; this.jieshushijian.Properties.EditFormat.FormatType = DevExpress.Utils.FormatType.DateTime; this.jieshushijian.Properties.Mask.EditMask = "yyyy-MM-dd HH:mm"; // sql改DTO this.dt = DBUtil.ExecuteDataTable("SELECT * FROM project_plan WHERE id = '" + planId + "'"); this.jihuamingcheng.Text = dt.Rows[0]["plan_name"].ToString(); this.kaishishijian.Text = dt.Rows[0]["start_time"].ToString(); this.jieshushijian.Text = dt.Rows[0]["end_time"].ToString(); this.combo负责人.Text = EmpService.findEmpNameById(this.empDtos, dt.Rows[0]["emp_id"].ToString()); }