/// <summary> /// 保存要发送的营收信息 /// </summary> /// <param name="phone"></param> /// <returns></returns> public bool SaveRevenueMsg(Business_WeChatPush_Information weChatPush, Business_WeChatPushDetail_Information weChatPushDetail) { using (SqlSugar.SqlSugarClient _dbMsSql = SugarDao.SugarDao_MsSql.GetInstance()) { bool result = false; try { _dbMsSql.BeginTran(); result = _dbMsSql.Insert <Business_WeChatPush_Information>(weChatPush, false) != DBNull.Value; if (result) { //短信接收者 result = _dbMsSql.Insert <Business_WeChatPushDetail_Information>(weChatPushDetail, false) != DBNull.Value; } _dbMsSql.CommitTran(); } catch (Exception ex) { Common.LogHelper.LogHelper.WriteLog(ex.Message); _dbMsSql.RollbackTran(); } finally { } return(result); } }
/// <summary> /// 给阅读消息历史并且没有答过题的人重新推送习题 /// </summary> /// <param name="businessPersonnelVguid"></param> /// <param name="wechatMainVguid"></param> /// <returns></returns> public bool ReWechatPushExercise(string businessPersonnelVguid, string wechatMainVguid) { Guid mainVguid = Guid.Parse(wechatMainVguid); Guid personnelVguid = Guid.Parse(businessPersonnelVguid); bool result = false; using (SqlSugarClient db = SugarDao_MsSql.GetInstance()) { try { db.BeginTran(); var wechatMainModel = db.Queryable <Business_WeChatPush_Information>().Where(i => i.VGUID == mainVguid).SingleOrDefault(); var currentUser = db.Queryable <Business_Personnel_Information>().Where(i => i.Vguid == personnelVguid).Select(i => i.UserID).SingleOrDefault(); DateTime?dateTime = null; var wechatMain = new Business_WeChatPush_Information() { PushType = 1, Title = wechatMainModel.Title, MessageType = 4, Timed = false, TimedSendTime = null, Important = wechatMainModel.PeriodOfValidity == null, PeriodOfValidity = wechatMainModel.PeriodOfValidity == null ? dateTime : DateTime.Now.AddMonths(1), Message = "从消息历史获取", PushPeople = wechatMainModel.PushPeople, Status = 3, CreatedDate = DateTime.Now, CreatedUser = wechatMainModel.CreatedUser, VGUID = Guid.NewGuid(), CoverImg = wechatMainModel.CoverImg, CoverDescption = wechatMainModel.CoverDescption, ExercisesVGUID = wechatMainModel.ExercisesVGUID, History = "0", Department_VGUID = Guid.Empty }; var wechatDetail = new Business_WeChatPushDetail_Information() { Type = "1", PushObject = currentUser, CreatedUser = wechatMainModel.CreatedUser, CreatedDate = DateTime.Now, Vguid = Guid.NewGuid(), Business_WeChatPushVguid = wechatMain.VGUID, ISRead = "0", }; string logdata = Extend.ModelToJson(wechatMain); _ll.SaveLog(10, 34, currentUser, "从消息历史获取习题", logdata); db.Insert(wechatDetail, false); db.Insert(wechatMain, false); db.CommitTran(); result = true; } catch (Exception ex) { db.RollbackTran(); LogHelper.WriteLog(ex.ToString()); } } return(result); }
/// <summary> /// 保存 /// </summary> /// <param name="weChatMain"></param> /// <returns></returns> public PushAPIresult SavePushApi(Business_WeChatPush_Information weChatMain, string userid) { using (SqlSugarClient _dbMsSql = SugarDao_MsSql.GetInstance()) { PushAPIresult PushAPIresult = new PushAPIresult(); var result = false; try { _dbMsSql.BeginTran(); weChatMain.VGUID = Guid.NewGuid(); weChatMain.CreatedDate = DateTime.Now; weChatMain.CreatedUser = "******"; result = _dbMsSql.Insert <Business_WeChatPush_Information>(weChatMain, false) != DBNull.Value;//保存微信推送信息表 PushAPIresult.ErrorMessage = "ok"; PushAPIresult.Succeed = result.ToString(); Business_WeChatPushDetail_Information BusinessWeChatPushDetailInformation = new Business_WeChatPushDetail_Information(); BusinessWeChatPushDetailInformation.Type = "1"; BusinessWeChatPushDetailInformation.PushObject = userid; BusinessWeChatPushDetailInformation.CreatedDate = DateTime.Now; BusinessWeChatPushDetailInformation.CreatedUser = "******"; BusinessWeChatPushDetailInformation.Vguid = Guid.NewGuid(); BusinessWeChatPushDetailInformation.Business_WeChatPushVguid = weChatMain.VGUID; _dbMsSql.Insert <Business_WeChatPushDetail_Information>(BusinessWeChatPushDetailInformation, false);//保存微信推送详细信息表 _dbMsSql.CommitTran(); } catch (Exception ex) { LogHelper.WriteLog(ex.ToString() + ex.StackTrace); PushAPIresult.ErrorMessage = ex.ToString() + "\r\n" + ex.Source + "\r\n" + ex.StackTrace; PushAPIresult.Succeed = "false"; _dbMsSql.RollbackTran(); } return(PushAPIresult); } }
/// <summary> /// 保存要发送的营收信息 /// </summary> /// <param name="paymentModel"></param> /// <param name="userID"></param> /// <returns></returns> public bool SaveRevenueMsg(API_PaymentMonthly paymentModel, string userID) { bool isZero = false; bool result = false; U_Revenue revenue = new U_Revenue(); var revenueQueryExceptionReply = _cs.GetConfigList()[12].ConfigValue; if (paymentModel == null) { revenue.HistoricalArrears = "0"; revenue.TheBalance = "0"; revenue.AmountDue = "0"; revenue.CurrentPayment = "0"; revenue.CurrentAccountBalance = "0"; isZero = true; } else if (paymentModel.DebtAmount == 0 && paymentModel.DueAmount == 0 && paymentModel.PaidAmount == 0) { isZero = true; } else { //if (paymentModel.DebtAmount > 0)//正值(欠款) //{ //revenue.TheBalance = (paymentModel.DebtAmount * -1).ToString("F2"); //revenue.HistoricalArrears = (paymentModel.DebtAmount * -1) >= 0 ? "0" : paymentModel.DebtAmount.ToString("F2"); ////} ////else//负值(结余) ////{ //// revenue.HistoricalArrears = (-paymentModel.DebtAmount).ToString("##.##"); //// revenue.TheBalance = paymentModel.DebtAmount.ToString("##.##"); ////} //revenue.AmountDue = paymentModel.DueAmount.ToString("F2"); //revenue.CurrentPayment = paymentModel.PaidAmount.ToString("F2"); //revenue.CurrentAccountBalance = (paymentModel.PaidAmount - paymentModel.DueAmount + (paymentModel.DebtAmount * -1)).ToString("F2"); revenue.TheBalance = paymentModel.DebtAmount.ToString("F2"); revenue.HistoricalArrears = paymentModel.DebtAmount >= 0 ? "0" : paymentModel.DebtAmount.ToString("F2"); //} //else//负值(结余) //{ // revenue.HistoricalArrears = (-paymentModel.DebtAmount).ToString("##.##"); // revenue.TheBalance = paymentModel.DebtAmount.ToString("##.##"); //} revenue.AmountDue = paymentModel.DueAmount.ToString("F2"); revenue.CurrentPayment = paymentModel.PaidAmount.ToString("F2"); revenue.CurrentAccountBalance = (paymentModel.PaidAmount - paymentModel.DueAmount + paymentModel.DebtAmount).ToString("F2"); } string isSmsPush = _ss.GetIsSmsPush(); string isWeChatPush = _ss.GetIsWeChatPush(); string isRevenuePush = _ss.GetIsRevenuePush(); string weChatRevenueTemp = ConfigSugar.GetAppString("WeChatRevenueTemp");//获取微信发送营收数据模板 //{"HistoricalArrears":"0","TheBalance":"0","AmountDue":"0","CurrentPayment":"0","CurrentAccountBalance":"0"} //只通过短信发送营收信息 if (isSmsPush == "1") { U_RevenueMonth revenueMonth = new U_RevenueMonth(); revenueMonth.AmountDue = revenue.AmountDue; revenueMonth.CurrentAccountBalance = revenue.CurrentAccountBalance; revenueMonth.CurrentPayment = revenue.CurrentPayment; revenueMonth.HistoricalArrears = revenue.HistoricalArrears; revenueMonth.TheBalance = revenue.TheBalance; revenueMonth.Month = DateTime.Now.Month.ToString(); Business_WeChatPush_Information weChatPush = new Business_WeChatPush_Information(); weChatPush.PushType = 2; weChatPush.Title = "营收短信"; weChatPush.MessageType = 8; weChatPush.Timed = false; weChatPush.TimedSendTime = null; weChatPush.Important = false; weChatPush.Message = Common.JsonHelper.ModelToJson <U_RevenueMonth>(revenueMonth); weChatPush.PeriodOfValidity = null; weChatPush.PushDate = DateTime.Now; weChatPush.Status = 3; weChatPush.CreatedDate = DateTime.Now; weChatPush.ChangeDate = DateTime.Now; weChatPush.VGUID = Guid.NewGuid(); //推送接收者 Business_WeChatPushDetail_Information weChatPushDetail = new Business_WeChatPushDetail_Information(); weChatPushDetail.PushObject = userID; weChatPushDetail.Vguid = Guid.NewGuid(); weChatPushDetail.CreatedDate = DateTime.Now; weChatPushDetail.ChangeDate = DateTime.Now; weChatPushDetail.Type = "短信营收"; weChatPushDetail.Business_WeChatPushVguid = weChatPush.VGUID; if (!isZero) { result = _ss.SaveRevenueMsg(weChatPush, weChatPushDetail); } } if (isWeChatPush == "1")//只通过微信发送营收信息 { Business_WeChatPush_Information weChatPush = new Business_WeChatPush_Information(); weChatPush.PushType = 1; weChatPush.Title = "营收微信"; weChatPush.MessageType = 1; weChatPush.Timed = false; weChatPush.TimedSendTime = null; weChatPush.Important = false; weChatPush.Message = isZero ? revenueQueryExceptionReply : string.Format(weChatRevenueTemp, revenue.HistoricalArrears, revenue.TheBalance, revenue.AmountDue, revenue.CurrentPayment, revenue.CurrentAccountBalance, DateTime.Now.Month); weChatPush.PeriodOfValidity = null; weChatPush.PushDate = null; weChatPush.Status = 3; weChatPush.CreatedDate = DateTime.Now; weChatPush.ChangeDate = DateTime.Now; weChatPush.VGUID = Guid.NewGuid(); //推送接收者 Business_WeChatPushDetail_Information weChatPushDetail = new Business_WeChatPushDetail_Information(); weChatPushDetail.PushObject = userID; weChatPushDetail.Vguid = Guid.NewGuid(); weChatPushDetail.CreatedDate = DateTime.Now; weChatPushDetail.ChangeDate = DateTime.Now; weChatPushDetail.Type = "微信营收"; weChatPushDetail.Business_WeChatPushVguid = weChatPush.VGUID; result = _ss.SaveRevenueMsg(weChatPush, weChatPushDetail); } if (isRevenuePush == "1")//只通过营收发送营收信息 { Business_WeChatPush_Information weChatPush = new Business_WeChatPush_Information(); weChatPush.PushType = 1; weChatPush.Title = "营收信息"; weChatPush.MessageType = 11; weChatPush.Timed = false; weChatPush.TimedSendTime = null; weChatPush.RevenueType = 2; DateTime now = DateTime.Now; //当前时间 DateTime d1 = new DateTime(now.Year, now.Month, 1); //当前月的第一天 DateTime d2 = d1.AddMonths(1).AddDays(-1); //当前月的最后一天 weChatPush.PeriodOfValidity = d2; weChatPush.CoverDescption = "个人营收账单明细"; weChatPush.CoverImg = "/_img/微信图片.jpg"; weChatPush.PushDate = DateTime.Now; weChatPush.Status = 3; weChatPush.CreatedDate = DateTime.Now; weChatPush.ChangeDate = DateTime.Now; weChatPush.VGUID = Guid.NewGuid(); //推送接收者 Business_WeChatPushDetail_Information weChatPushDetail = new Business_WeChatPushDetail_Information(); weChatPushDetail.PushObject = userID; weChatPushDetail.Vguid = Guid.NewGuid(); weChatPushDetail.CreatedDate = DateTime.Now; weChatPushDetail.ChangeDate = DateTime.Now; weChatPushDetail.Type = "营收发送"; weChatPushDetail.Business_WeChatPushVguid = weChatPush.VGUID; result = _ss.SaveRevenueMsg(weChatPush, weChatPushDetail); } //else if (isWeChatPush == "1" && isSmsPush == "1") //{ // Business_WeChatPush_Information weChatPush = new Business_WeChatPush_Information(); // weChatPush.PushType = 1; // weChatPush.Title = "营收微信"; // weChatPush.MessageType = 1; // weChatPush.Timed = false; // weChatPush.TimedSendTime = null; // weChatPush.Important = false; // weChatPush.Message = isZero ? revenueQueryExceptionReply : string.Format(weChatRevenueTemp, revenue.HistoricalArrears, revenue.TheBalance, revenue.AmountDue, revenue.CurrentPayment, revenue.CurrentAccountBalance, DateTime.Now.Month); // weChatPush.PeriodOfValidity = null; // weChatPush.PushDate = null; // weChatPush.Status = 3; // weChatPush.CreatedDate = DateTime.Now; // weChatPush.ChangeDate = DateTime.Now; // weChatPush.VGUID = Guid.NewGuid(); // //推送接收者 // Business_WeChatPushDetail_Information weChatPushDetail = new Business_WeChatPushDetail_Information(); // weChatPushDetail.PushObject = userID; // weChatPushDetail.Vguid = Guid.NewGuid(); // weChatPushDetail.CreatedDate = DateTime.Now; // weChatPushDetail.ChangeDate = DateTime.Now; // weChatPushDetail.Type = "微信营收"; // weChatPushDetail.Business_WeChatPushVguid = weChatPush.VGUID; // result = _ss.SaveRevenueMsg(weChatPush, weChatPushDetail); // if (result) // { // U_RevenueMonth revenueMonth = new U_RevenueMonth(); // revenueMonth.AmountDue = revenue.AmountDue; // revenueMonth.CurrentAccountBalance = revenue.CurrentAccountBalance; // revenueMonth.CurrentPayment = revenue.CurrentPayment; // revenueMonth.HistoricalArrears = revenue.HistoricalArrears; // revenueMonth.TheBalance = revenue.TheBalance; // revenueMonth.Month = DateTime.Now.Month.ToString(); // Business_WeChatPush_Information weChatPush1 = new Business_WeChatPush_Information(); // weChatPush1.PushType = 2; // weChatPush1.Title = "营收短信"; // weChatPush1.MessageType = 8; // weChatPush1.Timed = false; // weChatPush1.TimedSendTime = null; // weChatPush1.Important = false; // weChatPush1.Message = Common.JsonHelper.ModelToJson(revenueMonth); // weChatPush1.PeriodOfValidity = null; // weChatPush1.PushDate = DateTime.Now; // weChatPush1.Status = 3; // weChatPush1.CreatedDate = DateTime.Now; // weChatPush1.ChangeDate = DateTime.Now; // weChatPush1.VGUID = Guid.NewGuid(); // //推送接收者 // Business_WeChatPushDetail_Information weChatPushDetail1 = new Business_WeChatPushDetail_Information(); // weChatPushDetail1.PushObject = userID; // weChatPushDetail1.Vguid = Guid.NewGuid(); // weChatPushDetail1.CreatedDate = DateTime.Now; // weChatPushDetail1.ChangeDate = DateTime.Now; // weChatPushDetail1.Type = "短信营收"; // weChatPushDetail1.Business_WeChatPushVguid = weChatPush1.VGUID; // if (!isZero) // { // result = _ss.SaveRevenueMsg(weChatPush1, weChatPushDetail1); // } // } //} if (isWeChatPush == "0" && isSmsPush == "0" && isRevenuePush == "0") { var queryReply = _cs.GetConfigList()[15].ConfigValue; Business_WeChatPush_Information weChatPush = new Business_WeChatPush_Information(); weChatPush.PushType = 1; weChatPush.Title = "营收微信"; weChatPush.MessageType = 1; weChatPush.Timed = false; weChatPush.TimedSendTime = null; weChatPush.Important = false; weChatPush.Message = queryReply; weChatPush.PeriodOfValidity = null; weChatPush.PushDate = null; weChatPush.Status = 3; weChatPush.CreatedDate = DateTime.Now; weChatPush.ChangeDate = DateTime.Now; weChatPush.VGUID = Guid.NewGuid(); //推送接收者 Business_WeChatPushDetail_Information weChatPushDetail = new Business_WeChatPushDetail_Information(); weChatPushDetail.PushObject = userID; weChatPushDetail.Vguid = Guid.NewGuid(); weChatPushDetail.CreatedDate = DateTime.Now; weChatPushDetail.ChangeDate = DateTime.Now; weChatPushDetail.Type = "微信营收"; weChatPushDetail.Business_WeChatPushVguid = weChatPush.VGUID; result = _ss.SaveRevenueMsg(weChatPush, weChatPushDetail); } return(result); }