파일업로드&다운로드 게시판_ Default1.aspx.cs

    protected void Page_Load(object sender, EventArgs e)
    {
        PageSetting();
     }

    protected void PageSetting()
    {
        DataSet ds = new DataSet();
        ds = list_doubleo_board();
        ▶ 데이터 바인드
        if (ds != null)
        {
            DataListTable.DataSource = ds.Tables[0];
            DataListTable.DataMember = "DataListTable";
            DataListTable.DataBind();
        }
    }

    protected void DataListTable_ItemDataBound(object sender, RepeaterItemEventArgs e)
    {
        Label lbl_deldate = (Label)e.Item.FindControl("deldate");
        Label lbl_hakdoc = (Label)e.Item.FindControl("hakdoc");
        Label lbl_hakmail = (Label)e.Item.FindControl("hakmail");
        Label lbl_dondoc = (Label)e.Item.FindControl("dondoc");
        Label lbl_donmail = (Label)e.Item.FindControl("donmail");
        Label lbl_regdate = (Label)e.Item.FindControl("regdate");

        DataRowView data = (DataRowView)e.Item.DataItem;
        ▶ lbl의 원래 아이디 = 바인드된 데이터
        lbl_deldate.Text = data["deldate"].ToString();
        lbl_regdate.Text = data["regdate"].ToString();
      
        
   lbl_hakdoc.Text = UploadLink("hakdoc_", data["deldate"].ToString(), data["idx"].ToString(), "1", data["hakdoc"].ToString());
   lbl_hakmail.Text = UploadLink("hakmail_", data["deldate"].ToString(), data["idx"].ToString(),"2", data["hakmail"].ToString());
   lbl_dondoc.Text = UploadLink("dondoc_", data["deldate"].ToString(), data["idx"].ToString(),"3", data["dondoc"].ToString());
   lbl_donmail.Text = UploadLink("donmail_", data["deldate"].ToString(), data["idx"].ToString(),"4", data["donmail"].ToString());
      
    }
    protected string UploadLink(string idx, string deldate, string num, string type, string file)
    {
        string returnValue = "";
        returnValue = " <a href=\"javascript:winopen('Default2.aspx?idx=" + idx + "&date=" + deldate + "&num=" + num + "&type=" + type + "') \">" + fileChechk(file) + "</a>";
       
        return returnValue;
    }

    ▶ o,x 구분하는 함수
    protected string fileChechk(string FileName)
    {
        string returnText = "X";
        string FileUrl = Server.MapPath(ConfigurationManager.AppSettings["uploadPath1"]);

        if (FileName != "X")
        {
            FileUrl += FileName;
            FileInfo fInfo = new FileInfo(FileUrl);
            if (fInfo.Exists)
            {
                returnText = "O</a> <a href=\"/upload/" + FileName + "\">[다운]";
            }
            else
            {
                returnText = "△";
            }                                                                          
        }
      
        return returnText;

    }

    protected DataSet list_doubleo_board()
    {
        SqlConnection conn = CDBConn.GetConn();
        SqlCommand cmd = new SqlCommand();
        DataSet ds = new DataSet();

        cmd.CommandText = "doubleoList";
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Connection = conn;

        SqlDataAdapter adap = new SqlDataAdapter(cmd);
        adap.Fill(ds);
        return ds;
    }

    ▶ 금주의 요일(금) 가져오기
    protected void Button1_Click(object sender, EventArgs e)
    {
        DateTime NowDate = DateTime.Today;
        int toDay = Convert.ToInt32(NowDate.DayOfWeek);
        int goalDay = Convert.ToInt32(DayOfWeek.Friday);
        DateTime fridayDate = NowDate.AddDays(goalDay - toDay);
        string str = fridayDate.ToString();
        string result = "";
        result = str.Substring(0, 10);

       Insert_doubleo_board(result);
       Response.Redirect("Default1.aspx");
    }

    public static int Insert_doubleo_board(string deldate)
    {
        int returnIdx = 0;
        SqlConnection conn = CDBConn.GetConn();
        SqlCommand cmd = new SqlCommand();

        cmd.CommandText = "doubleoInsert";
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.Connection = conn;

        cmd.Parameters.AddWithValue("@deldate", deldate);
       
        conn.Open();
        returnIdx = int.Parse(cmd.ExecuteScalar().ToString());
        conn.Close();

        return returnIdx;
    }