//事务处理组装
List<string> ltsql = new List<string>();
string sql = "";
//更新转盘中奖奖品的物流信息
sql = @"insert into T_ReceiveAddress( MemberID, Contact, MobileNumber, Address, CreatedDate, Remark,RegionId)
Values( @MemberID, @Contact, @MobileNumber, @Address, @CreatedDate, @Remark,@RegionId);";
//更新转盘中奖奖品的物流信息
sql =sql+ @"update T_DrawList set LogisticsCompany=@LogisticsCompany, LogisticsNO=@LogisticsNO,LogisticsDate=@CreatedDate ,Remark=@Remark,ReceiveAddressID=SCOPE_IDENTITY()
where DrawListID=@DrawListID";
ltsql.Add(sql);
if (!string.IsNullOrEmpty(turntableDrawModel.ReceiveAddressId.ToString()))
{
//更新转盘中奖奖品的联系人相关信息
sql = @"DELETE FROM T_ReceiveAddress
where ReceiveAddressID=@ReceiveAddressID";
ltsql.Add(sql);
}
SqlParameter[] paras = new SqlParameter[] { new SqlParameter("@DrawListID", turntableDrawModel.DrawListID),
new SqlParameter("@ReceiveAddressID", turntableDrawModel.ReceiveAddressId),
new SqlParameter("@MemberID", turntableDrawModel.MemberId),
new SqlParameter("@LogisticsCompany", turntableDrawModel.LogisticsCompany),
new SqlParameter("@LogisticsNO", turntableDrawModel.LogisticsNO),
new SqlParameter("@Contact", turntableDrawModel.Contact),
new SqlParameter("@MobileNumber", turntableDrawModel.MobileNumber),
new SqlParameter("@Address", turntableDrawModel.Address),
new SqlParameter("@RegionId", turntableDrawModel.NewRegionId),
new SqlParameter("@CreatedDate", DateTime.Now),
new SqlParameter("@UpdatedDate", DateTime.Now),
new SqlParameter("@Remark",turntableDrawModel.Remark)};
//执行事务
return returnValue = SqlHelper.ExecuteSqlTran(ltsql, paras);