/// <summary>
/// 즐겨찾기추가
/// </summary>
/// <param name="list"></param>
/// <returns></returns>
public bool InsertBookMark(BookMark_VO list)
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.Connection = new SqlConnection(Connstr);
cmd.CommandText = "InsertBookMark";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@User_ID", list.User_ID);
cmd.Parameters.AddWithValue("@Screen_Code", list.Screen_Code);
cmd.Parameters.AddWithValue("@Parent_Screen_Code", list.Parent_Screen_Code);
cmd.Parameters.AddWithValue("@Type", list.Type);
cmd.Parameters.AddWithValue("@Ins_Date", DateTime.Now);
cmd.Parameters.AddWithValue("@Ins_Emp", "박상인");
cmd.Connection.Open();
var rowsAffected = cmd.ExecuteNonQuery();
cmd.Connection.Close();
return(rowsAffected > 0);
}
}
private void 즐겨찾기ToolStripMenuItem_Click(object sender, EventArgs e)
{
MainForm_Service service = new MainForm_Service();
MenuTree_Master_VO parentname = menulist.Find(item => item.Screen_Name == tvMenu.SelectedNode.Text);//부모코드find
BookMark_VO bookmark = new BookMark_VO();
bookmark.Parent_Screen_Code = parentname.Parent_Screen_Code;
bookmark.Screen_Code = parentname.Screen_Code;
bookmark.User_ID = UserInfo.User_ID;
bookmark.Type = parentname.Screen_Name;
if (!string.IsNullOrEmpty(parentname.Parent_Screen_Code))
{
if (!service.InsertBookMark(bookmark))
{
MessageBox.Show("이미등록된 항목입니다.", "알림", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
tvBookMark.Nodes.Clear();
booklist = service.GetAll_BookMark(UserInfo.User_ID);
tvBookMark.Nodes.Add("즐겨찾기");
for (int i = 0; i < booklist.Count; i++)
{
tvBookMark.TopNode.Nodes.Add(booklist[i].Type);
}
tvBookMark.ExpandAll();
}
}
else
{
MessageBox.Show("등록할 수 없는 항목입니다.", "알림", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public bool InsertBookMark(BookMark_VO list)
{
MainForm_DAC dac = new DAC.MainForm_DAC();
return(dac.InsertBookMark(list));
}