/// <summary>
/// Hàm cập nhật kíp nổ
/// </summary>
/// <param name="value">kíp nổ cần cập nhật</param>
/// <returns>bool</returns>
public static bool CapNhatKipNo(KipNo value)
{
String sql = "UPDATE KipNo SET TenKipNo = '" + value.TenKipNo + "', ThoiGianViSai = '" + value.ThoiGianViSai + "', DonViTinh_KN = '" + value.DonViTinh_KN + "', GiaThanh_KN = '" + value.GiaThanh_KN + "' WHERE MaKipNo = '" + value.MaKipNo + "'";
Connection conn = new Connection();
return(conn.SetData(sql));
}
/// <summary>
/// Hàm thêm kíp nổ
/// </summary>
/// <param name="value">kíp nổ cần thêm</param>
/// <returns>bool</returns>
public static bool ThemKipNo(KipNo value)
{
String sql = "INSERT INTO KipNo (MaKipNo, TenKipNo, ThoiGianViSai, DonViTinh_KN, GiaThanh_KN) VALUES ('" + value.MaKipNo + "', '" + value.TenKipNo + "', '" + value.ThoiGianViSai + "', '" + value.DonViTinh_KN + "', '" + value.GiaThanh_KN + "')";
Connection conn = new Connection();
return(conn.SetData(sql));
}
/// <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 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);
}
private void buttonInsert_Click(object sender, EventArgs e)
{
KipNo insert = new KipNo();
insert.MaKipNo = textBoxMaKipNo2.Text;
insert.TenKipNo = textBoxTenKipNo2.Text;
insert.ThoiGianViSai = textBoxThoiGianViSai2.Text;
if (textBoxDonViTinh2.Text != String.Empty) { insert.DonViTinh_KN = double.Parse(textBoxDonViTinh2.Text); }
if (textBoxGiaThanh2.Text != String.Empty) { insert.GiaThanh_KN = double.Parse(textBoxGiaThanh2.Text); }
try
{
BS_KipNo.ThemKipNo(insert);
}
catch (Exception exc)
{
MessageBox.Show("Lỗi - " + exc.Message);
}
ShowPanel(1);
HienThiDuLieu_KipNo();
}
/// <summary>
/// Hàm cập nhật kíp nổ
/// </summary>
/// <param name="value">kíp nổ cần cập nhật</param>
/// <returns>bool</returns>
public static bool CapNhatKipNo(KipNo value)
{
String sql = "UPDATE KipNo SET TenKipNo = '" + value.TenKipNo + "', ThoiGianViSai = '" + value.ThoiGianViSai + "', DonViTinh_KN = '" + value.DonViTinh_KN + "', GiaThanh_KN = '" + value.GiaThanh_KN + "' WHERE MaKipNo = '" + value.MaKipNo + "'";
Connection conn = new Connection();
return conn.SetData(sql);
}
/// <summary>
/// Hàm thêm kíp nổ
/// </summary>
/// <param name="value">kíp nổ cần thêm</param>
/// <returns>bool</returns>
public static bool ThemKipNo(KipNo value)
{
String sql = "INSERT INTO KipNo (MaKipNo, TenKipNo, ThoiGianViSai, DonViTinh_KN, GiaThanh_KN) VALUES ('" + value.MaKipNo + "', '" + value.TenKipNo + "', '" + value.ThoiGianViSai + "', '" + value.DonViTinh_KN + "', '" + value.GiaThanh_KN + "')";
Connection conn = new Connection();
return conn.SetData(sql);
}