public ActionResult Select(int?workerWorkplaceId)
{
IList <WorkerNorma> workerNormas = new List <WorkerNorma>();
WorkerNorma workerNorma = null;
if (workerWorkplaceId != null)
{
WorkerWorkplace workerWorkplace = workerWorkplaceRepository.Get(workerWorkplaceId.Value);
//ViewData["worker"] = workerWorkplace.Worker;
//HttpContext.Cache.Insert("workerWorkplaceId", workerWorkplaceId);
Session.Add("workerWorkplaceId", workerWorkplaceId);
Dictionary <string, object> query = new Dictionary <string, object>();
query.Add("WorkerWorkplace", workerWorkplace);
WorkerCardHead workerCardHead = workerCardRepository.FindOne(query);
foreach (WorkerCardContent workerCardContent in workerCardHead.WorkerCardContents)
{
workerNorma = new WorkerNorma();
workerNorma.StorageId = workerCardContent.Storage.Id;
workerNorma.StorageInfo = workerCardContent.Storage.StorageInfo;
workerNorma.ReceptionDate = workerCardContent.Operation.OperDate;
workerNorma.PresentQuantity = workerCardContent.Quantity;
workerNormas.Add(workerNorma);
}
}
return(View(new GridModel(workerNormas)));
}
public ActionResult Select(int?workerWorkplaceId, string workerWorkplaceText)
{
IList <WorkerNorma> workerNormas = new List <WorkerNorma>();
WorkerNorma workerNorma = null;
// Убрали запоминание табельных. Кладовщики путаются
//if (workerWorkplaceId == null && Session["workerWorkplaceId"] != null)
// workerWorkplaceId = (int)Session["workerWorkplaceId"];
if (workerWorkplaceId != null)
{
WorkerWorkplace workerWorkplace = workerWorkplaceRepository.Get(workerWorkplaceId.Value);
//ViewData["worker"] = workerWorkplace.Worker;
Session.Add("workerWorkplaceId", workerWorkplaceId);
Session.Add("workerWorkplaceText", workerWorkplaceText);
Dictionary <string, object> query = new Dictionary <string, object>();
query.Add("WorkerWorkplace", workerWorkplace);
WorkerCardHead workerCardHead = workerCardRepository.FindOne(query);
if (workerCardHead != null)
{
workerCardHead.WorkerCardContents = reorderWorkerCardContents(workerCardHead.WorkerCardContents);
foreach (WorkerCardContent workerCardContent in workerCardHead.WorkerCardContents)
{
//if (workerCardContent.Quantity <= 0)
// continue;
if (workerCardContent.Quantity > 0)
{
workerNorma = new WorkerNorma();
//workerNorma.Storage = rebuildStorage(workerCardContent.Storage);
workerNorma.Id = workerCardContent.Id;
workerNorma.StorageId = workerCardContent.Storage.Id;
workerNorma.StorageNumber = workerCardContent.Storage.StorageName.StorageNumber;
workerNorma.StorageInfo = workerCardContent.Storage.StorageInfo;
// workerNorma.ReceptionDate = workerCardContent.Operation.OperDate;
workerNorma.ReceptionDate = workerCardContent.StartDate;
workerNorma.PresentQuantity = workerCardContent.Quantity;
//workerNorma.PutQuantity = workerNorma.PresentQuantity;
workerNorma.PutQuantity = 0;
workerNormas.Add(workerNorma);
}
}
}
}
return(View(new GridModel(workerNormas)));
}
//private int getQuantityNomOnStorageByNomGroup(int nomGroupId)
//{
// int result = 0;
// Dictionary<string, object> query = new Dictionary<string, object>();
// query.Add("Nomenclature.NomGroup.Id", nomGroupId);
// IList<Storage> storages = storageRepository.GetByCriteria(query);
// foreach (Storage curStorage in storages)
// {
// result += curStorage.Quantity;
// }
// return result;
//}
//private Storage getStorageForWorkerNorma(NormaContent normaContent, Worker worker)
////private Storage getStorageForWorkerNorma(NormaContent normaContent, IList<NomBodyPartSize> NomBodyPartSizes)
//{
// //Storage storage = null;
// List<Storage> storages = null;
// NomBodyPart normaBodyPart = normaContent.NomGroup.NomBodyPart;
// NomBodyPartSize workerBodyPartSize = null;
// foreach (var item in worker.NomBodyPartSizes)
// //foreach (var item in NomBodyPartSizes)
// {
// if (item.NomBodyPart.Id == normaBodyPart.Id)
// {
// workerBodyPartSize = item;
// break;
// }
// }
// Dictionary<string, object> query = new Dictionary<string, object>();
// query.Add("StorageName.Organization.Id", int.Parse(getCurrentEnterpriseId()));
// query.Add("Nomenclature.NomGroup.Id", normaContent.NomGroup.Id);
// query.Add("NomBodyPartSize.NomBodyPart.Id", normaBodyPart.Id);
// if (workerBodyPartSize != null && DataGlobals.SIZ_SIZE_ID != normaBodyPart.Id)
// query.Add("NomBodyPartSize.SizeNumber", workerBodyPartSize.SizeNumber);
// if (DataGlobals.CLOTH_SIZE_ID == normaBodyPart.Id)
// query.Add("Growth.SizeNumber", worker.Growth);
// storages = (List<Storage>)storageRepository.GetByCriteria(query);
// if (storages == null || storages.Count == 0)
// {
// query.Clear();
// query.Add("StorageName.Organization.Id", int.Parse(getCurrentEnterpriseId()));
// foreach (var normaNomGroup in normaContent.NormaNomGroups)
// {
// query.Add("Nomenclature.NomGroup.Id", normaNomGroup.NomGroup.Id);
// storages.AddRange(storageRepository.GetByLikeCriteria(query));
// query.Remove("Nomenclature.NomGroup.Id");
// }
// }
// if (storages == null || storages.Count == 0)
// {
// storages.Add(new Storage());
// }
// return storages[0];
//}
private WorkerCardContent getWorkerCard(int workerCardContentId, WorkerCardHead workerCardHead)
{
WorkerCardContent outWorkerCard = null;
foreach (WorkerCardContent item in workerCardHead.WorkerCardContents)
{
if (workerCardContentId == item.Id)
{
outWorkerCard = item;
break;
}
}
return(outWorkerCard);
}
// public ActionResult Update(string id)
//public ActionResult Update(WorkerNorma workerNorma)
public ActionResult Update([Bind(Prefix = "updated")] IEnumerable <WorkerNorma> workerNormas)
{
//int workerWorkplaceId = (int)HttpContext.Cache.Get("workerWorkplaceId");
int workerWorkplaceId = (int)Session["workerWorkplaceId"];
string docNumber = operationRepository.GetNextDocNumber(DataGlobals.OPERATION_WORKER_RETURN, getCurrentEnterpriseId());
int? motivId = null;
//DateTime? docDate = null;
DateTime?operDate = null;
// перове число текущего месяца
DateTime firstDay = new DateTime(DateTime.Today.Year, DateTime.Today.Month, 1);
// первое число предыдущего месяца
DateTime minDate = firstDay.AddMonths(-1);
Dictionary <string, object> query = new Dictionary <string, object>();
query.Add("Id", workerWorkplaceId);
WorkerWorkplace workerWorkplace = workerWorkplaceRepository.Get(workerWorkplaceId);
query.Clear();
query.Add("WorkerWorkplace", workerWorkplace);
WorkerCardHead workerCardHead = workerCardRepository.FindOne(query);
if (workerNormas != null)
{
int i = -1;
foreach (var workerNorma in workerNormas)
{
i++;
if (i == 0)
{
if (workerNorma.OperDate != null)
{
operDate = workerNorma.OperDate.Value;
if (DateTime.Today > operDate)
{
operDate = operDate.Value.AddHours(21).AddMinutes(0).AddSeconds(0);
}
else
{
operDate = operDate.Value.AddHours(DateTime.Now.Hour).AddMinutes(DateTime.Now.Minute).AddSeconds(DateTime.Now.Second);
}
}
motivId = workerNorma.MotivId;
}
if (workerNorma.PutQuantity <= 0)
{
continue;
}
//NormaContent normaContent = normaContentRepository.Get(workerNorma.NormaContentId);
WorkerCardContent workerCardContentPresent = getWorkerCard(workerNorma.Id, workerCardHead);
//workerCardContent.Storage = workerNorma.WorkerCardContent.Storage;
// if (workerCardContentPresent.Quantity != workerNorma.PutQuantity)
// ModelState.AddModelError("updated[" + i + "].StorageName", "Списать можно только столько сколько есть на руках");
//if (operDate != null && (DateTime.Now < operDate || minDate > operDate))
if (operDate != null && DateTime.Now < operDate)
{
ModelState.AddModelError(operDate + ": ", "Дата операции должна быть не больше текущей даты и не меньше 1-го числа предыдущего месяца");
}
if (operDate < workerNorma.ReceptionDate)
{
ModelState.AddModelError(operDate + ": ", "Дата возврата не может быть меньше даты выдачи");
}
if (firstDay > operDate)
{
// проверка на закрытие периода
string periodIsClosed = getConfigParamValue(configRepository, "periodIsClosed", getCurrentEnterpriseId());
string periodDateStr = getConfigParamValue(configRepository, "periodDate", getCurrentEnterpriseId());
DateTime periodDate;
DateTime.TryParseExact(periodDateStr, DataGlobals.DATE_FORMAT_FULL_YEAR, null, System.Globalization.DateTimeStyles.None, out periodDate);
if (periodIsClosed != null && periodIsClosed.Equals("1") && periodDate > operDate)
{
ModelState.AddModelError(operDate + ": ", "Период закрыт для изменений");
}
}
if (workerNorma.PutQuantity <= 0)
{
ModelState.AddModelError(workerCardContentPresent.Storage.Nomenclature.Name, "Вернуть можно кол-во больше 0");
}
if (workerNorma.PutQuantity > workerCardContentPresent.Quantity)
{
ModelState.AddModelError(workerCardContentPresent.Storage.Nomenclature.Name, "Вернуть можно не больше чем есть на руках");
}
if (workerNorma.Wear == null)
{
ModelState.AddModelError(workerCardContentPresent.Storage.Nomenclature.Name, "Введите износ");
}
//if (string.IsNullOrEmpty(docNumber) || docDate == null)
// ModelState.AddModelError("updated[" + i + "].StorageName", "Номер и дата документа должны быть заполнены");
}
if (ModelState.IsValid)
{
foreach (var workerNorma in workerNormas)
{
if (workerNorma.PutQuantity <= 0)
{
continue;
}
WorkerCardContent workerCardContentPresent = getWorkerCard(workerNorma.Id, workerCardHead);
//workerCardContentPresent.Storage = null;
Operation oper = new Operation();
oper.OperDate = operDate.Value;
oper.OperType = operTypeRepository.Get(DataGlobals.OPERATION_WORKER_RETURN);
oper.Organization = organizationRepository.Get(workerWorkplace.RootOrganization);
oper.Quantity = workerNorma.PutQuantity;
//oper.Storage = workerCardContentPresent.Storage;
oper.Wear = workerNorma.Wear;
oper.DocNumber = docNumber;
oper.DocDate = oper.OperDate;
oper.Motiv = motivRepository.Get(motivId.Value);
oper.WorkerWorkplace = workerWorkplace;
oper.GiveOperation = workerCardContentPresent.GiveOperation;
//workerCardContentPresent.Operation = oper;
//workerCardContentPresent.Quantity -= oper.Quantity;
if (workerNorma.PutQuantity == workerCardContentPresent.Quantity)
{
workerCardHead.WorkerCardContents.Remove(workerCardContentPresent);
}
// workerCardContentRepository.Delete(workerCardContentPresent);
//workerCardRepository.SaveOrUpdate(workerCardHead);
// если не утиль, ищем позицию с таким износом на складе
//if (int.Parse(workerNorma.Wear) > 0)
//{
query.Clear();
query.Add("Nomenclature", workerCardContentPresent.Storage.Nomenclature);
if (workerCardContentPresent.Storage.NomBodyPartSize != null)
{
query.Add("NomBodyPartSize", workerCardContentPresent.Storage.NomBodyPartSize);
}
if (workerCardContentPresent.Storage.Growth != null)
{
query.Add("Growth", workerCardContentPresent.Storage.Growth);
}
query.Add("StorageName", workerCardContentPresent.Storage.StorageName);
if (int.Parse(workerNorma.Wear) > 0)
{
query.Add("Wear", workerNorma.Wear);
}
IList <Storage> storages = storageRepository.GetByCriteria(query);
Storage storage = null;
if (storages.Count > 0)
{
storage = storages[0];
if (int.Parse(workerNorma.Wear) > 0)
{
storage.Quantity += workerNorma.PutQuantity;
}
}
else
{
storage = new Storage();
storage.Growth = workerCardContentPresent.Storage.Growth;
storage.NomBodyPartSize = workerCardContentPresent.Storage.NomBodyPartSize;
storage.Nomenclature = workerCardContentPresent.Storage.Nomenclature;
storage.StorageName = workerCardContentPresent.Storage.StorageName;
storage.Wear = workerNorma.Wear;
if (int.Parse(workerNorma.Wear) > 0)
{
storage.Quantity = workerNorma.PutQuantity;
}
else
{
storage.Quantity = 0;
}
}
storageRepository.SaveOrUpdate(storage);
oper.Storage = storage;
operationRepository.SaveOrUpdate(oper);
if (workerNorma.PutQuantity == workerCardContentPresent.Quantity)
{
workerCardContentPresent.OperReturn = oper;
workerCardContentPresent.Quantity = 0;
workerCardContentPresent.EndDate = oper.OperDate;
}
else
{
workerCardContentPresent.Quantity = workerCardContentPresent.Quantity - workerNorma.PutQuantity;
WorkerCardContent wcc = new WorkerCardContent();
wcc.Quantity = 0;
wcc.StartDate = workerCardContentPresent.StartDate;
wcc.EndDate = oper.OperDate;
wcc.WorkerCardHead = workerCardContentPresent.WorkerCardHead;
wcc.Storage = workerCardContentPresent.Storage;
wcc.Operation = workerCardContentPresent.Operation;
wcc.OperReturn = oper;
wcc.NormaContent = workerCardContentPresent.NormaContent;
wcc.GiveOperation = workerCardContentPresent.GiveOperation;
workerCardContentRepository.SaveOrUpdate(wcc);
}
workerCardContentRepository.SaveOrUpdate(workerCardContentPresent);
if (firstDay > operDate)
{
//пересчитываем остатки
rebuildRemaind(operationRepository, remainsRepository, storage, minDate, firstDay.AddSeconds(-1), firstDay);
}
//}
}
}
}
return(Select(workerWorkplaceId, (string)Session["workerWorkplaceText"], (string)Session["storageNameId"]));
}
public ActionResult Select(int?workerWorkplaceId, string workerWorkplaceText, string storageNameId)
{
IList <WorkerNorma> workerNormas = new List <WorkerNorma>();
WorkerNorma workerNorma = null;
// Убрали запоминание табельных. Кладовщики путаются
//if (workerWorkplaceId == null && Session["workerWorkplaceId"] != null)
// workerWorkplaceId = (int)Session["workerWorkplaceId"];
if (workerWorkplaceId != null)
{
WorkerWorkplace workerWorkplace = workerWorkplaceRepository.Get(workerWorkplaceId.Value);
//ViewData["worker"] = workerWorkplace.Worker;
Session.Add("workerWorkplaceId", workerWorkplaceId);
Session.Add("workerWorkplaceText", workerWorkplaceText);
Session.Add("storageNameId", storageNameId);
Dictionary <string, object> query = new Dictionary <string, object>();
Dictionary <string, object> order = new Dictionary <string, object>();
query.Add("WorkerWorkplace", workerWorkplace);
WorkerCardHead workerCardHead = workerCardRepository.FindOne(query);
if (workerCardHead != null)
{
//query.Clear();
//order.Clear();
//query.Add("WorkerCardHead.Id", workerCardHead.Id);
//order.Add("Storage.Nomenclature.Name", ASC);
//workerCardHead.WorkerCardContents = workerCardContentRepository.GetByCriteria(query, order);
workerCardHead.WorkerCardContents = reorderWorkerCardContents(workerCardHead.WorkerCardContents);
foreach (WorkerCardContent workerCardContent in workerCardHead.WorkerCardContents)
{
//if (workerCardContent.Quantity <= 0)
// continue;
StorageName storageName = storageNameRepository.Get(int.Parse(storageNameId));
// if (workerCardContent.Storage.StorageName.Id.ToString() != storageNameId)
if (workerCardContent.Storage.StorageName.StorageNumber != storageName.StorageNumber)
{
continue;
}
if (workerCardContent.Quantity > 0)
{
workerNorma = new WorkerNorma();
//workerNorma.Storage = rebuildStorage(workerCardContent.Storage);
workerNorma.Id = workerCardContent.Id;
workerNorma.StorageId = workerCardContent.Storage.Id;
workerNorma.StorageNumber = workerCardContent.Storage.StorageName.StorageNumber;
workerNorma.StorageInfo = workerCardContent.Storage.StorageInfo;
workerNorma.Wear = workerCardContent.Storage.Wear;
//Возвращают в основном б/у
//workerNorma.Wear = "50";
workerNorma.Wear = "";
// workerNorma.ReceptionDate = workerCardContent.Operation.OperDate;
workerNorma.ReceptionDate = workerCardContent.StartDate;
workerNorma.PresentQuantity = workerCardContent.Quantity;
//workerNorma.PutQuantity = workerNorma.PresentQuantity;
workerNorma.PutQuantity = 0;
workerNormas.Add(workerNorma);
}
}
}
}
return(View(new GridModel(workerNormas)));
}
// public ActionResult Update(string id)
//public ActionResult Update(WorkerNorma workerNorma)
public ActionResult Update([Bind(Prefix = "updated")] IEnumerable <WorkerNorma> workerNormas)
{
//int workerWorkplaceId = (int)HttpContext.Cache.Get("workerWorkplaceId");
int workerWorkplaceId = (int)Session["workerWorkplaceId"];
if (workerNormas != null)
{
int i = -1;
foreach (var workerNorma in workerNormas)
{
i++;
if (workerNorma.PutQuantity <= 0)
{
continue;
}
Dictionary <string, object> query = new Dictionary <string, object>();
query.Add("Id", workerWorkplaceId);
WorkerWorkplace workerWorkplace = workerWorkplaceRepository.Get(workerWorkplaceId);
//TryUpdateModel(workerNorma);
//WorkerCard workerCard = workerNorma.WorkerCard;
//WorkerCard workerCard = new WorkerCard();
query.Clear();
query.Add("WorkerWorkplace", workerWorkplace);
WorkerCardHead workerCardHead = workerCardRepository.FindOne(query);
WorkerCardContent workerCardContent = new WorkerCardContent();
if (workerCardHead == null)
{
workerCardHead = new WorkerCardHead();
workerCardHead.WorkerCardContents = new List <WorkerCardContent>();
workerCardHead.WorkerWorkplace = workerWorkplace;
}
workerCardContent.Quantity = workerNorma.PutQuantity;
//workerCardContent.Storage = workerNorma.WorkerCardContent.Storage;
if (workerNorma.StorageId == 0)
{
ModelState.AddModelError("updated[" + i + "].StorageName", "Выберите номенклатуру");
}
else
{
workerCardContent.Storage = storageRepository.Get(workerNorma.StorageId);
workerCardContent.WorkerCardHead = workerCardHead;
if (workerCardContent.Storage.Quantity - workerNorma.PutQuantity < 0)
{
ModelState.AddModelError("updated[" + i + "].StorageName", "На складе недостаточно кол-ва");
}
if (workerNorma.PresentQuantity + workerNorma.PutQuantity > workerNorma.NormaQuantity)
{
ModelState.AddModelError("updated[" + i + "].StorageName", "На руках есть номенклатура у которой не истек срок");
}
}
if (ModelState.IsValid)
{
//replaceIfExist(workerCardHead.WorkerCardContents, workerCardContent, workerNorma);
Operation oper = new Operation();
oper.OperDate = DateTime.Now;
oper.OperType = operTypeRepository.Get(DataGlobals.OPERATION_WORKER_IN);
oper.Organization = organizationRepository.Get(workerWorkplace.RootOrganization);
oper.Quantity = workerCardContent.Quantity;
oper.Storage = workerCardContent.Storage;
workerCardContent.Operation = oper;
oper.Storage.Quantity -= oper.Quantity;
oper.WorkerWorkplace = workerWorkplace;
operationRepository.SaveOrUpdate(oper);
workerCardRepository.SaveOrUpdate(workerCardHead);
}
}
}
return(Select(workerWorkplaceId));
}
public void SaveOnHand(HttpResponseBase response, string loadDate, int operTypeId, IEnumerable <HttpPostedFileBase> attachments)
{
// The Name of the Upload component is "attachments"
IFormatProvider culture = new System.Globalization.CultureInfo("ru-RU", true);
DateTime operationDate;
DateTime.TryParseExact(loadDate, DataGlobals.DATE_FORMAT_FULL_YEAR, null, System.Globalization.DateTimeStyles.None, out operationDate);
if (operationDate == Null_Date)
{
response.Write("Ошибка в дате операции!<br/>");
response.Flush();
return;
}
foreach (var file in attachments)
{
// Some browsers send file names with full path. This needs to be stripped.
var isError = false;
var fileName = Path.GetFileName(file.FileName);
response.Write("Обрабатывается файл <b>" + fileName + "</b><br/>");
response.Flush();
var physicalFilePath = Path.Combine(Server.MapPath("~/TempFiles"), fileName);
try
{
if (System.IO.File.Exists(physicalFilePath))
{
System.IO.File.Delete(physicalFilePath);
}
try
{
file.SaveAs(physicalFilePath);
}
catch (Exception e)
{
response.Write("Ошибка при охранении файла на сервере:<br/>");
response.Write(e.Message);
response.Flush();
isError = true;
}
System.Data.DataTable table = null;
string workSheetNames = "";
if (!isError)
{
try
{
ExcelReader excelReader = new ExcelReader(physicalFilePath, true);
if (excelReader.workSheetNames.Length > 0)
{
workSheetNames = excelReader.workSheetNames[0];
table = excelReader.GetWorksheet(workSheetNames);
}
else
{
response.Write("В файле не найден рабочий лист!<br/>");
response.Flush();
isError = true;
}
}
catch (Exception e)
{
response.Write("Ошибка при открытии файла:<br/>");
response.Write(e.Message);
response.Flush();
isError = true;
}
}
if (table != null)
{
response.Write("Загрузка данных производится из листа с именем '" + workSheetNames.Trim(new[] { '$' }) + "'<br/>");
response.Flush();
if (!table.Columns.Contains("Табельный номер"))
{
response.Write("Файл содержит не коррекные данные ('Табельный номер').<br/>");
response.Flush();
isError = true;
}
if (!table.Columns.Contains("Номенклатурный номер"))
{
response.Write("Файл содержит не коррекные данные ('Номенклатурный номер').<br/>");
response.Flush();
isError = true;
}
if (!table.Columns.Contains("Дата выдачи"))
{
response.Write("Файл содержит не коррекные данные ('Дата выдачи').<br/>");
response.Flush();
isError = true;
}
if (!table.Columns.Contains("Кол-во"))
{
response.Write("Файл содержит не коррекные данные ('Кол-во').<br/>");
response.Flush();
isError = true;
}
/*
* if (!table.Columns.Contains("Период"))
* {
* response.Write("Файл содержит не коррекные данные ('Период').<br/>");
* response.Flush();
* isError = true;
* }
*/
int colTabN = table.Columns.IndexOf("Табельный номер");
int colNomenclature = table.Columns.IndexOf("Номенклатурный номер");
int colDate = table.Columns.IndexOf("Дата выдачи");
int colCount = table.Columns.IndexOf("Кол-во");
int colUsePeriod = -1;
if (!table.Columns.Contains("Период"))
{
colUsePeriod = table.Columns.IndexOf("Период");
}
if (!isError)
{
// DataRow[] result = table.Select("F2 = '*' and F3=" + storageName.Plant + " and F4 in (" + storageName.StorageNumber + ")");
DataRow[] result = table.Select();
Dictionary <string, object> queryParams = new Dictionary <string, object>();
Dictionary <string, object> orderParams = new Dictionary <string, object>();
int idOrg = int.Parse(getCurrentEnterpriseId());
Organization currentOrg = organizationRepository.Get(idOrg);
Motiv motiv = motivRepository.Get(DataGlobals.MOTIVID_TRANSFER);
foreach (DataRow row in result) // Loop over the rows.
{
if (row[colTabN] != System.DBNull.Value)
{
int tabN = int.Parse(row[colTabN].ToString());
int quantity = 0;
if (!int.TryParse(row[colCount].ToString(), out quantity))
{
response.Write("У человека с Таб.№ " + tabN + " ошибка в кол-ве!<br/>");
response.Flush();
continue;
}
DateTime startDate;
String rowDate = row[colDate].ToString();
if (rowDate.IndexOf(' ') > 0)
{
rowDate = rowDate.Substring(0, rowDate.IndexOf(' '));
}
DateTime.TryParseExact(rowDate, DataGlobals.DATE_FORMAT_FULL_YEAR, null, System.Globalization.DateTimeStyles.None, out startDate);
if (startDate == Null_Date)
{
response.Write("У человека с Таб.№ " + tabN + " ошибочная дата выдачи!<br/>");
response.Flush();
continue;
}
if (startDate > DateTime.Now)
{
response.Write("У человека с Таб.№ " + tabN + " дата выдачи больше текущей даты!<br/>");
response.Flush();
continue;
}
int useperiod = 0;
if (colUsePeriod >= 0)
{
useperiod = int.Parse(row[colUsePeriod].ToString());
}
// Ищем id работника по табельному номеру, если не находим, то не берем его
queryParams.Clear();
queryParams.Add("RootOrganization", currentOrg.Id);
//queryParams.Add("IsActive", true);
queryParams.Add("TabN", tabN);
Worker correntWorker = workerRepository.FindOne(queryParams);
if (correntWorker == null)
{
response.Write("Человека с Таб.№ " + tabN + " нет в базе!<br/>");
response.Flush();
continue;
}
// Ищем ID рабочего места
queryParams.Clear();
queryParams.Add("RootOrganization", currentOrg.Id);
queryParams.Add("Worker", correntWorker);
// Будем ипользовать последнее место работы
orderParams.Clear();
orderParams.Add("BeginDate", DESC);
orderParams.Add("IsActive", DESC);
IList <WorkerWorkplace> workerWorkplaces = workerWorkplaceRepository.GetByLikeCriteria(queryParams, orderParams);
// Ищем id номенклатуры на руках( сверила все номенклатуры, в справочнике есть все)
queryParams.Clear();
queryParams.Add("Organization", currentOrg);
queryParams.Add("ExternalCode", row[colNomenclature].ToString());
queryParams.Add("IsActive", true);
IList <Nomenclature> nomenclatures = nomenclatureRepository.GetByLikeCriteria(queryParams);
if (nomenclatures.Count == 0)
{
queryParams.Clear();
queryParams.Add("Organization", currentOrg);
queryParams.Add("ExternalCode", row[colNomenclature].ToString());
queryParams.Add("IsActive", false);
nomenclatures = nomenclatureRepository.GetByLikeCriteria(queryParams);
if (nomenclatures.Count == 0)
{
response.Write("Номенклатура с № " + row[colNomenclature].ToString() + " не найдена в системе!<br/>");
response.Flush();
continue;
}
}
// Ищем склад
queryParams.Clear();
queryParams.Add("AreaCode", workerWorkplaces[0].Organization.AreaCode);
queryParams.Add("Organization", currentOrg);
//StorageName storageName = storageNameRepository.FindOne(queryParams);
StorageName storageName = workerWorkplaces[0].Organization.StorageName;
if (storageName == null)
{
response.Write("Для человека с Таб.№ " + tabN + "не найден склад!<br/>");
response.Flush();
continue;
}
operationRepository.DbContext.BeginTransaction();
try
{
// Ищем есть ли подобная позиция на складе (номенклатура+рост+размер), считаем, что % годностиу всех 100
// Если не находим, то добавляем запись на склад с нулевым кол-вом
queryParams.Clear();
queryParams.Add("StorageName", storageName);
queryParams.Add("Nomenclature", nomenclatures[0]);
queryParams.Add("Wear", "100");
Storage storage = storageRepository.FindOne(queryParams);
if (storage == null)
{
storage = new Storage();
storage.StorageName = storageName;
storage.Nomenclature = nomenclatures[0];
storage.Quantity = 0;
storage.Wear = "100";
storageRepository.SaveOrUpdate(storage);
storage.NomBodyPartSize = nomenclatures[0].NomBodyPartSize;
storage.Growth = nomenclatures[0].Growth;
}
OperType operType = operTypeRepository.Get(operTypeId);
//OperType operType = operTypeRepository.Get(DataGlobals.OPERATION_WORKER_IN);
//OperType operType = operTypeRepository.Get(DataGlobals.OPERATION_STORAGE_TRANSFER_IN);
// Добавляем операцию постановки на забаланс , вместо последней выдачи
queryParams.Clear();
queryParams.Add("OperType", operType);
queryParams.Add("DocNumber", "0");
queryParams.Add("Storage", storage);
queryParams.Add("WorkerWorkplace", workerWorkplaces[0]);
Operation operation = operationRepository.FindOne(queryParams);
if (operation == null)
{
operation = new Operation();
operation.DocNumber = "0";
if (operType.Id == DataGlobals.OPERATION_STORAGE_TRANSFER_IN)
{
operation.DocDate = operationDate;
operation.OperDate = operationDate;
operation.Motiv = motiv;
}
else
{
operation.DocDate = startDate;
operation.OperDate = startDate;
}
operation.OperType = operType;
operation.Organization = storageName.Organization;
operation.Quantity = quantity;
operation.Wear = "100";
operation.StorageName = storageName;
operation.Storage = storage;
operation.WorkerWorkplace = workerWorkplaces[0];
if (operation.OperType.Id == DataGlobals.OPERATION_WORKER_IN)
{
operation.GiveOperation = operation;
}
operationRepository.SaveOrUpdate(operation);
}
// Формируем личную карточку
// Если нет шапки формируеруем шапку
queryParams.Clear();
queryParams.Add("WorkerWorkplace", workerWorkplaces[0]);
WorkerCardHead workerCardHead = workerCardHeadRepository.FindOne(queryParams);
if (workerCardHead == null)
{
workerCardHead = new WorkerCardHead();
workerCardHead.WorkerWorkplace = workerWorkplaces[0];
workerCardHeadRepository.SaveOrUpdate(workerCardHead);
}
// Формируем содержание личной карточки
queryParams.Clear();
queryParams.Add("Operation", operation);
queryParams.Add("WorkerCardHead", workerCardHead);
WorkerCardContent workerCardContent = workerCardContentRepository.FindOne(queryParams);
if (workerCardContent == null)
{
workerCardContent = new WorkerCardContent();
workerCardContent.Operation = operation;
workerCardContent.Quantity = quantity;
workerCardContent.Storage = storage;
workerCardContent.WorkerCardHead = workerCardHead;
workerCardContent.StartDate = startDate;
workerCardContent.UsePeriod = useperiod;
workerCardContentRepository.SaveOrUpdate(workerCardContent);
}
operationRepository.DbContext.CommitTransaction();
}
catch (Exception e)
{
operationRepository.DbContext.RollbackTransaction();
response.Write("Ошибка при сохранении данных в БД:<br/>");
response.Write(e.Message);
response.Write("<br/>");
if (e.InnerException != null)
{
response.Write(e.InnerException.Message);
response.Write("<br/>");
}
isError = true;
response.Flush();
}
}
}
response.Flush();
}
response.Flush();
}
if (!isError)
{
response.Write("Файл успешно обработан!");
}
}
finally
{
System.IO.File.Delete(physicalFilePath);
}
}
}
// public ActionResult Update(string id)
//public ActionResult Update(WorkerNorma workerNorma)
public ActionResult Update([Bind(Prefix = "updated")] IEnumerable <WorkerNorma> workerNormas)
{
//int workerWorkplaceId = (int)HttpContext.Cache.Get("workerWorkplaceId");
int workerWorkplaceId = (int)Session["workerWorkplaceId"];
string docNumber = null;
DateTime?docDate = null;
OperType operType = null;
DateTime?operDate = null;
Motiv motiv = null;
Cause cause = null;
Dictionary <string, object> query = new Dictionary <string, object>();
query.Add("Id", workerWorkplaceId);
WorkerWorkplace workerWorkplace = workerWorkplaceRepository.Get(workerWorkplaceId);
query.Clear();
query.Add("WorkerWorkplace", workerWorkplace);
WorkerCardHead workerCardHead = workerCardRepository.FindOne(query);
if (workerNormas != null)
{
int i = -1;
foreach (var workerNorma in workerNormas)
{
i++;
if (i == 0)
{
docNumber = workerNorma.DocNumber;
//DateTime docDate = DateTime.ParseExact(workerNorma.DocDate, DataGlobals.DATE_FORMAT, null);
docDate = workerNorma.DocDate;
operType = operTypeRepository.Get(workerNorma.OperTypeId);
motiv = motivRepository.Get(workerNorma.MotivId);
query.Clear();
query.Add("Id", workerNorma.CauseId);
cause = causeRepository.FindOne(query);
operDate = workerNorma.DocDate;
if (DateTime.Today > operDate)
{
operDate = operDate.Value.AddHours(21).AddMinutes(0).AddSeconds(0);
}
else
{
operDate = operDate.Value.AddHours(DateTime.Now.Hour).AddMinutes(DateTime.Now.Minute).AddSeconds(DateTime.Now.Second);
}
}
if (workerNorma.PutQuantity <= 0)
{
continue;
}
WorkerCardContent workerCardContentPresent = getWorkerCard(workerNorma.Id, workerCardHead);
if (workerNorma.PutQuantity <= 0)
{
ModelState.AddModelError(workerCardContentPresent.Storage.Nomenclature.Name, "Списать можно кол-во больше 0");
}
if (workerNorma.PutQuantity > workerCardContentPresent.Quantity)
{
ModelState.AddModelError(workerCardContentPresent.Storage.Nomenclature.Name, "Списать можно не больше чем есть на руках");
}
if (string.IsNullOrEmpty(docNumber) || docDate == null)
{
ModelState.AddModelError("updated[" + i + "].StorageName", "Номер и дата документа должны быть заполнены");
}
string periodDateStr = getConfigParamValue(configRepository, "periodDate", getCurrentEnterpriseId());
string periodIsClosed = getConfigParamValue(configRepository, "periodIsClosed", getCurrentEnterpriseId());
DateTime periodDate;
DateTime.TryParseExact(periodDateStr, DataGlobals.DATE_FORMAT_FULL_YEAR, null, System.Globalization.DateTimeStyles.None, out periodDate);
// проверка на закрытие периода
if (periodIsClosed != null && periodIsClosed.Equals("1") && periodDate > operDate)
{
ModelState.AddModelError(operDate + ": ", "Период закрыт для изменений");
}
}
if (ModelState.IsValid)
{
foreach (var workerNorma in workerNormas)
{
if (workerNorma.PutQuantity <= 0)
{
continue;
}
WorkerCardContent workerCardContentPresent = getWorkerCard(workerNorma.Id, workerCardHead);
Operation oper = new Operation();
oper.OperDate = operDate.Value;
oper.OperType = operTypeRepository.Get(DataGlobals.OPERATION_WORKER_OUT);
oper.Organization = organizationRepository.Get(workerWorkplace.RootOrganization);
oper.Quantity = workerNorma.PutQuantity;
oper.Storage = workerCardContentPresent.Storage;
oper.DocNumber = docNumber;
oper.DocDate = docDate.Value;
oper.WorkerWorkplace = workerWorkplace;
oper.Motiv = motiv;
oper.Cause = cause;
oper.OperType = operType;
oper.GiveOperation = workerCardContentPresent.GiveOperation;
//workerCardContentPresent.Operation = oper;
//workerCardContentPresent.Quantity -= oper.Quantity;
if (workerNorma.PutQuantity == workerCardContentPresent.Quantity)
{
workerCardHead.WorkerCardContents.Remove(workerCardContentPresent);
}
//Теперь позиции на карточки не удаляем
// workerCardContentRepository.Delete(workerCardContentPresent);
operationRepository.SaveOrUpdate(oper);
if (workerNorma.PutQuantity == workerCardContentPresent.Quantity)
{
workerCardContentPresent.OperReturn = oper;
workerCardContentPresent.Quantity = 0;
workerCardContentPresent.EndDate = oper.OperDate;
}
else
{
workerCardContentPresent.Quantity = workerCardContentPresent.Quantity - workerNorma.PutQuantity;
WorkerCardContent wcc = new WorkerCardContent();
wcc.Quantity = 0;
wcc.StartDate = workerCardContentPresent.StartDate;
wcc.EndDate = operDate.Value;
wcc.WorkerCardHead = workerCardContentPresent.WorkerCardHead;
wcc.Storage = workerCardContentPresent.Storage;
wcc.Operation = workerCardContentPresent.Operation;
wcc.OperReturn = oper;
wcc.NormaContent = workerCardContentPresent.NormaContent;
wcc.GiveOperation = workerCardContentPresent.GiveOperation;
workerCardContentRepository.SaveOrUpdate(wcc);
}
workerCardContentRepository.SaveOrUpdate(workerCardContentPresent);
//workerCardRepository.SaveOrUpdate(workerCardHead);
}
}
}
return(Select(workerWorkplaceId, (string)Session["workerWorkplaceText"]));
}
public ActionResult CancelOper()
{
int workerWorkplaceId = (int)Session["workerWorkplaceId"];
Dictionary <string, object> query = new Dictionary <string, object>();
Dictionary <string, object> order = new Dictionary <string, object>();
query.Add("WorkerWorkplace.Id", workerWorkplaceId);
query.Add("OperType.Id", DataGlobals.OPERATION_WORKER_OUT);
query.Add("OperDate", DateTime.Today);
IList <Operation> operations = operationRepository.GetByLikeCriteria(query);
string lastDocNumber = "-1";
foreach (var item in operations)
{
if (int.Parse(item.DocNumber) > int.Parse(lastDocNumber))
{
lastDocNumber = item.DocNumber;
}
}
query.Clear();
query.Add("WorkerWorkplace.Id", workerWorkplaceId);
WorkerCardHead workerCardHead = workerCardRepository.GetByCriteria(query)[0];
WorkerCardContent workerCardContent = null;
foreach (var item in operations)
{
if (item.DocNumber != lastDocNumber)
{
continue;
}
// ищем операцию по которой выдавалось
query.Clear();
order.Clear();
query.Add("WorkerWorkplace.Id", workerWorkplaceId);
query.Add("Storage.Id", item.Storage.Id);
query.Add("OperType.Id", DataGlobals.OPERATION_WORKER_IN);
order.Add("OperDate", DESC);
Operation operation = operationRepository.GetByLikeCriteria(query, order)[0];
workerCardContent = new WorkerCardContent();
workerCardContent.WorkerCardHead = workerCardHead;
workerCardContent.Operation = operation;
workerCardContent.Storage = item.Storage;
workerCardContent.Quantity = item.Quantity;
workerCardHead.WorkerCardContents.Add(workerCardContent);
workerCardContentRepository.SaveOrUpdate(workerCardContent);
operationRepository.Delete(item);
}
workerCardRepository.SaveOrUpdate(workerCardHead);
//return Index();
//return RedirectToAction("Index");
//return Select(workerWorkplaceId, (string)Session["workerWorkplaceText"], (string)Session["storageNameId"] );
return(null);
}
public ActionResult _TransferWorkerCard(int?workerWorkplaceId, int storageNameId, string listId, Boolean outNorma, string OperDate)
{
DateTime operDate;
DateTime.TryParseExact(OperDate, DataGlobals.DATE_FORMAT, null, System.Globalization.DateTimeStyles.None, out operDate);
ResultState resultState = new ResultState();
resultState.Status = ResultState.OK;
if (workerWorkplaceId != null)
{
Dictionary <string, object> query = new Dictionary <string, object>();
Dictionary <string, object> order = new Dictionary <string, object>();
query.Add("Worker.Id", workerWorkplaceId);
query.Add("IsActive", true);
order.Add("Storage.StorageName.Id", storageNameId);
//Выбираем активные рабочие места
IList <WorkerWorkplace> workerWorkplaces = workerWorkplaceRepository.GetByLikeCriteria(query);
if (workerWorkplaces.Count == 1)
{
WorkerWorkplace ww = workerWorkplaces[0];
//Выбираем активные рабочие места
// Запрет на одевание работника в салоне к которому он не приписан. Пока закомментировала, т.к. не уверена, что не будет последствий
/*
* if (ww.Organization.StorageName.Id != storageNameId)
* {
* resultState.Status = ResultState.ERROR;
* resultState.setMessage("НЕЛЬЗЯ ВЫПОЛНИТЬ ПЕРЕВОД!!! Работник приписан к складу " + ww.Organization.StorageName.StorageNumber);
* }
*/
string periodDateStr = getConfigParamValue(configRepository, "periodDate", getCurrentEnterpriseId());
string periodIsClosed = getConfigParamValue(configRepository, "periodIsClosed", getCurrentEnterpriseId());
DateTime periodDate;
DateTime.TryParseExact(periodDateStr, DataGlobals.DATE_FORMAT_FULL_YEAR, null, System.Globalization.DateTimeStyles.None, out periodDate);
// проверка на закрытие периода
if (periodIsClosed != null && periodIsClosed.Equals("1") && periodDate > operDate)
{
resultState.Status = ResultState.ERROR;
resultState.setMessage(OperDate + ": Период закрыт для изменений");
}
if (resultState.Status == ResultState.OK)
{
query.Clear();
query.Add("WorkerWorkplace", ww);
WorkerCardHead newWorkerCardHead = workerCardRepository.FindOne(query);
if (newWorkerCardHead == null)
{
newWorkerCardHead = new WorkerCardHead();
newWorkerCardHead.WorkerWorkplace = ww;
}
query.Clear();
query.Add("Organization", ww.Organization);
query.Add("Norma.Organization.Id", int.Parse(getCurrentEnterpriseId()));
query.Add("Norma.IsActive", true);
IList <NormaOrganization> normaOrganizations = normaOrganizationRepository.GetByCriteria(query);
IList <NomenclatureSimple> list = getNomenclaturesByParam(listId);
string docNumber = "00000";
// Убрала ниже, чтобы можно было изменять номер документа
docNumber = operationRepository.GetNextDocNumber(DataGlobals.OPERATION_STORAGE_TRANSFER_OUT, getCurrentEnterpriseId());
int?skladId = null;
foreach (var item in list)
{
ResultState listResultState = new ResultState();
listResultState.Status = ResultState.OK;
WorkerCardContent oldWorkerCardContent = workerCardContentRepository.Get(item.Id);
if (skladId != null && skladId != oldWorkerCardContent.Storage.StorageName.Id)
{
docNumber = operationRepository.GetNextDocNumber(DataGlobals.OPERATION_STORAGE_TRANSFER_OUT, getCurrentEnterpriseId());
}
if (oldWorkerCardContent.StartDate >= operDate)
{
listResultState.Status = ResultState.ERROR;
listResultState.setMessage(item.Name + " Дата перевода раньше даты выдачи!!! Введите текущую дату!");
resultState.Status = ResultState.ERROR;
resultState.setMessage(item.Name + " Дата перевода раньше даты выдачи!!! Введите текущую дату!");
}
NormaContent newNormaContent = GetNewNormaContent(normaOrganizations, item.GroupId);
// Если на новом рабочем месте номенклатура не подходит по норме и выбрана опция
//Ставим старую норму
//Закомментировано, т.к. по просьбе УПУ не нужно переносить на руки, то что не по норме
if (newNormaContent == null && outNorma == true)
{
newNormaContent = oldWorkerCardContent.NormaContent;
}
// if (newNormaContent != null )
if (newNormaContent == null && outNorma != true)
{
listResultState.Status = ResultState.ERROR;
listResultState.setMessage(item.Name + " НЕ СООТВЕТСТВУЕТ новой норме. Выполните ВОЗВРАТ или СПИСАНИЕ по акту!");
resultState.Status = ResultState.ERROR;
resultState.setMessage(item.Name + " НЕ СООТВЕТСТВУЕТ новой норме. Выполните ВОЗВРАТ или СПИСАНИЕ по акту!");
}
else
{
Storage storageTo = null;
//Выбранный склад и склад номенклатуры совпадают
if (oldWorkerCardContent.Storage.StorageName.Id == storageNameId)
{
storageTo = oldWorkerCardContent.Storage;
}
//Выбранный склад и склад номенклатуры не совпадают
else
{
//Пытаемся найти номенклатуру на другом складе
StorageName storageName = storageNameRepository.Get(storageNameId);
if (storageName == null)
{
listResultState.Status = ResultState.ERROR;
listResultState.setMessage("В справочнике не найден склад с идентификатором " + storageNameId + "!");
resultState.Status = ResultState.ERROR;
resultState.setMessage("В справочнике не найден склад с идентификатором " + storageNameId + "!");
}
if (listResultState.Status == ResultState.OK)
{
query.Clear();
query.Add("Nomenclature", oldWorkerCardContent.Storage.Nomenclature);
query.Add("StorageName", storageName);
if (oldWorkerCardContent.Storage.Wear == null)
{
query.Add("[]Wear", "");
}
else
{
query.Add("Wear", oldWorkerCardContent.Storage.Wear);
}
if (oldWorkerCardContent.Storage.Growth == null)
{
query.Add("[]Growth", "");
}
else
{
query.Add("Growth", oldWorkerCardContent.Storage.Growth);
}
if (oldWorkerCardContent.Storage.NomBodyPartSize == null)
{
query.Add("[]NomBodyPartSize", "");
}
else
{
query.Add("NomBodyPartSize", oldWorkerCardContent.Storage.NomBodyPartSize);
}
IList <Storage> storages = storageRepository.GetByLikeCriteria(query);
if (storages.Count > 0)
{
storageTo = storages[0];
}
else
{
//На новом складе не нашлась номенклатура
storageTo = new Storage();
storageTo.StorageName = storageName;
storageTo.Nomenclature = oldWorkerCardContent.Storage.Nomenclature;
storageTo.Quantity = 0;
storageTo.Price = oldWorkerCardContent.Storage.Price;
storageTo.Growth = oldWorkerCardContent.Storage.Growth;
storageTo.NomBodyPartSize = oldWorkerCardContent.Storage.NomBodyPartSize;
storageTo.Wear = oldWorkerCardContent.Storage.Wear;
storageRepository.SaveOrUpdate(storageTo);
}
}
}
// if (resultState.Status == ResultState.OK)
if (listResultState.Status == ResultState.OK)
{
//Создаем операцию на перевод по старому месту работы
Operation oldOperation = new Operation();
oldOperation.WorkerWorkplace = oldWorkerCardContent.WorkerCardHead.WorkerWorkplace;
oldOperation.OperDate = operDate; //DateTime.Now;
oldOperation.Quantity = oldWorkerCardContent.Quantity;
oldOperation.OperType = operTypeRepository.Get(DataGlobals.OPERATION_STORAGE_TRANSFER_OUT);
oldOperation.Organization = organizationRepository.Get(int.Parse(getCurrentEnterpriseId()));
oldOperation.DocNumber = docNumber;
oldOperation.GiveOperation = oldWorkerCardContent.GiveOperation;
//oldOperation.DocDate=
query.Clear();
query.Add("OperType", oldOperation.OperType);
IList <Motiv> motivs = motivRepository.GetByLikeCriteria(query);
if (motivs.Count > 0)
{
oldOperation.Motiv = motivs[0];
}
oldOperation.Storage = oldWorkerCardContent.Storage;
//Создаем операцию на перевод по новому месту работы
Operation newOperation = new Operation();
newOperation.WorkerWorkplace = ww;
newOperation.OperDate = operDate; //DateTime.Now;
newOperation.Quantity = oldWorkerCardContent.Quantity;
newOperation.OperType = operTypeRepository.Get(DataGlobals.OPERATION_STORAGE_TRANSFER_IN);
newOperation.Organization = organizationRepository.Get(int.Parse(getCurrentEnterpriseId()));
newOperation.DocNumber = docNumber;
newOperation.GiveOperation = oldWorkerCardContent.GiveOperation;
//newOperation.DocDate=
motivs.Clear();
query.Clear();
query.Add("OperType", newOperation.OperType);
motivs = motivRepository.GetByLikeCriteria(query);
if (motivs.Count > 0)
{
newOperation.Motiv = motivs[0];
}
newOperation.Storage = storageTo;
newOperation.TransferOperation = oldOperation;
oldOperation.TransferOperation = newOperation;
operationRepository.SaveOrUpdate(oldOperation);
operationRepository.SaveOrUpdate(newOperation);
//Создаем новую карточку
WorkerCardContent newWorkerCardContent = new WorkerCardContent();
newWorkerCardContent.WorkerCardHead = newWorkerCardHead;
newWorkerCardContent.Storage = storageTo;
newWorkerCardContent.Quantity = oldWorkerCardContent.Quantity;
newWorkerCardContent.Operation = newOperation;
newWorkerCardContent.StartDate = oldWorkerCardContent.StartDate;
newWorkerCardContent.UsePeriod = oldWorkerCardContent.UsePeriod;
newWorkerCardContent.GiveOperation = oldWorkerCardContent.GiveOperation;
//Проставляем новую норму!!!
newWorkerCardContent.NormaContent = newNormaContent;
//Обнуляем старую карточку
oldWorkerCardContent.Quantity = 0;
oldWorkerCardContent.EndDate = operDate; //DateTime.Now;
oldWorkerCardContent.OperReturn = oldOperation;
//Сохраняем новую и старую карточки
workerCardContentRepository.SaveOrUpdate(oldWorkerCardContent);
workerCardContentRepository.SaveOrUpdate(newWorkerCardContent);
}
}
skladId = oldWorkerCardContent.Storage.StorageName.Id;
}
}
}
else
{
//У человека несколько активных рабочих мест или рабочее место не найдено
resultState.Status = ResultState.ERROR;
resultState.setMessage("У человека больше одного рабочего места или рабочее место не найдено!");
}
}
return(Json(resultState));
}
private IList <NomenclatureSimple> getNomenclaturesForWorkplace(int workerWorkplaceId, bool isActive)
{
IList <NomenclatureSimple> nomenclatures = new List <NomenclatureSimple>();
IList <WorkerWorkplace> workerWorkplaces = new List <WorkerWorkplace>();
Dictionary <string, object> query = new Dictionary <string, object>();
Dictionary <string, object> order = new Dictionary <string, object>();
query.Add("Worker.Id", workerWorkplaceId);
query.Add("IsActive", isActive);
//Выбираем рабочие места
workerWorkplaces = workerWorkplaceRepository.GetByLikeCriteria(query);
//Если активное рабочее место, то сначала выбираем все, что положено по норме
if (isActive)
{
if (workerWorkplaces.Count > 0)
{
query.Clear();
query.Add("Organization", workerWorkplaces[0].Organization);
query.Add("Norma.Organization.Id", int.Parse(getCurrentEnterpriseId()));
query.Add("Norma.IsActive", true);
IList <NormaOrganization> normaOrganizations = normaOrganizationRepository.GetByCriteria(query);
if (normaOrganizations != null && normaOrganizations.Count > 0)
{
IList <NormaContent> normas = normaOrganizations[0].Norma.NormaContents;
//normas = reorderNormaContents(normas, false);
foreach (var item in normas)
{
if (item.IsActive == true)
{
if (item.InShop == false)
{
NomenclatureSimple nomenclature = new NomenclatureSimple();
nomenclature.GroupId = item.NomGroup.Id;
nomenclature.GroupName = item.NomGroup.Name;
nomenclature.NormaContentId = item.Id;
nomenclatures.Add(nomenclature);
}
}
}
}
}
}
foreach (var item in workerWorkplaces)
{
//Для всех неактивных рабочих мест
//Ищем номенклатуры, которые на руках
query.Clear();
query.Add("WorkerWorkplace", item);
WorkerCardHead workerCardHead = workerCardRepository.FindOne(query);
//Если карточка найдена
if (workerCardHead != null)
{
IList <WorkerCardContent> workerCardContents = new List <WorkerCardContent>();
query.Clear();
query.Add("WorkerCardHead", workerCardHead);
query.Add("[>]Quantity", 0);
workerCardContents = workerCardContentRepository.GetByLikeCriteria(query);
bool addNomenclature = false;
foreach (var itemContens in workerCardContents)
{
// NomenclatureSimple nomenclature = getEmptyNomenclature(nomenclatures, itemContens.NormaContent.NomGroup.Id);
NomenclatureSimple nomenclature = getEmptyNomenclature(nomenclatures, itemContens.Storage.Nomenclature.NomGroup.Id);
if (nomenclature == null)
{
nomenclature = new NomenclatureSimple();
if (itemContens.NormaContent != null)
{
nomenclature.NormaContentId = itemContens.NormaContent.Id;
}
addNomenclature = true;
}
else
{
addNomenclature = false;
}
nomenclature.setId(itemContens.Id);
nomenclature.NameId = itemContens.Storage.Nomenclature.Id;
nomenclature.Name = itemContens.Storage.NomenclatureInfo;
if (!isActive)
//{
// nomenclature.GroupId = itemContens.NormaContent.NomGroup.Id;
// nomenclature.GroupName = itemContens.NormaContent.NomGroup.Name;
//}
//else
{
nomenclature.GroupId = itemContens.Storage.Nomenclature.NomGroup.Id;
nomenclature.GroupName = itemContens.Storage.Nomenclature.NomGroup.Name;
}
nomenclature.Quantity = itemContens.Quantity;
nomenclature.OperType = itemContens.Operation.OperType.Id;
nomenclature.StartDate = itemContens.StartDate;
nomenclature.StartDateStr = itemContens.StartDate.ToString(DataGlobals.DATE_FORMAT_FULL_YEAR);
if (nomenclature.OperType == DataGlobals.OPERATION_STORAGE_TRANSFER_IN)
{
nomenclature.DocNumber = itemContens.Operation.DocNumber;
nomenclature.OperDate = itemContens.Operation.OperDate;
nomenclature.OperDateStr = itemContens.Operation.OperDate.ToString(DataGlobals.DATE_FORMAT_FULL_YEAR);
}
nomenclature.StorageNameId = itemContens.Storage.StorageName.Id;
nomenclature.StorageNumber = itemContens.Storage.StorageName.StorageNumber;
if (addNomenclature)
{
nomenclatures.Add(nomenclature);
}
}
}
}
return(nomenclatures);
}
