private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_str_query = "";
if (m_id_sinh_vien == 0)
{
if (CIPConvert.ToDecimal(m_cbo_ma_lop_hoc.SelectedValue.ToString()) > -1)
{
v_str_query = "SELECT * FROM V_DIEM_THI WHERE ID_LOP_HOC = " + m_cbo_ma_lop_hoc.SelectedValue.ToString();
}
else
{
v_us.FillDatasetWithQuery(v_ds, "SELECT * FROM V_DIEM_THI WHERE ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString());
}
}
else
{
if (CIPConvert.ToDecimal(m_cbo_ma_lop_hoc.SelectedValue.ToString()) > -1)
{
v_str_query = "SELECT * FROM V_DIEM_THI WHERE ID_LOP_HOC = " + m_cbo_ma_lop_hoc.SelectedValue.ToString() + "AND ID_SINH_VIEN = " + m_id_sinh_vien.ToString();
}
else
{
v_us.FillDatasetWithQuery(v_ds, "SELECT * FROM V_DIEM_THI WHERE ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString() + "AND ID_SINH_VIEN = " + m_id_sinh_vien.ToString());
}
}
v_us.FillDatasetWithQuery(v_ds, v_str_query);
m_grc_diem_thi.DataSource = v_ds.Tables[0];
}
private void update_log_tiep_nhan()
{
US_GD_LOG_DAT_HANG v_US = new US_GD_LOG_DAT_HANG(m_us.dcID);
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
if (us_user.dcIDNhom == 2)
{
v_us.FillDatasetWithQuery(v_ds, "SELECT *FROM GD_LOG_DAT_HANG WHERE ID_GD_DAT_HANG =" + v_US.dcID_GD_DAT_HANG.ToString() + "And ID_LOAI_THAO_TAC in (295,311) And THAO_TAC_HET_HAN_YN = 'N' AND ID_NGUOI_NHAN_THAO_TAC = " + us_user.dcID.ToString());
}
else if (us_user.dcIDNhom == 3)
{
v_us.FillDatasetWithQuery(v_ds, "SELECT *FROM GD_LOG_DAT_HANG WHERE ID_GD_DAT_HANG =" + v_US.dcID_GD_DAT_HANG.ToString() + "And ID_LOAI_THAO_TAC in (303) And THAO_TAC_HET_HAN_YN = 'N' AND ID_NGUOI_NHAN_THAO_TAC = " + us_user.dcID.ToString());
}
else if (us_user.dcIDNhom == 5)
{
v_us.FillDatasetWithQuery(v_ds, "SELECT *FROM GD_LOG_DAT_HANG WHERE ID_GD_DAT_HANG =" + v_US.dcID_GD_DAT_HANG.ToString() + "And ID_LOAI_THAO_TAC in (305) And THAO_TAC_HET_HAN_YN = 'N' AND ID_NGUOI_NHAN_THAO_TAC = " + us_user.dcID.ToString());
}
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
v_US = new US_GD_LOG_DAT_HANG(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i][0].ToString()));
v_US.strTHAO_TAC_HET_HAN_YN = "Y";
v_US.Update();
}
}
private void simpbtn_xoa_Click(object sender, EventArgs e)
{
try
{
DataRow v_dr = m_grv_dm_cau_hoi.GetDataRow(m_grv_dm_cau_hoi.FocusedRowHandle);
decimal v_id = CIPConvert.ToDecimal(v_dr[DM_CAU_HOI.ID].ToString());
US_DM_CAU_HOI v_us = new US_DM_CAU_HOI(v_id);
// xóa bảng câu trả lời
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
US_DUNG_CHUNG v_us_dc = new US_DUNG_CHUNG();
v_us_dc.FillDatasetWithQuery(v_ds, "select * from dm_cau_tra_loi where id_cau_hoi=" + v_id.ToString());
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
decimal v_datarow = CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i]["ID"].ToString());
US_DM_CAU_TRA_LOI v_d_r = new US_DM_CAU_TRA_LOI(v_datarow);
v_d_r.Delete();
}
// xóa bảng câu hỏi
v_us.Delete();
MessageBox.Show("Da xoa thanh cong " + v_dr[DM_CAU_HOI.ID].ToString());
load_data_grid();
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
private void load_data_2_grid(decimal v_dc_value)
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_str_query;
if (v_dc_value > -1)
{
v_str_query = "SELECT* FROM V_KET_QUA_HOC_TAP WHERE ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString() + "AND ID_LOP_SINH_VIEN = " + m_cbo_lop_sinh_vien.SelectedValue.ToString();
}
else
{
if (CIPConvert.ToDecimal(m_cbo_khoa.SelectedValue.ToString()) > -1 && CIPConvert.ToDecimal(m_cbo_khoa_vien.SelectedValue.ToString()) > -1)
{
v_str_query = "SELECT* FROM V_KET_QUA_HOC_TAP WHERE ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString() + " AND ID_KHOA = " + m_cbo_khoa.SelectedValue.ToString() + "AND ID_KHOA_VIEN = " + m_cbo_khoa_vien.SelectedValue.ToString();
}
else if (CIPConvert.ToDecimal(m_cbo_khoa.SelectedValue.ToString()) == -1 && CIPConvert.ToDecimal(m_cbo_khoa_vien.SelectedValue.ToString()) > -1)
{
v_str_query = "SELECT* FROM V_KET_QUA_HOC_TAP WHERE ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString() + "AND ID_KHOA_VIEN = " + m_cbo_khoa_vien.SelectedValue.ToString();
}
else if (CIPConvert.ToDecimal(m_cbo_khoa.SelectedValue.ToString()) > -1 && CIPConvert.ToDecimal(m_cbo_khoa_vien.SelectedValue.ToString()) == -1)
{
v_str_query = "SELECT* FROM V_KET_QUA_HOC_TAP WHERE ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString() + "AND ID_KHOA = " + m_cbo_khoa.SelectedValue.ToString();
}
else
{
v_str_query = "SELECT* FROM V_KET_QUA_HOC_TAP WHERE ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString();
}
}
v_us.FillDatasetWithQuery(v_ds, v_str_query);
m_grc_ket_qua.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid(decimal m_id_dich_vu)
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
// v_us.FillDatasetWithTableName(v_ds, "V_HT_NGUOI_SU_DUNG");
v_us.FillDatasetWithQuery(v_ds, " select distinct ID_BO, BO from V_DICH_VU_BO_PM_TD where ID_DICH_VU=" + m_id_dich_vu);
m_grc_ht_nguoi_su_dung.DataSource = v_ds.Tables[0];
Color.AliceBlue.ToArgb();
DataSet v_ds_appointment = new DataSet();
v_ds_appointment.Tables.Add(new DataTable());
DataSet v_ds_resource = new DataSet();
v_ds_resource.Tables.Add(new DataTable());
v_us.FillAppointmentByDichVu(v_ds_appointment, m_id_dich_vu);
v_us.FillResourcesByDichVu(v_ds_resource, m_id_dich_vu);
SetUpMapping();
schedulerStorage1.Appointments.DataSource = v_ds_appointment.Tables[0];
schedulerStorage1.Resources.DataSource = v_ds_resource.Tables[0];
m_sch.ActiveViewType = SchedulerViewType.Timeline;
m_sch.GroupType = SchedulerGroupType.Resource;
m_sch.Start = System.DateTime.Now;
}
private bool kiem_tra_du_lieu_truoc_luu()
{
if (m_txt_ma_sinh_vien.Text == " " || m_txt_ma_sinh_vien.TextLength == 0)
{
MessageBox.Show("Sinh viên có mã " + m_txt_ma_sinh_vien.Text + " không tồn tại!");
m_txt_ma_sinh_vien.Focus();
return(false);
}
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from v_ket_qua_hoc_tap where ma_sinh_vien = " + m_txt_ma_sinh_vien.Text);
if (v_ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Sinh viên có mã " + m_txt_ma_sinh_vien.Text + " không tồn tại!");
m_txt_ma_sinh_vien.Focus();
return(false);
}
else
{
m_lb_ho_ten_sinh_vien.Text = v_ds.Tables[0].Rows[0]["TEN_SINH_VIEN"].ToString();
}
return(true);
}
private bool check_du_lieu_truoc_luu(DataRow v_dr)
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from dm_sinh_vien where ma_sinh_vien='" + m_txt_ma_so_sinh_vien.Text + "' AND ma_sinh_vien != " + v_dr["MA_SINH_VIEN"].ToString());
if (v_ds.Tables[0].Rows.Count != 0)
{
MessageBox.Show("Sinh viên có mã số này đã tồn tại!");
return false;
}
if (m_txt_ma_so_sinh_vien.Text == "" || m_txt_ho_ten_sinh_vien.Text == "")
{
MessageBox.Show("Hãy điền đủ thông tin trước khi lưu!");
return false;
}
if (CIPConvert.ToDecimal(m_cbo_lop_sinh_vien.SelectedValue) == -1)
{
MessageBox.Show("Hãy chọn lớp phù hợp!");
return false;
}
return true;
}
private void format_controll(decimal p)
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from V_HT_PHAN_QUYEN_CHO_NHOM where id_NHOM_NGUOI_SU_DUNG=" + us_user.dcIDNhom);
List<Control> list = new List<Control>();
GetAllControl(this, list);
foreach (Control control in list)
{
if (control.GetType() == typeof(SimpleButton) || control.GetType() == typeof(Panel))
{
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
if (control.Name == v_ds.Tables[0].Rows[i]["CONTROL_NAME"].ToString())
{
control.Visible = true;
}
}
}
}
}
public void load_data()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_str_query = "";
if (m_trang_thai == 0)
{
v_str_query = "SELECT DISTINCT * FROM V_BO_PM_TD_DICH_VU_GD_DAT_HANG_GD_LOG_DAT_HANG bptdvgdhgldh WHERE (bptdvgdhgldh.ID_NGUOI_SU_DUNG = " + us_user.dcID.ToString() + ") AND (bptdvgdhgldh.CAP_SU_DUNG =" + us_user.dcIDNhom.ToString() + ")" + "AND thoi_gian_hoan_thanh is not null AND THAO_TAC_HET_HAN_YN = 'N' AND ID_DANH_GIA_TU_USER_DAT_HANG IS NULL";
m_pan_button.Visible = false;
}
else if (m_trang_thai == 1)
{
v_str_query = "SELECT DISTINCT * FROM V_BO_PM_TD_DICH_VU_GD_DAT_HANG_GD_LOG_DAT_HANG bptdvgdhgldh WHERE (bptdvgdhgldh.ID_NGUOI_SU_DUNG = " + us_user.dcID.ToString() + ") AND (bptdvgdhgldh.CAP_SU_DUNG =" + us_user.dcIDNhom.ToString() + ")" + "AND thoi_gian_hoan_thanh is not null AND THAO_TAC_HET_HAN_YN = 'N' AND ID_DANH_GIA_TU_USER_DAT_HANG IS NOT NULL";
m_pan_button.Visible = false;
}
else
{
v_str_query = "SELECT DISTINCT * FROM V_GD_DAT_HANG_GD_LOG_DAT_HANG WHERE thoi_gian_hoan_thanh is not null AND THAO_TAC_HET_HAN_YN = 'N' AND ID_DANH_GIA_TU_USER_DAT_HANG IS NOT NULL";
c_dich_vu_yeu_cau.FieldName = "TEN_NHOM_DICH_VU_YEU_CAU";
m_pan_button.Visible = false;
}
v_us.FillDatasetWithQuery(v_ds, v_str_query);
m_grc_ds_dh_hoan_thanh.DataSource = v_ds.Tables[0];
}
private bool check_du_lieu_truoc_luu()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from dm_sinh_vien where ma_sinh_vien='" + m_txt_ma_so_sinh_vien.Text + "'");
if (v_ds.Tables[0].Rows.Count != 0)
{
MessageBox.Show("Sinh viên có mã số này đã tồn tại!");
return(false);
}
if (m_txt_ma_so_sinh_vien.Text == "" || m_txt_ho_ten_sinh_vien.Text == "")
{
MessageBox.Show("Hãy điền đủ thông tin trước khi lưu!");
return(false);
}
if (CIPConvert.ToDecimal(m_cbo_lop_sinh_vien.SelectedValue) == -1)
{
MessageBox.Show("Hãy chọn lớp phù hợp!");
return(false);
}
return(true);
}
private bool kiem_tra_du_lieu_truoc_luu()
{
if (m_txt_ma_sinh_vien.Text == " " || m_txt_ma_sinh_vien.TextLength == 0)
{
MessageBox.Show("Sinh viên có mã " + m_txt_ma_sinh_vien.Text + " không tồn tại!");
m_txt_ma_sinh_vien.Focus();
return false;
}
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from v_ket_qua_hoc_tap where ma_sinh_vien = " + m_txt_ma_sinh_vien.Text);
if (v_ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Sinh viên có mã " + m_txt_ma_sinh_vien.Text + " không tồn tại!");
m_txt_ma_sinh_vien.Focus();
return false;
}
else
{
m_lb_ho_ten_sinh_vien.Text = v_ds.Tables[0].Rows[0]["TEN_SINH_VIEN"].ToString();
}
return true;
}
private bool check_du_lieu_truoc_luu()
{
if (m_txt_tai_khoan.Text == "")
{
MessageBox.Show("Tài khoản chưa đúng!");
m_txt_tai_khoan.Focus();
return(false);
}
DataRow v_dr = m_grv_user_name.GetDataRow(m_grv_user_name.FocusedRowHandle);
if (v_dr["TAI_KHOAN"].ToString() != m_txt_tai_khoan.Text)
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from user_name where tai_khoan = '" + m_txt_tai_khoan.Text + "'");
if (v_ds.Tables[0].Rows.Count != 0)
{
MessageBox.Show("Tài khoản đã tồn tại!");
return(false);
}
}
return(true);
}
private void load_data_to_grv_ds_nv(decimal v_id_nhom, List <decimal> v_list_id_nguoi_xu_ly)
{
if (v_list_id_nguoi_xu_ly.Count != 0)
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_query = "SELECT distinct hbdv.ID_NGUOI_SU_DUNG, hnsd.TEN_TRUY_CAP FROM HT_BO_DICH_VU hbdv,HT_NGUOI_SU_DUNG hnsd WHERE hnsd.ID = hbdv.ID_NGUOI_SU_DUNG AND hbdv.ID_NGUOI_SU_DUNG IN (";
for (int i = 0; i < v_list_id_nguoi_xu_ly.Count; i++)
{
v_query += v_list_id_nguoi_xu_ly[i].ToString() + ",";
if (i == v_list_id_nguoi_xu_ly.Count - 1)
{
v_query += v_list_id_nguoi_xu_ly[i].ToString();
}
}
v_query += ")";
v_us.FillDatasetWithQuery(v_ds, v_query);
if (v_id_nhom == 2)
{
grc_danh_sach_bo.DataSource = v_ds.Tables[0];
}
else if (v_id_nhom == 3)
{
grc_danh_sach_pm.DataSource = v_ds.Tables[0];
}
else if (v_id_nhom == 5)
{
grc_danh_sach_td.DataSource = v_ds.Tables[0];
}
}
}
private void load_data()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_str_query = "";
if (m_trang_thai == 0)
{
v_str_query = "SELECT DISTINCT * FROM V_BO_PM_TD_DICH_VU_GD_DAT_HANG_GD_LOG_DAT_HANG bptdvgdhgldh WHERE (bptdvgdhgldh.ID_NGUOI_SU_DUNG = " + us_user.dcID.ToString() + ") AND (bptdvgdhgldh.CAP_SU_DUNG ="+us_user.dcIDNhom.ToString() + ")" + "AND thoi_gian_hoan_thanh is not null AND THAO_TAC_HET_HAN_YN = 'N' AND ID_DANH_GIA_TU_USER_DAT_HANG IS NULL";
m_pan_button.Visible = false;
}
else if (m_trang_thai == 1)
{
v_str_query = "SELECT DISTINCT * FROM V_BO_PM_TD_DICH_VU_GD_DAT_HANG_GD_LOG_DAT_HANG bptdvgdhgldh WHERE (bptdvgdhgldh.ID_NGUOI_SU_DUNG = " + us_user.dcID.ToString() + ") AND (bptdvgdhgldh.CAP_SU_DUNG =" + us_user.dcIDNhom.ToString() + ")" + "AND thoi_gian_hoan_thanh is not null AND THAO_TAC_HET_HAN_YN = 'N' AND ID_DANH_GIA_TU_USER_DAT_HANG IS NOT NULL";
m_pan_button.Visible = false;
}
else
{
v_str_query = "SELECT DISTINCT * FROM V_GD_DAT_HANG_GD_LOG_DAT_HANG WHERE thoi_gian_hoan_thanh is not null AND THAO_TAC_HET_HAN_YN = 'N' AND ID_DANH_GIA_TU_USER_DAT_HANG IS NOT NULL";
c_dich_vu_yeu_cau.FieldName = "TEN_NHOM_DICH_VU_YEU_CAU";
m_pan_button.Visible = false;
}
v_us.FillDatasetWithQuery(v_ds, v_str_query);
m_grc_ds_dh_hoan_thanh.DataSource = v_ds.Tables[0];
}
private void m_cmd_BO_tu_choi_Click(object sender, EventArgs e)
{
decimal id_nguoi_tao;
try
{
fill_data_to_m_us();
if (m_us.dcID_LOAI_THAO_TAC == 313)
{
US_DUNG_CHUNG v_us_dung_chung = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us_dung_chung.FillDatasetWithQuery(v_ds, "SELECT id FROM GD_LOG_DAT_HANG gldh WHERE gldh.ID_LOAI_THAO_TAC in (295,311) AND gldh.ID_GD_DAT_HANG = " + m_us.dcID_DON_HANG + "ORDER BY id DESC");
US_GD_LOG_DAT_HANG v_us_log = new US_GD_LOG_DAT_HANG(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0]["ID"].ToString()));
id_nguoi_tao = v_us_log.dcID_NGUOI_TAO_THAO_TAC;
}
else
{
id_nguoi_tao = m_us.dcID_NGUOI_TAO;
}
f107_tu_choi_don_hang v_f107 = new f107_tu_choi_don_hang();
v_f107.displayForRefuse(m_us, id_nguoi_tao);
load_data_2_grid();
}
catch (Exception v_e)
{
CSystemLog_100.ExceptionHandle(v_e);
}
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from V_GD_DAT_HANG WHERE THOI_GIAN_HOAN_THANH IS NOT NULL ORDER BY [THOI_GIAN_TAO] DESC");
m_grc_ds_dh_hoan_thanh.DataSource = v_ds.Tables[0];
}
private void load_data_to_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, " select * from V_GD_DAT_HANG_GD_LOG_DAT_HANG WHERE ID IS NOT NULL order by NGAY_LAP_THAO_TAC desc");
m_grc_ds_log_gd_dat_hang.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from v_ket_qua_hoc_tap where ma_sinh_vien = " + m_txt_ma_sinh_vien.Text);
m_pivot_kq_sinh_vien.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new System.Data.DataTable());
v_us.FillDatasetWithQuery(v_ds, "SELECT * FROM V_DIEM_THI WHERE ID_SINH_VIEN =" + m_dc_id_sinh_vien.ToString() + " AND ID_HOC_KY = " + m_cbo_ky_hoc.SelectedValue.ToString());
m_grc_ket_qua_tra_cuu.DataSource = v_ds.Tables[0];
}
private void load_data_2_ma_giang_vien()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from dm_giang_vien");
m_txt_ma_giang_vien.Text = (CIPConvert.ToDecimal( v_ds.Tables[0].Rows[v_ds.Tables[0].Rows.Count -1]["MA_GIANG_VIEN"].ToString()) + 1).ToString();
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from V_GD_DAT_HANG where dbo.f_get_trang_thai_xu_ly_don_hang_YN(ID) = 'Y'");
m_grc_ds_don_dat_hang.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, query);
m_grc_ds_don_hang_nguoi_xu_ly.DataSource = v_ds.Tables[0];
}
internal void load_to_form(decimal v_id_nhom)
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "SELECT hnsd.ID,hnsd.TEN FROM V_HT_NGUOI_SU_DUNG hnsd WHERE hnsd.ID_NHOM = "+v_id_nhom.ToString());
grc_danh_sach.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from v_gd_dat_hang_gd_log_dat_hang");
//m_grv_gd_dat_hang_gd_log_dat_hang.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "SELECT * FROM V_DIEM_THI WHERE ID_LOP_HOC=" + m_cbo_ma_lop_hoc.SelectedValue );
m_grc_bao_cao_hoc_tap_theo_ma_lop_hoc.DataSource = v_ds.Tables[0];
}
private void gui_email_bao_hoan_thanh()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
US_V_GD_DAT_HANG m_us_v_gd_dat_hang = new US_V_GD_DAT_HANG(M_us.dcID);
v_us.FillDatasetWithQuery(v_ds, "select * from dm_mau_email where id =6");
string TIEU_DE = v_ds.Tables[0].Rows[0]["TIEU_DE_MAIL"].ToString();
string NOI_DUNG = v_ds.Tables[0].Rows[0]["NOI_DUNG_EMAIL"].ToString();
string GUI_CC = v_ds.Tables[0].Rows[0]["GUI_CC"].ToString();
TIEU_DE = TIEU_DE.Replace("MA_DON_HANG", m_us_v_gd_dat_hang.strMA_DON_HANG);
NOI_DUNG = NOI_DUNG.Replace("MA_DON_HANG", m_us_v_gd_dat_hang.strMA_DON_HANG);
NOI_DUNG = NOI_DUNG.Replace("USER_NHAN_VIEN", m_us_v_gd_dat_hang.strHO_TEN_USER_DAT_HANG);
NOI_DUNG = NOI_DUNG.Replace("USER_DON_VI", m_us_v_gd_dat_hang.strMA_DON_VI);
NOI_DUNG = NOI_DUNG.Replace("USER_DIEN_THOAI", M_us.strDIEN_THOAI);
NOI_DUNG = NOI_DUNG.Replace("USER_THOI_GIAN_DAT_HANG", M_us.datTHOI_GIAN_TAO.ToString());
NOI_DUNG = NOI_DUNG.Replace("LOAI_DICH_VU_HO_TRO", m_us_v_gd_dat_hang.strTEN_YEU_CAU);
NOI_DUNG = NOI_DUNG.Replace("YEU_CAU_CU_THE", M_us.strNOI_DUNG_DAT_HANG);
NOI_DUNG = NOI_DUNG.Replace("THOI_GIAN_HOAN_THANH_THUC_TE", M_us.datTHOI_GIAN_HOAN_THANH.ToString());
NOI_DUNG = NOI_DUNG.Replace("LICH_SU_TRAO_DOI", "Hoàn thành");
NOI_DUNG = NOI_DUNG.Replace("THOI_GIAN_MONG_MUON_SUA_XONG", M_us.datTHOI_DIEM_CAN_HOAN_THANH + "hoặc thời gian hoàn thành là:"+ M_us.datTHOI_GIAN_HOAN_THANH);
NOI_DUNG = NOI_DUNG.Replace("PHAN_HOI_CUA_DVMC", M_us.strPHAN_HOI_TU_DVMC);
string nguoi_xu_ly = "";
List<decimal> m_lst_id_nguoi_xu_ly = new List<decimal>();
US_DUNG_CHUNG v_us_3 = new US_DUNG_CHUNG();
DataSet v_ds_3 = new DataSet();
v_ds_3.Tables.Add(new DataTable());
v_us_3.FillDatasetWithQuery(v_ds_3, "select * from V_GD_DAT_HANG_GD_LOG_DAT_HANG where ten_nguoi_tao_thao_tac_log is not null and thao_tac_het_han_yn='N' and ID_DON_HANG=" + M_us.dcID);
for (int i = 0; i < v_ds_3.Tables[0].Rows.Count; i++)
{
nguoi_xu_ly+="," +v_ds_3.Tables[0].Rows[i]["TEN_NGUOI_TAO_THAO_TAC_LOG"].ToString();
}
NOI_DUNG = NOI_DUNG.Replace("NGUOI_XU_LY_DON_HANG", nguoi_xu_ly);
NOI_DUNG = NOI_DUNG.Replace("NGUOI_NHAN_DAT_HANG", m_us_v_gd_dat_hang.strNGUOI_TAO);
US_DUNG_CHUNG v_us_1 = new US_DUNG_CHUNG();
DataSet v_ds_1 = new DataSet();
v_ds_1.Tables.Add(new DataTable());
v_us_1.FillDatasetWithQuery(v_ds_1, "select * from dm_khach_hang where id=" + M_us.dcID_USER_NV_DAT_HANG);
string to_cc = "";
to_cc = v_ds_1.Tables[0].Rows[0]["EMAIL"].ToString();
string user_email = "*****@*****.**";
string password = "******";
try
{
Mail.sendEmail(user_email, password, to_cc, TIEU_DE, NOI_DUNG);
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
public void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from V_GD_DAT_HANG WHERE THOI_GIAN_HOAN_THANH IS NOT NULL ORDER BY [THOI_GIAN_TAO] DESC");
m_grc_ds_dh_hoan_thanh.DataSource = v_ds.Tables[0];
}
public void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from V_GD_DAT_HANG where dbo.f_get_trang_thai_xu_ly_don_hang_YN(ID) = 'Y' order by THOI_GIAN_TAO DESC");
m_grc_ds_don_dat_hang.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, " select * from DM_BLACK_LIST where ADD_YN='N'");
m_grc_ds_backlist.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid(string id_nhan_vien)
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
DataTable v_dt = new DataTable();
v_ds.Tables.Add(v_dt);
v_us.FillDatasetWithQuery(v_ds, "select * from v_gd_phu_thuoc_details where DA_XOA = 'N' and id_nhan_vien =" + id_nhan_vien);
m_grc.DataSource = v_ds.Tables[0];
}
private void load_data_2_ma_giang_vien()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from dm_giang_vien");
m_txt_ma_giang_vien.Text = (CIPConvert.ToDecimal(v_ds.Tables[0].Rows[v_ds.Tables[0].Rows.Count - 1]["MA_GIANG_VIEN"].ToString()) + 1).ToString();
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_str_query = "SELECT VKQHT.* ,DS_HOC_BONG.MUC_HONG_BONG FROM V_KET_QUA_HOC_TAP AS VKQHT, (SELECT * FROM dbo.fn_ds_hoc_bong(" + m_cbo_hoc_ky.SelectedValue.ToString() + ") ) AS DS_HOC_BONG WHERE DS_HOC_BONG.ID_SINH_VIEN = VKQHT.ID_SINH_VIEN AND VKQHT.ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString();
v_us.FillDatasetWithQuery(v_ds,v_str_query);
m_grc_bao_cao_hoc_tap_theo_sv.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from v_ket_qua_hoc_tap where ma_sinh_vien = " + m_txt_ma_sinh_vien.Text);
m_pivot_kq_sinh_vien.DataSource = v_ds.Tables[0];
}
private void load_to_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_str_query = "SELECT gdh.*FROM V_GD_DAT_HANG as gdh, HT_BO_DICH_VU bdv WHERE dbo.f_get_trang_thai_cho_xu_ly_don_hang_YN(gdh.ID) = 'Y' AND gdh.ID_DV_YEU_CAU = bdv.ID_DICH_VU AND bdv.ID_NGUOI_SU_DUNG =" + us_user.dcID.ToString() + "and bdv.CAP_SU_DUNG =" + us_user.dcIDNhom.ToString() + "ORDER BY gdh.[THOI_GIAN_TAO] DESC";
v_us.FillDatasetWithQuery(v_ds, v_str_query);
m_grc_ds_don_hang_can_xu_ly.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new System.Data.DataTable());
v_us.FillDatasetWithQuery(v_ds, "SELECT * FROM V_DIEM_THI WHERE ID_SINH_VIEN =" + m_dc_id_sinh_vien.ToString() + " AND ID_HOC_KY = " + m_cbo_ky_hoc.SelectedValue.ToString());
m_grc_ket_qua_tra_cuu.DataSource = v_ds.Tables[0];
}
private void get_id_gd_diem(US_DUNG_CHUNG v_us_dc, decimal v_id_ns, decimal v_id_gdlm, DataRow v_dt_r, ref int v_int_khong_nhap_duoc, DataRow v_data_row, ref decimal v_count)
{
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us_dc.FillDatasetWithQuery(v_ds, "SELECT * FROM GD_DIEM WHERE ID_NHAN_VIEN=" + v_id_ns.ToString() + " AND ID_LOP_MON=" + v_id_gdlm.ToString());
if (v_ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Nhân viên này chưa có tên trong lớp môn này");
}
v_dt_r = v_ds.Tables[0].Rows[0];
decimal v_id_gdd = CIPConvert.ToDecimal(v_dt_r["ID"].ToString());
US_GD_DIEM v_us_gdd = new US_GD_DIEM(v_id_gdd);
if (v_us_gdd.dcDIEM_CHUYEN_CAN.ToString() == "")
{
v_us_gdd.IsDIEM_CHUYEN_CANNull();
}
else
{
v_us_gdd.dcDIEM_CHUYEN_CAN = CIPConvert.ToDecimal(v_data_row["DIEM_CHUYEN_CAN"].ToString());
}
if (v_us_gdd.dcDIEM_THI.ToString() == "")
{
v_us_gdd.IsDIEM_THINull();
}
else
{
v_us_gdd.dcDIEM_THI = CIPConvert.ToDecimal(v_data_row["DIEM_KIEM_TRA"].ToString());
}
if (v_us_gdd.dcDIEM_KIEM_TRA.ToString()=="")
{
v_us_gdd.IsDIEM_KIEM_TRANull();
}
else
{
v_us_gdd.dcDIEM_KIEM_TRA = CIPConvert.ToDecimal(v_data_row["DIEM_THI"].ToString());
}
v_us_gdd.strQUA_MON = v_data_row["KET_QUA"].ToString();
v_us_gdd.datNGAY_SUA = DateTime.Now.Date;
v_us_gdd.strHOC_XONG_YN = "Y";
v_us_gdd.Update();
try
{
v_us_gdd.Update();
v_data_row.Delete();
v_count++;
}
catch (Exception)
{
MessageBox.Show("Lỗi!");
v_int_khong_nhap_duoc++;
}
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "SELECT * FROM V_DIEM_THI WHERE ID_LOP_HOC=" + m_cbo_ma_lop_hoc.SelectedValue);
m_grc_bao_cao_hoc_tap_theo_ma_lop_hoc.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid_dp_lai(decimal id_user)
{
query += "And ID_LOAI_THAO_TAC in (295,311) And ID_NGUOI_NHAN_THAO_TAC = "+ id_user;
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, query);
}
private void get_nhan_vien()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
DataTable v_dt = new DataTable();
v_ds.Tables.Add(v_dt);
v_us.FillDatasetWithQuery(v_ds, "select ID, DIA_CHI_THUONG_TRU, MA_NV, HO_DEM +' ' +TEN as HO_TEN from DM_NHAN_VIEN");
m_slue_nhan_vien.Properties.DataSource = v_ds.Tables[0];
m_slue_nhan_vien.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
}
private void load_data_to_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_query = "SELECT * FROM V_GD_DAT_HANG WHERE dbo.[f_get_trang_thai_da_xu_ly_don_hang_YN](ID) ='Y'";
v_us.FillDatasetWithQuery(v_ds, v_query);
m_grc_ds_don_dat_hang_can_nghiem_thu.DataSource = v_ds.Tables[0];
}
private void load_data_to_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_query = "SELECT * FROM V_GD_DAT_HANG WHERE thoi_gian_hoan_thanh is not null and id_danh_gia_tu_user_dat_hang is null and trang_thai_don_hang = N'L8A- TM đã nghiệm thu' ";
v_us.FillDatasetWithQuery(v_ds, v_query);
m_grc_ds_dh_ht_chua_danh_gia.DataSource = v_ds.Tables[0];
}
private void get_nhan_vien()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
DataTable v_dt = new DataTable();
v_ds.Tables.Add(v_dt);
v_us.FillDatasetWithQuery(v_ds, "Select ID, MA_NV, ho_dem +' '+ Ten as HO_TEN from dm_nhan_su");
m_search_lookup_edit.Properties.DataSource = v_ds.Tables[0];
m_search_lookup_edit.Properties.BestFitMode = BestFitMode.BestFitResizePopup;
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_str_query = "SELECT VKQHT.* ,DS_HOC_BONG.MUC_HONG_BONG FROM V_KET_QUA_HOC_TAP AS VKQHT, (SELECT * FROM dbo.fn_ds_hoc_bong(" + m_cbo_hoc_ky.SelectedValue.ToString() + ") ) AS DS_HOC_BONG WHERE DS_HOC_BONG.ID_SINH_VIEN = VKQHT.ID_SINH_VIEN AND VKQHT.ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString();
v_us.FillDatasetWithQuery(v_ds, v_str_query);
m_grc_bao_cao_hoc_tap_theo_sv.DataSource = v_ds.Tables[0];
}
public void load_data_to_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_query = "SELECT * FROM V_GD_DAT_HANG WHERE thoi_gian_hoan_thanh is not null and id_danh_gia_tu_user_dat_hang is null and trang_thai_don_hang = N'L8A- TM đã nghiệm thu' order by THOI_GIAN_TAO DESC";
v_us.FillDatasetWithQuery(v_ds, v_query);
m_grc_ds_dh_ht_chua_danh_gia.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, " select * from DM_BLACK_LIST where ADD_YN='N'");
m_grc_ds_backlist.DataSource = v_ds.Tables[0];
}
public void load_data_to_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_query = "SELECT * FROM V_GD_DAT_HANG WHERE dbo.[f_get_trang_thai_da_xu_ly_don_hang_YN](ID) ='Y' ORDER BY THOI_GIAN_TAO DESC";
v_us.FillDatasetWithQuery(v_ds, v_query);
m_grc_ds_don_dat_hang_can_nghiem_thu.DataSource = v_ds.Tables[0];
}
private void simpleButton1_Click(object sender, EventArgs e)
{
string user_email = "*****@*****.**";
string password = "******";
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from dm_mau_email where id =6");
string TIEU_DE = v_ds.Tables[0].Rows[0]["TIEU_DE_MAIL"].ToString();
string NOI_DUNG = v_ds.Tables[0].Rows[0]["NOI_DUNG_EMAIL"].ToString();
string GUI_CC = v_ds.Tables[0].Rows[0]["GUI_CC"].ToString();
DataRow v_dr = m_grv_ds_dh_hoan_thanh.GetDataRow(m_grv_ds_dh_hoan_thanh.FocusedRowHandle);
decimal v_id_giao_dich = CIPConvert.ToDecimal(v_dr["ID_DON_HANG"].ToString());
US_V_GD_DAT_HANG m_us = new US_V_GD_DAT_HANG(v_id_giao_dich);
TIEU_DE = TIEU_DE.Replace("MA_DON_HANG", m_us.strMA_DON_HANG);
NOI_DUNG = NOI_DUNG.Replace("MA_DON_HANG", m_us.strMA_DON_HANG);
NOI_DUNG = NOI_DUNG.Replace("USER_NHAN_VIEN", m_us.strHO_TEN_USER_DAT_HANG);
NOI_DUNG = NOI_DUNG.Replace("USER_DON_VI", m_us.strMA_DON_VI);
NOI_DUNG = NOI_DUNG.Replace("USER_DIEN_THOAI", m_us.strDIEN_THOAI);
NOI_DUNG = NOI_DUNG.Replace("USER_THOI_GIAN_DAT_HANG", m_us.datTHOI_GIAN_TAO.ToString());
NOI_DUNG = NOI_DUNG.Replace("LOAI_DICH_VU_HO_TRO", m_us.strTEN_YEU_CAU);
NOI_DUNG = NOI_DUNG.Replace("YEU_CAU_CU_THE", m_us.strNOI_DUNG_DAT_HANG);
NOI_DUNG = NOI_DUNG.Replace("THOI_GIAN_HOAN_THANH_THUC_TE", m_us.datTHOI_GIAN_HOAN_THANH.ToString());
NOI_DUNG = NOI_DUNG.Replace("LICH_SU_TRAO_DOI", "Vừa tiếp nhận.");
NOI_DUNG = NOI_DUNG.Replace("THOI_GIAN_MONG_MUON_SUA_XONG", m_us.datTHOI_DIEM_CAN_HOAN_THANH + "hoặc thời gian hoàn thành là:" + m_us.datTHOI_GIAN_HOAN_THANH);
NOI_DUNG = NOI_DUNG.Replace("PHAN_HOI_CUA_DVMC", "Quý khách vui lòng đáng giá chất lượng dịch vụ một cửa");
NOI_DUNG = NOI_DUNG.Replace("NGUOI_XU_LY_DON_HANG", m_us.strNGUOI_XU_LY);
NOI_DUNG = NOI_DUNG.Replace("NGUOI_NHAN_DAT_HANG", m_us.strNGUOI_TAO);
NOI_DUNG = NOI_DUNG.Replace("LINK_DANH_GIA_DON_HANG", "app.websomot.com:8888/chucnang/f200_kh_danh_gia_dich_vu.aspx?ma=" + m_us.strMA_DON_HANG);
US_DUNG_CHUNG v_us_1 = new US_DUNG_CHUNG();
DataSet v_ds_1 = new DataSet();
v_ds_1.Tables.Add(new DataTable());
v_us_1.FillDatasetWithQuery(v_ds_1, "select * from dm_khach_hang where id=" + m_us.dcID_USER_NV_DAT_HANG);
string to_cc = "";
to_cc = v_ds_1.Tables[0].Rows[0]["EMAIL"].ToString();
try
{
HelpUtils.send_mail("Dịch Vụ Một Cửa", user_email, password, to_cc, GUI_CC, TIEU_DE, NOI_DUNG);
}
catch (Exception v_e)
{
CSystemLog_100.ExceptionHandle(v_e);
}
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_str_query = "";
if (CIPConvert.ToDecimal(m_cbo_lop_sinh_vien.SelectedValue.ToString()) > -1)
v_str_query = "SELECT * FROM V_KET_QUA_HOC_TAP WHERE ID_LOP_SINH_VIEN=" + m_cbo_lop_sinh_vien.SelectedValue + "AND ID_HOC_KY=" + m_cbo_ky_hoc.SelectedValue;
else
v_str_query = "SELECT * FROM V_KET_QUA_HOC_TAP WHERE ID_HOC_KY=" + m_cbo_ky_hoc.SelectedValue;
v_us.FillDatasetWithQuery(v_ds,v_str_query);
m_grc_bao_cao_hoc_tap_theo_lop_sinh_vien.DataSource = v_ds.Tables[0];
}
private void update_log_admin_huy_don_hang()
{
US_DUNG_CHUNG v_us_dc = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us_dc.FillDatasetWithQuery(v_ds, "SELECT * FROM V_GD_DAT_HANG_GD_LOG_DAT_HANG WHERE [ID_DON_HANG] = " + v_us.dcID.ToString());
for(int i= 0;i< v_ds.Tables[0].Rows.Count;i++)
{
US_GD_LOG_DAT_HANG V_us = new US_GD_LOG_DAT_HANG(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i]["ID"].ToString()));
V_us.strTHAO_TAC_HET_HAN_YN = "Y";
V_us.Update();
}
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_str_query = "";
if (CIPConvert.ToDecimal(m_cbo_hoc_ky.SelectedValue.ToString()) > -1)
v_str_query = "SELECT * FROM V_DIEM_THI WHERE MA_SINH_VIEN = '" + m_txt_ma_sinh_vien.Text + "' AND ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString() ;
else
v_str_query = "SELECT * FROM V_DIEM_THI WHERE MA_SINH_VIEN = '" + m_txt_ma_sinh_vien.Text+ "'";
v_us.FillDatasetWithQuery(v_ds, v_str_query);
m_grc_bao_cao_hoc_tap_theo_sv.DataSource = v_ds.Tables[0];
}
private void update_nhom_sd()
{
string m_query = "select top 1 id from ht_nguoi_su_dung_nhom_chi_nhanh where ID_NGUOI_SU_DUNG = " + m_us.dcID;
US_DUNG_CHUNG us = new US_DUNG_CHUNG();
DataSet ds = new DataSet();
ds.Tables.Add(new DataTable());
us.FillDatasetWithQuery(ds, m_query);
US_HT_NGUOI_SU_DUNG_NHOM_CHI_NHANH m_us_nguoi_sd_nhom_cn = new US_HT_NGUOI_SU_DUNG_NHOM_CHI_NHANH(CIPConvert.ToDecimal(ds.Tables[0].Rows[0][0].ToString()));
m_us_nguoi_sd_nhom_cn.dcID_NHOM = CIPConvert.ToDecimal(m_cbo_cap_xu_ly.SelectedValue.ToString());
m_us.Update();
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_str_query;
if(CIPConvert.ToDecimal( m_cbo_muc_canh_cao.SelectedValue.ToString()) > -1)
v_str_query = "SELECT VKQHT.* ,DS_XU_LY.MUC_CANH_CAO FROM V_KET_QUA_HOC_TAP AS VKQHT, (SELECT * FROM dbo.fn_ds_xu_ly_hoc_tap(" + m_cbo_hoc_ky.SelectedValue.ToString() + ") ) AS DS_XU_LY WHERE DS_XU_LY.ID_SINH_VIEN = VKQHT.ID_SINH_VIEN AND VKQHT.ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString() + "AND DS_XU_LY.MUC_CANH_CAO = N'" + m_cbo_muc_canh_cao.Text + "'";
else
v_str_query = "SELECT VKQHT.* ,DS_XU_LY.MUC_CANH_CAO FROM V_KET_QUA_HOC_TAP AS VKQHT, (SELECT * FROM dbo.fn_ds_xu_ly_hoc_tap(" + m_cbo_hoc_ky.SelectedValue.ToString() + ") ) AS DS_XU_LY WHERE DS_XU_LY.ID_SINH_VIEN = VKQHT.ID_SINH_VIEN AND VKQHT.ID_HOC_KY = " + m_cbo_hoc_ky.SelectedValue.ToString() ;
v_us.FillDatasetWithQuery(v_ds, v_str_query);
m_grc_bao_cao_hoc_tap_theo_sv.DataSource = v_ds.Tables[0];
}
private void m_btn_remind_Click(object sender, EventArgs e)
{
string user_email = "*****@*****.**";
string password = "******";
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select * from dm_mau_email where id =10");
string TIEU_DE = v_ds.Tables[0].Rows[0]["TIEU_DE_MAIL"].ToString();
string NOI_DUNG = v_ds.Tables[0].Rows[0]["NOI_DUNG_EMAIL"].ToString();
string GUI_CC = v_ds.Tables[0].Rows[0]["GUI_CC"].ToString();
DataRow v_dr = m_grv_ds_don_hang_ht_chua_danh_gia.GetDataRow(m_grv_ds_don_hang_ht_chua_danh_gia.FocusedRowHandle);
decimal v_id_giao_dich = CIPConvert.ToDecimal(v_dr["ID"].ToString());
US_V_GD_DAT_HANG m_us = new US_V_GD_DAT_HANG(v_id_giao_dich);
TIEU_DE = TIEU_DE.Replace("MA_DON_HANG", m_us.strMA_DON_HANG);
NOI_DUNG = NOI_DUNG.Replace("MA_DON_HANG", m_us.strMA_DON_HANG);
NOI_DUNG = NOI_DUNG.Replace("USER_NHAN_VIEN", m_us.strHO_TEN_USER_DAT_HANG);
NOI_DUNG = NOI_DUNG.Replace("USER_DON_VI", m_us.strMA_DON_VI);
NOI_DUNG = NOI_DUNG.Replace("USER_DIEN_THOAI", m_us.strDIEN_THOAI);
NOI_DUNG = NOI_DUNG.Replace("USER_THOI_GIAN_DAT_HANG", m_us.datTHOI_GIAN_TAO.ToString());
NOI_DUNG = NOI_DUNG.Replace("LOAI_DICH_VU_HO_TRO", m_us.strTEN_YEU_CAU);
NOI_DUNG = NOI_DUNG.Replace("YEU_CAU_CU_THE", m_us.strNOI_DUNG_DAT_HANG);
NOI_DUNG = NOI_DUNG.Replace("THOI_GIAN_HOAN_THANH_THUC_TE", m_us.datTHOI_GIAN_HOAN_THANH.ToString());
NOI_DUNG = NOI_DUNG.Replace("LICH_SU_TRAO_DOI", "Vừa tiếp nhận.");
NOI_DUNG = NOI_DUNG.Replace("THOI_GIAN_MONG_MUON_SUA_XONG", m_us.datTHOI_DIEM_CAN_HOAN_THANH + "hoặc thời gian hoàn thành là:" + m_us.datTHOI_GIAN_HOAN_THANH);
NOI_DUNG = NOI_DUNG.Replace("PHAN_HOI_CUA_DVMC", "Quý khách vui lòng đáng giá chất lượng dịch vụ một cửa");
NOI_DUNG = NOI_DUNG.Replace("NGUOI_XU_LY_DON_HANG", m_us.strNGUOI_XU_LY);
NOI_DUNG = NOI_DUNG.Replace("NGUOI_NHAN_DAT_HANG", m_us.strNGUOI_TAO);
US_DUNG_CHUNG v_us_1 = new US_DUNG_CHUNG();
DataSet v_ds_1 = new DataSet();
v_ds_1.Tables.Add(new DataTable());
v_us_1.FillDatasetWithQuery(v_ds_1, "select * from dm_khach_hang where id=" + m_us.dcID_USER_NV_DAT_HANG);
string to_cc = "";
to_cc = v_ds_1.Tables[0].Rows[0]["EMAIL"].ToString();
// to_cc = "*****@*****.**";
try
{
Mail.sendEmail(user_email, password, to_cc, TIEU_DE, NOI_DUNG);
MessageBox.Show("Hoàn thành!");
}
catch (Exception v_e)
{
CSystemLog_301.ExceptionHandle(v_e);
}
}
private void update_log_dieu_phoi()
{
US_DUNG_CHUNG v_us_dc = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us_dc.FillDatasetWithQuery(v_ds, "SELECT * FROM V_GD_DAT_HANG_GD_LOG_DAT_HANG WHERE [ID_DON_HANG] = " + v_us.dcID.ToString());
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
US_GD_LOG_DAT_HANG V_us = new US_GD_LOG_DAT_HANG(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i]["ID"].ToString()));
V_us.strTHAO_TAC_HET_HAN_YN = "Y";
V_us.Update();
}
}
private void f120_ds_don_hang_khach_hang_Load(object sender, EventArgs e)
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "getAllOrderState");
//chbbOrderState.Properties.DataSource = (from DataRow dr in v_ds.Tables[0].Rows
// select (string)dr["TEN"]).ToList();
chbbOrderState.Properties.DataSource = v_ds.Tables[0];
chbbOrderState.Properties.DisplayMember = "TEN";
chbbOrderState.Properties.ValueMember = "ID";
chbbOrderState.CheckAll();
}
private void m_cmd_luu_Click(object sender, EventArgs e)
{
try
{
if (check_du_lieu())
{
// kiểm tra xem là update hay insert
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "SELECT ID,ID_SINH_VIEN,ID_LOP_HOC FROM V_DIEM_THI WHERE MA_SINH_VIEN = '" + m_txt_ma_so_sinh_vien.Text + "' AND ID_LOP_HOC =" + m_cbo_ma_lop_hoc.SelectedValue.ToString());
if (v_ds.Tables[0].Rows.Count == 0)
{
m_bol_isUpdate = false;
}
else
{
m_bol_isUpdate = true;
}
if (m_bol_isUpdate)
{
US_DIEM_THI v_us_diem_thi = new US_DIEM_THI(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0]["ID"].ToString()));
v_us_diem_thi.dcDIEM_QUA_TRINH = CIPConvert.ToDecimal(m_txt_diem_qua_trinh.Text);
v_us_diem_thi.dcID_SINH_VIEN = m_id_sinh_vien;
v_us_diem_thi.dcID_LOP_HOC = CIPConvert.ToDecimal(m_cbo_ma_lop_hoc.SelectedValue);
v_us_diem_thi.dcDIEM_THI = CIPConvert.ToDecimal(m_txt_diem_thi.Text);
v_us_diem_thi.strDIEM_CHU = User.GetDiemChu(v_us_diem_thi.dcDIEM_QUA_TRINH, v_us_diem_thi.dcDIEM_THI, CIPConvert.ToDecimal(CIPConvert.ToDecimal(m_txt_trong_so.Text)));
v_us_diem_thi.Update();
MessageBox.Show("Cập nhật thành công!");
load_data_2_grid();
}
else
{
US_DIEM_THI v_us_diem_thi = new US_DIEM_THI();
v_us_diem_thi.dcDIEM_QUA_TRINH = CIPConvert.ToDecimal(m_txt_diem_qua_trinh.Text);
v_us_diem_thi.dcDIEM_THI = CIPConvert.ToDecimal(m_txt_diem_thi.Text);
v_us_diem_thi.dcID_SINH_VIEN = m_id_sinh_vien;
v_us_diem_thi.dcID_LOP_HOC = CIPConvert.ToDecimal(m_cbo_ma_lop_hoc.SelectedValue);
v_us_diem_thi.strDIEM_CHU = User.GetDiemChu(v_us_diem_thi.dcDIEM_QUA_TRINH, v_us_diem_thi.dcDIEM_THI, CIPConvert.ToDecimal(m_txt_trong_so.Text));
v_us_diem_thi.Insert();
MessageBox.Show("thêm thành công!");
load_data_2_grid();
}
}
}
catch
{
MessageBox.Show("Đã xảy ra lỗi trong hệ thống!");
}
}
private void delete_ht_bo_dich_vu(GridView v_grv, decimal v_cap_sd)
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
string v_query = "SELECT hbdv.ID FROM HT_BO_DICH_VU hbdv WHERE hbdv.ID_DICH_VU =" + m_us_dich_vu.dcID.ToString() + "AND hbdv.CAP_SU_DUNG=" + v_cap_sd.ToString();
v_us.FillDatasetWithQuery(v_ds, v_query);
for (int i = 0; i < v_ds.Tables[0].Rows.Count; i++)
{
US_HT_BO_DICH_VU v_us_bo_dv = new US_HT_BO_DICH_VU(CIPConvert.ToDecimal(v_ds.Tables[0].Rows[i]["ID"].ToString()));
v_us_bo_dv.Delete();
}
}
private void m_cbo_hoc_phan_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "select TEN_HOC_PHAN from DM_hoc_phan where id=" + m_cbo_hoc_phan.SelectedValue);
m_lb_ten_hoc_phan.Text = v_ds.Tables[0].Rows[0][0].ToString();
}
catch
{
MessageBox.Show("Đã xảy ra lỗi hệ thống!");
}
}
private bool kiem_tra_du_lieu_truoc_luu()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, "SELECT ID FROM V_DM_SINH_VIEN WHERE MA_SINH_VIEN = '" + m_txt_ma_sinh_vien.Text + "'");
if (v_ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("Hãy chọn lại sinh viên! \n Không có sinh viên nào có mã số: " + m_txt_ma_sinh_vien.Text);
m_txt_ma_sinh_vien.Focus();
return(false);
}
return(true);
}
public void load_data_to_grid()
{
try
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithQuery(v_ds, " select * from V_GD_DAT_HANG_GD_LOG_DAT_HANG WHERE ID IS NOT NULL order by NGAY_LAP_THAO_TAC desc");
m_grc_ds_log_gd_dat_hang.DataSource = v_ds.Tables[0];
}
catch (Exception v_e)
{
CSystemLog_100.ExceptionHandle(v_e);
}
}
