//批量删除
protected void btnDelete_Click(object sender, EventArgs e)
{
ChkAdminLevel("member_level_list", DTEnums.ActionEnum.Delete.ToString()); //检查权限
int sucCount = 0;
int errorCount = 0;
BLL.member_level bll = new BLL.member_level();
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)
{
if (bll.Delete(id))
{
sucCount += 1;
}
else
{
errorCount += 1;
}
}
}
AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "删除会员级别" + sucCount + "条，失败" + errorCount + "条"); //记录日志
JscriptMsg("删除成功" + sucCount + "条，失败" + errorCount + "条！", Utils.CombUrlTxt("member_level_list.aspx", "keywords={0}", this.keywords));
}
private void ShowInfo(int _id)
{
BLL.member_level bll = new BLL.member_level();
Model.member_level model = bll.GetModel(_id);
txtName.Text = model.name;
txtAmount.Text = model.amount.ToString();
txtAddTime.Text = model.add_time.Value.ToString("yyyy-MM-dd HH:mm:ss");
}
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 void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
txtKeywords.Text = this.keywords;
BLL.member_level bll = new BLL.member_level();
this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("member_level_list.aspx", "keywords={0}&page={1}", this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
private bool DoEdit(int _id)
{
bool result = false;
BLL.member_level bll = new BLL.member_level();
Model.member_level model = bll.GetModel(_id);
model.name = txtName.Text.Trim();
model.amount = Utils.StrToDecimal(txtAmount.Text, 0);
model.add_time = Utils.StrToDateTime(txtAddTime.Text.Trim());
if (bll.Update(model))
{
AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改会员级别:" + model.name); //记录日志
result = true;
}
return(result);
}
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));
}
}
private bool DoAdd()
{
Model.member_level model = new Model.member_level();
BLL.member_level bll = new BLL.member_level();
//检测会员证号码是否重复
if (bll.Exists(txtName.Text.Trim()))
{
return(false);
}
model.name = txtName.Text.Trim();
model.amount = Utils.StrToDecimal(txtAmount.Text, 0);
model.add_time = Utils.StrToDateTime(txtAddTime.Text.Trim());
if (bll.Add(model) > 0)
{
AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加会员级别:" + model.name); //记录日志
return(true);
}
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);
}
