示例#1
0
        public static int TagInfoUpdate(TagInfoEntity tagInfoEntity)
        {
            tagInfoEntity.LogMessages.MsgType = MessageType.INFO;
            tagInfoEntity.LogMessages.Content = _nameSpaceClass + "TagInfoUpdate";
            LoggerHelper.LogWriter(tagInfoEntity.LogMessages);

            try
            {
                return TagInfoDA.TagInfoUpdate(tagInfoEntity);
            }
            catch (Exception ex)
            {
                tagInfoEntity.LogMessages.MsgType = MessageType.ERROR;
                tagInfoEntity.LogMessages.Content = _nameSpaceClass + "TagInfoUpdate  Error: " + ex.Message;
                LoggerHelper.LogWriter(tagInfoEntity.LogMessages);
                throw ex;
            }
        }
示例#2
0
        public static int TagInfoInsert(TagInfoEntity tagInfoEntity)
        {
            OracleParameter[] parm ={
                                    new OracleParameter("TAGNAME",OracleType.VarChar),
                                    new OracleParameter("LONGITUDE",OracleType.VarChar),
                                    new OracleParameter("LATITUDE",OracleType.VarChar),
                                    new OracleParameter("TYPEID",OracleType.VarChar),
                                    new OracleParameter("STATUS",OracleType.VarChar),
                                    new OracleParameter("CITYID",OracleType.VarChar),
                                    new OracleParameter("CITYNAME",OracleType.VarChar),
                                    new OracleParameter("PINYINLONG",OracleType.VarChar),
                                    new OracleParameter("PINYINSHORT",OracleType.VarChar)
                                };
            if (string.IsNullOrEmpty(tagInfoEntity.TagName))
            {
                parm[0].Value = DBNull.Value;
            }
            else
            {
                parm[0].Value = tagInfoEntity.TagName;
            }
            if (string.IsNullOrEmpty(tagInfoEntity.Longitude))
            {
                parm[1].Value = DBNull.Value;
            }
            else
            {
                parm[1].Value = tagInfoEntity.Longitude;
            }
            if (string.IsNullOrEmpty(tagInfoEntity.Latitude))
            {
                parm[2].Value = DBNull.Value;
            }
            else
            {
                parm[2].Value = tagInfoEntity.Latitude;
            }
            if (string.IsNullOrEmpty(tagInfoEntity.TypeID))
            {
                parm[3].Value = DBNull.Value;
            }
            else
            {
                parm[3].Value = tagInfoEntity.TypeID;
            }
            if (string.IsNullOrEmpty(tagInfoEntity.Status))
            {
                parm[4].Value = DBNull.Value;
            }
            else
            {
                parm[4].Value = tagInfoEntity.Status;
            }
            if (string.IsNullOrEmpty(tagInfoEntity.CityID))
            {
                parm[5].Value = DBNull.Value;
            }
            else
            {
                parm[5].Value = tagInfoEntity.CityID;
            }
            if (string.IsNullOrEmpty(tagInfoEntity.CityName))
            {
                parm[6].Value = DBNull.Value;
            }
            else
            {
                parm[6].Value = tagInfoEntity.CityName;
            }
            if (string.IsNullOrEmpty(tagInfoEntity.PinyinLong))
            {
                parm[7].Value = DBNull.Value;
            }
            else
            {
                parm[7].Value = tagInfoEntity.PinyinLong;
            }
            if (string.IsNullOrEmpty(tagInfoEntity.PinyinShort))
            {
                parm[8].Value = DBNull.Value;
            }
            else
            {
                parm[8].Value = tagInfoEntity.PinyinShort;
            }

            int i = DbManager.ExecuteSql("TagInfo", "t_tag_info_insert", parm);
            return i;
        }
示例#3
0
        public static TagInfoEntity TagInfoSearchCount(TagInfoEntity tagInfoEntity)
        {
            OracleParameter[] parm ={
                                    new OracleParameter("CITYID",OracleType.VarChar),
                                    new OracleParameter("TAGNAME",OracleType.VarChar)
                                };
            if (string.IsNullOrEmpty(tagInfoEntity.CityID))
            {
                parm[0].Value = DBNull.Value;
            }
            else
            {
                parm[0].Value = tagInfoEntity.CityID;
            }
            if (string.IsNullOrEmpty(tagInfoEntity.TagName))
            {
                parm[1].Value = DBNull.Value;
            }
            else
            {
                parm[1].Value = tagInfoEntity.TagName;
            }

            DataSet dsResult = DbManager.Query("TagInfo", "t_tag_info_search_count", true, parm);
            tagInfoEntity.QueryResult = dsResult;
            return tagInfoEntity;
        }
示例#4
0
        public static TagInfoEntity TagInfoSearch(TagInfoEntity tagInfoEntity)
        {
            OracleParameter[] parm ={
                                    new OracleParameter("CITYID",OracleType.VarChar),
                                    new OracleParameter("TAGNAME",OracleType.VarChar)
                                };
            if (string.IsNullOrEmpty(tagInfoEntity.CityID))
            {
                parm[0].Value = DBNull.Value;
            }
            else
            {
                parm[0].Value = tagInfoEntity.CityID;
            }
            if (string.IsNullOrEmpty(tagInfoEntity.TagName))
            {
                parm[1].Value = DBNull.Value;
            }
            else
            {
                parm[1].Value = tagInfoEntity.TagName;
            }
            string SqlString = XmlSqlAnalyze.GotSqlTextFromXml("TagInfo", "t_tag_info_search");
            DataSet dsResult = DbManager.Query(SqlString, parm, (tagInfoEntity.PageCurrent - 1) * tagInfoEntity.PageSize, tagInfoEntity.PageSize, true);

            tagInfoEntity.QueryResult = dsResult;
            return tagInfoEntity;
        }