private void FCustomerMsg_Load(object sender, EventArgs e) { toolTip1.SetToolTip(this.pictureBox1, "請拖放圖片至此"); //var get_AuthorityID = (from n in DE.Member_Table // where n.MemberID == member_id // select n.AuthorityID).FirstOrDefault(); //m_AuthorityID = (int)get_AuthorityID; if (m_AuthorityID < 3) { textBox2.Visible = false; label2.Visible = false; pictureBox2.Visible = false; button2.Visible = false; label4.Visible = false; var q2 = from n in DE.Feedback_Table where n.MemberID == member_id select new { n.Feedback_Category_Table.FeedbackCategory, n.Contents, n.FeedbackContent, n.Feedback_Progress_Table.ProgressContent, n.FeedbackDate, n.Picture }; dataGridView1.DataSource = q2.ToList(); label3.Text = Viewbag.member.MemberName; } else { label1.Visible = false; pictureBox1.Visible = false; textBox1.Visible = false; listBox1.Visible = false; button1.Visible = false; label3.Visible = false; var q2 = new CCustomerMsg().get_Feedback_process(4); dataGridView1.DataSource = q2.ToList(); dataGridView1.Columns[9].Visible = false; dataGridView1.Columns[10].Visible = false; dataGridView1.Columns[11].Visible = false; label4.Text = Viewbag.member.MemberName; } comboBox1.DataSource = new CCustomerMsg().get_Feedback_Category().ToList(); var q1 = new CCustomerMsg().get_Feedback_msg(member_id); foreach (var item in q1) { listBox1.Items.Add(item); } }
private void button2_Click(object sender, EventArgs e) { int current_index = (int)(dataGridView1.CurrentRow.Cells[0].Value); var q = (from n in DE.Feedback_Table where n.FeedbackID == current_index select n).FirstOrDefault(); q.FeedbackContent = textBox2.Text; q.ProgressID = 3; q.FeedbackDate = DateTime.Now; DE.SaveChanges(); var q2 = new CCustomerMsg().get_Feedback_process(4); dataGridView1.DataSource = q2.ToList(); dataGridView1.Columns[9].Visible = false; dataGridView1.Columns[10].Visible = false; dataGridView1.Columns[11].Visible = false; textBox2.Text = ""; }