private string boolStr(string loginName) { StringBuilder str = new StringBuilder(); DataSet ds = bll.GetList("tzparId=0"); string ids = ""; if ((ds != null) && ds.Tables[0].Rows.Count > 0) { for (int i = 0; i < ds.Tables[0].Rows.Count; i++)//大类 { bool flag = false; dr = ds.Tables[0].Rows[i]; ids = dr["tztypeId"].ToString() + ","; string[] strId = ids.Split(','); string strIDs = ""; for (int b = 0; b < strId.Length - 1; b++) { DataSet ds1 = bll.GetList(" tzparId =" + int.Parse(strId[b])); if ((ds1 != null) && ds1.Tables[0].Rows.Count > 0) { for (int j = 0; j < ds1.Tables[0].Rows.Count; j++) { dr = ds1.Tables[0].Rows[j]; strIDs += dr["tztypeId"].ToString() + ","; } string[] strChild = strIDs.Split(','); DataSet ds2 = childBll.GetList(" tztypeid in(" + strIDs.Substring(0, strIDs.Length - 1) + ")" + " and loginname='" + loginName + "'"); if ((ds2 != null) && ds2.Tables[0].Rows.Count > 0) { for (int c = 0; c < ds2.Tables[0].Rows.Count; c++) { dr = ds2.Tables[0].Rows[c]; if (!string.IsNullOrEmpty(dr["typeprice"].ToString()) && dr["typeprice"].ToString() != "0" && dr["typeprice"].ToString() != "0.00" && Convert.ToInt32(dr["typeprice"]) != 0) { flag = true; break; } } } } } str.Append(flag + ","); } } return(str.ToString()); }
/// <summary> /// 投资成本 ///author: desgin by longbin ///createdate: 2011-05-09 ///description: 根据用户名获取投资成本(index) /// </summary> /// <param name="loginName"></param> /// <returns></returns> public string GetInvestListUIByLoginName(string loginName) { // TzchildTypDAL dal = new TzchildTypDAL(); TzbigTypeDAL dal = new TzbigTypeDAL(); StringBuilder str = new StringBuilder(); //DataSet ds = dal.GetList(" loginName='" + loginName + "'"); DataSet ds = dal.GetList(""); if ((ds != null) && (ds.Tables[0].Rows.Count > 0)) { str.Append("<ul>"); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { DataRow dr = ds.Tables[0].Rows[i]; string str1 = ""; if (dr["tztypeName"].ToString().Length > 5) { str1 = dr["tztypeName"].ToString().Substring(0, 5) + ".."; } else { str1 = dr["tztypeName"].ToString(); } str.Append("<li><a target='_blank' href='http://" + loginName + ".topfo.com/cost.htm'>"); str.Append(str1); str.Append("</a></li>"); } str.Append("</ul>"); } return(str.ToString()); }
/// <summary> /// 获得数据列表 /// </summary> public DataSet GetList(string strWhere) { return(dal.GetList(strWhere)); }