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;
}