Пример #1
0
        /// <summary>
        /// 查询商品
        /// </summary>
        /// <returns></returns>
        public string GetPro()
        {
            DataSet             dt         = new DataSet();
            List <SqlParameter> parameters = new List <SqlParameter>();
            string sqlWhere  = "  AID =@AID ";
            var    parameter = new SqlParameter("@AID", DbType.AnsiString);

            parameter.Value = hidAId.Value;
            parameters.Add(parameter);
            dt = cmProDal.GetListPro(sqlWhere, parameters);
            StringBuilder strBuilder = new StringBuilder();

            if (dt != null)
            {
                if (dt.Tables[0].Rows.Count > 0)
                {
                    for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
                    {
                        strBuilder.Append(" <tr id='tr2'>");
                        strBuilder.Append("   <td>" + dt.Tables[0].Rows[i]["Title"] + "</td>");
                        var orgInfo = orgDal.GetModel(Convert.ToInt64(dt.Tables[0].Rows[i]["OrgId"]));
                        strBuilder.Append("   <td>" + orgInfo.OrgName + "</td>");
                        strBuilder.Append("   <td style=\"width: 15%; text-align: center\">");
                        strBuilder.Append("      <a href=\"javascript:void(0);\" onclick=\"delProAId(this,'" + dt.Tables[0].Rows[i]["AID"] + "','" + dt.Tables[0].Rows[i]["PID"] + "');return false;\" data-backdrop=\"false\">删除</a>");
                        strBuilder.Append("  </td>");
                        strBuilder.Append(" </tr>");
                    }
                }
            }
            return(strBuilder.ToString());
        }