Пример #1
0
        public bool addDeviceInformationDao(bean.manageHose hm)
        {
            string id;
            string id0;
            int    flag = 0;
            string wd1  = "35.0";
            string wd2  = "0.0";
            string sd1  = "75.0";
            string sd2  = "35.0";
            string cd   = null;
            string m    = null;
            int    ret  = 0;
            String sql  = "insert into lb_device_information (id,measureCode,meterNo,terminalname,house_code,housetype,t_high,t_low,h_high,h_low,powerflag,createtime,State) values ";
            String sql0 = "insert into lb_base_data_home (id,measureCode,meterNo,devtime,temperature,humidity,lng,lat,createDate,warnState,sign,measureMeterCode,warningistrue,carinterval,houseinterval,mcc,measureNo) values ";

            int    num  = Int32.Parse(hm.portNumber);
            string time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

            for (int j = 0; j < num; j++)
            {
                if (j < 10)
                {
                    if (hm.CommunicationType == "串口通讯协议" || hm.CommunicationType == "TCP协议" || hm.CommunicationType == "云平台协议-01")
                    {
                        if (j + 1 == 10)
                        {
                            m = (j + 1).ToString();
                        }
                        else
                        {
                            m = "0" + (j + 1).ToString();
                        }
                    }
                    else
                    {
                        if (hm.CommunicationType == "云平台协议-00")
                        {
                            if (num == 1)
                            {
                                m = "00";
                            }
                            else
                            {
                                m = "0" + j.ToString();
                            }
                        }
                    }
                    cd += hm.hostName + "-" + m;
                }
                else
                {
                    if (hm.CommunicationType == "串口通讯协议" || hm.CommunicationType == "TCP协议" || hm.CommunicationType == "云平台协议-01")
                    {
                        m = (j + 1).ToString();
                    }
                    else
                    {
                        m = j.ToString();
                    }
                    cd += hm.hostName + "-" + m;
                }
                id  = Result.GetNewId();
                id0 = Result.GetNewId();
                int measureNo = System.Math.Abs(id.GetHashCode());
                measureNo = Int32.Parse(measureNo.ToString().Substring(0, 5));
                if (j > 0)
                {
                    sql  += " ,('" + id + "','" + hm.measureCode + "', '" + m + "', '" + cd + "','" + hm.houseType + "', '" + 0 + "', '" + wd1 + "', '" + wd2 + "', '" + sd1 + "', '" + sd2 + "', '" + flag + "', '" + time + "', '" + hm.State + "')";
                    sql0 += " , ('" + id0 + "','" + hm.measureCode + "', '" + m + "','" + time + "','0.0','0.0','','','" + time + "','','',CONCAT('" + hm.measureCode + "', '_', '" + m + "'),'','','','0','" + measureNo + "')";
                }
                else
                {
                    sql  += "('" + id + "','" + hm.measureCode + "', '" + m + "', '" + cd + "','" + hm.houseType + "', '" + 0 + "', '" + wd1 + "', '" + wd2 + "', '" + sd1 + "', '" + sd2 + "', '" + flag + "', '" + time + "', '" + hm.State + "')";
                    sql0 += "('" + id0 + "','" + hm.measureCode + "', '" + m + "','" + time + "','0.0','0.0','','','" + time + "','','',CONCAT('" + hm.measureCode + "', '_', '" + m + "'),'','','','0','" + measureNo + "')";
                }
                cd = null;
            }
            ret = DbHelperMySQL.ExecuteSql(sql);
            if (ret > 0)
            {
                ret = DbHelperMySQL.ExecuteSql(sql0);
            }


            return(ret == 0 ? false : true);
        }
Пример #2
0
        public void deleteInvalidData()
        {
            String sql1 = " delete from lb_base_data_home where warnState != '1' and warnState != '3' and warningistrue != '1'  and warningistrue != '2' and warningistrue != '3'  and houseinterval < 1  and carinterval < 1";

            DbHelperMySQL.ExecuteSql(sql1);
        }