SourceCode/RFrameGenerate.DAL/DataBase/SQLServer/Procedure/IProcedure.cs

(开头部分) 26KB

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Linq.Expressions;
using System.Text;
using RFrameGenerate.Model;
using RFramework.SQLServer;
using RFramework.SQLServer.Enums;
using RFrameGenerate.DAL.Enums;
using RFramework.SQLQuery;
using System.Data.SqlClient;
using RFrameGenerate.Model.Datas;

namespace RFrameGenerate.DAL.SQLServer
{
    public partial class IProcedure : IDisposable
    {
        SqlRTransaction transaction;

        #region ...
        public IProcedure(SqlRTransaction transaction = null)
        {
            this.transaction = transaction;
        }
        #region IDisposable 成员

        public void Dispose()
        {
            if (transaction != null)
                transaction.Dispose();
        }

        #endregion
        #endregion

        #region Datas

        /// <summary>
        /// 获取访问数据统计
        /// </summary>
        /// <returns></returns>
        public List<StatisticsDataModel> GetDataStatisticsList(DataStatisticsType type, DateTime dateFrom, DateTime dateTo, Guid head, Guid agent, Guid merch)
        {
            return SqlHelper.RunProcedureList<StatisticsDataModel>("DataStatisticsProc", transaction,
                SqlRParameter.GetParameter("@DateFrom", SqlDbType.NVarChar, dateFrom),
                SqlRParameter.GetParameter("@DateTo", SqlDbType.NVarChar, dateTo),
                SqlRParameter.GetParameter("@VisitType", SqlDbType.NVarChar, (int)type),
                SqlRParameter.GetParameter("@head", SqlDbType.VarChar, head.ToString()),
                SqlRParameter.GetParameter("@agent", SqlDbType.VarChar, agent.ToString()),
                SqlRParameter.GetParameter("@merch", SqlDbType.VarChar, merch.ToString()));
        }
        public List<StatisticsDataModel> GetDataOnlineStatisticsList(DataType type, DateTime dateFrom, DateTime dateTo)
        {
            return SqlHelper.RunProcedureList<StatisticsDataModel>("DataStatisticsOnlineProc", transaction,
                SqlRParameter.GetParameter("@DateFrom", SqlDbType.NVarChar, dateFrom),
                SqlRParameter.GetParameter("@DateTo", SqlDbType.NVarChar, dateTo),
                SqlRParameter.GetParameter("@Type", SqlDbType.Int, (int)type));
        }
        #endregion
后面还有 467 行代码,解锁后查看完整代码

24 小时内免费解锁 3 个项目,之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用,每次 10 算力,解读结果公开显示在下面。

还没有人解读过这个文件。