public static bool UpdateSpecialColumn(SpecialColumn model)
{
try
{
return(SpecialColumnDAL.UpdateSpecialColumn(ProcessConnection.OpenMarketing, model));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool AddSpecialColumn(SqlConnection conn, SpecialColumn model)
{
SqlTransaction tran = conn.BeginTransaction();
List <bool> res = new List <bool>();
bool result = false;
string insertSql1 = "INSERT INTO Marketing..tbl_SpecialColumn(ColumnName,ColumnDesc,ColumnImage,IsTop,IsShow,CreateTime,Creator,PublishTime) OUTPUT Inserted.ID VALUES(@ColumnName, @ColumnDesc, @ColumnImage, 0, @IsShow, @CreateTime, @Creator,@PublishTime)";
string insertSql2 = "INSERT INTO Marketing..tbl_ColumnArticle(PKID,SCID,CreateTime)VALUES(@PKID,@SCID,@CreateTime)";
try
{
var sqlParamsInfo = new SqlParameter[]
{
new SqlParameter("@ColumnName", model.ColumnName),
new SqlParameter("@ColumnDesc", model.ColumnDesc),
new SqlParameter("@ColumnImage", model.ColumnImage),
new SqlParameter("@IsShow", model.IsShow),
new SqlParameter("@CreateTime", model.CreateTime),
new SqlParameter("@Creator", model.Creator),
new SqlParameter("@PublishTime", model.PublishTime)
};
object obj = SqlHelper.ExecuteScalar(tran, CommandType.Text, insertSql1, sqlParamsInfo);
int columnId = Convert.ToInt32(obj);
foreach (var article in model.Articles)
{
var param = new SqlParameter[] {
new SqlParameter("@PKID", article.PKID),
new SqlParameter("@SCID", columnId),
new SqlParameter("@CreateTime", DateTime.Now)
};
res.Add(SqlHelper.ExecuteNonQuery(tran, CommandType.Text, insertSql2, param) > 0);
}
if (res.Contains(false))
{
tran.Rollback();
}
else
{
result = true;
tran.Commit();
}
}
catch (Exception ex)
{
tran.Rollback();
}
conn.Close();
return(result);
}
public static bool UpdateSpecialColumn(SqlConnection conn, SpecialColumn model)
{
SqlTransaction tran = conn.BeginTransaction();
List <bool> res = new List <bool>();
bool result = false;
string updateSql = "UPDATE Marketing..tbl_SpecialColumn SET ColumnName=@ColumnName,ColumnDesc=@ColumnDesc,ColumnImage=@ColumnImage,IsShow=@IsShow,PublishTime=@PublishTime WHERE ID=@ID";
string deleteSql = "DELETE FROM Marketing..tbl_ColumnArticle WHERE SCID=" + model.ID;
string insertSql = "INSERT INTO Marketing..tbl_ColumnArticle(PKID,SCID,CreateTime)VALUES(@PKID,@SCID,@CreateTime)";
try
{
var sqlParamsInfo = new SqlParameter[]
{
new SqlParameter("@ColumnName", model.ColumnName),
new SqlParameter("@ColumnDesc", model.ColumnDesc),
new SqlParameter("@ColumnImage", model.ColumnImage),
new SqlParameter("@IsShow", model.IsShow),
new SqlParameter("@PublishTime", model.PublishTime),
new SqlParameter("@ID", model.ID)
};
res.Add(SqlHelper.ExecuteNonQuery(tran, CommandType.Text, updateSql, sqlParamsInfo) > 0);
res.Add(SqlHelper.ExecuteNonQuery(tran, CommandType.Text, deleteSql) > 0);
foreach (var article in model.Articles)
{
var param = new SqlParameter[] {
new SqlParameter("@PKID", article.PKID),
new SqlParameter("@SCID", model.ID),
new SqlParameter("@CreateTime", DateTime.Now)
};
res.Add(SqlHelper.ExecuteNonQuery(tran, CommandType.Text, insertSql, param) > 0);
}
if (res.Contains(false))
{
tran.Rollback();
}
else
{
result = true;
tran.Commit();
}
}
catch
{
tran.Rollback();
}
return(result);
}
public QueryBuilder AddSpecialColumn(SpecialColumn column)
{
SpecialColumns.Add(column);
return(this);
}
