public QA_CategoryShow MapQA_Category(DataRow input) { QA_CategoryShow ret = new QA_CategoryShow(); if (input["DR"].ToString() != "") { ret.DR = int.Parse(input["DR"].ToString()); } ret.Name = input["Name"].ToString(); if (input["ParentSysNo"].ToString() != "") { ret.ParentSysNo = int.Parse(input["ParentSysNo"].ToString()); } if (input["SysNo"].ToString() != "") { ret.SysNo = int.Parse(input["SysNo"].ToString()); } if (input["TopSysNo"].ToString() != "") { ret.TopSysNo = int.Parse(input["TopSysNo"].ToString()); } if (input["TS"].ToString() != "") { ret.TS = DateTime.Parse(input["TS"].ToString()); } ret.Pic = input["Pic"].ToString(); ret.Intro = input["Intro"].ToString(); if (input["OrderID"].ToString() != "") { ret.OrderID = int.Parse(input["OrderID"].ToString()); } return(ret); }
public ReturnValue <List <QA_CategoryShow> > GetCates(int parent) { DataTable m_dt = QA_CategoryBll.GetInstance().GetCates(parent); if (m_dt == null || m_dt.Rows.Count == 0) { throw new BusinessException("该分类下无子分类"); } List <QA_CategoryShow> ret = new List <QA_CategoryShow>(); DataTable questnum = QA_CategoryBll.GetInstance().GetCatesPostNum().Tables[0]; DataTable postnum = QA_CategoryBll.GetInstance().GetCatesPostNum().Tables[1]; for (int i = 0; i < m_dt.Rows.Count; i++) { QA_CategoryShow tmp_cate = MapQA_Category(m_dt.Rows[i]); if (!string.IsNullOrEmpty(tmp_cate.Pic)) { tmp_cate.Pic = Container.ConfigService.GetAppSetting <string>("WebResourcesPath", "") + "img/CatePic/" + tmp_cate.Pic; } if (tmp_cate.TopSysNo == 1) { tmp_cate.Pic = tmp_cate.Pic.Replace("pp", "p").Replace("jpg", "png"); } for (int j = 0; j < questnum.Rows.Count; j++) { if (questnum.Rows[j]["CateSysNo"].ToString() == tmp_cate.SysNo.ToString()) { tmp_cate.QuestNum = tmp_cate.QuestNum + int.Parse(questnum.Rows[j]["questnum"].ToString()); if (questnum.Rows[j]["IsSolved"].ToString() == "1") { tmp_cate.SolvedNum = tmp_cate.QuestNum; } } } for (int j = 0; j < postnum.Rows.Count; j++) { if (postnum.Rows[j]["CateSysNo"].ToString() == tmp_cate.SysNo.ToString()) { tmp_cate.Replys = int.Parse(tmp_cate.QuestNum.ToString()) + int.Parse(postnum.Rows[j]["AnswerNum"].ToString()) + int.Parse(postnum.Rows[j]["CommentNum"].ToString()); } } ret.Add(tmp_cate); } return(ReturnValue <List <QA_CategoryShow> > .Get200OK(ret)); }
public QA_CategoryShow MapQA_Category(DataRow input) { QA_CategoryShow ret = new QA_CategoryShow(); if (input["DR"].ToString() != "") { ret.DR = int.Parse(input["DR"].ToString()); } ret.Name = input["Name"].ToString(); if (input["ParentSysNo"].ToString()!="") { ret.ParentSysNo = int.Parse(input["ParentSysNo"].ToString()); } if (input["SysNo"].ToString() != "") { ret.SysNo = int.Parse(input["SysNo"].ToString()); } if (input["TopSysNo"].ToString() != "") { ret.TopSysNo = int.Parse(input["TopSysNo"].ToString()); } if (input["TS"].ToString() != "") { ret.TS = DateTime.Parse(input["TS"].ToString()); } ret.Pic = input["Pic"].ToString(); ret.Intro = input["Intro"].ToString(); if (input["OrderID"].ToString() != "") { ret.OrderID = int.Parse(input["OrderID"].ToString()); } return ret; }