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;
}
}
}
