111111111111
using System;
using System.Data.SqlClient;
using System.Data;
using System.Data.OleDb;
using System.IO;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
namespace www
{
public class MyCodeBehind : Page
{
public System.Web.UI.WebControls.TextBox kehu;
public System.Web.UI.WebControls.TextBox zhidanhao;
public System.Web.UI.WebControls.TextBox caigoudanhao;
public System.Web.UI.WebControls.TextBox gongyingshang;
public System.Web.UI.WebControls.Label Label1;
public System.Web.UI.WebControls.Label Span1;
public HtmlInputFile File1;
public HtmlInputButton Button1;
public String qa_id;
public DataRow dr;
public TextBox TextBox3;
public TextBox TextBox4;
void Page_Load(Object sender, EventArgs e)
{
if(!IsPostBack)
{
name1.Text=Session["uid"].ToString();
qa_id = Request.Params["id"];
Page.DataBind();
}
}
public void Button1_Click(Object Source, EventArgs e)
{
if ((kehu.Text=="")||(zhidanhao.Text=="")||(caigoudanhao.Text==""))
{
Label1.Text="批量、样本等不能为空！";
}
else if((gongyingshang.Text=="")||(dingdan_name.Text=="")||(piliang_num.Text==""))
{
Label1.Text="允收MI，实际MA，实际MI等不能为空";
}
else if (piliang_num.Text.Length>50)
{
Label1.Text="批量太大！";
}
else
{
OleDbConnection myConnection = new OleDbConnection("provider=sqloledb.1;datasource=(local);uid=sa;pwd=123456;initial catalog=pubs");
OleDbCommand myCommand = new OleDbCommand(CommandText,myConnection);
myCommand.CommandText = "insert into qa(kehu,zhidanhao,caigoudanhao,gongyingshang,dingdan_name,piliang_num,yangben_num,MA11,MI11,MA22,MI22,caizhi,tanxing,guige,zhanxing,yanse,duma,waiguan,yinshua,yingdu,qita)values('" + kehu.Text.ToString() + "', '" + zhidanhao.Text.ToString() + "','" + caigoudanhao.Text.ToString() + "','" + gongyingshang.Text.ToString() + "', '" + dingdan_name.Text.ToString() + "', piliang_num.Text.ToString() , yangben_num.Text.ToString(), '"+MA11.Text.ToString()+"' , '"+MI11.Text.ToString()+"' , '"+MA22.Text.ToString()+"' , '"+MI22.Text.ToString()+"' ,'" + Request["caizhi"] + "','" + Request["tanxing"] + "', '" + Request["guige"] + "','" + Request["zhanxing"] + "','" + Request["yanse"] + "','" + Request["duma"] + "','" + Request["waiguan"] + "','" + Request["yinshua"] + "', '" + Request["yingdu"] + "','" + Request["qita"] + "')";
myCommand.CommandText = "insert into qa(buliang1,buliang2,buliang3,buliang4,buliang5,buliang6,bulianglv1,bulianglv2,bulianglv3,bulianglv4,bulianglv5,Ma1,Ma2,Ma3,Ma4,Ma5,Ma6,Mi1,Mi2,Mi3,Mi4,Mi5,Mi6,ceshi_id,chouyan_id)values('" + buliang1.Text.ToString() + "', '" + buliang2.Text.ToString() + "','" + buliang3.Text.ToString() + "','" + buliang4.Text.ToString() + "','" + buliang5.Text.ToString() + "','" + buliang6.Text.ToString() + "','"+bulianglv1.Text.ToString() + "', '" + bulianglv2.Text.ToString() + "','" + bulianglv3.Text.ToString() + "','" + bulianglv4.Text.ToString() + "','" + bulianglv5.Text.ToString() + "',Ma1.Text.ToString() , Ma2.Text.ToString(), Ma3.Text.ToString(), Ma4.Text.ToString() ,Ma5.Text.ToString(),Ma6.Text.ToString() ,Mi1.Text.ToString(), Mi2.Text.ToString() , Mi3.Text.ToString() ,Mi4.Text.ToString() ,Mi5.Text.ToString() , Mi6.Text.ToString() ,'"+ ceshi_id.Text.ToString() + "','" + chouyan_id.Text.ToString() + "')";
myCommand.CommandText = "insert into qa(ceshi1,ceshi2,ceshi3,ceshi4,ceshi5,ceshi6,ceshi7,ceshi8,ceshi9,ceshi10,ceshi11,chouyang1,chouyang2,chouyang3,chouyang4,chouyang5,chouyang6,chouyang7,chouyang8,chouyang9,chouyang10,chouyang11)values('" + Request["ceshi1"] + "','" + Request["ceshi2"] + "','" + Request["ceshi3"] + "','" + Request["ceshi4"] + "','" + Request["ceshi5"] + "','" + Request["ceshi6"] + "','" + Request["ceshi7"] + "','" + Request["ceshi8"] + "','" + Request["ceshi9"] + "','" + Request["ceshi10"] + "','" + Request["ceshi11"] + "','" + chouyang1.Text.ToString() + "','" + chouyang2.Text.ToString() + "','" + chouyang3.Text.ToString() + "','" + chouyang4.Text.ToString() + "','" + chouyang5.Text.ToString() + "','" + chouyang6.Text.ToString() + "','" + chouyang7.Text.ToString() + "','" + chouyang8.Text.ToString() + "','" + chouyang9.Text.ToString() + "','" + chouyang10.Text.ToString() + "','" + chouyang11.Text.ToString() + "')";
myCommand.CommandText = "insert into qa(jianyan1,jianyan2,jianyan3,jianyan4,jianyan5,jianyan6,jianyan7,jianyan8,jianyan9,jianyan10,jianyan11,memo1,memo2,memo3,memo4,memo5,memo6,memo7,memo8,memo9,memo10,memo11,jieguo,name1,name2,time1,time2)values('"+Request["jianyan1"]+"','"+Request["jianyan2"]+"',,'"+Request["jianyan3"]+"',,'"+Request["jianyan4"]+"',,'"+Request["jianyan5"]+"',,'"+Request["jianyan6"]+"',,'"+Request["jianyan7"]+"',,'"+Request["jianyan8"]+"',,'"+Request["jianyan9"]+"',,'"+Request["jianyan10"]+"',,'"+Request["jianyan11"]+"','"+memo1.Text.ToString()+"','"+memo2.Text.ToString()+"',,'"+memo3.Text.ToString()+"',,'"+memo4.Text.ToString()+"',,'"+memo5.Text.ToString()+"',,'"+memo6.Text.ToString()+"',,'"+memo7.Text.ToString()+"',,'"+memo8.Text.ToString()+"',,'"+memo9.Text.ToString()+"',,'"+memo10.Text.ToString()+"',,'"+memo11.Text.ToString()+"','"+Request["jieguo"]+"','"+name1.Text.ToString()+"','"+name2.Text.ToString()+"','"+time1.Text.ToString()+"','"+time2.Text.ToString()+"')";
myCommand.Connection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close();
Response.Redirect("kkk.aspx") ;
}
}
public void reset_Click(Object sender,EventArgs e)
{
piliang_num.Text="";
}
}
}
问题点数：0、回复次数：1Top
1 楼hedonister（冰戈）回复于 2005-03-04 19:32:44 得分 0
?Top
