///<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;
}
}
///<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);
}