/// <summary>
/// 同步全过程基础信息(更换挂车记录)
/// </summary>
public void SyncBaseInfoForcCLGLLSPZ(Action <string, eOutputType> output, SqlServerDapperDber sqlDapperDber)
{
int res = 0;
try
{
foreach (View_chlgl_lspz qgc_lspz in sqlDapperDber.Entities <View_chlgl_lspz>())
{
if (commonDAO.SelfDber.Get <View_chlgl_lspz>(qgc_lspz.Chlgl_id.ToString()) != null)
{
commonDAO.SelfDber.Update <View_chlgl_lspz>(qgc_lspz);
}
else
{
commonDAO.SelfDber.Insert <View_chlgl_lspz>(qgc_lspz);
}
res++;
}
}
catch (Exception ex)
{
output("同步更换挂车记录报错，" + ex.Message, eOutputType.Error);
}
output(string.Format("同步更换挂车记录{0}条", res), eOutputType.Normal);
}
/// <summary>
/// 同步全过程基础信息(汽车来煤预归批)
/// </summary>
public void SyncBaseInfoForQCLMYGP(Action <string, eOutputType> output, SqlServerDapperDber sqlDapperDber)
{
int res = 0;
try
{
foreach (View_rlgl_cygl_qclmygp qgc_qclmygp in sqlDapperDber.Entities <View_rlgl_cygl_qclmygp>())
{
if (commonDAO.SelfDber.Get <View_rlgl_cygl_qclmygp>(qgc_qclmygp.Dbid.ToString()) != null)
{
commonDAO.SelfDber.Update <View_rlgl_cygl_qclmygp>(qgc_qclmygp);
}
else
{
commonDAO.SelfDber.Insert <View_rlgl_cygl_qclmygp>(qgc_qclmygp);
}
res++;
}
}
catch (Exception ex)
{
output("同步汽车来煤预归批报错，" + ex.Message, eOutputType.Error);
}
output(string.Format("同步汽车来煤预归批{0}条", res), eOutputType.Normal);
}
/// <summary>
/// 同步全过程物资车信息(物资车信息)
/// </summary>
public void SyncBaseInfoForWZJHCL(Action <string, eOutputType> output, SqlServerDapperDber sqlDapperDber)
{
int res = 0;
try
{
foreach (View_rlgl_wzjh_cl qgc_wzjhcl in sqlDapperDber.Entities <View_rlgl_wzjh_cl>())
{
if (commonDAO.SelfDber.Get <View_rlgl_wzjh_cl>(qgc_wzjhcl.Dbid.ToString()) != null)
{
commonDAO.SelfDber.Update <View_rlgl_wzjh_cl>(qgc_wzjhcl);
}
else
{
commonDAO.SelfDber.Insert <View_rlgl_wzjh_cl>(qgc_wzjhcl);
}
res++;
}
}
catch (Exception ex)
{
output("同步物资车信息报错，" + ex.Message, eOutputType.Error);
}
output(string.Format("同步物资车信息{0}条", res), eOutputType.Normal);
}
/// <summary>
/// 同步全过程基础信息(调运计划卡)
/// </summary>
public void SyncBaseInfoForDYJHK(Action <string, eOutputType> output, SqlServerDapperDber sqlDapperDber)
{
int res = 0;
try
{
foreach (View_dyjhk qgc_dyjh in sqlDapperDber.Entities <View_dyjhk>())
{
if (commonDAO.SelfDber.Get <View_dyjhk>(qgc_dyjh.Dbid.ToString()) != null)
{
commonDAO.SelfDber.Update <View_dyjhk>(qgc_dyjh);
}
else
{
commonDAO.SelfDber.Insert <View_dyjhk>(qgc_dyjh);
}
res++;
}
}
catch (Exception ex)
{
output("同步调运计划卡报错，" + ex.Message, eOutputType.Error);
}
output(string.Format("同步调运计划卡{0}条", res), eOutputType.Normal);
}
/// <summary>
/// 同步全过程基础信息(车辆基本信息)
/// </summary>
public void SyncBaseInfoForCHLGL(Action <string, eOutputType> output, SqlServerDapperDber sqlDapperDber)
{
int res = 0;
try
{
foreach (View_rlgl_chlgl_chlgl qgc_chlgl in sqlDapperDber.Entities <View_rlgl_chlgl_chlgl>())
{
if (commonDAO.SelfDber.Get <View_rlgl_chlgl_chlgl>(qgc_chlgl.Dbid.ToString()) != null)
{
commonDAO.SelfDber.Update <View_rlgl_chlgl_chlgl>(qgc_chlgl);
}
else
{
commonDAO.SelfDber.Insert <View_rlgl_chlgl_chlgl>(qgc_chlgl);
}
CmcsAutotruck cmcsAutotruck = commonDAO.SelfDber.Entity <CmcsAutotruck>("where CarNumber=:CarNumber", new { CarNumber = qgc_chlgl.Chph });
if (cmcsAutotruck == null)
{
commonDAO.SelfDber.Insert(new CmcsAutotruck()
{
CarNumber = qgc_chlgl.Chph,
EPCCardId = qgc_chlgl.Rfid_xlh,
CarMaxWeight = qgc_chlgl.Hzl,
Is_hmd = qgc_chlgl.Is_hmd,
BX_EndDate = qgc_chlgl.Bx_enddate,
Xshzh_EndDate = qgc_chlgl.Xshzh_enddate,
Zgzh_EndDate = qgc_chlgl.Zgzh_enddate,
IsUse = 1,
CarType = qgc_chlgl.Cllx == 965 ? "入厂煤" : "其他物资"
});
}
else
{
cmcsAutotruck.CarNumber = qgc_chlgl.Chph;
cmcsAutotruck.EPCCardId = qgc_chlgl.Rfid_xlh;
cmcsAutotruck.CarMaxWeight = qgc_chlgl.Hzl;
cmcsAutotruck.Is_hmd = qgc_chlgl.Is_hmd;
cmcsAutotruck.BX_EndDate = qgc_chlgl.Bx_enddate;
cmcsAutotruck.Xshzh_EndDate = qgc_chlgl.Xshzh_enddate;
cmcsAutotruck.Zgzh_EndDate = qgc_chlgl.Zgzh_enddate;
cmcsAutotruck.IsUse = 1;
cmcsAutotruck.CarType = qgc_chlgl.Cllx == 965 ? "入厂煤" : "其他物资";
commonDAO.SelfDber.Update(cmcsAutotruck);
}
res++;
}
}
catch (Exception ex)
{
output("同步车辆基本信息报错，" + ex.Message, eOutputType.Error);
}
output(string.Format("同步车辆基本信息{0}条", res), eOutputType.Normal);
}
private void CmdHandle(EquPDCYJUnloadCmd input)
{
Task task = new Task((state) =>
{
EquPDCYJUnloadCmd pDCYJUnloadCmd = state as EquPDCYJUnloadCmd;
OutputRunInfo(rtxtOutput, "处理卸样命令，采样码：" + pDCYJUnloadCmd.SampleCode);
// 更新系统状态为正在卸样
dber.Execute("update " + EntityReflectionUtil.GetTableName <EquPDCYJSignal>() + " set TagValue=@TagValue where MachineCode=@MachineCode and TagName=@TagName", new { MachineCode = pDCYJUnloadCmd.MachineCode, TagName = eSignalDataName.设备状态.ToString(), TagValue = eEquInfSamplerSystemStatus.正在卸样.ToString() });
Thread.Sleep(3000);
foreach (EquPDCYJBarrel pDCYJBarrel in dber.Entities <EquPDCYJBarrel>("where SampleCode=@SampleCode", new { SampleCode = pDCYJUnloadCmd.SampleCode }))
{
// 生成卸样结果
dber.Insert(new EquPDCYJUnloadResult
{
DataFlag = 0,
SampleCode = pDCYJUnloadCmd.SampleCode,
UnloadTime = DateTime.Now,
//BarrelNumber = pDCYJBarrel.BarrelNumber,
BarrelCode = Guid.NewGuid().ToString().Substring(0, 8).ToUpper(),
//SamplingId = pDCYJUnloadCmd.SamplingId,
MachineCode = pDCYJBarrel.MachineCode
});
pDCYJBarrel.SampleCount = 0;
pDCYJBarrel.InFactoryBatchId = string.Empty;
pDCYJBarrel.SampleCode = string.Empty;
pDCYJBarrel.BarrelStatus = eSampleBarrelStatus.空桶.ToString();
pDCYJBarrel.UpdateTime = DateTime.Now;
pDCYJBarrel.DataFlag = 0;
if (dber.Update(pDCYJBarrel) > 0)
{
OutputRunInfo(rtxtOutput, "卸样完成，罐号：" + pDCYJBarrel.BarrelNumber.ToString() + " " + pDCYJBarrel.BarrelType.ToString());
}
Thread.Sleep(1500);
}
// 更新命令
pDCYJUnloadCmd.ResultCode = eEquInfCmdResultCode.成功.ToString();
pDCYJUnloadCmd.DataFlag = 2;
dber.Update(pDCYJUnloadCmd);
OutputRunInfo(rtxtOutput, "卸样完成");
autoResetEvent.Set();
}, input);
task.Start();
}
/// <summary>
/// 同步全过程基础信息(公司信息)
/// </summary>
public void SyncBaseInfoForGS(Action <string, eOutputType> output, SqlServerDapperDber sqlDapperDber)
{
int res = 0;
try
{
foreach (View_rlgl_dygl_gs qgc_gs in sqlDapperDber.Entities <View_rlgl_dygl_gs>())
{
if (commonDAO.SelfDber.Get <View_rlgl_dygl_gs>(qgc_gs.Dbid.ToString()) != null)
{
commonDAO.SelfDber.Update <View_rlgl_dygl_gs>(qgc_gs);
}
else
{
commonDAO.SelfDber.Insert <View_rlgl_dygl_gs>(qgc_gs);
}
CmcsSupplier cmcsSupplier = commonDAO.SelfDber.Entity <CmcsSupplier>("where PkId=:PkId", new { PkId = qgc_gs.Dbid });
if (cmcsSupplier == null)
{
commonDAO.SelfDber.Insert(new CmcsSupplier()
{
PkId = qgc_gs.Dbid,
TaxregCode = qgc_gs.Taxnumber,
Name = qgc_gs.Corpname,
ShortName = qgc_gs.Corpshortname,
Code = qgc_gs.Gys,
Is_fhdw = qgc_gs.Is_fhdw,
is_shhdw = qgc_gs.Is_shhdw
});
}
else
{
cmcsSupplier.PkId = qgc_gs.Dbid;
cmcsSupplier.TaxregCode = qgc_gs.Taxnumber;
cmcsSupplier.Name = qgc_gs.Corpname;
cmcsSupplier.ShortName = qgc_gs.Corpshortname;
cmcsSupplier.Code = qgc_gs.Gys;
cmcsSupplier.Is_fhdw = qgc_gs.Is_fhdw;
cmcsSupplier.is_shhdw = qgc_gs.Is_shhdw;
commonDAO.SelfDber.Update(cmcsSupplier);
}
res++;
}
}
catch (Exception ex)
{
output("同步公司信息报错，" + ex.Message, eOutputType.Error);
}
output(string.Format("同步公司信息{0}条", res), eOutputType.Normal);
}
/// <summary>
/// 同步全过程基础信息(货物信息)
/// </summary>
public void SyncBaseInfoForHW(Action <string, eOutputType> output, SqlServerDapperDber sqlDapperDber)
{
int res = 0;
try
{
foreach (View_rlgl_dygl_hw qgc_hw in sqlDapperDber.Entities <View_rlgl_dygl_hw>())
{
if (commonDAO.SelfDber.Get <View_rlgl_dygl_hw>(qgc_hw.Dbid.ToString()) != null)
{
commonDAO.SelfDber.Update <View_rlgl_dygl_hw>(qgc_hw);
}
else
{
commonDAO.SelfDber.Insert <View_rlgl_dygl_hw>(qgc_hw);
}
CmcsFuelKind cmcsFuelKind = commonDAO.SelfDber.Entity <CmcsFuelKind>("where PkId=:PkId", new { PkId = qgc_hw.Dbid });
if (cmcsFuelKind == null)
{
commonDAO.SelfDber.Insert(new CmcsFuelKind()
{
ParentId = "-1",
PkId = qgc_hw.Dbid,
Code = qgc_hw.Productcode,
Name = qgc_hw.Productname,
Mzbh = qgc_hw.Mzbh,
WLType = qgc_hw.Wltype
});
}
else
{
cmcsFuelKind.PkId = qgc_hw.Dbid;
cmcsFuelKind.Code = qgc_hw.Productcode;
cmcsFuelKind.Name = qgc_hw.Productname;
cmcsFuelKind.Mzbh = qgc_hw.Mzbh;
cmcsFuelKind.WLType = qgc_hw.Wltype;
commonDAO.SelfDber.Update(cmcsFuelKind);
}
res++;
}
}
catch (Exception ex)
{
output("同步货物信息报错，" + ex.Message, eOutputType.Error);
}
output(string.Format("同步货物信息{0}条", res), eOutputType.Normal);
}
/// <summary>
/// 同步全过程基础信息(煤种信息)
/// </summary>
public void SyncBaseInfoForMZ(Action <string, eOutputType> output, SqlServerDapperDber sqlDapperDber)
{
int res = 0;
try
{
foreach (View_mz qgc_mz in sqlDapperDber.Entities <View_mz>())
{
if (commonDAO.SelfDber.Get <View_mz>(qgc_mz.Dbid.ToString()) != null)
{
commonDAO.SelfDber.Update <View_mz>(qgc_mz);
}
else
{
commonDAO.SelfDber.Insert <View_mz>(qgc_mz);
}
CmcsFuelKind cmcsFuelKind = commonDAO.SelfDber.Entity <CmcsFuelKind>("where PkId=:PkId", new { PkId = qgc_mz.Dbid });
if (cmcsFuelKind == null)
{
commonDAO.SelfDber.Insert(new CmcsFuelKind()
{
ParentId = "-1",
PkId = qgc_mz.Dbid,
Code = qgc_mz.Mzbm,
Name = qgc_mz.Mzmc,
IsStop = int.Parse(qgc_mz.Is_valid)
});
}
else
{
cmcsFuelKind.ParentId = "-1";
cmcsFuelKind.PkId = qgc_mz.Dbid;
cmcsFuelKind.Code = qgc_mz.Mzbm;
cmcsFuelKind.Name = qgc_mz.Mzmc;
cmcsFuelKind.IsStop = int.Parse(qgc_mz.Is_valid);
commonDAO.SelfDber.Update(cmcsFuelKind);
}
res++;
}
}
catch (Exception ex)
{
output("同步煤种信息报错，" + ex.Message, eOutputType.Error);
}
output(string.Format("同步煤种信息{0}条", res), eOutputType.Normal);
}
/// <summary>
/// 同步全过程基础信息(承运商信息)
/// </summary>
public void SyncBaseInfoForCHYSH(Action <string, eOutputType> output, SqlServerDapperDber sqlDapperDber)
{
int res = 0;
try
{
foreach (View_rlgl_dygl_chysh qgc_chysh in sqlDapperDber.Entities <View_rlgl_dygl_chysh>())
{
if (commonDAO.SelfDber.Get <View_rlgl_dygl_chysh>(qgc_chysh.Dbid.ToString()) != null)
{
commonDAO.SelfDber.Update <View_rlgl_dygl_chysh>(qgc_chysh);
}
else
{
commonDAO.SelfDber.Insert <View_rlgl_dygl_chysh>(qgc_chysh);
}
CmcsTransportCompany cmcsTransportCompany = commonDAO.SelfDber.Entity <CmcsTransportCompany>("where PkId=:PkId", new { PkId = qgc_chysh.Dbid });
if (cmcsTransportCompany == null)
{
commonDAO.SelfDber.Insert(new CmcsTransportCompany()
{
PkId = qgc_chysh.Dbid,
ShipperTaxNumber = qgc_chysh.Shippertaxnumber,
Name = qgc_chysh.Shipername,
PlanNo = qgc_chysh.Planno,
Code = qgc_chysh.Gys
});
}
else
{
cmcsTransportCompany.PkId = qgc_chysh.Dbid;
cmcsTransportCompany.ShipperTaxNumber = qgc_chysh.Shippertaxnumber;
cmcsTransportCompany.Name = qgc_chysh.Shipername;
cmcsTransportCompany.PlanNo = qgc_chysh.Planno;
cmcsTransportCompany.Code = qgc_chysh.Gys;
commonDAO.SelfDber.Update(cmcsTransportCompany);
}
res++;
}
}
catch (Exception ex)
{
output("同步承运商信息报错，" + ex.Message, eOutputType.Error);
}
output(string.Format("同步承运商信息{0}条", res), eOutputType.Normal);
}
/// <summary>
/// 同步全过程基础信息(供应商信息)
/// </summary>
public void SyncBaseInfoForGYS(Action <string, eOutputType> output, SqlServerDapperDber sqlDapperDber)
{
int res = 0;
try
{
foreach (View_gys qgc_gys in sqlDapperDber.Entities <View_gys>())
{
if (commonDAO.SelfDber.Get <View_gys>(qgc_gys.Dbid.ToString()) != null)
{
commonDAO.SelfDber.Update <View_gys>(qgc_gys);
}
else
{
commonDAO.SelfDber.Insert <View_gys>(qgc_gys);
}
CmcsSupplier cmcsSupplier = commonDAO.SelfDber.Entity <CmcsSupplier>("where PkId=:PkId", new { PkId = qgc_gys.Dbid });
if (cmcsSupplier == null)
{
commonDAO.SelfDber.Insert(new CmcsSupplier()
{
PkId = qgc_gys.Dbid,
Name = qgc_gys.Gysqc,
ShortName = qgc_gys.Gysjc,
Code = qgc_gys.Gysbm,
IsStop = int.Parse(qgc_gys.Is_valid)
});
}
else
{
cmcsSupplier.PkId = qgc_gys.Dbid;
cmcsSupplier.Name = qgc_gys.Gysqc;
cmcsSupplier.ShortName = qgc_gys.Gysjc;
cmcsSupplier.Code = qgc_gys.Gysbm;
cmcsSupplier.IsStop = int.Parse(qgc_gys.Is_valid);
commonDAO.SelfDber.Update(cmcsSupplier);
}
CmcsTransportCompany cmcsTransportCompany = commonDAO.SelfDber.Entity <CmcsTransportCompany>("where PkId=:PkId", new { PkId = qgc_gys.Dbid });
if (cmcsTransportCompany == null)
{
commonDAO.SelfDber.Insert(new CmcsTransportCompany()
{
PkId = qgc_gys.Dbid,
Name = qgc_gys.Gysqc,
IsStop = int.Parse(qgc_gys.Is_valid),
Code = qgc_gys.Gysbm
});
}
else
{
cmcsTransportCompany.PkId = qgc_gys.Dbid;
cmcsTransportCompany.Name = qgc_gys.Gysqc;
cmcsTransportCompany.IsStop = int.Parse(qgc_gys.Is_valid);
cmcsTransportCompany.Code = qgc_gys.Gysbm;
commonDAO.SelfDber.Update(cmcsTransportCompany);
}
res++;
}
}
catch (Exception ex)
{
output("同步供应商信息报错，" + ex.Message, eOutputType.Error);
}
output(string.Format("同步供应商信息{0}条", res), eOutputType.Normal);
}
private void Bind_TB_YQ_ERRORCODE()
{
List <TB_YQ_ERRORCODE> list = equDber.Entities <TB_YQ_ERRORCODE>();
SGC_TB_YQ_ERRORCODE.PrimaryGrid.DataSource = list;
}
private void Bind_SAMPLE_INTERFACE_DATA()
{
List <Interface_Data> list = equDber.Entities <Interface_Data>();
SGC_SAMPLE_INTERFACE_DATA.PrimaryGrid.DataSource = list;
}
private void Bind_tb_bolt()
{
List <Tb_Bolt> list = equDber.Entities <Tb_Bolt>();
SGC_tb_bolt.PrimaryGrid.DataSource = list;
}
private void Bind_EquTbHCQSCYJBarrel()
{
List <EquHCQSCYJBarrel> list = equDber.Entities <EquHCQSCYJBarrel>();
SGC_EquTbHCQSCYJBarrel.PrimaryGrid.DataSource = list;
}
private void Bind_ZY_Status_Tb()
{
List <ZY_Status_Tb> list = equDber.Entities <ZY_Status_Tb>();
SGC_ZY_Status_Tb.PrimaryGrid.DataSource = list;
}
