private void SetCtrlSetting(int estterm_ref_id, int est_dept_ref_id)
{
Biz_Bsc_Work_Map bizMap = new Biz_Bsc_Work_Map();
//DataSet dsMap = bizMap.GetWorkMapTotalList(estterm_ref_id, est_dept_ref_id);
DataSet dsMap = bizMap.GetWorkMapTotalListHeader_DB(estterm_ref_id, est_dept_ref_id);
if (dsMap.Tables[0].Rows.Count > 0)
{
ltrStgMapVision.Text = dsMap.Tables[0].Rows[0]["DEPT_VISION"].ToString();
ltrStgMapChamp.Text = dsMap.Tables[0].Rows[0]["BSCCHAMPION_NAME"].ToString();
this.IMAP_VERSION_ID = DataTypeUtility.GetToInt32(dsMap.Tables[0].Rows[0]["MAP_VERSION_ID"]);
}
Biz_Bsc_Term_Detail bizTerm = new Biz_Bsc_Term_Detail();
string strYMD = bizTerm.GetReleasedMonth();
this.IYMD = (strYMD == "000000" ? DataTypeUtility.GetToInt32(DateTime.Now.ToString("yyyyMM")) : DataTypeUtility.GetToInt32(strYMD));
SetViewScoreGrid(estterm_ref_id, est_dept_ref_id, this.IYMD);
string view_kpi_str = (ViewKPI) ? "1" : "0";
string url = "../usr/usr_stg_map.aspx?ESTTERM_REF_ID=" + estterm_ref_id.ToString()
+ "&EST_DEPT_REF_ID=" + est_dept_ref_id.ToString()
+ "&MAP_VERSION_ID=" + this.IMAP_VERSION_ID
+ "&TMCODE=" + this.IYMD
+ "&LINE_TYPE=0"
+ "&SHOW_KPI_LIST=" + view_kpi_str
+ "&WORKINGMAPYN=T";
ifm.Attributes.Add("src", Server.UrlDecode(url));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
DoInitControl();
DoBindingMaster();
DoBindingTree();
Biz_Bsc_Term_Detail bizTerm = new Biz_Bsc_Term_Detail();
DataSet dsTerm = bizTerm.GetAllList(IESTTERM_REF_ID);
if (dsTerm.Tables[0].Rows.Count > 0)
{
ITERM_MONTH = dsTerm.Tables[0].Compute("MAX(YMD)", "RELEASE_YN = 'Y'").ToString();
}
if (ITERM_MONTH == "")
{
Biz_Bsc_Map_Info bizMap2 = new Biz_Bsc_Map_Info();
DataSet dsMap2 = bizMap2.GetMapTermList(IESTTERM_REF_ID, IEST_DEPT_REF_ID, IMAP_VERSION_ID);
if (dsMap2.Tables[0].Rows.Count > 0)
{
ITERM_MONTH = dsMap2.Tables[0].Compute("MAX(YMD)", "APPLY_YN = 'Y'").ToString();
}
}
}
ltrScript.Text = "";
}
protected void iBtnSave_Click(object sender, ImageClickEventArgs e)
{
object[] objList = GetSelectKpiList();
Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail();
DataSet dsYear = objTerm.GetTermDetail(ESTTERM_REF_ID);
if (dsYear.Tables[0].Rows.Count < 1)
{
ltrScript.Text = JSHelper.GetAlertScript("평가년도를 확인하세요.");
return;
}
Biz_Bsc_Kpi_Info objMBO = new Biz_Bsc_Kpi_Info();
//if (objMBO.CopyKpiToMbo(ESTTERM_REF_ID
// , objList
// , gUserInfo.Emp_Ref_ID
// , dsYear.Tables[0].Rows[0]["YMD"].ToString().Substring(0, 4)
// , "STG"))
//{
// DoBindingDept();
// DoBinding();
// ltrScript.Text = JSHelper.GetAlertScript("복사를 완료하였습니다.");
//}
//else
//{
// ltrScript.Text = JSHelper.GetAlertScript("복사가 실패하였습니다.");
//}
int checkCount = 0;
for (int i = 0; i < objList.Length; i++)
{
checkCount += new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info().KpiInfoExsistCheckPerson(int.Parse(objList[i].ToString()), gUserInfo.Emp_Ref_ID, ESTTERM_REF_ID);
}
if (checkCount > 0)
{
Response.Write("<script>alert('중복되는 KPI 풀입니다.');</script>");
}
else
{
string returnStr = objMBO.CopyKpiToMbo_NW(ESTTERM_REF_ID
, objList
, gUserInfo.Emp_Ref_ID
, dsYear.Tables[0].Rows[0]["YMD"].ToString().Substring(0, 4)
, "STG");
if (returnStr.Equals(string.Empty))
{
DoBindingDept();
ltrScript.Text = JSHelper.GetAlertOpenerReflashScript("복사를 완료하였습니다.", true);
}
else
{
ltrScript.Text = JSHelper.GetAlertScript(returnStr);
}
}
}
private void SetTermList()
{
Biz_Bsc_Term_Detail objTrm = new Biz_Bsc_Term_Detail();
DataSet rDs = objTrm.GetAllList(PageUtility.GetIntByValueDropDownList(ddlEstTerm));
ugrdTerm.Clear();
ugrdTerm.DataSource = rDs;
ugrdTerm.DataBind();
}
protected void ibtnInsert_Click(object sender, ImageClickEventArgs e)
{
object[] objList = GetSelectKpiList();
Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail();
DataSet dsYear = objTerm.GetTermDetail(PageUtility.GetIntByValueDropDownList(ddlEstTerm));
if (dsYear.Tables[0].Rows.Count < 1)
{
ltrScript.Text = JSHelper.GetAlertScript("평가년도를 확인하세요.");
return;
}
Biz_Bsc_Kpi_Info objMBO = new Biz_Bsc_Kpi_Info();
//if (objMBO.CopyKpiToMbo(PageUtility.GetIntByValueDropDownList(ddlEstTerm)
// , objList
// , gUserInfo.Emp_Ref_ID
// , dsYear.Tables[0].Rows[0]["YMD"].ToString().Substring(0, 4)
// , "STG"))
//{
// DoBindingDept();
// DoBinding();
// ltrScript.Text = JSHelper.GetAlertScript("복사를 완료하였습니다.");
//}
//else
//{
// ltrScript.Text = JSHelper.GetAlertScript("복사가 실패하였습니다.");
//}
string returnStr = objMBO.CopyKpiToMbo_NW(PageUtility.GetIntByValueDropDownList(ddlEstTerm)
, objList
, gUserInfo.Emp_Ref_ID
, dsYear.Tables[0].Rows[0]["YMD"].ToString().Substring(0, 4)
, "STG");
if (returnStr.Equals(string.Empty))
{
DoBindingDept();
DoBinding();
ltrScript.Text = JSHelper.GetAlertScript("복사를 완료하였습니다.");
}
else
{
ltrScript.Text = JSHelper.GetAlertScript(returnStr);
}
}
protected void ibtnInsert2_Click(object sender, ImageClickEventArgs e)
{
object[] objList = GetSelectTeamMboList();
Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail();
DataSet dsYear = objTerm.GetTermDetail(PageUtility.GetIntByValueDropDownList(ddlEstTerm));
if (dsYear.Tables[0].Rows.Count < 1)
{
ltrScript.Text = JSHelper.GetAlertScript("평가년도를 확인하세요.");
return;
}
Biz_Bsc_Kpi_Info objMBO = new Biz_Bsc_Kpi_Info();
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info bizBscKpiInfo = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info();
bool Result = bizBscKpiInfo.CopyKpiToMbo(PageUtility.GetIntByValueDropDownList(ddlEstTerm)
, objList
, gUserInfo.Emp_Ref_ID
, dsYear.Tables[0].Rows[0]["YMD"].ToString().Substring(0, 4)
, "PRS");
/*
* bool Result = objMBO.CopyKpiToMbo(PageUtility.GetIntByValueDropDownList(ddlEstTerm)
* , objList
* , gUserInfo.Emp_Ref_ID
* , dsYear.Tables[0].Rows[0]["YMD"].ToString().Substring(0, 4)
* , "PRS");
*/
if (Result)
{
DoBindingDeptMBO();
DoBinding();
ltrScript.Text = JSHelper.GetAlertScript("복사를 완료하였습니다.");
}
else
{
Response.Write(objMBO.Transaction_Message);
ltrScript.Text = JSHelper.GetAlertScript("복사가 실패하였습니다.");
}
}
/// <summary>
/// 평가기간
/// </summary>
/// <param name="ddl"></param>
public static void BindEstTerm(DropDownList ddl)
{
TermInfos term = new TermInfos();
DataSet ds = term.GetAllList();
ddl.DataSource = ds;
ddl.DataTextField = "ESTTERM_NAME";
ddl.DataValueField = "ESTTERM_REF_ID";
ddl.DataBind();
// 배포되어있는 평가월의 평가기간을 가져온다
Biz_Bsc_Term_Detail objTD = new Biz_Bsc_Term_Detail();
ddl.ClearSelection();
if (ddl.Items.FindByValue(objTD.GetOpenEstTermID().ToString()) != null)
{
ddl.Items.FindByValue(objTD.GetOpenEstTermID().ToString()).Selected = true;
}
}
private void DoBinding()
{
ltEstDeptName.Text = lblSTGMapName.Text = lblChampName.Text = "";
this.IESTTERM_REF_ID = PageUtility.GetIntByValueDropDownList(ddlEstTermInfo);
Biz_Bsc_Work_Map bizMap = new Biz_Bsc_Work_Map();
DataSet dsMap = bizMap.GetWorkMapTotalListHeader_DB(this.IESTTERM_REF_ID, this.IEST_DEPT_REF_ID);
IMAP_VERSION_ID = 1;
if (dsMap.Tables[0].Rows.Count > 0)
{
ltEstDeptName.Text = dsMap.Tables[0].Rows[0]["EST_DEPT_NAME"].ToString();
lblSTGMapName.Text = dsMap.Tables[0].Rows[0]["DEPT_VISION"].ToString();
lblChampName.Text = dsMap.Tables[0].Rows[0]["BSCCHAMPION_NAME"].ToString();
IMAP_VERSION_ID = DataTypeUtility.GetToInt32(dsMap.Tables[0].Rows[0]["MAP_VERSION_ID"]);
}
Biz_Bsc_Term_Detail bizTerm = new Biz_Bsc_Term_Detail();
DataSet dsTerm = bizTerm.GetAllList(IESTTERM_REF_ID);
if (dsTerm.Tables[0].Rows.Count > 0)
{
ITERM_MONTH = dsTerm.Tables[0].Compute("MAX(YMD)", "RELEASE_YN = 'Y'").ToString();
}
if (ITERM_MONTH == "")
{
Biz_Bsc_Map_Info bizMap2 = new Biz_Bsc_Map_Info();
DataSet dsMap2 = bizMap2.GetMapTermList(IESTTERM_REF_ID, IEST_DEPT_REF_ID, IMAP_VERSION_ID);
if (dsMap2.Tables[0].Rows.Count > 0)
{
ITERM_MONTH = dsMap2.Tables[0].Compute("MAX(YMD)", "APPLY_YN = 'Y'").ToString();
}
}
DataSet dsList = bizMap.GetWorkMapTotalList_DB();
ugrdStgList.Clear();
ugrdStgList.DataSource = dsList.Tables[0];
ugrdStgList.DataBind();
}
/// <summary>
/// 생성쿼리 검증
/// </summary>
public void SetQueryValidate()
{
Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail();
string sSYmd = objTerm.GetStartEstMonth();
string sCYmd = objTerm.GetReleasedMonth();
decimal dRtnVal = 0;
string sRtnMsg = "";
bool bIsSuccess = false;
this.IisValidQuery = "Y";
Biz_Bsc_Interface_Kpi_Query objQry = new Biz_Bsc_Interface_Kpi_Query();
// 인터페이스 리스트
DataSet rDs = objQry.GetInterfaceData(txtQUERY_AL.Text, sCYmd, out sRtnMsg, out bIsSuccess);
lblSuccessAl.Text = sRtnMsg;
lblSuccessAl.BackColor = (bIsSuccess) ? Color.WhiteSmoke : Color.Red;
if (!bIsSuccess)
{
this.IisValidQuery = "N";
}
// 당월실적 쿼리결과
dRtnVal = objQry.GetInterfaceResultMs(txtQUERY_MS.Text, sCYmd, out sRtnMsg, out bIsSuccess);
lblSuccessMs.Text = sRtnMsg;
lblSuccessMs.BackColor = (bIsSuccess) ? Color.WhiteSmoke : Color.Red;
if (!bIsSuccess)
{
this.IisValidQuery = "N";
}
// 누적실적 쿼리결과
dRtnVal = objQry.GetInterfaceResultTs(txtQUERY_TS.Text, sSYmd, sCYmd, out sRtnMsg, out bIsSuccess);
lblSuccessTs.Text = sRtnMsg;
lblSuccessTs.BackColor = (bIsSuccess) ? Color.WhiteSmoke : Color.Red;
if (!bIsSuccess)
{
this.IisValidQuery = "N";
}
}
public void SetPreviewGrid()
{
Biz_Bsc_Interface_Column objCol = new Biz_Bsc_Interface_Column();
DataSet rDs = objCol.GetAllList(this.IDiCode, gUserInfo.Emp_Ref_ID);
int iRow = 0;
string sUseYn = "N";
string sColKey = "";
string sColName = "";
int iDPoints = 0;
int iGridWith = 0;
UltraGridColumn ugCol;
if (rDs.Tables.Count > 0)
{
iRow = rDs.Tables[0].Rows.Count;
if (iRow > 0)
{
ugCol = new UltraGridColumn();
ugCol.Key = "YMD";
ugCol.BaseColumnName = "YMD";
ugCol.Header.Caption = "평가월";
ugCol.Width = Unit.Pixel(50);
ugCol.AllowUpdate = AllowUpdate.No;
ugCol.DataType = "System.String";
ugCol.CellStyle.HorizontalAlign = HorizontalAlign.Center;
ugrdPreview.Columns.Add(ugCol);
ugCol = new UltraGridColumn();
ugCol.Key = "DD";
ugCol.BaseColumnName = "DD";
ugCol.Header.Caption = "발생일자";
ugCol.Width = Unit.Pixel(35);
ugCol.AllowUpdate = AllowUpdate.Yes;
ugCol.DataType = "System.String";
ugCol.Header.Style.Wrap = true;
ugCol.CellStyle.HorizontalAlign = HorizontalAlign.Center;
ugrdPreview.Columns.Add(ugCol);
for (int i = 0; i < iRow; i++)
{
sUseYn = rDs.Tables[0].Rows[i]["USE_YN"].ToString();
sColKey = rDs.Tables[0].Rows[i]["COLUMN_ID"].ToString();
sColName = rDs.Tables[0].Rows[i]["COLUMN_ALIAS"].ToString();
iDPoints = Convert.ToInt32(rDs.Tables[0].Rows[i]["DECIMAL_POINTS"].ToString());
iGridWith = Convert.ToInt32(rDs.Tables[0].Rows[i]["GRID_WIDTH"].ToString());
if (sUseYn == "Y")
{
if (sColKey.Substring(0, 7) == "SVALUES")
{
ugCol = new UltraGridColumn();
ugCol.Key = sColKey;
ugCol.BaseColumnName = sColKey;
ugCol.Header.Caption = sColName;
ugCol.Width = Unit.Pixel(iGridWith);
ugCol.DataType = "System.String";
ugCol.AllowUpdate = AllowUpdate.Yes;
ugCol.CellStyle.HorizontalAlign = HorizontalAlign.Left;
ugrdPreview.Columns.Add(ugCol);
}
else
{
ugCol = new UltraGridColumn();
ugCol.Key = sColKey;
ugCol.BaseColumnName = sColKey;
ugCol.Header.Caption = sColName;
ugCol.Width = Unit.Pixel(iGridWith);
ugCol.AllowUpdate = AllowUpdate.Yes;
ugCol.DataType = "System.Double";
ugCol.Format = "#,###,###,###,###,###,###,##0" + this.GetFormatPoints(iDPoints);
ugCol.CellStyle.HorizontalAlign = HorizontalAlign.Right;
ugrdPreview.Columns.Add(ugCol);
}
}
}
}
}
Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail();
string sEstMon = objTerm.GetReleasedMonth();
Random rndObj = new Random();
for (int i = 0; i < 11; i++)
{
ugrdPreview.Rows.Add();
for (int j = 0; j < ugrdPreview.Columns.Count; j++)
{
if (ugrdPreview.Columns[j].DataType == "System.String")
{
if (ugrdPreview.Columns[j].Key == "YMD")
{
ugrdPreview.Rows[i].Cells.FromKey(ugrdPreview.Columns[j].Key).Value = sEstMon;
}
else if (ugrdPreview.Columns[j].Key == "DD")
{
ugrdPreview.Rows[i].Cells.FromKey(ugrdPreview.Columns[j].Key).Value = Convert.ToString(rndObj.Next(1, 31)).PadLeft(2, '0');
}
else
{
ugrdPreview.Rows[i].Cells.FromKey(ugrdPreview.Columns[j].Key).Value = "String" + i.ToString();
}
}
else if (ugrdPreview.Columns[j].DataType == "System.Date")
{
ugrdPreview.Rows[i].Cells.FromKey(ugrdPreview.Columns[j].Key).Value = DateTime.Now;
}
else if (ugrdPreview.Columns[j].DataType == "System.Double")
{
ugrdPreview.Rows[i].Cells.FromKey(ugrdPreview.Columns[j].Key).Value = rndObj.NextDouble() * rndObj.Next(1000, 1000000);
}
}
}
ugrdPreview.Visible = true;
}
protected void iBtnSave_Click(object sender, ImageClickEventArgs e)
{
object[] objList = GetSelectKpiList(UltraWebGrid2);
Biz_Bsc_Term_Detail objTerm = new Biz_Bsc_Term_Detail();
DataSet dsYear = objTerm.GetTermDetail(ESTTERM_REF_ID);
if (dsYear.Tables[0].Rows.Count < 1)
{
ltrScript.Text = JSHelper.GetAlertScript("평가년도를 확인하세요.");
return;
}
string result_measurement_step = "LV5";
MicroBSC.Biz.Common.Biz.Biz_Com_Code_Info bizComCodeInfo = new MicroBSC.Biz.Common.Biz.Biz_Com_Code_Info();
DataTable dtComCodeInfo = bizComCodeInfo.getCheckStep(0).Tables[0];
DataRow[] rows = dtComCodeInfo.Select(" USE_YN = 'Y' ", "SORT_ORDER DESC");
if (rows.Length > 0)
{
result_measurement_step = DataTypeUtility.GetValue(rows[0]["ETC_CODE"]);
}
int unit_type_ref_id = 1;
MicroBSC.Biz.Common.Biz.Biz_Com_Unit_Type_Info bizComUnitTypeInfo = new MicroBSC.Biz.Common.Biz.Biz_Com_Unit_Type_Info();
DataTable dtComUnitTypeInfo = bizComUnitTypeInfo.GetAllList().Tables[0];
if (dtComUnitTypeInfo.Rows.Count > 0)
{
unit_type_ref_id = DataTypeUtility.GetToInt32(dtComUnitTypeInfo.Rows[0]["UNIT_TYPE_REF_ID"]);
}
Biz_Bsc_Threshold_Step bizBscThresholdStep = new Biz_Bsc_Threshold_Step();
DataTable dtBscThresholdStep = bizBscThresholdStep.GetThresholdLevelList(result_measurement_step).Tables[0];
int checkCount = 0;
for (int i = 0; i < objList.Length; i++)
{
checkCount += new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info().KpiInfoExsistCheckPerson(int.Parse(objList[i].ToString()), gUserInfo.Emp_Ref_ID, ESTTERM_REF_ID);
}
if (checkCount > 0)
{
Response.Write("<script>alert('중복되는 KPI 풀입니다.');</script>");
}
else
{
MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info bizBscKpiInfo = new MicroBSC.Integration.BSC.Biz.Biz_Bsc_Kpi_Info();
string returnStr = bizBscKpiInfo.CopyKpiToMboUsingTemplete(ESTTERM_REF_ID
, objList
, TEMPLETE_ID
, TEMPLETE_NAME
, gUserInfo.Emp_Ref_ID
, DateTime.Now.ToString("yyyy-MM-dd")
, result_measurement_step
, unit_type_ref_id
, "PRS"
, dtBscThresholdStep);
if (returnStr.Equals(string.Empty))
{
DoBindingTemplete();
ltrScript.Text = JSHelper.GetAlertOpenerReflashScript("복사를 완료하였습니다.", true);
}
else
{
ltrScript.Text = JSHelper.GetAlertScript(returnStr);
}
}
}
