/// <summary>
/// 修改
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Update(SupplierEntity entity)
{
string key = string.Format(CacheKey.JOOSHOW_SUPPLIER_CACHE, this.CompanyID);
entity.Include(a => new { a.SupNum, a.SupName, a.SupType, a.Email, a.Phone, a.Fax, a.ContactName, a.Address, a.Description });
entity.Where(a => a.SnNum == entity.SnNum)
.And(a => a.CompanyID == entity.CompanyID);
int line = this.Supplier.Update(entity);
if (line > 0)
{
CacheHelper.Remove(key);
}
return(line);
}
public async Task SaveForm(SupplierEntity entity)
{
if (entity.Id.IsNullOrZero())
{
await entity.Create();
await this.BaseRepository().Insert(entity);
}
else
{
await entity.Modify();
await this.BaseRepository().Update(entity);
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="userCode"></param>
/// <returns></returns>
public int Delete(string supNum)
{
SupplierEntity entity = new SupplierEntity();
entity.IsDelete = (int)EIsDelete.Deleted;
entity.IncludeIsDelete(true);
entity.Where(a => a.SupNum == supNum);
int line = this.Supplier.Update(entity);
if (line > 0)
{
CacheHelper.Remove(CacheKey.JOOSHOW_SUPPLIER_CACHE);
}
return(line);
}
public BankAccountEntity[] GetBySupplier(SupplierEntity supplier)
{
try
{
var banks = context.BankAccounts.Where(x => x.CustomerId == supplier.CustomerId && x.SupplierId == supplier.Id).Select(x => new BankAccountEntity
{
BankAccountInFinance = x.BankAccountInFinance, CustomerId = x.CustomerId, SupplierId = x.SupplierId
});
return(banks != null?banks.ToArray() : null);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 编辑
/// </summary>
private void ShowEditSupplier()
{
SupplierEntity editEntity = SelectedSupplierRow;
if (editEntity == null)
{
MsgBox.Warn("没有要修改的数据。");
return;
}
FrmSupplierEdit frmSupplierEdit = new FrmSupplierEdit(editEntity);
frmSupplierEdit.DataSourceChanged += OnEditChanage;
frmSupplierEdit.ShowDialog();
}
public bool InsertSupplier(SupplierEntity entity)
{
try
{
//bool inserted = _repository.Insert(entity);
return(_repository.Insert(entity));
}catch (Exception ex)
{
//Log Exception Error
ExceptionHandler.LogException(ex, "Supplier_Bussiness_Logic_Layer_Insert");
throw new Exception("Business Logic :: Supplier Business :: Insert Function :: Error in Execution", ex);
}
}
public bool Put([FromBody] SupplierEntity SupplierEntity)
{
try
{
if (SupplierEntity.SID > 0)
{
return(_Supplierservice.UpdateSupplier(SupplierEntity.SID, SupplierEntity));
}
}
catch (Exception ex)
{
throw new ApiDataException(1000, "Product not found", HttpStatusCode.NotFound);
}
return(false);
}
public void TestEntityConstructorValidData()
{
APartyEntity payee = new SupplierEntity(SupplierType.Cruise, "", "Galasam");
APartyEntity payer = new CustomerEntity(CustomerType.Bureau, "", "Lonely Tree");
PaymentEntity entity = new PaymentEntity(validDueDate, validDueAmount, payer,
payee, validType, validSale, validBooking);
Payment payment = new Payment(entity, dataAccessFacadeStub);
Assert.AreEqual(validDueDate, payment.DueDate);
Assert.AreEqual(validDueAmount, payment.DueAmount);
Assert.AreEqual(payee.Name, payment.Payee.Name);
Assert.AreEqual(payer.Name, payment.Payer.Name);
Assert.AreEqual(validType, payment.Type);
Assert.AreEqual(validSale, payment.Sale);
Assert.AreEqual(validBooking, payment.Booking);
}
public void MakeInvoice_InvoiceController_SuplierVATPayer_ClientInEU_IsNotVATPayer_DifferentCountries()
{
// Arrange
ClientEntity clientEntity = new ClientEntity(1, "PirmasKlientas", 3, true, false, 17);
SupplierEntity supplierEntity = new SupplierEntity(1, "PirmasSupplier", 1, true, true, 21);
_clientRepository.Add(clientEntity);
_supplierRepository.Add(supplierEntity);
InvoiceController invoiceController = new InvoiceController(_clientRepository, _supplierRepository);
// Act
double sumResult = invoiceController.MakeInvoice(1, 1, 100);
// Assert
Assert.AreEqual(117, sumResult);
}
public void MakeInvoice_InvoiceController_SuplierAndClientSameCountry()
{
// Arrange
ClientEntity clientEntity = new ClientEntity(1, "PirmasKlientas", 1, true, false, 21);
SupplierEntity supplierEntity = new SupplierEntity(1, "PirmasSupplier", 1, true, true, 21);
_clientRepository.Add(clientEntity);
_supplierRepository.Add(supplierEntity);
InvoiceController invoiceController = new InvoiceController(_clientRepository, _supplierRepository);
// Act
double sumResult = invoiceController.MakeInvoice(1, 1, 100);
// Assert
Assert.AreEqual(121, sumResult);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="userCode"></param>
/// <returns></returns>
public int Delete(IEnumerable <string> list)
{
string key = string.Format(CacheKey.JOOSHOW_SUPPLIER_CACHE, this.CompanyID);
SupplierEntity entity = new SupplierEntity();
entity.IsDelete = (int)EIsDelete.Deleted;
entity.IncludeIsDelete(true);
entity.Where("SnNum", ECondition.In, list.ToArray());
entity.And(a => a.CompanyID == this.CompanyID);
int line = this.Supplier.Update(entity);
if (line > 0)
{
CacheHelper.Remove(key);
}
return(line);
}
public SupplierEntity GetSupplierDetail(int storeId, int LoggedInUserId, int?SupplierID)
{
SupplierEntity Supplier = new SupplierEntity();
if (SupplierID > 0)
{
Supplier = (from t in GetSupplierList(storeId, LoggedInUserId, SupplierID)
where t.supplier_id == SupplierID
select t).FirstOrDefault();
}
else
{
Supplier = new SupplierEntity();
}
return(Supplier);
}
protected override BookingEntity entityFromReader(SqlDataReader reader)
{
//Sets data from the database to corresponding data type for usage in the program.
int supplierId = (int)reader["Supplier"];
int customerId = (int)reader["Customer"];
string note = (string)reader["Note"];
string sale = (string)reader["Sale"];
int bookingNumber = (int)reader["BookingNumber"];
DateTime startDate = (DateTime)reader["StartDate"];
DateTime endDate = (DateTime)reader["EndDate"];
BookingType type = (BookingType)Enum.Parse(typeof(BookingType), reader["Type"].ToString());
decimal iVAExempt = (decimal)reader["IVAExempt"];
decimal iVASubject = (decimal)reader["IVASubject"];
decimal service = (decimal)reader["Service"];
decimal iVA = (decimal)reader["IVA"];
decimal productRetention = (decimal)reader["ProductRetention"];
decimal supplierRetention = (decimal)reader["supplierRetention"];
decimal transferAmount = (decimal)reader["TransferAmount"];
int id = (int)reader["BookingId"];
DateTime lastModified = (DateTime)reader["LastModified"];
bool deleted = (bool)reader["Deleted"];
SupplierEntity supplier = SupplierMapper.Read(supplierId);
CustomerEntity customer = CustomerMapper.Read(customerId);
BookingEntity bookingEntity = new BookingEntity(supplier, customer, sale, bookingNumber,
startDate, endDate);
//Uses the data to make it into an booking object.
bookingEntity.Note = note;
bookingEntity.Id = id;
bookingEntity.LastModified = lastModified;
bookingEntity.Deleted = deleted;
bookingEntity.Type = type;
bookingEntity.IVAExempt = iVAExempt;
bookingEntity.IVA = iVA;
bookingEntity.IVASubject = iVASubject;
bookingEntity.Service = service;
bookingEntity.ProductRetention = productRetention;
bookingEntity.SupplierRetention = supplierRetention;
bookingEntity.TransferAmount = transferAmount;
return(bookingEntity);
}
//修改供货商信息
private void toolStripButton6_Click(object sender, EventArgs e)
{
DialogResult dialog = MessageBox.Show(this, "确定要修改此供货商信息吗？", "提示",
MessageBoxButtons.YesNo, MessageBoxIcon.Warning);
if (this.dataGridView2.SelectedRows.Count == 0)
{
MessageBox.Show("没有选中供货商！");
return;
}
SupplierEntity supplierEntity = new SupplierEntity();
if (dialog == DialogResult.Yes)
{
int i = this.dataGridView1.CurrentRow.Index;
supplierEntity.SupplierId = dataGridView2.CurrentRow.Cells[0].Value.ToString();
supplierEntity.Merchantname = dataGridView2.Rows[i].Cells[1].Value.ToString();
supplierEntity.Contacts = dataGridView2.Rows[i].Cells[2].Value.ToString();
supplierEntity.Phone = dataGridView2.Rows[i].Cells[3].Value.ToString();
supplierEntity.Address = dataGridView2.Rows[i].Cells[4].Value.ToString();
supplierEntity.Settlement = dataGridView2.Rows[i].Cells[5].Value.ToString();
UpdateSupplier update = new UpdateSupplier(supplierEntity);
DialogResult dt = update.ShowDialog();
if (dt == DialogResult.OK)
{
supplierEntity = update.SupplierUpdate();
dataGridView1.CurrentRow.Cells[0].Value = supplierEntity.SupplierId;
dataGridView1.Rows[i].Cells[1].Value = supplierEntity.Merchantname;
dataGridView1.Rows[i].Cells[2].Value = supplierEntity.Contacts;
dataGridView1.Rows[i].Cells[3].Value = supplierEntity.Phone;
dataGridView1.Rows[i].Cells[4].Value = supplierEntity.Address;
dataGridView1.Rows[i].Cells[5].Value = supplierEntity.Settlement;
}
}
if (supplierEntity == null)
{
MessageBox.Show("未选中供货商！");
return;
}
}
public async Task <IActionResult> Edit(string id, [FromBody] SupplierEntity supplier)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
supplier.Id = id;
var result = await _repository.Update(supplier);
if (result == false)
{
return(BadRequest("edit failed"));
}
return(Ok(supplier));
}
public static async Task ThenSuppliersExist(Table table)
{
var expectedSuppliers = table.CreateSet <SupplierTable>().Select(s => new
{
s.Id,
Summary = string.IsNullOrWhiteSpace(s.Summary) ? null : s.Summary,
SupplierUrl = string.IsNullOrWhiteSpace(s.SupplierUrl) ? null : s.SupplierUrl,
});
var suppliers = await SupplierEntity.FetchAllAsync();
suppliers.Select(s => new
{
s.Id,
s.Summary,
s.SupplierUrl,
}).Should().BeEquivalentTo(expectedSuppliers);
}
public async Task <IActionResult> Create([FromBody] SupplierEntity supplier)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
supplier.Id = Guid.NewGuid().ToString("N");
var result = await _repository.Add(supplier);
if (result == false)
{
return(BadRequest("create failed"));
}
return(Ok(supplier));
}
public static Supplier_CE ToCE(SupplierEntity item)
{
Supplier_CE target = new Supplier_CE();
target.ID = item.ID;
target.SupNum = item.SupNum;
target.SupName = item.SupName;
target.Phone = item.Phone;
target.Fax = item.Fax;
target.Email = item.Email;
target.ContactName = item.ContactName;
target.Address = item.Address;
target.CreateUser = item.CreateUser;
target.Description = item.Description;
target.IsDelete = item.IsDelete;
target.CreateTime = item.CreateTime;
return(target);
}
public bool Add(SupplierEntity supplier)
{
try
{
string supplierId = Convert.ToInt32(supplier.Id).ToString("D9");
context.Suppliers.Add(new Suppliers {
SupplierId = supplierId, SupplierEnabled = true,
SupplierName = supplier.Name, SupplierWithBanks = supplier.WithBanks, SupplierPkudatYomanNumber = supplier.PkudatYomanNumber, SupplierCustomerId = supplier.CustomerId
, SupplierNumberInFinance = supplier.SupplierNumberInFinance
});
context.SaveChanges();
return(true);
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// 添加供应商
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public int Add(SupplierEntity entity)
{
string key = string.Format(CacheKey.JOOSHOW_SUPPLIER_CACHE, this.CompanyID);
entity.IsDelete = (int)EIsDelete.NotDelete;
entity.CreateTime = DateTime.Now;
entity.SupNum = entity.SupNum.IsEmpty() ? new TNumProvider(this.CompanyID).GetSwiftNum(typeof(SupplierEntity), 5) : entity.SupNum;
entity.SnNum = entity.SnNum.IsEmpty() ? ConvertHelper.NewGuid() : entity.SnNum;
entity.IncludeAll();
int line = this.Supplier.Add(entity);
if (line > 0)
{
CacheHelper.Remove(key);
}
return(line);
}
public static Supplier ToDto(this SupplierEntity entity, Hashtable seenObjects, Hashtable parents)
{
OnBeforeEntityToDto(entity, seenObjects, parents);
var dto = new Supplier();
if (entity != null)
{
if (seenObjects == null)
{
seenObjects = new Hashtable();
}
seenObjects[entity] = dto;
parents = new Hashtable(parents)
{
{ entity, null }
};
// Map dto properties
dto.SupplierId = entity.SupplierId;
dto.CompanyName = entity.CompanyName;
dto.ContactName = entity.ContactName;
dto.ContactTitle = entity.ContactTitle;
dto.Address = entity.Address;
dto.City = entity.City;
dto.Region = entity.Region;
dto.PostalCode = entity.PostalCode;
dto.Country = entity.Country;
dto.Phone = entity.Phone;
dto.Fax = entity.Fax;
dto.HomePage = entity.HomePage;
// Map dto associations
// 1:n Products association of Product entities
if (entity.Products != null && entity.Products.Any())
{
dto.Products = new ProductCollection(entity.Products.RelatedArray(seenObjects, parents));
}
}
OnAfterEntityToDto(entity, seenObjects, parents, dto);
return(dto);
}
public void TestSupplierConstructorValidData()
{
string name = "gert";
string note = "total fed note";
SupplierType type = SupplierType.Cruise;
DataAccessFacadeStub stub = new DataAccessFacadeStub();
SupplierEntity entity = new SupplierEntity(type, note, name);
Supplier supplier = new Supplier(stub, entity);
string expectedName = "gert";
string expectedNote = "total fed note";
SupplierType expectedType = SupplierType.Cruise;
Assert.AreEqual(expectedNote, supplier.Note);
Assert.AreEqual(expectedName, supplier.Name);
Assert.AreEqual(expectedType, supplier.Type);
}
public ActionResult GetSupplierList()
{
int pageIndex = WebUtil.GetFormValue <int>("pageIndex", 1);
int pageSize = WebUtil.GetFormValue <int>("pageSize", 15);
string SupNum = WebUtil.GetFormValue <string>("SupNum", string.Empty);
SupplierProvider provider = new SupplierProvider();
SupplierEntity entity = new SupplierEntity();
List <SupplierEntity> list = provider.GetList();
if (!list.IsNullOrEmpty())
{
List <SupplierEntity> listResult = list.Where(a => a.SupNum.Contains(SupNum) || a.SupName.Contains(SupNum)).ToList();
List <SupplierEntity> returnList = listResult.Skip((pageIndex - 1) * pageSize).Take(pageSize).OrderByDescending(a => a.ID).ToList();
string json = ConvertJson.ListToJson <SupplierEntity>(returnList, "List");
this.ReturnJson.AddProperty("Data", new JsonObject(json));
this.ReturnJson.AddProperty("RowCount", listResult.Count);
}
return(Content(this.ReturnJson.ToString()));
}
public async Task <bool> AddRelationshipByFile(FileEntity fileEntity)
{
var pck = new ExcelPackage();
pck.Load(fileEntity.File.OpenReadStream());
try
{
SupplierEntity supplier = new SupplierEntity
{
Id = fileEntity.SupplierId,
CustomerId = fileEntity.CustomerId
};
var result = await Task.Run(() =>
{
var excel = pck.Workbook.Worksheets.First();
var budgets = new BudgetsService(context).GetBySupplier(supplier);
var contracts = new ContractsService(context).GetBySupplier(supplier).Result;
var relationship = new BudgetContractService(context).GetRelationshipBySupplier(supplier);
for (int rowNum = 2; rowNum <= excel.Dimension.End.Row; rowNum++)
{
if (!string.IsNullOrEmpty(excel.Cells[rowNum, 1].Text))
{
handleRelationShipsExcel(excel, rowNum, contracts, budgets, relationship, supplier);
}
else
{
break;
}
}
return(true);
});
pck.Dispose();
await context.SaveChangesAsync();
return(result);
}
catch (Exception e)
{
pck.Dispose();
throw e;
}
}
public void Add_SupplierRepository_SupplierAdded()
{
// Arrange
SupplierEntity supplierEntity = new SupplierEntity();
supplierEntity.Id = 1;
supplierEntity.Name = "Pirma";
supplierEntity.IdCountry = 1;
supplierEntity.IsInEuropeanUnion = true;
supplierEntity.IsVATPayer = true;
supplierEntity.VATPercentage = 21;
SupplierEntity supplierEntity2 = new SupplierEntity();
supplierEntity2.Id = 2;
supplierEntity2.Name = "Antra";
supplierEntity2.IdCountry = 1;
supplierEntity2.IsInEuropeanUnion = true;
supplierEntity2.IsVATPayer = false;
supplierEntity2.VATPercentage = 21;
SupplierEntity supplierEntity3 = new SupplierEntity();
supplierEntity3.Id = 3;
supplierEntity3.Name = "Trecia";
supplierEntity3.IdCountry = 2;
supplierEntity3.IsInEuropeanUnion = false;
supplierEntity3.IsVATPayer = true;
supplierEntity3.VATPercentage = 18;
InvoiceController invoiceController = new InvoiceController(_clientRepository, _supplierRepository);
// Act
_supplierRepository.Add(supplierEntity);
_supplierRepository.Add(supplierEntity2);
_supplierRepository.Add(supplierEntity3);
// Assert
Assert.AreEqual(_supplierRepository.GetBy(1).Name, "Pirma");
Assert.AreEqual(_supplierRepository.GetBy(2).IsVATPayer, false);
Assert.AreEqual(_supplierRepository.GetBy(3).Name, "Trecia");
Assert.AreEqual(_supplierRepository.GetBy(3).Id, 3);
Assert.AreEqual(_supplierRepository.GetCount(), 3);
}
public void Create(SupplierEntity item)
{
using (var context = new DatabaseContext())
{
var e = new Supplier();
e.Name = item.Name;
e.Address = item.Address;
e.Email = item.Email;
e.Contact = item.Contact;
e.Status = item.Status;
e.CreatedBy = item.CreatedBy;
e.CreatedDate = item.CreatedDate;
e.ModifiedBy = item.ModifiedBy;
e.ModifiedDate = item.ModifiedDate;
context.Suppliers.Add(e);
context.SaveChanges();
item.ID = e.ID;
}
}
public ActionResult AddSupplier()
{
string SupNum = WebUtil.GetQueryStringValue <string>("SupNum");
if (SupNum.IsEmpty())
{
ViewBag.Supplier = new SupplierEntity();
ViewBag.SupType = EnumHelper.GetOptions <ESupType>((int)ESupType.Invented, "请选择供应商类型");
return(View());
}
else
{
SupplierProvider provider = new SupplierProvider();
SupplierEntity entity = provider.GetSupplier(SupNum);
entity = entity == null ? new SupplierEntity() : entity;
ViewBag.SupType = EnumHelper.GetOptions <ESupType>(entity.SupType, "请选择供应商类型");
ViewBag.Supplier = entity;
return(View());
}
}
/// <summary>
/// 绑定供应商代码
/// </summary>
public void BindSupplierCode()
{
DataSet dataSet = new DataSet();
SupplierEntity supplierEntity = new SupplierEntity();
dataSet = supplierEntity.GetSupplierCode();
if (dataSet != null)
{
DataTable dt = dataSet.Tables[0].Copy();
dt.Rows.InsertAt(dt.NewRow(), 0);
this.lueCode.Properties.DataSource = dt;
this.lueCode.Properties.DisplayMember = "CODE";
this.lueCode.Properties.ValueMember = "CODE";
lueCode.ItemIndex = 0;
grdCrtlCode.MainView = gridViewCode;
grdCrtlCode.DataSource = dataSet.Tables[0];
gridViewCode.BestFitColumns();
}
}
/// <summary>
/// 获得所有供应商信息
/// </summary>
/// <param name="entity"></param>
/// <param name="pageInfo"></param>
/// <returns></returns>
public List <SupplierEntity> GetList()
{
//List<SupplierEntity> listResult = CacheHelper.Get(CacheKey.JOOSHOW_SUPPLIER_CACHE) as List<SupplierEntity>;
//if (!listResult.IsNullOrEmpty())
//{
// return listResult;
//}
SupplierEntity entity = new SupplierEntity();
entity.IncludeAll();
entity.OrderBy(a => a.ID, EOrderBy.DESC);
entity.Where(a => a.IsDelete == (int)EIsDelete.NotDelete);
List <SupplierEntity> listResult = this.Supplier.GetList(entity);
//if (!listResult.IsNullOrEmpty())
//{
// CacheHelper.Insert(CacheKey.JOOSHOW_SUPPLIER_CACHE, listResult);
//}
return(listResult);
}
private void gridLoad()
{
try
{
Execute objExecute = new Execute();
string Query = "[dbo].[spGetAllSupplierView]";
SqlParameter[] para = new SqlParameter[]
{
};
DataTable dt = (DataTable)objExecute.Executes(Query, ReturnType.DataTable, para, CommandType.StoredProcedure);
SupplierEntity objSupplierEntity;
List <SupplierEntity> lstSupplier = new List <SupplierEntity>();
foreach (DataRow dr in dt.Rows)
{
objSupplierEntity = new SupplierEntity
{
intSupplierID = (int)dr["intSupplierID"],
vcSupplierName = dr["vcSupplierName"].ToString(),
vcAddress = dr["vcAddress"].ToString(),
vcCity = dr["vcCity"].ToString(),
vcEmail = dr["vcEmail"].ToString(),
intContactNo = (int)dr["intContactNo"],
};
lstSupplier.Add(objSupplierEntity);
}
dgvSupplierView.DataSource = null;
dgvSupplierView.AutoGenerateColumns = false;
dgvSupplierView.DataSource = lstSupplier;
GlobleList = lstSupplier.ToList();
}
catch (Exception ex)
{
MessageBox.Show("Data Loading Error");
Logger.LoggError(ex, "GetAllSupplierView");
}
}
private void ShowItem(SupplierEntity ent)
{
lblId.Text = ent.Id.HasValue ? ent.Id.Value.ToString() : string.Empty;
txtName.Text = ent.Name;
txtAddress.Text = ent.Address;
txtAddress2.Text = ent.Address2;
txtPhone.Text = ent.Phone;
txtEmail.Text = ent.Email;
txtComment.Text = ent.Comment;
var found = allSeries.Where(s => s.Id == ent.NrSerieId).FirstOrDefault();
if (found != null)
cbNumberSerie.Text = found.ToString();
}
private void NewItem()
{
current = SupplierEntity.Empty;
ShowItem(current);
}
private void gridSuppliers_SelectionChanged(object sender, EventArgs e)
{
if (gridSuppliers.SelectedCells == null || gridSuppliers.SelectedCells.Count == 0)
current = SupplierEntity.Empty;
else
current = gridSuppliers.Rows[gridSuppliers.SelectedCells[0].RowIndex].DataBoundItem as SupplierEntity;
ShowItem(current);
}
