Manage/ExcelToModel.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Data;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using EKETEAM.Extension.ComObject;
using System.Data.OleDb;
using System.IO;
using EKETEAM.Data;
using EKETEAM.FrameWork;
using System.Text;
using EKETEAM.ePinyin;

public partial class Manage_ExcelToModel : System.Web.UI.Page
{
    public string file = eParameters.QueryString("file");
    private eUser user;
    private string tempPath = "";
    public eExtensionsList allowExts = new eExtensionsList(".xls.xlsx.csv");
    protected void Page_Load(object sender, EventArgs e)
    {
        user = new eUser("Manage");
        user.Check();
        //eBase.Writeln(ePinyin.getFirstLetter("中国人民邮电大学"));
        //eBase.Writeln(ePinyin.getPinYin("中国人民邮电大学"));
        //eBase.Writeln(ePinyin.getPinYin("中国人民邮电大学",true));
        tempPath = eRunTime.tempPath;
        if (file.Length == 0)
        {
            #region 保存文件
            if (Request.Files.Count == 1)
            {
                HttpPostedFile postfile = Request.Files[0];
                if (postfile.ContentLength > 0)
                {
                    string ext = postfile.FileName.fileExtension();
                    string filename = eBase.GetFileName() + ext;
                    string pathname = tempPath + filename;
                    if (!Directory.Exists(tempPath)) Directory.CreateDirectory(tempPath);
                    postfile.safeSaveAs(pathname,allowExts);
                    Response.Redirect(eBase.getAspxFileName() + "?file=" + filename, true);

                }
            }
            #endregion
        }
        else
        {
            if (Request.Form.Count > 3)
            {
                Save();
            }
            else
            {
                List();
            }
        }
    }
    private void Save()