コード例 #1
0
        /// <summary>
        /// 查询是否存在指定的记录
        /// </summary>
        /// <param name="imodel"></param>
        /// <returns></returns>
        public override bool Exists(IModel imodel)
        {
            MLocationMapInf model = (MLocationMapInf)imodel;

            strSql = "select * from " + TableName + " where LOATION_MAP_INF_ID='" + model.LOATION_MAP_INF_ID + "'";
            return(recordIsExist(strSql));
        }
コード例 #2
0
        /// <summary>
        /// 更新指定的记录
        /// </summary>
        /// <param name="imodel"></param>
        /// <param name="where"></param>
        /// <returns></returns>
        public override int Update(IModel imodel, string where)
        {
            MLocationMapInf model = (MLocationMapInf)imodel;
            Hashtable       ht    = new Hashtable();

            ht.Add("LOATION_MAP_INF_ID", model.LOATION_MAP_INF_ID);
            ht.Add("MAP_FILENAME", model.MAP_FILENAME);
            ht.Add("MAP_PART", model.MAP_PART);
            ht.Add("MAP_EXPLAIN", model.MAP_EXPLAIN);
            return(ExecuteSql(StringConstructor.UpdateSql(TableName, ht, where).ToString()));
        }
コード例 #3
0
        /// <summary>
        /// 获取指定ID的记录
        /// </summary>
        /// <param name="LOATION_MAP_INF_ID"></param>
        /// <returns></returns>
        public override IModel GetModel(string LOATION_MAP_INF_ID)
        {
            strSql = "select * from " + TableName + " where MLocationMapInf='" + LOATION_MAP_INF_ID + "'";
            DataTable dt = GetDataTable(strSql);

            if (dt.Rows.Count == 0)
            {
                return(null);
            }
            MLocationMapInf model = new MLocationMapInf();

            model.LOATION_MAP_INF_ID = Convert.ToInt32(dt.Rows[0]["LOATION_MAP_INF_ID"].ToString());
            model.MAP_EXPLAIN        = dt.Rows[0]["MAP_EXPLAIN"].ToString();
            model.MAP_FILENAME       = dt.Rows[0]["MAP_FILENAME"].ToString();
            model.MAP_PART           = dt.Rows[0]["MAP_PART"].ToString();
            return(model);
        }