/// <summary>
/// Hàm cập nhật hộ chiếu
/// </summary>
/// <param name="value">hộ chiếu cần cập nhật</param>
/// <returns>bool</returns>
public static bool CapNhatHoChieu(HoChieu value)
{
String sql = "UPDATE HoChieu SET TenHoChieu = '" + value.TenHoChieu + "', ChieuCaoTang = '" + value.ChieuCaoTang + "', QuyMoDotNo ='" + value.QuyMoDotNo + "', MaCongTruong = '" + value.MaCongTruong + "', MaDatDa = '" + value.MaDatDa + "', MaMayKhoan = '" + value.MaMayKhoan + "', MaKipNo = '" + value.MaKipNo + "', MaThuocNo = '" + value.MaThuocNo + "', MaPPNo = '" + value.MaPPNo + "', MaPhuKien = '" + value.MaPhuKien + "', MaCapDo = '" + value.MaCapDo + "', NgayLap = '" + value.NgayLap + "', HeSoKC = '" + value.HeSoKC + "', KichThuoc_X = '" + value.KichThuoc_X + "', KichThuoc_Y = '" + value.KichThuoc_Y + "' WHERE MaHoChieu = '" + value.MaHoChieu + "'";
Connection conn = new Connection();
return(conn.SetData(sql));
}
/// <summary>
/// Hàm thêm hộ chiếu
/// </summary>
/// <param name="value">hộ chiếu cần thêm</param>
/// <returns>bool</returns>
public static bool ThemHoChieu(HoChieu value)
{
String sql = "INSERT INTO HoChieu (MaBanVe, TenHoChieu, ChieuCaoTang, QuyMoDotNo, MaCongTruong, MaDatDa, MaMayKhoan, MaKipNo, MaThuocNo, MaPPNo, MaPhuKien, MaCapDo, NgayLap, HeSoKC, KichThuoc_X, KichThuoc_Y) VALUES ('" + value.MaBanVe + "', '" + value.TenHoChieu + "', '" + value.ChieuCaoTang + "', '" + value.QuyMoDotNo + "', '" + value.MaCongTruong + "', '" + value.MaDatDa + "', '" + value.MaMayKhoan + "', '" + value.MaKipNo + "', '" + value.MaThuocNo + "', '" + value.MaPPNo + "', '" + value.MaPhuKien + "', '" + value.MaCapDo + "', '" + value.NgayLap + "', '" + value.HeSoKC + "', '" + value.KichThuoc_X + "', '" + value.KichThuoc_Y + "')";
Connection conn = new Connection();
return(conn.SetData(sql));
}
/// <summary>
/// Hàm lấy thông tin hộ chiếu nổ mìn
/// </summary>
/// <param name="id">mã hộ chiếu</param>
/// <returns>HoChieu</returns>
public static HoChieu HoChieu(String id)
{
HoChieu hoChieu = new HoChieu();
Connection conn = new Connection();
string sql = "SELECT * FROM HoChieu WHERE MaHoChieu = '" + id + "'";
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
hoChieu = new HoChieu(dr["MaHoChieu"].ToString(), dr["MaBanVe"].ToString(), dr["TenHoChieu"].ToString(), ((dr["ChieuCaoTang"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["ChieuCaoTang"])), ((dr["QuyMoDotNo"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["QuyMoDotNo"])), dr["MaCongTruong"].ToString(), dr["MaDatDa"].ToString(), dr["MaMayKhoan"].ToString(), dr["MaKipNo"].ToString(), dr["MaThuocNo"].ToString(), dr["MaPPNo"].ToString(), dr["MaPhuKien"].ToString(), dr["MaCapDo"].ToString(), dr["NgayLap"].ToString(), ((dr["HeSoKC"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["HeSoKC"])), ((dr["KichThuoc_X"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["KichThuoc_X"])), ((dr["KichThuoc_Y"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["KichThuoc_Y"])));
}
return hoChieu;
}
/// <summary>
/// Hàm lấy thông tin hộ chiếu nổ mìn
/// </summary>
/// <param name="id">mã hộ chiếu</param>
/// <returns>HoChieu</returns>
public static HoChieu HoChieu(String id)
{
HoChieu hoChieu = new HoChieu();
Connection conn = new Connection();
string sql = "SELECT * FROM HoChieu WHERE MaHoChieu = '" + id + "'";
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
hoChieu = new HoChieu(dr["MaHoChieu"].ToString(), dr["MaBanVe"].ToString(), dr["TenHoChieu"].ToString(), ((dr["ChieuCaoTang"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["ChieuCaoTang"])), ((dr["QuyMoDotNo"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["QuyMoDotNo"])), dr["MaCongTruong"].ToString(), dr["MaDatDa"].ToString(), dr["MaMayKhoan"].ToString(), dr["MaKipNo"].ToString(), dr["MaThuocNo"].ToString(), dr["MaPPNo"].ToString(), dr["MaPhuKien"].ToString(), dr["MaCapDo"].ToString(), dr["NgayLap"].ToString(), ((dr["HeSoKC"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["HeSoKC"])), ((dr["KichThuoc_X"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["KichThuoc_X"])), ((dr["KichThuoc_Y"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["KichThuoc_Y"])));
}
return(hoChieu);
}
/// <summary>
/// Hàm tạo hộ chiếu
/// </summary>
/// <param name="tenHoChieu">Tên hộ chiếu</param>
/// <returns>ID hộ chiếu vừa tạo</returns>
public static String TaoHoChieu(String idTemplate, String tenHoChieu)
{
Connection conn = new Connection();
SQLiteDataReader dr;
HoChieu hoChieuVuaTao = new HoChieu();
bool flag = true;
//kiểm tra tên hộ chiếu có trùng ko
List <HoChieu> danhSachHoChieu = BS_HoChieu.DanhSachHoChieu();
foreach (HoChieu value in danhSachHoChieu)
{
if (value.TenHoChieu == tenHoChieu)
{
flag = false; break;
}
}
//nếu ko trùng => tạo hộ chiếu mới, trả về id hộ chiếu vừa tạo
if (flag)
{
//tạo bản vẽ mới cho hộ chiếu
String idBanVe = BS_BanVe.TaoBanVe(idTemplate, tenHoChieu);
if (idBanVe == null)
{
return(null);
}
else
{
String sql = "INSERT INTO HoChieu (MaBanVe, TenHoChieu, NgayLap) VALUES ('" + idBanVe + "', '" + tenHoChieu + "', '" + DateTime.Now.ToString() + "')";
conn.SetData(sql);
sql = "SELECT * FROM HoChieu WHERE TenHoChieu = '" + tenHoChieu + "'";
dr = conn.GetData(sql);
while (dr.Read())
{
hoChieuVuaTao = new HoChieu(dr["MaHoChieu"].ToString(), dr["MaBanVe"].ToString(), dr["TenHoChieu"].ToString(), ((dr["ChieuCaoTang"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["ChieuCaoTang"])), ((dr["QuyMoDotNo"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["QuyMoDotNo"])), dr["MaCongTruong"].ToString(), dr["MaDatDa"].ToString(), dr["MaMayKhoan"].ToString(), dr["MaKipNo"].ToString(), dr["MaThuocNo"].ToString(), dr["MaPPNo"].ToString(), dr["MaPhuKien"].ToString(), dr["MaCapDo"].ToString(), dr["NgayLap"].ToString(), ((dr["HeSoKC"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["HeSoKC"])), ((dr["KichThuoc_X"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["KichThuoc_X"])), ((dr["KichThuoc_Y"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["KichThuoc_Y"])));
}
return(hoChieuVuaTao.MaHoChieu);
}
}
//nếu trùng => trả về null
else
{
return(null);
}
}
public FormBaoCaoThongKe(HoChieu _HoChieu)
{
InitializeComponent();
//add text control
textLabel.Add(labelText);
textLabel.Add(labelText3);
textLabel.Add(label_GiaTri1);
textLabel.Add(label_GiaTri2);
textLabel.Add(label_GiaTri3);
textLabel.Add(label_GiaTri4);
textLabel.Add(label_GiaTri5);
textLabel.Add(label_GiaTri6);
textLabel.Add(label_GiaTri7);
//add value control
valueLabel.Add(labelValue_GiaTri1);
valueLabel.Add(labelValue_GiaTri2);
valueLabel.Add(labelValue_GiaTri3);
valueLabel.Add(labelValue_GiaTri4);
valueLabel.Add(labelValue_GiaTri5);
valueLabel.Add(labelValue_GiaTri6);
valueLabel.Add(labelValue_GiaTri7);
//add combobox control
valueComboBox.Add(comboBox_MaHoChieu);
//add button control
buttonGroup.Add(buttonTaoMoi);
//UI
this.BackColor = Properties.Settings.Default.FormBackgroundColor;
this.MinimizeBox = false;
this.MaximizeBox = false;
foreach (Button b in buttonGroup)
{
b.BackColor = Properties.Settings.Default.ButtonColor;
b.FlatAppearance.BorderSize = 0;
}
foreach (Label l in textLabel)
{
l.ForeColor = Properties.Settings.Default.TextColor;
}
idHoChieu = _HoChieu.MaHoChieu;
comboBox_MaHoChieu.DataSource = BS_HoChieu.DanhSachHoChieu();
comboBox_MaHoChieu.DisplayMember = "TenHoChieu";
comboBox_MaHoChieu.Text = _HoChieu.TenHoChieu;
}
private void loadFile_FormMoBanVeDatabase(String idHoChieu)
{
this.hoChieuChinh = BS_HoChieu.HoChieu(idHoChieu);
this.banVeChinh = BS_BanVe.BanVe(this.hoChieuChinh.MaBanVe);
List<LoKhoan> danhSachLoKhoan = BS_LoKhoan.DanhSachLoKhoan(idHoChieu);
List<Circle> danhSachCircle = new List<Circle>();
mgCircles = new ManageCircle();
//dựng bản vẽ mới
//this.banVeChinh.HienKhoangCach = false;
this.Text = "Bản vẽ: [" + this.banVeChinh.TenBanVe + "]";
Lcad.DrwLoad(hDrw, BS_Template.ChonTemplate(this.banVeChinh.Template).DuongDan, this.Handle, hWnd);
layerLoMin = Lcad.DrwAddLayer(hDrw, "LoMin", "cyan", 0, Lcad.LC_LWEIGHT_DEFAULT);
layerLuoiKichThuoc = Lcad.DrwAddLayer(hDrw, "LuoiKichThuoc", "foreground", 0, Lcad.LC_LWEIGHT_DEFAULT);
int hBlockModel = Lcad.PropGetHandle(hDrw, Lcad.LC_PROP_DRW_BLOCK_MODEL);
foreach (LoKhoan value in danhSachLoKhoan)
{
int hEntCircle = Lcad.BlockAddCircle(hBlockModel, value.ToaDoX, value.ToaDoY, value.BanKinh, false);
Lcad.PropPutInt(hEntCircle, Lcad.LC_PROP_ENT_ID, int.Parse(value.MaLoKhoan));
Lcad.PropPutInt(hEntCircle, Lcad.LC_PROP_ENT_KEY, keyCircle);
Lcad.PropPutStr(hEntCircle, Lcad.LC_PROP_ENT_LAYER, "LoMin");
danhSachCircle.Add(new Circle(hEntCircle));
}
mgCircles.AddListCircle(danhSachCircle);
if (banVeChinh.HienKhoangCach)
{
Lcad.LayerClear(layerLuoiKichThuoc, hBlockModel);
DungLuoiKichThuoc();
}
//vẽ lại hình
Lcad.DrwRegenViews(hDrw, 0);
Lcad.WndExeCommand(hWnd, Lcad.LC_CMD_ZOOM_EXT, 0);
BS_LiteCAD.ShowNotifyAutoHide(elementHost1, this.banVeChinh.TenBanVe + " - đã mở");
//mở form dựng lưới lỗ khoan
if(mgCircles.GetListCircles().Count == 0)
{
FormXayDungLoKhoan fm = new FormXayDungLoKhoan();
fm.MyGetData = new FormXayDungLoKhoan.GetData(loadFile_FormXayDungLoKhoan);
fm.Show();
}
}
//mở bản vẽ
private void barButtonItem_OpenFile_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
try
{
//filename = Lcad.DgGetFileName(panelControl_hWnd.Handle, Lcad.LC_DG_SELFILE);
OpenFileDialog filename = new OpenFileDialog();
filename.Title = "Open file LiteCAD";
filename.Filter = "Drawing liteCAD|*.lcd;*.dwg;*.dxf;*.shp|all file|*.*";
if (filename.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
if (filename.FileName != "")
{
this.hoChieuChinh = new HoChieu();
this.banVeChinh = new BanVe();
//this.banVeChinh.HienKhoangCach = false;
this.Text = "Bản vẽ: [" + filename.FileName + "]";
Lcad.DrwLoad(hDrw, filename.FileName, this.Handle, hWnd);
layerLoMin = Lcad.DrwAddLayer(hDrw, "LoMin", "cyan", 0, Lcad.LC_LWEIGHT_DEFAULT);
layerLuoiKichThuoc = Lcad.DrwAddLayer(hDrw, "LuoiKichThuoc", "foreground", 0, Lcad.LC_LWEIGHT_DEFAULT);
GetCirlcesFromAutocadFile();
Lcad.DrwRegenViews(hDrw, 0);
BS_LiteCAD.ShowNotifyAutoHide(elementHost1, "Bản vẽ sẵn sàng");
}
}
}
catch
{
BS_LiteCAD.ShowNotifyAutoHide(elementHost1, "Không hiển thị được bản vẽ");
}
}
private void loadFile_FormBanVeMoi(String idHoChieu)
{
this.hoChieuChinh = BS_HoChieu.HoChieu(idHoChieu);
this.banVeChinh = BS_BanVe.BanVe(this.hoChieuChinh.MaBanVe);
mgCircles = new ManageCircle();
//dựng bản vẽ mới
this.Text = "Hộ chiếu: [" + this.hoChieuChinh.TenHoChieu + "]";
Lcad.DrwLoad(hDrw, BS_Template.ChonTemplate(this.banVeChinh.Template).DuongDan, this.Handle, hWnd);
layerLoMin = Lcad.DrwAddLayer(hDrw, "LoMin", "cyan", 0, Lcad.LC_LWEIGHT_DEFAULT);
layerLuoiKichThuoc = Lcad.DrwAddLayer(hDrw, "LuoiKichThuoc", "foreground", 0, Lcad.LC_LWEIGHT_DEFAULT);
//vẽ lại hình
Lcad.DrwRegenViews(hDrw, 0);
Lcad.WndExeCommand(hWnd, Lcad.LC_CMD_ZOOM_EXT, 0);
//mở form dựng lưới lỗ khoan
if (mgCircles.GetListCircles().Count == 0)
{
FormXayDungLoKhoan fm = new FormXayDungLoKhoan();
fm.MyGetData = new FormXayDungLoKhoan.GetData(loadFile_FormXayDungLoKhoan);
fm.Show();
}
}
private void buttonInsert_Click(object sender, EventArgs e)
{
HoChieu inserted = new HoChieu();
if (textBoxMaHoChieu2.Text != String.Empty) { inserted.MaHoChieu = textBoxMaHoChieu2.Text; }
if (textBoxTenHoChieu2.Text != String.Empty) { inserted.TenHoChieu = textBoxTenHoChieu2.Text; }
inserted.NgayLap = DateTime.Now.ToString();
if (comboBox_CongTruong2.Text != String.Empty) { inserted.MaCongTruong = (comboBox_CongTruong2.SelectedItem as CongTruong).MaCongTruong; }
if (comboBox_DatDa2.Text != String.Empty) { inserted.MaDatDa = (comboBox_DatDa2.SelectedItem as DatDa).MaDatDa; }
if (comboBox_MayKhoan2.Text != String.Empty) { inserted.MaMayKhoan = (comboBox_MayKhoan2.SelectedItem as MayKhoan).MaMayKhoan; }
if (comboBox_KipNo2.Text != String.Empty) { inserted.MaKipNo = (comboBox_KipNo2.SelectedItem as KipNo).MaKipNo; }
if (comboBox_ThuocNo2.Text != String.Empty) { inserted.MaThuocNo = (comboBox_ThuocNo2.SelectedItem as ThuocNo).MaThuocNo; }
if (comboBox_PhuongPhapNo2.Text != String.Empty) { inserted.MaPPNo = (comboBox_PhuongPhapNo2.SelectedItem as PhuongPhapNo).MaPPNo; }
if (comboBox_PhuKien2.Text != String.Empty) { inserted.MaPhuKien = (comboBox_PhuKien2.SelectedItem as PhuKienNo).MaPhuKien; }
if (comboBox_CapDo2.Text != String.Empty) { inserted.MaCapDo = (comboBox_CapDo2.SelectedItem as CapDoNo).MaCapDo; }
inserted.HeSoKC = double.Parse(textBoxHeSoKC2.Text);
inserted.ChieuCaoTang = double.Parse(textBoxChieuCaoTang2.Text);
inserted.QuyMoDotNo = double.Parse(textBoxQuyMoDotNo2.Text);
inserted.KichThuoc_X = double.Parse(textBoxKichThuoc_X2.Text);
inserted.KichThuoc_Y = double.Parse(textBoxKichThuoc_Y2.Text);
try
{
BS_HoChieu.ThemHoChieu(inserted);
}
catch (Exception exc)
{
MessageBox.Show("Lỗi - " + exc.Message);
}
ShowPanel(1);
HienThiDuLieu_HoChieu();
}
/// <summary>
/// Hàm thêm hộ chiếu
/// </summary>
/// <param name="value">hộ chiếu cần thêm</param>
/// <returns>bool</returns>
public static bool ThemHoChieu(HoChieu value)
{
String sql = "INSERT INTO HoChieu (MaBanVe, TenHoChieu, ChieuCaoTang, QuyMoDotNo, MaCongTruong, MaDatDa, MaMayKhoan, MaKipNo, MaThuocNo, MaPPNo, MaPhuKien, MaCapDo, NgayLap, HeSoKC, KichThuoc_X, KichThuoc_Y) VALUES ('" + value.MaBanVe + "', '" + value.TenHoChieu + "', '" + value.ChieuCaoTang + "', '" + value.QuyMoDotNo + "', '" + value.MaCongTruong + "', '" + value.MaDatDa + "', '" + value.MaMayKhoan + "', '" + value.MaKipNo + "', '" + value.MaThuocNo + "', '" + value.MaPPNo + "', '" + value.MaPhuKien + "', '" + value.MaCapDo + "', '" + value.NgayLap + "', '" + value.HeSoKC + "', '" + value.KichThuoc_X + "', '" + value.KichThuoc_Y + "')";
Connection conn = new Connection();
return conn.SetData(sql);
}
/// <summary>
/// Hàm tạo hộ chiếu
/// </summary>
/// <param name="tenHoChieu">Tên hộ chiếu</param>
/// <returns>ID hộ chiếu vừa tạo</returns>
public static String TaoHoChieu(String idTemplate, String tenHoChieu)
{
Connection conn = new Connection();
SQLiteDataReader dr;
HoChieu hoChieuVuaTao = new HoChieu();
bool flag = true;
//kiểm tra tên hộ chiếu có trùng ko
List<HoChieu> danhSachHoChieu = BS_HoChieu.DanhSachHoChieu();
foreach (HoChieu value in danhSachHoChieu)
{
if (value.TenHoChieu == tenHoChieu)
{
flag = false; break;
}
}
//nếu ko trùng => tạo hộ chiếu mới, trả về id hộ chiếu vừa tạo
if (flag)
{
//tạo bản vẽ mới cho hộ chiếu
String idBanVe = BS_BanVe.TaoBanVe(idTemplate, tenHoChieu);
if (idBanVe == null)
{
return null;
}
else
{
String sql = "INSERT INTO HoChieu (MaBanVe, TenHoChieu, NgayLap) VALUES ('" + idBanVe + "', '" + tenHoChieu + "', '" + DateTime.Now.ToString() + "')";
conn.SetData(sql);
sql = "SELECT * FROM HoChieu WHERE TenHoChieu = '" + tenHoChieu + "'";
dr = conn.GetData(sql);
while (dr.Read())
{
hoChieuVuaTao = new HoChieu(dr["MaHoChieu"].ToString(), dr["MaBanVe"].ToString(), dr["TenHoChieu"].ToString(), ((dr["ChieuCaoTang"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["ChieuCaoTang"])), ((dr["QuyMoDotNo"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["QuyMoDotNo"])), dr["MaCongTruong"].ToString(), dr["MaDatDa"].ToString(), dr["MaMayKhoan"].ToString(), dr["MaKipNo"].ToString(), dr["MaThuocNo"].ToString(), dr["MaPPNo"].ToString(), dr["MaPhuKien"].ToString(), dr["MaCapDo"].ToString(), dr["NgayLap"].ToString(), ((dr["HeSoKC"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["HeSoKC"])), ((dr["KichThuoc_X"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["KichThuoc_X"])), ((dr["KichThuoc_Y"].ToString() == String.Empty) ? -1 : Convert.ToDouble(dr["KichThuoc_Y"])));
}
return hoChieuVuaTao.MaHoChieu;
}
}
//nếu trùng => trả về null
else
{
return null;
}
}
/// <summary>
/// Hàm cập nhật hộ chiếu
/// </summary>
/// <param name="value">hộ chiếu cần cập nhật</param>
/// <returns>bool</returns>
public static bool CapNhatHoChieu(HoChieu value)
{
String sql = "UPDATE HoChieu SET TenHoChieu = '" + value.TenHoChieu + "', ChieuCaoTang = '" + value.ChieuCaoTang + "', QuyMoDotNo ='" + value.QuyMoDotNo + "', MaCongTruong = '" + value.MaCongTruong + "', MaDatDa = '" + value.MaDatDa + "', MaMayKhoan = '" + value.MaMayKhoan + "', MaKipNo = '" + value.MaKipNo + "', MaThuocNo = '" + value.MaThuocNo + "', MaPPNo = '" + value.MaPPNo + "', MaPhuKien = '" + value.MaPhuKien + "', MaCapDo = '" + value.MaCapDo + "', NgayLap = '" + value.NgayLap + "', HeSoKC = '" + value.HeSoKC + "', KichThuoc_X = '" + value.KichThuoc_X + "', KichThuoc_Y = '" + value.KichThuoc_Y + "' WHERE MaHoChieu = '" + value.MaHoChieu + "'";
Connection conn = new Connection();
return conn.SetData(sql);
}
