/// <summary> /// 批量返回点数 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Button2_Click(object sender, EventArgs e) { string sql = "select * from Activity"; List<Daxu.Entity.Activity> ActList = new List<Daxu.Entity.Activity>(); ActList = Daxu.BLL.ActivityBll.GetIActivityData(sql) as List<Daxu.Entity.Activity>; Daxu.Entity.balanceSj bananceSjinfo = new Daxu.Entity.balanceSj();//商家点数明细表 string dyimgSql = "select * from dyimg order by id desc"; Daxu.Entity.Dyimg dyimginfo=Daxu.BLL.DyimgBLL.getIDyimgModel(dyimgSql); foreach( Daxu.Entity.Activity activityinfo in ActList) { string sql1 = "select * from businessman where id='" + Convert.ToInt32(activityinfo.businessmanId) + "'"; Daxu.Entity.businessman businfo = Daxu.BLL.businessmanBll.getIbusinessmanModel(sql1); businfo.Balance += Convert.ToDecimal(condian.Text); businfo.id = Convert.ToInt32(activityinfo.businessmanId); Daxu.BLL.businessmanBll.UpdateIbusinessman(businfo); //发送信息 bananceSjinfo.Text = "感谢" + businfo.RestaurantName + "参加平台举办" + dyimginfo.name + "活动" + "为此奖励" + condian.Text+"个积分!"+DateTime.Now.ToString("yyyy-mm-dd")+""; bananceSjinfo.Rechargetime = DateTime.Now.Date.ToString(); bananceSjinfo.RechargeJe = Convert.ToDecimal( condian.Text); bananceSjinfo.businessmanId = activityinfo.businessmanId; bananceSjinfo.cx = "1"; Daxu.BLL.balanceSjBll.InsertIbalanceSj(bananceSjinfo); Daxu.BLL.ActivityBll.DeleteIActivity(Convert.ToInt32(activityinfo.id)); } Response.Write("<script>alert(\"操作成功!\");location.href='../Promotion/PromotionBus.aspx';</script>"); }
protected void Calculate() { List<Daxu.Entity.Activity> DyimgList = Daxu.BLL.ActivityBll.GetIActivityData("select * from Activity ") as List<Daxu.Entity.Activity>; foreach (Daxu.Entity.Activity Dyimginfo in DyimgList) { TimeSpan time = Convert.ToDateTime(Dyimginfo.datetime).AddDays(30).Date - DateTime.Now; Daxu.Entity.Activity Activityinfo = new Daxu.Entity.Activity(); Activityinfo.days = (time.Days).ToString(); if (Convert.ToInt32(Activityinfo.days) > 0) { Activityinfo.id = Convert.ToInt32(Dyimginfo.id); Daxu.BLL.ActivityBll.UpdateIActivity(Activityinfo); } else if (Convert.ToInt32(Activityinfo.days) < 0) { //系统信息 string sql1="select * from pageinfo where id=1"; Daxu.Entity.pageinfo pageinfo=Daxu.BLL.pageinfoBll.getIpageinfoModel(sql1); string sql = "select * from businessman where id='"+ Convert.ToInt32(Dyimginfo.businessmanId)+"'"; Daxu.Entity.businessman busman= Daxu.BLL.businessmanBll.getIbusinessmanModel(sql); Daxu.Entity.businessman busmaninfo = new Daxu.Entity.businessman(); busmaninfo.Balance = busman.Balance + pageinfo.dian; busmaninfo.id = Convert.ToInt32(Dyimginfo.businessmanId); Daxu.BLL.businessmanBll.UpdateIbusinessman(busmaninfo); Daxu.Entity.balanceSj bananceSjinfo = new Daxu.Entity.balanceSj();//商家点数明细表 bananceSjinfo.Text = "感谢" + busman.RestaurantName + "参加平台举办" + Dyimginfo.fenleiname + "活动" + "为此奖励" + pageinfo.dian + "个积分!" + DateTime.Now.ToString("yyyy-mm-dd") + ""; //发送信息 bananceSjinfo.Rechargetime = DateTime.Now.Date.ToString(); bananceSjinfo.RechargeJe = Convert.ToDecimal(pageinfo.dian); bananceSjinfo.businessmanId = Dyimginfo.businessmanId; bananceSjinfo.cx = "1"; Daxu.BLL.balanceSjBll.InsertIbalanceSj(bananceSjinfo); Daxu.BLL.ActivityBll.DeleteIActivity( Convert.ToInt32(Dyimginfo.id)); } } }