protected void Page_Load(object sender, EventArgs e) { // 로그인 체크 check login EmployeeInfo loginEmployee = new EmployeeInfo(); VisitData bllVisit = new VisitData(); TakeOutData bllTakeOut = new TakeOutData(); loginEmployee = (EmployeeInfo)Session["loginMember"]; if (loginEmployee == null) { Response.Redirect("~/login.aspx", true); } if (loginEmployee.ManagerLevel < 1) { Response.Redirect("~/login.aspx", true); } if (Request.QueryString["mode"].Equals("takeOut")) { int result = bllTakeOut.updateApprove(Request.QueryString["takeOutDataCode"], Request.QueryString["status"], ""); Page.RegisterClientScriptBlock("alert", JavaScriptBuilder.alert("Đã hoàn thành (처리 하였습니다).", "takeOutDataList.aspx?keyWord=" + Request.QueryString["keyWord"] + "&key=" + Request.QueryString["key"])); } else if (Request.QueryString["mode"].Equals("visit")) { int result = bllVisit.updateApprove(Request.QueryString["visitDataCode"], Request.QueryString["status"], ""); Page.RegisterClientScriptBlock("alert", JavaScriptBuilder.alert("Đã hoàn thành (처리 하였습니다).", "visitDataList.aspx?keyWord=" + Request.QueryString["keyWord"] + "&key=" + Request.QueryString["key"] + "&page=" + Request.QueryString["page"])); } }
protected void Page_Load(object sender, EventArgs e) { TakeOutData bll = new TakeOutData(); bll.DeleteUserFile(Request.QueryString["takeOutDataCode"], Request.QueryString["fileNumber"], Request.QueryString["fileName"]); Response.Redirect("inputTakeOut.aspx?takeOutDataCode=" + Request.QueryString["takeOutDataCode"] + "&mode=modify"); }
protected void Page_Load(object sender, EventArgs e) { TakeOutData blltakeOutData = new TakeOutData(); TakeOutItemData bllTakeOutItemData = new TakeOutItemData(); List <TakeOutItemDataInfo> list = bllTakeOutItemData.selectTakeOutItemDataList(Request.QueryString["takeOutDataCode"]); for (int i = 0; i < list.Count; i++) { TakeOutItemDataInfo item = (TakeOutItemDataInfo)list[i]; int resultDel = bllTakeOutItemData.deleteTakeOutItemData(item); } TakeOutDataInfo takeOutDataInfo = new TakeOutDataInfo(); takeOutDataInfo.TakeOutDataCode = Request.QueryString["takeOutDataCode"]; int result = blltakeOutData.deleteTakeOutData(takeOutDataInfo); Page.RegisterClientScriptBlock("alert", JavaScriptBuilder.alert("đã xóa (삭제 하였습니다).", "listTakeOut.aspx")); }
//private String filepath; //private String filename; protected void Page_Load(object sender, EventArgs e) { bllTakeOutData = new TakeOutData(); bllTakeOutItemData = new TakeOutItemData(); bllVisitData = new VisitData(); String takeOutDataCode; // 반출 번호 mã ra ngoài // 로그인 체크 check login EmployeeInfo loginEmployee = new EmployeeInfo(); loginEmployee = (EmployeeInfo)Session["loginMember"]; if (loginEmployee == null) { Response.Redirect("~/login.aspx", true); } if (Page.IsPostBack) { //Createfolder(); // 2021-03-26 Nguyen Van An: file upload #region 일 업로드 String userFileMimeType1 = String.Empty; String userFileMimeType2 = String.Empty; String userFileMimeType3 = String.Empty; String userFileName1 = String.Empty; String userFileName2 = String.Empty; String userFileName3 = String.Empty; String userFileByte1 = String.Empty; String userFileByte2 = String.Empty; String userFileByte3 = String.Empty; String userFileDBName1 = String.Empty; String userFileDBName2 = String.Empty; String userFileDBName3 = String.Empty; String separator = "|"; // String fileUploadDir = ConfigurationManager.AppSettings["fileUploadPath"]; string[] arrFileName; string ext; if (userFile1.HasFile && checkfile(userFile1.FileName)) { //arrFileName = userFile1.FileName.Split('.'); //ext = arrFileName[arrFileName.Length - 1].ToLower(); //userFileName1 = HanaMicron.COMS.Utility.StringUtil.ReplaceSpecial(userFile1.FileName.Replace("." + ext, "")) + "." + ext; //String savePath1 = fileUploadDir + "\\" + (userFileName1); //userFileMimeType1 = userFile1.PostedFile.ContentType; //userFileByte1 = userFile1.PostedFile.ContentLength.ToString(); //userFile1.SaveAs(savePath1); // userFileDBName1 = userFileName1 ; String filename1 = DateTime.Now.ToString("yyyyMMdd_hhmmss_") + userFile1.FileName; String filepath = MapPath("~/image/" + filename1); userFile1.SaveAs(filepath); userFileDBName1 = filename1; } if (userFile2.HasFile && checkfile(userFile2.FileName)) { //arrFileName = userFile2.FileName.Split('.'); //ext = arrFileName[arrFileName.Length - 1].ToLower(); //userFileName2 = HanaMicron.COMS.Utility.StringUtil.ReplaceSpecial(userFile2.FileName.Replace("." + ext, "")) + "." + ext; //userFileMimeType2 = userFile2.PostedFile.ContentType; //userFileByte2 = userFile2.PostedFile.ContentLength.ToString(); //String savePath2 = fileUploadDir + "\\" + userFileName2; //userFile2.SaveAs(savePath2); //userFileDBName2 = userFileName2 + separator + userFileMimeType2 + separator + userFileByte2; String filename2 = DateTime.Now.ToString("yyyyMMdd_hhmmss_") + userFile2.FileName; String filepath = MapPath("~/image/" + filename2); userFile2.SaveAs(filepath); userFileDBName2 = filename2; } if (userFile3.HasFile && checkfile(userFile3.FileName)) { //arrFileName = userFile3.FileName.Split('.'); //ext = arrFileName[arrFileName.Length - 1].ToLower(); //userFileName3 = HanaMicron.COMS.Utility.StringUtil.ReplaceSpecial(userFile3.FileName.Replace("." + ext, "")) + "." + ext; //userFileMimeType3 = userFile3.PostedFile.ContentType; //userFileByte3 = userFile3.PostedFile.ContentLength.ToString(); //String savePath3 = fileUploadDir + "\\" + userFileName3; //userFile3.SaveAs(savePath3); //userFileDBName3 = userFileName3 ; String filename3 = DateTime.Now.ToString("yyyyMMdd_hhmmss_") + userFile3.FileName; String filepath = MapPath("~/image/" + filename3); userFile3.SaveAs(filepath); userFileDBName3 = filename3; } #endregion // 반출 정보 Data 만들기 tạo data thông tin ra ngoài TakeOutDataInfo takeOutDataInfo = new TakeOutDataInfo(); takeOutDataInfo.CompanyCode = Convert.ToInt32(Request["companyCode"]); takeOutDataInfo.RecieveName = Request["recieveName"]; takeOutDataInfo.RequestUserCode = loginEmployee.Upnid; takeOutDataInfo.RequireIN = Convert.ToInt32(Request["requireIN"]); //반입 필 여부 có/ không cần vào takeOutDataInfo.ObjectContents = Request["objectContents"]; //반입필 일 경우만 반입예정일 입력 if (takeOutDataInfo.RequireIN == 1) { takeOutDataInfo.ScheduleInDate = Request["scheduleInDate"]; } takeOutDataInfo.ScheduleOutDate = Request["scheduleOutDate"]; takeOutDataInfo.CarCode = Convert.ToInt32(Request["carCode"]); takeOutDataInfo.TakeOutStateCode = 0; takeOutDataInfo.TakeOutObjectCode = Convert.ToInt32(takeOutObjectCode.SelectedValue); //takeOutDataInfo.ApprovalUserCode = Request["approvalUserCode"]; takeOutDataInfo.TakeOutPathEndCode = Convert.ToInt32(takeOutPathEnd.SelectedValue); takeOutDataInfo.TakeOutPathStartCode = Convert.ToInt32(takeOutPathStart.SelectedValue); takeOutDataInfo.Note = Request["note"]; //반입불가 일때만 반입불가사유 입력 (수정시에도 해당됨) if (takeOutDataInfo.RequireIN == 2) { takeOutDataInfo.DisApprovalCategoryCode = Convert.ToInt32(disApprovalCategoryCode.SelectedValue); } takeOutDataInfo.DisApprovalCategoryDetail = Request["disApprovalCategoryDetail"]; takeOutDataInfo.ElecApproveCode = Request["elecApproveCode"]; // 신규 if (Request.QueryString["mode"].Equals("write")) { // 반출 번호 만들기 (물품 저장 될것을 위해서) takeOutDataCode = bllTakeOutData.selectNextTakeOutDataCode(); takeOutDataInfo.TakeOutDataCode = takeOutDataCode; takeOutDataInfo.ApprovalState = 0; takeOutDataInfo.UserFile1 = userFileDBName1; takeOutDataInfo.UserFile2 = userFileDBName2; takeOutDataInfo.UserFile3 = userFileDBName3; int result = bllTakeOutData.insertTakeOutData(takeOutDataInfo); } // 수정 else { takeOutDataCode = Request["takeOutDataCode"]; TakeOutDataInfo oldData = bllTakeOutData.selectTakeOutData(Request.QueryString["takeOutDataCode"]); takeOutDataInfo.TakeOutDataCode = takeOutDataCode; takeOutDataInfo.ApprovalState = 0; //takeOutDataInfo.TakeOutItemDataList[0].TakeOutTime = oldData.TakeOutItemDataList[0].TakeOutTime; //takeOutDataInfo.TakeOutItemDataList[0].TakeINTime = oldData.TakeOutItemDataList[0].TakeINTime; //takeOutDataInfo.ApproveTime = oldData.ApproveTime; takeOutDataInfo.ElecApproveCode = oldData.ElecApproveCode; if (!String.IsNullOrEmpty(userFileName1)) { takeOutDataInfo.UserFile1 = userFileDBName1; } if (!String.IsNullOrEmpty(userFileName2)) { takeOutDataInfo.UserFile2 = userFileDBName2; } if (!String.IsNullOrEmpty(userFileName3)) { takeOutDataInfo.UserFile3 = userFileDBName3; } int result = bllTakeOutData.updateTakeOutData(takeOutDataInfo); // 이전 물품 삭제 List <TakeOutItemDataInfo> takeOutItemList = bllTakeOutItemData.selectTakeOutItemDataList(oldData.TakeOutDataCode); for (int i = 0; i < takeOutItemList.Count; i++) { TakeOutItemDataInfo obj = (TakeOutItemDataInfo)takeOutItemList[i]; int resultDelete = bllTakeOutItemData.deleteTakeOutItemData(obj); } } // 반출 물품 정보 넣기 String subTakeOutItemCategoryCodes = Request["subTakeOutItemCategoryCodes"]; String[] arrSubTakeOutItemCategoryCode = subTakeOutItemCategoryCodes.Split(','); String takeOutItemNames = Request["takeOutItemNames"]; String[] arrTakeOutItemNames = takeOutItemNames.Split(','); String takeOutItemNameTypes = Request["takeOutItemNameTypes"]; String[] arrTakeOutItemNameTypes = takeOutItemNameTypes.Split(','); String takeOutItemAccounts = Request["takeOutItemAccounts"]; String[] arrTakeOutItemAccounts = takeOutItemAccounts.Split(','); String takeOutUnits = Request["takeOutUnits"]; String[] arrTakeOutUnits = takeOutUnits.Split(','); for (int i = 0; i < arrSubTakeOutItemCategoryCode.Length; i++) { if (!String.IsNullOrEmpty(arrSubTakeOutItemCategoryCode[i])) { TakeOutItemDataInfo takeOutItemDataInfo = new TakeOutItemDataInfo(); takeOutItemDataInfo.TakeOutDataCode = takeOutDataCode; takeOutItemDataInfo.SubCategoryCode = Convert.ToInt32(arrSubTakeOutItemCategoryCode[i]); takeOutItemDataInfo.TakeOutItemName = arrTakeOutItemNames[i]; takeOutItemDataInfo.TakeOutItemType = arrTakeOutItemNameTypes[i]; takeOutItemDataInfo.Account = Convert.ToInt32(arrTakeOutItemAccounts[i]); takeOutItemDataInfo.UnitCode = Convert.ToInt32(arrTakeOutUnits[i]); int itemResult = bllTakeOutItemData.insertTakeOutItemData(takeOutItemDataInfo); } } Response.Redirect("viewTakeOut.aspx?takeOutDataCode=" + takeOutDataCode, true); } else { // 신규 if (Request.QueryString["mode"].Equals("write")) { // 신규 결재 코드 가져오기 approveDocCode = bllVisitData.GetNewApproveCode(); } // 수정 else { // 반출 번호 TakeOutDataInfo oldData = bllTakeOutData.selectTakeOutData(Request.QueryString["takeOutDataCode"]); lblTakeOutDataCode.Text = Request["takeOutDataCode"]; scheduleDateTitle = oldData.ScheduleInDate; scheduleDateOut = oldData.ScheduleOutDate; takeOutObjectCode.SelectedValue = oldData.TakeOutObjectCode.ToString(); takeOutPathStart.SelectedValue = oldData.TakeOutPathStartCode.ToString(); takeOutPathEnd.SelectedValue = oldData.TakeOutPathEndCode.ToString(); objectContents = oldData.ObjectContents; companyCode = oldData.CompanyCode; companyName = oldData.CompanyName; recieveName = oldData.RecieveName; carCode = oldData.CarCode; carNumber = oldData.CarNumber; // 반입불가가 아닌경우(반입가능) 불가사유 없으므로 수정시 select 1로 하고 실제 저장시에는 저장 안되게 되어 있음. if (oldData.DisApprovalCategoryCode == 0) { disApprovalCategoryCode.SelectedValue = "20"; } else { disApprovalCategoryCode.SelectedValue = oldData.DisApprovalCategoryCode.ToString(); } disApprovalCategoryDetail = oldData.DisApprovalCategoryDetail; if (oldData.RequireIN == 1) { ckRequire1 = "checked"; } else { ckRequire2 = "checked"; } // 이전 물품 정보 보여주기 List <TakeOutItemDataInfo> takeOutItemList = bllTakeOutItemData.selectTakeOutItemDataList(Request.QueryString["takeOutDataCode"]); for (int i = 0; i < takeOutItemList.Count; i++) { TakeOutItemDataInfo obj = (TakeOutItemDataInfo)takeOutItemList[i]; arrTakeOutItemList += "parentCategory[" + i + "]='" + obj.ParentCategoryCode + "';\n"; arrTakeOutItemList += "subCategory[" + i + "]='" + obj.SubCategoryCode + "';\n"; arrTakeOutItemList += "itemName[" + i + "]='" + obj.TakeOutItemName + "';\n"; arrTakeOutItemList += "itemType[" + i + "]='" + obj.TakeOutItemType + "';\n"; arrTakeOutItemList += "account[" + i + "]='" + obj.Account.ToString() + "';\n"; arrTakeOutItemList += "unit[" + i + "]='" + obj.UnitCode + "';\n"; } displayCellCount = takeOutItemList.Count.ToString(); // 결재 코드 approveDocCode = oldData.ElecApproveCode; //첨부 파일 if (!String.IsNullOrEmpty(oldData.UserFile1)) { lblUserFile1.Text = "<a href='" + ConfigurationManager.AppSettings["fileOpenPath"] + "/" + bllTakeOutData.GetFileName(oldData.UserFile1) + "' target='_blank'>" + bllTakeOutData.GetFileName(oldData.UserFile1) + "</a>"; lblUserFile1.Text += "<a href='#;' onclick=\"confirmMove('Có chắc chắn xóa không? (정말로 삭제하시겠습니까?)','userFileDeleteTakeOut.aspx?takeOutDataCode=" + oldData.TakeOutDataCode + "&fileNumber=1&fileName=" + HttpUtility.UrlEncode(bllTakeOutData.GetFileName(oldData.UserFile1)) + "',document.dummy)\"><img src='../../images/icon/fileDelete.gif' align='absmiddle'></a>"; } if (!String.IsNullOrEmpty(oldData.UserFile2)) { String[] arrUserFile2 = oldData.UserFile2.Split('|'); lblUserFile2.Text = "<a href='" + ConfigurationManager.AppSettings["fileOpenPath"] + "/" + bllTakeOutData.GetFileName(oldData.UserFile2) + "' target='_blank'>" + bllTakeOutData.GetFileName(oldData.UserFile2) + "</a>"; lblUserFile2.Text += "<a href='#;' onclick=\"confirmMove('Có chắc chắn xóa không? (정말로 삭제하시겠습니까?)','userFileDeleteTakeOut.aspx?takeOutDataCode=" + oldData.TakeOutDataCode + "&fileNumber=2&fileName=" + HttpUtility.UrlEncode(bllTakeOutData.GetFileName(oldData.UserFile2)) + "',document.dummy)\"><img src='../../images/icon/fileDelete.gif' align='absmiddle'></a>"; } if (!String.IsNullOrEmpty(oldData.UserFile3)) { String[] arrUserFile3 = oldData.UserFile3.Split('|'); lblUserFile3.Text = "<a href='" + ConfigurationManager.AppSettings["fileOpenPath"] + "/" + bllTakeOutData.GetFileName(oldData.UserFile3) + "' target='_blank'>" + bllTakeOutData.GetFileName(oldData.UserFile3) + "</a>"; lblUserFile3.Text += "<a href='#;' onclick=\"confirmMove('Có chắc chắn xóa không? (정말로 삭제하시겠습니까?)','userFileDeleteTakeOut.aspx?takeOutDataCode=" + oldData.TakeOutDataCode + "&fileNumber=3&fileName=" + HttpUtility.UrlEncode(bllTakeOutData.GetFileName(oldData.UserFile3)) + "',document.dummy)\"><img src='../../images/icon/fileDelete.gif' align='absmiddle'></a>"; } note = oldData.Note; } // 임직원 정보 보이기 lblDepartment.Text = loginEmployee.Dep_name; lblUpnid.Text = loginEmployee.Upnid; lblOfficeName.Text = loginEmployee.OfficeName; lblDisplayName.Text = loginEmployee.DisplayName; lblTitle.Text = loginEmployee.Title_name; lblPhone.Text = loginEmployee.MobilePhoneNumber; // 대분류 가져오기 TakeOutItemCategory bllTakeOutItemCategory = new TakeOutItemCategory(); List <TakeOutItemCategoryInfo> categorylist = bllTakeOutItemCategory.selectTakeOutItemCategoryList(1, 0); for (int i = 0; i < categorylist.Count; i++) { TakeOutItemCategoryInfo itemCategory = (TakeOutItemCategoryInfo)categorylist[i]; itemCategoryNameList += "arrItemCategoryNameList[" + i + "] = '" + itemCategory.CodeName + "';\n"; itemCategoryCodeList += "arrItemCategoryCodeList[" + i + "] = '" + itemCategory.TakeOutItemCategoryCode + "';\n"; } // 단위 가져오기 HanaMicron.COMS.BLL.Unit bllUnit = new HanaMicron.COMS.BLL.Unit(); String unitSearchKey = "A"; List <UnitInfo> unitList = bllUnit.selectUnitList(unitSearchKey); for (int i = 0; i < unitList.Count; i++) { UnitInfo unitInfo = (UnitInfo)unitList[i]; unitNameList += "arrUnitNameList[" + i + "] = '" + unitInfo.CodeName + "';\n"; unitCodeList += "arrUnitCodeList[" + i + "] = '" + unitInfo.UnitCode + "';\n"; } } }
public String elecApproveType; //전자결재 타입(반출:takeOut,내방:visit,보안카드:secCard) loại phê duyệt điện tử () protected void Page_Load(object sender, EventArgs e) { // 로그인 체크 check login EmployeeInfo loginEmployee = new EmployeeInfo(); loginEmployee = (EmployeeInfo)Session["loginMember"]; if (loginEmployee == null) { Response.Redirect("~/login.aspx", true); } loginEmploeeDepartmentName = loginEmployee.Dep_name; loginEmploeeDisplayName = loginEmployee.DisplayName; loginEmployeeUpnid = loginEmployee.Upnid; // 전자결재 타입 elecApproveType = Request.QueryString["elecApproveType"]; VisitData bll = new VisitData(); VisitDataInfo obj = new VisitDataInfo(); TakeOutData bllTakeOut = new TakeOutData(); TakeOutDataInfo takeOutData = new TakeOutDataInfo(); SecCardData bllSecCard = new SecCardData(); SecCardDataInfo secCardData = new SecCardDataInfo(); if (elecApproveType.Equals("visit")) // 내방 부분 phần visit { obj = bll.selectVisitData(Request["visitDataCode"]); if (obj.VisitFlag == 1) { doc_title = "[Đăng ký khách thăm dài hạn] ([장기내방신청])"; } else { doc_title = "Đăng ký khách thăm ([내방신청])"; } elecApproveContents = bll.MakeElecApproveContents(obj); //내방 전자결재 web.config에 등록된 카테고리 코드. 전자결재 Legacy 연동시 사용함. elecCategoryCode = ConfigurationManager.AppSettings["elecCategoryCode"]; } else if (elecApproveType.Equals("secCard")) // 반출 부분 { secCardData = bllSecCard.selectSecCardData(Request["secCardDataCode"]); doc_title = "[Mẫu đăng ký ra/vào (Card Reader)] ([출입(카드리더기)등록 신청서])"; elecApproveContents = bllSecCard.MakeElecApproveContents(secCardData); //반출 전자결재 web.config에 등록된 카테고리 코드. 전자결재 Legacy 연동시 사용함. elecCategoryCode = ConfigurationManager.AppSettings["elecCategoryCodeAll"]; bllSecCard.updateApprove(secCardData.ElecApproveCode, "1", ""); } else // 반출 부분 { takeOutData = bllTakeOut.selectTakeOutData(Request["takeOutDataCode"]); doc_title = "[Đăng ký mang ra] ([반출신청])"; elecApproveContents = bllTakeOut.MakeElecApproveContentsTakeOut(takeOutData); //반출 전자결재 web.config에 등록된 카테고리 코드. 전자결재 Legacy 연동시 사용함. elecCategoryCode = ConfigurationManager.AppSettings["elecCategoryCodeTakeOut"]; } form_code = ConfigurationManager.AppSettings["elecApproveFormCode"]; doc_term = "1"; sec_level = "M"; user_id = loginEmployee.Upnid; user_Title = loginEmployee.Title_name; user_depName = loginEmployee.Dep_name; user_name = loginEmployee.DisplayName; attach_flag = "0"; if (elecApproveType.Equals("visit")) //내방부분 { if (!String.IsNullOrEmpty(obj.UserFile1)) { attach_str += MakeFileString(obj.UserFile1) + ";"; attach_flag = "1"; } if (!String.IsNullOrEmpty(obj.UserFile2)) { attach_str += MakeFileString(obj.UserFile2) + ";"; attach_flag = "1"; } if (!String.IsNullOrEmpty(obj.UserFile3)) { attach_str += MakeFileString(obj.UserFile3) + ";"; attach_flag = "1"; } bll.updateApprove(Request["visitDataCode"], "1", ""); } else //반출 부분 { if (!String.IsNullOrEmpty(takeOutData.UserFile1)) { attach_str += MakeFileString(takeOutData.UserFile1) + ";"; attach_flag = "1"; } if (!String.IsNullOrEmpty(takeOutData.UserFile2)) { attach_str += MakeFileString(takeOutData.UserFile2) + ";"; attach_flag = "1"; } if (!String.IsNullOrEmpty(takeOutData.UserFile3)) { attach_str += MakeFileString(takeOutData.UserFile3) + ";"; attach_flag = "1"; } bllTakeOut.updateApprove(Request["takeOutDataCode"], "1", ""); } }