private void getPTDBSJ(string xgid, string Mes, string jsyhdm) { DataTable table = publicDbOpClass.DataTableQuary(string.Format("\r\n\t\t\t\tSELECT DISTINCT MSG.*, IM.BusinessCode, BC.DoWithUrl\r\n\t\t\t\tFROM WF_RecieveMsg AS MSG\r\n\t\t\t\tJOIN WF_Instance_Main AS IM ON IM.InstanceCode = MSG.InstanceCode\r\n\t\t\t\tJOIN WF_BusinessCode AS BC ON BC.BusinessCode = IM.BusinessCode\r\n\t\t\t\tWHERE MSG.RecordID='{0}'\r\n\t\t\t", xgid)); if (table.Rows.Count > 0) { PTDBSJ model = new PTDBSJ { V_LXBM = "014", I_XGID = xgid, DTM_DBSJ = DateTime.Now, V_Content = Mes }; string str2 = table.Rows[0]["DoWithUrl"].ToString().TrimStart(new char[] { '/' }); if (!str2.Contains("?")) { model.V_DBLJ = str2 + "?ic=" + table.Rows[0]["InstanceCode"].ToString(); } else { model.V_DBLJ = str2 + "&ic=" + table.Rows[0]["InstanceCode"].ToString(); } model.V_YHDM = jsyhdm; PublicInterface.SendSysMsg(model); } }
public int Add(OACalendarRemindSet model, OACalendarInfo model2, DateTime RDate) { publicDbOpClass.ExecSqlString(" delete OA_Calendar_Info where InfoGuid = '" + model.InfoGuid + "' "); StringBuilder builder = new StringBuilder(); builder.Append(" begin"); builder.Append(" delete OA_Calendar_RemindSet where InfoGuid = '" + model.InfoGuid + "' "); builder.Append(" insert into OA_Calendar_RemindSet("); builder.Append(" InfoGuid,IsSms,IsMessage,RemindType,RemindHour,RemindMinute,EndDate"); builder.Append(")"); builder.Append(" values ("); builder.Append("'" + model.InfoGuid + "',"); builder.Append("'" + model.IsSms + "',"); builder.Append("'" + model.IsMessage + "',"); builder.Append(model.RemindType + ","); builder.Append(model.RemindHour + ","); builder.Append(model.RemindMinute + ","); builder.Append("'" + model.EndDate + "'"); builder.Append(")"); builder.Append(" end"); DataTable table = publicDbOpClass.DataTableQuary("select * from OA_Calendar_Info where InfoGuid = '" + model.InfoGuid + "' "); for (int i = 0; i < table.Rows.Count; i++) { PublicInterface.PTDBSJDelete(table.Rows[i]["RecordID"].ToString(), "001"); PublicInterface.PTDBSJTodayDelete(table.Rows[i]["RecordID"].ToString(), "001"); PublicInterface.SMSLogDelete(table.Rows[i]["RecordID"].ToString(), "001"); PublicInterface.SMSLogTodayDelete(table.Rows[i]["RecordID"].ToString(), "001"); } this.SmsOrMessageAdd(model, model2, RDate); return(publicDbOpClass.ExecSqlString(builder.ToString())); }
private void SmsOrMessageAdd(OACalendarRemindSet model, int recordid) { StringBuilder builder = new StringBuilder(); builder.Append(" insert into OA_Calendar_RemindSet("); builder.Append("InfoGuid,IsSms,IsMessage,RemindType,RemindHour,RemindMinute,EndDate"); builder.Append(")"); builder.Append(" values ("); builder.Append("'" + model.InfoGuid + "',"); builder.Append("'" + model.IsSms + "',"); builder.Append("'" + model.IsMessage + "',"); builder.Append(model.RemindType + ","); builder.Append(model.RemindHour + ","); builder.Append(model.RemindMinute + ","); builder.Append("'" + model.EndDate + "'"); builder.Append(")"); PublicInterface.PTDBSJDelete(recordid.ToString(), "001"); PublicInterface.PTDBSJTodayDelete(recordid.ToString(), "001"); PublicInterface.SMSLogDelete(recordid.ToString(), "001"); PublicInterface.SMSLogTodayDelete(recordid.ToString(), "001"); if (model.IsSms == "1") { SMSLog log; log = new SMSLog { SendUser = HttpContext.Current.Session["yhdm"].ToString(), SendTime = model.EndDate.Date.AddHours((double)model.RemindHour).AddMinutes((double)model.RemindMinute), ReceiveUser = HttpContext.Current.Session["yhdm"].ToString(), Message = this.strMessage(recordid), V_LXBM = "001", I_XGID = recordid.ToString() }; PublicInterface.SendSmsMsg(log); } if (model.IsMessage == "1") { PTDBSJ ptdbsj = new PTDBSJ { V_LXBM = "001", I_XGID = recordid.ToString(), DTM_DBSJ = model.EndDate.Date.AddHours((double)model.RemindHour).AddMinutes((double)model.RemindMinute), V_Content = this.strMessage(recordid), V_DBLJ = "?rid=" + recordid, V_YHDM = HttpContext.Current.Session["yhdm"].ToString() }; PublicInterface.SendSysMsg(ptdbsj); } publicDbOpClass.ExecSqlString(builder.ToString()); }
private void SmsOrMessageAdd(OACalendarRemindSet model, OACalendarInfo model2, DateTime RDate) { double num4; int num5; int num = 0; switch (model.RemindType) { case 2: { TimeSpan span = model.EndDate.Date.Subtract(RDate); for (int i = 0; i <= span.Days; i++) { num = this.CalendarInfoAdd(model2, RDate.AddDays(Convert.ToDouble(i)).Date.AddHours((double)model.RemindHour).AddMinutes((double)model.RemindMinute)); if (model.IsSms == "1") { SMSLog log; log = new SMSLog { SendUser = HttpContext.Current.Session["yhdm"].ToString(), SendTime = RDate.AddDays(Convert.ToDouble(i)).Date.AddHours((double)model.RemindHour).AddMinutes((double)model.RemindMinute), ReceiveUser = HttpContext.Current.Session["yhdm"].ToString(), Message = "日程管理消息:" + model2.Content, V_LXBM = "001", I_XGID = num.ToString() }; PublicInterface.SendSmsMsg(log); } if (model.IsMessage == "1") { PTDBSJ ptdbsj = new PTDBSJ { V_LXBM = "001", I_XGID = num.ToString(), C_OpenFlag = "0", DTM_DBSJ = RDate.AddDays(Convert.ToDouble(i)).Date.AddHours((double)model.RemindHour).AddMinutes((double)model.RemindMinute), V_Content = model2.Content, V_TPLJ = "", V_DBLJ = "?rid=" + num, V_YHDM = HttpContext.Current.Session["yhdm"].ToString() }; PublicInterface.SendSysMsg(ptdbsj); } } return; } case 3: { TimeSpan span2 = model.EndDate.Date.Subtract(RDate); for (int j = 0; j <= span2.Days; j++) { if (Convert.ToInt32(RDate.AddDays(Convert.ToDouble(j)).DayOfWeek) == Convert.ToInt32(RDate.DayOfWeek)) { num = this.CalendarInfoAdd(model2, RDate.AddDays(Convert.ToDouble(j)).Date.AddHours((double)model.RemindHour).AddMinutes((double)model.RemindMinute)); if (model.IsSms == "1") { SMSLog log2; log2 = new SMSLog { SendUser = HttpContext.Current.Session["yhdm"].ToString(), SendTime = RDate.AddDays(Convert.ToDouble(j)).Date.AddHours((double)model.RemindHour).AddMinutes((double)model.RemindMinute), ReceiveUser = HttpContext.Current.Session["yhdm"].ToString(), Message = "日程管理消息:" + model2.Content, V_LXBM = "001", I_XGID = num.ToString() }; PublicInterface.SendSmsMsg(log2); } if (model.IsMessage == "1") { PTDBSJ ptdbsj2 = new PTDBSJ { V_LXBM = "001", I_XGID = num.ToString(), C_OpenFlag = "0", DTM_DBSJ = RDate.AddDays(Convert.ToDouble(j)).Date.AddHours((double)model.RemindHour).AddMinutes((double)model.RemindMinute), V_Content = model2.Content, V_TPLJ = "", V_DBLJ = "?rid=" + num.ToString(), V_YHDM = HttpContext.Current.Session["yhdm"].ToString() }; PublicInterface.SendSysMsg(ptdbsj2); } } } return; } case 4: num4 = this.MonthEquals(RDate, model.EndDate); num5 = 0; break; default: return; } while (num5 <= num4) { num = this.CalendarInfoAdd(model2, RDate.AddMonths(num5).Date.AddHours((double)model.RemindHour).AddMinutes((double)model.RemindMinute)); if (model.IsSms == "1") { SMSLog log3; log3 = new SMSLog { SendUser = HttpContext.Current.Session["yhdm"].ToString(), SendTime = RDate.AddMonths(num5).Date.AddHours((double)model.RemindHour).AddMinutes((double)model.RemindMinute), ReceiveUser = HttpContext.Current.Session["yhdm"].ToString(), Message = "日程管理消息:" + model2.Content, V_LXBM = "001", I_XGID = num.ToString() }; PublicInterface.SendSmsMsg(log3); } if (model.IsMessage == "1") { PTDBSJ ptdbsj3 = new PTDBSJ { V_LXBM = "001", I_XGID = num.ToString(), C_OpenFlag = "0", DTM_DBSJ = RDate.AddMonths(num5).Date.AddHours((double)model.RemindHour).AddMinutes((double)model.RemindMinute), V_Content = model2.Content, V_TPLJ = "", V_DBLJ = "?rid=" + num.ToString(), V_YHDM = HttpContext.Current.Session["yhdm"].ToString() }; PublicInterface.SendSysMsg(ptdbsj3); } num5++; } }