/// <summary> /// BTApply对象转为数据库对象 /// </summary> /// <param name="flag">标志,1为添加,2为修改需要复制修改人信息</param> /// <returns>T_HR_BusinessTrip数据库对象</returns> public T_HR_BusinessTrip ToDB(int flag) { T_HR_BusinessTrip bt = new T_HR_BusinessTrip(); bt.ID = ID; bt.StaffID = StaffID; bt.BTPlace = BTPlace; bt.StartTime = StartTime; bt.EndTime = EndTime; bt.TimeSpan = TimeSpan; bt.BTReason = BTReason; bt.Valid = Valid; bt.Remark = Remark; bt.CreaterName = CreaterName; bt.CreateTime = CreateTime; bt.OperationListID = OperationListID; if (flag != 1) { bt.EditorName = EditorName; bt.EditeTime = EditeTime; } bt.LastID = LastID; bt.BTEdit = BTEdit; bt.BTDelete = BTDelete; bt.EditOrDelete = EditOrDelete; return(bt); }
public ActionResult BRSubmit(BTApply businesstrip) { DirectResult r = new DirectResult(); string orid = businesstrip.ID; var prelists = from o in entities.T_HR_BusinessTrip where o.BTDelete == true && o.LastID == orid select o; foreach (T_HR_BusinessTrip item in prelists) { T_HR_BusinessTrip prelist = entities.T_HR_BusinessTrip.Find(item.ID); prelist.BTDelete = false; } T_HR_BusinessTrip orlist = entities.T_HR_BusinessTrip.Find(orid); orlist.BTDelete = true; orlist.EditOrDelete = "Delete"; businesstrip.ID = Guid.NewGuid().ToString(); businesstrip.OperationListID = Guid.NewGuid().ToString(); businesstrip.Valid = false; businesstrip.CreaterName = new LoginUser().EmployeeId; businesstrip.CreateTime = DateTime.Now; businesstrip.BTEdit = false; businesstrip.BTDelete = true; businesstrip.EditOrDelete = ""; businesstrip.LastID = orid; T_CH_Operation_list newList = new T_CH_Operation_list(); newList.ID = businesstrip.OperationListID; newList.State = (int)CheckState.Checking;//审核中 newList.Check_flowID = businesstrip.CheckFlowId; newList.Check_funcID = businesstrip.FuncId; newList.CreateTime = DateTime.Now; newList.Creator = new LoginUser().EmployeeId; newList.Url = Url.Action("CheckBusinessTrip", "BusinessTrip", new { id = businesstrip.ID }); entities.T_HR_BusinessTrip.Add(businesstrip.ToDB(1)); entities.T_CH_Operation_list.Add(newList); try { entities.SaveChanges(); r.Success = true; X.Msg.Alert("提示", "保存成功!", new JFunction { Fn = "closewindow" }).Show(); } catch (Exception e) { X.Msg.Alert("警告", "数据保存失败!<br /> note:" + e.Message, new JFunction { Fn = "closewindow" }).Show(); r.Success = false; } return(r); }
public bool GetPreState(string id) { T_HR_BusinessTrip last = entities.T_HR_BusinessTrip.Find(id); bool flag = true; string opid; if (Convert.ToBoolean(last.BTEdit)) { var pre = (from o in entities.T_HR_BusinessTrip where o.LastID == id && o.BTEdit == true select o).ToList(); if (pre.Any()) { opid = pre.First().OperationListID; var list = from o in entities.T_CH_Operation_list where o.ID == opid select o; if (list.Any()) { if (list.First().State == 1) { flag = false; } } } } if (Convert.ToBoolean(last.BTDelete)) { var pre = (from o in entities.T_HR_BusinessTrip where o.LastID == id && o.BTDelete == true select o).ToList(); if (pre.Any()) { opid = pre.First().OperationListID; var list = from o in entities.T_CH_Operation_list where o.ID == opid select o; if (list.Any()) { if (list.First().State == 1) { flag = false; } } } } return(flag); }
public ActionResult BESubmit(BTApply businesstrip) { try { businesstrip.StartTime = Convert.ToDateTime(businesstrip.StartTimeStr);//计算TimeSpan businesstrip.EndTime = Convert.ToDateTime(businesstrip.EndTimeStr); } catch (FormatException fe) { X.Msg.Alert("警告", "日期不正确,请检查!").Show(); return(this.Direct()); } if (businesstrip.StartTime.Year == businesstrip.EndTime.Year && businesstrip.StartTime.Month == businesstrip.EndTime.Month && businesstrip.StartTime <= businesstrip.EndTime) { DirectResult r = new DirectResult(); string orid = businesstrip.ID; var prelists = from o in entities.T_HR_BusinessTrip where o.BTEdit == true && o.LastID == orid select o; foreach (T_HR_BusinessTrip item in prelists) { T_HR_BusinessTrip prelist = entities.T_HR_BusinessTrip.Find(item.ID); prelist.BTEdit = false; } T_HR_BusinessTrip orlist = entities.T_HR_BusinessTrip.Find(orid); orlist.BTEdit = true; orlist.EditOrDelete = "Edit"; businesstrip.ID = Guid.NewGuid().ToString(); businesstrip.OperationListID = Guid.NewGuid().ToString(); businesstrip.Valid = false; businesstrip.CreaterName = new LoginUser().EmployeeId; businesstrip.CreateTime = DateTime.Now; businesstrip.BTEdit = true; businesstrip.BTDelete = false; businesstrip.EditOrDelete = ""; businesstrip.LastID = orid; //businesstrip.TimeSpan = GetTimeSpan(businesstrip.StartTime, businesstrip.EndTime); //businesstrip.TiaoxiuHours = GetTH(businesstrip.StartTime, businesstrip.EndTime); T_CH_Operation_list newList = new T_CH_Operation_list(); newList.ID = businesstrip.OperationListID; newList.State = (int)CheckState.Checking;//审核中 newList.Check_flowID = businesstrip.CheckFlowId; newList.Check_funcID = businesstrip.FuncId; newList.CreateTime = DateTime.Now; newList.Creator = new LoginUser().EmployeeId; newList.Url = Url.Action("CheckBusinessTrip", "BusinessTrip", new { id = businesstrip.ID }); entities.T_HR_BusinessTrip.Add(businesstrip.ToDB(1)); entities.T_CH_Operation_list.Add(newList); try { entities.SaveChanges(); r.Success = true; X.Msg.Alert("提示", "保存成功!", new JFunction { Fn = "closewindow" }).Show(); } catch (Exception e) { X.Msg.Alert("警告", "数据保存失败!<br /> note:" + e.Message, new JFunction { Fn = "closewindow" }).Show(); r.Success = false; } return(r); } else { X.Msg.Alert("警告", "请假不可跨月!").Show(); return(this.Direct()); } }
public ActionResult AddOrEditBusinessTrip(BTApply businesstrip) { try { businesstrip.StartTime = Convert.ToDateTime(businesstrip.StartTimeStr);//计算TimeSpan businesstrip.EndTime = Convert.ToDateTime(businesstrip.EndTimeStr); } catch (FormatException fe) { X.Msg.Alert("警告", "日期不正确,请检查!").Show(); return(this.Direct()); } if (businesstrip.StartTime.Year == businesstrip.EndTime.Year && businesstrip.StartTime.Month == businesstrip.EndTime.Month && businesstrip.StartTime <= businesstrip.EndTime) { DirectResult r = new DirectResult(); T_HR_BusinessTrip businesstripupdate = entities.T_HR_BusinessTrip.Find(businesstrip.ID); if (businesstripupdate == null)//为空为添加 { //businesstrip.StartTime = Convert.ToDateTime(businesstrip.StartTimeStr);//计算TimeSpan //businesstrip.EndTime = Convert.ToDateTime(businesstrip.EndTimeStr); businesstrip.ID = Guid.NewGuid().ToString(); businesstrip.OperationListID = Guid.NewGuid().ToString(); businesstrip.Valid = true; businesstrip.CreaterName = new LoginUser().EmployeeId; businesstrip.CreateTime = DateTime.Now; businesstrip.BTEdit = false; businesstrip.BTDelete = false; //businesstrip.TimeSpan = GetTimeSpan(businesstrip.StartTime, businesstrip.EndTime); T_CH_Operation_list newList = new T_CH_Operation_list(); newList.ID = businesstrip.OperationListID; newList.State = (int)CheckState.Checking;//审核中 newList.Check_flowID = businesstrip.CheckFlowId; newList.Check_funcID = businesstrip.FuncId; newList.CreateTime = DateTime.Now; newList.Creator = new LoginUser().EmployeeId; newList.Url = Url.Action("CheckBusinessTrip", "BusinessTrip", new { id = businesstrip.ID }); entities.T_HR_BusinessTrip.Add(businesstrip.ToDB(1)); entities.T_CH_Operation_list.Add(newList); try { entities.SaveChanges(); r.Success = true; X.Msg.Alert("提示", "保存成功!", new JFunction { Fn = "closewindow" }).Show(); } catch (Exception e) { X.Msg.Alert("警告", "数据保存失败!<br /> note:" + e.Message, new JFunction { Fn = "closewindow" }).Show(); r.Success = false; } } else//否则为修改 { //businesstrip.StartTime = Convert.ToDateTime(businesstrip.StartTimeStr);//计算TimeSpan //businesstrip.EndTime = Convert.ToDateTime(businesstrip.EndTimeStr); businesstrip.EditorName = new LoginUser().EmployeeId; businesstrip.EditeTime = DateTime.Now; businesstripupdate.Valid = false; businesstrip.ID = Guid.NewGuid().ToString(); businesstrip.OperationListID = Guid.NewGuid().ToString(); businesstrip.Valid = true; businesstrip.BTEdit = false; businesstrip.BTDelete = false; //businesstrip.TimeSpan = GetTimeSpan(businesstrip.StartTime, businesstrip.EndTime); T_CH_Operation_list newList = new T_CH_Operation_list(); newList.ID = businesstrip.OperationListID; newList.State = (int)CheckState.Checking;//审核中 newList.Check_flowID = businesstrip.CheckFlowId; newList.Check_funcID = businesstrip.FuncId; newList.CreateTime = DateTime.Now; newList.Creator = new LoginUser().EmployeeId; newList.Url = Url.Action("CheckBusinessTrip", "BusinessTrip", new { id = businesstrip.ID }); entities.T_HR_BusinessTrip.Add(businesstrip.ToDB(2)); entities.T_CH_Operation_list.Add(newList); try { entities.SaveChanges(); r.Success = true; X.Msg.Alert("提示", "修改成功!", new JFunction { Fn = "closewindow" }).Show(); } catch (Exception e) { X.Msg.Alert("警告", "数据保存失败!<br /> note:" + e.Message, new JFunction { Fn = "closewindow" }).Show(); r.Success = false; } } return(r); } else { X.Msg.Alert("警告", "出差申请不可跨月!").Show(); return(this.Direct()); } }