private void TreeBind() { BLL.village bll = new BLL.village(); DataTable dt = bll.GetList(0); 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["name"].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 RoleBind(DropDownList ddl, int role_type) { BLL.manager_role bll = new BLL.manager_role(); DataTable dt = bll.GetList("").Tables[0]; ddl.Items.Clear(); ddl.Items.Add(new ListItem("请选择角色...", "")); foreach (DataRow dr in dt.Rows) { if (Convert.ToInt32(dr["role_type"]) >= role_type) { ddl.Items.Add(new ListItem(dr["role_name"].ToString(), dr["id"].ToString())); } } BLL.village villageBll = new BLL.village(); DataTable dtVillage = villageBll.GetParentList(0); ddlTown.Items.Clear(); ddlTown.Items.Add(new ListItem("请选择所属乡镇", "0")); foreach (DataRow dr in dtVillage.Rows) { string Id = dr["id"].ToString(); string Title = dr["name"].ToString().Trim(); ddlTown.Items.Add(new ListItem(Title, Id)); } }
private bool DoEdit(int _id) { try { BLL.village bll = new BLL.village(); Model.village model = bll.GetModel(_id); int parentId = int.Parse(ddlParentId.SelectedValue); model.name = txtName.Text.Trim(); //如果选择的父ID不是自己,则更改 if (parentId != model.id) { model.parent_id = parentId; } model.sort_id = int.Parse(txtSortId.Text.Trim()); if (bll.Update(model)) { AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改层级分类:" + model.name); //记录日志 return(true); } } catch { return(false); } return(false); }
//数据绑定 private void RptBind() { BLL.village bll = new BLL.village(); DataTable dt = bll.GetList(0); this.rptList.DataSource = dt; this.rptList.DataBind(); }
public void village_Change_Click(object sender, EventArgs e) { BLL.village bll = new BLL.village(); if (ddlVillage.SelectedValue != "0") { var name = bll.GetName(Utils.StrToInt(ddlVillage.SelectedValue, 0)); txtVillage.Text = name; } }
private void ShowInfo(int _id) { BLL.village bll = new BLL.village(); Model.village model = bll.GetModel(_id); ddlParentId.SelectedValue = model.parent_id.ToString(); txtName.Text = model.name; txtSortId.Text = model.sort_id.ToString(); }
protected void Page_Load(object sender, EventArgs e) { List <string> xData = new List <string>(); List <int> yData = new List <int>(); var bll = new BLL.member(); var ds = bll.GetListByType().Tables[0]; foreach (DataRow dr in ds.Rows) { if (dr["type"].ToString() == "0") { xData.Add("常规会员"); } else { xData.Add("贫困户会员"); } yData.Add(Utils.StrToInt(dr["count"].ToString(), 0)); } Chart1.Series[0]["PieLabelStyle"] = "Outside"; //将文字移到外侧 Chart1.Series[0]["PieLineColor"] = "Black"; //绘制黑色的连线。 Chart1.Series[0].Points.DataBindXY(xData, yData); List <string> xLevelData = new List <string>(); List <int> yLevelData = new List <int>(); var dsLevel = bll.GetListByLevel().Tables[0]; var bllLevel = new BLL.member_level(); foreach (DataRow dr in dsLevel.Rows) { var level = bllLevel.GetName(Utils.StrToInt(dr["level"].ToString(), 0)); xLevelData.Add(level); yLevelData.Add(Utils.StrToInt(dr["count"].ToString(), 0)); } Chart2.Series[0]["PieLabelStyle"] = "Outside"; //将文字移到外侧 Chart2.Series[0]["PieLineColor"] = "Black"; //绘制黑色的连线。 Chart2.Series[0].Points.DataBindXY(xLevelData, yLevelData); List <string> xTownData = new List <string>(); List <int> yTownData = new List <int>(); var dsTown = bll.GetListByTown().Tables[0]; foreach (DataRow dr in dsTown.Rows) { var villageBll = new BLL.village(); var town = villageBll.GetName(Utils.StrToInt(dr["town"].ToString(), 0)); xTownData.Add(town); yTownData.Add(Utils.StrToInt(dr["count"].ToString(), 0)); } Chart3.Series[0]["PieLabelStyle"] = "Outside"; //将文字移到外侧 Chart3.Series[0]["PieLineColor"] = "Black"; //绘制黑色的连线。 Chart3.Series[0].Points.DataBindXY(xTownData, yTownData); }
private string action = DTEnums.ActionEnum.Add.ToString(); //操作类型 protected void Page_Load(object sender, EventArgs e) { BLL.village bll = new BLL.village(); DataTable dtVillage = bll.GetList(0); this.cunlist.DataBind(); cunlist.Items.Clear(); cunlist.Items.Add(new ListItem("请选择", "0")); foreach (DataRow dr in dtVillage.Rows) { string Id = dr["id"].ToString(); string Title = dr["name"].ToString().Trim(); cunlist.Items.Add(new ListItem(Title, Id)); } var start = 1991; var end = DateTime.Now.Year; agesye.Items.Add(new ListItem("请选择年份", "0")); for (int i = start; i <= end; i++) { agesye.Items.Add(new ListItem(i.ToString(), i.ToString())); } ; for (int i = 1; i <= 150; i++) { age.Items.Add(new ListItem(i.ToString(), i.ToString())); } ; this.name.Text = "张三1"; this.peiouxingming.Text = "张三2"; this.jichengren.Text = "cxvxcv"; this.cunzu.Text = "ewqe掐我v"; this.jiatingshouru.Text = "驱蚊器无"; this.jiekuanyongtu.Text = "恶趣味"; this.jiekuanjine.Text = "全文我去额"; this.shenqings1.Text = "张 全文三"; this.shenqings2.Text = "张而我却三"; this.shenqings3.Text = "张擦擦擦三"; this.shenqings4.Text = "张三"; this.xiaozuyijian1.Text = "张三"; this.xiaozuyijian2.Text = "张三"; this.name.Text = "张三"; this.name.Text = "张三"; this.jiekuanstart.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); this.jiekuanend.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); this.jiekuantime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); this.xiaozutime.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); this.xieshenpiyijian.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); this.jianshiyijian.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm"); }
//删除导航 protected void btnDelete_Click(object sender, EventArgs e) { BLL.village bll = new BLL.village(); 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); } } AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "删除导航菜单"); //记录日志 JscriptMsg("删除数据成功!", "village_list.aspx", "parent.loadMenuTree"); }
//保存排序 protected void btnSave_Click(object sender, EventArgs e) { BLL.village bll = new BLL.village(); 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()); } AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "保存导航排序"); //记录日志 JscriptMsg("保存排序成功!", "village_list.aspx"); }
private void LevelBind() { BLL.member_level bll = new BLL.member_level(); DataTable dt = bll.GetList("").Tables[0]; BLL.village villageBll = new BLL.village(); DataTable dtVillage = villageBll.GetParentList(0); ddlTown.Items.Clear(); ddlTown.Items.Add(new ListItem("请选择所属乡镇", "0")); foreach (DataRow dr in dtVillage.Rows) { string Id = dr["id"].ToString(); string Title = dr["name"].ToString().Trim(); ddlTown.Items.Add(new ListItem(Title, Id)); } }
//保存 public void town_Change_Click(object sender, EventArgs e) { ddlVillage.Items.Clear(); BLL.village subjectBll = new BLL.village(); DataTable dtVillage = subjectBll.GetList(Utils.StrToInt(ddlTown.SelectedValue, 0)); foreach (DataRow dr in dtVillage.Rows) { string Id = dr["id"].ToString(); string Title = dr["name"].ToString().Trim(); ddlVillage.Items.Add(new ListItem(Title, Id)); var rowIndex = dtVillage.Rows.IndexOf(dr); if (rowIndex == 0) { txtVillage.Text = Title; } } }
//保存 public void town_Change_Click(object sender, EventArgs e) { for (int i = 0; i < 10; i++) { if (ddlVillage.SelectedValue.ToString() != "0") { ddlVillage.Items.Clear(); BLL.village subjectBll = new BLL.village(); DataTable dtVillage = subjectBll.GetList(Utils.StrToInt(ddlTown.SelectedValue, 0)); foreach (DataRow dr in dtVillage.Rows) { string Id = dr["id"].ToString(); string Title = dr["name"].ToString().Trim(); ddlVillage.Items.Add(new ListItem(Title, Id)); } } } }
private bool DoAdd() { try { Model.village model = new Model.village(); BLL.village bll = new BLL.village(); model.name = txtName.Text.Trim(); model.parent_id = int.Parse(ddlParentId.SelectedValue); model.sort_id = int.Parse(txtSortId.Text.Trim()); if (bll.Add(model) > 0) { AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加层级分类:" + model.name); //记录日志 return(true); } } catch { return(false); } return(false); }
public void MemberCount() { List <string> xData = new List <string>(); List <int> yData = new List <int>(); var bll = new BLL.member(); var ds = bll.GetListByType().Tables[0]; foreach (DataRow dr in ds.Rows) { if (dr["type"].ToString() == "0") { xData.Add("常规会员"); } else { xData.Add("贫困户会员"); } yData.Add(Utils.StrToInt(dr["count"].ToString(), 0)); } Chart1.Series[0]["PieLabelStyle"] = "Outside"; //将文字移到外侧 Chart1.Series[0]["PieLineColor"] = "Black"; //绘制黑色的连线。 Chart1.Series[0].Points.DataBindXY(xData, yData); List <string> xLevelData = new List <string>(); List <int> yLevelData = new List <int>(); var dsLevel = bll.GetListByLevel().Tables[0]; var bllLevel = new BLL.member_level(); foreach (DataRow dr in dsLevel.Rows) { var level = bllLevel.GetName(Utils.StrToInt(dr["level"].ToString(), 0)); xLevelData.Add(level); yLevelData.Add(Utils.StrToInt(dr["count"].ToString(), 0)); } Chart2.Series[0]["PieLabelStyle"] = "Outside"; //将文字移到外侧 Chart2.Series[0]["PieLineColor"] = "Black"; //绘制黑色的连线。 Chart2.Series[0].Points.DataBindXY(xLevelData, yLevelData); List <string> xTownData = new List <string>(); List <int> yTownData = new List <int>(); var dsTown = bll.GetListByTown().Tables[0]; foreach (DataRow dr in dsTown.Rows) { var villageBll = new BLL.village(); var town = villageBll.GetName(Utils.StrToInt(dr["town"].ToString(), 0)); xTownData.Add(town); yTownData.Add(Utils.StrToInt(dr["count"].ToString(), 0)); } Chart3.Series[0]["PieLabelStyle"] = "Outside"; //将文字移到外侧 Chart3.Series[0]["PieLineColor"] = "Black"; //绘制黑色的连线。 Chart3.Series[0].Points.DataBindXY(xTownData, yTownData); //List<string> xTData = new List<string>() { "A", "B", "C", "D" }; //List<int> yTData = new List<int>() { 10, 10, 30, 40 }; ////线条颜色 //Chart4.Series[0].Color = Color.Green; ////线条粗细 //Chart4.Series[0].BorderWidth = 3; ////标记点边框颜色 //Chart4.Series[0].MarkerBorderColor = Color.Black; ////标记点边框大小 //Chart4.Series[0].MarkerBorderWidth = 3; ////标记点中心颜色 //Chart4.Series[0].MarkerColor = Color.Red; ////标记点大小 //Chart4.Series[0].MarkerSize = 8; ////标记点类型 //Chart4.Series[0].MarkerStyle = MarkerStyle.Circle; ////将文字移到外侧 //Chart4.Series[0]["PieLabelStyle"] = "Outside"; ////绘制黑色的连线 //Chart4.Series[0]["PieLineColor"] = "Black"; //Chart4.Series[0].Points.DataBindXY(xTData, yTData); }