public void pLoad()
{
string sql = " SELECT tn.SoHoSo,DienThoai,DanhBo,lt.TenLoai,NgayNhan, GhiChu,CreateBy,ChuyenHS,DonViChuyen,NgayChuyen,NgayXuLy,KetQuaXuLy,NhanVienXuLy,TenKH,(SoNha + ' ' + TenDuong ) as DiaChi ";
sql += " FROM TiepNhan tn, LoaiTiepNhan lt ";
sql += " WHERE tn.LoaiHs=lt.ID ";
sql += " AND CONVERT(DATE,NgayNhan,103) BETWEEN CONVERT(DATE,'" + Utilities.DateToString.NgayVN(dateTuNgay.Value.Date) + "',103) AND CONVERT(DATE,'" + Utilities.DateToString.NgayVN(dateDenNgay.Value.Date) + "',103) ";
sql += " AND DonViChuyen='" + phong + "'";
if (ckChuaChuyen.Checked)
{
sql += " AND (ChuyenHS is NULL OR ChuyenHS='False')";
}
else if (ckChuaXuLy.Checked)
{
sql += " AND (ChuyenHS is not null AND NgayXuLy is null) ";
}
else if (ckHoanTat.Checked)
{
sql += " AND NgayXuLy IS NOT NULL ";
}
sql += " ORDER BY NgayNhan DESC";
dataGrid.DataSource = CCallCenter.getDataTable(sql);
}
private void btChuyenHS_Click(object sender, EventArgs e)
{
string listDanhBa = "";
int flag = 0;
for (int i = 0; i < dataGrid.Rows.Count; i++)
{
if ("True".Equals(this.dataGrid.Rows[i].Cells["checkChon"].Value + ""))
{
flag++;
listDanhBa += ("'" + (this.dataGrid.Rows[i].Cells["sohoso"].Value + "").Replace(" ", "") + "',");
}
}
string sql = "UPDATE TiepNhan SET ChuyenHS='True',Mess='True' ,NgayChuyen=GETDATE(),DonViChuyen='" + cbPhongBan.SelectedValue + "' WHERE SoHoSo IN (" + listDanhBa.Remove(listDanhBa.Length - 1, 1) + ") ";
if (CCallCenter.ExecuteCommand_(sql) > 0)
{
MessageBox.Show(this, "Chuyển Hồ Sơ Thành Công !", "..: Thông Báo :..", MessageBoxButtons.OK, MessageBoxIcon.Information); pLoad();
}
else
{
MessageBox.Show(this, "Chuyển Hồ Sơ Thất Bại !", "..: Thông Báo :..", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
// MessageBox.Show(this, listDanhBa.Remove(listDanhBa.Length - 1, 1));
}
public static DataTable getListTiepNhan(string danhbo)
{
string sql = " SELECT tn.SoHoSo,DienThoai,DanhBo,lt.TenLoai,NgayNhan, GhiChu,CreateBy,ChuyenHS,DonViChuyen,NgayChuyen,NgayXuLy,KetQuaXuLy,NhanVienXuLy,TenKH,(SoNha + ' ' + TenDuong ) as DiaChi ";
sql += " FROM TiepNhan tn, LoaiTiepNhan lt ";
sql += " WHERE tn.LoaiHs=lt.ID ";
sql += " AND DanhBo='" + danhbo + "' ORDER BY NgayNhan DESC ";
return(CCallCenter.getDataTable(sql));
}
private void btCapNhat_Click(object sender, EventArgs e)
{
string sql = "UPDATE TiepNhan SET NgayXuLy=GETDATE(),KetQuaXuLy=N'" + txtKetQuaXL.Text + "',NhanVienXuLy=N'" + CNguoiDung.HoTen + "' WHERE SoHoSo='" + txtSoHoSo.Text + "'";
if (CCallCenter.ExecuteCommand_(sql) > 0)
{
MessageBox.Show(this, "Cập Nhật Xử Lý Thành Công !", "..: Thông Báo :..", MessageBoxButtons.OK, MessageBoxIcon.Information); pLoad();
}
else
{
MessageBox.Show(this, "Cập Nhật Xử Lý Thất Bại !", "..: Thông Báo :..", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void bttiepnhan_Click(object sender, EventArgs e)
{
string listDanhBa = "";
int flag = 0;
for (int i = 0; i < dataGrid.Rows.Count; i++)
{
flag++;
listDanhBa += ("'" + (this.dataGrid.Rows[i].Cells["sohoso"].Value + "").Replace(" ", "") + "',");
}
string sql = "UPDATE TiepNhan SET Mess='False' WHERE SoHoSo IN (" + listDanhBa.Remove(listDanhBa.Length - 1, 1) + ") ";
CCallCenter.ExecuteCommand_(sql);
timer1.Stop();
this.Close();
}
public void alrt()
{
string sql2 = " SELECT tn.SoHoSo,DienThoai,DanhBo,lt.TenLoai,NgayNhan, GhiChu,CreateBy ";
sql2 += " FROM TiepNhan tn, LoaiTiepNhan lt ";
sql2 += " WHERE tn.LoaiHs=lt.ID ";
//sql2 += " AND CONVERT(DATE,NgayNhan,103) BETWEEN CONVERT(DATE,'" + Utilities.DateToString.NgayVN(dateTuNgay.Value.Date) + "',103) AND CONVERT(DATE,'" + Utilities.DateToString.NgayVN(dateDenNgay.Value.Date) + "',103) ";
sql2 += " AND DonViChuyen='TCTB' AND Mess='True' ";
DataTable tb = CCallCenter.getDataTable(sql2);
if (tb.Rows.Count > 0)
{
Mess of = new Mess(tb);
timer1.Stop();
if (of.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
timer1.Start();
}
}
}
public void alrt()
{
string sql = " SELECT tn.SoHoSo,DienThoai,DanhBo,lt.TenLoai,NgayNhan, GhiChu,CreateBy,ChuyenHS,DonViChuyen,NgayChuyen,NgayXuLy,KetQuaXuLy,NhanVienXuLy,TenKH,(SoNha + ' ' + TenDuong ) as DiaChi ";
sql += " FROM TiepNhan tn, LoaiTiepNhan lt ";
sql += " WHERE tn.LoaiHs=lt.ID ";
sql += " AND DATEDIFF(DD,NgayNhan,GETDATE())>3 ";
sql += " AND NgayXuLy IS NULL ";
sql += " ORDER BY NgayNhan DESC";
DataTable tb = CCallCenter.getDataTable(sql);
if (tb.Rows.Count > 0)
{
MessChuaXL of = new MessChuaXL(tb);
timer1.Stop();
of.ShowDialog();
//if (of.ShowDialog() == System.Windows.Forms.DialogResult.OK )
// timer1.Start();
}
}
public void pLoad()
{
string sql = " SELECT tn.SoHoSo,DienThoai,DanhBo,lt.TenLoai,NgayNhan, GhiChu,CreateBy,ChuyenHS,DonViChuyen,NgayChuyen,NgayXuLy,KetQuaXuLy,NhanVienXuLy,TenKH,(SoNha + ' ' + TenDuong ) as DiaChi ";
sql += " FROM TiepNhan tn, LoaiTiepNhan lt ";
sql += " WHERE tn.LoaiHs=lt.ID ";
sql += " AND CONVERT(DATE,NgayNhan,103) BETWEEN CONVERT(DATE,'" + Utilities.DateToString.NgayVN(dateTuNgay.Value.Date) + "',103) AND CONVERT(DATE,'" + Utilities.DateToString.NgayVN(dateDenNgay.Value.Date) + "',103) ";
if (cbLoai.SelectedIndex == 0)
{
sql += " AND LoaiTN='KH'";
}
else
{
sql += " AND LoaiTN='GM'";
}
if (ckChuaChuyen.Checked)
{
sql += " AND (ChuyenHS is NULL OR ChuyenHS='False')";
}
else if (ckChuaXuLy.Checked)
{
sql += " AND (ChuyenHS is not null AND NgayXuLy is null) ";
}
else if (ckHoanTat.Checked)
{
sql += " AND NgayXuLy IS NOT NULL ";
}
sql += " ORDER BY NgayNhan DESC";
dataGrid.DataSource = CCallCenter.getDataTable(sql);
// format();
cbPhongBan.DataSource = CCallCenter.getDataTable("SELECT * FROM PhongBan ");
cbPhongBan.DisplayMember = "TenPhong";
cbPhongBan.ValueMember = "MaPhong";
}
