private decimal load_user_quyen(string ip_str_user_name) { m_us_ht_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG(); m_ds_ht_nguoi_su_dung = new DS_HT_NGUOI_SU_DUNG(); m_us_ht_nguoi_su_dung.FillDataset(m_ds_ht_nguoi_su_dung, " WHERE TEN_TRUY_CAP = N'" + ip_str_user_name + "'"); return(CIPConvert.ToDecimal(m_ds_ht_nguoi_su_dung.HT_NGUOI_SU_DUNG.Rows[0]["ID_USER_GROUP"])); }
private void load_data_2_grid() { m_ds = new DS_HT_NGUOI_SU_DUNG(); m_us.FillDataset(m_ds); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); m_fg.Redraw = true; }
private decimal get_id_user_by_username(string ip_strsusername) { US_HT_NGUOI_SU_DUNG v_us_ht_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG(); DS_HT_NGUOI_SU_DUNG v_ds_ht_nguoi_su_dung = new DS_HT_NGUOI_SU_DUNG(); v_us_ht_nguoi_su_dung.FillDataset(v_ds_ht_nguoi_su_dung, " WHERE TEN_TRUY_CAP=N'" + ip_strsusername + "'"); return(CIPConvert.ToDecimal(v_ds_ht_nguoi_su_dung.HT_NGUOI_SU_DUNG.Rows[0][HT_NGUOI_SU_DUNG.ID])); }
private void load_data_to_cbo_tai_khoan() { DS_HT_NGUOI_SU_DUNG v_ds_ht_nguoi_su_dung = new DS_HT_NGUOI_SU_DUNG(); m_us_ht_nguoi_su_dung.FillDataset(v_ds_ht_nguoi_su_dung); m_cbo_tai_khoan.DataSource = v_ds_ht_nguoi_su_dung.Tables[0]; m_cbo_tai_khoan.DisplayMember = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; m_cbo_tai_khoan.ValueMember = HT_NGUOI_SU_DUNG.ID; }
protected void Page_Load(object sender, EventArgs e) { US_HT_NGUOI_SU_DUNG v_us = new US_HT_NGUOI_SU_DUNG(); DS_HT_NGUOI_SU_DUNG v_ds = new DS_HT_NGUOI_SU_DUNG(); v_us.FillDataset(v_ds); m_cbo_bill.DataSource = v_ds.HT_NGUOI_SU_DUNG; m_cbo_bill.DataValueField = HT_NGUOI_SU_DUNG.ID; m_cbo_bill.DataTextField=HT_NGUOI_SU_DUNG.TEN; m_cbo_bill.DataBind(); }
public US_HT_NGUOI_SU_DUNG(decimal i_dbID) { pm_objDS = new DS_HT_NGUOI_SU_DUNG(); pm_strTableName = c_TableName; IMakeSelectCmd v_objMkCmd = new CMakeAndSelectCmd(pm_objDS, c_TableName); v_objMkCmd.AddCondition("ID", i_dbID, eKieuDuLieu.KieuNumber, eKieuSoSanh.Bang); SqlCommand v_cmdSQL; v_cmdSQL = v_objMkCmd.getSelectCmd(); this.FillDatasetByCommand(pm_objDS, v_cmdSQL); pm_objDR = getRowClone(pm_objDS.Tables[pm_strTableName].Rows[0]); }
private string get_ten_by_ten_truy_cap(string ip_str_ten_truy_cap) { US_HT_NGUOI_SU_DUNG v_us_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG(); DS_HT_NGUOI_SU_DUNG v_ds_ht_nguoi_su_dung = new DS_HT_NGUOI_SU_DUNG(); v_us_nguoi_su_dung.FillDataset(v_ds_ht_nguoi_su_dung, " WHERE TEN_TRUY_CAP = N'" + ip_str_ten_truy_cap + "'"); if (v_ds_ht_nguoi_su_dung.HT_NGUOI_SU_DUNG.Rows.Count > 0) { return(v_ds_ht_nguoi_su_dung.HT_NGUOI_SU_DUNG.Rows[0][HT_NGUOI_SU_DUNG.TEN].ToString()); } return(""); }
private void load_data_2_cbo_dien_thoai_vien() { US_HT_NGUOI_SU_DUNG v_us_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG(); DS_HT_NGUOI_SU_DUNG v_ds_nguoi_su_dung = new DS_HT_NGUOI_SU_DUNG(); string v_str_nhom_nguoi_dung = "1,3"; v_us_nguoi_su_dung.LoadNguoiDungByNhom(v_str_nhom_nguoi_dung, v_ds_nguoi_su_dung); m_ddl_dien_thoai_vien.Items.Add(new ListItem("-- Tất cả --", "0")); foreach (DataRow v_dr in v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG.Rows) { m_ddl_dien_thoai_vien.Items.Add(new ListItem(v_dr[HT_NGUOI_SU_DUNG.TEN_TRUY_CAP].ToString() + " - " + v_dr[HT_NGUOI_SU_DUNG.TEN].ToString(), v_dr[HT_NGUOI_SU_DUNG.ID].ToString())); } }
private void load_data_2_nguoi_xu_ly_don_hang() { US_HT_NGUOI_SU_DUNG v_us_nguoi_dung = new US_HT_NGUOI_SU_DUNG(); DS_HT_NGUOI_SU_DUNG v_ds_nguoi_dung = new DS_HT_NGUOI_SU_DUNG(); v_us_nguoi_dung.LoadNguoiDungXuLy("", v_ds_nguoi_dung); DataRow v_dr = v_ds_nguoi_dung.HT_NGUOI_SU_DUNG.NewHT_NGUOI_SU_DUNGRow(); v_dr[HT_NGUOI_SU_DUNG.ID] = 0; v_dr[HT_NGUOI_SU_DUNG.TEN_TRUY_CAP] = "- Chọn người xử lý -"; v_ds_nguoi_dung.EnforceConstraints = false; v_ds_nguoi_dung.HT_NGUOI_SU_DUNG.Rows.InsertAt(v_dr, 0); m_cbo_nguoi_xu_ly_don_hang.DataSource = v_ds_nguoi_dung.HT_NGUOI_SU_DUNG; m_cbo_nguoi_xu_ly_don_hang.DisplayMember = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; m_cbo_nguoi_xu_ly_don_hang.ValueMember = HT_NGUOI_SU_DUNG.ID; }
private void load_data_2_cbo_po_quan_ly_chinh_va_phu() { US_HT_NGUOI_SU_DUNG v_us_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG(); DS_HT_NGUOI_SU_DUNG v_ds_nguoi_su_dung = new DS_HT_NGUOI_SU_DUNG(); try { v_us_nguoi_su_dung.FillDataset(v_ds_nguoi_su_dung); // Load data to PO phụ trách chính Combobox m_cbo_po_phu_trach_chinh.DataSource = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG; m_cbo_po_phu_trach_chinh.DataValueField = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; m_cbo_po_phu_trach_chinh.DataTextField = HT_NGUOI_SU_DUNG.TEN; m_cbo_po_phu_trach_chinh.SelectedIndex = 0; m_cbo_po_phu_trach_chinh.DataBind(); DataRow v_dr_none = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG.NewHT_NGUOI_SU_DUNGRow(); v_dr_none[HT_NGUOI_SU_DUNG.ID] = "0"; v_dr_none[HT_NGUOI_SU_DUNG.TEN] = "Không có"; v_dr_none[HT_NGUOI_SU_DUNG.MAT_KHAU] = "123456"; v_dr_none[HT_NGUOI_SU_DUNG.TEN_TRUY_CAP] = "KHONG_CO"; v_dr_none[HT_NGUOI_SU_DUNG.NGAY_TAO] = CIPConvert.ToDatetime("01/01/2011"); v_dr_none[HT_NGUOI_SU_DUNG.NGUOI_TAO] = "ADMIN"; v_dr_none[HT_NGUOI_SU_DUNG.BUILT_IN_YN] = "N"; v_dr_none[HT_NGUOI_SU_DUNG.TRANG_THAI] = "0"; v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG.Rows.InsertAt(v_dr_none, 0); m_cbo_po_phu_trach_phu.DataSource = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG; m_cbo_po_phu_trach_phu.DataValueField = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; m_cbo_po_phu_trach_phu.DataTextField = HT_NGUOI_SU_DUNG.TEN; m_cbo_po_phu_trach_phu.SelectedIndex = 0; m_cbo_po_phu_trach_phu.DataBind(); } catch (Exception v_e) { throw v_e; } }
public static bool check_user_have_menu() { object v_obj_id_user_login = HttpContext.Current.Session[SESSION.UserID]; if (v_obj_id_user_login == null) return false; else { string v_str_url_without_query = get_chuc_nang_without_query(); if (v_str_url_without_query == "Default.aspx") return true; if (v_str_url_without_query == "Account/ChangePassword.aspx") return true; if (v_str_url_without_query.Contains("MessageError.aspx")) return true; if (v_str_url_without_query.Contains("ChucNang/f604_xac_nhan_cong_van.aspx")) return true; if (v_str_url_without_query.Contains("ChucNang/f560_tra_cuu_dm_vpp.aspx")) return true; if (CIPConvert.ToDecimal(v_obj_id_user_login) == -1) { return false; } else { DS_HT_NGUOI_SU_DUNG v_ds_ht_nguoi_su_dung = new DS_HT_NGUOI_SU_DUNG(); US_HT_NGUOI_SU_DUNG v_us_ht_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG(); v_us_ht_nguoi_su_dung.FillDataset(v_ds_ht_nguoi_su_dung, "where id = " + v_obj_id_user_login.ToString()); if (v_ds_ht_nguoi_su_dung.HT_NGUOI_SU_DUNG.Count < 1) return false; v_us_ht_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG(CIPConvert.ToDecimal(v_obj_id_user_login)); US_HT_USER_GROUP v_us_ht_user_group = new US_HT_USER_GROUP(v_us_ht_nguoi_su_dung.dcID_USER_GROUP); US_HT_QUYEN_GROUP v_us_ht_quyen_group = new US_HT_QUYEN_GROUP(); DS_HT_QUYEN_GROUP v_ds_ht_quyen_group = new DS_HT_QUYEN_GROUP(); v_us_ht_quyen_group.FillDataset(v_ds_ht_quyen_group, "where id_user_group = " + v_us_ht_user_group.dcID + " and id_quyen in (select id from ht_chuc_nang where url_form like N'%" + get_chuc_nang() + "%' and trang_thai_yn ='Y' and hien_thi_yn='Y')"); if (v_ds_ht_quyen_group.HT_QUYEN_GROUP.Count < 1) { v_ds_ht_quyen_group.Clear(); v_us_ht_quyen_group.FillDataset(v_ds_ht_quyen_group, "where id_user_group = " + v_us_ht_user_group.dcID + " and id_quyen in (select id from ht_chuc_nang where url_form like N'%" + get_chuc_nang_without_query() + "%' and trang_thai_yn ='Y' and hien_thi_yn='Y')"); if (v_ds_ht_quyen_group.HT_QUYEN_GROUP.Count < 1) return false; }; } } return true; }
private void load_data_2_po_phu_trach() { US_HT_NGUOI_SU_DUNG v_us_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG(); DS_HT_NGUOI_SU_DUNG v_ds_nguoi_su_dung = new DS_HT_NGUOI_SU_DUNG(); DataRow v_dr_none = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG.NewHT_NGUOI_SU_DUNGRow(); v_dr_none[HT_NGUOI_SU_DUNG.ID] = "0"; v_dr_none[HT_NGUOI_SU_DUNG.TEN] = "Tất cả"; v_dr_none[HT_NGUOI_SU_DUNG.MAT_KHAU] = "123456"; v_dr_none[HT_NGUOI_SU_DUNG.TEN_TRUY_CAP] = "All"; v_dr_none[HT_NGUOI_SU_DUNG.NGAY_TAO] = CIPConvert.ToDatetime("01/01/2011"); v_dr_none[HT_NGUOI_SU_DUNG.NGUOI_TAO] = "ADMIN"; v_dr_none[HT_NGUOI_SU_DUNG.BUILT_IN_YN] = "N"; v_dr_none[HT_NGUOI_SU_DUNG.TRANG_THAI] = "0"; v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG.Rows.InsertAt(v_dr_none, 0); v_us_nguoi_su_dung.FillDataset(v_ds_nguoi_su_dung, " ORDER BY TEN_TRUY_CAP"); m_cbo_po_lap_bang_ke.DataTextField = HT_NGUOI_SU_DUNG.TEN; m_cbo_po_lap_bang_ke.DataValueField = HT_NGUOI_SU_DUNG.ID; m_cbo_po_lap_bang_ke.DataSource = v_ds_nguoi_su_dung; m_cbo_po_lap_bang_ke.DataBind(); }
private void load_2_cbo_po_phu_trach() { try { US_HT_NGUOI_SU_DUNG v_us_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG(); DS_HT_NGUOI_SU_DUNG v_ds_nguoi_su_dung = new DS_HT_NGUOI_SU_DUNG(); // Đổ dữ liệu vào DS v_us_nguoi_su_dung.FillDataset(v_ds_nguoi_su_dung); //TReo dữ liệu vào Dropdownlist loại hợp đồng // Đây là giá trị thực m_cbo_po_phu_trach.DataValueField = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; // dây là giá trị hiển thị m_cbo_po_phu_trach.DataTextField = HT_NGUOI_SU_DUNG.TEN; m_cbo_po_phu_trach.DataSource = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG; m_cbo_po_phu_trach.DataBind(); } catch (Exception v_e) { throw v_e; } }
private void load_2_cbo_po_phu_trach() { try { US_HT_NGUOI_SU_DUNG v_us_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG(); DS_HT_NGUOI_SU_DUNG v_ds_nguoi_su_dung = new DS_HT_NGUOI_SU_DUNG(); // Đổ dữ liệu vào DS v_us_nguoi_su_dung.FillDataset(v_ds_nguoi_su_dung, " WHERE ID_USER_GROUP <> " + (int)e_user_group.GIANG_VIEN + " ORDER BY TEN_TRUY_CAP"); //TReo dữ liệu vào Dropdownlist loại hợp đồng // Đây là giá trị thực m_cbo_po_phu_trach_hop_dong.DataSource = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG; m_cbo_po_phu_trach_hop_dong.DataValueField = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; // dây là giá trị hiển thị m_cbo_po_phu_trach_hop_dong.DataTextField = HT_NGUOI_SU_DUNG.TEN; m_cbo_po_phu_trach_hop_dong.DataBind(); } catch (Exception v_e) { throw v_e; } }
private void load_data_2_cbo_po_quan_ly_chinh_va_phu() { US_HT_NGUOI_SU_DUNG v_us_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG(); DS_HT_NGUOI_SU_DUNG v_ds_nguoi_su_dung = new DS_HT_NGUOI_SU_DUNG(); try { v_us_nguoi_su_dung.FillDataset(v_ds_nguoi_su_dung, " WHERE ID_USER_GROUP <> " + LOAI_USER_QUYEN.GIANG_VIEN); // Load data to PO phụ trách chính Combobox m_cbo_po_phu_trach_chinh.DataSource = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG; m_cbo_po_phu_trach_chinh.DataValueField = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; m_cbo_po_phu_trach_chinh.DataTextField = HT_NGUOI_SU_DUNG.TEN; m_cbo_po_phu_trach_chinh.SelectedIndex = 0; m_cbo_po_phu_trach_chinh.DataBind(); DataRow v_dr_none = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG.NewHT_NGUOI_SU_DUNGRow(); v_dr_none[HT_NGUOI_SU_DUNG.ID] = "0"; v_dr_none[HT_NGUOI_SU_DUNG.TEN] = "Không có"; //v_dr_none[HT_NGUOI_SU_DUNG.MAT_KHAU] = "123456"; v_dr_none[HT_NGUOI_SU_DUNG.TEN_TRUY_CAP] = "KHONG_CO"; //v_dr_none[HT_NGUOI_SU_DUNG.NGAY_TAO] = CIPConvert.ToDatetime("01/01/2011"); //v_dr_none[HT_NGUOI_SU_DUNG.NGUOI_TAO] = "ADMIN"; //v_dr_none[HT_NGUOI_SU_DUNG.BUILT_IN_YN] = "N"; //v_dr_none[HT_NGUOI_SU_DUNG.TRANG_THAI] = "0"; v_ds_nguoi_su_dung.EnforceConstraints = false; v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG.Rows.InsertAt(v_dr_none, 0); // Cbo phụ 1 m_cbo_po_phu_trach_phu.DataSource = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG; m_cbo_po_phu_trach_phu.DataValueField = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; m_cbo_po_phu_trach_phu.DataTextField = HT_NGUOI_SU_DUNG.TEN; m_cbo_po_phu_trach_phu.SelectedIndex = 0; m_cbo_po_phu_trach_phu.DataBind(); // Cbo phụ 2 m_cbo_po_phu_trach_phu2.DataSource = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG; m_cbo_po_phu_trach_phu2.DataValueField = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; m_cbo_po_phu_trach_phu2.DataTextField = HT_NGUOI_SU_DUNG.TEN; m_cbo_po_phu_trach_phu2.SelectedIndex = 0; m_cbo_po_phu_trach_phu2.DataBind(); // Cbo phụ 3 m_cbo_po_phu_trach_phu3.DataSource = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG; m_cbo_po_phu_trach_phu3.DataValueField = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; m_cbo_po_phu_trach_phu3.DataTextField = HT_NGUOI_SU_DUNG.TEN; m_cbo_po_phu_trach_phu3.SelectedIndex = 0; m_cbo_po_phu_trach_phu3.DataBind(); // Cbo phụ 4 m_cbo_po_phu_trach_phu4.DataSource = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG; m_cbo_po_phu_trach_phu4.DataValueField = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; m_cbo_po_phu_trach_phu4.DataTextField = HT_NGUOI_SU_DUNG.TEN; m_cbo_po_phu_trach_phu4.SelectedIndex = 0; m_cbo_po_phu_trach_phu4.DataBind(); // Cbo phụ 5 m_cbo_po_phu_trach_phu5.DataSource = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG; m_cbo_po_phu_trach_phu5.DataValueField = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; m_cbo_po_phu_trach_phu5.DataTextField = HT_NGUOI_SU_DUNG.TEN; m_cbo_po_phu_trach_phu5.SelectedIndex = 0; m_cbo_po_phu_trach_phu5.DataBind(); // Cbo phụ 6 m_cbo_po_phu_trach_phu6.DataSource = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG; m_cbo_po_phu_trach_phu6.DataValueField = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; m_cbo_po_phu_trach_phu6.DataTextField = HT_NGUOI_SU_DUNG.TEN; m_cbo_po_phu_trach_phu6.SelectedIndex = 0; m_cbo_po_phu_trach_phu6.DataBind(); // Cbo phụ 7 m_cbo_po_phu_trach_phu7.DataSource = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG; m_cbo_po_phu_trach_phu7.DataValueField = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; m_cbo_po_phu_trach_phu7.DataTextField = HT_NGUOI_SU_DUNG.TEN; m_cbo_po_phu_trach_phu7.SelectedIndex = 0; m_cbo_po_phu_trach_phu7.DataBind(); // Cbo phụ 8 m_cbo_po_phu_trach_phu8.DataSource = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG; m_cbo_po_phu_trach_phu8.DataValueField = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; m_cbo_po_phu_trach_phu8.DataTextField = HT_NGUOI_SU_DUNG.TEN; m_cbo_po_phu_trach_phu8.SelectedIndex = 0; m_cbo_po_phu_trach_phu8.DataBind(); // Cbo phụ 9 m_cbo_po_phu_trach_phu9.DataSource = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG; m_cbo_po_phu_trach_phu9.DataValueField = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; m_cbo_po_phu_trach_phu9.DataTextField = HT_NGUOI_SU_DUNG.TEN; m_cbo_po_phu_trach_phu9.SelectedIndex = 0; m_cbo_po_phu_trach_phu9.DataBind(); // Cbo phụ 10 m_cbo_po_phu_trach_phu10.DataSource = v_ds_nguoi_su_dung.HT_NGUOI_SU_DUNG; m_cbo_po_phu_trach_phu10.DataValueField = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; m_cbo_po_phu_trach_phu10.DataTextField = HT_NGUOI_SU_DUNG.TEN; m_cbo_po_phu_trach_phu10.SelectedIndex = 0; m_cbo_po_phu_trach_phu10.DataBind(); } catch (Exception v_e) { throw v_e; } }
private void load_data_2_grid() { m_ds = new DS_HT_NGUOI_SU_DUNG(); if(m_txt_tim_kiem.Text.Trim().Equals("")) m_us.FillDataset(m_ds," order by ten_truy_cap"); else m_us.FillDataset(m_ds, "where ten_truy_cap like N'%" + m_txt_tim_kiem.Text + "%' order by ten_truy_cap"); m_fg.Redraw = false; CGridUtils.Dataset2C1Grid(m_ds, m_fg, m_obj_trans); m_fg.Redraw = true; }
// 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_data_2_nguoi_xu_ly_don_hang() { US_HT_NGUOI_SU_DUNG v_us_nguoi_dung = new US_HT_NGUOI_SU_DUNG(); DS_HT_NGUOI_SU_DUNG v_ds_nguoi_dung = new DS_HT_NGUOI_SU_DUNG(); v_us_nguoi_dung.LoadNguoiDungXuLy("", v_ds_nguoi_dung); DataRow v_dr = v_ds_nguoi_dung.HT_NGUOI_SU_DUNG.NewHT_NGUOI_SU_DUNGRow(); v_dr[HT_NGUOI_SU_DUNG.ID] = 0; v_dr[HT_NGUOI_SU_DUNG.TEN_TRUY_CAP] = "- Tất cả -"; v_ds_nguoi_dung.EnforceConstraints = false; v_ds_nguoi_dung.HT_NGUOI_SU_DUNG.Rows.InsertAt(v_dr, 0); m_cbo_nguoi_xu_ly.DataSource = v_ds_nguoi_dung.HT_NGUOI_SU_DUNG; m_cbo_nguoi_xu_ly.DisplayMember = HT_NGUOI_SU_DUNG.TEN_TRUY_CAP; m_cbo_nguoi_xu_ly.ValueMember = HT_NGUOI_SU_DUNG.ID; }
public US_HT_NGUOI_SU_DUNG() { pm_objDS = new DS_HT_NGUOI_SU_DUNG(); pm_strTableName = c_TableName; pm_objDR = pm_objDS.Tables[pm_strTableName].NewRow(); }
this.m_pnl_out_place_dm.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.m_grv_don_hang)).EndInit(); this.panel1.ResumeLayout(false); this.panel1.PerformLayout(); this.ResumeLayout(false); } private void insert_v_gd_don_dat_hang_dinh_muc() { // f538_TAD_DUYET_DON_HANG_DE v_fDE = new f538_TAD_DUYET_DON_HANG_DE(); // v_fDE.display(); load_data_2_grid(); } private void khong_duyet_v_gd_don_dat_hang_dinh_muc() { if (!CGridUtils.IsThere_Any_NonFixed_Row(m_grv_don_hang)) return; if (!CGridUtils.isValid_NonFixed_RowIndex(m_grv_don_hang, m_grv_don_hang.Row)) return; grid2us_object(m_us, m_grv_don_hang.Row); // f538_TAD_DUYET_DON_HANG_DE v_fDE = new f538_TAD_DUYET_DON_HANG_DE(); // v_fDE.display(m_us); US_DM_PHONG_BAN v_us_pb = new US_DM_PHONG_BAN(); DS_DM_PHONG_BAN v_ds_pb = new DS_DM_PHONG_BAN(); US_HT_NGUOI_SU_DUNG v_us_user = new US_HT_NGUOI_SU_DUNG(); DS_HT_NGUOI_SU_DUNG v_ds_user = new DS_HT_NGUOI_SU_DUNG(); v_us_pb.FillDataset(v_ds_pb, "where ID =" + m_us.dcID_PHONG_BAN); string ten_truy_cap = "nv_" + v_ds_pb.Tables[0].Rows[0]["MA_PHONG_BAN"].ToString(); v_us_user.FillDataset(v_ds_user, "Where TEN_TRUY_CAP = " + "'" + ten_truy_cap + "'"); string v_mail; if (v_ds_user.Tables[0].Rows.Count >= 0) v_mail = v_ds_user.Tables[0].Rows[0]["MAIL"].ToString(); else { v_mail = ""; DialogResult result = MessageBox.Show("Chưa có mail người gửi! \nBạn có muốn Không duyệt đơn hàng này mà không gửi mail thông báo?", "Thông báo", MessageBoxButtons.YesNo); if (result == DialogResult.Yes)
private decimal load_user_quyen(string ip_str_user_name) { m_us_ht_nguoi_su_dung = new US_HT_NGUOI_SU_DUNG(); m_ds_ht_nguoi_su_dung = new DS_HT_NGUOI_SU_DUNG(); m_us_ht_nguoi_su_dung.FillDataset(m_ds_ht_nguoi_su_dung, " WHERE TEN_TRUY_CAP = N'" + ip_str_user_name + "'"); return CIPConvert.ToDecimal(m_ds_ht_nguoi_su_dung.HT_NGUOI_SU_DUNG.Rows[0]["ID_USER_GROUP"]); }