Example #1
0
        ///<summary>
        ///根据Province对象查询Province
        ///</summary>
        ///<param name="Model"></param>
        /// <returns></returns>
        public String Get_Province_By_Province(Province Model,string type)
        {
            try
            {
               string strSql="";
                DataAccessor<Province> tableAccessor;
               // if (string.IsNullOrEmpty(type))
               // {
                    strSql = string.Format("select * from Province s where 1=1 ");

               // } else {
                //    strSql = string.Format("select * from Province s where 1=1 and s.Id=s.ParentId");

                //}

                if (!string.IsNullOrEmpty(Model.Id))
                {

                    strSql += string.Format(" and s.Id='{0}'", Model.Id);
                }
                if (!string.IsNullOrEmpty(Model.Name))
                {

                    strSql += string.Format(" and s.Name='{0}'", Model.Name);
                }
                if (!string.IsNullOrEmpty(Model.ParentId))
                {

                    strSql += string.Format(" and s.ParentId='{0}'", Model.ParentId);
                }
                if (Model.SortNo != null)
                {
                    strSql += string.Format(" and s.SortNo='{0}'", Model.SortNo);
                }
                if (Model.IsUse != null)
                {
                    strSql += string.Format(" and s.IsUse='{0}'", Model.IsUse);
                }
                tableAccessor = db.CreateSqlStringAccessor(strSql, MapBuilder<Province>.MapAllProperties().Build());
                List<Province> result = tableAccessor.Execute().ToList();
                string html = "";
                if (string.IsNullOrEmpty(type))
                {
                    html = string.Format("<select name='province' onchange='GetCity(this.value)'> <option value='-1'>--省--</option>");
                }
                else {
                    html = string.Format("<select name='province' onchange='page(this.value,this.options[this.selectedIndex].innerText)'> <option value='-1'>--市--</option>");

                }
                    if (result.Count > 0)
                    {
                        for (int i = 0; i < result.Count; i++)
                        {
                            html += string.Format(" <option value='{0}'>{1}</option>", result[i].Id, result[i].Name);
                        }
                    }
                   html += string.Format(" </select>");

               // else {

                //  html += string.Format("<nav id='city'>");
                  // if (result.Count > 0)
                //    {
                //        for (int i = 0; i < result.Count; i++)
                //        {
                //            html += string.Format(" <a href='javascript:void(0)' onclick='page('{0}')' >{1}</a>", result[i].Id,result[i].Name);
                //        }
                //    }
                //    html += string.Format(" </nav>");
                //}

                return html;

            }
            catch
            {
                return null;
            }
        }
Example #2
0
        ///<summary>
        ///显示省、城市
        ///</summary>
        ///<param name="Model"></param>
        /// <returns></returns>
        public string Get_Province_By_Province(string id = null)
        {
            Province p = new Province();
            ProvinceModel model = new ProvinceModel();
            if (string.IsNullOrEmpty(id))
            {
                p.ParentId = "###";

            }
            else
            {
                p.ParentId = id;

            }
            p.IsUse = true;
            return model.Get_Province_By_Province(p, id);
        }