初学linq （1）

最新推荐文章于 2024-10-14 16:51:37 发布

小生我怕怕

最新推荐文章于 2024-10-14 16:51:37 发布

阅读量533

点赞数

分类专栏： linq 文章标签： linq byte website null qq

本文链接：https://blog.csdn.net/wowmboy/article/details/6210710

版权

linq 专栏收录该内容

0 篇文章 0 订阅

订阅专栏

l.增

     try
          {
            crmDataContext myc = new crmDataContext();
            con.Beizhu = remark;
            if (pathName != "")
            {
                //保存图片
                System.IO.FileStream fs =
                       new System.IO.FileStream(pathName, System.IO.FileMode.Open, System.IO.FileAccess.Read);
                byte[] bufferByte = new byte[fs.Length];
                fs.Read(bufferByte, 0, (int)fs.Length);
                fs.Close();
                fs = null;
                con.MyPic = bufferByte;
            }

            myc.Contact.InsertOnSubmit(con);
            myc.SubmitChanges();
            MessageBox.Show("保存成功");
            this.Close();
            //重新绑定GridvIEW
            tls.bdLinker();
            }

catch()

{

}

2.改

crmDataContext myc2 = new crmDataContext();

            var vContect = from p in myc2.Contact
                           where p.cid == Convert.ToInt32(_id)
                           select new { p };

            Contact con2 = myc2.Contact.Where(p => p.cid.ToString() == _id).First();
            con2.Name = name;
            con2.FirstChar = getSpells(name);
            con2.QQ = qq;
            con2.Web = website;
            con2.Shengshi = shengshi;
            con2.Shixian = shixian;
            con2.Jiedao = street;
            con2.Beizhu = remark;
            if (pathName != "")
            {
                //保存图片
                System.IO.FileStream fs =
                       new System.IO.FileStream(pathName, System.IO.FileMode.Open, System.IO.FileAccess.Read);
                byte[] bufferByte = new byte[fs.Length];
                fs.Read(bufferByte, 0, (int)fs.Length);
                fs.Close();
                fs = null;
                con2.MyPic = bufferByte;
            }

myc2.SubmitChanges();
MessageBox.Show("修改成功！");

3.删

if (_callID != "")
            {
                try
                {
                    crmDataContext mcc = new crmDataContext();
                    var vContect = from p in mcc.call
                                   where p.id == Convert.ToInt32(_callID)
                                   select new { p };

                    call cl = mcc.call.FirstOrDefault(a => a.id.ToString() == _callID);
                    mcc.call.DeleteOnSubmit(cl);
                    mcc.SubmitChanges();
                    MessageBox.Show("删除成功！");
                    bddgvTHJL();
                }
                catch
                {
                    MessageBox.Show("删除失败！");
                }
            }

4.查

crmDataContext cdcL = new crmDataContext();
                var aa = from p in cdcL.lines
                         where p.Line==Convert.ToInt32(_line)
                         select p;
               this.lblTD.Text= aa.FirstOrDefault().Line.Value.ToString();
               tbTDName.Text = aa.FirstOrDefault().Phone;