/// <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)); }
/// <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())); }
/// <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); }