/// <summary> /// 傳入一個DTO,存檔,一次存檔一筆 /// </summary> public void InsertData(MED04_0000 MED04_0000) { Comm comm = new Comm(); string sSql = " INSERT INTO " + " MED04_0000 ( mo_code, wrk_code, mac_code, stop_code, date_s, time_s, date_e, time_e, ins_date, ins_time, usr_code, " + " des_memo, is_ng, is_end, end_memo, end_date, end_time, end_usr_code, " + " 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, @stop_code, @date_s, @time_s, @date_e, @time_e, @ins_date, @ins_time, @usr_code, " + " @des_memo, @is_ng, @is_end, @end_memo, @end_date, @end_time, @end_usr_code, " + " @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, MED04_0000); } }
/// <summary> /// 傳入一個DTO,修改,一次修改一筆 /// </summary> public void UpdateData(MED04_0000 MED04_0000) { Comm comm = new Comm(); string sSql = " UPDATE MED04_0000 " + " SET mo_code = @mo_code, " + " wrk_code = @wrk_code, " + " mac_code = @mac_code, " + " stop_code = @stop_code, " + " date_s = @date_s, " + " time_s = @time_s, " + " date_e = @date_e, " + " time_e = @time_e, " + " ins_date = @ins_date, " + " ins_time = @ins_time, " + " usr_code = @usr_code, " + " des_memo = @des_memo, " + " is_ng = @is_ng, " + " is_end = @is_end, " + " end_memo = @end_memo, " + " end_date = @end_date, " + " end_time = @end_time, " + " end_usr_code = @end_usr_code " + " user_field_01 = @user_field_01, " + " user_field_02 = @user_field_02, " + " user_field_03 = @user_field_03, " + " user_field_04 = @user_field_04, " + " user_field_05 = @user_field_05, " + " user_field_06 = @user_field_06, " + " user_field_07 = @user_field_07, " + " user_field_08 = @user_field_08, " + " user_field_09 = @user_field_09, " + " user_field_10 = @user_field_10 " + " WHERE med04_0000 = @med04_0000 "; using (SqlConnection con_db = comm.Set_DBConnection()) { con_db.Execute(sSql, MED04_0000); } }