public static void UpdateTT(PN_DTO pn)
{
string sql;
sql = "Update service_import set Tongtien=('" + pn.TongTien + "')";
sql += " Where MaPN = " + pn.MaPN;
DataAccess.executeNonQuery(sql);
}
//cap nhat
public static void Update(PN_DTO pn)
{
string sql;
sql = "Update service_import set Ngaynhap = (STR_TO_DATE('" + pn.NgayNhap + "','%m/%d/%Y %h:%i:%s %p')),Tongtien=('" + pn.TongTien + "')";
sql += "Where MaPN = " + pn.MaPN;
DataAccess.executeNonQuery(sql);
}
//them
public static void Insert(PN_DTO pn)
{
string sql;
sql = "Insert into service_import(MaPN, Ngaynhap, Tongtien) values (";
sql += "'" + pn.MaPN + "',STR_TO_DATE('" + pn.NgayNhap + "','%m/%d/%Y %h:%i:%s %p'),'" + pn.TongTien + "')";
DataAccess.executeNonQuery(sql);
}
//xoa
public static void Delete(CTPN_DTO ctpn)
{
string sql;
sql = "Delete From service_import_detail Where MaCTPN = " + ctpn.MaCTPN;
DataAccess.executeNonQuery(sql);
//update so luong service
DataTable dt = DataAccess.executeQuery("service_numbers", "service_stt=" + ctpn.MaDV, "service");
int soluong = int.Parse(dt.Rows[0]["service_numbers"].ToString());
ServiceDTO service = new ServiceDTO();
service.Service_stt = ctpn.MaDV;
service.Service_number = soluong - ctpn.Soluong;
ServiceData.UpdateSL(service);
//update phieu nhap
DataTable dt2 = DataAccess.executeQuery("Tongtien", "MaPN=" + ctpn.MaPN, "service_import");
int tongtien = int.Parse(dt2.Rows[0]["Tongtien"].ToString());
PN_DTO pn = new PN_DTO();
pn.TongTien = tongtien - ctpn.Thanhtien;
pn.MaPN = ctpn.MaPN;
PN_Data.UpdateTT(pn);
}
private void btnNhapKho_Click(object sender, EventArgs e)
{
if (listCTPN.Count > 0)
{
if (MessageBox.Show("Bạn có chắc muốn nhập kho những dịch vụ này?", "Xác nhận", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK)
{
PN_DTO pn = new PN_DTO();
pn.NgayNhap = DateTime.ParseExact(dateTimePickerNN.Text, "dd/MM/yyyy", null);
pn.TongTien = tongtien;
PN_Data.Insert(pn);
DataTable dt = DataAccess.executeQuery("MaPN", "MaPN=(select max(MaPN) from service_import)", "service_import");
int maPN = int.Parse(dt.Rows[0]["MaPN"].ToString());
for (int i = 0; i < listCTPN.Count; i++)
{
listCTPN[i].MaPN = maPN;
CTPN_Data.Insert(listCTPN[i]);
}
MessageBox.Show("Thêm thành công !", "Thông báo");
listCTPN.Clear();
dtg_list_dv.Rows.Clear();
totalRow = 0;
load();
}
}
else
{
MessageBox.Show("Chưa có chi tiết phiếu nhập nào !", "Thông báo");
}
}
//xoa
public static void Delete(PN_DTO pn)
{
string sql;
sql = "Delete From service_import Where MaPN = " + pn.MaPN;
DataAccess.executeNonQuery(sql);
}
public static void Update(CTPN_DTO ctpn, int slmoi, int dgmoi)
{
string sql;
sql = "Update service_import_detail set Soluong=('" + slmoi + "'),Dongia=('" + dgmoi + "'),Thanhtien=('"
+ slmoi*dgmoi + "')";
sql += "Where MaCTPN = " + ctpn.MaCTPN;
DataAccess.executeNonQuery(sql);
//update so luong service
DataTable dt = DataAccess.executeQuery("service_numbers", "service_stt=" + ctpn.MaDV, "service");
int soluong = int.Parse(dt.Rows[0]["service_numbers"].ToString());
ServiceDTO service = new ServiceDTO();
service.Service_stt = ctpn.MaDV;
service.Service_number = soluong - ctpn.Soluong + slmoi;
ServiceData.UpdateSL(service);
//update phieu nhap
DataTable dt2 = DataAccess.executeQuery("Tongtien", "MaPN=" + ctpn.MaPN, "service_import");
int tongtien = int.Parse(dt2.Rows[0]["Tongtien"].ToString());
PN_DTO pn = new PN_DTO();
pn.TongTien = tongtien - ctpn.Thanhtien + slmoi * dgmoi;
pn.MaPN = ctpn.MaPN;
PN_Data.UpdateTT(pn);
}
