/// <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);
}
public static AzNormalSet GetAzNormalSet()
{
if (normalSet == null)
{
lock (locker)
{
if (normalSet == null)
{
normalSet = new AzNormalSet();
}
}
}
return(normalSet);
}
/// <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;
}
