public int AddBargain(BargainEntity bargain, string loginName)
{
using (IDbConnection conn = DBContext.GetConnection(DataBaseName.AccountTrianDB, ReadOrWriteDB.Write))
{
string query = string.Format(@"INSERT INTO Train_Bargain
(BargainId
,OpenId
,ClassId
,PrePrice
,NowPrice
,Status
,CreateTime
,CreateUser
,UpdateTime
,UpdateUser)
VALUES
('{0}'
,'{1}'
,'{2}'
,'{3}'
,'{4}'
,'{5}'
,getdate()
,'{6}'
,getdate()
,'{7}')",
bargain.BargainId, bargain.OpenId, bargain.ClassId, bargain.PrePrice, bargain.NowPrice, 1, loginName, loginName);
return(conn.Execute(query));
}
}
/// <summary>
/// 新增砍价数据
/// </summary>
/// <param name="openid"></param>
/// <param name="classid"></param>
/// <param name="price"></param>
/// <returns></returns>
public ActionResult AddBargain(string openid, string classid, string price)
{
try
{
if (string.IsNullOrEmpty(openid) || string.IsNullOrEmpty(classid) || string.IsNullOrEmpty(price))
{
return(Json(string.Empty));
}
//判断是否注册
var userInfo = new WxUserBC().GetWxUserByOpenid(openid);
if (string.IsNullOrEmpty(userInfo.Phone))
{
string url = CommonHelper.GetRedirect("WxMy%2fRegistered");
//Response.Redirect(url);
return(Json(url, JsonRequestBehavior.AllowGet));
}
var result = new OrderBC().GetBargainByOpenIdAndClassId(classid, openid);
if (result != null)
{
return(Json("/WxOrder/Bargain?bargainid=" + result.BargainId, JsonRequestBehavior.AllowGet));
}
else
{
string bargainId = Guid.NewGuid().ToString();
BargainEntity entity = new BargainEntity()
{
BargainId = bargainId,
OpenId = openid,
ClassId = classid,
PrePrice = Convert.ToDecimal(price),
NowPrice = Convert.ToDecimal(price),
};
var addResult = new OrderBC().AddBargain(entity, openid);
if (addResult > 0)
{
string okUrl = "/WxOrder/Bargain?bargainid=" + bargainId;
return(Json(okUrl, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(string.Empty, JsonRequestBehavior.AllowGet));
}
}
}
catch (Exception ex)
{
return(Json(string.Empty, JsonRequestBehavior.AllowGet));
}
}
public ActionResult GetBargainByOpenIdAndClassId(string ClassId, string openId)
{
try
{
var result = new OrderBC().GetBargainByOpenIdAndClassId(ClassId, openId);
if (result == null)
{
result = new BargainEntity();
}
return(Json(result, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new BargainEntity(), JsonRequestBehavior.AllowGet));
}
}
public int AddBargain(BargainEntity bargain, string loginName)
{
OrderDA da = new OrderDA();
return(da.AddBargain(bargain, loginName));
}
