Exemple #1
0
        public static bool WriteJKLog(NETLOG_INFO log)
        {
            bool bolResult = false;

            NETLOG_INFO netLog = new NETLOG_INFO();
            //string strJKID;
            //bool bHasUpdated = netLog.GetUpdate(log.LWLSH, log.JYCS, log.JYXM, log.JKName, out strJKID);

            string strSql = "";

            //if (strJKID != "-1")
            //{
            //    if (bHasUpdated == false)
            //    {
            //        strSql = "update NET_AJ_JK_RESULT set  SendInfo ='" + log .SendInfo+ "', RevcInfo = '"+log.RevcInfo+"',LogTime ='"+DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")+"')  where ID='"+strJKID+"'";
            //    }
            //}
            //else
            //{
            strSql  = "insert into NET_AJ_JK_RESULT(LWLSH,JCLSH,JYCS,LWType,JKName,JYXM,SendInfo,RevcInfo,IsSuc,LogTime) ";
            strSql += " values('" + log.LWLSH + "','" + log.JCLSH + "','" + log.JYCS + "','" + log.LWType + "','" + log.JKName + "','" + log.JYXM + "','" + log.SendInfo + "','" + log.RevcInfo + "','" + log.IsSuc + "','" + log.LogTime.ToString("yyyy-MM-dd HH:mm:ss") + "')";
            //}

            try
            {
                string        strConn = ReadConfig.GetValueFromXML("connectionString", "value");
                SqlConnection conn    = new SqlConnection(strConn);
                conn.Open();

                if (conn.State == ConnectionState.Open)
                {
                    SqlCommand m_cmdCommand = conn.CreateCommand();

                    m_cmdCommand.Parameters.Clear();
                    m_cmdCommand.CommandType = CommandType.Text;
                    m_cmdCommand.CommandText = strSql;

                    try
                    {
                        m_cmdCommand.ExecuteNonQuery();
                        bolResult = true;
                    }
                    catch
                    {
                    }
                    finally
                    {
                        m_cmdCommand.Dispose();
                        conn.Close();
                    }
                }
            }
            catch (Exception ex)
            {
            }

            return(bolResult);
        }
Exemple #2
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="strLWLSH"></param>
        /// <param name="strJYCS"></param>
        /// <returns></returns>
        public bool GetSuccessful(string strLWLSH, string strJYCS, string strJYXM, string strJKID, bool IsBJXY = false)
        {
            bool bRet = false;

            if (IsBJXY)
            {
                return(false);
            }

            //原因是新凌志联网,必须发两张照片和两个视频
            if (strJKID == "18X04" && (strJYXM == "M1" || strJYXM == "Z1"))
            {
                return(false);
            }

            string        strConn = ReadConfig.GetValueFromXML("connectionString", "value");
            SqlConnection conn    = new SqlConnection(strConn);

            try
            {
                conn.Open();
                string strSql = "select IsSuc,ID from NET_AJ_JK_RESULT where LWType='AJ' and LWLSH='" + strLWLSH + "' and JYCS='" + strJYCS + "' and (JCLSH<>'' and JCLSH is not null) and JYXM='" + strJYXM + "' and JKName='" + strJKID + "'";

                SqlCommand    cmd = new SqlCommand(strSql, conn);
                SqlDataReader dr  = cmd.ExecuteReader();

                string strIsSuc = "";
                while (dr.Read())
                {
                    strIsSuc = dr["IsSuc"].ToString();
                    if (strIsSuc == "1")
                    {
                        bRet = true;
                        break;
                    }
                }

                conn.Close();
                conn.Dispose();
            }
            catch (Exception ex)
            {
                if (conn != null)
                {
                    conn.Close();
                    conn.Dispose();
                }
            }

            return(bRet);
        }
Exemple #3
0
        public string GetJCLSH(string strLWLSH, string strJYCS)
        {
            string strRet = "";

            try
            {
                string        strConn = ReadConfig.GetValueFromXML("connectionString", "value");
                SqlConnection conn    = new SqlConnection(strConn);
                conn.Open();

                if (strJYCS == null)
                {
                    string        strGetJYCSSql = string.Format("SELECT * FROM NET_AJ_JK_RESULT WHERE LWLSH = '{0}' ORDER BY ID DESC ", strLWLSH);
                    SqlCommand    cmd1          = new SqlCommand(strGetJYCSSql, conn);
                    SqlDataReader dr1           = cmd1.ExecuteReader();
                    while (dr1.Read())
                    {
                        if (dr1["JYCS"].ToString() != string.Empty)
                        {
                            strJYCS = dr1["JYCS"].ToString();
                            break;
                        }
                    }
                }

                string strSql = "select JCLSH from NET_AJ_JK_RESULT where LWLSH='" + strLWLSH + "' and JYCS='" + strJYCS + "' and (JCLSH<>'' and JCLSH is not null)";

                SqlCommand    cmd = new SqlCommand(strSql, conn);
                SqlDataReader dr  = cmd.ExecuteReader();

                while (dr.Read())
                {
                    strRet = dr["JCLSH"].ToString();
                    break;
                }

                conn.Close();
                conn.Dispose();
            }
            catch (Exception ex)
            {
            }

            return(strRet);
        }