public static int Insert(Database db, MapInfo mapInfo) { StringBuilder sbField = new StringBuilder(); StringBuilder sbValue = new StringBuilder(); sbField.Append("INSERT INTO MapInfo("); sbValue.Append("values("); sbField.Append("Name"); sbValue.AppendFormat("'{0}'", mapInfo.Name); sbField.Append(",Width"); sbValue.AppendFormat(",{0}", mapInfo.Width); sbField.Append(",Height"); sbValue.AppendFormat(",{0}", mapInfo.Height); sbField.Append(",FileName)"); sbValue.AppendFormat(",'{0}')", mapInfo.FileName); string cmdText = sbField + " " + sbValue; try { return db.ExecuteNonQuery(CommandType.Text, cmdText); } catch (Exception ex) { throw ex; } }
public int Insert(ref string errMessage, MapInfo mapInfo) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; try { return MapDataAccess.Insert(db, mapInfo); } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return -1; } }
public static int Update(Database db, MapInfo mapInfo) { StringBuilder sb = new StringBuilder(); sb.Append("update MapInfo set"); sb.AppendFormat(" Name={0}", mapInfo.Name); sb.AppendFormat(",X={0}", mapInfo.Width); sb.AppendFormat(",Y={0} ", mapInfo.Height); sb.AppendFormat(",FileName='{0}' ", mapInfo.FileName); sb.AppendFormat(" where Id={0}", mapInfo.Id); string cmdText = sb.ToString(); try { return db.ExecuteNonQuery(CommandType.Text, cmdText); } catch (Exception ex) { throw ex; } }
public Dictionary<int, MapInfo> GetAllMapInfo(ref string errMessage) { Database db = DatabaseFactory.CreateDatabase(); errMessage = ""; Dictionary<int, MapInfo> list = new Dictionary<int, MapInfo>(); try { MapInfo mapInfo; DataSet ds = MapDataAccess.GetAllMapInfo(db); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { mapInfo = new MapInfo(ds.Tables[0].Rows[i]); list.Add(mapInfo.Id, mapInfo); } return list; } catch (Exception ex) { errMessage = ex.Message + ex.StackTrace; logger.Error("Error Message:" + ex.Message + " Trace:" + ex.StackTrace); return null; } }
private void btnAddMap_Click(object sender, EventArgs e) { MapInfo mapInfo = new MapInfo(); mapInfo.Name = teMapName.Text; mapInfo.Width = CurrentImage.Width; mapInfo.Height = CurrentImage.Height; mapInfo.FileName ="img\\maps\\" + Path.GetFileName(CurrentFileName); File.Copy(CurrentFileName, Path.Combine(Application.StartupPath,mapInfo.FileName)); MapBusiness.Instance.Insert(ref errMessage, mapInfo); BuildMapTree(); }
//���ӵ�ͼ private void tvMap_DoubleClick_1(object sender, EventArgs e) { string str = tvMap.FocusedNode.Tag.ToString(); if (str.IndexOf("d") >= 0) { string[] strs = str.Split(';'); CurrentMapInfo = _listMapInfo[int.Parse(strs[0])]; pictureBoxMap.Image = Image.FromFile(Path.Combine(Application.StartupPath, CurrentMapInfo.FileName)); teMapName.Text = CurrentMapInfo.Name; } }