protected string Getzong_zhitui(string _id)
{
double _title = 0;
tbl_xiaofei bll = new tbl_xiaofei();
_title = Convert.ToDouble(bll.GetTitleSum("huiyuan_shang_id='" + _id + "' and xiaofei_qr_flag=1", "sum(xiaofei_money)"));
return(_title.ToString());
}
// 单个删除
protected void delete_Click1(object sender, EventArgs e)
{
// 当前点击的按钮
this.page = AXRequest.GetQueryInt("page");
LinkButton lb = (LinkButton)sender;
string huiyuan_id = lb.CommandArgument.ToString();
tbl_huiyuan bll = new tbl_huiyuan();
if (!bll.show_is_jd(huiyuan_id) || !bll.show_is_tj(huiyuan_id))
{
mym.JscriptMsg(this.Page, "不能删除！下面已有消费者注册", "", "Error");
return;
}
bll.GetModel_hui_id(huiyuan_id);
bll.huiyuan_id = huiyuan_id;
bll.Delete(huiyuan_id);//触发器删除
tbl_shangshu ssbll = new tbl_shangshu();
ssbll.huiyuan_id = huiyuan_id;
ssbll.Delete(huiyuan_id);
tbl_shangshu2 ss2bll = new tbl_shangshu2();
ss2bll.huiyuan_id = huiyuan_id;
ss2bll.Delete(huiyuan_id);
tbl_xiaofei xfbll = new tbl_xiaofei();
xfbll.xiaofei_hui_id = huiyuan_id;
xfbll.Delete_xiaofei_hui_id(huiyuan_id);
tbl_orders orders = new tbl_orders();
orders.user_id = huiyuan_id;
orders.Delete_orders(huiyuan_id);
mym.JscriptMsg(this.Page, " 删除成功！", Utils.CombUrlTxt("al_read1.aspx", "start_time={0}&stop_time={1}&huiyuan_jiebie={2}¬e_no={3}&type={4}&page={5}", this.txtstart_time.Value, this.txtstop_time.Value, this.ddlproduct_category_id.SelectedValue, txtNote_no.Text, this.type.SelectedValue, this.page.ToString()), "Success");
}
