/// <summary>
/// 获取单个购物车明细
/// </summary>
/// <param name="Id"></param>
/// <returns></returns>
internal static Tb_ShoppingCar GetShoppingDetailedModel(string Id)
{
IDbConnection con = new SqlConnection(PubConstant.GetConnectionString("BusinessContionString"));
Tb_ShoppingCar m = con.Query <Tb_ShoppingCar>("select * from Tb_ShoppingCar where Id=@Id and ISNULL(IsDelete,0)=0", new { Id = Id }).SingleOrDefault <Tb_ShoppingCar>();
return(m);
}
/// <summary>
/// 查询购物车
/// </summary>
/// <param name="UserId">用户编码</param>
/// <returns></returns>
internal static Tb_ShoppingCar GetShoppingCarModel(string UserId)
{
IDbConnection con = new SqlConnection(PubConstant.GetConnectionString("BusinessContionString"));
Tb_ShoppingCar m = con.Query <Tb_ShoppingCar>("select * from dbo.Tb_ShoppingCar where UserId=@UserId and isnull( IsDelete,0)=0", new { UserId = UserId }).SingleOrDefault <Tb_ShoppingCar>();
return(m);
}
/// <summary>
/// 添加购物车
/// </summary>
/// <param name="UserId"></param>
/// <param name="ResourcesID"></param>
/// <param name="BussId"></param>
/// <param name="Number"></param>
/// <param name="PropertysId"></param>
/// <param name="con"></param>
/// <returns></returns>
private static Tb_ShoppingCar SetShopping(int?corpId, string UserId, string ResourcesID, string BussId, int Number, string PropertysId, IDbConnection con)
{
Tb_ShoppingCar Car = new Tb_ShoppingCar();
Car.Id = Guid.NewGuid().ToString();
Car.IsDelete = 0;
Car.Number = Number;
Car.ResourcesID = ResourcesID;
Car.SubtotalMoney = 0;
Car.UserId = UserId;
Car.BussId = BussId;
Car.CorpId = corpId;
//增加购物车
con.Insert <Tb_ShoppingCar>(Car);
//添加属性
SetShoppingCarDetailed(BussId, PropertysId, con, Car);
return(Car);
}
/// <summary>
/// 添加属性集
/// </summary>
/// <param name="BussId"></param>
/// <param name="PropertysId"></param>
/// <param name="con"></param>
/// <param name="Car"></param>
private static void SetShoppingCarDetailed(string BussId, string PropertysId, IDbConnection con, Tb_ShoppingCar Car)
{
if (PropertysId != "")
{
foreach (string item in PropertysId.Split(','))
{
Tb_ShoppingDetailed ShoppingDetailed = new Tb_ShoppingDetailed();
ShoppingDetailed.BussId = BussId;
ShoppingDetailed.Id = Guid.NewGuid().ToString();
ShoppingDetailed.ShoppingId = Car.Id;
ShoppingDetailed.PropertysId = item.Split(':')[0].ToString();//属性
if (item.Split(':').Length >= 2)
{
ShoppingDetailed.SpecId = item.Split(':')[1].ToString();//规格
}
else
{
ShoppingDetailed.SpecId = "";//规格
}
con.Insert <Tb_ShoppingDetailed>(ShoppingDetailed);
}
}
}
