/// <summary>
/// Hàm trả về danh sách thuốc nổ
/// </summary>
/// <returns>List<ThuocNo></returns>
public static List<ThuocNo> DanhSachThuocNo()
{
List<ThuocNo> danhSachThuocNo = new List<ThuocNo>();
Connection conn = new Connection();
string sql = "SELECT * FROM ThuocNo";
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
danhSachThuocNo.Add(new ThuocNo(dr["MaThuocNo"].ToString(), dr["TenThuocNo"].ToString(), dr.GetDouble(2), dr.GetDouble(3), dr.GetDouble(4), dr["ChiuNuoc"].ToString(), dr.GetDouble(6), dr.GetDouble(7), dr.GetDouble(8)));
}
return danhSachThuocNo;
}
/// <summary>
/// Hàm trả về danh sách phương pháp nổ
/// </summary>
/// <returns>List<PhuongPhapNo></returns>
public static List<PhuongPhapNo> DanhSachPPNo()
{
List<PhuongPhapNo> danhSachPPNo = new List<PhuongPhapNo>();
Connection conn = new Connection();
string sql = "SELECT * FROM PhuongPhapNo";
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
danhSachPPNo.Add(new PhuongPhapNo(dr["MaPPNo"].ToString(), dr["TenPPNo"].ToString(), dr["MaCongTruong"].ToString(), dr.GetDouble(3), dr.GetDouble(4)));
}
return danhSachPPNo;
}
/// <summary>
/// Hàm lấy bản vẽ từ ID tương ứng
/// </summary>
/// <param name="ID">ID bản vẽ</param>
/// <returns>BanVe</returns>
public static BanVe BanVe(String ID)
{
BanVe danhSachBanVe = new BanVe();
String sql = "SELECT * FROM BanVe WHERE ID = '" + ID + "'";
Connection conn = new Connection();
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
danhSachBanVe = new BanVe(dr["ID"].ToString(), dr["Template"].ToString(), dr["TenBanVe"].ToString(), dr.GetString(3), dr.GetDouble(4), dr.GetDouble(5), dr["NguoiDung"].ToString(), (dr.GetInt32(7) == 1)? true:false);
}
return danhSachBanVe;
}
/// <summary>
/// Hàm lấy danh sách lỗ khoan
/// </summary>
/// <returns>List<LoKhoan></returns>
public static List<LoKhoan> DanhSachLoKhoan()
{
List<LoKhoan> danhSachLoKhoan = new List<LoKhoan>();
Connection conn = new Connection();
string sql = "SELECT * FROM LoKhoan";
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
danhSachLoKhoan.Add(new LoKhoan(dr["ID"].ToString(), dr["MaHoChieu"].ToString(), dr["MaBanVe"].ToString(), dr["MaMayKhoan"].ToString(), dr["MaLK"].ToString(), dr.GetDouble(5), dr.GetDouble(6), dr["HuongKhoan"].ToString(), dr.GetDouble(8), dr.GetDouble(9), dr.GetDouble(10), dr.GetDouble(11), dr.GetDouble(12), dr.GetDouble(13)));
}
return danhSachLoKhoan;
}
/// <summary>
/// Hàm lấy thông tin công trường
/// </summary>
/// <param name="id">mã công trường</param>
/// <returns>CongTruong</returns>
public static CongTruong CongTruong(String id)
{
CongTruong congTruong = new CongTruong();
Connection conn = new Connection();
string sql = "SELECT * FROM CongTruong WHERE MaCongTruong = '" + id + "'";
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
congTruong = new CongTruong(dr["MaCongTruong"].ToString(), dr["TenCongTruong"].ToString(), dr["SoDienThoai"].ToString(), dr.GetDouble(3), dr["Tang"].ToString(), dr["KhuVuc"].ToString());
}
return congTruong;
}
public static List<BanVe> DanhSachBanVeGanNhat()
{
List<BanVe> danhSachBanVe = new List<BanVe>();
String sql = "SELECT * FROM BanVe ORDER BY NgayChinhSua DESC LIMIT 5";
Connection conn = new Connection();
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
danhSachBanVe.Add(new BanVe(dr["ID"].ToString(), dr["TenBanVe"].ToString(), dr.GetString(2)));
}
return danhSachBanVe;
}
/// <summary>
/// Hàm lấy thông tin một lỗ khoan của một bản vẽ
/// </summary>
/// <param name="_idHoChieu">ID hộ chiếu</param>
/// <param name="_idLoKhoan">ID lỗ khoan</param>
/// <returns>LoKhoan</returns>
public static LoKhoan ThongTinLoKhoan(String _idHoChieu, String _idLoKhoan)
{
LoKhoan loKhoan = new LoKhoan();
Connection conn = new Connection();
string sql = "SELECT * FROM LoKhoan WHERE MaHoChieu = '" + _idHoChieu + "' AND MaLK = '" + _idLoKhoan + "'";
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
loKhoan = new LoKhoan(dr["ID"].ToString(), dr["MaHoChieu"].ToString(), dr["MaBanVe"].ToString(), dr["MaMayKhoan"].ToString(), dr["MaLK"].ToString(), dr.GetDouble(5), dr.GetDouble(6), dr["HuongKhoan"].ToString(), dr.GetDouble(8), dr.GetDouble(9), dr.GetDouble(10), dr.GetDouble(11), dr.GetDouble(12), dr.GetDouble(13));
}
return loKhoan;
}
/// <summary>
/// Hàm trả về danh sách đất đá
/// </summary>
/// <returns>List<DatDa></returns>
public static List<DatDa> DanhSachDatDa()
{
List<DatDa> danhSachDatDa = new List<DatDa>();
Connection conn = new Connection();
string sql = "SELECT * FROM DatDa";
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
danhSachDatDa.Add(new DatDa(dr["MaDatDa"].ToString(), dr["TenDatDa"].ToString(), dr.GetDouble(2), dr.GetDouble(3), dr["TinhChat"].ToString(), dr.GetDouble(5), dr.GetDouble(6), dr.GetDouble(7)));
}
return danhSachDatDa;
}
/// <summary>
/// Hàm lấy thông tin kíp nổ
/// </summary>
/// <param name="id">mã kíp nổ</param>
/// <returns>KipNo</returns>
public static KipNo KipNo(String id)
{
KipNo kipNo = new KipNo();
Connection conn = new Connection();
string sql = "SELECT * FROM KipNo WHERE MaKipNo = '" + id + "'";
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
kipNo = new KipNo(dr["MaKipNo"].ToString(), dr["TenKipNo"].ToString(), dr["ThoiGianViSai"].ToString(), dr.GetDouble(3), dr.GetDouble(4));
}
return kipNo;
}
/// <summary>
/// Hàm lấy danh sách lỗ khoan của một bản vẽ
/// </summary>
/// <param name="_id">ID bản vẽ</param>
/// <returns>List<LoKhoan></returns>
public static List<LoKhoan> DanhSachLoKhoan(String _id)
{
List<LoKhoan> danhSachLoKhoan = new List<LoKhoan>();
Connection conn = new Connection();
string sql = "SELECT * FROM LoKhoan WHERE MaBanVe = " + _id;
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
danhSachLoKhoan.Add(new LoKhoan(dr["MaHoChieu"].ToString(), dr["MaLK"].ToString(), dr["MaBanVe"].ToString(), dr["MaMayKhoan"].ToString(), dr.GetDouble(4), dr.GetDouble(5), dr["HuongKhoan"].ToString(), dr.GetDouble(7), dr.GetDouble(8)));
}
return danhSachLoKhoan;
}
/// <summary>
/// Hàm lấy thông tin đất đá
/// </summary>
/// <param name="id">mã đất đá</param>
/// <returns>DatDa</returns>
public static DatDa DatDa(String id)
{
DatDa datDa = new DatDa();
Connection conn = new Connection();
string sql = "SELECT * FROM DatDa WHERE MaDatDa = '" + id + "'";
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
datDa = new DatDa(dr["MaDatDa"].ToString(), dr["TenDatDa"].ToString(), dr.GetDouble(2), dr.GetDouble(3), dr["TinhChat"].ToString(), dr.GetDouble(5), dr.GetDouble(6), dr.GetDouble(7));
}
return datDa;
}
/// <summary>
/// Hàm lấy danh sách Template
/// </summary>
/// <returns>List<Template></returns>
static public List<Template> DanhSachTemplate()
{
List<Template> danhSachTemplate = new List<Template>();
String sql = "SELECT * FROM Template";
Connection conn = new Connection();
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
danhSachTemplate.Add(new Template(dr["ID"].ToString(), dr["TenTemplate"].ToString(), dr["DuongDan"].ToString(), dr["MoTa"].ToString(), dr["AnhMau"].ToString()));
}
return danhSachTemplate;
}
/// <summary>
/// Hàm lấy thông tin phương pháp nổ
/// </summary>
/// <param name="id">mã phương pháp nổ</param>
/// <returns>PhuongPhapNo</returns>
public static PhuongPhapNo PhuongPhapNo(String id)
{
PhuongPhapNo phuongPhapNo = new PhuongPhapNo();
Connection conn = new Connection();
string sql = "SELECT * FROM PhuongPhapNo WHERE MaPPNo = '" + id + "'";
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
phuongPhapNo = new PhuongPhapNo(dr["MaPPNo"].ToString(), dr["TenPPNo"].ToString(), dr["MaCongTruong"].ToString(), dr.GetDouble(3), dr.GetDouble(4));
}
return phuongPhapNo;
}
/// <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 thuốc nổ
/// </summary>
/// <param name="id">mã thuốc nổ</param>
/// <returns>ThuocNo</returns>
public static ThuocNo ThuocNo(String id)
{
ThuocNo thuocNo = new ThuocNo();
Connection conn = new Connection();
string sql = "SELECT * FROM ThuocNo WHERE MaThuocNo = '" + id + "'";
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
thuocNo = new ThuocNo(dr["MaThuocNo"].ToString(), dr["TenThuocNo"].ToString(), dr.GetDouble(2), dr.GetDouble(3), dr.GetDouble(4), dr["ChiuNuoc"].ToString(), dr.GetDouble(6), dr.GetDouble(7), dr.GetDouble(8));
}
return thuocNo;
}
/// <summary>
/// Hàm trả về danh sách công trường
/// </summary>
/// <returns>List<CongTruong></returns>
public static List<CongTruong> DanhSachCongTruong()
{
List<CongTruong> danhSachCongTruong = new List<CongTruong>();
Connection conn = new Connection();
string sql = "SELECT * FROM CongTruong";
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
danhSachCongTruong.Add(new CongTruong(dr["MaCongTruong"].ToString(), dr["TenCongTruong"].ToString(), dr["SoDienThoai"].ToString(), dr.GetDouble(3), dr["Tang"].ToString(), dr["KhuVuc"].ToString()));
}
return danhSachCongTruong;
}
/// <summary>
/// Hàm lấy danh sách máy khoan
/// </summary>
/// <returns>List<MayKhoan></returns>
static public List<MayKhoan> DanhSachMayKhoan()
{
List<MayKhoan> danhSachMayKhoan = new List<MayKhoan>();
Connection conn = new Connection();
string sql = "SELECT * FROM MayKhoan";
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
danhSachMayKhoan.Add(new MayKhoan(dr["MaMayKhoan"].ToString(), dr["TenMayKhoan"].ToString(), dr.GetDouble(2), dr["HuongKhoan"].ToString(), dr.GetDouble(4)));
}
return danhSachMayKhoan;
}
/// <summary>
/// Hàm lấy thông tin máy khoan
/// </summary>
/// <param name="id">mã máy khoan</param>
/// <returns>MayKhoan</returns>
public static MayKhoan MayKhoan(String id)
{
MayKhoan mayKhoan = new MayKhoan();
Connection conn = new Connection();
string sql = "SELECT * FROM MayKhoan WHERE MaMayKhoan = '" + id + "'";
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
mayKhoan = new MayKhoan(dr["MaMayKhoan"].ToString(), dr["TenMayKhoan"].ToString(), dr.GetDouble(2), dr["HuongKhoan"].ToString(), dr.GetDouble(4));
}
return mayKhoan;
}
/// <summary>
/// Hàm trả về danh sách hộ chiếu sử dụng gần đây nhất
/// </summary>
/// <returns>List<HoChieu></returns>
public static List<HoChieu> DanhSachHoChieuGanNhat()
{
List<HoChieu> danhSachHoChieu = new List<HoChieu>();
String sql = "SELECT * FROM HoChieu a ORDER BY (SELECT NgayChinhSua FROM BanVe WHERE ID = a.MaBanVe)";
Connection conn = new Connection();
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
danhSachHoChieu.Add(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 danhSachHoChieu;
}
/// <summary>
/// Hàm trả về danh sách kíp nổ
/// </summary>
/// <returns>List<KipNo></returns>
public static List<KipNo> DanhSachKipNo()
{
List<KipNo> danhSachKipNo = new List<KipNo>();
Connection conn = new Connection();
string sql = "SELECT * FROM KipNo";
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
danhSachKipNo.Add(new KipNo(dr["MaKipNo"].ToString(), dr["TenKipNo"].ToString(), dr["ThoiGianViSai"].ToString(), dr.GetDouble(3), dr.GetDouble(4)));
}
return danhSachKipNo;
}
/// <summary>
/// Hàm tìm kiếm bản vẽ tương ứng với tên bản vẽ
/// </summary>
/// <param name="tenBanVe">Tên bản vẽ</param>
/// <returns>List<BanVe></returns>
public static List<BanVe> TimKiemBanVe(String tenBanVe)
{
List<BanVe> danhSachBanVe = new List<BanVe>();
String sql = "SELECT * FROM BanVe WHERE TenBanVe LIKE '%" + tenBanVe + "%'";
Connection conn = new Connection();
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
danhSachBanVe.Add(new BanVe(dr["ID"].ToString(), dr["Template"].ToString(), dr["TenBanVe"].ToString(), dr.GetString(3), dr.GetDouble(4), dr.GetDouble(5), dr["NguoiDung"].ToString(), (dr.GetInt32(7) == 1) ? true : false));
}
return danhSachBanVe;
}
/// <summary>
/// Hàm lấy Template theo id
/// </summary>
/// <param name="ID">ID Template</param>
/// <returns>Template</returns>
static public Template ChonTemplate(String ID)
{
if (ID == null)
{
return null;
}
Template danhSachTemplate = new Template();
if (ID.Equals(String.Empty))
{
return danhSachTemplate;
}
String sql = "SELECT * FROM Template WHERE ID = " + ID;
Connection conn = new Connection();
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
danhSachTemplate = new Template(dr["ID"].ToString(), dr["TenTemplate"].ToString(), dr["DuongDan"].ToString(), dr["MoTa"].ToString(), dr["AnhMau"].ToString());
}
return danhSachTemplate;
}
/// <summary>
/// Hàm trả về danh sách bản vẽ sử dụng gần đây nhất (có giới hạn)
/// </summary>
/// <param name="number">số bản vẽ trả về</param>
/// <returns>List<BanVe></returns>
public static List<BanVe> DanhSachBanVeGanNhat(int number)
{
List<BanVe> danhSachBanVe = new List<BanVe>();
String sql = "SELECT * FROM BanVe ORDER BY NgayChinhSua DESC LIMIT " + number;
Connection conn = new Connection();
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
danhSachBanVe.Add(new BanVe(dr["ID"].ToString(), dr["Template"].ToString(), dr["TenBanVe"].ToString(), dr.GetString(3), dr.GetDouble(4), dr.GetDouble(5), dr["NguoiDung"].ToString(), (dr.GetInt32(7) == 1) ? true : false));
}
return danhSachBanVe;
}
/// <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 ExportData(String _maHoChieu)
{
Connection conn = new Connection();
string sql = "SELECT HoChieu.*, LoKhoan.ID, LoKhoan.MaLK, LoKhoan.BanKinhLK, LoKhoan.ChieuSauLK FROM LoKhoan, BanVe, HoChieu WHERE HoChieu.MaHoChieu = LoKhoan.MaHoChieu And BanVe.ID= HoChieu.MaBanVe and HoChieu.MaHoChieu = \'" + _maHoChieu + "\';";
SQLiteDataReader dr = conn.GetData(sql);
while (dr.Read())
{
hoChieu.TenHoChieu = dr["TenHoChieu"].ToString();
hoChieu.ChieuCaoTang = (dr["ChieuCaoTang"].ToString() == String.Empty ? 0 : Convert.ToDouble(dr["ChieuCaoTang"].ToString()));
hoChieu.HeSoKC = (dr["HeSoKC"].ToString() == String.Empty ? 0 : Convert.ToDouble(dr["HeSoKC"].ToString()));
hoChieu.KichThuoc_X = (dr["KichThuoc_X"].ToString() == String.Empty ? 0 : Convert.ToDouble(dr["KichThuoc_X"].ToString()));
hoChieu.KichThuoc_Y = (dr["KichThuoc_Y"].ToString() == String.Empty ? 0 : Convert.ToDouble(dr["KichThuoc_Y"].ToString()));
//thoiDiemNo = Convert.ToDateTime(dr["ThoiDiemNo"].ToString());
hoChieu.MaDatDa = dr["MaDatDa"].ToString();
hoChieu.MaCapDo = dr["MaCapDo"].ToString();
hoChieu.MaMayKhoan = dr["MaMayKhoan"].ToString();
hoChieu.MaThuocNo = dr["MaThuocNo"].ToString();
hoChieu.MaCongTruong = dr["MaCongTruong"].ToString();
danhSachLoKhoan.Add(new LoKhoan(dr["MaLK"].ToString(), Convert.ToDouble(dr["BanKinhLK"].ToString()), Convert.ToDouble(dr["ChieuSauLK"].ToString())));
}
dr.Close();
//Lấy hết giá trị của bảng Đất Đá
datDa = BS_DatDa.DatDa(hoChieu.MaDatDa);
//Lấy hết giá trị từ bảng Cấp độ nổ
capDoNo = BS_CapDoNo.CapDoNo(hoChieu.MaCapDo);
//Lấy hết giá trị của bảng Máy khoan
mayKhoan = BS_MayKhoan.MayKhoan(hoChieu.MaMayKhoan);
//Lấy hết giá trị của bảng Thuốc nổ
thuocNo = BS_ThuocNo.ThuocNo(hoChieu.MaThuocNo);
//Lấy hết giá trị của bảng Công trường
congTruong = BS_CongTruong.CongTruong(hoChieu.MaCongTruong);
//tính toán
congTB = Math.Round((thuocNo.KhaNangSinhCong / 360), 2); // Cong trung binh (e)
//double congtb = thuocNo.KhaNangSinhCong / 360; // Cong trung binh (e)
//congtb = Math.Round(congtb * 100) / 100;
//duong Khang chan tang
// duongKhang = Math.Round((53 * datDa.KCTB_KhoiNut * (mayKhoan.DuongKinhLoKhoan / 1000) * Math.Sqrt(thuocNo.MatDoNapThuoc * congTB / datDa.DungTrong) * (1.6 - 0.5 * hoChieu.HeSoKC)) * 100) / 100;
duongKhang = Math.Round((53 * datDa.HeSoDatDa * (mayKhoan.DuongKinhLoKhoan / 1000) * Math.Sqrt((thuocNo.MatDoNapThuoc * (congTB / datDa.DungTrong))) * (1.6 - 0.5 * hoChieu.HeSoKC)), 2);
//Khoang cach giua cac lo min (Kí Hiệu {A})
// KC_Cot = Math.Round((hoChieu.HeSoKC * duongKhang) * 100) / 100;
KC_Cot = Math.Round((hoChieu.HeSoKC * duongKhang), 2);
// Khoảng cách giữa các hàng (Kí Hiệu {b})
// KC_Hang = Math.Round((0.85 * KC_Cot) * 100) / 100;
KC_Hang = Math.Round((0.85 * KC_Cot), 2);
//Chieu sau khoan them
chieuSauThem = Math.Round((0.3 * KC_Hang), 2);
// Chieu dai lo khoan (Kí Hiệu {Lk})
chieuSauToanBoLK = Math.Round((mayKhoan.ChieuSau + chieuSauThem), 2);
// Chieu cao cột bua thiết kế ( Kí Hiệu {Lbua})
chieuDaiBua = Math.Round((0.75 * duongKhang), 2);
//Hang min
//hangMin = Convert.ToInt32(hoChieu.KichThuoc_Y / KC_Hang);
//Hangmin = Math.Round(Hangmin * 100) / 100;
//Cot min
//soCotMin = Convert.ToInt32((hoChieu.KichThuoc_X - duongKhang) / KC_Cot);
// Tổng số lỗ mìn (Kí Hiệu {Tổng số lỗ})
//tongLoMin = soCotMin * hangMin;
}
/// <summary>
/// Hàm tạo bản vẽ (không có template)
/// </summary>
/// <param name="tenBanVe">Tên bản vẽ</param>
/// <returns>ID bản vẽ vừa tạo</returns>
public static String TaoBanVe(String tenBanVe)
{
Connection conn = new Connection();
SQLiteDataReader dr;
BanVe banVeVuaTao = new BanVe();
bool flag = true;
//kiểm tra tên bản vẽ có trùng ko
List<BanVe> danhSachBanVe = BS_BanVe.DanhSachBanVe();
foreach (BanVe value in danhSachBanVe)
{
if (value.TenBanVe == tenBanVe)
{
flag = false; break;
}
}
//nếu ko trùng => tạo bản vẽ mới, trả về id bản vẽ vừa tạo
if (flag)
{
String sql = "INSERT INTO BanVe (TenBanVe, NgayChinhSua) VALUES ('" + tenBanVe + "','" + DateTime.Now + "')";
conn.SetData(sql);
sql = "SELECT * FROM BanVe WHERE TenBanVe = '" + tenBanVe + "'";
dr = conn.GetData(sql);
while (dr.Read())
{
banVeVuaTao = new BanVe(dr["ID"].ToString(), dr["Template"].ToString(), dr["TenBanVe"].ToString(), dr.GetString(3), dr.GetDouble(4), dr.GetDouble(5), dr["NguoiDung"].ToString(), (dr.GetInt32(7) == 1) ? true : false);
}
return banVeVuaTao.ID;
}
//nếu trùng => trả về null
else
{
return null;
}
}