private List <string> GetFileArray() { CMO_Order cMO_Order = db.CMO_Order.Find(idOrder); var fileList = Directory.GetFiles(cMO_Order.folder).ToList(); return(fileList); }
private void UpdateOrderBeforeFirtst() { CMO_Order cMO_Order = db.CMO_Order.Find(idOrder); cMO_Order.firstTenderStart = true; db.Entry(cMO_Order).State = EntityState.Modified; db.SaveChanges(); }
private void CloseFirstTenderInOrder() { CMO_Order cMO_Order = db.CMO_Order.Find(idOrder); cMO_Order.datetimeFirstTenderFinish = DateTime.Now; db.Entry(cMO_Order).State = EntityState.Modified; db.SaveChanges(); }
private void CloseWinnerTenderInOrder() { double minData = db.CMO_UploadResult.Where(d => d.CMO_Tender.id_CMO_Order == idOrder & d.CMO_Tender.id_CMO_TypeTask == 2 & d.cost > 0).Min(d => d.cost); CMO_UploadResult getCMOUploadLead = db.CMO_UploadResult.Where(d => d.CMO_Tender.id_CMO_Order == idOrder & d.CMO_Tender.id_CMO_TypeTask == 2 & d.cost > 0 & d.cost == minData).First(); CMO_Order cMO_Order = db.CMO_Order.Find(idOrder); cMO_Order.datetimeWinTenderFinish = DateTime.Now; cMO_Order.companyWin = getCMOUploadLead.id_CMO_Company; db.Entry(cMO_Order).State = EntityState.Modified; db.SaveChanges(); }
private void CreateOrder(bool bit, int winCompanyId) { CMO_Order cMO_Order = new CMO_Order(); cMO_Order.companyWin = winCompanyId; cMO_Order.dateCloseOrder = DateTime.Now; cMO_Order.idTime = 1; cMO_Order.dateCreate = DateTime.Now; cMO_Order.userCreate = this.loginIdCreate; cMO_Order.firstTenderStart = true; db.CMO_Order.Add(cMO_Order); db.SaveChanges(); this.idOrder = cMO_Order.id; }
private void CreateOrder() { CMO_Order cMO_Order = new CMO_Order(); try { cMO_Order.idTime = 1; cMO_Order.dateCreate = DateTime.Now; cMO_Order.userCreate = this.loginIdCreate; db.CMO_Order.Add(cMO_Order); db.SaveChanges(); logger.Debug(goodDB + "private void CreateOrder()" + loginIdCreate.ToString()); } catch (Exception ex) { logger.Error(badDB + "private void CreateOrder()" + loginIdCreate.ToString() + ex.Message.ToString()); } this.idOrder = cMO_Order.id; }
private void CreateFolderAndFileForOrder() { string directory = "\\\\192.168.1.30\\m$\\_ЗАКАЗЫ\\OrderCMO\\" + idOrder.ToString() + "\\"; try { Directory.CreateDirectory(directory); logger.Debug("успешно создана папка с заявкой железа " + "CreateFolderAndFileForOrder() - 1.Directory.CreateDirectory " + loginIdCreate.ToString()); } catch (Exception ex) { logger.Error("ошибка! создания папки с заявкой железа " + "CreateFolderAndFileForOrder() - 1.Directory.CreateDirectory " + loginIdCreate.ToString() + ex.Message.ToString()); } try { SaveFileToServer(directory); logger.Debug("успешно загружен файл в папку " + "CreateFolderAndFileForOrder() - 1.1.Directory.CreateDirectory " + loginIdCreate.ToString()); } catch (Exception ex) { logger.Error("ошибка! загружен файл в папку " + "CreateFolderAndFileForOrder() - 1.1.Directory.CreateDirectory " + loginIdCreate.ToString() + ex.Message.ToString()); } CreateCMO_FileOrder(); try { CMO_Order cMO_Order = db.CMO_Order.Find(idOrder); cMO_Order.folder = directory; db.Entry(cMO_Order).State = EntityState.Modified; db.SaveChanges(); logger.Debug("успешно создана папка с заявкой железа " + "CreateFolderAndFileForOrder() - 3.db.SaveChanges() " + loginIdCreate.ToString()); } catch (Exception ex) { logger.Error("ошибка! создания папки с заявкой железа " + "CreateFolderAndFileForOrder() - 3.db.SaveChanges() " + loginIdCreate.ToString() + ex.Message.ToString()); } }
public void GetData() { SaveFileToServer(@"\\192.168.1.30\m$\_ЗАКАЗЫ\OrderCMO\"); //re/FacK int row = 9; int colCost = 4; Excel.Worksheet sheet = null; foreach (Excel.Worksheet data in Workbook.Worksheets) { sheet = data; break; } Excel.Range range = sheet.UsedRange; List <TenderOffer> offerList = new List <TenderOffer>(); int countPosition = 0; while (row < 1000) { TenderOffer offer = new TenderOffer(); offer.Id_CMO_Order = Convert.ToInt32(((Excel.Range)range.Cells[row, 1]).Text); offer.Id_CMO_Company = 1; offer.Cost = Convert.ToInt32(((Excel.Range)range.Cells[row, colCost]).Text); offer.Duration = Convert.ToInt32(((Excel.Range)range.Cells[row, colCost + 1]).Text); offerList.Add(offer); offer = new TenderOffer(); offer.Id_CMO_Order = Convert.ToInt32(((Excel.Range)range.Cells[row, 1]).Text); offer.Id_CMO_Company = 2; offer.Cost = Convert.ToInt32(((Excel.Range)range.Cells[row, colCost + 2]).Text); offer.Duration = Convert.ToInt32(((Excel.Range)range.Cells[row, colCost + 3]).Text); offerList.Add(offer); offer = new TenderOffer(); offer.Id_CMO_Order = Convert.ToInt32(((Excel.Range)range.Cells[row, 1]).Text); offer.Id_CMO_Company = 3; offer.Cost = Convert.ToInt32(((Excel.Range)range.Cells[row, colCost + 4]).Text); offer.Duration = Convert.ToInt32(((Excel.Range)range.Cells[row, colCost + 5]).Text); offerList.Add(offer); row++; if (((Excel.Range)range.Cells[row, 1]).Text == "") { break; } } int orderId = 0; int tenderId = 0; foreach (var VARIABLE in offerList) { if (orderId != VARIABLE.Id_CMO_Order) { CMO_Tender tender = new CMO_Tender(); tender.id_CMO_Order = VARIABLE.Id_CMO_Order; tender.id_CMO_TypeTask = 1; tender.finishPlanClose = DateTime.Now; tender.close = true; tender.closeDateTime = DateTime.Now; db.CMO_Tender.Add(tender); db.SaveChanges(); tenderId = tender.id; orderId = tender.id_CMO_Order; CMO_Order order = db.CMO_Order.Find(orderId); order.firstTenderStart = true; db.Entry(order).State = EntityState.Modified; db.SaveChanges(); countPosition++; } CMO_UploadResult result = new CMO_UploadResult(); result.id_CMO_Tender = tenderId; result.dateTimeUpload = DateTime.Now; result.cost = VARIABLE.Cost; result.dateComplited = DateTime.Now; result.id_CMO_Company = VARIABLE.Id_CMO_Company; result.day = VARIABLE.Duration; db.CMO_UploadResult.Add(result); db.SaveChanges(); } row += 4; offerList = new List <TenderOffer>(); for (int i = 0; i < countPosition; i++) { TenderOffer offer = new TenderOffer(); offer.Id_CMO_Order = Convert.ToInt32(((Excel.Range)range.Cells[row, 1]).Text); offer.Id_CMO_Company = GetIdCompany(((Excel.Range)range.Cells[row, 4]).Text); offer.Cost = Convert.ToInt32(((Excel.Range)range.Cells[row, 6]).Text); offer.Duration = Convert.ToInt32(((Excel.Range)range.Cells[row, 8]).Text); offerList.Add(offer); row++; } foreach (var VARIABLE in offerList) { CMO_Tender tender = new CMO_Tender(); tender.id_CMO_Order = VARIABLE.Id_CMO_Order; tender.id_CMO_TypeTask = 3; tender.finishPlanClose = DateTime.Now; tender.close = true; tender.closeDateTime = DateTime.Now; db.CMO_Tender.Add(tender); db.SaveChanges(); CMO_UploadResult result = new CMO_UploadResult(); result.id_CMO_Tender = tender.id; result.dateTimeUpload = DateTime.Now; result.cost = VARIABLE.Cost; result.dateComplited = DateTime.Now; result.id_CMO_Company = VARIABLE.Id_CMO_Company; result.day = VARIABLE.Duration; db.CMO_UploadResult.Add(result); db.SaveChanges(); CMO_Order order = db.CMO_Order.Find(tender.id_CMO_Order); order.companyWin = result.id_CMO_Company; db.Entry(order).State = EntityState.Modified; db.SaveChanges(); } CloseWorkbook(); }