前台用户点击增加按钮增加输入行控件,然后保存(惊险经历)
来源:互联网 发布:mac svn客户端 version 编辑:程序博客网 时间:2024/05/17 21:12
<%@ Page Inherits="www.MyCodeBehind" Src="add_hang6.cs" %>
<html>
<head>
<title>新增</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<meta name="title" content="" />
<meta name="author" content="活靶子,Huobazi,www.AspxBoy.com" />
<meta name="subject" content="" />
<meta name="language" content="gb2312" />
<meta name="keywords" content="" />
<meta name="Copyright" content="www.AspxBoy.com" />
<meta name="robots" content="all" />
<script language="javascript" src="../js/JScript.js"></script>
<script language="javascript" src="../js/calendar.js"></script>
<script language="JavaScript" src="../js/date.js" type="text/JavaScript"></script>
</head>
<link rel="stylesheet" href="../images/style.css" type="text/css">
<body topmargin=0 leftmargin=0 bgcolor=cccccc>
<form id="frm" method="post" runat="server">
<table width="100%" border="0" cellspacing="0" cellpadding=0>
<tr><td colspan=4 bgcolor=#ffffff><img src="../images/top.gif"></td></tr>
</table>
<table width="100%" border="0" bgcolor="#CCCCCC" cellspacing="1" cellpadding=1 align="center">
<tr><td>
<asp:textbox id="Num" width=0 value="0" runat="server"/>
<asp:textbox id="Num0" width=0 value="0" runat="server"/>
<asp:button id="btn" runat="server" Text="ADD" height=24 onclick="Button_ServerClick" />
<asp:Button id="Button1" runat="server" height=24 Text="確定"></asp:Button>
</td></tr>
</table>
<table><tr>
<td width=880 height=1 bgcolor=#ffffff> </td>
</tr></table>
<table><tr>
<td width=30> </td>
<td width=80>砧板編號</td>
<td width=80>客戶</td>
<td width=80>P/O編號</td>
<td width=80>訂單號碼</td>
<td width=80>入倉數量</td>
<td width=80>起始箱號</td>
<td width=80>結尾箱號</td>
<td width=80>款式號碼</td>
<td width=80>港口名稱</td>
<td width=80>進倉時間</td>
</tr></table>
<asp:panel id="Panel1" runat="server">
</asp:panel>
</form>
</body>
</html>
------------------------------------------------
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Configuration;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.IO;
namespace www
{
/// <summary>
/// WebForm1 的摘要说明。
/// </summary>
public class MyCodeBehind : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DropDownList DropDownList1;
protected System.Web.UI.WebControls.DropDownList DropDownList2;
protected System.Web.UI.WebControls.DropDownList DropDownList3;
protected System.Web.UI.WebControls.DropDownList DropDownList4;
protected System.Web.UI.WebControls.TextBox TextBox1,TextBox2,TextBox3,TextBox4,TextBox5,TextBox6,TextBox7,TextBox8,TextBox9,TextBox10,TextBox11,TextBox12,TextBox13,TextBox14,TextBox15,TextBox16,TextBox17,TextBox18,TextBox19,TextBox20,TextBox21,TextBox22,TextBox23,TextBox24,TextBox25,TextBox26,TextBox27,TextBox28,TextBox29,TextBox30,TextBox31,TextBox32,TextBox33,TextBox34,TextBox35,TextBox36,TextBox37,TextBox38,TextBox39,TextBox40,TextBox41,TextBox42,TextBox43,TextBox44,TextBox45,TextBox46,TextBox47,TextBox48,TextBox49,TextBox50,TextBox51,TextBox52,TextBox53,TextBox54,TextBox55,TextBox56,TextBox57,TextBox58,TextBox59,TextBox60,TextBox61,TextBox62,TextBox63,TextBox64,TextBox65,TextBox66,TextBox67,TextBox68,TextBox69,TextBox70,TextBox71,TextBox72,TextBox73,TextBox74,TextBox75,TextBox76,TextBox77,TextBox78,TextBox79,TextBox80,TextBox81,TextBox82,TextBox83,TextBox84,TextBox85,TextBox86,TextBox87,TextBox88,TextBox89,TextBox90,TextBox91,TextBox92,TextBox93,TextBox94,TextBox95,TextBox96,TextBox97,TextBox98,TextBox99,TextBox100;
protected System.Web.UI.HtmlControls.HtmlInputHidden hid1,hid11,hid111;
protected System.Web.UI.HtmlControls.HtmlInputHidden hid2,hid22,hid222;
protected System.Web.UI.HtmlControls.HtmlInputHidden hid3,hid33,hid333;
protected System.Web.UI.HtmlControls.HtmlInputHidden hid4,hid44,hid444;
protected System.Web.UI.WebControls.Button Button1,btn;
public System.Web.UI.WebControls.TextBox companyno2,companyname,departmentno,departmentname,warehouseno2,warehousename,blockno,inqty,beginno,endno,orderno,carno,po,itemno,haven,customer,indate,inputdate,departmentname2;
int countTextBox=0;
int Num2=0;
int Num3=0;
protected System.Web.UI.WebControls.TextBox Num,Num0;
static Table t = new Table();
protected Panel Panel1;
public System.Web.UI.HtmlControls.HtmlInputText departmentname3;
public static string ConnectionString=System.Configuration.ConfigurationSettings.AppSettings["produce1"];
public static DataSet GetDataSet(string sql)
{
SqlDataAdapter sda =new SqlDataAdapter(sql,ConnectionString);
DataSet ds=new DataSet();
sda.Fill(ds);
return ds;
}
private void Page_Load(object sender, System.EventArgs e)
{
try
{
if(Session["popedom2"].ToString()!="2" && Session["popedom2"].ToString()!="3")
{
throw new ArgumentNullException() ;
}
else
{
}
}
catch
{
Response.Write ("<script>window.alert('你沒有權限,按確定返回');window.open('../login_again.aspx','','width=300,height=200')</script>");
Response.End ();
}
if(!this.IsPostBack)
{
ControlCollection c = this.Page.Controls;
for(int i=0;i<c.Count;i++)
{
for(int j=0;j<c[i].Controls.Count;j++)
{
if(c[i].Controls[j] is TextBox)
{
countTextBox=countTextBox; //统计TextBox控件的个数
}
}
}
//Num.Text=countTextBox.ToString();
Page.DataBind();
}
DataBind();
}
public void Button_ServerClick(object sender, System.EventArgs e)
{
TableRow tr = new TableRow();
TextBox TextBox;
TableCell td = new TableCell();
Num3=int.Parse(Num0.Text)+1;
Label label1 = new Label();
label1.Width=30;
label1.Text = Num3.ToString()+"";
td.Controls.Add(label1);
for(int i=1;i<11;i++)
{
Num2=int.Parse(Num.Text)+1;
if(i==10)
{
TextBox = new TextBox();
TextBox.ID = "TextBox" + Num2;
TextBox.Width=107;
TextBox.Attributes.Add("onfocus","calendar()");
//TextBox.Attributes.Add("onpropertychange","if(//D/g.test(value))value=value.replace(//D/g,'');");
td.Controls.Add(TextBox);
tr.Cells.Add(td);
t.Rows.Add(tr);
//frm.Controls.Add(t); //如果写在ASPX里就是这种写法
Panel1.Controls.Add(t); //CS里是这种写法
Num.Text=Num2.ToString();
}
else if(i==9)
{
TextBox = new TextBox();
TextBox.ID = "TextBox" + Num2;
//TextBox.Attributes.Add("Value","0");
//TextBox.Attributes.Add("bgcolor","red");
//TextBox.Attributes.Add("style","font-family:verdana;font-size:8pt;text-align=center;border:1px #DDE3EC solid");
//TextBox.Attributes.Add("Value","<%# DateTime.Now.ToString("yyyy-MM-dd")%>");
//TextBox.Enabled=false;
TextBox.Width=80;
td.Controls.Add(TextBox);
tr.Cells.Add(td);
t.Rows.Add(tr);
Panel1.Controls.Add(t);
Num.Text=Num2.ToString();
}
else
{
TextBox = new TextBox();
TextBox.ID = "TextBox" + Num2;
TextBox.Width=80;
td.Controls.Add(TextBox);
tr.Cells.Add(td);
t.Rows.Add(tr);
Panel1.Controls.Add(t);
Num.Text=Num2.ToString();
}
if(Num3==10)
{
btn.Visible=false;
}
Num0.Text=Num3.ToString();
}
}
override protected void OnInit(EventArgs e)
{
InitializeComponent();
base.OnInit(e);
}
private void InitializeComponent()
{
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
public void Button1_Click(object sender, System.EventArgs e)
{
string sql="";
SqlConnection myConnection0=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["produce1"]);
string sql1="";
string sql2="";
string sql3="";
string sql4="";
string sql5="";
string sql6="";
string sql7="";
string sql8="";
string sql9="";
string sql10="";
if(Request.Form["TextBox1"]!="")
{
sql1="insert into block2(companyname,departmentname,warehousename,blockno,customer,po,orderno,inqty,beginno,endno,itemno,haven,indate,inputdate,inname)values('"+Session["companyname2"].ToString()+"','"+departmentname.Text.ToString()+"','"+warehousename.Text.ToString()+"','"+Request.Form["TextBox1"]+"','"+Request.Form["TextBox2"]+"','"+Request.Form["TextBox3"]+"','"+Request.Form["TextBox4"]+"','"+Request.Form["TextBox5"]+"','"+Request.Form["TextBox6"]+"','"+Request.Form["TextBox7"]+"','"+Request.Form["TextBox8"]+"','"+Request.Form["TextBox9"]+"','"+Request.Form["TextBox10"]+"','"+DateTime.Now.Date.ToShortDateString()+"','"+Session["user_name"].ToString()+"')";
}
if(Request.Form["TextBox11"]!="")
{
sql2="insert into block2(companyname,departmentname,warehousename,blockno,customer,po,orderno,inqty,beginno,endno,itemno,haven,indate,inputdate,inname)values('"+Session["companyname2"].ToString()+"','"+departmentname.Text.ToString()+"','"+warehousename.Text.ToString()+"','"+Request.Form["TextBox11"]+"','"+Request.Form["TextBox12"]+"','"+Request.Form["TextBox13"]+"','"+Request.Form["TextBox14"]+"','"+Request.Form["TextBox15"]+"','"+Request.Form["TextBox16"]+"','"+Request.Form["TextBox17"]+"','"+Request.Form["TextBox18"]+"','"+Request.Form["TextBox19"]+"','"+Request.Form["TextBox20"]+"','"+DateTime.Now.Date.ToShortDateString()+"','"+Session["user_name"].ToString()+"')";
}
if(Request.Form["TextBox21"]!="")
{
sql3="insert into block2(companyname,departmentname,warehousename,blockno,customer,po,orderno,inqty,beginno,endno,itemno,haven,indate,inputdate,inname)values('"+Session["companyname2"].ToString()+"','"+departmentname.Text.ToString()+"','"+warehousename.Text.ToString()+"','"+Request.Form["TextBox21"]+"','"+Request.Form["TextBox22"]+"','"+Request.Form["TextBox23"]+"','"+Request.Form["TextBox24"]+"','"+Request.Form["TextBox25"]+"','"+Request.Form["TextBox26"]+"','"+Request.Form["TextBox27"]+"','"+Request.Form["TextBox28"]+"','"+Request.Form["TextBox29"]+"','"+Request.Form["TextBox30"]+"','"+DateTime.Now.Date.ToShortDateString()+"','"+Session["user_name"].ToString()+"')";
}
if(Request.Form["TextBox31"]!="")
{
sql4="insert into block2(companyname,departmentname,warehousename,blockno,customer,po,orderno,inqty,beginno,endno,itemno,haven,indate,inputdate,inname)values('"+Session["companyname2"].ToString()+"','"+departmentname.Text.ToString()+"','"+warehousename.Text.ToString()+"','"+Request.Form["TextBox31"]+"','"+Request.Form["TextBox32"]+"','"+Request.Form["TextBox33"]+"','"+Request.Form["TextBox34"]+"','"+Request.Form["TextBox35"]+"','"+Request.Form["TextBox36"]+"','"+Request.Form["TextBox37"]+"','"+Request.Form["TextBox38"]+"','"+Request.Form["TextBox39"]+"','"+Request.Form["TextBox40"]+"','"+DateTime.Now.Date.ToShortDateString()+"','"+Session["user_name"].ToString()+"')";
}
if(Request.Form["TextBox41"]!="")
{
sql5="insert into block2(companyname,departmentname,warehousename,blockno,customer,po,orderno,inqty,beginno,endno,itemno,haven,indate,inputdate,inname)values('"+Session["companyname2"].ToString()+"','"+departmentname.Text.ToString()+"','"+warehousename.Text.ToString()+"','"+Request.Form["TextBox41"]+"','"+Request.Form["TextBox42"]+"','"+Request.Form["TextBox43"]+"','"+Request.Form["TextBox44"]+"','"+Request.Form["TextBox45"]+"','"+Request.Form["TextBox46"]+"','"+Request.Form["TextBox47"]+"','"+Request.Form["TextBox48"]+"','"+Request.Form["TextBox49"]+"','"+Request.Form["TextBox50"]+"','"+DateTime.Now.Date.ToShortDateString()+"','"+Session["user_name"].ToString()+"')";
}
if(Request.Form["TextBox51"]!="")
{
sql6="insert into block2(companyname,departmentname,warehousename,blockno,customer,po,orderno,inqty,beginno,endno,itemno,haven,indate,inputdate,inname)values('"+Session["companyname2"].ToString()+"','"+departmentname.Text.ToString()+"','"+warehousename.Text.ToString()+"','"+Request.Form["TextBox51"]+"','"+Request.Form["TextBox52"]+"','"+Request.Form["TextBox53"]+"','"+Request.Form["TextBox54"]+"','"+Request.Form["TextBox55"]+"','"+Request.Form["TextBox56"]+"','"+Request.Form["TextBox57"]+"','"+Request.Form["TextBox58"]+"','"+Request.Form["TextBox59"]+"','"+Request.Form["TextBox60"]+"','"+DateTime.Now.Date.ToShortDateString()+"','"+Session["user_name"].ToString()+"')";
}
if(Request.Form["TextBox61"]!="")
{
sql7="insert into block2(companyname,departmentname,warehousename,blockno,customer,po,orderno,inqty,beginno,endno,itemno,haven,indate,inputdate,inname)values('"+Session["companyname2"].ToString()+"','"+departmentname.Text.ToString()+"','"+warehousename.Text.ToString()+"','"+Request.Form["TextBox61"]+"','"+Request.Form["TextBox62"]+"','"+Request.Form["TextBox63"]+"','"+Request.Form["TextBox64"]+"','"+Request.Form["TextBox65"]+"','"+Request.Form["TextBox66"]+"','"+Request.Form["TextBox67"]+"','"+Request.Form["TextBox68"]+"','"+Request.Form["TextBox69"]+"','"+Request.Form["TextBox70"]+"','"+DateTime.Now.Date.ToShortDateString()+"','"+Session["user_name"].ToString()+"')";
}
if(Request.Form["TextBox71"]!="")
{
sql8="insert into block2(companyname,departmentname,warehousename,blockno,customer,po,orderno,inqty,beginno,endno,itemno,haven,indate,inputdate,inname)values('"+Session["companyname2"].ToString()+"','"+departmentname.Text.ToString()+"','"+warehousename.Text.ToString()+"','"+Request.Form["TextBox71"]+"','"+Request.Form["TextBox72"]+"','"+Request.Form["TextBox73"]+"','"+Request.Form["TextBox74"]+"','"+Request.Form["TextBox75"]+"','"+Request.Form["TextBox76"]+"','"+Request.Form["TextBox77"]+"','"+Request.Form["TextBox78"]+"','"+Request.Form["TextBox79"]+"','"+Request.Form["TextBox80"]+"','"+DateTime.Now.Date.ToShortDateString()+"','"+Session["user_name"].ToString()+"')";
}
if(Request.Form["TextBox81"]!="")
{
sql9="insert into block2(companyname,departmentname,warehousename,blockno,customer,po,orderno,inqty,beginno,endno,itemno,haven,indate,inputdate,inname)values('"+Session["companyname2"].ToString()+"','"+departmentname.Text.ToString()+"','"+warehousename.Text.ToString()+"','"+Request.Form["TextBox81"]+"','"+Request.Form["TextBox82"]+"','"+Request.Form["TextBox83"]+"','"+Request.Form["TextBox84"]+"','"+Request.Form["TextBox85"]+"','"+Request.Form["TextBox86"]+"','"+Request.Form["TextBox87"]+"','"+Request.Form["TextBox88"]+"','"+Request.Form["TextBox89"]+"','"+Request.Form["TextBox90"]+"','"+DateTime.Now.Date.ToShortDateString()+"','"+Session["user_name"].ToString()+"')";
}
if(Request.Form["TextBox91"]!="")
{
sql10="insert into block2(companyname,departmentname,warehousename,blockno,customer,po,orderno,inqty,beginno,endno,itemno,haven,indate,inputdate,inname)values('"+Session["companyname2"].ToString()+"','"+departmentname.Text.ToString()+"','"+warehousename.Text.ToString()+"','"+Request.Form["TextBox91"]+"','"+Request.Form["TextBox92"]+"','"+Request.Form["TextBox93"]+"','"+Request.Form["TextBox94"]+"','"+Request.Form["TextBox95"]+"','"+Request.Form["TextBox96"]+"','"+Request.Form["TextBox97"]+"','"+Request.Form["TextBox98"]+"','"+Request.Form["TextBox99"]+"','"+Request.Form["TextBox100"]+"','"+DateTime.Now.Date.ToShortDateString()+"','"+Session["user_name"].ToString()+"')";
}
string nowDSN=ConfigurationSettings.AppSettings["produce1"];
SqlConnection myConnection=new SqlConnection(nowDSN);
string CommandText;
SqlCommand myCommand = new SqlCommand();
myCommand.Connection=myConnection;
myCommand.Connection.Open();
if(Request.Form["TextBox1"]!="")
{
myCommand.CommandText = sql1;
myCommand.ExecuteNonQuery();
}
if(Request.Form["TextBox2"]!="")
{
myCommand.CommandText = sql2;
myCommand.ExecuteNonQuery();
}
if(Request.Form["TextBox3"]!="")
{
myCommand.CommandText = sql3;
myCommand.ExecuteNonQuery();
}
if(Request.Form["TextBox4"]!="")
{
myCommand.CommandText = sql4;
myCommand.ExecuteNonQuery();
}
if(Request.Form["TextBox5"]!="")
{
myCommand.CommandText = sql5;
myCommand.ExecuteNonQuery();
}
if(Request.Form["TextBox6"]!="")
{
myCommand.CommandText = sql6;
myCommand.ExecuteNonQuery();
}
if(Request.Form["TextBox7"]!="")
{
myCommand.CommandText = sql7;
myCommand.ExecuteNonQuery();
}
if(Request.Form["TextBox8"]!="")
{
myCommand.CommandText = sql8;
myCommand.ExecuteNonQuery();
}
if(Request.Form["TextBox9"]!="")
{
myCommand.CommandText = sql9;
myCommand.ExecuteNonQuery();
}
if(Request.Form["TextBox10"]!="")
{
myCommand.CommandText = sql10;
myCommand.ExecuteNonQuery();
}
myCommand.Connection.Close();
Num0.Text="0";
Num.Text="0";
Response.Write ("<script>window.alert('已成功添加,按“确定”返回');</script>");
Response.Write("<script language='javascript'>window.opener.location.href = window.opener.location.href;</script>");
}
}
}
- 前台用户点击增加按钮增加输入行控件,然后保存(惊险经历)
- js实现按钮点击增加输入框
- 增加前台控件属性
- 点击增加输入框
- 点击按钮增加数据框(二级输入目录)
- android_button点击增加顺序增加按钮
- 用户控件增加事件
- div点击按钮增加一行
- 网页中点击增加按钮
- javascript点击按钮,增加文本框
- javascript 点击按钮 增加一个按钮
- javascript点击按钮,增加文本框和按钮
- 点击dataview组件下的一行,然后在点击的那行下增加一个表
- iOS 点击按钮增加加载中视图
- JS点击按钮自动增加一行
- jQuery 点击按钮,表格增加一行。
- 点击增加输入框,可删除,类似投票选项增加
- 新建 ProvinceCity用户控件。在该控件 中增加一个Button1按钮
- Tomcat配置经验谈
- Windows Vista User Account Control (UAC) 全新安全模块“用户帐户控制”
- 中国外包开发成功与失败的“实态”
- 学生笔记(Oracle第二章)
- 从MySQL导入导出大量数据的程序实现方法
- 前台用户点击增加按钮增加输入行控件,然后保存(惊险经历)
- 为什么外包预算报价会高
- 点击按钮后出现新的输入画面,否则隐藏
- Java WEB 应用字符编码解决方案
- 编程的另一面:从生死到变化~
- Google 桌面搜索的使用
- Asp.net Web控件失效
- NET树(dropdownlist 选择弹出另一页面)
- SQL Server数据库里的Management里的SQL Server Agent里的Jobs是个定时运行功能(死亡;历险)