/// <summary>
/// 更新一级菜单内容
/// </summary>
void UpdateClassifyOnePanel()
{
classifyOnePanel.CassifyContent.Clear();
List <DataCell_classify> classifyOneList = SQLDataInterface.SelectClassifyListInfo(0);
for (int i = 0; i < classifyOneList.Count; i++)
{
ClassifyInfo ci = new ClassifyInfo();
ci.Index = i;// classifyOneList[i].Classify_numpos;
ci.ID = classifyOneList[i].Classify_id.ToString();
ci.Name = classifyOneList[i].Classify_name;
ci.ParentID = classifyOneList[i].Classify_parentID.ToString();
classifyOnePanel.CassifyContent.Add(ci);
}
classifyOnePanel.CreateScrollView();
}
public string Add(string jsons)
{
int code = 1; int status = 200; string message = "成功";
ResponseInfo responseInfo = new Models.ResponseInfo();
Data data = new Data();
if (string.IsNullOrEmpty(jsons))
{
code = 1; status = 200; message = "传递的参数不能为空";
//return "{\"status\":\"-1\",\"Message\":\"传递的参数不能为空！\"}";
}
else
{
try
{
ClassifyInfo info = JsonConvert.DeserializeObject <ClassifyInfo>(jsons);
string sql = string.Format(@"insert into Classify(ClassifyName,CreateTime)values('{0}',now())", info.ClassifyName);
MySqlParameter parameters = new MySqlParameter("ClassifyName", info.ClassifyName);
int i = MySqlHelper.ExecuteNonQuery(CommandType.Text, sql, parameters);
if (i > 0)
{
code = 1; status = 200; message = "添加分类成功";
// return "{\"status\":\"1\",\"Message\":\"添加分类成功！\"}";
}
else
{
code = 0; status = 200; message = "添加分类失败";
// return "{\"status\":\"0\",\"Message\":\"添加分类失败！\"}";
}
}
catch (Exception ex)
{
code = 0; status = 500; message = "服务器内部错误：" + ex.Message;
//return "{\"status\":\"-2\",\"Message\":\"异常:\"" + ex.Message + "}";
//throw;
}
}
data.code = code;
data.data = message;
responseInfo.status = status;
responseInfo.data = data;
responseInfo.message = message;
return(JsonConvert.SerializeObject(responseInfo));
}
public string Edit(string jsons)
{
int code = 1; int status = 200; string message = "成功";
ResponseInfo responseInfo = new Models.ResponseInfo();
Data data = new Data();
if (string.IsNullOrEmpty(jsons))
{
message = "传递的参数不能为空";
// return "{\"status\":\"-1\",\"Message\":\"传递的参数不能为空！\"}";
}
else
{
try
{
ClassifyInfo info = JsonConvert.DeserializeObject <ClassifyInfo>(jsons);
string sql = string.Format(@"update Classify set ClassifyName='{1}' where ClassifyID={0}", info.ClassifyID, info.ClassifyName);
MySqlParameter[] mySqlParameters = { new MySqlParameter("ClassifyID", info.ClassifyID), new MySqlParameter("ClassifyName", info.ClassifyName) };
int i = MySqlHelper.ExecuteNonQuery(CommandType.Text, sql, mySqlParameters);
if (i > 0)
{
code = 1; status = 200; message = "编辑分类成功";
// return "{\"status\":\"1\",\"Message\":\"编辑分类成功！\"}";
}
else
{
code = 0; status = 200; message = "编辑分类失败";
// return "{\"status\":\"0\",\"Message\":\"编辑分类失败！\"}";
}
}
catch (Exception ex)
{
code = 0; status = 500; message = "服务器内部错误：" + ex.Message;;
//return "{\"status\":\"-2\",\"Message\":\"异常:\"" + ex.Message + "}";
//throw;
}
}
data.code = code;
data.data = message;
responseInfo.status = status;
responseInfo.data = data;
responseInfo.message = message;
return(JsonConvert.SerializeObject(responseInfo));
}
public void GetVideosJson(string json)
{
// print(json);
ClassifyViteoRoot classifyViteoRoot = JsonConvert.DeserializeObject <ClassifyViteoRoot>(json);
ClassifyInfo classifyInfo = classifyViteoRoot.info;
totalPages = GetTotalPagesCount(classifyInfo.total); //总的页面数
if (classifyVideoItems.Count > 0) //
{
classifyVideoItems.Clear();
}
if (classifyInfo.data.Count == 0)//表示此时的二级界面没有数据
{
LauncherUIManager.instance.NoDataReturned();
}
else//二级界面有数据返回的时候
{
LauncherUIManager.instance.HaveDataReturned();
//赋值
for (int i = 0; i < classifyInfo.data.Count; i++)
{
classifyVideoItems.Add(classifyInfo.data[i]);
VideoItem item = new VideoItem();
item.title = classifyInfo.data[i].title;
item.contentId = classifyInfo.data[i].contentId;
item.subscript = classifyInfo.data[i].description;
// item.title = classifyInfo.data[i].title;
if (!classifyVideosDic.ContainsKey(classifyVideoItems[i].contentId))
{
classifyVideosDic.Add(classifyVideoItems[i].contentId, classifyVideoItems[i]);
}
if (!JsonDataManager.VideosDic.ContainsKey(item.contentId))
{
JsonDataManager.VideosDic.Add(item.contentId, item);
}
}
//正常情况下都是小于等于4的测试时候会走这一步
if (classifyInfo.data.Count > LauncherUIManager.instance.videoButtonList.Count)
{
for (int i = 0; i < 4; i++)
{
LauncherUIManager.instance.videoButtonList[i].name = classifyVideoItems[i].contentId;
RawImage im = LauncherUIManager.instance.videoButtonList[i].transform.
Find("poster").GetComponent <RawImage>();
Text title = LauncherUIManager.instance.videoButtonList[i].transform.
Find("Text").GetComponent <Text>();
title.text = classifyVideoItems[i].title;
SetImage(classifyVideoItems[i].imgM0, im);
}
}
else
{
for (int i = 0; i < LauncherUIManager.instance.videoButtonList.Count; i++)
{
if (i < classifyVideoItems.Count)
{
LauncherUIManager.instance.videoButtonList[i].name = classifyVideoItems[i].contentId;
RawImage im = LauncherUIManager.instance.videoButtonList[i].transform.
Find("poster").GetComponent <RawImage>();
Text title = LauncherUIManager.instance.videoButtonList[i].transform.
Find("Text").GetComponent <Text>();
title.text = classifyVideoItems[i].title;
SetImage(classifyVideoItems[i].imgM0, im);
}
else
{
LauncherUIManager.instance.videoButtonList[i].name = "";
}
}
}
LauncherUIManager.instance.pageShowText.text = LauncherUIManager.instance.currentPageIndex + "/" + totalPages.ToString();
}
}
/// <summary>
/// 更新二级菜单内容
/// </summary>
void UpdateClassifyTwoPanel(string parentid)
{
classifyTwoPanel.CassifyContent.Clear();
List<DataCell_classify> classifyOneList = SQLDataInterface.SelectClassifyListInfo(int.Parse(parentid));
for (int i = 0; i < classifyOneList.Count; i++)
{
ClassifyInfo ci = new ClassifyInfo();
ci.Index = i;// classifyOneList[i].Classify_numpos;
ci.ID = classifyOneList[i].Classify_id.ToString();
ci.Name = classifyOneList[i].Classify_name;
ci.ParentID = classifyOneList[i].Classify_parentID.ToString();
classifyTwoPanel.CassifyContent.Add(ci);
}
classifyTwoPanel.CreateScrollView();
}
