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++;
}
}