public AssayBill AddAssayBillWithSave(Assay oldAssay, int user_id, string billIndex, Contract cont,
IList <GrainQualityIndex> GrainQualityIndexList, List <string> resultList)
{
//新增一个SampleDetail
SampleDetail newSampleDetail = new SampleDetail();
newSampleDetail.sample_number = oldAssay.sample_number;
newSampleDetail.sample_detail_number = oldAssay.sample_number + billIndex;
newSampleDetail.saved = oldAssay.Sample.sample_saved;
_unitOfWork.AddAction(newSampleDetail, DataActions.Add);
//AssayBill新增
AssayBill newAssayBill = new AssayBill();
newAssayBill.assay_bill_number = oldAssay.assay_number + billIndex;
newAssayBill.assay_number = oldAssay.assay_number;
newAssayBill.assay_time = oldAssay.create_time.Value;
newAssayBill.assay_user = user_id;
newAssayBill.sample_detail = newSampleDetail.sample_detail_number;
_unitOfWork.AddAction(newAssayBill, DataActions.Add);
AddAssayResultWithUnitOfWork(newAssayBill, cont, GrainQualityIndexList, resultList);
_unitOfWork.Save();
return(newAssayBill);
}
public bool Update(Sample items)
{
bool result = false;
try
{
context.Entry(items).State = EntityState.Modified;
context.SaveChanges();
foreach (var row in items.Details)
{
var details = new SampleDetail();
details.SampleId = row.SampleId;
details.ProductCode = row.ProductCode;
details.Quantity = row.Quantity;
details.User = row.User;
details.DateCreated = DateTime.Now.ToString("dd/MM/yyyy hh:mm");
details.Value1 = row.Value1;
details.Value2 = row.Value2;
details.Value3 = row.Value3;
details.Value4 = row.Value4;
details.Value5 = row.Value5;
//esta variable determina la accion a ejecutar en el registro
//null or empty = Nothing
// 1 = Add
// 2 = Update
// 3 = Delete
int status = (string.IsNullOrEmpty(row.Value1)) ? 0 : int.Parse(row.Value1);
switch (status)
{
case 1:
AddDetail(details);
break;
case 2:
details.Id = row.Id;
UpdateDetail(details);
break;
case 3:
details.Id = row.Id;
DeleteDetail(details);
break;
}
}
result = true;
}
catch (Exception ex)
{
result = false;
Debug.Write(@"Error " + ex.Message);
}
return(result);
}
public async Task <IActionResult> Details(int sampleDetailId)
{
SampleDetail foundSampleDetail = await factory.Samples.GetSampleDetailFromSampleDetailID(sampleDetailId);
if (foundSampleDetail == null)
{
return(NotFound());
}
return(View(foundSampleDetail));
}
private void UpdateDetail(SampleDetail detail)
{
try
{
context.Entry(detail).State = EntityState.Modified;
context.SaveChanges();
}
catch (Exception ex)
{
throw;
}
}
private void DeleteDetail(SampleDetail detail)
{
try
{
context.SampleDetails.Remove(detail);
context.SaveChanges();
}
catch (Exception ex)
{
throw;
}
}
private void AddDetail(SampleDetail detail)
{
try
{
context.SampleDetails.Add(detail);
context.SaveChanges();
}
catch (Exception ex)
{
throw;
}
}
public async Task <SampleDetail> GetSampleDetailAsync(string sampleId, EntityHeader org, EntityHeader user)
{
var sample = await _sampleRepo.GetSampleAsync(sampleId, org.Id);
var labels = await _labelSampleRepo.GetLabelsForSampleAsync(sampleId);
var detail = SampleDetail.FromSample(sample);
detail.Labels = new List <EntityHeader>(labels.Select(lbl => EntityHeader.Create(lbl.LabelId, lbl.Label)));
await AuthorizeAsync(detail, AuthorizeResult.AuthorizeActions.Read, user, org);
return(detail);
}
private void addDetail(int detailKey, int sampleKey)
{
var detailText = "Detail" + sampleKey + '.' + detailKey;
expectedData !.Details.Add(detailKey, detailText);
var sample = DC.Data.SampleX[sampleKey];
var detail = new SampleDetail(detailText, sample, false);
detail.Store();
expectedData !.Samples.Remove(sampleKey);
expectedData !.Samples.Add(sampleKey, sample.ToString());
assertData();
}
public async Task <IActionResult> Edit(int sampleDetailId)
{
ViewBag.Error = false;
ViewBag.ErrorMessage = "";
SampleDetail editSampleDetail = await factory.Samples.GetSampleDetailFromSampleDetailID(sampleDetailId);
if (editSampleDetail == null)
{
return(NotFound());
}
return(View("CreateOrUpdate", editSampleDetail));
}
public async Task <IActionResult> Save(SampleDetail sampleDetail)
{
ViewBag.Error = true;
string errorMessage = string.Empty;
if (!ModelState.IsValid)
{
foreach (var key in ModelState.Keys)
{
var modelStateVal = ModelState[key];
foreach (var error in modelStateVal.Errors)
{
errorMessage += error.ErrorMessage + "<br>";
}
}
ViewBag.ErrorMessage = errorMessage;
return(View("CreateOrUpdate"));
}
if (sampleDetail.SampleDetailID == 0)
{
if (!(User.IsInRole("Sample", AuthType.Add)))
{
return(Unauthorized());
}
await factory.Samples.AddSampleDetail(sampleDetail, int.Parse(User.Identity.Name));
}
else
{
if (!(User.IsInRole("Sample", AuthType.Update)))
{
return(Unauthorized());
}
var foundSampleDetails = await factory.Samples.GetSampleDetailFromSampleDetailID(sampleDetail.SampleDetailID);
foundSampleDetails.Meter = sampleDetail.Meter;
foundSampleDetails.DateTime = sampleDetail.DateTime;
foundSampleDetails.Details = sampleDetail.Details;
await factory.Samples.UpdateSampleDetail(foundSampleDetails, int.Parse(User.Identity.Name));
}
return(RedirectToAction("Index", new { sampleDetail.RuloID, sampleDetail.SampleID }));
}
public int Save(Sample items)
{
int id = 0;
try
{
var user = items.User;
items.DateCreated = DateTime.Now.ToString("dd/MM/yyyy hh:mm");
context.Samples.Add(items);
context.SaveChanges();
id = items.Id;
if (id > 0)
{
var detail = new SampleDetail();
foreach (var row in items.Details)
{
detail.SampleId = id;
detail.ProductCode = row.ProductCode;
detail.Quantity = row.Quantity;
detail.User = user;
detail.DateCreated = row.DateCreated;
detail.Value1 = row.Value1;
detail.Value2 = row.Value2;
detail.Value3 = row.Value3;
detail.Value4 = row.Value4;
detail.Value5 = row.Value5;
context.SampleDetails.Add(detail);
context.SaveChanges();
}
}
}
catch (Exception ex)
{
id = 0;
Debug.Write(@"Error " + ex.Message);
}
return(id);
}
public async Task <IActionResult> Create(int sampleId)
{
ViewBag.Error = false;
ViewBag.ErrorMessage = "";
var sample = await factory.Samples.GetSampleFromSampleID(sampleId);
if (sample == null)
{
NotFound();
}
SampleDetail newSampleDetail = new SampleDetail();
newSampleDetail.SampleID = sample.SampleID;
newSampleDetail.RuloID = sample.RuloID;
newSampleDetail.RuloProcessID = sample.RuloProcessID;
newSampleDetail.DateTime = DateTime.Now;
return(View("CreateOrUpdate", newSampleDetail));
}
public Assay AddAssayWithUnitOfWork(Sample newSample, SampleDetail newSampleDetail, int user_id, Contract cont,
IList <GrainQualityIndex> GrainQualityIndexList, List <string> resultList,
AssayStatus status, string AssayBillIndex, OrganizationDepartment org, int gradeID)
{
Assay newAssay = new Assay();
int billID = _sysBillNoService.GetBillNoID("QUM", "ASN");
newAssay.assay_number = _sysBillNoService.GetBillNo(billID);
//newAssay.assay_result = null;
//newAssay.bill_owner_org = 1;
//newAssay.confirm_time = null;
newAssay.confirm_user = user_id;
newAssay.create_time = _sPGetSysDateTimeService.GetSysDateTime();
newAssay.grain_grade = gradeID;
newAssay.remark = "";
newAssay.sample_number = newSample.sample_number;
newAssay.status = (int)status;
_unitOfWork.AddAction(newAssay, DataActions.Add);
AddAssayBillWithUnitOfWork(newAssay, user_id, newSampleDetail, cont, GrainQualityIndexList, resultList, AssayBillIndex);
//newAssay.grain_grade = JudgeGrainGrade(newAssay.AssayBills.First().AssayResults,
return(newAssay);
}
public void AddAssayBillWithUnitOfWork(Assay newAssay, int user_id, SampleDetail newSampleDetail, Contract cont,
IList <GrainQualityIndex> GrainQualityIndexList, List <string> resultList, string AssayBillIndex)
{
//AssayBill新增
AssayBill newAssayBill = new AssayBill();
if (AssayBillIndex == string.Empty)
{
int billNumberIndex = 1;
if (newAssay != null && newAssay.AssayBills != null && newAssay.AssayBills.Count != 0)
{
billNumberIndex = newAssay.AssayBills.Count + 1;
}
AssayBillIndex = billNumberIndex.ToString("D2");
}
newAssayBill.assay_bill_number = newAssay.assay_number + AssayBillIndex;
newAssayBill.assay_number = newAssay.assay_number;
newAssayBill.assay_time = newAssay.create_time.Value;
newAssayBill.assay_user = user_id;
newAssayBill.sample_detail = newSampleDetail.sample_detail_number;
_unitOfWork.AddAction(newAssayBill, DataActions.Add);
AddAssayResultWithUnitOfWork(newAssayBill, cont, GrainQualityIndexList, resultList);
}
public abstract Task DeleteSampleDetail(SampleDetail sampleDetail, int deleterRef);
public override async Task AddSampleDetail(SampleDetail sampleDetail, int adderRef)
{
await repositorySampleDetail.Add(sampleDetail, adderRef);
}
public override async Task DeleteSampleDetail(SampleDetail sampleDetail, int deleterRef)
{
await repositorySampleDetail.Remove(sampleDetail.SampleDetailID, deleterRef);
}
public override async Task UpdateSampleDetail(SampleDetail sampleDetail, int updaterRef)
{
await repositorySampleDetail.Update(sampleDetail, updaterRef);
}
public abstract Task UpdateSampleDetail(SampleDetail sampleDetail, int updaterRef);
public abstract Task AddSampleDetail(SampleDetail sampleDetail, int adderRef);