protected void grdList_ItemCommand(object sender, C1CommandEventArgs e)
{
try
{
if (e.CommandName == "Excel")
{
//string[] xParams = new string[6];
//DataTable xDt = new DataTable();
//xDt.Columns.Add("open_course_id");
////O.COURSE_ID ||'^'|| O.OPEN_COURSE_ID
//DataRow xRow = xDt.NewRow();
//xRow["open_course_id"] = Util.Split(grdList.DataKeys[e.Item.ItemIndex].ToString(), "^", 2)[1];
//xDt.Rows.Add(xRow);
//int xEduCnt = 0;
//string xHtml = "";
//DataSet xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md",
// "GetEduApprovalExcel",
// LMS_SYSTEM.APPLICATION,
// "CLT.WEB.UI.APPLICATION",
// (object)xParams,
// xDt);
//xHtml = "<table border='1'>";
//for (int i = 0; i < xDs.Tables.Count; i++)
//{
// if (xDs.Tables[i].Rows.Count > 0)
// {
// xHtml += "<tr style='text-align:center;font-weight:bold;'><td style='background-color:#ddd;'>주민등록번호</td><td style='background-color:#ddd;'>훈련생구분</td><td style='background-color:#ddd;'>성명</td><td style='background-color:#ddd;'>비용수급사업장번호</td><td style='background-color:#ddd;'>최종학력</td><td style='background-color:#ddd;'>비정규직구분</td><td style='background-color:#ddd;'>기숙사사용여부</td><td style='background-color:#ddd;'>식비사용여부</td><td style='background-color:#ddd;'>훈련구분</td><td style='background-color:#ddd;'>대체인력</td></tr>";
// for (int j = 0; j < xDs.Tables[i].Rows.Count; j++)
// {
// xEduCnt++;
// DataRow xRowTable = xDs.Tables[i].Rows[j];
// xHtml += "<tr><td style='text-align:center'>" + Convert.ToString(xRowTable["PERSONAL_NO"]) + "</td><td style='text-align:center'>" + Convert.ToString(xRowTable["T_TRAINEE_CLASS"]) + "</td><td style='text-align:center'>" + Convert.ToString(xRowTable["USER_NM_KOR"]) + "</td><td style='text-align:center'>" + Convert.ToString(xRowTable["TAX_NO"]) + "</td><td style='text-align:center'> 1 </td><td style='text-align:center'> " + Convert.ToString(xRowTable["C_TRAINEE_CLASS"]) + " </td><td style='text-align:center'>N</td><td style='text-align:center'>Y</td><td>" + Convert.ToString(xRowTable["COURSE_TYPE"]) + "</td><td></td></tr>";
// }
// }
//}
//xHtml += "</table>";
//if (xEduCnt == 0)
// ScriptHelper.Page_Alert(this, CLT.WEB.UI.COMMON.BASE.MsgInfo.GetMsg("A062", new string[] { "자료" }, new string[] { "Data" }, System.Threading.Thread.CurrentThread.CurrentCulture));
//else
// this.GetExcelFileHtml(xHtml);
string[] xParams = new string[6];
DataTable xDt = new DataTable();
xDt.Columns.Add("open_course_id");
//O.COURSE_ID ||'^'|| O.OPEN_COURSE_ID
DataRow xRow = xDt.NewRow();
xRow["open_course_id"] = Util.Split(grdList.DataKeys[e.Item.ItemIndex].ToString(), "^", 2)[1];
xDt.Rows.Add(xRow);
DataSet xDs = SBROKER.GetDataSet("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md",
"GetEduApprovalExcel",
LMS_SYSTEM.APPLICATION,
"CLT.WEB.UI.LMS.APPLICATION",
(object)xParams,
xDt);
DataTable xDtReturn = xDs.Tables[0];
int xColumnCnt = 10;
string[] xExcelHeader = new string[xColumnCnt];
if (this.IsSettingKorean())
{
xExcelHeader[0] = "주민등록번호";
xExcelHeader[1] = "훈련생구분";
xExcelHeader[2] = "성명";
xExcelHeader[3] = "비용수급사업장번호";
xExcelHeader[4] = "최종학력";
xExcelHeader[5] = "비정규직구분";
xExcelHeader[6] = "기숙사사용여부";
xExcelHeader[7] = "식비사용여부";
xExcelHeader[8] = "훈련구분";
xExcelHeader[9] = "대체인력";
}
string[] xDtHeader = new string[xColumnCnt];
xDtHeader[0] = "PERSONAL_NO";
xDtHeader[1] = "T_TRAINEE_CLASS";
xDtHeader[2] = "USER_NM_KOR";
xDtHeader[3] = "EMPOLY_INS_NO";
xDtHeader[4] = "LAST_SCHOOL";
xDtHeader[5] = "C_TRAINEE_CLASS";
xDtHeader[6] = "IS_DORMITORY";
xDtHeader[7] = "IS_MEALS";
xDtHeader[8] = "COURSE_TYPE";
xDtHeader[9] = "IS_SUBSTITUTE";
this.GetExcelFile(xDtReturn, xExcelHeader, xDtHeader, "0");
}
}
catch (Exception ex)
{
base.NotifyError(ex);
}
}
protected void grdUserList_ItemCommand(object sender, C1CommandEventArgs e)
{
try
{
if (iAppCD == "edu_user")
{
if (e.CommandName == "UserId")
{
int xCntSel = 0;
DataTable xDt = new DataTable();
xDt.Columns.Add("keys");
xDt.Columns.Add("confirm");
xDt.Columns.Add("non_approval_cd");
xDt.Columns.Add("non_approval_remark");
// R.COURSE_ID || '^' || R.OPEN_COURSE_ID || '^' || U.USER_ID||'^'|| R.COURSE_RESULT_SEQ
DataRow xRow = xDt.NewRow();
xRow["keys"] = iSearch + "^" + grdUserList.DataKeys[e.Item.ItemIndex].ToString();
xRow["confirm"] = "1";
xRow["non_approval_cd"] = "";
xRow["non_approval_remark"] = "";
xDt.Rows.Add(xRow);
string xRtn = SBROKER.GetString("CLT.WEB.BIZ.LMS.EDUM.vp_a_edumng_md",
"SetEduList",
LMS_SYSTEM.MANAGE,
"CLT.WEB.UI.LMS.APPR",
xDt, "");
if (xRtn.ToUpper() == "TRUE")
{
ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A001", new string[] { "교육대상자 선발" }, new string[] { "Educational object selection" }, Thread.CurrentThread.CurrentCulture));
}
else
{
ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A101", new string[] { "관리자" }, new string[] { "Administrator" }, Thread.CurrentThread.CurrentCulture));
}
}
}
else
{
if (e.CommandName == "UserId")
{
bool xIsSave = true;
if (iAppCD == "appr")
{
string[] xParams = new string[1];
xParams[0] = grdUserList.DataKeys[e.Item.ItemIndex].ToString();
//승선여부 체크
DataTable xDt = SBROKER.GetTable("CLT.WEB.BIZ.LMS.COMMON.vp_l_common_md",
"GetVHOrderdetKind",
LMS_SYSTEM.MANAGE,
"CLT.WEB.UI.LMS.APPR",
(object)xParams);
bool isOrderKind = false;
if (xDt.Rows.Count > 0)
{
//'AF6','AN2','AH6', 승선,복직,파견면 일때 승선
if (Convert.ToString(xDt.Rows[0]["ORD_KIND"]) == "AF6" || Convert.ToString(xDt.Rows[0]["ORD_KIND"]) == "AN2" || Convert.ToString(xDt.Rows[0]["ORD_KIND"]) == "AH6")
{
isOrderKind = true;
}
}
/*사용자 요청 - 승선한 사람도 역량평가 가능하도록 2013.03.19 Seo.jw*/
/*
* if (isOrderKind)
* {
* ScriptHelper.Page_Alert(this.Page, MsgInfo.GetMsg("A127",
* new string[] { "" },
* new string[] { "" },
* Thread.CurrentThread.CurrentCulture
* ));
* xIsSave = false;
* }
* else
* {
* //승선이 아닐때
*
* xIsSave = true;
* }
*/
xIsSave = true;
}
if (xIsSave)
{
string[] iBindControls = Util.Split(iBindControl, "^", 5);
string xCtlUserId = iBindControls[0];
string xCtlUserNMKor = iBindControls[1];
string xCtlAppDutyStep = iBindControls[2];
string xCtlPersonalNo = iBindControls[3];
string xCtlShipCode = iBindControls[4];
string[] xUsers = Util.Split(e.CommandArgument.ToString(), "^", 6);
ScriptHelper.ScriptStartup(this.Page, Guid.NewGuid().ToString(), "<script>SetUserId('" + xUsers[0] + "','" + xUsers[1] + "','" + xUsers[2] + "','" + xUsers[3] + "','" + xUsers[4] + "','" + xUsers[5] + "','" + xCtlUserId + "','" + xCtlUserNMKor + "','" + xCtlAppDutyStep + "','" + xCtlPersonalNo + "','" + xCtlShipCode + "');</script>");
}
}
}
}
catch (Exception ex)
{
base.NotifyError(ex);
}
}
