public static bool CreateTable(MetaStandard standard) { if (standard == null) { return(false); } try { StringBuilder strSQL = new StringBuilder("Create Table "); strSQL.Append(standard.TableName); strSQL.Append(" ("); strSQL.Append(GetSQLFromField(IDFieldInfo)); strSQL.Append(","); foreach (FieldInfo fInfo in standard.FieldsInfo) { strSQL.Append(GetSQLFromField(fInfo)); strSQL.Append(","); } strSQL.Remove(strSQL.Length - 1, 1); strSQL.Append(")"); Environment.AdodbHelper.ExecuteSQL(strSQL.ToString()); return(true); } catch { return(false); } }
public static DataTable GetAllMetaData(MetaStandard standard) { DataTable dtResult = Environment.AdodbHelper.ExecuteDataTable(string.Format("select * from {0}", standard.TableName)); TransCaption(dtResult, standard.GetFieldNameDictionary()); return(dtResult); }
public static bool UpdateMeatadata(MetaStandard standard, DataTable dtData) { if (standard == null) { return(false); } return(Environment.AdodbHelper.UpdateTable(standard.TableName, dtData)); }
public static void ReLoadItem(MetaStandard standard) { if (standard == null) { return; } Environment.NhibernateHelper.RefreshObject(standard, Define.enumLockMode.UpgradeNoWait); }
public static DataTable GetMetadata(MetaStandard standard, string strClause, int countPerPage, int pageIndex, ref int totalCount) { if (!Environment.AdodbHelper.TableExists(standard.TableName)) { if (!CreateTable(standard)) { ErrorMessage = "此标准的数据表不存在,并且创建失败"; return(null); } } DataTable dtResult = GetMetadata(standard.TableName, strClause, countPerPage, pageIndex, ref totalCount); TransCaption(dtResult, standard.GetFieldNameDictionary()); return(dtResult); }
/// <summary> /// 保存字典项 /// </summary> /// <param name="standard"></param> /// <returns></returns> public static bool SaveStandard(MetaStandard standard) { if (standard == null) { return(false); } try { Environment.NhibernateHelper.SaveObject(standard); // 记录 if (standard.FieldsInfo != null) { foreach (FieldInfo fInfo in standard.FieldsInfo) { fInfo.Layer = standard.ID; Environment.NhibernateHelper.SaveObject(fInfo); } } Environment.NhibernateHelper.Flush(); // 创建表 if (Environment.AdodbHelper.TableExists(standard.TableName)) { int eCount = Environment.AdodbHelper.ExecuteSQL(string.Format("Drop table {0}", standard.TableName)); if (eCount < 1) { ErrorMessage = "删除原有数据表时出错"; return(false); } } if (!CreateTable(standard)) { ErrorMessage = "创建新数据表时出错"; return(false); } return(true); } catch (Exception exp) { Environment.Logger.AppendMessage(Define.enumLogType.Error, string.Format("保存元数据标准时出错:{0}", exp.ToString())); return(false); } }
/// <summary> /// 删除字典项 /// </summary> /// <param name="standard"></param> /// <returns></returns> public static bool DeleteStandard(MetaStandard standard) { if (standard == null) { return(false); } try { // 记录 if (standard.FieldsInfo != null) { foreach (FieldInfo fInfo in standard.FieldsInfo) { Environment.NhibernateHelper.DeleteObject(fInfo); } } Environment.NhibernateHelper.DeleteObject(standard); Environment.NhibernateHelper.Flush(); // 删除数据表 if (Environment.AdodbHelper.TableExists(standard.TableName)) { Environment.AdodbHelper.ExecuteSQL(string.Format("Drop table {0}", standard.TableName)); } return(true); } catch (Exception exp) { ErrorMessage = "删除出错了!"; Environment.Logger.AppendMessage(Define.enumLogType.Error, string.Format("删除元数据标准时出错:{0}", exp.ToString())); return(false); } }
public MetaStandardHelper(MetaStandard metaStandard) { }