public int Add(MapInfo model) { StringBuilder builder = new StringBuilder(); builder.Append("insert into Ms_Maps("); builder.Append("UserId,DepartmentId,PointerLongitude,PointDimension,PointClass,PointerType,PointerTitle,PointImg,PointerContent,SearchCity,searchArea,Level,enableKeyboard,enableScrollWheelZoom,NavigationControl,ScaleControl,MapTypeControl,MarkersLongitude,MarkersDimension,setAnimation,LoadEvent,MenuItemzoomIn,MenuItemzoomOut,MenuItemsetZoomTop,MenuItemsetPoint,MapType,Other1,Other2,Other3)"); builder.Append(" values ("); builder.Append("@UserId,@DepartmentId,@PointerLongitude,@PointDimension,@PointClass,@PointerType,@PointerTitle,@PointImg,@PointerContent,@SearchCity,@searchArea,@Level,@enableKeyboard,@enableScrollWheelZoom,@NavigationControl,@ScaleControl,@MapTypeControl,@MarkersLongitude,@MarkersDimension,@setAnimation,@LoadEvent,@MenuItemzoomIn,@MenuItemzoomOut,@MenuItemsetZoomTop,@MenuItemsetPoint,@MapType,@Other1,@Other2,@Other3)"); builder.Append(";select @@IDENTITY"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@DepartmentId", SqlDbType.Int, 4), new SqlParameter("@PointerLongitude", SqlDbType.NVarChar, 100), new SqlParameter("@PointDimension", SqlDbType.NVarChar, 100), new SqlParameter("@PointClass", SqlDbType.NVarChar, 100), new SqlParameter("@PointerType", SqlDbType.NVarChar, 100), new SqlParameter("@PointerTitle", SqlDbType.NVarChar, 100), new SqlParameter("@PointImg", SqlDbType.NVarChar, 100), new SqlParameter("@PointerContent", SqlDbType.NVarChar, 300), new SqlParameter("@SearchCity", SqlDbType.NVarChar, 50), new SqlParameter("@searchArea", SqlDbType.NVarChar, 50), new SqlParameter("@Level", SqlDbType.Int, 4), new SqlParameter("@enableKeyboard", SqlDbType.Bit, 1), new SqlParameter("@enableScrollWheelZoom", SqlDbType.Bit, 1), new SqlParameter("@NavigationControl", SqlDbType.Bit, 1), new SqlParameter("@ScaleControl", SqlDbType.Bit, 1), new SqlParameter("@MapTypeControl", SqlDbType.Bit, 1), new SqlParameter("@MarkersLongitude", SqlDbType.NVarChar, 100), new SqlParameter("@MarkersDimension", SqlDbType.NVarChar, 100), new SqlParameter("@setAnimation", SqlDbType.NVarChar, 100), new SqlParameter("@LoadEvent", SqlDbType.NVarChar, 50), new SqlParameter("@MenuItemzoomIn", SqlDbType.Bit, 1), new SqlParameter("@MenuItemzoomOut", SqlDbType.Bit, 1), new SqlParameter("@MenuItemsetZoomTop", SqlDbType.Bit, 1), new SqlParameter("@MenuItemsetPoint", SqlDbType.Bit, 1), new SqlParameter("@MapType", SqlDbType.SmallInt, 2), new SqlParameter("@Other1", SqlDbType.NVarChar, 100), new SqlParameter("@Other2", SqlDbType.NVarChar, 100), new SqlParameter("@Other3", SqlDbType.NVarChar, 50) }; cmdParms[0].Value = model.UserId; cmdParms[1].Value = model.DepartmentId; cmdParms[2].Value = model.PointerLongitude; cmdParms[3].Value = model.PointDimension; cmdParms[4].Value = model.PointClass; cmdParms[5].Value = model.PointerType; cmdParms[6].Value = model.PointerTitle; cmdParms[7].Value = model.PointImg; cmdParms[8].Value = model.PointerContent; cmdParms[9].Value = model.SearchCity; cmdParms[10].Value = model.searchArea; cmdParms[11].Value = model.Level; cmdParms[12].Value = model.enableKeyboard; cmdParms[13].Value = model.enableScrollWheelZoom; cmdParms[14].Value = model.NavigationControl; cmdParms[15].Value = model.ScaleControl; cmdParms[0x10].Value = model.MapTypeControl; cmdParms[0x11].Value = model.MarkersLongitude; cmdParms[0x12].Value = model.MarkersDimension; cmdParms[0x13].Value = model.setAnimation; cmdParms[20].Value = model.LoadEvent; cmdParms[0x15].Value = model.MenuItemzoomIn; cmdParms[0x16].Value = model.MenuItemzoomOut; cmdParms[0x17].Value = model.MenuItemsetZoomTop; cmdParms[0x18].Value = model.MenuItemsetPoint; cmdParms[0x19].Value = model.MapType; cmdParms[0x1a].Value = model.Other1; cmdParms[0x1b].Value = model.Other2; cmdParms[0x1c].Value = model.Other3; object single = DbHelperSQL.GetSingle(builder.ToString(), cmdParms); if (single == null) { return 0; } return Convert.ToInt32(single); }
protected void SetDepartmentMap(HttpContext context) { JsonObject obj2 = new JsonObject(); User user = context.Session[Globals.SESSIONKEY_ENTERPRISE] as User; if (user != null) { int num = Globals.SafeInt(context.Request.Params["DepartmentId"], 0); string str = context.Request.Params["MarkersLongitude"]; string str2 = context.Request.Params["MarkersDimension"]; string target = context.Request.Params["PointerTitle"]; string content = context.Request.Params["PointerContent"]; string str5 = context.Request.Params["PointImg"]; int num2 = Globals.SafeInt(context.Request.Params["MapId"], 0); if (num < 1) { obj2.Accumulate("ERROR", "NOENTERPRISEID"); context.Response.Write(obj2.ToString()); } else { MapInfo model = new MapInfo { UserId = user.UserID, DepartmentId = num, MarkersLongitude = str, MarkersDimension = str2, PointerTitle = Globals.HtmlEncode(target), PointerContent = Globals.HtmlEncodeForSpaceWrap(content) }; if (!string.IsNullOrWhiteSpace(str5)) { model.PointImg = str5; } if (num2 < 1) { model.MapId = base.mapInfoManage.Add(model); } else { model.MapId = num2; base.mapInfoManage.Update(model); } obj2.Accumulate("STATUS", "OK"); obj2.Accumulate("DATA", model); context.Response.Write(obj2.ToString()); } } }
public bool Update(MapInfo model) { return this.dal.Update(model); }
public List<MapInfo> DataTableToList(DataTable dt) { List<MapInfo> list = new List<MapInfo>(); int count = dt.Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { MapInfo item = new MapInfo(); if ((dt.Rows[i]["MapId"] != null) && (dt.Rows[i]["MapId"].ToString() != "")) { item.MapId = int.Parse(dt.Rows[i]["MapId"].ToString()); } if ((dt.Rows[i]["UserId"] != null) && (dt.Rows[i]["UserId"].ToString() != "")) { item.UserId = int.Parse(dt.Rows[i]["UserId"].ToString()); } if ((dt.Rows[i]["DepartmentId"] != null) && (dt.Rows[i]["DepartmentId"].ToString() != "")) { item.DepartmentId = int.Parse(dt.Rows[i]["DepartmentId"].ToString()); } if ((dt.Rows[i]["PointerLongitude"] != null) && (dt.Rows[i]["PointerLongitude"].ToString() != "")) { item.PointerLongitude = dt.Rows[i]["PointerLongitude"].ToString(); } if ((dt.Rows[i]["PointDimension"] != null) && (dt.Rows[i]["PointDimension"].ToString() != "")) { item.PointDimension = dt.Rows[i]["PointDimension"].ToString(); } if ((dt.Rows[i]["PointClass"] != null) && (dt.Rows[i]["PointClass"].ToString() != "")) { item.PointClass = dt.Rows[i]["PointClass"].ToString(); } if ((dt.Rows[i]["PointerType"] != null) && (dt.Rows[i]["PointerType"].ToString() != "")) { item.PointerType = dt.Rows[i]["PointerType"].ToString(); } if ((dt.Rows[i]["PointerTitle"] != null) && (dt.Rows[i]["PointerTitle"].ToString() != "")) { item.PointerTitle = dt.Rows[i]["PointerTitle"].ToString(); } if ((dt.Rows[i]["PointImg"] != null) && (dt.Rows[i]["PointImg"].ToString() != "")) { item.PointImg = dt.Rows[i]["PointImg"].ToString(); } if ((dt.Rows[i]["PointerContent"] != null) && (dt.Rows[i]["PointerContent"].ToString() != "")) { item.PointerContent = dt.Rows[i]["PointerContent"].ToString(); } if ((dt.Rows[i]["SearchCity"] != null) && (dt.Rows[i]["SearchCity"].ToString() != "")) { item.SearchCity = dt.Rows[i]["SearchCity"].ToString(); } if ((dt.Rows[i]["searchArea"] != null) && (dt.Rows[i]["searchArea"].ToString() != "")) { item.searchArea = dt.Rows[i]["searchArea"].ToString(); } if ((dt.Rows[i]["Level"] != null) && (dt.Rows[i]["Level"].ToString() != "")) { item.Level = new int?(int.Parse(dt.Rows[i]["Level"].ToString())); } if ((dt.Rows[i]["enableKeyboard"] != null) && (dt.Rows[i]["enableKeyboard"].ToString() != "")) { if ((dt.Rows[i]["enableKeyboard"].ToString() == "1") || (dt.Rows[i]["enableKeyboard"].ToString().ToLower() == "true")) { item.enableKeyboard = true; } else { item.enableKeyboard = false; } } if ((dt.Rows[i]["enableScrollWheelZoom"] != null) && (dt.Rows[i]["enableScrollWheelZoom"].ToString() != "")) { if ((dt.Rows[i]["enableScrollWheelZoom"].ToString() == "1") || (dt.Rows[i]["enableScrollWheelZoom"].ToString().ToLower() == "true")) { item.enableScrollWheelZoom = true; } else { item.enableScrollWheelZoom = false; } } if ((dt.Rows[i]["NavigationControl"] != null) && (dt.Rows[i]["NavigationControl"].ToString() != "")) { if ((dt.Rows[i]["NavigationControl"].ToString() == "1") || (dt.Rows[i]["NavigationControl"].ToString().ToLower() == "true")) { item.NavigationControl = true; } else { item.NavigationControl = false; } } if ((dt.Rows[i]["ScaleControl"] != null) && (dt.Rows[i]["ScaleControl"].ToString() != "")) { if ((dt.Rows[i]["ScaleControl"].ToString() == "1") || (dt.Rows[i]["ScaleControl"].ToString().ToLower() == "true")) { item.ScaleControl = true; } else { item.ScaleControl = false; } } if ((dt.Rows[i]["MapTypeControl"] != null) && (dt.Rows[i]["MapTypeControl"].ToString() != "")) { if ((dt.Rows[i]["MapTypeControl"].ToString() == "1") || (dt.Rows[i]["MapTypeControl"].ToString().ToLower() == "true")) { item.MapTypeControl = true; } else { item.MapTypeControl = false; } } if ((dt.Rows[i]["MarkersLongitude"] != null) && (dt.Rows[i]["MarkersLongitude"].ToString() != "")) { item.MarkersLongitude = dt.Rows[i]["MarkersLongitude"].ToString(); } if ((dt.Rows[i]["Markersdimension"] != null) && (dt.Rows[i]["Markersdimension"].ToString() != "")) { item.MarkersDimension = dt.Rows[i]["Markersdimension"].ToString(); } if ((dt.Rows[i]["setAnimation"] != null) && (dt.Rows[i]["setAnimation"].ToString() != "")) { item.setAnimation = dt.Rows[i]["setAnimation"].ToString(); } if ((dt.Rows[i]["LoadEvent"] != null) && (dt.Rows[i]["LoadEvent"].ToString() != "")) { item.LoadEvent = dt.Rows[i]["LoadEvent"].ToString(); } if ((dt.Rows[i]["MenuItemzoomIn"] != null) && (dt.Rows[i]["MenuItemzoomIn"].ToString() != "")) { if ((dt.Rows[i]["MenuItemzoomIn"].ToString() == "1") || (dt.Rows[i]["MenuItemzoomIn"].ToString().ToLower() == "true")) { item.MenuItemzoomIn = true; } else { item.MenuItemzoomIn = false; } } if ((dt.Rows[i]["MenuItemzoomOut"] != null) && (dt.Rows[i]["MenuItemzoomOut"].ToString() != "")) { if ((dt.Rows[i]["MenuItemzoomOut"].ToString() == "1") || (dt.Rows[i]["MenuItemzoomOut"].ToString().ToLower() == "true")) { item.MenuItemzoomOut = true; } else { item.MenuItemzoomOut = false; } } if ((dt.Rows[i]["MenuItemsetZoomTop"] != null) && (dt.Rows[i]["MenuItemsetZoomTop"].ToString() != "")) { if ((dt.Rows[i]["MenuItemsetZoomTop"].ToString() == "1") || (dt.Rows[i]["MenuItemsetZoomTop"].ToString().ToLower() == "true")) { item.MenuItemsetZoomTop = true; } else { item.MenuItemsetZoomTop = false; } } if ((dt.Rows[i]["MenuItemsetPoint"] != null) && (dt.Rows[i]["MenuItemsetPoint"].ToString() != "")) { if ((dt.Rows[i]["MenuItemsetPoint"].ToString() == "1") || (dt.Rows[i]["MenuItemsetPoint"].ToString().ToLower() == "true")) { item.MenuItemsetPoint = true; } else { item.MenuItemsetPoint = false; } } if ((dt.Rows[i]["MapType"] != null) && (dt.Rows[i]["MapType"].ToString() != "")) { item.MapType = int.Parse(dt.Rows[i]["MapType"].ToString()); } if ((dt.Rows[i]["Other1"] != null) && (dt.Rows[i]["Other1"].ToString() != "")) { item.Other1 = dt.Rows[i]["Other1"].ToString(); } if ((dt.Rows[i]["Other2"] != null) && (dt.Rows[i]["Other2"].ToString() != "")) { item.Other2 = dt.Rows[i]["Other2"].ToString(); } if ((dt.Rows[i]["Other3"] != null) && (dt.Rows[i]["Other3"].ToString() != "")) { item.Other3 = dt.Rows[i]["Other3"].ToString(); } list.Add(item); } } return list; }
public int Add(MapInfo model) { return this.dal.Add(model); }
public bool Update(MapInfo model) { StringBuilder builder = new StringBuilder(); builder.Append("update Ms_Maps set "); builder.Append("UserId=@UserId,"); builder.Append("DepartmentId=@DepartmentId,"); builder.Append("PointerLongitude=@PointerLongitude,"); builder.Append("PointDimension=@PointDimension,"); builder.Append("PointClass=@PointClass,"); builder.Append("PointerType=@PointerType,"); builder.Append("PointerTitle=@PointerTitle,"); builder.Append("PointImg=@PointImg,"); builder.Append("PointerContent=@PointerContent,"); builder.Append("SearchCity=@SearchCity,"); builder.Append("searchArea=@searchArea,"); builder.Append("Level=@Level,"); builder.Append("enableKeyboard=@enableKeyboard,"); builder.Append("enableScrollWheelZoom=@enableScrollWheelZoom,"); builder.Append("NavigationControl=@NavigationControl,"); builder.Append("ScaleControl=@ScaleControl,"); builder.Append("MapTypeControl=@MapTypeControl,"); builder.Append("MarkersLongitude=@MarkersLongitude,"); builder.Append("MarkersDimension=@MarkersDimension,"); builder.Append("setAnimation=@setAnimation,"); builder.Append("LoadEvent=@LoadEvent,"); builder.Append("MenuItemzoomIn=@MenuItemzoomIn,"); builder.Append("MenuItemzoomOut=@MenuItemzoomOut,"); builder.Append("MenuItemsetZoomTop=@MenuItemsetZoomTop,"); builder.Append("MenuItemsetPoint=@MenuItemsetPoint,"); builder.Append("MapType=@MapType,"); builder.Append("Other1=@Other1,"); builder.Append("Other2=@Other2,"); builder.Append("Other3=@Other3"); builder.Append(" where MapId=@MapId"); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@UserId", SqlDbType.Int, 4), new SqlParameter("@DepartmentId", SqlDbType.Int, 4), new SqlParameter("@PointerLongitude", SqlDbType.NVarChar, 100), new SqlParameter("@PointDimension", SqlDbType.NVarChar, 100), new SqlParameter("@PointClass", SqlDbType.NVarChar, 100), new SqlParameter("@PointerType", SqlDbType.NVarChar, 100), new SqlParameter("@PointerTitle", SqlDbType.NVarChar, 100), new SqlParameter("@PointImg", SqlDbType.NVarChar, 100), new SqlParameter("@PointerContent", SqlDbType.NVarChar, 300), new SqlParameter("@SearchCity", SqlDbType.NVarChar, 50), new SqlParameter("@searchArea", SqlDbType.NVarChar, 50), new SqlParameter("@Level", SqlDbType.Int, 4), new SqlParameter("@enableKeyboard", SqlDbType.Bit, 1), new SqlParameter("@enableScrollWheelZoom", SqlDbType.Bit, 1), new SqlParameter("@NavigationControl", SqlDbType.Bit, 1), new SqlParameter("@ScaleControl", SqlDbType.Bit, 1), new SqlParameter("@MapTypeControl", SqlDbType.Bit, 1), new SqlParameter("@MarkersLongitude", SqlDbType.NVarChar, 100), new SqlParameter("@MarkersDimension", SqlDbType.NVarChar, 100), new SqlParameter("@setAnimation", SqlDbType.NVarChar, 100), new SqlParameter("@LoadEvent", SqlDbType.NVarChar, 50), new SqlParameter("@MenuItemzoomIn", SqlDbType.Bit, 1), new SqlParameter("@MenuItemzoomOut", SqlDbType.Bit, 1), new SqlParameter("@MenuItemsetZoomTop", SqlDbType.Bit, 1), new SqlParameter("@MenuItemsetPoint", SqlDbType.Bit, 1), new SqlParameter("@MapType", SqlDbType.SmallInt, 2), new SqlParameter("@Other1", SqlDbType.NVarChar, 100), new SqlParameter("@Other2", SqlDbType.NVarChar, 100), new SqlParameter("@Other3", SqlDbType.NVarChar, 50), new SqlParameter("@MapId", SqlDbType.Int, 4) }; cmdParms[0].Value = model.UserId; cmdParms[1].Value = model.DepartmentId; cmdParms[2].Value = model.PointerLongitude; cmdParms[3].Value = model.PointDimension; cmdParms[4].Value = model.PointClass; cmdParms[5].Value = model.PointerType; cmdParms[6].Value = model.PointerTitle; cmdParms[7].Value = model.PointImg; cmdParms[8].Value = model.PointerContent; cmdParms[9].Value = model.SearchCity; cmdParms[10].Value = model.searchArea; cmdParms[11].Value = model.Level; cmdParms[12].Value = model.enableKeyboard; cmdParms[13].Value = model.enableScrollWheelZoom; cmdParms[14].Value = model.NavigationControl; cmdParms[15].Value = model.ScaleControl; cmdParms[0x10].Value = model.MapTypeControl; cmdParms[0x11].Value = model.MarkersLongitude; cmdParms[0x12].Value = model.MarkersDimension; cmdParms[0x13].Value = model.setAnimation; cmdParms[20].Value = model.LoadEvent; cmdParms[0x15].Value = model.MenuItemzoomIn; cmdParms[0x16].Value = model.MenuItemzoomOut; cmdParms[0x17].Value = model.MenuItemsetZoomTop; cmdParms[0x18].Value = model.MenuItemsetPoint; cmdParms[0x19].Value = model.MapType; cmdParms[0x1a].Value = model.Other1; cmdParms[0x1b].Value = model.Other2; cmdParms[0x1c].Value = model.Other3; cmdParms[0x1d].Value = model.MapId; return (DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0); }
private static MapInfo GetMapInfo(StringBuilder strSql, SqlParameter[] parameters) { MapInfo info = new MapInfo(); DataSet set = DbHelperSQL.Query(strSql.ToString(), parameters); if (set.Tables[0].Rows.Count <= 0) { return null; } if ((set.Tables[0].Rows[0]["MapId"] != null) && (set.Tables[0].Rows[0]["MapId"].ToString() != "")) { info.MapId = int.Parse(set.Tables[0].Rows[0]["MapId"].ToString()); } if ((set.Tables[0].Rows[0]["UserId"] != null) && (set.Tables[0].Rows[0]["UserId"].ToString() != "")) { info.UserId = int.Parse(set.Tables[0].Rows[0]["UserId"].ToString()); } if ((set.Tables[0].Rows[0]["DepartmentId"] != null) && (set.Tables[0].Rows[0]["DepartmentId"].ToString() != "")) { info.DepartmentId = int.Parse(set.Tables[0].Rows[0]["DepartmentId"].ToString()); } if ((set.Tables[0].Rows[0]["PointerLongitude"] != null) && (set.Tables[0].Rows[0]["PointerLongitude"].ToString() != "")) { info.PointerLongitude = set.Tables[0].Rows[0]["PointerLongitude"].ToString(); } if ((set.Tables[0].Rows[0]["PointDimension"] != null) && (set.Tables[0].Rows[0]["PointDimension"].ToString() != "")) { info.PointDimension = set.Tables[0].Rows[0]["PointDimension"].ToString(); } if ((set.Tables[0].Rows[0]["PointClass"] != null) && (set.Tables[0].Rows[0]["PointClass"].ToString() != "")) { info.PointClass = set.Tables[0].Rows[0]["PointClass"].ToString(); } if ((set.Tables[0].Rows[0]["PointerType"] != null) && (set.Tables[0].Rows[0]["PointerType"].ToString() != "")) { info.PointerType = set.Tables[0].Rows[0]["PointerType"].ToString(); } if ((set.Tables[0].Rows[0]["PointerTitle"] != null) && (set.Tables[0].Rows[0]["PointerTitle"].ToString() != "")) { info.PointerTitle = set.Tables[0].Rows[0]["PointerTitle"].ToString(); } if ((set.Tables[0].Rows[0]["PointImg"] != null) && (set.Tables[0].Rows[0]["PointImg"].ToString() != "")) { info.PointImg = set.Tables[0].Rows[0]["PointImg"].ToString(); } if ((set.Tables[0].Rows[0]["PointerContent"] != null) && (set.Tables[0].Rows[0]["PointerContent"].ToString() != "")) { info.PointerContent = set.Tables[0].Rows[0]["PointerContent"].ToString(); } if ((set.Tables[0].Rows[0]["SearchCity"] != null) && (set.Tables[0].Rows[0]["SearchCity"].ToString() != "")) { info.SearchCity = set.Tables[0].Rows[0]["SearchCity"].ToString(); } if ((set.Tables[0].Rows[0]["searchArea"] != null) && (set.Tables[0].Rows[0]["searchArea"].ToString() != "")) { info.searchArea = set.Tables[0].Rows[0]["searchArea"].ToString(); } if ((set.Tables[0].Rows[0]["Level"] != null) && (set.Tables[0].Rows[0]["Level"].ToString() != "")) { info.Level = new int?(int.Parse(set.Tables[0].Rows[0]["Level"].ToString())); } if ((set.Tables[0].Rows[0]["enableKeyboard"] != null) && (set.Tables[0].Rows[0]["enableKeyboard"].ToString() != "")) { if ((set.Tables[0].Rows[0]["enableKeyboard"].ToString() == "1") || (set.Tables[0].Rows[0]["enableKeyboard"].ToString().ToLower() == "true")) { info.enableKeyboard = true; } else { info.enableKeyboard = false; } } if ((set.Tables[0].Rows[0]["enableScrollWheelZoom"] != null) && (set.Tables[0].Rows[0]["enableScrollWheelZoom"].ToString() != "")) { if ((set.Tables[0].Rows[0]["enableScrollWheelZoom"].ToString() == "1") || (set.Tables[0].Rows[0]["enableScrollWheelZoom"].ToString().ToLower() == "true")) { info.enableScrollWheelZoom = true; } else { info.enableScrollWheelZoom = false; } } if ((set.Tables[0].Rows[0]["NavigationControl"] != null) && (set.Tables[0].Rows[0]["NavigationControl"].ToString() != "")) { if ((set.Tables[0].Rows[0]["NavigationControl"].ToString() == "1") || (set.Tables[0].Rows[0]["NavigationControl"].ToString().ToLower() == "true")) { info.NavigationControl = true; } else { info.NavigationControl = false; } } if ((set.Tables[0].Rows[0]["ScaleControl"] != null) && (set.Tables[0].Rows[0]["ScaleControl"].ToString() != "")) { if ((set.Tables[0].Rows[0]["ScaleControl"].ToString() == "1") || (set.Tables[0].Rows[0]["ScaleControl"].ToString().ToLower() == "true")) { info.ScaleControl = true; } else { info.ScaleControl = false; } } if ((set.Tables[0].Rows[0]["MapTypeControl"] != null) && (set.Tables[0].Rows[0]["MapTypeControl"].ToString() != "")) { if ((set.Tables[0].Rows[0]["MapTypeControl"].ToString() == "1") || (set.Tables[0].Rows[0]["MapTypeControl"].ToString().ToLower() == "true")) { info.MapTypeControl = true; } else { info.MapTypeControl = false; } } if ((set.Tables[0].Rows[0]["MarkersLongitude"] != null) && (set.Tables[0].Rows[0]["MarkersLongitude"].ToString() != "")) { info.MarkersLongitude = set.Tables[0].Rows[0]["MarkersLongitude"].ToString(); } if ((set.Tables[0].Rows[0]["MarkersDimension"] != null) && (set.Tables[0].Rows[0]["MarkersDimension"].ToString() != "")) { info.MarkersDimension = set.Tables[0].Rows[0]["MarkersDimension"].ToString(); } if ((set.Tables[0].Rows[0]["setAnimation"] != null) && (set.Tables[0].Rows[0]["setAnimation"].ToString() != "")) { info.setAnimation = set.Tables[0].Rows[0]["setAnimation"].ToString(); } if ((set.Tables[0].Rows[0]["LoadEvent"] != null) && (set.Tables[0].Rows[0]["LoadEvent"].ToString() != "")) { info.LoadEvent = set.Tables[0].Rows[0]["LoadEvent"].ToString(); } if ((set.Tables[0].Rows[0]["MenuItemzoomIn"] != null) && (set.Tables[0].Rows[0]["MenuItemzoomIn"].ToString() != "")) { if ((set.Tables[0].Rows[0]["MenuItemzoomIn"].ToString() == "1") || (set.Tables[0].Rows[0]["MenuItemzoomIn"].ToString().ToLower() == "true")) { info.MenuItemzoomIn = true; } else { info.MenuItemzoomIn = false; } } if ((set.Tables[0].Rows[0]["MenuItemzoomOut"] != null) && (set.Tables[0].Rows[0]["MenuItemzoomOut"].ToString() != "")) { if ((set.Tables[0].Rows[0]["MenuItemzoomOut"].ToString() == "1") || (set.Tables[0].Rows[0]["MenuItemzoomOut"].ToString().ToLower() == "true")) { info.MenuItemzoomOut = true; } else { info.MenuItemzoomOut = false; } } if ((set.Tables[0].Rows[0]["MenuItemsetZoomTop"] != null) && (set.Tables[0].Rows[0]["MenuItemsetZoomTop"].ToString() != "")) { if ((set.Tables[0].Rows[0]["MenuItemsetZoomTop"].ToString() == "1") || (set.Tables[0].Rows[0]["MenuItemsetZoomTop"].ToString().ToLower() == "true")) { info.MenuItemsetZoomTop = true; } else { info.MenuItemsetZoomTop = false; } } if ((set.Tables[0].Rows[0]["MenuItemsetPoint"] != null) && (set.Tables[0].Rows[0]["MenuItemsetPoint"].ToString() != "")) { if ((set.Tables[0].Rows[0]["MenuItemsetPoint"].ToString() == "1") || (set.Tables[0].Rows[0]["MenuItemsetPoint"].ToString().ToLower() == "true")) { info.MenuItemsetPoint = true; } else { info.MenuItemsetPoint = false; } } if ((set.Tables[0].Rows[0]["MapType"] != null) && (set.Tables[0].Rows[0]["MapType"].ToString() != "")) { info.MapType = int.Parse(set.Tables[0].Rows[0]["MapType"].ToString()); } if ((set.Tables[0].Rows[0]["Other1"] != null) && (set.Tables[0].Rows[0]["Other1"].ToString() != "")) { info.Other1 = set.Tables[0].Rows[0]["Other1"].ToString(); } if ((set.Tables[0].Rows[0]["Other2"] != null) && (set.Tables[0].Rows[0]["Other2"].ToString() != "")) { info.Other2 = set.Tables[0].Rows[0]["Other2"].ToString(); } if ((set.Tables[0].Rows[0]["Other3"] != null) && (set.Tables[0].Rows[0]["Other3"].ToString() != "")) { info.Other3 = set.Tables[0].Rows[0]["Other3"].ToString(); } return info; }