/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/multibin/po.ashx
49 строк
2 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
<%@ WebHandler Language="VB" Class="getsqldata" %> Imports System Imports System.Web Imports Newtonsoft.Json Public Class getsqldata : Implements IHttpHandler Public Sub ProcessRequest(ByVal context As HttpContext) Implements IHttpHandler.ProcessRequest context.Response.ContentType = "text/plain" With context.Request Dim sql As New StringBuilder Dim line As String = .QueryString("Line") sql.AppendLine("SELECT ") sql.AppendLine("distinct l.[po] ") sql.AppendLine("FROM [Multi-bin].[dbo].[LTS] l ") sql.AppendLine("left join [Multi-bin].[dbo].[Monitoring] m ") sql.AppendLine("on l.po = m.PO ") sql.AppendLine("and l.material = m.Material ") 'sql.AppendLine("where delivery_date >= cast (getdate() as date) ") 'sql.AppendLine("and line = '" & line & "' ") sql.AppendLine("where line = '" & line & "' ") sql.AppendLine(" ") Dim sqlf As New sharedClasses.dbFunctions.SqlFunctions Dim dt As Data.DataTable = Nothing dt = sqlf.GetData(sql.ToString) Try context.Response.Write(JsonConvert.SerializeObject(dt, Formatting.None)) Catch ex As Exception context.Response.Write("") End Try End With End Sub Public ReadOnly Property IsReusable() As Boolean Implements IHttpHandler.IsReusable Get Return False End Get End Property End Class