private void btThemHD_Click(object sender, EventArgs e)
{
if (txtThanhTien.Text == "0")
{
string mh, mk, mv; DateTime nx; int tt;
mh = txtMaHD.Text.Trim();
mk = cbbMaKH.Text.Trim();
nx = Convert.ToDateTime(dtpNgayXuat.Text);
tt = int.Parse(txtThanhTien.Text);
mv = txtMaNV.Text.Trim();
DTOHoaDon hd = new DTOHoaDon(mh, mk, nx, tt, mv);
try
{
int i = new BUSHoaDon().Add(hd);
dgvHoaDon.DataSource = GetHD();
load();
xoatrangHD();
txtMaHD.Text = "";
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
MessageBox.Show("Chưa Reset lại!");
}
}
public List <DTOHoaDon> GetHD(string sql)
{
dp.connect();
List <DTOHoaDon> list = new List <DTOHoaDon>();
{
string mh, mk, mn;
DateTime nx; int tt;
try
{
SqlDataReader dr = dp.ExecuteReader(sql);
while (dr.Read())
{
mh = dr.GetString(0);
mk = dr.GetString(1);
nx = dr.GetDateTime(2);
tt = dr.GetInt32(3);
mn = dr.GetString(4);
DTOHoaDon hd = new DTOHoaDon(mh, mk, nx, tt, mn);
list.Add(hd);
}
dr.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
finally { dp.disconnect(); }
}
}
private void btnTiep_Click(object sender, EventArgs e)
{
DTOHoaDon bill = new DTOHoaDon(fDatHang.mBillID, -1, DateTime.Now, null, 1);
DAOHoaDon.Instance.UpdateBillByID(fDatHang.mBillID, bill);
DAOShip.Instance.InsertShip(fDatHang.mBillID, doiTac, "NULL", "NULL", "NULL", "NULL", "NULL");
fTrangChu.Finish = true;
this.Close();
}
/// <summary>
/// Thành công: bill ID
/// thất bại: -1
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int GetUncheckBillIDByTableID(int id)
{
DataTable data = DataProvider.Instance.ExecuteQuery("SELECT * FROM dbo.Bill WHERE idTable = " + id + " AND status = 0");
if (data.Rows.Count > 0)
{
DTOHoaDon bill = new DTOHoaDon(data.Rows[0]);
return(bill.ID);
}
return(-1);
}
private void btnTiep_Click(object sender, EventArgs e)
{
DTOHoaDon bill = new DTOHoaDon(fDatHang.mBillID, -1, DateTime.Now, null, 1);
DAOHoaDon.Instance.UpdateBillByID(fDatHang.mBillID, bill);
string nguoiGiao, sdtNguoiGiao, nguoiNhan, sdtNguoiNhan, diaChi;
nguoiGiao = string.Format("N'{0}'", txtbNguoiGiao.Text);
sdtNguoiGiao = string.Format("'{0}'", txtbSDTNguoiGiao.Text);
nguoiNhan = string.Format("N'{0}'", txtbNguoiNhan.Text);
sdtNguoiNhan = string.Format("'{0}'", txtbSDTNguoiNhan.Text);
diaChi = string.Format("N'{0}'", txtbDiaChi.Text);
DAOShip.Instance.InsertShip(fDatHang.mBillID, null, nguoiGiao, sdtNguoiGiao, nguoiNhan, sdtNguoiNhan, diaChi);
fTrangChu.Finish = true;
this.Close();
}
public int Add(DTOHoaDon hd)
{
List <SqlParameter> paras = new List <SqlParameter>();
paras.Add(new SqlParameter("@mh", hd.MaHD));
paras.Add(new SqlParameter("@mk", hd.MaKH));
paras.Add(new SqlParameter("@nx", hd.NgayXuat));
paras.Add(new SqlParameter("@tt", hd.ThanhTien));
paras.Add(new SqlParameter("@mv", hd.MaNV));
try
{
return(dp.ExcuteNonQuery("ThemHD", System.Data.CommandType.StoredProcedure, paras));
}
catch (SqlException ex)
{
throw ex;
}
}
public void UpdateBillByID(int id, DTOHoaDon hoaDon)
{
string sqlFormattedDate = hoaDon.NgayDat.ToString("yyyy-MM-dd HH:mm:ss.fff");
string strIdKhachHang = "NULL";
string strHinhThucThanhToan = "NULL";
if (hoaDon.ID_KhachHang != -1)
{
strIdKhachHang = hoaDon.ID_KhachHang.ToString();
}
if (hoaDon.HinhThucThanhToan != null)
{
strHinhThucThanhToan = "N'" + hoaDon.HinhThucThanhToan + "'";
}
string query = string.Format(
"UPDATE HOADON SET ID_KhachHang = {0}, NgayDat = '{1}', HinhThucThanhToan = {2}, KT_Ship = {3}"
+ " WHERE ID = {4}", strIdKhachHang, sqlFormattedDate, strHinhThucThanhToan,hoaDon.KT_Ship,id);
DataProvider.Instance.ExcuteNonQuery(query);
}
public int Add(DTOHoaDon hd)
{
return(new DAOHoaDon().Add(hd));
}
