/// <summary> /// 清除所有当前项目的元数据(根据配置) /// </summary> public static void ClearAllMetaData() { var azset = AzNormalSet.GetAzNormalSet(); DeleteByTableName(azset.AzMetaTableName); DeleteByTableName(azset.AzMetaCloumName); }
/// <summary> /// 初始化元数据值 /// </summary> public static int InitMetaData() { var azset = AzNormalSet.GetAzNormalSet(); if (DataHelper.DbTableNameExist(azset.AzMetaCloumName)) { string cmdstr = DbCreateLoad(BaseConstants.Az_InitMetaDatafile); cmdstr = cmdstr.ReaplaceTemplate(BaseConstants.Az_Parameters1, GetDefAppNameUpdate(azset.AzBase.AzTablePrefix)); return(ExecuteCmd(cmdstr)); } return(-10); }
/// <summary> /// 创建元数据查询视图 /// </summary> public static int CreateMetaQueryView() { var azset = AzNormalSet.GetAzNormalSet(); if (!DataHelper.DbTableNameExist(azset.AzMetaQueryView)) { string cmdstr = DbCreateLoad(BaseConstants.Az_MetaQueryViewfile); return(ExecuteCmd(cmdstr)); } return(-10); }
/// <summary> /// 替换初始化元数据表字串 /// </summary> /// <param name="loadFile">模板文件</param> /// <returns></returns> public static string DbCreateLoad(string loadFile) { string templatestr = string.Empty; var azset = AzNormalSet.GetAzNormalSet(); templatestr = FileHelper.ReadTemplateFile(loadFile); templatestr = templatestr.ReaplaceTemplate(BaseConstants.Az_MetaTable, azset.AzMetaTableName) .ReaplaceTemplate(BaseConstants.Az_MetaCloum, azset.AzMetaCloumName) .ReaplaceTemplate(BaseConstants.Az_MetaQueryView, azset.AzMetaQueryView); return(templatestr); }
/// <summary> /// 导入元数据(列信息,类的属性) /// </summary> public static int ImportMetaData() { var azset = AzNormalSet.GetAzNormalSet(); if (DataHelper.DbTableNameExist(azset.AzMetaCloumName)) { string cmdstr = DbCreateLoad(BaseConstants.Az_ImportMetaDatafile); cmdstr = cmdstr + string.Format(BaseConstants.WhereAppStr, azset.AzBase.AzTablePrefix); cmdstr = cmdstr.ReaplaceTemplate(BaseConstants.AppNameDefautSign, GetDefAppNameUpdate(azset.AzBase.AzTablePrefix)); return(ExecuteCmd(cmdstr)); } return(-10); }
//[ConfigurationProperty("azconnectionstring", IsRequired = true)] //public string AzConnectionString //{ // get { return this["azconnectionstring"].ToString(); } // set { this["azconnectionstring"] = value; } //} ///// <summary> ///// 获取数据连接 ///// </summary> ///// <returns></returns> //public static string AzGetConnectionString() //{ // AzDataSourceSet azDataSourceSet = ConfigurationManager.GetSection("AzDataSource") as AzDataSourceSet; // if (azDataSourceSet == null) // { // //增加此处代码,主要解决“C#设计界面时,未将对象引用设置到对象实例问题解决方案” // // 如无此行代码,winForm时,就会报错。 // return ""; // } // else // { // return azDataSourceSet.AzConnectionString; // } //} /// <summary> /// 设置数据库连接 /// </summary> /// <param name="azsqllink"></param> public static void AzSetConnectionString(string azsqllink) { //Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None); //AzDataSourceSet azDataSourceSet = config.GetSection("AzDataSource") as AzDataSourceSet; //azDataSourceSet.AzConnectionString = azsqllink; //config.Save(); AzNormalSet normalSet = AzNormalSet.GetAzNormalSet(); normalSet.AzBase.AzConnectionString = azsqllink; AzBaseSet.AzSetBaseCnns(normalSet.AzBase); }
/// <summary> /// 删除指定元数据表中删除数据 /// </summary> /// <param name="deletetable">删除表名</param> public static int DeleteByTableName(string deletetable) { if (DataHelper.DbTableNameExist(deletetable)) { using (SqlConnection cn = new SqlConnection(dbConnectionString)) { cn.Open(); var azset = AzNormalSet.GetAzNormalSet().AzBase; string cmdstr = string.Format(BaseConstants.DeleteTblesStr, deletetable, GetDefAppNameUpdate(azset.AzTablePrefix)); using (SqlCommand cmd = new SqlCommand(cmdstr, cn)) { return(cmd.ExecuteNonQuery()); } } } return(-10); }
public static int ImportCustomMetaData(string impFrom, string impTo, bool istmp = false) { var azset = AzNormalSet.GetAzNormalSet(); string cmdstr = string.Empty; if (istmp) { cmdstr = DbCreateLoad(BaseConstants.Az_MetaImportTmpfile); } else { cmdstr = DbCreateLoad(BaseConstants.Az_MetaImportfile); } cmdstr = cmdstr.ReaplaceTemplate(BaseConstants.Az_Parameters1, impTo) .ReaplaceTemplate(BaseConstants.Az_Parameters2, impFrom) .ReaplaceTemplate(BaseConstants.AppNameDefautSign, GetDefAppNameUpdate(azset.AzBase.AzTablePrefix));; return(ExecuteCmd(cmdstr)); }
public static bool MetaWhetherInit() { var azset = AzNormalSet.GetAzNormalSet(); if (!DataHelper.DbTableNameExist(azset.AzMetaTableName)) { return(false); } if (!DataHelper.DbTableNameExist(azset.AzMetaCloumName)) { return(false); } if (!DataHelper.DbTableNameExist(azset.AzMetaQueryView)) { return(false); } return(true); }
public static bool ConfigWhetherInit() { var azset = AzNormalSet.GetAzNormalSet(); if (string.IsNullOrWhiteSpace(azset.AzConnectionString)) { return(false); } try { using (SqlConnection cn = new SqlConnection(azset.AzConnectionString)) { cn.Open(); } } catch (Exception) { throw new Exception($"{azset.AzConnectionString},此连接数据库不存在,或不能打开,请正确设置!!"); // GeneralHelpler.SomethingWarning("数据库不能打开,请正确设置!!"); // return false; } if (string.IsNullOrWhiteSpace(azset.AzMetaTableName)) { return(false); } if (string.IsNullOrWhiteSpace(azset.AzMetaQueryView)) { return(false); } if (string.IsNullOrWhiteSpace(azset.AzMetaCloumName)) { return(false); } return(true); }
static MetadataOperate() { dbConnectionString = AzNormalSet.GetAzNormalSet().AzConnectionString; }