EasyShop/siteAdmin/Goods/importCardPwd.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using OpSql;
using Ftion;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using conn;
using System.Linq;
using System.Text;
using System.Data.OleDb;
using MyModels;
using Common;
using System.Net;

namespace EasyShop.siteAdmin.Goods
{
    public partial class importCardPwd : System.Web.UI.Page
    {
        DbConn conn = new DbConn();
        public string jsString = "";
        protected void Page_Load(object sender, EventArgs e)
        {

        }
        //导入文件
        public void Tj_Click(object sender, EventArgs e)
        {
            string strPID = Common.GetMes.GetRequestQuery(Request, "PID");
            if (!string.IsNullOrEmpty(strPID))
            {
                TB_MC_Product tmp = new TB_MC_Product();
                tmp.ID = int.Parse(strPID);
                DataSet ckds = new DataSet();
                ckds = tmp.GetDataSetListByID();
                string ProductNumber = "";
                string ProID = strPID;
                int cknum = ckds.Tables[0].Rows.Count;
                int kucunNum = 0;
                for (int b = 0; b < cknum; b++)
                {
                    ProductNumber = ckds.Tables[0].Rows[b][29].ToString();
                    kucunNum = int.Parse(ckds.Tables[0].Rows[b]["Stock"].ToString());
                }
                if (fileuploadID.HasFile)
                {
                    string filename = fileuploadID.FileName;
                    string path = fileuploadID.PostedFile.FileName.ToString();
                    string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Extended Properties=Excel 8.0";
                    //链接Excel
                    OleDbConnection cnnxls = new OleDbConnection(strConn);
                    //读取Excel里面有 表Sheet1
                    OleDbDataAdapter oda = new OleDbDataAdapter("select * from [Sheet1$]", cnnxls);
                    DataSet ds = new DataSet();
                    //将Excel里面有表内容装载到内存表中！
                    oda.Fill(ds);
                    int num = ds.Tables[0].Rows.Count;