/// <summary> /// /// </summary> /// <param name="ids"></param> /// <param name="nodes"></param> /// <returns></returns> public int MoveTo(string[] ids, string[] nodes) { if (ids.Length == 0) { throw new Exception("被移动的文章未选择!"); } if (nodes.Length == 0) { throw new Exception("要移动到的栏目未选择!"); } int r = 0; try { for (int i = 0; i < nodes.Length; i++) { cmsNewsCatalog nc = NewsCatalogService.GetInstance().Get(nodes[i]); string sql = @"update cmsNews set nodecode='{0}',langId={1} where 1=1 and Id in ('{2}')"; sql = string.Format(sql, nodes[i], nc.LangId, string.Join("','", ids).Replace("'0',", "")); r = DBSession.CurrentSession.FromSql(sql).ExecuteNonQuery(); } } catch (Exception ex) { throw ex; } return(r); }
static NewsCatalogService() { if (instance == null) { lock (lockObj) { instance = new NewsCatalogService(); } } }
/// <summary> /// /// </summary> /// <param name="ids"></param> /// <param name="nodes"></param> /// <returns></returns> public int CopyTo(string[] ids, string[] nodes) { if (ids.Length == 0) { throw new Exception("被复制的文章未选择!"); } if (nodes.Length == 0) { throw new Exception("要复制到的栏目未选择!"); } int r = 0; try { for (int i = 0; i < nodes.Length; i++) { cmsNewsCatalog nc = NewsCatalogService.GetInstance().Get(nodes[i]); for (int j = 0; j < ids.Length; j++) { string sql = @"insert into cmsNews(RGuid,NodeCode,Title,Content,Summary,Tags,Author,Source,SmallPic,Pics,Hits,AddTime,AddUser,EditTime,EditUser,OrderNo,IsIndex,IsTop,IsAudit,AuditTime,AuditUser,AuditComment,ProductNo,ProductModel,Parameter1,Parameter2,Parameter3,Parameter4,Parameter5,langId) select '{0}','{1}',Title,Content,Summary,Tags,Author,Source,SmallPic,Pics,Hits,AddTime,AddUser,EditTime,EditUser,OrderNo,IsIndex,IsTop,IsAudit,AuditTime,AuditUser,AuditComment,ProductNo,ProductModel,Parameter1,Parameter2,Parameter3,Parameter4,Parameter5,{2} from cmsNews where 1=1 and Id='{3}'"; sql = string.Format(sql, Guid.NewGuid().ToString(), nodes[i], nc.LangId, ids[j]); r = DBSession.CurrentSession.FromSql(sql).ExecuteNonQuery(); } } } catch (Exception ex) { throw ex; } return(r); }