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);
}
}
