public string Login(string username, string pwd)
{
BLL_Manager_User bll = new BLL_Manager_User();
Manager_User users = new Manager_User();
bool istrue = false;
try
{
users.manager_Account = username;
users.manager_Pw = pwd;
if (bll.Login(users))
{
istrue = true;
}
else
{
istrue = false;
}
}
catch
{
istrue = false;
}
if (istrue)
{
return("true");
}
else
{
return("false");
}
}
public bool Login(Manager_User Manager_User)
{
str = "select * from E_User where manager_Account=@manager_Account and manager_Pw=@manager_Pw";
SqlParameter[] para = { new SqlParameter("@manager_Account", Manager_User.manager_Account), new SqlParameter("@manager_Pw", Manager_User.manager_Pw) };
if (sql.FillDt_para(str, para).Rows.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
public bool Login(Manager_User Manager_User)
{
return(muser.Login(Manager_User));
}
// GET api/values/5
public HttpResponseMessage Get_manager_user(int manager)
{
string json = "";
int level;
int id_user = Convert.ToInt32(Thread.CurrentPrincipal.Identity.Name);
var res = Request.CreateResponse(HttpStatusCode.OK);
MySqlConnection conn = new MySqlConnection(ConnnectData.connectionString);
conn.Open();
string sql = "";
sql = "select level from t_user where id ='" + id_user + "' ";
MySqlCommand cmd = new MySqlCommand(sql, conn);
MySqlDataAdapter adap = new MySqlDataAdapter(cmd);
DataSet ds = new DataSet();
adap.Fill(ds);
level = Convert.ToInt32(ds.Tables[0].Rows[0]["level"].ToString());
try
{
sql = " SELECT id,name,level,email" +
" from t_user t0 where (level+2<=" + level + " or " + level + "=7)";
List <Manager_User> list_user = new List <Manager_User>();
cmd = new MySqlCommand(sql, conn);
adap = new MySqlDataAdapter(cmd);
ds = new DataSet();
adap.Fill(ds);
Manager_User us = new Manager_User();
foreach (DataRow r in ds.Tables[0].Rows)
{
us = new Manager_User();
us.level_manager = level;
us.username = r["name"].ToString();
us.email = r["email"].ToString();
us.id = Convert.ToInt32(r["id"].ToString());
us.level = Convert.ToInt32(r["level"].ToString());
us.listmac = new List <string>();
us.listtime = new List <string>();
sql = " select HOUR(TIMEDIFF(leavetime, createtime)) h,MINUTE(TIMEDIFF(leavetime, createtime)) m,SECOND(TIMEDIFF(leavetime, createtime)) s " +
"from t_user_time where id_user="******" order by createtime DESC ";
if (level < 4)
{
sql += " LIMIT 20";
}
MySqlCommand cmd2 = new MySqlCommand(sql, conn);
MySqlDataAdapter adap2 = new MySqlDataAdapter(cmd2);
DataSet ds2 = new DataSet();
adap2.Fill(ds2);
long totaltime = 0;
int i = 0;
foreach (DataRow r2 in ds2.Tables[0].Rows)
{
if (i < 20)
{
us.listtime.Add(r2["h"].ToString() + ":" + r2["m"].ToString() + ":" + r2["s"].ToString());
}
totaltime += Convert.ToInt32(r2["h"].ToString()) * 3600 + Convert.ToInt32(r2["m"].ToString()) * 60 + Convert.ToInt32(r2["s"].ToString());
i++;
}
us.totaltime = ((int)(totaltime / 3600)).ToString() + ":" + ((int)(totaltime / 60)).ToString();
//-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
sql = " select DISTINCT ifnull(macadress,' ') mac from t_token where id_user = '******' LIMIT 20 ";
cmd2 = new MySqlCommand(sql, conn);
adap2 = new MySqlDataAdapter(cmd2);
ds2 = new DataSet();
adap2.Fill(ds2);
i = 0;
foreach (DataRow r2 in ds2.Tables[0].Rows)
{
if (i < 20)
{
us.listmac.Add(r2["mac"].ToString() + " ");
}
i++;
}
list_user.Add(us);
}
json = JsonConvert.SerializeObject(list_user);
res.Content = new StringContent(json.ToString(), Encoding.UTF8, "application/json");
}
catch (Exception e)
{
res = Request.CreateResponse(HttpStatusCode.BadRequest);
}
finally
{
if (conn.State == ConnectionState.Open)
{
conn.Clone();
}
}
return(res);
}
/// <summary>
/// 增加 信息插入记录
/// </summary>
/// <param name="Manager_User_in"></param>
/// <returns></returns>
public bool insert(Manager_User Manager_User_in)
{
return(dal_base.insert(Manager_User_in));
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id">id</param>
/// <returns>bool</returns>
public bool delete(Manager_User Manager_User_del)
{
return(dal_base.delete(Manager_User_del));
}
/// <summary>
/// 信息更新记录
/// </summary>
/// <param name="ll"></param>
/// <returns></returns>
public bool update(Manager_User Manager_User_up)
{
return(dal_base.update(Manager_User_up));
}
