25장 ASP.NET 자료실 만들기 (App_Code)

UploadUtil.cs

using System; using System.IO; public class UploadUtil {  // HTTP GET을 사용하여 [WebGet] 특성을 추가합니다.  [OperationContract]  public void DoWork()  {   // 여기에 작업 구현을 추가합니다.   return;  }  // 여기에 작업을 추가하고 해당 작업을 [OperationContract]로 표시합니다.     public static string GetFilePath                                 (string strBaseDirTemp, string strFileNameTemp)     {      string strName = //순수파일명 : Test      Path.GetFileNameWithoutExtension(strFileNameTemp); //[1] 순수 파일명만 반환      string strExt =  // 확장자 : .txt      Path.GetExtension(strFileNameTemp); //[2] 순수 확장자만 : . 포함         bool blnExists = true;         int i = 0;         while (blnExists)         {             //[3] Path.Combine(경로, 파일명) = 경로 + 파일명             if (File.Exists(Path.Combine(strBaseDirTemp, strFileNameTemp)))             {                 strFileNameTemp =                   strName + "(" + ++i + ")" + strExt; // Test(3).txt             }             else             {                 blnExists = false;             }         }         return strFileNameTemp;     } }

UploadBiz.cs

using System; using System.Transactions; using System.Data; using System.Collections.Generic; //참조추가 : System.Transactions public class UploadBiz {     //입력메서드     public int WriteUpload(string name, string email, string title,                                      string PostIp, string content         , string password, string encoding, string homepage,                                     string fileName, int fileSize)     {         //using 구문에 있는 여러개 메서드들을 트랜잭션으로 처리         //첫번재 메서드로 처리한 후 두번째 메서드에서 에러가 발생하면,         //첫번째 메서드로 롤백시킨다         int result = 0;         using(TransactionScope scope = new                  TransactionScope(TransactionScopeOption.RequiresNew))         {           UploadDac ud = new UploadDac();             result = ud.AddUpload(name, email, title, PostIp, content, password                       ,encoding, homepage, fileName, fileSize);                         scope.Complete();                             }             return result; //UI영역으로 반환     }     //출력 메서드     public DataSet ListUpload()     {         return (new UploadDac()).GetUploads();     }     //출력된 결과값을 백업해주고 싶다     //백업 매서드     //public void BackupUpload()     //{     //    UploadDac ud = new UploadDac();     //    ud.GetUploads().WriteXml("Backup.xml");     //}     //상세메서드     public UploadEntity ViewUpload(int num)     {         UploadEntity entity = new UploadEntity();         using (IDataReader dr = (new UploadDac()).GetUploadByNum(num))         {             while (dr.Read())             {                 entity.Num = num;                 entity.Name = dr["Name"].ToString(); //문자열 인덱서                 entity.Email = dr[2].ToString(); //정수형 인덱서                 entity.Title = dr.GetString(3); //GEtXXX()메서드                 entity.PostDate = dr.GetDateTime(4);                 entity.PostIP = dr["PostIp"].ToString();                 entity.Content = dr[6].ToString();                 entity.Password = dr.GetString(7);                 entity.ReadCount = dr.GetInt32(8);                 entity.Encoding = dr.GetString(9);                                 if (dr["Homepage"] != null)                 {                     entity.Homepage = dr["Homepage"].ToString();                 }                 if (dr[11] != null)                 {                     entity.ModifyDate = dr.GetDateTime(11);                 }                 if (dr[12] != null)                 {                     entity.ModifyIP = dr["ModifyIP"].ToString();                 }                 if (dr[13] != null)                 {                     entity.FileName = dr.GetString(13);                 }                 entity.FileSize = Convert.ToInt32(dr["FileSize"]);                 entity.DownCount = int.Parse(dr["DownCount"].ToString());             }         }         return entity;     }     //수정 메서드     public int ModifyUpload(UploadEntity entity)     {         UploadDac ud = new UploadDac();         return ud.UpdateUpload(entity);     }     //삭제 메서드     public int DeleteUpload(int num, string password)     {         return (new UploadDac()).DeleteUpload(num, password);            }     //검색 메서드     public List<UploadEntity> SearchUpload                                          (string searchField, string searchQentityry)     {         List<UploadEntity> lst = new List<UploadEntity>(); //컬렉션         UploadEntity entity = new UploadEntity(); //한개 레코드         UploadDac ud = new UploadDac();         using (IDataReader dr = ud.GetUploadByWord                                            (searchField, searchQentityry))         {             while (dr.Read())             {                 #region 레코드 가져오기                 entity.Num = Convert.ToInt32(dr["Num"]);                 entity.Name = dr["Name"].ToString(); //문자열 인덱서                 entity.Email = dr[2].ToString(); //정수형 인덱서                 entity.Title = dr.GetString(3); //GEtXXX()메서드                 entity.PostDate = dr.GetDateTime(4);                 entity.PostIP = dr["PostIp"].ToString();                 entity.Content = dr[6].ToString();                 entity.Password = dr.GetString(7);                 entity.ReadCount = dr.GetInt32(8);                 entity.Encoding = dr.GetString(9);                 if (dr["Homepage"] != null)                 {                     entity.Homepage = dr["Homepage"].ToString();                 }                 if (dr[11] != null)                 {                     entity.ModifyDate = dr.GetDateTime(11);                 }                 if (dr[12] != null)                 {                     entity.ModifyIP = dr["ModifyIP"].ToString();                 }                 if (dr[13] != null)                 {                     entity.FileName = dr.GetString(13);                 }                 entity.FileSize = Convert.ToInt32(dr["FileSize"]);                 entity.DownCount = int.Parse(dr["DownCount"].ToString());                 #endregion                                 lst.Add(entity);             }         }         return lst; //전체 담겨진 리스트제네릭클래스(레코드셋)을 반환     }     //다운 메서드     public void UpdateDownCount(string fileName)     {         //Biz단에서 Dac단 호출         //Biz단에서 TransactionScope         //클래스 사용하여 묶어서 구현하는 것을 권장하여 사용         using (TransactionScope scope = new TransactionScope                                               (TransactionScopeOption.RequiresNew))         {             (new UploadDac()).UpdateDownCount(fileName);             //(new UploadDac()).UpdateDownCount(num);             scope.Complete();         }     } }

UploadDac.cs

using System; using System.Linq; using System.Runtime.Serialization; using System.ServiceModel; using System.ServiceModel.Activation; using System.ServiceModel.Web; using System.Configuration; using System.Data; using System.Data.SqlClient; [ServiceContract(Namespace = "")] [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)] public class UploadDac {     private string _ConnectionString; //연결문자열 보관     //ConnectionString 보관하여 사용     public UploadDac()     {         //Web.Config의 ConnectionString 을 딱 한번만 보관하여 사용....         _ConnectionString =                 ConfigurationManager.ConnectionStrings                                    ["ConnectionString"].ConnectionString;     }     //메서드 : 저장 프로시저만큼 ..         public int AddUpload      (string name, string email, string title, string PostIp, string content        , string password, string encoding, string homepage, string fileName,          int fileSize)     {         SqlConnection con = new SqlConnection(_ConnectionString);                 SqlCommand cmd = new SqlCommand("WriteUpload",con);         cmd.CommandType = CommandType.StoredProcedure;         cmd.Parameters.AddWithValue("@name",name);         cmd.Parameters.AddWithValue("@email",email);         cmd.Parameters.AddWithValue("@title",title);         cmd.Parameters.AddWithValue("@PostIp",PostIp);         cmd.Parameters.AddWithValue("@content",content);         cmd.Parameters.AddWithValue("@password",password);         cmd.Parameters.AddWithValue("@encoding",encoding);         cmd.Parameters.AddWithValue("@homepage",homepage);         cmd.Parameters.AddWithValue("@fileName",fileName);         cmd.Parameters.AddWithValue("@fileSize",fileSize);         con.Open();         int result = cmd.ExecuteNonQuery();         con.Close();         return result;            }     public DataSet GetUploads()     {         SqlConnection conn = new SqlConnection(_ConnectionString);         SqlCommand cmd = new SqlCommand("ListUpload" ,conn);         cmd.CommandType= CommandType.StoredProcedure;         SqlDataAdapter da = new SqlDataAdapter(cmd);                 DataSet ds = new DataSet();         da.Fill(ds,"Upload");         return ds;            }     //수정     public int UpdateUpload(UploadEntity entity)     {         SqlConnection con = new SqlConnection(_ConnectionString);         SqlCommand cmd = new SqlCommand("ModifyUpload", con);         cmd.CommandType = CommandType.StoredProcedure;         cmd.Parameters.AddWithValue("@Name",entity.Name);         cmd.Parameters.AddWithValue("@Email",entity.Email);         cmd.Parameters.AddWithValue("@Title",entity.Title);         cmd.Parameters.AddWithValue("@ModifyIP",entity.ModifyIP);         cmd.Parameters.AddWithValue("@Content",entity.Content);         cmd.Parameters.AddWithValue("@Encoding", entity.Encoding);         cmd.Parameters.AddWithValue("@Homepage", entity.Homepage);         cmd.Parameters.AddWithValue("@Password", entity.Password);         cmd.Parameters.AddWithValue("@FileName", entity.FileName);         cmd.Parameters.AddWithValue("@FileSize", entity.FileSize);         cmd.Parameters.AddWithValue("@Num", entity.Num);         con.Open();         int result = cmd.ExecuteNonQuery();         con.Close();         return result;     }     //상세     public SqlDataReader GetUploadByNum(int num)     {         SqlConnection  conn = new SqlConnection(_ConnectionString);         SqlCommand cmd = new SqlCommand("ViewUpload",conn);         cmd.Parameters.AddWithValue("@Num",num);         SqlDataReader dr = cmd.ExecuteReader();         return dr; //Close() =-> Using사용해서 Close 처리                     }     //삭제     public int DeleteUpload(int num, string password)     {         SqlConnection con = new SqlConnection(_ConnectionString);         SqlCommand cmd = new SqlCommand("DeleteUpload", con);                 cmd.CommandType = CommandType.StoredProcedure;         cmd.Parameters.AddWithValue("@Password", password);         cmd.Parameters.AddWithValue("@Num", num);                        con.Open();         int result = cmd.ExecuteNonQuery();         con.Close();          return result;     }     //검색     public IDataReader GetUploadByWord                                  (string searchField, string searchQuery)     {         SqlConnection conn = new SqlConnection(_ConnectionString);         SqlCommand cmd = new SqlCommand("SearchUpload", conn);         cmd.CommandType = CommandType.StoredProcedure;         cmd.Parameters.AddWithValue("@SearchField", searchField);         cmd.Parameters.AddWithValue("@SearchQuery", searchQuery);         SqlDataReader dr = cmd.ExecuteReader();                 return dr;                  }     //다운 증가     public void UpdateDownCount(string fileName)     {         SqlConnection conn = new SqlConnection(_ConnectionString);         SqlCommand cmd = new SqlCommand("IncreaseDownCountUpload", conn);         cmd.CommandType = CommandType.StoredProcedure;         cmd.Parameters.AddWithValue("@fileName", fileName);         conn.Open();                 cmd.ExecuteNonQuery();         conn.Close();    } }

UploadEntity.cs

using System; using System.Linq; using System.Runtime.Serialization; using System.ServiceModel; using System.ServiceModel.Activation; using System.ServiceModel.Web; [ServiceContract(Namespace = "")] [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)] public class UploadEntity {       public int Num { get; set; }       public string Name { get; set; }       public string Email { get; set; }       public string Title { get; set; }       public DateTime PostDate { get; set; }       public string PostIP { get; set; }       public string Content { get; set; }       public string Password { get; set; }       public int ReadCount { get; set; }       public string Encoding { get; set; }       public string Homepage { get; set; }       public DateTime ModifyDate { get; set; }       public string ModifyIP { get; set; }       public string FileName { get; set; }       public int FileSize { get; set; }       public int DownCount { get; set; } }

---

WebUpload 자료실.zip