App_Code/AddAcess.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Text;
using System.Data.OleDb;
using Microsoft.Office.Interop.Excel;
using System.Data;
using System.Text.RegularExpressions;

using System.Web.UI;
/// <summary>
///AddAcess 的摘要说明
/// </summary>
public class AddAcess
{

    private string s_SysDataBaseAddress = System.Configuration.ConfigurationManager.ConnectionStrings["mycon"].ConnectionString;
    string bid;
    string str1 = "";

    /// <summary>
    /// 判断列是否合法，不合法返回fasle，否则返回true
    /// 导入之前做判断
    /// 判断报表期别的时间是否符合规则
    /// </summary>
    /// <param name="dt"></param>
    /// <returns></returns>
    public bool isColumnsYorN(System.Data.DataTable dt)
    {
        SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["mycon"].ConnectionString);
        conn.Open();
        bool flg = false;

        for (int i = 0; i < dt.Columns.Count; i++)
        {
            string Name = dt.Columns[i].ColumnName;
            bid = HttpContext.Current.Session["bid"].ToString();
            string sql = "select count(a.指标代码id) from ZBYSJB as a inner join YSB as b on a.指标代码ID=b.指标代码ID where BID= " + bid + " and 指标名称='" + Name + "'";
            SqlCommand cmd = new SqlCommand(sql, conn);
            int count = int.Parse(cmd.ExecuteScalar().ToString());
            if (count == 0)
            {
                flg = true;
                break;
            }
        }
        conn.Close();
        return flg;
        
    }
    /// <summary>
    /// 导入之前做判断
    /// 判断报表期的时间是否符合规则
    /// </summary>
    /// <param name="dt"></param>
    /// <returns></returns>