databindingtest.cs

课程设计了

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;
/// <summary>
/// DataBind 的摘要说明
/// </summary>
public class DataBindingtest
{
    static public string sqlconn = System.Configuration.ConfigurationManager.AppSettings["sqconnectionstring"];
	public DataBindingtest()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}

    static public ICollection DataBindsear(string sql)
    {

        SqlConnection conn = new SqlConnection(sqlconn);
        conn.Open();
        SqlCommand cmd = new SqlCommand(sql, conn);
        SqlDataAdapter sdr = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();

        sdr.Fill(ds, "databindsear");
        return ds.Tables["databindsear"].DefaultView;
        cmd.Dispose();
        conn.Close();
        conn.Dispose();

    }
  static public   void   dropbind(string sql,DropDownList ddlist,string dutext,string duvalues)
   {



      SqlConnection conn = new SqlConnection(sqlconn);
        conn.Open();
        SqlCommand cmd = new SqlCommand(sql, conn);
        /**/
        /*建立数据适配器、数据表并填充*/
        SqlDataAdapter adpt = new SqlDataAdapter(cmd);
        DataTable dtable = new DataTable();
        adpt.Fill(dtable);


        ddlist.DataSource = dtable;

        ddlist.DataTextField = dutext;
        ddlist.DataValueField = duvalues;
        ddlist.DataBind();

  
  }
    static public string operate(string sql)
    {
  
        string res = "";
        SqlConnection conn = new SqlConnection(sqlconn);
        conn.Open();
        SqlCommand Comm = new SqlCommand(sql, conn);
        try
        {
            Comm.ExecuteNonQuery();
            res = "ok";
        }
        catch(SqlException err)
        {
            res = err.ToString();
 
        }

        return res;
    }

    static public string jinjia(string producesid)
    {
        string res = "";
        string sql = "select ProducesJinJia from Produces where ProducesId='" + producesid+"'";
        SqlConnection conn = new SqlConnection(sqlconn);
        conn.Open();
        SqlCommand cmd = new SqlCommand(sql, conn);
        try
        {
            SqlDataReader sdr = cmd.ExecuteReader();
            if (sdr.Read())
            {

                res = Convert.ToString(sdr["ProducesJinjia"]);
            }
        }
        catch (SqlException err)
        {
           res = err.ToString();
           
        }

      

        return res;
 
    }

    static public string zongjia(string sql)
    {
        string res = "";
        SqlConnection conn = new SqlConnection(sqlconn);
        conn.Open();
        SqlCommand Cmd = new SqlCommand(sql, conn);
        object returnnum = Cmd.ExecuteScalar();




        if (returnnum != null)
        {


            res = Convert.ToString(returnnum);
            if (res.Length == 0)
            {
                res = "0";
            }



        }



        return res;
    }

  static public int stillkc(string producesid)
   {
       string totalnumshow ="";
     string sellnumshow = "";

       SqlConnection conn = new SqlConnection(sqlconn);
       conn.Open();

      string sql1 = "select sum(NeedNum) from SupplyList where ProducesId="+producesid;
    

       SqlCommand Comm1= new SqlCommand(sql1, conn);
       object returnnum = Comm1.ExecuteScalar();




       if (returnnum != null)
       {


           totalnumshow = Convert.ToString(returnnum);
           if (totalnumshow.Length==0)
           {
               totalnumshow = "0";
           }
       
          

       }

   
     
    

  string sql2="select sum(SellNum) from SellList where ProducesId=" + producesid;
  
      SqlCommand Comm2 = new SqlCommand(sql2, conn);

      object res = Comm2.ExecuteScalar();
      if (res!=null)
      {

        sellnumshow = Convert.ToString(res);
        if (sellnumshow.Length == 0)
        {
            sellnumshow = "0";
        }

  
      }


 
      Comm1.Dispose();
  
      Comm2.Dispose();
   
      conn.Close();
   
      conn.Dispose();

      int stillck = Int32.Parse(totalnumshow) - Int32.Parse(sellnumshow);
    

   return stillck;

  

 
   }
}