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); } }