/// <summary>
/// 创建表分区配置
/// </summary>
/// <param name="table"></param>
/// <param name="error"></param>
/// <returns></returns>
public bool Create(Table table, out string error)
{
error = "";
var query = GetLambdaQuery();
query.Where(b => b.DataBaseName == table.DataBaseName && b.TableName == table.TableName);
query.Top(1);
query.OrderBy(b => b.MainDataEndIndex, true);
var part1 = query.ToList().FirstOrDefault();
var start = part1.MainDataEndIndex += 1;
var end = start + table.MaxPartDataTotal - 1;
TablePart part = new TablePart()
{
DataBaseName = table.DataBaseName, TableName = table.TableName, MainDataStartIndex = start, MainDataEndIndex = end, PartIndex = part1.PartIndex + 1
};
if (part.PartIndex == 0)
{
part.PartName = table.TableName;
}
else
{
part.PartName = string.Format("{0}_{1}", table.TableName, part.PartIndex);
}
Add(part);
table.TablePartTotal = part.PartIndex + 1;
DBExtend.Update(table);
return(true);
}
/// <summary>
/// 更改数量
/// </summary>
/// <param name="item"></param>
public static void AddNum(ICartItem item)
{
DBExtend helper = dbHelper;
ParameCollection c = new ParameCollection();
c["$Num"] = "Num+" + item.Num;
//int n = GetCartCount(item.CartType) + item.Num;
//SetCartCount(item.CartType, n);
helper.Update <ICartItem>(b => b.UserId == item.UserId && b.ProductId == item.ProductId && b.StyleId == item.StyleId && b.CartType == item.CartType, c);
}
/// <summary>
/// 更改数量
/// </summary>
/// <param name="userId"></param>
/// <param name="num"></param>
/// <param name="id"></param>
public static void ChangeNum(string userId, int num, int id)
{
DBExtend helper = dbHelper;
var cartItem = helper.QueryItem <ICartItem>(b => b.UserId == userId && b.Id == id);
if (cartItem != null)
{
//int n = GetCartCount(cartItem.CartType) + num - cartItem.Num;
//SetCartCount(cartItem.CartType, n);
}
ParameCollection c = new ParameCollection();
c["Num"] = num;
helper.Update <ICartItem>(b => b.UserId == userId && b.Id == id, c);
}