private CalendarEventEntity GetCalendarEntityFromIDataReader(DbDataReader dr)
{
CalendarEventEntity dt = new CalendarEventEntity();
if (dr.FieldCount > 0)
{
dt.Content = dr["CalendarEventContent"].ToString();
dt.EmailNote = dr["CalendarEventEmailNote"].ToString();
dt.EndTime = DateTime.Parse(dr["CalendarEventEndTime"].ToString());
dt.Invite = dr["CalendarEventInvite"].ToString();
dt.Note = dr["CalendarEventNote"].ToString();
dt.NoteBefore = Int32.Parse(dr["CalendarEventNoteBefore"].ToString());
dt.Repeat = dr["CalendarEventRepeat"].ToString();
dt.RepeatRate = Int32.Parse(dr["CalendarEventRepeatRate"].ToString());
dt.StartTime = DateTime.Parse(dr["CalendarEventStartTime"].ToString());
dt.Title = dr["CalendarEventTitle"].ToString();
dt.Type = Int32.Parse(dr["CalendarEventType"].ToString());
dt.Userial = Int32.Parse(dr["CalendarEventUserial"].ToString());
dt.UserID = Int32.Parse(dr["CalendarEventUserID"].ToString());
dr.Close();
return dt;
}
dr.Close();
return null;
}
public int UpDateCalendarEvnetByID(CalendarEventEntity _CalendarEventEntity)
{
DbParameter[] pramsUpDate = {
MakeInParam("@CalendarEventTitle",(DbType)SqlDbType.VarChar,50,_CalendarEventEntity.Title),
MakeInParam("@CalendarEventContent",(DbType)SqlDbType.VarChar,100,_CalendarEventEntity.Content),
MakeInParam("@CalendarEventType",(DbType)SqlDbType.Int,4,_CalendarEventEntity.Type),
MakeInParam("@CalendarEventStartTime",(DbType)SqlDbType.DateTime,50,_CalendarEventEntity.StartTime),
MakeInParam("@CalendarEventEndTime",(DbType)SqlDbType.DateTime,50,_CalendarEventEntity.EndTime),
MakeInParam("@CalendarEventInvite",(DbType)SqlDbType.VarChar,1000,_CalendarEventEntity.Invite),
MakeInParam("@CalendarEventEmailNote",(DbType)SqlDbType.VarChar,50,_CalendarEventEntity.EmailNote),
MakeInParam("@CalendarEventNote",(DbType)SqlDbType.VarChar,50,_CalendarEventEntity.Note),
MakeInParam("@CalendarEventNoteBefore",(DbType)SqlDbType.Int ,4,_CalendarEventEntity.NoteBefore),
MakeInParam("@CalendarEventRepeat",(DbType)SqlDbType.VarChar,50,_CalendarEventEntity.Repeat),
MakeInParam("@CalendarEventRepeatRate",(DbType)SqlDbType.Int,4,_CalendarEventEntity.RepeatRate),
MakeInParam("@CalendarEventUserID",(DbType)SqlDbType.Int,4,_CalendarEventEntity.UserID),
MakeInParam("@CalendarEventUserial",(DbType)SqlDbType.Int,4,_CalendarEventEntity.Userial),
};
StringBuilder sb = new StringBuilder();
sb.Append("UpDate [dbo].[CalendarEvent]");
sb.Append(" set ");
sb.Append(" [CalendarEventUserial]=@CalendarEventUserial,");
sb.Append(" [CalendarEventUserID]=@CalendarEventUserID,");
sb.Append(" [CalendarEventTitle]=@CalendarEventTitle,");
sb.Append(" [CalendarEventContent]=@CalendarEventContent,");
sb.Append(" [CalendarEventType]=@CalendarEventType,");
sb.Append(" [CalendarEventStartTime]=@CalendarEventStartTime,");
sb.Append(" [CalendarEventEndTime]=@CalendarEventEndTime,");
sb.Append(" [CalendarEventInvite]=@CalendarEventInvite,");
sb.Append(" [CalendarEventEmailNote]=@CalendarEventEmailNote,");
sb.Append(" [CalendarEventNote]=@CalendarEventNote,");
sb.Append(" [CalendarEventNoteBefore]=@CalendarEventNoteBefore,");
sb.Append(" [CalendarEventRepeat]=@CalendarEventRepeat,");
sb.Append(" [CalendarEventRepeatRate]=@CalendarEventRepeatRate");
sb.Append(" where [CalendarEventUserial]=@CalendarEventUserial and [CalendarEventUserID]=@CalendarEventUserID");
sb.Append(" select @@identity;");
return Int32.Parse(ExecuteScalar(CommandType.Text, sb.ToString(), pramsUpDate).ToString());
}
public int AddNewsCalenderEvent(CalendarEventEntity _CalendarEvent)
{
DbParameter[] pramsInsert = {
MakeInParam("@CalendarEventTitle",(DbType)SqlDbType.VarChar,50,_CalendarEvent.Title),
MakeInParam("@CalendarEventContent",(DbType)SqlDbType.VarChar,100,_CalendarEvent.Content),
MakeInParam("@CalendarEventType",(DbType)SqlDbType.Int,4,_CalendarEvent.Type),
MakeInParam("@CalendarEventStartTime",(DbType)SqlDbType.DateTime,50,_CalendarEvent.StartTime),
MakeInParam("@CalendarEventEndTime",(DbType)SqlDbType.DateTime,50,_CalendarEvent.EndTime),
MakeInParam("@CalendarEventInvite",(DbType)SqlDbType.VarChar,1000,_CalendarEvent.Invite),
MakeInParam("@CalendarEventEmailNote",(DbType)SqlDbType.VarChar,50,_CalendarEvent.EmailNote),
MakeInParam("@CalendarEventNote",(DbType)SqlDbType.VarChar,50,_CalendarEvent.Note),
MakeInParam("@CalendarEventNoteBefore",(DbType)SqlDbType.Int ,4,_CalendarEvent.NoteBefore),
MakeInParam("@CalendarEventRepeat",(DbType)SqlDbType.VarChar,50,_CalendarEvent.Repeat),
MakeInParam("@CalendarEventRepeatRate",(DbType)SqlDbType.Int,4,_CalendarEvent.RepeatRate),
MakeInParam("@CalendarEventUserID",(DbType)SqlDbType.Int,4,_CalendarEvent.UserID),
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[CalendarEvent]");
sb.Append("([CalendarEventTitle]");
sb.Append(",[CalendarEventContent]");
sb.Append(",[CalendarEventType]");
sb.Append(",[CalendarEventStartTime]");
sb.Append(",[CalendarEventEndTime]");
sb.Append(",[CalendarEventInvite]");
sb.Append(",[CalendarEventEmailNote]");
sb.Append(",[CalendarEventNote]");
sb.Append(",[CalendarEventNoteBefore]");
sb.Append(",[CalendarEventRepeat]");
sb.Append(",[CalendarEventRepeatRate]");
sb.Append(",[CalendarEventUserID]");
sb.Append(")");
sb.Append("VALUES");
sb.Append("(@CalendarEventTitle");
sb.Append(",@CalendarEventContent");
sb.Append(",@CalendarEventType");
sb.Append(",@CalendarEventStartTime");
sb.Append(",@CalendarEventEndTime");
sb.Append(",@CalendarEventInvite");
sb.Append(",@CalendarEventEmailNote");
sb.Append(",@CalendarEventNote");
sb.Append(",@CalendarEventNoteBefore");
sb.Append(",@CalendarEventRepeat");
sb.Append(",@CalendarEventRepeatRate");
sb.Append(",@CalendarEventUserID");
sb.Append(")");
sb.Append(" select @@identity;");
return Int32.Parse(ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString());
}
public void ProcessRequest(HttpContext context)
{
string myaction = context.Request.Params["action"];
string temp = "";
if (myaction.ToLower() == "add")
{
string Title = context.Request.Params["TxtTitle"];
string Content = context.Request.Params["TxtContent"];
string Type = context.Request.Params["drType"];
string BeginTime = context.Request.Params["TxtBeginTime"];
string EndTime = context.Request.Params["TxtEndTime"];
string Invite = context.Request.Params["TxtInvite"];
string ckRemind = context.Request.Params["ckTiXing"]; //是否提醒
string Remind = context.Request.Params["drTiXing"]; //多久提醒
string ckRepeat = context.Request.Params["ckRepeat"]; //是否重复
string RepeatRate = context.Request.Params["drRepeatRate"]; //重复频率
string ckEmailNote = context.Request.Params["ckEmailNote"]; //是否邮件提醒
CalendarEventEntity _CalendarEvent = new CalendarEventEntity();
_CalendarEvent.Content = Content;
_CalendarEvent.EmailNote = ckEmailNote;
_CalendarEvent.EndTime = DateTime.Parse(EndTime);
_CalendarEvent.Invite = Invite;
_CalendarEvent.Note = ckRemind;
_CalendarEvent.NoteBefore = Int16.Parse(Remind);
_CalendarEvent.Repeat = ckRepeat;
_CalendarEvent.RepeatRate = Int16.Parse(RepeatRate);
_CalendarEvent.StartTime = DateTime.Parse(BeginTime);
_CalendarEvent.Title = Title;
_CalendarEvent.Type = Int16.Parse(Type);
_CalendarEvent.UserID = Int32.Parse(context.Session["UserID"].ToString());
int id = DbHelper.GetInstance().AddNewsCalenderEvent(_CalendarEvent);
string[] UserList = Invite.Split(',');
foreach(string UserID in UserList)
{
if (UserID != "")
{
if (ckEmailNote == "true") //发邮件提醒
{
EmailEntity _EmailEntity = new EmailEntity();
_EmailEntity.UserID = context.Session["UserID"].ToString();
_EmailEntity.SenderID = UserID;
_EmailEntity.ReceiverID = context.Session["UserID"].ToString();
_EmailEntity.SendTime = DateTime.Now;
_EmailEntity.ReceiveTime = DateTime.Now;
_EmailEntity.MailTitle = "[提醒]" + Title;
_EmailEntity.MailContent = Content;
_EmailEntity.ISRead = 0; //0: 未读 1: 已读 2:删除(非彻底删除)
_EmailEntity.SecretSenderID = "";
_EmailEntity.IsScret = 0;
_EmailEntity.AttachID = "";
_EmailEntity.UserMasterID = 0;
string szResult = DbHelper.GetInstance().AddEmailInfor(_EmailEntity);
}
//添加到提醒好友的事件中
_CalendarEvent.Content = Content;
_CalendarEvent.EmailNote = ckEmailNote;
_CalendarEvent.EndTime = DateTime.Parse(EndTime);
_CalendarEvent.Invite = Invite;
_CalendarEvent.Note = ckRemind;
_CalendarEvent.NoteBefore = Int16.Parse(Remind);
_CalendarEvent.Repeat = ckRepeat;
_CalendarEvent.RepeatRate = Int16.Parse(RepeatRate);
_CalendarEvent.StartTime = DateTime.Parse(BeginTime);
_CalendarEvent.Title = Title;
_CalendarEvent.Type = Int16.Parse(Type);
_CalendarEvent.UserID = Int32.Parse( UserID);
int idd = DbHelper.GetInstance().AddNewsCalenderEvent(_CalendarEvent);
}
}
if (ckRemind=="true") //提醒
{}
if (ckRepeat == "true") //重复
{ }
Global.CalendarNote(); //提醒定时器
}
else if (myaction.ToLower() == "show")
{
int UserID = Int32.Parse(context.Session["UserID"].ToString());
int id = Int32.Parse(context.Request.Params["activity.id"].ToString());
StringBuilder jsonBuilder = new StringBuilder();
DataTable dtCalendar = DbHelper.GetInstance().GetCalenderEventByID(id);
if (dtCalendar.Rows.Count > 0)
{
if (dtCalendar.Rows.Count > 0)
{
jsonBuilder.Append("{\"");
jsonBuilder.Append(dtCalendar.TableName);
jsonBuilder.Append("\":[");
for (int i = 0; i < dtCalendar.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dtCalendar.Columns.Count; j++)
{
jsonBuilder.Append("\"");
jsonBuilder.Append(dtCalendar.Columns[j].ColumnName);
jsonBuilder.Append("\":\"");
jsonBuilder.Append(dtCalendar.Rows[i][j].ToString());
jsonBuilder.Append("\",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
}
}
context.Response.Write(jsonBuilder);
}
else if (myaction.ToLower() == "delete")
{
}
else if (myaction.ToLower() == "update")
{
int id = Int32.Parse(context.Request.Form["activity.id"].ToString());
CalendarEventEntity _CalendarEventEntity = DbHelper.GetInstance().GetCalendarEntityByID(id);
string Title = context.Request.Params["TxtTitle"];
string Content = context.Request.Params["TxtContent"];
string Type = context.Request.Params["drType"];
string BeginTime = context.Request.Params["TxtBeginTime"];
string EndTime = context.Request.Params["TxtEndTime"];
string Invite = context.Request.Params["TxtInvite"];
string ckRemind = context.Request.Params["ckTiXing"]; //是否提醒
string Remind = context.Request.Params["drTiXing"]; //多久提醒
string ckRepeat = context.Request.Params["ckRepeat"]; //是否重复
string RepeatRate = context.Request.Params["drRepeatRate"]; //重复频率
string ckEmailNote = context.Request.Params["ckEmailNote"]; //是否邮件提醒
_CalendarEventEntity.Content = Content;
_CalendarEventEntity.EmailNote = ckEmailNote;
_CalendarEventEntity.EndTime = DateTime.Parse(EndTime);
_CalendarEventEntity.Invite = Invite;
_CalendarEventEntity.Note = ckRemind;
_CalendarEventEntity.NoteBefore = Int16.Parse(Remind);
_CalendarEventEntity.Repeat = ckRepeat;
_CalendarEventEntity.RepeatRate = Int16.Parse(RepeatRate);
_CalendarEventEntity.StartTime = DateTime.Parse(BeginTime);
_CalendarEventEntity.Title = Title;
_CalendarEventEntity.Type = Int16.Parse(Type);
int id_update = DbHelper.GetInstance().UpDateCalendarEvnetByID(_CalendarEventEntity);
Global.CalendarNote(); //提醒定时器
}
else if (myaction.ToLower() == "save")
{
string title = context.Request.Form["activity.title"];
DateTime startTime = DateTime.Parse(context.Request.Form["activity.startTime"]);
DateTime endTime = DateTime.Parse(context.Request.Form["activity.endTime"]);
CalendarEventEntity _CalendarEventEntity = new CalendarEventEntity();
_CalendarEventEntity.UserID = Int32.Parse(context.Session["UserID"].ToString());
_CalendarEventEntity.Type = 0;
_CalendarEventEntity.Title = title;
_CalendarEventEntity.StartTime = startTime;
_CalendarEventEntity.RepeatRate = 0;
_CalendarEventEntity.Repeat = "";
_CalendarEventEntity.NoteBefore = 0;
_CalendarEventEntity.Note = "";
_CalendarEventEntity.Invite = "";
_CalendarEventEntity.EndTime = endTime;
_CalendarEventEntity.EmailNote = "";
_CalendarEventEntity.Content = "";
int id = DbHelper.GetInstance().AddNewsCalenderEvent(_CalendarEventEntity);
if (id != 0)
{
SortedDictionary<string, object> values = new SortedDictionary<string, object>();
values.Add("returnStr", "success");
values.Add("id", id);
context.Response.Write(new JavaScriptSerializer().Serialize(values));
}
Global.CalendarNote(); //提醒定时器
}
else if (myaction.ToLower() == "loadmonth")
{
DateTime startTime = DateTime.Parse(context.Request.Form["activity.startTime"]);
DateTime endTime = DateTime.Parse(context.Request.Form["activity.endTime"]);
int PermissionUserID = Int32.Parse(context.Request.Params["PerssionUserID"].ToString());
int UserID;
if (PermissionUserID == 0)
UserID = Int32.Parse(context.Session["UserID"].ToString());
else
UserID = PermissionUserID;
////本月第一天时间
//DateTime dt_First = startTime.AddDays(-(startTime.Day) + 1);
////将本月月数+1
//DateTime dt2 = startTime.AddMonths(1);
////本月最后一天时间
//DateTime dt_Last = dt2.AddDays(-(startTime.Day));
DataTable dtMonth = DbHelper.GetInstance().GetCalendarByDate(startTime, endTime, UserID);
StringBuilder jsonBuilder = new StringBuilder();
if (dtMonth.Rows.Count > 0)
{
if (dtMonth.Rows.Count > 0)
{
jsonBuilder.Append("{\"");
jsonBuilder.Append(dtMonth.TableName);
jsonBuilder.Append("\":[");
for (int i = 0; i < dtMonth.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dtMonth.Columns.Count; j++)
{
jsonBuilder.Append("\"");
jsonBuilder.Append(dtMonth.Columns[j].ColumnName);
jsonBuilder.Append("\":\"");
jsonBuilder.Append(dtMonth.Rows[i][j].ToString());
jsonBuilder.Append("\",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
}
}
context.Response.Write(jsonBuilder);
}
else if (myaction.ToLower() == "loadweek")
{
DateTime startTime = DateTime.Parse(context.Request.Form["activity.startTime"]);
DateTime endTime = DateTime.Parse(context.Request.Form["activity.endTime"]);
int PermissionUserID = Int32.Parse( context.Request.Params["PerssionUserID"].ToString());
int UserID;
if(PermissionUserID==0)
UserID = Int32.Parse(context.Session["UserID"].ToString());
else
UserID = PermissionUserID;
//int weeknow = Convert.ToInt32(startTime.DayOfWeek);
////星期日 获取weeknow为0
//weeknow = weeknow == 0 ? 7 : weeknow;
//int daydiff = (-1) * weeknow + 1;
//int dayadd = 7 - weeknow;
////本周第一天
//DateTime datebegin = startTime.AddDays(daydiff);
////本周最后一天
//DateTime dateend = startTime.AddDays(dayadd);
DataTable dtWeek = DbHelper.GetInstance().GetCalendarByDate(startTime, endTime, UserID);
StringBuilder jsonBuilder = new StringBuilder();
if (dtWeek.Rows.Count > 0)
{
if (dtWeek.Rows.Count > 0)
{
jsonBuilder.Append("{\"");
jsonBuilder.Append(dtWeek.TableName);
jsonBuilder.Append("\":[");
for (int i = 0; i < dtWeek.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dtWeek.Columns.Count; j++)
{
jsonBuilder.Append("\"");
jsonBuilder.Append(dtWeek.Columns[j].ColumnName);
jsonBuilder.Append("\":\"");
jsonBuilder.Append(dtWeek.Rows[i][j].ToString());
jsonBuilder.Append("\",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
}
context.Response.Write(jsonBuilder);
}
}
}
