/// <summary> /// 修改 /// </summary> /// <param name="connection"></param> /// <param name="articleModel">对象</param> /// <returns></returns> public static bool UpdateArticleNewList(SqlConnection connection, ArticleNewList articleModel) { string sql = @"update [Marketing].[dbo].[tbl_ArticleNewList] set ArticleId =@ArticleId, ArticleUrl = @ArticleUrl, ProductId = @ProductId, [Type] = @Type, CreateTime = @CreateTime, Field_1 = @Field_1, Field_2 = @Field_2, Field_3 = @Field_3, Field_4 = @Field_4 where Id=@Id"; var sqlPrams = new SqlParameter[] { new SqlParameter("@ArticleId", articleModel.ArticleId), new SqlParameter("@ArticleUrl", articleModel.ArticleUrl), new SqlParameter("@ProductId", articleModel.ProductId), new SqlParameter("@Type", articleModel.Type), new SqlParameter("@CreateTime", articleModel.CreateTime), new SqlParameter("@Field_1", articleModel.Field_1), new SqlParameter("@Field_2", articleModel.Field_2), new SqlParameter("@Field_3", articleModel.Field_3), new SqlParameter("@Field_4", articleModel.Field_4), new SqlParameter("@Id", articleModel.Id) }; return(SqlHelper.ExecuteNonQuery(connection, CommandType.Text, sql, sqlPrams) > 0); }
public bool UpdateArticleNewList(ArticleNewList modelWhere, ArticleNewList modelValue) { try { return(handler.UpdateArticleNewList(modelWhere, modelValue)); } catch (Exception ex) { logger.Log(Level.Error, ex, "UpdateArticleNewList"); throw; } }
public bool UpdateArticleNewList(ArticleNewList articleModel) { try { return(handler.UpdateArticleNewList(articleModel)); } catch (Exception ex) { logger.Log(Level.Error, ex, "UpdateArticleNewList"); throw; } }
//表Marketing..tbl_ArticleNewList相关操作(增,删,改,查) public List <ArticleNewList> SelectArticleNewList(ArticleNewList modelValue) { try { return(handler.SelectArticleNewList(modelValue)); } catch (Exception ex) { logger.Log(Level.Error, ex, "SelectArticleNewList"); throw; } }
/// <summary> /// 添加 /// </summary> /// <param name="connection"></param> public static bool AddArticleNewList(SqlConnection connection, ArticleNewList articleModel) { string sql = @"insert into [Marketing].[dbo].[tbl_ArticleNewList] (ArticleId, ArticleUrl, ProductId, [Type], CreateTime, Field_1, Field_2, Field_3, Field_4) values (@ArticleId, @ArticleUrl, @ProductId, @Type, @CreateTime, @Field_1, @Field_2, @Field_3, @Field_4)"; var sqlPrarms = new SqlParameter[] { new SqlParameter("@ArticleId", articleModel.ArticleId), new SqlParameter("@ArticleUrl", articleModel.ArticleUrl), new SqlParameter("@ProductId", articleModel.ProductId), new SqlParameter("@Type", articleModel.Type), new SqlParameter("@CreateTime", articleModel.CreateTime), new SqlParameter("@Field_1", articleModel.Field_1), new SqlParameter("@Field_2", articleModel.Field_2), new SqlParameter("@Field_3", articleModel.Field_3), new SqlParameter("@Field_4", articleModel.Field_4) }; return(SqlHelper.ExecuteNonQuery(connection, CommandType.Text, sql, sqlPrarms) > 0); }
/// <summary> /// 修改局部字段 /// </summary> /// <param name="modelWhere">条件</param> /// <param name="modelValue">字段</param> /// <returns></returns> public bool UpdateArticleNewList(ArticleNewList modelWhere, ArticleNewList modelValue) { if (modelWhere != null && modelValue != null) { string strSql = @"update [Marketing].[dbo].[tbl_ArticleNewList] WITH(rowlock) set {0} WHERE 1=1 {1}"; StringBuilder strSqlWhere = new StringBuilder(); Dictionary <string, object> dicParamsWhere = new Dictionary <string, object>(); Dictionary <string, object> dicParamsValue = new Dictionary <string, object>(); #region 更新字段 if (modelValue.ArticleId > 0) { dicParamsValue.Add("ArticleId", modelValue.ArticleId); } if (!string.IsNullOrEmpty(modelValue.ArticleUrl)) { dicParamsValue.Add("ArticleUrl", modelValue.ArticleUrl); } if (!string.IsNullOrEmpty(modelValue.ProductId)) { dicParamsValue.Add("ProductId", modelValue.ProductId); } if (modelValue.Type > 0) { dicParamsValue.Add("Type", modelValue.Type); } if (DateTime.Compare(modelValue.CreateTime, DateTime.MinValue) > 0) { dicParamsValue.Add("CreateTime", modelValue.CreateTime); } if (!string.IsNullOrEmpty(modelValue.Field_1)) { dicParamsValue.Add("Field_1", modelValue.Field_1); } if (!string.IsNullOrEmpty(modelValue.Field_2)) { dicParamsValue.Add("Field_2", modelValue.Field_2); } if (!string.IsNullOrEmpty(modelValue.Field_3)) { dicParamsValue.Add("Field_3", modelValue.Field_3); } if (!string.IsNullOrEmpty(modelValue.Field_4)) { dicParamsValue.Add("Field_4", modelValue.Field_4); } #endregion #region 更新条件 if (modelWhere.Id > 0) { dicParamsWhere.Add("Id", modelWhere.Id); } if (modelWhere.ArticleId > 0) { dicParamsWhere.Add("ArticleId", modelWhere.ArticleId); } if (!string.IsNullOrEmpty(modelWhere.ArticleUrl)) { dicParamsWhere.Add("ArticleUrl", modelWhere.ArticleUrl); } if (!string.IsNullOrEmpty(modelValue.ProductId)) { dicParamsWhere.Add("ProductId", modelWhere.ProductId); } if (modelWhere.Type > 0) { dicParamsWhere.Add("Type", modelWhere.Type); } if (DateTime.Compare(modelWhere.CreateTime, DateTime.MinValue) > 0) { dicParamsWhere.Add("CreateTime", modelWhere.CreateTime); } if (!string.IsNullOrEmpty(modelWhere.Field_1)) { dicParamsWhere.Add("Field_1", modelWhere.Field_1); } if (!string.IsNullOrEmpty(modelWhere.Field_2)) { dicParamsWhere.Add("Field_2", modelWhere.Field_2); } if (!string.IsNullOrEmpty(modelWhere.Field_3)) { dicParamsWhere.Add("Field_3", modelWhere.Field_3); } if (!string.IsNullOrEmpty(modelWhere.Field_4)) { dicParamsWhere.Add("Field_4", modelWhere.Field_4); } #endregion StringBuilder strSqlField = new StringBuilder(); //字段 SqlParameter[] sqlParams = new SqlParameter[dicParamsWhere.Count + dicParamsValue.Count]; //参数值 for (int i = 0; i < dicParamsWhere.Count; i++) { var dicKey = dicParamsWhere.ElementAt(i).Key; var dicValue = dicParamsWhere.ElementAt(i).Value; sqlParams[i] = new SqlParameter("@Where" + dicKey, dicValue); strSqlWhere.AppendFormat(" AND {0} = @Where{0} ", dicKey); } for (int i = 0; i < dicParamsValue.Count; i++) { var dicKey = dicParamsValue.ElementAt(i).Key; var dicValue = dicParamsValue.ElementAt(i).Value; sqlParams[dicParamsWhere.Count + i] = new SqlParameter("@Value" + dicKey, dicValue); strSqlField.AppendFormat("{0}=@Value{0},", dicKey); } strSql = string.Format(strSql, strSqlField.ToString().TrimEnd(','), strSqlWhere.ToString()); if (strSql.ToLower().IndexOf("and") > 0) { Func <SqlConnection, bool> action = (connection) => DalArticle.UpdateArticleNewList(connection, strSql.ToString(), sqlParams); return(dbManager.Execute(action)); } } return(false); }
/// <summary> /// 修改所有字段 /// </summary> /// <param name="articleModel"></param> /// <returns></returns> public bool UpdateArticleNewList(ArticleNewList articleModel) { return(dbManager.Execute(conn => DalArticle.UpdateArticleNewList(conn, articleModel))); }
//表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)); }