Exemplo n.º 1
0
        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);
            }
        }
Exemplo n.º 2
0
        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()));
        }
Exemplo n.º 3
0
        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());
        }
Exemplo n.º 4
0
        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++;
            }
        }