//根据对象获加载物体 public GameObject GetCat(CatType catType) { GameObject cat; for (int i = 0; i < catPoolList.Count; i++) { var ccCat = catPoolList[i].GetComponent <Cat>(); if (ccCat.catType == catType) { cat = catPoolList[i]; catPoolList.Remove(cat); cat.SetActive(true); ccCat.ResetWriteCat(); //catPoolList[i].GetComponent<Cat>().ResetWriteCat(); return(cat); } } //如果这个物体在对象池里,就直接返回,如果不在就创建 cat = new GameObject("Cat_" + catType.ToString()); //GameObject obj = Resources.Load<GameObject>("Cat/Cat"); //cat = GameObject.Instantiate(obj) as GameObject; //cat.name = "Cat_" + catType.ToString(); cat.AddComponent <Cat>().catType = catType; SpriteRenderer render = cat.AddComponent <SpriteRenderer>(); render.sprite = defaultSpriteList[(int)catType]; render.sortingLayerName = "actor"; return(cat); }
public CatAsset getCatAsset() { if (catAsset == null) { catAsset = Resources.Load <CatAsset>("CatAssets/" + catType.ToString()); } return(catAsset); }
public static void InsertArticle2Category(int articleId, CatType catType, List <int> ids) { //首先根据文章ID和类型删除对应的数据 StringBuilder sbSQL = new StringBuilder(); sbSQL.AppendFormat("DELETE Article2Category WHERE ArticleId = {0} AND [Type] = '{1}'", articleId, catType.ToString().ToLower()); SQLPlus.ExecuteNonQuery(CommandType.Text, sbSQL.ToString()); if (ids.Count > 0) { sbSQL = new StringBuilder(); //在插入 sbSQL.Append("INSERT INTO Article2Category(ArticleId,CategoryId,[Type]) VALUES"); foreach (int id in ids) { sbSQL.AppendFormat("({0},{1},'{2}'),", articleId, id, catType.ToString().ToLower()); } string strSQL = Regex.Replace(sbSQL.ToString(), @",$", "", RegexOptions.IgnoreCase); SQLPlus.ExecuteNonQuery(CommandType.Text, strSQL); } }
public static List <int> Article2CategoryListByArticleIdAndType(int articleId, CatType catType) { string strSQL = string.Format("SELECT CategoryId FROM Article2Category WITH(NOLOCK) WHERE ArticleId = {0} AND [Type] = '{1}'", articleId, catType.ToString().ToLower()); List <int> ids = new List <int>(); if (articleId == 0) { return(ids); } DataTable dt = SQLPlus.ExecuteDataTable(CommandType.Text, strSQL); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { ids.Add(dr.Field <int>("CategoryId")); } } return(ids); }
public static List<int> Article2CategoryListByArticleIdAndType(int articleId, CatType catType) { string strSQL = string.Format("SELECT CategoryId FROM Article2Category WITH(NOLOCK) WHERE ArticleId = {0} AND [Type] = '{1}'",articleId,catType.ToString().ToLower()); List<int> ids = new List<int>(); if (articleId == 0) { return ids; } DataTable dt = SQLPlus.ExecuteDataTable(CommandType.Text,strSQL); if(dt != null && dt.Rows.Count>0){ foreach(DataRow dr in dt.Rows){ ids.Add(dr.Field<int>("CategoryId")); } } return ids; }
public static void InsertArticle2Category(int articleId,CatType catType,List<int> ids) { //首先根据文章ID和类型删除对应的数据 StringBuilder sbSQL = new StringBuilder(); sbSQL.AppendFormat("DELETE Article2Category WHERE ArticleId = {0} AND [Type] = '{1}'", articleId, catType.ToString().ToLower()); SQLPlus.ExecuteNonQuery(CommandType.Text,sbSQL.ToString()); if (ids.Count > 0) { sbSQL = new StringBuilder(); //在插入 sbSQL.Append("INSERT INTO Article2Category(ArticleId,CategoryId,[Type]) VALUES"); foreach(int id in ids){ sbSQL.AppendFormat("({0},{1},'{2}'),",articleId,id,catType.ToString().ToLower()); } string strSQL = Regex.Replace(sbSQL.ToString(),@",$","",RegexOptions.IgnoreCase); SQLPlus.ExecuteNonQuery(CommandType.Text,strSQL); } }