/// <summary> /// 添加反馈 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Insert_FeedbackTableData(Feedback_Table obj) { return(DBHerlper.ExecuteNonQuery(GetSqlString("Insert"), CommandType.StoredProcedure, new SqlParameter[] { new SqlParameter("@U_id", obj.U_id), new SqlParameter("@P_id", obj.P_id), new SqlParameter("@Feed_Datetime", obj.Feed_Datetime), new SqlParameter("@Feed_Content", obj.Feed_Content) })); }
private void button1_Click(object sender, EventArgs e) { Feedback_Table ft = new Feedback_Table(); ft.FeedbackCategoryID = comboBox1.SelectedIndex + 1; ft.MemberID = member_id; ft.Contents = textBox1.Text; ft.ProgressID = 1; ft.FeedbackDate = DateTime.Today; if (pictureBox1.Image != null) { byte[] bytes; System.IO.MemoryStream ms = new System.IO.MemoryStream(); pictureBox1.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg); bytes = ms.GetBuffer(); ft.Picture = bytes; } DE.Feedback_Table.Add(ft); DE.SaveChanges(); listBox1.Items.Clear(); var q1 = new CCustomerMsg().get_Feedback_msg(member_id); foreach (var item in q1) { listBox1.Items.Add(item); } textBox1.Text = ""; pictureBox1.Image = null; 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(); }
/// <summary> /// 获取全部的反馈 /// </summary> /// <returns></returns> public List <Feedback_Table> GetFeedbackTableAll() { List <Feedback_Table> list = new List <Feedback_Table>(); SqlDataReader dr = DBHerlper.ExecuteReader(GetSqlString("Select"), CommandType.StoredProcedure); while (dr.Read()) { Feedback_Table obj = new Feedback_Table() { Feed_Content = dr["Feed_Content"].ToString(), Feed_Datetime = Convert.ToDateTime(dr["Feed_Datetime"]), Feed_id = Convert.ToInt32(dr["Feed_id"]), P_id = Convert.ToInt32(dr["P_id"]), U_id = Convert.ToInt32(dr["U_id"]) }; list.Add(obj); } dr.Close(); return(list); }
/// <summary> /// 根据ID查询反馈信息 /// </summary> /// <param name="con"></param> /// <returns></returns> public Feedback_Table GetFeedbackTableByConn(string con) { Feedback_Table obj = null; SqlDataReader dr = DBHerlper.ExecuteReader( "Select * from Feedback_Table where Feed_id=@Feed_id", CommandType.Text, new SqlParameter[] { new SqlParameter("@Feed_id", con) }); if (dr.Read()) { obj = new Feedback_Table() { Feed_Content = dr["Feed_Content"].ToString(), Feed_Datetime = Convert.ToDateTime(dr["Feed_Datetime"]), Feed_id = Convert.ToInt32(dr["Feed_id"]), P_id = Convert.ToInt32(dr["P_id"]), U_id = Convert.ToInt32(dr["U_id"]) }; } dr.Close(); return(obj); }
/// <summary> /// 更改反馈信息 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Update_FeedbackTableData(Feedback_Table obj) { return(relevanceClass.Update_FeedbackTableData(obj)); }
/// <summary> /// 添加反馈信息 /// </summary> /// <param name="obj">带入参数</param> /// <returns></returns> public int Insert_FeedbackTableData(Feedback_Table obj) { return(relevanceClass.Insert_FeedbackTableData(obj)); }