ashx 获取数据库数据

lfl18326162160

已于 2024-08-28 13:56:17 修改

阅读量123

点赞数 1

文章标签：数据库

于 2024-08-28 10:48:29 首次发布

本文链接：https://blog.csdn.net/lfl18326162160/article/details/141633677

版权

<%@ WebHandler Language="C#" Class="Load" %>
using System;
using System.Web;
using System.Configuration;
using System.Data;
using System.Text;
using MysqlHelpers;  using InitData;


public class Load : IHttpHandler ,System.Web.SessionState.IRequiresSessionState {
    static   string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString();
    public dataManager dmBase = new dataManager(constr);

    public void ProcessRequest (HttpContext context) {
        context.Response.ContentType = "text/plain";
                            string ORGID = Convert.ToString(context.Session["ORGID"]);
							string pc  = Convert.ToString(context.Session["pc"]);
							string code  = Convert.ToString(context.Session["code"]);
							
                    //获取分布式DataSource
        DataTable DataSourceDept = InitDataCaching.GetDataTable(dmBase, "DS_"+ORGID, "select xt_sysdb.FACCODE,DBNAME,DBADDRESS,USERID,`PASSWORD` from xt_sysdb join xt_dept on xt_dept.FACCODE=xt_sysdb.FACCODE where xt_dept.deptid='"+ORGID+"'");

        string DSCon = "";

        if (DataSourceDept.Rows.Count > 0)
        {
            DSCon = "server=" + DataSourceDept.Rows[0]["DBADDRESS"].ToString() + ";User Id=" + DataSourceDept.Rows[0]["USERID"].ToString() + ";password=" + DataSourceDept.Rows[0]["PASSWORD"].ToString() + ";Database=" + DataSourceDept.Rows[0]["DBNAME"].ToString() + ";charset=utf8;SslMode = none;Allow User Variables=True";
        }
        //激活分布式数据连接
        dataManager dm_Active = new dataManager(DSCon);

      DataTable  dt1 = dm_Active.ExecuteDataTable("select ID as id,concat(GBNO,'-',MATNAME) as text from rawwhole_beiliao  where UBSTATE='2' and MATCODE = '"+code+"' and GBNO = '"+pc+"' order by ID asc ");

        string json = ToJson.DataTable2Json(dt1);

        context.Response.ContentType = "application/json";
        context.Response.ContentEncoding = System.Text.Encoding.UTF8;
        context.Response.Write("["+json+"]");
        context.Response.End();

    }

    public bool IsReusable {
        get {
            return false;
        }
    }

}

ashx 数据获取方式
1. aspx数据保存
   Session["pc"]=pc;
       Session["code"]=code;
ashx 数据获取
  string pc = Convert.ToString(context.Session["pc"]);
       string code = Convert.ToString(context.Session["code"]);

2.链接拼接