private void doc_PrintPage(object sender, PrintPageEventArgs e)
{
try
{
Gia_LK glk = new Gia_LK();
glk = lkBUS.LayGiaLinhKien(txtMaLK.Text);
double giaLK = Convert.ToDouble(glk.GiaBan1);
string laygia = String.Format("{0:0,0}", giaLK);
if (laygia != "00")
{
Bitmap bm = new Bitmap(picboxBarcode.Width, picboxBarcode.Height);
picboxBarcode.DrawToBitmap(bm, new Rectangle(0, 0, picboxBarcode.Width, picboxBarcode.Height));
e.Graphics.DrawImage(bm, 0, 0);
//in malk
e.Graphics.DrawString(txtMaLK.Text, new System.Drawing.Font("Tahoma", 9), new SolidBrush(Color.Black), new PointF(45f, 79f));
//in gia
e.Graphics.DrawString(laygia + " VNĐ", new System.Drawing.Font("Tahoma", 9), new SolidBrush(Color.Black), new PointF(45f, 0f));
bm.Dispose();
}
else
{
MessageBox.Show("Hiện chưa có giá cho linh kiện này nên không thể in !!", "Thông báo");
}
}
catch
{
}
}
public bool XoaLK(LinhKien lk, Gia_LK glk)
{
bool isXoaGiaLK = lkDAL.XoaGiaLinhKien(glk);
bool isXoaLK = lkDAL.XoaLinhKien(lk);
return(isXoaGiaLK && isXoaGiaLK);
}
public DateTime LayNgayCapNhatGiaCuoiCung(Gia_LK glk)
{
try
{
string sql = "select TOP 1 WITH ties (NgayApDung) from GIA_LK where MaLK='" + glk.Str_maLK + "'ORDER BY (NgayApDung) DESC";
return((DateTime)dtsql.ExecuteScalar(sql));
}
catch
{
return(Convert.ToDateTime("1/1/1990"));
}
}
public bool KiemTraNgayCapNhat(Gia_LK glk, DateTime now)
{
int KQ = lkDAL.KiemTraNgayCapNhap(glk, now);
if (KQ == 1)
{
return(true);
}
else
{
return(false);
}
}
public bool XoaGiaLinhKien(Gia_LK glk)
{
try
{
string sqp_Xoa = "delete from Gia_LK where MaLK = '" + glk.Str_maLK + "' ";
dtsql.ExecNonQuery(sqp_Xoa);
return(true);
}
catch
{
return(false);
}
}
public bool CapNhatGiaLinhKien(Gia_LK glk)
{
try
{
string sql_SuaGialk = "insert into Gia_LK(MaLK,NgayApDung,GiaBan) Values('" + glk.Str_maLK + "', '" + glk.NgayApDung1 + "', '" + glk.GiaBan1 + "')";
dtsql.ExecNonQuery(sql_SuaGialk);
return(true);
}
catch
{
return(false);
}
}
public int KiemTraNgayCapNhap(Gia_LK glk, DateTime now)
{
try
{
int ktra_KQ;
string kt_sql = "select DATEDIFF(day,'" + LayNgayCapNhatGiaCuoiCung(glk) + "','" + now + "')";//hàm
ktra_KQ = (int)dtsql.ExecuteScalar(kt_sql);
if (ktra_KQ > 0)
{
return(1); //hợp lệ
}
return(2); // ko hợp lệ xuất thông báo
}
catch
{
return(0);//xuất thông báo lỗi không hợp lệ
}
}
public bool ThemGia_LK(Gia_LK glk)
{
try
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
string sql_Them = "INSERT INTO GIA_LK(MaLK,NgayApDung,GiaBan) Values ('" +
glk.Str_maLK + "',N'" +
glk.NgayApDung1 + "','" +
glk.GiaBan1 + "')";
dtsql.ExecNonQuery(sql_Them);
return(true);
}
catch (Exception e)
{
//MessageBox.Show(e.Message);
return(false);
}
}
public Gia_LK LayGiaLinhKien(string _maLK)
{
try
{
string sql = "Select * from GiaLinhKienUpdated where MaLK = '" + _maLK + "'";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count != 0)
{
Gia_LK glk = new Gia_LK();
glk.GiaBan1 = dt.Rows[0][1].ToString();
return(glk);
}
return(null);
}
catch
{
return(null);
}
}
private void btnInMa_Click(object sender, EventArgs e)
{
Gia_LK glk = new Gia_LK();
glk = lkBUS.LayGiaLinhKien(txtMaLK.Text);
string laygia = String.Format("{0:0,0}", glk.GiaBan1);
if (laygia != "0.0000")
{
PrintDialog pd = new PrintDialog();
PrintDocument doc = new PrintDocument();
doc.PrintPage += doc_PrintPage;
pd.Document = doc;
if (pd.ShowDialog() == DialogResult.OK)
{
doc.Print();
}
}
else
{
MessageBox.Show("Hiện chưa có giá cho linh kiện này nên không thể in !!", "Thông báo");
}
}
public bool ThemGia_LK(Gia_LK glk)
{
return(lkDAL.ThemGia_LK(glk));
}
public bool CapNhatGiaLinhKien(Gia_LK glk)
{
return(lkDAL.CapNhatGiaLinhKien(glk));
}
