public string GetAllIsiType(string isitype, string sub_isitype, string end_isitype)
{
string str_isi = "";
string str_subisi = "";
string str_endisi = "";
DataDict isi = db.DataDicts.Where(i => i.ID.ToString().Trim() == isitype.Trim()).SingleOrDefault();
if (isi != null)
{
str_isi = isi.DataDictName;
}
DataDict subisi = db.DataDicts.Where(i => i.ID.ToString().Trim() == sub_isitype.Trim()).SingleOrDefault();
if (subisi != null)
{
str_subisi = "->" + subisi.DataDictName;
}
DataDict endisi = db.DataDicts.Where(i => i.ID.ToString().Trim() == end_isitype.Trim()).SingleOrDefault();
if (endisi != null)
{
str_endisi = "->" + endisi.DataDictName;
}
return(str_isi + str_subisi + str_endisi);
}
public ActionResult EditDataDict(DataDict dd)
{
if (ModelState.IsValid)
{
db.Entry(dd).State = EntityState.Modified;
try
{
db.SaveChanges();
var json = new
{
okMsg = "修改成功"
};
return(Json(json, "text/html", JsonRequestBehavior.AllowGet));
}
catch
{
var json = new
{
errorMsg = "保存数据出错"
};
return(Json(json, "text/html", JsonRequestBehavior.AllowGet));
}
}
else
{
var json = new
{
errorMsg = "验证错误"
};
return(Json(json, "text/html", JsonRequestBehavior.AllowGet));
}
}
public ActionResult DelDataDict(int id, int pid)
{
if (pid != 0)
{
DataDict porg = db.DataDicts.Where(t => t.parentId == id).FirstOrDefault();
if (porg != null)
{
var json = new
{
errorMsg = "删除失败，需保证此数据字典下没有子数据字典"
};
return(Json(json, "text/html", JsonRequestBehavior.AllowGet));
}
else
{
DataDict dd = db.DataDicts.Find(id);
if (dd == null)
{
var json = new
{
errorMsg = "删除失败"
};
return(Json(json, "text/html", JsonRequestBehavior.AllowGet));
}
else
{
try
{
db.DataDicts.Remove(dd);
db.SaveChanges();
var json = new
{
okMsg = "删除成功"
};
return(Json(json, "text/html", JsonRequestBehavior.AllowGet));
}
catch
{
var json = new
{
errorMsg = "数据库操作失败"
};
return(Json(json, "text/html", JsonRequestBehavior.AllowGet));
}
}
}
}
else
{
var json = new
{
errorMsg = "根数据字典不能删除"
};
return(Json(json, "text/html", JsonRequestBehavior.AllowGet));
}
}
public IActionResult ArticleTypeSave(DataDict dataDict)
{
dataDict.DictType = DataDictType.文章类型;
var ro = _dataDictService.Edit(dataDict);
return(Json(ro));
}
public IActionResult Save(DataDict dataDict)
{
dataDict.DictType = dictType;
var ro = _dataDictService.Edit(dataDict);
return(Json(ro));
}
public override Dictionary <string, Rect> ParseData(string name, string data)
{
if (!DataDict.ContainsKey(name))
{
DataDict.Add(name, new Dictionary <string, Rect>());
JsonReader reader = new JsonReader();
UnityJsonData jsonData = reader.Read <UnityJsonData>(data);
DualSize texSize = jsonData.meta.size;
foreach (KeyValuePair <string, Frame> item in jsonData.frames)
{
string frameName = item.Key;
Frame frameData = item.Value;
// Calculate
Vector2 scale = new Vector2(frameData.frame.w / texSize.w, frameData.frame.h / texSize.h);
Vector2 offset = new Vector2(frameData.frame.x / texSize.w, (texSize.h - frameData.frame.y - frameData.sourceSize.h) / texSize.h);
Rect rect = new Rect(offset.x, offset.y, scale.x, scale.y);
DataDict[name].Add(frameName, rect);
}
}
return(DataDict[name]);
}
public void RemoveKey(string key)
{
if (HasKey(key))
{
DataDict.Remove(key);
UpdateDataDict();
}
}
public static List <IContainer> CreateContainersForDataDictionary(DataDict r)
{
List <IContainer> containers = new List <IContainer>();
foreach (var structure in r.Structures)
{
IContainer control = GenerateGUIStructures.CreateStructureGUI(structure) as IContainer;
containers.Add(control);
}
return(containers);
}
public CodeUIEdgeItem(string srcName, string tarName, DataDict edgeData)
{
m_srcUniqueName = srcName;
m_tarUniqueName = tarName;
if (edgeData != null)
{
if (edgeData.ContainsKey("dbRef"))
{
var dbRef = edgeData["dbRef"] as DoxygenDB.Reference;
if (dbRef != null)
{
m_file = dbRef.File().Longname();
m_line = dbRef.Line();
m_column = dbRef.Column();
}
}
if (edgeData.ContainsKey("customEdge"))
{
m_customEdge = (int)edgeData["customEdge"] != 0;
}
}
var scene = UIManager.Instance().GetScene();
var srcItem = scene.GetItemDict()[srcName];
string srcItemFile;
int srcItemLine, srcItemColumn;
srcItem.GetDefinitionPosition(out srcItemFile, out srcItemLine, out srcItemColumn);
if (srcItemFile != "" && m_file != srcItemFile)
{
m_file = srcItemFile;
m_line = srcItemLine;
m_column = srcItemColumn;
}
this.MouseDown += new MouseButtonEventHandler(MouseDownCallback);
this.MouseUp += new MouseButtonEventHandler(MouseUpCallback);
this.MouseMove += new MouseEventHandler(MouseMoveCallback);
this.MouseEnter += new MouseEventHandler(MouseEnterCallback);
this.MouseLeave += new MouseEventHandler(MouseLeaveCallback);
this.Cursor = Cursors.Arrow;
SolidColorBrush brush = new SolidColorBrush(Color.FromArgb(100, 150, 150, 150));
this.Fill = Brushes.Transparent;
this.Stroke = brush;
this.StrokeThickness = 2.0;
this.StrokeLineJoin = PenLineJoin.Bevel;
BuildGeometry();
Canvas.SetZIndex(this, -1);
}
public static DataDict ToEntity(this DataDictModel model)
{
var entity = new DataDict()
{
Id = model.Id,
//Type = model.Type,
Value = model.Value,
Text = model.Text,
Parent = model.Parent
};
return(entity);
}
public static DataDictModel ToModel(this DataDict entity)
{
var model = new DataDictModel()
{
Id = entity.Id,
//Type = entity.Type,
Value = entity.Value,
Text = entity.Text,
Parent = entity.Parent
};
return(model);
}
public IActionResult Edit(long id, int parentId = 0)
{
var dataDict = _dataDictService.Single(id);
if (dataDict == null)
{
dataDict = new DataDict();
dataDict.ParentId = parentId;
dataDict.OrderNum = 999;
dataDict.Status = 1;
}
ViewBag.m = dataDict;
return(View());
}
public string getIsitype()
{
DataDict dd_root = db.DataDicts.Where(i => i.DataDictName == "IT服务类别").SingleOrDefault();
List <DataDict> dd = db.DataDicts.Where(i => i.parentId == dd_root.ID).ToList();
JArray json = new JArray(
from r in dd
select new JObject(
new JProperty("id", r.ID),
new JProperty("parentId", r.parentId),
new JProperty("name", r.DataDictName)
));
return(json.ToString());
}
/// <summary>
/// 比较数据字典是否相等
/// </summary>
/// <param name="sourceList">源</param>
/// <param name="targetList">目标</param>
/// <returns></returns>
private bool compareField(ref List <FieldCompare> sourceList, List <FieldCompare> targetList)
{
bool isSame = true;
List <FieldCompare> compareResultList = new List <FieldCompare>();
foreach (FieldCompare source in sourceList)
{
//判断字段是否存在
DataDict target = targetList.FirstOrDefault(t => t.field_name == source.field_name);
if (target == null)
{
source.FieldStatus = FieldStatusEnum.Created;
compareResultList.Add(source);
}
else
{
//如果字段的数据类型、长度、小数位有一个不相同，则说明有修改字段
if (source.data_type != target.data_type || source.width != target.width || source.DecimalPrecision != target.DecimalPrecision)
{
source.FieldStatus = FieldStatusEnum.Update;
compareResultList.Add(source);
}
}
}
//反向查询，是否有删字段
foreach (FieldCompare target in targetList)
{
DataDict source = sourceList.FirstOrDefault(t => t.field_name == target.field_name);
if (source == null)
{
target.FieldStatus = FieldStatusEnum.Deleted;
compareResultList.Add(target);
}
}
if (compareResultList.Count > 0)
{
isSame = false;
sourceList = compareResultList;
}
return(isSame);
}
public ActionResult CreateDataDict(DataDict dd)
{
if (ModelState.IsValid)
{
DataDict dd1 = new DataDict();
dd1.DataDictName = dd.DataDictName;
dd1.DataDictCode = dd.DataDictCode;
dd1.DataDictType = dd.DataDictType;
dd1.DataDictNote = dd.DataDictNote;
dd1.parentId = dd.ID;
db.DataDicts.Add(dd1);
try
{
db.SaveChanges();
var json = new
{
okMsg = "创建成功"
};
return(Json(json, "text/html", JsonRequestBehavior.AllowGet));
}
catch
{
var json = new
{
errorMsg = "保存数据出错"
};
return(Json(json, "text/html", JsonRequestBehavior.AllowGet));
}
}
else
{
var json = new
{
errorMsg = "验证错误"
};
return(Json(json, "text/html", JsonRequestBehavior.AllowGet));
}
}
public ResultObject Edit(DataDict dataDict)
{
if (string.IsNullOrEmpty(dataDict.Name))
{
return(new ResultObject("名称不能为空"));
}
var flag = 0L;
if (dataDict.Id == 0)
{
dataDict.DictId = _dataDictDao.GetMaxDictId(dataDict.DictType) + 1;
flag = _dataDictDao.Insert(dataDict);
}
else
{
flag = _dataDictDao.Update(dataDict);
}
return(new ResultObject(flag));
}
protected void EntityDataSource1_Updated(object sender, EntityDataSourceChangedEventArgs e)
{
if (e.Entity is DataDict)
{
DataDict model = e.Entity as DataDict;
if (model != null)
{
if (model.Code == "NCWebServiceURL") //如果配置项是用友接口参数，那么更改WebConfig中的WebServiceURL
{
string newURL = model.Name;
string oldURL = "";
string msg = "";
bool ret = SaveURL(newURL, out oldURL, out msg);
if (ret == true)
{
StringBuilder strMsg = new StringBuilder("更新成功！");
strMsg.Append("<br />");
strMsg.Append(" 原用友接口URL：");
strMsg.Append(oldURL);
strMsg.Append("<br />");
strMsg.Append(" 更新后用友接口URL：");
strMsg.Append(newURL);
ShowMessageBox(strMsg.ToString());
}
else
{
StringBuilder strMsg = new StringBuilder("更新失败！");
strMsg.Append(Environment.NewLine);
strMsg.Append(" 详细信息：");
strMsg.Append(msg);
ShowMessageBox(strMsg.ToString());
}
}
}
}
}
/// <summary>
/// 更新字典条目
/// </summary>
/// <param name="item">实体</param>
/// <returns></returns>
public int UpdateDataDict(DataDict item)
{
return(dataDictRepository.Update(item));
}
/// <summary>
/// 删除字典条目
/// </summary>
/// <param name="item">实体</param>
/// <returns></returns>
public int Delete(DataDict item)
{
return(dataDictRepository.Delete(item.ID));
}
private void Export(string fileTtype)
{
var export = GetActor <IExport>(_export, DefaultExport, fileTtype);
if (_columns == null)
{
_columns = new List <List <Column> > {
new List <Column>()
};
EachHelper.EachListHeader(_data, (i, field, type) => _columns[0].Add(new Column()
{
title = field, field = field, rowspan = 1, colspan = 1
}));
}
Dictionary <int, int> currentHeadRow = new Dictionary <int, int>();
Dictionary <string, List <int> > fieldIndex = new Dictionary <string, List <int> >();
Func <int, int> getCurrentHeadRow = cell => currentHeadRow.ContainsKey(cell) ? currentHeadRow[cell] : 0;
var currentRow = 0;
var currentCell = 0;
export.Init(_data);
//生成多行题头
for (var i = 0; i < _columns.Count; i++)
{
currentCell = 0;
for (var j = 0; j < _columns[i].Count; j++)
{
var item = _columns[i][j];
if (item.hidden)
{
continue;
}
while (currentRow < getCurrentHeadRow(currentCell))
{
currentCell++;
}
export.FillData(currentCell, currentRow, "title_" + item.field, item.title);
if (item.rowspan + item.colspan > 2)
{
export.MergeCell(currentCell, currentRow, currentCell + item.colspan - 1, currentRow + item.rowspan - 1);
}
if (!string.IsNullOrEmpty(item.field))
{
if (!fieldIndex.ContainsKey(item.field))
{
fieldIndex[item.field] = new List <int>();
}
fieldIndex[item.field].Add(currentCell);
}
for (var k = 0; k < item.colspan; k++)
{
currentHeadRow[currentCell] = getCurrentHeadRow(currentCell++) + item.rowspan;
}
}
currentRow++;
}
//设置题头样式
export.SetHeadStyle(0, 0, currentCell - 1, currentRow - 1);
//设置数据样式
var dataCount = 0;
EachHelper.EachListRow(_data, (i, r) => dataCount++);
export.SetRowsStyle(0, currentRow, currentCell - 1, currentRow + dataCount - 1);
EachHelper.EachListRow(_data, (rowIndex, rowData) =>
{
var currRow = currentRow;
EachHelper.EachColumnProperty(rowData, (i, name, value) =>
{
if (fieldIndex.ContainsKey(name))
{
foreach (int cellIndex in fieldIndex[name])
{
if (_codeList.Contains(name, StringComparer.CurrentCultureIgnoreCase))
{
value = DataDict.Format(name, value);
}
export.FillData(cellIndex, currRow, name, value);
}
}
});
currentRow++;
});
_fileStream = export.SaveAsStream();
_suffix = export.suffix;
}
public bool HasKey(string key)
{
return(DataDict.ContainsKey(key));
}
/// <summary>
/// 新增字典条目
/// </summary>
/// <param name="item">实体</param>
/// <returns>受影响的记录数</returns>
public int Add(DataDict item)
{
return(dataDictRepository.Insert(item));
}
public AisinoPrint(DataDict dataDict_1, Aisino.Framework.Plugin.Core.Controls.PrintControl.Canvas canvas_1) : this()
{
this.Data = dataDict_1;
this.Canvas = canvas_1;
}
private static void Main(string[] args)
{
var recnik = new DataDict();
recnik.CreateStructure(
Composition.Aggregation, "Stavka narudzbenice", new List <IComponent>
{
recnik.CreateField("Sifra", Domain.Int),
recnik.CreateField("Kolicina", Domain.Int),
recnik.CreateField("Proizvod", Domain.Structure)
});
recnik.CreateStructure(
Composition.Aggregation,
"Proizvod",
new List <IComponent>
{
recnik.CreateField("Sifra", Domain.Int),
recnik.CreateField("Name", Domain.String),
recnik.CreateStructure(
Composition.NonExclusiveSpecialization,
new List <IComponent>
{
recnik.CreateField("Opis", Domain.String),
recnik.CreateField("Napomena", Domain.String),
recnik.CreateField("Cena", Domain.Int),
}),
recnik.CreateField("Proizvodjac", Domain.Structure),
}
);
recnik.CreateStructure(Composition.Aggregation, "Narudzbenica",
new List <IComponent>
{
recnik.CreateField("Sifra", Domain.Int),
recnik.CreateField("Date", Domain.Date),
recnik.CreateField("Stavka narudzbenice", Domain.Structure, Composition.Set),
});
recnik.CreateStructure(Composition.Aggregation, "Kupac",
new List <IComponent>
{
recnik.CreateField("Sifra", Domain.Int),
recnik.CreateField("Ulica", Domain.String),
recnik.CreateStructure(
Composition.ExclusiveSpecialization, new List <IComponent>
{
recnik.CreateStructure(
Composition.Aggregation, "Pravno lice", new List <IComponent>
{
recnik.CreateField("PIB", Domain.Int),
recnik.CreateField("Name Firme", Domain.String),
recnik.CreateField("Adresa sedista", Domain.String)
}),
recnik.CreateStructure(
Composition.Aggregation, "Fizicko lice", new List <IComponent>
{
recnik.CreateField("Ime", Domain.String),
recnik.CreateField("Prezime", Domain.String),
recnik.CreateField("JMBG", Domain.String),
recnik.CreateField("Adresa sedista", Domain.String)
}),
})
});
var ContainersForDictinary = GenerateGUI.CreateContainersForDataDictionary(recnik);
var strukturaKupca = ContainersForDictinary[5];
foreach (var guiControl in ContainersForDictinary)
{
Console.WriteLine(guiControl.Name);
CreateGUI(guiControl, new GuiBuilderConsole());
}
}
