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