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 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 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 load_data_to_grv()
{
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 ((us_user.dcIDNhom == 3 && v_us.get_id_pm_dich_vu(10,us_user.dcID) != 0) ||(us_user.dcIDNhom == 5 && v_us.get_id_td_dich_vu(10, us_user.dcID) != 0))
{
if (us_user.dcIDNhom == 3)
m_grv_ht_bo_pm_td_dich_vu.OptionsView.NewItemRowPosition = NewItemRowPosition.None;
v_str_query = "SELECT * FROM V_DICH_VU_BO_PM_TD";
}
else
{
m_grv_ht_bo_pm_td_dich_vu.OptionsView.NewItemRowPosition = NewItemRowPosition.None;
if (us_user.dcIDNhom == 3)
{
v_str_query = "SELECT * FROM V_DICH_VU_BO_PM_TD WHERE ID_PM = " + us_user.dcID.ToString();
}
else
v_str_query = "SELECT * FROM V_DICH_VU_BO_PM_TD WHERE ID_TD = " + us_user.dcID.ToString();
}
v_us.FillDatasetWithQuery(v_ds, v_str_query);
m_grc_ht_bo_pm_td_dich_vu.DataSource = v_ds.Tables[0];
}
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 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 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 bool check_login()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
DataSet v_ds = new DataSet();
v_ds.Tables.Add(new DataTable());
v_us.FillDatasetLogin(v_ds, login_username.Text, usUser.GetMD5(login_password.Text), CIPConvert.ToDecimal(select_chi_nhanh.SelectedValue.ToString()));
if (v_ds.Tables[0].Rows.Count > 0)
{
DataRow v_dr = v_ds.Tables[0].Rows[0];
US_V_HT_NGUOI_SU_DUNG ht_us = new US_V_HT_NGUOI_SU_DUNG(CIPConvert.ToDecimal(v_dr["ID"].ToString()));
//us_user.dcID = ht_us.dcID;
//us_user.dcIDNhom = ht_us.dcID_NHOM;
//us_user.dcCHI_NHANH = CIPConvert.ToDecimal(select_chi_nhanh.SelectedValue.ToString());
//us_user.strTEN_TRUY_CAP = ht_us.strTEN_TRUY_CAP;
//us_user.strEMAIL = ht_us.strEMAIL;
Session["user_dcID"] = ht_us.dcID;
Session["user_dcIDNhom"] = ht_us.dcID_NHOM;
Session["user_dcCHI_NHANH"] = CIPConvert.ToDecimal(select_chi_nhanh.SelectedValue.ToString());
Session["user_strTEN_TRUY_CAP"] = ht_us.strTEN_TRUY_CAP;
Session["user_strEMAIL"] = ht_us.strEMAIL;
return(true);
}
else
{
return(false);
}
}
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 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_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 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;
}
}
}
}
}
private void f999_ht_bo_pm_td_dich_vu_de_Load(object sender, EventArgs e)
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
if (us_user.dcIDNhom == 3 && v_us.get_id_pm_dich_vu(11, us_user.dcID) == 0 || us_user.dcIDNhom == 5 && v_us.get_id_td_dich_vu(11, us_user.dcID) == 0)
{
if (m_e_form_mode == DataEntryFormMode.UpdateDataState)
{
txt_dich_vu.ReadOnly = true;
cbo_loai_dich_vu.Enabled = false;
cbo_nhom_dich_vu.Enabled = false;
m_cbox_thoi_gian_xly.Enabled = false;
m_cbox_thoi_gian_xu_ly.Enabled = false;
m_txt_diem_khoi_luong.Enabled = false;
}
m_pan_xoa.Visible = false;
m_pan_them_td.Visible = false;
grc_danh_sach_td.Enabled = false;
if (us_user.dcIDNhom == 3)
{
m_pan_them_pm.Visible = false;
grc_danh_sach_pm.Enabled = false;
}
}
}
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];
}
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 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 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 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 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];
}
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.FillDatasetVNghiepVuMonHoc(v_ds);
m_grc.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_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_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_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()
{
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_griv()
{
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");
m_grc_ht_nguoi_su_dung.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_grid()
{
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_GD_DIEU_PHOI_LAI");
m_grc_ds_dieu_phoi_lai.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.FillDatasetDanhSachSV(v_ds, CIPConvert.ToDecimal(m_cbo_hoc_ky.SelectedValue.ToString()));
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.FillDatasetWithTableName(v_ds, "V_DON_HANG_SO_DIEU_PHOI_LAI");
pivotGridControl1.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_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.FillDatasetWithTableName(v_ds, "V_TINH_HINH_DANH_GIA");
pivotGridControl1.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.FillDatasetWithTableName(v_ds, "V_DON_HANG_NGUOI_XU_LY_DICH_VU_TRANG_THAI_DON_HANG");
pivotGridControl1.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.FillDatasetWithTableName(v_ds, "V_GD_CUOC_GOI_YEU_CAU");
m_grc_cuoc_goi.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.FillDatasetWithTableName(v_ds, "V_GD_DA_NHAN_XU_LY");
m_grc_xac_nhan_don_hang.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);
}
}
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_griv()
{
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");
m_grc_ht_nguoi_su_dung.DataSource = v_ds.Tables[0];
}
private void load_data_2_grid()
{
US_DUNG_CHUNG v_us = new US_DUNG_CHUNG();
m_ds = new DataSet();
m_ds.Tables.Add(new DataTable());
v_us.FillDatasetWithTableName(m_ds, "V_TONG_QUAN");
m_grc.DataSource = m_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_grid()
{
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_DM_LOP_SINH_VIEN");
m_grc_dm_lop_sinh_vien.DataSource = v_ds.Tables[0];
load_data_2_thong_tin_chi_tiet(v_ds.Tables[0].Rows[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.FillDatasetWithTableName(v_ds, "V_DON_HANG_SO_DIEU_PHOI_LAI");
pivotGridControl1.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];
}
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];
}
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];
}
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.FillDatasetWithTableName(v_ds, "V_DM_LOAI_NGAY_CONG");
m_grc_dm_loai_ngay_cong.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();//Khai báo US
DataSet v_ds = new DataSet();
DataTable v_dt = new DataTable();
v_ds.Tables.Add(v_dt);
v_us.FillDatasetWithTableName(v_ds, "V_GD_CHUNG_CHI");
m_grc.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.FillDatasetWithTableName(v_ds, "V_DM_GIANG_VIEN");
m_grc_dm_giang_vien.DataSource = v_ds.Tables[0];
load_data_2_thong_tin_chi_tiet(v_ds.Tables[0].Rows[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.FillDatasetWithTableName(v_ds, "V_GD_CUOC_GOI_YEU_CAU");
m_grc_cuoc_goi.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.FillDatasetDanhSachSV(v_ds, CIPConvert.ToDecimal(m_cbo_hoc_ky.SelectedValue.ToString()));
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 System.Data.DataTable());
v_us.FillDatasetWithTableName(v_ds, "V_DM_KHOA");
m_grc_dm_khoa.DataSource = v_ds.Tables[0];
load_data_2_thong_tin_chi_tiet(v_ds.Tables[0].Rows[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.FillDatasetWithTableName(v_ds, "V_DM_GIANG_VIEN");
m_grc_dm_giang_vien.DataSource = v_ds.Tables[0];
load_data_2_thong_tin_chi_tiet(v_ds.Tables[0].Rows[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.FillDatasetWithTableName(v_ds, "V_DM_LOP_SINH_VIEN");
m_grc_dm_lop_sinh_vien.DataSource = v_ds.Tables[0];
load_data_2_thong_tin_chi_tiet(v_ds.Tables[0].Rows[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.FillDatasetWithTableName(v_ds, "V_USER_NAME");
v_ds.Tables[0].Rows[0].Delete();
m_grc_user_name.DataSource = v_ds.Tables[0];
load_data_2_thong_tin_chi_tiet(v_ds.Tables[0].Rows[1]);
}
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()
{
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.FillDatasetWithTableName(v_ds, "V_CAN_PM_DANH_GIA");
// v_us.FillDatasetWithQuery(v_ds, " select * from V_HT_NGUOI_SU_DUNG_NHOM_CHI_NHANH WHERE ID_NHOM = 2");
m_grc_danh_sach_can_phe_duyet_PM.DataSource = v_ds.Tables[0];
}
