public static IEnumerable <SaldoItem> LoadCreditAnaliticAtributes(IEnumerable <SaldoAnaliticModel> fields, int typecpnto)
{
List <SaldoItem> saldoItems = new List <SaldoItem>();
int offset = 16;
if (typecpnto == 2)
{
offset = 60;
}
int current = 0;
foreach (SaldoAnaliticModel analiticalFields in fields)
{
current++;
//Titles.Add(analiticalFields.Name);
SaldoItemTypes saldotype = SaldoItemTypes.String;
if (analiticalFields.DBField == "integer")
{
saldotype = SaldoItemTypes.Integer;
}
if (analiticalFields.DBField.Contains("DECIMAL"))
{
saldotype = SaldoItemTypes.Currency;
}
if (analiticalFields.DBField == "Date")
{
saldotype = SaldoItemTypes.Date;
}
SaldoItem saldoItem = new SaldoItem();
saldoItem.Type = saldotype;
saldoItem.Name = analiticalFields.Name;
saldoItem.Value = analiticalFields.VAL;
saldoItem.Fieldkey = analiticalFields.ACCFIELDKEY;
saldoItem.IsK = typecpnto == 0;
saldoItem.IsD = typecpnto == 1;
saldoItem.Id = analiticalFields.ID;
saldoItem.KursDif = analiticalFields.KURSD;
saldoItem.ValueKurs = analiticalFields.KURS;
saldoItem.MainKurs = analiticalFields.KURSM;
saldoItem.ValueVal = analiticalFields.VALVAL;
saldoItem.ValueCredit = analiticalFields.VALUEMONEY;
saldoItem.Lookupval = analiticalFields.LOOKUPVAL;
saldoItem.TabIndex = offset + current;
if (analiticalFields.ACCFIELDKEY == 29 || analiticalFields.ACCFIELDKEY == 30 ||
analiticalFields.ACCFIELDKEY == 31)
{
saldoItem.IsDK = true;
if (analiticalFields.ACCFIELDKEY == 30)
{
//saldoItem.InfoTitle = "Валутен курс";
saldoItem.IsVal = true;
}
if (analiticalFields.ACCFIELDKEY == 31)
{
// saldoItem.InfoTitle = "Единичнa цена";
saldoItem.IsKol = true;
saldoItem.ValueKol = analiticalFields.VALVAL;
saldoItem.OnePrice = analiticalFields.KURS;
}
}
if (analiticalFields.LOOKUPID != 0)
{
saldoItem.LiD = analiticalFields.LOOKUPFIELDKEY;
saldoItem.Relookup = analiticalFields.LOOKUPID;
saldoItem.IsLookUp = true;
}
saldoItems.Add(saldoItem);
}
return(saldoItems);
}
public IEnumerable <SaldoItem> LoadCreditAnaliticAtributes(IEnumerable <SaldoAnaliticModel> fields, int typecpnto,
TempoDataBaseContext context)
{
List <SaldoItem> saldoItems = new List <SaldoItem>();
foreach (SaldoAnaliticModel analiticalFields in fields)
{
//Titles.Add(analiticalFields.Name);
SaldoItemTypes saldotype = SaldoItemTypes.String;
if (analiticalFields.DBField == "integer")
{
saldotype = SaldoItemTypes.Integer;
}
if (analiticalFields.DBField.Contains("DECIMAL"))
{
saldotype = SaldoItemTypes.Currency;
}
if (analiticalFields.DBField == "Date")
{
saldotype = SaldoItemTypes.Date;
}
SaldoItem saldoItem = new SaldoItem
{
Name = analiticalFields.Name,
Type = saldotype,
Value = analiticalFields.VAL,
Fieldkey = analiticalFields.ACCFIELDKEY,
IsK = typecpnto == 0,
IsD = typecpnto == 1,
Id = analiticalFields.ID,
KursDif = analiticalFields.KURSD,
ValueKurs = analiticalFields.KURS,
MainKurs = analiticalFields.KURSM,
ValueVal = analiticalFields.VALVAL,
ValueCredit = analiticalFields.VALUEMONEY,
Lookupval = analiticalFields.LOOKUPVAL
};
if (analiticalFields.ACCFIELDKEY == 29 || analiticalFields.ACCFIELDKEY == 30 ||
analiticalFields.ACCFIELDKEY == 31)
{
saldoItem.IsDK = true;
if (analiticalFields.ACCFIELDKEY == 30)
{
saldoItem.InfoTitle = "Валутен курс";
saldoItem.IsVal = true;
}
if (analiticalFields.ACCFIELDKEY == 31)
{
saldoItem.InfoTitle = "Единичнa цена";
saldoItem.IsKol = true;
}
}
if (analiticalFields.LOOKUPID != 0)
{
saldoItem.Key = analiticalFields.LOOKUPFIELDKEY.ToString();
saldoItem.IsLookUp = true;
saldoItem.Relookup = analiticalFields.LOOKUPID;
LookupModel lm = context.GetLookup(analiticalFields.LOOKUPID);
var list = context.GetLookup(lm.LookUpMetaData.Tablename,
1);
int k = 0;
foreach (IEnumerable <string> enumerable in list)
{
int i = 0;
SaldoItem saldoitem = new SaldoItem();
saldoitem.Name = saldoItem.Name;
foreach (string s in enumerable)
{
if (i == 2)
{
saldoitem.Value = s;
}
if (i == 1)
{
saldoitem.Key = s;
}
if (k == 0 && i == 1)
{
k++;
}
if (k == 1 && i == 2)
{
k++;
}
i++;
}
saldoItem.LookUp.Add(saldoitem);
saldoItem.SelectedLookupItem =
saldoItem.LookUp.FirstOrDefault(e => e.Value == saldoItem.Value);
}
}
saldoItems.Add(saldoItem);
}
return(saldoItems);
}
public EditorAddSaldosViewModel(AccountsModel acc, int groupid, long typeAnaliticalKey)
{
IsEdit = true;
Title = string.Format("Редактиране на салдо по сметка {0}", acc);
this.AccID = acc.Id;
this.Acc = acc;
this.GroupId = groupid;
_items = new ObservableCollection <SaldoItem>();
this.typeAnaliticalKey = typeAnaliticalKey;
List <SaldoAnaliticModel> fields = new List <SaldoAnaliticModel>(Context.GetCurrentMovements(acc.Id, groupid));
int tabindex = 1;
foreach (SaldoAnaliticModel analiticalFields in fields)
{
//Titles.Add(analiticalFields.Name);
SaldoItemTypes saldotype = SaldoItemTypes.String;
if (analiticalFields.DBField == "integer")
{
saldotype = SaldoItemTypes.Integer;
}
if (analiticalFields.DBField.Contains("DECIMAL"))
{
saldotype = SaldoItemTypes.Currency;
}
if (analiticalFields.DBField == "Date")
{
saldotype = SaldoItemTypes.Date;
}
SaldoItem saldoItem = new SaldoItem
{
Name = analiticalFields.Name,
Type = saldotype,
Value = analiticalFields.VAL + analiticalFields.VALS,
Valued = analiticalFields.VALUED.ToString(),
Fieldkey = analiticalFields.ACCFIELDKEY,
IsInUnigroup = analiticalFields.Required,
TabIndex = tabindex,
Vals = analiticalFields.VALS
};
tabindex++;
if (analiticalFields.ACCFIELDKEY == 30)
{
saldoItem.ValueCredit = analiticalFields.VALVALK;
saldoItem.ValueDebit = analiticalFields.VALVALD;
saldoItem.IsVal = true;
saldoItem.IsDK = true;
}
if (analiticalFields.ACCFIELDKEY == 31)
{
saldoItem.ValueCredit = analiticalFields.VALKOLK;
saldoItem.ValueDebit = analiticalFields.VALKOLD;
saldoItem.IsKol = true;
saldoItem.IsDK = true;
}
if (analiticalFields.ACCFIELDKEY == 29)
{
saldoItem.ValueCredit = analiticalFields.VALUEMONEY;
saldoItem.ValueDebit = analiticalFields.VALUED;
saldoItem.IsDK = true;
}
//if (analiticalFields.LOOKUPID != 0)
//{
// saldoItem.Key = analiticalFields.LOOKUPFIELDKEY.ToString();
// saldoItem.IsLookUp = true;
// saldoItem.Relookup = analiticalFields.LOOKUPID;
// LookupModel lm = context.GetLookup(analiticalFields.LOOKUPID);
// var list = context.GetLookup(lm.LookUpMetaData.Tablename);
// int k = 0;
// foreach (IEnumerable<string> enumerable in list)
// {
// int i = 0;
// SaldoItem saldoitem = new SaldoItem();
// foreach (string s in enumerable)
// {
// if (i == 2) saldoitem.Value = s;
// if (i == 1) saldoitem.Key = s;
// if (k == 0 && i == 1)
// {
// saldoItem.Key = s;
// k++;
// }
// if (k == 1 && i == 2)
// {
// saldoItem.Value = s;
// k++;
// }
// i++;
// }
// saldoItem.LookUp.Add(saldoitem);
// }
//}
_items.Add(saldoItem);
}
}
private IEnumerable <SaldoItem> LoadAccFieldsMetaData(AccountsModel acc)
{
AllAnaliticTypes = new ObservableCollection <AnaliticalAccountType>(Context.GetAllAnaliticalAccountType());
AllAnaliticalAccount = new ObservableCollection <AnaliticalAccount>(Context.GetAllAnaliticalAccount());
AllAnaliticalFields = new ObservableCollection <AnaliticalFields>(Context.GetAllAnaliticalFields());
AllConnectors =
new ObservableCollection <MapAnanaliticAccToAnaliticField>(Context.GetAllConnectorAnaliticField());
AlaMapToType = new ObservableCollection <MapAnanaliticAccToAnaliticField>(Context.GetAllConnectorTypeField());
SelectedAnaliticalFields = new ObservableCollection <AnaliticalFields>();
SelectedAnaliticalTypeFields = new ObservableCollection <AnaliticalFields>();
SelectedAnaliticalFields.Clear();
var CurrentAllAnaliticalAccount = AllAnaliticalAccount.FirstOrDefault(e => e.Id == acc.AnaliticalNum);
//AnaliticalAccountType CurrentAllTypeAccount = AllAnaliticTypes.FirstOrDefault(e => e.Id == CurrentAllAnaliticalAccount.Id);
SelectedConnectors =
new ObservableCollection <MapAnanaliticAccToAnaliticField>(
AllConnectors.Where(e => CurrentAllAnaliticalAccount != null && e.AnaliticalNameID == CurrentAllAnaliticalAccount.Id));
foreach (var curr in SelectedConnectors.OrderBy(e => e.SortOrder))
{
var addfield = AllAnaliticalFields.Where(e => e.Id == curr.AnaliticalFieldId).FirstOrDefault();
if (addfield != null)
{
addfield.Requared = curr.Required;
if (addfield != null)
{
SelectedAnaliticalFields.Add(addfield);
}
}
}
Context.LoadMapToLookUps(SelectedAnaliticalFields, acc.Id, acc.AnaliticalNum);
SelectedConnectors =
new ObservableCollection <MapAnanaliticAccToAnaliticField>(
AlaMapToType.Where(e => e.AnaliticalFieldId == CurrentAllAnaliticalAccount.TypeID));
SelectedAnaliticalTypeFields.Clear();
foreach (var curr in SelectedConnectors)
{
var addfield = AllAnaliticalFields.FirstOrDefault(e => e.Id == curr.AnaliticalNameID);
if (addfield != null)
{
addfield.Requared = curr.Required;
SelectedAnaliticalTypeFields.Add(addfield);
}
}
ObservableCollection <AnaliticalFields> sFieldses = new ObservableCollection <AnaliticalFields>();
CurrentAllTypeAccount = AllAnaliticTypes.FirstOrDefault(e => e.Id == CurrentAllAnaliticalAccount.TypeID);
if (CurrentAllTypeAccount != null)
{
if (CurrentAllTypeAccount.Sl)
{
sFieldses.Add(AllAnaliticalFields.FirstOrDefault(f => f.Name == "Сума лв."));
}
if (CurrentAllTypeAccount.Sv)
{
sFieldses.Add(AllAnaliticalFields.FirstOrDefault(f => f.Name == "Сума валута"));
}
if (CurrentAllTypeAccount.Kol)
{
sFieldses.Add(AllAnaliticalFields.FirstOrDefault(f => f.Name == "Количество"));
}
}
else
{
sFieldses.Add(AllAnaliticalFields.FirstOrDefault(f => f.Name == "Сума лв."));
}
Titles = new ObservableCollection <string>();
Contents = new ObservableCollection <ObservableCollection <string> >();
ObservableCollection <string> vals = new ObservableCollection <string>();
ObservableCollection <SaldoItem> _saldoItems = new ObservableCollection <SaldoItem>();
int tabitem = 1;
foreach (AnaliticalFields analiticalFields in sFieldses)
{
Titles.Add(analiticalFields.Name + "Кредит");
Titles.Add(analiticalFields.Name + "Дебит");
SaldoItemTypes saldotype = SaldoItemTypes.String;
if (analiticalFields.FieldType == "integer")
{
saldotype = SaldoItemTypes.Integer;
}
if (analiticalFields.FieldType.Contains("DECIMAL"))
{
saldotype = SaldoItemTypes.Currency;
}
if (analiticalFields.FieldType == "Date")
{
saldotype = SaldoItemTypes.Date;
}
SaldoItem saldoItem = new SaldoItem
{
Name = analiticalFields.Name,
Type = saldotype,
Length = 50,
Value = Vf.LevFormatUI,
Valued = Vf.LevFormatUI,
IsDK = true,
Fieldkey = analiticalFields.Id,
IsInUnigroup = analiticalFields.Requared,
TabIndex = tabitem
};
tabitem++;
if (analiticalFields.Name == "Количество")
{
saldoItem.IsKol = true;
}
if (analiticalFields.Name == "Сума валута")
{
saldoItem.IsVal = true;
}
if (analiticalFields.Name == "Валутен курс")
{
saldoItem.IsKurs = true;
}
_saldoItems.Add(saldoItem);
}
foreach (AnaliticalFields analiticalFields in SelectedAnaliticalFields)
{
Titles.Add(analiticalFields.Name);
SaldoItemTypes saldotype = SaldoItemTypes.String;
string defvalue = "";
if (analiticalFields.FieldType == "integer")
{
saldotype = SaldoItemTypes.Integer;
defvalue = "0";
}
if (analiticalFields.FieldType == "decimal")
{
saldotype = SaldoItemTypes.Currency;
defvalue = Vf.LevFormatUI;
}
if (analiticalFields.FieldType == "Date")
{
saldotype = SaldoItemTypes.Date;
defvalue = DateTime.Now.ToShortDateString();
}
SaldoItem saldoItem = new SaldoItem
{
Name = analiticalFields.Name,
Type = saldotype,
Value = defvalue,
Fieldkey = analiticalFields.Id,
IsInUnigroup = analiticalFields.Requared,
TabIndex = tabitem
};
tabitem++;
if (analiticalFields.IdLookUp != 0)
{
saldoItem.IsLookUp = true;
saldoItem.Relookup = analiticalFields.IdLookUp;
}
// LookupModel lm = Context.GetLookup(analiticalFields.IdLookUp);
// var list = Context.GetLookup(lm.LookUpMetaData.Tablename, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id);
// int k = 0;
// foreach (IEnumerable<string> enumerable in list)
// {
// int i = 0;
// SaldoItem saldoitem = new SaldoItem();
// foreach (string s in enumerable)
// {
// if (i == 2) saldoitem.Value = s;
// if (i == 1) saldoitem.Key = s;
// if (k == 0 && i == 1)
// {
// saldoItem.Key = s;
// k++;
// }
// if (k == 1 && i == 2)
// {
// saldoItem.Value = s;
// k++;
// }
// i++;
// }
// saldoItem.LookUp.Add(saldoitem);
// }
//}
_saldoItems.Add(saldoItem);
}
foreach (AnaliticalFields analiticalFields in SelectedAnaliticalTypeFields)
{
Titles.Add(analiticalFields.Name);
string defvalue = "";
SaldoItemTypes saldotype = SaldoItemTypes.String;
if (analiticalFields.FieldType == "integer")
{
saldotype = SaldoItemTypes.Integer;
defvalue = "0";
}
if (analiticalFields.FieldType == "decimal")
{
saldotype = SaldoItemTypes.Currency;
defvalue = Vf.LevFormatUI;
}
if (analiticalFields.FieldType == "Date")
{
saldotype = SaldoItemTypes.Date;
defvalue = DateTime.Now.ToShortDateString();
}
SaldoItem saldoItem = new SaldoItem
{
Name = analiticalFields.Name,
Type = saldotype,
Value = defvalue,
Fieldkey = analiticalFields.Id,
IsInUnigroup = analiticalFields.Requared,
TabIndex = tabitem
};
tabitem++;
if (analiticalFields.IdLookUp != 0)
{
saldoItem.IsLookUp = true;
saldoItem.Relookup = analiticalFields.IdLookUp;
}
// LookupModel lm = Context.GetLookup(analiticalFields.IdLookUp);
// var list = Context.GetLookup(lm.LookUpMetaData.Tablename, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id);
// foreach (IEnumerable<string> enumerable in list)
// {
// int i = 0;
// SaldoItem saldoitem = new SaldoItem();
// foreach (string s in enumerable)
// {
// if (i == 2) saldoitem.Value = s;
// if (i == 1) saldoitem.Key = s;
// i++;
// }
// saldoItem.LookUp.Add(saldoitem);
// }
//}
//if (!string.IsNullOrWhiteSpace(analiticalFields.RTABLENAME))
//{
// saldoItem.IsLookUp = true;
// saldoItem.RCODELOOKUP = analiticalFields.RCODELOOKUP;
// var list = Context.GetLookup(analiticalFields.RTABLENAME, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id);
// int k = 0;
// foreach (IEnumerable<string> enumerable in list)
// {
// int i = 0;
// SaldoItem saldoitem = new SaldoItem();
// foreach (string s in enumerable)
// {
// if (i == 2) saldoitem.Value = s;
// if (i == 1) saldoitem.Key = s;
// if (k == 0 && i == 1)
// {
// saldoItem.Key = s;
// k++;
// }
// if (k == 1 && i == 2)
// {
// saldoItem.Value = s;
// k++;
// }
// i++;
// }
// saldoItem.LookUp.Add(saldoitem);
// }
//}
_saldoItems.Add(saldoItem);
}
return(_saldoItems);
}
public SaldosAnaliticViewModel(ObservableCollection <AnaliticalFields> observableCollection, ObservableCollection <AnaliticalFields> observableCollection_2, ObservableCollection <AnaliticalFields> staticFields, AccountsModel accountsModel)
{
Title = string.Format("Начални аналитични салда на сметка {0}", accountsModel);
IsCol = accountsModel.SaldoDK > 0 || accountsModel.SaldoKK > 0;
IsVal = accountsModel.SaldoDV > 0 || accountsModel.SaldoKV > 0;
this.IsShowNavigation = false;
this.observableCollection = observableCollection;
this.observableCollection_2 = observableCollection_2;
this.staticFields = staticFields;
this.accountsModel = accountsModel;
this.IsShowReport = true;
Titles = new ObservableCollection <string>();
Contents = new ObservableCollection <ObservableCollection <string> >();
ObservableCollection <string> vals = new ObservableCollection <string>();
_saldoItems = new ObservableCollection <SaldoItem>();
foreach (AnaliticalFields analiticalFields in staticFields)
{
Titles.Add(analiticalFields.Name + "Кредит");
Titles.Add(analiticalFields.Name + "Дебит");
SaldoItemTypes saldotype = SaldoItemTypes.String;
if (analiticalFields.FieldType == "integer")
{
saldotype = SaldoItemTypes.Integer;
}
if (analiticalFields.FieldType.Contains("DECIMAL"))
{
saldotype = SaldoItemTypes.Currency;
}
if (analiticalFields.FieldType == "Date")
{
saldotype = SaldoItemTypes.Date;
}
SaldoItem saldoItem = new SaldoItem
{
Name = analiticalFields.Name,
Type = saldotype,
Length = 50,
Value = Vf.LevFormatUI,
Valued = Vf.LevFormatUI,
IsDK = true,
Fieldkey = analiticalFields.Id,
IsInUnigroup = analiticalFields.Requared,
Group = analiticalFields.Group
};
_saldoItems.Add(saldoItem);
}
foreach (AnaliticalFields analiticalFields in observableCollection)
{
Titles.Add(analiticalFields.Name);
SaldoItemTypes saldotype = SaldoItemTypes.String;
string defvalue = "";
if (analiticalFields.FieldType == "integer")
{
saldotype = SaldoItemTypes.Integer;
defvalue = "0";
}
if (analiticalFields.FieldType == "decimal")
{
saldotype = SaldoItemTypes.Currency;
defvalue = Vf.LevFormatUI;
}
if (analiticalFields.FieldType == "Date")
{
saldotype = SaldoItemTypes.Date;
defvalue = DateTime.Now.ToShortDateString();
}
SaldoItem saldoItem = new SaldoItem
{
Name = analiticalFields.Name,
Type = saldotype,
Value = defvalue,
Fieldkey = analiticalFields.Id,
IsInUnigroup = analiticalFields.Requared,
Group = analiticalFields.Group
};
if (analiticalFields.IdLookUp != 0)
{
saldoItem.IsLookUp = true;
saldoItem.Relookup = analiticalFields.IdLookUp;
}
// LookupModel lm = Context.GetLookup(analiticalFields.IdLookUp);
// var list = Context.GetLookup(lm.LookUpMetaData.Tablename, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id);
// int k = 0;
// foreach (IEnumerable<string> enumerable in list)
// {
// int i = 0;
// SaldoItem saldoitem = new SaldoItem();
// saldoitem.Name = saldoItem.Name;
// List<string> s = new List<string>(enumerable);
// saldoitem.Key = s[1];
// saldoitem.Value = s[2];
// saldoItem.LookUp.Add(saldoitem);
// }
//}
_saldoItems.Add(saldoItem);
}
foreach (AnaliticalFields analiticalFields in observableCollection_2)
{
Titles.Add(analiticalFields.Name);
string defvalue = "";
SaldoItemTypes saldotype = SaldoItemTypes.String;
if (analiticalFields.FieldType == "integer")
{
saldotype = SaldoItemTypes.Integer;
defvalue = "0";
}
if (analiticalFields.FieldType == "decimal")
{
saldotype = SaldoItemTypes.Currency;
defvalue = Vf.LevFormatUI;
}
if (analiticalFields.FieldType == "Date")
{
saldotype = SaldoItemTypes.Date;
defvalue = DateTime.Now.ToShortDateString();
}
SaldoItem saldoItem = new SaldoItem
{
Name = analiticalFields.Name,
Type = saldotype,
Value = defvalue,
Fieldkey = analiticalFields.Id,
IsInUnigroup = analiticalFields.Requared,
Group = analiticalFields.Group
};
if (analiticalFields.IdLookUp != 0)
{
saldoItem.IsLookUp = true;
saldoItem.Relookup = analiticalFields.IdLookUp;
}
// LookupModel lm = Context.GetLookup(analiticalFields.IdLookUp);
// var list = Context.GetLookup(lm.LookUpMetaData.Tablename, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id);
// foreach (IEnumerable<string> enumerable in list)
// {
// int i = 0;
// SaldoItem saldoitem = new SaldoItem();
// saldoitem.Name = saldoItem.Name;
// List<string> s = new List<string>(enumerable);
// saldoitem.Key = s[1];
// saldoitem.Value = s[2];
// saldoItem.LookUp.Add(saldoitem);
// }
//}
//if (!string.IsNullOrWhiteSpace(analiticalFields.RTABLENAME))
//{
// saldoItem.IsLookUp = true;
// saldoItem.RCODELOOKUP = analiticalFields.RCODELOOKUP;
// var list = Context.GetLookup(analiticalFields.RTABLENAME, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id);
// int k= 0;
// foreach (IEnumerable<string> enumerable in list)
// {
// int i = 0;
// SaldoItem saldoitem = new SaldoItem();
// saldoitem.Name = saldoItem.Name;
// List<string> s = new List<string>(enumerable);
// saldoitem.Key = s[1];
// saldoitem.Value = s[2];
// saldoItem.LookUp.Add(saldoitem);
// }
//}
_saldoItems.Add(saldoItem);
}
GetValue(accountsModel);
}
public IEnumerable <SaldoItem> LoadCreditAnaliticAtributes(IEnumerable <SaldoAnaliticModel> fields, int typecpnto)
{
List <SaldoItem> saldoItems = new List <SaldoItem>();
int offset = 16;
if (typecpnto == 2)
{
offset = 60;
}
int current = 0;
foreach (SaldoAnaliticModel analiticalFields in fields)
{
current++;
//Titles.Add(analiticalFields.Name);
SaldoItemTypes saldotype = SaldoItemTypes.String;
if (analiticalFields.DBField == "integer")
{
saldotype = SaldoItemTypes.Integer;
}
if (analiticalFields.DBField.Contains("DECIMAL"))
{
saldotype = SaldoItemTypes.Currency;
}
if (analiticalFields.DBField == "Date")
{
saldotype = SaldoItemTypes.Date;
}
SaldoItem saldoItem = new SaldoItem();
saldoItem.Type = saldotype;
saldoItem.Name = analiticalFields.Name;
saldoItem.Value = analiticalFields.VAL;
saldoItem.Fieldkey = analiticalFields.ACCFIELDKEY;
saldoItem.IsK = typecpnto == 0;
saldoItem.IsD = typecpnto == 1;
saldoItem.Id = analiticalFields.ID;
saldoItem.KursDif = analiticalFields.KURSD;
saldoItem.ValueKurs = analiticalFields.KURS;
saldoItem.MainKurs = analiticalFields.KURSM;
saldoItem.ValueVal = analiticalFields.VALVAL;
saldoItem.ValueCredit = analiticalFields.VALUEMONEY;
saldoItem.Lookupval = analiticalFields.LOOKUPVAL;
saldoItem.TabIndex = offset + current;
if (analiticalFields.ACCFIELDKEY == 29 || analiticalFields.ACCFIELDKEY == 30 ||
analiticalFields.ACCFIELDKEY == 31)
{
saldoItem.IsDK = true;
if (analiticalFields.ACCFIELDKEY == 30)
{
//saldoItem.InfoTitle = "Валутен курс";
saldoItem.IsVal = true;
//if (typecpnto == 0)
//{
// try
// {
// saldoItem.InfoValue = DAccountsModel.EndSaldoL/DAccountsModel.EndSaldoV;
// }
// catch (Exception)
// {
// saldoItem.InfoValue =0;
// }
//}
//if (typecpnto == 1)
//{
// try
// {
// saldoItem.InfoValue = CAccountsModel.EndSaldoL / CAccountsModel.EndSaldoV;
// }
// catch (Exception)
// {
// saldoItem.InfoValue = 0;
// }
//}
}
if (analiticalFields.ACCFIELDKEY == 31)
{
// saldoItem.InfoTitle = "Единичнa цена";
saldoItem.IsKol = true;
saldoItem.ValueKol = analiticalFields.VALVAL;
saldoItem.OnePrice = analiticalFields.KURS;
}
// if (typecpnto == 1)
// {
// try
// {
// saldoItem.InfoValue = (DAccountsModel.EndSaldoL / DAccountsModel.EndSaldoK);
// }
// catch (Exception)
// {
// saldoItem.InfoValue = 0;
// }
// }
// if (typecpnto == 0)
// {
// try
// {
// saldoItem.InfoValue = CAccountsModel.EndSaldoL / CAccountsModel.EndSaldoK;
// }
// catch (Exception)
// {
// saldoItem.InfoValue = 0; ;
// }
// }
//}
}
if (analiticalFields.LOOKUPID != 0)
{
//saldoItem.LiD = analiticalFields.LOOKUPFIELDKEY;
saldoItem.Relookup = analiticalFields.LOOKUPID;
saldoItem.IsLookUp = true;
//LookupModel lm = Context.GetLookup(analiticalFields.LOOKUPID);
//var list = Context.GetLookupDictionary(lm.LookUpMetaData.Tablename, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id,""," FIRST 30 ");
//int k = 0;
//foreach (var enumerable in list)
//{
// int i = 0;
// SaldoItem saldoitem = new SaldoItem();
// saldoitem.Name = saldoItem.Name;
// saldoitem.Key = enumerable[lm.Fields[0].NameEng].ToString();
// saldoitem.Value = enumerable[lm.Fields[1].NameEng].ToString();
// saldoItem.LookUp.Add(saldoitem);
// saldoItem.SelectedLookupItem =
// saldoItem.LookUp.FirstOrDefault(e => e.Value == saldoItem.Value);
//}
//if (!string.IsNullOrWhiteSpace(analiticalFields.RTABLENAME))
//{
// saldoItem.Key = analiticalFields.LOOKUPFIELDKEY.ToString();
// saldoItem.IsLookUp = true;
// var list1 = Context.GetLookup(analiticalFields.RTABLENAME, ConfigTempoSinglenton.GetInstance().CurrentFirma.Id);
// k = 0;
// foreach (IEnumerable<string> enumerable in list1)
// {
// int i = 0;
// SaldoItem saldoitem = new SaldoItem();
// saldoitem.Name = saldoItem.Name;
// List<string> s = new List<string>(enumerable);
// saldoitem.Key = s[1];
// saldoitem.Value = s[2];
// saldoItem.LookUp.Add(saldoitem);
// }
//}
}
saldoItems.Add(saldoItem);
}
return(saldoItems);
}
