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