private void editdialog(bool state) { var lookup = context.GetLookup(Lookup.Id); if ((this.CurrentRowIndex == -1) && state) { return; } List <FieldValuePair> current = new List <FieldValuePair>(); for (var i = 0; i < this.Fields[this.CurrentRowIndex + 1].Count; i++) { if (state) { current.Add(new FieldValuePair { Name = Fields[0][i], Value = Fields[this.CurrentRowIndex + 1][i], Length = lookup.Fields[i].Length, ReadOnly = (lookup.Fields[i].NameEng == "Id") ? false : true }); } else { current.Add(new FieldValuePair { Name = Fields[0][i], Value = "", Length = lookup.Fields[i].Length, ReadOnly = (lookup.Fields[i].NameEng == "Id") ? false : true }); } } LookupsEdidViewModels vm = new LookupsEdidViewModels(current); EditInsertLookups ds = new EditInsertLookups(vm); ds.ShowDialog(); if (ds.DialogResult.HasValue && ds.DialogResult.Value) { if (state) { //update context.UpdateRow(ds.GetNewFields(), lookup); } else { //nov red context.SaveRow(ds.GetNewFields(), lookup); } CalculateFields(); OnPropertyChanged("Fields"); OnPropertyChanged("Lookup"); } }
private void ButtonBase_OnClick(object sender, RoutedEventArgs e) { var Context = new TempoDataBaseContext(); var sen = (sender as Button); if (sen != null) { var cp = sen.CommandParameter as SaldoItem; if (cp != null && (cp.Relookup != 0 || cp.RCODELOOKUP != 0)) { List <FieldValuePair> current = new List <FieldValuePair>(); LookupModel lookup = null; if (cp.Relookup > 0) { lookup = cp.SysLookup ? Context.GetSysLookup(cp.Relookup) : Context.GetLookup(cp.Relookup); } else { lookup = cp.SysLookup ? Context.GetSysLookup(cp.Relookup) : Context.GetLookup(cp.Relookup); } int i = 0; foreach (var item in lookup.Fields) { if (cp.SysLookup && i == 0) { i++; continue; } current.Add(new FieldValuePair { Name = item.Name, Value = "", Length = item.Length, ReadOnly = (item.NameEng == "Id") ? false : true, IsRequared = item.IsRequared, IsUnique = item.IsUnique, RTABLENAME = item.RTABLENAME, FieldName = item.NameEng }); } LookupsEdidViewModels vmm = new LookupsEdidViewModels(current, lookup.LookUpMetaData.Tablename, true); EditInsertLookups ds = new EditInsertLookups(vmm); ds.ShowDialog(); if (ds.DialogResult.HasValue && ds.DialogResult.Value) { //nov red lookup.Fields.Add(new TableField { DbField = "integer", GROUP = 4, Id = 4, Length = 4, IsRequared = false, NameEng = "FIRMAID", Name = "Фирма Номер" }); if (!Context.SaveRow(ds.GetNewFields(), lookup, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id)) { MessageBoxWrapper.Show("Получвава се дублиране на елемент от номенклатура! Номенклатурата не е записана!"); } else { var dc = DataContext as SaldoItem; var dat = ds.GetNewFields(); if (dat != null) { if (dc != null) { dc.Value = dat[1]; dc.Lookupval = dat[2]; } } if (dat != null && dat.Count > 5) { if (dc != null) { dc.Bulstad = dat[3]; dc.Vat = dat[4]; } } OnRefreshExecuted(new FastLookupEventArgs(dc)); } } //cp.LookUp.Add(new SaldoItem { Value = ds.GetNewFields()[2], Key = ds.GetNewFields()[1] }); } } }
private void Calculate() { var Context = new TempoDataBaseContext(); var cp = this.DataContext as SaldoItem; if (cp != null && (cp.Relookup != 0 || cp.RCODELOOKUP != 0)) { string search = Entrence.ConfigFirmaToLookup.GetField(ConfigTempoSinglenton.GetInstance().CurrentFirma.Id, cp.Relookup); List <FieldValuePair> current = new List <FieldValuePair>(); LookupModel lookup = null; if (cp.Relookup > 0) { lookup = cp.SysLookup ? Context.GetSysLookup(cp.Relookup):Context.GetLookup(cp.Relookup); } else { lookup = cp.SysLookup ? Context.GetSysLookup(cp.Relookup) : Context.GetLookup(cp.Relookup); } int i = 0; foreach (var item in lookup.Fields) { if (cp.SysLookup && i == 0) { i++; continue; } var nf = new FieldValuePair { Name = item.Name, Length = item.Length, Value = i == 1 && string.IsNullOrWhiteSpace(search)?searcher.Text:"", ReadOnly = item.NameEng != "Id", IsRequared = item.IsRequared, IsUnique = item.IsUnique, RTABLENAME = item.RTABLENAME, FieldName = item.NameEng }; if (item.NameEng == search) { nf.Value = searcher.Text; } current.Add(nf); } LookupsEdidViewModels vmm = new LookupsEdidViewModels(current, lookup.LookUpMetaData.Tablename, true); EditInsertLookups ds = new EditInsertLookups(vmm); ds.ShowDialog(); if (ds.DialogResult.HasValue && ds.DialogResult.Value) { //nov red if (!cp.SysLookup) { lookup.Fields.Add(new TableField { DbField = "integer", GROUP = 4, Id = 4, Length = 4, IsRequared = false, NameEng = "FIRMAID", Name = "Фирма Номер" }); } bool sys = cp.SysLookup?!Context.SaveRow(ds.GetNewFields(), lookup):!Context.SaveRow(ds.GetNewFields(), lookup, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id); if (sys) { MessageBoxWrapper.Show( "Получвава се дублиране на елемент от номенклатура! Номенклатурата не е записана!"); } else { var dc = DataContext as SaldoItem; var dat = ds.GetNewFields(); if (dat != null) { dc.Value = dat[1]; dc.Lookupval = dat[2]; } if (dat != null && dat.Count > 5) { dc.Bulstad = dat[3]; dc.Vat = dat[4]; } dc.LiD = 0; OnRefreshExecuted(new FastLookupEventArgs(dc)); } } //cp.LookUp.Add(new SaldoItem { Value = ds.GetNewFields()[2], Key = ds.GetNewFields()[1] }); } }
private void editdialog(bool state) { List <FieldValuePair> current = new List <FieldValuePair>(); LookupModel lookup = null; if (Lookup != null) { if ((this.CurrentRowIndex == -1) && state) { return; } lookup = Context.GetSysLookup(Lookup.Id); for (var i = 0; i < this.Fields[this.CurrentRowIndex + 1].Count; i++) { if (state) { current.Add(new FieldValuePair { Name = Fields[0][i], Value = Fields[this.CurrentRowIndex + 1][i], Length = lookup.Fields[i].Length, ReadOnly = !(lookup.Fields[i].NameEng == "Id" || lookup.Fields[i].NameEng == "ID"), IsRequared = lookup.Fields[i].IsRequared, IsUnique = lookup.Fields[i].IsUnique, RCODELOOKUP = lookup.Fields[i].RCODELOOKUP, RFIELDNAME = lookup.Fields[i].RFIELDNAME, RTABLENAME = lookup.Fields[i].RTABLENAME, RFIELDKEY = lookup.Fields[i].RFIELDKEY, Tn = lookup.Fields[i].Tn, Type = lookup.Fields[i].DbField, FieldName = lookup.Fields[i].NameEng }); } else { if (i > 0) { current.Add(new FieldValuePair { Name = Fields[0][i], Value = "", Length = lookup.Fields[i].Length, ReadOnly = (lookup.Fields[i].NameEng == "Id" || lookup.Fields[i].NameEng == "ID") ? false : true, IsRequared = lookup.Fields[i].IsRequared, IsUnique = lookup.Fields[i].IsUnique, RCODELOOKUP = lookup.Fields[i].RCODELOOKUP, RFIELDNAME = lookup.Fields[i].RFIELDNAME, RTABLENAME = lookup.Fields[i].RTABLENAME, RFIELDKEY = lookup.Fields[i].RFIELDKEY, Tn = lookup.Fields[i].Tn, Type = lookup.Fields[i].DbField, FieldName = lookup.Fields[i].NameEng }); } } } } else { MessageBoxWrapper.Show(Resources.AnaliticManagerViewModel_editdialogres1); return; } LookupsEdidViewModels vm = new LookupsEdidViewModels(current, lookup.LookUpMetaData.Tablename, false); EditInsertLookups ds = new EditInsertLookups(vm); ds.ShowDialog(); if (ds.DialogResult.HasValue && ds.DialogResult.Value) { if (state) { //update Context.UpdateRowSys(ds.GetNewFields(), lookup); } else { //nov red Context.SaveRow(ds.GetNewFields(), lookup); } CalculateFields(); OnPropertyChanged("Fields"); OnPropertyChanged("Lookup"); } }
private void editdialog(bool state) { List <FieldValuePair> current = new List <FieldValuePair>(); if (Lookup != null) { if ((this.CurrentRowIndex == -1) && state) { return; } for (var i = 0; i < this.Fields[this.CurrentRowIndex + 1].Count - 1; i++) { if (state) { current.Add(new FieldValuePair { Name = Fields[0][i], Value = Fields[this.CurrentRowIndex + 1][i], Length = LookupModelm.Fields[i].Length, ReadOnly = (LookupModelm.Fields[i].NameEng == "Id") ? false : true, Type = LookupModelm.Fields[i].DbField, IsRequared = LookupModelm.Fields[i].IsRequared, IsUnique = LookupModelm.Fields[i].IsUnique, Tn = LookupModelm.Fields[i].Tn, RTABLENAME = LookupModelm.Fields[i].RTABLENAME, FieldName = LookupModelm.Fields[i].NameEng }); } else { current.Add(new FieldValuePair { Name = Fields[0][i], Value = "", Length = LookupModelm.Fields[i].Length, ReadOnly = (LookupModelm.Fields[i].NameEng == "Id") ? false : true, Type = LookupModelm.Fields[i].DbField, IsRequared = LookupModelm.Fields[i].IsRequared, IsUnique = LookupModelm.Fields[i].IsUnique, Tn = LookupModelm.Fields[i].Tn, RTABLENAME = LookupModelm.Fields[i].RTABLENAME, FieldName = LookupModelm.Fields[i].NameEng }); } } } else { MessageBoxWrapper.Show("Не е избрана номенклатура"); return; } LookupsEdidViewModels vm = new LookupsEdidViewModels(current, LookupModelm.LookUpMetaData.Tablename, !state); EditInsertLookups ds = new EditInsertLookups(vm); ds.ShowDialog(); if (ds.DialogResult.HasValue && ds.DialogResult.Value) { if (state) { //update Context.UpdateRow(ds.GetNewFields(), LookupModelm); } else { //nov red if (Context.CheckLookup(ds.GetNewFields(), LookupModelm)) { var list = new List <string>(ds.GetNewFields()); Context.SaveRow(list, LookupModelm, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id); } else { MessageBoxWrapper.Show("Има поле ,за което не е спазено правилото за уникалност"); } } CalculateFields(); OnPropertyChanged("Fields"); OnPropertyChanged("Lookup"); } }