public static SpecialColumn SelectSpecialColumnByID(int ID)
{
var row = SpecialColumnDAL.SelectSpecialColumnByID(ProcessConnection.OpenMarketing, ID);
if (row == null)
{
return(new SpecialColumn());
}
int id = row.Field <int>("ID");
string columnName = row.Field <string>("ColumnName");
string columnDesc = row.Field <string>("ColumnDesc");
string columnImage = row.Field <string>("ColumnImage");
int isTop = row.Field <int>("IsTop");
bool isShow = row.Field <bool>("IsShow");
DateTime createTime = row.Field <DateTime>("CreateTime");
DateTime?publishTime = row.Field <DateTime?>("PublishTime");
string creator = row.Field <string>("Creator");
return(new SpecialColumn
{
ID = id,
ColumnName = columnName,
ColumnDesc = columnDesc,
ColumnImage = columnImage,
IsTop = isTop,
IsShow = isShow,
CreateTime = createTime,
Creator = creator,
PublishTime = publishTime
});
}
public static bool UpdateSpecialColumn(SpecialColumn model)
{
try
{
return(SpecialColumnDAL.UpdateSpecialColumn(ProcessConnection.OpenMarketing, model));
}
catch (Exception ex)
{
throw ex;
}
}
public static bool UpdateIsShow(int id, bool isShow)
{
try
{
return(SpecialColumnDAL.UpdateIsShow(ProcessConnection.OpenMarketing, id, isShow));
}
catch (Exception ex)
{
throw ex;
}
}
public static List <SpecialColumn> SelectColumnList(PagerModel pager, string strWhere)
{
try
{
DataTable dt = SpecialColumnDAL.SelectColumnList(ProcessConnection.OpenMarketing, pager, strWhere);
if (dt.Rows.Count > 0)
{
return(DTConvertSpecialColumn(dt));
}
else
{
return(new List <SpecialColumn>());
}
}
catch (Exception ex)
{
throw ex;
}
}
public static List <ColumnArticle> SelectArticleBySCID(int scid)
{
try
{
DataTable dt = SpecialColumnDAL.SelectColumnArticleBySql(ProcessConnection.OpenMarketing, string.Format("AND SCID={0}", scid.ToString()));
if (dt.Rows.Count > 0)
{
return(DTConvertColumnArticle(dt));
}
else
{
return(new List <ColumnArticle>());
}
}
catch (Exception ex)
{
throw ex;
}
}
