/// <summary>
/// 傳入一個DTO，存檔，一次存檔一筆
/// </summary>
public void InsertData(MEM04_0000 MEM04_0000)
{
Comm comm = new Comm();
string sSql = " INSERT INTO " +
" MEM04_0000 ( mac_code, station_code, station_ip, station_mac ) " +
" VALUES ( @mac_code, @station_code, @station_ip, @station_mac ) ";
using (SqlConnection con_db = comm.Set_DBConnection())
{
con_db.Execute(sSql, MEM04_0000);
}
}
/// <summary>
/// 傳入一個DTO，修改，一次修改一筆
/// </summary>
public void UpdateData(MEM04_0000 MEM04_0000)
{
Comm comm = new Comm();
string sSql = " UPDATE MEM04_0000" +
" SET mac_code = @mac_code, " +
" station_code = @station_code, " +
" station_ip = @station_ip, " +
" station_mac = @station_mac " +
" WHERE mem04_0000 = @mem04_0000 ";
using (SqlConnection con_db = comm.Set_DBConnection())
{
con_db.Execute(sSql, MEM04_0000);
}
}