/// <summary>
/// 上传用户信息
/// </summary>
public void updateUserInfo()
{
try
{
TaskJobDao sqlDao = new TaskJobDao();
List <AddMemberInfoParam> paramList = sqlDao.getAddMemberInfoParam();
if (paramList.Count == 0)
{
return;
}
ArrayList list = new ArrayList();
foreach (var param in paramList)
{
string st = getRemoteParam(param, "AddMemberInfo", "5");
string result = HttpHandle.PostHttps(Global.PostUrl, st, "application/json");
ReturnItem ri = JsonConvert.DeserializeObject <ReturnItem>(result);
if (ri.success)
{
StringBuilder builder = new StringBuilder();
builder.AppendFormat(ShipSqls.UPDATE_USER_IF_ADD, param.cardCode);
list.Add(builder.ToString());
}
}
DatabaseOperationWeb.ExecuteDML(list);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
/// <summary>
/// 上传积分变动信息
/// </summary>
public void updateCommit()
{
try
{
TaskJobDao sqlDao = new TaskJobDao();
ArrayList list = new ArrayList();
//处理玩偶兑换积分
List <UserPointParam> gList = sqlDao.getChange();
foreach (UserPointParam aParam in gList)
{
AddPointRecordParam param = new AddPointRecordParam
{
phone = aParam.phone,
point = aParam.point,
};
string st = getRemoteParam(param, "AddPointRecord", "5");
string result = HttpHandle.PostHttps(Global.PostUrl, st, "application/json");
ReturnItem ri = JsonConvert.DeserializeObject <ReturnItem>(result);
if (ri.success)
{
StringBuilder builder = new StringBuilder();
builder.AppendFormat(ShipSqls.UPDATE_USER_CHANGE_POINT, aParam.cardCode, aParam.totalPoint);
list.Add(builder.ToString());
}
}
DatabaseOperationWeb.ExecuteDML(list);
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
public void doWork(string ids)
{
Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "> " + "开始处理" + Global.TASK_JOB + ":" + ids);
TaskJobDao taskJobDao = new TaskJobDao();
Order order = taskJobDao.GetOrder(ids);
if (order == null || order.state != "1")
{
taskJobDao.CutOut(ids);
}
if (taskJobDao.checkOrderGoodsState(ids))
{
if (taskJobDao.Done(ids))
{
StringBuilder builder = new StringBuilder();
builder.AppendFormat(Global.SMS_CODE_URL, Global.SMS_CODE, Global.SMS_TPL, order.phone);
string url = builder.ToString();
string res = Utils.GetHttp(url);
SmsCodeRes smsCodeRes = JsonConvert.DeserializeObject <SmsCodeRes>(res);
if (smsCodeRes == null || smsCodeRes.error_code != 0)
{
Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "> " + "发送短信失败原因:" + smsCodeRes.reason);
}
}
}
else
{
taskJobDao.NotYet(ids);
}
Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "> " + "处理" + Global.TASK_JOB + ":" + ids + "完成");
}
public void doWork(string ids)
{
Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "> " + "开始处理" + Global.TASK_JOB + ":" + ids);
TaskJobDao taskJobDao = new TaskJobDao();
var qbuyList = taskJobDao.GetActiveQBuy();
foreach (ActiveQBuyItem item in qbuyList)
{
var storeConsumeList =
taskJobDao.GetMemberCheckStores(
item.storeId,
item.dateFrom.ToString("yyyyMMddHHmmss"),
item.dateTo.ToString("yyyyMMddHHmmss"),
item.minConsume,
item.consumeNum,
item.checkNum,
item.activeId);
foreach (string memberId in storeConsumeList)
{
taskJobDao.InsertQBuy(item.activeId, item.activeQBuyId, item.storeId, memberId, item.beforeStart, item.lastDays);
}
}
}
/// <summary>
/// 获取积分变动信息
/// </summary>
public void getCommit()
{
try
{
TaskJobDao sqlDao = new TaskJobDao();
string st = getRemoteParam(new Param(), "GetPointCommitList", "5");
string result = HttpHandle.PostHttps(Global.PostUrl, st, "application/json");
ReturnItem ri = JsonConvert.DeserializeObject <ReturnItem>(result);
if (ri.success)
{
if (ri.data != null)
{
for (int i = 0; i < ri.data.Count; i++)
{
if (ri.data[i].storeId == "5")
{
try
{
string userId = sqlDao.getUserIdByPhone(ri.data[i].phone);
if (userId != null)
{
int rPoint = Convert.ToInt32(ri.data[i].point);
int oldPoint = sqlDao.getMemberTotalScore(ri.data[i].phone);
int newPoint = oldPoint - rPoint;
if (newPoint < 0)
{
continue;
}
sqlDao.updateUserPoint(userId, rPoint, newPoint, oldPoint);
UpdatePointCommitParam param = new UpdatePointCommitParam
{
pointCommitId = ri.data[i].pointCommitId,
};
string st1 = getRemoteParam(param, "UpdatePointCommit", "5");
string result1 = HttpHandle.PostHttps(Global.PostUrl, st1, "application/json");
ReturnItem ri1 = JsonConvert.DeserializeObject <ReturnItem>(result1);
if (ri1.success)
{
}
else
{
Console.WriteLine("UpdatePointCommit:" + result1);
}
}
}
catch (Exception)
{
}
}
}
}
}
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
public void doWork(string ids)
{
Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "> " + "开始处理" + Global.TASK_JOB + ": " + ids);
TaskJobDao taskJobDao = new TaskJobDao();
Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "> " + "开始处理updateUserInfo");
updateUserInfo();
Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "> " + "开始处理updateCommit");
updateCommit();
Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "> " + "开始处理getCommit");
getCommit();
}
public void doWork(string ids)
{
Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "> " + "开始处理" + Global.TASK_JOB + ":" + ids);
TaskJobDao taskJobDao = new TaskJobDao();
try
{
MemberCheckStore memberCheckStore = taskJobDao.GetMemberCheckStore(ids);
if (memberCheckStore == null)
{
taskJobDao.Error(ids);
}
else
{
Member member = taskJobDao.GetMember(memberCheckStore.memberId);
Store store = taskJobDao.GetStore(memberCheckStore.storeId);
List <ActiveItem> list = taskJobDao.GetActiveItems(memberCheckStore.storeId, memberCheckStore.consume);
foreach (ActiveItem item in list)
{
switch (item.valueType)
{
case "0":
Goods goods = taskJobDao.GetGoods(item.itemValue);
if (goods == null)
{
taskJobDao.Error(ids);
}
else
{
if (taskJobDao.GoodsAdd(
goods,
store,
member.memberId,
Convert.ToInt32(item.itemNums)))
{
taskJobDao.Done(ids);
}
else
{
taskJobDao.Error(ids);
}
}
break;
case "1":
int total = Convert.ToInt32(item.itemValue) * Convert.ToInt32(item.itemNums);
if (taskJobDao.HeartAdd(
total.ToString(),
member.memberId,
member.heart,
store.storeId,
item.activeId))
{
taskJobDao.Done(ids);
}
else
{
taskJobDao.Error(ids);
}
break;
case "2":
if ((Convert.ToInt32(memberCheckStore.consume) == 0 && item.actionType == "1") || (Convert.ToInt32(memberCheckStore.consume) > 0 && item.actionType == "0"))
{
int totalLimit = Convert.ToInt32(item.itemValue) * Convert.ToInt32(item.itemNums);
if (taskJobDao.LimitAdd(
store.storeId,
member.memberId,
item.actionType,
totalLimit.ToString(),
memberCheckStore.checkTime.ToString("yyyyMMdd"),
item.activeId))
{
taskJobDao.Done(ids);
}
else
{
taskJobDao.Error(ids);
}
}
break;
default:
break;
}
}
}
Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "> " + "处理" + Global.TASK_JOB + ":" + ids + "完成");
}
catch
{
taskJobDao.Error(ids);
Console.WriteLine(DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "> " + "处理" + Global.TASK_JOB + ":" + ids + "失败");
}
}
