protected void Prj_Est_Point_Bind()
{
DataTable dt = bizPrjData.Get_Prj_Data_List(PRJ_REF_ID, COMP_ID, EST_ID, ESTTERM_REF_ID, ESTTERM_SUB_ID, ESTTERM_STEP_ID);
DataTable dtPrjInfo = DataTypeUtility.FilterSortDataTable(dt, "TGT_DEPT_ID=-1 AND TGT_EMP_ID=-1");
object point = dtPrjInfo.Rows[0]["POINT"];
string Result = Math.Round(DataTypeUtility.GetToDouble(point), 1).ToString();
this.lblPrjEstPoint.Text = Result;
}
protected void ibnSave_Click(object sender, ImageClickEventArgs e)
{
UltraGridRow row;
Biz_DeptOpinionTgtEmps deptOpinionTgtEmp = new Biz_DeptOpinionTgtEmps();
DataTable dataTable = deptOpinionTgtEmp.GetDataTableSchema();
for (int i = 0; i < UltraWebGrid1.Rows.Count; i++)
{
row = UltraWebGrid1.Rows[i];
TemplatedColumn hdf_col = (TemplatedColumn)row.Band.Columns.FromKey("CTRL_EMP");
HiddenField hdfTgtEmpID = (HiddenField)((CellItem)hdf_col.CellItems[row.BandIndex]).FindControl("hdfTgtEmpID");
TemplatedColumn txt_col = (TemplatedColumn)row.Band.Columns.FromKey("CTRL_EMP");
TextBox txtTgtEmpName = (TextBox)((CellItem)txt_col.CellItems[row.BandIndex]).FindControl("txtTgtEmpName");
if (hdfTgtEmpID.Value.Equals(""))
{
row.Cells.FromKey("TGT_EMP_ID").Value = DBNull.Value;
}
else
{
row.Cells.FromKey("TGT_EMP_ID").Value = DataTypeUtility.GetToDouble(hdfTgtEmpID.Value);
}
}
dataTable = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid1
, new string[] { "TGT_DEPT_ID", "TGT_EMP_ID" }
, dataTable);
dataTable = DataTypeUtility.FilterSortDataTable(dataTable, "TGT_EMP_ID IS NOT NULL");
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["COMP_ID"] = COMP_ID;
dataRow["EST_ID"] = EST_ID;
dataRow["TGT_OPINION_YN"] = "Y";
dataRow["DATE"] = DateTime.Now;
dataRow["USER"] = EMP_REF_ID;
}
bool isOK = deptOpinionTgtEmp.SaveDeptOpinionTgtEmp(dataTable, COMP_ID, EST_ID);
if (isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 의견상신 담당자를 설정하였습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("처리 중 오류가 발생하였습니다.");
}
}
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.AlternatingItem || e.Item.ItemType == ListItemType.Item)
{
groupNumber = 0; // 정의별합산점수초기화
noneSelectCount = 0;
DataRowView dr = (DataRowView)e.Item.DataItem;
string q_dfn_id = DataTypeUtility.GetString(dr["Q_DFN_ID"]);
Biz_QuestionDefines questionDefines = new Biz_QuestionDefines(q_dfn_id, "");
Literal ltrDefName = e.Item.FindControl("ltrLevelDefName") as Literal;
Literal ltrDefine = e.Item.FindControl("ltrLevelDefine") as Literal;
DataList dalList = e.Item.FindControl("DataList3") as DataList;
Label lblText1 = e.Item.FindControl("lblAvgSumText") as Label;
Label lblText2 = e.Item.FindControl("lblAvgText") as Label;
lblValue1 = e.Item.FindControl("lblAvgSumValue") as Label;
lblValue2 = e.Item.FindControl("lblAvgValue") as Label;
ltrDefName.Text = questionDefines.Q_Dfn_Name;
ltrDefine.Text = questionDefines.Q_Dfn_Define;
lblText1.Text = lblName1;
lblText2.Text = lblName2;
Biz_QuestionSubjects questionSubjects = new Biz_QuestionSubjects();
DataSet ds = questionSubjects.GetQuestionSubject("", Q_OBJ_ID, q_dfn_id);
dalList.DataSource = ds;
dalList.DataBind();
double tmpSum = 0;
double tmpSumAvg = 0;
if (SUBJECT_ITEM_YN == "1")
{
lblText1.Text = "";
lblText2.Text = "환산점수";
lblValue2.Text = txtValueText;
}
else
{
tmpSum = Math.Round(((groupNumber * 100) / (5 * ds.Tables[0].Rows.Count)), 1);
tmpSumAvg = Math.Round(((((groupNumber * 100) / (5 * ds.Tables[0].Rows.Count)) * ds.Tables[0].Rows.Count) / (ds.Tables[0].Rows.Count - noneSelectCount)), 1);
lblValue1.Text = Convert.ToString(tmpSum);
lblValue2.Text = Convert.ToString(tmpSumAvg);
}
TOTALPOINT += DataTypeUtility.GetToDouble(lblValue2.Text);
}
}
private void DataListBinding_P()
{
if (_tgt_pos_biz_use_yn.Equals("N"))
{
Biz_QuestionObjects questionObjects = new Biz_QuestionObjects(EST_ID, Q_OBJ_ID);
Q_OBJ_NAME = questionObjects.Q_Obj_Name;
}
else
{
Q_OBJ_NAME = "직무평가";
}
Biz_QuestionSubjects questionSubjects = new Biz_QuestionSubjects();
DataTable dtSubject = null;
if (_tgt_pos_biz_use_yn.Equals("N"))
{
dtSubject = questionSubjects.GetQuestionSubject("", Q_OBJ_ID, "").Tables[0];
double weight_total = DataTypeUtility.GetToDouble(dtSubject.Compute("SUM(WEIGHT)", "1 = 1"));
for (int i = 1; i <= dtSubject.Rows.Count; i++)
{
dtSubject.Rows[i - 1]["WEIGHT"] = DataTypeUtility.GetToDouble(dtSubject.Rows[i - 1]["WEIGHT"]) / weight_total * 100;
}
}
else
{
dtSubject = questionSubjects.GetQuestionSubject(COMP_ID, EST_ID, TGT_EMP_ID, "").Tables[0];
double weight_total = DataTypeUtility.GetToDouble(dtSubject.Compute("SUM(WEIGHT)", "1 = 1"));
for (int i = 1; i <= dtSubject.Rows.Count; i++)
{
dtSubject.Rows[i - 1]["NUM"] = i;
dtSubject.Rows[i - 1]["WEIGHT"] = DataTypeUtility.GetToDouble(dtSubject.Rows[i - 1]["WEIGHT"]) / weight_total * 100;
}
}
DataTable dt = DataTypeUtility.GetGroupByDataTable(dtSubject, new string[] { "Q_DFN_ID" });
string q_dfn_ids = DataTypeUtility.GetSplitString(dt, "Q_DFN_ID", ",");
if (!q_dfn_ids.Equals(""))
{
DefineDataBinding_P(q_dfn_ids);
}
NoDefineDataBinding_P(dtSubject);
}
protected void ibnUpdateEmpRole_Click(object sender, ImageClickEventArgs e)
{
UltraGridRow row;
Biz_EmpRoleRels empRoleRel = new Biz_EmpRoleRels();
Biz_DeptOpinionTgtEmps deptOpinionTgtEmp = new Biz_DeptOpinionTgtEmps();
DataTable dataTable = deptOpinionTgtEmp.GetDataTableSchema();
dataTable.Columns.Add("EMP_REF_ID", typeof(int));
dataTable.Columns.Add("ROLE_REF_ID", typeof(int));
for (int i = 0; i < UltraWebGrid1.Rows.Count; i++)
{
row = UltraWebGrid1.Rows[i];
TemplatedColumn hdf_col = (TemplatedColumn)row.Band.Columns.FromKey("CTRL_EMP");
HiddenField hdfTgtEmpID = (HiddenField)((CellItem)hdf_col.CellItems[row.BandIndex]).FindControl("hdfTgtEmpID");
if (hdfTgtEmpID.Value.Equals(""))
{
row.Cells.FromKey("TGT_EMP_ID").Value = DBNull.Value;
}
else
{
row.Cells.FromKey("TGT_EMP_ID").Value = DataTypeUtility.GetToDouble(hdfTgtEmpID.Value);
}
}
dataTable = UltraGridUtility.GetDataTableByAllValue(UltraWebGrid1
, new string[] { "TGT_EMP_ID" }
, dataTable);
dataTable = DataTypeUtility.FilterSortDataTable(dataTable, "TGT_EMP_ID IS NOT NULL");
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["EMP_REF_ID"] = dataRow["TGT_EMP_ID"];
dataRow["ROLE_REF_ID"] = ROLE_REF_ID;
}
bool isOK = empRoleRel.SaveEmpRoleRel(dataTable, ROLE_REF_ID);
if (isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 의견상신 담당자 권한을 부여하였습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("부여된 권한이 없습니다.");
}
}
protected bool setAverage_Point()
{
//데이터 수집
DataTable dt = getConfirmed_EstData();
int result = 0;
if (dt.Rows.Count > 0)
{
Biz_Est_Data bizEstData = new Biz_Est_Data();
DataTable dt_Bias_ratio = bizEstData.Get_Bias_AVG_Ratio_STD(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID);
//데이터 가공
for (int i = 0; i < dt.Rows.Count; i++)
{
string est_emp_id = DataTypeUtility.GetString(dt.Rows[i]["EST_EMP_ID"]);
string filter = string.Format("EST_EMP_ID={0}", est_emp_id);
DataTable dt_filtered_ratio = DataTypeUtility.FilterSortDataTable(dt_Bias_ratio, filter);
if (dt_filtered_ratio.Rows.Count > 0)
{
double avg_ratio = DataTypeUtility.GetToDouble(dt_filtered_ratio.Rows[0]["AVG_RATIO"]);
double point_org = DataTypeUtility.GetToDouble(dt.Rows[i]["POINT_ORG"]);
double point_avg = point_org * avg_ratio;
double point_ctrl_org = point_avg; //환산점수 계산용 점수
double point = point_ctrl_org * 100 / 5; //환산점수
dt.Rows[i]["POINT"] = Math.Round(point, 1);
dt.Rows[i]["POINT_AVG"] = Math.Round(point_avg, 1);
dt.Rows[i]["POINT_STD"] = -1;
dt.Rows[i]["POINT_CTRL_ORG"] = Math.Round(point_avg, 1);
dt.Rows[i]["STATUS_ID"] = "E";//확정
}
}
dt = Add_Date_User(dt);
result = bizEstData.ModifyEstData_Point(dt, gUserInfo.Emp_Ref_ID);
}
return(result > 0 ? true : false);
}
protected void ugrdKpiList_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
TemplatedColumn cCol = (TemplatedColumn)e.Row.Band.Columns.FromKey("USE_YN");
System.Web.UI.WebControls.Image objImg = (System.Web.UI.WebControls.Image)((CellItem)cCol.CellItems[e.Row.BandIndex]).FindControl("imgUseYn");
objImg.ImageUrl = (e.Row.Cells.FromKey("USE_YN").Value.ToString() == "Y") ?
"../images/icon_o.gif" : "../images/icon_x.gif";
cCol = (TemplatedColumn)e.Row.Band.Columns.FromKey("APP_STATUS");
objImg = (System.Web.UI.WebControls.Image)((CellItem)cCol.CellItems[e.Row.BandIndex]).FindControl("imgApp");
string strImg = (e.Row.Cells.FromKey("APP_STATUS").Value == null) ? "" : e.Row.Cells.FromKey("APP_STATUS").Value.ToString();
objImg.ImageUrl = Biz_Com_Approval_Info.GetAppImageUrl(strImg);
objImg.AlternateText = Biz_Com_Approval_Info.GetAppImageText(strImg);
iTRow += 1;
if (strImg == Biz_Type.app_status_complete)
{
iCRow += 1;
}
lblRowCount.Text = iCRow.ToString() + " / " + iTRow.ToString();
string estterm_ref_id = DataTypeUtility.GetValue(e.Row.Cells.FromKey("ESTTERM_REF_ID").Value);
string kpi_ref_id = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_REF_ID").Value);
string kpi_name = DataTypeUtility.GetValue(e.Row.Cells.FromKey("KPI_NAME").Value);
string url = "<a href='#null' onclick='doPoppingUp_KPI(\"{0}\",\"{1}\",\"{2}\")' style=\"color:Navy;\">{3}</a>";
string temp = string.Format(url, estterm_ref_id, kpi_ref_id, ICCB1, kpi_name);
e.Row.Cells.FromKey("KPI_NAME").Value = temp;
string useyn = DataTypeUtility.GetValue(e.Row.Cells.FromKey("USE_YN").Value);
if (useyn == "Y")
{
if (e.Row.Cells.FromKey("WEIGHT").Value != null)
{
string weight = DataTypeUtility.GetValue(e.Row.Cells.FromKey("WEIGHT").Value.ToString());
totalsum += weight == "" ? 0 : DataTypeUtility.GetToDouble(weight);
}
}
else
{
e.Row.Cells.FromKey("WEIGHT").Value = "0";
e.Row.Cells.FromKey("WEIGHT").AllowEditing = AllowEditing.No;
}
}
protected double CalcPoint(DataTable dtQuiz)
{
double Result = 0.0;
for (int i = 0; i < dtQuiz.Rows.Count; i++)
{
string q_sbj_id = dtQuiz.Rows[i]["Q_SBJ_ID"].ToString();
string point = dtQuiz.Rows[i]["POINT"].ToString();
object calcPoint = quizWeight.Compute(string.Format("SUM({0})*{1}", q_sbj_id, point), null);
Result += DataTypeUtility.GetToDouble(calcPoint);
}
return(Result);
}
private void DataBinding()
{
DataTable dt = null;
if (BU.Equals("DD"))
{
dt = DS_DATA.Tables[0];
}
else if (BU.Equals("DO"))
{
dt = DS_DATA.Tables[1];
}
else if (BU.Equals("CJ"))
{
dt = DS_DATA.Tables[2];
dt = DataTypeUtility.FilterSortDataTable(dt, "", "SORT_ORDER, SORT_ORDER2 DESC");
}
else
{
return;
}
uGrid.DataSource = dt;
uGrid.DataBind();
dt.Columns.Add("TEXT", typeof(string));
foreach (DataRow dr in dt.Rows)
{
dr["TEXT"] = string.Format("{0}({2}%)"
, dr["ALIAS"]
, DataTypeUtility.GetToDouble(dr["RESULT_TS"]).ToString("#,##0.00")
, DataTypeUtility.GetToDouble(dr["RESULT_RATIO"]).ToString("#,##0.00"));
}
BindChart(Chart1
, DataTypeUtility.FilterSortDataTable(dt, "SORT_ORDER2 = 2", "SORT_ORDER")
, "Item별 점유비 - 총매출"
, lbl1);
BindChart(Chart2
, DataTypeUtility.FilterSortDataTable(dt, "SORT_ORDER2 = 1", "SORT_ORDER")
, "Item별 점유비 - 내수매출"
, lbl2);
}
private void GridDoLayout(UltraWebGrid grid)
{
Biz_Prj_Info objPrjInfo = new Biz_Prj_Info();
_iprjType = WebUtility.GetByValueDropDownList(ddlPrjType);
_iprjCode = txtPrjCode.Text.Trim();
_iprjName = txtPrjName.Text.Trim();
DataTable dt = objPrjInfo.GetTotalFootInfo(_iprjCode
, _iprjName
, _iprjType).Tables[0];
UltraGridRow row = new UltraGridRow();
grid.Rows.Add(row);
UltraGridRow row2 = new UltraGridRow();
grid.Rows.Add(row2);
UltraGridRow row3 = new UltraGridRow();
grid.Rows.Add(row3);
row.Cells.FromKey("KPI_NAME").Value = "<B>소요예산 : </B>";
row2.Cells.FromKey("KPI_NAME").Value = "<B>집행현황 : </B>";
row3.Cells.FromKey("KPI_NAME").Value = "<B>진행율(%): </B>";
foreach (UltraGridColumn col in grid.Columns)
{
foreach (DataRow dr in dt.Rows)
{
if (col.Header.Column.Key == dr["PRJ_REF_ID"].ToString())
{
double dTotalBudget = DataTypeUtility.GetToDouble(dr["TOTAL_BUDGET"]);
row.Cells.FromKey(col.Header.Column.Key).Value = dTotalBudget.ToString("###,##0.#0");
double dExecAmount = DataTypeUtility.GetToDouble(dr["EXEC_AMOUNT"]);
row2.Cells.FromKey(col.Header.Column.Key).Value = dExecAmount.ToString("###,##0.#0");
double dTotalRate = DataTypeUtility.GetToDouble(dr["RATE"]);
row3.Cells.FromKey(col.Header.Column.Key).Value = dTotalRate.ToString("##0.#0");
}
}
}
}
protected void BindScore()
{
if (DT_SCORE != null && DT_SCORE.Rows.Count > 0)
{
DataTable dt_current_score = DataTypeUtility.FilterSortDataTable(DT_SCORE, string.Format("YMD='{0}'", YMD));
if (dt_current_score.Rows.Count > 0)
{
string score_col_name = "SCORE";
SCORE = DataTypeUtility.GetToDouble(dt_current_score.Rows[0][score_col_name]);
lblScore.Text = Math.Round(SCORE, 1).ToString();
}
else
{
lblScore.Text = "-";
}
}
}
protected void uwgrid_Weight_InitializeRow(object sender, RowEventArgs e)
{
if (e.Row.Cells.FromKey("PRJ_COL_CUSTOM_YN").Value.ToString().Equals("N") ||
EST_EMP_ID == gUserInfo.Emp_Ref_ID)
{
e.Row.Cells.FromKey("PRJ_COL_VALUE").AllowEditing = AllowEditing.No;
}
else
{
e.Row.Cells.FromKey("PRJ_COL_VALUE").Style.BackColor = System.Drawing.Color.MintCream;
}
double prj_col_weight = DataTypeUtility.GetToDouble(e.Row.Cells.FromKey("PRJ_COL_WEIGHT").Value);
double prj_col_value = DataTypeUtility.GetToDouble(e.Row.Cells.FromKey("PRJ_COL_VALUE").Value);
double cal = prj_col_value * (prj_col_weight / 100);
e.Row.Cells.FromKey("PRJ_COL_CAL").Value = cal;
}
/// <summary>
/// 평가주기의 총가중치 합 반환
/// </summary>
/// <param name="est_id"></param>
/// <returns></returns>
public static double GetTotalWeightEstTermSub(int comp_id, string est_id)
{
Biz_TermSubEstMaps estterm = new Biz_TermSubEstMaps();
DataTable dataTable = estterm.GetTermSubEstMap(comp_id, est_id, "").Tables[0];
double total = 0;
foreach (DataRow dataRow in dataTable.Rows)
{
total += DataTypeUtility.GetToDouble(dataRow["WEIGHT"]);
}
if (total == 0)
{
return(100);
}
return(total);
}
public void SetWeight()
{
int itxr_user = gUserInfo.Emp_Ref_ID;
UltraGridRow row;
Biz_Bsc_Mbo_Kpi_Weight objBSC = new Biz_Bsc_Mbo_Kpi_Weight();
DataTable dt = new DataTable();
dt.Columns.Add("ESTTERM_REF_ID", typeof(int));
dt.Columns.Add("KPI_REF_ID", typeof(int));
dt.Columns.Add("WEIGHT", typeof(decimal));
dt.Columns.Add("KPI_CLASS_REF_ID", typeof(string));
for (int i = 0; i < ugrdMBO.Rows.Count; i++)
{
row = ugrdMBO.Rows[i];
DataRow dr = dt.NewRow();
dr["ESTTERM_REF_ID"] = DataTypeUtility.GetToInt32(row.Cells.FromKey("ESTTERM_REF_ID").Value);
dr["KPI_REF_ID"] = DataTypeUtility.GetToInt32(row.Cells.FromKey("KPI_REF_ID").Value);
dr["WEIGHT"] = DataTypeUtility.GetToDouble(row.Cells.FromKey("WEIGHT").Value);
try
{
dr["KPI_CLASS_REF_ID"] = (row.Cells.FromKey("IS_TEAM_KPI").Value.ToString() == "Y" ? "SCO" : "PCO");
}
catch { }
dt.Rows.Add(dr);
}
if (objBSC.UpdateMBOWeight(gUserInfo.Emp_Ref_ID, dt))
{
PageUtility.AlertMessage("처리하였습니다.");
}
else
{
PageUtility.AlertMessage("실패하였습니다.");
}
DoBinding();
}
protected void iBtnConfirmOpinion_Click(object sender, ImageClickEventArgs e)
{
double total = 0.0; //정성평가 점수
string point_list = string.Empty; //정성평가 질의 평가 결과
for (int i = 0; i < ugrdQuestionList.Rows.Count; i++)
{
double weight = DataTypeUtility.GetToDouble(ugrdQuestionList.Rows[i].Cells.FromKey("WEIGHT").Value) * 0.01;
double point = DataTypeUtility.GetToDouble(ugrdQuestionList.Rows[i].Cells.FromKey("POINT").Value);
string point_text = DataTypeUtility.GetValue(ugrdQuestionList.Rows[i].Cells.FromKey("POINT").Text);
point_list += ";" + point_text;
double result = weight * point;
total += result;
}
if (point_list.Length > 2)
{
point_list = point_list.Remove(0, 1);
}
string grid_id = IFROMKEY.Split(';')[0];
string col_final_score = IFROMKEY.Split(';')[1];
string col_score_ori_list = IFROMKEY.Split(';')[2];
string col_grade_pop = IFROMKEY.Split(';')[3];
string jscript = JSHelper.GetSclipt(string.Format("doSettingValueInCell('{0}', '{1}', '{2}', '{3}', '{4}', '{5}','{6}');"
, grid_id
, col_final_score
, col_score_ori_list
, col_grade_pop
, IROW_NO
, total
, point_list));
ltrScript.Text = jscript;
}
/// <summary>
/// 프로젝트 리스트에 대한 프로젝트 점수 평균
/// </summary>
public double Select_Avg_Prj_Point(IDbConnection conn, IDbTransaction trx
, object comp_id
, object est_id
, object estterm_ref_id
, object estterm_sub_id
, object estterm_step_id
, object prj_ref_id_list)
{
string query = string.Format(@"
SELECT AVG( CASE WHEN POINT IS NULL THEN 0 ELSE POINT END ) AS AVG_POINT
FROM PRJ_DATA PD
LEFT OUTER JOIN PRJ_INFO PI
ON PD.PRJ_REF_ID = PI.PRJ_REF_ID
LEFT OUTER JOIN PMS_INFO PMS
ON PI.PRJ_CODE = PMS.PROJECTID
WHERE COMP_ID = @COMP_ID
AND EST_ID = @EST_ID
AND ESTTERM_REF_ID = @ESTTERM_REF_ID
AND ESTTERM_SUB_ID = @ESTTERM_SUB_ID
AND ESTTERM_STEP_ID = @ESTTERM_STEP_ID
AND TGT_DEPT_ID = -1
AND TGT_EMP_ID = -1
AND PD.PRJ_REF_ID IN ( {0} )
", prj_ref_id_list.ToString());
IDbDataParameter[] paramArray = CreateDataParameters(5);
paramArray[0] = CreateDataParameter("@COMP_ID", SqlDbType.Int);
paramArray[0].Value = comp_id;
paramArray[1] = CreateDataParameter("@EST_ID", SqlDbType.NVarChar);
paramArray[1].Value = est_id;
paramArray[2] = CreateDataParameter("@ESTTERM_REF_ID", SqlDbType.Int);
paramArray[2].Value = estterm_ref_id;
paramArray[3] = CreateDataParameter("@ESTTERM_SUB_ID", SqlDbType.Int);
paramArray[3].Value = estterm_sub_id;
paramArray[4] = CreateDataParameter("@ESTTERM_STEP_ID", SqlDbType.Int);
paramArray[4].Value = estterm_step_id;
object result = DbAgentObj.ExecuteScalar(conn, trx, query, paramArray, CommandType.Text);
return(DataTypeUtility.GetToDouble(result));
}
public Biz_QuestionItems(string q_itm_id, string q_sbj_id, string q_obj_id)
{
DataSet ds = _questionItem.Select(q_itm_id, q_sbj_id, q_obj_id);
DataRow dr;
if (ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_q_itm_id = (dr["Q_ITM_ID"] == DBNull.Value) ? "" : dr["Q_ITM_ID"].ToString();
_q_sbj_id = (dr["Q_SBJ_ID"] == DBNull.Value) ? "" : dr["Q_SBJ_ID"].ToString();
_num = (dr["NUM"] == DBNull.Value) ? 0 : DataTypeUtility.GetToInt32(dr["NUM"]);
_q_item_name = (dr["Q_ITEM_NAME"] == DBNull.Value) ? "" : dr["Q_ITEM_NAME"].ToString();
_point = (dr["POINT"] == DBNull.Value) ? 0 : DataTypeUtility.GetToDouble(dr["POINT"]);
_weight = (dr["WEIGHT"] == DBNull.Value) ? 0 : DataTypeUtility.GetToDouble(dr["WEIGHT"]);
_comment = (dr["COMMENT"] == DBNull.Value) ? "" : dr["COMMENT"].ToString();
_subject_item_yn = (dr["SUBJECT_ITEM_YN"] == DBNull.Value) ? "" : dr["SUBJECT_ITEM_YN"].ToString();
_update_date = (dr["UPDATE_DATE"] == DBNull.Value) ? DateTime.MinValue : DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
_update_user = (dr["UPDATE_USER"] == DBNull.Value) ? 0 : DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
}
}
public Biz_QuestionSubjects(string q_sbj_id)
{
DataSet ds = _questionsubject.Select(q_sbj_id, "", "");
DataRow dr;
if (ds.Tables[0].Rows.Count == 1)
{
dr = ds.Tables[0].Rows[0];
_q_sbj_id = dr["Q_SBJ_ID"].ToString();
_q_obj_id = dr["Q_OBJ_ID"].ToString();
_q_dfn_id = dr["Q_DFN_ID"].ToString();
_num = DataTypeUtility.GetToInt32(dr["NUM"]);
_q_sbj_name = dr["Q_SBJ_NAME"].ToString();
_q_sbj_define = dr["Q_SBJ_DEFINE"].ToString();
_q_sbj_desc = dr["Q_SBJ_DESC"].ToString();
_weight = DataTypeUtility.GetToDouble(dr["WEIGHT"]);
_update_date = DataTypeUtility.GetToDateTime(dr["UPDATE_DATE"]);
_update_user = DataTypeUtility.GetToInt32(dr["UPDATE_USER"]);
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
int isAllConvertThis = txtThis.Text == "" ? 0 : DataTypeUtility.GetToInt32(txtThis.Text);
int isAllConvertFill = txtThis.Text == "" ? 0 : DataTypeUtility.GetToInt32(txtFill.Text);
int rowEffect = 0;
int ccc = 0;
for (int i = 0; i < ugrdKpiResultList.Rows.Count; i++)
{
UltraGridRow row = ugrdKpiResultList.Rows[i];
TemplatedColumn Col_Check = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
System.Web.UI.WebControls.CheckBox chkCheck = (System.Web.UI.WebControls.CheckBox)((CellItem)Col_Check.CellItems[row.BandIndex]).FindControl("cBox");
if (chkCheck.Checked)
{
ccc++;
double target_ms = txtThis.Text != "" && DataTypeUtility.GetToDouble(txtThis.Text) != 0 ?
DataTypeUtility.GetToDouble(txtThis.Text) : DataTypeUtility.GetToDouble((row.Cells.FromKey("TARGET_MS").Value));
double target_ts = txtFill.Text != "" && DataTypeUtility.GetToDouble(txtFill.Text) != 0 ?
DataTypeUtility.GetToDouble(txtFill.Text) : DataTypeUtility.GetToDouble((row.Cells.FromKey("TARGET_TS").Value));
int kpi_pool_ref_id = DataTypeUtility.GetToInt32((row.Cells.FromKey("KPI_REF_ID").Value));
int esstid = DataTypeUtility.GetToInt32(ddlEstTermInfo.SelectedValue);
string ymd = ddlEstTermMonth.SelectedValue;
rowEffect += new Biz_Com_Emp_Info().Update_Goal(esstid, kpi_pool_ref_id, ymd, target_ms, target_ts);
}
}
if (rowEffect > 0)
{
ltrScript.Text = JSHelper.GetAlertScript("저장되었습니다.");
txtFill.Text = "";
txtThis.Text = "";
Grid_Bind();
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("저장 실패.");
return;
}
}
protected void UltraWebGrid1_InitializeRow(object sender, RowEventArgs e)
{
double total_weight = 0; //가중치 합계
double weight = 0; //부서 가중치
//가중치 입력 필드에 바인드
for (int i = 0; i < DEPT_TYPE_REF_ID.Length; i++)
{
string colName = string.Format("WEIGHT_{0}", DEPT_TYPE_REF_ID[i]);
TemplatedColumn tc = (TemplatedColumn)UltraWebGrid1.Columns.FromKey("i" + colName);
Infragistics.WebUI.WebDataInput.WebNumericEdit ne = (Infragistics.WebUI.WebDataInput.WebNumericEdit)((CellItem)tc.CellItems[e.Row.Index]).FindControl("WEIGHT");
weight = DataTypeUtility.GetToDouble(e.Row.Cells.FromKey(colName).Value);
ne.Value = weight;
total_weight += weight;
}
e.Row.Cells.FromKey("TOTAL_WEIGHT").Value = total_weight;
}
protected void ugridKpiTargetList_InitializeRow(object sender, RowEventArgs e)
{
DataRowView drv = (DataRowView)e.Data;
//string appUrl = Server.MapPath
for (int i = 1; i < 13; i++)
{
e.Row.Cells.FromKey("M" + i.ToString("00")).Value = DataTypeUtility.GetToDouble(drv["M" + i.ToString("00") + "_MS"]).ToString("###,##0.00")
+ String.Format(" <img src='{1}/images/{0}' alt='' />", dtTH.Select(string.Format("THRESHOLD_REF_ID = {0}", (drv["M" + i.ToString("00") + "_CHECKSTATUS"].ToString() == "Y" ? DataTypeUtility.GetToInt32(drv["M" + i.ToString("00") + "_SIGNAL_MS"]) : dtTH.Rows.Count - 1)))[0]["IMAGE_FILE_NAME"].ToString(), this.ITOP_URL)
+ "<br/>"
+ DataTypeUtility.GetToDouble(drv["M" + i.ToString("00") + "_TS"]).ToString("###,##0.00")
+ String.Format(" <img src='{1}/images/{0}' alt='' />", dtTH.Select(string.Format("THRESHOLD_REF_ID = {0}", (drv["M" + i.ToString("00") + "_CHECKSTATUS"].ToString() == "Y" ? DataTypeUtility.GetToInt32(drv["M" + i.ToString("00") + "_SIGNAL_TS"]) : dtTH.Rows.Count - 1)))[0]["IMAGE_FILE_NAME"].ToString(), this.ITOP_URL);
if (drv["M" + i.ToString("00") + "_CHECK_YN"].ToString() == "N")
{
e.Row.Cells.FromKey("M" + i.ToString("00")).Style.ForeColor = System.Drawing.Color.LightGray;
}
e.Row.Cells.FromKey("THRESHOLD_ENAME").Value
+= dtTH.Select(string.Format("THRESHOLD_REF_ID = {0}", (drv["M" + i.ToString("00") + "_CHECKSTATUS"].ToString() == "Y" ? DataTypeUtility.GetToInt32(drv["M" + i.ToString("00") + "_SIGNAL_MS"]) : dtTH.Rows.Count - 1)))[0]["THRESHOLD_ENAME"].ToString() + "^"
+ dtTH.Select(string.Format("THRESHOLD_REF_ID = {0}", (drv["M" + i.ToString("00") + "_CHECKSTATUS"].ToString() == "Y" ? DataTypeUtility.GetToInt32(drv["M" + i.ToString("00") + "_SIGNAL_TS"]) : dtTH.Rows.Count - 1)))[0]["THRESHOLD_ENAME"].ToString() + "*";
}
e.Row.Cells.FromKey("THRESHOLD_ENAME").Value = e.Row.Cells.FromKey("THRESHOLD_ENAME").Value.ToString().Substring(0, e.Row.Cells.FromKey("THRESHOLD_ENAME").Value.ToString().Length - 1);
}
protected void UltraWebGrid1_InitializeRow(object sender, RowEventArgs e)
{
double target = DataTypeUtility.GetToDouble(e.Row.Cells.FromKey("TARGET").Value);
double result = DataTypeUtility.GetToDouble(e.Row.Cells.FromKey("RESULT").Value);
double progress;
if (result == 0 || target == 0)
{
progress = 0;
if (result + target == 0)
{
e.Row.Cells.FromKey("SIGNAL_NAME").Value = "-";
}
}
else
{
progress = result / target * 100;
}
e.Row.Cells.FromKey("PROGRESS").Value = Math.Round(progress, 1);
}
public static string GetWeightStringByEstTermStep(int comp_id, string est_id)
{
Biz_TermStepEstMaps estterm = new Biz_TermStepEstMaps();
DataTable dataTable = estterm.GetTermStepEstMap(comp_id, est_id).Tables[0];
string temp = "";
bool isFirst = true;
foreach (DataRow dataRow in dataTable.Rows)
{
if (isFirst)
{
temp += DataTypeUtility.GetToDouble(dataRow["WEIGHT"]).ToString("#,##0.00");
isFirst = false;
}
else
{
temp += " : " + DataTypeUtility.GetToDouble(dataRow["WEIGHT"]).ToString("#,##0.00");
}
}
return(temp);
}
protected void ugrdResultStatus_InitializeRow(object sender, RowEventArgs e)
{
DataRowView drw = (DataRowView)e.Data;
string strTrend = e.Row.Cells.FromKey("TREND").Value.ToString();
e.Row.Cells.FromKey("ACHIEVE_RATE").Value = DataTypeUtility.GetToDouble(e.Row.Cells.FromKey("ACHIEVE_RATE").Value) * 100 / 100.00;
switch (strTrend)
{
case "UP":
e.Row.Cells.FromKey("TREND").Value = "<img class='KPI' border='0' src='../images/arrow/arrow_e_up.gif'>";;
break;
case "DOWN":
e.Row.Cells.FromKey("TREND").Value = "<img class='KPI' border='0' src='../images/arrow/arrow_b_down.gif'>";;
break;
case "FLAT":
e.Row.Cells.FromKey("TREND").Value = "<img class='KPI' border='0' src='../images/arrow/arrow_m.gif'>";;
break;
default:
break;
}
e.Row.Cells.FromKey("SIGNAL_IMAGE").Value = "<div align=center><img src='../images/" + e.Row.Cells.FromKey("SIGNAL_IMAGE").Value.ToString() + "'></div>";
if (drw["SORT_TYPE"].ToString() == "H")
{
e.Row.Cells.FromKey("RANK").Style.BackColor = System.Drawing.Color.FromName("#CEE2F4");
}
else if (drw["SORT_TYPE"].ToString() == "L")
{
e.Row.Cells.FromKey("RANK").Style.BackColor = System.Drawing.Color.FromName("#FFE0E0");
}
}
private void BindingItem(DataListItemEventArgs e)
{
DataRowView dr = (DataRowView)e.Item.DataItem;
string q_sbj_id = DataTypeUtility.GetValue(dr["Q_SBJ_ID"]);
string q_sbj_name = DataTypeUtility.GetValue(dr["Q_SBJ_NAME"]);
string q_sbj_define = DataTypeUtility.GetValue(dr["Q_SBJ_DEFINE"]);
double weight = DataTypeUtility.GetToDouble(dr["WEIGHT"]);
quizWeight.Columns.Add(q_sbj_id, typeof(double));
if (quizWeight.Rows.Count == 0)
{
quizWeight.Rows.Add(weight / 100);
}
else
{
quizWeight.Rows[0][q_sbj_id] = weight / 100;
}
Literal ltrSbjName = e.Item.FindControl("ltrLevelSbjName") as Literal;
Literal ltrSbjDefine = e.Item.FindControl("ltrLevelSbjDefine") as Literal;
RadioButtonList rBtnList = e.Item.FindControl("rBtnList") as RadioButtonList;
TextBox txtValue = e.Item.FindControl("txtLevelValue") as TextBox;
HiddenField hdfSubItmYN = e.Item.FindControl("tmpSubItmYN") as HiddenField;
Literal ltrPointData = e.Item.FindControl("ltrLevelPointData") as Literal;
DataList dtList = e.Item.FindControl("DataList3") as DataList;
HtmlTableCell tdHeader = e.Item.FindControl("tdHeader") as HtmlTableCell;
HtmlTableCell tdContent = null;
if (dtList == null)
{
tdContent = e.Item.FindControl("tdContent") as HtmlTableCell;
}
else
{
tdContent = dtList.FindControl("tdContent") as HtmlTableCell;
}
TextBoxCommon.SetOnlyPercent(txtValue);
ltrSbjName.Text = q_sbj_name;
ltrSbjDefine.Text = q_sbj_define;
Biz_QuestionItems questionItems = new Biz_QuestionItems();
DataSet ds = questionItems.GetQuestionItem("", q_sbj_id, Q_OBJ_ID);
SUBJECT_ITEM_YN = ds.Tables[0].Rows[0]["SUBJECT_ITEM_YN"].ToString();
hdfSubItmYN.Value = SUBJECT_ITEM_YN;
if (ds.Tables[0].Rows.Count == 0)
{
rBtnList.Visible = false;
txtValue.Visible = false;
txtValue.Width = Unit.Percentage(100);
}
else if (SUBJECT_ITEM_YN == "1")
{
rBtnList.Visible = false;
txtValue.Visible = true;
txtValue.Width = Unit.Percentage(100);
Biz_Prj_QuestionData questionDatas = new Biz_Prj_QuestionData(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, EST_DEPT_ID
, EST_EMP_ID
, PRJ_REF_ID
, q_sbj_id);
txtValueText = questionDatas.Text_Value;
txtValue.Text = txtValueText;
}
else
{
rBtnList.Visible = true;
txtValue.Visible = false;
// 만약 질의항목에 설명을 표시할 경우
if (_q_item_desc_use_yn.Equals("Y"))
{
rBtnList.RepeatLayout = RepeatLayout.Table;
rBtnList.DataTextField = "Q_ITEM_DESC";
tdHeader.Style.Add("width", "260px");
if (tdContent != null)
{
tdContent.Style.Add("width", "262px");
}
}
rBtnList.DataSource = ds;
rBtnList.DataBind();
if (READ_ONLY_YN.Equals("N"))
{
//Biz_Prj_QuestionData questionDatas = new Biz_Prj_QuestionData(COMP_ID
// , EST_ID
// , ESTTERM_REF_ID
// , ESTTERM_SUB_ID
// , ESTTERM_STEP_ID
// , EST_DEPT_ID
// , EST_EMP_ID
// , PRJ_REF_ID
// , q_sbj_id);
//// 데이타 바인딩
//WebUtility.FindByValueRadioButtonList(rBtnList, questionDatas.Q_Itm_ID);
Biz_Prj_QuestionData questionDatas = new Biz_Prj_QuestionData(COMP_ID
, EST_ID
, ESTTERM_REF_ID
, ESTTERM_SUB_ID
, ESTTERM_STEP_ID
, EST_DEPT_ID
, EST_EMP_ID
, TGT_EMP_ID
, PRJ_REF_ID
, q_sbj_id);
// 데이타 바인딩
WebUtility.FindByValueRadioButtonList(rBtnList, questionDatas.Q_Itm_ID);
groupNumber += questionDatas.Point;
if (questionDatas.Point.Equals(0))
{
noneSelectCount = noneSelectCount + 1;
}
if (questionDatas.Point > 0)
{
ltrPointData.Text = "<font color=#BF0000>" + DataTypeUtility.GetToInt32_String(questionDatas.Point, "##.#0") + "</font>점";
//TOTALPOINT += questionDatas.Point * weight;
}
//----------------- 라디오버튼 유효성 검사 시작 -------------------
string clientIDs = "";
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (i != 0)
{
clientIDs += ";";
}
clientIDs += rBtnList.ClientID + "_" + i.ToString();
}
VALID_SCRIPT += string.Format("if(ValidQuestion('{0}', '{1}') == false) return false;", dr["Q_SBJ_NAME"], clientIDs);
//----------------- 라디오버튼 유효성 검사 끝 -------------------
}
}
}
private void DataListBinding(DataTable dtPrjData)
{
Biz_QuestionObjects questionObjects = new Biz_QuestionObjects(EST_ID, Q_OBJ_ID);
Q_OBJ_NAME = questionObjects.Q_Obj_Name;
TOTALPOINT = 0;
Biz_QuestionSubjects questionSubjects = new Biz_QuestionSubjects();
DataSet ds = questionSubjects.GetQuestionSubject("", Q_OBJ_ID, "");
if (ds.Tables.Count == 0)
{
return;
}
DataTable dt = DataTypeUtility.GetGroupByDataTable(ds.Tables[0], new string[] { "Q_DFN_ID" });
string q_dfn_ids = DataTypeUtility.GetSplitString(dt, "Q_DFN_ID", ",");
if (!q_dfn_ids.Equals(""))
{
DefineDataBinding(q_dfn_ids);
}
NoDefineDataBinding(ds);
//MicroBSC.Integration.EST.Biz.Biz_Est_Data bizEstData = new MicroBSC.Integration.EST.Biz.Biz_Est_Data();
//DataTable dtEstData = bizEstData.GetEstData(COMP_ID
// , EST_ID
// , ESTTERM_REF_ID
// , ESTTERM_SUB_ID
// , ESTTERM_STEP_ID
// , ""
// , EST_EMP_ID
// , TGT_EMP_ID);
//MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data bizPrjData = new MicroBSC.Integration.PRJ.Biz.Biz_Prj_Data();
//DataTable dtPrjData = bizPrjData.Get_Prj_Data_List(PRJ_REF_ID
// , COMP_ID
// , EST_ID
// , ESTTERM_REF_ID
// , ESTTERM_SUB_ID
// , ESTTERM_STEP_ID
// , EST_DEPT_ID
// , EST_EMP_ID
// , TGT_DEPT_ID
// , TGT_EMP_ID
// , "");
//POINT_ORG = Math.Round(TOTALPOINT * 0.01, 2);
//POINT_ORG = Math.Round(TOTALPOINT / 3, 1);
POINT_ORG = DataTypeUtility.GetToDouble(dtPrjData.Rows[0]["POINT"]);
if (POINT_ORG == 0)
{
ltrTotalPoint.Text = "미평가";
}
else
{
ltrTotalPoint.Text = POINT_ORG.ToString("###.0") + " / 100";
}
}
public bool CopyQuestionObject(DataTable dataTable)
{
int affectedRow = 0;
Dac_QuestionEstMaps questionEstMap = new Dac_QuestionEstMaps();
Dac_QuestionSubjects questionSubject = new Dac_QuestionSubjects();
Dac_QuestionItems questionItem = new Dac_QuestionItems();
Dac_QuestionDatas questionData = new Dac_QuestionDatas();
Dac_KeyGens keyGen = new Dac_KeyGens();
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
try
{
//EST_QUESTION_OBJECT - 복사
foreach (DataRow dataRowDT in dataTable.Rows)
{
DataTable dtObj = _questionObject.Select(conn
, trx
, DataTypeUtility.GetValue(dataRowDT["EST_ID"])
, DataTypeUtility.GetValue(dataRowDT["Q_OBJ_ID"])).Tables[0];
DataTable dtEstMap = questionEstMap.Select(conn
, trx
, ""
, DataTypeUtility.GetValue(dataRowDT["Q_OBJ_ID"])).Tables[0];
foreach (DataRow dataRowObj in dtObj.Rows)
{
string q_obj_id = keyGen.GetCode(conn
, trx
, "EST_QUESTION_OBJECT");
// 질의 그룹 등록
affectedRow += _questionObject.Insert(conn
, trx
, q_obj_id
, "Copy of " + DataTypeUtility.GetValue(dataRowObj["Q_OBJ_NAME"])
, DataTypeUtility.GetValue(dataRowObj["Q_OBJ_TITLE"])
, DataTypeUtility.GetValue(dataRowObj["Q_OBJ_PREFACE"])
, DataTypeUtility.GetToDateTime(dataRowDT["DATE"])
, DataTypeUtility.GetToInt32(dataRowDT["USER"]));
// 질의 매핑 등록
foreach (DataRow dataRowEstMap in dtEstMap.Rows)
{
affectedRow += questionEstMap.Insert(conn
, trx
, DataTypeUtility.GetValue(dataRowEstMap["EST_ID"])
, q_obj_id
, DataTypeUtility.GetToDateTime(dataRowDT["DATE"])
, DataTypeUtility.GetToInt32(dataRowDT["USER"]));
}
DataTable dtSub = questionSubject.Select(conn
, trx
, ""
, DataTypeUtility.GetValue(dataRowObj["Q_OBJ_ID"])
, "").Tables[0];
// 질의 제목 등록
foreach (DataRow dataRowSub in dtSub.Rows)
{
string q_sbj_id = keyGen.GetCode(conn
, trx
, "EST_QUESTION_SUBJECT");
affectedRow += questionSubject.Insert(conn
, trx
, q_sbj_id
, q_obj_id
, DataTypeUtility.GetValue(dataRowSub["Q_DFN_ID"])
, DataTypeUtility.GetToInt32(dataRowSub["NUM"])
, DataTypeUtility.GetValue(dataRowSub["Q_SBJ_NAME"])
, DataTypeUtility.GetToDouble(dataRowSub["WEIGHT"])
, DataTypeUtility.GetValue(dataRowSub["Q_SBJ_DEFINE"])
, DataTypeUtility.GetValue(dataRowSub["Q_SBJ_DESC"])
, DataTypeUtility.GetToDateTime(dataRowDT["DATE"])
, DataTypeUtility.GetToInt32(dataRowDT["USER"]));
DataTable dtItem = questionItem.Select(conn
, trx
, ""
, DataTypeUtility.GetValue(dataRowSub["Q_SBJ_ID"])
, DataTypeUtility.GetValue(dataRowObj["Q_OBJ_ID"])).Tables[0];
// 질의 항목 등록
foreach (DataRow dataRowItem in dtItem.Rows)
{
string q_itm_id = keyGen.GetCode(conn
, trx
, "EST_QUESTION_ITEM");
affectedRow += questionItem.Insert(conn
, trx
, q_itm_id
, q_sbj_id
, DataTypeUtility.GetToInt32(dataRowItem["NUM"])
, DataTypeUtility.GetValue(dataRowItem["Q_ITEM_NAME"])
, DataTypeUtility.GetToDouble(dataRowItem["POINT"])
, DataTypeUtility.GetValue(dataRowItem["COMMENT"])
, DataTypeUtility.GetValue(dataRowItem["SUBJECT_ITEM_YN"])
, DataTypeUtility.GetToDateTime(dataRowDT["DATE"])
, DataTypeUtility.GetToInt32(dataRowDT["USER"]));
}
}
}
}
trx.Commit();
}
catch (Exception ex)
{
trx.Rollback();
return(false);
}
finally
{
conn.Close();
}
return((affectedRow > 0) ? true : false);
}
protected void ibtnSave_Click(object sender, ImageClickEventArgs e)
{
Biz_EstDeptOrgScoreInfos bizEDOS = new Biz_EstDeptOrgScoreInfos();
if (bizEDOS.InsertEDOS(WebUtility.GetIntByValueDropDownList(ddlEstTermInfo), txtSCORE_CODE.Text.Trim(), txtSCORE_NAME.Text.Trim(), DataTypeUtility.GetToDouble(txtMIN_VALUE.Text), DataTypeUtility.GetToDouble(txtMAX_VALUE.Text), gUserInfo.Emp_Ref_ID))
{
DoBinding();
ltrScript.Text = JSHelper.GetAlertScript("저장하였습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("저장실패!");
}
}
private void DoBinding_JeonSa()
{
UltraWebGrid1.Clear();
MicroBSC.Integration.COM.Biz.Biz_NHIT bizNHIT = new MicroBSC.Integration.COM.Biz.Biz_NHIT();
DataTable dtNHIT = bizNHIT.GetJeonSaPOPUP(GRP_ONE_ID.A.ToString()
, (int)GRP_TWO_ID.GTO_10
, CR_YEAR
, TG_GUBUN);
#region 차트용 datatable 생성
DataTable dtChart = new DataTable();
dtChart.Columns.Add("CR_YEAR");
dtChart.Columns.Add("CR_MONTH");
dtChart.Columns.Add("ME_RATE", typeof(double));
dtChart.Columns.Add("YG_RATE", typeof(double));
dtChart.Columns.Add("DN_RATE", typeof(double));
for (int i = 0; i < 12; i++)
{
DataRow dr = dtChart.NewRow();
dr["CR_YEAR"] = CR_YEAR;
dr["CR_MONTH"] = DataTypeUtility.GetString(i + 1).PadLeft(2, '0');
dr["ME_RATE"] = 0;
dr["YG_RATE"] = 0;
dr["DN_RATE"] = 0;
dtChart.Rows.Add(dr);
}
string cr_year = "";
string cr_month = "";
string grp_three_code = "";
int iRow = 0;
for (int i = 0; i < dtNHIT.Rows.Count; i++)
{
cr_year = DataTypeUtility.GetString(dtNHIT.Rows[i]["CR_YEAR"]);
cr_month = DataTypeUtility.GetString(dtNHIT.Rows[i]["CR_MONTH"]);
grp_three_code = DataTypeUtility.GetString(dtNHIT.Rows[i]["GRP_THREE_CODE"]);
iRow = DataTypeUtility.GetToInt32(cr_month) - 1;
if (grp_three_code == "ME")
{
dtChart.Rows[iRow]["ME_RATE"] = DataTypeUtility.GetToDouble(dtNHIT.Rows[i]["DAL_RATE_100"]);
}
else if (grp_three_code == "YG")
{
dtChart.Rows[iRow]["YG_RATE"] = DataTypeUtility.GetToDouble(dtNHIT.Rows[i]["DAL_RATE_100"]);
}
else if (grp_three_code == "DN")
{
dtChart.Rows[iRow]["DN_RATE"] = DataTypeUtility.GetToDouble(dtNHIT.Rows[i]["DAL_RATE_100"]);
}
}
DrawChart(dtChart);
#endregion
#region 그리드용 datatable 생성
DataTable dtGrid = new DataTable();
dtGrid.Columns.Add("ACC");
dtGrid.Columns.Add("GUBUN");
dtGrid.Columns.Add("M01", typeof(double));
dtGrid.Columns.Add("M02", typeof(double));
dtGrid.Columns.Add("M03", typeof(double));
dtGrid.Columns.Add("M04", typeof(double));
dtGrid.Columns.Add("M05", typeof(double));
dtGrid.Columns.Add("M06", typeof(double));
dtGrid.Columns.Add("M07", typeof(double));
dtGrid.Columns.Add("M08", typeof(double));
dtGrid.Columns.Add("M09", typeof(double));
dtGrid.Columns.Add("M10", typeof(double));
dtGrid.Columns.Add("M11", typeof(double));
dtGrid.Columns.Add("M12", typeof(double));
for (int i = 0; i < 9; i++)
{
DataRow dr = dtGrid.NewRow();
switch (i)
{
case 0:
dr["ACC"] = "매출";
break;
case 3:
dr["ACC"] = "영업이익";
break;
case 6:
dr["ACC"] = "당기순이익";
break;
}
switch (i)
{
case 0:
case 3:
case 6:
dr["GUBUN"] = "목표";
break;
case 1:
case 4:
case 7:
dr["GUBUN"] = "실적";
break;
case 2:
case 5:
case 8:
dr["GUBUN"] = "달성률";
break;
}
dr["M01"] = 0;
dr["M02"] = 0;
dr["M03"] = 0;
dr["M04"] = 0;
dr["M05"] = 0;
dr["M06"] = 0;
dr["M07"] = 0;
dr["M08"] = 0;
dr["M09"] = 0;
dr["M10"] = 0;
dr["M11"] = 0;
dr["M12"] = 0;
dtGrid.Rows.Add(dr);
}
cr_year = "";
cr_month = "";
grp_three_code = "";
int iCol = 0;
for (int i = 0; i < dtNHIT.Rows.Count; i++)
{
cr_year = DataTypeUtility.GetString(dtNHIT.Rows[i]["CR_YEAR"]);
cr_month = DataTypeUtility.GetString(dtNHIT.Rows[i]["CR_MONTH"]);
grp_three_code = DataTypeUtility.GetString(dtNHIT.Rows[i]["GRP_THREE_CODE"]);
iCol = DataTypeUtility.GetToInt32(cr_month) + 1;
if (grp_three_code == "ME")
{
dtGrid.Rows[0][iCol] = DataTypeUtility.GetToDouble(dtNHIT.Rows[i]["TARGET_TS"]);
dtGrid.Rows[1][iCol] = DataTypeUtility.GetToDouble(dtNHIT.Rows[i]["RESULT_TS"]);
dtGrid.Rows[2][iCol] = DataTypeUtility.GetToDouble(dtNHIT.Rows[i]["DAL_RATE_100"]);
}
else if (grp_three_code == "YG")
{
dtGrid.Rows[3][iCol] = DataTypeUtility.GetToDouble(dtNHIT.Rows[i]["TARGET_TS"]);
dtGrid.Rows[4][iCol] = DataTypeUtility.GetToDouble(dtNHIT.Rows[i]["RESULT_TS"]);
dtGrid.Rows[5][iCol] = DataTypeUtility.GetToDouble(dtNHIT.Rows[i]["DAL_RATE_100"]);
}
else if (grp_three_code == "DN")
{
dtGrid.Rows[6][iCol] = DataTypeUtility.GetToDouble(dtNHIT.Rows[i]["TARGET_TS"]);
dtGrid.Rows[7][iCol] = DataTypeUtility.GetToDouble(dtNHIT.Rows[i]["RESULT_TS"]);
dtGrid.Rows[8][iCol] = DataTypeUtility.GetToDouble(dtNHIT.Rows[i]["DAL_RATE_100"]);
}
}
UltraWebGrid1.DataSource = dtGrid;
UltraWebGrid1.DataBind();
#endregion
}
private void BindChart(Chart chart
, DataTable dt
, string titleName
, System.Web.UI.WebControls.Label lbl)
{
DundasCharts.DundasChartBase(chart
, ChartImageType.Flash
, 480
, 300
, 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);
Series series1 = DundasCharts.CreateSeries(chart
, "Series1"
, "Default"
, null
, null
, SeriesChartType.Doughnut
, 1
, GetChartColor(0)
, Color.FromArgb(0x4A, 0x58, 0x7E)
, Color.FromArgb(64, 0, 0, 0)
, 1
, 9
, Color.FromArgb(64, 64, 64));
//series1.Label = "#VALY{N0}";
series1.ToolTip = "#VALY{N0}";
//series1.ShowLabelAsValue = true;
//series1.ShowInLegend = true;
chart.ChartAreas["Default"].AxisY.LabelStyle.Format = "N0";
DundasAnimations.DundasChartBase(chart, AnimationTheme.None, -1, -1, false, 1);
DundasAnimations.GrowingAnimation(chart, series1, 0.5, 1.5, true);
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// series1.Points[i].AxisLabel = dt.Rows[i]["ALIAS"].ToString();
//}
//for (int i = 0; i < dt.Rows.Count; i++)
//{
// series1.Points.AddY(dt.Rows[i]["RESULT_TS"]);
//}
DataTable dtData = DataTypeUtility.FilterSortDataTable(dt, "KPI_REF_ID > 0");
for (int i = 0; i < dtData.Rows.Count; i++)
{
series1.Points.AddXY(dt.Rows[i]["TEXT"].ToString(), dt.Rows[i]["RESULT_TS"]);
}
if (series1.Type == SeriesChartType.Pie || series1.Type == SeriesChartType.Doughnut)
{
for (int p = 0; p < series1.Points.Count; p++)
{
DataPoint point = series1.Points[p];
point.Color = GetChartColor(p);
}
}
//series1.ToolTip = "#VALY{#,##0,00}";
//series2.ToolTip = "#VALY{#,##0}";
//series2.MarkerStyle = MarkerStyle.Circle;
//series2.MarkerColor = Color.FromArgb(0xFF, 0xAA, 0x20);
//series2.MarkerBorderColor = Color.FromArgb(0xD7, 0x41, 0x01);
Font font = new Font("Gulim", 11, FontStyle.Regular);
Dundas.Charting.WebControl.Title title = DundasCharts.CreateTitle(chart
, "Title1"
, titleName
, font
, Color.FromArgb(26, 59, 105)
, Color.Empty
, Color.Empty
, ContentAlignment.TopCenter
, null
, Color.FromArgb(32, 0, 0, 0)
, 3
, false
, 5
, 7
, 91
, 6);
Legend legend = DundasCharts.CreateLegend(chart
, "Default"
, Color.Transparent
, Color.Empty
, Color.Empty);
series1.Font = new Font("굴림", 8, FontStyle.Regular);
series1["PieLabelStyle"] = "Outside";
legend.LegendStyle = LegendStyle.Table;
legend.AutoFitText = false;
legend.Docking = LegendDocking.Bottom;
//legend.Alignment = StringAlignment.Near;
//legend.Position = new ElementPosition(60, 7, 50, 24);
//legend.Enabled = false;
//legend.DockInsideChartArea = true;
//chart.ChartAreas["Default"].AlignOrientation = AreaAlignOrientation.Horizontal;
DundasCharts.SetChartArea(chart.ChartAreas["Default"], true);
DataRow[] drCol = dt.Select(string.Format("KPI_REF_ID < 0"));
if (drCol.Length > 0)
{
lbl.Text = DataTypeUtility.GetToDouble(drCol[0]["RESULT_TS"]).ToString("#,##0");
}
else
{
lbl.Text = "0";
}
}