/// <summary>
/// 根据WechatId取得卡信息
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public static List <WxUserCard> GetCardList(WxUserMast param)
{
RechargeFactory factory = new RechargeFactory();
try
{
if (param == null)
{
throw new Exception("Param is null");
}
List <WxUserCard> lstCardList = factory.GetCardList(param);
if (lstCardList == null || lstCardList.Count == 0)
{
throw new Exception("DAL.WeChat.RechargeFactory.GetCardList()==null");
}
return(lstCardList);
}
catch (Exception ex)
{
LogHelper.WriteLog(new Log()
{
message = ex.Message
}, "GetCardList");
return(null);
}
}
/// <summary>
/// 根据卡号取得卡信息
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public static CCMast GetCostCenterCode(WxUserMast param)
{
RechargeFactory factory = new RechargeFactory();
try
{
if (param == null)
{
throw new Exception("Param is null");
}
CCMast ccm = factory.GetCostCenterCode(param);
if (ccm == null)
{
throw new Exception("DAL.WeChat.RechargeFactory.GetCostCenterCode()==null");
}
return(ccm);
}
catch (Exception ex)
{
LogHelper.WriteLog(new Log()
{
message = ex.Message
}, "GetCostCenterCode");
return(null);
}
}
public Response GetCostCenterCode(string token, [FromBody] WxUserMast param)
{
Response response = new Response();
if (string.IsNullOrEmpty(token) || !token.Equals(_token))
{
response.code = "404";
response.message = "Invild token";
}
else
{
CCMast ccm = RechargeHelper.GetCostCenterCode(param);
if (ccm == null)
{
response.code = "500";
response.message = "Get data failed";
}
else
{
response.code = "200";
response.content = ccm;
}
}
return(response);
}
public Response ModifyWxUser(string token, [FromBody] WxUserMast param)
{
Response response = new Response();
if (string.IsNullOrEmpty(token) || !token.Equals(_token))
{
response.code = "404";
response.message = "Invild token";
}
else
{
int result = RechargeHelper.ModifyWxUser(param);
if (result == -1)
{
response.code = "500";
response.message = "Get data failed";
}
else
{
response.code = "200";
response.content = result;
}
}
return(response);
}
///// <summary>
///// 取得交易记录
///// </summary>
///// <param name="param"></param>
///// <returns></returns>
//public List<TransLog> GetTransLog_bak2(WxUserCard param)
//{
// string strSql = " SELECT APPNAME " +
// " , TYPE " +
// " , CARDID " +
// " , OUT_TRADE_NO " +
// " , TRANSACTION_ID " +
// " , OPENID " +
// " , ATTACH " +
// " , CAST(TOTAL_FEE AS DECIMAL) AS TOTAL_FEE " +
// " , CASH_FEE " +
// " , FEE_TYPE " +
// " , BANK_TYPE " +
// " , TIME_END " +
// " , TIME_START " +
// " , TIME_EXPIRE " +
// " , RESULT_CODE " +
// " , RETURN_CODE " +
// " , CONVERT(VARCHAR(100), CREATETIME, 120) AS CREATETIME " +
// " , CONVERT(VARCHAR(100), NOTIFYTIME, 120) AS NOTIFYTIME " +
// " FROM WXORDER " +
// " WHERE OPENID = '{0}' " +
// " AND CARDID = '{1}' " +
// " AND RETURN_CODE = 'SUCCESS' " +
// " AND NOTIFYTIME IS NOT NULL ";
// List<WxOrder> lstWxOrder = SqlServerHelper.GetEntityList<WxOrder>(SqlServerHelper.salesorderConn, string.Format(strSql, param.wechatId,
// param.cardId));
// List<TransLog> lstTlog = new List<TransLog>();
// TransLog tLog = new TransLog();
// foreach(WxOrder o in lstWxOrder)
// {
// tLog = new TransLog();
// tLog.amount = (decimal)o.total_fee / 100;
// tLog.type = "success".Equals(o.result_code.ToLower()) ? "s" : "x";
// tLog.operateDate = o.time_end;
// tLog.date = DateTimeHelper.convertDateTime(o.time_end, "yyyyMMddHHmmss", "MM-dd");
// tLog.time = DateTimeHelper.convertDateTime(o.time_end, "yyyyMMddHHmmss", "HH:mm");
// tLog.typeCSS = "#3cc51f";
// lstTlog.Add(tLog);
// }
// return lstTlog;
//}
///// <summary>
///// 取得交易记录
///// </summary>
///// <param name="param"></param>
///// <returns></returns>
//public List<TransLog> GetTransLog_bak(AdenPayUserCard param)
//{
// string strSql = " SELECT TOP 30 AMOUNT " +
// " , TYPE " +
// " , OPERATEDATE " +
// " FROM " +
// " ( SELECT AMOUNT " +
// " , 'A' AS TYPE " +
// " , CONVERT(VARCHAR(100), CREATEDATE, 120) AS OPERATEDATE " +
// " , '' AS FLOWNO " +
// " FROM ADENPAIEDRECORD " +
// " WHERE CARDNUMBER = '{0}' " +
// " UNION " +
// " SELECT REALAMT AS AMOUNT " +
// " , TYPE " +
// " , CONVERT(VARCHAR(100), OPERATEDATE, 120) AS OPERATEDATE " +
// " , FLOWNO " +
// " FROM ADENPOSRECORD " +
// " WHERE CARDNUMBER = '{0}' ) AS T " +
// " ORDER BY OPERATEDATE DESC ";
// List<TransLog> lstTLog = new List<TransLog>();
// lstTLog = SqlServerHelper.GetEntityList<TransLog>(SqlServerHelper.gladisConn, string.Format(strSql, param.cardNumber));
// foreach (TransLog tlog in lstTLog)
// {
// string[] strs = tlog.operateDate.Split(' ');
// tlog.date = strs[0].Replace("-", ".");
// tlog.time = strs[1];
// tlog.typeCSS = "S".Equals(tlog.type) ? "red" : "#3cc51f";
// }
// return lstTLog;
//}
/// <summary>
/// 根据WechatId取得绑定的卡信息
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public List <WxUserCard> GetCardList(WxUserMast param)
{
List <WxUserCard> lstCards = new List <WxUserCard>();
string strSql = " SELECT CARDID " +
" , USERCODE " +
" , USERNAME " +
" FROM WXUSERCARD " +
" WHERE WECHATID = '{0}' " +
" AND DELETETIME IS NULL " +
" ORDER BY CREATETIME DESC ";
lstCards = SqlServerHelper.GetEntityList <WxUserCard>(SqlServerHelper.salesorderConn(), string.Format(strSql, param.wechatId));
return(lstCards);
}
/// <summary>
/// 根据WeChatId取得成本中心
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public CCMast GetCostCenterCode(WxUserMast param)
{
string strSql = " SELECT COSTCENTERCODE " +
" FROM WXUSERMAST " +
" WHERE APPNAME = '{0}' " +
" AND WECHATID = '{1}' " +
" AND DELETETIME IS NULL ";
WxUserMast user = SqlServerHelper.GetEntity <WxUserMast>(SqlServerHelper.salesorderConn(), string.Format(strSql, param.appName, param.wechatId));
if (user != null)
{
CCMast cc = (new CCMastFactory()).GetCCMastInfo(user.costCenterCode);
string name = (new SalesOrder.MastDataFactory()).GetCostCenterInfo(cc.costCenterCode).costCenterName_ZH;
cc.costCenterName = string.IsNullOrWhiteSpace(name) ? cc.costCenterName : name;
return(cc);
}
return(null);
}
/// <summary>
/// 更新用户
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public static int ModifyWxUser(WxUserMast param)
{
RechargeFactory factory = new RechargeFactory();
try
{
if (param == null)
{
throw new Exception("Param is null");
}
int result = factory.ModifyWxUser(param);
return(result);
}
catch (Exception ex)
{
LogHelper.WriteLog(new Log()
{
message = ex.Message
}, "GetCostCenterCode");
return(-1);
}
}
public WxUserMast GetUserInfo(string wechatId)
{
WxUserMast userInfo = new WxUserMast();
string strSql = " SELECT APPNAME " +
" , WECHATID " +
" , COSTCENTERCODE " +
" , NICKNAME " +
" , NICKNAMEENCODE " +
" , GENDER " +
" , LANGUAGE " +
" , CITY " +
" , PROVINCE " +
" , ISTESTUSER " +
" , CONVERT(VARCHAR(100), CREATETIME, 20) AS CREATETIME " +
" FROM WXUSERMAST " +
" WHERE WECHATID = '{0}' " +
" AND DELETETIME IS NULL ";
userInfo = SqlServerHelper.GetEntity <WxUserMast>(SqlServerHelper.salesorderConn(), string.Format(strSql, wechatId));
return(userInfo);
}
public int ModifyWxUser(WxUserMast param)
{
int result = 0;
// 当前时间
string dateTimeNow = DateTimeHelper.convertDateTime(DateTime.Now.ToString());
#region Sql文定义
string strSqlSel = " SELECT COSTCENTERCODE " +
" , ISTESTUSER " +
" FROM WXUSERMAST " +
" WHERE WECHATID = '{0}' " +
" AND DELETETIME IS NULL ";
string strSqlInsert = " INSERT INTO WXUSERMAST " +
" ( APPNAME " +
" , WECHATID " +
" , COSTCENTERCODE " +
" , NICKNAME " +
" , NICKNAMEENCODE " +
" , GENDER " +
" , LANGUAGE " +
" , CITY " +
" , PROVINCE " +
" , ISTESTUSER " +
" , CREATETIME ) " +
" VALUES " +
" ( '{0}' " +
" , '{1}' " +
" , '{2}' " +
" , '{3}' " +
" , '{4}' " +
" , '{5}' " +
" , '{6}' " +
" , '{7}' " +
" , '{8}' " +
" , '{9}' " +
" , '{10}' ) ";
string strSqlUpdate = " UPDATE WXUSERMAST " +
" SET COSTCENTERCODE = '{0}' " +
" , NICKNAME = '{1}' " +
" , NICKNAMEENCODE = '{2}' " +
" , GENDER = '{3}' " +
" , LANGUAGE = '{4}' " +
" , CITY = '{5}' " +
" , PROVINCE = '{6}' " +
" WHERE WECHATID = '{7}' " +
" AND DELETETIME IS NULL ";
string strSqlDelete1 = " UPDATE WXUSERMAST " +
" SET DELETETIME = '{0}' " +
" WHERE WECHATID = '{1}' " +
" AND DELETETIME IS NULL ";
string strSqlDelete2 = " UPDATE WXUSERCARD " +
" SET DELETETIME = '{0}' " +
" WHERE WECHATID = '{1}' " +
" AND DELETETIME IS NULL ";
#endregion
// 检查用户是否存在
WxUserMast user = SqlServerHelper.GetEntity <WxUserMast>(SqlServerHelper.salesorderConn(), string.Format(strSqlSel, param.wechatId));
// 最终Sql文
StringBuilder sbSqlFinal = new StringBuilder();
// 用户昵称Base64编码
string nickNameEncode = System.Web.HttpUtility.UrlEncode(param.nickName, System.Text.Encoding.UTF8);
if (user == null)
{
// Insert Sql
sbSqlFinal.Append(string.Format(strSqlInsert, param.appName, param.wechatId, param.costCenterCode, param.nickName, nickNameEncode,
param.gender, param.language, param.city, param.province, 0, dateTimeNow));
}
else
{
/***当CostCenter不相同时删除原来的记录后插入新记录***/
if (!user.costCenterCode.Equals(param.costCenterCode))
{
// Delte Sql WxUserMast
sbSqlFinal.Append(string.Format(strSqlDelete1, dateTimeNow, param.wechatId));
// Delte Sql WxUserCard
sbSqlFinal.Append(string.Format(strSqlDelete2, dateTimeNow, param.wechatId));
// Insert Sql
sbSqlFinal.Append(string.Format(strSqlInsert, param.appName, param.wechatId, param.costCenterCode,
param.nickName, nickNameEncode, param.gender, param.language, param.city, param.province, user.isTestUser, dateTimeNow));
}
else
{
// Update Sql
sbSqlFinal.Append(string.Format(strSqlUpdate, param.costCenterCode, param.nickName, nickNameEncode,
param.gender, param.language, param.city, param.province, param.wechatId));
}
}
// 执行Sql文
result = SqlServerHelper.Execute(SqlServerHelper.salesorderConn(), sbSqlFinal.ToString());
return(result);
}
