//문서데이터 삭제
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());
}
