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