private void SetMauHoaDon() { if (cboMauHoaDon.SelectedValue == null) { return; } string mauHoaDon = cboMauHoaDon.Text; int index = mauHoaDon.IndexOf("-"); if (index >= 0) { _mauSo = mauHoaDon.Substring(0, index); _kiHieu = mauHoaDon.Substring(index + 1, mauHoaDon.Length - index - 1); Result result = QuanLySoHoaDonBus.GetThayDoiSoHoaDon(_mauSo, _kiHieu, ref _toNgayThayDoiHD); if (result.IsOK) { NgayBatDauLamMoiSoHoaDon nbdlm = result.QueryResult as NgayBatDauLamMoiSoHoaDon; _fromNgayThayDoiHD = nbdlm.NgayBatDau; } else { MsgBox.Show(Application.ProductName, result.GetErrorAsString("QuanLySoHoaDonBus.GetThayDoiSoHoaDon"), IconType.Error); Utility.WriteToTraceLog(result.GetErrorAsString("QuanLySoHoaDonBus.GetThayDoiSoHoaDon")); } } }
private void dlgLamMoiSoHoaDon_Load(object sender, EventArgs e) { Result result = QuanLySoHoaDonBus.GetThayDoiSoHoaSonSauCung(); if (result.IsOK) { if (result.QueryResult != null) { NgayBatDauLamMoiSoHoaDon thayDoiSauCung = result.QueryResult as NgayBatDauLamMoiSoHoaDon; 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("QuanLySoHoaDonBus.GetThayDoiSoHoaSonSauCung"), IconType.Error); Utility.WriteToTraceLog(result.GetErrorAsString("QuanLySoHoaDonBus.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(); NgayBatDauLamMoiSoHoaDon nbd = new NgayBatDauLamMoiSoHoaDon(); nbd.MaNgayBatDauGUID = Guid.NewGuid(); nbd.NgayBatDau = ngayThayDoi; nbd.MauSo = mauSo; nbd.KiHieu = kiHieu; nbd.SoHoaDonBatDau = soHoaDonBatDau; db.NgayBatDauLamMoiSoHoaDons.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); }