/
ivan
/
ModMas
Обзор
Документация
Войти
/
ivan
/
ModMas
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
main
ModuleMaster/hr/reststatbyperson.aspx.vb
29 строк
1 KB
i.krivokon
Initial commit
13 мар 2026, 13:49
13 мар 2026, 13:49
00d9fb6
Код
Авторство
О чём код?
Imports sharedClasses.dbFunctions Imports System.Data.SqlClient Partial Class HR_reststatbyperson Inherits System.Web.UI.Page Protected Sub Page_Load(sender As Object, e As EventArgs) Handles Me.Load Dim sqlf As New SqlFunctions Dim sql As New StringBuilder sql.AppendLine(" select rank() over(order by regdate) as [№], EMPLOYEENO, regdate, domainid, cost ") sql.AppendLine(" from UserModules.[user].[RESTAURANT_STATISTICS] ") sql.AppendLine(" where procdate between @from and @to ") sql.AppendLine(" and EMPLOYEENO = @gen ") sql.AppendLine(" order by regdate ") Dim com As New SqlCommand com.CommandText = sql.ToString With com.Parameters .AddWithValue("from", Request.QueryString("from")) .AddWithValue("to", Request.QueryString("to")) .AddWithValue("gen", Request.QueryString("gen")) End With GridView1.DataSource = sqlf.GetData(com) GridView1.DataBind() If GridView1.Rows.Count = 0 Then Response.Write("No data found") End If End Sub End Class