/// <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;
}
}
