private void DataListBinding_P()
{
Biz_QuestionObjects questionObjects = new Biz_QuestionObjects(EST_ID, Q_OBJ_ID);
Q_OBJ_NAME = questionObjects.Q_Obj_Name;
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.Length > 0)
{
DefineDataBinding_P(q_dfn_ids);
}
NoDefineDataBinding_P(ds);
}
protected void UltraWebGrid1_InitializeRow(object sender, RowEventArgs e)
{
DataRowView dr = (DataRowView)e.Data;
Biz_QuestionObjects questionObjects = new Biz_QuestionObjects(hdfSearchEstID.Value, dr["Q_OBJ_ID"].ToString());
e.Row.Cells.FromKey("Q_OBJ_NAME").Value = questionObjects.Q_Obj_Name;
e.Row.Cells.FromKey("Q_OBJ_TITLE").Value = questionObjects.Q_Obj_Title;
}
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);
}
public static void BindQuestionObject(DropDownList ddl, string strEstID, bool isBlank)
{
Biz_QuestionObjects questionObject = new Biz_QuestionObjects();
ddl.DataSource = questionObject.GetQuestionObjects(strEstID);
ddl.DataTextField = "Q_OBJ_NAME";
ddl.DataValueField = "Q_OBJ_ID";
ddl.DataBind();
if (isBlank)
{
ListItem itemA = new ListItem("----------", "");
ddl.Items.Insert(0, itemA);
}
}
private void DataListBinding()
{
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);
//POINT_ORG = Math.Round(TOTALPOINT * 0.01, 2);
POINT_ORG = Math.Round(TOTALPOINT / 3, 1);
if (POINT_ORG == 0)
{
ltrTotalPoint.Text = "미평가";
}
else
{
ltrTotalPoint.Text = POINT_ORG.ToString("###.0") + " / 100";
}
}
protected void ibnCopyQObj_Click(object sender, ImageClickEventArgs e)
{
Biz_QuestionObjects questionObj = new Biz_QuestionObjects();
DataTable dataTable = questionObj.GetDataTableSchema();
dataTable = UltraGridUtility.GetDataTableByCheckValue(UltraWebGrid1
, "cBox"
, "selchk"
, new string[] { "Q_OBJ_ID" }
, dataTable);
if (dataTable.Rows.Count == 0)
{
ltrScript.Text = JSHelper.GetAlertScript("복사하려는 질의가 없습니다.");
return;
}
foreach (DataRow dataRow in dataTable.Rows)
{
dataRow["EST_ID"] = hdfSearchEstID.Value;
dataRow["DATE"] = DateTime.Now;
dataRow["USER"] = EMP_REF_ID;
}
bool isOK = questionObj.CopyQuestionObject(dataTable);
if (isOK)
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 질의 그룹이 복사되었습니다.");
BindGrid(hdfSearchEstID.Value);
}
else
{
ltrScript.Text = JSHelper.GetAlertScript("정상적으로 복사되지 않았습니다.");
}
}
protected void UltraWebGrid1_InitializeRow(object sender, Infragistics.WebUI.UltraWebGrid.RowEventArgs e)
{
DataRowView dr = (DataRowView)e.Data;
string empId = e.Row.Cells.FromKey("EMP_REF_ID").Value.ToString();
string empName = e.Row.Cells.FromKey("EMP_NAME").Value.ToString();
Biz_QuestionObjects questionObjects = new Biz_QuestionObjects("", DataTypeUtility.GetString(e.Row.Cells.FromKey("Q_OBJ_ID").Value));
e.Row.Cells.FromKey("Q_OBJ_NAME").Value = questionObjects.Q_Obj_Name;
CheckBox chk;
UltraGridRow row;
TemplatedColumn col;
row = e.Row;
col = (TemplatedColumn)row.Band.Columns.FromKey("selchk");
chk = (CheckBox)((CellItem)col.CellItems[row.BandIndex]).FindControl("cBox");
if (dr["ENABLED"].ToString().Equals("0"))
{
chk.Enabled = false;
}
}
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";
}
}
