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_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 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]; }
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 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]); }
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]; }