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