private static List<ExceptionsInfo> GetValue(string sql)
{
List<ExceptionsInfo> list = new List<ExceptionsInfo>();
OleDbDataReader odr = DBHelper.GetReader(sql);
while (odr.Read())
{
ExceptionsInfo ei = new ExceptionsInfo();
ei.ID = Convert.ToInt32(odr["ID"]);
ei.UserID = odr["userid"].ToString();
ei.ProjectID = odr["projectid"].ToString();
ei.TypeID = odr["typeid"].ToString();
ei.ExcepitionID = odr["exceptionid"].ToString();
ei.ExcepitionName = odr["ExceptionName"].ToString();
ei.ExcepitionDescri = odr["ExceptionDescription"].ToString();
ei.Solution = odr["solution"].ToString();
ei.Remarks = odr["remarks"].ToString();
list.Add(ei);
}
odr.Close();
return list;
}
/// <summary>
/// 在屏幕中添加标记元素
/// </summary>
/// <param name="n"></param>
private void drawElement(ExceptionsInfo n)
{
IFeature pFeature;
IQueryFilter pQFilter = new QueryFilter();
pQFilter.WhereClause = "\"projectName\"='" + n.ProjectID+"'";
IFeatureLayer pFlayer = LayerHelper.getFeatureLayerFromMap(axMapControl1.Map, "Cities"); //获取特定图层
IFeatureCursor pFtCursor =pFlayer.Search(pQFilter, true); //查找对应结果的要素
IRgbColor pColor1 = setRGBColor(255, 0, 0, 255);
IRgbColor pColor2 = setRGBColor(0, 255, 0, 255);
IElement ele =createElement(pColor1, pColor2);
IElementProperties pEleProperties = (IElementProperties)ele;
pEleProperties.Name = n.ProjectID; //设置element的Name属性方便查找
IGraphicsContainer pGContainer = axMapControl1.Map as IGraphicsContainer;
IActiveView pView = pGContainer as IActiveView;
while ((pFeature = pFtCursor.NextFeature()) != null)
{
IPoint pPoint = pFeature.Shape as IPoint;
IElement pEleTemp;
IEnumElement pEnumEle = queryElementOnMap(pPoint, 0);
if (pEnumEle != null) //检查地图中是否已存在此元素
{
while ((pEleTemp = pEnumEle.Next()) != null)
{
IElementProperties pEleProTemp = (IElementProperties)pEleTemp;
if (pEleProTemp.Name == n.ProjectID) return;
//if (!pEleProTemp.Name.Contains(n.ProjectID))
//{
// pEleProTemp.Name += "," + n.ProjectID;
// pGContainer.UpdateElement((IElement)pEleProTemp);
// return;
//}
}
}
ele.Geometry = pPoint;
pGContainer.AddElement(ele, 0);
}
}
/// <summary>
/// 新建结果按钮
/// </summary>
/// <param name="n"></param>
/// <returns></returns>
private Button createNewButton(ExceptionsInfo n)
{
Button btn = new Button();
btn.BackColor = _witheColor;
btn.BackgroundImageLayout = System.Windows.Forms.ImageLayout.None;
btn.FlatAppearance.BorderSize = 0;
btn.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
btn.Margin = new System.Windows.Forms.Padding(0, 2, 0, 2);
btn.Size = new System.Drawing.Size(205, 62);
btn.Text = "ID：" + n.ID + "，" + n.ExcepitionName + "\r\n标签：" + n.ProjectID + "，" + n.UserID + "\r\n异常信息：" + n.ExcepitionID + "，" + n.TypeID + "\r\n问题描述：" + n.ExcepitionDescri;
//btn.Text = "ID：" + n.ID + "，" + n.ExcepitionName + "\r\n标签：" + n.ProjectName + "，" + n.UserID + "\r\n异常信息：" + n.ExcepitionID + "，" + n.TypeID + "\r\n问题描述：" + n.ExcepitionDescri;
btn.Tag = n.ProjectID;
btn.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
btn.UseVisualStyleBackColor = true;
btn.Click += new System.EventHandler(this.btnResultArr_Click);
btn.MouseEnter += new System.EventHandler(changeElementStyle);
btn.MouseLeave += new System.EventHandler(rollBackElementStyle);
return btn;
}
