/// <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; }