/// <summary> /// 创建数据库连接 /// </summary> //private static A_connectTodata m_dataBase = new N_connectTodata(); //private static readonly object m_locker01 = new object(); /// <summary> /// 查询表,用户名,和密码,返回登陆是否成功 /// </summary> /// <param name="_sendback"></param> public static void fns_canLoad(string _name, string _pass, string _macID, I_sendBackClient _sendback) { //lock (m_locker01) //{ string t_name = _name; string t_pass = _pass; I_sendBackClient t_send = _sendback; //查询数据库 string t_cmd; Task <string> t_getCmd = new Task <string>(() => { return(S_makeCmd.fns_readCmd2("xian_user_1", "studentID", t_name, "password", _pass)); }); t_getCmd.Start(); t_cmd = t_getCmd.Result; //Console.WriteLine("cmd:" + t_cmd); //反馈结果 N_msg_canLoad t_canload = null; //检查数据库中有没有账号信息 if (S_sql.M_instance.fn_read(t_cmd)) { //这里还差限制一个账号只能登陆一次 I_checkIsLoaded t_checkIsLoaded = S_sql.M_instance; if (!t_checkIsLoaded.fni_check(t_name)) { //没有发现登陆信息 if (t_checkIsLoaded.fni_addIn(_macID, t_name)) { //加入登陆队列成功 t_canload = new N_msg_canLoad(true); } else { t_canload = new N_msg_canLoad(false); } } else //登陆失败 { t_canload = new N_msg_canLoad(false); } //t_canload = new N_msg_canLoad(true); } else { t_canload = new N_msg_canLoad(false); } if (t_canload != null) { if (t_send != null) { t_send.fn_sendback(JsonMapper.ToJson(t_canload)); } } //} }
//private static readonly object m_lock01 = new object(); /// <summary> /// 用户登录验证 /// </summary> /// <param name="_obj">json数据</param> /// <param name="_sendback"></param> public static void fns_load(string _obj, I_sendBackClient _sendback) { //Console.WriteLine("user loading..."); //lock (m_lock01) //{ I_sendBackClient t_send = _sendback; N_msg_userload t_user = JsonMapper.ToObject <N_msg_userload>(_obj); if (t_user == null) { N_msg_canLoad t_canload = new N_msg_canLoad(false); t_send.fn_sendback(JsonMapper.ToJson(t_canload)); } else { //去数据库查找相应的用户名和密码信息 new Task(() => { S_useMysql.fns_canLoad(t_user.m_username, t_user.m_password, t_user.m_machineID, t_send); }).Start(); Console.WriteLine("user id= " + t_user.m_username); } //} }