private void load_data_2_grid() { string v_str_key_search = ""; string v_str_ho_ten = m_txt_key_ten_qlht.Text.Trim(); string v_str_ma_lop = m_txt_key_ma_lop.Text.Trim(); string v_str_ma_truong = CIPConvert.ToStr(m_cbo_qlht_truong.SelectedValue); if (v_str_ma_truong == "ALL") { v_str_ma_truong = ""; } v_str_key_search = HelpUtils.gen_string_call_scm_get_QLHT_ws("", v_str_ho_ten, v_str_ma_truong, v_str_ma_lop, "20"); m_ds_dm_qlht_scm = new DS_DM_QLHT_SCM(); m_scm_ws = new SCMServices.SyncData(); m_ds_qlht = m_scm_ws.TOS_search_thong_tin_qlht_all_T(v_str_key_search); dataset_2_ds_qlht(); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds_dm_qlht_scm, m_fg, m_obj_trans); set_tree_on_grid(); CGridUtils.MakeSoTT((int)e_col_Number.STT, m_fg); m_fg.Redraw = true; m_fg.Focus(); }
private void load_thong_tin_qlht(string ip_str_ma_sinh_vien) { string v_str_search_key_qlht = HelpUtils.gen_string_call_scm_get_QLHT_ws(ip_str_ma_sinh_vien, "", "", "", "10"); DataSet v_ds_qlht = new DataSet(); m_ws_scm = new SCMServices.SyncData(); v_ds_qlht = m_ws_scm.TOS_search_qlht_all_T(v_str_search_key_qlht); if (v_ds_qlht.Tables[0].Rows.Count > 0) { m_us_dm_qlht.dcID = CIPConvert.ToDecimal(v_ds_qlht.Tables[0].Rows[0][DM_QLHT_SCM.ID]); m_us_dm_qlht.strTEN_THAT = CIPConvert.ToStr(v_ds_qlht.Tables[0].Rows[0][DM_QLHT_SCM.TEN_THAT]); m_us_dm_qlht.strACCOUNT = CIPConvert.ToStr(v_ds_qlht.Tables[0].Rows[0][DM_QLHT_SCM.ACCOUNT]); m_us_dm_qlht.strMA_TRUONG = CIPConvert.ToStr(v_ds_qlht.Tables[0].Rows[0][DM_QLHT_SCM.MA_TRUONG]); m_txt_qlht_ho_ten.Text = CIPConvert.ToStr(v_ds_qlht.Tables[0].Rows[0][DM_QLHT_SCM.TEN_THAT]); m_txt_qlht_acc_scm.Text = CIPConvert.ToStr(v_ds_qlht.Tables[0].Rows[0][DM_QLHT_SCM.ACCOUNT]); m_cbo_qlht_truong.SelectedValue = CIPConvert.ToStr(v_ds_qlht.Tables[0].Rows[0][DM_QLHT_SCM.MA_TRUONG]); if (m_txt_qlht_acc_scm.Text != "") { load_thong_tin_email_qlht(m_txt_qlht_acc_scm.Text); } } }
// Kiem tra cap ten/mat khau public void CheckAccount(string strUserName, string strPassWord, string strMaTruong) { //string v_str_string_call_ws_login = HelpUtils.gen_string_call_scm_login_ws(strUserName, strPassWord); SCMServices.SyncData v_ws_scm = new SCMServices.SyncData(); DataSet v_ds = new DataSet(); if (strMaTruong.ToUpper() != "TOPICA") { v_ds = v_ws_scm.TOS_check_login_scm_status(strUserName, strPassWord, strMaTruong); if (v_ds.Tables[0].Rows.Count > 0) { decimal v_dc_id_qlht = 0; v_dc_id_qlht = CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0][NGUOI_DUNG_SCM.ID]); if (v_dc_id_qlht > 0 && CIPConvert.ToStr(v_ds.Tables[0].Rows[0][NGUOI_DUNG_SCM.TRANG_THAI_NGUOI_SU_DUNG]).Equals("NORMAL")) { if (this.cbxRememberPassword.Checked) { Response.Cookies["UserName"].Expires = DateTime.Now.AddMonths(1); Response.Cookies["PassWord"].Expires = DateTime.Now.AddMonths(1); Response.Cookies["MaTruong"].Expires = DateTime.Now.AddMonths(1); Response.Cookies["UserName"].Value = strUserName; Response.Cookies["PassWord"].Value = strPassWord; Response.Cookies["MaTruong"].Value = strMaTruong; Response.Cookies["UserId"].Value = v_dc_id_qlht.ToString(); } Session["AccounLogin"] = "******"; Session["Username"] = strUserName; Session["MaTruong"] = strMaTruong; Session["UserId"] = v_dc_id_qlht; //if (CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0][NGUOI_DUNG_SCM.ID_NHOM_NGUOI_SU_DUNG]) == C_TU_DIEN_NHOM_NGUOI_DUNG.NHAP_LIEU_CVHT_HN) Response.Redirect("../Default.aspx", false); HttpContext.Current.ApplicationInstance.CompleteRequest(); } else { this.ctvLogin.IsValid = false; ctvLogin.Text = "Tài khoản của bạn đã bị khóa!"; } } else { this.ctvLogin.IsValid = false; } } else { m_us_ht_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG(); m_ds_ht_nguoi_su_dung = new DS_HT_NGUOI_SU_DUNG(); US_HT_NGUOI_SU_DUNG.LogonResult v_log_on_result = US_HT_NGUOI_SU_DUNG.LogonResult.WrongPassword_OR_Name; //m_us_ht_nguoi_su_dung.FillDataset(m_ds_ht_nguoi_su_dung, "where TEN_TRUY_CAP = '" + strUserName + "' and MAT_KHAU = '" + CIPConvert.Encoding(strPassWord) + "'"); strPassWord = CIPConvert.Encoding(strPassWord); m_us_ht_nguoi_su_dung.check_user_web(strUserName, strPassWord, ref v_log_on_result); if (v_log_on_result == US_HT_NGUOI_SU_DUNG.LogonResult.OK_Login_Succeeded) { decimal v_dc_id_qlht = 0; v_dc_id_qlht = m_us_ht_nguoi_su_dung.dcID; if (v_dc_id_qlht > 0 && m_us_ht_nguoi_su_dung.strTRANG_THAI.Equals("0")) { if (this.cbxRememberPassword.Checked) { Response.Cookies["UserName"].Expires = DateTime.Now.AddMonths(1); Response.Cookies["PassWord"].Expires = DateTime.Now.AddMonths(1); Response.Cookies["MaTruong"].Expires = DateTime.Now.AddMonths(1); Response.Cookies["UserName"].Value = strUserName; Response.Cookies["PassWord"].Value = strPassWord; Response.Cookies["MaTruong"].Value = strMaTruong; Response.Cookies["UserId"].Value = v_dc_id_qlht.ToString(); } Session["AccounLogin"] = "******"; Session["Username"] = strUserName; Session["MaTruong"] = strMaTruong; Session["UserId"] = v_dc_id_qlht; //if (CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0][NGUOI_DUNG_SCM.ID_NHOM_NGUOI_SU_DUNG]) == C_TU_DIEN_NHOM_NGUOI_DUNG.NHAP_LIEU_CVHT_HN) Response.Redirect("../Default2.aspx", false); //if (CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0][NGUOI_DUNG_SCM.ID_NHOM_NGUOI_SU_DUNG]) == C_TU_DIEN_NHOM_NGUOI_DUNG.NHAP_HO_SO_HN) // Response.Redirect("../Default2.aspx", false); //if (CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0][NGUOI_DUNG_SCM.ID_NHOM_NGUOI_SU_DUNG]) == C_TU_DIEN_NHOM_NGUOI_DUNG.NHAP_HO_SO_HN) // Response.Redirect("../UC/TongHopSoLuongCuocGoi.aspx", false); HttpContext.Current.ApplicationInstance.CompleteRequest(); } else { this.ctvLogin.IsValid = false; ctvLogin.Text = "Tài khoản của bạn đã bị khóa!"; } } else { this.ctvLogin.IsValid = false; } } }
private void load_thong_tin_qlht(string ip_str_ma_sinh_vien) { string v_str_search_key_qlht = HelpUtils.gen_string_call_scm_get_QLHT_ws(ip_str_ma_sinh_vien, "", "", "", "10"); DataSet v_ds_qlht = new DataSet(); m_ws_scm = new SCMServices.SyncData(); v_ds_qlht = m_ws_scm.TOS_search_qlht_all_T(v_str_search_key_qlht); if (v_ds_qlht.Tables[0].Rows.Count > 0) { m_us_dm_qlht.dcID = CIPConvert.ToDecimal(v_ds_qlht.Tables[0].Rows[0][DM_QLHT_SCM.ID]); m_us_dm_qlht.strTEN_THAT = CIPConvert.ToStr(v_ds_qlht.Tables[0].Rows[0][DM_QLHT_SCM.TEN_THAT]); m_us_dm_qlht.strACCOUNT = CIPConvert.ToStr(v_ds_qlht.Tables[0].Rows[0][DM_QLHT_SCM.ACCOUNT]); m_us_dm_qlht.strMA_TRUONG = CIPConvert.ToStr(v_ds_qlht.Tables[0].Rows[0][DM_QLHT_SCM.MA_TRUONG]); m_txt_qlht_ho_ten.Text = CIPConvert.ToStr(v_ds_qlht.Tables[0].Rows[0][DM_QLHT_SCM.TEN_THAT]); m_txt_qlht_acc_scm.Text = CIPConvert.ToStr(v_ds_qlht.Tables[0].Rows[0][DM_QLHT_SCM.ACCOUNT]); m_cbo_qlht_truong.SelectedValue = CIPConvert.ToStr(v_ds_qlht.Tables[0].Rows[0][DM_QLHT_SCM.MA_TRUONG]); if (m_txt_qlht_acc_scm.Text != "") load_thong_tin_email_qlht(m_txt_qlht_acc_scm.Text); } }
// Kiem tra cap ten/mat khau public void CheckAccount(string strUserName, string strPassWord, string strMaTruong) { //string v_str_string_call_ws_login = HelpUtils.gen_string_call_scm_login_ws(strUserName, strPassWord); SCMServices.SyncData v_ws_scm = new SCMServices.SyncData(); DataSet v_ds = new DataSet(); if (strMaTruong.ToUpper() != "TOPICA") { v_ds = v_ws_scm.TOS_check_login_scm_status(strUserName, strPassWord, strMaTruong); if (v_ds.Tables[0].Rows.Count > 0) { decimal v_dc_id_qlht = 0; v_dc_id_qlht = CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0][NGUOI_DUNG_SCM.ID]); if (v_dc_id_qlht > 0 && CIPConvert.ToStr(v_ds.Tables[0].Rows[0][NGUOI_DUNG_SCM.TRANG_THAI_NGUOI_SU_DUNG]).Equals("NORMAL")) { if (this.cbxRememberPassword.Checked) { Response.Cookies["UserName"].Expires = DateTime.Now.AddMonths(1); Response.Cookies["PassWord"].Expires = DateTime.Now.AddMonths(1); Response.Cookies["MaTruong"].Expires = DateTime.Now.AddMonths(1); Response.Cookies["UserName"].Value = strUserName; Response.Cookies["PassWord"].Value = strPassWord; Response.Cookies["MaTruong"].Value = strMaTruong; Response.Cookies["UserId"].Value = v_dc_id_qlht.ToString(); } Session["AccounLogin"] = "******"; Session["Username"] = strUserName; Session["MaTruong"] = strMaTruong; Session["UserId"] = v_dc_id_qlht; //if (CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0][NGUOI_DUNG_SCM.ID_NHOM_NGUOI_SU_DUNG]) == C_TU_DIEN_NHOM_NGUOI_DUNG.NHAP_LIEU_CVHT_HN) Response.Redirect("../Default.aspx", false); HttpContext.Current.ApplicationInstance.CompleteRequest(); } else { this.ctvLogin.IsValid = false; ctvLogin.Text = "Tài khoản của bạn đã bị khóa!"; } } else { this.ctvLogin.IsValid = false; } } else { m_us_ht_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG(); m_ds_ht_nguoi_su_dung = new DS_HT_NGUOI_SU_DUNG(); US_HT_NGUOI_SU_DUNG.LogonResult v_log_on_result = US_HT_NGUOI_SU_DUNG.LogonResult.WrongPassword_OR_Name; //m_us_ht_nguoi_su_dung.FillDataset(m_ds_ht_nguoi_su_dung, "where TEN_TRUY_CAP = '" + strUserName + "' and MAT_KHAU = '" + CIPConvert.Encoding(strPassWord) + "'"); strPassWord = CIPConvert.Encoding(strPassWord); m_us_ht_nguoi_su_dung.check_user_web(strUserName, strPassWord, ref v_log_on_result); if (v_log_on_result == US_HT_NGUOI_SU_DUNG.LogonResult.OK_Login_Succeeded) { decimal v_dc_id_qlht = 0; v_dc_id_qlht = m_us_ht_nguoi_su_dung.dcID; if (v_dc_id_qlht > 0 && m_us_ht_nguoi_su_dung.strTRANG_THAI.Equals("0")) { if (this.cbxRememberPassword.Checked) { Response.Cookies["UserName"].Expires = DateTime.Now.AddMonths(1); Response.Cookies["PassWord"].Expires = DateTime.Now.AddMonths(1); Response.Cookies["MaTruong"].Expires = DateTime.Now.AddMonths(1); Response.Cookies["UserName"].Value = strUserName; Response.Cookies["PassWord"].Value = strPassWord; Response.Cookies["MaTruong"].Value = strMaTruong; Response.Cookies["UserId"].Value = v_dc_id_qlht.ToString(); } Session["AccounLogin"] = "******"; Session["Username"] = strUserName; Session["MaTruong"] = strMaTruong; Session["UserId"] = v_dc_id_qlht; //if (CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0][NGUOI_DUNG_SCM.ID_NHOM_NGUOI_SU_DUNG]) == C_TU_DIEN_NHOM_NGUOI_DUNG.NHAP_LIEU_CVHT_HN) Response.Redirect("../Default2.aspx", false); //if (CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0][NGUOI_DUNG_SCM.ID_NHOM_NGUOI_SU_DUNG]) == C_TU_DIEN_NHOM_NGUOI_DUNG.NHAP_HO_SO_HN) // Response.Redirect("../Default2.aspx", false); //if (CIPConvert.ToDecimal(v_ds.Tables[0].Rows[0][NGUOI_DUNG_SCM.ID_NHOM_NGUOI_SU_DUNG]) == C_TU_DIEN_NHOM_NGUOI_DUNG.NHAP_HO_SO_HN) // Response.Redirect("../UC/TongHopSoLuongCuocGoi.aspx", false); HttpContext.Current.ApplicationInstance.CompleteRequest(); } else { this.ctvLogin.IsValid = false; ctvLogin.Text = "Tài khoản của bạn đã bị khóa!"; } } else { this.ctvLogin.IsValid = false; } } }