protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e)
 {
     if (e.CommandName == "bbb")
     {
         tServicesPic ga = db.tServicesPic.FirstOrDefault(t => t.fIdServicesPic == Convert.ToInt32(Label1.Text));
         if (ga != null)
         {
             ga.fIdPhoto = Convert.ToInt32((e.Item.FindControl("Label2") as Label).Text);
         }
         db.SubmitChanges();
         Label4.Text = "更換封面成功";
     }
 }
Esempio n. 2
0
    protected void Button2_Click(object sender, EventArgs e)
    {
        // Textarea.Value.Replace("\r\n", "<br/>");
        // TextBox2.Text = TextBox2.Text.Replace("\r\n", "<br/>");
        var newServices = new tServices
        {
            fIdStores           = id,
            fUploadTime         = DateTime.Now,
            fIdSubServicesClass = Convert.ToInt32(Dw2.SelectedItem.Value),
            fName        = TextBox1.Text,
            fMaxMoney    = Convert.ToInt32(tbMax.Text),
            fDescription = TextBox2.Text,
            fContent     = Textarea.Value
        };

        db.tServices.InsertOnSubmit(newServices);
        db.SubmitChanges();

        var last = (from ser in db.tServices
                    where ser.fIdStores == id
                    orderby ser.fIdServices descending
                    select new {
            la = ser.fIdServices
        }).Take(1);

        foreach (var l in last)
        {
            lastser = l.la;
        }
        var newServicesPic = new tServicesPic
        {
            fIdPhoto    = 1,
            fIdServices = lastser
        };

        db.tServicesPic.InsertOnSubmit(newServicesPic);
        db.SubmitChanges();



        TextBox1.Text      = "";
        TextBox2.Text      = "";
        tbMax.Text         = "";
        Textarea.InnerText = "";
        lblMsg.Visible     = true;
    }