protected void btnPublic_Click1(object sender, EventArgs e) { string phonename = txtphonename.Text.ToString(); string uname = Session["name"].ToString(); select_id_viewTableAdapter selid = new select_id_viewTableAdapter(); DataTable dtid = selid.selectidbyuname(uname); string owner = dtid.Rows[0][0].ToString(); Guid sellerid = new Guid(); sellerid = Guid.Parse(owner); string shopname = dtid.Rows[0][1].ToString(); string brand = ddlbrand.SelectedItem.Text; string version = ddlversion.SelectedItem.Text; string color = ddlcolor.SelectedItem.Text; string priceint = ddlpriceinterval.SelectedItem.Text; string[] sArray = priceint.Split('-'); string str1 = sArray[0].ToString().Trim(); string str2 = sArray[1].ToString().Trim(); int low = Convert.ToInt32(str1.ToString()); int high = Convert.ToInt32(str2.ToString()); string os = ddlos.SelectedItem.Text; string cpu = ddlcpu.SelectedItem.Text; string type = ddltype.SelectedItem.Text; string piexl = ddlpixel.SelectedItem.Text; string screen = ddlscreensize.SelectedItem.Text; int quantity = Convert.ToInt32(txtquantity.Text); int price = Convert.ToInt32(txtprice.Text); string introduction = txtintroduce.Text; string image = img; DateTime starttime = DateTime.Today; DateTime selltime = DateTime.Today; string state = "1"; if (price > high || price < low) { ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('温馨提示:\\n\\n您输入的商品价格与选择的价格区间不符!\\n请重新选择区间');", true); return; } QueriesTableAdapter insertinfo = new QueriesTableAdapter(); int result = insertinfo.proc_insertphoneinfo(phonename, sellerid, shopname, brand, version, color, low, high, os, cpu, type, piexl, screen, quantity, price, introduction, image, starttime, selltime, state); if (result == -1) { ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('温馨提示:\\n\\n商品插入成功!');", true); } else { ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('温馨提示:\\n\\n商品信息由于一些原因审核失败!');", true); } }
protected void btnPublic_Click1(object sender, EventArgs e) { string phonename = txtphonename.Text.ToString(); string uname = Session["name"].ToString(); select_id_viewTableAdapter selid = new select_id_viewTableAdapter(); DataTable dtid = selid.selectidbyuname(uname); string owner = dtid.Rows[0][0].ToString(); Guid sellerid = new Guid(); sellerid = Guid.Parse(owner); string shopname = dtid.Rows[0][1].ToString(); string brand = ddlbrand.SelectedItem.Text; string version = ddlversion.SelectedItem.Text; string color = ddlcolor.SelectedItem.Text; string priceint = ddlpriceinterval.SelectedItem.Text; string[] sArray = priceint.Split('-'); string str1 = sArray[0].ToString().Trim(); string str2 = sArray[1].ToString().Trim(); int low = Convert.ToInt32(str1.ToString()); int high = Convert.ToInt32(str2.ToString()); string os = ddlos.SelectedItem.Text; string cpu = ddlcpu.SelectedItem.Text; string type = ddltype.SelectedItem.Text; string piexl = ddlpixel.SelectedItem.Text; string screen = ddlscreensize.SelectedItem.Text; int quantity = Convert.ToInt32(txtquantity.Text); int price = Convert.ToInt32(txtprice.Text); string introduction = txtintroduce.Text; string image = img; DateTime starttime = DateTime.Today; DateTime selltime = DateTime.Today; string state = "1"; if (price > high || price < low) { ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('温馨提示:\\n\\n您输入的商品价格与选择的价格区间不符!\\n请重新选择区间');", true); return; } QueriesTableAdapter insertinfo = new QueriesTableAdapter(); int result = insertinfo.proc_insertphoneinfo(phonename,sellerid,shopname,brand,version,color,low,high,os,cpu,type,piexl,screen,quantity,price,introduction,image,starttime,selltime,state); if (result==-1) { ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('温馨提示:\\n\\n商品插入成功!');", true); } else { ScriptManager.RegisterStartupScript(this, GetType(), "", "alert('温馨提示:\\n\\n商品信息由于一些原因审核失败!');", true); } }