SQL 数据库连接配置

SQL Server 连接配置

Data Source=.;Initial Catalog=SportsStore;Persist Security Info=True;User ID=sa

 

 <connectionStrings>
    <add name="EFDbContext" connectionString="server=.;database=SportsStore;uid=sa;password=123456" providerName="System.Data.SqlClient" />
  </connectionStrings>

工具类中使用

  public static class SqlServerTools
    {
        public static string connString = ConfigurationManager.ConnectionStrings["SqlConnString"].ConnectionString;

        #region 删除多条记录
        public static bool DeleteMore(int enterpriseId)
        {
            SqlConnection conn = new SqlConnection(connString);
            conn.Open();
            string cmdStr = "delete from TL_INFO where id>0";
            SqlCommand cmd = new SqlCommand(cmdStr, conn);
            int result = cmd.ExecuteNonQuery();
            if (result > 0)
            {
                conn.Dispose();
                return true;
            }
            else
            {
                conn.Dispose();
                return false;
            }
        }
        #endregion

        #region 添加多条记录
        public static bool AddMore(int enterpriseId, List<WEBSERVICETRANSLATE> models, int id)
        {
            int result = 0;
            SqlConnection conn = new SqlConnection(connString);
            conn.Open();
            string cmdStr = "insert into TL_INFO(id,lable_id,label_desc,label_type,date_type,time,value,create_time,connect_status)values ";
            foreach (WEBSERVICETRANSLATE model in models)
            {

                cmdStr += "('" +id + "','" + model.label_id.ToString() + "', '" + model.label_desc.ToString() + "','" + model.label_type + "','" + model.date_type + "','" + model.time.ToString("yyyy-MM-dd HH:mm") + "','" + model.value + "','" + model.create_time + "','" + model.connect_status + "'), ";
                id++;
            }
            cmdStr = cmdStr.Substring(0, cmdStr.Length - 2);
            SqlCommand cmd = new SqlCommand(cmdStr, conn);
            result = cmd.ExecuteNonQuery();
            if (result > 0)
            {
                conn.Dispose();
                return true;
            }
            else
            {
                conn.Dispose();
                return false;
            }
        }
        #endregion
    }

Oracle 连接配置

 <appSettings>
    <add key="OracleConn" value="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ShenPanPan-PC)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=AritimeEms)));Persist Security Info=True;User ID=emsuser1;Password=Ems168;"/>
  </appSettings>

 public static class OracleTools
    {
        public static string connString = ConfigurationManager.AppSettings["OracleConn"];

        #region 删除多条记录
        public static bool DeleteMore(int enterpriseId)
        {
            OracleConnection conn = new OracleConnection(connString);
            conn.Open();
            string cmdStr = "begin delete TL_INFO where eidweb = " + enterpriseId
                + " ; commit; end;";
            OracleCommand cmd = new OracleCommand(cmdStr, conn);
            int result = cmd.ExecuteNonQuery();
            if (result > 0)
            {
                conn.Dispose();
                return true;
            }
            else
            {
                conn.Dispose();
                return false;
            }
        }
        #endregion

        #region 添加多条记录
        public static bool AddMore(int enterpriseId, List<WEBSERVICETRANSLATE> models)
        {
            OracleConnection conn = new OracleConnection(connString);
            conn.Open();
            if (models.Count > 0)
            {
                string cmdStr = "begin ";
                foreach (WEBSERVICETRANSLATE model in models)
                {
                    cmdStr += "insert into TL_INFO(id, lable_id, label_desc,label_type,date_type,time,value,create_time,connect_status) values(" + model.lable_id.ToString()
                        + ", " + model.label_desc.ToString() + ", '" + model.label_type + "','" + model.date_type + "',to_date('" + model.time.ToString("yyyy-MM-dd HH:mm") + "', 'YYYY-MM-DD HH24:MI'),'" + model.value + "', '" + model.create_time + "', '" + model.connect_status + "'); ";
                }
                cmdStr += "commit; end;";

                OracleCommand cmd = new OracleCommand(cmdStr, conn);
                int result = cmd.ExecuteNonQuery();
                if (result > 0)
                {
                    conn.Dispose();
                    return true;
                }
                else
                {
                    conn.Dispose();
                    return false;
                }
            }
            return true;
        }
        #endregion
    }

WEBSERVICETRANSLATE 类

 public class WEBSERVICETRANSLATE
    {

        public int EidWeb { get; set; }

        public int EidLocal { get; set; }

        public int Tagweb { get; set; }

        public int TagLocal { get; set; }
        public string idecollect { get; set; }

        public string idTagcollect { get; set; }

        public string idWebTagcollect { get; set; }
        public string secondValue { get; set; }

    }