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