public static void InitBaseAccess() { DBHelper db = new DBHelper(); var tbs = RPTableSetting.GetTables(); //清空Fields表 DeleteField(); int num = 0; foreach (var tb in tbs) { var sql = string.Format("select name from syscolumns WHERE (id = OBJECT_ID('{0}'))", tb.TableName); var cmd = db.GetSqlStringCommond(sql); DataTable fields = db.ExecuteDataTable(cmd); if (fields != null && fields.Rows.Count > 0) { var data = new List <RPFieldSetting>(); for (int i = 0; i < fields.Rows.Count; i++) { var fieldName = fields.Rows[i][0].ToString(); var model = new RPFieldSetting(); model.TableID = tb.ID; model.FieldName = fieldName; model.OtherZHCN = fieldName; model.OtherENUS = fieldName; model.DispZHCN = fieldName; model.DispENUS = fieldName; model.OrderBy = i; model.GlobalBy = num; model.ConditionType = FieldConditionType.None; data.Add(model); num++; } using (var scope = new TransactionScope()) { RPFieldSetting.Add(data.ToArray()); scope.Complete(); } } } }
public IHttpActionResult GetTableFields(int tableId) { return(Ok(RPFieldSetting.GetFieldsByTableID(tableId))); }