public MemberCheckStore GetMemberCheckStore(string memberCheckStoreId) { StringBuilder builder = new StringBuilder(); builder.AppendFormat(TaskJobSqls.SELECT_MEMBER_CHECK_STORE, memberCheckStoreId); string sql = builder.ToString(); DataTable dt = DatabaseOperation.ExecuteSelectDS(sql, "T").Tables[0]; if (dt != null && dt.Rows.Count == 1) { MemberCheckStore memberCheckStore = new MemberCheckStore { checkTime = Convert.ToDateTime(dt.Rows[0]["CHECK_TIME"]), consume = dt.Rows[0]["CONSUME"].ToString(), memberId = dt.Rows[0]["MEMBER_ID"].ToString(), storeId = dt.Rows[0]["STORE_ID"].ToString(), }; return(memberCheckStore); } return(null); }
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 + "失败"); } }