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);
}
