C# (CSharp) Dal SqlHelper.ExecuteDataTableProcedure Exemples

Exemple #1

        /// <summary>
        /// 主页面 Datagrid数据
        /// </summary>
        public List <LabelPrintHistoryModel> GetLabelPrintHistoryDataByDate(DateTime date, int userId)
        {
            DataTable data = SqlHelper.ExecuteDataTableProcedure(@"SJGetLabelPrintHistoryDataByDateUser"
                                                                 , new SqlParameter[] { new SqlParameter("@ProductionDate", date), new SqlParameter("@UserID", userId) });

            return(SqlHelper.DataTableToModelList <LabelPrintHistoryModel>(data));
        }