protected override bool UpdateObject()
{
try
{
if (!ValidInput()) return false;
var id = (Guid)grvMain.GetFocusedRowCellValue("Id");
var o = new Tra_Detail()
{
Id = id,
//Pol_UserInId = BasePRE._sss.User.Id,
//Tra_VehicleId = id,
DateIn = BasePRE._sss.Current
};
if (_bll.Tra_Detail.Update(o) != null) return true;
else
{
BasePRE.ShowMessage(STR_IN_GATE, Text);
return false;
}
}
catch { return false; }
}
protected override bool InsertObject()
{
try
{
if (!ValidInput()) return false;
var id = _bll.Tra_Vehicle.CheckExist(txtNumber.Text);
if (id != new Guid()) // kiểm tra biển số xe trong danh sách các xe được quản lí
{
var o = new Tra_Detail()
{
Pol_UserInId = BasePRE._sss.User.Id,
Tra_VehicleId = id,
DateIn = BasePRE._sss.Current
};
if (_bll.Tra_Detail.Insert(o) != null) return true;
else
{
BasePRE.ShowMessage(STR_IN_GATE, Text);
return false;
}
}
else
{
try
{
var ve = new Tra_Vehicle
{
Number = txtNumber.Text,
Tra_KindId = (Guid)lkeKind.GetColumnValue("Id"),
Chair = txtChair.Text.ToInt32(),
Driver = txtDriver.Text,
Birth = dteBirth.DateTime,
Address = txtAddress.Text,
Phone = txtPhone.Text,
Descript = txtDescript.Text
};
if (_bll.Tra_Vehicle.Insert(ve) != null) // thêm xe nào vào danh sách xe cộ
{
var o = new Tra_Detail()
{
Pol_UserInId = BasePRE._sss.User.Id,
Tra_VehicleId = ve.Id,
DateIn = BasePRE._sss.Current
};
if (_bll.Tra_Detail.Insert(o) != null) return true;
else
{
BasePRE.ShowMessage(STR_NO_SAVE, Text);
return false;
}
}
else
{
BasePRE.ShowMessage(STR_IN_MAG, Text);
return false;
}
}
catch (Exception ex)
{
BasePRE.ShowMessage(String.Format(STR_INP_ERR, Environment.NewLine, ex.Message), Text);
return false;
}
}
}
catch { return false; }
finally { GetDataInMinute(); }
}
protected override bool UpdateObject()
{
try
{
if (!ValidInput()) return false;
var tb = _dtb.GetChanges(DataRowState.Modified);
foreach (DataRow r in tb.Rows)
{
var id = (Guid)r["Id"];
var guest = "" + r["Guest"];
var discount = "" + r["Discount"];
var arrears = "" + r["Arrears"];
var o = new Tra_Detail()
{
Id = id,
Guest = guest.ToInt32(),
Discount = discount.ToInt32(),
Arrears = arrears.ToInt32()
};
_bll.Tra_Detail.UpdateMore(o);
}
return true;
}
catch { return false; }
}
protected override bool UpdateObject()
{
try
{
//if (!ValidInput()) return false;
var tb = _dtb.GetChanges(DataRowState.Modified);
foreach (DataRow r in tb.Rows)
{
var id = (Guid)r["Id"];
var text = "" + r["Text"];
var o = new Tra_Detail()
{
Id = id,
Text = text
};
_bll.Tra_Detail.UpdateSeri(o);
}
return true;
}
catch { return false; }
}
/// <summary>
/// Tạo dữ liệu mẫu bảng Tra_Detail
/// </summary>
void CreateTra_Detail()
{
if (Tra_Detail.Count() > 0) return;
#region Bộ dữ liệu 1
var tbl = Tra_Vehicle.Select();
if (tbl == null) return;
var d = Tra_Vehicle.GetDate();
var ui = (Pol_User)Pol_User.Select("nvt");
var uo = (Pol_User)Pol_User.Select("ntt");
var kj = (Tra_Tariff)Tra_Tariff.Select("J");
var kk = (Tra_Tariff)Tra_Tariff.Select("K");
var kl = (Tra_Tariff)Tra_Tariff.Select("L");
foreach (DataRow r in tbl.Rows)
{
var id = (Guid)r["Id"];
var a = new Random();
var b = -a.Next();
var x = (Guid)r["Tra_KindId"];
var c = (x == kj.Id || x == kk.Id || x == kl.Id) ? b % 3 : b % 49;
var o = new Tra_Detail() { UserInId = ui.Id, VehicleId = id, DateIn = DateTime.Now.AddHours(c) };
Tra_Detail.Insert(o);
}
#endregion
#region Bộ dữ liệu 2
tbl = Tra_Vehicle.Select(null, 0, 5);
ui = (Pol_User)Pol_User.Select("cv");
uo = (Pol_User)Pol_User.Select("cr");
foreach (DataRow r in tbl.Rows)
{
var id = (Guid)r["Id"];
var a = new Random();
var b = -a.Next();
var x = (Guid)r["Tra_KindId"];
var c = (x == kj.Id || x == kk.Id || x == kl.Id) ? b % 3 : b % 49;
var o = new Tra_Detail() { UserInId = ui.Id, VehicleId = id, DateIn = DateTime.Now.AddHours(c) };
Tra_Detail.Insert(o);
}
#endregion
}
protected override void PerformSave()
{
try
{
int fix = 0, normal = 0;
#region Fixed
var dtr = _tbFixed.Select("[Id] Is Not Null ");
foreach (DataRow r in dtr)
{
var dt = Global.Session.Current;
if (!DateTime.TryParse(r["DateIn"] + "", out dt))
continue;
var bs = r["Code"] + "";
var id = _bll.Tra_Vehicle.CheckExist(bs);
var o = new Tra_Detail { VehicleId = id, DateIn = dt, Code = bs };
if (_bll.Tra_Detail.Insert(o) == null)
{
r["Note"] = STR_IN_DEPOT;
continue;
}
else
{
r["Note"] = STR_ENTERED;
fix++;
}
}
#endregion
#region Normal
dtr = _tbNormal.Select("[Id] Is Not Null ");
foreach (DataRow r in dtr)
{
var dt = Global.Session.Current;
if (!DateTime.TryParse(r["DateIn"] + "", out dt))
continue;
var bs = r["Code"] + "";
var id = _bll.Tra_Vehicle.CheckExist(bs);
var o = new Tra_Detail { VehicleId = id, DateIn = dt, Code = bs };
if (_bll.Tra_Detail.Insert(o) == null)
{
r["Note"] = STR_IN_DEPOT;
continue;
}
else
{
r["Note"] = STR_ENTERED;
normal++;
}
}
#endregion
XtraMessageBox.Show(String.Format(STR_INTO, fix, normal), Text);
PerformCancel();
grvFixed.BestFitColumns();
grvNormal.BestFitColumns();
}
catch (Exception ex)
{
#if DEBUG
XtraMessageBox.Show(ex.Message);
#endif
}
}
protected override bool InsertObject()
{
try
{
var id = _bll.Tra_Vehicle.CheckExist(txtNumber.Text);
if (id != new Guid())
{
var o = new Tra_Detail()
{
UserInId = Global.Session.User.Id,
VehicleId = id,
DateIn = Global.Session.Current,
Code = txtNumber.Text
};
if (_bll.Tra_Detail.Insert(o) != null) return true;
else
{
XtraMessageBox.Show(STR_IN_GATE,
STR_ADD,
MessageBoxButtons.OK,
MessageBoxIcon.Information);
return false;
}
}
else return false;
}
catch { return false; }
finally { LoadData(); }
}
protected override bool UpdateObject()
{
try
{
var id = (Guid)grvMain.GetFocusedRowCellValue("Id");
var o = new Tra_Detail()
{
Id = id,
DateIn = Global.Session.Current
};
if (_bll.Tra_Detail.Update(o) != null) return true;
else
{
XtraMessageBox.Show(STR_IN_GATE, Text);
return false;
}
}
catch { return false; }
}
/// <summary>
/// Tính tiền
/// </summary>
/// <param name="isOut">Cho xe ra</param>
private void Invoice(bool isOut = false)
{
if (cbbNumber.Text == "") return;
try
{
var v = (Tra_Vehicle)_bll.Tra_Vehicle.Select(cbbNumber.Text);
var o = new Tra_Detail() { Pol_UserOutId = BasePRE._sss.User.Id, Tra_VehicleId = v.Id, DateOut = BasePRE._sss.Current };
decimal money = 0;
int price1 = 0, price2 = 0;
int day = 0, hour = 0;
var tb = _bll.Tra_Detail.InvoiceOut(o, ref day, ref hour, ref money, ref price1, ref price2, isOut);
if (tb == null) return;
if (tb.Rows.Count > 0)
{
DateTime timeIn = Convert.ToDateTime(tb.Rows[0]["DateIn"]);
DateTime timeOut = isOut ? Convert.ToDateTime(tb.Rows[0]["DateOut"]) : o.DateOut.Value;
string code = tb.Rows[0]["GroupCode"] + "" != "" ? tb.Rows[0]["GroupCode"] + "" : "";
int chair = (tb.Rows[0]["Chair"] + "").ToInt32();
lblDateIn.Text = timeIn.ToStringVN();
lblDateOut.Text = timeOut.ToStringVN();
lblNumber.Text = (tb.Rows[0]["Number"] + "").ToUpper();
lblGroup.Text = tb.Rows[0]["GroupName"] + "";
lblKind.Text = tb.Rows[0]["Name"].ToString();
lblAccIn.Text = (tb.Rows[0]["UserInName"] + "").ToUpper();
lblAccIn.Text += " - SĐT: " + tb.Rows[0]["UserInPhone"];
lblChair.Text = chair + "";
string dayL = (hour > 0 && hour < 12) ? ".5" : "";
int dayF = (hour >= 12) ? day + 1 : day;
if (day == 0)
{
if (code == "A") dayL = ".5";
if (code == "B") dayF = 1;
}
lblDuration.Text = string.Format("{0}ngày {1}giờ => {2}{3}ngày", day, hour, dayF, dayL);
if (price1 == 0) lblPrice.Text = String.Format("{0:0,0}VNĐ (một lần)", price2);
else lblPrice.Text = String.Format("{0:0,0}VNĐ (một ngày); {1:0,0}VNĐ (nửa ngày)", price2, price1);
lblMoney.Text = String.Format("{0:0,0}VNĐ", money);
if (isOut)
{
LoadData();
tmrMain.Enabled = false;
}
}
}
catch (Exception ex) { BasePRE.ShowMessage("Lỗi tính tiền;" + ex.Message, Text); }
}
