private void btnThu_Click(object sender, EventArgs e)
{
if (txtTienThu.Text.Equals("") == false)
{
float tienNo = (float)Convert.ToDouble(txtTienNo.Text);
float tienThu = (float)Convert.ToDouble(txtTienThu.Text);
if (tienThu <= tienNo)
{
int id = dsIdDL[cbDaiLy.SelectedIndex];
DateTime ngayThu = dtNgayThu.Value;
float soTienThu = (float)Convert.ToDouble(txtTienThu.Text);
string cmnd = nhanVien.Cmnd;
DTO_PhieuThuTien pt = new DTO_PhieuThuTien(0, ngayThu, soTienThu, id, cmnd);
BUS_PhieuThuTien.ThemPhieuThu(pt);
float tienNoMoi = tienNo - tienThu;
int kq = BUS_DaiLy.UpdateTienNo(id, tienNoMoi);
if (kq == 1)
{
MessageBox.Show("Thu thành công");
txtTienNo.Text = BUS_DaiLy.GetTienNo(id).ToString();
txtTienThu.Text = "";
}
else if (kq == 2)
{
MessageBox.Show("tiền nợ vượt quá quy định");
}
else
{
MessageBox.Show("Thu thất bại");
}
}
}
}
public static ArrayList DSPhieuThu()
{
ArrayList arrList = new ArrayList();
DataTable dt = new DataTable();
dt = ResultQuery.GetTableResult(conn, "SELECT * FROM PhieuThuTien ");
int idPhieuThu;
DateTime ngayThu;
float soTienThu;
int idDaiLy;
string cmnd;
foreach (DataRow r in dt.Rows)
{
idPhieuThu = (int)r["IdPhieuXuat"];
ngayThu = Convert.ToDateTime(r["NgayThu"]);
soTienThu = (float)Convert.ToDouble(r["SoTienThu"]);
idDaiLy = (int)r["IdDaiLy"];
cmnd = r["CMND"].ToString();
DTO_PhieuThuTien phieuThu = new DTO_PhieuThuTien(idPhieuThu, ngayThu, soTienThu, idDaiLy, cmnd);
arrList.Add(phieuThu);
}
return(arrList);
}
/*
* ThemPhieuThu trả về
* 1:thành công
* 0:thất bại
*/
public static int ThemPhieuThu(DTO_PhieuThuTien ptt)
{
int kq = 0;
string ngayThuSql = ptt.NgayThu.ToString("yyyy-MM-dd");
string query = "insert into PhieuThuTien(NgayThu, SoTienThu, IdDaiLy, CMND) values('" + ngayThuSql + "'," + ptt.SoTienThu + "," + ptt.IdDaiLy + ",'" + ptt.Cmnd + "')";
kq = ResultQuery.GetResultQuery(conn, query);
return(kq);
}
private void btnAdd_Click(object sender, EventArgs e)
{
if (txtTienThu.Text.Equals("") == false)
{
float tienNo = (float)Convert.ToDouble(txtTienNo.Text);
float tienThu = (float)Convert.ToDouble(txtTienThu.Text);
if (tienThu <= tienNo)
{
int id = dsIdDL[cbDaiLy.SelectedIndex];
DateTime ngayThu = dtNgayThu.Value;
float soTienThu = (float)Convert.ToDouble(txtTienThu.Text);
string cmnd = nhanVien.Cmnd;
DTO_PhieuThuTien pt = new DTO_PhieuThuTien(0, ngayThu, soTienThu, id, cmnd);
BUS_PhieuThuTien.ThemPhieuThu(pt);
float tienNoMoi = tienNo - tienThu;
BUS_DaiLy.UpdateTienNo(id, tienNoMoi);
}
}
}
public static int ThemPhieuThu(DTO_PhieuThuTien p)
{
int al = DAL_PhieuThuTien.ThemPhieuThu(p);
return(al);
}
