using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Data.Entity;
|
using System.Drawing;
|
using System.Linq;
|
using System.Text;
|
using System.Windows.Forms;
|
using System.IO;
|
using System.Text;
|
|
namespace sbcLabSystem.Import
|
{
|
public partial class Form1 : Form
|
{
|
public Form1()
|
{
|
InitializeComponent();
|
|
byte[] buf = new byte[] { 0xA8, 0x01, 0x00, 0x00 };
|
float data = BitConverter.ToSingle(buf,0);
|
|
}
|
|
private void button1_Click(object sender, EventArgs e)
|
{
|
try
|
{
|
sbcLabSystemEntities current_db = new sbcLabSystemEntities();
|
using (hds1230001_dbEntities ori_db = new hds1230001_dbEntities())
|
{
|
var regList = ori_db.EQAParticipant.OrderBy(p => p.LabID).ToList();
|
regList.ForEach(x =>
|
{
|
QCDistributionRegisterInfoes regInfo = new QCDistributionRegisterInfoes();
|
regInfo.ProjectId = x.ProjectID;
|
regInfo.ModifyTime = DateTime.Now;
|
regInfo.IsCharged = x.IsCharged;
|
regInfo.IsSendEMS = x.IsExpressSended;
|
regInfo.SampleNo = x.SampleSNO;
|
regInfo.EMSNo = x.ExpressBillCode;
|
regInfo.PacketContent = x.ExpressContent;
|
regInfo.IsModified = x.IsDataChanged;
|
regInfo.IsSubmit = x.IsDataSubmitted;
|
regInfo.SubmitTime = x.DateSubmitted;
|
regInfo.AnswerJSON = x.DataProject;
|
regInfo.LetterNo = x.RegisteredLetter;
|
|
var distInfo = ori_db.EQADistribution.FirstOrDefault(p => p.ID == x.DistributionID);
|
var labInfo = ori_db.Lab.FirstOrDefault(p => p.ID == x.LabID);
|
|
var distInfo2 = current_db.QCDistributions.FirstOrDefault(p => p.DistNo == distInfo.DistNo);
|
var labInfo2 = current_db.UserRequestInfoes.FirstOrDefault(p => p.LabCode == labInfo.LabCode);
|
|
regInfo.QCDistributionId = distInfo2.Id;
|
regInfo.LabId = labInfo2.Id;
|
|
current_db.QCDistributionRegisterInfoes.Add(regInfo);
|
current_db.SaveChanges();
|
});
|
}
|
current_db.Dispose();
|
}
|
catch (Exception ex)
|
{
|
MessageBox.Show(ex.ToString());
|
}
|
}
|
}
|
}
|
