public ActionResult List(string project, string severity, string datediscovered, string timediscovered, int projectedmanhours, string shortdescription, string location, string description) { List <string> newArgs = new List <string>(); MySqlTableModel issueTable = SqlTables.Issues; //projectedmanhours string pmh = projectedmanhours.ToString(); //projectedcost float tempPc = projectedmanhours * 20; string pc = tempPc.ToString(); newArgs = new List <string>() { "DEFAULT", project, severity, datediscovered, timediscovered, pmh, pc, shortdescription, location, "DEFAULT", description }; MySqlCrud.InsertRow(SqlConnections.IssueWebsite, issueTable.Table, issueTable.Collumns, newArgs); return(RedirectToAction("List")); }
public ActionResult List() { List <Issue> issues = new List <Issue>(); List <string>[] values; MySqlTableModel issueTable = SqlTables.Issues; values = MySqlCrud.SelectAllRows(SqlConnections.IssueWebsite, issueTable.Table, issueTable.Collumns); /* * idIssues DEFAULT(int) * project name * severity string * datediscovered string XX/XX/XXXX * time discovered string XX:XX:XX * projectedmanhours float * projectedcost float * shortdescription string * location string * popularity int * description string */ int r = 0; foreach (var i in values[0]) { int issueId; Int32.TryParse(values[0][r], out issueId); string project = values[1][r]; //100 MaxChars string severity = values[2][r]; //45 MaxChars string datediscovered = values[3][r]; //45 MaxChars string timediscovered = values[4][r]; //45 MaxChars int pmhTemp; Int32.TryParse(values[5][r], out pmhTemp); float projectedmanhours = (float)pmhTemp; int pcTemp; Int32.TryParse(values[6][r], out pcTemp); float projectedcost = (float)pcTemp; string shortdescription = values[7][r]; //100 MaxChars string location = values[8][r]; //45 MaxChars int popularity; Int32.TryParse(values[9][r], out popularity); string description = values[10][r]; //300 MaxChars Issue ish = new Issue() { Project = project, Severity = severity, DateDiscovered = datediscovered, TimeDiscovered = timediscovered, ProjectedManHours = projectedmanhours, ProjectedCost = projectedcost, ShortDescription = shortdescription, Location = location, Popularity = popularity, Description = description }; issues.Add(ish); r++; } IssueListModel IssueListModel = new IssueListModel() { Issues = issues }; return(View(IssueListModel)); }
/// <summary> /// 获得模型代码字符串 /// </summary> /// <param name="tableModel">表模型</param> /// <returns>模型代码字符串</returns> public string GetModelCodeStrByCSharp(MySqlTableModel tableModel) { string code = string.Empty; code += "using System;\r\n"; code += "using System.ComponentModel;\r\n"; code += "using System.ComponentModel.DataAnnotations;\r\n"; code += "using System.ComponentModel.DataAnnotations.Schema;\r\n"; code += "using MateralTools.MEntityFramework;\r\n"; code += String.Format("namespace {0}.Model\r\n", ProjectName); code += "{\r\n"; if (!tableModel.Remark.MIsNullOrEmpty()) { code += " /// <summary>\r\n"; code += String.Format(" /// {0}\r\n", tableModel.Remark); code += " /// </summary>\r\n"; } code += String.Format(" [Table(\"{0}\")]\r\n", tableModel.Name); code += String.Format(" public class {0}\r\n", tableModel.Name); code += " {\r\n"; if (tableModel.Columns != null && tableModel.Columns.Count > 0) { List <MySqlColumnModel> PKitems = tableModel.Columns.Where(m => m.ColumKey == "PRI").ToList(); if (PKitems == null || PKitems.Count == 0) { tableModel.Columns[0].ColumKey = "PRI"; } foreach (MySqlColumnModel item in tableModel.Columns) { if (!item.Remark.MIsNullOrEmpty()) { code += " /// <summary>\r\n"; code += String.Format(" /// {0}\r\n", item.Remark); code += " /// </summary>\r\n"; code += String.Format(" [Description(\"{0}\")]\r\n", item.Remark); } code += String.Format(" [Column(\"{0}\")]\r\n", item.Name); if (item.ColumKey == "PRI") { code += " [Key]\r\n"; } if (item.DataType == "timestamp") { code += " [Timestamp]\r\n"; } else if (item.IsNull == "NO" && item.ColumKey != "PRI") { code += " [Required]\r\n"; } if (item.Name == "IsDelete") { code += " [LogicDelete]\r\n"; } //if (item.TypeByCSharp == "string") //{ // code += string.Format(" [MaxLength({0})]\r\n", item.Length); //} code += String.Format(" public {0} {1} ", item.TypeByCSharp, item.Name) + "{ get; set; }\r\n"; } } code += " }\r\n"; code += "}\r\n"; return(code); }