/// <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 + "失败"); } }