using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Reflection;
using WPFTest.Models;
namespace WPFTest.Test.DAL
{
public class ProcessData
{
private const string connString = @"Password=sa.;User ID=sa;Initial Catalog=DatabaseName;Data Source=.";
public static int Insert(Location l)
{
try
{
string sql = $@"insert into [dbo].[SF$$Location] (LineCode,StationCode,LocationCode,LocationName) values('{l.LineCode}','{l.StationCode}','{l.LocationCode}','{l.LocationName}')";
using (SqlConnection sqlCnt = new SqlConnection(connString))
{
sqlCnt.Open();
using (SqlCommand insert = new SqlCommand(sql, sqlCnt))
{
return insert.ExecuteNonQuery();
}
}
}
catch (Exception e)
{
string a = e.Message;
return 0;
}
}
public static DataSet Select()
{
try
{
string sql = "select * from [dbo].[SF$$Location]";
using (SqlConnection sqlCnt = new SqlConnection(connString))
{
//sqlCnt.Open();
SqlDataAdapter sda = new SqlDataAdapter(sql, sqlCnt);
DataSet ds = new DataSet();
//使用SQLDataAdapter对象sda将查询结果填充到Dataset对象ds中
sda.Fill(ds);
return ds;
}
}
catch (Exception e)
{
string a = e.Message;
return null;
}
}
public static int Update(Location l)
{
try
{
string sql = $@"update [dbo].[SF$$Location] set LineCode='{l.LineCode}',StationCode='{l.StationCode}',LocationName='{l.LocationName}' where LocationCode='{l.LocationCode}'";
using (SqlConnection sqlCnt = new SqlConnection(connString))
{
sqlCnt.Open();
SqlCommand insert = new SqlCommand(sql, sqlCnt);
return insert.ExecuteNonQuery();
}
}
catch (Exception)
{
throw;
}
}
public static int Delete(Location l)
{
try
{
string sql = $@"Delete from [dbo].[SF$$Location] where LocationCode='{l.LocationCode}'";
using (SqlConnection sqlCnt = new SqlConnection(connString))
{
sqlCnt.Open();
SqlCommand insert = new SqlCommand(sql, sqlCnt);
return insert.ExecuteNonQuery();
}
}
catch (Exception)
{
throw;
}
}
}
}
C#数据库增删改查
最新推荐文章于 2024-05-18 17:19:38 发布