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"; }