public static void FilldcInfTariffInfo(TrudoyomkostDBContext dbcontext, ref Dictionary<InfTariffInfo, double> dcInfTariffInfo) { var tempResult = from inftariff in dbcontext.InfTariff select inftariff; dcInfTariffInfo.Clear(); foreach (var item in tempResult) if (!dcInfTariffInfo.ContainsKey(new InfTariffInfo(item.TariffNetNum, item.KindPay, item.WorkerRate))) { dcInfTariffInfo.Add(new InfTariffInfo(item.TariffNetNum, item.KindPay, item.WorkerRate), item.HourCost); } }
public fmAuthentication(mainForm fm) { this.fm = fm; InitializeComponent(); //tbLogin.Text = "admin"; //tbPass.Text = "admin"; using (var newLocalDb = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { _usersList = LinqQueryForTrudoyomkost.FillUsersList(newLocalDb); } }
public void execute() { var result = from currLabItem in FillTrudoyomkostDB.CurrentLabourNormList join whOper in FillTrudoyomkostDB.WhereOperationUseList on currLabItem.ID equals whOper.LabourNormID select new { LabourId= currLabItem.ID, whOper.Id, whOper.InfProductsChipher, whOper.SeriaFrom, whOper.SeriaTo, } into res group res by res.LabourId into groupResult select new { Key = groupResult.Key, Value = groupResult }; using (var currentContex = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { foreach (var item in result) { if (item.Value.Count() < 2) { var tempEl= item.Value.First(); if (tempEl.SeriaFrom >= _seriaFrom && tempEl.InfProductsChipher == _productCipher) { var el= currentContex.WhereOperationUse.First(x => x.Id == tempEl.Id); var memoryEl = FillTrudoyomkostDB.WhereOperationUseList.First(x => x.Id == tempEl.Id); bool Visible = FillTrudoyomkostDB.WhereOperationUseList.Remove(memoryEl); currentContex.WhereOperationUse.DeleteOnSubmit(el); } else if(tempEl.SeriaFrom < _seriaFrom && tempEl.SeriaTo >=_seriaFrom && tempEl.InfProductsChipher ==_productCipher) { var el = currentContex.WhereOperationUse.First(x => x.Id == tempEl.Id); el.SeriaTo = _seriaFrom - 1; FillTrudoyomkostDB.WhereOperationUseList.First(x => x.Id == tempEl.Id).SeriaTo = _seriaFrom - 1; } currentContex.SubmitChanges(); } } } }
public static void FilldcInfProfession(TrudoyomkostDBContext dbcontext, ref Dictionary<string, ShortProfInfo> dcShortInfProf, ref ValidatingComboBox cbinfProf) { var tempResult = from infprofession in dbcontext.InfProfession select new { infprofession.ProfCode, infprofession.NameKindWork }; dcShortInfProf.Clear(); foreach (var item in tempResult) { string fullInfo = item.ProfCode.ToString() + " " + item.NameKindWork; dcShortInfProf.Add(fullInfo, new ShortProfInfo(item.ProfCode, item.NameKindWork)); cbinfProf.Items.Add(fullInfo); } }
public static void FilldcInfProducts(TrudoyomkostDBContext dbcontext, ref Dictionary<string, short> dicInfProduct) { var listProducts = from infproducts in dbcontext.InfProducts where infproducts.Mask == 1 //выбор изделий select new { infproducts.Product, infproducts.Cipher }; dicInfProduct.Clear(); foreach (var item in listProducts) { dicInfProduct.Add(item.Product, item.Cipher); } }
private void InitializeFormElement() { this.Location = new Point(_parentForm.Location.X, _parentForm.Location.Y); vtbOperNum.ValidateValue = VtboxMethods.checkForNonEmpty; vtbTaskNum.ValidateValue = VtboxMethods.checkForNonEmpty; vtbWorkRate.ValidateValue = VtboxMethods.checkWorkRate; vtbWorkRate.StringAutoCorrectionMethod = VtboxMethods.correctForDouble; vtbItemCTN.ValidateValue = VtboxMethods.checkForDouble; vtbItemCTN.StringAutoCorrectionMethod = VtboxMethods.correctForDouble; vtbPreparTimeCTN.ValidateValue = VtboxMethods.checkForDouble; vtbPreparTimeCTN.StringAutoCorrectionMethod = VtboxMethods.correctForDouble; vtbCoeffCTN.ValidateValue = VtboxMethods.checkForDouble; vtbCoeffCTN.StringAutoCorrectionMethod = VtboxMethods.correctForDouble; vtbItemPayNorm.ValidateValue = VtboxMethods.checkForDouble; vtbItemPayNorm.StringAutoCorrectionMethod = VtboxMethods.correctForDouble; vtbPreparTimePayNorm.ValidateValue = VtboxMethods.checkForDouble; vtbPreparTimePayNorm.StringAutoCorrectionMethod = VtboxMethods.correctForDouble; vtbLoverCoeff.ValidateValue = VtboxMethods.checkForDouble; vtbLoverCoeff.StringAutoCorrectionMethod = VtboxMethods.correctForDouble; vtbDepRegion.ValidateValue = VtboxMethods.checkForDouble; vtbPreparTimePayNorm.StringAutoCorrectionMethod = VtboxMethods.correctForDouble; vtbSeriaFrom.StringAutoCorrectionMethod = VtboxMethods.correctForInt; vtbSeriaFrom.ValidateValue = VtboxMethods.CheckSeria; vtbSeriaTo.StringAutoCorrectionMethod = VtboxMethods.correctForInt; vtbSeriaTo.ValidateValue = VtboxMethods.CheckSeria; vtbProdName.ValidateValue = VtboxMethods.CheckProdNume; vtbProdName.StringAutoCorrectionMethod = VtboxMethods.correctForInt; using (var newLocalDb = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { LinqQueryForTrudoyomkost.FilldcInfProfession(newLocalDb, ref _dcShortInfProf, ref vcbProfCode); LinqQueryForTrudoyomkost.FilldcInfTariffInfo(newLocalDb, ref _dcInfTariffInfo); } vcbProfCode.AutoCompleteMode = AutoCompleteMode.SuggestAppend; vcbProfCode.AutoCompleteSource = AutoCompleteSource.ListItems; _autoComSourceForDocNum = LinqQueryForTrudoyomkost.FillDocNumlst(); foreach (var item in _autoComSourceForDocNum) { cbDocNum.Items.Add(item); } cbDocNum.AutoCompleteMode = AutoCompleteMode.SuggestAppend; cbDocNum.AutoCompleteSource = AutoCompleteSource.ListItems; cbDocNum.AutoCompleteCustomSource = _autoComSourceForDocNum; dgOperApply.Columns[1].Width = 120; dgOperApply.Columns[2].Width = 120; vtbSeriaTo.ValueTxt = " "; vtbLoverCoeff.ValueTxt = "1"; vtbCoeffCTN.ValueTxt = "0"; if (TrudoyomkostSettings.IsAggregateDep) { vtbTaskNum.Enabled = true; } }
private void btUpdateForm_Click(object sender, EventArgs e) { CheckValidateForm(gbOperItems); if (!IsValidForm) { MessageBox.Show(_isValidateGbNotific); IsValidForm = true; } else { using (var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { btUpdateForm.Enabled = false; UpdateLabourNorm(ref templabour, _timeInHour); LabourNorm item2 = FillTrudoyomkostDB.LabourNormList.Find(itemEl => itemEl.ID == templabour.ID); if (FillTrudoyomkostDB.LabourNormList.Contains(item2)) { FillTrudoyomkostDB.LabourNormList.Remove(item2); FillTrudoyomkostDB.LabourNormList.Add(templabour.Copy()); FillTrudoyomkostDB.LabourNormTableAdapter.UpdateQuery(templabour.OperNum, templabour.DepRegion, templabour.ProfCode, templabour.NameKindWork, templabour.TariffNetNum, templabour.KindPay, templabour.WorkerRate, templabour.ItemCTN, templabour.PreparTimeCTN, templabour.ItemPayNorm, templabour.PreparTimePayNorm, templabour.Valuation, templabour.ValPreparTime, templabour.CoeffCTN, templabour.DocNum, templabour.Date, templabour.TaskNumber, templabour.ID); } _parentForm.UpdateDataGrids(); btUpdateForm.Enabled = true; } } }
public static void FilldtInfProf(TrudoyomkostDBContext dbcontext, ref TrudoyomkostDBDataSet.infProfessionDataTable dtInfProff) { var tempResult = from infproff in dbcontext.InfProfession select infproff; dtInfProff.Clear(); foreach (var item in tempResult) { DataRow rowdttemp = dtInfProff.NewRow(); rowdttemp[0] = item.ProfCode; rowdttemp[1] = item.Name; rowdttemp[2] = item.NameKindWork; rowdttemp[3] = item.LangCode; dtInfProff.Rows.Add(rowdttemp); } }
public static void FillInfProductsList(TrudoyomkostDBContext dbcontext, ref List<InfProducts> inputList) { var tempResult = from infproducts in dbcontext.InfProducts where infproducts.Mask == 1 select infproducts; inputList.Clear(); inputList = tempResult.ToList(); }
private void tabProducts_Enter(object sender, EventArgs e) { using (var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { dgProducts.DataSource = LinqQueryForTrudoyomkost.GetAllProducts(currentContext); dgProducts.Columns[0].ReadOnly = true; } }
private void dgProducts_RowValidated(object sender, DataGridViewCellEventArgs e) { short cipher = 0; DataGridView tempDg; tempDg = sender as DataGridView; if (tempDg != null) cipher = (short)tempDg.Rows[e.RowIndex].Cells[0].Value; //tempDg.Rows[e.RowIndex]. using (var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { var selectEntity = currentContext.InfProducts.Where(item => item.Cipher == cipher).First(); selectEntity.Product = tempDg.Rows[e.RowIndex].Cells[1].Value.ToString(); selectEntity.Mask = (byte)tempDg.Rows[e.RowIndex].Cells[3].Value; selectEntity.ProductTotal = tempDg.Rows[e.RowIndex].Cells[2].Value.ToString(); currentContext.SubmitChanges(); } }
private void btProfAdd_Click_1(object sender, EventArgs e) { foreach (DataRow row in _dtInfProf.Rows) { if ((int)row[0] == int.Parse(vtbProfCode.ValueTxt)) return; } if (checkValidateProfRow(gpEditProff)) { using (var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { FillTrudoyomkostDB.InfProfessionTableAdapter.InsertQuery(int.Parse(vtbProfCode.ValueTxt), tbProfName.Text, tbProfKindWork.Text, 1049); LinqQueryForTrudoyomkost.FilldtInfProf(currentContext, ref _dtInfProf); } errorProv.SetError(gpEditProff, String.Empty); } else { errorProv.SetError(gpEditProff, "Заполните поля"); } }
public static DataTable GetAllProducts(TrudoyomkostDBContext dbcontext) { var result = from infProduct in dbcontext.InfProducts select infProduct; return DataTableFromIEnumerable(result); }
public static List<WhereUse> FillWhereUselst(TrudoyomkostDBContext dbcontext) { var tempresult = from whereuselst in dbcontext.WhereUse select whereuselst; List<WhereUse> whereUseLst = tempresult.ToList(); return whereUseLst; }
public static void FillWhereOperationUseList(TrudoyomkostDBContext dbcontext, ref BigList<WhereOperationUse> inputList) { var tempresult = from labourlist in dbcontext.WhereOperationUse select labourlist; inputList.Clear(); foreach (var item in tempresult) { inputList.Add(item); } }
public static List<Users> FillUsersList(TrudoyomkostDBContext dbcontext) { try { var tempResult = from userList in dbcontext.Users select userList; var usersList = tempResult.ToList(); return usersList; } catch (SqlCeException e) { var usersList = new List<Users>(); return usersList; } }
public static void FillLabourNormList(TrudoyomkostDBContext dbcontext, ref BigList<LabourNorm> inputList) { var tempresult = from labourlist in dbcontext.LabourNorm select labourlist; inputList.Clear(); //IList temp = tempresult.ToList(); foreach (var item in tempresult) { inputList.Add(item); } }
public void AddDoubleItems() { this.Enabled = false; var labourNormlist = LinqQueryForTrudoyomkost.FillLabournNormForDet(_destinationDetID); foreach (var item in labourNormlist) { var whereOperUselstdel = LinqQueryForTrudoyomkost.FillWhereOperationUseList(item.ID); if (whereOperUselstdel.Count() > 0) { foreach (var applydel in whereOperUselstdel) { FillTrudoyomkostDB.WhereOperationUseList.Remove(applydel); } } FillTrudoyomkostDB.LabourNormTableAdapter.DeleteQuery(item.ID); FillTrudoyomkostDB.WhereOperationUseTableAdapter.DeleteQuery(item.ID); FillTrudoyomkostDB.LabourNormList.Remove(item); } labourNormlist = LinqQueryForTrudoyomkost.FillLabournNormForDet(_sourceDetID); using (var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { int Id = 0; int whereOperUseId = FillTrudoyomkostDB.WhereOperationUseList.Last().Id; Id = currentContext.LabourNorm.ToList().Max().ID; foreach (var item in labourNormlist) { var whereOperUselst = LinqQueryForTrudoyomkost.FillWhereOperationUseList(item.ID); if (whereOperUselst.Count() > 0) { Id++; //FillTrudoyomkostDB.LabourNormTableAdapter.InsertQuery(_destinationDetID, item.OperNum, item.DepRegion, item.ProfCode, item.NameKindWork, // item.TariffNetNum, item.KindPay, item.WorkerRate, item.ItemCTN, item.PreparTimeCTN, //item.ItemPayNorm, item.PreparTimePayNorm, item.Valuation, item.ValPreparTime, item.CoeffCTN, item.DocNum, item.Date, item.TaskNumber); FillTrudoyomkostDB.FilltmpLabourNormRow(new LabourNorm(Id, _destinationDetID, item.OperNum, item.DepRegion, item.ProfCode, item.NameKindWork, item.TariffNetNum, item.KindPay, item.WorkerRate, item.ItemCTN, item.PreparTimeCTN, item.ItemPayNorm, item.PreparTimePayNorm, item.Valuation, item.ValPreparTime, item.CoeffCTN, item.DocNum, DateTime.Now, item.TaskNumber)); FillTrudoyomkostDB.LabourNormList.Add(new LabourNorm(Id, _destinationDetID, item.OperNum, item.DepRegion, item.ProfCode, item.NameKindWork, item.TariffNetNum, item.KindPay, item.WorkerRate, item.ItemCTN, item.PreparTimeCTN, item.ItemPayNorm, item.PreparTimePayNorm, item.Valuation, item.ValPreparTime, item.CoeffCTN, item.DocNum, DateTime.Now, item.TaskNumber)); //currentContext.LabourNorm.InsertOnSubmit(new LabourNorm(Id, _destinationDetID, item.OperNum, item.DepRegion, item.ProfCode, // item.NameKindWork, item.TariffNetNum, item.KindPay, item.WorkerRate, item.ItemCTN, item.PreparTimeCTN, item.ItemPayNorm, item.PreparTimePayNorm, // item.Valuation, item.ValPreparTime, item.CoeffCTN, item.DocNum, DateTime.Now, item.TaskNumber)); foreach (var applyItem in whereOperUselst) { whereOperUseId++; FillTrudoyomkostDB.FilltmpWhereOperUseRow(new WhereOperationUse(Id, applyItem.SeriaFrom, applyItem.SeriaTo, applyItem.InfProductsChipher)); FillTrudoyomkostDB.WhereOperationUseList.Add(new WhereOperationUse(Id, applyItem.SeriaFrom, applyItem.SeriaTo, applyItem.InfProductsChipher, whereOperUseId)); //currentContext.WhereOperationUse.InsertOnSubmit(new WhereOperationUse(Id, applyItem.SeriaFrom, applyItem.SeriaTo, applyItem.InfProductsChipher,whereOperUseId)); //FillTrudoyomkostDB.WhereOperationUseTableAdapter.InsertQuery(Id, applyItem.SeriaFrom, applyItem.SeriaTo, applyItem.InfProductsChipher); } } //currentContext.SubmitChanges(); } DataTable tmpWhereOperUse = FillTrudoyomkostDB.WhereOperationUseDataTable; DataTable tmpLabourNorm = FillTrudoyomkostDB.LabourNormDataTable; SqlCeBulkCopy bulkInsert = new SqlCeBulkCopy(Properties.Settings.Default.TrudoyomkostDBConnectionString); if (tmpWhereOperUse.Rows.Count > 0) { bulkInsert.DestinationTableName = "whereOperationUse"; bulkInsert.WriteToServer(tmpWhereOperUse); } if (tmpLabourNorm.Rows.Count > 0) { bulkInsert.DestinationTableName = "LabourNorm"; bulkInsert.WriteToServer(tmpLabourNorm); } FillTrudoyomkostDB.LabourNormDataTable.Clear(); FillTrudoyomkostDB.WhereOperationUseDataTable.Clear(); bulkInsert.Close(); } this.Enabled = true; }
private void btDelProf_Click(object sender, EventArgs e) { if ( MessageBox.Show("Вы уверены, что хотите удалить запись?", "", MessageBoxButtons.YesNo) == DialogResult.Yes) { FillTrudoyomkostDB.InfProfessionTableAdapter.DeleteRow(_currentProfCode); using ( var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { LinqQueryForTrudoyomkost.FilldtInfProf(currentContext, ref _dtInfProf); } } }
public static void GetInfTariff(ref List<InfTariff> inputlist) { using (var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { inputlist = currentContext.InfTariff.ToList(); } }
private void button1_Click(object sender, EventArgs e) { using (var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { foreach (var item in currentContext.LabourNorm) { if (item.ItemCTN == 0 && item.PreparTimeCTN == 0 && item.ItemPayNorm == 0 && item.PreparTimePayNorm == 0) { currentContext.LabourNorm.DeleteOnSubmit(item); } if (item.KindPay == "C") item.KindPay = "C"; currentContext.SubmitChanges(); } } }
public static void GetInfTariffList(TrudoyomkostDBContext dbcontext, ref List<byte> inputTariffList) { var result = from tariff in dbcontext.InfTariff select tariff.TariffNetNum; inputTariffList = result.Distinct().ToList(); }
private void FillFormData() { using (var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { LinqQueryForTrudoyomkost.FillInfProductsList(currentContext, ref FillTrudoyomkostDB.infProductList); LinqQueryForTrudoyomkost.FillLabourNormList(currentContext, ref FillTrudoyomkostDB.LabourNormList); LinqQueryForTrudoyomkost.FillWhereOperationUseList(currentContext, ref FillTrudoyomkostDB.WhereOperationUseList); _whereUseList = LinqQueryForTrudoyomkost.FillWhereUselst(currentContext); _depList = LinqQueryForTrudoyomkost.FillinfDeplst(currentContext); _infDetList = LinqQueryForTrudoyomkost.FillinfDetList(currentContext); FillTrudoyomkostDB.whereUseList = _whereUseList; FillTrudoyomkostDB.infDetList = _infDetList; LinqQueryForTrudoyomkost.FilldcInfProducts(currentContext, ref FillTrudoyomkostDB.DcInfProducts); _infProductsDc = FillTrudoyomkostDB.DcInfProducts; LinqQueryForTrudoyomkost.FilldcDetNumForProduct(ref dcIDDetNum, _infProductsDc.Values.First()); LinqQueryForTrudoyomkost.FilldtInfProf(currentContext, ref _dtInfProf); LinqQueryForTrudoyomkost.GetInfTariffList(currentContext, ref FillTrudoyomkostDB.tariffList); LinqQueryForTrudoyomkost.FillDictDepIDCode(currentContext, ref FillTrudoyomkostDB.DicDepCodeAndId); _detNumList.Clear(); foreach (var item in dcIDDetNum) { _detNumList.Add(item.Key); } }// }
public void execute() { using (var currentContex = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { FillTrudoyomkostDB.WhereOperationUseList.Add(_whereOperUse); currentContex.WhereOperationUse.InsertOnSubmit(_whereOperUse); currentContex.SubmitChanges(); } }
public static void InsertFromANTables(DataSet tableList) { using (var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { LinqQueryForTrudoyomkost.FilldcInfProducts(currentContext, ref DcInfProducts); LinqQueryForTrudoyomkost.FillDictDetNumID(currentContext, ref DicDetNumAndId); LinqQueryForTrudoyomkost.FillDictDepIDCode(currentContext, ref DicDepCodeAndId); Properties.Settings.Default.DetID = currentContext.InfDet.ToList().Count == 0 ? 0 : ++currentContext.InfDet.ToList().Last().ID; } if (int.Parse((tableList.Tables[0].Rows[0].Field<string>("CEH").Trim())) != Properties.Settings.Default.DepNum) return; _whereUseTableAdapter.DeleteAllQuery(); foreach (DataTable itemTable in tableList.Tables) { foreach (DataRow itemRow in itemTable.Rows) { string NDET = (string)itemRow["NDET"]; if (!DicDetNumAndId.ContainsKey(NDET)) { var infDetItem = FillItemInfDet(itemRow); FilltmpInfDetRow(ref infDetItem); DicDetNumAndId.Add(NDET, Properties.Settings.Default.DetID); Properties.Settings.Default.DetID++; } var itemWhereuse = FillItemWhereUse(itemRow); FilltmpWhereUseRow(itemWhereuse); } } Properties.Settings.Default.Save(); SqlCeBulkCopy bulkInsert = new SqlCeBulkCopy(connString); DataTable tmptbInfDet = InfDetDataTable; DataTable tmptbWhereUse = WhereUseDataTable; if (tmptbInfDet.Rows.Count > 0) { bulkInsert.DestinationTableName = "infDet"; bulkInsert.WriteToServer(tmptbInfDet); } if (tmptbWhereUse.Rows.Count > 0) { bulkInsert.DestinationTableName = "whereUse"; bulkInsert.WriteToServer(tmptbWhereUse); } WhereUseDataTable.Clear(); InfDetDataTable.Clear(); bulkInsert.Close(); }
public static List<InfDet> FillinfDetList(TrudoyomkostDBContext dbcontext) { var tempresult = from detlist in dbcontext.InfDet select detlist; List<InfDet> infDetlist = tempresult.ToList(); return infDetlist; }
private void btnSaveForm_Click(object sender, EventArgs e) { CheckValidateForm(gbOperItems); if (!IsValidForm) { MessageBox.Show(_isValidateGbNotific); IsValidForm = true; } else { using (var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { btSaveFrom.Enabled = false; int Id = currentContext.LabourNorm.ToList().Max().ID; Id++; templabour.ID = Id; UpdateLabourNorm(ref templabour, _timeInHour); InitializeGbOperItem(); FillTrudoyomkostDB.LabourNormList.Add(templabour); FillTrudoyomkostDB.LabourNormTableAdapter.InsertQuery(templabour.InfDetID, templabour.OperNum, templabour.DepRegion, templabour.ProfCode, templabour.NameKindWork, templabour.TariffNetNum, templabour.KindPay, templabour.WorkerRate, templabour.ItemCTN, templabour.PreparTimeCTN, templabour.ItemPayNorm, templabour.PreparTimePayNorm, templabour.Valuation, templabour.ValPreparTime, templabour.CoeffCTN, templabour.DocNum, templabour.Date, templabour.TaskNumber); int WhereUseId = currentContext.WhereOperationUse.ToList().Last().Id; foreach (DataRow row in _dtOperApply.Rows) { WhereUseId++; int seriaFrom = MathFunctionForSeries.GetIntSeriaNumber(row[1].ToString()); int seriaTo = MathFunctionForSeries.GetIntSeriaNumber(row[2].ToString()); short prodChipher = _dcInfProducts[row[0].ToString()]; WhereOperationUse _whereOperUseitem = new WhereOperationUse(templabour.ID, seriaFrom, seriaTo, prodChipher, WhereUseId); FillTrudoyomkostDB.WhereOperationUseList.Add(_whereOperUseitem); FillTrudoyomkostDB.WhereOperationUseTableAdapter.InsertQuery(templabour.ID, seriaFrom, seriaTo, prodChipher); } _parentForm.UpdateDataGrids(); ClearForm(); btSaveFrom.Enabled = true; } } }
private void btSaveAndLimit_Click(object sender, EventArgs e) { CheckValidateForm(gbOperItems); if (!IsValidForm) { MessageBox.Show(_isValidateGbNotific); IsValidForm = true; return; } using (var currentContext = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { foreach (var item in _oldAndNewApplyDict) { WhereOperationUse tempItem = new WhereOperationUse(); tempItem = FillTrudoyomkostDB.WhereOperationUseList.ToList().Find(currItem => (currItem.SeriaFrom == item.Key.SeriaFrom && currItem.SeriaTo == item.Key.SeriaTo && currItem.InfProductsChipher == item.Key.ProductChipher && currItem.LabourNormID == templabour.ID)); tempItem.SeriaTo = item.Value.SeriaFrom - 1; FillTrudoyomkostDB.WhereOperationUseTableAdapter.UpdateSeriaTo(tempItem.SeriaTo, item.Key.ProductChipher, item.Key.SeriaFrom, templabour.ID); FillTrudoyomkostDB.WhereOperationUseList.Add(item.Value); currentContext.WhereOperationUse.InsertOnSubmit(item.Value); currentContext.SubmitChanges(); } templabour.ID = _newID; btSaveAndLimit.Enabled = false; UpdateLabourNorm(ref templabour, _timeInHour); FillTrudoyomkostDB.LabourNormTableAdapter.InsertQuery(templabour.InfDetID, templabour.OperNum, templabour.DepRegion, templabour.ProfCode, templabour.NameKindWork, templabour.TariffNetNum, templabour.KindPay, templabour.WorkerRate, templabour.ItemCTN, templabour.PreparTimeCTN, templabour.ItemPayNorm, templabour.PreparTimePayNorm, templabour.Valuation, templabour.ValPreparTime, templabour.CoeffCTN, templabour.DocNum, templabour.Date, templabour.TaskNumber); FillTrudoyomkostDB.LabourNormList.Add(templabour); templabour = new LabourNorm(); } _parentForm.UpdateDataGrids(); _newID++; btSaveAndLimit.Enabled = true; }
public static void InsertFromTNTables() { InfDetDataTable.Clear(); using (var newLocalDb = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { LinqQueryForTrudoyomkost.FillDictDetNumID(newLocalDb, ref DicDetNumAndId); LinqQueryForTrudoyomkost.FillDictDepIDCode(newLocalDb, ref DicDepCodeAndId); LinqQueryForTrudoyomkost.FillDictInfProfession(newLocalDb, ref DictInfProfession); } int whereOperUseId = 1; foreach (var item in Tn148DataTable) { if (DicDetNumAndId.ContainsKey(item.NDET)) { LabourNorm itemlabourNorm = FillItemLabourNorm(item); itemlabourNorm.ID = whereOperUseId; FilltmpLabourNormRow(itemlabourNorm); WhereOperationUse itemWhereOperUse = FillItemWhereOperationUse(item); itemWhereOperUse.LabourNormID = whereOperUseId; FilltmpWhereOperUseRow(itemWhereOperUse); ListAllLabourNorm.Add(item.NDET); whereOperUseId++; } } using (var newLocalDb = new TrudoyomkostDBContext(Properties.Settings.Default.TrudoyomkostDBConnectionString)) { LinqQueryForTrudoyomkost.FillDictDetNumID(newLocalDb, ref DicDetNumAndId); } DicCheckRepeatTN.Clear(); foreach (var item in Tn158DataTable) { if (DicDetNumAndId.ContainsKey(item.NDET)) { LabourNorm itemlabourNorm = FillItemLabourNorm(item); itemlabourNorm.ID = whereOperUseId; FilltmpLabourNormRow(itemlabourNorm); WhereOperationUse itemWhereOperUse = FillItemWhereOperationUse(item); itemWhereOperUse.LabourNormID = whereOperUseId; FilltmpWhereOperUseRow(itemWhereOperUse); ListAllLabourNorm.Add(item.NDET); whereOperUseId++; } } Properties.Settings.Default.Save(); SqlCeBulkCopy bulkInsert = new SqlCeBulkCopy(connString); DataTable tmptbLabourNorm = LabourNormDataTable; DataTable tmpWhereOperUse = WhereOperationUseDataTable; if (tmptbLabourNorm.Rows.Count > 0) { bulkInsert.DestinationTableName = "LabourNorm"; bulkInsert.WriteToServer(tmptbLabourNorm); } if (tmpWhereOperUse.Rows.Count > 0) { bulkInsert.DestinationTableName = "whereOperationUse"; bulkInsert.WriteToServer(tmpWhereOperUse); } LabourNormDataTable.Clear(); WhereOperationUseDataTable.Clear(); bulkInsert.Close(); }
public static void FillDictInfProfession(TrudoyomkostDBContext dbcontext, ref Dictionary<string, int> dictInfProfession) { var detnumInDB = from infdet in dbcontext.InfProfession select new { infdet.ProfCode, infdet.NameKindWork }; dictInfProfession.Clear(); foreach (var item in detnumInDB) { dictInfProfession.Add(item.NameKindWork, item.ProfCode); } }