/// <summary> /// 字段对应描述列表 /// </summary> /// <param name="dt"></param> /// <returns></returns> public Dictionary <string, string> ConvertColumn(DataTable dt) { Dictionary <string, string> dic = new Dictionary <string, string>(); RoadFlow.Platform.DBConnection conn = new RoadFlow.Platform.DBConnection(); dic = conn.GetFields(conn.GetAll().First <RoadFlow.Data.Model.DBConnection>().ID, "[Buildings]");//获取所有字段名 string name = string.Empty; for (int j = 0; j < dt.Columns.Count; j++) { if (dic.Keys.Contains(dt.Columns[j].ColumnName)) { name = dic[dt.Columns[j].ColumnName]; if (!name.IsNullOrEmpty()) { dic.Add(dt.Columns[j].ColumnName, name); } } } return(dic); }
public ActionResult DisplayItem(FormCollection collection) { RoadFlow.Data.Model.QueryDesign model = new QueryDesign(); Dictionary <string, string> dic = new Dictionary <string, string>(); ViewBag.Query1 = string.Format("&appid={0}&tabid={1}", Request.QueryString["appid"], Request.QueryString["tabid"]); string id = Request.QueryString["id"]; string tableName = Request.QueryString["table"]; string connid = Request.QueryString["connid"]; string name = Request["SJCXNAMEFVHJ"]; dic = conn.GetFields(connid.Convert <Guid>(), tableName); if (id.IsNullOrEmpty()) { if (!Request["save"].IsNullOrEmpty()) { string eleme = Request["reldata"]; eleme = "[" + eleme + "]"; model.ID = Guid.NewGuid(); model.Name = name; model.TableName = tableName; model.CreateUserID = RoadFlow.Platform.UsersBLL.CurrentUserID; model.CreateUserName = RoadFlow.Platform.UsersBLL.CurrentUserName; model.ConnectionID = connid.Convert <Guid>(); model.DisplayItem = eleme; model.Status = 0; queryDesign.Add(model); ViewBag.Script = "alert('保存成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();"; } else { model.Name = name; model.TableName = tableName; model.ConnectionID = connid.Convert <Guid>(); } } else { model = queryDesign.Get(id.Convert <Guid>()); if (connid.IsNullOrEmpty() || tableName.IsNullOrEmpty()) { tableName = model.TableName; connid = model.ConnectionID.ToString(); dic = conn.GetFields(connid.Convert <Guid>(), tableName); } if (!Request["save"].IsNullOrEmpty()) { string eleme = Request["reldata"]; eleme = "[" + eleme + "]"; model.Name = name; model.TableName = tableName; model.ConnectionID = connid.Convert <Guid>(); model.DisplayItem = eleme; queryDesign.Update(model); ViewBag.Script = "alert('保存成功!');new RoadUI.Window().reloadOpener();new RoadUI.Window().close();"; } } ViewBag.DisplayItem = model.DisplayItem; ViewBag.Connid = model.ConnectionID; ViewBag.TableName = model.TableName; ViewBag.Name = model.Name; return(View(dic)); }