public ActionResult Create(column column) { if (ModelState.IsValid) { db.columns.Add(column); db.SaveChanges(); //for adding adding to the current sprint to activity stream MvcApplicationTest1.DAL.activitystream activitystr = new MvcApplicationTest1.DAL.activitystream(); var xx = db.projects.Select(x => x).Where(x => x.id == column.projectid).FirstOrDefault(); String username = Convert.ToString(Session["UserName"]); activitystr.actiontype = "Add Column"; activitystr.description = username + " Added Column " + column.name + " To Project " + xx.projectname; activitystr.issueid = 4; activitystr.issuekey = "-"; activitystr.actiondate = DateTime.Now.ToString(); activitystr.projectid = column.projectid; int uid = int.Parse(Session["UserId"] + ""); activitystr.userid = uid; db.activitystreams.Add(activitystr); db.SaveChanges(); return(RedirectToAction("indexproject", "Column", new { id = column.projectid }));; } ViewBag.projectid = new SelectList(db.projects, "id", "projectkey", column.projectid); return(View(column)); }
public static Dictionary <string, column> getColumns(DataSet ds) { var tmpColumns = new Dictionary <string, column>(); if (ds != null) { if (ds.Tables.Count > 0) { var tb = ds.Tables[0]; foreach (DataRow item in tb.Rows) { if (tmpColumns.ContainsKey(item["COLUMN_NAME"].ToString())) { var tmpcol = new column() { COLUMN_NAME = item["COLUMN_NAME"].ToString(), COLUMN_ID = Convert.ToInt32(item["COLUMN_ID"]), DATA_LENGTH = Convert.ToInt32(item["DATA_LENGTH"]), DATA_TYPE = item["DATA_TYPE"].ToString(), NULLABLE = item["NULLABLE"].ToString() }; tmpColumns.Add(tmpcol.COLUMN_NAME, tmpcol); } } } } return(tmpColumns); }
public static Dictionary<string, column> getColumns(DataSet ds) { var tmpColumns = new Dictionary<string, column>(); if (ds != null) { if (ds.Tables.Count > 0) { var tb = ds.Tables[0]; foreach (DataRow item in tb.Rows) { if (tmpColumns.ContainsKey(item["COLUMN_NAME"].ToString())) { var tmpcol = new column() { COLUMN_NAME = item["COLUMN_NAME"].ToString(), COLUMN_ID = Convert.ToInt32(item["COLUMN_ID"]), DATA_LENGTH = Convert.ToInt32(item["DATA_LENGTH"]), DATA_TYPE = item["DATA_TYPE"].ToString(), NULLABLE = item["NULLABLE"].ToString() }; tmpColumns.Add(tmpcol.COLUMN_NAME, tmpcol); } } } } return tmpColumns; }
private String getTableColumns(FileInfo file, DlineageCommon dlineage) { if (dlineage.DataMetaInfos == null) { return(null); } StringBuilder buffer = new StringBuilder(); for (int i = 0; i < dlineage.DataMetaInfos.Length; i++) { database db = dlineage.DataMetaInfos[i]; for (int j = 0; j < db.tables.Length; j++) { demos.dlineage.model.ddl.schema.table currentTable = db.tables[j]; if (currentTable.columns == null || currentTable.columns.Length == 0) { continue; } if (!string.ReferenceEquals(currentTable.isView, null) && true == Convert.ToBoolean(currentTable.isView)) { continue; } if ("CONSTANT".Equals(currentTable.name)) { continue; } String tableName = ""; if (currentTable.name.IndexOf(".") != -1) { tableName = currentTable.name.Replace(".", ","); } else { if (!string.ReferenceEquals(db.name, null) && !"unknown".Equals(db.name, StringComparison.CurrentCultureIgnoreCase)) { tableName = (db.name + "," + currentTable.name); } else { tableName = ("," + currentTable.name); } } for (int k = 0; k < currentTable.columns.Length; k++) { column column = currentTable.columns[k]; if ("*".Equals(column.name)) { continue; } buffer.Append(tableName).Append(",").Append(column.name).Append(",").Append(file.Name).Append("\r\n"); } } } return(buffer.ToString()); }
public Chart Profits(DateTime Start, DateTime End, DateStatistics format) { Chart chartTevenue = Tevenue(Start, End, format); Chart chartImportMoney = ImportMoney(Start, End, format); Chart chartProfits = new Chart(); int count = chartTevenue.ColumnCount; long maxValue = 0; for (int i = 0; i < count; i++) { column cl; cl.value = chartTevenue.ListColumn[i].value - chartImportMoney.ListColumn[i].value; cl.percent = 0; cl.name = "" + chartTevenue.ListColumn[i].name; if (cl.value > maxValue) { maxValue = cl.value; } chartProfits.ListColumn.Add(cl); } for (int i = 0; i < count; i++) { column cl = chartProfits.listColumn[i]; cl.percent = cl.value / maxValue; chartProfits.listColumn[i] = cl; } return(chartProfits); }
public ActionResult DeleteConfirmed(int id) { column column = db.columns.Find(id); db.columns.Remove(column); db.SaveChanges(); return(RedirectToAction("Index")); }
public UserInfo() { HEADER = new column { id_ = "Id", name_ = "Name", point_ = "Point" }; }
// // GET: /Column/Delete/5 public ActionResult Delete(int id = 0) { column column = db.columns.Find(id); if (column == null) { return(HttpNotFound()); } return(View(column)); }
public ActionResult Edit(column column) { if (ModelState.IsValid) { db.Entry(column).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.projectid = new SelectList(db.projects, "id", "projectkey", column.projectid); return(View(column)); }
public TimeLine() { HEADER = new column { globalId_ = "gId", localId_ = "lId", name_ = "Name", text_ = "Text", time_ = "Time", enabled_ = "Enabled" }; }
// // GET: /Column/Edit/5 public ActionResult Edit(int id = 0) { column column = db.columns.Find(id); if (column == null) { return(HttpNotFound()); } ViewBag.projectid = new SelectList(db.projects, "id", "projectkey", column.projectid); return(View(column)); }
public ContentValues updateEntry(column _column) { ContentValues values = new ContentValues(); values.Put("gId", _column.globalId_); values.Put("Name", _column.name_); values.Put("Time", _column.time_); values.Put("Text", _column.text_); values.Put("Enabled", _column.enabled_); return(values); }
public static void AddColumn(this key thisKey, column column) { if (thisKey.column == null) { thisKey.column = new column[0]; } column[] items = thisKey.column; Array.Resize(ref items, thisKey.column.Length + 1); items[items.Length - 1] = column; thisKey.column = items; }
private static IEnumerable <column> GetColumnNodes(IEnumerable <IColumn> columns) { List <column> columnNodes = new List <column>(); foreach (var mappedColumn in columns) { var columnNode = new column { name = mappedColumn.Name.BackTick() }; columnNodes.Add(columnNode); } return(columnNodes); }
public JsonResult Select2AjaxTable(string PageName, string colname, List <inputParameter> Parameters) { Page Info = PDAL.FindPage(PageName); ConvertNullToEmpty(Parameters); column Pp = null; for (int k = 0; k < Info.tables[0].columns.Count; k++) { if (Info.tables[0].columns[k].name == colname) { Pp = Info.tables[0].columns[k]; } } for (int k = 0; k < Pp.DBSelectCommandParameters.Count; k++) { if (Pp.DBSelectCommandParameters[k].source == "Session") { inputParameter i = new inputParameter(); i.key = Pp.DBSelectCommandParameters[k].name; i.value = PDAL.GetSession(Pp.DBSelectCommandParameters[k].Parameter); Parameters.Add(i); } } DataTable Dt = PDAL.ReadRecords(ref Pp.DBSelect2Command, Parameters); List <item> it = new List <item>(); for (int k = 0; k < Pp.options.Count; k++) { item i = new item(); i.id = Pp.options[k].value; i.text = Pp.options[k].text; it.Add(i); } for (int k = 0; k < Dt.Rows.Count; k++) { item i = new item(); i.id = Dt.Rows[k][Pp.codeColumn].ToString(); i.text = Dt.Rows[k][Pp.textColumn].ToString(); it.Add(i); } obj o = new obj(); o.results = it.ToArray(); return(Json(o)); }
public JsonResult GetOperations() { GetDatabase(); string[] files = Directory.GetFiles(Server.MapPath(@"~\Content\Templates\"), "*.ipynb"); List <DataModel> TemplateList = new List <DataModel>(); if (files.Count() != 0) { foreach (var file in files) { DataModel newtemplate = new DataModel(); List <column> functions = new List <column>(); var notebooktemplate = System.IO.File.ReadAllText(file); dynamic template = JsonConvert.DeserializeObject <dynamic>(notebooktemplate); List <string> code = new List <string>(); List <dynamic> cellslist = new List <dynamic>(); if (notebooktemplate.Contains("worksheets")) { cellslist = template.worksheets[0].cells.ToObject <List <dynamic> >(); } else { cellslist = template.cells.ToObject <List <dynamic> >(); } var markdowncells = cellslist.Where(x => x.cell_type == "markdown").Select(z => z.source.ToString()).ToList(); var oper = markdowncells.Select(y => Regex.Match(y, @"\""UNIQUEID-([\w\s+]*)").Groups[1].ToString().Replace(@"\n", "")).ToList(); newtemplate.Id = Path.GetFileNameWithoutExtension(file); newtemplate.text = Path.GetFileNameWithoutExtension(file); newtemplate.tooltiptext = Path.GetFileNameWithoutExtension(file); foreach (var op in oper) { if (op != "") { column column = new column(); column.Id = Path.GetFileNameWithoutExtension(file) + "." + op; column.text = op; var nre = markdowncells.Where(y => y.Contains("UNIQUEID-" + op)).Select(y => y).ToList(); column.tooltiptext = nre[0].Replace("\"", "").Replace("\\n", "<br>").Replace("[", "").Replace("]", "").Replace(",", ""); functions.Add(column); } } newtemplate.children = functions; newtemplate.IsChecked = false; TemplateList.Add(newtemplate); } } return(Json(TemplateList, JsonRequestBehavior.AllowGet)); }
} //end constructor public bool AddDerivedData(data_item data, int ordinal) { foreach (column c in this.items) { //we cant update an ordinal that already exists... if (c.index == ordinal) { return(false); } } //ok we got herer, the column doesnt exist. lets add it. column new_data_column = new column(data.value, this.config, ordinal); this.items.Add(new_data_column); return(true); }
public static column Setup(this column column, MemberInfo memberInfo, string columnName = null, string columnPrefix = "", bool?notnull = true) { column.SetName(columnName ?? column.GetName() ?? memberInfo.Name.Sanitise(), columnPrefix); if (memberInfo.ReturnType() == typeof(string)) { var stringLengthAttribute = memberInfo.GetCustomAttributes(true).OfType <StringLengthAttribute>().SingleOrDefault(); string maxLength = stringLengthAttribute == null ? SqlDialect.Current.VarcharMax : stringLengthAttribute.MaximumLength.ToString(); column.sqltype = "NVARCHAR(" + maxLength + ")"; } if (memberInfo.ReturnType() == typeof(byte[])) { column.sqltype = "VARBINARY(MAX)"; } column.notnull = notnull; return(column); }
private key GetKeyNode(ITable joinedTable) { int count = joinedTable.ColumnsInPrimaryKey.Count(); key keyNode = new key(); if (count > 1) { foreach (var col in joinedTable.ColumnsInPrimaryKey) { column column = new column { name = col.Name }; keyNode.AddColumn(column); } } else if (count == 1) { keyNode.column1 = joinedTable.ColumnsInPrimaryKey.First().Name.BackTick(); } return(keyNode); }
/// <summary> /// 根据表格名称获取表格信息 /// </summary> /// <param name="connection">SQL连接</param> /// <param name="tableName">表格名称</param> /// <param name="isExecute">SQL连接执行是否成功</param> /// <returns>表格信息</returns> internal override table getTable(DbConnection connection, string tableName, ref byte isExecute) { using (DbCommand command = GetCommand(connection, "select top 1 * from [" + tableName + "]")) { using (DataSet dataSet = GetDataSet(command, ref isExecute)) { DataTable table = dataSet.Tables[0]; column identity = null; subArray <column> columns = new subArray <column>(table.Columns.Count); foreach (DataColumn dataColumn in table.Columns) { column column = new column { Name = dataColumn.ColumnName, DbType = fastCSharp.sql.sqlDbType.formCSharpType(dataColumn.DataType), Size = dataColumn.MaxLength, DefaultValue = dataColumn.DefaultValue == null ? null : dataColumn.DefaultValue.ToString(), IsNull = dataColumn.AllowDBNull, }; if (dataColumn.AutoIncrement) { identity = column; } columns.UnsafeAdd(column); } return(new table { Columns = new columnCollection { Name = tableName, Columns = columns.array, Type = sql.columnCollection.type.None }, Identity = identity }); } } }
public static void AddColumn(this manytoone thisManyToOne, column column) { //throw new NotImplementedException("TODO: What are we meant to do here?"); //if (thisManyToOne.column == null) // thisManyToOne.column = new column[0]; //var items = thisManyToOne.column; //Array.Resize(ref items, thisManyToOne.column.Length + 1); //items[items.Length - 1] = column; //thisManyToOne.column = items; if (thisManyToOne.Items == null) { thisManyToOne.Items = new column[0]; } var items = thisManyToOne.Items; Array.Resize(ref items, thisManyToOne.Items.Length + 1); items[items.Length - 1] = column; thisManyToOne.Items = items; }
//populate derived column data after the fact. public void derive_column_data() { if (this.derive_key_columns | this.derive_array_columns) { foreach (row r in this.items) { int count = r.items.Count; for (int i = 0; i < count; i++) { column c = r.items[i]; column_definition column_def = this.config.columns.get_column_by_ordinal(c.index); List <data_item> new_data = new List <data_item>(); foreach (data_item d in c.items) { if (d.is_key_value) { column_definition derived_column_def = this.config.columns.get_column_by_name(d.key); r.AddDerivedData(d, derived_column_def.ordinal); continue; } if (d.is_value) { //we only add array data if the max item count is >1 if (column_def.max_items > 1) { column_definition derived_column_def = this.config.columns.get_column_by_ordinal(c.index, d.index); r.AddDerivedData(d, derived_column_def.ordinal); } } } //end inner } //end minor } //end major loop } //end if derived } //end
public row(string data, table_config config, int index) { this.config = config; //clean data by trimming this.index = index; string clean_row = data.Trim(); //if its empty skip. we dont need it if (clean_row.Length == 0) { return; } //comments are skipped... if (clean_row[0] == config.comment_delimiter) { return; } //process whats left into columns //split the ros on the column delimiter string[] raw_colums = data.Split(config.column_delimiter); int column_index = 0; //loop through the columns and append them foreach (string raw_column in raw_colums) { column processed_column = new column(raw_column, config, column_index); //add proccessed row, with or without errors items.Add(processed_column); ++column_index; } //end column loop } //end constructor
public Test() { kKey = 42; dMoney = 3.1415926f; cValue = "May the force be with you!"; }
set => SetValue(column, value);
public void OrderBy(column v,orderType o) { this.orderby = v; this.ordtype = o; }
private void appendTables(Dlineage dlineage, Element dlineageRelation) { if (dlineage.DataMetaInfos == null) { return; } for (int i = 0; i < dlineage.DataMetaInfos.Length; i++) { database db = dlineage.DataMetaInfos[i]; for (int j = 0; j < db.tables.Length; j++) { table currentTable = db.tables[j]; if (currentTable.columns == null || currentTable.columns.Length == 0) { continue; } Element tableNode = new Element("table"); if (!string.ReferenceEquals(currentTable.isView, null) && true == Convert.ToBoolean(currentTable.isView)) { tableNode.Add(new XAttribute("isView", currentTable.isView)); } if (!string.ReferenceEquals(db.name, null) && !"unknown".Equals(db.name, StringComparison.CurrentCultureIgnoreCase)) { tableNode.Add(new XAttribute("name", db.name + "." + currentTable.name)); } else { tableNode.Add(new XAttribute("name", currentTable.name)); } for (int k = 0; k < currentTable.columns.Length; k++) { column column = currentTable.columns[k]; Element columnNode = new Element("column"); if (column.autoIncrement != null) { columnNode.Add(new XAttribute("autoIncrement", column.autoIncrement.ToLower())); } if (column.defaultValue != null) { columnNode.Add(new XAttribute("default", column.defaultValue)); } if (column.description != null) { columnNode.Add(new XAttribute("description", column.description)); } columnNode.Add(new XAttribute("name", column.name)); if (column.primaryKey != null) { columnNode.Add(new XAttribute("primaryKey", column.primaryKey.ToLower())); } if (column.required != null) { columnNode.Add(new XAttribute("required", column.required.ToLower())); } if (column.size != null) { columnNode.Add(new XAttribute("size", column.size)); } if (column.type != null) { columnNode.Add(new XAttribute("type", column.type)); } tableNode.Add(columnNode); } dlineageRelation.Add(tableNode); } } }
private database[] collectDDLInfo() { LinkedHashMap <string, database> databaseMap = new LinkedHashMap <string, database>(); if (tableColumns != null) { IEnumerator <TableMetaData> tableIter = tableColumns.Keys.GetEnumerator(); while (tableIter.MoveNext()) { TableMetaData tableMetadata = tableIter.Current; string databaseName = tableMetadata.CatalogDisplayName; if (string.ReferenceEquals(databaseName, null)) { databaseName = "unknown"; } if (!databaseMap.ContainsKey(databaseName)) { database database = new database(); database.name = databaseName; databaseMap[databaseName] = database; } database datasource = databaseMap[databaseName]; table table = new table(); if (!string.ReferenceEquals(tableMetadata.SchemaDisplayName, null)) { table.name = tableMetadata.SchemaDisplayName + "." + tableMetadata.DisplayName; } else { table.name = tableMetadata.DisplayName; } if (tableMetadata.View) { table.isView = true.ToString(); } if (tableMetadata.Indices != null && tableMetadata.Indices.Count > 0) { table.indices = tableMetadata.Indices.ToArray(); } if (tableMetadata.Uniques != null && tableMetadata.Uniques.Count > 0) { table.uniques = tableMetadata.Uniques.ToArray(); } if (tableMetadata.ForeignKeys != null && tableMetadata.ForeignKeys.Count > 0) { table.foreignKeys = tableMetadata.ForeignKeys.ToArray(); } List <table> tables = new List <table>(); if (datasource.tables != null) { tables.AddRange(datasource.tables); } tables.Add(table); tables.Sort(); datasource.tables = tables.ToArray(); IList <ColumnMetaData> columnMetadatas = tableColumns[tableMetadata]; if (columnMetadatas != null) { for (int i = 0; i < columnMetadatas.Count; i++) { ColumnMetaData columnMetadata = columnMetadatas[i]; column column = new column(); column.name = columnMetadata.DisplayName; column.type = columnMetadata.Type; column.size = columnMetadata.Size; column.primaryKey = columnMetadata.isPrimaryKey(); column.description = columnMetadata.Comment; column.defaultValue = columnMetadata.DefaultValue; column.required = columnMetadata.Required; column.autoIncrement = columnMetadata.AutoIncrease; List <column> columns = new List <column>(); if (table.columns != null) { columns.AddRange(table.columns); } columns.Add(column); table.columns = columns.ToArray(); } } } } if (databaseMap.Count > 0) { List <database> databases = new List <database>(); IEnumerator <string> databaseIter = databaseMap.Keys.GetEnumerator(); while (databaseIter.MoveNext()) { database database = databaseMap[databaseIter.Current]; databases.Add(database); } return(databases.ToArray()); } else { return(null); } }
private void txtOutput_DragDrop(object sender, DragEventArgs e) { relFiles = new List <relFile>(); relf = new relFile(); headers = new List <string>(); Headers = new List <Header>(); nutrNos = new List <string>(); txtOutput.Clear(); txtName.Clear(); txtNutrDesc.Clear(); txtFlavVal.Clear(); txtNdb.Clear(); txtNutrNo.Clear(); listBox1.Items.Clear(); if (radioMultiKey.Checked) { string folder = ((string[])e.Data.GetData(DataFormats.FileDrop))[0]; if (!Directory.Exists(folder)) { MessageBox.Show("Is not a valid directory\n" + folder); txtOutput.Text = "<Drag and drop>\r\n<the folder>\r\n<contains *.TXT files>\r\n<more than one!!>"; return; } files = Directory.GetFiles(((string[])e.Data.GetData(DataFormats.FileDrop))[0]); folder = folder.Split(new char[] { '/', '\\' })[folder.Split(new char[] { '/', '\\' }).Length - 1]; txtName.Text = folder.ToUpper(); foreach (string s in files) { relFile r = new relFile(); r.file = s; r.lines = File.ReadAllLines(s); r.headers = r.lines[0].Split('\t'); for (int i = 0; i < r.headers.Length; i++) { if (r.unit == "") { try { r.unit = r.headers[i].Split('(')[1].Split(')')[0]; r.headers[i] = r.headers[i].Split('(')[0].Trim(); } catch { } } if (!headers.Contains(r.headers[i])) { headers.Add(r.headers[i]); } } column c = new column(); string f = s.Split(Path.DirectorySeparatorChar)[s.Split(Path.DirectorySeparatorChar).Length - 1]; txtOutput.Text += f + "\r\n"; txtOutput.Text += $"{string.Join("\r\n", r.headers)}\r\n\r\n"; relFiles.Add(r); } foreach (string s in headers) { Header h = new Header(); h.header = s; Headers.Add(h); } foreach (Header h in Headers) { foreach (relFile r in relFiles) { if (r.headers.Contains(h.header)) { h.occcurance++; } } } int hMax = 0; foreach (Header h in Headers) { if (h.occcurance > hMax) { hMax = h.occcurance; } } List <string> suspKeys = new List <string>(); for (int i = hMax; i > 1; i--) { foreach (Header h in Headers) { if (h.occcurance == i) { suspKeys.Add(h.header); } } } txtOutput.Text = $"Recurrent keys:\r\n{string.Join("\r\n", suspKeys)}\r\n\r\n" + txtOutput.Text; string[] parentHeaders = File.ReadAllLines(activeDBdir + slash + "_nameKeyPairs.TXT"); for (int i = 0; i < parentHeaders.Length; i++) { parentHeaders[i] = parentHeaders[i].Split('|')[1]; } foreach (string s in parentHeaders) { foreach (string st in headers) { if (s == st) { listBox1.Items.Add(s); } } } AutoCompleteStringCollection source = new AutoCompleteStringCollection(); foreach (string s in headers) { source.Add(s); if (s == "NDB_No") { txtNdb.Text = s; } else if (s == "NutrDesc") { txtNutrDesc.Text = s; } else if (s == "Nutr_No") { txtNutrNo.Text = s; } else if (s == "Flav_Val" || s == "Isfl_Val") { txtFlavVal.Text = s; } } txtNutrDesc.AutoCompleteCustomSource = source; txtNutrDesc.AutoCompleteSource = AutoCompleteSource.CustomSource; txtNutrDesc.AutoCompleteMode = AutoCompleteMode.SuggestAppend; txtNutrNo.AutoCompleteCustomSource = source; txtNutrNo.AutoCompleteSource = AutoCompleteSource.CustomSource; txtNutrNo.AutoCompleteMode = AutoCompleteMode.SuggestAppend; txtFlavVal.AutoCompleteCustomSource = source; txtFlavVal.AutoCompleteSource = AutoCompleteSource.CustomSource; txtFlavVal.AutoCompleteMode = AutoCompleteMode.SuggestAppend; txtNdb.AutoCompleteCustomSource = source; txtNdb.AutoCompleteSource = AutoCompleteSource.CustomSource; txtNdb.AutoCompleteMode = AutoCompleteMode.SuggestAppend; } else { string file = ((string[])e.Data.GetData(DataFormats.FileDrop))[0]; if (!File.Exists(file) || !file.EndsWith(".TXT")) { MessageBox.Show("Is not a valid .TXT file\n" + file); txtOutput.Text = "<Drag and drop>\r\n<a single .TXT file>"; return; } relFile r = new relFile(); r.file = file; r.lines = File.ReadAllLines(file); r.headers = r.lines[0].Split('\t'); relf = r; foreach (string s in r.headers) { Header H = new Header(); H.header = s.Split('(')[0].Trim(); try { H.unit = s.Split('(')[1].Split(')')[0]; } catch { } if (!headers.Contains(s.Split('(')[0].Trim())) { headers.Add(s.Split('(')[0].Trim()); } Headers.Add(H); } file = file.Split(Path.DirectorySeparatorChar)[file.Split(Path.DirectorySeparatorChar).Length - 1].Replace(".TXT", ""); txtName.Text = file; txtOutput.Text += file + ".TXT\r\n"; foreach (Header H in Headers) { txtOutput.Text += H.header + "\r\n"; } txtOutput.Text += "\r\nUnits detected:\r\n"; foreach (Header H in Headers) { if (H.unit != null && H.unit != "") { txtOutput.Text += H.unit + "\r\n"; } } string[] parentHeaders = File.ReadAllLines(activeDBdir + slash + "_nameKeyPairs.TXT"); for (int i = 0; i < parentHeaders.Length; i++) { parentHeaders[i] = parentHeaders[i].Split('|')[1]; } foreach (string s in parentHeaders) { foreach (string st in headers) { if (s == st) { listBox1.Items.Add(s); } } } AutoCompleteStringCollection source = new AutoCompleteStringCollection(); foreach (Header H in Headers) { string s = H.header; source.Add(s); if (s == "NDB_No") { txtNdb.Text = s; } } txtFlavVal.AutoCompleteCustomSource = source; txtFlavVal.AutoCompleteSource = AutoCompleteSource.CustomSource; txtFlavVal.AutoCompleteMode = AutoCompleteMode.SuggestAppend; txtNdb.AutoCompleteCustomSource = source; txtNdb.AutoCompleteSource = AutoCompleteSource.CustomSource; txtNdb.AutoCompleteMode = AutoCompleteMode.SuggestAppend; } }
private void btnCreate_Click(object sender, EventArgs e) { if (radioMultiKey.Checked) { if (!headers.Contains(txtNutrNo.Text) || !headers.Contains(txtNutrDesc.Text) || !headers.Contains(txtNdb.Text) || !headers.Contains(txtFlavVal.Text)) { MessageBox.Show("Please fill everything out. Not all the fields match."); return; } string newRelDir = $"{Application.StartupPath}{slash}usr{slash}share{slash}rel{slash}multi{slash}{txtName.Text}"; Directory.CreateDirectory(newRelDir); string unit = ""; string ndb = ""; string nutrNo = ""; foreach (relFile r in relFiles) { string f = r.file.Split(new char[] { '/', '\\' })[r.file.Split(new char[] { '/', '\\' }).Length - 1].Replace(".TXT", ""); Directory.CreateDirectory(newRelDir + slash + f); for (int i = 0; i < r.headers.Length; i++) { column c = new column(); c.header = r.headers[i]; for (int j = 1; j < r.lines.Length; j++) { c.rows.Add(r.lines[j].Split('\t')[i]); } r.columns.Add(c); } foreach (column c in r.columns) { File.WriteAllLines(newRelDir + slash + f + slash + c.header + ".TXT", c.rows); if (c.header == txtNutrNo.Text) { nutrNos = c.rows; } else if (c.header == txtFlavVal.Text) { flavVal = $"{slash}{f}{slash}{c.header}.TXT"; } if (r.unit != "") { unit = r.unit; } } nutrNos = nutrNos.ToArray().Distinct().ToList(); nutrNos.Sort(); File.WriteAllText(newRelDir + slash + "_dbInit.TXT", $"[ParentDB]{comboBox1.Text}\r\n[Values]{txtFlavVal.Text}.TXT\r\n[Units]{unit}\r\n[ParentKey]$NDBNo\r\n[ChildKey]$NutrNo\r\n[Fields]{txtNutrDesc.Text}.TXT"); txtOutput.Text = "Units: " + unit + txtOutput.Text; } files = Directory.GetFiles(newRelDir, "*.TXT", SearchOption.AllDirectories); foreach (string s in files) { if (s.EndsWith(txtFlavVal.Text + ".TXT")) { ndb = s.Replace(txtFlavVal.Text + ".TXT", txtNdb.Text + ".TXT"); } else if (s.EndsWith(txtNutrDesc.Text + ".TXT")) { nutrNo = s.Replace(txtNutrDesc.Text + ".TXT", txtNutrNo.Text + ".TXT"); } } ndb = ndb.Replace(newRelDir, "").Replace(slash, "/"); nutrNo = nutrNo.Replace(newRelDir, "").Replace(slash, "/"); string text = File.ReadAllText(newRelDir + slash + "_dbInit.TXT"); text = text.Replace("$NDBNo", ndb).Replace("$NutrNo", nutrNo); File.WriteAllText(newRelDir + slash + "_dbInit.TXT", text); MessageBox.Show($"Database created successfully! Go to the extended tab of the {comboBox1.Text} database to configure it"); //this.Close(); } else { if (!headers.Contains(txtNdb.Text) || !headers.Contains(txtFlavVal.Text)) { MessageBox.Show("Please fill everything out. Not all the fields match."); return; } string newRelDir = $"{Application.StartupPath}{slash}usr{slash}share{slash}rel{slash}single{slash}{txtName.Text}"; Directory.CreateDirectory(newRelDir); for (int i = 0; i < relf.headers.Length; i++) { List <string> c = new List <string>(); for (int j = 1; j < relf.lines.Length; j++) { c.Add(relf.lines[j].Split('\t')[i]); } File.WriteAllLines($"{newRelDir}{slash}{headers[i]}.TXT", c); } } }
ref Block8x8 blockRef = ref this.GetBlockReference(column, row);
Column(column, escape, alias);