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 OACalendarInfo GetModel(int RecordID)
{
StringBuilder builder = new StringBuilder();
builder.Append("select ");
builder.Append(" RecordID,UserCode,RecordDate,Title,Content,IsRemind,InfoGuid ");
builder.Append(" from OA_Calendar_Info ");
builder.Append(" where RecordID=" + RecordID);
OACalendarInfo info = new OACalendarInfo();
DataSet set = publicDbOpClass.DataSetQuary(builder.ToString());
if (set.Tables[0].Rows.Count <= 0)
{
return(null);
}
if (set.Tables[0].Rows[0]["RecordID"].ToString() != "")
{
info.RecordID = int.Parse(set.Tables[0].Rows[0]["RecordID"].ToString());
}
info.UserCode = set.Tables[0].Rows[0]["UserCode"].ToString();
if (set.Tables[0].Rows[0]["RecordDate"].ToString() != "")
{
info.RecordDate = DateTime.Parse(set.Tables[0].Rows[0]["RecordDate"].ToString());
}
info.Title = set.Tables[0].Rows[0]["Title"].ToString();
info.Content = set.Tables[0].Rows[0]["Content"].ToString();
info.IsRemind = set.Tables[0].Rows[0]["IsRemind"].ToString();
info.InfoGuid = (Guid)set.Tables[0].Rows[0]["InfoGuid"];
return(info);
}
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 PageBind()
{
OACalendarInfo model = this.cia.GetModel(this.RecordID);
if (model != null)
{
this.lbRecordDate.Text = Convert.ToDateTime(model.RecordDate).ToString("yyyy-MM-dd");
this.lbContent.Text = model.Content;
this.lbTitle.Text = model.Title;
userManageDb userManageDb = new userManageDb();
this.lbUserName.Text = userManageDb.GetUserName(model.UserCode);
this.CBIsRemind.Checked = (model.IsRemind == "1");
}
}
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()));
}
private int CalendarInfoAdd(OACalendarInfo model, DateTime rdate)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into OA_Calendar_Info(");
builder.Append("InfoGuid,UserCode,RecordDate,Title,Content,IsRemind");
builder.Append(")");
builder.Append(" values (");
builder.Append("'" + model.InfoGuid + "',");
builder.Append("'" + model.UserCode + "',");
builder.Append("'" + rdate + "',");
builder.Append("'" + model.Title + "',");
builder.Append("'" + model.Content + "',");
builder.Append("'" + model.IsRemind + "'");
builder.Append(")");
builder.Append(";select @@IDENTITY");
object obj2 = publicDbOpClass.ExecuteScalar(builder.ToString());
if (obj2 != null)
{
return(Convert.ToInt32(obj2));
}
return(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++;
}
}
