Meeting/Js/Ajax/yysubmit.ashx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using DBUtility;
using System;
using System.Collections.Generic;
using System.Web.SessionState;
using System.Web;
using System.Collections;

namespace WebApplication.Js.Ajax
{
    /// <summary>
    /// yysubmit 的摘要说明
    /// </summary>
    public class yysubmit : IHttpHandler,IRequiresSessionState
    {

        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            //context.Response.Write("Hello World");
            try
            {
                string sd = context.Request["d"] + " " + context.Request["stime"];
                string ed = context.Request["d"] + " " + context.Request["etime"];
                string sdjy = DateTime.Parse(sd).AddMinutes(+1).ToString("yyyy-MM-dd HH:mm");
                string edjy = DateTime.Parse(ed).AddMinutes(-1).ToString("yyyy-MM-dd HH:mm");
                int count = int.Parse(DbHelperSQL.GetSingle("select count(*) from GZXX_U_Order where verify = 1 and MeetingInfoID = '" + context.Request["roomid"] + "' and ((StartDate BETWEEN '" + sd + "' AND '" + edjy + "') or (EndDate BETWEEN '" + sdjy + "' AND '" + ed + "')) and CONVERT(varchar(10), StartDate, 23) = '" + context.Request["d"] + "'").ToString());
                if (count == 0)
                {
                    Hashtable ht = new Hashtable();
                    ht.Add("ChannelID", "1000055");
                    ht.Add("ClassID", "100");
                    ht.Add("DepartID", "1");
                    ht.Add("Title", context.Request["title"]);
                    ht.Add("StartDate", sd + ":00");
                    ht.Add("EndDate", ed + ":00");
                    ht.Add("MeetingInfoID", context.Request["roomid"]);
                    ht.Add("UserInfoID", context.Session["InfoID"]);
                    ht.Add("Inputer", context.Session["InfoID"]);
                    ht.Add("CreateDate", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                    BLL.Models.GZXX_Model bll = new BLL.Models.GZXX_Model();
                    if (bll.AddContent("GZXX_U_Order", ht) > 0)
                    {
                        context.Response.Write("OK");
                    }
                    else
                    {
                        context.Response.Write("会议室预约失败，请稍后再试！");
                    }
                }
                else
                {
                    context.Response.Write("所选时间段内会议室已有预约！");
                }
            }
            catch (Exception ex) 
            {
                context.Response.Write("Error:" + ex.Message);
            }
        }