addarea.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>
/// addarea 的摘要说明
/// </summary>
public class addarea
{
    public void add(string strname,string strfzr,string strinfo)//添加区域
    {

        SqlConnection con = new SqlConnection();
        con.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
        con.Open();
        SqlCommand cmd = new SqlCommand("addarea",con);
        cmd.CommandType = CommandType.StoredProcedure;

        SqlParameter paraname = new SqlParameter("@area_name",SqlDbType.NVarChar,50);
        paraname.Value = strname;
        cmd.Parameters.Add(paraname);

        SqlParameter parafzr = new SqlParameter("@area_FZR", SqlDbType.NVarChar, 50);
        parafzr.Value = strfzr;
        cmd.Parameters.Add(parafzr);

        SqlParameter parainfo = new SqlParameter("@area_info", SqlDbType.NVarChar, 200);
        parainfo.Value = strinfo;
        cmd.Parameters.Add(parainfo);

        SqlParameter paratime = new SqlParameter("@area_time", SqlDbType.NVarChar, 50);
        DateTime Mydatetime = DateTime.Now;
        string format = "yyyy-MM-dd"; 
        string strdate = Mydatetime.ToString(format);
        paratime.Value = strdate;
        cmd.Parameters.Add(paratime);
           cmd.ExecuteNonQuery();
        con.Close();
        con.Dispose();
       }
    public SqlDataReader bindarea()
    {
        SqlConnection con = new SqlConnection();
        con.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
        con.Open();
        SqlCommand cmd = new SqlCommand("select area_name from area", con);
        SqlDataReader dr = cmd.ExecuteReader();
        return dr;
        con.Dispose();
     }
    public void deletearea(string strname)
    {
        SqlConnection con = new SqlConnection();
        con.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"];
        con.Open();
        SqlCommand cmd = new SqlCommand("delete area where area_name='" + strname + "'",con);
        cmd.ExecuteNonQuery();
        con.Close();
        con.Dispose();
     }
}