Пример #1
0
 public static void Select(TkDbContext context, DataSet dataSet, string tableName, string sql)
 {
     using (SqlSelector selector = new SqlSelector(context, dataSet))
     {
         selector.Select(tableName, sql);
     }
 }
Пример #2
0
 public static void Select(TkDbContext context, DataSet dataSet, string tableName,
                           string selectSql, IParamBuilder builder, string orderBy)
 {
     using (SqlSelector selector = new SqlSelector(context, dataSet))
     {
         selector.Select(tableName, selectSql, builder, orderBy);
     }
 }
Пример #3
0
 public static void Select(TkDbContext context, DataSet dataSet, string tableName,
                           string sql, params IDbDataParameter[] dbParams)
 {
     using (SqlSelector selector = new SqlSelector(context, dataSet))
     {
         selector.Select(tableName, sql, dbParams);
     }
 }
Пример #4
0
        private DataTable CalTotalData(FilledListEventArgs e)
        {
            if (fStatFields.All(item => item.Method == StatMethod.Count))
            {
                DataSet.Tables.Add(new DataTable("_Total"));
            }
            else
            {
                SqlSelector.Select(Context, DataSet, "_Total", CreateStatSql(), e.Condition);
            }
            DataTable table = DataSet.Tables["_Total"];

            AppendCountPart(table, e.Count);
            return(table);
        }
Пример #5
0
        public override OutputData DoAction(IInputData input)
        {
            using (SqlSelector selector = new SqlSelector(Context, DataSet))
            {
                foreach (var item in fSqlList)
                {
                    selector.Select(item.Item2, item.Item1);
                }
            }
            if (UseCallerInfo)
            {
                input.CallerInfo.AddInfo(DataSet);
            }

            string message = SuccessMessage ?? string.Empty;

            ActionResultData.CreateSuccessResult(message).AddToDataSet(DataSet);
            return(OutputData.Create(DataSet));
        }