/// <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));
}
