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