Ejemplo n.º 1
0
 public int Post(orderform model)
 {
     using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["Sqlconn"].ToString()))
     {
         return(conn.Execute($"update orderform set orderform.OF_site='{model.OF_site}' where OF_Id={model.OF_Id}"));
     }
 }
Ejemplo n.º 2
0
 public int Post(orderform model)
 {
     using (SqlConnection conn = new SqlConnection(Mysql))
     {
         return(conn.Execute($"update orderform set orderform.OF_status='{model.OF_status}' where OF_Id={model.OF_Id}"));
     }
 }
Ejemplo n.º 3
0
    protected void Button3_Click(object sender, EventArgs e)
    {
        if (TextBox2.Text.Length != 0)
        {
            Session["memberid"] = TextBox2.Text.ToString();
        }
        else
        {
            Session["memberid"] = "00000";
        }

        int flag = 0;

        for (int i = 0; i < GridView1.Rows.Count; i++)
        {
            CheckBox cbox = (CheckBox)GridView1.Rows[i].FindControl("CheckBox1");
            if (cbox.Checked == true)
            {
                flag++;
                //Response.Write(GridView1.DataKeys[i].Value.ToString());
                //TextBox2.Text += GridView1.DataKeys[i].Value.ToString();

                DataClassesDataContext data = new DataClassesDataContext("Data Source=.;Initial Catalog=DSMS;Integrated Security=True");
                ///////////////////////////////////////////////
                var exist =
                    from orderform1 in data.orderform
                    where orderform1.orderformid == Session["orderformid"].ToString()
                    select orderform1;
                if (flag == 1 && exist.Count() == 0)
                {
                    orderform form = new orderform();
                    form.orderformid = Session["orderformid"].ToString();
                    form.stuffid     = Session["stuffid"].ToString();
                    form.drugstoreid = Session["drugstoreid"].ToString();
                    if (TextBox2.Text.Length != 0)
                    {
                        form.memberid = TextBox2.Text.ToString();
                    }
                    else
                    {
                        form.memberid = "00000";
                    }
                    form.saletime   = DateTime.Now;
                    form.totalmoney = 0;
                    data.orderform.InsertOnSubmit(form);
                    data.SubmitChanges();
                }

                /////////////////////////////////////////
                orderDetails de = new orderDetails();
                de.datailid = Session["detailid"].ToString();
                //de.datailid = "111";
                // de.orderformid = Session["orderformid"].ToString();
                de.orderformid = Session["orderformid"].ToString();
                de.drugid      = GridView1.DataKeys[i].Value.ToString();
                de.discount    = 1;
                de.drugnumber  = 1;
                data.orderDetails.InsertOnSubmit(de);
                data.SubmitChanges();
            }
        }
        Response.Redirect("OrderDetails.aspx");
    }