private bool isExist_SSO(string CustomerName, double ID)
{
DataTable d = _userDAL.GetT_User_Dynamic(" UserName=N'" + CustomerName + "' and UserID<>" + ID.ToString()).Tables[0];
if (d.Rows.Count == 0)
{
return(false);
}
else
{
return(true);
}
}
private void BindComboxNguoiNhan(int _MaNhom)
{
DataTable _dt = new DataTable();
DataTable _dtmanhom = new DataTable();
HPCBusinessLogic.AnPhamDAL dal = new AnPhamDAL();
string _sqlselect = string.Empty;
string _where = string.Empty;
if (_MaNhom > 0)
{
_sqlselect = "select Ma_Nguoidung from T_Nguoidung_Nhom where Ma_Nhom=" + _MaNhom;
_dtmanhom = ulti.ExecSqlDataSet(_sqlselect).Tables[0];
string _ma_nguoidung = string.Empty;
for (int i = 0; i < _dtmanhom.Rows.Count; i++)
{
if (i == 0)
{
_ma_nguoidung = _dtmanhom.Rows[i][0].ToString();
}
else
{
_ma_nguoidung += "," + _dtmanhom.Rows[i][0].ToString();
}
}
_where = " IsDeleted = 0 and UserID in (" + _ma_nguoidung + ")";
_dt = _NguoidungDAL.GetT_User_Dynamic(_where).Tables[0];
cbo_NguoiNhan.Items.Add(new ListItem("--Chọn người nhận-- ", "0", true));
cbo_NguoiNhan.DataSource = _dt;
cbo_NguoiNhan.DataTextField = "UserFullName";
cbo_NguoiNhan.DataValueField = "UserID";
cbo_NguoiNhan.DataBind();
}
else
{
_where = " IsDeleted = 0 ";
_dt = _NguoidungDAL.GetT_User_Dynamic(_where).Tables[0];
cbo_NguoiNhan.Items.Add(new ListItem("--Chọn người nhận-- ", "0", true));
cbo_NguoiNhan.DataSource = _dt;
cbo_NguoiNhan.DataTextField = "UserFullName";
cbo_NguoiNhan.DataValueField = "UserID";
cbo_NguoiNhan.DataBind();
}
}
public void BinddDropDownList(double maphong)
{
DataTable _dt = new DataTable();
string _where = string.Empty;
if (maphong > 0)
{
_where = " IsDeleted = 0 and ProvinceID=" + maphong;
}
else
{
_where = " IsDeleted = 0";
}
_dt = _userDAL.GetT_User_Dynamic(_where).Tables[0];
cbo_nguoinhan.DataSource = _dt;
cbo_nguoinhan.DataTextField = "UserFullName";
cbo_nguoinhan.DataValueField = "UserID";
cbo_nguoinhan.DataBind();
cbo_nguoinhan.Items.Insert(0, "---All---");
}
public string _GetWhereThuchienCV()
{
DataTable _dt = new DataTable();
string _where = string.Empty;
string phong = string.Empty;
string _sql = " IsDeleted = 0 and ProvinceID<>0 and UserID=" + _user.UserID;
_dt = _NguoidungDAL.GetT_User_Dynamic(_sql).Tables[0];
if (_dt != null && _dt.Rows.Count > 0)
{
phong = _dt.Rows[0]["ProvinceID"].ToString();
}
if (phong != string.Empty)
{
_where = " Status=0 and (NguoiNhan = " + _user.UserID.ToString() + " or NguoiNhan =0) and (Phong_ID=0 or Phong_ID =" + _dt.Rows[0]["ProvinceID"].ToString() + ") and NguoiGiaoViec<>" + _user.UserID;
}
else
{
_where = " Status=0 and (NguoiNhan = " + _user.UserID.ToString() + " or NguoiNhan =0) and Phong_ID=0 and NguoiGiaoViec<>" + _user.UserID;
}
return(_where);
}
