private void GetAreaListByName(HttpContext context)
{
//检查是否重复点击
context.Response.Cache.SetCacheability(HttpCacheability.NoCache);
//获取城市ID
int area_id = DTRequest.GetQueryInt("id");
string json_result = string.Empty;
if (area_id == 0)
{
json_result = "{\"status\":\"false\",\"data\":\"参数不能为0\"}";
context.Response.Write(json_result);
context.Response.End();
}
DataTable dt_area = null;
string json_area = "[]";
BLL.cityinfo bll_city = new BLL.cityinfo();
//获取频道一级分类列表
dt_area = bll_city.GetChildList(area_id, 0);
//分类反序列化为JSON
if (dt_area != null && dt_area.Rows.Count > 0)
{
json_area = Common.ObjToJson.ToJson(dt_area, new string[2] { "id", "title" });
}
json_result = "{\"status\":\"true\",\"area_data\":" + json_area + "}";
context.Response.Write(json_result);
//返回JSON
context.Response.End();
return;
}
//保存排序
protected void btnSave_Click(object sender, EventArgs e)
{
BLL.cityinfo bll = new BLL.cityinfo();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
int sortId;
if (!int.TryParse(((TextBox)rptList.Items[i].FindControl("txtSortId")).Text.Trim(), out sortId))
{
sortId = 99;
}
bll.UpdateField(id, "sort_id=" + sortId.ToString());
}
JscriptMsg("保存排序成功啦！", Utils.CombUrlTxt("list.aspx", "channel_id={0}&sign_type={1}", this.channel_id.ToString(), this.sign_type), "Success");
}
//删除类别
protected void btnDelete_Click(object sender, EventArgs e)
{
// ChkAdminLevel(channel_id, DTEnums.ActionEnum.Delete.ToString()); //检查权限
BLL.cityinfo bll = new BLL.cityinfo();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked)
{
bll.Delete(id);
}
}
JscriptMsg("批量删除成功啦！", Utils.CombUrlTxt("list.aspx", "channel_id={0}&sign_type={1}", this.channel_id.ToString(), this.sign_type), "Success");
}
private bool DoAdd()
{
try
{
Model.cityinfo model = new Model.cityinfo();
BLL.cityinfo bll = new BLL.cityinfo();
model.channel_id = this.channel_id;
model.call_index = txtCallIndex.Text.Trim();
model.title = txtTitle.Text.Trim();
model.parent_id = int.Parse(ddlParentId.SelectedValue);
model.sort_id = int.Parse(txtSortId.Text.Trim());
model.seo_title = txtSeoTitle.Text;
model.seo_keywords = txtSeoKeywords.Text;
model.seo_description = txtSeoDescription.Text;
model.link_url = txtLinkUrl.Text.Trim();
model.img_url = txtImgUrl.Text.Trim();
model.content = txtContent.Value;
if (bll.Add(model) < 1)
{
return false;
}
}
catch
{
return false;
}
return true;
}
private void TreeBind(int _channel_id)
{
BLL.cityinfo bll = new BLL.cityinfo();
DataTable dt = bll.GetList(0, _channel_id);
this.ddlParentId.Items.Clear();
this.ddlParentId.Items.Add(new ListItem("无父级分类", "0"));
foreach (DataRow dr in dt.Rows)
{
string Id = dr["id"].ToString();
int ClassLayer = int.Parse(dr["class_layer"].ToString());
string Title = dr["title"].ToString().Trim();
if (ClassLayer == 1)
{
this.ddlParentId.Items.Add(new ListItem(Title, Id));
}
else
{
Title = "├ " + Title;
Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title;
this.ddlParentId.Items.Add(new ListItem(Title, Id));
}
}
}
private void ShowInfo(int _id)
{
BLL.cityinfo bll = new BLL.cityinfo();
Model.cityinfo model = bll.GetModel(_id);
ddlParentId.SelectedValue = model.parent_id.ToString();
txtCallIndex.Text = model.call_index;
txtTitle.Text = model.title;
txtSortId.Text = model.sort_id.ToString();
txtSeoTitle.Text = model.seo_title;
txtSeoKeywords.Text = model.seo_keywords;
txtSeoDescription.Text = model.seo_description;
txtLinkUrl.Text = model.link_url;
txtImgUrl.Text = model.img_url;
txtContent.Value = model.content;
}
private bool DoEdit(int _id)
{
try
{
BLL.cityinfo bll = new BLL.cityinfo();
Model.cityinfo model = bll.GetModel(_id);
int parentId = int.Parse(ddlParentId.SelectedValue);
model.channel_id = this.channel_id;
model.call_index = txtCallIndex.Text.Trim();
model.title = txtTitle.Text.Trim();
//如果选择的父ID不是自己,则更改
if (parentId != model.id)
{
model.parent_id = parentId;
}
model.sort_id = int.Parse(txtSortId.Text.Trim());
model.seo_title = txtSeoTitle.Text;
model.seo_keywords = txtSeoKeywords.Text;
model.seo_description = txtSeoDescription.Text;
model.link_url = txtLinkUrl.Text.Trim();
model.img_url = txtImgUrl.Text.Trim();
model.content = txtContent.Value;
if (!bll.Update(model))
{
return false;
}
}
catch
{
return false;
}
return true;
}
private void CityBind(int _province, int _city)
{
DataTable dt_province = null;
DataTable dt_city = null;
DataTable dt_area = null;
BLL.cityinfo bll_city = new BLL.cityinfo();
dt_province = bll_city.GetChildList(0, 0);
this.ddlProvince.Items.Clear();
//this.ddlProvince.Items.Add(new ListItem("请选择省名称...", ""));
foreach (DataRow dr in dt_province.Rows)
{
string Id = dr["id"].ToString();
int ClassLayer = int.Parse(dr["class_layer"].ToString());
string Title = dr["title"].ToString().Trim();
this.ddlProvince.Items.Add(new ListItem(Title, Id));
}
dt_city = bll_city.GetChildList(_province, 0);
this.ddlCity.Items.Clear();
foreach (DataRow dr in dt_city.Rows)
{
string Id = dr["id"].ToString();
int ClassLayer = int.Parse(dr["class_layer"].ToString());
string Title = dr["title"].ToString().Trim();
this.ddlCity.Items.Add(new ListItem(Title, Id));
}
dt_area = bll_city.GetChildList(_city, 0);
this.ddlArea.Items.Clear();
foreach (DataRow dr in dt_area.Rows)
{
string Id = dr["id"].ToString();
int ClassLayer = int.Parse(dr["class_layer"].ToString());
string Title = dr["title"].ToString().Trim();
this.ddlArea.Items.Add(new ListItem(Title, Id));
}
}
//数据绑定
private void RptBind()
{
BLL.cityinfo bll = new BLL.cityinfo();
DataTable dt = bll.GetList(0, 0);
this.rptList.DataSource = dt;
this.rptList.DataBind();
}
private void TreeBind(int _channel_id)
{
BLL.category bll = new BLL.category();
BLL.cityinfo bll_city = new BLL.cityinfo();
DataTable dt_grouptype, dt_property, dt_language, dt_pay, dt_account,dt_world = null;
DataTable dt_city = null;
#region 绑定旅团类型
dt_grouptype = bll.GetList(0, _channel_id, DTEnums.CategoryEnum.tourgroup.ToString());
this.ddlGroupType.Items.Clear();
foreach (DataRow dr in dt_grouptype.Rows)
{
string Id = dr["id"].ToString();
int ClassLayer = int.Parse(dr["class_layer"].ToString());
string Title = dr["title"].ToString().Trim();
if (ClassLayer == 1)
{
this.ddlGroupType.Items.Add(new ListItem(Title, Id));
}
else
{
Title = "├ " + Title;
Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title;
this.ddlGroupType.Items.Add(new ListItem(Title, Id));
}
}
#endregion
#region 绑定语种
dt_language = bll.GetList(0, _channel_id, DTEnums.CategoryEnum.language.ToString());
this.ddlLanguage.Items.Clear();
this.ddlLanguage.Items.Add(new ListItem("请选择语种...", "0"));
foreach (DataRow dr in dt_language.Rows)
{
string Id = dr["id"].ToString();
int ClassLayer = int.Parse(dr["class_layer"].ToString());
string Title = dr["title"].ToString().Trim();
if (ClassLayer == 1)
{
this.ddlLanguage.Items.Add(new ListItem(Title, Id));
}
else
{
Title = "├ " + Title;
Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title;
this.ddlLanguage.Items.Add(new ListItem(Title, Id));
}
}
#endregion
#region 绑定账单周期
dt_account = bll.GetList(0, _channel_id, DTEnums.CategoryEnum.period.ToString());
this.ddlAccount.Items.Clear();
this.ddlAccount.Items.Add(new ListItem("请选择账单周期...", "0"));
foreach (DataRow dr in dt_account.Rows)
{
string Id = dr["id"].ToString();
int ClassLayer = int.Parse(dr["class_layer"].ToString());
string Title = dr["title"].ToString().Trim();
if (ClassLayer == 1)
{
this.ddlAccount.Items.Add(new ListItem(Title, Id));
}
else
{
Title = "├ " + Title;
Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title;
this.ddlAccount.Items.Add(new ListItem(Title, Id));
}
}
#endregion
#region 绑定支付类型
dt_pay = bll.GetList(0, _channel_id, DTEnums.CategoryEnum.pay.ToString());
this.ddlRestaurant.Items.Clear();
this.ddlRestaurant.Items.Add(new ListItem("请选择餐厅支付类型...", "0"));
this.ddlTicketType.Items.Clear();
this.ddlTicketType.Items.Add(new ListItem("请选择门票支付类型...", "0"));
foreach (DataRow dr in dt_pay.Rows)
{
string Id = dr["id"].ToString();
int ClassLayer = int.Parse(dr["class_layer"].ToString());
string Title = dr["title"].ToString().Trim();
if (ClassLayer == 1)
{
this.ddlRestaurant.Items.Add(new ListItem(Title, Id));
this.ddlTicketType.Items.Add(new ListItem(Title, Id));
}
else
{
Title = "├ " + Title;
Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title;
this.ddlRestaurant.Items.Add(new ListItem(Title, Id));
this.ddlTicketType.Items.Add(new ListItem(Title, Id));
}
}
#endregion
#region 绑定团属
dt_property = bll.GetList(0, _channel_id, DTEnums.CategoryEnum.groupteam.ToString());
this.ddlProperty.Items.Clear();
this.ddlProperty.Items.Add(new ListItem("请选择团属...", "0"));
foreach (DataRow dr in dt_property.Rows)
{
string Id = dr["id"].ToString();
int ClassLayer = int.Parse(dr["class_layer"].ToString());
string Title = dr["title"].ToString().Trim();
if (ClassLayer == 1)
{
this.ddlProperty.Items.Add(new ListItem(Title, Id));
}
else
{
Title = "├ " + Title;
Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title;
this.ddlProperty.Items.Add(new ListItem(Title, Id));
}
}
#endregion
#region 绑定国际线路
//world
dt_world = bll.GetList(0, _channel_id, DTEnums.CategoryEnum.world.ToString());
this.ddlLineCity.Items.Clear();
this.ddlLineCity.Items.Add(new ListItem("请选择线路...", "0"));
foreach (DataRow dr in dt_world.Rows)
{
string Id = dr["id"].ToString();
int ClassLayer = int.Parse(dr["class_layer"].ToString());
string Title = dr["title"].ToString().Trim();
if (ClassLayer == 1)
{
this.ddlLineCity.Items.Add(new ListItem(Title, Id));
}
else
{
Title = "├ " + Title;
Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title;
this.ddlLineCity.Items.Add(new ListItem(Title, Id));
}
}
#endregion
#region 绑定城市
dt_city = bll_city.GetChildList(0, _channel_id);
this.ddlFromCity.Items.Clear();
this.ddlFromCity.Items.Add(new ListItem("请选择省市...", ""));
this.ddlToCity.Items.Clear();
this.ddlToCity.Items.Add(new ListItem("请选择省市...", ""));
foreach (DataRow dr in dt_city.Rows)
{
string Id = dr["id"].ToString();
int ClassLayer = int.Parse(dr["class_layer"].ToString());
string Title = dr["title"].ToString().Trim();
if (ClassLayer == 1)
{
this.ddlFromCity.Items.Add(new ListItem(Title, Id));
this.ddlToCity.Items.Add(new ListItem(Title, Id));
}
else
{
Title = "├ " + Title;
Title = Utils.StringOfChar(ClassLayer - 1, " ") + Title;
this.ddlFromCity.Items.Add(new ListItem(Title, Id));
this.ddlToCity.Items.Add(new ListItem(Title, Id));
}
}
#endregion
}
protected void Button1_Click(object sender, EventArgs e)
{
BLL.exportCity bll_export = new BLL.exportCity();
Model.exportCity model_export= new Model.exportCity();
DataSet ds_province = null;
DataSet ds_city = null;
DataSet ds_area = null;
DataTable dt_province = null;
DataTable dt_city = null;
DataTable dt_area = null;
BLL.cityinfo bll_cityinfo = new BLL.cityinfo();
Model.cityinfo model_province = null;
Model.cityinfo model_city = null;
Model.cityinfo model_area = null;
int return_province = 0;
int return_city = 0;
//查找省级数据
ds_province = bll_export.GetProvinceList("");
dt_province = ds_province.Tables[0];
//循环省级数据
for (int i = 0; i < dt_province.Rows.Count; i++)
{
model_province = new Model.cityinfo();
model_province.title = dt_province.Rows[i]["name"].ToString().Trim().Replace(" ","");
model_province.call_index = dt_province.Rows[i]["code"].ToString();
model_province.sort_id = 99;
model_province.parent_id = 0;
model_province.channel_id = 0;
return_province = bll_cityinfo.Add(model_province);
model_export.provinceId = dt_province.Rows[i]["code"].ToString();
ds_city = bll_export.GetCityListByProID(model_export.provinceId);
dt_city = ds_city.Tables[0];
for (int j = 0; j < dt_city.Rows.Count; j++)
{
model_city = new Model.cityinfo();
model_city.channel_id = 0;
model_city.title = dt_city.Rows[j]["name"].ToString().Trim().Replace(" ", "");
model_city.call_index = dt_city.Rows[j]["code"].ToString();
model_city.sort_id = 99;
model_city.parent_id = return_province;
return_city = bll_cityinfo.Add(model_city);
model_export.cityId = dt_city.Rows[j]["code"].ToString();
ds_area = bll_export.GetAreaListByCityID(model_export.cityId);
dt_area = ds_area.Tables[0];
for (int k = 0; k < dt_area.Rows.Count; k++)
{
model_area = new Model.cityinfo();
model_area.title = dt_area.Rows[k]["name"].ToString().Trim().Replace(" ", "");
model_area.call_index = dt_area.Rows[k]["code"].ToString();
model_area.sort_id = 99;
model_area.channel_id = 0;
model_area.parent_id = return_city;
bll_cityinfo.Add(model_area);
}
}
}
//根据省级的编号 查下城市数据
//循环市数据
//查找区级
//循环区级，做
}
