Ejemplo n.º 1
0
 //�ظ���ע
 private void C_Pos_PlaceMark(DataClient dataClient, String rec)
 {
     try
     {
         StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_POS).Append(Constant.C_POS_PLACE_MARK);
         String[] para = rec.Split(Constant.SPLIT1);
         if(dbm.ExecuteUpdate("insert_place '" + para[0] + "','" + para[1] + "','" + para[2] + "'"))
             stb.Append(Constant.RESULT_OK).Append(Constant.FOOT);
         else stb.Append(Constant.RESULT_FAIL).Append(Constant.FOOT);
         dataClient.Send(stb.ToString());
         String us = "";
         if(dataClient.LoginUser != null)
             us = dataClient.LoginUser.UserName;
         else if(dataClient.LoginTeam != null)
             us = dataClient.LoginTeam.TeamName;
         else if(dataClient.LoginCar != null)
             us = dataClient.LoginCar.CarNO;
         dbAssistant.AddOperation(us, "��ӱ�ע:���� " + para[0]);
     }
     catch(Exception e)
     {
         if(FormMain.LOG_ERR)
             logger.AddErr(e, "");
     }
 }
Ejemplo n.º 2
0
        //�ظ���ӳ���
        private void C_Info_AddCar(DataClient dataClient, String rec)
        {
            try
            {
                StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_INFO).Append(Constant.C_INFO_CAR_ADD);
                if((dataClient.LoginUser != null && dataClient.LoginUser.PolicyModCar == 1) || (dataClient.LoginTeam != null && dataClient.LoginTeam.PolicyModCar == 1))
                {
                    String[] para = rec.Split(Constant.SPLIT1);
                    Team team = GetTeamByID(Int32.Parse(para[0]));
                    Car car = Car.Parse(para[1]);
                    car.TeamID = team.TeamID;
                    car.Team = team;
                    if(car == null)
                    {
                        stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_ERR_INFO).Append(Constant.FOOT);
                        dataClient.Send(stb.ToString());
                        return;
                    }
                    Car car1 = CheckCarInfo(car);
                    if(car1 == null)
                    {
                        DataTable dt = dbm.ExecuteQuery(car.SqlInsertStr(team.TeamID));
                        if(dt != null)
                        {
                            car.CarID = Int32.Parse(dt.Rows[0][0].ToString());
                            car.Pos = new Position();
                            team.Cars.Add(car);

                            stb.Append(Constant.RESULT_OK).Append(Constant.FOOT);
                            dataClient.Send(stb.ToString());

                            StringBuilder stb1 = new StringBuilder(Constant.HEAD).Append(Constant.S_INFO).Append(Constant.S_INFO_CAR_ADD);
                            stb1.Append(team.TeamID).Append(Constant.SPLIT1).Append(car.ToString()).Append(Constant.FOOT);
                            String s1 = stb1.ToString();
                            DataClient[] tempList = dataClientList.ToArray();
                            foreach(DataClient dc in tempList)
                            {
                                if((dc.LoginUser != null && dc.LoginUser.GetTeamByID(team.TeamID) != null)
                                    || (dc.LoginTeam != null && dc.LoginTeam.TeamID == team.TeamID))
                                    dc.Send(s1);
                            }
                            String opUser = "";
                            if(dataClient.LoginUser != null)
                                opUser = "******" + dataClient.LoginUser.UserName;
                            else opUser = "******" + dataClient.LoginTeam.TeamName;
                            dbAssistant.AddOperation(opUser, "��ӳ���:���ƺ�" + car.CarNO);
                            return;
                        }
                        else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_UPDATE_DB).Append(Constant.FOOT);
                    }
                    else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_ECHO_INFO).Append(",�ѵǼǴ����ϵij���:").Append(car1.CarNO).Append(Constant.FOOT);
                }
                else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_NO_POLICY).Append(Constant.FOOT);
                dataClient.Send(stb.ToString());
            }
            catch(Exception e)
            {
                if(FormMain.LOG_ERR)
                    logger.AddErr(e, "");
            }
        }
Ejemplo n.º 3
0
 //�ظ�ɾ���ʺ�
 private void C_Info_DelAccount(DataClient dataClient, String rec)
 {
     try
     {
         StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_INFO).Append(Constant.C_INFO_ACCOUNT_DEL);
         if(dataClient.LoginUser != null && dataClient.LoginUser.UserType == User.USER_ADMIN)
         {
             User user = GetUserByID(Int32.Parse(rec));
             if(user != null && dbm.ExecuteUpdate(user.SqlDeleteStr()))
             {
                 DataClient[] tempList = dataClientList.ToArray();
                 foreach(DataClient dc in tempList)
                     if(dc.LoginUser == user)
                     {
                         dc.CloseConnection();
                         break;
                     }
                 userList.Remove(user);
                 stb.Append(Constant.RESULT_OK).Append(Constant.FOOT);
                 dbAssistant.AddOperation(dataClient.LoginUser.UserName, "ɾ���ʺ�:�û���" + user.UserName);
             }
             else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_UPDATE_DB).Append(Constant.FOOT);
         }
         else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_NO_POLICY).Append(Constant.FOOT);
         dataClient.Send(stb.ToString());
     }
     catch(Exception e)
     {
         if(FormMain.LOG_ERR)
             logger.AddErr(e, "");
     }
 }
Ejemplo n.º 4
0
 private void C_Declare_List(DataClient dataClient, String rec)
 {
     try
     {
         StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_DECLARE).Append(Constant.C_DECLARE_LIST);
         if(dataClient.LoginUser != null && dataClient.LoginUser.PolicyDeclare == 1)
         {
             Car car = GetCarByID(Int32.Parse(rec));
             if(car != null)
             {
                 DataTable dt = dbm.ExecuteQuery("select_declare " + rec);
                 if(dt.Rows.Count > 0)
                 {
                     foreach(DataRow dr in dt.Rows)
                     {
                         for(int i = 0; i < 12; i++)
                             stb.Append(dr[i].ToString()).Append(Constant.SPLIT2);
                         stb.Append(Constant.SPLIT1);
                     }
                     stb.Remove(stb.Length - 1, 1);
                 }
             }
         }
         stb.Append(Constant.FOOT);
         dataClient.Send(stb.ToString());
     }
     catch(Exception e)
     {
         if(FormMain.LOG_ERR)
             logger.AddErr(e, "");
     }
 }
Ejemplo n.º 5
0
 //�ظ��ʺ��б�
 private void C_Info_AccountList(DataClient dataClient)
 {
     try
     {
         StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_INFO).Append(Constant.C_INFO_ACCOUNT_LIST);
         if(dataClient.LoginUser != null && dataClient.LoginUser.UserType == User.USER_ADMIN)
         {
             stb.Append(Constant.RESULT_OK);
             foreach(User user in userList)
                 stb.Append(user.ToString()).Append(Constant.SPLIT1);
             stb.Remove(stb.Length - 1, 1).Append(Constant.FOOT);
         }
         else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_NO_POLICY).Append(Constant.FOOT);
         dataClient.Send(stb.ToString());
     }
     catch(Exception e)
     {
         if(FormMain.LOG_ERR)
             logger.AddErr(e, "");
     }
 }
Ejemplo n.º 6
0
 //�ظ��dz�
 private void C_Conn_Logout(DataClient dataClient)
 {
     dataServer.CloseConnection(dataClient.Socket);
 }
Ejemplo n.º 7
0
 private void C_Declare_Deal(DataClient dataClient, String rec)
 {
     try
     {
         StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_DECLARE).Append(Constant.C_DECLARE_DEAL);
         if(dataClient.LoginUser != null && dataClient.LoginUser.PolicyDeclare == 1)
         {
             Declare dec = Declare.Parse(rec);
             if(dec != null)
             {
                 Car car = GetCarByID(dec.CarID);
                 DataTable dt = dbm.ExecuteQuery(dec.SqlUpdateStr(car.CarID));
                 if(dt != null)
                 {
                     stb.Append(Constant.RESULT_OK).Append(car.CarID);
                     int dcount = Int32.Parse(dt.Rows[0][0].ToString());
                     if(car.DeclareCount != dcount)
                     {
                         car.DeclareCount = dcount;
                         StringBuilder stb1 = new StringBuilder(Constant.HEAD).Append(Constant.S_DECLARE).Append(Constant.S_DECLARE_DEAL);
                         stb1.Append(car.CarID).Append(Constant.SPLIT1).Append(car.DeclareCount).Append(Constant.FOOT);
                         foreach(DataClient dc in dataClientList)
                         {
                             if((dc.LoginUser != null && dc.LoginUser.GetTeamByID(car.TeamID) != null)
                                 || (dc.LoginTeam != null && dc.LoginTeam.TeamID == car.TeamID)
                                 || (dc.LoginCar != null && dc.LoginCar.CarID == dec.CarID))
                                 dc.Send(stb1.ToString());
                         }
                         dbAssistant.AddOperation(dataClient.LoginUser.UserName, "������ϡ�Ͷ��:����" + dec.DeclareID);
                     }
                     else dbAssistant.AddOperation(dataClient.LoginUser.UserName, "�޸Ĺ��ϡ�Ͷ��:����" + dec.DeclareID);
                 }
                 else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_UPDATE_DB);
             }
             else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_ERR_INFO);
         }
         else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_NO_POLICY);
         stb.Append(Constant.FOOT);
         dataClient.Send(stb.ToString());
     }
     catch(Exception e)
     {
         if(FormMain.LOG_ERR)
             logger.AddErr(e, "");
     }
 }
Ejemplo n.º 8
0
 //�ظ��걨��¼��ѯ
 //ID,�걨ʱ��1,�걨ʱ��2,����,�Ѵ���,������,���ѯ����ʱ��,����ʱ��1,����ʱ��2,������Ա,����,���
 private void C_Query_Declare(DataClient dataClient, String rec)
 {
     String[] ss = rec.Split(Constant.SPLIT1);
     StringBuilder stbPara = new StringBuilder();
     stbPara.Append(" where declareID  like '%").Append(ss[0]).Append("%' ");
     if(ss[1] != "")
         stbPara.Append(" and referDate  >= '").Append(ss[1]).Append("' ");
     if(ss[2] != "")
         stbPara.Append(" and referDate  <= '").Append(ss[2]).Append("' ");
     stbPara.Append(" and declareContent  like '%").Append(ss[3]).Append("%' ");
     if(ss[4] == "1")
         stbPara.Append(" and opUser  = '' ");
     else
     {
         if(ss[4] == "2")
         {
             stbPara.Append(" and opUser  <> '' ");
         }
         stbPara.Append(" and opUser like '%").Append(ss[5]).Append("%' ");
         if(ss[6] == "1")
         {
             stbPara.Append(" and opDate  >= '").Append(ss[7]).Append("' ");
             stbPara.Append(" and opDate  <= '").Append(ss[8]).Append("' ");
         }
         stbPara.Append(" and mechanic like '%").Append(ss[9]).Append("%' ");
         if(ss[10] != "0")
             stbPara.Append(" and satisfaction = ").Append(Int32.Parse(ss[10]) - 1).Append(" ");
         stbPara.Append(" and opinion like '%").Append(ss[11]).Append("%' ");
     }
     if(ss[12] != "")
         stbPara.Append(" and carID=").Append(ss[12]).Append(" ");
     StringBuilder stbSql = new StringBuilder("select * from vDeclare ").Append(stbPara.ToString());
     if(dataClient.LoginCar != null)
     {
         stbSql.Append("and carID=").Append(dataClient.LoginCar.CarID);
     }
     else if(dataClient.LoginTeam != null)
     {
         stbSql.Append("and teamID=").Append(dataClient.LoginTeam.TeamID);
     }
     else if(dataClient.LoginUser != null && dataClient.LoginUser.UserType == User.USER_OP)
     {
         stbSql.Append("and (teamID=0 or teamID=");
         foreach(Team t in dataClient.LoginUser.Teams)
             stbSql.Append(t.TeamID).Append(" or teamID=");
         stbSql.Remove(stbSql.Length - 12, 11).Append(")");
     }
     DataTable dt = dbm.ExecuteQuery(stbSql.ToString());
     StringBuilder stb1 = new StringBuilder(Constant.HEAD).Append(Constant.C_QUERY).Append(Constant.C_QUERY_DECLARE);
     if(dt.Rows.Count > 0)
     {
         foreach(DataRow dr in dt.Rows)
         {
             for(int i = 0; i < 12; i++)
                 stb1.Append(dr[i].ToString()).Append(Constant.SPLIT2);
             stb1.Append(Constant.SPLIT1);
         }
         stb1.Remove(stb1.Length - 1, 1);
     }
     stb1.Append(Constant.FOOT);
     dataClient.Send(stb1.ToString());
 }
Ejemplo n.º 9
0
 //�ظ�������¼��ѯ
 //������,ʱ��1,ʱ��2,��������
 private void C_Query_Operation(DataClient dataClient, String rec)
 {
     StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_QUERY).Append(Constant.C_QUERY_OPERATION);
     String[] ss = rec.Split(Constant.SPLIT1);
     if(ss.Length == 4)
     {
         StringBuilder stbSql = new StringBuilder("select * from tOperation ");
         stbSql.Append(" where opDate  >= '").Append(ss[1]).Append("' ");
         stbSql.Append(" and opDate  <= '").Append(ss[2]).Append("' ");
         stbSql.Append(" and remark  like '%").Append(ss[3]).Append("%' ");
         if(dataClient.LoginCar != null)
         {
             stbSql.Append("and opUser='******' ");
         }
         else if(dataClient.LoginTeam != null)
         {
             stbSql.Append("and opUser='******' ");
         }
         else if(dataClient.LoginUser != null && dataClient.LoginUser.UserType == User.USER_OP)
         {
             stbSql.Append("and opUser='******'");
         }
         else stbSql.Append(" and opUser  like '%").Append(ss[0]).Append("%' ");
         DataTable dt = dbm.ExecuteQuery(stbSql.ToString());
         if(dt != null && dt.Rows.Count > 0)
         {
             foreach(DataRow dr in dt.Rows)
             {
                 for(int i = 0; i < 4; i++)
                     stb.Append(dr[i].ToString()).Append(Constant.SPLIT2);
                 stb.Append(Constant.SPLIT1);
             }
             stb.Remove(stb.Length - 1, 1);
         }
     }
     stb.Append(Constant.FOOT);
     dataClient.Send(stb.ToString());
 }
Ejemplo n.º 10
0
 //�ظ�������
 private void C_Pos_StopWatch(DataClient dataClient, String rec)
 {
     try
     {
         if(rec == "")//�������
         {
             foreach(Team team in teamList)
                 foreach(Car car in team.Cars)
                     car.WatchSockets.Remove(dataClient.Socket);
         }
         else
         {
             int id = Int32.Parse(rec);
             if(id >= 100000)//����
             {
                 Car car = GetCarByID(id);
                 if(car != null)
                     car.WatchSockets.Remove(dataClient.Socket);
             }
             else//����
             {
                 Team team = GetTeamByID(id);
                 if(team != null)
                     foreach(Car car in team.Cars)
                         car.WatchSockets.Remove(dataClient.Socket);
             }
         }
     }
     catch(Exception e)
     {
         if(FormMain.LOG_ERR)
             logger.AddErr(e, "");
     }
 }
Ejemplo n.º 11
0
 //�ظ����
 private void C_Pos_Watch(DataClient dataClient, String rec)
 {
     try
     {
         int count  = 0;
         StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_POS).Append(Constant.C_POS_WATCH);
         int id = Int32.Parse(rec);
         if(id >= 100000)//����
         {
             Car car = GetCarByID(id);
             if(car != null && car.WatchSockets.IndexOf(dataClient.Socket) < 0)
             {
                 car.WatchSockets.Add(dataClient.Socket);
                 stb.Append(car.CarID).Append(Constant.SPLIT1).Append(car.Pos.ToString()).Append(Constant.FOOT);
                 count++;
             }
         }
         else//����
         {
             Team team = GetTeamByID(id);
             if(team != null)
             {
                 foreach(Car car in team.Cars)
                 {
                     if(car.WatchSockets.IndexOf(dataClient.Socket) < 0)
                     {
                         car.WatchSockets.Add(dataClient.Socket);
                         stb.Append(car.CarID).Append(Constant.SPLIT1).Append(car.Pos.ToString()).Append(Constant.SPLIT1);
                         count++;
                     }
                 }
                 if(count > 0)
                     stb.Remove(stb.Length - 1, 1).Append(Constant.FOOT);
             }
         }
         if(count > 0)
             dataClient.Send(stb.ToString());
     }
     catch(Exception e)
     {
         if(FormMain.LOG_ERR)
             logger.AddErr(e, "");
     }
 }
Ejemplo n.º 12
0
 //�ظ�����鳵 ///////////////////////////////////////////
 private void C_Pos_RegionQuery(DataClient dataClient, String rec)
 {
     try
     {
         StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_POS).Append(Constant.C_POS_REGION_QUERY);
         String[] ss = rec.Split(Constant.SPLIT1);
         StringBuilder stbSql = new StringBuilder("select carID,lo,la from vPosition where gpsTime>='");
         stbSql.Append(ss[1]).Append("' and gpsTime<='").Append(ss[2]).Append("' ");
         if(ss[0] != "")
             stbSql.Append("and teamID=").Append(ss[0]);
         DataTable dt = dbm.ExecuteQuery(stbSql.ToString());
         if(dt != null && dt.Rows.Count > 0)
         {
             String cids = "";
             Region region = new Region(ss[3]);
             stb.Append(ss[1]).Append(Constant.SPLIT1).Append(ss[2]).Append(Constant.SPLIT1);
             foreach(DataRow dr in dt.Rows)
             {
                 String cid = dr[0].ToString();
                 if(cids.IndexOf(cid) >= 0)
                     continue;
                 else if(region.InRegion(new DPoint(Double.Parse(dr[1].ToString()), Double.Parse(dr[2].ToString()))))
                     cids = cids + cid + Constant.SPLIT1;
             }
             stb.Append(cids.Substring(0, cids.Length - 1));
         }
         stb.Append(Constant.FOOT);
         dataClient.Send(stb.ToString());
     }
     catch(Exception e)
     {
         if(FormMain.LOG_ERR)
             logger.AddErr(e, "");
     }
 }
Ejemplo n.º 13
0
        //�ظ���λ
        private void C_Pos_Point(DataClient dataClient, String rec)
        {
            try
            {
                String order = "";
                Car car = GetCarByID(Int32.Parse(rec));
                bool suc = false;
                if(car.Protocol == Constant.PROTOCOL_QICHUAN)
                {
                    order = Protocol_QiChuan.CreatePointOrder(false, car.MachineNO);
                    if(car.Routeway == Constant.ROUTE_WAY_MODEM)
                    {
                        if(SendSmsToModem(car.SimNO, order))
                            suc = true;
                    }
                    else if(car.Routeway >= Constant.ROUTE_WAY_SMS)
                    {
                        if(SendSms(car.Routeway - 2, car.SimNO, order))
                            suc = true;
                    }
                }
                else if(car.Protocol == Constant.PROTOCOL_TIANHE)
                {
                    order = Protocol_TianHe.CreatePointOrder(false, car.MachineNO);
                    if(car.Routeway == Constant.ROUTE_WAY_TCP)
                    {
                        if(car.GprsConn != null && car.GprsConn.Send(order))

                            suc = true;
                    }
                    else if(car.Routeway == Constant.ROUTE_WAY_MODEM)
                    {
                        if(SendSmsToModem(car.SimNO, order))
                            suc = true;
                    }
                    else if(car.Routeway >= Constant.ROUTE_WAY_SMS)
                    {
                        if(SendSms(car.Routeway - 2, car.SimNO, order))
                            suc = true;
                    }
                }
                else if(car.Protocol == Constant.PROTOCOL_DASANTONG)
                {
                    order = Protocol_DaSanTong.CreatePointOrder(false, car.MachineNO);
                    if(car.Routeway == Constant.ROUTE_WAY_TCP)
                    {
                        if(car.GprsConn != null && car.GprsConn.Send(order))
                            suc = true;
                    }
                    else if(car.Routeway == Constant.ROUTE_WAY_MODEM)
                    {
                        if(SendSmsToModem(car.SimNO, order))
                            suc = true;
                    }
                    else if(car.Routeway >= Constant.ROUTE_WAY_SMS)
                    {
                        if(SendSms(car.Routeway - 2, car.SimNO, order))
                            suc = true;
                    }
                }
                else if (car.Protocol == Constant.PROTOCOL_VicZone)
                {
                    order = Protocol_DaSanTong.CreatePointOrder(false, car.MachineNO);
                    if (car.Routeway == Constant.ROUTE_WAY_TCP)
                    {

                           suc = true;
                    }
                    else if (car.Routeway == Constant.ROUTE_WAY_MODEM)
                    {
                        if (SendSmsToModem(car.SimNO, order))
                            suc = true;
                    }
                    else if (car.Routeway >= Constant.ROUTE_WAY_SMS)
                    {
                        if (SendSms(car.Routeway - 2, car.SimNO, order))
                            suc = true;
                    }
                }
                else if (car.Protocol == Constant.PROTOCOL_XUNLUOSHU)
                {
                    order = Protocol_XunLuoShu.CreatePointOrder(false, car.MachineNO);
                    if (car.Routeway == Constant.ROUTE_WAY_UDP)
                    {
                        int port=0;

                        string IP="";

                        DBManager dbms = DBManager.GetInstance(Config.DbHost, Config.DbName, Config.DbUser, Config.DbPw);
                        DataTable dt = dbms.ExecuteQuery("select_Terminal " + "'" +car.MachineNO+ "'");

                        foreach (DataRow dr in dt.Rows)
                        {

                            IP = dr[1].ToString();
                            port = Int32.Parse(dr[2].ToString());

                        }

                        udpConnection.Send(IP, port, order);

                        dt = dbms.ExecuteQuery("select_Terminal " + "'" + car.MachineNO + "'");
                        foreach (DataRow dr in dt.Rows)
                        {

                            IP = dr[1].ToString();
                            port = Int32.Parse(dr[2].ToString());

                        }
                        udpConnection.Send(IP, port, order);

                      dt = dbms.ExecuteQuery("select_Terminal " + "'" + car.MachineNO + "'");
                        foreach (DataRow dr in dt.Rows)
                        {

                            IP = dr[1].ToString();
                            port = Int32.Parse(dr[2].ToString());

                        }
                        udpConnection.Send(IP, port, order);

                        dbms.Close();

                      //   suc = true;
                    }

                }

                if(suc)
                {

                    if(car.PointSockets.IndexOf(dataClient.Socket) < 0)
                        car.PointSockets.Add(dataClient.Socket);
                }
                else
                {
                    if (car.Protocol != Constant.PROTOCOL_XUNLUOSHU||car.Protocol != Constant.PROTOCOL_VicZone)
                    {
                 StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_POS).Append(Constant.C_POS_POINT).Append(Constant.RESULT_FAIL).Append(rec).Append(Constant.FOOT);
                        dataClient.Send(stb.ToString());
                    }

                    }
            }
            catch(Exception e)
            {
                if(FormMain.LOG_ERR)
                    logger.AddErr(e, "");
            }
        }
Ejemplo n.º 14
0
 //�ظ���ע��ѯ
 private void C_Pos_PlaceQuery(DataClient dataClient, String rec)
 {
     try
     {
         StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_POS).Append(Constant.C_POS_PLACE_QUERY);
         DataTable dt = dbm.ExecuteQuery("select_palce " + rec);
         if(dt != null && dt.Rows.Count > 0)
         {
             foreach(DataRow dr in dt.Rows)
                 stb.Append(dr[0].ToString()).Append(Constant.SPLIT2).Append(dr[1].ToString()).Append(Constant.SPLIT2).Append(dr[2].ToString()).Append(Constant.SPLIT1);
             stb.Remove(stb.Length - 1, 1);
         }
         stb.Append(Constant.FOOT);
         dataClient.Send(stb.ToString());
     }
     catch(Exception e)
     {
         if(FormMain.LOG_ERR)
             logger.AddErr(e, "");
     }
 }
Ejemplo n.º 15
0
 //���û���Ϣ
 private void C_Chat_ToUser(DataClient dataClient, String rec)
 {
     try
     {
         String sender = "";
         if(dataClient.LoginUser != null)
             sender = "[����Ա]" + dataClient.LoginUser.UserName;
         else if(dataClient.LoginTeam != null)
             sender = "[����]" + dataClient.LoginTeam.TeamName;
         else sender = "[����]" + dataClient.LoginCar.CarNO;
         String s = new StringBuilder(Constant.HEAD).Append(Constant.C_CHAT).Append(Constant.C_CHAT_TO_USER).Append(sender).Append(Constant.SPLIT1).Append(rec).Append(Constant.FOOT).ToString();
         DataClient[] tempList = dataClientList.ToArray();
         foreach(DataClient dc in tempList)
             if(dc.LoginUser == null
                 || (dc.LoginUser != null && dc == dataClient))
                 dc.Send(s);
     }
     catch(Exception e)
     {
         if(FormMain.LOG_ERR)
             logger.AddErr(e, "");
     }
 }
Ejemplo n.º 16
0
 //�ظ�ָ���·���¼��ѯ
 //������,ʱ��1,ʱ��2,����,ָ������
 private void C_Query_Order(DataClient dataClient, String rec)
 {
     StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_QUERY).Append(Constant.C_QUERY_ORDER);
     String[] ss = rec.Split(Constant.SPLIT1);
     if(ss.Length == 5)
     {
         StringBuilder stbSql = new StringBuilder("select * from tOrder ");
         stbSql.Append(" where sendTime  >= '").Append(ss[1]).Append("' ");
         stbSql.Append(" and sendTime  <= '").Append(ss[2]).Append("' ");
         stbSql.Append(" and carNO  like '%").Append(ss[3]).Append("%' ");
         stbSql.Append(" and remark  like '%").Append(ss[4]).Append("%' ");
         if(dataClient.LoginUser != null && dataClient.LoginUser.UserType == User.USER_OP)
         {
             stbSql.Append("and opUser='******'");
         }
         else stbSql.Append(" and opUser  like '%").Append(ss[0]).Append("%' ");
         //Console.WriteLine(stbSql.ToString());
         DataTable dt = dbm.ExecuteQuery(stbSql.ToString());
         if(dt != null && dt.Rows.Count > 0)
         {
             foreach(DataRow dr in dt.Rows)
             {
                 for(int i = 0; i < 6; i++)
                     stb.Append(dr[i].ToString()).Append(Constant.SPLIT2);
                 stb.Append(Constant.SPLIT1);
             }
             stb.Remove(stb.Length - 1, 1);
         }
     }
     stb.Append(Constant.FOOT);
     dataClient.Send(stb.ToString());
 }
Ejemplo n.º 17
0
        //�ظ���½
        private void C_Conn_Login(DataClient dataClient, String rec)
        {
            try
            {
                char result = Constant.RESULT_FAIL;
                StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_CONN).Append(Constant.C_CONN_LOGIN);
                StringBuilder stb2 = new StringBuilder();
                List<AlarmPosition> aList = new List<AlarmPosition>();
                String[] para = rec.Split(Constant.SPLIT1);
                int type = Int32.Parse(para[0]);
                if(type == User.USER_ADMIN || type == User.USER_OP)
                {
                    User user = GetUserByName(para[1]);
                    if(user != null && user.Password == para[2])
                    {
                        result = Constant.RESULT_OTHER;
                        if(!user.HasLogin)//����Ƿ��ѵ�½
                        {
                            user.HasLogin = true;

                            stb2.Append(user.ToString()).Append(Constant.SPLIT1);
                            foreach(Team team in user.Teams)
                            {
                                stb2.Append(team.ToString()).Append(Constant.SPLIT3);
                                foreach(Car car in team.Cars)
                                {
                                    stb2.Append(car.ToString()).Append(Constant.SPLIT3);
                                    if(car.HandleAlarmClient == null && user.PolicyAlarmList == 1)
                                    {
                                        foreach(AlarmPosition apos in car.AlarmPos)
                                        {
                                            aList.Add(apos);
                                        }
                                    }
                                }
                                stb2.Remove(stb2.Length-1, 1);
                                stb2.Append(Constant.SPLIT1);
                            }
                            dataClient.LoginUser = user;
                            result = Constant.RESULT_OK;
                        }
                    }
                }
                else if(type == User.USER_TEAM)
                {
                    Team team = null;
                    //����ID���߳�����
                    try
                    {
                        team = GetTeamByID(Int32.Parse(para[1]));
                    }
                    catch
                    {
                        team = GetTeamByName(para[1]);
                    }
                    if(team != null && team.Password == para[2])
                    {
                        result = Constant.RESULT_OTHER;
                        if(!team.HasLogin)
                        {
                            team.HasLogin = true;

                            stb2.Append(team.ToString()).Append(Constant.SPLIT3);
                            foreach(Car car in team.Cars)
                                stb2.Append(car.ToString()).Append(Constant.SPLIT3);
                            stb2.Remove(stb2.Length - 1, 1);
                            stb2.Append(Constant.SPLIT1);
                            dataClient.LoginTeam = team;
                            result = Constant.RESULT_OK;
                        }
                    }
                }
                else
                {
                    Car car = null;
                    try
                    {
                        car = GetCarByID(Int32.Parse(para[1]));
                    }
                    catch
                    {
                        car = GetCarByNO(para[1]);
                    }
                    if(car != null && car.Password == para[2])
                    {
                        result = Constant.RESULT_OTHER;
                        if(!car.HasLogin)
                        {
                            car.HasLogin = true;

                            stb2.Append(car.Team.ToString()).Append(Constant.SPLIT3);
                            stb2.Append(car.ToString()).Append(Constant.SPLIT1);
                            dataClient.LoginCar = car;
                            result = Constant.RESULT_OK;
                        }
                    }
                }
                //ָ��ͨ��
                stb2.Append("GPRS(TCP)").Append(Constant.SPLIT2).Append("GPRS(UDP)").Append(Constant.SPLIT2).Append("����Modem");
                foreach(SmsConfig smsconfig in Config.SmsList)
                    stb2.Append(Constant.SPLIT2).Append(smsconfig.SmsName);
                stb.Append(result);
                if(result == Constant.RESULT_OK)
                {
                    stb.Append(stb2.ToString());
                    dataClient.HasLogin = true;
                }
                stb.Append(Constant.FOOT);
                dataClient.Send(stb.ToString());
                if(result == Constant.RESULT_OK && aList.Count > 0)
                {
                    String stba = new StringBuilder(Constant.HEAD).Append(Constant.S_INFO).Append(Constant.S_INFO_ALARM).ToString();
                    foreach(AlarmPosition apos in aList)
                    {
                        dataClient.Send(stba + apos.ToString() + Constant.FOOT);
                    }
                }
            }
            catch(Exception e)
            {
                if(FormMain.LOG_ERR)
                    logger.AddErr(e, "");
            }
        }
Ejemplo n.º 18
0
        //�ظ�ȡ���ն�����
        private void C_Set_GetSet(DataClient dataClient, String rec)
        {
            try
            {
                String[] ss = rec.Split(Constant.SPLIT1);
                Car car = GetCarByID(Int32.Parse(ss[0]));
                bool suc = false;
                if(car.Protocol == Constant.PROTOCOL_QICHUAN)
                {
                    String order = Protocol_QiChuan.CreateGetSettingOrder(false, car.MachineNO);
                    if(car.Routeway == Constant.ROUTE_WAY_TCP)
                    {
                    }
                    else if(car.Routeway == Constant.ROUTE_WAY_MODEM)
                    {
                        if(SendSmsToModem(car.SimNO, order))
                            suc = true;
                    }
                    else if(car.Routeway >= Constant.ROUTE_WAY_SMS)
                    {
                        if(SendSms(car.Routeway - 2, car.SimNO, order))
                            suc = true;
                    }
                }
                else if(car.Protocol == Constant.PROTOCOL_TIANHE)
                {
                    String order = Protocol_TianHe.CreateGetSettingOrder(false, car.MachineNO);
                    if(car.Routeway == Constant.ROUTE_WAY_TCP)
                    {
                        if(car.GprsConn != null && car.GprsConn.Send(order))
                            suc = true;
                    }
                    else if(car.Routeway >= Constant.ROUTE_WAY_SMS)
                    {
                        if(SendSms(car.Routeway - 2, car.SimNO, order))
                            suc = true;
                    }
                }
                else if (car.Protocol == Constant.PROTOCOL_XUNLUOSHU)
                {
                    String order = Protocol_XunLuoShu.CreateGetSettingOrder(false, car.MachineNO);
                    if (car.Routeway == Constant.ROUTE_WAY_UDP)
                    {
                        int port = 0;

                        string IP = "";

                        DBManager dbms = DBManager.GetInstance(Config.DbHost, Config.DbName, Config.DbUser, Config.DbPw);
                        DataTable dt = dbms.ExecuteQuery("select_Terminal " + "'" + car.MachineNO + "'");

                        foreach (DataRow dr in dt.Rows)
                        {

                            IP = dr[1].ToString();
                            port = Int32.Parse(dr[2].ToString());

                        }

                        udpConnection.Send(IP, port, order);
                        dt = dbms.ExecuteQuery("select_Terminal " + "'" + car.MachineNO + "'");
                        foreach (DataRow dr in dt.Rows)
                        {

                            IP = dr[1].ToString();
                            port = Int32.Parse(dr[2].ToString());

                        }

                        udpConnection.Send(IP, port, order);

                        dt = dbms.ExecuteQuery("select_Terminal " + "'" + car.MachineNO + "'");
                        foreach (DataRow dr in dt.Rows)
                        {

                            IP = dr[1].ToString();
                            port = Int32.Parse(dr[2].ToString());

                        }

                        udpConnection.Send(IP, port, order);

                        dbms.Close();

                            //suc = true;

                    }
                    // ��Ӳ��Ŀǰ������ģʽ����

                   }

                if(suc)
                {
                    if(car.GetSetSockets.IndexOf(dataClient.Socket) < 0)
                        car.GetSetSockets.Add(dataClient.Socket);
                    //dbAssistant.AddOperation(dataClient.LoginUser.UserName, "��ȡ�ն�����:���ƺ�" + car.CarNO);
                }
                else
                {
                    if (car.Protocol != Constant.PROTOCOL_XUNLUOSHU)
                    {
                        StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_SET).Append(Constant.C_SET_GET_SET).Append(Constant.RESULT_FAIL).Append(ss[0]).Append(Constant.FOOT);
                        dataClient.Send(stb.ToString());
                    }

                }
            }
            catch(Exception e)
            {
                if(FormMain.LOG_ERR)
                    logger.AddErr(e, "");
            }
        }
Ejemplo n.º 19
0
 //�ظ��������
 private void C_Conn_Test(DataClient dataClient)
 {
     //dataClient.Send(Constant.CONN_TEST);
     if(dataClient.HasLogin && !dataClient.TestOk)
         dataClient.TestOk = true;
 }
Ejemplo n.º 20
0
        //�ظ��������
        private void C_Alarm_Free(DataClient dataClient, String rec)
        {
            try
            {
                StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_ALARM).Append(Constant.C_ALARM_FREE);
                String[] para = rec.Split(Constant.SPLIT1);
                if(dataClient.LoginUser != null && dataClient.LoginUser.PolicyAlarmList == 1)
                {
                    bool hasSuc = false;
                    Car car = GetCarByID(Int32.Parse(para[0]));
                    if(car == null)
                        return;
                    //Console.WriteLine("��ϯ������� cno:" + car.CarNO + ";user:"******"update_alarm_free " + para[0] + "," + dataClient.LoginUser.UserID.ToString()))
                    {
                        try
                        {
                            car.AlarmPos.Clear();
                            if(para[1] == "1")//�������ָ��
                            {
                                if(car.Routeway >= Constant.ROUTE_WAY_SMS)
                                {
                                    if(car.Protocol == Constant.PROTOCOL_QICHUAN)
                                    {
                                        String remark = "", order = Protocol_QiChuan.CreateSMSOrder(car.MachineNO, Protocol_QiChuan.OD_CTR_FREE_ALARM, "", out remark);
                                        if(SendSms(car.Routeway - 2, car.SimNO, order))
                                            stb.Append(Constant.RESULT_OK).Append(para[0]).Append(Constant.FOOT);
                                        else stb.Append(Constant.RESULT_OTHER).Append(para[0]).Append(Constant.FOOT);
                                    }
                                    else stb.Append(Constant.RESULT_OTHER).Append(para[0]).Append(Constant.FOOT);
                                }
                                else if(car.Routeway == Constant.ROUTE_WAY_MODEM)
                                {
                                    if(car.Protocol == Constant.PROTOCOL_QICHUAN)
                                    {
                                        String remark = "", order = Protocol_QiChuan.CreateSMSOrder(car.MachineNO, Protocol_QiChuan.OD_CTR_FREE_ALARM, "", out remark);
                                        if (SendSmsToModem(car.SimNO, order))
                                            stb.Append(Constant.RESULT_OK).Append(para[0]).Append(Constant.FOOT);
                                        else stb.Append(Constant.RESULT_OTHER).Append(para[0]).Append(Constant.FOOT);
                                    }
                                    else stb.Append(Constant.RESULT_OTHER).Append(para[0]).Append(Constant.FOOT);
                                }
                                else if (car.Routeway == Constant.ROUTE_WAY_UDP)
                                {
                                    if (car.Protocol == Constant.PROTOCOL_XUNLUOSHU)
                                    {
                                        String remark = "", order = Protocol_XunLuoShu.CreateGPRSOrder(car.MachineNO, Protocol_XunLuoShu.OD_CTR_FREE_ALARM, "", out remark);

                                        int port = 0;

                                        string IP = "";

                                        DBManager dbms = DBManager.GetInstance(Config.DbHost, Config.DbName, Config.DbUser, Config.DbPw);
                                        DataTable dt = dbms.ExecuteQuery("select_Terminal " + "'" + car.MachineNO + "'");

                                        foreach (DataRow dr in dt.Rows)
                                        {

                                            IP = dr[1].ToString();
                                            port = Int32.Parse(dr[2].ToString());

                                        }

                                        udpConnection.Send(IP, port, order);

                                        dt = dbms.ExecuteQuery("select_Terminal " + "'" + car.MachineNO + "'");

                                        foreach (DataRow dr in dt.Rows)
                                        {

                                            IP = dr[1].ToString();
                                            port = Int32.Parse(dr[2].ToString());

                                        }
                                        udpConnection.Send(IP, port, order);

                                        dt = dbms.ExecuteQuery("select_Terminal " + "'" + car.MachineNO + "'");

                                        foreach (DataRow dr in dt.Rows)
                                        {

                                            IP = dr[1].ToString();
                                            port = Int32.Parse(dr[2].ToString());

                                        }
                                        udpConnection.Send(IP, port, order);

                                        dbms.Close();
                                        stb.Append(Constant.RESULT_OK).Append(para[0]).Append(Constant.FOOT);

                                    }
                                    else stb.Append(Constant.RESULT_OTHER).Append(para[0]).Append(Constant.FOOT);
                                }

                                else stb.Append(Constant.RESULT_OTHER).Append(para[0]).Append(Constant.FOOT);
                            }
                            else stb.Append(Constant.RESULT_OK).Append(para[0]).Append(Constant.FOOT);
                            //Console.WriteLine("��ϯ��������ɹ� cno:" + car.CarNO + ";user:"******"����ϯ���ͽ������ cno:" + car.CarNO + ";user:"******"�������:���ƺ�" + car.CarNO);
                        }
                        catch { }
                    }
                    if(!hasSuc)
                    {
                        stb.Append(Constant.RESULT_FAIL).Append(para[0]).Append(Constant.SPLIT1).Append(StrConst.RET_UPDATE_DB).Append(Constant.FOOT);
                        dataClient.Send(stb.ToString());
                        car.HandleAlarmClient = null;
                        foreach(AlarmPosition apos in car.AlarmPos)
                            S_Alarm(car, apos);
                        return;
                    }
                }
                else stb.Append(Constant.RESULT_FAIL).Append(para[0]).Append(Constant.SPLIT1).Append(StrConst.RET_NO_POLICY).Append(Constant.FOOT);
                dataClient.Send(stb.ToString());
            }
            catch(Exception e)
            {
                if(FormMain.LOG_ERR)
                    logger.AddErr(e, "");
            }
        }
Ejemplo n.º 21
0
 private void C_Declare_HisContent(DataClient dataClient, String rec)
 {
     try
     {
         StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_DECLARE).Append(Constant.C_DECLARE_HIS_CONTENT);
         String[] ss = rec.Split(Constant.SPLIT1);
         StringBuilder stbSql = new StringBuilder("select referDate,declareContent from vDeclare  where");
         stbSql.Append(" carID=").Append(ss[0]);
         stbSql.Append(" and referDate  <= '").Append(ss[1]).Append("' ");
         DataTable dt = dbm.ExecuteQuery(stbSql.ToString());
         if(dt != null && dt.Rows.Count > 0)
         {
             foreach(DataRow dr in dt.Rows)
             {
                 stb.Append("[").Append(dr[0].ToString()).Append("]").Append(dr[1].ToString());
                 stb.Append(Constant.SPLIT1);
             }
             stb.Remove(stb.Length - 1, 1);
         }
         stb.Append(Constant.FOOT);
         dataClient.Send(stb.ToString());
     }
     catch(Exception e)
     {
         if(FormMain.LOG_ERR)
             logger.AddErr(e, "");
     }
 }
Ejemplo n.º 22
0
        //�ظ����ò�����ʾ
        private void C_Set_Notify(DataClient dataClient, String rec)
        {
            try
            {
                String[] para = rec.Split(Constant.SPLIT1);
                Car car = GetCarByID(Int32.Parse(para[0]));
                StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_SET).Append(Constant.C_SET_NOTIFY);
                if(dataClient.LoginUser != null && dataClient.LoginUser.PolicyNotify == 1)
                {
                    bool suc = false;
                    if(para[1] == "0")
                    {
                        if(dbm.ExecuteUpdate(car.SqlUpdateDisableNotify()))
                        {
                            car.Notify = 0;
                            suc = true;
                        }
                    }
                    else
                    {
                        if(dbm.ExecuteUpdate(car.SqlUpdateEnableNotify(para[2], para[3], para[4])))
                        {
                            car.Notify = 1;
                            car.NotifyStart = para[2];
                            car.NotifyEnd = para[3];
                            car.NotifyText = para[4];
                            suc = true;
                        }
                    }
                    if(suc)
                    {
                        //stb.Append(Constant.RESULT_OK).Append(Constant.FOOT);
                        //dataClient.Send(stb.ToString());

                        String s1 = new StringBuilder(Constant.HEAD).Append(Constant.S_INFO).Append(Constant.S_INFO_SET_NOTIFY).Append(rec).Append(Constant.FOOT).ToString();
                        DataClient[] tempList = dataClientList.ToArray();
                        foreach(DataClient dc in tempList)
                        {
                            if((dc.LoginUser != null && dc.LoginUser.GetTeamByID(car.TeamID) != null)
                                || (dc.LoginTeam != null && dc.LoginTeam.TeamID == car.TeamID)
                                || (dc.LoginCar != null && dc.LoginCar.CarID == car.CarID))
                                dc.Send(s1);
                        }
                        dbAssistant.AddOperation(dataClient.LoginUser.UserName, "���ó���������ʾ:���ƺ�" + car.CarNO);
                        return;
                    }
                    else stb.Append(Constant.RESULT_FAIL).Append(car.CarNO).Append(Constant.SPLIT1).Append(StrConst.RET_UPDATE_DB).Append(Constant.FOOT);
                }
                else stb.Append(Constant.RESULT_FAIL).Append(car.CarNO).Append(Constant.SPLIT1).Append(StrConst.RET_NO_POLICY).Append(Constant.FOOT);
                dataClient.Send(stb.ToString());
            }
            catch(Exception e)
            {
                if(FormMain.LOG_ERR)
                    logger.AddErr(e, "");
            }
        }
Ejemplo n.º 23
0
 private void C_Declare_New(DataClient dataClient, String rec)
 {
     try
     {
         StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_DECLARE).Append(Constant.C_DECLARE_NEW);
         Declare dec = Declare.Parse(rec);
         if(dec != null)
         {
             Car car = GetCarByID(dec.CarID);
             if(car != null)
             {
                 DataTable dt = dbm.ExecuteQuery(dec.SqlInsertStr());
                 if(dt != null)
                 {
                     car.DeclareCount++;
                     stb.Append(Constant.RESULT_OK).Append(car.CarID);
                     StringBuilder stb1 = new StringBuilder(Constant.HEAD).Append(Constant.S_DECLARE).Append(Constant.S_DECLARE_ADD).Append(dec.CarID).Append(Constant.FOOT);
                     foreach(DataClient dc in dataClientList)
                     {
                         if((dc.LoginUser != null && dc.LoginUser.GetTeamByID(car.TeamID) != null)
                             || (dc.LoginTeam != null && dc.LoginTeam.TeamID == car.TeamID)
                             || (dc.LoginCar != null && dc.LoginCar.CarID == dec.CarID))
                             dc.Send(stb1.ToString());
                     }
                     String op = "";
                     if(dataClient.LoginUser != null)
                         op = "[����Ա]" + dataClient.LoginUser.UserName;
                     else if(dataClient.LoginTeam != null)
                         op = "[�����û�]" + dataClient.LoginTeam.TeamName;
                     else op = "[�����û�]" + dataClient.LoginCar.CarNO;
                     dbAssistant.AddOperation(op, "�ύ���ϡ�Ͷ���걨");
                 }
                 else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_UPDATE_DB);
             }
             else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_ERR_INFO);
         }
         else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_ERR_INFO);
         stb.Append(Constant.FOOT);
         dataClient.Send(stb.ToString());
     }
     catch(Exception e)
     {
         if(FormMain.LOG_ERR)
             logger.AddErr(e, "");
     }
 }
Ejemplo n.º 24
0
        //�ظ��·�ָ��
        private void C_Set_Order(DataClient dataClient, String rec)
        {
            try
            {
                StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_SET).Append(Constant.C_SET_ORDER);
                int maxCount = 1, smsCount = 0, gprsCount = 0, modemCount = 0;
                String sucNO = "", failNo = "", order = "", remark = "";
                if((dataClient.LoginUser != null && (dataClient.LoginUser.UserType == User.USER_ADMIN || dataClient.LoginUser.PolicyOrder == 1))
                    || (dataClient.LoginTeam != null && dataClient.LoginTeam.PolicyOrder == 1))
                {
                    String[] para = rec.Split(Constant.SPLIT1);
                    if(para.Length == 4)
                    {
                        String[] cids = para[1].Split(Constant.SPLIT_EX_2);
                        maxCount = cids.Length;
                        if(para[0] == Constant.PROTOCOL_QICHUAN.ToString())//GPRS��1��
                        {
                            foreach(String cid in cids)
                            {
                                try
                                {
                                    Car car = GetCarByID(Int32.Parse(cid));
                                    if(car.Routeway == Constant.ROUTE_WAY_TCP)
                                    {
                                        failNo = failNo + car.CarNO + Constant.SPLIT_EX_2.ToString();
                                        continue;
                                    }
                                    order = Protocol_QiChuan.CreateSMSOrder(car.MachineNO, para[2][0], para[3], out remark);
                                    //Console.WriteLine(remark + ":" + order);
                                    if(car.Routeway == Constant.ROUTE_WAY_MODEM)
                                    {
                                        if(SendSmsToModem(car.SimNO, order))
                                        {
                                            modemCount++;
                                            sucNO = sucNO + car.CarNO + Constant.SPLIT_EX_2.ToString();
                                        }
                                        else failNo = failNo + car.CarNO + Constant.SPLIT_EX_2.ToString();
                                    }
                                    else if(car.Routeway >= Constant.ROUTE_WAY_SMS)
                                    {
                                        if(SendSms(car.Routeway - 2, car.SimNO, order))
                                        {
                                            smsCount++;
                                            sucNO = sucNO + car.CarNO + Constant.SPLIT_EX_2.ToString();
                                        }
                                        else failNo = failNo + car.CarNO + Constant.SPLIT_EX_2.ToString();
                                    }
                                    else failNo = failNo + car.CarNO + Constant.SPLIT_EX_2.ToString();
                                }
                                catch { }
                            }
                        }
                        else if (para[0] == Constant.PROTOCOL_TIANHE.ToString())//GPRS��2��
                        {
                            foreach (String cid in cids)
                            {
                                try
                                {
                                    Car car = GetCarByID(Int32.Parse(cid));
                                    remark = para[3];
                                    if (car.Routeway == Constant.ROUTE_WAY_TCP)
                                    {
                                        if (car.GprsConn == null)
                                        {
                                            failNo = failNo + car.CarNO + Constant.SPLIT_EX_2.ToString();
                                            continue;
                                        }
                                        order = Protocol_TianHe.BuildOrder(car.MachineNO, para[2]);
                                        if (order != "" && car.GprsConn.Send(order))
                                        {
                                            sucNO = sucNO + car.CarNO + Constant.SPLIT_EX_2.ToString();
                                            gprsCount++;
                                        }
                                        else failNo = failNo + car.CarNO + Constant.SPLIT_EX_2.ToString();
                                    }
                                    else if (car.Routeway == Constant.ROUTE_WAY_MODEM)
                                    {
                                        if (SendSmsToModem(car.SimNO, order))
                                        {
                                            modemCount++;
                                            sucNO = sucNO + car.CarNO + Constant.SPLIT_EX_2.ToString();
                                        }
                                        else failNo = failNo + car.CarNO + Constant.SPLIT_EX_2.ToString();
                                    }
                                    else
                                    {
                                        order = Protocol_TianHe.BuildOrder(car.MachineNO, para[2]);
                                        if (SendSms(car.Routeway - 2, car.SimNO, order))
                                        {
                                            smsCount++;
                                            sucNO = sucNO + car.CarNO + Constant.SPLIT_EX_2.ToString();
                                        }
                                        else failNo = failNo + car.CarNO + Constant.SPLIT_EX_2.ToString();
                                    }
                                }
                                catch { }
                            }

                        }
                        else if (para[0] == Constant.PROTOCOL_XUNLUOSHU.ToString())//GPRS��4��
                        {
                            foreach (String cid in cids)
                            {
                                try
                                {
                                    Car car = GetCarByID(Int32.Parse(cid));
                                    if (car.Routeway == Constant.ROUTE_WAY_UDP)
                                    {

                                        order = Protocol_XunLuoShu.CreateGPRSOrder(car.MachineNO, para[2][0], para[3], out remark);
                                        if (order != "")
                                        {
                                            int port = 0;

                                            string IP = "";

                                            DBManager dbms = DBManager.GetInstance(Config.DbHost, Config.DbName, Config.DbUser, Config.DbPw);
                                            DataTable dt = dbms.ExecuteQuery("select_Terminal " + "'" + car.MachineNO + "'");

                                            foreach (DataRow dr in dt.Rows)
                                            {

                                                IP = dr[1].ToString();
                                                port = Int32.Parse(dr[2].ToString());

                                            }

                                            udpConnection.Send(IP, port, order);

                                            dt = dbms.ExecuteQuery("select_Terminal " + "'" + car.MachineNO + "'");

                                            foreach (DataRow dr in dt.Rows)
                                            {

                                                IP = dr[1].ToString();
                                                port = Int32.Parse(dr[2].ToString());

                                            }
                                            udpConnection.Send(IP, port, order);
                                            dt = dbms.ExecuteQuery("select_Terminal " + "'" + car.MachineNO + "'");
                                            foreach (DataRow dr in dt.Rows)
                                            {

                                                IP = dr[1].ToString();
                                                port = Int32.Parse(dr[2].ToString());

                                            }
                                            udpConnection.Send(IP, port, order);

                                            dbms.Close();
                                            sucNO = sucNO + car.CarNO + Constant.SPLIT_EX_2.ToString();
                                            gprsCount++;
                                        }
                                        else failNo = failNo + car.CarNO + Constant.SPLIT_EX_2.ToString();

                                    }
                                }

                                catch { }
                            }
                        }

                        }

                    if((smsCount + gprsCount + modemCount) > 0)
                    {
                        String op = "";
                        if(dataClient.LoginUser != null)
                            op = "[����Ա]" + dataClient.LoginUser.UserName;
                        else if(dataClient.LoginTeam != null)
                            op = "[�����û�]" + dataClient.LoginTeam.TeamName;
                        dbAssistant.AddOrder(sucNO, op, order, remark, DateTime.Now);
                    }
                }
                if(maxCount > 0 && maxCount == (smsCount + gprsCount + modemCount))
                {
                    stb.Append(Constant.RESULT_OK).Append("ָ��[").Append(remark).Append("]�����͵�").Append(sucNO).Append("�ɹ�");
                }
                else if((smsCount + gprsCount + modemCount) == 0)
                {
                    stb.Append(Constant.RESULT_FAIL).Append("ָ��[").Append(remark).Append("]�����͵�").Append(failNo).Append("ʧ��");
                }
                else
                {
                    stb.Append(Constant.RESULT_FAIL).Append("ָ��[").Append(remark).Append("]�����͵�").Append(sucNO).Append("�ɹ���ʧ�ܣ�").Append(failNo);
                }
                stb.Append(Constant.FOOT);
                dataClient.Send(stb.ToString());
            }
            catch(Exception e)
            {
                if(FormMain.LOG_ERR)
                    logger.AddErr(e, "");
            }
        }
Ejemplo n.º 25
0
 //�ظ�����ʺ�
 private void C_Info_AddAccount(DataClient dataClient, String rec)
 {
     try
     {
         StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_INFO).Append(Constant.C_INFO_ACCOUNT_ADD);
         if(dataClient.LoginUser != null && dataClient.LoginUser.UserType == User.USER_ADMIN)
         {
             User user = User.Parse(rec);
             if(user == null)
             {
                 stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_ERR_INFO).Append(Constant.FOOT);
                 dataClient.Send(stb.ToString());
                 return;
             }
             if(user.UserName != "" && user.Password != "" && GetUserByName(user.UserName) == null)
             {
                 DataTable dt = dbm.ExecuteQuery(user.SqlInsertStr());
                 if(dt != null)
                 {
                     user.UserID = Int32.Parse(dt.Rows[0][0].ToString());
                     user.JoinTime = Pub.DateTimeStr;
                     if(user.UserType == User.USER_ADMIN)
                         user.Teams = teamList;
                     else
                     {
                         String[] temp = user.TeamStr.Split(Constant.SPLIT_EX_1);
                         foreach(String s in temp)
                         {
                             try
                             {
                                 Team team = GetTeamByID(Int32.Parse(s));
                                 if(team != null)
                                     user.Teams.Add(team);
                             }
                             catch { }
                         }
                     }
                     userList.Add(user);
                     stb.Append(Constant.RESULT_OK).Append(Constant.FOOT);
                     dbAssistant.AddOperation(dataClient.LoginUser.UserName, "����ʺ�:�û���" + user.UserName);
                 }
                 else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_UPDATE_DB).Append(Constant.FOOT);
             }
             else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_ECHO_INFO).Append(":�û���").Append(Constant.FOOT);
         }
         else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_NO_POLICY).Append(Constant.FOOT);
         dataClient.Send(stb.ToString());
     }
     catch(Exception e)
     {
         if(FormMain.LOG_ERR)
             logger.AddErr(e, "");
     }
 }
Ejemplo n.º 26
0
        //�ظ����÷���״̬
        private void C_Set_Stoped(DataClient dataClient, String rec)
        {
            try
            {
                String[] para = rec.Split(Constant.SPLIT1);
                Car car = GetCarByID(Int32.Parse(para[0]));
                StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_SET).Append(Constant.C_SET_STOPED);
                if(dataClient.LoginUser != null && dataClient.LoginUser.PolicyOverTime == 1)
                {
                    int stp = Int32.Parse(para[1]);
                    if(car != null && dbm.ExecuteUpdate(car.SqlUpdateStopedStr(stp)))
                    {
                        car.Stoped = stp;
                        //stb.Append(Constant.RESULT_OK).Append(Constant.FOOT);
                        //dataClient.Send(stb.ToString());

                        String s1 = new StringBuilder(Constant.HEAD).Append(Constant.S_INFO).Append(Constant.S_INFO_SET_STOPED).Append(rec).Append(Constant.FOOT).ToString();
                        DataClient[] tempList = dataClientList.ToArray();
                        foreach(DataClient dc in tempList)
                        {
                            if((dc.LoginUser != null && dc.LoginUser.GetTeamByID(car.TeamID) != null)
                                || (dc.LoginTeam != null && dc.LoginTeam.TeamID == car.TeamID)
                                || (dc.LoginCar != null && dc.LoginCar.CarID == car.CarID))
                                dc.Send(s1);
                        }
                        dbAssistant.AddOperation(dataClient.LoginUser.UserName, "���ó�������״̬:���ƺ�" + car.CarNO);
                        return;
                    }
                    else stb.Append(Constant.RESULT_FAIL).Append(car.CarNO).Append(Constant.SPLIT1).Append(StrConst.RET_UPDATE_DB).Append(Constant.FOOT);
                }
                else stb.Append(Constant.RESULT_FAIL).Append(car.CarNO).Append(Constant.SPLIT1).Append(StrConst.RET_NO_POLICY).Append(Constant.FOOT);
                dataClient.Send(stb.ToString());
            }
            catch(Exception e)
            {
                if(FormMain.LOG_ERR)
                    logger.AddErr(e, "");
            }
        }
Ejemplo n.º 27
0
 //�ظ���ӳ���
 private void C_Info_AddTeam(DataClient dataClient, String rec)
 {
     try
     {
         StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_INFO).Append(Constant.C_INFO_TEAM_ADD);
         if(dataClient.LoginUser != null && dataClient.LoginUser.PolicyModTeam == 1)
         {
             Team team = Team.Parse(rec);
             if(team == null)
             {
                 stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_ERR_INFO).Append(Constant.FOOT);
                 dataClient.Send(stb.ToString());
                 return;
             }
             if(GetTeamByName(team.TeamName) == null)
             {
                 DataTable dt = dbm.ExecuteQuery(team.SqlInsertStr());
                 if(dt != null)
                 {
                     team.TeamID = Int32.Parse(dt.Rows[0][0].ToString());
                     team.JoinTime = Pub.DateTimeStr;
                     teamList.Add(team);
                     stb.Append(Constant.RESULT_OK).Append(Constant.FOOT);
                     dataClient.Send(stb.ToString());
                     StringBuilder stb1 = new StringBuilder(Constant.HEAD).Append(Constant.S_INFO).Append(Constant.S_INFO_TEAM_ADD);
                     stb1.Append(team.ToString()).Append(Constant.FOOT);
                     String s1 = stb1.ToString();
                     if(dataClient.LoginUser.UserType == User.USER_OP)//����Ƿֿؿͻ���,����ӹ���Ȩ��
                     {
                         dataClient.LoginUser.TeamStr = dataClient.LoginUser.TeamStr + Constant.SPLIT3 + team.TeamID.ToString();
                         dataClient.LoginUser.Teams.Add(team);
                         dbm.ExecuteUpdate(dataClient.LoginUser.SqlUpdateStr());
                         dataClient.Send(s1);
                     }
                     //֪ͨ����ϵͳ����Ա
                     DataClient[] tempList = dataClientList.ToArray();
                     foreach(DataClient dc in tempList)
                         if(dc.LoginUser != null && dc.LoginUser.UserType == User.USER_ADMIN)
                             dc.Send(s1);
                     dbAssistant.AddOperation(dataClient.LoginUser.UserName, "��ӳ���:���Ӻ�" + team.TeamName);
                     return;
                 }
                 else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_UPDATE_DB).Append(Constant.FOOT);
             }
             else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_ECHO_INFO).Append(":������").Append(Constant.FOOT);
         }
         else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_NO_POLICY).Append(Constant.FOOT);
         dataClient.Send(stb.ToString());
     }
     catch(Exception e)
     {
         if(FormMain.LOG_ERR)
             logger.AddErr(e, "");
     }
 }
Ejemplo n.º 28
0
        //�ظ��Ӿ�
        private void C_Alarm_Handle(DataClient dataClient, String rec)
        {
            try
            {
                String[] para = rec.Split(Constant.SPLIT1);
                Car car = GetCarByID(Int32.Parse(para[0]));
                StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_ALARM).Append(Constant.C_ALARM_HANDLE);
                if(dataClient.LoginUser != null && (dataClient.LoginUser.UserType == User.USER_ADMIN || dataClient.LoginUser.PolicyAlarmList == 1))
                {
                    if(para[1][0] == Constant.RESULT_OK)//�Ӿ�
                    {
                        if(car.HandleAlarmClient == null && car.AlarmPos.Count > 0)
                        {
                            car.HandleAlarmClient = dataClient;
                            if(dataClient.HandleAlarmCar != null)
                                foreach(AlarmPosition apos in car.AlarmPos)
                                    S_Alarm(car, apos);
                            dataClient.HandleAlarmCar = car;
                            String s1 = new StringBuilder(Constant.HEAD).Append(Constant.S_INFO).Append(Constant.S_INFO_FREE_ALARM).Append(para[0]).Append(Constant.FOOT).ToString();
                            DataClient[] tempList = dataClientList.ToArray();
                            foreach(DataClient dc in tempList)//��������ϯ�����ѽӾ�
                                if(dc != dataClient && dc.LoginUser != null && dc.LoginUser.PolicyAlarmList == 1 && dc.LoginUser.GetTeamByID(car.TeamID) != null)
                                {
                                    dc.Send(s1);
                                }

                            stb.Append(Constant.RESULT_OK).Append(para[0]).Append(Constant.FOOT);
                            dataClient.Send(stb.ToString());
                            //dbAssistant.AddOperation(dataClient.LoginUser.UserName, "�Ӿ�:���ƺ�" + car.CarNO);
                            return;
                        }
                        else stb.Append(Constant.RESULT_FAIL).Append(para[0]).Append(Constant.SPLIT1).Append("�ó��������ѱ��Ӿ�����").Append(Constant.FOOT);
                    }
                    else//ȡ���Ӿ�
                    {
                        if(car.HandleAlarmClient == dataClient)//�Ƿ�Ϊ�Ӿ�����ϯ
                        {
                            car.HandleAlarmClient = null;
                            dataClient.HandleAlarmCar = null;
                            foreach(AlarmPosition apos in car.AlarmPos)
                                S_Alarm(car, apos);
                            //dbAssistant.AddOperation(dataClient.LoginUser.UserName, "ȡ���Ӿ�:���ƺ�" + car.CarNO);
                            stb.Append(Constant.FOOT);
                        }
                    }
                }
                else stb.Append(Constant.RESULT_FAIL).Append(para[0]).Append(Constant.SPLIT1).Append(StrConst.RET_NO_POLICY).Append(Constant.FOOT);
                dataClient.Send(stb.ToString());
            }
            catch(Exception e)
            {
                if(FormMain.LOG_ERR)
                    logger.AddErr(e, "");
            }
        }
Ejemplo n.º 29
0
        //�ظ�ɾ������
        private void C_Info_DelCar(DataClient dataClient, String rec)
        {
            try
            {
                StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_INFO).Append(Constant.C_INFO_CAR_DEL);
                if((dataClient.LoginUser != null && dataClient.LoginUser.PolicyModCar == 1) || (dataClient.LoginTeam != null && dataClient.LoginTeam.PolicyModCar == 1))
                {
                    Car car = GetCarByID(Int32.Parse(rec));
                    if(car != null && dbm.ExecuteUpdate(car.SqlDeleteStr()))
                    {
                        //stb.Append(Constant.RESULT_OK).Append(Constant.FOOT);
                        //dataClient.Send(stb.ToString());

                        StringBuilder stb1 = new StringBuilder(Constant.HEAD).Append(Constant.S_INFO).Append(Constant.S_INFO_CAR_DEL);
                        stb1.Append(car.CarID).Append(Constant.FOOT);
                        String s1 = stb1.ToString();
                        DataClient[] tempList = dataClientList.ToArray();
                        foreach(DataClient dc in tempList)
                        {
                            if(dc.LoginCar == car)
                                dc.CloseConnection();
                            else if(dc.LoginUser != null && dc.LoginUser.GetTeamByID(car.TeamID) != null
                                || dc.LoginTeam != null && dc.LoginTeam.TeamID == car.TeamID)
                                dc.Send(s1);
                        }
                        if(car.GprsConn != null)//�ر�GPRS����
                            car.GprsConn.CloseConnection();
                        car.Team.Cars.Remove(car);
                        String opUser = "";
                        if(dataClient.LoginUser != null)
                            opUser = "******" + dataClient.LoginUser.UserName;
                        else opUser = "******" + dataClient.LoginTeam.TeamName;
                        dbAssistant.AddOperation(opUser, "ɾ������:���ƺ�" + car.CarNO);
                        return;
                    }
                    else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_UPDATE_DB).Append(Constant.FOOT);
                }
                else stb.Append(Constant.RESULT_FAIL).Append(StrConst.RET_NO_POLICY).Append(Constant.FOOT);
                dataClient.Send(stb.ToString());
            }
            catch(Exception e)
            {
                if(FormMain.LOG_ERR)
                    logger.AddErr(e, "");
            }
        }
Ejemplo n.º 30
0
        //�ظ����ͳ��
        private void C_Pos_Mileage(DataClient dataClient, String rec)
        {
            // ĿǰӲ���޼�¼������롣select_mileageAʹ�����ݿ�洢�ṹ���м��㷵�ؽ��

            try
            {
                String[] para = rec.Split(Constant.SPLIT1);
                StringBuilder stb = new StringBuilder(Constant.HEAD).Append(Constant.C_POS).Append(Constant.C_POS_MILEAGE);
                String cid = para[0];
                String m = "0";
                bool check = false;

                DataTable dc = dbm.ExecuteQuery("select_mileage " + para[0] + ",'" + para[1] + "','" + para[2] + "'");

                if (dc != null && dc.Rows.Count > 0)
                    m = dc.Rows[0][0].ToString();

                 if (m == ""||m=="0")
                {
                    DataTable dt = dbm.ExecuteQuery("select_mileageA " + para[0] + ",'" + para[1] + "','" + para[2] + "'");

                    foreach (DataRow dr in dt.Rows)
                    {
                        float getvalue = float.Parse(dr[0].ToString());

                        int s = (int)getvalue;

                        m = s.ToString();
                        check = true;

                    }

                }

             stb.Append(para[0]).Append(Constant.SPLIT1).Append(m).Append(Constant.FOOT);

                 dataClient.Send(stb.ToString());
                 if (check)
                 {
                     dbm.ExecuteQuery("delete from temp;");
                     dbm.ExecuteQuery("delete from mileage;");
                     dbm.ExecuteQuery("delete from mileage_com;");
                 }

            }
            catch(Exception e)
            {
                if(FormMain.LOG_ERR)
                    logger.AddErr(e, "");
            }
        }