//根据对象获加载物体
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);
}
}
