public int Edit(Model.DelayedAwardsModel model, Model.OrderInfoModel OrderModel)
{
int rtn = 0;
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionString))
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update OrderInfo set ");
strSql.Append("IsGrant=@IsGrant,GrantTime=@GrantTime,States=@States");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@IsGrant", DbTool.FixSqlParameter(OrderModel.IsGrant))
, new SqlParameter("@GrantTime", DbTool.FixSqlParameter(OrderModel.GrantTime))
, new SqlParameter("@States", DbTool.FixSqlParameter(OrderModel.States))
, new SqlParameter("@Id", OrderModel.Id)
};
rtn += SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSql.ToString(), parameters);
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("update DelayedAwards set ");
strSql2.Append("StatusId=@StatusId,UpdateTime=@UpdateTime");
strSql2.Append(" where Id=@Id ");
SqlParameter[] parameters2 =
{
new SqlParameter("@StatusId", model.StatusId),
new SqlParameter("@UpdateTime", model.UpdateTime),
new SqlParameter("@Id", model.Id)
};
rtn += SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSql2.ToString(), parameters2);
if (rtn > 1)
{
trans.Commit();
return(rtn);
}
}
catch (Exception)
{
trans.Rollback();
rtn = 0;
}
}
}
return(0);
}
/// <summary>
/// 发放奖品
/// </summary>
/// <param name="OrderModel">订单</param>
/// <returns></returns>
private static void SendPrize(Model.DelayedAwardsModel DelayedModel, Model.OrderInfoModel OrderModel, PrizeParameter Parameter)
{
//具体发奖逻辑根据项目来
Common.RedPackHelper rp = new Common.RedPackHelper();
int moeny = OrderModel.RedPackMoney;
if (Parameter.IsTest == 1)
{
moeny = 100;
}
if (Parameter.RedSwitch == 0) //红包开关
{
return;
}
Common.RedPackHelper.result result = rp.send(Parameter.acid, Parameter.acid, OrderModel.OpenId, OrderModel.HbOrderCode, moeny, Parameter.ckey, Parameter.hkey);
if (result.SendStatus)
{
DelayedModel.StatusId = 1;
OrderModel.States = 1;
OrderModel.IsGrant = 1;
}
else
{
DelayedModel.StatusId = -1;
OrderModel.IsGrant = -1;
}
//执行时间
DelayedModel.UpdateTime = DateTime.Now;
OrderModel.GrantTime = DelayedModel.UpdateTime;
delayedAwardsDal.Edit(DelayedModel, OrderModel);
}
/// <summary>
/// 添加虚拟订单
/// </summary>
/// <param name="model">订单</param>
public void AddFictitiousOrder(Model.OrderInfoModel model)
{
//虚拟比例
var Fictitious = Common.TypeHelper.StringToInt(WebFramework.GeneralMethodBase.GetKeyConfig(51).Val);
if (Fictitious > 0)
{
var task = Task.Factory.StartNew(() =>
{
Common.Prize prize = new Common.Prize(Fictitious, 0, 0, 0, 0, 0, 100 - Fictitious);
//奖项为一等奖时添加虚拟订单
if (prize.GetPrize()[0] == "参与奖")
{
return;
}
Model.FictitiousOrderModel FictitiousModel = new Model.FictitiousOrderModel();
FictitiousModel.OrderCode = model.OrderCode;
FictitiousModel.Jx = model.Jx;
FictitiousModel.Jp = model.Jp;
FictitiousModel.DateStamp = model.DateStamp;
FictitiousModel.Ip = model.Ip;
FictitiousModel.IpAddress = model.IpAddress;
FictitiousModel.CreateTime = model.CreateTime;
FictitiousModel.OpenId = model.OpenId;
FictitiousModel.Mob = model.Mob;
FictitiousModel.Code = model.Code;
FictitiousModel.States = model.States;
FictitiousModel.HbOrderCode = model.HbOrderCode;
FictitiousModel.RedPackMoney = model.RedPackMoney;
new Db.FictitiousOrderDal().Add(FictitiousModel);
});
}
}
public int AddandOrder(Model.VoteInfoModel model, Model.OrderInfoModel oddel, Model.OrderLogModel mdlog)
{
int rtn = 0;
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionString))
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into [VoteInfo]");
strSql.Append("(OrderCode,VoteDate,VoteDt,Ip,VoteName,VoteOpid,VoteId,States,OpenId,NickName,NickImg)");
strSql.Append(" values (@OrderCode,@VoteDate,@VoteDt,@Ip,@VoteName,@VoteOpid,@VoteId,@States,@OpenId,@NickName,@NickImg)");
strSql.Append(";select SCOPE_IDENTITY()");
SqlParameter[] parameters =
{
new SqlParameter("@OrderCode", DbTool.FixSqlParameter(model.OrderCode))
, new SqlParameter("@VoteDate", DbTool.FixSqlParameter(model.VoteDate))
, new SqlParameter("@VoteDt", DbTool.FixSqlParameter(model.VoteDt))
, new SqlParameter("@Ip", DbTool.FixSqlParameter(model.Ip))
, new SqlParameter("@VoteName", DbTool.FixSqlParameter(model.VoteName))
, new SqlParameter("@VoteOpid", DbTool.FixSqlParameter(model.VoteOpid))
, new SqlParameter("@VoteId", DbTool.FixSqlParameter(model.VoteId))
, new SqlParameter("@States", DbTool.FixSqlParameter(model.States))
, new SqlParameter("@OpenId", DbTool.FixSqlParameter(model.OpenId))
, new SqlParameter("@NickName", DbTool.FixSqlParameter(model.NickName))
, new SqlParameter("@NickImg", DbTool.FixSqlParameter(model.NickImg))
};
rtn += SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSql.ToString(), parameters);
StringBuilder strSql3 = new StringBuilder();
strSql3.Append("update orderInfo set Number=Number+1");
strSql3.Append(" where id=@id");
SqlParameter[] parameters3 =
{
new SqlParameter("@id", oddel.Id)
};
rtn += SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSql3.ToString(), parameters3);
StringBuilder strSql2 = new StringBuilder();
strSql2.Append(" insert into OrderLog(Oid,OrderCode,Mob,UpTime,LStatus,Status,Notes)");
strSql2.Append(" values(@Oid,@OrderCode,@Mob,@UpTime,@LStatus,@Status,@Notes)");
SqlParameter[] parameters2 =
{
new SqlParameter("@Oid", mdlog.OId),
new SqlParameter("@OrderCode", mdlog.OrderCode),
new SqlParameter("@Mob", mdlog.Mob),
new SqlParameter("@UpTime", mdlog.UpTime),
new SqlParameter("@LStatus", mdlog.LStatus),
new SqlParameter("@Status", mdlog.Status),
new SqlParameter("@Notes", mdlog.Notes)
};
rtn += SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSql2.ToString(), parameters2);
if (rtn == 3)
{
trans.Commit();
return(rtn);
}
}
catch (Exception)
{
trans.Rollback();
rtn = 0;
}
}
}
return(0);
}
//修改两个电影码的记录，订单表的状态，订单日志
public int SetsCode(Model.CodesModel codes1, Model.CodesModel codes2, Model.OrderInfoModel model, Model.OrderLogModel mdlog)
{
int rtn = 0;
using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionString))
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
StringBuilder strSql10 = new StringBuilder();
strSql10.Append("update Codes set IsUsed=@IsUsed,Mob=@Mob,UsedTime=@UsedTime ");
strSql10.Append(" where id=@id");
SqlParameter[] parameter10 =
{
new SqlParameter("@IsUsed", codes1.IsUsed),
new SqlParameter("@mob", codes1.Mob),
new SqlParameter("@UsedTime", codes1.UsedTime),
new SqlParameter("@id", codes1.Id)
};
rtn += SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSql10.ToString(), parameter10);
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("update Codes set IsUsed=@IsUsed,Mob=@Mob,UsedTime=@UsedTime ");
strSql2.Append(" where id=@id");
SqlParameter[] parameter2 =
{
new SqlParameter("@IsUsed", codes2.IsUsed),
new SqlParameter("@mob", codes2.Mob),
new SqlParameter("@UsedTime", codes2.UsedTime),
new SqlParameter("@id", codes2.Id)
};
rtn += SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSql2.ToString(), parameter2);
StringBuilder strSql = new StringBuilder();
strSql.Append(" update OrderInfo set States=@States where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@States", model.States),
new SqlParameter("@Id", model.Id)
};
rtn += SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSql.ToString(), parameters);
StringBuilder strSql1 = new StringBuilder();
strSql1.Append(" insert into OrderLog(Oid,OrderCode,Mob,UpTime,LStatus,Status,Notes)");
strSql1.Append(" values(@Oid,@OrderCode,@Mob,@UpTime,@LStatus,@Status,@Notes)");
SqlParameter[] parameters2 =
{
new SqlParameter("@Oid", mdlog.OId),
new SqlParameter("@OrderCode", mdlog.OrderCode),
new SqlParameter("@Mob", mdlog.Mob),
new SqlParameter("@UpTime", mdlog.UpTime),
new SqlParameter("@LStatus", mdlog.LStatus),
new SqlParameter("@Status", mdlog.Status),
new SqlParameter("@Notes", mdlog.Notes)
};
rtn += SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSql1.ToString(), parameters2);
trans.Commit();
return(rtn);
}
catch (Exception)
{
trans.Rollback();
rtn = 0;
}
}
}
return(0);
}
/// <summary>
/// 大数据记录
/// </summary>
/// <param name="model">订单</param>
/// <returns></returns>
public string AddOrderApi(Model.OrderInfoModel model)
{
#region 抽红包保存信息
string temp = "";
string ActivityNo = WebFramework.GeneralMethodBase.GetKeyConfig(22).Val;
Task <string> task1 = Task.Factory.StartNew <string>(() =>
{
// WriteLog(message);
try
{
WebApiInterface webapi = new WebApiInterface();
Esmart_Totlal_Root customer = new Esmart_Totlal_Root();
#region 必填项 项目编号-品牌-openid
customer.ActivityNo = ActivityNo;
customer.OpenId = model.OpenId;
#endregion
#region 订单信息
customer.OrderCode = model.OrderCode;
customer.OrderStatus = 0;
customer.GiftName = model.Jp;
customer.GiftMoney = model.RedPackMoney.ToString();
customer.PrizeCode = model.PrizeCode;//兑换码
#endregion
#region 客户信息
customer.Ip = model.Ip;
customer.IpAdds = model.IpAddress;
customer.Mob = model.Mob;
#endregion
temp = webapi.InertActivityReqDetail(customer);
if (temp == "")
{
return("请求服务异常404");
//WebDebugLog("请求服务异常404");
}
else
{
MessageResponse <bool> obj = JsonConvert.DeserializeObject <MessageResponse <bool> >(temp);
if (obj.Code == 0)
{
return("OK");
}
else
{
return(obj.Message);
//WebDebugLog("请求服务异常");
}
}
}
catch (Exception ex)
{
return("在调用服务前出现异常-" + ex.Message);
}
});
temp = task1.Result;
return(temp);
#endregion
}
