public void UpdatePostInfo(string info)
{
var cmd = new DataCommand("mySql", "UpdatePostInfos");
cmd.SetParameters("@Id", $"{info}");
cmd.ExeSqlCmd();
}
public void UpdateTbOrdersSend(string orderId)
{
var cmd = new DataCommand <MySqlContext>("mySql", "UpdateTbOrdersSend");
cmd.SetParameters("@orderId", orderId);
cmd.ExeSqlCmd();
}
public void UpdateCartGoInfo(Tb_CartGo cartGo, string oldId)
{
var cmd = new DataCommand("mySql", "UpdateCartGoInfo");
cmd.SetParameters("@userId", cartGo.UserId);
cmd.SetParameters("@Oldid", oldId);
cmd.ExeSqlCmd();
}
public void SubmitOrder(string userSsid, string orderId)
{
var cmd = new DataCommand("mySql", "SubmitOrder");
cmd.SetParameters("@ssid", userSsid);
cmd.SetParameters("@orderId", orderId);
cmd.ExeSqlCmd();
}
public void RmUserCartgo(string userSsid, string code)
{
var cmd = new DataCommand("mySql", "RmUserCartgo");
cmd.SetParameters("@ssid", userSsid);
cmd.SetParameters("@code", code);
cmd.ExeSqlCmd();
}
public void UpdateUserInfo(Tb_UserInfo userInfo)
{
var cmd = new DataCommand("mySql", "InsertUserInfo");
cmd.SetParameters("@UserId", $"{userInfo.UserId}");
cmd.SetParameters("@Address", userInfo.Address);
cmd.SetParameters("@Phone", userInfo.Phone1);
cmd.ExeSqlCmd();
}
public void AddBuyCnt(string userSsid, string code, string cnt)
{
var cmd = new DataCommand("mySql", "AddBuyCnt");
cmd.SetParameters("@ssid", userSsid);
cmd.SetParameters("@code", code);
cmd.SetParameters("@cnt", $"{cnt}");
cmd.ExeSqlCmd();
}
public void InsertGoodsInfo(Tb_GoodsInfo goodsInfo)
{
var cmd = new DataCommand("mySql", "InsertGoodsInfo");
cmd.SetParameters("@GoodsId", $"{goodsInfo.GoodsId}");
cmd.SetParameters("@SalePrice", goodsInfo.SalePrice);
cmd.SetParameters("@Discount", $"{goodsInfo.Discount}");
cmd.ExeSqlCmd();
}
public void AddStockToCart(Tb_CartGo cartGo)
{
var cmd = new DataCommand();
var findIt = cmd.Search <Tb_CartGo>(x => x.StockCode.Equals(cartGo.StockCode) && x.UserId.Equals(cartGo.UserId) && x.IsPay != 1);
if (findIt != null)
{
findIt.BuyCnt += cartGo.BuyCnt;
findIt.CurPrice = cartGo.CurPrice;
DataCommand.Update(findIt);
return;
}
cmd = new DataCommand("mySql", "InsertGoodsCartGo");
cmd.SetParameters("@UserId", cartGo.UserId);
cmd.SetParameters("@StockCode", cartGo.StockCode);
cmd.SetParameters("@BuyCnt", $"{cartGo.BuyCnt}");
cmd.SetParameters("@CurPrice", $"{cartGo.CurPrice}");
cmd.SetParameters("@TempUser", $"{cartGo.TempUser}");
cmd.SetParameters("@CreateTime", cartGo.CreateTime.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.ExeSqlCmd();
}