addruku.aspx.cs

来自「仓库管理系统源码」· CS 代码 · 共 89 行

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class Addruku : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (kong())
        {
            //定义变量
            string aa, bb, cc, dd, ee, ff, gg, hh, ii;
            //aa = this.TextBox1.Text;//riqi
            aa =DateTime.Now.ToString("yyyy-MM-dd");
            bb = this.TextBox2.Text;//danhao
            cc = this.TextBox3.Text;//mingcheng
            dd = this.TextBox4.Text;//shuliang
            ee = this.TextBox5.Text;//jinhuojia
            ff = this.TextBox6.Text;//zonge
            gg = this.TextBox7.Text;//beizhu
            hh = this.DropDownList1.Text;
            ii = this.DropDownList2.Text;

            SqlConnection scon = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
            scon.Open();
            SqlCommand scmd = new SqlCommand("insert into ruku(rukuDate,rukuBianma,huoName,shuliang,jinjia,zhonge,beizhu,ghdw,jingbanren) values ('" + aa + "','" + bb + "','" + cc + "','" + dd + "','" + ee + "','" + ff + "','" + gg + "','" + hh + "','" + ii + "')", scon);
            scmd.ExecuteNonQuery();
            scmd.Dispose();
            scon.Close();
            Response.Write("<script language='javascript'>alert('添加成功！');</script>");
            Server.Transfer("rukujetj.aspx");
        }
    }
    private bool kong()
    {
            if (this.TextBox2.Text == "")
            {
                Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
                return false;
            }
            else
            {
                if (this.TextBox3.Text == "")
                {
                    Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
                    return false;
                }

                else
                {
                    if (this.TextBox5.Text == "")
                    {
                        Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
                        return false;
                    }
                    else
                    {
                        if (this.TextBox6.Text == "")
                        {
                            Response.Write("<script language='javascript'>alert('其他不能为空！');</script>");
                            return false;
                        }
                       
                            else
                            {
                               return true;
                            }
                }
            }
        }
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Server.Transfer("rukujetj.aspx");
    }
}