loaddata.cs

一个较小的采购系统,一些比较实际的代码,可以用来参考

using System;
using System.Data;
using System.Configuration;
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;


/// <summary>
/// loaddata 的摘要说明
/// </summary>
public class loaddata
{
	public void insert(string strleibie,string strpinmin,string strgg,string stradd,string strsession)
	{
        //初始化表中的数据，对数据表插入相关数据
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
        conn.Open();
        SqlCommand cmd = new SqlCommand("loadinsert",conn);
        cmd.CommandType = CommandType.StoredProcedure;

        SqlParameter paraleibie = new SqlParameter("@load_leibie",SqlDbType.NVarChar,50);
        paraleibie.Value = strleibie;
        cmd.Parameters.Add(paraleibie);

        SqlParameter parapinmin = new SqlParameter("@load_pinmin", SqlDbType.NVarChar, 50);
        parapinmin.Value = strpinmin;
        cmd.Parameters.Add(parapinmin);

        SqlParameter paragg = new SqlParameter("@load_guige", SqlDbType.NVarChar, 50);
        paragg.Value = strgg;
        cmd.Parameters.Add(paragg);

        SqlParameter paraadd = new SqlParameter("@load_address", SqlDbType.NVarChar, 50);
        paraadd.Value = stradd;
        cmd.Parameters.Add(paraadd);

        SqlParameter parasession = new SqlParameter("@load_session", SqlDbType.NVarChar, 50);
        parasession.Value = strsession;
        cmd.Parameters.Add(parasession);

        cmd.ExecuteNonQuery();
        conn.Close();
        conn.Dispose();
      }
  public void updatetime(string strsession,string strtime)
    {
        //一次性更新use_load表中的到货时间，需要帐号信息
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
        conn.Open();
        SqlCommand cmd = new SqlCommand("updatetime", conn);
        cmd.CommandType = CommandType.StoredProcedure;

        SqlParameter parasession = new SqlParameter("@load_session", SqlDbType.NVarChar, 50);
        parasession.Value = strsession;
        cmd.Parameters.Add(parasession);

        SqlParameter paratime = new SqlParameter("@load_date", SqlDbType.NVarChar, 50);
        paratime.Value = strtime;
        cmd.Parameters.Add(paratime);

        cmd.ExecuteNonQuery();
        conn.Close();
        conn.Dispose();
    }
    public DataSet getload(string strsession)
    {
        //获得use_load中的数据,绑定到batches.aspx页面上的GridView中
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
        SqlCommand cmd = new SqlCommand("getload", conn);
        cmd.CommandType = CommandType.StoredProcedure;
        SqlParameter parasession = new SqlParameter("@load_session", SqlDbType.NVarChar, 50) ;
        parasession.Value = strsession;
        cmd.Parameters.Add(parasession);

        DataSet ds = new DataSet();
        SqlDataAdapter adpt = new SqlDataAdapter(cmd);
        adpt.Fill(ds,"use_load");
        conn.Dispose();
        return ds;
    }
    public void copy()
    {
        //把use_load表中的数据插入到cooktb表中，完成批量送签
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
        conn.Open();
        SqlCommand cmd = new SqlCommand("copyload", conn);
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.ExecuteNonQuery();
        conn.Close();
        conn.Dispose();
    }
}