/// <summary>
/// 傳入一個DTO，存檔，一次存檔一筆
/// </summary>
public void InsertData(MED01_0100 MED01_0100)
{
Comm comm = new Comm();
string sSql = " INSERT INTO " +
" MED01_0100 ( mo_code, wrk_code, mac_code, usr_code, date_s, time_s, date_e, time_e , status ," +
" user_field_01, user_field_02, user_field_03, user_field_04, user_field_05, " +
" user_field_06, user_field_07, user_field_08, user_field_09, user_field_10 ) " +
" VALUES ( @mo_code, @wrk_code, @mac_code, @usr_code, @date_s, @time_s, @date_e, @time_e , @status , " +
" @user_field_01, @user_field_02, @user_field_03, @user_field_04, @user_field_05, " +
" @user_field_06, @user_field_07, @user_field_08, @user_field_09, @user_field_10 ) ";;
using (SqlConnection con_db = comm.Set_DBConnection())
{
con_db.Execute(sSql, MED01_0100);
}
}
/// <summary>
/// 傳入一個DTO，修改，一次修改一筆
/// </summary>
public void UpdateData(MED01_0100 MED01_0100)
{
Comm comm = new Comm();
string sSql = " UPDATE MED01_0100 " +
" SET mo_code = @mo_code, " +
" wrk_code = @wrk_code, " +
" mac_code = @mac_code, " +
" usr_code = @usr_code, " +
" date_s = @date_s, " +
" time_s = @time_s, " +
" date_e = @date_e, " +
" time_e = @time_e, " +
" status = @status " +
" WHERE med01_0100 = @med01_0100 ";
using (SqlConnection con_db = comm.Set_DBConnection())
{
con_db.Execute(sSql, MED01_0100);
}
}