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