Exemplo n.º 1
0
 public Driver GetDriverByUcode(string ucode)
 {
     try
        {
        string sSql = string.Format(@"Select ddi.DriveCount,ddi.DrivedYears,ddi.DriverlicenseType,
                 ddi.Grade,ddi.Photo,ddi.Sex,ddi.Tel,ddi.Ucode,ddi.Phone,ddi.DriverName,ddi.BirthPlace,
                 dp.Latitude,dp.Longitude,ddi.Online,ddi.OnService
                  From D_DriverInfo (nolock) ddi join D_DriverPositon(nolock) dp on ddi.Ucode=dp.Ucode
                  where ddi.Ucode='{0}' or ddi.DriverCarType='{0}' or ddi.Phone='{0}'", ucode);
        var dt = helper.GetDataTable(sSql);
        if (dt != null && dt.Rows.Count>0)
        {
            Driver entity = new Driver();
            entity.DriveCount = Convert.ToInt32(dt.Rows[0]["DriveCount"] == DBNull.Value ? 0 : dt.Rows[0]["DriveCount"]);
            entity.DrivedYears = Convert.ToInt32(dt.Rows[0]["DrivedYears"] == DBNull.Value ? 0 : dt.Rows[0]["DrivedYears"]);
            entity.DriverlicenseType =dt.Rows[0]["DriverlicenseType"]==DBNull.Value?"": dt.Rows[0]["DriverlicenseType"].ToString();
            entity.Grade = Convert.ToInt32(dt.Rows[0]["Grade"] == DBNull.Value ? 0 : dt.Rows[0]["Grade"]);
            entity.Photo =dt.Rows[0]["Photo"]==DBNull.Value?"": dt.Rows[0]["Photo"].ToString();
            entity.Sex = Convert.ToInt32(dt.Rows[0]["Sex"] == DBNull.Value ? 0 : dt.Rows[0]["Sex"]);
            entity.Tel =dt.Rows[0]["Tel"]==DBNull.Value?"": dt.Rows[0]["Tel"].ToString();
            entity.Ucode =dt.Rows[0]["Ucode"]==DBNull.Value?"": dt.Rows[0]["Ucode"].ToString();
            entity.Phone = dt.Rows[0]["Phone"] == DBNull.Value ? "" : dt.Rows[0]["Phone"].ToString();
            entity.DriverName = dt.Rows[0]["DriverName"] == DBNull.Value ? "" : dt.Rows[0]["DriverName"].ToString();
            entity.BirthPlace = dt.Rows[0]["BirthPlace"] == DBNull.Value ? "" : dt.Rows[0]["BirthPlace"].ToString();
            entity.Lat = Convert.ToDouble(dt.Rows[0]["Latitude"] == DBNull.Value ? 0 : dt.Rows[0]["Latitude"]);
            entity.Lng = Convert.ToDouble(dt.Rows[0]["Longitude"] == DBNull.Value ? 0 : dt.Rows[0]["Longitude"]);
            entity.Online = Convert.ToInt32(dt.Rows[0]["Online"] == DBNull.Value ? 0 : dt.Rows[0]["Online"]);
            entity.OnService = Convert.ToInt32(dt.Rows[0]["OnService"] == DBNull.Value ? 0 : dt.Rows[0]["OnService"]);
           return entity;
        }
        else
        {
            return null;
        }
        }
        catch (Exception ex)
        {
        LogControl.WriteError("GetDriverByUcode查询司机失败|Error:" + ex.Message);
       return null;
        }
 }
Exemplo n.º 2
0
 public List<Driver> GetDriverInfoByRange(double lat, double lng, double range,int Top)
 {
     List<Driver> result = new List<Driver>();
     try
     {
         string sSql = string.Format(@" SELECT TOP {3}  ddi.Ucode, ddi.DriverName, ddi.Deposit, ddi.DisposableGoodsCount, ddi.DriveCount, ddi.DrivedYears,
                               ddi.DriverlicenseType,ddi.Grade,ddi.Photo,ddi.Sex,ddi.Tel,ddi.Phone,ddi.BirthPlace,ddp.Latitude,ddp.Longitude
                                FROM D_DriverInfo AS ddi WITH(NOLOCK)
                                 INNER JOIN D_DriverPositon AS ddp WITH(NOLOCK)
                                     ON ddi.Ucode = ddp.Ucode
                             WHERE ddi.OnLine = 1
                                 AND ddi.OnService = 0
                                 AND	dbo.fnGetDistance({0},{1},ddp.Latitude,ddp.Longitude)<={2}
                                 Order by  dbo.fnGetDistance({0},{1},ddp.Latitude,ddp.Longitude)
                                 ", lat, lng, range,Top<0?10:Top);
         var dt = helper.GetDataTable(sSql);
         if (dt != null && dt.Rows.Count > 0)
         {
             for (int i = 0; i < dt.Rows.Count; i++)
             {
                 Driver entity = new Driver();
                 entity.Deposit = Convert.ToDecimal(dt.Rows[i]["Deposit"] == DBNull.Value ? 0 : dt.Rows[i]["Deposit"]);
                 entity.DisposableGoodsCount = Convert.ToInt32(dt.Rows[i]["DisposableGoodsCount"] == DBNull.Value ? 0 : dt.Rows[i]["DisposableGoodsCount"]);
                 entity.DriveCount = Convert.ToInt32(dt.Rows[i]["DriveCount"] == DBNull.Value ? 0 : dt.Rows[i]["DriveCount"]);
                 entity.DrivedYears = Convert.ToInt32(dt.Rows[i]["DrivedYears"] == DBNull.Value ? 0 : dt.Rows[i]["DrivedYears"]);
                 entity.DriverlicenseType = dt.Rows[i]["DriverlicenseType"] == DBNull.Value ? "" : dt.Rows[i]["DriverlicenseType"].ToString();
                 entity.Grade = Convert.ToInt32(dt.Rows[i]["Grade"] == DBNull.Value ? 0 : dt.Rows[i]["Grade"]);
                 entity.Photo = dt.Rows[i]["Photo"] == DBNull.Value ? "" : dt.Rows[i]["Photo"].ToString();
                 entity.Sex = Convert.ToInt32(dt.Rows[i]["Sex"] == DBNull.Value ? 0 : dt.Rows[i]["Sex"]);
                 entity.Phone = dt.Rows[i]["Phone"] == DBNull.Value ? "" : dt.Rows[i]["Phone"].ToString();
                 entity.Tel = dt.Rows[i]["Tel"] == DBNull.Value ? "" : dt.Rows[i]["Tel"].ToString();
                 entity.Ucode = dt.Rows[i]["Ucode"] == DBNull.Value ? "" : dt.Rows[i]["Ucode"].ToString();
                 entity.DriverName = dt.Rows[i]["DriverName"] == DBNull.Value ? "" : dt.Rows[i]["DriverName"].ToString();
                 entity.BirthPlace = dt.Rows[i]["BirthPlace"] == DBNull.Value ? "" : dt.Rows[i]["BirthPlace"].ToString();
                 entity.Lat = dt.Rows[i]["Latitude"] == DBNull.Value ? 0 : Convert.ToDouble(dt.Rows[i]["Latitude"]);
                 entity.Lng = dt.Rows[i]["Longitude"] == DBNull.Value ? 0 : Convert.ToDouble(dt.Rows[i]["Longitude"]);
                 result.Add(entity);
             }
         }
     }
     catch (Exception ex)
     {
         LogControl.WriteError("GetDriverInfoByRange查询周边司机列表失败|Error:" + ex.Message);
     }
     return result;
 }
Exemplo n.º 3
0
        public List<Driver> GetDriverByUcodes(string ucodes)
        {
            List<Driver> result = new List<Driver>();
            try
            {
                string[] sIds = ucodes.Split(',');
                string newIds = "";

                for (int i = 0; i < sIds.Length; i++)
                {
                    newIds += "'" + sIds[i] + "',";
                }
                newIds = newIds.Substring(0, newIds.Length - 1);
                string sSql = string.Format("Select * From D_DriverInfo (nolock) where Ucode in ({0})", newIds);
                var dt = helper.GetDataTable(sSql);
                if (dt != null && dt.Rows.Count > 0)
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        Driver entity = new Driver();
                        entity.Deposit = Convert.ToDecimal(dt.Rows[i]["Deposit"] == DBNull.Value ? 0 : dt.Rows[i]["Deposit"]);
                        entity.DisposableGoodsCount = Convert.ToInt32(dt.Rows[i]["DisposableGoodsCount"] == DBNull.Value ? 0 : dt.Rows[i]["DisposableGoodsCount"]);
                        entity.DriveCount = Convert.ToInt32(dt.Rows[i]["DriveCount"] == DBNull.Value ? 0 : dt.Rows[i]["DriveCount"]);
                        entity.DrivedYears = Convert.ToInt32(dt.Rows[i]["DrivedYears"] == DBNull.Value ? 0 : dt.Rows[i]["DrivedYears"]);
                        entity.DriverlicenseType = dt.Rows[i]["DriverlicenseType"] == DBNull.Value ? "" : dt.Rows[i]["DriverlicenseType"].ToString();
                        entity.Grade = Convert.ToInt32(dt.Rows[i]["Grade"] == DBNull.Value ? 0 : dt.Rows[i]["Grade"]);
                        entity.Photo = dt.Rows[i]["Photo"] == DBNull.Value ? "" : dt.Rows[i]["Photo"].ToString();
                        entity.Sex = Convert.ToInt32(dt.Rows[i]["Sex"] == DBNull.Value ? 0 : dt.Rows[i]["Sex"]);
                        entity.Tel = dt.Rows[i]["Tel"] == DBNull.Value ? "" : dt.Rows[i]["Tel"].ToString();
                        entity.Ucode = dt.Rows[i]["Ucode"] == DBNull.Value ? "" : dt.Rows[i]["Ucode"].ToString();
                        entity.Phone = dt.Rows[i]["Phone"] == DBNull.Value ? "" : dt.Rows[i]["Phone"].ToString();
                        entity.DriverName = dt.Rows[i]["DriverName"] == DBNull.Value ? "" : dt.Rows[i]["DriverName"].ToString();
                        entity.BirthPlace = dt.Rows[i]["BirthPlace"] == DBNull.Value ? "" : dt.Rows[i]["BirthPlace"].ToString();
                        result.Add(entity);
                    }
                }
            }
            catch (Exception ex)
            {
                LogControl.WriteError("GetDriverByUcodes查询司机列表失败|Error:" + ex.Message);
            }
            return result;
        }