public int InitColumnValueSchema(string initSchemaName) { string sql = MetadataOperate.DbCreateLoad(BaseConstants.Az_InitColumnValueSchemafile) .ReaplaceTemplate(BaseConstants.Az_Parameters1, initSchemaName.AddSingleQuotes()) .ReaplaceTemplate(BaseConstants.AppNameDefautSign, MetadataOperate.GetDefAppNameUpdate(azNormalSet.AzBase.AzTablePrefix));; return(repository.ExecuteNonQuerySql().WithSql(sql).Go()); }
public int UpdataCodeSetVales() { return(repository.Update() .UsingTableName(azNormalSet.AzMetaTableName) .Set(m => m.CodeSetVales, string.Empty) .Where(m => m.AppName == MetadataOperate.GetDefAppNameUpdate(azNormalSet.AzBase.AzTablePrefix)) .Go()); }
public List <AzMetaTableEntity> GetDBSchema() { List <AzMetaTableEntity> result = new List <AzMetaTableEntity>(); StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append(" SELECT TOP (100) PERCENT A.name AS SchemaName, CASE WHEN A.xtype = 'U' THEN 1 WHEN A.xtype = 'V' THEN 2 ELSE 3 END AS ObjDataType, B.value as ClassDisPlay"); stringBuilder.Append(" FROM sys.sysobjects AS A LEFT OUTER JOIN"); stringBuilder.Append(" (SELECT TOP (100) PERCENT value, major_id"); stringBuilder.Append(" FROM sys.extended_properties"); stringBuilder.Append(" WHERE (name = N'MS_Description') AND (minor_id = 0)) AS B ON A.id = B.major_id"); if (string.IsNullOrWhiteSpace(azNormalSet.AzBase.AzTablePrefix)) { stringBuilder.Append(" WHERE (NOT (A.name LIKE N'sys%')) AND (NOT (A.name LIKE N'sp_%')) And(A.xtype = 'U' OR"); } else { stringBuilder.Append($" WHERE (NOT (A.name LIKE N'sys%')) AND (NOT (A.name LIKE N'sp_%')) And (A.name LIKE '{azNormalSet.AzBase.AzTablePrefix}%') AND (A.xtype = 'U' OR"); } stringBuilder.Append($" A.xtype = 'V' OR A.xtype = 'P') AND (NOT (A.name LIKE N'{BaseConstants.CodeToolName}%'))"); stringBuilder.Append(" ORDER BY SchemaName"); string cmdstr = stringBuilder.ToString(); string dbConnectionString = azNormalSet.AzConnectionString; using (SqlConnection cn = new SqlConnection(dbConnectionString)) { cn.Open(); using (SqlCommand cmd = new SqlCommand(cmdstr, cn)) { using (SqlDataReader atkDataReader = cmd.ExecuteReader()) { int id = 1; while (atkDataReader.Read()) { string scname = atkDataReader["SchemaName"] is DBNull ? null : (string)atkDataReader["SchemaName"]; string objname = ReMovePer(scname); AzMetaTableEntity schemaEntity = new AzMetaTableEntity(); schemaEntity.Id = id; schemaEntity.ClassName = azNormalSet.AzBase.AzClassPrefix + objname; schemaEntity.ObjModeName = objname; schemaEntity.SchemaName = scname; schemaEntity.AppName = MetadataOperate.GetDefAppNameUpdate(azNormalSet.AzBase.AzTablePrefix); schemaEntity.ObjDataType = (int)atkDataReader["ObjDataType"];; schemaEntity.ClassDisPlay = atkDataReader["ClassDisPlay"] is DBNull ? null : (string)atkDataReader["ClassDisPlay"]; schemaEntity.ObjModeType = 1; result.Add(schemaEntity); id += 1; } } } } 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; }