public List <EnumData> QueryEnumMember(string enumName, bool isContainerDelete) { Dictionary <string, string> columns = SqlCmdHelper.GenerateColumnMapPropertyDict <EnumData>(); string[] col = columns.Keys.ToArray(); EnumData ed = new EnumData() { Code = enumName }; string sql = ed.QueryEnumMembersSqlFormat(col, isContainerDelete); return(CommonRepository.QueryModels <EnumData, EnumData>(sql, ed, SqlConnString)); }
public List <LogData> QueryLogs(RequestParam param, out int total) { string day = param.BeginTime; if (string.IsNullOrEmpty(day)) { day = DateTime.Now.ToString(Common.Data.CommonFormat.DateFormat); } total = 0; if (param.RowEndIndex < param.RowBeginIndex) { return(new List <LogData>()); } //将这个日期转换为指定的日期串【兼容传递的值为 date或者datetime】 DateTime qd = DateTime.ParseExact(day, Common.Data.CommonFormat.DateFormat, System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None); int dayInt = int.Parse(qd.ToString(Common.Data.CommonFormat.DateIntFormat)); //exec SP_QueryDayLog 20180705 ,1,200,@total out 使用这样的形式没法获取到输出参数,修改未调用存储过程 List <SqlParameter> ps = new List <SqlParameter>(); string exec = " exec SP_QueryDayLog {day},{beginRow},{endRow} ,{total} output"; /* * 如果存在一个参数被赋值: * 必须传递参数 4,并以 '@name = value' 的形式传递后续的参数。一旦使用了 '@name = value' 形式之后,所有后续的参数就必须以 '@name = value' 的形式传递。 */ LogQueryParam p = new LogQueryParam() { day = dayInt, beginRow = param.RowBeginIndex, endRow = param.RowEndIndex }; Dictionary <ParameterDirection, string[]> dict = new Dictionary <ParameterDirection, string[]>(); dict.Add(ParameterDirection.Output, new string[] { "total" }); List <LogData> data = CommonRepository.QueryModels <LogData, LogQueryParam>(exec, p, SqlConnString, dict); total = p.total; return(data); }