public string ShowSingle(string nowTime, string creator) { QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); DataTable dt = calendar.GetCalendars(nowTime, creator); if (dt == null || dt.Rows.Count == 0) { return(string.Empty); } StringBuilder sb = new StringBuilder(); string theme = string.Empty; int total = dt.Rows.Count >= 5 ? 5 : dt.Rows.Count; sb.Append("<ul>"); for (int i = 0; i < total; i++) { theme = dt.Rows[i]["Theme"].ToString(); theme = theme.Length > 6 ? theme.Substring(0, 6) + "..." : theme; sb.Append("<li><a href=\"javascript:openManager('" + dt.Rows[i]["CalendarId"].ToString() + "', '" + nowTime + "')\">" + theme + "</a></li>"); } sb.Append("</ul>"); if (dt.Rows.Count >= 5) { sb.Append("<div class=\"tar\" style=\"MARGIN: -3px 5px 0px 0px\">"); sb.Append("<A class=\"c9\" href=\"javascript:openFull('" + nowTime + "');\">全部</A>"); sb.Append("</div>"); } return(sb.ToString()); }
//编辑 public bool EditCalendar(string calendarId, string theme, string site, string label, string sDate, string sTime, string eDate, string eTime, string content, string creator) { QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); return(calendar.EditCalendar(new Guid(calendarId), theme, site, label, sDate, sTime, eDate, eTime, content, creator)); }
//显示当天的全部信息 public string ShowNowCalendars(string nowTime, string creator) { QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); DataTable dt = calendar.GetCalendars(nowTime, creator); if (dt == null || dt.Rows.Count == 0) { return(string.Empty); } StringBuilder sb = new StringBuilder(); sb.Append("<ul>"); for (int i = 0; i < dt.Rows.Count; i++) { DateTime sTime = Convert.ToDateTime(dt.Rows[i]["StartTime"].ToString()); DateTime eTime = Convert.ToDateTime(dt.Rows[i]["EndTime"].ToString()); sb.Append("<li>"); sb.Append("<table width=\"95%\" id=\"" + dt.Rows[i]["CalendarId"].ToString() + nowTime + "table\">"); sb.Append("<tr><td width=\"10px\">" + (i + 1).ToString() + ".</td><td width=\"300px\">"); sb.Append("主题:" + dt.Rows[i]["Theme"].ToString()); sb.Append("</td><td>地点:" + dt.Rows[i]["Site"].ToString()); sb.Append("</td></tr>"); sb.Append("<tr><td></td>"); sb.Append("<td>标签:" + dt.Rows[i]["Label"].ToString() + "</td>"); if (IsDiffTime(DateTime.Now, sTime)) { sb.Append("<td>状态:距开始" + GetDiffTime(DateTime.Now, sTime) + "</td>"); } else if (IsDiffTime(DateTime.Now, eTime)) { sb.Append("<td>状态:正在进行</td>"); } else { sb.Append("<td>状态:已过期" + GetDiffTime(DateTime.Now, eTime) + "</td>"); } sb.Append("</tr>"); sb.Append("<tr><td></td><td colspan=\"2\">"); sb.Append("开始时间:" + Convert.ToDateTime(sTime).ToString("yyyy-MM-dd hh:mm")); sb.Append(" "); sb.Append("结束时间:" + Convert.ToDateTime(eTime).ToString("yyyy-MM-dd hh:mm")); sb.Append("</td></tr>"); sb.Append("<tr><td></td><td colspan=\"2\">"); sb.Append("<span style=\"float:left;\">内容:</span><div style=\"float:left;\">" + dt.Rows[i]["DContent"].ToString() + "</div>"); sb.Append("</td></tr>"); sb.Append("</table>"); sb.Append("</li>"); } sb.Append("</ul>"); return(sb.ToString()); }
//首页显示的信息 public string ShowCalendars(string nowTime, string creator) { QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); DataTable dt = calendar.ShowCalendars(nowTime, creator); if (dt == null || dt.Rows.Count == 0) { return(string.Empty); } StringBuilder sb = new StringBuilder(); string theme = string.Empty; for (int i = 0; i < dt.Rows.Count; i++) { DateTime sTime = Convert.ToDateTime(dt.Rows[i]["StartTime"].ToString()); DateTime eTime = Convert.ToDateTime(dt.Rows[i]["EndTime"].ToString()); sb.Append("<li>"); sb.Append("<div class=\"title1\">"); theme = dt.Rows[i]["Theme"].ToString(); theme = theme.Length > 14 ? theme.Substring(0, 14) + "..." : theme; string title = theme; if (IsDiffTime(DateTime.Now, sTime)) { title = theme + " ---- 距开始" + GetDiffTime(DateTime.Now, sTime); } else { if (IsDiffTime(DateTime.Now, eTime)) { title = theme + " ---- 正在进行"; } else { title = theme + " ---- 已过期" + GetDiffTime(DateTime.Now, eTime); } } sb.Append("<a title=\"" + title + "\" href=\"Calendar.aspx?calendarId=" + dt.Rows[i]["calendarId"].ToString() + "\" target=\"_blank\">" + theme + "</a>"); sb.Append("</div>"); //if (IsDiffTime(DateTime.Now, sTime)) { // sb.Append("<div class=\"date1\">距开始" + GetDiffTime(DateTime.Now, sTime) + "</div>"); //} //else { // if (IsDiffTime(DateTime.Now, eTime)) // sb.Append("<div class=\"date1\">正在进行</div>"); // else // sb.Append("<div class=\"date1\">已过期" + GetDiffTime(DateTime.Now, eTime) + "</div>"); //} sb.Append("</li>"); } return(sb.ToString()); }
//显示单个信息 public string ShowCalendar(string calendarId, ref string theme) { QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); DataTable dt = calendar.GetCalendar(new Guid(calendarId)); if (dt == null || dt.Rows.Count == 0) { return(string.Empty); } theme = dt.Rows[0]["Theme"].ToString(); StringBuilder sb = new StringBuilder(); sb.Append("<div class=\"issue_top\">"); sb.Append("<strong style=\"font-size:14px;\"><span>" + dt.Rows[0]["Theme"].ToString() + "</span></strong>"); sb.Append("</div>"); //sb.Append("<div class=\"newclass\">"); //sb.Append("开始时间:<span>" + Convert.ToDateTime(dt.Rows[0]["StartTime"].ToString()).ToString("yyyy-MM-dd hh:mm") + "</span>"); //sb.Append(" "); //sb.Append("结束时间:<span>" + Convert.ToDateTime(dt.Rows[0]["EndTime"].ToString()).ToString("yyyy-MM-dd hh:mm") + "</span>"); //sb.Append("</div>"); sb.Append("<div><ul>"); sb.Append("<li></li>"); sb.Append("<li>开始时间:<span>" + Convert.ToDateTime(dt.Rows[0]["StartTime"].ToString()).ToString("yyyy-MM-dd hh:mm") + "</span>"); sb.Append(" "); sb.Append("结束时间:<span>" + Convert.ToDateTime(dt.Rows[0]["EndTime"].ToString()).ToString("yyyy-MM-dd hh:mm") + "</span></li>"); sb.Append("<li>地点:<span>" + dt.Rows[0]["Site"].ToString() + "</span>"); sb.Append(" "); sb.Append("标签:<span>" + dt.Rows[0]["Label"].ToString() + "</span></li>"); sb.Append("</ul></div>"); sb.Append("<div id=\"context\">"); sb.Append("<span>" + dt.Rows[0]["DContent"].ToString() + "</span>"); sb.Append("</div>"); return(sb.ToString()); }
//删除 public bool DeleteCalendar(string calendarId) { QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); return calendar.DeleteCalendar(new Guid(calendarId)); }
public DataTable GetCalendar(string calendarId) { QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); return calendar.GetCalendar(new Guid(calendarId)); }
//编辑 public bool EditCalendar(string calendarId, string theme, string site, string label, string sDate, string sTime, string eDate, string eTime, string content, string creator) { QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); return calendar.EditCalendar(new Guid(calendarId), theme, site, label, sDate, sTime, eDate, eTime, content, creator); }
//显示单个信息 public string ShowCalendar(string calendarId, ref string theme) { QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); DataTable dt = calendar.GetCalendar(new Guid(calendarId)); if (dt == null || dt.Rows.Count == 0) return string.Empty; theme = dt.Rows[0]["Theme"].ToString(); StringBuilder sb = new StringBuilder(); sb.Append("<div class=\"issue_top\">"); sb.Append("<strong style=\"font-size:14px;\"><span>" + dt.Rows[0]["Theme"].ToString() + "</span></strong>"); sb.Append("</div>"); //sb.Append("<div class=\"newclass\">"); //sb.Append("开始时间:<span>" + Convert.ToDateTime(dt.Rows[0]["StartTime"].ToString()).ToString("yyyy-MM-dd hh:mm") + "</span>"); //sb.Append(" "); //sb.Append("结束时间:<span>" + Convert.ToDateTime(dt.Rows[0]["EndTime"].ToString()).ToString("yyyy-MM-dd hh:mm") + "</span>"); //sb.Append("</div>"); sb.Append("<div><ul>"); sb.Append("<li></li>"); sb.Append("<li>开始时间:<span>" + Convert.ToDateTime(dt.Rows[0]["StartTime"].ToString()).ToString("yyyy-MM-dd hh:mm") + "</span>"); sb.Append(" "); sb.Append("结束时间:<span>" + Convert.ToDateTime(dt.Rows[0]["EndTime"].ToString()).ToString("yyyy-MM-dd hh:mm") + "</span></li>"); sb.Append("<li>地点:<span>" + dt.Rows[0]["Site"].ToString() + "</span>"); sb.Append(" "); sb.Append("标签:<span>" + dt.Rows[0]["Label"].ToString() + "</span></li>"); sb.Append("</ul></div>"); sb.Append("<div id=\"context\">"); sb.Append("<span>" + dt.Rows[0]["DContent"].ToString() + "</span>"); sb.Append("</div>"); return sb.ToString(); }
//首页显示的信息 public string ShowCalendars(string nowTime, string creator) { QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); DataTable dt = calendar.ShowCalendars(nowTime, creator); if (dt == null || dt.Rows.Count == 0) return string.Empty; StringBuilder sb = new StringBuilder(); string theme = string.Empty; for (int i = 0; i < dt.Rows.Count; i++) { DateTime sTime = Convert.ToDateTime(dt.Rows[i]["StartTime"].ToString()); DateTime eTime = Convert.ToDateTime(dt.Rows[i]["EndTime"].ToString()); sb.Append("<li>"); sb.Append("<div class=\"title1\">"); theme = dt.Rows[i]["Theme"].ToString(); theme = theme.Length > 14 ? theme.Substring(0, 14) + "..." : theme; string title = theme; if (IsDiffTime(DateTime.Now, sTime)) { title = theme+ " ---- 距开始" + GetDiffTime(DateTime.Now, sTime); } else { if (IsDiffTime(DateTime.Now, eTime)) title = theme + " ---- 正在进行"; else title = theme + " ---- 已过期" + GetDiffTime(DateTime.Now, eTime); } sb.Append("<a title=\"" + title + "\" href=\"Calendar.aspx?calendarId=" + dt.Rows[i]["calendarId"].ToString() + "\" target=\"_blank\">" + theme + "</a>"); sb.Append("</div>"); //if (IsDiffTime(DateTime.Now, sTime)) { // sb.Append("<div class=\"date1\">距开始" + GetDiffTime(DateTime.Now, sTime) + "</div>"); //} //else { // if (IsDiffTime(DateTime.Now, eTime)) // sb.Append("<div class=\"date1\">正在进行</div>"); // else // sb.Append("<div class=\"date1\">已过期" + GetDiffTime(DateTime.Now, eTime) + "</div>"); //} sb.Append("</li>"); } return sb.ToString(); }
//显示当天的全部信息 public string ShowNowCalendars(string nowTime, string creator) { QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); DataTable dt = calendar.GetCalendars(nowTime, creator); if (dt == null || dt.Rows.Count == 0) return string.Empty; StringBuilder sb = new StringBuilder(); sb.Append("<ul>"); for (int i = 0; i < dt.Rows.Count; i++) { DateTime sTime = Convert.ToDateTime(dt.Rows[i]["StartTime"].ToString()); DateTime eTime = Convert.ToDateTime(dt.Rows[i]["EndTime"].ToString()); sb.Append("<li>"); sb.Append("<table width=\"95%\" id=\"" + dt.Rows[i]["CalendarId"].ToString() + nowTime + "table\">"); sb.Append("<tr><td width=\"10px\">"+(i+1).ToString()+".</td><td width=\"300px\">"); sb.Append("主题:" + dt.Rows[i]["Theme"].ToString()); sb.Append("</td><td>地点:" + dt.Rows[i]["Site"].ToString()); sb.Append("</td></tr>"); sb.Append("<tr><td></td>"); sb.Append("<td>标签:" + dt.Rows[i]["Label"].ToString()+"</td>"); if (IsDiffTime(DateTime.Now, sTime)) sb.Append("<td>状态:距开始" + GetDiffTime(DateTime.Now, sTime) + "</td>"); else if (IsDiffTime(DateTime.Now, eTime)) sb.Append("<td>状态:正在进行</td>"); else sb.Append("<td>状态:已过期" + GetDiffTime(DateTime.Now, eTime) + "</td>"); sb.Append("</tr>"); sb.Append("<tr><td></td><td colspan=\"2\">"); sb.Append("开始时间:" + Convert.ToDateTime(sTime).ToString("yyyy-MM-dd hh:mm")); sb.Append(" "); sb.Append("结束时间:" + Convert.ToDateTime(eTime).ToString("yyyy-MM-dd hh:mm")); sb.Append("</td></tr>"); sb.Append("<tr><td></td><td colspan=\"2\">"); sb.Append("<span style=\"float:left;\">内容:</span><div style=\"float:left;\">" + dt.Rows[i]["DContent"].ToString() + "</div>"); sb.Append("</td></tr>"); sb.Append("</table>"); sb.Append("</li>"); } sb.Append("</ul>"); return sb.ToString(); }
public string ShowContent(int year, int month, string creator) { int total = DateTime.DaysInMonth(year, month); int nowDay = DateTime.Now.Day; string sTime = year.ToString() + "-" + month.ToString() + "-1"; string eTime = year.ToString() + "-" + month.ToString() + "-" + total.ToString(); QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); DataTable dt = calendar.GetCalendarsMonth(sTime, eTime, creator); StringBuilder sb = new StringBuilder(); string week = Convert.ToDateTime(sTime).DayOfWeek.ToString(); int iWeek = GetWeek(week); int day = 1; string head = string.Empty; string content = string.Empty; for (int i = 0; i < 7; i++) { if (i >= iWeek) { head += "<DIV class=\"title1\"><SPAN style=\"CURSOR: pointer\">" + day.ToString() + "</SPAN></DIV>"; if (nowDay == day) { content += "<DIV class=\"cont1\" onclick=\"this.className = 'cont2';\" onmouseout=\"this.className = 'cont1';\" ondblclick=\"openEdit('" + year.ToString() + "-" + month.ToString() + "-" + day.ToString() + "')\" id=\"" + year.ToString() + month.ToString() + day.ToString() + "\">" + GetContent(year, month, day, dt) + "</DIV>"; } else { content += "<DIV class=\"cont\" onclick=\"this.className = 'cont2;'\" onmouseout=\"this.className = 'cont';\" ondblclick=\"openEdit('" + year.ToString() + "-" + month.ToString() + "-" + day.ToString() + "')\" id=\"" + year.ToString() + month.ToString() + day.ToString() + "\">" + GetContent(year, month, day, dt) + "</DIV>"; } day++; } else { head += "<DIV class=\"title1\"><SPAN style=\"CURSOR: pointer\"> </SPAN></DIV>"; content += "<DIV class=\"cont\"></DIV>"; } } int num = total - day + 7; for (int i = 7; i <= num; i++) { if (i % 7 == 0) { head += "<DIV class=\"c\"></DIV>"; content += "<DIV class=\"c\"></DIV>"; sb.Append(head + content); head = string.Empty; content = string.Empty; head += "<DIV class=\"title1\"><SPAN style=\"CURSOR: pointer\">" + day.ToString() + "</SPAN></DIV>"; if (nowDay == day) { content += "<DIV class=\"cont1\" onclick=\"this.className = 'cont2';\" onmouseout=\"this.className = 'cont1';\" ondblclick=\"openEdit('" + year.ToString() + "-" + month.ToString() + "-" + day.ToString() + "')\" id=\"" + year.ToString() + month.ToString() + day.ToString() + "\">" + GetContent(year, month, day, dt) + "</DIV>"; } else { content += "<DIV class=\"cont\" onclick=\"this.className = 'cont2';\" onmouseout=\"this.className = 'cont';\" ondblclick=\"openEdit('" + year.ToString() + "-" + month.ToString() + "-" + day.ToString() + "')\" id=\"" + year.ToString() + month.ToString() + day.ToString() + "\">" + GetContent(year, month, day, dt) + "</DIV>"; } day++; if (i == num) { head += "<DIV class=\"c\"></DIV>"; content += "<DIV class=\"c\"></DIV>"; sb.Append(head + content); head = string.Empty; content = string.Empty; } } else { head += "<DIV class=\"title1\"><SPAN style=\"CURSOR: pointer\">" + day.ToString() + "</SPAN></DIV>"; if (nowDay == day) { content += "<DIV class=\"cont1\" onclick=\"this.className = 'cont2';\" onmouseout=\"this.className = 'cont1';\" ondblclick=\"openEdit('" + year.ToString() + "-" + month.ToString() + "-" + day.ToString() + "')\" id=\"" + year.ToString() + month.ToString() + day.ToString() + "\">" + GetContent(year, month, day, dt) + "</DIV>"; } else { content += "<DIV class=\"cont\" onclick=\"this.className = 'cont2';\" onmouseout=\"this.className = 'cont';\" ondblclick=\"openEdit('" + year.ToString() + "-" + month.ToString() + "-" + day.ToString() + "')\" id=\"" + year.ToString() + month.ToString() + day.ToString() + "\">" + GetContent(year, month, day, dt) + "</DIV>"; } day++; } if (i == num && i % 7 != 0) { head += "<DIV class=\"c\"></DIV>"; content += "<DIV class=\"c\"></DIV>"; sb.Append(head + content); head = string.Empty; content = string.Empty; } } return(sb.ToString()); }
public string SearchCalendarsContent(string monthTime, string stime, string etime, string state, string creator, int pageSize, int pageIndex, int type) { int pageCount = 0; QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); DataSet ds = calendar.SearchCalendars(monthTime, stime, etime, state, creator, pageSize, pageIndex, type); if (ds == null && ds.Tables.Count == 0) { return(string.Empty); } DataTable dt = ds.Tables[1]; pageCount = string.IsNullOrEmpty(ds.Tables[0].Rows[0][0].ToString()) ? 0 : int.Parse(ds.Tables[0].Rows[0][0].ToString()); StringBuilder sb = new StringBuilder(); if (pageCount > pageSize) { sb.Append(SearchCalendarsPage(pageSize, pageIndex, pageCount, monthTime, stime, etime, state, type)); } sb.Append("<ul>"); for (int i = 0; i < dt.Rows.Count; i++) { DateTime sTime = Convert.ToDateTime(dt.Rows[i]["StartTime"].ToString()); DateTime eTime = Convert.ToDateTime(dt.Rows[i]["EndTime"].ToString()); int no = pageSize * (pageIndex - 1) + i + 1; sb.Append("<li>"); sb.Append("<table width=\"95%\" style=\"border-bottom:#ddd 1px solid;\">"); sb.Append("<tr><td width=\"10px\">" + no.ToString() + ".</td><td width=\"300px\">"); sb.Append("主题:" + dt.Rows[i]["Theme"].ToString()); sb.Append("</td><td>地点:" + dt.Rows[i]["Site"].ToString()); sb.Append("</td></tr>"); sb.Append("<tr><td></td>"); sb.Append("<td>标签:" + dt.Rows[i]["Label"].ToString() + "</td>"); if (IsDiffTime(DateTime.Now, sTime)) { sb.Append("<td>状态:距开始" + GetDiffTime(DateTime.Now, sTime) + "</td>"); } else if (IsDiffTime(DateTime.Now, eTime)) { sb.Append("<td>状态:正在进行</td>"); } else { sb.Append("<td>状态:已过期" + GetDiffTime(DateTime.Now, eTime) + "</td>"); } sb.Append("</tr>"); sb.Append("<tr><td></td><td colspan=\"2\">"); sb.Append("开始时间:" + Convert.ToDateTime(sTime).ToString("yyyy-MM-dd hh:mm")); sb.Append(" "); sb.Append("结束时间:" + Convert.ToDateTime(eTime).ToString("yyyy-MM-dd hh:mm")); sb.Append("</td></tr>"); sb.Append("<tr><td></td><td colspan=\"2\">"); sb.Append("<span style=\"float:left;\">内容:</span><div style=\"float:left;\">" + dt.Rows[i]["DContent"].ToString() + "</div>"); sb.Append("</td></tr>"); sb.Append("</table>"); sb.Append("</li>"); } sb.Append("</ul>"); if (pageCount > pageSize) { sb.Append(SearchCalendarsPage(pageSize, pageIndex, pageCount, monthTime, stime, etime, state, type)); } return(sb.ToString()); }
//删除 public bool DeleteCalendar(string calendarId) { QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); return(calendar.DeleteCalendar(new Guid(calendarId))); }
public DataTable GetCalendar(string calendarId) { QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); return(calendar.GetCalendar(new Guid(calendarId))); }
public string SearchCalendarsContent(string monthTime, string stime, string etime, string state, string creator, int pageSize, int pageIndex, int type) { int pageCount = 0; QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); DataSet ds = calendar.SearchCalendars(monthTime,stime,etime,state,creator,pageSize,pageIndex,type); if (ds == null && ds.Tables.Count == 0) return string.Empty; DataTable dt = ds.Tables[1]; pageCount = string.IsNullOrEmpty(ds.Tables[0].Rows[0][0].ToString()) ? 0 : int.Parse(ds.Tables[0].Rows[0][0].ToString()); StringBuilder sb = new StringBuilder(); if (pageCount > pageSize) sb.Append(SearchCalendarsPage(pageSize, pageIndex, pageCount, monthTime, stime, etime, state, type)); sb.Append("<ul>"); for (int i = 0; i < dt.Rows.Count; i++) { DateTime sTime = Convert.ToDateTime(dt.Rows[i]["StartTime"].ToString()); DateTime eTime = Convert.ToDateTime(dt.Rows[i]["EndTime"].ToString()); int no = pageSize * (pageIndex - 1) + i + 1; sb.Append("<li>"); sb.Append("<table width=\"95%\" style=\"border-bottom:#ddd 1px solid;\">"); sb.Append("<tr><td width=\"10px\">" + no.ToString() + ".</td><td width=\"300px\">"); sb.Append("主题:" + dt.Rows[i]["Theme"].ToString()); sb.Append("</td><td>地点:" + dt.Rows[i]["Site"].ToString()); sb.Append("</td></tr>"); sb.Append("<tr><td></td>"); sb.Append("<td>标签:" + dt.Rows[i]["Label"].ToString() + "</td>"); if (IsDiffTime(DateTime.Now, sTime)) sb.Append("<td>状态:距开始" + GetDiffTime(DateTime.Now, sTime) + "</td>"); else if (IsDiffTime(DateTime.Now, eTime)) sb.Append("<td>状态:正在进行</td>"); else sb.Append("<td>状态:已过期" + GetDiffTime(DateTime.Now, eTime) + "</td>"); sb.Append("</tr>"); sb.Append("<tr><td></td><td colspan=\"2\">"); sb.Append("开始时间:" + Convert.ToDateTime(sTime).ToString("yyyy-MM-dd hh:mm")); sb.Append(" "); sb.Append("结束时间:" + Convert.ToDateTime(eTime).ToString("yyyy-MM-dd hh:mm")); sb.Append("</td></tr>"); sb.Append("<tr><td></td><td colspan=\"2\">"); sb.Append("<span style=\"float:left;\">内容:</span><div style=\"float:left;\">" + dt.Rows[i]["DContent"].ToString() + "</div>"); sb.Append("</td></tr>"); sb.Append("</table>"); sb.Append("</li>"); } sb.Append("</ul>"); if (pageCount > pageSize) sb.Append(SearchCalendarsPage(pageSize,pageIndex,pageCount,monthTime,stime,etime,state,type)); return sb.ToString(); }
public string ShowContent(int year, int month, string creator) { int total = DateTime.DaysInMonth(year, month); int nowDay = DateTime.Now.Day; string sTime = year.ToString() + "-" + month.ToString() + "-1"; string eTime = year.ToString() + "-" + month.ToString() + "-" + total.ToString(); QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); DataTable dt = calendar.GetCalendarsMonth(sTime, eTime, creator); StringBuilder sb = new StringBuilder(); string week = Convert.ToDateTime(sTime).DayOfWeek.ToString(); int iWeek = GetWeek(week); int day = 1; string head = string.Empty; string content = string.Empty; for (int i = 0; i < 7; i++) { if (i >= iWeek) { head += "<DIV class=\"title1\"><SPAN style=\"CURSOR: pointer\">" + day.ToString() + "</SPAN></DIV>"; if(nowDay == day) content += "<DIV class=\"cont1\" onclick=\"this.className = 'cont2';\" onmouseout=\"this.className = 'cont1';\" ondblclick=\"openEdit('" + year.ToString() + "-" + month.ToString() + "-" + day.ToString() + "')\" id=\"" + year.ToString() + month.ToString() + day.ToString() + "\">" + GetContent(year, month, day, dt) + "</DIV>"; else content += "<DIV class=\"cont\" onclick=\"this.className = 'cont2;'\" onmouseout=\"this.className = 'cont';\" ondblclick=\"openEdit('" + year.ToString() + "-" + month.ToString() + "-" + day.ToString() + "')\" id=\"" + year.ToString() + month.ToString() + day.ToString() + "\">"+ GetContent(year, month, day, dt) + "</DIV>"; day++; } else { head += "<DIV class=\"title1\"><SPAN style=\"CURSOR: pointer\"> </SPAN></DIV>"; content += "<DIV class=\"cont\"></DIV>"; } } int num = total - day + 7; for (int i = 7; i <= num; i++) { if (i % 7 == 0) { head += "<DIV class=\"c\"></DIV>"; content += "<DIV class=\"c\"></DIV>"; sb.Append(head + content); head = string.Empty; content = string.Empty; head += "<DIV class=\"title1\"><SPAN style=\"CURSOR: pointer\">" + day.ToString() + "</SPAN></DIV>"; if(nowDay == day) content += "<DIV class=\"cont1\" onclick=\"this.className = 'cont2';\" onmouseout=\"this.className = 'cont1';\" ondblclick=\"openEdit('" + year.ToString() + "-" + month.ToString() + "-" + day.ToString() + "')\" id=\"" + year.ToString() + month.ToString() + day.ToString() + "\">" + GetContent(year, month, day, dt) + "</DIV>"; else content += "<DIV class=\"cont\" onclick=\"this.className = 'cont2';\" onmouseout=\"this.className = 'cont';\" ondblclick=\"openEdit('" + year.ToString() + "-" + month.ToString() + "-" + day.ToString() + "')\" id=\"" + year.ToString() + month.ToString() + day.ToString() + "\">" + GetContent(year, month, day, dt) + "</DIV>"; day++; if (i == num) { head += "<DIV class=\"c\"></DIV>"; content += "<DIV class=\"c\"></DIV>"; sb.Append(head + content); head = string.Empty; content = string.Empty; } } else { head += "<DIV class=\"title1\"><SPAN style=\"CURSOR: pointer\">" + day.ToString() + "</SPAN></DIV>"; if(nowDay == day) content += "<DIV class=\"cont1\" onclick=\"this.className = 'cont2';\" onmouseout=\"this.className = 'cont1';\" ondblclick=\"openEdit('" + year.ToString() + "-" + month.ToString() + "-" + day.ToString() + "')\" id=\"" + year.ToString() + month.ToString() + day.ToString() + "\">" + GetContent(year, month, day, dt) + "</DIV>"; else content += "<DIV class=\"cont\" onclick=\"this.className = 'cont2';\" onmouseout=\"this.className = 'cont';\" ondblclick=\"openEdit('" + year.ToString() + "-" + month.ToString() + "-" + day.ToString() + "')\" id=\"" + year.ToString() + month.ToString() + day.ToString() + "\">" + GetContent(year, month, day, dt) + "</DIV>"; day++; } if (i == num && i % 7 != 0) { head += "<DIV class=\"c\"></DIV>"; content += "<DIV class=\"c\"></DIV>"; sb.Append(head + content); head = string.Empty; content = string.Empty; } } return sb.ToString(); }
public string ShowSingle(string nowTime, string creator) { QJVRMS.Business.CalendarWS.CalendarService calendar = new QJVRMS.Business.CalendarWS.CalendarService(); DataTable dt = calendar.GetCalendars(nowTime, creator); if (dt == null || dt.Rows.Count == 0) return string.Empty; StringBuilder sb = new StringBuilder(); string theme = string.Empty; int total = dt.Rows.Count >= 5 ? 5 : dt.Rows.Count; sb.Append("<ul>"); for (int i = 0; i < total; i++) { theme = dt.Rows[i]["Theme"].ToString(); theme = theme.Length > 6 ? theme.Substring(0, 6) + "..." : theme; sb.Append("<li><a href=\"javascript:openManager('" + dt.Rows[i]["CalendarId"].ToString() + "', '"+nowTime+"')\">" + theme + "</a></li>"); } sb.Append("</ul>"); if (dt.Rows.Count >= 5) { sb.Append("<div class=\"tar\" style=\"MARGIN: -3px 5px 0px 0px\">"); sb.Append("<A class=\"c9\" href=\"javascript:openFull('" + nowTime + "');\">全部</A>"); sb.Append("</div>"); } return sb.ToString(); }