public Rec_JobConditionModel GetById(Guid id)
{
string status = string.Empty;
var model = new Rec_JobConditionModel();
ActionService service = new ActionService(UserLogin);
var entity = service.GetByIdUseStore<Rec_JobConditionEntity>(id, ConstantSql.hrm_rec_sp_get_JobConditionById, ref status);//note
if (entity != null)
{
model = entity.CopyData<Rec_JobConditionModel>();
if (model.ConditionName == ConditionName.E_DISEASEIDS.ToString() && !string.IsNullOrEmpty(model.Value1))
{
var service1 = new BaseService();
var lst = service1.GetData<Cat_ComputingLevelMultiEntity>(model.Value1, ConstantSql.hrm_cat_sp_get_LevelGeneralByIds, UserLogin ,ref status).ToList();
var ids = model.Value1
.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries)
.Select(x => Common.OracleToDotNet(x.ToString()))
.ToList();
model.Value1 = string.Join(",", ids);
model.DiseaseIDs = string.Join(",", ids);
// model.ArrDisease = lst;
}
}
model.ActionStatus = status;
return model;
}
public string ActionApprovedCandidate(string selectedIds)
{
using (var context = new VnrHrmDataContext())
{
BaseService service = new BaseService();
string message = string.Empty;
string status = string.Empty;
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoCandidate = new Rec_CandidateRepository(unitOfWork);
var repoHistory = new Rec_RecruitmentHistoryRepository(unitOfWork);
List<Guid> lstcandidateIds = selectedIds.Split(',').Select(x => Guid.Parse(x)).ToList();
var lstCandidates = repoCandidate.FindBy(m => m.ID != null && lstcandidateIds.Contains(m.ID)).ToList();
var lstRecruimentHistory = repoHistory.FindBy(m => m.CandidateID != null && lstcandidateIds.Contains(m.CandidateID)).ToList();
foreach (var Candidate in lstCandidates)
{
Candidate.Status = HRM.Infrastructure.Utilities.EnumDropDown.CandidateStatus.E_APPROVE.ToString();
Candidate.DateUpdate = DateTime.Now;
var hisbycandidate = lstRecruimentHistory.Where(s => s.CandidateID == Candidate.ID).OrderByDescending(s => s.DateApply).FirstOrDefault();
hisbycandidate.Status = HRM.Infrastructure.Utilities.EnumDropDown.CandidateStatus.E_APPROVE.ToString();
hisbycandidate.CandidateID = Candidate.ID;
hisbycandidate.DateUpdate = DateTime.Now;
}
repoCandidate.SaveChanges();
repoHistory.SaveChanges();
message = NotificationType.Success.ToString();
return message;
}
}
public Eva_BonusSalaryModel Post([Bind]Eva_BonusSalaryModel model)
{
#region Validate
string message = string.Empty;
var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Eva_BonusSalaryModel>(model, "Eva_BonusSalary", ref message);
if (!checkValidate)
{
model.ActionStatus = message;
return model;
}
#endregion
#region kt dữ liệu khi tính phòng ban, tháng hoặc quý
if (string.IsNullOrEmpty(model.Quarter) && string.IsNullOrEmpty(model.Month.ToString()))
{
message = string.Format(ConstantMessages.FieldNotAllowNull.TranslateString(), ("Quarter").TranslateString()) + " Or " + string.Format(ConstantMessages.FieldNotAllowNull.TranslateString(), ("Month").TranslateString());
model.ActionStatus = message;
return model;
}
#endregion
var service = new Eva_BonusSalaryServices();
var bService = new BaseService();
var bonusSalaryEntity = model.CopyData<Eva_BonusSalaryEntity>();
var m = service.CalculateBonusSalary(bonusSalaryEntity,UserLogin);
return m.CopyData<Eva_BonusSalaryModel>();
}
public void Execute()
{
if (!string.IsNullOrWhiteSpace(JobArgs))
{
BaseService service = new BaseService();
string status = string.Empty;
var taskArgs = JobArgs.Split('|');
JobType = taskArgs.Length > 0 ? taskArgs[0] : string.Empty;
var procedure = taskArgs.Length > 1 ? taskArgs[1] : string.Empty;
var email = taskArgs.Length > 2 ? taskArgs[2] : string.Empty;
try
{
//Gọi lệnh thực thi câu stored procedure
service.ActionData(procedure,ref status);
}
catch (Exception ex)
{
//Gọi hàm gửi mail và throw exception để lớp dưới ghi log
//Sử dụng TaskName làm tiêu đề mail gửi đi + exception
SendMail(email, JobType, ex.GetExceptionMessage());
throw;
}
}
}
public ActionResult ConfirmarExclusao(int id)
{
var servico = new BaseService<regional>();
servico.Excluir(ent => ent.regionalid == id);
servico.Salvar();
return RedirectToAction("Index");
}
public string ActionBlackListCandidate(string selectedIds, Guid? _ReasonBlackListID)
{
using (var context = new VnrHrmDataContext())
{
BaseService service = new BaseService();
string message = string.Empty;
string status = string.Empty;
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoCandidate = new Rec_CandidateRepository(unitOfWork);
var repoHistory = new Rec_RecruitmentHistoryRepository(unitOfWork);
List<Guid> lstcandidateIds = selectedIds.Split(',').Select(x => Guid.Parse(x)).ToList();
var lstCandidates = repoCandidate.FindBy(m => m.ID != null && lstcandidateIds.Contains(m.ID)).ToList();
var lstRecruimentHistory = repoHistory.FindBy(m => m.CandidateID != null && lstcandidateIds.Contains(m.CandidateID)).ToList();
foreach (var Candidate in lstCandidates)
{
Candidate.IsBlackList = true;
Candidate.ReasonBlackListID = _ReasonBlackListID;
var hisbycandidate = lstRecruimentHistory.Where(s => s.CandidateID == Candidate.ID).OrderByDescending(s => s.DateApply).FirstOrDefault();
hisbycandidate.IsBlackList = true;
}
repoCandidate.SaveChanges();
repoHistory.SaveChanges();
message = NotificationType.Success.ToString();
return message;
}
}
public List<Att_LeaveDayEntity> Get_LeaveDay_WillBeApproveByUser(Guid UserLoginID, List<Att_LeaveDayEntity> lstLeavedayAfterFilter, string userLogin)
{
BaseService service = new BaseService();
string status = string.Empty;
List<object> lstParam = new List<object>();
lstParam.AddRange(new object[10]);
var lstDelegateApprove = service.GetData<Sys_DelegateApprove>(lstParam, ConstantSql.hrm_sys_sp_get_DelegateApprove, userLogin, ref status);
DateTime today = DateTime.Today;
string E_LEAVEDAY = DelegateApproveType.E_LEAVE_DAY.ToString();
List<Guid> lstUserCanView = lstDelegateApprove.Where(m => m.UserID != null
&& m.DataTypeDelegate == E_LEAVEDAY
&& m.DateFrom <= today
&& m.DateTo >= today
&& m.UserDelegateID == UserLoginID).Select(m => m.UserID.Value).ToList();
lstUserCanView.Add(UserLoginID);
string E_SUBMIT = LeaveDayStatus.E_SUBMIT.ToString();
string E_APPROVED = LeaveDayStatus.E_APPROVED.ToString();
string E_REJECTED = LeaveDayStatus.E_REJECTED.ToString();
string E_CANCEL = LeaveDayStatus.E_CANCEL.ToString();
var lstLeaveDay = lstLeavedayAfterFilter.Where(m =>
m.Status != E_APPROVED
&& m.Status != E_REJECTED
&& m.Status != E_CANCEL
&& ((m.Status == E_SUBMIT && m.UserApproveID != null && lstUserCanView.Contains(m.UserApproveID.Value))
|| (m.UserApproveID2 != null && lstUserCanView.Contains(m.UserApproveID2.Value)))).ToList();
return lstLeaveDay;
}
public JsonResult DeleteItems(string idList)
{
var flag = false;
var count = 0;
if (idList != null)
{
count = idList.Split(',').Count();
flag = new BaseService().Delete("Product", idList);
}
return Json(new { flag = flag, count = count });
}
public List<Cat_ShiftItemEntity> GetCatShiftItem( string userLogin)
{
using (var context = new VnrHrmDataContext())
{
IUnitOfWork unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
Cat_ShiftItemRepository repo = new Cat_ShiftItemRepository(unitOfWork);
BaseService service = new BaseService();
string status = string.Empty;
return service.GetData<Cat_ShiftItemEntity>(ConstantSql.hrm_cat_sp_get_ShiftItem, string.Empty, userLogin, ref status);
}
}
public ActionResult Editar(int? id)
{
if (id == null)
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
regional regional = new BaseService<regional>().Obter(id.Value);
if (regional == null)
return HttpNotFound();
return View(regional);
}
public JsonResult Edit(Solution solution)
{
var res = false;
if (solution.Id == null || solution.Id == Guid.Empty.ToSafeTrim())
{
solution.Id = Guid.NewGuid().ToSafeTrim();
res = new BaseService().Insert<Solution>(solution);
}
else
res = new BaseService().Update<Solution>(solution);
return Json(new { res = res });
}
public JsonResult Edit(AboutUs us)
{
var res = false;
if (us.Id == null || us.Id == Guid.Empty.ToSafeTrim())
{
us.Id = Guid.NewGuid().ToSafeTrim();
res = new BaseService().Insert<AboutUs>(us);
}
else
res = new BaseService().Update<AboutUs>(us);
return Json(new { res = res });
}
public ActionResult Editar(int? id)
{
if (id == null)
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
adepto adepto = new BaseService<adepto>().Obter(id.Value);
if (adepto == null)
return HttpNotFound();
return View(adepto);
}
public void SetStatusSelected(string selectedIds, string status)
{
if (!string.IsNullOrEmpty(selectedIds))
{
selectedIds = Common.DotNetToOracle(selectedIds);
BaseService service = new BaseService();
string statusMessages = string.Empty;
List<object> lstObj = new List<object>();
lstObj.Add(selectedIds);
lstObj.Add(status);
service.UpdateData<Att_LeaveDayModel>(lstObj, ConstantSql.hrm_att_sp_get_Leaveday_UpdateStatus, ref statusMessages);
}
}
public ActionResult Editar([Bind(Include = "adeptoid,nome,datanascimento,email,telefoneresidencial,telefonecomercial,telefonecelular,dataprimeiravez,datainclusao")] adepto adepto)
{
if (ModelState.IsValid)
{
//Campo atribuído automaticamente
adepto.dataalteracao = DateTime.Now;
var servico = new BaseService<adepto>();
servico.Alterar(adepto);
servico.Salvar();
return RedirectToAction("Index");
}
return View(adepto);
}
public ActionResult Editar([Bind(Include = "federacaoid,datainclusao,descricao")] federacao federacao)
{
if (ModelState.IsValid)
{
//Campo atribuído automaticamente
federacao.dataalteracao = DateTime.Now;
var servico = new BaseService<federacao>();
servico.Alterar(federacao);
servico.Salvar();
return RedirectToAction("Index");
}
return View(federacao);
}
public IEnumerable<Eva_SalesTypeMultiModel> Get()
{
BaseService service = new BaseService();
string status = string.Empty;
var listEntity = service.GetDataNotParam<Eva_SalesTypeMultiModel>(ConstantSql.hrm_eva_sp_get_SalesType_multi,UserLogin, ref status);
if (listEntity != null)
{
var listModel = listEntity.Translate<Eva_SalesTypeMultiModel>();
return listModel;
}
return new List<Eva_SalesTypeMultiModel>();
}
public ActionResult Editar(int? id)
{
if (id == null)
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
associacao associacao = new BaseService<associacao>().Obter(id.Value);
if (associacao == null)
return HttpNotFound();
CriarViewBags();
return View(associacao);
}
public ActionResult Editar([Bind(Include = "regionalid,descricao,dataabertura,datainclusao")] regional regional)
{
if (ModelState.IsValid)
{
//Campo atribuído automaticamente
regional.dataalteracao = DateTime.Now;
var servico = new BaseService<regional>();
servico.Alterar(regional);
servico.Salvar();
return RedirectToAction("Index");
}
return View(regional);
}
public Sal_CostCentreSalModel Post([Bind]Sal_CostCentreSalModel model)
{
ActionService service = new ActionService(UserLogin);
#region Validate
string message = string.Empty;
var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Sal_CostCentreSalModel>(model, "Sal_CostCentreSal", ref message);
if (!checkValidate)
{
model.ActionStatus = message;
return model;
}
#endregion
string status = string.Empty;
var baseService = new BaseService();
var objs = new List<object>();
objs.Add(Common.DotNetToOracle(model.ProfileID.ToString()));
objs.Add(1);
objs.Add(10000);
var result = baseService.GetData<Sal_CostCentreSalEntity>(objs, ConstantSql.hrm_hr_sp_get_Sal_CostCentreSalByProfileId, UserLogin, ref status);
//kiem tra he so cua 1 nv
if(model.ID == Guid.Empty)
{
double? rate = result.Sum(s => s.Rate);
double? ratenew = rate + model.Rate;
if (ratenew > 1)
{
model.SetPropertyValue(Constant.ActionStatus, NotificationType.Error + ",");
return model;
}
}
else
{
result = result.Where(s => s.ID != model.ID).ToList();
double? rate = result.Sum(s => s.Rate);
double? ratenew = rate + model.Rate;
if (ratenew > 1)
{
model.SetPropertyValue(Constant.ActionStatus, NotificationType.Error + ",");
return model;
}
}
//kiem tra trung
var resultdulicate = result.Where(s => s.CostCentreID == model.CostCentreID && s.ElementType == model.ElementType).ToList();
if (resultdulicate.Count > 0)
{
model.SetPropertyValue(Constant.ActionStatus, NotificationType.Info + "," + ConstantMessages.FieldDuplicate);
return model;
}
return service.UpdateOrCreate<Sal_CostCentreSalEntity, Sal_CostCentreSalModel>(model);
}
//// GET api/<controller>
///// <summary>
///// Lấy tất cả dữ liệu
///// </summary>
///// <returns></returns>
public IEnumerable<Sys_UserMultiModel> Get()
{
BaseService service = new BaseService();
string status = string.Empty;
var listEntity = service.GetData<Sys_UserMultiModel>(string.Empty, ConstantSql.hrm_sys_sp_get_user_multi, UserLogin, ref status);
if (listEntity != null)
{
var listModel = listEntity.Translate<Sys_UserMultiModel>();
return listModel;
}
return new List<Sys_UserMultiModel>();
}
/// <summary>
/// [Hien.Nguyen] Get All Cat_Shift for Multi Control
/// </summary>
/// <returns></returns>
public IEnumerable<CatLeaveDayTypeModel> Get()
{
BaseService service = new BaseService();
string status = string.Empty;
var listEntity = service.GetData<CatLeaveDayTypeModel>(string.Empty, ConstantSql.hrm_cat_sp_get_LeaveDayType_multi,UserLogin, ref status);
if (listEntity != null)
{
var listModel = listEntity.Translate<CatLeaveDayTypeModel>();
return listModel;
}
return new List<CatLeaveDayTypeModel>();
}
public ActionResult Criar([Bind(Include = "descricao, dataabertura, regionalid, federacaoid")] associacao associacao)
{
if (ModelState.IsValid)
{
//Campo atribuído automaticamente
associacao.datainclusao = associacao.dataalteracao = DateTime.Now;
var servico = new BaseService<associacao>();
servico.Incluir(associacao);
servico.Salvar();
return RedirectToAction("Index");
}
CriarViewBags();
return View(associacao);
}
public IEnumerable<Cat_TAMScanReasonMissMuitlModel> Get()
{
BaseService service = new BaseService();
string status = string.Empty;
var listEntity = service.GetData<Cat_TAMScanReasonMissMultiEntity>(string.Empty, ConstantSql.hrm_cat_sp_get_TamScanReasonMiss_multi,UserLogin, ref status);
if (listEntity!=null)
{
var listModel = listEntity.Translate<Cat_TAMScanReasonMissMuitlModel>();
return listModel;
}
return new List<Cat_TAMScanReasonMissMuitlModel>();
}
public Lau_LaundryRecordModel Put([Bind]Lau_LaundryRecordModel model)
{
model.ProfileIDs = Common.DotNetToOracle(model.ProfileIDs);
BaseService service = new BaseService();
string status = string.Empty;
List<object> lstObj = new List<object>();
lstObj.Add(model.ProfileIDs);
lstObj.Add(model.Status);
var rs = service.UpdateData<Lau_LaundryRecordModel>(lstObj, ConstantSql.hrm_att_sp_get_LaundryRecord_UpdateStatus, ref status);
if (rs != null)
{
return model;
}
return null;
}
public IEnumerable<Can_MealAllowanceTypeSettingMultiModel> Get()
{
BaseService service = new BaseService();
string status = string.Empty;
var listEntity = service.GetData<Can_MealAllowanceTypeSettingMultiEntity>(string.Empty, ConstantSql.hrm_can_sp_get_MealAllowanceTypeSetting_multi, UserLogin, ref status);
if (listEntity != null)
{
var listModel = listEntity.Translate<Can_MealAllowanceTypeSettingMultiModel>();
return listModel;
}
return new List<Can_MealAllowanceTypeSettingMultiModel>();
}
public ActionResult ComputeSumryMealRecord(Guid CutoffdurationID, string OrgStructureID)
{
BaseService baseservices = new BaseService();
var Actionservices = new ActionService(UserLogin);
string status = string.Empty;
List<object> listModel = new List<object>();
listModel.AddRange(new object[18]);
listModel[2] = OrgStructureID;
listModel[16] = 1;
listModel[17] = Int32.MaxValue - 1;
List<Hre_ProfileEntity> ListProfile = Actionservices.GetData<Hre_ProfileEntity>(listModel, ConstantSql.hrm_hr_sp_get_Profile, ref status);
Can_ReportServices CanteenServices = new Can_ReportServices();
bool result = CanteenServices.SaveSumryMealRecord(CutoffdurationID, ListProfile.Select(m => m.ID).ToList());
return Json(result, JsonRequestBehavior.AllowGet);
}
public Eva_SaleBonusModel Post([Bind]Eva_SaleBonusModel model)
{
#region Validate
string message = string.Empty;
string status=string.Empty;
var baseService = new ActionService(UserLogin);
var bService = new BaseService();
var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Eva_SaleBonusModel>(model, "Eva_SaleBonus", ref message);
if (!checkValidate)
{
model.ActionStatus = message;
return model;
}
#endregion
#region kt trùng dữ liệu với Jobttile,KPI,Type theo mức phần %
List<object> lst=new List<object>();
var lstSaleBonus = bService.GetDataNotParam<Eva_SaleBonusEntity>(ConstantSql.hrm_eva_getdata_SaleBonus,UserLogin, ref status).ToList();
if (lstSaleBonus != null && lstSaleBonus.Count != 0)
{
if (model.ID == Guid.Empty)
{
if (lstSaleBonus.Where(x => x.JobTittleID == model.JobTittleID && x.SalesTypeID == model.SalesTypeID && x.Type == model.Type && x.FromPercent <= model.ToPercent && x.ToPercent >= model.FromPercent).Count() > 0)
{
model.SetPropertyValue(Constant.ActionStatus, NotificationType.Error + "," + string.Format(ConstantMessages.FieldDuplicate.TranslateString(), ConstantDisplay.HRM_Evaluation_Information.TranslateString()));
return model;
}
}
else
{
lstSaleBonus = lstSaleBonus.Where(x => x.ID != model.ID).ToList();
if (lstSaleBonus.Where(x => x.JobTittleID == model.JobTittleID && x.SalesTypeID == model.SalesTypeID && x.Type == model.Type && x.FromPercent <= model.ToPercent && x.ToPercent >= model.FromPercent).Count() > 0)
{
model.SetPropertyValue(Constant.ActionStatus, NotificationType.Error + "," + string.Format(ConstantMessages.FieldDuplicate.TranslateString(), ConstantDisplay.HRM_Evaluation_Information.TranslateString()));
return model;
}
}
}
#endregion
model.ActionStatus = "Success";
var service = new ActionService(UserLogin);
return service.UpdateOrCreate<Eva_SaleBonusEntity, Eva_SaleBonusModel>(model);
}
public Eva_PerformanceExtendEntity GetPerformanceExtendByPerID(string ID,string userLogin)
{
Guid perID = Guid.Empty;
Guid.TryParse( ID, out perID);
BaseService service = new BaseService();
string status = string.Empty;
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoEva_Performance = new CustomBaseRepository<Eva_Performance>(unitOfWork);
var repoEva_PerformanceExtend = new CustomBaseRepository<Eva_PerformanceExtend>(unitOfWork);
var performance = repoEva_Performance.GetAll().Where(s => s.ID == perID).FirstOrDefault();
var extend = repoEva_PerformanceExtend.GetAll().Where(s => s.ID == performance.PerformanceExtendID).FirstOrDefault();
var result = extend.Copy<Eva_PerformanceExtendEntity>();
string proID = Common.DotNetToOracle(performance.ProfileID.Value.ToString());
var profile = service.GetData<Hre_ProfileEntity>(proID, ConstantSql.hrm_hr_sp_get_ProfileById,userLogin, ref status).FirstOrDefault();
if (profile != null && result == null)
{
result = new Eva_PerformanceExtendEntity();
}
result.ProfileName = profile.ProfileName ?? string.Empty;
result.CodeEmp = profile.CodeEmp ?? string.Empty;
result.PositionName = profile.PositionName ?? string.Empty;
result.JobTitleName = profile.JobTitleName ?? string.Empty;
result.DateOfBirth = profile.DateOfBirth;
result.DateHire = profile.DateHire;
result.PayrollGroupName = profile.PayrollGroupName ?? string.Empty;
result.SupervisorName = profile.SupervisorName ?? string.Empty;
result.HighSupervisorName = profile.HighSupervisorName ?? string.Empty;
result.WorkPlaceName = profile.WorkPlaceName ?? string.Empty;
result.TCountryName = profile.TCountryName ?? string.Empty;
result.TProvinceName = profile.TProvinceName ?? string.Empty;
result.Channel = profile.Channel ?? string.Empty;
result.Region = profile.Region ?? string.Empty;
result.Area = profile.Area ?? string.Empty;
result.DateOfEffect = profile.DateOfEffect;
return result;
}
}
public ActionResult Criar([Bind(Include = "nome,datanascimento,email,telefoneresidencial,telefonecomercial,telefonecelular,dataprimeiravez")] adepto adepto)
{
if (ModelState.IsValid)
{
//Campo atribuído automaticamente
adepto.datainclusao = adepto.dataalteracao = DateTime.Now;
//Tratamento antes de incluir
adepto.telefoneresidencial = adepto.telefoneresidencial.RemoveMascara();
adepto.telefonecomercial = adepto.telefonecomercial.RemoveMascara();
adepto.telefonecelular = adepto.telefonecelular.RemoveMascara();
var servico = new BaseService<adepto>();
servico.Incluir(adepto);
servico.Salvar();
return RedirectToAction("Index");
}
return View(adepto);
}
public async Task <Tuple <Vm, List <ProductReportViewModel>, int> > GetHistoryByDate(Rm rm)
{
var productDetailService = new BaseService <ProductDetail, ProductDetailRequestModel, ProductDetailViewModel>(new BaseRepository <ProductDetail>(Repository.Db));
var productDetail = productDetailService.GetById(rm.ParentId);
var productDetailViewModel = new Vm(productDetail);
var saleDetailService = new BaseService <SaleDetail, SaleDetailRequestModel, SaleDetailViewModel>(new BaseRepository <SaleDetail>(Repository.Db));
var saleDetailRequestModel = new SaleDetailRequestModel("")
{
ShopId = rm.ShopId,
ProductDetailId = rm.ParentId,
Page = -1,
IsIncludeParents = true,
WarehouseId = rm.WarehouseId,
StartDate = rm.StartDate,
EndDate = rm.EndDate,
};
// this will pull all data
Tuple <List <SaleDetailViewModel>, int> saleDetailResult = await saleDetailService.SearchAsync(saleDetailRequestModel);
List <HistoryViewModel> saleDetailHistoryViewModels = saleDetailResult.Item1.ConvertAll(x => new HistoryViewModel(x, productDetail.Name, productDetail.SalePrice)).ToList();
var purchaseDetailService = new BaseService <PurchaseDetail, PurchaseDetailRequestModel, PurchaseDetailViewModel>(new BaseRepository <PurchaseDetail>(Repository.Db));
var purchaseDetailRequestModel = new PurchaseDetailRequestModel("")
{
ShopId = rm.ShopId,
ProductDetailId = rm.ParentId,
Page = -1,
PerPageCount = rm.PerPageCount,
IsIncludeParents = true,
WarehouseId = rm.WarehouseId,
StartDate = rm.StartDate,
EndDate = rm.EndDate,
};
Tuple <List <PurchaseDetailViewModel>, int> purchaseDetailResult = await purchaseDetailService.SearchAsync(purchaseDetailRequestModel);
List <HistoryViewModel> purchaseDetailHistoryViewModels = purchaseDetailResult.Item1.ConvertAll(x => new HistoryViewModel(x, productDetail.Name, productDetail.CostPrice)).ToList();
saleDetailHistoryViewModels.AddRange(purchaseDetailHistoryViewModels);
List <HistoryViewModel> merged = saleDetailHistoryViewModels.OrderByDescending(x => x.Date).ToList();
List <IGrouping <DateTime, HistoryViewModel> > list = merged.GroupBy(x => x.Date.Date).ToList();
List <ProductReportViewModel> reportModels = new List <ProductReportViewModel>();
foreach (IGrouping <DateTime, HistoryViewModel> groupModels in list)
{
double purchasedToday = groupModels.Where(x => x.Type == "Purchase").Sum(x => x.Quantity);
double soldToday = groupModels.Where(x => x.Type == "Sale").Sum(x => x.Quantity);
double soldPendingToday = groupModels.Where(x => x.Type == "Sale" && x.OrderState == OrderState.Pending)
.Sum(x => x.Quantity);
double soldProcessingToday = groupModels.Where(x => x.Type == "Sale" && x.OrderState > OrderState.Pending && x.OrderState < OrderState.Delivered)
.Sum(x => x.Quantity);
double soldDoneToday = groupModels.Where(x => x.Type == "Sale" && x.OrderState != OrderState.Cancel && x.OrderState >= OrderState.Delivered)
.Sum(x => x.Quantity);
double purchasedAmount = groupModels.Where(x => x.Type == "Purchase").Sum(x => x.Total);
double soldAmount = groupModels.Where(x => x.Type == "Sale").Sum(x => x.Total);
ProductReport reportModel = new ProductReport()
{
Id = productDetail.Id,
Date = groupModels.Key,
ProductDetailId = productDetail.Id,
IsActive = productDetail.IsActive,
ShopId = productDetail.ShopId,
ProductCategoryId = productDetail.ProductCategoryId,
QuantityPurchaseToday = purchasedToday,
QuantitySaleToday = soldToday,
QuantitySalePendingToday = soldPendingToday,
QuantitySaleProcessingToday = soldProcessingToday,
QuantitySaleDoneToday = soldDoneToday,
AmountPurchaseToday = purchasedAmount,
AmountSaleToday = soldAmount,
};
reportModels.Add(new ProductReportViewModel(reportModel));
}
return(new Tuple <Vm, List <ProductReportViewModel>, int>(productDetailViewModel, reportModels, reportModels.Count));
}
public static string SaveModule(BaseModule module, string pageid)
{
string Url = HttpContext.Current.Request.UrlReferrer.ToString();
BaseService.CheckLoginAndLicense();
module.Site = SessionObject.CurrentSite;
if (module.IsVisibleOnAllPages)
{
module.Template = null;
module.Page = null;
}
else if (module.IsVisibleOnAllPagesInLayout)
{
if (Url.ToLower().Contains("/newsletters"))
{
Newsletter newletter = BaseObject.GetById <Newsletter>(new Guid(pageid));
module.Template = newletter.Template;
}
else
{
CmsPage page = BaseObject.GetById <CmsPage>(new Guid(pageid));
module.Template = page.Template;
}
}
else
{
if (Url.ToLower().Contains("/newsletters"))
{
module.Newsletter = new Newsletter();
module.Newsletter.ID = new Guid(pageid);
}
else
{
module.Page = new CmsPage();
module.Page.ID = new Guid(pageid);
}
}
module.Save();
//SetUnpublishedItem(module);
module = module.ConvertToType();
//lijst van ObjectPermissions wordt hier alleen als drager gebruikt.
//in de licentieserver wordt deze lijst weer gesplitst en in 2 tabellen gezet
BaseCollection <ObjectPermission> objPermissions = module.GetObjectPermissions4LicenseServer();
if (objPermissions.Count > 0)
{
BitAutorisationService.AutorisationClient client = BitAutorisationServiceHelper.GetClient();
client.SaveObjectPermissions(objPermissions);
}
//publiceren van pagina('s)
PublishModule(module);
PublishDependentPages(module);
//Experimenteel caching reset
//if (module.Page != null) BitCaching.RemoveItemFromCache(module.Page.ID.ToString());
string returnValue = new ModuleService().GetUserControlContent(module);
return(returnValue);
}
public StudentsHub(BaseService service)
: base(service, "students", "studentId")
{
_service = service;
}
public void ImportRecruitmentHistory(string candidateIds, string UserLogin)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new Rec_RecruitmentCampaignRepository(unitOfWork);
var repoCandidate = new Rec_CandidateRepository(unitOfWork);
var lstIds = candidateIds.Split(',');
List <Guid> listID = new List <Guid>();
for (int i = 0; i < lstIds.Length; i++)
{
try
{
listID.Add(Guid.Parse(lstIds[i].ToString()));
}
catch
{ }
}
BaseService baseService = new BaseService();
string status = string.Empty;
var listCandidates = repoCandidate.FindBy(x => listID.Contains(x.ID)).ToList();
foreach (var candidateModel in listCandidates)
{
List <object> lstObjhistory = new List <object>();
lstObjhistory.Add(candidateModel.IdentifyNumber);
lstObjhistory.Add(candidateModel.CandidateName);
lstObjhistory.Add(candidateModel.DateOfBirth);
lstObjhistory.Add(candidateModel.DateApply);
var recruimentHistory = baseService.ActionData <Rec_RecruitmentHistoryEntity>(lstObjhistory, ConstantSql.hrm_rec_sp_checkduplidaterecruimentHistory, true, UserLogin, ref status).FirstOrDefault();
if (recruimentHistory != null)
{
recruimentHistory.CandidateName = candidateModel.CandidateName;
recruimentHistory.DateOfBirth = candidateModel.DateOfBirth;
recruimentHistory.Gender = candidateModel.Gender;
recruimentHistory.Phone = candidateModel.Phone;
recruimentHistory.Mobile = candidateModel.Mobile;
recruimentHistory.Email = candidateModel.Email;
recruimentHistory.YearOfExperience = candidateModel.YearOfExperience.Value != null ? candidateModel.YearOfExperience.Value : 0;
recruimentHistory.PositionID = candidateModel.PositionID;
recruimentHistory.JobVacancyID = candidateModel.JobVacancyID;
recruimentHistory.DateApply = candidateModel.DateApply;
recruimentHistory.ScorePotential = candidateModel.ScorePotential;
recruimentHistory.HealthStatus = candidateModel.HealthStatus;
recruimentHistory.IdentifyNumber = candidateModel.IdentifyNumber;
baseService.Edit(recruimentHistory);
}
else
{
Rec_RecruitmentHistoryEntity recruimentHistoryentity = new Rec_RecruitmentHistoryEntity();
recruimentHistoryentity.CandidateID = candidateModel.ID;
recruimentHistoryentity.CandidateName = candidateModel.CandidateName;
recruimentHistoryentity.DateOfBirth = candidateModel.DateOfBirth;
recruimentHistoryentity.Gender = candidateModel.Gender;
recruimentHistoryentity.Phone = candidateModel.Phone;
recruimentHistoryentity.Mobile = candidateModel.Mobile;
recruimentHistoryentity.Email = candidateModel.Email;
recruimentHistoryentity.YearOfExperience = candidateModel.YearOfExperience.Value != null ? candidateModel.YearOfExperience.Value : 0;
recruimentHistoryentity.PositionID = candidateModel.PositionID;
recruimentHistoryentity.JobVacancyID = candidateModel.JobVacancyID;
recruimentHistoryentity.DateApply = candidateModel.DateApply;
recruimentHistoryentity.ScorePotential = candidateModel.ScorePotential;
recruimentHistoryentity.HealthStatus = candidateModel.HealthStatus;
recruimentHistoryentity.PassFilterResume = candidateModel.PassFilterResume;
recruimentHistoryentity.Status = candidateModel.Status;
recruimentHistoryentity.IdentifyNumber = candidateModel.IdentifyNumber;
baseService.Add(recruimentHistoryentity);
}
}
repo.SaveChanges();
}
}
public BaseController(BaseService <DomainEntity, ViewModel> service)
{
entityService = service;
}
public async Task <IActionResult> Delete(int id)
{
await BaseService.DeleteAsync <ROLE, int>(id);
return(Ok(true));
}
public async Task <IActionResult> CreateExploitationRole(ExploitationRoleCreateDto roleCreateDto)
{
await BaseService.CreateAsync <ROLE, ExploitationRoleCreateDto>(roleCreateDto);
return(Ok());
}
private void stopButton_Click(object sender, EventArgs e)
{
RunInBackground("Stoping...", () => BaseService.Stop());
}
private void Restart()
{
RunInBackground("Restarting...", () => BaseService.Restart());
}
public BaseServiceTests()
{
unitOfWork = Substitute.For <IUnitOfWork>();
service = Substitute.ForPartsOf <BaseService>(unitOfWork);
}
/// <summary>
/// test setup and creating mock object
/// </summary>
/// <param name="fixture"></param>
public BlogService_Unit_Test()
{
Repository = new Mock <IBaseRepository <DAL.Models.Blog> >();
blogs = new List <DAL.Models.Blog>
{
new DAL.Models.Blog
{
Id = 1,
DateAdded = DateTime.Now,
DateModified = DateTime.Now,
Rating = 5,
Url = "https://samueleresca.net/"
},
new DAL.Models.Blog
{
Id = 2,
DateAdded = DateTime.Now,
DateModified = DateTime.Now,
Rating = 1,
Url = "https://yahoo.net/"
}
};
blogModels = new List <BlogResponseModel>()
{
new BlogResponseModel
{
Id = 1,
DateAdded = DateTime.Now,
DateModified = DateTime.Now,
Rating = 5,
Url = "https://samueleresca.net/"
},
new BlogResponseModel
{
Id = 2,
DateAdded = DateTime.Now,
DateModified = DateTime.Now,
Rating = 1,
Url = "https://yahoo.net/"
}
};
//GetAll
Repository.Setup(x => x.GetAll())
.ReturnsAsync(blogs);
//GetById
Repository.Setup(x => x.GetById(It.IsAny <int>()))
.Returns((int id) => Task.Run(() => blogs.Find(s => s.Id == id)));
//Where
Repository.Setup(x => x.Where(It.IsAny <Expression <Func <DAL.Models.Blog, bool> > >()))
.Returns((Expression <Func <DAL.Models.Blog, bool> > exp) => blogs.AsQueryable().Where(exp));
//Insert
Repository.Setup(x => x.Insert(It.IsAny <DAL.Models.Blog>()))
.Callback((DAL.Models.Blog label) => blogs.Add(label));
//Update
Repository.Setup(x => x.Update(It.IsAny <DAL.Models.Blog>()))
.Callback((DAL.Models.Blog label) => blogs[blogs.FindIndex(x => x.Id == label.Id)] = label);
//Delete
Repository.Setup(x => x.Delete(It.IsAny <DAL.Models.Blog>()))
.Callback((DAL.Models.Blog label) => blogs.RemoveAt(blogs.FindIndex(x => x.Id == label.Id)));
//mock mapper
mapper = new Mock <IMapper>();
mapper.Setup(x => x.Map <DAL.Models.Blog, BlogResponseModel>(It.IsAny <DAL.Models.Blog>())).Returns(blogModels[0]);
mapper.Setup(x => x.Map <BlogResponseModel, DAL.Models.Blog>(It.IsAny <BlogResponseModel>())).Returns(blogs[0]);
var baseService = new BaseService <DAL.Models.Blog>(Repository.Object);
Service = new BlogService(baseService, mapper.Object);
}
public override void DoAction(NWPlayer player, string pageName, int responseID)
{
PlayerDialog dialog = DialogService.LoadPlayerDialog(GetPC().GlobalID);
Guid structureID = new Guid(_.GetLocalString(player.Area, "PC_BASE_STRUCTURE_ID"));
PCBaseStructure structure = DataService.PCBaseStructure.GetByID(structureID);
PCBase pcBase = DataService.PCBase.GetByID(structure.PCBaseID);
DialogPage page = dialog.GetPageByName(pageName);
DialogResponse response = page.Responses[responseID - 1];
bool carefulPilot = PerkService.GetCreaturePerkLevel(player, PerkType.CarefulPilot) > 0;
if (pageName == "MainPage")
{
// The number of dialog options available can vary. So query based on the actual text of the response.
if (response.Text == "Land")
{
ChangePage("LandingDestPage");
}
else if (response.Text == "Pilot Ship")
{
SpaceService.CreateShipInSpace(player.Area); // In case we logged in here.
SpaceService.DoFlyShip(GetPC(), GetPC().Area);
EndConversation();
}
else if (response.Text == "Hyperspace Jump")
{
// Build the list of destinations.
ChangePage("HyperDestPage");
}
else if (response.Text == "Take Off")
{
// Check fuel
if (pcBase.Fuel < 1)
{
GetPC().SendMessage("You don't have enough fuel! You need 1 fuel to take off.");
dialog.ResetPage();
}
else
{
// Fuel is good - we have liftoff.
if (!SpaceService.DoPilotingSkillCheck(GetPC(), 2, carefulPilot))
{
// Failed our skill check. Deduct fuel but don't do anything else.
GetPC().FloatingText("The ship shudders a bit, but your awkwardness on the throttle shows, and it doesn't make it off the dock. Try again.");
pcBase.Fuel -= 1;
DataService.SubmitDataChange(pcBase, DatabaseActionType.Update);
return;
}
EndConversation();
// Save details of the current dock for later.
Guid shipPCBaseID = new Guid(pcBase.ShipLocation);
PCBaseStructure dock = DataService.PCBaseStructure.GetByIDOrDefault(shipPCBaseID);
pcBase.Fuel -= 1;
pcBase.DateRentDue = DateTime.UtcNow.AddDays(99);
pcBase.ShipLocation = SpaceService.GetPlanetFromLocation(pcBase.ShipLocation) + " - Orbit";
DataService.SubmitDataChange(pcBase, DatabaseActionType.Update);
SpaceService.CreateShipInSpace(player.Area);
// Give the impression of movement
foreach (var creature in player.Area.Objects)
{
if (creature.IsPC || creature.IsDM)
{
_.FloatingTextStringOnCreature("The ship is taking off", creature);
}
}
_.ApplyEffectToObject(DurationType.Instant, _.EffectVisualEffect(VisualEffect.Vfx_Fnf_Screen_Shake), player);
// Clean up the base structure, if we were in a PC dock not public starport.
// Get a reference to our placeable (and door), and delete them with some VFX.
if (dock != null)
{
PCBase dockBase = DataService.PCBase.GetByID(dock.PCBaseID);
IEnumerable <NWArea> areas = NWModule.Get().Areas;
NWArea landingArea = new NWArea(_.GetFirstArea());
foreach (var area in areas)
{
if (_.GetResRef(area) == dockBase.AreaResref)
{
landingArea = area;
}
}
List <AreaStructure> areaStructures = landingArea.Data["BASE_SERVICE_STRUCTURES"];
foreach (var plc in areaStructures)
{
if (plc.PCBaseStructureID == dock.ID)
{
// Found our dock. Clear its variable and play some VFX.
plc.Structure.SetLocalInt("DOCKED_STARSHIP", 0);
DoDustClouds(plc.Structure.Location);
_.ApplyEffectToObject(DurationType.Instant, _.EffectVisualEffect(VisualEffect.Vfx_Fnf_Screen_Shake), plc.Structure);
}
else if (plc.PCBaseStructureID == structure.ID)
{
// found either our ship or our entrance (both are saved with our structure ID). Delete them.
// Dp NOT remove the PC base structure object from the database. We still need that.
plc.Structure.Destroy();
}
}
}
}
}
else if (response.Text == "Access Fuel Bay")
{
OpenFuelBay(false);
EndConversation();
}
else if (response.Text == "Access Stronidium Bay")
{
OpenFuelBay(true);
EndConversation();
}
else if (response.Text == "Access Resource Bay")
{
NWPlaceable bay = SpaceService.GetCargoBay(player.Area, GetPC());
if (bay != null)
{
GetPC().AssignCommand(() => _.ActionInteractObject(bay.Object));
}
EndConversation();
}
else if (response.Text == "Export Starcharts")
{
NWItem item = _.CreateItemOnObject("starcharts", player, 1, _.Random(10000).ToString());
// Initialise the list, in case it hasn't been populated yet.
SpaceService.GetHyperspaceDestinationList(pcBase);
item.SetLocalInt("Starcharts", (int)pcBase.Starcharts);
}
}
else if (pageName == "HyperDestPage")
{
// Check fuel
if (pcBase.Fuel < 50)
{
GetPC().SendMessage("You don't have enough fuel! You need 50 fuel to make a hyperspace jump.");
dialog.ResetPage();
}
else
{
// Fuel is good - make the jump
if (!SpaceService.DoPilotingSkillCheck(GetPC(), 13, carefulPilot))
{
// Failed our skill check. Deduct fuel but don't do anything else.
GetPC().FloatingText("Jump failed! You forgot to whatsit the thingummyjig.");
pcBase.Fuel -= 50;
DataService.SubmitDataChange(pcBase, DatabaseActionType.Update);
EndConversation();
return;
}
// Move the ship out of the old orbit.
SpaceService.RemoveShipInSpace(player.Area);
// Fade to black for hyperspace.
EndConversation();
pcBase.Fuel -= 50;
pcBase.ShipLocation = response.Text + " - Orbit";
DataService.SubmitDataChange(pcBase, DatabaseActionType.Update);
// Put the ship in its new orbit.
SpaceService.CreateShipInSpace(player.Area);
// Give the impression of movement - would be great to have the actual hyperspace jump graphics here.
foreach (var creature in player.Area.Objects)
{
if (creature.IsPC || creature.IsDM)
{
_.FloatingTextStringOnCreature("Making a hyperspace jump!", creature);
_.FadeToBlack(creature, 0.5f);
_.DelayCommand(1.0f, () => { _.FadeFromBlack(creature, 0.5f); });
}
}
}
}
else if (pageName == "LandingDestPage")
{
// Skill check.
if (!SpaceService.DoPilotingSkillCheck(GetPC(), 5, carefulPilot))
{
// Failed our skill check. Land anyway but burn more fuel.
if (pcBase.Fuel > 0)
{
GetPC().FloatingText("You overshoot the landing spot, burning extra fuel getting your ship into position.");
pcBase.Fuel -= 1;
DataService.SubmitDataChange(pcBase, DatabaseActionType.Update);
}
}
// Get the response, then find the structure ID.
Guid dockStructureID = dialog.CustomData["LAND_" + response.Text];
// This could be a public startport ID or a private dock base structure ID.
Starport starport = DataService.Starport.GetByStarportIDOrDefault(dockStructureID);
if (starport != null)
{
// We have a public starport.
if (player.Gold < starport.Cost)
{
player.SendMessage("You do not have enough credits to land here.");
return;
}
else
{
_.TakeGoldFromCreature(starport.Cost, player, true);
// Land.
pcBase.ShipLocation = starport.StarportID.ToString();
pcBase.DateRentDue = DateTime.UtcNow.AddDays(1);
DataService.SubmitDataChange(pcBase, DatabaseActionType.Update);
// Notify PC.
player.SendMessage("You have paid your first day's berthing fees. Use the Base Management System to extend your lease if you plan to stay longer, or your ship will be impounded.");
EndConversation();
}
}
else
{
LoggingService.Trace(TraceComponent.Space, "Landing in PC base dock, ID: " + dockStructureID.ToString());
PCBaseStructure dock = DataService.PCBaseStructure.GetByIDOrDefault(dockStructureID);
if (dock == null)
{
player.SendMessage("ERROR: Could not find landing dock by ID. Please report this.");
LoggingService.Trace(TraceComponent.Space, "Could not find landing dock ID " + dockStructureID.ToString());
return;
}
NWPlaceable plc = BaseService.FindPlaceableFromStructureID(dock.ID.ToString());
if (plc == null)
{
LoggingService.Trace(TraceComponent.Space, "Failed to find dock placeable.");
player.SendMessage("ERROR: Could not find landing dock placeable. Please report this.");
return;
}
LoggingService.Trace(TraceComponent.Space, "Found dock, landing ship.");
// We've found our dock. Update our record of where the ship's exterior should spawn.
NWLocation loc = plc.Location;
structure.LocationX = loc.X;
structure.LocationY = loc.Y;
structure.LocationZ = loc.Z;
structure.LocationOrientation = _.GetFacingFromLocation(loc);
DataService.SubmitDataChange(structure, DatabaseActionType.Update);
// And update the base to mark the parent dock as the location.
pcBase.ShipLocation = dock.ID.ToString();
DataService.SubmitDataChange(pcBase, DatabaseActionType.Update);
// Now use the Base Service to spawn the ship exterior.
BaseService.SpawnStructure(plc.Area, structure.ID);
// Mark the dock as occupied.
plc.SetLocalInt("DOCKED_STARSHIP", 1);
// Notify PCs in the landing area.
foreach (var creature in plc.Area.Objects)
{
if (creature.IsPC || creature.IsDM)
{
_.FloatingTextStringOnCreature("A ship has just landed!", creature);
}
}
// And shake the screen, because stuff.
_.ApplyEffectAtLocation(DurationType.Instant, _.EffectVisualEffect(VisualEffect.Vfx_Fnf_Screen_Shake), loc);
DoDustClouds(loc);
}
// We're landing. Make sure any pilot or gunner get out of flight mode.
SpaceService.LandCrew(player.Area);
// If we are still here, we landed successfully. Shake the screen about and notify PCs on the ship.
// Give the impression of movement
foreach (var creature in player.Area.Objects)
{
if (creature.IsPC || creature.IsDM)
{
_.FloatingTextStringOnCreature("The ship is landing.", creature);
}
}
_.ApplyEffectToObject(DurationType.Instant, _.EffectVisualEffect(VisualEffect.Vfx_Fnf_Screen_Shake), player);
SpaceService.RemoveShipInSpace(player.Area);
EndConversation();
}
}
public TagController(BaseService <Tag, TagDTO> service)
: base(service)
{
}
public async Task <Tuple <Vm, List <HistoryViewModel>, int> > GetHistory(Rm rm)
{
var productDetailService = new BaseService <ProductDetail, ProductDetailRequestModel, ProductDetailViewModel>(new BaseRepository <ProductDetail>(Repository.Db));
var productDetail = productDetailService.GetById(rm.ParentId);
var productDetailViewModel = new Vm(productDetail);
var service1 = new BaseService <SaleDetail, SaleDetailRequestModel, SaleDetailViewModel>(new BaseRepository <SaleDetail>(Repository.Db));
var saleDetailRequestModel = new SaleDetailRequestModel("")
{
ShopId = rm.ShopId,
ProductDetailId = rm.ParentId,
Page = rm.Page,
IsIncludeParents = true,
WarehouseId = rm.WarehouseId,
PerPageCount = rm.PerPageCount,
StartDate = rm.StartDate,
EndDate = rm.EndDate
};
// this will pull all data
Tuple <List <SaleDetailViewModel>, int> result = await service1.SearchAsync(saleDetailRequestModel);
List <HistoryViewModel> viewModels = result.Item1.ConvertAll(x => new HistoryViewModel(x, productDetail.Name, productDetail.SalePrice)).ToList();
var stockTransferService =
new BaseService <StockTransferDetail, StockTransferDetailRequestModel, StockTransferDetailViewModel>(
new BaseRepository <StockTransferDetail>(Repository.Db));
var stockTransferDetailInRequestModel = new StockTransferDetailRequestModel("")
{
ShopId = rm.ShopId,
ProductDetailId = rm.ParentId,
Page = rm.Page,
IsIncludeParents = true,
DestinationWarehouseId = rm.WarehouseId,
PerPageCount = rm.PerPageCount,
StartDate = rm.StartDate,
EndDate = rm.EndDate
};
var stockInResult = await stockTransferService.SearchAsync(stockTransferDetailInRequestModel);
var stockInViewModels = stockInResult.Item1.ConvertAll(x => new HistoryViewModel(x, productDetail.Name, "StockIn")).ToList();
var stockTransferDetailOutRequestModel = new StockTransferDetailRequestModel("")
{
ShopId = rm.ShopId,
ProductDetailId = rm.ParentId,
Page = rm.Page,
IsIncludeParents = true,
SourceWarehouseId = rm.WarehouseId,
PerPageCount = rm.PerPageCount,
StartDate = rm.StartDate,
EndDate = rm.EndDate
};
var stockOutResult = await stockTransferService.SearchAsync(stockTransferDetailOutRequestModel);
var stockOutViewModels = stockOutResult.Item1.ConvertAll(x => new HistoryViewModel(x, productDetail.Name, "StockOut")).ToList();
var purchaseDetailService = new BaseService <PurchaseDetail, PurchaseDetailRequestModel, PurchaseDetailViewModel>(new BaseRepository <PurchaseDetail>(Repository.Db));
var purchaseDetailRequestModel = new PurchaseDetailRequestModel("")
{
ShopId = rm.ShopId,
ProductDetailId = rm.ParentId,
Page = rm.Page,
PerPageCount = rm.PerPageCount,
IsIncludeParents = true,
WarehouseId = rm.WarehouseId,
StartDate = rm.StartDate,
EndDate = rm.EndDate
};
Tuple <List <PurchaseDetailViewModel>, int> purchaseDetailResult = await purchaseDetailService.SearchAsync(purchaseDetailRequestModel);
List <HistoryViewModel> models = purchaseDetailResult.Item1.ConvertAll(x => new HistoryViewModel(x, productDetail.Name, productDetail.CostPrice)).ToList();
viewModels.AddRange(models);
viewModels.AddRange(stockInViewModels);
viewModels.AddRange(stockOutViewModels);
List <HistoryViewModel> merged = viewModels.OrderByDescending(x => x.Date.Date).ToList();
double purchased = merged.Where(x => x.Type == "Purchase").Sum(x => x.Quantity);
double sold = merged
.Where(x => x.Type == "Sale" && x.OrderState > OrderState.Pending && x.OrderState < OrderState.Cancel)
.Sum(x => x.Quantity);
double stockInQuantity = merged
.Where(x => x.Type == "StockIn" && x.TransferState == StockTransferState.Approved.ToString())
.Sum(x => x.Quantity);
double stockOutQuantity = merged
.Where(x => x.Type == "StockOut" && x.TransferState == StockTransferState.Approved.ToString())
.Sum(x => x.Quantity);
productDetailViewModel.Purchased = purchased;
productDetailViewModel.Sold = sold;
productDetailViewModel.StockIn = stockInQuantity;
productDetailViewModel.StockOut = stockOutQuantity;
productDetailViewModel.OnHand = purchased
+ stockInQuantity
- sold
- stockOutQuantity;
return(new Tuple <Vm, List <HistoryViewModel>, int>(productDetailViewModel, merged, viewModels.Count));
}
public HttpResponseMessage GetHistoryView(int requestId)
{
try
{
BaseModel baseModel = viewHistoryService.GetRequestFilterValues();
viewHistoryViewModel = new ViewHistoryViewModel();
InitShow();
viewHistoryViewModel.RequestId = requestId.ToString();
viewHistoryViewModel = viewHistoryService.GetHistoryData(viewHistoryViewModel);
viewHistoryViewModel.username = UserName.Split(Syngenta.ERMS.Common.Constants.SLASH.ToCharArray())[1].ToString();
BaseService baseService = new BaseService();
//For Fast
if (string.IsNullOrEmpty(viewHistoryViewModel.SetFastTeamMgr))
{
viewHistoryViewModel.trFastMgrShow = false;
}
if (string.IsNullOrEmpty(viewHistoryViewModel.SetFastTeamSignOff))
{
viewHistoryViewModel.trFastSignOffShow = false;
viewHistoryViewModel.trFastTimeTakenShow = false;
}
/*
* if (SetFastSignOffDays == 0)
* {
* trFastTimeTaken.Visible = false;
* }
*/
if (string.IsNullOrEmpty(viewHistoryViewModel.SetFastTeamMgr) && string.IsNullOrEmpty(viewHistoryViewModel.SetFastTeamSignOff) && viewHistoryViewModel.SetFastSignOffDays == "0")
{
viewHistoryViewModel.trFastShow = false;
}
//For SCP
if (string.IsNullOrEmpty(viewHistoryViewModel.SetSCPMgr))
{
viewHistoryViewModel.trSCPMgrShow = false;
}
if (string.IsNullOrEmpty(viewHistoryViewModel.SetSCPSignOff))
{
viewHistoryViewModel.trSCPSignOffShow = false;
viewHistoryViewModel.trSCPTimeTakenShow = false;
}
/*
* if (SetSCPSignOffDays == 0)
* {
* trSCPTimeTaken.Visible = false;
* }
*/
if (string.IsNullOrEmpty(viewHistoryViewModel.SetSCPMgr) && string.IsNullOrEmpty(viewHistoryViewModel.SetSCPSignOff) && viewHistoryViewModel.SetSCPSignOffDays == "0")
{
viewHistoryViewModel.trSCPShow = false;
}
//For Pack Tech
if (string.IsNullOrEmpty(viewHistoryViewModel.SetPackTechMgr))
{
viewHistoryViewModel.trPackTechMgrShow = false;
}
if (string.IsNullOrEmpty(viewHistoryViewModel.SetPackTechSignOff))
{
viewHistoryViewModel.trPackTechSignOffShow = false;
viewHistoryViewModel.trPackTechTimeTakenShow = false;
}
/*
* if (SetPackTechSignOffDays == 0)
* {
* trPackTechTimeTaken.Visible = false;
* }
*/
if (string.IsNullOrEmpty(viewHistoryViewModel.SetPackTechCompleteMgr))
{
viewHistoryViewModel.trPackCompleteMgrShow = false;
}
if (string.IsNullOrEmpty(viewHistoryViewModel.SetPackCompletSignOff))
{
viewHistoryViewModel.trPackCompleteSignOffShow = false;
viewHistoryViewModel.trPackTestCompleteTimeTakenShow = false;
}
/*
* if (SetPackTestCompleteTimeTaken == 0)
* {
* trPackTestCompleteTimeTaken.Visible = false;
* }
*/
if (string.IsNullOrEmpty(viewHistoryViewModel.SetPackTechMgr) && string.IsNullOrEmpty(viewHistoryViewModel.SetPackTechSignOff) && viewHistoryViewModel.SetPackTechSignOffDays == "0" &&
string.IsNullOrEmpty(viewHistoryViewModel.SetPackTechCompleteMgr) && string.IsNullOrEmpty(viewHistoryViewModel.SetPackCompletSignOff) && viewHistoryViewModel.SetPackTestCompleteTimeTaken == "0")
{
viewHistoryViewModel.trPackTechShow = false;
}
//For RDM
if (string.IsNullOrEmpty(viewHistoryViewModel.SetRDMMgr))
{
viewHistoryViewModel.trRDMMgrShow = false;
}
if (string.IsNullOrEmpty(viewHistoryViewModel.SetRDMSignOff))
{
viewHistoryViewModel.trRDMSignOffShow = false;
viewHistoryViewModel.trRDMTimeTakenShow = false;
}
/*
* if (SetRDMSignOffDays == 0)
* {
* trRDMTimeTaken.Visible = false;
* }
*/
if (string.IsNullOrEmpty(viewHistoryViewModel.SetSUCodeRaiseRDMMgr))
{
viewHistoryViewModel.trSUCodeRaiseRDMMgrShow = false;
}
if (string.IsNullOrEmpty(viewHistoryViewModel.SetSUCodeRaiseSignOff))
{
viewHistoryViewModel.trSUCodeRaiseSignOffShow = false;
viewHistoryViewModel.trSUCodeRaiseTimeTakenShow = false;
}
/*
* if (SetSUCodeRaiseTimeTake == 0)
* {
* trSUCodeRaiseTimeTaken.Visible = false;
* }
*/
if (string.IsNullOrEmpty(viewHistoryViewModel.SetRDMMgr) && string.IsNullOrEmpty(viewHistoryViewModel.SetRDMSignOff) && viewHistoryViewModel.SetRDMSignOffDays == "0" &&
string.IsNullOrEmpty(viewHistoryViewModel.SetSUCodeRaiseRDMMgr) && string.IsNullOrEmpty(viewHistoryViewModel.SetSUCodeRaiseSignOff) && viewHistoryViewModel.SetSUCodeRaiseTimeTake == "0")
{
viewHistoryViewModel.trRDMShow = false;
}
//For EBM
if (string.IsNullOrEmpty(viewHistoryViewModel.SetEBMMgr))
{
viewHistoryViewModel.trEBMMgrShow = false;
}
if (string.IsNullOrEmpty(viewHistoryViewModel.SetEBMSignOff))
{
viewHistoryViewModel.trEBMSignOffShow = false;
viewHistoryViewModel.trEBMTimeTakenShow = false;
}
/*
* if (SetEBMSignOffDays == 0)
* {
* trEBMTimeTaken.Visible = false;
* }
*/
if (string.IsNullOrEmpty(viewHistoryViewModel.SetEBM2ndManager))
{
viewHistoryViewModel.trEBM2ndManagerShow = false;
}
if (string.IsNullOrEmpty(viewHistoryViewModel.SetEBM2ndSignOff))
{
viewHistoryViewModel.trEBM2ndSignOffShow = false;
viewHistoryViewModel.trEBM2ndTimeTakenShow = false;
}
/*
* if (SetEBM2ndTimeTaken == 0)
* {
* trEBM2ndTimeTaken.Visible = false;
* }
*/
if (string.IsNullOrEmpty(viewHistoryViewModel.SetEBMMgr) && string.IsNullOrEmpty(viewHistoryViewModel.SetEBMSignOff) && viewHistoryViewModel.SetEBMSignOffDays == "0" &&
string.IsNullOrEmpty(viewHistoryViewModel.SetEBM2ndManager) && string.IsNullOrEmpty(viewHistoryViewModel.SetEBM2ndSignOff) && viewHistoryViewModel.SetEBM2ndTimeTaken == "0")
{
viewHistoryViewModel.trEBMShow = false;
}
//For SCTeam
if (string.IsNullOrEmpty(viewHistoryViewModel.SetSCTeamPackTechHead))
{
viewHistoryViewModel.trSCTeamPackTechHeadShow = false;
}
if (string.IsNullOrEmpty(viewHistoryViewModel.SetSCTeamPackPuchasingMgr))
{
viewHistoryViewModel.trSCTeamPackPurchasingMgrShow = false;
}
if (string.IsNullOrEmpty(viewHistoryViewModel.SetSCTeamFastMgr))
{
viewHistoryViewModel.trSCTeamFastMgrShow = false;
}
//Start of change for ERMS case 1165724-1 and 1165721-1
if (string.IsNullOrEmpty(viewHistoryViewModel.SetSCTeamGSCMMgr) || viewHistoryViewModel.SetRequestType != "Combi Pack")
{
viewHistoryViewModel.trSCTeamGSCMMgrShow = false;
}
if (string.IsNullOrEmpty(viewHistoryViewModel.SetSCTeamGTPMgr))
{
viewHistoryViewModel.trSCTeamGTPMgrShow = false;
}
if (string.IsNullOrEmpty(viewHistoryViewModel.SetSCTeamPackTechMgr))
{
viewHistoryViewModel.trSCTeamPackTechShow = false;
}
//end of change for ERMS case 1165724-1 and 1165721-1
if (string.IsNullOrEmpty(viewHistoryViewModel.SetSCTeamRDMMgr))
{
viewHistoryViewModel.trSCTeamRDMMgrShow = false;
}
if (string.IsNullOrEmpty(viewHistoryViewModel.SetSCTeamSignOff))
{
viewHistoryViewModel.trSCTeamSignOffShow = false;
viewHistoryViewModel.trSCTeamTimeTakenShow = false;
}
/*
* if (SetSCTeamSignOffDays == 0)
* {
* trSCTeamTimeTaken.Visible = false;
* }
*/
if (string.IsNullOrEmpty(viewHistoryViewModel.SetSCTeamPackTechHead) && string.IsNullOrEmpty(viewHistoryViewModel.SetSCTeamPackPuchasingMgr) && string.IsNullOrEmpty(viewHistoryViewModel.SetSCTeamFastMgr) &&
string.IsNullOrEmpty(viewHistoryViewModel.SetSCTeamGSCMMgr) && string.IsNullOrEmpty(viewHistoryViewModel.SetSCTeamRDMMgr) && string.IsNullOrEmpty(viewHistoryViewModel.SetSCTeamSignOff) &&
viewHistoryViewModel.SetSCTeamSignOffDays == "0")
{
viewHistoryViewModel.trSCTeamShow = false;
}
//For GSCM
if (string.IsNullOrEmpty(viewHistoryViewModel.SetGSCMMgr) || viewHistoryViewModel.SetRequestType != "Supply Chain")
{
viewHistoryViewModel.trGSCMMgrShow = false;
}
if (string.IsNullOrEmpty(viewHistoryViewModel.SetGSCMSignOff) || viewHistoryViewModel.SetRequestType != "Supply Chain")
{
viewHistoryViewModel.trGSCMSignOffShow = false;
viewHistoryViewModel.trGSCMTimeTakenShow = false;
}
/*
* if (SetGSCMSignOffDays == 0 || lblReqType.Text != "Supply Chain")
* {
* trGSCMTimeTaken.Visible = false;
* }
*/
if (string.IsNullOrEmpty(viewHistoryViewModel.SetGSCM2ndManager) || viewHistoryViewModel.SetRequestType != "Supply Chain")
{
viewHistoryViewModel.trGSCM2ndManagerShow = false;
}
if (string.IsNullOrEmpty(viewHistoryViewModel.SetGSCM2ndSignOff) || viewHistoryViewModel.SetRequestType != "Supply Chain")
{
viewHistoryViewModel.trGSCM2ndSignOffShow = false;
viewHistoryViewModel.trGSCM2ndTimeTakenShow = false;
}
/*
* if (SetGSCM2ndTimeTaken == 0 || lblReqType.Text != "Supply Chain")
* {
* trGSCM2ndTimeTaken.Visible = false;
* }
*/
if ((string.IsNullOrEmpty(viewHistoryViewModel.SetGSCMMgr) && string.IsNullOrEmpty(viewHistoryViewModel.SetGSCMSignOff) && viewHistoryViewModel.SetGSCMSignOffDays == "0" &&
string.IsNullOrEmpty(viewHistoryViewModel.SetGSCM2ndManager) && string.IsNullOrEmpty(viewHistoryViewModel.SetGSCM2ndSignOff) && viewHistoryViewModel.SetGSCM2ndTimeTaken == "0") ||
viewHistoryViewModel.SetRequestType != "Supply Chain")
{
viewHistoryViewModel.trGSCMShow = false;
}
return(Request.CreateResponse(HttpStatusCode.OK, viewHistoryViewModel));
}
catch (Exception ex)
{
NameValueCollection additionalInfo = new NameValueCollection();
additionalInfo.Add("PageName", "ViewHistory");
ExceptionManager.Publish(ex, additionalInfo);
//Message = errMessages.GetString("Error in ViewHistory");
errEntity.ErrorNumber = 420;
errEntity.ErrorMess = "Error in GetHistoryView method of ViewHistory controller";
viewHistoryViewModel.ErrorBE = errEntity;
return(Request.CreateResponse(HttpStatusCode.OK, viewHistoryViewModel));
}
}
protected BaseCommandController(BaseService <T, TRm, TVm> service)
{
Service = service;
typeName = typeof(T).Name;
}
public async Task <IActionResult> GetRoleById(int id)
{
return(Ok(await BaseService.FindAsync <ROLE, RoleDetailDto>(id)));
}
public static Dictionary <string, object> GetTags(string id)
{
BaseService.CheckLoginAndLicense();
List <string> tagArray = new List <string>();
string tagString = "Dubbelklik op een tag om het op de plaats van de cursor te zetten<br/>";
id = id.Replace("bitModule", "");
id = id.Replace("bitEditor", "");
//id = id.Replace("Template", "");
if (id.Contains("Template"))
{
tagString += "<br/>";
tagString += "<strong>Body-tags:</strong> (Deze tags kunnen genummerd worden.<br />Bijvoorbeeld: [CONTENT1], [CONTENT2], [CONTENT...)<br/>";
tagString += "<div class='tagToInsert'>[CONTENT]</div>";
tagArray.Add("[CONTENT]");
tagString += "<div class='tagToInsert'>[TOP]</div>";
tagArray.Add("[TOP]");
tagString += "<div class='tagToInsert'>[LEFT]</div>";
tagArray.Add("[LEFT]");
tagString += "<div class='tagToInsert'>[CENTER]</div>";
tagArray.Add("[CENTER]");
tagString += "<div class='tagToInsert'>[RIGHT]</div>";
tagArray.Add("[RIGHT]");
tagString += "<div class='tagToInsert'>[BOTTOM]</div>";
tagArray.Add("[BOTTOM]");
tagString += "<br/>";
tagString += "<strong>Head-tags:</strong><br/>";
tagString += "<div class='tagToInsert'>[PAGETITLE]</div>";
tagArray.Add("[PAGETITLE]");
tagString += "<div class='tagToInsert'>[SCRIPTS]</div>";
tagArray.Add("[SCRIPTS]");
tagString += "<div class='tagToInsert'>[HEAD]</div>";
tagArray.Add("[HEAD]");
//returnValue += "<div class='tagToInsert'>[METADESCRIPTION]</div>";
//returnValue += "<div class='tagToInsert'>[METAKEYWORDS]</div>";
}
else if (id != "")
{
//TemplateModule module = (TemplateModule)BaseDomainObject.GetById<TemplateModule>(new Guid(id));
BaseModule module = (BaseModule)BaseDomainObject.GetById <BaseModule>(new Guid(id));
module = module.ConvertToType();
List <Tag> tags = module.GetAllTags();
tags = tags.OrderBy(c => c.Name).ToList();
foreach (Tag tag in tags) //ModeEnum.EditPageMode))
{
if (tag.HasCloseTag)
{
tagString += String.Format("<div class='tagToInsert'>{0}</div>", tag.Name + tag.CloseTag);
tagArray.Add(tag.Name + tag.CloseTag);
}
else
{
tagString += String.Format("<div class='tagToInsert'>{0}</div>", tag.Name);
tagArray.Add(tag.Name);
if (tag.AllowFormats && tag.SampleFormats != null)
{
foreach (string sampleFormat in tag.SampleFormats)
{
string tagWithFormat = tag.Name.Replace("}", ":" + sampleFormat + "}");
tagString += String.Format("<div class='tagToInsert'>{0}</div>", tagWithFormat);
tagArray.Add(tagWithFormat);
}
}
}
}
if (tags.Count == 0)
{
tagString = "Deze module kent geen tags";
}
}
Dictionary <string, object> returnvalue = new Dictionary <string, object>();
returnvalue.Add("CKTags", tagString);
returnvalue.Add("CMTags", tagArray.ToArray());
return(returnvalue);
}
public async Task <IActionResult> UpdateRole(int id, RoleUpdateDto roleUpdateDto)
{
await BaseService.UpdateAsync <ROLE, RoleUpdateDto>(id, roleUpdateDto);
return(Ok(true));
}
public async Task <ActionResult> WebGetEvtType()
{
var list = await BaseService.GetEvtType();
return(Json(list));
}
public Ins_InsuranceRecordModel Post([Bind] Ins_InsuranceRecordModel model)
{
var hrService = new Hre_ProfileServices();
var baseService = new BaseService();
var InsuranceRecordService = new Ins_InsuranceRecordServices();
List <Ins_InsuranceRecordEntity> ilInsuranceRecord = new List <Ins_InsuranceRecordEntity>();
string status = string.Empty;
#region Validate
string message = string.Empty;
var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData <Ins_InsuranceRecordModel>(model, "Ins_InsuranceRecord", ref message);
if (!checkValidate)
{
model.ActionStatus = message;
return(model);
}
#endregion
if (model.ID == Guid.Empty)
{
if (string.IsNullOrEmpty(model.OrgStructureIDs) && string.IsNullOrEmpty(model.ProfileIds) && model.ProfileID == Guid.Empty)
{
message = string.Format(ConstantMessages.FieldNotAllowNull.TranslateString(), ("ProfileID").TranslateString());
model.ActionStatus = message;
return(model);
}
if (!string.IsNullOrEmpty(model.OrgStructureIDs))
{
List <Guid> listGuid = new List <Guid>();
if (model.ProfileIds != null)
{
var listStr = model.ProfileIds.Split(',');
if (listStr[0] != "")
{
foreach (var item in listStr)
{
listGuid.Add(Guid.Parse(item));
}
}
}
List <object> listObj = new List <object>();
listObj.Add(model.OrgStructureIDs);
listObj.Add(string.Empty);
listObj.Add(string.Empty);
var lstProfile = baseService.GetData <Hre_ProfileEntity>(listObj, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrgStructure, UserLogin, ref status).Select(x => x.ID);
if (listGuid.Count > 0)
{
lstProfile = lstProfile.Where(s => !listGuid.Contains(s)).ToList();
}
if (lstProfile.Count() > 0)
{
foreach (var objProfile in lstProfile)
{
var modelSave = model.CopyData <Ins_InsuranceRecordModel>();
modelSave.ProfileID = objProfile;
ilInsuranceRecord.Add(modelSave.CopyData <Ins_InsuranceRecordEntity>());
}
model.ActionStatus = InsuranceRecordService.Add(ilInsuranceRecord);
}
return(model);
}
if (!string.IsNullOrEmpty(model.ProfileIds))
{
List <Guid> ilprofileID = new List <Guid>();
var listprofile = model.ProfileIds.Split(',');
foreach (var x in listprofile)
{
try
{
ilprofileID.Add(Guid.Parse(x));
}
catch
{
}
}
foreach (var item in ilprofileID)
{
var modelSave = model.CopyData <Ins_InsuranceRecordModel>();
modelSave.ProfileID = item;
ilInsuranceRecord.Add(modelSave.CopyData <Ins_InsuranceRecordEntity>());
}
model.ActionStatus = InsuranceRecordService.Add(ilInsuranceRecord);
}
}
else
{
ActionService service = new ActionService(UserLogin);
return(service.UpdateOrCreate <Ins_InsuranceRecordEntity, Ins_InsuranceRecordModel>(model));
}
return(model);
}
public List <Model.Ocdf> GetByOcdfRoomId(int ocdfRoomId)
{
return(AutoMapper.Mapper.Map <List <Model.Ocdf> >(BaseService.GetAll(x => x.OcdfRoomId == ocdfRoomId).ToList()));
}
/// <summary>
/// 统一影响库存方法
/// </summary>
/// <param name="records"></param>
public static void SaveLog(List <InventoryRecord> records)
{
if (records == null || !records.Any())
{
return;
}
InventCache.Clear();
var storeIds = records.Select(o => o.StoreId).Distinct();
var barcodes = records.Select(o => o.Barcode).Distinct();
var procs = ProductService.FindList(o => !(o.Barcodes == null || o.Barcodes == "") || barcodes.Contains(o.Barcode));
var rds = new List <InventoryRecord>();
var storeDal = new DAL.StoreDAL();
foreach (var rd in records)
{
rd.CreateDT = DateTime.Now;
rd.CreateUID = Sys.CurrentUser.UID;
storeDal.AffectInventory(rd);//调用存储过程
continue;
rds.Add(rd);
if (rd.Source == 13)//批发 (含一品多码,组合,拆分,单品)
{
OutboundUpdateProduct(rd.Number, rd.Barcode, rd.StoreId, rd.OperatId, procs);
continue;
}
var info = procs.FirstOrDefault(o => o.Barcode == rd.Barcode || ("," + o.Barcodes + ",").Contains("," + rd.Barcode + ","));
if (info.Nature == 1)//组合
{
var groups = BaseService <ProductGroup> .CurrentRepository.Entities.Where(o => o.Barcode == info.Barcode).ToList();
barcodes = groups.Select(o => o.GroupBarcode).ToList();
var inventList2 = BaseService <Inventory> .FindList(o => barcodes.Contains(o.Barcode) && o.StoreId == rd.StoreId);
rds.Remove(rd);
foreach (var g in groups)
{
var ir = new InventoryRecord()
{
Number = g.Number * rd.Number, Barcode = g.GroupBarcode, StoreId = rd.StoreId, Source = rd.Source, OperatId = rd.OperatId, CreateDT = rd.CreateDT, CreateUID = rd.CreateUID
};
UpdateInvent(inventList2, ir);
rds.Add(ir);
}
continue;
}
var inventList = BaseService <Inventory> .FindList(o => (o.Barcode == rd.Barcode || o.Barcode == info.Barcode) && o.StoreId == rd.StoreId);
if (rd.Barcode != info.Barcode && !info.Barcodes.IsNullOrEmpty())//一品多码
{
rd.Barcode = info.Barcode;
UpdateInvent(inventList, rd);
}
else if (info.Nature == 2 && outSources.Contains(rd.Source))//出库存拆分
{
var purchaseNumber = rd.Number;
var storeId = rd.StoreId;
var childProductInventory = inventList.FirstOrDefault(o => o.StockNumber > 0 && o.Barcode == info.Barcode);
if (childProductInventory != null)
{
var stockNum = childProductInventory.StockNumber;
if (stockNum >= purchaseNumber)
{
UpdateInvent(inventList, rd);
}
else if (stockNum < purchaseNumber)
{
var ir = new InventoryRecord()
{
Number = stockNum, Barcode = rd.Barcode, StoreId = storeId, Source = rd.Source, OperatId = rd.OperatId, CreateDT = rd.CreateDT, CreateUID = rd.CreateUID
};
UpdateInvent(inventList, ir);
SplitSingleProduct(purchaseNumber - stockNum, storeId, info, ref rds);
}
}
else
{
SplitSingleProduct(purchaseNumber, storeId, info, ref rds);
}
}
else
{
UpdateInvent(inventList, rd);//单品
}
}
AddRange(rds.Where(o => o.Number > 0 && o.Source != 13).ToList(), false);
}
public PilotsController(IMapper mapper, BaseService service)
{
this.mapper = mapper;
this.service = service;
}
public void PushWeiXin(string OpenId, LoggingSessionInfo loggingSessionInfo, string OrderId, string VipId)
{
string webUrl = ConfigurationManager.AppSettings["website_url"];
string msgUrl = ConfigurationManager.AppSettings["push_weixin_msg_url"];;
Random rad = new Random();
string msgText = "<a href='" + webUrl + "wap/Event/20131109/aboutEvent.htm'>点击查看本次活动议程</a>";
string msgData = "<xml><OpenID><![CDATA[" + OpenId + "]]></OpenID>"
+ "<Content><![CDATA[" + msgText + "]]></Content></xml>";
//var msgResult = Common.Utils.GetRemoteData(msgUrl, "POST", msgData);
#region 发送日志
MarketSendLogBLL logServer = new MarketSendLogBLL(loggingSessionInfo);
MarketSendLogEntity logInfo = new MarketSendLogEntity();
logInfo.LogId = BaseService.NewGuidPub();
logInfo.IsSuccess = 1;
logInfo.MarketEventId = OrderId;
logInfo.SendTypeId = "2";
logInfo.TemplateContent = msgData;
logInfo.VipId = VipId;
logInfo.WeiXinUserId = OpenId;
logInfo.CreateTime = System.DateTime.Now;
logServer.Create(logInfo);
#endregion
#region
msgText = "亲爱的，为答谢您参加本次活动，主办方推出多个奖品的刮刮卡等你来刮，快来试试运气，<a href='" + webUrl + "OnlineClothing/1109guagua.html?customerId="
+ loggingSessionInfo.CurrentUser.customer_id
+ "&userId="
+ VipId
+ "&openId="
+ OpenId
+ "&eventId=" + OrderId + "'>点击试试手气</a>";
//msgData = "<xml><OpenID><![CDATA[" + OpenId + "]]></OpenID>"
// + "<Content><![CDATA[" + msgText + "]]></Content></xml>";
LEventsBLL eventServer = new LEventsBLL(loggingSessionInfo);
LEventsEntity eventInfo = new LEventsEntity();
eventInfo = eventServer.GetByID(OrderId);
if (eventInfo != null && eventInfo.EventID != null)
{
string picUrl1 = eventInfo.Content;
string Url1 = "" + webUrl + "OnlineClothing/1109guagua.html?customerId="
+ loggingSessionInfo.CurrentUser.customer_id
+ "&userId="
+ VipId
+ "&openId="
+ OpenId
+ "&eventId=" + OrderId + "";
msgData = "<xml>"
+ "<OpenID><![CDATA[" + OpenId + "]]></OpenID>"
+ "<MsgType><![CDATA[news]]></MsgType>"
+ "<Articles>"
+ "<item>"
+ "<Title><![CDATA[活动刮刮卡，惊喜享不停！]]></Title> "
+ "<Description><![CDATA[亲！为答谢您来参加本次活动，我们特别推出刮刮卡，大量精美奖品等你来取，快来试试运气吧。]]></Description> "
+ "<Url><![CDATA[" + Url1 + "]]></Url> "
+ "<PicUrl><![CDATA[" + picUrl1 + "]]></PicUrl> "
+ "</item>"
+ "</Articles>"
+ "</xml>";
var msgResult1 = Common.Utils.GetRemoteData(msgUrl, "POST", msgData);
}
#endregion
#region 发送日志
MarketSendLogEntity logInfo1 = new MarketSendLogEntity();
logInfo1.LogId = BaseService.NewGuidPub();
logInfo1.IsSuccess = 1;
logInfo1.MarketEventId = OrderId;
logInfo1.SendTypeId = "2";
logInfo1.TemplateContent = msgData;
logInfo1.VipId = VipId;
logInfo1.WeiXinUserId = OpenId;
logInfo1.CreateTime = System.DateTime.Now;
logServer.Create(logInfo1);
#endregion
}
public static object[] AddNewModule(string type, string pageid, string containername, int sortorder)
{
string Url = HttpContext.Current.Request.UrlReferrer.ToString();
BaseService.CheckLoginAndLicense();
//volgende waardes terug geven:
//1. De inhoud gewrapt met module toolbar,
//2: de specifieke javascripts
//3: de moduleID
object[] returnValue = new object[3];
BaseModule module = null;
type = type.Replace("bitModule", "");
containername = containername.Replace("bitContainer", "");
module = ModuleLoader.Load(type);
if (module != null)
{
module.Name = type;
module.Site = SessionObject.CurrentSite;
//module.Page = new CmsPage();
//module.Page.ID = new Guid(pageid);
if (Url.ToLower().Contains("/newsletters"))
{
module.Newsletter = new Newsletter();
module.Newsletter.ID = new Guid(pageid);
}
else
{
module.Page = new CmsPage();
module.Page.ID = new Guid(pageid);
}
module.ContainerName = containername;
module.OrderingNumber = sortorder;
module.Content = module.FirstContentSample;
module.Settings.Add("UseCkeditor", true);
//WORK ARROUND SETTINGS WILLEN NIET OPSLAAN.
module.SettingsJsonString = module.Settings.ToJsonString();
module.Save();
//SetUnpublishedItem(module);
returnValue[1] = module.IncludeScripts;
returnValue[2] = module.ID.ToString();
//moet naar container
//updateOrderingNumber
//alleen degene ophalen met een groter nummer dan sortorder
string where = String.Format("FK_PAGE = '{0}' And ContainerName='{1}' AND OrderingNumber > {2}", pageid, containername, sortorder);
BaseCollection <BaseModule> modules = BaseCollection <BaseModule> .Get(where);
foreach (BaseModule mod in modules)
{
mod.OrderingNumber++;
mod.Save();
}
}
module.ForceReloadTags(); //De tags zijn al gegenereerd, maar dit is gebeurd voor het opslaan van de module. Hierdoor hebben de tags geen geldig control ID. Forceer hergeneratie van de tags. Dit is alleen bij nieuwe modules nodig.
PublishModule(module);
//Na toevoegen nieuwe ook pagina updaten
PublishDependentPages(module);
returnValue[0] = new ModuleService().GetUserControlContent(module);
return(returnValue);
}
private void gpb_CustomButtonChecked(object sender, DevExpress.XtraBars.Docking2010.BaseButtonEventArgs e)
{
try
{
switch (e.Button.Properties.Caption)
{
case "Insert":
ChkBtn(e.Button.Properties.Caption);
rtfSql_Insert.BringToFront();
TopSql = rtfSql_Insert;
break;
case "Update":
ChkBtn(e.Button.Properties.Caption);
rtfSql_Update.BringToFront();
TopSql = rtfSql_Update;
break;
case "Delete":
ChkBtn(e.Button.Properties.Caption);
rtfSql_Delete.BringToFront();
TopSql = rtfSql_Delete;
break;
case "Select":
ChkBtn(e.Button.Properties.Caption);
rtfSql_Select.BringToFront();
TopSql = rtfSql_Select;
break;
case "Generate":
e.Button.Properties.Checked = false;
TopSql = TopSql == null ? rtfSql_Select : TopSql;
if (gvt.FocusedRowHandle >= 0)
{
string conn = gvt.GetFocusedRowCellValue("WorkSet_Connection").ToStringEx();
List <MyParameter> connPara = new List <MyParameter>();
//切换到当前连接
try
{
connPara.Add("@WorkSet_Name", DbType.String, "SystemWorkSet_Schema", null);
connPara.Add("@WorkSet_Connection", DbType.String, conn, null);
BaseService.Execute("SystemWorkSet_SchemaClear", connPara);
}
catch (Exception ex)
{
SharedFunc.RaiseError(ex);
}
List <Sys_Schema> sys_Schemas = new List <Sys_Schema>();
string TableName = gvt.GetFocusedRowCellValue("WorkSet_Table").ToStringEx();
try
{
//执行生成语句
List <MyParameter> myParameters = new List <MyParameter>();
myParameters.Add("@TableName", DbType.String, TableName, null);
DataTable dt = BaseService.Open("SystemWorkSet_Schema", myParameters);
sys_Schemas = EntityHelper.GetEntities <Sys_Schema>(dt);
}
catch (Exception ex)
{
SharedFunc.RaiseError(ex);
}
//切换到默认连接
connPara.Clear();
try
{
connPara.Add("@WorkSet_Name", DbType.String, "SystemWorkSet_Schema", null);
connPara.Add("@WorkSet_Connection", DbType.String, null, null);
BaseService.Execute("SystemWorkSet_SchemaClear", connPara);
}
catch (Exception ex)
{
SharedFunc.RaiseError(ex);
}
if (sys_Schemas != null)
{
if (!string.IsNullOrEmpty(TableName))
{
string IsPagination = gvt.GetFocusedRowCellValue("WorkSet_Pagination").ToStringEx();
if (!string.IsNullOrEmpty(IsPagination) && CurBtn.Equals("Select"))
{
TopSql.Text = ScriptHelper.GenerateSql(TableName, sys_Schemas, "SelectPage");
}
else
{
TopSql.Text = ScriptHelper.GenerateSql(TableName, sys_Schemas, CurBtn);
}
}
}
}
break;
case "Parameter":
e.Button.Properties.Checked = false;
try
{
if (gvt.FocusedRowHandle >= 0)
{
string WorkSet_Name = gvt.GetFocusedRowCellValue("WorkSet_Name").ToStringEx();
if (string.IsNullOrEmpty(WorkSet_Name.Trim()))
{
return;
}
DataTable fdt = (DataTable)gdf.DataSource;
List <MyParameter> myParameter = new List <MyParameter>();
if (string.IsNullOrEmpty(rtfSql_Select.Text))
{
return;
}
string tmpSql = rtfSql_Select.Text;
Regex decRgx = new Regex("DECLARE( )*@(([A-Za-z0-9_])* )( )*([A-Za-z0-9_,])*( )*(,|\r)", RegexOptions.IgnoreCase);
foreach (Match m in decRgx.Matches(tmpSql))
{
Regex eRgx = new Regex("@(([A-Za-z0-9_])*)", RegexOptions.IgnoreCase);
foreach (Match em in eRgx.Matches(m.Value))
{
tmpSql = tmpSql.Replace(em.Value, "");
}
}
//tmpSql = decRgx.Replace(tmpSql, "");
Regex rgxOne = new Regex("@(([A-Za-z0-9_])*)", RegexOptions.IgnoreCase);
foreach (Match OneMth in rgxOne.Matches(tmpSql))
{
if (myParameter.Find(p => p.Name.Equals(OneMth.Value)) == null)
{
string Bind_Name = "Bind_Name='{0}'";
Bind_Name = string.Format(Bind_Name, OneMth.Value);
if (fdt.Select(Bind_Name).Length.Equals(0))
{
DataRow dr = fdt.NewRow();
dr["Bind_WorkSet"] = gvt.GetFocusedRowCellValue("WorkSet_Id").ToStringEx();
dr["Bind_Name"] = OneMth.Value;
dr["Bind_Nick"] = OneMth.Value;
dr["Bind_Field"] = OneMth.Value.Trim('@');
dr["Bind_Width"] = 25;
dr["Bind_ToolTip"] = OneMth.Value;
dr["Bind_Sort"] = fdt.Rows.Count * 10 + 100;
dr["Bind_Visible"] = true;
dr["Bind_ReadOnly"] = false;
dr["Bind_SqlDbType"] = (int)DbType.String;
dr["Bind_Summary"] = 6;
dr["IsDelete"] = 0;
//分页
if (OneMth.Value == "@PageSize" || OneMth.Value == "@PageIndex")
{
dr["Bind_Sort"] = 999999;
dr["Bind_SqlDbType"] = DbType.Int32;
dr["Bind_Field"] = gvt.GetFocusedRowCellValue("WorkSet_Pagination").ToStringEx();
dr["Bind_Property"] = OneMth.Value.Trim('@');
}
fdt.Rows.Add(dr);
}
}
}
}
}
catch (Exception ex)
{
SharedFunc.RaiseError(ex);
}
break;
case "Debug":
e.Button.Properties.Checked = false;
try
{
if (gvt.FocusedRowHandle >= 0)
{
string WorkSet_Name = gvt.GetFocusedRowCellValue("WorkSet_Name").ToStringEx();
if (string.IsNullOrEmpty(WorkSet_Name.Trim()))
{
return;
}
DataTable fdt = (DataTable)gdf.DataSource;
List <MyParameter> myParameter = new List <MyParameter>();
if (string.IsNullOrEmpty(rtfSql_Select.Text))
{
return;
}
List <Sys_Bind> sys_Binds = EntityHelper.GetEntities <Sys_Bind>(fdt);
foreach (Sys_Bind sys_Bind in sys_Binds)
{
myParameter.Add(sys_Bind.Bind_Name, (DbType)sys_Bind.Bind_SqlDbType, null, null);
}
DataTable dt = BaseService.Open(WorkSet_Name, myParameter);
if (dt == null)
{
throw new ArgumentNullException(WorkSet_Name);
}
string TableName = gvt.GetFocusedRowCellValue("WorkSet_Table").ToStringEx();
List <MyParameter> SchemaPara = new List <MyParameter>();
SchemaPara.Add("@TableName", DbType.String, TableName, null);
List <Sys_Schema> sys_Schemas = EntityHelper.GetEntities <Sys_Schema>(BaseService.Open("SystemWorkSet_Schema", SchemaPara));
foreach (DataColumn col in dt.Columns)
{
string Bind_Name = "Bind_Name='{0}'";
Bind_Name = string.Format(Bind_Name, col.ColumnName);
if (fdt.Select(Bind_Name).Length.Equals(0))
{
DataRow dr = fdt.NewRow();
dr["Bind_WorkSet"] = gvt.GetFocusedRowCellValue("WorkSet_Id").ToStringEx();
dr["Bind_Name"] = col.ColumnName;
Sys_Schema sys_Schema = sys_Schemas.Find(s => s.FieldName == col.ColumnName);
dr["Bind_Nick"] = sys_Schema != null && !string.IsNullOrEmpty(sys_Schema.Description) ? sys_Schema.Description : col.ColumnName;
dr["Bind_Field"] = col.ColumnName;
dr["Bind_ToolTip"] = col.ColumnName;
dr["Bind_Sort"] = (col.Ordinal + 10) * 10 + 1000;
dr["Bind_Visible"] = true;
dr["Bind_ReadOnly"] = false;
if (ReservedHelper.GridAutoField.Contains(col.ColumnName))
{
dr["Bind_Visible"] = false;
}
dr["Bind_SqlDbType"] = (int)ConvertHelper.GetDbType(col.DataType);
dr["Bind_Summary"] = 6;
dr["IsDelete"] = 0;
if (col.DataType.Equals(typeof(DateTime)))
{
dr["Bind_Width"] = 128;
}
else if (col.DataType.Equals(typeof(bool)))
{
dr["Bind_Width"] = 40;
}
else if (col.DataType.Equals(typeof(int)))
{
dr["Bind_Width"] = 60;
}
else
{
dr["Bind_Width"] = 100;
}
string submit = gvt.GetFocusedRowCellValue("WorkSet_Type").ToStringEx();
if (submit.Equals("7"))
{
dr["Bind_FormWidth"] = 25;
dr["Bind_FormSort"] = (col.Ordinal + 10) * 10 + 1000;
dr["Bind_Push"] = "edit_" + col.ColumnName;
dr["Bind_Property"] = "EditValue";
}
//IsEditable
if (col.ColumnName == "IsEditable")
{
dr["Bind_Default"] = "True";
}
//IsEditable
if (col.ColumnName == "IsEnabled")
{
dr["Bind_Default"] = "True";
}
if (col.ColumnName == "PageCount")
{
dr["Bind_Property"] = col.ColumnName;
dr["Bind_Push"] = gvt.GetFocusedRowCellValue("WorkSet_Pagination").ToStringEx();
dr["Bind_Sort"] = 999999;
}
fdt.Rows.Add(dr);
}
}
}
}
catch (Exception ex)
{
SharedFunc.RaiseError(ex);
}
break;
case "Design":
e.Button.Properties.Checked = false;
break;
case "Subversion":
e.Button.Properties.Checked = false;
List <MyParameter> mps = new List <MyParameter>();
mps.Add("@cSubversion_Table", DbType.String, "Sys_WorkSet", null);
mps.Add("@cSubversion_Field", DbType.String, "WorkSet_" + CurBtn, null);
mps.Add("@cSubversion_Key", DbType.String, gvt.GetFocusedRowCellValue("WorkSet_Id").ToStringEx(), null);
lstVer.Manager.Items.Clear();
DataTable sdt = BaseService.Open("SystemWorkSet_Subversion", mps);
List <Sys_Subversion> sys_Subversions = EntityHelper.GetEntities <Sys_Subversion>(sdt);
foreach (Sys_Subversion sys_Subversion in sys_Subversions)
{
string cat = sys_Subversion.Subversion_Version.ToString("yyyy-MM-dd");
DevExpress.XtraBars.BarSubItem subItem;
if (lstVer.Manager.Items[cat] == null)
{
subItem = new DevExpress.XtraBars.BarSubItem();
subItem.Name = cat;
subItem.Caption = cat;
lstVer.AddItem(subItem);
}
subItem = (DevExpress.XtraBars.BarSubItem)lstVer.Manager.Items[cat];
DevExpress.XtraBars.BarButtonItem bsi = new DevExpress.XtraBars.BarButtonItem();
bsi.Name = sys_Subversion.Subversion_Id.ToString();
bsi.Hint = sys_Subversion.Subversion_Value;
bsi.Description = sys_Subversion.Subversion_Value;
bsi.Caption = sys_Subversion.Subversion_Version.ToString("HH:mm:ss");
bsi.Tag = sys_Subversion.Subversion_Value;
bsi.ItemClick += Bsi_ItemClick;
subItem.AddItem(bsi);
}
lstVer.ShowPopup(Control.MousePosition);
break;
case "Reset":
e.Button.Properties.Checked = false;
break;
default:
break;
}
}
catch (Exception ex)
{
SharedFunc.RaiseError(ex);
}
}
public void Main()
{
NWCreature attacker = (_.GetLastDamager(NWGameObject.OBJECT_SELF));
NWPlaceable tower = (NWGameObject.OBJECT_SELF);
NWItem weapon = (_.GetLastWeaponUsed(attacker.Object));
int damage = _.GetTotalDamageDealt();
var structureID = tower.GetLocalString("PC_BASE_STRUCTURE_ID");
PCBaseStructure structure = DataService.PCBaseStructure.GetByID(new Guid(structureID));
int maxShieldHP = BaseService.CalculateMaxShieldHP(structure);
PCBase pcBase = DataService.PCBase.GetByID(structure.PCBaseID);
var playerIDs = DataService.PCBasePermission.GetAllByHasPrivatePermissionToBase(structure.PCBaseID)
.Select(s => s.PlayerID);
var toNotify = NWModule.Get().Players.Where(x => playerIDs.Contains(x.GlobalID));
DateTime timer = DateTime.UtcNow.AddSeconds(30);
string clock = timer.ToString(CultureInfo.InvariantCulture);
string sector = BaseService.GetSectorOfLocation(attacker.Location);
if (DateTime.UtcNow <= DateTime.Parse(clock))
{
foreach (NWPlayer player in toNotify)
{
player.SendMessage("Your base in " + attacker.Area.Name + " " + sector + " is under attack!");
}
}
// Apply damage to the shields. Never fall below 0.
pcBase.ShieldHP -= damage;
if (pcBase.ShieldHP <= 0)
{
pcBase.ShieldHP = 0;
}
// Calculate the amount of shield percentage remaining. If the tower is in reinforced mode, HP
// will always be set back to 25% of shields.
float hpPercentage = (float)pcBase.ShieldHP / (float)maxShieldHP * 100.0f;
if (hpPercentage <= 25.0f && pcBase.ReinforcedFuel > 0)
{
pcBase.IsInReinforcedMode = true;
pcBase.ShieldHP = (int)(maxShieldHP * 0.25f);
hpPercentage = (float)pcBase.ShieldHP / (float)maxShieldHP * 100.0f;
}
// Notify the attacker.
attacker.SendMessage("Tower Shields: " + hpPercentage.ToString("0.00") + "%");
if (pcBase.IsInReinforcedMode)
{
attacker.SendMessage("Control tower is in reinforced mode and cannot be damaged. Reinforced mode will be disabled when the tower runs out of fuel.");
}
// HP is tracked in the database. Heal the placeable so it doesn't get destroyed.
_.ApplyEffectToObject(_.DURATION_TYPE_INSTANT, _.EffectHeal(9999), tower.Object);
if (attacker.IsPlayer)
{
DurabilityService.RunItemDecay(attacker.Object, weapon, RandomService.RandomFloat(0.01f, 0.03f));
}
// If the shields have fallen to zero, the tower will begin to take structure damage.
if (pcBase.ShieldHP <= 0)
{
pcBase.ShieldHP = 0;
structure.Durability -= RandomService.RandomFloat(0.5f, 2.0f);
if (structure.Durability < 0.0f)
{
structure.Durability = 0.0f;
}
attacker.SendMessage("Structure Durability: " + structure.Durability.ToString("0.00"));
// If the structure durability drops to zero, destroy everything in the base.
if (structure.Durability <= 0.0f)
{
structure.Durability = 0.0f;
BaseService.ClearPCBaseByID(pcBase.ID, true, false);
MessageHub.Instance.Publish(new OnBaseDestroyed(pcBase, attacker));
return;
}
}
DataService.SubmitDataChange(pcBase, DatabaseActionType.Update);
DataService.SubmitDataChange(structure, DatabaseActionType.Update);
}
/// <summary>
/// 构造
/// </summary>
/// <param name="clsName"></param>
/// <param name="cache"></param>
public BaseBllExtend(BaseService <T> service, string clsName, IDatabase cache = null, IOptions <SysConfig> config = null) : base(service, clsName, cache, config)
{
_cache = cache;
_service = service;
_cacheOpen = cache != null;
}
//查询功能开始
private void btnGoodsType_Click(object sender, EventArgs e)
{
int souci = 0;
dgvSearchList.Rows.Clear();
foreach (string item_InOut in CommValue.BoxInOut)
{
//查询 1.根据上面的集合 先结算进口的
string inwhere = CountWhereBillIndex("ID") + " and (inout='" + item_InOut + "')";
List <BillIndex> billsIndex = new BaseService <BillIndex>().GetRecords(inwhere);
//2.循环进出口的船只
foreach (BillIndex item in billsIndex)
{
List <Total> totals = new BaseService <Total>().GetRecords(" billIndexID=" + item.ID);
//插入记录
InsertDataGridView(dgvSearchList, totals, item.Title);
}
//进出口总计
List <Total> samlltotal = new BaseService <Total>().GetRecords(CountWhereBillIndex("billIndexID") + " and (inout='" + item_InOut + "')");
//插入记录
InsertDataGridView(dgvSearchList, samlltotal, item_InOut + ":" + billsIndex.Count.ToString() + "艘");
souci += billsIndex.Count;
}
//总计 循环找合计数
Dictionary <string, int> ztotals = new Dictionary <string, int>();
ztotals.Add("dgvCount小计", 0);
ztotals.Add("dgvCount总计", 0);
double w1 = 0;
double w2 = 0;
foreach (string item_InOut in CommValue.BoxInOut)
{
//20 40类型
foreach (string item_2040 in CommValue.BoxSize)
{
// 重 空
foreach (string item_State in CommValue.BoxState)
{
ztotals.Add(item_InOut + item_2040 + item_State, 0);
}
}
} //字典初始值
foreach (DataGridViewRow item in dgvSearchList.Rows)
{
if (item.Cells["dgvCountShip"].Value.ToString().Contains("口:")) //如果包括小计的字符
{
foreach (string item_InOut in CommValue.BoxInOut)
{
//20 40类型
foreach (string item_2040 in CommValue.BoxSize)
{
// 重 空
foreach (string item_State in CommValue.BoxState)
{
string s1 = item.Cells["dgvCount" + item_InOut + item_2040 + item_State].Value.ToString();
ztotals[item_InOut + item_2040 + item_State] += (string.IsNullOrEmpty(s1) ? 0 : int.Parse(s1));
}
}
} //数字相加
//总计末尾
string s2 = item.Cells["dgvCount小计"].Value.ToString();
string s3 = item.Cells["dgvCount总计"].Value.ToString();
string s4 = item.Cells["dgvWeight总计"].Value.ToString();
string s5 = item.Cells["dgvWeight小计"].Value.ToString();
ztotals["dgvCount小计"] += int.Parse(s2);
ztotals["dgvCount总计"] += int.Parse(s3);
w1 += double.Parse(s4);
w2 += double.Parse(s5);
//修饰
item.DefaultCellStyle.BackColor = Color.Silver;
item.DefaultCellStyle.Font = new Font("宋体", 10, FontStyle.Bold);
}
}
//总计增加到表格中
int index = dgvSearchList.Rows.Add();
dgvSearchList.Rows[index].Cells["dgvCountShip"].Value = "总计:" + souci.ToString() + "艘";
foreach (string item_InOut in CommValue.BoxInOut)
{
//20 40类型
foreach (string item_2040 in CommValue.BoxSize)
{
// 重 空
foreach (string item_State in CommValue.BoxState)
{
dgvSearchList.Rows[index].Cells["dgvCount" + item_InOut + item_2040 + item_State].Value = (ztotals[item_InOut + item_2040 + item_State] == 0 ? "" : ztotals[item_InOut + item_2040 + item_State].ToString());
}
}
}
dgvSearchList.Rows[index].Cells["dgvCount" + "小计"].Value = (ztotals["dgvCount小计"] == 0?"":ztotals["dgvCount小计"].ToString());
dgvSearchList.Rows[index].Cells["dgvCount" + "总计"].Value = (ztotals["dgvCount总计"] == 0 ? "" : ztotals["dgvCount总计"].ToString());
dgvSearchList.Rows[index].Cells["dgvWeight" + "总计"].Value = w1.ToString();
dgvSearchList.Rows[index].Cells["dgvWeight" + "小计"].Value = w2.ToString();
//修饰
dgvSearchList.Rows[index].DefaultCellStyle.BackColor = Color.Gray;
dgvSearchList.Rows[index].DefaultCellStyle.Font = new Font("宋体", 10, FontStyle.Bold);
}
