public void AddDonDHNCC(EC_DonDHNCC _dondhncc)
{
string sqlquery = (@"INSERT INTO tb_DonDHNCC ( madhncc, mancc, ngaydat, manv)
VALUES (N'{0}',N'{1}','{2}',N'{3}')");
sqlquery = string.Format(sqlquery, _dondhncc.MaDonDHNCC, _dondhncc.MaNCC, _dondhncc.NgayDat, _dondhncc.MaNV);
Connect.ExcuteNonQuery(sqlquery);
}
public void AddDonDHNCC(EC_DonDHNCC _dondhncc)
{
if (!sqldondhncc.CheckDonDHNCC(_dondhncc.MaDonDHNCC))
{
sqldondhncc.AddDonDHNCC(_dondhncc);
}
else
{
MessageBox.Show("Mã này đã tồn tại,xin chọn Mã khác", "Chú Ý", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public DataTable CreateTbDonDHNCC(EC_DonDHNCC _dondhncc)
{
if (_dondhncc.NgayDat != "%")
{
return(Connect.CreateTable(string.Format("select * from tb_DonDHNCC where madhncc like N'%{0}%' and mancc like N'%{1}%' and ngaydat = '{2}' and manv like N'%{3}%'", _dondhncc.MaDonDHNCC, _dondhncc.MaNCC, _dondhncc.NgayDat, _dondhncc.MaNV)));
}
else
{
return(Connect.CreateTable(string.Format("select * from tb_DonDHNCC where madhncc like N'%{0}%' and mancc like N'%{1}%' and ngaydat like '%{2}%' and manv like N'%{3}%'", _dondhncc.MaDonDHNCC, _dondhncc.MaNCC, _dondhncc.NgayDat, _dondhncc.MaNV)));
}
}
//public void UpdateDonDHNCC(EC_DonDHNCC _dondhncc)
//{
// sqldondhncc.UpdateDonDHNCC(_dondhncc);
//}
public void DeleteDonDHNCC(EC_DonDHNCC _dondhncc)
{
sqldondhncc.DeleteDonDHNCC(_dondhncc);
}
public DataTable CreateTbDonDHNCC(EC_DonDHNCC _dondhncc)
{
return(sqldondhncc.CreateTbDonDHNCC(_dondhncc));
}
public void DeleteDonDHNCC(EC_DonDHNCC _dondhncc)
{
Connect.ExcuteNonQuery("DELETE FROM [tb_CTDonDHNCC] WHERE madhncc=N'" + _dondhncc.MaDonDHNCC + "'");
Connect.ExcuteNonQuery("DELETE FROM [tb_DonDHNCC] WHERE madhncc=N'" + _dondhncc.MaDonDHNCC + "'");
}
