/// <summary>
/// 创建连接
/// </summary>
public void CreateConnecting()
{
sqlHelper = new SQLHelper();
try
{
sqlHelper.CreateConnection(ConfigHelper.ConnStr_AutoRent);
}
catch (Exception ex)
{
CloseConnecting();
}
finally
{
}
}
/// <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>
/// 根据AccessToken获取会员ID
/// </summary>
/// <param name="Access_token"></param>
/// <param name="AccountTpye"></param>
/// <param name="sql"></param>
/// <returns></returns>
//public int GetCustomerid(string Access_token, ref int AccountTpye, SQLHelper sql)
//{
// int Result = 0;
// string Commondtext = "USP_PCustomer_V2_ValidateAccessToken";
// SqlParameter[] Par =
// {
// new SqlParameter("@Accesstoken",Access_token),
// new SqlParameter("@CustomerID",SqlDbType.Int),
// new SqlParameter("@Accounttype",SqlDbType.VarChar,200),
// new SqlParameter("@ReturnMsg",SqlDbType.VarChar,200),
// new SqlParameter("@AccountName",SqlDbType.VarChar,200)
// };
// for (int i = 1; i < Par.Count(); i++)
// {
// Par[i].Direction = ParameterDirection.Output;
// }
// sql.ExecuteNonQuery(CommandType.StoredProcedure, Commondtext, Par);
// Result = ConvertHelper.ToInt32(Par[1].Value.ToString());
// AccountTpye = ConvertHelper.ToInt32(Par[2].Value.ToString());
// return Result;
//}
/// <summary>
/// 获取AccessToken获取企业ID
/// </summary>
/// <param name="Access_token"></param>
/// <param name="sql"></param>
/// <returns></returns>
public int GetPCustomerid(string Access_token, SQLHelper sql)
{
int Result = 0;
const string Commondtext = "USP_PCustomer_V2_GetPCustomerID";
SqlParameter[] Parameter =
{
new SqlParameter("@Accesstoken",Access_token),
new SqlParameter("@PCustomerID",SqlDbType.Int),
};
for (int i = 1; i < Parameter.Count(); i++)
{
Parameter[i].Direction = ParameterDirection.Output;
}
sql.ExecuteNonQuery(CommandType.StoredProcedure, Commondtext, Parameter);
Result = ConvertHelper.ToInt32(Parameter[Parameter.Length - 1].Value);
return Result;
}
/// <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 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;
}
public void Dispose()
{
if (sqlHelper != null)
{
if (sqlHelper != null)
sqlHelper.Dispose();
sqlHelper = null;
}
}
/// <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;
}
}