public FiderViewModel(MethodsEntities methodsEntities)
{
this.methodsEntities = methodsEntities;
fiders = new ObservableCollection <FIDER>(methodsEntities.FIDER.OrderBy(p => p.F_TYPE));
persons = new ObservableCollection <PERSON>(methodsEntities.PERSON.OrderBy(p => p.PERSON_FIO));
units = new ObservableCollection <UNIT>(methodsEntities.UNIT.OrderBy(p => p.UNIT_VALUE));
}
public static void Merge()
{
using (var context = new MethodsEntities())
{
context.Merge();
}
}
public PersonViewModel(MethodsEntities methodsEntities)
{
this.methodsEntities = methodsEntities;
data = new ObservableCollection <PERSON>(methodsEntities.PERSON.OrderBy(p => p.PERSON_FIO));
if (data != null && data.Count != 0)
{
selectedRow = data.FirstOrDefault();
}
}
public EqTypeViewModel(MethodsEntities methodsEntities)
{
this.methodsEntities = methodsEntities;
data = new ObservableCollection <EQUIPMENT_TYPE>(methodsEntities.EQUIPMENT_TYPE.OrderBy(p => p.EQT_NAME));
if (data != null && data.Count != 0)
{
selectedRow = data.FirstOrDefault();
}
}
public ProducerViewModel(MethodsEntities methodsEntities)
{
this.methodsEntities = methodsEntities;
data = new ObservableCollection <PRODUCER>(methodsEntities.PRODUCER);
if (data != null && data.Count != 0)
{
selectedRow = data.FirstOrDefault();
}
}
public MDTViewModel(MethodsEntities methodsEntities)
{
this.methodsEntities = methodsEntities;
data = new ObservableCollection <MEASURING_DEVICE_TYPE>(methodsEntities.MEASURING_DEVICE_TYPE.OrderBy(p => p.MDT_NAME));
if (data != null && data.Count != 0)
{
selectedRow = data.FirstOrDefault();
}
}
public OrganizationViewModel(MethodsEntities methodsEntities)
{
this.methodsEntities = methodsEntities;
data = new ObservableCollection <ORGANIZATION>(methodsEntities.ORGANIZATION.OrderBy(p => p.ORG_NAME));
if (data != null && data.Count != 0)
{
selectedRow = data.FirstOrDefault();
}
}
public UnitViewModel(MethodsEntities methodsEntities)
{
this.methodsEntities = methodsEntities;
data = new ObservableCollection<UNIT>(methodsEntities.UNIT.OrderBy(p=>p.UNIT_VALUE));
if (data != null && data.Count != 0)
{
selectedRow = data.FirstOrDefault();
}
}
public EquipmentViewModelNew(MethodsEntities methodsEntities, ARM arm_one)
{
this.arm_one = arm_one;
this.methodsEntities = methodsEntities;
this.arm_id = arm_one.ARM_ID;
data = new ObservableCollection <EQUIPMENT>(methodsEntities.EQUIPMENT.Where(p => p.EQ_ARM_ID == arm_id));
EquipmentTypes = new ObservableCollection <EQUIPMENT_TYPE>(methodsEntities.EQUIPMENT_TYPE);
equipmentNew = new EQUIPMENT();
isEnabled = false;
}
public AntennaViewModel(MethodsEntities methodsEntities)
{
this.methodsEntities = methodsEntities;
antennas = new ObservableCollection <ANTENNA>(methodsEntities.ANTENNA.OrderBy(p => p.ANT_TYPE));
if (selectedRow == null && antennas != null && antennas.Any())
{
selectedRow = antennas[0];
}
persons = new ObservableCollection <PERSON>(methodsEntities.PERSON.OrderBy(p => p.PERSON_FIO));
units = new ObservableCollection <UNIT>(methodsEntities.UNIT.OrderBy(p => p.UNIT_VALUE));
}
//static DatabaseOps()
//{
// using (var context = new MethodsEntities())
// {
// var connection = context.Database.Connection;
// Server server = new Server(new ServerConnection(new SqlConnection(connection.ConnectionString)));
// Database = server.Databases[connection.Database];
// }
//}
private static void currentDatabase()
{
using (var context = new MethodsEntities())
{
var connection = context.Database.Connection;
Server server = new Server(new ServerConnection(new SqlConnection(connection.ConnectionString)));
_Database = server.Databases[connection.Database];
}
}
public MdViewModel(MethodsEntities methodsEntities, ARM arm_one)
{
this.methodsEntities = methodsEntities;
this.arm_id = arm_one.ARM_ID;
mdTypes = new ObservableCollection <MEASURING_DEVICE_TYPE>(methodsEntities.MEASURING_DEVICE_TYPE);
mdArm = new ObservableCollection <MEASURING_DEVICE>();
PrepareData();
CheckRightLeft();
isEnabled = false;
}
public AnalyseResultsViewModel(MethodsEntities methodsEntities, ObservableCollection <ARM_TYPE> ArmTypes, int at_id)
{
this.methodsEntities = methodsEntities;
this.ArmTypes = ArmTypes;
RaisePropertyChanged(() => ArmTypes);
DataForAnalyse = new ObservableCollection <ForScenario.DataForAnalyse>();
this.at_id = at_id;
srPort = srDrive = srCarry = true;
lsSosr = true;
kategoria2 = true;
kategoria1 = false;
kategoria3 = false;
}
public ReportWindowViewModel(MethodsEntities MethodsEntities, XtraReport xr, int anl_id)
{
this.methodsEntities = MethodsEntities;
this.xr = xr;
this.anl_id = anl_id;
reportName = xr.GetType().Name;
RaisePropertyChanged(() => reportData); //все строки таблицы для заданных отчёта и счёта
RaisePropertyChanged(() => listLabel); //все метки из пред.коллекции
if (listLabel.Any())
{
selectedLabel = listLabel[0];
}
}
public OrgAnalysis_1_ViewModel(MethodsEntities methodsEntities, string userName, int org_id, int anl_id, string invoice)
{
this.methodsEntities = methodsEntities;
this.userName = userName;
this.invoice = invoice;
//подготовка к новому вводу
TextOrganization = String.Empty;
TextAnalysis = String.Empty;
organization_new = new ORGANIZATION();
Persons = new ObservableCollection <PERSON>(methodsEntities.PERSON.OrderBy(p => p.PERSON_FIO));
Persons_M = new ObservableCollection <PERSON>(methodsEntities.PERSON.Where(p => p.PERSON_NOTE.Contains("М") || String.IsNullOrEmpty(p.PERSON_NOTE)));
Persons_I = new ObservableCollection <PERSON>(methodsEntities.PERSON.Where(p => p.PERSON_NOTE.Contains("И") || String.IsNullOrEmpty(p.PERSON_NOTE)));
Organizations = new ObservableCollection <ORGANIZATION>(methodsEntities.ORGANIZATION.OrderBy(p => p.ORG_NAME));
this.org_id = org_id;
this.anl_id = anl_id;
}
//public static List<MEASURING_DATA> BulkCopy(List<MEASURING_DATA> entities, string table = "MEASURING_DATA")
public static List <MEASURING_DATA> BulkCopy(List <MEASURING_DATA> entities, string table)
{
var context = new MethodsEntities();
string connectionString = context.Database.Connection.ConnectionString;
using (IDataReader reader = entities.GetDataReader())
using (SqlConnection connection = new SqlConnection(connectionString))
using (SqlBulkCopy bcp = new SqlBulkCopy(connection))
{
connection.Open();
bcp.DestinationTableName = string.Format("[{0}]", table);
bcp.ColumnMappings.Add("MDA_ID", "MDA_ID");
bcp.ColumnMappings.Add("MDA_MODE_ID", "MDA_MODE_ID");
bcp.ColumnMappings.Add("MDA_F", "MDA_F");
bcp.ColumnMappings.Add("MDA_F_UNIT_ID", "MDA_F_UNIT_ID");
bcp.ColumnMappings.Add("MDA_I", "MDA_I");
bcp.ColumnMappings.Add("MDA_ECN_VALUE_IZM", "MDA_ECN_VALUE_IZM");
bcp.ColumnMappings.Add("MDA_EN_VALUE_IZM", "MDA_EN_VALUE_IZM");
bcp.ColumnMappings.Add("MDA_U0CN_VALUE_IZM", "MDA_U0CN_VALUE_IZM");
bcp.ColumnMappings.Add("MDA_U0N_VALUE_IZM", "MDA_U0N_VALUE_IZM");
bcp.ColumnMappings.Add("MDA_UFCN_VALUE_IZM", "MDA_UFCN_VALUE_IZM");
bcp.ColumnMappings.Add("MDA_UFN_VALUE_IZM", "MDA_UFN_VALUE_IZM");
bcp.ColumnMappings.Add("MDA_ES_VALUE_IZM", "MDA_ES_VALUE_IZM");
bcp.ColumnMappings.Add("MDA_ECN_VALUE_IZM_DB", "MDA_ECN_VALUE_IZM_DB");
bcp.ColumnMappings.Add("MDA_EN_VALUE_IZM_DB", "MDA_EN_VALUE_IZM_DB");
bcp.ColumnMappings.Add("MDA_U0CN_VALUE_IZM_DB", "MDA_U0CN_VALUE_IZM_DB");
bcp.ColumnMappings.Add("MDA_U0N_VALUE_IZM_DB", "MDA_U0N_VALUE_IZM_DB");
bcp.ColumnMappings.Add("MDA_UFCN_VALUE_IZM_DB", "MDA_UFCN_VALUE_IZM_DB");
bcp.ColumnMappings.Add("MDA_UFN_VALUE_IZM_DB", "MDA_UFN_VALUE_IZM_DB");
bcp.ColumnMappings.Add("MDA_ES_VALUE_IZM_DB", "MDA_ES_VALUE_IZM_DB");
bcp.ColumnMappings.Add("MDA_ECN_VALUE_IZM_MKV", "MDA_ECN_VALUE_IZM_MKV");
bcp.ColumnMappings.Add("MDA_EN_VALUE_IZM_MKV", "MDA_EN_VALUE_IZM_MKV");
bcp.ColumnMappings.Add("MDA_U0CN_VALUE_IZM_MKV", "MDA_U0CN_VALUE_IZM_MKV");
bcp.ColumnMappings.Add("MDA_U0N_VALUE_IZM_MKV", "MDA_U0N_VALUE_IZM_MKV");
bcp.ColumnMappings.Add("MDA_UFCN_VALUE_IZM_MKV", "MDA_UFCN_VALUE_IZM_MKV");
bcp.ColumnMappings.Add("MDA_UFN_VALUE_IZM_MKV", "MDA_UFN_VALUE_IZM_MKV");
bcp.ColumnMappings.Add("MDA_ES_VALUE_IZM_MKV", "MDA_ES_VALUE_IZM_MKV");
bcp.ColumnMappings.Add("MDA_EGS_DB", "MDA_EGS_DB");
bcp.ColumnMappings.Add("MDA_EGS_MKV", "MDA_EGS_MKV");
bcp.ColumnMappings.Add("MDA_E", "MDA_E");
bcp.ColumnMappings.Add("MDA_UF", "MDA_UF");
bcp.ColumnMappings.Add("MDA_U0", "MDA_U0");
bcp.ColumnMappings.Add("MDA_EGS", "MDA_EGS");
bcp.ColumnMappings.Add("MDA_KP", "MDA_KP");
bcp.ColumnMappings.Add("MDA_KPS", "MDA_KPS");
bcp.ColumnMappings.Add("MDA_RBW", "MDA_RBW");
bcp.ColumnMappings.Add("MDA_RBW_UNIT_ID", "MDA_RBW_UNIT_ID");
bcp.ColumnMappings.Add("MDA_TYPE", "MDA_TYPE");
bcp.ColumnMappings.Add("MDA_KA", "MDA_KA");
bcp.ColumnMappings.Add("MDA_KF", "MDA_KF");
bcp.ColumnMappings.Add("MDA_K0", "MDA_K0");
bcp.ColumnMappings.Add("MDA_F_BEGIN", "MDA_F_BEGIN");
bcp.ColumnMappings.Add("MDA_F_END", "MDA_F_END");
bcp.ColumnMappings.Add("MDA_ECN_BEGIN", "MDA_ECN_BEGIN");
bcp.ColumnMappings.Add("MDA_EN_BEGIN", "MDA_EN_BEGIN");
bcp.ColumnMappings.Add("MDA_ECN_END", "MDA_ECN_END");
bcp.ColumnMappings.Add("MDA_EN_END", "MDA_EN_END");
bcp.ColumnMappings.Add("MDA_ANGLE", "MDA_ANGLE");
try
{
bcp.WriteToServer(reader);
}
catch (Exception e) { }
}
return(entities);
}
public ARMMode_1_ViewModel(MethodsEntities methodsEntities, string userName)
{
this.methodsEntities = methodsEntities;
this.userName = userName;
//подготовка к новому вводу
}
