企业会议室,车辆预定系统

'js.liu@viasystems.com' CREATE proc dbo.sp_attencemeeting(@roomno nvarchar(50),@returnvalue nvarchar(200) output) as begin declare @PreID nvarchar(20) set @PreID=null if not exists (select top 1 1 from dbo.Meeting_Room WITH (NOLOCK) where isnull(status,0)=1 and roomno=@roomno) set @returnvalue='Error:The meeting room '+@roomno+' is not exists.' else begin select @PreID=PreID from Meeting_Pre WITH (NOLOCK) where getdate()<=cast((convert(varchar(10),predate,120)+' '+PreStart_time)as datetime) and getdate()>=dateadd(mi,-30,cast((convert(varchar(10),predate,120)+' '+PreStart_time)as datetime)) if (@PreID is null) set @returnvalue='Error:There is not any meeting will begin in the '+@roomno+'.' else begin update Meeting_Attend set Attend=1 where PreID=@PreID update Meeting_Pre set Status=2 where PreID=@PreID set @returnvalue='Sucess:the meeting room '+@roomno+' will start.' end end end GO using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using iTextSharp; using iTextSharp.text; using iTextSharp.text.pdf; using System.IO; using System.Text; using System.Data.OleDb; using System.Collections.Generic; using System.Linq; namespace LinkPower.CivilAviation.Web.UICommon { public class toDownLoad { private string strFileName = ""; public toDownLoad(string _strFileName) { // //TODO: 在此处添加构造函数逻辑 // strFileName = HttpUtility.UrlEncode(_strFileName.Trim(), System.Text.Encoding.UTF8) + DateTime.Now.ToString(@"_yyyyMMddhhmmss"); } /// <summary> /// 导出Excel /// </summary> /// <param name="table">参数类型：DataTable</param> public void toExcel(DataTable table) { try { DataTable dt = new DataTable(); dt = table; StringBuilder sb = new StringBuilder(); sb.Append("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">"); sb.Append("<tr style=\"font-weight: bold; white-space: nowrap;\">"); for (int i = 0; i < dt.Columns.Count; i++) { sb.Append("<td>").Append(dt.Columns[i].ColumnName).Append("</td>"); } sb.Append("</tr>"); foreach (DataRow row in dt.Rows) { sb.Append("<tr>"); for (int i = 0; i < dt.Columns.Count; i++) { sb.Append("<td>").Append(row[i].ToString()).Append("</td>"); } sb.Append("</tr>"); } sb.Append("</table>"); toResponse(sb.ToString(), "application/vnd.ms-excel", ".xls"); } catch { } } /// <summary> /// 导出Word /// </summary> /// <param name="table">参数类型：DataTable</param> public void toWord(DataTable table) { try { DataTable dt = new DataTable(); dt = table; StringBuilder sb = new StringBuilder(); sb.Append("<table cellspacing=\"0\" cellpadding=\"5\" rules=\"all\" border=\"1\">"); sb.Append("<tr style=\"font-weight: bold; white-space: nowrap;\">"); for (int i = 0; i < dt.Columns.Count; i++) { sb.Append("<td>").Append(dt.Columns[i].ColumnName).Append("</td>"); } sb.Append("</tr>"); foreach (DataRow row in dt.Rows) { sb.Append("<tr>"); for (int i = 0; i < dt.Columns.Count; i++) { sb.Append("<td>").Append(row[i].ToString()).Append("</td>"); } sb.Append("</tr>"); } sb.Append("</table>"); toResponse(sb.ToString(), "application/vnd.ms - word", ".doc"); } catch { } } /// <summary> /// 导出Excel /// </summary> /// <param name="table">参数类型：String 可以包含Html代码</param> public void toExcel(string strHtmlValue) { toResponse(strHtmlValue, "application/vnd.ms-excel", ".xls"); } /// <summary> /// 导出Word /// </summary> /// <param name="table">参数类型：String 可以包含Html代码</param> public void toWord(string strHtmlValue) { toResponse(strHtmlValue, "application/vnd.ms-word", ".doc"); } /// <summary> /// 导出Excel /// </summary> /// <param name="table">参数类型：System.Web.UI.Control 建议GridView</param> public void toExcel(System.Web.UI.Control source) { try { HttpResponse Response = HttpContext.Current.Response; Response.Clear(); Response.Buffer = true; Response.Write("<meta http-equiv=Content-Type content=text/html;charset=gb2312>"); Response.AppendHeader("Content-Disposition", "attachment;filename=" + strFileName + ".xls"); Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312"); Response.AddHeader("base", "target=_blank"); Response.ContentType = "application/vnd.ms-excel"; //关闭控件的视图状态 source.Page.EnableViewState = false; //初始化HtmlWriter System.IO.StringWriter writer = new System.IO.StringWriter(); System.Web.UI.HtmlTextWriter htmlWriter = new System.Web.UI.HtmlTextWriter(writer); //source.RenderControl(htmlWriter); //预防出现控件必须放在具有 runat=server 的窗体标记内的错误 System.Web.UI.Page page = new System.Web.UI.Page(); HtmlForm form = new HtmlForm(); source.EnableViewState = false; page.EnableEventValidation = false; page.DesignerInitialize(); page.Controls.Add(form); form.Controls.Add(source); page.RenderControl(htmlWriter); //输出 Response.Write(writer.ToString()); Response.End(); } catch { } } /// <summary> /// 导出Word /// </summary> /// <param name="table">参数类型：System.Web.UI.Control 建议GridView</param> public void toWord(System.Web.UI.Control source) { try { HttpResponse Response = HttpContext.Current.Response; Response.Clear(); Response.Buffer = true; Response.Write("<meta http-equiv=Content-Type content=text/html;charset=gb2312>"); Response.AppendHeader("Content-Disposition", "attachment;filename=" + strFileName + ".doc"); Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");