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()));
}
public int Add(OACalendarInfo model, OACalendarRemindSet model2)
{
StringBuilder builder = new StringBuilder();
builder.Append(" begin");
builder.Append(" insert into OA_Calendar_Info(");
builder.Append("UserCode,RecordDate,Title,Content,IsRemind,InfoGuid");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + model.UserCode + "',");
builder.Append("'" + model.RecordDate + "',");
builder.Append("'" + model.Title + "',");
builder.Append("'" + model.Content + "',");
builder.Append("'" + model.IsRemind + "',");
builder.Append("'" + model.InfoGuid + "'");
builder.Append(")");
builder.Append(";select @@IDENTITY");
builder.Append(" end");
object obj2 = publicDbOpClass.ExecuteScalar(builder.ToString());
if (obj2 == null)
{
return(0);
}
if (model.IsRemind == "1")
{
this.SmsOrMessageAdd(model2, Convert.ToInt32(obj2));
}
return(1);
}
private void PageBind()
{
OACalendarInfo model = this.cia.GetModel(this.RecordID);
this.TxtRecordDate.Text = Convert.ToDateTime(model.RecordDate).ToString("yyyy-MM-dd");
this.TxtContent.Text = model.Content;
this.TxtTitle.Text = model.Title;
userManageDb userManageDb = new userManageDb();
this.TxtUserName.Text = userManageDb.GetUserName(model.UserCode);
this.CBIsRemind.Checked = (model.IsRemind == "1");
if (!this.CBIsRemind.Checked)
{
this.CBIsSms.Enabled = false;
this.CBIsMessage.Enabled = false;
}
this.InfoGuid = model.InfoGuid;
CalendarRemindSetaction calendarRemindSetaction = new CalendarRemindSetaction();
OACalendarRemindSet model2 = calendarRemindSetaction.GetModel(this.InfoGuid);
if (model2 != null)
{
this.TxtHours.Text = model2.RemindHour.ToString();
this.TxtMinutes.Text = model2.RemindMinute.ToString();
this.CBIsMessage.Checked = (model2.IsMessage == "1");
this.CBIsSms.Checked = (model2.IsSms == "1");
return;
}
this.CBIsMessage.Checked = false;
this.CBIsSms.Checked = false;
}
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 PageBind()
{
CalendarRemindSetaction calendarRemindSetaction = new CalendarRemindSetaction();
OACalendarRemindSet model = calendarRemindSetaction.GetModel(this.InfoGuid);
if (model != null)
{
this.CBIsMessage.Checked = (model.IsMessage == "1");
this.CBIsSms.Checked = (model.IsSms == "1");
this.TxtHours.Text = model.RemindHour.ToString();
this.TxtMinutes.Text = model.RemindMinute.ToString();
if (model.RemindType > 1)
{
this.DDLRemindType.SelectedValue = model.RemindType.ToString();
}
this.DBEndDate.Text = model.EndDate.ToString("yyyy-MM-dd");
}
}
public int Update(OACalendarInfo model, OACalendarRemindSet model2)
{
StringBuilder builder = new StringBuilder();
builder.Append(" begin");
builder.Append(" update OA_Calendar_Info set ");
builder.Append("UserCode='" + model.UserCode + "',");
builder.Append("Title='" + model.Title + "',");
builder.Append("Content='" + model.Content + "',");
builder.Append("IsRemind='" + model.IsRemind + "'");
builder.Append(" where InfoGuid='" + model.InfoGuid + "'");
builder.Append(" update OA_Calendar_RemindSet set ");
builder.Append("IsMessage='" + model2.IsMessage + "',");
builder.Append("RemindHour=" + model2.RemindHour + ",");
builder.Append("RemindMinute=" + model2.RemindMinute + ",");
builder.Append("EndDate='" + model2.EndDate + "'");
builder.Append(" where InfoGuid='" + model2.InfoGuid + "'");
builder.Append(" update OA_Calendar_RemindSet set ");
builder.Append("IsSms='" + model2.IsSms + "',");
builder.Append("RemindHour=" + model2.RemindHour + ",");
builder.Append("RemindMinute=" + model2.RemindMinute + ",");
builder.Append("EndDate='" + model2.EndDate + "'");
builder.Append(" where InfoGuid='" + model2.InfoGuid + "'");
DataTable table = publicDbOpClass.DataTableQuary("select * from OA_Calendar_Info where InfoGuid='" + model.InfoGuid + "'");
string content = model.Content;
if (model.Content.Length > 70)
{
content = model.Content.Substring(0, 60) + "...";
}
for (int i = 0; i < table.Rows.Count; i++)
{
builder.Append(" update PT_SMSLog set Message = '日程管理消息：" + content + "' where I_XGID = '" + table.Rows[i]["RecordID"].ToString() + "'");
builder.Append(" update PT_SMSLog_Today set Message = '日程管理消息：" + content + "' where I_XGID = '" + table.Rows[i]["RecordID"].ToString() + "'");
builder.Append(" update PT_DBSJ set V_Content = '" + content + "' where I_XGID = '" + table.Rows[i]["RecordID"].ToString() + "'");
builder.Append(" update PT_DBSJ_Today set V_Content = '" + content + "' where I_XGID = '" + table.Rows[i]["RecordID"].ToString() + "'");
}
builder.Append(" end");
return(publicDbOpClass.ExecSqlString(builder.ToString()));
}
public OACalendarRemindSet GetModel(Guid InfoGuid)
{
StringBuilder builder = new StringBuilder();
builder.Append(" select ");
builder.Append(" InfoGuid,IsSms,IsMessage,RemindType,RemindHour,RemindMinute,EndDate ");
builder.Append(" from OA_Calendar_RemindSet ");
builder.Append(" where InfoGuid='" + InfoGuid + "'");
OACalendarRemindSet set = new OACalendarRemindSet();
DataSet set2 = publicDbOpClass.DataSetQuary(builder.ToString());
if (set2.Tables[0].Rows.Count <= 0)
{
return(null);
}
if (set2.Tables[0].Rows[0]["InfoGuid"].ToString() != "")
{
set.InfoGuid = new Guid(set2.Tables[0].Rows[0]["InfoGuid"].ToString());
}
set.IsSms = set2.Tables[0].Rows[0]["IsSms"].ToString();
set.IsMessage = set2.Tables[0].Rows[0]["IsMessage"].ToString();
if (set2.Tables[0].Rows[0]["RemindType"].ToString() != "")
{
set.RemindType = int.Parse(set2.Tables[0].Rows[0]["RemindType"].ToString());
}
if (set2.Tables[0].Rows[0]["RemindHour"].ToString() != "")
{
set.RemindHour = int.Parse(set2.Tables[0].Rows[0]["RemindHour"].ToString());
}
if (set2.Tables[0].Rows[0]["RemindMinute"].ToString() != "")
{
set.RemindMinute = int.Parse(set2.Tables[0].Rows[0]["RemindMinute"].ToString());
}
if (set2.Tables[0].Rows[0]["EndDate"].ToString() != "")
{
set.EndDate = DateTime.Parse(set2.Tables[0].Rows[0]["EndDate"].ToString());
}
return(set);
}
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++;
}
}
