private void SetFormData(int est_ref_id)
{
this.IEstTermRefID = PageUtility.GetIntByValueDropDownList(ddlEstTermInfo);
this.strYMD = PageUtility.GetByValueDropDownList(ddlEstTermMonth);
Biz_Bsc_Map_Info objMap = new Biz_Bsc_Map_Info(this.IEstTermRefID, est_ref_id, this.strYMD);
this.IMapVersionID = objMap.Imap_version_id;
ltEstDeptName.Text = objMap.Iest_dept_name;
lblChampName.Text = objMap.Ibscchampion_name;
lblSTGMapName.Text = objMap.Idept_vision;
Biz_Bsc_Map_Kpi objKpi = new Biz_Bsc_Map_Kpi();
DataSet rDs = objKpi.GetWeightPerStg(this.IEstTermRefID, est_ref_id, this.strYMD);
if (rDs.Tables.Count > 0)
{
if (rDs.Tables[0].Rows.Count > 0)
{
rDs.Tables[0].Columns.Add("PARENT_STG", typeof(string));
Biz_Bsc_Map_Stg_Parent objPrt = new Biz_Bsc_Map_Stg_Parent();
int iRow = rDs.Tables[0].Rows.Count;
string sUpStg = "";
for (int i = 0; i < iRow; i++)
{
objPrt.Iestterm_ref_id = int.Parse(rDs.Tables[0].Rows[i]["ESTTERM_REF_ID"].ToString());
objPrt.Iest_dept_ref_id = int.Parse(rDs.Tables[0].Rows[i]["EST_DEPT_REF_ID"].ToString());
objPrt.Imap_version_id = int.Parse(rDs.Tables[0].Rows[i]["MAP_VERSION_ID"].ToString());
objPrt.Istg_ref_id = int.Parse(rDs.Tables[0].Rows[i]["STG_REF_ID"].ToString());
DataSet pDs = objPrt.GetParentStgList
(objPrt.Iestterm_ref_id
, objPrt.Iest_dept_ref_id
, objPrt.Imap_version_id
, objPrt.Istg_ref_id);
sUpStg = "";
if (pDs.Tables.Count > 0)
{
for (int k = 0; k < pDs.Tables[0].Rows.Count; k++)
{
sUpStg += (k == 0) ? pDs.Tables[0].Rows[k]["UP_STG_REF_ID"].ToString()
: "," + pDs.Tables[0].Rows[k]["UP_STG_REF_ID"].ToString();
}
}
rDs.Tables[0].Rows[i]["PARENT_STG"] = sUpStg;
}
}
}
ugrdStgList.Clear();
ugrdStgList.DataSource = rDs;
ugrdStgList.DataBind();
}
public int Add_BSC_MAP_STG_MANUAL(int estterm_ref_id
, int est_dept_ref_id
, string ymd
, string st_up_tbl_id
, string st_tbl_id
, string ed_up_tbl_id
, string ed_tbl_id
, string[] arrX1
, string[] arrY1
, string[] arrX2
, string[] arrY2
, int create_user
, DateTime create_date
, int map_version_id)
{
int okCnt = 0;
IDbConnection conn = DbAgentHelper.CreateDbConnection();
conn.Open();
IDbTransaction trx = conn.BeginTransaction();
MicroBSC.BSC.Biz.Biz_Bsc_Map_Stg_Parent objPrt = new Biz_Bsc_Map_Stg_Parent();
MicroBSC.BSC.Biz.Biz_Bsc_Map_Kpi objKpi = new Biz_Bsc_Map_Kpi();
try
{
DataSet ds = base.Select(conn
, trx
, estterm_ref_id
, est_dept_ref_id
, ymd
, st_up_tbl_id
, st_tbl_id
, ed_up_tbl_id
, ed_tbl_id);
if (ds.Tables[0].Rows.Count > 0)
{
base.Delete(conn
, trx
, estterm_ref_id
, est_dept_ref_id
, ymd
, st_up_tbl_id
, st_tbl_id
, ed_up_tbl_id
, ed_tbl_id);
}
for (int i = 0; i < arrX1.Length; i++)
{
if (arrX1[i] == arrX2[i] && arrY1[i] == arrY2[i])
{
}
else
{
int seq = base.NewSeq(conn
, trx
, estterm_ref_id
, est_dept_ref_id
, ymd
, st_up_tbl_id
, st_tbl_id
, ed_up_tbl_id
, ed_tbl_id);
okCnt += base.Insert(conn
, trx
, seq
, estterm_ref_id
, est_dept_ref_id
, ymd
, st_up_tbl_id
, st_tbl_id
, ed_up_tbl_id
, ed_tbl_id
, arrX1[i]
, arrY1[i]
, arrX2[i]
, arrY2[i]
, create_user
, DateTime.Now);
}
}
if (okCnt > 0)
{
string[] stg_ref_id = st_tbl_id.Split('_');
string[] up_stg_ref_id = ed_tbl_id.Split('_');
Biz_Bsc_Map_Stg_Parent bizBsc_Map_Stg_Parent = new Biz_Bsc_Map_Stg_Parent();
bizBsc_Map_Stg_Parent.InsertData(conn
, trx
, estterm_ref_id
, est_dept_ref_id
, map_version_id
, DataTypeUtility.GetToInt32(stg_ref_id[1])
, DataTypeUtility.GetToInt32(up_stg_ref_id[1])
, DataTypeUtility.GetToInt32(create_user));
}
base.Transaction_Message = "정상적으로 처리되었습니다.";
base.Transaction_Result = "Y";
trx.Commit();
}
catch (Exception e)
{
base.Transaction_Message = e.Message;
base.Transaction_Result = "N";
trx.Rollback();
okCnt = 0;
}
finally
{
conn.Close();
}
return(okCnt);
}
