/// <summary>
 /// 获取人员考勤表序号
 /// </summary>
 /// <returns></returns>
 public string GetNumber()
 {
     try
     {
         string sql    = "select count(*)+1 from Rykqb where xh>=to_char(sysdate,'yyyyMMdd')||'0000'";
         string Number = DBHelperOracle.GetSingle(sql).ToString();
         string No     = "";
         if (Number.Length == 1)
         {
             No = DateTime.Now.ToString("yyyyMMdd") + "000" + Number;
         }
         else if (Number.Length == 2)
         {
             No = DateTime.Now.ToString("yyyyMMdd") + "00" + Number;
         }
         else if (Number.Length == 3)
         {
             No = DateTime.Now.ToString("yyyyMMdd") + "0" + Number;
         }
         else if (Number.Length == 4)
         {
             No = DateTime.Now.ToString("yyyyMMdd") + Number;
         }
         return(No);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
예제 #2
0
 /// <summary>
 /// 查询中心派受理单
 /// </summary>
 /// <param name="SelectData"></param>
 /// <returns></returns>
 public DispatchTaskSelectDataResp SelectDispatchTaskSelectSingle(DispatchTaskSelectData SelectData)
 {
     try
     {
         DispatchTaskSelectDataResp Data = new DispatchTaskSelectDataResp();
         DataSet   ds = DBHelperOracle.Query(DispatchTaskSelectSingleSql.GetRecordSql(SelectData.DDHM));
         DataTable dt = ds.Tables[0];
         if (dt.Rows.Count >= 1)
         {
             int i = DBHelperOracle.ExecuteSql(DispatchTaskSelectSingleSql.SetRecordFlagSql(SelectData.DDHM, SelectData.LSH));
             if (i > 0)
             {
                 foreach (DataRow row in dt.Rows)
                 {
                     Data.CommandID = Data.GetType().Name;
                     Data.ZXLSH     = row["ZXLSH"].ToString();
                     Data.HJDZ      = row["HJDZ"].ToString();
                     Data.ZJXM      = row["HZ"].ToString();
                     Data.ZJHM      = row["ZJHM"].ToString();
                     Data.FZXLSH    = SelectData.LSH;
                     Data.FZXSLTH   = SelectData.SLTH;
                     Data.DWBH      = SelectData.DWBH;
                 }
             }
         }
         return(Data);
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }
        /// <summary>
        /// 车辆状态是否存在
        /// </summary>
        /// <param name="Mobile"></param>
        /// <returns></returns>
        public bool GetBoolVehicleID(string ID, string XZBM)
        {
            bool VehicleID = false;

            try
            {
                string sql = "select id from dqclztxxb where id='" + ID + "' and xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    VehicleID = true;
                }
            }
            catch {}
            return(VehicleID);
        }
        /// <summary>
        /// 查询车辆编号
        /// </summary>
        /// <param name="DealRecordID">流水号</param>
        /// <param name="Mobile">手机号</param>
        /// <returns></returns>
        public string GetVehicleNo(string DealRecordID, string Mobile, string XZBM)
        {
            string clbh = "";

            try
            {
                string sql = "select cl.clbh from clxxb cl join ccxxb cc on cl.clbh=cc.clbh where lsh='" + DealRecordID + "' and cl.czdh='" + Mobile + "' and xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    clbh = obj.ToString();
                }
            }
            catch (Exception ex)
            {
                LOG.LogHelper.WriteLog("GetVehicleNo", ex);
            }
            return(clbh);
        }
        /// <summary>
        /// 联网调度关联表数据
        /// </summary>
        public bool GetLWDDGLB(string RemoteLSH, string RemoteDWBH, string LocalLSH, string XZBM)
        {
            bool Vehicle = false;

            try
            {
                string sql = "select RemoteLSH from LWDDGLB  where RemoteLSH= '" + RemoteLSH + "' and RemoteDWBH ='" + RemoteDWBH + "' and LocalLSH ='" + LocalLSH + "' and  xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    Vehicle = true;
                }
            }
            catch (Exception ex)
            {
                LOG.LogHelper.WriteLog("GetLWDDGLB", ex);
            }
            return(Vehicle);
        }
        /// <summary>
        /// 大型事故表数据
        /// </summary>
        public bool GetDXSGB(string LSH, string XZBM)
        {
            bool Vehicle = false;

            try
            {
                string sql = "select LSH from DXSGB  where LSH='" + LSH + "' and xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    Vehicle = true;
                }
            }
            catch (Exception ex)
            {
                LOG.LogHelper.WriteLog("GetDXSGB", ex);
            }
            return(Vehicle);
        }
        /// <summary>
        /// 值班员信息表数据
        /// </summary>
        public bool GetZBYXXB(string ID, string XZBM)
        {
            bool Vehicle = false;

            try
            {
                string sql = "select id from ZBYXXB where ID=" + ID + " and xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    Vehicle = true;
                }
            }
            catch (Exception ex)
            {
                LOG.LogHelper.WriteLog("GetZBYXXB", ex);
            }
            return(Vehicle);
        }
        /// <summary>
        /// 呼救区域表数据
        /// </summary>
        public bool GetHJQYB(string XH, string XZBM)
        {
            bool Vehicle = false;

            try
            {
                string sql = "select XH from HJQYB t where XH=" + XH + " and xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    Vehicle = true;
                }
            }
            catch (Exception ex)
            {
                LOG.LogHelper.WriteLog("GetHJQYB", ex);
            }
            return(Vehicle);
        }
        /// <summary>
        /// 病历基础信息表数据
        /// </summary>
        public bool GetBLJCXXB(string LX, string MC, string XZBM)
        {
            bool Vehicle = false;

            try
            {
                string sql = "select XH from BLJCXXB t where LX='" + LX + "'and MC ='" + MC + "'and xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    Vehicle = true;
                }
            }
            catch (Exception ex)
            {
                LOG.LogHelper.WriteLog("GetBLJCXXB", ex);
            }
            return(Vehicle);
        }
        /// <summary>
        /// 病历填写项目值
        /// </summary>
        /// <param name="ID"></param>
        /// <returns></returns>
        public bool GetWeb_MedicalProjectValue(string ID, string XZBM)
        {
            bool Vehicle = false;

            try
            {
                string sql = "select id from Web_MedicalProjectValue t where id='" + ID + "' and xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    Vehicle = true;
                }
            }
            catch (Exception ex)
            {
                LOG.LogHelper.WriteLog("GetWeb_MedicalProjectValue", ex);
            }
            return(Vehicle);
        }
        /// <summary>
        /// 查询人员信息是否存在
        /// </summary>
        /// <param name="VehicleCode"></param>
        /// <returns></returns>
        public bool GetBoolSysUserData(string UserName, string XZBM)
        {
            bool SysUser = false;

            try
            {
                string sql = "select xm from xtryb t where rybh='" + UserName + "' and xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    SysUser = true;
                }
            }
            catch (Exception ex)
            {
                LOG.LogHelper.WriteLog("GetBoolSysUserData", ex);
            }
            return(SysUser);
        }
        /// <summary>
        /// 联网病历关系同步对应表数据
        /// </summary>
        public bool GetLWBLGXTBDYB(string LocalLSH, string LocalStatisticsID, string XZBM)
        {
            bool Vehicle = false;

            try
            {
                string sql = "select LocalLSH from LWBLGXTBDYB  where LocalLSH= '" + LocalLSH + "' and LocalStatisticsID =" + LocalStatisticsID + " and xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    Vehicle = true;
                }
            }
            catch (Exception ex)
            {
                LOG.LogHelper.WriteLog("GetLWBLGXTBDYB", ex);
            }
            return(Vehicle);
        }
        /// <summary>
        /// 调度分站记录信息表
        /// </summary>
        /// <param name="LSH"></param>
        /// <param name="CCDW"></param>
        /// <param name="XZBM"></param>
        /// <returns></returns>
        public bool GetDispatchStationInfoData(string LSH, string CCDW, string XZBM)
        {
            bool Vehicle = false;

            try
            {
                string sql = "select lsh from DDFZJLB t where LSH='" + LSH + "' and CCDW='" + CCDW + "' and xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    Vehicle = true;
                }
            }
            catch (Exception ex)
            {
                LOG.LogHelper.WriteLog("GetDispatchStationInfoData", ex);
            }
            return(Vehicle);
        }
        /// <summary>
        /// 大型事故信息表
        /// </summary>
        /// <param name="ID"></param>
        /// <returns></returns>
        public bool GetLargeSlipData(string ID, string XZBM)
        {
            bool Vehicle = false;

            try
            {
                string sql = "select lsh from DXSGB t where LSH='" + ID + "' and xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    Vehicle = true;
                }
            }
            catch (Exception ex)
            {
                LOG.LogHelper.WriteLog("GetLargeSlipData", ex);
            }
            return(Vehicle);
        }
        /// <summary>
        /// 单位信息表
        /// </summary>
        /// <param name="UnitCode"></param>
        /// <returns></returns>
        public bool GetUnitInfoData(string UnitCode, string XZBM)
        {
            bool Vehicle = false;

            try
            {
                string sql = "select DWBH from DWXXB t where DWBH='" + UnitCode + "' and xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    Vehicle = true;
                }
            }
            catch (Exception ex)
            {
                LOG.LogHelper.WriteLog("GetUnitInfoData", ex);
            }
            return(Vehicle);
        }
        /// <summary>
        /// 呼叫记录表
        /// </summary>
        /// <param name="DealRecordID"></param>
        /// <returns></returns>
        public bool GetCallRcordData(string DealRecordID, string XZBM)
        {
            bool Vehicle = false;

            try
            {
                string sql = "select lsh from HJJLB t where lsh='" + DealRecordID + "' and xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    Vehicle = true;
                }
            }
            catch (Exception ex)
            {
                LOG.LogHelper.WriteLog("GetCallRcordData", ex);
            }
            return(Vehicle);
        }
        /// <summary>
        /// 出车信息表
        /// </summary>
        /// <param name="DealRecordID"></param>
        /// <param name="VehicleNo"></param>
        /// <returns></returns>
        public bool GetDispatchVehicleData(string DealRecordID, string VehicleCode, string cs, string XZBM)
        {
            bool Vehicle = false;

            try
            {
                string sql = "select lsh from CCXXB t where lsh='" + DealRecordID + "' and cs='" + cs + "' and clbh='" + VehicleCode + "' and xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    Vehicle = true;
                }
            }
            catch (Exception ex)
            {
                LOG.LogHelper.WriteLog("GetDispatchVehicleData", ex);
            }
            return(Vehicle);
        }
        /// <summary>
        /// 查询受理记录是否存在
        /// </summary>
        /// <param name="DealRecordID"></param>
        /// <returns></returns>
        public bool GetBoolDealData(string DealRecordID, string XZBM)
        {
            bool DealData = false;

            try
            {
                string sql = "select lsh from sljlb t where lsh='" + DealRecordID + "' and xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    DealData = true;
                }
            }
            catch (Exception ex)
            {
                LOG.LogHelper.WriteLog("GetBoolDealData", ex);
            }
            return(DealData);
        }
        /// <summary>
        /// 获取车辆ID
        /// </summary>
        /// <param name="Mobile"></param>
        /// <returns></returns>
        public string GetVehicleID(string Mobile, string XZBM)
        {
            string ID = "";

            try
            {
                string sql = "select ID from clxxb where CZDH='" + Mobile + "' and xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    ID = obj.ToString();
                }
            }
            catch (Exception ex)
            {
                LOG.LogHelper.WriteLog("GetVehicleID", ex);
            }
            return(ID);
        }
        /// <summary>
        /// 查询车辆信息是否存在
        /// </summary>
        /// <param name="VehicleCode"></param>
        /// <param name="Mobile"></param>
        /// <returns></returns>
        public bool GetBoolVehicleData(string clbh, string XZBM)
        {
            bool Vehicle = false;

            try
            {
                string sql = "select clbh from clxxb where clbh='" + clbh + "' and xzbm='" + XZBM + "'";
                object obj = DBHelperOracle.GetSingle(sql);
                if (obj != null)
                {
                    Vehicle = true;
                }
            }
            catch (Exception ex)
            {
                LOG.LogHelper.WriteLog("GetBoolVehicleData", ex);
            }
            return(Vehicle);
        }