/// <summary>
/// 读取sheet 内的数据 生成实体集合 若报价单元格为空则跳过
/// </summary>
/// <param name="worksheet"></param>
/// <returns></returns>
public IEnumerable <QuoteDetailModel> GetSheetValues(string fileFullName)
{
FileInfo file = new FileInfo(fileFullName);
if (file != null)
{
using (ExcelPackage package = new ExcelPackage(file))
{
ExcelWorksheet worksheet = package.Workbook.Worksheets[0];
//获取表格的列数和行数
int rowCount = worksheet.Dimension.Rows;
int ColCount = worksheet.Dimension.Columns;
var QuoteDetailModels = new List <QuoteDetailModel>();
for (int row = 4; row <= rowCount; row++)
{
if (worksheet.Cells[row, 7].Value == null)
{
break;
}
QuoteDetailModel detail = new QuoteDetailModel
{
GoodsName = worksheet.Cells[row, 4].Value.ToString(),
Price = Convert.ToDecimal(worksheet.Cells[row, 7].Value)
};
QuoteDetailModels.Add(detail);
}
return(QuoteDetailModels);
}
}
return(null);
}
public JsonResult SaveQouteData(List <QuoteModel> lstSampleSubmissionMaster, List <QuoteDetailModel> lstSampleSubmissionDetails)
{
var strMessage = string.Empty;
try
{
foreach (var item in lstSampleSubmissionMaster)
{
QuoteModel masterEntityModel = new QuoteModel();
#region Current User
var userName = HttpContext.User.Identity.Name;
masterEntityModel.IUser = userName;
masterEntityModel.IDate = DateTime.Now;
masterEntityModel.EDate = DateTime.Now;
#endregion
masterEntityModel.QuoteNo = "Test";
masterEntityModel.SalesCallId = Convert.ToInt64(item.SalesCallId);
masterEntityModel.QuoteDate = item.QuoteDate;
masterEntityModel.CustomerId = Convert.ToInt64(item.CustomerId);
//masterList.Add(masterEntityModel);
var entity = masterEntityModel.ToEntity();
_QuoteService.BMSUnit.QuoteRepository.Add(entity);
_QuoteService.BMSUnit.QuoteRepository.SaveChanges();
Session["QuoteMasterId"] = entity.Id;
}
// Add new detail information
foreach (var item in lstSampleSubmissionDetails)
{
QuoteDetailModel entityDetailModel = new QuoteDetailModel();
entityDetailModel.QuoteId = Convert.ToInt64(Convert.ToInt64(Session["QuoteMasterId"]));
entityDetailModel.ArticleId = item.ArticleId;
entityDetailModel.MOQ = item.MOQ;
entityDetailModel.ValidityDate = item.ValidityDate;
entityDetailModel.SupplierId = item.SupplierId;
entityDetailModel.PriceTermId = item.PriceTermId;
entityDetailModel.ShipmentCountryId = item.ShipmentCountryId;
entityDetailModel.ShipmentLeadTime = item.ShipmentLeadTime;
entityDetailModel.DetailText = item.DetailText;
var detailEntity = entityDetailModel.ToEntity();
_QuoteService.BMSUnit.QuoteDetailsRepository.Add(detailEntity);
_QuoteService.BMSUnit.QuoteDetailsRepository.SaveChanges();
}
strMessage = "Information has been saved successfully";
}
catch (Exception ex)
{
strMessage = CommonExceptionMessage.GetExceptionMessage(ex, CommonAction.Save);
}
return(Json(new { strMessage = strMessage }));
}
public QuoteDetailModel GetQuoteDetail(int quoteID)
{
var result = new QuoteDetailModel();
var allQuotes = GetData();
if (allQuotes.Count > 0)
{
result = allQuotes.Where(a => a.ID == quoteID).FirstOrDefault();
}
return(result);
}
public async Task <ActionResult> QuoteDetail(int id)
{
var data = new QuoteDetailModel();
if (id != 0)
{
var uri = "quotes/getQuotedetail/" + id.ToString();
client = _clientHelper.GetClient();
data = await _restHelper.GetSingleObject <QuoteDetailModel>(uri, client);
}
return(View(data));
}
public static QuoteDetail MapClientToServer(this QuoteDetailModel source)
{
return(new QuoteDetail
{
QuoteDetailId = source.QuoteDetailId,
QuoteId = source.QuoteId,
ProductId = source.ProductId,
ModelId = source.ModelId,
Make = source.Make,
Price = source.Price,
Quantity = source.Quantity,
Discount = source.Discount
});
}
public JsonResult SetQuoteDetailsListForSave(List <QuoteDetailViewModel> lstQuoteDetails)
{
var strMessage = string.Empty;
// Clear detail list
Session["lstQuoteDetails"] = null;
try
{
List <QuoteDetailModel> list = new List <QuoteDetailModel>();
var _QuoteModel = new QuoteModel();
// Add new detail information
foreach (var item in lstQuoteDetails)
{
QuoteDetailModel entityModel = new QuoteDetailModel();
entityModel.QuoteId = item.QuoteId;
entityModel.ArticleId = item.ArticleId;
entityModel.QuoteQuantity = Convert.ToDecimal(item.QuoteQuantity);
entityModel.MOQ = Convert.ToInt64(item.MOQ);
entityModel.ValidityDate = item.ValidityDate;
entityModel.UnitPrice = Convert.ToDecimal(item.UnitPrice);
entityModel.SupplierId = item.SupplierId;
entityModel.Origin = item.Origin;
entityModel.ApproveState = item.ApproveState;
entityModel.DetailText = item.DetailText;
list.Add(entityModel);
}
Session["lstQuoteDetails"] = list;
return(Json(_QuoteModel, JsonRequestBehavior.AllowGet));
//strMessage = Boolean.TrueString;
}
catch (Exception ex)
{
strMessage = CommonExceptionMessage.GetExceptionMessage(ex, CommonAction.Save);
}
return(Json(new { strMessage = strMessage }));
}
public static tblQuoteDetails ToEntity(this QuoteDetailModel model)
{
return(Mapper.Map <QuoteDetailModel, tblQuoteDetails>(model));
}
