/// <summary>
/// 同步水分结果
/// </summary>
/// <param name="output"></param>
/// <returns></returns>
public void SyncMtResult(Action <string, eOutputType> output)
{
int res = 0;
foreach (Tb_TestResult entity in this.EquDber.Entities <Tb_TestResult>("where SampleName is not null and EndingTime is not null and Moisture!=0 and endingtime >=getdate()-1 order by EndingTime asc"))
{
CmcsMoistureAssay moisture = commonDAO.SelfDber.Entity <CmcsMoistureAssay>("where PKID=:PKID", new
{
PKID = this.MachineCode + "-" + entity.Id
});
if (moisture == null)
{
moisture = new CmcsMoistureAssay();
moisture.PKID = this.MachineCode + "-" + entity.Id;
moisture.FacilityNumber = this.MachineCode;
moisture.SampleNumber = entity.SampleNo;
moisture.SampleWeight = entity.SampleWeight;
moisture.Mar = entity.ReviseMoisture;
moisture.ContainerNumber = entity.PositionNo.ToString();
moisture.ContainerWeight = entity.TrayWeight;
moisture.DryWeight = entity.LeftWeight;
moisture.AssayTime = entity.EndingTime;
moisture.WaterType = entity.SampleName == "全水样" ? "mt" : "mar";
moisture.DataFrom = "在线全水仪";
moisture.AssayUser = entity.Operator;
moisture.DeterMination = "在线全水仪";
res += Dbers.GetInstance().SelfDber.Insert(moisture);
}
else
{
moisture.FacilityNumber = this.MachineCode;
moisture.SampleNumber = entity.SampleNo;
moisture.SampleWeight = entity.SampleWeight;
moisture.Mar = entity.ReviseMoisture;
moisture.ContainerNumber = entity.PositionNo.ToString();
moisture.ContainerWeight = entity.TrayWeight;
moisture.DryWeight = entity.LeftWeight;
moisture.AssayTime = entity.EndingTime;
moisture.WaterType = entity.SampleName == "全水样" ? "mt" : "mar";
moisture.DataFrom = "在线全水仪";
moisture.AssayUser = entity.Operator;
res += Dbers.GetInstance().SelfDber.Update(moisture);
}
output(string.Format("同步全水测试记录 {0} 条", res), eOutputType.Normal);
}
}
/// <summary>
/// 保存标准水分仪数据
/// </summary>
/// <param name="output"></param>
/// <returns></returns>
public int SaveToMoistureAssay(Action <string, eOutputType> output, Int32 days)
{
int res = 0;
// .水分仪 型号：5E-MW6510
foreach (SFY_5EMW6510 entity in Dbers.GetInstance().SelfDber.Entities <SFY_5EMW6510>("where TestDate>= :TestTime and SampleNo is not null", new { TestTime = DateTime.Now.AddDays(-days).Date }))
{
string pkid = entity.PKID;
CmcsMoistureAssay item = Dbers.GetInstance().SelfDber.Entity <CmcsMoistureAssay>("where PKID=:PKID", new { PKID = pkid });
if (item == null)
{
item = new CmcsMoistureAssay();
item.SampleNumber = entity.SampleNo;
item.FacilityNumber = entity.DeviceNo;
item.ContainerWeight = 0;
item.SampleWeight = entity.MtMass;
item.Mar = entity.Mt;
item.AssayUser = entity.TestMan;
item.IsEffective = 0;
item.PKID = pkid;
item.AssayTime = entity.TestDate;
item.WaterType = entity.MType.Contains("全水") ? "全水分" : "分析水";
res += Dbers.GetInstance().SelfDber.Insert <CmcsMoistureAssay>(item);
}
else
{
item.SampleNumber = entity.SampleNo;
item.FacilityNumber = entity.DeviceNo;
item.ContainerWeight = 0;
item.SampleWeight = entity.MtMass;
item.Mar = entity.Mt;
item.AssayUser = entity.TestMan;
item.AssayTime = entity.TestDate;
item.WaterType = entity.MType.Contains("全水") ? "全水分" : "分析水";
res += Dbers.GetInstance().SelfDber.Update <CmcsMoistureAssay>(item);
}
}
output(string.Format("生成标准水分仪数据 {0} 条", res), eOutputType.Normal);
return(res);
}
