/// <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));
}
