//문서데이터 삭제 public static void DeleteDoc(string mode, string da_id) { URLQuery.Self.RemoveAll(); DBLib dbUtil = new DBLib(); //(실제로 업데이트) if (mode == "d") { string[] setNameValue = new string[3] { "daModifyDT=GetDate()", "daStatus=0", "daDescription = daDescription + '\r\n\r\n\r\n" + Cookie.Self["sLoginID"] + "의한 삭제'" }; dbUtil.Update_EN("t_DocumentAssets", setNameValue, "da_id = " + da_id); } else if (mode == "dd") //게시물 영구삭제(실제삭제) { //관련문서파일삭제 SqlDataReader drDelFiles = dbUtil.Select_DR("dfName", "t_DocFileAssets", "df_id=" + da_id); while (drDelFiles.Read()) { //FileLib.Self.FileDelete(SystemConfig.GetValue("DocUploadDir") + drDelFiles["dfName"].ToString()); string backupDir = SystemConfig.GetValue("UploadDirBackup") + "docData.bak/"; FileLib.Self.FileMoveTo(SystemConfig.GetValue("DocUploadDir") + drDelFiles["dfName"].ToString(), backupDir + drDelFiles["dfName"].ToString()); } drDelFiles.Close(); //관련레코드 삭제 dbUtil.Delete_EN("t_DocFileAssets", "df_id = " + da_id); dbUtil.Delete_EN("t_DocumentAssets", "da_id = " + da_id); URLQuery.Self["smv"] = "0"; } dbUtil.SqlConnection.Close(); }
//회원데이터 삭제 public static void DeleteMember(string mode, string member_id) { dbUtil = new DBLib(); //(실제로 업데이트) if (mode == "d") { string[] setNameValue = new string[2] { "leaveDT=GetDate()", "IPaddress = '" + WebUtil.CurrentRequest.UserHostAddress + "_" + Cookie.Self["sLoginID"] + "'" }; dbUtil.Update_EN("t_MemberValue", setNameValue, "member_id = " + member_id); } else if (mode == "dd") //게시물 영구삭제(실제삭제) { MbrFilesMoveTo(member_id, dbUtil.Select_DR("avataImage", "t_MemberOption", "member_id=" + member_id)); dbUtil.Delete_EN("t_MemberJob", "member_id = " + member_id); dbUtil.Delete_EN("t_MemberOption", "member_id = " + member_id); dbUtil.Delete_EN("t_MemberValue", "member_id = " + member_id); dbUtil.Delete_EN("t_Members", "member_id = " + member_id); } dbUtil.SqlConnection.Close(); URLQuery.Self.Remove("mode"); HttpContext.Current.Response.Redirect(whichList + "?" + URLQuery.Self.GetQueryString()); }