/// <summary> /// 分页通用方法 /// </summary> /// <param name="input"></param> /// <param name="sql"></param> /// <returns></returns> public PaginationResponse ProcessPagination(PaginationRequest input, SQLHelper sql) { const string CmdText = "Usp_PCustomer_V2_Pagination"; PaginationResponse Response = null; SqlParameter[] Parameter = PrepareParameters(input); try { DataTable dt = sql.ExecuteDataTable(CommandType.StoredProcedure, CmdText, "", Parameter); Response = new PaginationResponse(); Response.dt = dt; Response.TotalPage = ConvertHelper.ToInt32(Parameter[Parameter.Length - 1].Value.ToString()); Response.TotalRecord = ConvertHelper.ToInt32(Parameter[Parameter.Length - 2].Value.ToString()); return Response; } catch (Exception ex) { sql.CloseConnection(); } return Response; }
/// <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; }
/// <summary> /// 验证accessToken是否合法,返回账户信息 /// </summary> /// <param name="accessToken"></param> /// <param name="sqlHelper"></param> /// <returns></returns> public bool ValidateAccessToken(string accessToken, SQLHelper sqlHelper, ref string appAcount) { bool result = false; string accessTokenCode = ConvertAccessTokenCode(accessToken); const string procName = "dbo.Usp_PCustomer_V2_GetUserInfoByAccesstoken"; SqlParameter[] spars = new SqlParameter[] { new SqlParameter("@Accesstoken",accessToken) ,new SqlParameter("@AccesstokenCode",accessTokenCode)}; try { DataTable dt = sqlHelper.ExecuteDataTable(CommandType.StoredProcedure, procName, "", spars); if (dt != null && dt.Rows.Count > 0) { appAcount = dt.Rows[0]["app_account"].ToString(); if (appAcount.Trim().Length > 0) { result = true; } } } catch (Exception ex) { throw ex; } return result; }
/// <summary> /// 查询订车人账号id /// </summary> /// <param name="Customerid"></param> /// <param name="sql"></param> /// <returns></returns> public int Getstaffid(int Customerid, SQLHelper sql) { DataTable dt = new DataTable(); string comondtxt = string.Format(@"SELECT PID FROM TB_PCustomerAssigner WHERE CustomerID={0}", Customerid); dt = sql.ExecuteDataTable(CommandType.Text, comondtxt, "", null); if (dt.Rows.Count > 0) { return dt.Rows[0][0].ToInt32(); } else { return 0; } }