/// <summary> /// 绑定用户账户信息 /// </summary> /// <param name="uInfo"></param> /// <param name="dt"></param> /// <returns></returns> private UserAccountInfo BindUserAccountInfo(UserAccountInfo uInfo, DataTable dt) { uInfo.AttributeHeadID = dt.Rows[0]["AttributeHeadID"].ToInt32(); uInfo.CustomerID = dt.Rows[0]["CustomerID"].ToInt32(); uInfo.ProtocolCustomerID = dt.Rows[0]["ProtocolCustomerID"].ToInt32(); uInfo.Accounttpe = dt.Rows[0]["Accounttpe"].ToInt32(); return uInfo; }
/// <summary> /// 根据账户名称获取账户信息 /// </summary> /// <param name="appAccount"></param> /// <param name="sqlHelper"></param> /// <returns></returns> public UserAccountInfo GetCustomerInfoByAppAccount(string appAccount, SQLHelper sqlHelper) { UserAccountInfo uInfo = new UserAccountInfo(); DataTable dt = null; if (appAccount == null || appAccount.Trim().Length == 0) { return uInfo; } const string procName = "dbo.Usp_PCustomer_V2_GetCustomerInfo"; SqlParameter[] spars = new SqlParameter[] { new SqlParameter("@appaccount",appAccount)}; try { dt = sqlHelper.ExecuteDataTable(CommandType.StoredProcedure, procName, "", spars); if (dt != null && dt.Rows.Count > 0) { uInfo = BindUserAccountInfo(uInfo, dt); } } catch (Exception ex) { } return uInfo; }
public UserAccountInfo UserAccountchange(UserAccountInfo info) { UserAccountInfo Result = new UserAccountInfo(); if (info.Accounttpe == 2) { Result.CustomerID = info.ProtocolCustomerID; Result.Accounttpe = 2; Result.AttributeHeadID = info.AttributeHeadID; Result.ProtocolCustomerID = info.ProtocolCustomerID; } if (info.Accounttpe == 1) { Result.CustomerID = info.CustomerID; Result.Accounttpe = 1; Result.AttributeHeadID = info.AttributeHeadID; Result.ProtocolCustomerID = info.ProtocolCustomerID; } //if (info.Accounttpe == 3) //{ // Result.Accounttpe = 3; // Result.CustomerID = info.AttributeHeadID; // Result.ProtocolCustomerID = info.ProtocolCustomerID; // Result.AttributeHeadID = info.AttributeHeadID; //} return Result; }
/// <summary> /// 根据accessToken获取账户信息 /// </summary> /// <param name="accessToken"></param> /// <param name="sqlHelper"></param> /// <returns></returns> public UserAccountInfo GetCustomerInfoByAccessToken(string accessToken, SQLHelper sqlHelper) { UserAccountInfo uInfo = new UserAccountInfo(); string appAcount = ""; if (ValidateAccessToken(accessToken, sqlHelper, ref appAcount)) { uInfo = GetCustomerInfoByAppAccount(appAcount, sqlHelper); uInfo = UserAccountchange(uInfo); } else { throw new Exception("验证失败-错误的令牌。"); } return uInfo; }