/// <summary> /// 綁定市區 /// </summary> private void GetArea() { DAL.AreaDal dalare = new DAL.AreaDal(); int count = 0; var table = dalare.GetDatalistpage(99999, 1, " parent=0", " sort", out count); if (table.Tables.Count > 0) { foreach (DataRow dr in table.Tables[0].Rows) { string Id = dr["id"].ToString(); string Title = dr["title"].ToString().Trim(); ddlAreaid.Items.Add(new ListItem(Title, Id)); var table2 = dalare.GetDatalistpage(99999, 1, " parent=" + Id, " sort", out count); if (table2.Tables.Count > 0) { foreach (DataRow dr2 in table2.Tables[0].Rows) { string Id2 = dr2["id"].ToString(); string Title2 = dr2["title"].ToString().Trim(); Title2 = "├ " + Title2; Title2 = Utils.StringOfChar(2 - 1, " ") + Title2; ddlAreaid.Items.Add(new ListItem(Title2, Id2)); } } } } }
private void ShowInfo(int _id) { DAL.AreaDal bll = new DAL.AreaDal(); Model.Area model = bll.GetModel(_id); txtTitle.Text = model.title; txtSortId.Text = model.sort; ddlParent.SelectedValue = model.parent.ToString(); txtCode.Text = model.code; }
//刪除操作 protected void btnDelete_Click(object sender, EventArgs e) { ChkAdminLevel("sys_model", DTEnums.ActionEnum.Delete.ToString()); //檢查許可權 DAL.AreaDal aredal = new DAL.AreaDal(); //批次刪除 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) { aredal.Delete(id); } } JscriptMsg("批次刪除成功!", Utils.CombUrlTxt("Area_list.aspx", "keywords={0}", txtKeywords.Text.Trim()), "Success", "parent.loadChannelTree"); }
private bool DoAdd() { bool result = true; Model.Area model = new Model.Area(); DAL.AreaDal bll = new DAL.AreaDal(); model.title = txtTitle.Text.Trim(); model.sort = txtSortId.Text.Trim(); model.parent = int.Parse(ddlParent.SelectedValue.Trim()); model.code = txtCode.Text.Trim(); if (bll.Add(model) < 1) { result = false; } return(result); }
private bool DoEdit(int _id) { bool result = true; DAL.AreaDal bll = new DAL.AreaDal(); Model.Area model = bll.GetModel(_id); model.title = txtTitle.Text.Trim(); model.sort = txtSortId.Text.Trim(); model.parent = int.Parse(ddlParent.SelectedValue.Trim()); model.code = txtCode.Text.Trim(); if (!bll.Update(model)) { result = false; } return(result); }
public void GetParent() { int totalCount = 0; DAL.AreaDal aredal = new DAL.AreaDal(); string where = "parent=" + Pid + ""; if (this.id > 0) { where += "and id <> " + id; } var table = aredal.GetDatalistpage(99999, 1, where, " sort", out totalCount).Tables[0]; ddlParent.DataSource = table; ddlParent.DataTextField = "title"; ddlParent.DataValueField = "id"; ddlParent.DataBind(); ddlParent.Items.Insert(0, new ListItem() { Text = "請選擇", Value = "0", Selected = true }); }