inputhuo.aspx.cs

asp.net 的某物流管理系统 MIS 系统

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.OleDb;

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

    }
    //保存货物信息
    private void Saveinfo(string sHuohao, string sHuoming, int nJianshu, string sZhongliang,
        string sDaozhan, decimal dYune, decimal dDianfu, string sFushi, string sLianren, string sLianhua,
        string sLianzhi, string sBeizhu)
    {
        string myConnectionString = ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING1"].ConnectionString + Server.MapPath("~") + ConfigurationManager.ConnectionStrings["OLEDBCONNECTIONSTRING2"].ConnectionString;
        OleDbConnection myConnection = new OleDbConnection(myConnectionString);
        string cmdText = "INSERT INTO Huowu(Huohao,Huoming,Jianshu,Zhongliang,Daozhan,Yune,Dianfu,Fushi,Lianren,Lianhua,Lianzhi,Beizhu,Createdate)VALUES('" +
            sHuohao + "','" +
            sHuoming + "'," +
            nJianshu + ",'" +
            sZhongliang + "','" +
            sDaozhan + "'," +
            dYune + "," +
            dDianfu + ",'" +
            sFushi + "','" +
            sLianren + "','" +
            sLianhua + "','" +
            sLianzhi + "','" +
            sBeizhu + "',now())";
        OleDbCommand myCommand = new OleDbCommand(cmdText, myConnection);
        try
        {
            myConnection.Open();
            myCommand.ExecuteNonQuery();
        }
        catch (OleDbException ex)
        {
            throw new Exception(ex.Message, ex);
        }
        finally
        {
            myConnection.Close();
        }

    }
    //清空
    private void Clearstr()
    {
        txtbeizhu.Text = "";
        txtdaozhan.Text = "";
        txtdianfu.Text = "";
        txtfushi.Text = "";
        txthuohao.Text = "";
        txthuoming.Text = "";
        txtjianshu.Text = "";
        txtlianhua.Text = "";
        txtlianren.Text = "";
        txtlianzhi.Text = "";
        txtyune.Text = "";
        txtzhongliang.Text = "";
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        Response.Write("<Script>window.close()</Script>");
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        if (txtyune.Text.Trim().Length < 1) txtyune.Text = "0";
        if (txtdianfu.Text.Trim().Length < 1) txtdianfu.Text = "0";
        string huohao = txthuohao.Text.ToString().Trim();
        string huoming = txthuoming.Text.ToString().Trim();
        int jianshu = Int32.Parse(txtjianshu.Text.ToString().Trim());
        string zhongliang = txtzhongliang.Text.ToString().Trim();
        string daozhan = txtdaozhan.Text.ToString().Trim();
        decimal yune = Convert.ToDecimal(txtyune.Text.ToString().Trim());
        decimal dianfu =Convert.ToDecimal(txtdianfu.Text.ToString().Trim());
        string fushi = txtfushi.Text.ToString().Trim();
        string lianren = txtlianren.Text.ToString().Trim();
        string lianhua = txtlianhua.Text.ToString().Trim();
        string lianzhi = txtlianzhi.Text.ToString().Trim();
        string beizhu = txtbeizhu.Text.ToString().Trim();
        if (huohao.Length < 1)
        {
            Response.Write("<Script>alert('货号不为空!')</Script>");
            return;
        }
        Saveinfo(huohao, huoming, jianshu, zhongliang, daozhan, yune, dianfu, fushi, lianren, lianhua, lianzhi, beizhu);
        Response.Write("<Script>alert('添加成功!')</Script>");
        Clearstr();
    }
}