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