private void AzGetCustomList(string nodeTable)
{
treeViewBusiness.Nodes.Clear();
tnTables.Nodes.Clear();
tnViews.Nodes.Clear();
treeViewBusiness.Nodes.Add(tnTables);
treeViewBusiness.Nodes.Add(tnViews);
//
//
var results = AzMetaTableHandle.Handle().Select()
.Where(e => e.ObjDataType == 1).And(e => e.ObjModeName != nodeTable)
.Go();
foreach (AzMetaTableEntity item in results)
{
switch (item.ObjModeType)
{
case 1:
tnTables.Nodes.Add(item.ObjModeName, item.ObjModeName + item.ClassDisPlay.AddBrackets());
break;
case 4:
tnViews.Nodes.Add(item.ObjModeName, item.ObjModeName + item.ClassDisPlay.AddBrackets());
break;
}
}
treeViewBusiness.ExpandAll();
}
private void AzGetCustomList()
{
treeViewBusiness.Nodes.Clear();
tnTables.Nodes.Clear();
tnViews.Nodes.Clear();
treeViewBusiness.Nodes.Add(tnTables);
treeViewBusiness.Nodes.Add(tnViews);
//
//
azMetaTableEntities = AzMetaTableHandle.Handle().Select()
.Where(e => e.ObjDataType == 1)
.Where(e => e.IsCustom == true)
.Go();
foreach (AzMetaTableEntity item in azMetaTableEntities)
{
switch (item.ObjModeType)
{
case 1:
tnTables.Nodes.Add(item.ObjModeName, item.ObjModeName + item.ClassDisPlay.AddBrackets()).Tag = 1;
break;
case 4:
tnViews.Nodes.Add(item.ObjModeName, item.ObjModeName + item.ClassDisPlay.AddBrackets()).Tag = 4;
break;
}
}
treeViewBusiness.ExpandAll();
ButtonAction();
}
private void LoadData(string objModeName)
{
metaTableEntity = AzMetaTableHandle.Handle().Select()
.Where(c => c.ObjModeName == objModeName)
.Go().AsQueryable().FirstOrDefault();
if (metaTableEntity == null)
{
return;
}
textObjModeName.Text = metaTableEntity.ObjModeName;
textTableName.Text = metaTableEntity.SchemaName;
textClassDisPlay.Text = metaTableEntity.ClassDisPlay;
textSchemaFrom.Text = metaTableEntity.SchemaFrom;
textRemark.Text = metaTableEntity.Remark;
azId = metaTableEntity.Id;
switch (metaTableEntity.ObjModeType)
{
case 1:
rdbMetaClass.Checked = true;
break;
case 4:
rdbMetaChild.Checked = true;
break;
}
}
public static int CreateExecSp()
{
var list = AzMetaTableHandle.Handle().GetAllDBTableList();
if (list.IndexOf(BaseConstants.Az_StoreProcedureExe) > -1)
{
return(0);
}
string cmdstr = DbCreateLoad(BaseConstants.Az_StoreProcedureExefile);
return(ExecuteCmd(cmdstr));
}
private void SetTableFrom(string tablename = "")
{
cbTableFrom.Text = "";
cbKeyField.Text = "";
cbDisplayField.Text = "";
cbTableFrom.Items.Clear();
cbTableFrom.Items.AddRange(AzMetaTableHandle.Handle().GetDBTableList().ToArray());
cbKeyField.Items.Clear();
cbDisplayField.Items.Clear();
if (!string.IsNullOrWhiteSpace(tablename))
{
cbTableFrom.Text = tablename;
}
}
private void SetTableFiedFrom(string tablename, string keyfieldname = "", string displayfieldname = "")
{
cbKeyField.Items.Clear();
cbDisplayField.Items.Clear();
cbKeyField.Items.AddRange(AzMetaTableHandle.Handle().GetDBTableFieldList(tablename).ToArray());
cbDisplayField.Items.AddRange(AzMetaTableHandle.Handle().GetDBTableFieldList(tablename).ToArray());
if (!string.IsNullOrWhiteSpace(keyfieldname))
{
cbKeyField.Text = keyfieldname;
}
if (!string.IsNullOrWhiteSpace(displayfieldname))
{
cbDisplayField.Text = displayfieldname;
}
}
private void ACM_ReNameColumns_Click(object sender, EventArgs e)
{
if (GeneralHelpler.ConfirmQuestionOperate("确定全部更新显示字段至数据库？") == DialogResult.Cancel)
{
return;
}
var listcol = AzMetaCloumHandle.Handle().Select().Where(t => t.TableName == currentObject.SchemaName).OrderBy(t => t.ShowOrder).Go();
foreach (var item in listcol)
{
AzMetaTableHandle.Handle().ReNameColumnDisplay(item.FldDisplay, currentObject.SchemaName, currentObject.DbObjType, item.FldName);
}
LoadMataColum();
}
private void ACM_ReNameColumn_Click(object sender, EventArgs e)
{
var drow = azMetaCloumListEntityBindingSource.Current;
if (drow != null)
{
var row = ((DataRowView)drow).Row;
var entity = row.ToObjectSafe <AzMetaCloumEntity>();
if (AzMetaTableHandle.Handle().ReNameColumnDisplay(entity.FldDisplay,
currentObject.SchemaName, currentObject.DbObjType, entity.FldName) == -1)
{
LoadMataColum();
}
}
}
private void WorkObjModeInit()
{
ClearNodes();
azDBSchemas = AzMetaTableHandle.Handle().GetDBSchema();
foreach (var item in azDBSchemas)
{
switch (item.ObjDataType)
{
case 1:
tablesNode.Nodes.Add(item.SchemaName, $"{item.SchemaName}{item.ClassDisPlay.AddBrackets()}");
break;
case 2:
viewsNode.Nodes.Add(item.SchemaName, $"{item.SchemaName}{item.ClassDisPlay.AddBrackets()}");
break;
}
}
}
private void CreateCodeBath(List <string> oplist, string current)
{
var item = AzMetaTableHandle.Handle().Select().Where(m => m.ObjModeName == current).Go().FirstOrDefault();
if (item == null)
{
return;
}
var itemDetails = AzMetaCloumHandle.Handle().Select().Where(t => t.TableName == item.SchemaName).OrderBy(t => t.ShowOrder).Go();
var itemproperty = AzCdgnClassProperty.GetItemClassCreatProperty(item);
var list = GetCreateList(oplist, itemproperty);
foreach (string c in list)
{
CreateCodeHandle(c, item, itemproperty, itemDetails);
}
azCdgnDetail1.SetCodeCreateMsg(CodeHandle.GetCodeHandleMsg());
}
private int CreateDBTabeOp(string objModeName)
{
AzMetaTableEntity azMetaTable = AzMetaTableHandle.Handle().Select()
.Where(t => t.ObjModeName == objModeName)
.Go().FirstOrDefault();
IEnumerable <AzMetaCustomCloumEntity> cloumListEntities = AzMetaCustomCloumHandle.Handle().Select()
.Where(t => t.TableName == azMetaTable.SchemaName)
.Go();
string strcreate = DataOperate.CreateDBObject(azMetaTable, cloumListEntities);
int result = MetadataOperate.ExecuteCmd(strcreate);
if (result > 0)
{
azMetaTable.ObjModeType = 0;
azMetaTable.ObjDataType = 0;
AzMetaTableHandle.Handle().Updata(azMetaTable);
}
return(result);
}
private void SaveMasterInfo()
{
JavaScriptSerializer js = new JavaScriptSerializer();
if (string.IsNullOrWhiteSpace(azClassCreatProperty.ObjPresentation.UpdateTableName))
{
azClassCreatProperty.ObjPresentation.UpdateTableName = azMetaTable.SchemaName;
}
azMetaTable.CodeSetVales = js.Serialize(azClassCreatProperty);
if (azMetaTable.ComeFrom == 1)
{
azMetaTable.ObjModeType = 1;
azMetaTable.AppName = MetadataOperate.GetDefAppNameUpdate(AzNormalSet.GetAzNormalSet().AzBase.AzTablePrefix);
azMetaTable = AzMetaTableHandle.Handle().Insert(azMetaTable);
return;
}
AzMetaTableHandle.Handle().Updata(azMetaTable);
SetSelectedObject(azMetaTable);
OnMasterSaveNotification?.Invoke();
}
private void btSave_Click(object sender, System.EventArgs e)
{
if (VerificationText())
{
return;
}
int objModeType = 1;
if (rdbMetaChild.Checked)
{
objModeType = 4;
}
metaTableEntity = new AzMetaTableEntity
{
ObjModeName = textObjModeName.Text,
ClassName = textClassName.Text,
SchemaName = textTableName.Text,
SchemaFrom = textSchemaFrom.Text,
ClassDisPlay = textClassDisPlay.Text,
CodeSetVales = "",
Remark = textRemark.Text,
IsCustom = true,
ObjDataType = 1,
ObjModeType = objModeType,
AppName = MetadataOperate.GetDefAppNameUpdate(azNormalSet.AzBase.AzTablePrefix),
};
if (IsEdit)
{
metaTableEntity.Id = azId;
AzMetaTableHandle.Handle().Updata(metaTableEntity);
}
else
{
AzMetaTableHandle.Handle().Insert(metaTableEntity);
}
DialogResult = DialogResult.OK;
}
private void tspButtonDel_Click(object sender, System.EventArgs e)
{
if (treeViewBusiness.SelectedNode.Level == 1)
{
var lused = AzMetaTableHandle.Handle().Select().Where(t => t.SchemaFrom == currentSelectObjModeName).Go();
if (lused != null)
{
if (lused.Count() > 0)
{
GeneralHelpler.SomethingWarning("当前元数已经被引用，不能删除？");
return;
}
}
string msg = $"确定要删除 {treeViewBusiness.SelectedNode.Text}";
if (GeneralHelpler.ConfirmQuestionOperate(msg) == DialogResult.OK)
{
AzMetaTableHandle.Handle().Delete(treeViewBusiness.SelectedNode.Name);
AzGetCustomList();
}
}
}
