13.02.04 C# Linq 添加、修改 带有richTextBox格式的内容到数据库

修改
                        //db.RTUs.AsEnumerable().ElementAt(listBox_rtu.SelectedIndex).RTU_ID = textBox_rtuID.Text;
                        //db.RTUs.AsEnumerable().ElementAt(listBox_rtu.SelectedIndex).X = Convert.ToInt32(textBox_PosX.Text);
                        //db.RTUs.AsEnumerable().ElementAt(listBox_rtu.SelectedIndex).Y = Convert.ToInt32(textBox_PosY.Text);
                        //db.RTUs.AsEnumerable().ElementAt(listBox_rtu.SelectedIndex).GPRS_ID = textBox_PosX.Text;

                        //var stream = new System.IO.MemoryStream();
                        //richTextBox_rtuDescription.SaveFile(stream, RichTextBoxStreamType.RichText);
                        //stream.WriteByte(13);
                        //byte[] buffer = stream.GetBuffer();
                        //db.RTUs.AsEnumerable().ElementAt(listBox_rtu.SelectedIndex).rtf = buffer;

                        //
                        //先删除，
                        //
                        var rs = from rtu in db.RTUs
                                 where rtu.RTU_ID == listBox_rtu.SelectedItem.ToString()
                                 select rtu;
                        db.RTUs.DeleteAllOnSubmit(rs);
                        db.SubmitChanges();

                        //
                        //再添加
                        //
                        RTUs newrtu = new RTUs();
                        newrtu.RTU_ID = textBox_rtuID.Text;
                        newrtu.X = Convert.ToInt32(textBox_PosX.Text);
                        newrtu.Y = Convert.ToInt32(textBox_PosY.Text);
                        newrtu.GPRS_ID = textBox_gprsNum.Text;
                        var stream = new System.IO.MemoryStream();
                        richTextBox_rtuDescription.SaveFile(stream, RichTextBoxStreamType.RichText);
                        stream.WriteByte(13);
                        byte[] buffer = stream.GetBuffer();
                        newrtu.rtf = buffer;
                        db.RTUs.InsertOnSubmit(newrtu);

                        db.SubmitChanges();

。。。。。

删除

                var results = from r in db.RTUs
                              where r.RTU_ID == listBox_rtu.SelectedItem.ToString()
                              select r;
                db.RTUs.DeleteAllOnSubmit(results);
                db.SubmitChanges();

。。。。。

添加

                        RTUs newRtu = new RTUs();

                        newRtu.RTU_ID = textBox_rtuID.Text;
                        newRtu.X = Convert.ToInt32(textBox_PosX.Text);
                        newRtu.Y = Convert.ToInt32(textBox_PosY.Text);
                        newRtu.GPRS_ID = textBox_PosX.Text;

                        var stream = new System.IO.MemoryStream();
                        richTextBox_rtuDescription.SaveFile(stream, RichTextBoxStreamType.RichText);
                        stream.WriteByte(13);
                        byte[] buffer = stream.GetBuffer();
                        newRtu.rtf = buffer;

                        db.RTUs.InsertOnSubmit(newRtu);
                        db.SubmitChanges();