//-------------------------------------------------------------方法 #region "行政線" private void LoadOrgType() { var isSuccess = false; var msg = ""; var datas = new List <OrganListModel>(); var viewData = new PunchConfirmModel() { CompID = UserInfo.getUserInfo().CompID, EmpID = UserInfo.getUserInfo().UserID, }; isSuccess = PunchLogInqForOrgan.SelectOrganForAll(viewData, out datas, out msg); if (isSuccess && datas != null && datas.Count > 0) { _AllowOrgan = datas; ddlOrgType.DataSource = datas.Select(x => new { x.OrgType, x.OrgTypeName }).Distinct().ToList(); ddlOrgType.DataTextField = "OrgTypeName"; ddlOrgType.DataValueField = "OrgType"; ddlOrgType.DataBind(); ddlOrgType.Items.Insert(0, new ListItem("----請選擇----", "")); } else { _AllowOrgan = new List <OrganListModel>(); resetDDL(ddlOrgType); resetDDL(ddlDeptID); resetDDL(ddlOrganID); } }
private void LoadRoleCode40() { var isSuccess = false; var msg = ""; var datas = new List <FlowOrganListModel>(); var viewData = new PunchConfirmModel() { CompID = UserInfo.getUserInfo().CompID, EmpID = UserInfo.getUserInfo().UserID, }; isSuccess = PunchLogInqForOrgan.SelectFlowOrganForAll(viewData, out datas, out msg); if (isSuccess && datas != null && datas.Count > 0) { _AllowFlowOrgan = datas; _AllowFlowOrganView = datas; ddlRoleCode40.DataSource = datas.Where(x => x.RoleCode == "40").Select(x => new { x.OrganID, x.OrganName }).Distinct().ToList(); ddlRoleCode40.DataTextField = "OrganName"; ddlRoleCode40.DataValueField = "OrganID"; ddlRoleCode40.DataBind(); ddlRoleCode40.Items.Insert(0, new ListItem("----請選擇----", "")); } else { _AllowFlowOrgan = new List <FlowOrganListModel>(); resetDDL(ddlRoleCode40); resetDDL(ddlRoleCode30); resetDDL(ddlRoleCode20); resetDDL(ddlRoleCode10); } }
//-------------------------------------------------------------主要邏輯區 /// <summary> /// 查詢邏輯 /// </summary> private void DoQuery() { var isSuccess = false; var msg = ""; var orgType = StringIIF(ddlOrganization.SelectedValue); var searchType = StringIIF(ddlSearchType.SelectedValue); var datas = new List <PunchConfirmBean>(); var viewData = new PunchConfirmModel(); viewData.CompID = StringIIF(UserInfo.getUserInfo().CompID); viewData.OrganID = StringIIF(GetOrganWhere()); viewData.FlowOrganID = StringIIF(GetFlowOrganWhere()); viewData.PunchSDate = StringIIF(ucStartDate.ucSelectedDate); viewData.PunchEDate = StringIIF(ucEndDate.ucSelectedDate); viewData.PunchSTime = StringIIF(StartTimeH.SelectedValue + ":" + StartTimeM.SelectedValue); viewData.PunchETime = StringIIF(EndTimeH.SelectedValue + ":" + EndTimeM.SelectedValue); viewData.ConfirmPunchFlag = StringIIF(ddlConfirmPunchFlag.SelectedValue); viewData.ConfirmStatus = StringIIF(ddlConfirmStatus.SelectedValue); viewData.Remedy_AbnormalFlag = StringIIF(ddlRemedy_AbnormalFlag.SelectedValue); viewData.EmpID = StringIIF(txtEmpID.Text); viewData.EmpName = StringIIF(txtEmpName.Text); isSuccess = PunchLogInqForOrgan.SelectPunchConfirmForAll(viewData, orgType, searchType, out datas, out msg); if (isSuccess && datas != null && datas.Count > 0) { viewData.SelectGridDataList = PunchLogInqForOrgan.GridDataFormat(datas); //Format Data } gvMain.DataSource = viewData.SelectGridDataList; gvMain.DataBind(); }
/// <summary> /// 查詢人員資料 /// </summary> private void QueryEmpInfo(string txtEmp) { var isSuccess = false; var msg = ""; var datas = new PunchConfirmBean(); var viewData = new PunchConfirmModel() { CompID = UserInfo.getUserInfo().CompID, EmpID = txtEmp }; isSuccess = PunchLogInqForOrgan.SelectPerson(viewData, out datas, out msg); if (isSuccess && datas != null) { txtEmpID.Text = datas.EmpID; lblEmpID.Text = datas.EmpNameN; } }