/// <summary> /// 保存笔记 /// </summary> /// <param name="note"></param> /// <returns></returns> public bool savanote(noteinfo note) { try { SqlParameter[] parames = new SqlParameter[] { new SqlParameter("@noteTitle", SqlDbType.NVarChar, 150), new SqlParameter("@noteContent", SqlDbType.NVarChar), new SqlParameter("@noteTime", SqlDbType.NVarChar, 13), new SqlParameter("@noteTag", SqlDbType.NVarChar, 100), new SqlParameter("@userId", SqlDbType.NVarChar, 32), new SqlParameter("@noteUrl", SqlDbType.NVarChar, 150), new SqlParameter("@reprint", SqlDbType.NVarChar, 1), new SqlParameter("@ispublic", SqlDbType.NVarChar, 1), }; parames[0].Value = note.noteTitle; parames[1].Value = note.noteContent; parames[2].Value = note.noteTime; parames[3].Value = note.noteTag; parames[4].Value = note.userId; parames[5].Value = note.noteUrl ?? "";; parames[6].Value = note.reprint; parames[7].Value = note.ispublic; return(DB.ExecuteNonQuery(cs, "saveNote", parames) > 0 ? true : false); } catch (Exception ex) { return(false); } }
// Update is called once per frame void Update() { for (; ;) { if (listTimeNote.Count > 0 && listTimeNote[0].Key - 3f <= asSong.time) { var info = new noteinfo(listTimeNote[0].Value); switch (info.type) { default: break; case 0: { var go = Instantiate(prefLeftRed); go.transform.position = trLeft.position; go.transform.Translate(0, Random.Range(-100, 100) / 100f, 0); var note = go.GetComponent <note>(); note.info = info; note.asSong = asSong; } break; case 1: { var go = Instantiate(prefRightBlue); go.transform.position = trRight.position; go.transform.Translate(0, Random.Range(-100, 100) / 100f, 0); var note = go.GetComponent <note>(); note.info = info; note.asSong = asSong; } break; } listTimeNote.RemoveAt(0); } else { break; } } }
public bool saveNote(noteinfo note) { return(noteDAL.savanote(note)); }