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