OA系统

开发平台：
ASP/ASPX

shangchuan.aspx.cs：源码内容
							﻿using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class web_shangchuan : System.Web.UI.Page
{
    private ArrayList attachments;
    private ArrayList attachment_save_names;
    private ArrayList content_lengths;
    protected void Page_Load(object sender, EventArgs e)
    {
    }
       protected bool UploadFiles(string time)
    {
        attachments = new ArrayList();
        attachment_save_names = new ArrayList();
        content_lengths = new ArrayList();
        bool flag = Upload(FileUpload1,time);
        return flag;
    }
    protected bool Upload(FileUpload fileUpload, string time)
    {
        //User user = (User)Session["user"];
        //string user_id = Session["user_id"].ToString();
        SqlConnection conn1 = dbConnection.getConnection();
        conn1.Open();
        //SqlCommand sqlcomm4 = new SqlCommand("select f.name as name from OA_DEPARTMENT as f, OA_EMPLOYEE as g where f.id=g.department_id and g.id='" + user_id + "'", conn1);
        SqlCommand sqlcomm4 = new SqlCommand("select f.name as name from OA_DEPARTMENT as f, OA_EMPLOYEE as g where f.id=g.department_id and g.id='347'", conn1);
        string department = Convert.ToString(sqlcomm4.ExecuteScalar());
        conn1.Close();
        bool flag = true;
        try
        {
            string directory = Server.MapPath("~/web/oa_upload/p_work/");
            string file_extension = System.IO.Path.GetExtension(fileUpload.FileName).ToLower();
            string[] allowed_extensions = { ".txt"};
            bool extenstion = false ;
            if (fileUpload.HasFile)
            {                
                for (int i = 0; i < allowed_extensions.Length; i++)
                {
                    if (file_extension == allowed_extensions[i])
                    {
                        extenstion = true;
                        break;
                    }
                }
                if (!extenstion)
                {
                    LblError.Text = "只允許上傳格式為txt文檔!";
                    this.LblError.ForeColor = System.Drawing.Color.Red;
                    return false;
                }
                else
                {
                    
                    string name = department+"考勤记录"+ time + System.IO.Path.GetExtension(fileUpload.FileName).ToLower();
                    //string name = "kaoqin" + time + System.IO.Path.GetExtension(fileUpload.FileName).ToLower();
                    fileUpload.PostedFile.SaveAs(directory+name);
                    attachments.Add(fileUpload.FileName);
                    attachment_save_names.Add(name);
                    content_lengths.Add(fileUpload.PostedFile.ContentLength.ToString());
                    flag = true;
                    LblError.Text = "上傳檔案成功!";
                    this.LblError.ForeColor = System.Drawing.Color.Red;
                }
            }
        }
        catch
        {
            LblError.Text = "上傳檔案失敗!";
            this.LblError.ForeColor = System.Drawing.Color.Red;
            return false;
        }
        return flag;
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        DateMgr mgr = new DateMgr();
        string today = mgr.getDate();
        string time = today.Substring(0,10);
        bool flag = UploadFiles(time);
    }
}

						