private void CTHD_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'qLCHDienThoaiDDDataSet14.MATHANG' table. You can move, or remove it, as needed.
//this.mATHANGTableAdapter1.Fill(this.qLCHDienThoaiDDDataSet14.MATHANG);
// TODO: This line of code loads data into the 'qLCHDienThoaiDDDataSet11.HOADON' table. You can move, or remove it, as needed.
//this.hOADONTableAdapter2.Fill(this.qLCHDienThoaiDDDataSet11.HOADON);
// TODO: This line of code loads data into the 'qLCHDienThoaiDDDataSet10.HOADON' table. You can move, or remove it, as needed.
//this.hOADONTableAdapter1.Fill(this.qLCHDienThoaiDDDataSet10.HOADON);
// TODO: This line of code loads data into the 'qLCHDienThoaiDDDataSet7.HOADON' table. You can move, or remove it, as needed.
//this.hOADONTableAdapter.Fill(this.qLCHDienThoaiDDDataSet7.HOADON);
// TODO: This line of code loads data into the 'qLCHDienThoaiDDDataSet6.KHACHHANG' table. You can move, or remove it, as needed.
//this.kHACHHANGTableAdapter.Fill(this.qLCHDienThoaiDDDataSet6.KHACHHANG);
// TODO: This line of code loads data into the 'qLCHDienThoaiDDDataSet5.NHANVIEN' table. You can move, or remove it, as needed.
//this.nHANVIENTableAdapter.Fill(this.qLCHDienThoaiDDDataSet5.NHANVIEN);
// TODO: This line of code loads data into the 'qLCHDienThoaiDDDataSet4.MATHANG' table. You can move, or remove it, as needed.
//this.mATHANGTableAdapter.Fill(this.qLCHDienThoaiDDDataSet4.MATHANG);
txtmacthd.Text = MACTHD;
luemaHD.Text = MAHD;
luemamh.Text = MAMH;
luemanv.Text = MANV;
luemakh.Text = MAKH;
txtsoluong.Text = SOLUONG;
txtdonvitinh.Text = DONVITINH;
txtthanhtien.Text = THANHTIEN.ToString();
gridmathang.DataSource = MH.Laymathang();
gridHoaDon.DataSource = HD.LayHoaDon();
}
private void button1_Click(object sender, EventArgs e)
{
string loai = null;
if (LOAISC.SelectedItem.ToString() == "1.Sua Chua")
{
loai = "1";
}
else
{
loai = "2";
}
string maphieusc = MAPSC.SelectedItem.ToString();
spilit_space(ref maphieusc);
string tenpt = LOAIPT.SelectedItem.ToString();
spilit_space(ref tenpt);
string query = "SELECT MAPT FROM PHUTUNG WHERE TENPT='" + tenpt + "'";
DATAPROVIDER provider = new DATAPROVIDER();
DataTable tb = new DataTable();
tb = provider.Executequery(query);
string mapt = tb.Rows[0]["MAPT"].ToString();
spilit_space(ref mapt);
////////////////////////////// kiểm tra sự tồn tại khóa chính
query = "SELECT *FROM THONGTINSUACHUA WHERE MAPT='" + mapt + "' AND MAPSC= '" + maphieusc + "'";
provider = new DATAPROVIDER();
DataTable result = provider.Executequery(query);
if (result.Rows.Count == 1)
{
MessageBox.Show("Thông tin sửa chữa bị trùng !!!");
}
else
{
//////////////////////////////////
query = "INSERT INTO dbo.THONGTINSUACHUA ( MAPT , MAPSC ,LOAISUACHUA ,MOTA ,SLPT_SUDUNG ,CHIPHI)VALUES ( '" + mapt + "','" + maphieusc + "', " + loai + " ,N'" + MOTA.Text.ToString() + "' ," + slptsd.Text.ToString() + "," + CHIPHI.Text.ToString() + ")";
tb = new DataTable();
tb = provider.Executequery(query);
loadthongtinsuachua(maphieusc);
}
///SHOW THÀNH TIỀN
query = "SELECT SUM (CHIPHI) AS 'CHIPHI' FROM dbo.THONGTINSUACHUA WHERE MAPSC='" + maphieusc + "'";
provider = new DATAPROVIDER();
tb = new DataTable();
tb = provider.Executequery(query);
foreach (DataRow row in tb.Rows)
{
THANHTIEN.Text = row["CHIPHI"].ToString();
THANHTIEN.Show();
}
}
private void MAPSC_SelectedIndexChanged(object sender, EventArgs e)
{
//load thông tin phiếu sửa chữa
String idpsc = MAPSC.Text.ToString();
spilit_space(ref idpsc);
loadthongtinsuachua(idpsc);
/////load thông tin chi phí thu
string query = "SELECT SUM (CHIPHI) AS 'CHIPHI' FROM dbo.THONGTINSUACHUA WHERE MAPSC='" + idpsc + "'";
DATAPROVIDER provider = new DATAPROVIDER();
DataTable tb = new DataTable();
tb = provider.Executequery(query);
foreach (DataRow row in tb.Rows)
{
THANHTIEN.Text = row["CHIPHI"].ToString();
THANHTIEN.Show();
}
}
