/// <summary> /// 根据主键删除班组信息 /// </summary> /// <param name="teamGroupId"></param> public static void DeleteTeamGroupById(string teamGroupId) { Model.SUBHSSEDB db = Funs.DB; Model.ProjectData_TeamGroup teamGroup = db.ProjectData_TeamGroup.FirstOrDefault(e => e.TeamGroupId == teamGroupId); if (teamGroup != null) { db.ProjectData_TeamGroup.DeleteOnSubmit(teamGroup); db.SubmitChanges(); } }
/// <summary> /// 修改班组信息 /// </summary> /// <param name="teamGroup"></param> public static void UpdateTeamGroup(Model.ProjectData_TeamGroup teamGroup) { Model.SUBHSSEDB db = Funs.DB; Model.ProjectData_TeamGroup newTeamGroup = db.ProjectData_TeamGroup.FirstOrDefault(e => e.TeamGroupId == teamGroup.TeamGroupId); if (newTeamGroup != null) { newTeamGroup.ProjectId = teamGroup.ProjectId; newTeamGroup.UnitId = teamGroup.UnitId; newTeamGroup.TeamGroupCode = teamGroup.TeamGroupCode; newTeamGroup.TeamGroupName = teamGroup.TeamGroupName; newTeamGroup.GroupLeaderId = teamGroup.GroupLeaderId; newTeamGroup.Remark = teamGroup.Remark; db.SubmitChanges(); } }
/// <summary> /// 添加班组信息 /// </summary> /// <param name="teamGroup"></param> public static void AddTeamGroup(Model.ProjectData_TeamGroup teamGroup) { Model.SUBHSSEDB db = Funs.DB; Model.ProjectData_TeamGroup newTeamGroup = new Model.ProjectData_TeamGroup { TeamGroupId = teamGroup.TeamGroupId, ProjectId = teamGroup.ProjectId, UnitId = teamGroup.UnitId, TeamGroupCode = teamGroup.TeamGroupCode, TeamGroupName = teamGroup.TeamGroupName, Remark = teamGroup.Remark, GroupLeaderId = teamGroup.GroupLeaderId }; db.ProjectData_TeamGroup.InsertOnSubmit(newTeamGroup); db.SubmitChanges(); }
/// <summary> /// 获取受检单位/班组 /// </summary> /// <param name="WorkStage"></param> /// <returns></returns> protected string ConvertUnitOrTeamGroup(object CheckDayId) { string name = string.Empty; if (CheckDayId != null) { Model.Check_CheckDayXA checkDay = BLL.Check_CheckDayXAService.GetCheckDayByCheckDayId(CheckDayId.ToString()); if (checkDay != null) { if (!string.IsNullOrEmpty(checkDay.DutyUnitIds)) { string[] unitIds = checkDay.DutyUnitIds.Split(','); foreach (var item in unitIds) { Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(item); name += unit.UnitName + ","; } if (!string.IsNullOrEmpty(name)) { name = name.Substring(0, name.LastIndexOf(",")); } } if (!string.IsNullOrEmpty(checkDay.DutyTeamGroupIds)) { string[] teamGroupIds = checkDay.DutyTeamGroupIds.Split(','); foreach (var item in teamGroupIds) { Model.ProjectData_TeamGroup unit = BLL.TeamGroupService.GetTeamGroupById(item); name += unit.TeamGroupName + ","; } if (!string.IsNullOrEmpty(name)) { name = name.Substring(0, name.LastIndexOf(",")); } } } } return(name); }
/// <summary> /// 加载页面 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { hdAttachUrl.Text = string.Empty; hdId.Text = string.Empty; this.btnClose.OnClientClick = ActiveWindow.GetHideReference(); this.ProjectId = this.CurrUser.LoginProjectId; this.CheckDayId = Request.Params["CheckDayId"]; var checkDay = BLL.Check_CheckDayXAService.GetCheckDayByCheckDayId(this.CheckDayId); if (checkDay != null) { this.ProjectId = checkDay.ProjectId; this.txtCheckDayCode.Text = BLL.CodeRecordsService.ReturnCodeByDataId(this.CheckDayId); if (checkDay.CheckDate != null) { this.txtCheckDate.Text = string.Format("{0:yyyy-MM-dd}", checkDay.CheckDate); } Model.Sys_User checkMan = BLL.UserService.GetUserByUserId(checkDay.CompileMan); if (checkMan != null) { this.txtCheckMan.Text = checkMan.UserName; } if (checkDay.NotOKNum != null) { this.txtNotOKNum.Text = checkDay.NotOKNum.ToString(); } if (BLL.ProjectUnitService.GetProjectUnitTypeByProjectIdUnitId(this.ProjectId, checkDay.CompileUnit)) //施工单位 { this.trTeamGroup.Hidden = false; if (!string.IsNullOrEmpty(checkDay.DutyTeamGroupIds)) { string names = string.Empty; string[] ids = checkDay.DutyTeamGroupIds.Split(','); foreach (var item in ids) { Model.ProjectData_TeamGroup teamGroup = BLL.TeamGroupService.GetTeamGroupById(item); if (teamGroup != null) { names += teamGroup.TeamGroupName + ","; } } if (!string.IsNullOrEmpty(names)) { names = names.Substring(0, names.LastIndexOf(",")); } this.drpDutyTeamGroupIds.Text = names; } } else { this.trUnit.Hidden = false; if (!string.IsNullOrEmpty(checkDay.DutyUnitIds)) { string names = string.Empty; string[] ids = checkDay.DutyUnitIds.Split(','); foreach (var item in ids) { Model.Base_Unit unit = BLL.UnitService.GetUnitByUnitId(item); if (unit != null) { names += unit.UnitName + ","; } } if (!string.IsNullOrEmpty(names)) { names = names.Substring(0, names.LastIndexOf(",")); } this.drpDutyUnitIds.Text = names; } } if (!string.IsNullOrEmpty(checkDay.WorkAreaIds)) { string names = string.Empty; string[] ids = checkDay.WorkAreaIds.Split(','); foreach (var item in ids) { Model.ProjectData_WorkArea workArea = BLL.WorkAreaService.GetWorkAreaByWorkAreaId(item); if (workArea != null) { names += workArea.WorkAreaName + ","; } } if (!string.IsNullOrEmpty(names)) { names = names.Substring(0, names.LastIndexOf(",")); } this.drpWorkAreaIds.Text = names; } this.txtUnqualified.Text = checkDay.Unqualified; this.txtHandleStation.Text = checkDay.HandleStation; if (checkDay.IsOK == true) { this.txtIsOK.Text = "是"; } else { this.txtIsOK.Text = "否"; } } } }