private void dlgLamMoiSoHoaDon_Load(object sender, EventArgs e) { Result result = QuanLySoHoaDonXetNghiemBus.GetThayDoiSoHoaSonSauCung(); if (result.IsOK) { if (result.QueryResult != null) { NgayBatDauLamMoiSoHoaDonXetNghiemYKhoa thayDoiSauCung = result.QueryResult as NgayBatDauLamMoiSoHoaDonXetNghiemYKhoa; dtpkNgayThayDoiSauCung.Value = thayDoiSauCung.NgayBatDau; txtMauSoCu.Text = thayDoiSauCung.MauSo; txtKiHieuCu.Text = thayDoiSauCung.KiHieu; txtSoHDBatDauCu.Text = thayDoiSauCung.SoHoaDonBatDau.ToString(); } else { dtpkNgayThayDoiSauCung.Value = Global.MinDateTime; } } else { MsgBox.Show(Application.ProductName, result.GetErrorAsString("QuanLySoHoaDonXetNghiemBus.GetThayDoiSoHoaSonSauCung"), IconType.Error); Utility.WriteToTraceLog(result.GetErrorAsString("QuanLySoHoaDonXetNghiemBus.GetThayDoiSoHoaSonSauCung")); } dtpkNgayThayDoiMoi.Value = DateTime.Now; }
public static Result SetThayDoiSoHoaSon(DateTime ngayThayDoi, string mauSo, string kiHieu, int soHoaDonBatDau) { Result result = new Result(); MMOverride db = null; try { db = new MMOverride(); NgayBatDauLamMoiSoHoaDonXetNghiemYKhoa nbd = new NgayBatDauLamMoiSoHoaDonXetNghiemYKhoa(); nbd.MaNgayBatDauGUID = Guid.NewGuid(); nbd.NgayBatDau = ngayThayDoi; nbd.MauSo = mauSo; nbd.KiHieu = kiHieu; nbd.SoHoaDonBatDau = soHoaDonBatDau; db.NgayBatDauLamMoiSoHoaDonXetNghiemYKhoas.InsertOnSubmit(nbd); db.SubmitChanges(); } catch (System.Data.SqlClient.SqlException se) { result.Error.Code = (se.Message.IndexOf("Timeout expired") >= 0) ? ErrorCode.SQL_QUERY_TIMEOUT : ErrorCode.INVALID_SQL_STATEMENT; result.Error.Description = se.ToString(); } catch (Exception e) { result.Error.Code = ErrorCode.UNKNOWN_ERROR; result.Error.Description = e.ToString(); } finally { if (db != null) { db.Dispose(); db = null; } } return(result); }