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 tenkhachhang_SelectedIndexChanged_1(object sender, EventArgs e)
{
get_kh.get_ten = makh.Text.ToString();
string query = "SELECT *FROM dbo.KHACHHANG WHERE MAKH= '" + makh.SelectedItem.ToString() + "'";
DATAPROVIDER provider = new DATAPROVIDER();
DataTable tb = new DataTable();
tb = provider.Executequery(query);
foreach (DataRow row in tb.Rows)
{
hoten.Text = row["HOTEN"].ToString();
hoten.Show();
cmnd.Text = row["CMND"].ToString();
cmnd.Show();
bienso.Text = row["BIENSO"].ToString();
bienso.Show();
loaixe.Text = row["LOAIXE"].ToString();
loaixe.Show();
}
loadthongtinMapsccombobox();
addphieusuachua.Enabled = true;
}
//kiểm tra sự tồn tại của khóa chính trong bảng thong tin sua chữa
void loadthongtinsuachua(string mapsc)
{
string query = "SELECT *FROM THONGTINSUACHUA WHERE MAPSC= '" + mapsc + "'";
DATAPROVIDER provider = new DATAPROVIDER();
dataGridView1.DataSource = provider.Executequery(query);
}
public void LoadListByKeyWord()
{
DATAPROVIDER kn = new DATAPROVIDER();
DataTable dt = new DataTable();
dt = kn.Executequery("select * from PHUTUNG where TENPHUTUNG like'%" + txtTimKiem.Text + "%' ");
dataGridPhuTung.DataSource = dt;
}
public void LayBangPT()
{
DATAPROVIDER kn = new DATAPROVIDER();
DataTable dt = new DataTable();
dt = kn.Executequery("select * from PHUTUNG");
dataGridPhuTung.DataSource = dt;
}
public void LayBangNV()
{
DATAPROVIDER kn = new DATAPROVIDER();
DataTable dt = new DataTable();
dt = kn.Executequery("select * from NHANVIEN");
dataGridNhanVien.DataSource = dt;
}
public void LoadListByKeyWord()
{
DATAPROVIDER kn = new DATAPROVIDER();
DataTable dt = new DataTable();
dt = kn.Executequery("select * from KHACHHANG where Name like'%" + txtTimKiem.Text + "%' ");
dataGridKhachHang.DataSource = dt;
}
public void LayBangKH()
{
DATAPROVIDER kn = new DATAPROVIDER();
DataTable dt = new DataTable();
dt = kn.Executequery("select * from KHACHHANG");
dataGridKhachHang.DataSource = dt;
}
public void LoadListByKeyWord()
{
DATAPROVIDER kn = new DATAPROVIDER();
DataTable dt = new DataTable();
dt = kn.Executequery("select * from NHANVIEN where HOTEN like'%" + txtTimKiem.Text + "%' ");
dataGridNhanVien.DataSource = dt;
}
//public void loadaccountlist()
//{
// //EXEC GETACCOUNTBYUSERNAME @USERNAME
// string query = "SELECT *FROM dbo.TAIKHOAN ";
// //string query = "INSERT INTO TAIKHOAN VALUES('TK06','NV6','123456','07/02/1788')";
// DATAPROVIDER provider = new DATAPROVIDER();
// dataGridView1.DataSource = provider.Executequery(query/*,new object[] { "NV2" }*/);
public void loadaccountlist()
{
//EXEC GETACCOUNTBYUSERNAME @USERNAME
string query = "SELECT *FROM dbo.TAIKHOAN ";
// string query = "INSERT INTO TAIKHOAN VALUES('TK06','NV6','123456','07/02/1788')";
DATAPROVIDER provider = new DATAPROVIDER();
dataGridView1.DataSource = provider.Executequery(query /*new object[] { "NV2" }*/);
}
public void loadthongtinkhintocombobox()
{
string query = "SELECT *FROM dbo.KHACHHANG ";
DATAPROVIDER provider = new DATAPROVIDER();
DataTable tb = new DataTable();
tb = provider.Executequery(query);
foreach (DataRow row in tb.Rows)
{
string name = row["MAKH"].ToString();
makh.Items.Add(name);
}
makh.Show();
}
public void loadthongtinMapsccombobox()
{
string query = "SELECT MAPSC FROM dbo.PHIEUSUACHUA JOIN dbo.KHACHHANG ON KHACHHANG.MAKH = PHIEUSUACHUA.MAKH AND HOTEN='" + hoten.Text.ToString() + "'";
DATAPROVIDER provider = new DATAPROVIDER();
DataTable tb = new DataTable();
tb = provider.Executequery(query);
foreach (DataRow row in tb.Rows)
{
string name = row["MAPSC"].ToString();
MAPSC.Items.Add(name);
}
MAPSC.Show();
}
public void loadloaiphutungcombobox()
{
string query = "SELECT TENPT FROM dbo.PHUTUNG ";
DATAPROVIDER provider = new DATAPROVIDER();
DataTable tb = new DataTable();
tb = provider.Executequery(query);
foreach (DataRow row in tb.Rows)
{
string name = row["TENPT"].ToString();
LOAIPT.Items.Add(name);
}
LOAIPT.Show();
}
void showmanv()
{
string query = "SELECT *FROM dbo.NHANVIEN ";
DATAPROVIDER provider = new DATAPROVIDER();
DataTable tb = new DataTable();
tb = provider.Executequery(query);
foreach (DataRow row in tb.Rows)
{
string name = row["MANV"].ToString();
MANV.Items.Add(name);
}
MANV.Show();
}
void updatedata()
{
string query = "SELECT *FROM dbo.TAIKHOAN ";
DATAPROVIDER provider = new DATAPROVIDER();
DataTable tb = new DataTable();
tb = provider.Executequery(query);
string MATK = tb.Rows[0]["MATK"].ToString();
spilit_space(ref MATK);
////////////////////////////
//textBoxmatkhau.Text.ToString();
query = "UPDATE dbo.TAIKHOAN SET TENDN= '" + textboxtendangnhap.Text.ToString() + "' , MATKHAU= '" + textBoxmatkhau.Text.ToString() + "' WHERE MATK= '" + MATK + "'";
DATAPROVIDER pro = new DATAPROVIDER();
DataTable tbable = new DataTable();
tbable = pro.Executequery(query);
}
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();
}
}
public void showdoanhthu()
{
string query = "SELECT PHUTUNG.MAPT AS N'Mã Phụ Tùng',TENPT AS N'Tên Phụ Tùng',SUM(SLPT_SUDUNG) AS N'Số Lượng Sử Dụng Trong Tháng',SOLUONG AS N'Số Lượng Còn Lại',SUM(THANHTIEN) AS'Tiền Thu' FROM dbo.THONGTINSUACHUA JOIN dbo.PHUTUNG ON PHUTUNG.MAPT = THONGTINSUACHUA.MAPT JOIN dbo.PHIEUSUACHUA ON PHIEUSUACHUA.MAPSC = THONGTINSUACHUA.MAPSC AND YEAR(NGAYSUACHUA)=YEAR(GETDATE()) AND MONTH(NGAYSUACHUA)=MONTH(GETDATE()) GROUP BY dbo.PHUTUNG.MAPT,dbo.PHUTUNG.TENPT,SOLUONG";
DATAPROVIDER provider = new DATAPROVIDER();
datagridbct.DataSource = provider.Executequery(query);
query = "SELECT SUM(TIENTHU) as N'DOANHTHU' FROM dbo.PHIEUTHUTIEN WHERE YEAR(NGAYTHU)=YEAR(GETDATE()) AND MONTH(NGAYTHU)=MONTH(GETDATE())";
///////////////////////////
DataTable tb = new DataTable();
provider = new DATAPROVIDER();
tb = provider.Executequery(query);
foreach (DataRow row in tb.Rows)
{
string DT = row["DOANHTHU"].ToString();
doanhthu.Text = DT;
doanhthu.Show();
}
}
private void INSERT_Click(object sender, EventArgs e)
{
if (MAPSC.Text == "" || MANV.Text == "")
{
MessageBox.Show("Mã phiếu sữa chữa hoặc mã nhân viên không được trống!!!");
}
else
{
string idnv = MANV.SelectedItem.ToString();
spilit_space(ref idnv);
string idkh = makh.Text.ToString();
spilit_space(ref idkh);
string ngaysc = NGAYSUACHUA.Value.ToString();
string query = "INSERT INTO dbo.PHIEUSUACHUA( MAPSC,MANV,MAKH,NGAYSUACHUA)VALUES( '" + MAPSC.Text.ToString() + "','" + idnv + "','" + idkh + "','" + ngaysc + "')";
DATAPROVIDER provider = new DATAPROVIDER();
DataTable tb = new DataTable();
tb = provider.Executequery(query);
MessageBox.Show("Thêm phiếu sửa chữa thành công");
}
}
void loadaccount()
{
string query = "SELECT *FROM dbo.TAIKHOAN";
DATAPROVIDER provider = new DATAPROVIDER();
DataTable tb = new DataTable();
tb = provider.Executequery(query);
string str = tb.Rows[0]["TENDN"].ToString();
spilit_space(ref str);
textboxtendangnhap.Text = str;
textboxtendangnhap.Show();
str = tb.Rows[0]["MATKHAU"].ToString();
spilit_space(ref str);
textBoxmatkhau.Text = str;
textboxtendangnhap.Show();
str = tb.Rows[0]["NGAYTAO"].ToString();
spilit_space(ref str);
textBoxngaytao.Text = str;
textboxtendangnhap.Show();
}
