private void frmTraXe_Load(object sender, EventArgs e)
{
btnDongY.LinkClicked += btnDongY_LinkClicked;
if (s_SerialPort != "")
{
TienIch.ComPort.serialPort_Open(s_SerialPort, false);
}
if (conn == null || conn.State != ConnectionState.Open)
{
Database.Open(ref this.conn);
}
if (conn.State == ConnectionState.Open)
{
TienIch.DsBanNang ds = new TienIch.DsBanNang();
DataTable dt = ds.LoadDsTheoID(conn, this.s_MaBN);
if (dt != null && dt.Rows.Count > 0)
{
r_BN = dt.Rows[0];
TrangThai.TrangThaiBanNang TT_trangthai = (TrangThai.TrangThaiBanNang)Convert.ToInt16(r_BN["trangthai"].ToString());
if (TT_trangthai == TrangThai.TrangThaiBanNang.DangSuaChua)
{
i_TongTG = Convert.ToInt32(r_BN["tongthoigian"].ToString());
DateTime TGCapNhat = r_BN["thoigianbd"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(r_BN["thoigianbd"]);
TimeSpan diff = DateTime.Now.Subtract(TGCapNhat);
double minutes = diff.TotalMinutes;
i_TGConLai = Convert.ToInt32(minutes) >= Convert.ToInt32(r_BN["tongthoigian"]) ? 0 : Convert.ToInt32(r_BN["tongthoigian"]) - Convert.ToInt32(minutes);
i_TGConLai += 1;
}
}
}
}
private void btnTraXe_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
string s_IDBanNang = grvBanNang.GetRowCellValue(grvBanNang.FocusedRowHandle, "maql").ToString();
DsBanNang dsBN = new DsBanNang();
TrangThai.TrangThaiBanNang ttBN = dsBN.LoadTrangThaiBanNang(SqlConn, s_IDBanNang);
if (ttBN == TrangThai.TrangThaiBanNang.DangSuaChua)
{
frmTraXe frm = new frmTraXe(SqlConn, s_IDBanNang, s_SerialPort);
frm.ShowDialog();
}
}
catch { }
finally
{
CapNhatDuLieuGridView();
}
}
private void frmSuaThongTinKH_Load(object sender, EventArgs e)
{
btnDongY.LinkClicked += btnDongY_LinkClicked;
if (conn == null || conn.State != ConnectionState.Open)
{
Database.Open(ref this.conn);
}
if (s_SerialPort != "")
{
TienIch.ComPort.serialPort_Open(s_SerialPort, false);
}
if (conn.State == ConnectionState.Open)
{
TienIch.DsBanNang ds = new TienIch.DsBanNang();
DataTable dt = ds.LoadDsTheoID(conn, s_IDBanNang);
if (dt != null && dt.Rows.Count > 0)
{
DataRow r_BN = dt.Rows[0];
this.s_MaKH = r_BN["makhachhang"].ToString();
this.s_HoTen = r_BN["hoten"].ToString();
this.s_BienSoXe = r_BN["biensoxe"].ToString();
TT_trangthai = (TrangThai.TrangThaiBanNang)Convert.ToInt16(r_BN["trangthai"].ToString());
i_TongTG = Convert.ToInt32(r_BN["tongthoigian"].ToString());
DateTime TGCapNhat = r_BN["thoigianbd"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(r_BN["thoigianbd"]);
TimeSpan diff = DateTime.Now.Subtract(TGCapNhat);
double minutes = diff.TotalMinutes;
double seconds = diff.TotalSeconds;
//Int32 minutes = Convert.ToInt32(Math.Ceiling(diff.TotalMinutes)); //Làm tròn lên để hiển thị khớp với bảng LED
i_TGConLai_TinhTheoGiay = Convert.ToInt32(seconds) >= (Convert.ToInt32(r_BN["tongthoigian"]) * 60) ? 0 : ((Convert.ToInt32(r_BN["tongthoigian"]) * 60) - Convert.ToInt32(seconds));
i_TGConLai_TinhTheoPhut = Convert.ToInt32(minutes) >= Convert.ToInt32(r_BN["tongthoigian"]) ? 0 : Convert.ToInt32(r_BN["tongthoigian"]) - Convert.ToInt32(minutes);
}
}
if (TT_trangthai == TrangThai.TrangThaiBanNang.ChoNhanXe)
{
txtHoTen.Enabled = false;;
txtBienSoXe.Enabled = false;
}
txtBanNang.Text = s_IDBanNang;
txtHoTen.Text = s_HoTen;
txtBienSoXe.Text = s_BienSoXe;
txtThoiGian.Text = i_TGConLai_TinhTheoPhut.ToString() + " Phút";
}
public DataTable LoadDsTheoTrangThai(SqlConnection conn, TrangThai.TrangThaiBanNang TT_BanNang)
{
try
{
string s_SQL = "select id,rtrim(kythuatvien) as kythuatvien from " + Database.Schema + ".dsbannang a left join " + Database.Schema + ".qlbannag b where b.trangthai =" + (int)TT_BanNang + " ";
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = s_SQL;
SqlDataAdapter sqlAdt = new SqlDataAdapter(s_SQL, conn);
sqlAdt.Fill(dt);
return(dt);
}
catch
{
return(null);
}
}
public bool UpdateTrangThai(SqlConnection conn, string s_MaQL, TrangThai.TrangThaiBanNang TT_TrangThai)
{
try
{
string s_SQL = "Update " + Database.Schema + "." + this.sTable + " set trangthai = @p_trangthai where maql = @p_maql";
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = s_SQL;
cmd.Parameters.Add("@p_maql", SqlDbType.NVarChar).Value = Convert.ToInt16(s_MaQL);
cmd.Parameters.Add("@p_trangthai", SqlDbType.Int).Value = TT_TrangThai;
cmd.ExecuteNonQuery();
return(true);
}
catch
{
return(false);
}
}
public DataTable LoadDsTheoTrangThai(SqlConnection conn, TrangThai.TrangThaiBanNang TT_BanNang)
{
try
{
string s_SQL = "select maql as id,rtrim(kythuatvien) as kythuatvien from " + Database.Schema + "." + this.sTable + " where trangthai =" + (int)TT_BanNang + " and kichhoat = " + (int)TrangThai.TrangThaiKichHoatBanNang.HoatDong;
DataTable dt = new DataTable();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = s_SQL;
SqlDataAdapter sqlAdt = new SqlDataAdapter(s_SQL, conn);
sqlAdt.Fill(dt);
return(dt);
}
catch
{
return(null);
}
}
void CapNhatDuLieuGridView()
{
int i_TGConLai = 0;
if (SqlConn == null || SqlConn.State != ConnectionState.Open)
{
Database.Open(ref this.SqlConn);
}
if (SqlConn.State == ConnectionState.Open)
{
try
{
//Cập nhật thông số
TienIch.tshienthi ts = new tshienthi();
ts.LoadAll(SqlConn);
s_Header = ts.Header;
s_Footer = ts.Footer;
i_SoDongHienThi = ts.SoDongHienThi;
iThoiGianHienThiDuLieu = ts.TGHienThi;
//
TienIch.DsKhachHang dskhachhang = new DsKhachHang();
dt_KhachHang = dskhachhang.LoadDSKHChoSuaChua(SqlConn);
if (bHienThiDuLieuMoi) //định kỳ 5s hiển thị dữ liệu
{
if (dt_KhachHang != null && dt_KhachHang.Rows.Count > 0)
{
DataTable dt_dsKH = new DataTable();
if (dt_KhachHang.Rows.Count < i_SoDongHienThi)
{
dt_dsKH = dt_KhachHang.Copy();
iDsKhachHangIndex = 0;
}
else
{
dt_dsKH = dt_KhachHang.Clone();
if (iDsKhachHangIndex >= dt_KhachHang.Rows.Count)
{
iDsKhachHangIndex = 0;
}
for (int i = 0; i < i_SoDongHienThi; i++)
{
if ((iDsKhachHangIndex + i) < dt_KhachHang.Rows.Count)
{
dt_dsKH.ImportRow(dt_KhachHang.Rows[iDsKhachHangIndex + i]);
}
else
{
break;
}
}
iDsKhachHangIndex += i_SoDongHienThi;
if (iDsKhachHangIndex >= dt_KhachHang.Rows.Count)
{
iDsKhachHangIndex = 0;
}
}
grdKhachHang.DataSource = dt_dsKH;
}
else
{
grdKhachHang.DataSource = dt_KhachHang;
iDsKhachHangIndex = 0;
}
}
///////////////////////////////////////////////
TienIch.DsBanNang dsbannang = new DsBanNang();
dt_BanNang = dsbannang.LoadAll(SqlConn);
try
{
if (dt_BanNang != null && dt_BanNang.Rows.Count > 0)
{
dt_BanNang.Columns.Add("thoigianconlai", typeof(decimal)).DefaultValue = 0;
dt_BanNang.Columns.Add("trangthaibn", typeof(string)).DefaultValue = "";
foreach (DataRow r in dt_BanNang.Rows)
{
TrangThai.TrangThaiBanNang TT_TrangThai = (TrangThai.TrangThaiBanNang)Convert.ToInt16(r["trangthai"].ToString());
r["trangthaibn"] = TienIch.TrangThai.TrangThaiBanNang2String((TrangThai.TrangThaiBanNang)Convert.ToInt16(r["trangthai"].ToString()));
DateTime TGCapNhat = r["thoigianbd"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(r["thoigianbd"]);
TimeSpan diff = DateTime.Now.Subtract(TGCapNhat);
Int32 minutes = Convert.ToInt32(Math.Ceiling(diff.TotalMinutes)); //Làm tròn lên để hiển thị khớp với bảng LED
if (r["tongthoigian"] == DBNull.Value)
{
r["tongthoigian"] = 0;
}
i_TGConLai = Convert.ToInt32(minutes) >= Convert.ToInt32(r["tongthoigian"]) ? 0 : Convert.ToInt32(r["tongthoigian"]) - Convert.ToInt32(minutes);
r["thoigianconlai"] = i_TGConLai;
if (TT_TrangThai != TrangThai.TrangThaiBanNang.DangSuaChua)
{
r["hoten"] = "";
r["thoigianbd"] = DateTime.MinValue;
r["biensoxe"] = "";
r["thoigianconlai"] = -1;
r["tongthoigian"] = -1;
}
}
}
}
catch
{
}
if (bHienThiDuLieuMoi) //định kỳ 5s hiển thị dữ liệu
{
if (dt_BanNang != null && dt_BanNang.Rows.Count > 0)
{
DataTable dt_HienThi = new DataTable();
if (dt_BanNang.Rows.Count < i_SoDongHienThi)
{
dt_HienThi = dt_BanNang.Copy();
iDsBanNangIndex = 0;
}
else
{
dt_HienThi = dt_BanNang.Clone();
if (iDsBanNangIndex >= dt_BanNang.Rows.Count)
{
iDsBanNangIndex = 0;
}
for (int i = 0; i < i_SoDongHienThi; i++)
{
if ((iDsBanNangIndex + i) < dt_BanNang.Rows.Count)
{
dt_HienThi.ImportRow(dt_BanNang.Rows[iDsBanNangIndex + i]);
}
else
{
break;
}
}
iDsBanNangIndex += i_SoDongHienThi;
if (iDsBanNangIndex >= dt_BanNang.Rows.Count)
{
iDsBanNangIndex = 0;
}
}
grdBanNang.DataSource = dt_HienThi;
}
else
{
grdBanNang.DataSource = dt_BanNang;
iDsBanNangIndex = 0;
}
}
//////////////////////////////////////////////////////////////////////////////////////
DsTraXe ds_TraXe = new DsTraXe();
// Hiển thị lên grid
dt_TraXe = ds_TraXe.LoadDsChuaLayXe(SqlConn);
if (bHienThiDuLieuMoi) //định kỳ 5s hiển thị dữ liệu
{
if (dt_TraXe != null && dt_TraXe.Rows.Count > 0)
{
DataTable dt_HienThi = new DataTable();
if (dt_TraXe.Rows.Count < i_SoDongHienThi)
{
dt_HienThi = dt_TraXe.Copy();
iDsTraXeIndex = 0;
}
else
{
dt_HienThi = dt_TraXe.Clone();
if (iDsTraXeIndex >= dt_TraXe.Rows.Count)
{
iDsTraXeIndex = 0;
}
for (int i = 0; i < i_SoDongHienThi; i++)
{
if ((iDsTraXeIndex + i) < dt_TraXe.Rows.Count)
{
dt_HienThi.ImportRow(dt_TraXe.Rows[iDsTraXeIndex + i]);
}
else
{
break;
}
}
iDsTraXeIndex += i_SoDongHienThi;
if (iDsTraXeIndex >= dt_TraXe.Rows.Count)
{
iDsTraXeIndex = 0;
}
}
grdTraXe.DataSource = dt_HienThi;
}
else
{
grdTraXe.DataSource = dt_TraXe;
iDsTraXeIndex = 0;
}
}
// Chạy chữ footer
DataTable dt_KQTraXe = ds_TraXe.LoadDsHienThiThongBao(SqlConn);
if (dt_KQTraXe != null && dt_KQTraXe.Rows.Count > 0)
{
if (dt_ThongBaoLayXe == null)
{
dt_ThongBaoLayXe = dt_KQTraXe.Clone();// Clone() only clones the table structure. It does not also clone the data.
}
for (int i = 0; i < dt_KQTraXe.Rows.Count; i++)
{
bool isDupe = false;
for (int j = 0; j < dt_ThongBaoLayXe.Rows.Count; j++)
{
if (dt_KQTraXe.Rows[i][0].ToString() == dt_ThongBaoLayXe.Rows[j][0].ToString())
{
isDupe = true;
break;
}
}
if (!isDupe)
{
dt_ThongBaoLayXe.ImportRow(dt_KQTraXe.Rows[i]);
}
}
}
}
catch
{
}
}
}
void CapNhatDuLieuGridView()
{
int i_TongBanNang = 0;
int i_BanNangBan = 0;
int i_TGConLai = 0;
int i_BanNang_SelectIndex = 0;
int i_KhachHang_SelectIndex = 0;
int i_TraXe_SelectIndex = 0;
string s_BanNangSuaChuaXong = "";
if (SqlConn == null || SqlConn.State != ConnectionState.Open)
{
Database.Open(ref this.SqlConn);
}
if (SqlConn.State == ConnectionState.Open)
{
try
{
i_BanNang_SelectIndex = grvBanNang.FocusedRowHandle;
i_KhachHang_SelectIndex = grvKhachHang.FocusedRowHandle;
i_TraXe_SelectIndex = grvTraXe.FocusedRowHandle;
TienIch.DsKhachHang dskhachhang = new DsKhachHang();
DataTable dt_DsKH = dskhachhang.LoadDSKHChoSuaChua(SqlConn);
grdKhachHang.DataSource = dt_DsKH;
TienIch.DsBanNang dsbannang = new DsBanNang();
DataTable dt_DsBN = dsbannang.LoadTheoTrangThaiKichHoat(SqlConn, TrangThai.TrangThaiKichHoatBanNang.HoatDong);
TienIch.DsTraXe ds_TraXe = new DsTraXe();
DataTable dt_TraXe = ds_TraXe.LoadDsChuaLayXe(SqlConn);
grdTraXe.DataSource = dt_TraXe;
try
{
if (dt_DsBN != null && dt_DsBN.Rows.Count > 0)
{
dt_DsBN.Columns.Add("thoigianconlai", typeof(decimal)).DefaultValue = 0;
dt_DsBN.Columns.Add("trangthaibn", typeof(string)).DefaultValue = "";
i_TongBanNang = dt_DsBN.Rows.Count;
foreach (DataRow r in dt_DsBN.Rows)
{
TrangThai.TrangThaiBanNang TT_TrangThai = (TrangThai.TrangThaiBanNang)Convert.ToInt16(r["trangthai"].ToString());
r["trangthaibn"] = TienIch.TrangThai.TrangThaiBanNang2String((TrangThai.TrangThaiBanNang)Convert.ToInt16(r["trangthai"].ToString()));
DateTime TGCapNhat = r["thoigianbd"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(r["thoigianbd"]);
TimeSpan diff = DateTime.Now.Subtract(TGCapNhat);
//double minutes = diff.TotalMinutes;
Int32 minutes = Convert.ToInt32(Math.Ceiling(diff.TotalMinutes)); //Làm tròn lên để hiển thị khớp với bảng LED
if (r["tongthoigian"] == DBNull.Value)
{
r["tongthoigian"] = 0;
}
i_TGConLai = Convert.ToInt32(minutes) >= Convert.ToInt32(r["tongthoigian"]) ? 0 : Convert.ToInt32(r["tongthoigian"]) - Convert.ToInt32(minutes);
r["thoigianconlai"] = i_TGConLai;
if (TT_TrangThai != TrangThai.TrangThaiBanNang.DangSuaChua)
{
r["hoten"] = "";
r["thoigianbd"] = DateTime.MinValue;
r["biensoxe"] = "";
r["thoigianconlai"] = -1;
r["tongthoigian"] = -1;
}
if (i_TGConLai <= 0 && TT_TrangThai == TrangThai.TrangThaiBanNang.DangSuaChua)
{
s_BanNangSuaChuaXong += String.Format("[{0}]", r["maql"].ToString());
}
}
}
lblSLBanNang.Caption = String.Format("Hoạt động: {0}/{1}", i_BanNangBan, i_TongBanNang);
grdBanNang.DataSource = dt_DsBN;
grvBanNang.FocusedRowHandle = i_BanNang_SelectIndex;
grvKhachHang.FocusedRowHandle = i_KhachHang_SelectIndex;
grvTraXe.FocusedRowHandle = i_TraXe_SelectIndex;
}
catch
{
}
}
catch
{
}
finally
{
if (s_BanNangSuaChuaXong != s_NhacNhoTraXe)
{
s_NhacNhoTraXe = s_BanNangSuaChuaXong;
if (s_NhacNhoTraXe != "")
{
ntfNhacNho.Visible = true;
ntfNhacNho.Icon = SystemIcons.Exclamation;
ntfNhacNho.BalloonTipTitle = "IKY-LED";
ntfNhacNho.BalloonTipText = "Bàn nâng " + s_NhacNhoTraXe + " đã sửa chữa xong";
ntfNhacNho.BalloonTipIcon = ToolTipIcon.Warning;
ntfNhacNho.ShowBalloonTip(10000);
}
}
}
}
}
