//表Marketing..tbl_ArticleNewList相关操作(增,删,改,查) public List <ArticleNewList> SelectArticleNewList(ArticleNewList modelValue) { string strSql = @"SELECT * FROM [Marketing].[dbo].[tbl_ArticleNewList] with (nolock) Where 1=1 {0}"; StringBuilder strSqlWhere = new StringBuilder(); Dictionary <string, object> dicParams = new Dictionary <string, object>(); if (modelValue.Id > 0) { dicParams.Add("Id", modelValue.Id); } if (modelValue.ArticleId > 0) { dicParams.Add("ArticleId", modelValue.ArticleId); } if (!string.IsNullOrEmpty(modelValue.ArticleUrl)) { dicParams.Add("ArticleUrl", modelValue.ArticleUrl); } if (!string.IsNullOrEmpty(modelValue.ProductId)) { dicParams.Add("ProductId", modelValue.ProductId); } if (modelValue.Type > 0) { dicParams.Add("Type", modelValue.Type); } if (DateTime.Compare(modelValue.CreateTime, DateTime.MinValue) > 0) { dicParams.Add("CreateTime", modelValue.CreateTime); } if (!string.IsNullOrEmpty(modelValue.Field_1)) { dicParams.Add("Field_1", modelValue.Field_1); } if (!string.IsNullOrEmpty(modelValue.Field_2)) { dicParams.Add("Field_2", modelValue.Field_2); } if (!string.IsNullOrEmpty(modelValue.Field_3)) { dicParams.Add("Field_3", modelValue.Field_3); } if (!string.IsNullOrEmpty(modelValue.Field_4)) { dicParams.Add("Field_4", modelValue.Field_4); } SqlParameter[] sqlParams = new SqlParameter[dicParams.Count]; for (int i = 0; i < dicParams.Count; i++) { var dicKey = dicParams.ElementAt(i).Key; var dicValue = dicParams.ElementAt(i).Value; sqlParams[i] = new SqlParameter("@" + dicKey, dicValue); strSqlWhere.AppendFormat(" AND {0} = @{0} ", dicKey); } strSql = string.Format(strSql, strSqlWhere.ToString()); Func <SqlConnection, List <ArticleNewList> > action = (connection) => DalArticle.SelectArticleNewList(connection, strSql.ToString(), sqlParams); return(dbManager.Execute(action)); }