private void btnLoad_Click(object sender, EventArgs e)
        {
            DateTime dti_TuNgay  = Convert.ToDateTime(txtTuNgay.EditValue);
            DateTime dti_DenNgay = Convert.ToDateTime(txtDenNgay.EditValue);

            if (dti_TuNgay == Convert.ToDateTime(null))
            {
                dti_TuNgay = DateTime.Today;
            }
            if (dti_DenNgay == Convert.ToDateTime(null))
            {
                dti_DenNgay = dti_TuNgay;
            }
            if (dti_TuNgay == Convert.ToDateTime(null) || dti_DenNgay == Convert.ToDateTime(null))
            {
                return;
            }
            string s_TuNgay  = dti_TuNgay.ToString("yyyy-MM-dd") + " 00:00";
            string s_DenNgay = dti_DenNgay.ToString("yyyy-MM-dd") + " 23:59";

            dt_BaoCao = new DataTable();
            string sql = "select * from baocao where time between '" + s_TuNgay + "' and '" + s_DenNgay + "'";

            dt_BaoCao            = ThuVien.SQLiteLoad(sqlConn, sql);
            grdDuLieu.DataSource = dt_BaoCao;
            if (dt_BaoCao != null && dt_BaoCao.Rows.Count > 0)
            {
                grvDuLieu.FocusedRowHandle = 0;
            }
        }
Esempio n. 2
0
        private void refreshToolStripButton_Click(object sender, EventArgs e)
        {
            int i_TongBanNang = 0;
            int i_BanNangBan  = 0;

            if (m_dbConnection == null || m_dbConnection.State != ConnectionState.Open)
            {
                m_dbConnection = new SQLiteConnection("Data Source=sled.sqlite;Version=3;");
                m_dbConnection.Open();
            }
            if (m_dbConnection.State == ConnectionState.Open)
            {
                try
                {
                    string sql = "select * from bannang order by id asc";
                    dt_HoatDongBanNang = ThuVien.SQLiteLoad(m_dbConnection, sql);

                    if (dt_HoatDongBanNang != null && dt_HoatDongBanNang.Rows.Count > 0)
                    {
                        dt_HoatDongBanNang.Columns.Add("thoigianconlai", typeof(decimal)).DefaultValue = 0;
                        i_TongBanNang = dt_HoatDongBanNang.Rows.Count;
                        foreach (DataRow r in dt_HoatDongBanNang.Rows)
                        {
                            if (Convert.ToInt32(r["counter"]) == 0)
                            {
                                r["trangthai"]      = "Rảnh";
                                r["khachhang"]      = "";
                                r["biensoxe"]       = "";
                                r["thoigianconlai"] = 0;
                            }
                            else
                            {
                                DateTime TGCapNhat = Convert.ToDateTime(r["time"]);
                                TimeSpan diff      = DateTime.Now.Subtract(TGCapNhat);
                                double   minutes   = diff.TotalMinutes;
                                r["thoigianconlai"] = Convert.ToInt32(minutes) >= Convert.ToInt32(r["counter"]) ? 0 : Convert.ToInt32(r["counter"]) - Convert.ToInt32(minutes);
                                r["trangthai"]      = "Bận";
                                i_BanNangBan++;
                            }
                        }
                    }
                    txtTrangThaiBanNang.Caption = String.Format("Hoạt động: {0}/{1}", i_BanNangBan, i_TongBanNang);
                    grdDuLieu.DataSource        = dt_HoatDongBanNang;
                    if (dt_HoatDongBanNang != null && dt_HoatDongBanNang.Rows.Count > 0)
                    {
                        grvDuLieu.FocusedRowHandle = 0;
                    }
                }
                catch
                {
                }
            }
        }
Esempio n. 3
0
 private void frmMain_Load(object sender, EventArgs e)
 {
     //this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
     try
     {
         string sFileDataBase = Application.ExecutablePath;
         int    i_Index       = sFileDataBase.LastIndexOf('\\');
         sFileDataBase = sFileDataBase.Substring(0, i_Index).Trim('\\');
         sFileDataBase = sFileDataBase + "\\" + s_Database;
         if (File.Exists(sFileDataBase) == false)
         {
             CreatNewDatabase();
         }
     }
     catch
     {
     }
     if (m_dbConnection == null || m_dbConnection.State != ConnectionState.Open)
     {
         m_dbConnection = new SQLiteConnection("Data Source=sled.sqlite;Version=3;");
         m_dbConnection.Open();
     }
     if (m_dbConnection.State == ConnectionState.Open)
     {
         try
         {
             string    sql = "select * from port order by time asc";
             DataTable dt  = ThuVien.SQLiteLoad(m_dbConnection, sql);
             if (dt != null && dt.Rows.Count > 0)
             {
                 DataRow r = dt.Rows[dt.Rows.Count - 1];
                 s_SerialPort = r["name"].ToString();
             }
         }
         catch
         {
         }
     }
     txtTTCongGiaoTiep.Caption = s_SerialPort;
     refreshToolStripButton_Click(null, null);
 }
Esempio n. 4
0
 private void btnDongY_Click(object sender, EventArgs e)
 {
     if (cbbSerialPorts.SelectedIndex > -1)
     {
         if (SQLiteCon == null || SQLiteCon.State != ConnectionState.Open)
         {
             SQLiteCon = new SQLiteConnection("Data Source=sled.sqlite;Version=3;");
             SQLiteCon.Open();
         }
         if (SQLiteCon.State == ConnectionState.Open)
         {
             string    sql = "select * from port";
             DataTable dt  = ThuVien.SQLiteLoad(SQLiteCon, sql);
             sql = "insert into port (id,name, baud) values (1,'" + cbbSerialPorts.SelectedItem.ToString() + "', 115200)";
             if (dt != null && dt.Rows.Count > 0)
             {
                 DataRow[] r_Col = dt.Select("id=1");
                 if (r_Col != null && r_Col.Length > 0)
                 {
                     sql = "UPDATE port SET name = '" + cbbSerialPorts.SelectedItem.ToString() + "' WHERE ID = 1";
                 }
             }
             try
             {
                 SQLiteCommand command = new SQLiteCommand(sql, SQLiteCon);
                 command.ExecuteNonQuery();
             }
             catch { }
         }
         b_ThayDoi = true;
     }
     else
     {
         MessageBox.Show("Dữ liệu không hợp lệ", "Lỗi!");
     }
     this.Close();
 }
        private void btnLuu_Click(object sender, EventArgs e)
        {
            if (dt_BaoCao != null && dt_BaoCao.Rows.Count > 0)
            {
                XoaDuLieuBaoCao_ThangTruoc();
                try
                {
                    SaveFileDialog objSaveFileDialog = new SaveFileDialog();
                    objSaveFileDialog.Filter = "Excel2003 Excel|*.xls|Excel2007 Excel|*.xlsx";
                    objSaveFileDialog.ShowDialog();


                    if (!string.IsNullOrEmpty(objSaveFileDialog.FileName.Trim()))
                    {
                        string[] strList = objSaveFileDialog.FileName.Split('.');
                        if (strList.Length > 0)
                        {
                            string s_FilePath = objSaveFileDialog.FileName;
                            switch (strList[strList.Length - 1].ToString().Trim())
                            {
                            case "xls":
                                grdDuLieu.ExportToXls(objSaveFileDialog.FileName);
                                break;

                            case "xlsx":
                                grdDuLieu.ExportToXlsx(objSaveFileDialog.FileName);
                                break;
                            }
                            Excel.Application oxl     = new Excel.Application();
                            int              i_SoCot  = dt_BaoCao.Columns.Count;
                            int              i_SoDong = dt_BaoCao.Rows.Count;
                            Excel.Workbook   owb      = oxl.Workbooks.Open(s_FilePath, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value, System.Reflection.Missing.Value);
                            Excel._Worksheet osheet   = (Excel._Worksheet)owb.ActiveSheet;
                            oxl.ActiveWindow.DisplayGridlines = true;
                            int i_SoDongTieuDe = 5;
                            for (int i_Dong = 0; i_Dong < i_SoDongTieuDe; i_Dong++)//insert các dòng tiêu đề
                            {
                                osheet.get_Range(ThuVien.ColumnExcel(i_Dong) + "1", ThuVien.ColumnExcel(i_Dong) + "1").EntireRow.Insert(Missing.Value);
                            }
                            oxl.ActiveWindow.DisplayZeros = false;

                            //Định dạng phần header.
                            //Thiết lập vùng điền dữ liệu.
                            int rowStart_h    = 1;
                            int columnStart_h = 1;
                            int rowEnd_h      = rowStart_h + i_SoDongTieuDe + 1;
                            int columnEnd_h   = dt_BaoCao.Columns.Count + 2;
                            // Ô bắt đầu điền dữ liệu
                            Excel.Range c1 = (Excel.Range)osheet.Cells[rowStart_h, columnStart_h];
                            // Ô kết thúc điền dữ liệu
                            Excel.Range c2 = (Excel.Range)osheet.Cells[rowEnd_h, columnEnd_h];
                            //Căn giữa vùng dữ liệu
                            osheet.get_Range(c1, c2).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;
                            osheet.get_Range(c1, c2).Font.Bold           = true;
                            //Định dạng phần footer.
                            int         rowStart_f = i_SoDongTieuDe + i_SoDong + 4;
                            int         rowEnd_f   = i_SoDongTieuDe + i_SoDong + 6;
                            Excel.Range c3         = (Excel.Range)osheet.Cells[rowStart_f, columnStart_h];
                            Excel.Range c4         = (Excel.Range)osheet.Cells[rowEnd_f, columnEnd_h];
                            osheet.get_Range(c3, c4).HorizontalAlignment = Excel.XlHAlign.xlHAlignCenter;

                            //set font chữ từ đầu dòng đến cuối dòng dữ liệu
                            Excel.Range orange = osheet.get_Range("A1", ThuVien.ColumnExcel(i_SoCot + 1) + (i_SoDongTieuDe + 1).ToString());
                            orange.Font.Bold            = true;
                            orange                      = osheet.get_Range("A1", ThuVien.ColumnExcel(i_SoCot) + (i_SoDongTieuDe + i_SoDong + 6).ToString());
                            orange.VerticalAlignment    = Excel.XlVAlign.xlVAlignCenter;
                            orange.WrapText             = false;
                            orange.RowHeight            = 180;
                            orange.Cells.Interior.Color = System.Drawing.Color.White;
                            orange.EntireRow.AutoFit();
                            orange = osheet.get_Range("A" + (i_SoDongTieuDe + 2).ToString(), ThuVien.ColumnExcel(i_SoCot - 3) + (i_SoDongTieuDe + i_SoDong + 2).ToString());
                            orange.Cells.BorderAround(4, Excel.XlBorderWeight.xlHairline, Excel.XlColorIndex.xlColorIndexAutomatic, 0);
                            for (int i = i_SoDongTieuDe + 2; i <= i_SoDongTieuDe + i_SoDong + 2; i++)
                            {
                                orange = osheet.get_Range("A" + i.ToString(), ThuVien.ColumnExcel(i_SoCot - 1) + i.ToString());
                                orange.Cells.BorderAround(4, Excel.XlBorderWeight.xlHairline, Excel.XlColorIndex.xlColorIndexAutomatic, 0);
                            }
                            osheet.PageSetup.LeftMargin   = 20;
                            osheet.PageSetup.RightMargin  = 20;
                            osheet.PageSetup.TopMargin    = 30;
                            osheet.PageSetup.CenterFooter = "Trang : &P/&N";
                            oxl.Visible = true;

                            orange = osheet.get_Range("A1", ThuVien.ColumnExcel(i_SoCot) + (i_SoDongTieuDe + i_SoDong + 6).ToString());
                            orange.Cells.Font.Size = 11;
                            orange.EntireColumn.AutoFit();
                            osheet.PageSetup.Orientation = Excel.XlPageOrientation.xlLandscape;
                            osheet.PageSetup.PaperSize   = Excel.XlPaperSize.xlPaperA4;

                            osheet.Cells[3, 3]           = "BÁO CÁO HOẠT ĐỘNG BÀN NÂNG";
                            osheet.Cells[3, 3].Font.Bold = true;
                            osheet.Cells[3, 3].Font.Size = 16;

                            osheet.Cells[i_SoDongTieuDe + i_SoDong + 5, 4] = "Người lập biểu";
                            osheet.Cells[i_SoDongTieuDe + i_SoDong + 6, 4] = "(Ký tên, đóng dấu)";
                            string s_NgayIn = "Ngày " + DateTime.Today.Day + " tháng " + DateTime.Today.Month + " năm " + DateTime.Today.Year;
                            osheet.Cells[i_SoDongTieuDe + i_SoDong + 4, 4] = s_NgayIn;
                        }
                    }
                }
                catch { }
            }
            else
            {
                MessageBox.Show("Không tìm thấy dữ liệu báo cáo!", "Thông báo");
            }
        }
Esempio n. 6
0
        private void TuyChinhBanNang(int mode)
        {
            string s_time = DateTime.Now.ToString("yymmddhhmmssfff");

            if (s_SerialPort == null || s_SerialPort == "")
            {
                MessageBox.Show("Bạn chưa thiết lập cổng COM", "Cảnh báo");
            }
            else
            {
                try
                {
                    string    s_QuangCao    = "";
                    string    s_TTKhachHang = "";
                    string    s_Counter     = "";
                    string    s_TTBienSoXe  = "";
                    string    s_KTV         = "";
                    bool      b_TaoMoi      = true;
                    Decimal   d_TongTG      = 0;
                    string    s_BanNang     = grvDuLieu.GetRowCellValue(grvDuLieu.FocusedRowHandle, "id").ToString();
                    string    sql           = "select * from bannang where  id = " + s_BanNang;
                    DataTable dt            = ThuVien.SQLiteLoad(m_dbConnection, sql);
                    if (dt != null && dt.Rows.Count > 0)
                    {
                        DataRow r = dt.Rows[dt.Rows.Count - 1];
                        if (r["maql"].ToString() == "0")
                        {
                            //sql = "UPDATE bannang SET maql = '" + s_time + "' WHERE id = " + s_BanNang;
                            s_MaQL = s_time;
                        }
                        else
                        {
                            s_MaQL        = r["maql"].ToString();
                            s_TTKhachHang = r["khachhang"].ToString();
                            s_TTBienSoXe  = r["biensoxe"].ToString();
                            b_TaoMoi      = false;
                        }
                        d_TongTG   = Convert.ToDecimal(r["counter"]);
                        s_Counter  = r["counter"].ToString();
                        s_KTV      = r["ktv"].ToString();
                        s_QuangCao = r["greetings"].ToString();
                    }

                    if (mode > -1)
                    {
                        switch (mode)
                        {
                        case 0:
                            frmTiepNhanXe frmTNX = new frmTiepNhanXe(m_dbConnection, s_SerialPort, s_BanNang, b_TaoMoi, s_MaQL, s_TTKhachHang, s_TTBienSoXe, s_KTV, d_TongTG);
                            frmTNX.ShowDialog();
                            break;

                        case 1:
                            frmDCTGSuaChua frmDCTG = new frmDCTGSuaChua(m_dbConnection, s_SerialPort, s_BanNang, d_TongTG);
                            frmDCTG.ShowDialog();
                            break;

                        case 2:
                            frmTraXe frmTX = new frmTraXe(m_dbConnection, s_SerialPort, s_BanNang, s_MaQL, s_TTKhachHang, s_TTBienSoXe, s_KTV, d_TongTG, b_TaoMoi);
                            frmTX.ShowDialog();
                            break;

                        case 3:
                            frmTTCauHinhBN frmTTCHBN = new frmTTCauHinhBN(m_dbConnection, s_SerialPort, s_BanNang, s_QuangCao, s_KTV);
                            frmTTCHBN.ShowDialog();
                            break;

                        default:
                            break;
                        }
                        refreshToolStripButton_Click(null, null);
                    }
                }
                catch
                {
                    validationForm_FormClosed(null, null);
                }
            }
        }