Web/Admin/shop/Foodimport.aspx.cs

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

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

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

using WMPT.Common;
using WMPT.SQLServerDAL;
using WMPT.Model;
using System.IO;

// 商家餐品信息管理
// CopyRight (c) 2009-2010 HangJing Teconology. All Rights Reserved.
// zjf@iWMPT.com 餐品信息
// 2010-07-12

public partial class qy_54tss_Admin_Shop_Foodimport : System.Web.UI.Page
{
    EFoodSort dal = new EFoodSort();
    Foodinfo dalfood = new Foodinfo();

    protected void Page_Load(object sender, EventArgs e)
    {
        ValidatorSet validator = new ValidatorSet("Admin");
        validator.SetValidator();
        if (!this.Page.IsPostBack)
        {
            int tid = HjNetHelper.GetQueryInt("tid", 0);
            hidTogoId.Value = tid.ToString();
        }
    }

    /// <summary>
    /// 导入
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void in_Click(object sender, EventArgs e)
    {
        int tid = HjNetHelper.GetQueryInt("tid", 0);//商家id
        string suffix = Path.GetExtension(this.fuFoodExcel.PostedFile.FileName);
        string filepath = "~/upload/excel/";
        if (!System.IO.Directory.Exists(Server.MapPath(filepath)))
        {
            System.IO.Directory.CreateDirectory(Server.MapPath(filepath));
        }
        string sFile = filepath + System.DateTime.Now.ToString("yyyyMMddHHmmssffff") + suffix;  //上传后文件的新名


        if (suffix == ".xls" || suffix == ".XLS")
        {
            //保存文件
            try