public IActionResult OnPost()
{
if (!ModelState.IsValid)
{
return(Page());
}
PersonnelFile.Id = _pinhuaContext.CreatePersonnelFileId("PF", 4);
var rcId = _pinhuaContext.GetNewRcId();
var rtId = _pinhuaContext.GetRtId("人员档案");
var repCase = new EsRepCase
{
RcId = rcId,
RtId = rtId,
LstFiller = 2,
LstFillerName = User.Identity.Name,
LstFillDate = DateTime.Now,
FillDate = DateTime.Now,
};
PersonnelFile.ExcelServerRcid = rcId;
PersonnelFile.ExcelServerRtid = rtId;
PersonnelFile.SignedDate = DateTime.Now;
_pinhuaContext.EsRepCase.Add(repCase);
_pinhuaContext.人员档案.Add(_mapper.Map <PersonnelFilesDTO, 人员档案>(PersonnelFile));
_pinhuaContext.SaveChanges();
return(RedirectToPage("Index"));
}
public IActionResult OnPost()
{
if (ModelState.IsValid)
{
var Rcid = _pinhuaContext.GetNewRcId();
var rtId = "165.1";
var repCase = new EsRepCase
{
RcId = Rcid,
RtId = rtId,
LstFiller = 2,
LstFillerName = User.Identity.Name,
LstFillDate = DateTime.Now,
//fillDate = DateTime.Now,
//wiId = "",
//state = 1,
};
var main = _mapper.Map <WarehouseDTO, Data.Entities.Pinhua.Warehouse>(WarehouseInfo.Main);
main.ExcelServerRcid = Rcid;
main.ExcelServerRtid = rtId;
_pinhuaContext.EsRepCase.Add(repCase);
_pinhuaContext.Warehouse.Add(main);
_pinhuaContext.SaveChanges();
return(RedirectToPage("Index"));
}
else
{
return(Page());
}
}
public IActionResult OnPost()
{
if (ModelState.IsValid)
{
var Rcid = _pinhuaContext.GetNewRcId();
var rtId = "178.1";
var repCase = new EsRepCase
{
RcId = Rcid,
RtId = rtId,
LstFiller = 2,
LstFillerName = User.Identity.Name,
LstFillDate = DateTime.Now,
//fillDate = DateTime.Now,
//wiId = "",
//state = 1,
};
var main = _mapper.Map <ProductRegistrationDTO, ProductRegistrationMain>(ProductRegistrationInfo);
main.ExcelServerRcid = Rcid;
main.ExcelServerRtid = rtId;
_pinhuaContext.EsRepCase.Add(repCase);
_pinhuaContext.ProductRegistrationMain.Add(main);
_pinhuaContext.SaveChanges();
return(RedirectToPage("Index"));
}
else
{
return(Page());
}
}
public IActionResult OnPost()
{
if (ModelState.IsValid)
{
var Rcid = _pinhuaContext.GetNewRcId();
var rtId = "157.1";
var repCase = new EsRepCase
{
RcId = Rcid,
RtId = rtId,
LstFiller = 2,
LstFillerName = User.Identity.Name,
LstFillDate = DateTime.Now,
//fillDate = DateTime.Now,
//wiId = "",
//state = 1,
};
var main = _mapper.Map <Gi2MainDTO, Gi2Main>(Order.Main);
main.ExcelServerRcid = Rcid;
main.ExcelServerRtid = rtId;
main.CustomerName = _pinhuaContext.往来单位.AsNoTracking().FirstOrDefault(p => p.单位编号 == Order.Main.CustomerId).单位名称;
var details = _mapper.Map <List <Gi2DetaislDTO>, List <Gi2Details> >(Order.Details);
details.ForEach(i =>
{
i.ExcelServerRcid = Rcid;
i.ExcelServerRtid = rtId;
i.DeliveryId = main.DeliveryId;
});
if (details.Count == 0)
{
ModelState.AddModelError("", "出库清单不可为空");
DeliveryTypes = BuildTypes();
CustomerSelectList = _pinhuaContext.GetCustomerSelectList();
ContactsSelectList = _pinhuaContext.GetContactsSelectList();
return(Page());
}
_pinhuaContext.EsRepCase.Add(repCase);
_pinhuaContext.Gi2Main.Add(main);
_pinhuaContext.Gi2Details.AddRange(details);
_pinhuaContext.SaveChanges();
return(RedirectToPage("Index"));
}
else
{
DeliveryTypes = BuildTypes();
CustomerSelectList = _pinhuaContext.GetCustomerSelectList();
ContactsSelectList = _pinhuaContext.GetContactsSelectList();
return(Page());
}
}
public IActionResult OnPost()
{
if (ModelState.IsValid)
{
var Rcid = _pinhuaContext.GetNewRcId();
var rtId = "175.1";
var repCase = new EsRepCase
{
RcId = Rcid,
RtId = rtId,
LstFiller = 2,
LstFillerName = User.Identity.Name,
LstFillDate = DateTime.Now,
//fillDate = DateTime.Now,
//wiId = "",
//state = 1,
};
var main = _mapper.Map <ProductionStockInMainDTO, StockInMain>(Order.Main);
main.ExcelServerRcid = Rcid;
main.ExcelServerRtid = rtId;
main.MovementType = "131";
var details = _mapper.Map <List <ProductionStockInDetailsDTO>, List <StockInDetails> >(Order.Details);
details.ForEach(i =>
{
i.ExcelServerRcid = Rcid;
i.ExcelServerRtid = rtId;
i.OrderId = main.OrderId;
});
if (details.Count == 0)
{
ModelState.AddModelError("", "清单不可为空");
Order.MovementTypeList = BuildTypes();
Order.CustomerList = _pinhuaContext.GetCustomerSelectList();
Order.WarehouseList = _pinhuaContext.GetWarehouseSelectList();
return(Page());
}
_pinhuaContext.EsRepCase.Add(repCase);
_pinhuaContext.StockInMain.Add(main);
_pinhuaContext.StockInDetails.AddRange(details);
_pinhuaContext.SaveChanges();
return(RedirectToPage("Index"));
}
else
{
Order.MovementTypeList = BuildTypes();
Order.CustomerList = _pinhuaContext.GetCustomerSelectList();
Order.WarehouseList = _pinhuaContext.GetWarehouseSelectList();
return(Page());
}
}
public IActionResult OnPost()
{
if (ModelState.IsValid)
{
var Rcid = _pinhuaContext.GetNewRcId();
var rtId = _pinhuaContext.GetRtId("入库简易版");
var repCase = new EsRepCase
{
RcId = Rcid,
RtId = rtId,
LstFiller = 2,
LstFillerName = User.Identity.Name,
LstFillDate = DateTime.Now,
//fillDate = DateTime.Now,
//wiId = "",
//state = 1,
};
var main = _mapper.Map <Gr2MainDto, Gr2Main>(Purchasing.Main);
main.ExcelServerRcid = Rcid;
main.ExcelServerRtid = rtId;
main.SupplierName = _pinhuaContext.往来单位.AsNoTracking().FirstOrDefault(p => p.单位编号 == main.Supplier).单位名称;
var details = _mapper.Map <List <Gr2DetailsDto>, List <Gr2Details> >(Purchasing.Details);
details.ForEach(i =>
{
i.ExcelServerRcid = Rcid;
i.ExcelServerRtid = rtId;
i.PurchasingId = main.PurchasingId;
});
if (Purchasing.Details.Count == 0)
{
ModelState.AddModelError("", "采购清单不可为空");
PurchasingTypes = buildPurchasingTypes();
SupplierList = _pinhuaContext.GetCustomerSelectList();
return(Page());
}
_pinhuaContext.EsRepCase.Add(repCase);
_pinhuaContext.Gr2Main.Add(main);
_pinhuaContext.Gr2Details.AddRange(details);
_pinhuaContext.SaveChanges();
return(RedirectToPage("Index"));
}
else
{
PurchasingTypes = buildPurchasingTypes();
SupplierList = _pinhuaContext.GetCustomerSelectList();
return(Page());
}
}
public IActionResult OnPost()
{
var year = DateTime.Now.ToString("yy");
var exsistedIds = (from p in _pinhuaContext.收款单
where p.收款单号.Substring(0, 4) == "SK" + year
orderby p.收款单号 descending
select p.收款单号)
.ToList();
var orderIndex = int.Parse(exsistedIds.Count() == 0 ? "0" : exsistedIds.First().Substring(4, 6)) + 1;
var name = _pinhuaContext.往来单位.FirstOrDefault(x => x.单位编号 == Collection.单位编号)?.单位名称;
Collection.收款单号 = "SK" + year + orderIndex.ToString("D6");
Collection.收款单位 = name;
var rcId = _pinhuaContext.GetNewRcId();
var rtId = _pinhuaContext.GetRtId("收款单");
var repCase = new EsRepCase
{
RcId = rcId,
RtId = rtId,
LstFiller = 2,
LstFillerName = User.Identity.Name,
LstFillDate = DateTime.Now,
FillDate = DateTime.Now,
};
Collection.ExcelServerRcid = rcId;
Collection.ExcelServerRtid = rtId;
_pinhuaContext.EsRepCase.Add(repCase);
_pinhuaContext.收款单.Add(Collection);
_pinhuaContext.SaveChanges();
return(RedirectToPage("Index"));
}
public IActionResult OnPost(int yyyy, int mm, string jsonStr)
{
if (string.IsNullOrEmpty(jsonStr))
{
return(Page());
}
var Payrolls = Newtonsoft.Json.JsonConvert.DeserializeObject <IList <PayrollDetailsDTO> >(jsonStr);
if (Payrolls == null)
{
return(Page());
}
var Rcid = _pinhuaContext.GetNewRcId();
var rtId = _pinhuaContext.GetRtId("工资单");
var repCase = new EsRepCase
{
RcId = Rcid,
RtId = rtId,
LstFiller = 2,
LstFillerName = User.Identity.Name,
LstFillDate = DateTime.Now,
};
var payrollMain = new PayrollMain
{
ExcelServerRcid = Rcid,
ExcelServerRtid = rtId,
Y = yyyy,
M = mm
};
var payrollDetails = new List <PayrollDetails>();
foreach (var payroll in Payrolls)
{
var pd = new PayrollDetails
{
ExcelServerRcid = Rcid,
ExcelServerRtid = rtId,
Y = yyyy,
M = mm,
};
_mapper.Map <PayrollDetailsDTO, PayrollDetails>(payroll, pd);
payrollDetails.Add(pd);
}
_pinhuaContext.EsRepCase.Add(repCase);
_pinhuaContext.PayrollMain.Add(payrollMain);
_pinhuaContext.PayrollDetails.AddRange(payrollDetails);
try
{
_pinhuaContext.SaveChanges();
}
catch (DbUpdateException e)
{
ModelState.AddModelError("", e.InnerException.Message);
return(Page());
}
return(RedirectToPage("Index"));
}
public IActionResult OnPost(string jsonStr)
{
if (string.IsNullOrEmpty(jsonStr))
{
return(Page());
}
var data = Newtonsoft.Json.JsonConvert.DeserializeObject <AttendanceServiceDTO>(jsonStr);
if (data == null)
{
return(Page());
}
var Rcid = _pinhuaContext.GetNewRcId();
var rtId = _pinhuaContext.GetRtId("AttendanceReport");
var repCase = new EsRepCase
{
RcId = Rcid,
RtId = rtId,
LstFiller = 2,
LstFillerName = User.Identity.Name,
LstFillDate = DateTime.Now,
};
var reportMain = new AttendanceReport
{
ExcelServerRcid = Rcid,
ExcelServerRtid = rtId,
Y = data.Y.Value,
M = data.M.Value
};
var reportDetails = new List <AttendanceReportResults>();
foreach (var person in data.PersonList)
{
var detail = new AttendanceReportResults
{
ExcelServerRcid = Rcid,
ExcelServerRtid = rtId,
Y = data.Y.Value,
M = data.M.Value,
编号 = person.Id,
姓名 = person.Name,
是否全勤 = person.IsFullAttendance ? "是" : "否",
正班 = person.DaytimeHours,
加班 = person.OvertimeHours,
总工时 = person.TotalHours,
缺勤 = person.TimesOfAbsent,
迟到 = person.TimesOfLate,
早退 = person.TimesOfLeaveEarly,
请假 = person.TimesOfAskForLeave,
用餐 = person.TimesOfDinner,
};
reportDetails.Add(detail);
}
// 保存明细
var abc = new List <AttendanceReportDetails>();
foreach (var person in data.PersonList)
{
foreach (var detail in person.Results)
{
foreach (var range in detail.Details)
{
var o = new AttendanceReportDetails
{
编号 = person.Id,
姓名 = person.Name,
日期 = detail.Date,
班段 = range.RangeId,
班段描述 = range.Range,
班 = range.Time1Fix,
班 = range.Time2Fix,
工时 = range.Hours,
考勤结果 = range.State,
ExcelServerRcid = Rcid,
ExcelServerRtid = rtId,
};
abc.Add(o);
}
}
}
_pinhuaContext.EsRepCase.Add(repCase);
_pinhuaContext.AttendanceReport.Add(reportMain);
_pinhuaContext.AttendanceReportResults.AddRange(reportDetails);
_pinhuaContext.AttendanceReportDetails.AddRange(abc);
_pinhuaContext.SaveChanges();
return(RedirectToPage("Index"));
}
public IActionResult OnPost()
{
if (ModelState.IsValid)
{
var Rcid = _pinhuaContext.GetNewRcId();
var rtId = "179.1";
var repCase = new EsRepCase
{
RcId = Rcid,
RtId = rtId,
LstFiller = 2,
LstFillerName = "*****@*****.**",
LstFillDate = DateTime.Now,
//fillDate = DateTime.Now,
//wiId = "",
//state = 1,
};
var main = _mapper.Map <dto生产单M, 生产单>(Order.M);
main.单号 = _pinhuaContext.GetZkyAutoId(181);
main.ExcelServerRcid = Rcid;
main.ExcelServerRtid = rtId;
main.客户名 = _pinhuaContext.往来单位.AsNoTracking().FirstOrDefault(p => p.单位编号 == Order.M.客户号).单位名称;
if (Order?.D?.Count == 0)
{
ModelState.AddModelError("", "产品清单不可为空");
PartnerSelectList = _pinhuaContext.GetCustomerSelectList();
return(Page());
}
foreach (var d in Order.D)
{
var newRecord = new 生产单d
{
ExcelServerRcid = Rcid,
ExcelServerRtid = rtId,
长 = d.长,
宽 = d.宽,
高 = d.高,
片数 = d.片数,
刻线要求 = d.刻线要求,
拉丝要求 = d.拉丝要求,
开槽要求 = d.开槽要求,
油漆要求 = d.油漆要求,
描述 = d.描述,
其他要求 = d.其他要求,
是否刻线 = d.是否刻线,
是否拉丝 = d.是否拉丝,
是否开槽 = d.是否开槽,
是否油漆 = d.是否油漆,
图片name = d.图片name,
图片type = d.图片type,
};
if (!string.IsNullOrEmpty(d.图片base64)) // base64非空，插入图片
{
var picNo = _pinhuaContext.GetNewPicNo();
var newBase64 = d.图片base64.Substring(d.图片base64.IndexOf(',') + 1);
_pinhuaContext.EsCasePic.Add(new EsCasePic
{
RcId = Rcid,
PicNo = picNo,
Img = Convert.FromBase64String(newBase64),
FileType = string.IsNullOrEmpty(d.图片name) ? ".jpg" : d.图片name.Substring(d.图片name.LastIndexOf(".")),
RtfId = 2573,
Sh = 2,
R = 21,
C = 51,
IsNew = 0,
Rng = null,
SaveInto = 0,
NfsfolderId = 0,
Nfsfolder = "",
PhyFileName = "",
RelaFolder = ""
});
newRecord.图片 = picNo;
}
_pinhuaContext.生产单d.Add(newRecord);
}
_pinhuaContext.EsRepCase.Add(repCase);
_pinhuaContext.生产单.Add(main);
_pinhuaContext.SaveChanges();
return(RedirectToPage("Index"));
}
else
{
PartnerSelectList = _pinhuaContext.GetCustomerSelectList();
return(Page());
}
}