C# DataClassesDataContext.SubmitChanges方法代码示例

    protected void Button1_Click(object sender, EventArgs e)
    {
        DataClassesDataContext da = new DataClassesDataContext();

        var result1 = from n in da.user
                     where n.user_name == TextBox3.Text
                     select n.major;
        var result2 = from m in da.project
                      where m.project_num == DropDownList1.Text
                      select m.major;
        foreach (var n in result1)
        {
            foreach (var m in result2)
            {
                if (n != m)
                {
                    ClientScriptManager client = this.ClientScript;
                    client.RegisterStartupScript(this.GetType(), "55", "<script>alert('专业不符！');history.back()</script>");
                    return;
                }
            }
        }
        proposal p = new proposal();
        p.proposal1 = TextBox1.Text;
        p.project_num = DropDownList1.Text;
        p.teacher_name = DropDownList2.Text;
        p.user_name = TextBox3.Text;
        p.proposal_num = TextBox2.Text;
        da.proposal.InsertOnSubmit(p);
        da.SubmitChanges();
        GridView1.DataBind();
    }

    protected void PrzydzielZadanieButton_Click(object sender, EventArgs e)
    {
        List<int> idGrupList = new List<int>();
        for (int i = 0; i < EnableGroupsListView.Items.Count; i++)
        {
            CheckBox chk = EnableGroupsListView.Items[i].FindControl("NazwaCheckBox") as CheckBox;
            if (chk != null && chk.Checked)
            {
                idGrupList.Add((int)EnableGroupsListView.DataKeys[i].Value);
            }
        }

        DataClassesDataContext db = new DataClassesDataContext();
        Zadania zadanie = db.Zadanias.FirstOrDefault(g => g.IdZadania == (int)((DataKey)Session["IdZadania"]).Value);
        foreach (int id in idGrupList)
        {
            ZadaniawGrupach zadaniawGrupach = new ZadaniawGrupach
                                                  {
                                                      Zadania = zadanie,
                                                      IdGrupy = id,
                                                      DataDodania = DateTime.Now
                                                  };
            db.ZadaniawGrupaches.InsertOnSubmit(zadaniawGrupach);
        }
        db.SubmitChanges();
        WczytajListeGrup(db);
        SuccesLabel.Text = "Dodano zadanie do grup/y";
        SuccesLabel.ForeColor = System.Drawing.Color.Green;
    }

    protected void SubmitButton_Click(object sender, EventArgs e)
    {
        TextBox commentCtrl = (TextBox)CommentsLoginView.FindControl("CommentTextBox");
        if (commentCtrl != null && commentCtrl.Text.Length > 0)
        {
            using (DataClassesDataContext dtx = new DataClassesDataContext())
            {
                int aid = 0;
                MembershipUser mu = Membership.GetUser(HttpContext.Current.User.Identity.Name);
                if (int.TryParse(Context.Request["aid"], out aid))
                {
                    var comment = new Comment()
                    {
                        ArticleId = aid,
                        UserId = (Guid)mu.ProviderUserKey,
                        Body = commentCtrl.Text,
                        Created = System.DateTime.Now
                    };
                    dtx.Comments.InsertOnSubmit(comment);
                    dtx.SubmitChanges();

                    CommentService c = new CommentService();
                    CommentsDataList.DataSource = c.GetComments(aid);
                    CommentsDataList.DataBind();
                }
                commentCtrl.Text = "";
            }
        }
    }

    protected void button1_Click(object sender, EventArgs e)
    {
        if (textbox1.Text.Equals(String.Empty) || textbox2.Text.Equals(String.Empty))
        {
            Label1.Text = "评论内容与验证码不能为空";
            return;
        }
        try
        {
            if (!Request.Cookies["ValiCode"].Value.ToString().Equals(textbox2.Text))
            {
                Label1.Text = "验证码错误";
                return;
            }
            Table_DocumentComment comment = new Table_DocumentComment();
            comment.AccountName = Session["name"].ToString();
            comment.AccountType = Session["type"].ToString();
            comment.Comment = textbox1.Text;
            comment.Date = DateTime.Now;
            comment.DocumentId = (Int32)Session["document"];
            DataClassesDataContext data = new DataClassesDataContext();
            data.Table_DocumentComment.InsertOnSubmit(comment);
            data.SubmitChanges();
            comments.Add(comment);
            textbox1.Text = String.Empty;
            textbox2.Text = String.Empty;
            Label1.Text = String.Empty;

        }
        catch (Exception) { }
    }

 public static void Insert(Student_Registration_Form studentToAdd)
     //used by that add student form to add a new record to the db
 {
     var db = new DataClassesDataContext();
     db.Student_Registration_Forms.InsertOnSubmit(studentToAdd);
     db.SubmitChanges();
 }

    public void DeletePerson(string personId)
    {
        WebOperationContext ctx = WebOperationContext.Current;

        try
        {
            using (var dataContext = new DataClassesDataContext())
            {
                Person person = dataContext.Persons.SingleOrDefault(p => p.PersonId == Convert.ToInt32(personId));
                if (person == null)
                {
                    ctx.OutgoingResponse.StatusCode = System.Net.HttpStatusCode.NotFound;
                    return;
                }

                dataContext.Persons.DeleteOnSubmit(person);
                dataContext.SubmitChanges();

                ctx.OutgoingResponse.StatusCode = System.Net.HttpStatusCode.OK;
                return;
            }
        }
        catch
        {
            ctx.OutgoingResponse.StatusCode = System.Net.HttpStatusCode.BadRequest;
            return;
        }
    }

 //��Ӵ�
 public bool AddAnswer(List<Answer> answer)
 {
     DataClassesDataContext da = new DataClassesDataContext();
     da.Answer.InsertAllOnSubmit(answer);
     da.SubmitChanges();
     return true;
 }

        public ActionResult Index(string username, string password)
        {
            DataClassesDataContext db = new DataClassesDataContext();
            if (string.IsNullOrWhiteSpace(username) || string.IsNullOrWhiteSpace(password))
            {
                return View();
            }

            if (db.Users.Where(u => u.nick == username).Count() < 1)
            {
                db.Users.InsertOnSubmit(new User { nick = username, password = password });
                db.SubmitChanges();
            }

            if (db.Users.Where(u => u.nick == username && u.password == password).Count() > 0)
            {
                Session["login"] = true;
                Session["nick"] = username;
                Session["userid"] = db.Users.Where(u => u.nick == username).First().id;
                Session["type"] = db.Users.Where(u => u.nick == username).First().type;

                return RedirectToAction("Index", "Chat");
            }
            else
            {
                ViewBag.ErrorMessage = "Nicket er ikke tilgjengelig!";
                return View();
            }
        }

    //***************************** MÉTODO INSERTAR ******************************
    protected void btn_Solicitar_Click(object sender, EventArgs e)
    {
        DataClassesDataContext scc = new DataClassesDataContext();

        solicitud obj_Solicitud = new solicitud();

        try
        {
            //Validacion
            cleanMsgTxt();

            if (validaForm() == 0)
            {
                obj_Solicitud.idCliente = Convert.ToInt32(idCliente);
                obj_Solicitud.cSolicitada = Convert.ToInt32(txt_cSolicitada.Text.Trim());
                obj_Solicitud.idModalidad = Convert.ToByte(txt_modalidad.SelectedValue);
                //obj_Cliente.fechaNac = txt_fn.SelectedDate.ToShortDateString(
                obj_Solicitud.fechaInicio = txt_fInicio.SelectedDate.ToShortDateString();
                obj_Solicitud.fechaFin = txt_fFin.SelectedDate.ToShortDateString();
                obj_Solicitud.ingresoMensual = Convert.ToDecimal(txt_ingresoMe.Text.Trim());
                obj_Solicitud.gastoMensual = Convert.ToDecimal(txt_gastoMens.Text.Trim());
                obj_Solicitud.descripcionCredito = txt_desc.Text.Trim();
                obj_Solicitud.descripcionGarantias = txt_garantias.Text.Trim();
                obj_Solicitud.montoValuado =  Convert.ToDecimal(txt_montoVa.Text.Trim());

                if (Convert.ToDecimal(txt_ingresoMe.Text.Trim()) > Convert.ToDecimal(txt_gastoMens.Text.Trim())
                    & Convert.ToDecimal(txt_montoVa.Text.Trim()) / 3 >= Convert.ToInt32(txt_cSolicitada.Text.Trim()))
                {
                    decimal monto=0;
                    monto=Convert.ToDecimal(txt_montoVa.Text.Trim()) /3;

                    obj_Solicitud.creditoMaximo = monto;

                    obj_Solicitud.estatus = "Aceptado";
                }
                else {

                    decimal monto = 0;
                    monto = Convert.ToDecimal(txt_montoVa.Text.Trim()) / 3;

                    obj_Solicitud.creditoMaximo = monto;
                    obj_Solicitud.estatus = "Rechazado";
                }

                scc.solicitud.InsertOnSubmit(obj_Solicitud); //uso del metodo

                scc.SubmitChanges(); //cambioss

                lbl_Mensaje.Text = "Su solicitud ha sido registrada";

            }

        }
        catch (Exception ex)
        {
            lbl_Mensaje.Text = "ERROR - " + ex.Message.ToString();

        }
    }

 public bool create(Assignment thisAssignment)
 {
     // ������ҵ
     DataClassesDataContext da = new DataClassesDataContext();
     da.Assignment.InsertOnSubmit(thisAssignment);
     da.SubmitChanges();
     return true;
 }

 protected void Button1_Click(object sender, EventArgs e)
 {
     DataClassesDataContext db = new DataClassesDataContext();
     Product product = db.Products.SingleOrDefault(p => p.ProductID == 16);
     product.UnitPrice = product.UnitPrice + 2;
     product.UnitsInStock = 70;
     db.SubmitChanges();
     DisplayData();
 }

 protected void btnDelete_Click(object sender, EventArgs e)
 {
     using (var obj = new DataClassesDataContext())
     {
         var tbl = obj.tblLinqSamples.Single(a => a.Id == Convert.ToInt64(txtId.Text));
         obj.tblLinqSamples.DeleteOnSubmit(tbl);
         obj.SubmitChanges();
     }
 }

 protected void Button2_Click(object sender, EventArgs e)
 {
     DataClassesDataContext data = new DataClassesDataContext();
     var q = from s in data.Table_Document
             where s.Id == (Int32)Session["document"]
             select s;
     data.Table_Document.DeleteAllOnSubmit(q);
     data.SubmitChanges();
     Response.Redirect("Document.aspx");
 }

    public void SetRead(bool state)
    {
        DataClassesDataContext dbo = new DataClassesDataContext();

        var temp = dbo.Messages.Single(m => m.ID == this.ID);

        temp.Read = true;

        dbo.SubmitChanges();
    }

    protected void Button1_Click(object sender, EventArgs e)
    {
        DataClassesDataContext context = new DataClassesDataContext();
        dynamic b = new dynamic();
        var query = (from p in context.dynamics where p.name == DropDownList1.SelectedValue select p).Single();

        query.description = FreeTextBox1.Text;

        context.SubmitChanges();
    }