//IF EXISTS(SELECT * FROM [IMES_FA].[dbo].[KittingCode] WHERE Code = @Code AND [Type] = 'Kitting')
// UPDATE [IMES_FA].[dbo].[KittingCode]
// SET Descr = @Description,Remark = @Remark,Editor = @Remark,Udt = GETDATE()
// WHERE Code = @Code AND [Type] = 'Kitting' ELSE INSERT INTO [IMES_FA].[dbo].[KittingCode]
//([Code],[Type],[Descr],[Remark],[Editor],[Cdt],[Udt]) VALUES(@Code, 'Kitting', @Description, @Remark, @Editor, GETDATE(), GETDATE())
public void SaveKittingCode(KittingCodeDef item)
{
try
{
IProductRepository itemRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository>();
KittingCode newItem = new KittingCode();
newItem.Code = item.Code;
newItem.Editor = item.Editor;
newItem.Descr = item.Descr;
newItem.Remark = item.Remark;
newItem.Type = "Kitting";
itemRepository.SaveKittingCode(newItem);
}
catch (Exception)
{
throw;
}
}
//INSERT INTO [IMES_FA].[dbo].[KittingCode]
// ([Code],[Type],[Descr],[Remark],[Editor],[Cdt],[Udt]) VALUES(@Code, 'Kitting',
//@Description, @Remark, @Editor, GETDATE(), GETDATE())
public string AddKittingCode(KittingCodeDef item)
{
string result = "";
try
{
IProductRepository itemRepository = RepositoryFactory.GetInstance().GetRepository<IProductRepository>();
Boolean isExistKittingCode=itemRepository.IsKittingCodeExist(item.Code);
if (isExistKittingCode == true)
{
//已经存在具有相同Code, 类型为Kitting的KittingCode记录
//!!!need change
List<string> erpara = new List<string>();
FisException ex;
ex = new FisException("DMT052", erpara);
throw ex;
}
KittingCode newItem = new KittingCode();
newItem.Code = item.Code;
newItem.Editor = item.Editor;
newItem.Descr = item.Descr;
newItem.Remark = item.Remark;
newItem.Type = "Kitting";
newItem.Cdt = DateTime.Now;
newItem.Udt = DateTime.Now;
itemRepository.AddKittingCode(newItem);
result = newItem.Code.ToString();
}
catch (Exception)
{
throw;
}
return result;
}
