Пример #1
0
        //根据用户id得到用户名
        private string GetConsumer(string UserId, AccessDapperDber doorDapperDber)
        {
            string    sql = " select name from userinfo where Badgenumber='" + UserId + "'";
            DataTable dt  = doorDapperDber.ExecuteDataTable(sql);

            if (dt != null && dt.Rows.Count > 0)
            {
                return(dt.Rows[0][0].ToString());
            }
            return("");
        }
Пример #2
0
        private string GetMachine(string MachineId, AccessDapperDber doorDapperDber)
        {
            string    sql = " select MachineAlias from Machines where id=" + MachineId + "";
            DataTable dt  = doorDapperDber.ExecuteDataTable(sql);

            if (dt != null && dt.Rows.Count > 0)
            {
                return(dt.Rows[0][0].ToString());
            }
            return("");
        }
Пример #3
0
        /// <summary>
        /// 默认取当前月份轨道衡的数据
        /// </summary>
        /// <param name="argConn">Access数据库连接串</param>
        /// <returns></returns>
        private DataTable getData(AccessDapperDber argConn)
        {
            DataTable dt        = new DataTable();
            int       tempMonth = DateTime.Now.Month;//取当前日期的月份
            int       tempDay   = -CommonDAO.GetInstance().GetAppletConfigInt32("轨道衡数据读取天数");
            string    sql       = string.Format(@"select * from {0} where 发货单位 <> '' and 收货单位 <> '' and 时间 > '{1}'", tempMonth,
                                                getCurrentTime(DateTime.Now.AddDays(tempDay)));

            dt = argConn.ExecuteDataTable(sql);
            return(dt);
        }
Пример #4
0
        private DcDbers()
        {
            BeltSampler_Dber       = new SqlServerDapperDber(commonDAO.GetCommonAppletConfigString("皮带采样机接口连接字符串"));
            AutoCupboard_Dber      = new SqlServerDapperDber(commonDAO.GetCommonAppletConfigString("智能存样柜接口连接字符串"));
            PneumaticTransfer_Dber = new SqlServerDapperDber(commonDAO.GetCommonAppletConfigString("气动传输接口连接字符串"));

            WeightBridger_Dber = new SqlServerDapperDber(commonDAO.GetCommonAppletConfigString("轨道衡数据库连接字符串"));
            CarJXSampler_Dber1 = new SqlServerDapperDber(commonDAO.GetCommonAppletConfigString("#1汽车机械采样机接口连接字符串"));
            CarJXSampler_Dber2 = new SqlServerDapperDber(commonDAO.GetCommonAppletConfigString("#2汽车机械采样机接口连接字符串"));

            WeightBridger_Dber1 = new AccessDapperDber(string.Format(commonDAO.GetAppletConfigString("轨道衡数据库连接字符串1"), DateTime.Now.Year));
        }
Пример #5
0
        /// <summary>
        /// 同步门禁数据
        /// </summary>
        /// <param name="output"></param>
        public void SyncDoorData(Action <string, eOutputType> output, AccessDapperDber doorDapperDber)
        {
            int res = 0;

            string sql = " select * from acc_monitor_log where time>#2018-08-08#";

            sql += " order by time";
            DataTable dtNum = doorDapperDber.ExecuteDataTable(sql);

            if (dtNum.Rows.Count > 0)
            {
                for (int i = 0; i < dtNum.Rows.Count; i++)
                {
                    string id       = dtNum.Rows[i]["id"].ToString();
                    string userId   = dtNum.Rows[i]["pin"].ToString();
                    string deviceId = dtNum.Rows[i]["device_id"].ToString();

                    string consumerName = GetConsumer(userId, doorDapperDber);
                    string doorName     = GetMachine(deviceId, doorDapperDber);

                    if (string.IsNullOrEmpty(consumerName))
                    {
                        continue;
                    }
                    if (string.IsNullOrEmpty(doorName))
                    {
                        continue;
                    }

                    CmcsGuardInfo entity = Dbers.GetInstance().SelfDber.Entity <CmcsGuardInfo>("where NId=:NId", new { NId = id });
                    if (entity == null)
                    {
                        entity = new CmcsGuardInfo()
                        {
                            DataFrom       = "智能化",
                            F_ConsumerId   = userId,
                            F_ConsumerName = consumerName,
                            F_InOut        = "1",
                            F_ReaderId     = deviceId,
                            F_ReaderName   = doorName,
                            NId            = id,
                            F_ReadDate     = DateTime.Parse(dtNum.Rows[i]["time"].ToString())
                        };

                        res += Dbers.GetInstance().SelfDber.Insert(entity);
                    }
                }
            }
            output(string.Format("同步门禁数据{0}条", res), eOutputType.Normal);
        }
Пример #6
0
        /// <summary>
        /// 执行所有任务
        /// </summary>
        void ExecuteAllTask()
        {
            DataHandlerDAO dataHandlerDAO = DataHandlerDAO.GetInstance();

            taskSimpleScheduler.StartNewTask("同步批次明细", () =>
            {
                dataHandlerDAO.SyncToBatch(this.rTxtOutputer.Output);
            }, 60000, OutputError);

            taskSimpleScheduler.StartNewTask("同步集控信号", () =>
            {
                dataHandlerDAO.SyncHomePageSignalData(this.rTxtOutputer.Output);
            }, 60000, OutputError);

            AccessDapperDber doorDapperDber = new AccessDapperDber("Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info =true;Data Source=\\\\10.36.0.71\\ZKAccess3.5\\ZKAccess.mdb;");

            taskSimpleScheduler.StartNewTask("同步门禁数据", () =>
            {
                //dataHandlerDAO.SyncDoorData(this.rTxtOutputer.Output, doorDapperDber);
            }, 60000, OutputError);
        }
Пример #7
0
        public override System.Data.DataTable ExecuteGrab()
        {
            AccessDapperDber accessDber = new AccessDapperDber(ConnStr);

            return(accessDber.ExecuteDataTable("select * from sample where Date > #" + DateTime.Now.AddDays(-DayRange).ToString("yyyy-MM-dd") + "#"));
        }
Пример #8
0
        /// <summary>
        /// 同步集样罐信息到集中管控
        /// </summary>
        /// <param name="output"></param>
        /// <returns></returns>
        public void SyncBarrel(Action <string, eOutputType> output, AccessDapperDber accessDapperDber)
        {
            int res = 0;


            DataTable infpdcybarrels = accessDapperDber.ExecuteDataTable("select * from 桶号点数");

            if (infpdcybarrels != null && infpdcybarrels.Rows.Count > 0)
            {
                for (int i = 0; i < infpdcybarrels.Rows.Count; i++)
                {
                    InfEquInfSampleBarrel oldEquInfSampleBarrel = Dbers.GetInstance().SelfDber.Entity <InfEquInfSampleBarrel>("where MachineCode=:MachineCode and BarrelNumber=:BarrelNumber"
                                                                                                                              , new { MachineCode = this.MachineCode, BarrelNumber = infpdcybarrels.Rows[i]["桶号"].ToString() });

                    if (oldEquInfSampleBarrel == null)
                    {
                        InfEquInfSampleBarrel entity = new InfEquInfSampleBarrel();

                        entity.BarrelNumber = infpdcybarrels.Rows[i]["桶号"].ToString();

                        entity.SampleCount  = Convert.ToInt32(infpdcybarrels.Rows[i]["点数"].ToString());
                        entity.BarrelStatus = entity.SampleCount > 0 ? "未满" : "空桶";
                        DataTable dtSetUp = accessDapperDber.ExecuteDataTable("select * from 系统参数");
                        if (dtSetUp != null && dtSetUp.Rows.Count > 0)
                        {
                            int count = Convert.ToInt32(dtSetUp.Rows[0]["盛样点数"].ToString());
                            if (entity.SampleCount == count)
                            {
                                entity.BarrelStatus = "已满";
                            }
                        }


                        entity.MachineCode = this.MachineCode;
                        //InFactoryBatchId = entity.InFactoryBatchId,
                        entity.InterfaceType = commonDAO.GetMachineInterfaceTypeByCode(this.MachineCode);

                        string dqth = commonDAO.GetSignalDataValue(MachineCode, "当前桶号");
                        if (entity.BarrelNumber == dqth)
                        {
                            entity.IsCurrent = 1;
                        }
                        else
                        {
                            entity.IsCurrent = 0;
                        }

                        entity.SampleCode = infpdcybarrels.Rows[i]["单位"].ToString();

                        entity.UpdateTime = DateTime.Now;
                        //BarrelType = entity.BarrelType,
                        if (Dbers.GetInstance().SelfDber.Insert(entity) > 0)
                        {
                            res++;
                        }
                        ;
                    }
                    else
                    {
                        oldEquInfSampleBarrel.BarrelNumber = infpdcybarrels.Rows[i]["桶号"].ToString();
                        oldEquInfSampleBarrel.SampleCount  = Convert.ToInt32(infpdcybarrels.Rows[i]["点数"].ToString());
                        oldEquInfSampleBarrel.BarrelStatus = oldEquInfSampleBarrel.SampleCount > 0 ? "未满" : "空桶";

                        DataTable dtSetUp = accessDapperDber.ExecuteDataTable("select * from 系统参数");
                        if (dtSetUp != null && dtSetUp.Rows.Count > 0)
                        {
                            int count = Convert.ToInt32(dtSetUp.Rows[0]["盛样点数"].ToString());
                            if (oldEquInfSampleBarrel.SampleCount == count)
                            {
                                oldEquInfSampleBarrel.BarrelStatus = "已满";
                            }
                        }

                        //oldEquInfSampleBarrel.InFactoryBatchId = equInfSampleBarrel.InFactoryBatchId;

                        string dqth = commonDAO.GetSignalDataValue(MachineCode, "当前桶号");
                        if (oldEquInfSampleBarrel.BarrelNumber == dqth)
                        {
                            oldEquInfSampleBarrel.IsCurrent = 1;
                        }
                        else
                        {
                            oldEquInfSampleBarrel.IsCurrent = 0;
                        }

                        oldEquInfSampleBarrel.SampleCode = infpdcybarrels.Rows[i]["单位"].ToString();
                        oldEquInfSampleBarrel.UpdateTime = DateTime.Now;
                        //oldEquInfSampleBarrel.DataFlag = equInfSampleBarrel.DataFlag;

                        if (Dbers.GetInstance().SelfDber.Update(oldEquInfSampleBarrel) > 0)
                        {
                            res++;
                        }
                    }



                    //{

                    //	entity.DataFlag = 1;
                    //	DcDbers.GetInstance().CarJXSampler_Dber.Update(entity);

                    //	res++;
                    //}
                }
            }


            output(string.Format("同步集样罐记录 {0} 条", res), eOutputType.Normal);
        }