/// ################################################################# /// <summary> /// 获取所有发明人名称 /// Kevin Wang(2010-10-25) /// </summary> /// <returns>所有发明人名称</returns> public string GetInventorNames(string sSplit) { string sNames = ""; IOrderedEnumerable <Inventor> Invertors = from e in Inventors.Cast <Inventor>() orderby e.n_Sequence select e; switch (sSplit) { case "1": foreach (Inventor app in Invertors) { sNames += app.s_Name + ";"; } sNames = sNames.TrimEnd(new[] { ';' }); break; case "2": foreach (Inventor app in Invertors) { sNames += app.s_Name + " "; } sNames = sNames.Trim(); break; case "3": foreach (Inventor app in Invertors) { sNames += app.s_Name + "、"; } sNames = sNames.TrimEnd(new[] { '、' }); break; case "4": foreach (Inventor app in Invertors) { sNames += app.s_Name + ";"; } sNames = sNames.TrimEnd(new[] { ';' }); break; case "5": int iCount = 1; sNames = " "; foreach (Inventor app in Invertors) { sNames += " " + iCount + "." + app.s_Name; } break; } return(sNames); }
public override Task Init() { // generate random order when the page is loaded the first time if (!Context.IsPostBack) { Inventions = Inventors .OrderBy(i => Guid.NewGuid()) .Select(i => i.Invention) .ToList(); } return(base.Init()); }
public IHttpActionResult DeleteInventors(int id) { Inventors inventors = db.Inventors.Find(id); if (inventors == null) { return(NotFound()); } db.Inventors.Remove(inventors); db.SaveChanges(); return(Ok(inventors)); }
public override int GetHashCode() { unchecked { var hashCode = RegNumber; hashCode = (hashCode * 397) ^ (Country != null ? Country.GetHashCode() : 0); hashCode = (hashCode * 397) ^ (Inventors != null ? Inventors.GetHashCode() : 0); hashCode = (hashCode * 397) ^ AppDate.GetHashCode(); hashCode = (hashCode * 397) ^ PubDate.GetHashCode(); hashCode = (hashCode * 397) ^ (Name != null ? Name.GetHashCode() : 0); hashCode = (hashCode * 397) ^ (Note != null ? Note.GetHashCode() : 0); hashCode = (hashCode * 397) ^ CountPages; return(hashCode); } }
public void CheckAnswer() { var selectedInventor = Inventors.First(i => i.Id == SelectedInventor); if (selectedInventor.Invention == SelectedInvention) { Inventors.Remove(selectedInventor); Inventions.Remove(selectedInventor.Invention); SelectedInventor = null; SelectedInvention = null; Points++; } else { Points = Points - 2; } }
/// ################################################################# /// <summary> /// 获取所有发明人其他名称 /// Kevin Wang(2010-10-25) /// </summary> /// <returns>所有发明人其他名称</returns> public string GetInventorOtherNames() { string sNames = ""; //2013-01-29 lixin for bug 26607 IOrderedEnumerable <Inventor> Invertors = from e in Inventors.Cast <Inventor>() orderby e.n_Sequence select e; foreach (Inventor app in Invertors) { sNames += app.s_NativeName + ";"; } //foreach (Inventor person in this.Inventors) //{ // sNames += person.s_NativeName + ";"; //} sNames = sNames.TrimEnd(new[] { ';' }); //去掉最后一个分号 return(sNames); }
public IHttpActionResult PostInventors(Inventors inventors) { db.Inventors.Add(inventors); try { db.SaveChanges(); } catch (DbUpdateException) { if (InventorsExists(inventors.ID)) { return(Conflict()); } else { throw; } } return(CreatedAtRoute("DefaultApi", new { id = inventors.ID }, inventors)); }
public IHttpActionResult PutInventors(int id, Inventors inventors) { if (id != inventors.ID) { return(BadRequest()); } string procedure = ""; int number; string connectionString = @"Data Source=DESKTOP-RDKB255\SQLEXPRESS;Initial Catalog=articles;Integrated Security=True"; SqlConnection connection = new SqlConnection(connectionString); try { string commandStr = $"EXEC InventorsRating @id = '{inventors.ID}'," + $" @rating = '{inventors.Rating}'"; connection.Open(); SqlCommand command = new SqlCommand(commandStr, connection); number = command.ExecuteNonQuery(); } catch (SqlException ex) { return(BadRequest(ex.Message)); } finally { connection.Close(); } if (number != null) { return(Ok()); } return(null); }
public int CompareTo(object obj) { var newObj = obj as Patent; if (ReferenceEquals(this, newObj)) { return(0); } else if (newObj == null) { return(1); } var cmp = DateTime.Compare(PubDate, newObj.PubDate); if (cmp != 0) { return(cmp); } cmp = Inventors.OrderBy(t => t).SequenceEqual(newObj.Inventors.OrderBy(t => t)) ? 1 : 0; if (cmp != 0) { return(cmp); } cmp = DateTime.Compare(AppDate, newObj.AppDate); if (cmp != 0) { return(cmp); } cmp = string.Compare(Country, newObj.Country, StringComparison.Ordinal); if (cmp != 0) { return(cmp); } cmp = string.Compare(Name, newObj.Name, StringComparison.Ordinal); if (cmp != 0) { return(cmp); } cmp = RegNumber.CompareTo(newObj.RegNumber); if (cmp != 0) { return(cmp); } cmp = string.Compare(Note, newObj.Note, StringComparison.Ordinal); if (cmp != 0) { return(cmp); } cmp = CountPages.CompareTo(newObj.CountPages); if (cmp != 0) { return(cmp); } cmp = Price.CompareTo(newObj.Price); if (cmp != 0) { return(cmp); } cmp = PubYear.CompareTo(newObj.PubYear); if (cmp != 0) { return(cmp); } return(0); }