public bool API_DelObjFromDataByObjServerId(int iObjServerId) { bool bResult = false; string strSql = "Delete from ObjTable where id = @id"; string strConn = YimaDataBase.GetSqlConnectionString(); using (OleDbConnection conn = new OleDbConnection(strConn)) { using (OleDbCommand cmd = new OleDbCommand(strSql, conn)) { cmd.Parameters.Add("id", OleDbType.Integer); cmd.Parameters["id"].Value = iObjServerId; try { conn.Open(); int i = cmd.ExecuteNonQuery(); if (i > 0) { bResult = true; } } catch (Exception ex) { string message = ex.ToString(); } } } return(bResult); }
public string API_GetPointObjectImgSizeFromData(int iObjServerId) { string strObjInfo = ""; JSONHelper jsonHelper = new JSONHelper(); string strSql = "select iObjImgWidth,iObjImgHeight from ObjTable where id = " + iObjServerId.ToString(); string strConn = YimaDataBase.GetSqlConnectionString(); DataSet ds = YimaDataBase.ExecuteSqlReDataSet(strSql, strConn); int iObjCount = ds.Tables[0].Rows.Count; if (iObjCount > 0) { string objImgWidth = ds.Tables[0].Rows[0]["iObjImgWidth"].ToString(); string objImgHeight = ds.Tables[0].Rows[0]["iObjImgHeight"].ToString(); jsonHelper.AddItem("objImgWidth", objImgWidth); jsonHelper.AddItem("objImgHeight", objImgHeight); jsonHelper.ItemOk(); } strObjInfo = jsonHelper.ToString(); return(strObjInfo); }
public bool API_SetObjImgUrlByServerId(int iServerId, string strObjImgUrl) { bool bResult = false; int imgWidth = 0; int imgHeight = 0; bool bGetSizeResult = API_GetImgSizeByUrl(strObjImgUrl, ref imgWidth, ref imgHeight); if (bGetSizeResult == true) { string strConn = YimaDataBase.GetSqlConnectionString(); strObjImgUrl = strObjImgUrl.Replace("'", "‘"); string strSql = "update ObjTable set strObjImgUrl='" + strObjImgUrl + "',iObjImgWidth=" + imgWidth.ToString() + ",iObjImgHeight=" + imgHeight.ToString() + " where id = " + iServerId.ToString(); int ii = YimaDataBase.ExecuteSql(strSql, strConn); if (ii > 0) { bResult = true; } /* * string strSql = "update ObjTable set strObjImgUrl=@objImgUrl,iObjImgWidth=@iObjImgWidth,iObjImgHeight=@iObjImgHeight where id = @id"; * using (OleDbConnection conn = new OleDbConnection(strConn)) * { * using (OleDbCommand cmd = new OleDbCommand(strSql, conn)) * { * cmd.Parameters.Add("id", OleDbType.Integer); * cmd.Parameters["id"].Value = iServerId; * * cmd.Parameters.Add("objImgUrl", OleDbType.VarChar, 50); * cmd.Parameters["objImgUrl"].Value = strObjImgUrl; * * cmd.Parameters.Add("iObjImgWidth", OleDbType.Integer); * cmd.Parameters["iObjImgWidth"].Value = imgWidth; * * cmd.Parameters.Add("iObjImgHeight", OleDbType.Integer); * cmd.Parameters["iObjImgHeight"].Value = imgHeight; * * try * { * conn.Open(); * int i = cmd.ExecuteNonQuery(); * * if (i > 0) * { * bResult = true; * } * } * catch (Exception ex) * { * string message = ex.ToString(); * } * } * } * */ } return(bResult); }
public bool API_SetObjectGeoByServerId(int iServerId, string strObjGeo) { bool bResult = false; //string strSql = "update ObjTable set strObjGeo=@objGeo where id = @id"; string strConn = YimaDataBase.GetSqlConnectionString(); strObjGeo = strObjGeo.Replace("'", "‘"); string strSql = "update ObjTable set strObjGeo='" + strObjGeo + "' where id = " + iServerId.ToString(); int ii = YimaDataBase.ExecuteSql(strSql, strConn); if (ii > 0) { bResult = true; } return(ii > 0); /* * using (OleDbConnection conn = new OleDbConnection(strConn)) * { * using (OleDbCommand cmd = new OleDbCommand(strSql, conn)) * { * cmd.Parameters.Add("id", OleDbType.Integer); * cmd.Parameters["id"].Value = iServerId; * * cmd.Parameters.Add("objGeo", OleDbType.VarChar, 2000); * cmd.Parameters["objGeo"].Value = strObjGeo; * * try * { * conn.Open(); * int i = cmd.ExecuteNonQuery(); * * if (i > 0) * { * bResult = true; * } * } * catch (Exception ex) * { * string message = ex.ToString(); * } * } * } * * return bResult; */ }
public string API_GetAllObjectInfoFromData() { string strObjInfo = ""; string strSql = "select id,iObjLayerId,strObjName,strObjContent,strObjGeo,dtObjDate,strCompany,iObjStyleId,strObjImgUrl,iObjImgWidth,iObjImgHeight from ObjTable order by iObjLayerId "; string strConn = YimaDataBase.GetSqlConnectionString(); DataSet ds = YimaDataBase.ExecuteSqlReDataSet(strSql, strConn); int iObjCount = ds.Tables[0].Rows.Count; JSONHelper jsonHelper = new JSONHelper(); for (int i = 0; i < iObjCount; i++) { string strServerId = ds.Tables[0].Rows[i]["id"].ToString(); string strObjLayerId = ds.Tables[0].Rows[i]["iObjLayerId"].ToString(); string strObjName = ds.Tables[0].Rows[i]["strObjName"].ToString(); string strObjContent = ds.Tables[0].Rows[i]["strObjContent"].ToString(); string strObjGeo = ds.Tables[0].Rows[i]["strObjGeo"].ToString(); string strObjDate = ds.Tables[0].Rows[i]["dtObjDate"].ToString(); string strCompany = ds.Tables[0].Rows[i]["strCompany"].ToString(); string strObjStyleId = ds.Tables[0].Rows[i]["iObjStyleId"].ToString(); string strObjImgUrl = ds.Tables[0].Rows[i]["strObjImgUrl"].ToString(); string strObjImgWidth = ds.Tables[0].Rows[i]["iObjImgWidth"].ToString(); string strObjImgHeight = ds.Tables[0].Rows[i]["iObjImgHeight"].ToString(); jsonHelper.AddItem("strServerId", strServerId); jsonHelper.AddItem("strObjLayerId", strObjLayerId); jsonHelper.AddItem("strObjName", strObjName); jsonHelper.AddItem("strObjContent", strObjContent); jsonHelper.AddItem("strObjGeo", strObjGeo); jsonHelper.AddItem("strObjDate", strObjDate); jsonHelper.AddItem("strObjStyleId", strObjStyleId); jsonHelper.AddItem("strObjImgUrl", strObjImgUrl); jsonHelper.AddItem("strObjImgWidth", strObjImgWidth); jsonHelper.AddItem("strObjImgHeight", strObjImgHeight); jsonHelper.ItemOk(); } strObjInfo = jsonHelper.ToString(); return(strObjInfo); }
public bool API_SetObjectContentByServerId(int iServerId, string strObjectContent) { strObjectContent = strObjectContent.Replace("'", "’"); string strConn = YimaDataBase.GetSqlConnectionString(); string strSql = "update ObjTable set strObjContent='" + strObjectContent + "' where id = " + iServerId.ToString(); int ii = YimaDataBase.ExecuteSql(strSql, strConn); return(ii > 0); /* * string strSql = "update ObjTable set strObjContent=@strObjContent where id = @id"; * using (OleDbConnection conn = new OleDbConnection(strConn)) * { * using (OleDbCommand cmd = new OleDbCommand(strSql, conn)) * { * cmd.Parameters.Add("id", OleDbType.Integer); * cmd.Parameters["id"].Value = iServerId; * * cmd.Parameters.Add("strObjContent", OleDbType.VarChar, 100); * cmd.Parameters["strObjContent"].Value = strObjectContent; * * try * { * conn.Open(); * int i = cmd.ExecuteNonQuery(); * * if (i > 0) * { * bResult = true; * } * } * catch (Exception ex) * { * string message = ex.ToString(); * } * } * } * return bResult; */ }
/// <summary> /// 添加一个图层 /// </summary> /// <param name="strLayerName">图层名称(string)</param> /// <param name="iLayerType">图层类型(int):1=点图层、2=线图层、3=面图层</param> /// <param name="iIsShowOrNot">图层是否显示(int):1=显示,0=隐藏</param> /// <param name="strContent">备注(string)</param> /// <returns></returns> public static int AddNewLayer(string strLayerName, int iLayerType, int iIsShowOrNot, string strContent) { int iPointServerId = -1; string strSql = "insert into LayerTable(iObjLayerId,strObjName,strObjContent,strObjGeo,dtObjDate,strCompany,iObjStyleId,strObjImgUrl,iObjImgWidth,iObjImgHeight)values(@objLayerId,@objName,@objContent,@objGeo,@objDate,@company,@objStyleId,@objImgUrl,@objImgWidth,@objImgHeight)"; string strConn = YimaDataBase.GetSqlConnectionString(); using (OleDbConnection conn = new OleDbConnection(strConn)) { using (OleDbCommand cmd = new OleDbCommand(strSql, conn)) { cmd.Parameters.Add("objLayerId", OleDbType.Integer); cmd.Parameters["objLayerId"].Value = Convert.ToInt32(objLayerId); cmd.Parameters.Add("objName", OleDbType.VarChar, 50); cmd.Parameters["objName"].Value = objName; cmd.Parameters.Add("objContent", OleDbType.VarChar, 100); cmd.Parameters["objContent"].Value = objContent; } } }
//添加新物标信息到数据库,并返回物标的再数据库中的id,即serverId public int API_AddObjToData(string objLayerId, string objType, string objName, string objContent, string objGeo, string company, string objStyleId, string objImgUrl) { int imgWidth = 0; int imgHeight = 0; if (!objImgUrl.Equals("")) { API_GetImgSizeByUrl(objImgUrl, ref imgWidth, ref imgHeight); } int iPointServerId = -1; string strSql = "insert into ObjTable(iObjLayerId,strObjName,strObjContent,strObjGeo,dtObjDate,strCompany,iObjStyleId,strObjImgUrl,iObjImgWidth,iObjImgHeight)values(@objLayerId,@objName,@objContent,@objGeo,@objDate,@company,@objStyleId,@objImgUrl,@objImgWidth,@objImgHeight)"; string strConn = YimaDataBase.GetSqlConnectionString(); using (OleDbConnection conn = new OleDbConnection(strConn)) { using (OleDbCommand cmd = new OleDbCommand(strSql, conn)) { cmd.Parameters.Add("objLayerId", OleDbType.Integer); cmd.Parameters["objLayerId"].Value = Convert.ToInt32(objLayerId); cmd.Parameters.Add("objName", OleDbType.VarChar, 50); cmd.Parameters["objName"].Value = objName; cmd.Parameters.Add("objContent", OleDbType.VarChar, 100); cmd.Parameters["objContent"].Value = objContent; cmd.Parameters.Add("objGeo", OleDbType.VarChar, 2000); cmd.Parameters["objGeo"].Value = objGeo; cmd.Parameters.Add("objDate", OleDbType.Date); cmd.Parameters["objDate"].Value = DateTime.Now; cmd.Parameters.Add("company", OleDbType.VarChar, 50); cmd.Parameters["company"].Value = company; cmd.Parameters.Add("objStyleId", OleDbType.Integer); cmd.Parameters["objStyleId"].Value = Convert.ToInt32(objStyleId); cmd.Parameters.Add("objImgUrl", OleDbType.VarChar, 50); cmd.Parameters["objImgUrl"].Value = objImgUrl; cmd.Parameters.Add("objImgWidth", OleDbType.Integer); cmd.Parameters["objImgWidth"].Value = imgWidth; cmd.Parameters.Add("objImgHeight", OleDbType.Integer); cmd.Parameters["objImgHeight"].Value = imgHeight; try { conn.Open(); int i = cmd.ExecuteNonQuery(); if (i > 0)//得到刚刚插入的记录id(即标注id) { cmd.CommandText = "select @@identity as id"; iPointServerId = Convert.ToInt32(cmd.ExecuteScalar()); } } catch (Exception ex) { string message = ex.ToString(); } } } return(iPointServerId); }