private WxUserCard CheckBind(string wechatid, string cardids)
{
string strSql = " SELECT CARDID " +
" FROM WXUSERCARD " +
" WHERE WECHATID = '{0}' " +
" AND CARDID in ('{1}') " +
" AND DELETETIME IS NULL ";
WxUserCard card = SqlServerHelper.GetEntity <WxUserCard>(SqlServerHelper.salesorderConn(),
string.Format(strSql, wechatid, cardids));
return(card);
}
/// <summary>
/// 根据CardId取得Card相关信息
/// </summary>
/// <param name="CardInfoParam"></param>
/// <param name="sqlType"></param>
/// <returns></returns>
public CardInfo GetCardInfo(CardInfoParam param)
{
//if (string.IsNullOrWhiteSpace(param.cardkey)) return null;
//CCMastFactory ccmf = new CCMastFactory();
//// Table CCMast
//CCMast ccm = ccmf.GetCCMastInfo(param.costCenterCode);
//// Table SqlMast
//SingleField ccObj = new SingleField();
//ccObj.code = param.costCenterCode;
//List<SingleField> lstCcObj = new List<SingleField>();
//lstCcObj.Add(ccObj);
//SqlMast sm = ccmf.GetSqlMastInfo(lstCcObj, "GetPOSUsers")[0];
//// Sql Connection
//string strConn = string.Format(string.Format(SqlServerHelper.customerAllConn, ccm.posIp, ccm.posDBName, ccm.posDBUserName
// , ccm.posDBPassword));
//// Sql文
//string strSql = string.Format(sm.sqlCommand, param.cardkey);
////strConn = "Data Source=192.168.0.97,1433;Initial Catalog=DWPOS;User ID=sa;Password=gladis0083;Persist Security Info=True;Connection Timeout=10";
//// 取得卡信息
//List<CardInfo> cardObjs = SqlServerHelper.GetEntityList<CardInfo>(strConn, strSql);
List <CardInfo> cardObjs = GetList <CardInfo>(param.costCenterCode, param.cardkey, "GetPOSUsers");
if (!cardObjs.Any())
{
return(null);
}
//检查用户卡是否已绑定
CardInfo cardObj = cardObjs.FirstOrDefault();
WxUserCard card = CheckBind(param.wechatId, string.Join("','", cardObjs.Select(q => q.oldCardId)));
cardObj.userCode = string.IsNullOrWhiteSpace(cardObj.userCode)? cardObj.cardCode: cardObj.userCode;
if (card == null)
{
return(cardObj);
}
//更改已绑定的cardId
cardObj.cardId = card.cardId;
cardObj.isBind = true;
return(cardObj);
}