SOA/GetPlan.ashx.cs

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

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.IO;
using System.Web.SessionState;

namespace 客户订单管理2.SOA
{
    public class GetPlan : IHttpHandler, IRequiresSessionState
    {

        public void ProcessRequest(HttpContext context)
        {
            #region 权限检查
            if (context.Session["login"] == null || context.Session["login"].ToString() != "true")
            {
                context.Response.Redirect("../Default.aspx");
                context.Response.End();
                return;
            }
            #endregion
            string sql;
            DataTable planTable = new DataTable();
            SqlConnection dataConnection;
            SqlCommand sqlCmd = new SqlCommand();
            string id = context.Request.QueryString["id"].ToString();
            sql = "select * from 系统_工作日程 where id='" + id + "' and (charindex('," + context.Session["username"] + ",',参与者) > 0 or 发起人 = '" + context.Session["username"] + "')";
            dataConnection = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["默认连接_3HK0R6GAS"].ConnectionString);
            SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
            sqlDataAdapter.SelectCommand = new SqlCommand(sql, dataConnection);
            try
            {
                dataConnection.Open();
                sqlDataAdapter.Fill(0, 1, planTable);
                dataConnection.Close();
                context.Response.ContentType = "text/html";
                if (planTable.Rows.Count == 0)
                {
                    context.Response.Write("");
                }
                else
                {
                    context.Response.Write(Convert.ToDateTime(planTable.Rows[0]["日期"]).ToString("HH") + "\t");
                    context.Response.Write(Convert.ToDateTime(planTable.Rows[0]["日期"]).ToString("mm") + "\t");
                    context.Response.Write(planTable.Rows[0]["日程"].ToString().Trim() + "\t");
                    context.Response.Write(planTable.Rows[0]["发起人"].ToString().Trim() + "\t");
                    context.Response.Write(planTable.Rows[0]["备注"].ToString().Trim() + "\t");
                    context.Response.Write(planTable.Rows[0]["参与者"].ToString().Trim().Substring(1,planTable.Rows[0]["参与者"].ToString().Trim().Length - 2));
                }
            }
            catch
            {
                context.Response.Write("(访问失败)");
            }
        }