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