public void Add_SavesToDatabase()
{
var options = new DbContextOptionsBuilder <GameInfoContext>()
.UseInMemoryDatabase(databaseName: "AddItem_ToDb")
.Options;
using (var context = new GameInfoContext(options))
{
var itemToAdd = new AddItemInputModel()
{
Name = "Item", AcquiredFrom = "How to get", Usage = "None"
};
var service = new ItemsService(context);
service.Add(itemToAdd);
var expectedItem = new Item()
{
Name = itemToAdd.Name, AcquiredFrom = itemToAdd.AcquiredFrom, Usage = itemToAdd.Usage
};
var itemFromDb = context.Items.First();
Assert.NotEmpty(context.Items);
Assert.Equal(expectedItem.Name, itemFromDb.Name);
Assert.Equal(expectedItem.AcquiredFrom, itemFromDb.AcquiredFrom);
Assert.Equal(expectedItem.Usage, itemFromDb.Usage);
}
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var its = new LHItems
{
FCode = txtFCode.Text.Trim(),
FName = txtFName.Text.Trim(),
FSpec = txtFSpec.Text.Trim(),
FSpell = ChineseSpell.MakeSpellCode(txtFName.Text.Trim(), "",
SpellOptions.FirstLetterOnly).ToUpper(),
FFlag = 1,
//分类
FCateId = "2001",
FSubCateId = ProjectItem.FId,
FCompanyId = CurrentUser.AccountComId,
FGroupNum = txtFGroupNum.Text,
FMemo = txtFMemo.Text.Trim(),
FRack = txtFRack.Text.Trim(),
//单位
FUnit = ddlUnit.SelectedValue,
FPurchasePrice = Convert.ToDecimal(txtFPurchasePrice.Text.Trim()),
FSalesPrice = Convert.ToDecimal(txtFSalesPrice.Text.Trim()),
FPieceWork1 = Convert.ToDecimal(txtFPieceWork1.Text.Trim()),
FPieceWork2 = Convert.ToDecimal(txtFPieceWork2.Text.Trim()),
FPieceWork3 = Convert.ToDecimal(txtFPieceWork3.Text.Trim()),
FPieceWork4 = Convert.ToDecimal(txtFPieceWork4.Text.Trim()),
FPieceWork5 = Convert.ToDecimal(txtFPieceWork5.Text.Trim()),
FNetWeight = Convert.ToDecimal(txtFNetWeight.Text.Trim()),//重量
};
return(ItemsService.Add(its));
}
/// <summary>
/// 提交添加
/// </summary>
private bool SubmintAdd()
{
var its = new LHItems
{
FCode = txtFCode.Text.Trim(),
FName = txtFName.Text.Trim(),
FSpec = txtFSpec.Text.Trim(),
FSpell = ChineseSpell.MakeSpellCode(txtFName.Text.Trim(), "",
SpellOptions.FirstLetterOnly).ToUpper(),
FFlag = 1,
//分类
FCateId = "2000",
FSubCateId = ProjectItem.FId,
FCompanyId = CurrentUser.AccountComId,
FGroupNum = txtFGroupNum.Text,
FMemo = txtFMemo.Text.Trim(),
FIsLiquid = ddlFIsLiquid.SelectedValue,
FRack = txtFRack.Text.Trim(),
//单位
FUnit = ddlUnit.SelectedValue,
FPurchasePrice = Convert.ToDecimal(txtFPurchasePrice.Text.Trim()),
FSalesPrice = Convert.ToDecimal(txtFSalesPrice.Text.Trim()),
//FPieceWork1 = 0,//Convert.ToDecimal(txtFPieceWork.Text.Trim()),
FQty = Convert.ToDecimal(txtFQty.Text.Trim()),
cinvdefine1 = txtcinvdefine1.Text,
FPieceWork1 = Convert.ToDecimal(txtFPieceWork1.Text.Trim())
};
// 包装物问题
if (!ddlBottleNum.SelectedValue.Equals("-1"))
{
var bottle = ItemsMapBottleService.Where(p => p.FCode == ProductItem.FCode && p.FCompanyId == CurrentUser.AccountComId).FirstOrDefault();
if (bottle != null)
{
bottle.FBottleCode = ddlBottleNum.SelectedValue;
ItemsMapBottleService.SaveChanges();
}
else
{
var bot = new LHItemsMapBottle
{
FCode = ProductItem.FCode,
FBottleCode = ddlBottleNum.SelectedValue
};
ItemsMapBottleService.Add(bot);
}
}
return(ItemsService.Add(its));
}
public ActionResult <int> Add(ItemsAddRequest model)
{
try
{
ItemsService service = new ItemsService();
int id = service.Add(model);
return(Ok(id));
}
catch (Exception ex)
{
return(StatusCode(500, ex.Message.ToString()));
}
}