Esempio n. 1
0
 public static DataSet UserLogin(LoginInput loginO, string currAccDbName, string IPStr)
 {
     Dictionary<string, ParamObj> dic = new Dictionary<string, ParamObj>();
     ParamObj paraO1 = new ParamObj();
     paraO1.name = "land_name";
     paraO1.size = 40;
     paraO1.type = SysDbType.VarChar;
     paraO1.value = loginO.username;
     ParamObj paraO2 = new ParamObj();
     paraO2.name = "password";
     paraO2.size = 40;
     paraO2.type = SysDbType.VarChar;
     paraO2.value = loginO.pwd;
     ParamObj paraO3 = new ParamObj();
     paraO3.name = "login_time";
     paraO3.type = SysDbType.BigInt;
     paraO3.value = System.DateTime.Now.ToUniversalTime().Ticks;
     ParamObj paraO4 = new ParamObj();
     paraO4.name = "computer_ip";
     paraO4.size = 40;
     paraO4.type = SysDbType.VarChar;
     paraO4.value = IPStr;
     ParamObj paraO5 = new ParamObj();
     paraO5.name = "computer_name";
     paraO5.size = 40;
     paraO5.type = SysDbType.NVarChar;
     paraO5.value = loginO.ComputerName;
     ParamObj paraO6 = new ParamObj();
     paraO6.name = "computer_mac";
     paraO6.size = 40;
     paraO6.type = SysDbType.VarChar;
     paraO6.value = loginO.MAC;
     ParamObj paraO7 = new ParamObj();
     paraO7.name = "login_Id";
     paraO7.size = 40;
     paraO7.type = SysDbType.VarChar;
     paraO7.value = loginO.Login_Id;
     dic.Add("land_name", paraO1);
     dic.Add("password", paraO2);
     dic.Add("login_time", paraO3);
     dic.Add("computer_ip", paraO4);
     dic.Add("computer_name", paraO5);
     dic.Add("computer_mac", paraO6);
     dic.Add("login_Id", paraO7);
     SQLObj sqlObj = new SQLObj();
     sqlObj.cmdType = System.Data.CommandType.StoredProcedure;
     sqlObj.sqlString = "ServerUserLogin";
     sqlObj.Param = dic;
     DataSet ds = DBHelper.GetDataSet("服务器端用户登录", currAccDbName, sqlObj);
     return ds;
 }
Esempio n. 2
0
 /// <summary> 登陆验证
 /// </summary>
 /// <param name="uName">用户名</param>
 /// <param name="uPwd">密码</param>
 /// <returns>返回错误信息</returns>
 public static string LoginInput(string uName, string uPwd, string MAC, string ComputerName, string Login_Id)
 {
     if (!WCFClientProxy.TestDataProxy())
     {
         return "未能建立同服务器连接";
     }
     LoginInput loginO = new LoginInput();
     loginO.username = uName;
     loginO.pwd = uPwd;
     loginO.ComputerName = ComputerName;
     loginO.MAC = MAC;
     loginO.Login_Id = Login_Id;
     loginO.acccode = GlobalStaticObj.CurrAccCode;
     string loginStr = HXCCommon.DotNetEncrypt.DESEncrypt.Encrypt(Newtonsoft.Json.JsonConvert.SerializeObject(loginO));
     loginStr = GlobalStaticObj.proxy.LoginIn(loginStr);
     string dsStr = HXCCommon.DotNetEncrypt.DESEncrypt.Decrypt(loginStr);
     RespFunStruct respO = JsonConvert.DeserializeObject<RespFunStruct>(dsStr);
     if (respO.IsSuccess == "0")
     {
         return respO.Msg;
     }
     HXCPcClient.GlobalStaticObj.gLoginDataSet = JsonConvert.DeserializeObject<DataSet>(respO.ReturnObject);
     return string.Empty;
 }
Esempio n. 3
0
        public static string UserLogin(LoginInput loginInput, string IPStr, string currAccDbName, out DataSet ds)
        {
            string errMsg = "";
            ds = new DataSet();
            #region 验证用户
            string tempUserID = BLL.DBHelper.GetSingleValue("验证用户是否存在", currAccDbName, "sys_user", "user_id", " land_name='" + loginInput.username + "' and enable_flag=1 ", "");
            if (string.IsNullOrEmpty(tempUserID))
            {
                return "登陆录号不存在或被删除";
            }
            string status = BLL.DBHelper.GetSingleValue("验证用户是否存在", currAccDbName, "sys_user", "status", " enable_flag=1 and land_name='" + loginInput.username + "' and password='******'", "");
            if (string.IsNullOrEmpty(status))
            {
                return "登录密码不正确";
            }
            if (status != DataSources.EnumStatus.Start.ToString("d"))
            {
                return "登陆录号已被停用";
            }
            #endregion

            Dictionary<string, ParamObj> dic = new Dictionary<string, ParamObj>();
            ParamObj paraO1 = new ParamObj();
            paraO1.name = "land_name";
            paraO1.size = 40;
            paraO1.type = SysDbType.VarChar;
            paraO1.value = loginInput.username;
            ParamObj paraO2 = new ParamObj();
            paraO2.name = "password";
            paraO2.size = 40;
            paraO2.type = SysDbType.VarChar;
            paraO2.value = loginInput.pwd;
            ParamObj paraO3 = new ParamObj();
            paraO3.name = "login_time";
            paraO3.type = SysDbType.BigInt;
            paraO3.value = Common.LocalDateTimeToUtcLong(GlobalStaticObj_Server.Instance.CurrentDateTime);
            ParamObj paraO4 = new ParamObj();
            paraO4.name = "computer_ip";
            paraO4.size = 40;
            paraO4.type = SysDbType.VarChar;
            paraO4.value = IPStr;
            ParamObj paraO5 = new ParamObj();
            paraO5.name = "computer_name";
            paraO5.size = 40;
            paraO5.type = SysDbType.NVarChar;
            paraO5.value = loginInput.ComputerName;
            ParamObj paraO6 = new ParamObj();
            paraO6.name = "computer_mac";
            paraO6.size = 40;
            paraO6.type = SysDbType.VarChar;
            paraO6.value = loginInput.MAC;
            ParamObj paraO7 = new ParamObj();
            paraO7.name = "login_Id";
            paraO7.size = 40;
            paraO7.type = SysDbType.VarChar;
            paraO7.value = loginInput.Login_Id;
            dic.Add("land_name", paraO1);
            dic.Add("password", paraO2);
            dic.Add("login_time", paraO3);
            dic.Add("computer_ip", paraO4);
            dic.Add("computer_name", paraO5);
            dic.Add("computer_mac", paraO6);
            dic.Add("login_Id", paraO7);
            SQLObj sqlObj = new SQLObj();
            sqlObj.cmdType = System.Data.CommandType.StoredProcedure;
            sqlObj.sqlString = "ClientUserLogin";
            sqlObj.Param = dic;
            ds = DBHelper.GetDataSet("客户端用户登录", currAccDbName, sqlObj);
            return errMsg;
        }
Esempio n. 4
0
        private void _Login(object state)
        {
            LoginInput loginO = new LoginInput();
            loginO.username = this.userName;
            loginO.pwd = this.pwd;
            GlobalStaticObj_Server.Instance.LoginIP = Utility.Tools.HardwareSerialNumber.Get_UserIP();
            string errMsg = string.Empty;
            try
            {
                DataSet ds = new DataSet();
                errMsg = BLL.ServerUser.UserLogin(loginO,
                    GlobalStaticObj_Server.DbPrefix + GlobalStaticObj_Server.CommAccCode, GlobalStaticObj_Server.Instance.LoginIP, out ds);
                if (string.IsNullOrEmpty(errMsg))
                {
                    GlobalStaticObj.gLoginDataSet = ds;
                }
            }
            catch
            {
                errMsg = "数据库连接异常!";
            }

            if (this.uiHandler != null)
            {
                this.Invoke(this.uiHandler, errMsg);
            }
        }
Esempio n. 5
0
        private void _Login(object state)
        {
            LoginInput loginO = new LoginInput();
            loginO.username = this.userName;
            loginO.pwd = this.pwd;
            GlobalStaticObj_Server.Instance.LoginIP = Utility.Tools.HardwareSerialNumber.Get_UserIP();
            GlobalStaticObj.gLoginDataSet = BLL.ServerUser.UserLogin(loginO, GlobalStaticObj_Server.DbPrefix + GlobalStaticObj_Server.CommAccCode, GlobalStaticObj_Server.Instance.LoginIP);

            if (this.uiHandler != null)
            {
                this.Invoke(this.uiHandler, "");
            }
        }