/// <summary> /// 删除抄送人员 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDelActorCopy_ServerClick(object sender, System.EventArgs e) { try { Procedure procedure = (Procedure)Session["Procedure"]; Task task = (Task)Session["Task"]; task.RemoveTaskActor(this.DelObjectCode.Value, false); DataSet ds = Rms.WorkFlow.DefinitionManager.SaveProcedureDefinitionData(procedure); UltraWebGrid UWGridCopyCase = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(1).FindControl("UltraWebGrid3")); UWGridCopyCase.DataSource = new DataView(ds.Tables["WorkFlowTaskActor"], String.Format("TaskCode='{0}' and TaskActorID='1'", task.TaskCode), "IOrder", DataViewRowState.CurrentRows); UWGridCopyCase.DataBind(); for (int i = 0; i < UWGridCopyCase.Rows.Count; i++) { if ((string)UWGridCopyCase.Rows[i].Cells[6].Value == "1") { UWGridCopyCase.Rows[i].Cells[4].Value = true; } else { UWGridCopyCase.Rows[i].Cells[4].Value = false; } UWGridCopyCase.Rows[i].Cells[7].Value = "<a href='javascript:deleteActor(\"" + (string)UWGridCopyCase.Rows[i].Cells[0].Value + "\",\"1\")'>删除</a>"; } Session["Procedure"] = procedure; } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); } }
/// <summary> /// 전략별 KPI 리스트 조회/ KPI 총가중치 조회 /// </summary> /// <param name="isSelectAll"></param> private void SetKpi(bool isSelectAll) { int intFindKpiID = (TtxtFindKpiID.Text == "") ? 0 : int.Parse(TtxtFindKpiID.Text); string strFindKpiNM = TtxtFindKpiNM.Text; MicroBSC.BSC.Biz.Biz_Bsc_Map_Kpi objKPI = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Kpi(); DataSet dsKPI = objKPI.GetKpiListPerStg(this.IEstTermRefID, this.IEstDeptRefID, this.IMapVersionID, int.Parse(this.ITreeSelValue)); TugrdKPIPerStg.Clear(); TugrdKPIPerStg.DataSource = dsKPI; TugrdKPIPerStg.DataBind(); TugrdKPIAll.Clear(); if (isSelectAll) { DataSet dsKPIAll = objKPI.GetAllKpiExceptDept(this.IEstTermRefID , this.IEstDeptRefID , this.IMapVersionID , intFindKpiID , strFindKpiNM , txtChampion.Text , txtMgmDept.Text); TugrdKPIAll.DataSource = dsKPIAll; TugrdKPIAll.DataBind(); } DataSet dsWeight = objKPI.GetWeightPerDept(this.IEstTermRefID, this.IEstDeptRefID, this.IYmd); if (dsWeight.Tables[0].Rows.Count > 0) { double dblWeight = double.Parse(dsWeight.Tables[0].Rows[0]["WEIGHT"].ToString()); TlblWeightTotal.ForeColor = (dblWeight != 100) ? Color.Red : Color.Blue; TlblWeightTotal.Text = Convert.ToString(Math.Round(dblWeight, 2, MidpointRounding.ToEven)); } }
private void GetKpiPoolQuestionList() { MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool_Question objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Kpi_Pool_Question(); DataSet rDs = objBSC.GetAllList(this.IKpiPoolRefID); TugrdQuestionItem.Clear(); TugrdQuestionItem.DataSource = rDs; TugrdQuestionItem.DataBind(); }
/// <summary> /// Do a Data Binding to the grid. /// </summary> public void DoDataBind() { TraceUWGC("UltraWebGridController::DoDataBind", ">>"); if (_lbActiveButton != "Save") { ObtainDataSet(); _grid.DataSource = _ds; _grid.DataMember = _ds.Tables[_component.MainTable].TableName; _grid.DataBind(); } TraceUWGC("UltraWebGridController::DoDataBind", "<<"); }
/// ******************************************************************************************* /// <summary> /// 加载路由数据 /// </summary> /// ******************************************************************************************* private void RouterGridDataBound() { Procedure procedure = (Procedure)Session["Procedure"]; DataSet procedureDS = Rms.WorkFlow.DefinitionManager.SaveProcedureDefinitionData(procedure); BLL.WorkFlowRule.FillRouterTaskName(procedureDS); UltraWebGrid UWGridCase2 = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(1).FindControl("UltraWebGrid2")); UWGridCase2.DataSource = new DataView(procedureDS.Tables["WorkFlowRouter"], "", "SortID", DataViewRowState.CurrentRows); UWGridCase2.DataBind(); for (int i = 0; i < UWGridCase2.Rows.Count; i++) { UWGridCase2.Rows[i].Cells[6].Value = "<a href='javascript:deleteRouter(" + (string)UWGridCase2.Rows[i].Cells[0].Value + ")'>删除</a>"; foreach (DataRow drw in procedureDS.Tables["WorkFlowCondition"].Select("RouterCode='" + UWGridCase2.Rows[i].Cells[0].Value + "'")) { UWGridCase2.Rows[i].Cells[5].Value = drw["Description"].ToString(); } } ValueList contactTypeFromTask = UWGridCase2.Columns[2].ValueList; ValueList contactTypeToTask = UWGridCase2.Columns[3].ValueList; System.Collections.IDictionaryEnumerator ie = procedure.GetTaskEnumerator(); DataTable dt = new DataTable(); dt.Columns.Add("TaskCode"); dt.Columns.Add("TaskName"); dt.Columns.Add("TaskID"); while (ie.MoveNext()) { Task task = (Task)ie.Value; DataRow drNew = dt.NewRow(); drNew["TaskCode"] = task.TaskCode; drNew["TaskName"] = task.TaskName; drNew["TaskID"] = task.TaskID; dt.Rows.Add(drNew); // contactTypeFromTask.ValueListItems.Add(task.TaskCode,task.TaskName); // contactTypeToTask.ValueListItems.Add(task.TaskCode,task.TaskName); } foreach (DataRow dr in dt.Select("", "TaskID", System.Data.DataViewRowState.CurrentRows)) { contactTypeFromTask.ValueListItems.Add(dr["TaskCode"].ToString(), dr["TaskName"].ToString()); contactTypeToTask.ValueListItems.Add(dr["TaskCode"].ToString(), dr["TaskName"].ToString()); } }
/// ******************************************************************************************* /// <summary> /// 加载数据帮定列表 /// </summary> /// ******************************************************************************************* private void LoadDataGrid() { Procedure procedure = (Procedure)Session["Procedure"]; UltraWebGrid UWGridCase3 = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(2).FindControl("UltraWebGrid3")); UltraWebGrid UWGridCase4 = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(3).FindControl("UltraWebGrid4")); DataGrid dgList1 = ((DataGrid)this.UltraWebTab1.Tabs.GetTab(1).FindControl("dgList")); DataSet procedureDS = Rms.WorkFlow.DefinitionManager.SaveProcedureDefinitionData(procedure); //任务帮定 TaskGridDataBound(); //路由帮定 RouterGridDataBound(); //角色帮定 UWGridCase3.DataSource = new DataView(procedureDS.Tables["WorkFlowRole"], "", "Remak", DataViewRowState.CurrentRows); UWGridCase3.DataBind(); for (int i = 0; i < UWGridCase3.Rows.Count; i++) { UWGridCase3.Rows[i].Cells[6].Value = "<a href='javascript:deleteRole(\"" + (string)UWGridCase3.Rows[i].Cells[0].Value + "\")'>删除</a>"; } RoleGridDataBound(); if (Request["Debug"] + "" == "1") { //属性帮定 UWGridCase4.DataSource = new DataView(procedureDS.Tables["WorkFlowProcedureProperty"], "", "Remak", DataViewRowState.CurrentRows); UWGridCase4.DataBind(); dgList1.DataSource = new DataView(procedureDS.Tables["WorkFlowProcedureProperty"], "", "", DataViewRowState.CurrentRows); dgList1.DataBind(); for (int i = 0; i < UWGridCase4.Rows.Count; i++) { UWGridCase4.Rows[i].Cells[4].Value = "<a href='javascript:deleteProperty(\"" + (string)UWGridCase4.Rows[i].Cells[0].Value + "\")'>删除</a>"; } this.RoleTypeBound(UWGridCase4.Columns[2].ValueList); this.UltraWebTab1.Tabs[3].Visible = true; } else { this.UltraWebTab1.Tabs[3].Visible = false; } procedureDS.Dispose(); }
/// <summary> /// 상위전략 리스트 /// </summary> private void SetParentStg() { MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg_Parent objBSC = new MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg_Parent(); DataSet dsStg = objBSC.GetParentStgList(this.IEstTermRefID, this.IEstDeptRefID, this.IMapVersionID, int.Parse(this.ITreeSelValue)); TugrdUpStgList.Clear(); TugrdUpStgList.DataSource = dsStg; TugrdUpStgList.DataBind(); DataSet dsAllStg = objBSC.GetDeptStgListExceptParentStg(this.IEstTermRefID, this.IEstDeptRefID, this.IMapVersionID, int.Parse(this.ITreeSelValue)); TugrdStgPerDept.Clear(); TugrdStgPerDept.DataSource = dsAllStg; TugrdStgPerDept.DataBind(); }
/// ******************************************************************************************* /// <summary> /// 加载任务数据 /// </summary> /// ******************************************************************************************* private void TaskGridDataBound() { Procedure procedure = (Procedure)Session["Procedure"]; UltraWebGrid UWGridCase1 = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(0).FindControl("UltraWebGrid1")); DataSet procedureDS = Rms.WorkFlow.DefinitionManager.SaveProcedureDefinitionData(procedure); BLL.WorkFlowRule.FillRouterTaskName(procedureDS); //任务帮定 UWGridCase1.DataSource = new DataView(procedureDS.Tables["WorkFlowTask"], "", "SortID,TaskID", DataViewRowState.CurrentRows); UWGridCase1.DataBind(); for (int i = 0; i < UWGridCase1.Rows.Count; i++) { UWGridCase1.Rows[i].Cells[1].Value = "<a href='#' onclick='javascript:modifyTask(" + (string)UWGridCase1.Rows[i].Cells[0].Value + ");return false;'>" + (string)UWGridCase1.Rows[i].Cells[1].Value + "</a>"; } ValueList contactTypeTaskType = UWGridCase1.Columns[3].ValueList; contactTypeTaskType.ValueListItems.Add(0, "一般节点"); contactTypeTaskType.ValueListItems.Add(1, "开始"); contactTypeTaskType.ValueListItems.Add(2, "结束"); contactTypeTaskType.ValueListItems.Add(3, "并流起点"); contactTypeTaskType.ValueListItems.Add(4, "并流交点"); contactTypeTaskType.ValueListItems.Add(5, "会签节点"); ValueList contactTypeRole = UWGridCase1.Columns[4].ValueList; RoleBound(contactTypeRole, procedure); ValueList contactTypeProperty = UWGridCase1.Columns[5].ValueList; PropertyBound(contactTypeProperty, procedure); ValueList contactTypeSelectPerson = UWGridCase1.Columns[6].ValueList; contactTypeSelectPerson.ValueListItems.Add("NoSelect", "不用选择"); contactTypeSelectPerson.ValueListItems.Add("SinglePerson", "人员单选"); contactTypeSelectPerson.ValueListItems.Add("MultiPerson", "人员多选"); contactTypeSelectPerson.ValueListItems.Add("UnLimited", "任意选择"); }
/// <summary> /// 删除角色 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDeleteRole_ServerClick(object sender, System.EventArgs e) { try { string RoleCode = this.DeleteObjectCode.Value; Procedure procedure = (Procedure)Session["Procedure"]; procedure.RemoveRole(RoleCode); Session["Procedure"] = procedure; //角色帮定 UltraWebGrid UWGridCase3 = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(2).FindControl("UltraWebGrid3")); DataSet procedureDS = Rms.WorkFlow.DefinitionManager.SaveProcedureDefinitionData(procedure); UWGridCase3.DataSource = new DataView(procedureDS.Tables["WorkFlowRole"], "", "", DataViewRowState.CurrentRows); UWGridCase3.DataBind(); for (int i = 0; i < UWGridCase3.Rows.Count; i++) { UWGridCase3.Rows[i].Cells[6].Value = "<a href='javascript:deleteRole(\"" + (string)UWGridCase3.Rows[i].Cells[0].Value + "\")'>删除</a>"; } RoleGridDataBound(); } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, "载入页面出错"); } }
private void SetPointsForGraph() { Biz_Bsc_Kpi_Qlt_Score_Had objBSC = new Biz_Bsc_Kpi_Qlt_Score_Had(); DataSet rDs = objBSC.GetKpiEstAdjustList (PageUtility.GetIntByValueDropDownList(ddlEstTermInfo) , PageUtility.GetByValueDropDownList(ddlMonthInfo) , 1 , PageUtility.GetIntByValueDropDownList(TddlEstGroup)); TugrdBias.Clear(); TugrdBias.DataSource = rDs; TugrdBias.DataBind(); if (rDs.Tables[0].Rows.Count > 0) { dblAvg = Convert.ToDouble(rDs.Tables[0].Rows[0]["ALL_AVG"].ToString()); dblStd = Convert.ToDouble(rDs.Tables[0].Rows[0]["ALL_STD"].ToString()); } DataSet rDsGraph = objBSC.GetEstEmpBiasGraphList (PageUtility.GetIntByValueDropDownList(ddlEstTermInfo) , PageUtility.GetByValueDropDownList(ddlMonthInfo) , 1 , PageUtility.GetIntByValueDropDownList(TddlEstGroup)); DundasCharts.DundasChartBase(TchartBias, ChartImageType.Flash, 800, 305 , BorderSkinStyle.Emboss, Color.FromArgb(181, 64, 1), 2 , Color.FromArgb(0xFF, 0xFF, 0xFE) , Color.FromArgb(0xFF, 0xFF, 0xFE), Color.FromArgb(0x20, 0x80, 0xD0), ChartDashStyle.Solid , -1 , ChartHatchStyle.None, GradientType.TopBottom, AntiAliasing.None); //TchartBias.ChartAreas["Default"].AxisY.Minimum = 40; Series serOriRng = DundasCharts.CreateSeries(TchartBias, "serOriRng", "Default", "원시점수구간", null, SeriesChartType.RangeColumn, 0, GetChartColor(0), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series serAvgRng = DundasCharts.CreateSeries(TchartBias, "serAvgRng", "Default", "평균점수구간", null, SeriesChartType.RangeColumn, 0, GetChartColor(1), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series serStdRng = DundasCharts.CreateSeries(TchartBias, "serStdRng", "Default", "평균.표준편차점수구간", null, SeriesChartType.RangeColumn, 0, GetChartColor(2), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 1, 9, Color.FromArgb(64, 64, 64)); Series serEmpAvg = DundasCharts.CreateSeries(TchartBias, "serEmpAvg", "Default", "평가자별평균점수", null, SeriesChartType.Line, 3, GetChartColor(3), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 0, 7, Color.FromArgb(64, 64, 64)); Series serAllAvg = DundasCharts.CreateSeries(TchartBias, "serAllAvg", "Default", "전체평균점수", null, SeriesChartType.Point, 1, GetChartColor(4), Color.FromArgb(0x4A, 0x58, 0x7E), Color.FromArgb(64, 0, 0, 0), 0, 7, Color.FromArgb(64, 64, 64)); string strEstEmp = ""; double dblEmpAvg = 0; double dblAllAvg = 0; double dblOriMin = 0; double dblOriMax = 0; double dblAvgMin = 0; double dblAvgMax = 0; double dblStdMin = 0; double dblStdMax = 0; int cntRow = rDsGraph.Tables[0].Rows.Count; for (int i = 0; i < cntRow; i++) { strEstEmp = rDsGraph.Tables[0].Rows[i]["EMP_NAME"].ToString(); dblEmpAvg = Convert.ToDouble(rDsGraph.Tables[0].Rows[i]["ORI_AVG_SCORE"].ToString()); dblAllAvg = Convert.ToDouble(rDsGraph.Tables[0].Rows[i]["ALL_AVG_SCORE"].ToString()); dblOriMin = Convert.ToDouble(rDsGraph.Tables[0].Rows[i]["ORI_MIN_SCORE"].ToString()); dblOriMax = Convert.ToDouble(rDsGraph.Tables[0].Rows[i]["ORI_MAX_SCORE"].ToString()); dblAvgMin = Convert.ToDouble(rDsGraph.Tables[0].Rows[i]["AVG_MIN_SCORE"].ToString()); dblAvgMax = Convert.ToDouble(rDsGraph.Tables[0].Rows[i]["AVG_MAX_SCORE"].ToString()); dblStdMin = Convert.ToDouble(rDsGraph.Tables[0].Rows[i]["STD_MIN_SCORE"].ToString()); dblStdMax = Convert.ToDouble(rDsGraph.Tables[0].Rows[i]["STD_MAX_SCORE"].ToString()); object[] objOri = new object[] { dblOriMax, dblOriMin }; object[] objAvg = new object[] { dblAvgMax, dblAvgMin }; object[] objStd = new object[] { dblStdMax, dblStdMin }; serEmpAvg.Points.AddXY(strEstEmp, dblEmpAvg); serAllAvg.Points.AddXY(strEstEmp, dblAllAvg); serOriRng.Points.AddXY(strEstEmp, objOri); serAvgRng.Points.AddXY(strEstEmp, objAvg); serStdRng.Points.AddXY(strEstEmp, objStd); } serEmpAvg.MarkerStyle = MarkerStyle.Diamond; serAllAvg.MarkerStyle = MarkerStyle.Triangle; serEmpAvg.ToolTip = "#VALY{N0}"; serAllAvg.ToolTip = "#VALY{N0}"; serOriRng.ToolTip = "#VALY{N0}"; serAvgRng.ToolTip = "#VALY{N0}"; serStdRng.ToolTip = "#VALY{N0}"; }
/// <summary> /// 数据绑定 /// </summary> /// <param name="grid"></param> /// <param name="datasource"></param> public static void SetGridData(UltraWebGrid grid, object datasource) { grid.DataSource = datasource;//数据源设定 grid.DataBind();//绑定 }
private void BindDaysType1(string deptid, string daytype, UltraWebGrid grid) { DataTable dt = bll.GetDaysType_1(deptid, daytype); grid.DataSource = dt; grid.DataBind(); }
/// **************************************************************************** /// <summary> /// 加载数据 /// </summary> /// **************************************************************************** private void LoadData() { Procedure procedure = (Procedure)Session["Procedure"]; string taskCode = Request["TaskCode"] + ""; if (taskCode == "") { this.btnDelete.Visible = false; Task task = Rms.WorkFlow.DefinitionManager.NewTask(); task.ProcedureCode = procedure.ProcedureCode; task.IsNew = true; Session["Task"] = task; return; } DataSet ds = Rms.WorkFlow.DefinitionManager.SaveProcedureDefinitionData(procedure); try { Task task = procedure.GetTask(taskCode); Session["Task"] = task; this.txtTaskName.Value = task.TaskName; this.txtTaskID.Value = task.TaskID; this.txtDescription.Value = task.Description; this.txtTaskTitle.Value = task.TaskTitle; this.sltTaskRole.Value = task.TaskRole; this.sltTaskProperty.Value = task.TaskProperty; this.sltTaskType.Value = task.TaskType.ToString(); this.chkTaskCopy.Checked = (task.Copy == 1); this.txtModuleState.Value = task.ModuleState; this.sltWayOfSelectPerson.Value = task.WayOfSelectPerson; this.ChkCanManual.Checked = (task.CanManual == 1); this.txtOpinionType.Value = task.OpinionType; ((HtmlSelect)this.UltraWebTab1.Tabs.GetTab(0).FindControl("sltMeetType")).Value = task.TaskMeetType; ((HtmlInputCheckBox)this.UltraWebTab1.Tabs.GetTab(0).FindControl("chkMeetOrder")).Checked = (task.IsOrderly == 1); ((HtmlInputControl)this.UltraWebTab1.Tabs.GetTab(1).FindControl("txtCopyTitle")).Value = task.TaskActorType; //是否等待初始化 ((HtmlInputCheckBox)this.UltraWebTab1.Tabs.GetTab(1).FindControl("chkWaitForCopy")).Checked = (task.CanEdit == 1); UltraWebGrid UWGridCase = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(0).FindControl("UltraWebGrid3")); UltraWebGrid UWGridCopyCase = ((UltraWebGrid)this.UltraWebTab1.Tabs.GetTab(1).FindControl("UltraWebGrid3")); UWGridCase.DataSource = new DataView(ds.Tables["WorkFlowTaskActor"], String.Format("TaskCode='{0}' and TaskActorID='0'", task.TaskCode), "IOrder", DataViewRowState.CurrentRows); UWGridCase.DataBind(); for (int i = 0; i < UWGridCase.Rows.Count; i++) { if ((string)UWGridCase.Rows[i].Cells[6].Value == "1") { UWGridCase.Rows[i].Cells[4].Value = true; } else { UWGridCase.Rows[i].Cells[4].Value = false; } if ((string)UWGridCase.Rows[i].Cells[11].Value == "1") { UWGridCase.Rows[i].Cells[7].Value = true; } else { UWGridCase.Rows[i].Cells[7].Value = false; } UWGridCase.Rows[i].Cells[10].Value = "<a href='javascript:deleteActor(\"" + (string)UWGridCase.Rows[i].Cells[0].Value + "\",\"0\")'>删除</a>"; } UWGridCopyCase.DataSource = new DataView(ds.Tables["WorkFlowTaskActor"], String.Format("TaskCode='{0}' and TaskActorID='1'", task.TaskCode), "IOrder", DataViewRowState.CurrentRows); UWGridCopyCase.DataBind(); for (int i = 0; i < UWGridCopyCase.Rows.Count; i++) { if ((string)UWGridCopyCase.Rows[i].Cells[6].Value == "1") { UWGridCopyCase.Rows[i].Cells[4].Value = true; } else { UWGridCopyCase.Rows[i].Cells[4].Value = false; } if ((string)UWGridCopyCase.Rows[i].Cells[9].Value == "1") { UWGridCopyCase.Rows[i].Cells[8].Value = true; } else { UWGridCopyCase.Rows[i].Cells[8].Value = false; } if ((int)UWGridCopyCase.Rows[i].Cells[11].Value == 1) { UWGridCopyCase.Rows[i].Cells[10].Value = true; } else { UWGridCopyCase.Rows[i].Cells[10].Value = false; } UWGridCopyCase.Rows[i].Cells[7].Value = "<a href='javascript:deleteActor(\"" + (string)UWGridCopyCase.Rows[i].Cells[0].Value + "\",\"1\")'>删除</a>"; } } catch (Exception ex) { ApplicationLog.WriteLog(this.ToString(), ex, ""); } ds.Dispose(); }