feedback.cs

一个web电子商务系统（我的毕业设计）

using System;
using System.Data.SqlClient;
using System.Data;
using System.Text;
using System.Collections;

namespace Data.BLL
{	
	public class Feedback
	{
		SqlConnection con;
		public Feedback()
		{
			con=new SqlConnection("server=127.0.0.1;database=BOOKSHOP;user id=sa;password=;");
		}
		/// <summary>
		/// 获得数据模型
		/// </summary>
		/// <param name="cID">表主键</param>
		/// <returns></returns>
	
		public Data.Model.Feedback getModel(string cID)
		{
			StringBuilder strSql=new StringBuilder();//实例化一个字符串容器
			strSql.AppendFormat("select * from Feedback where cID={0}",cID);//向字符容器里添加一条 SQL 语句
			con.Open();
			SqlDataAdapter adapter=new SqlDataAdapter(strSql.ToString(),con);
			DataSet ds=new DataSet();
			DataTable dt=new DataTable();
			adapter.Fill(ds,"Feedback");
			dt=ds.Tables["Feedback"];

			Data.Model.Feedback model=new Data.Model.Feedback();//实例化此数据表的模型

			if(dt.Rows.Count>0)
			{//有数据则向模型里存入数据
				model.cID=int.Parse(dt.Rows[0]["cID"].ToString());
				model.cUserID=dt.Rows[0]["cUserID"].ToString();
				model.cMessage=dt.Rows[0]["cMessage"].ToString();
				model.dDateTime=DateTime.Parse(dt.Rows[0]["dDateTime"].ToString());
				model.cStatus=dt.Rows[0]["cStatus"].ToString();
			}
			con.Close();
			
			return model;
		}

		/// <summary>
		///  添加数据行
		/// </summary>
		/// <param name="model">要添加表的模型</param>
		public bool add(Data.Model.Feedback model)
		{
			StringBuilder strSql=new StringBuilder();

			strSql.Append("insert into Feedback  values(");
			strSql.AppendFormat("{0}",model.cID);
			strSql.AppendFormat(",'{0}'",model.cUserID);
			strSql.AppendFormat(",'{0}'",model.cMessage);
			strSql.AppendFormat(",'{0}'",model.dDateTime);
			strSql.AppendFormat(",'{0}')",model.cStatus);

			return this.Execute(strSql.ToString());//调用执行SQL命令的函数并返回结果true or false
		}

		/// <summary>
		/// 删除数据表行
		/// </summary>
		/// <param name="cID">数据表主键</param>
		public bool  delete(string cID)
		{
			StringBuilder strSql=new StringBuilder();
			strSql.AppendFormat("delete Feedback where cID='{0}'",cID);

			return this.Execute(strSql.ToString());//调用执行SQL命令的函数并返回结果true or false
		}
		/// <summary>
		/// 更新数据表行
		/// </summary>
		/// <param name="model">要更新表模型</param>
		public bool update(Data.Model.Feedback model)
		{
			StringBuilder strSql=new StringBuilder();

            strSql.Append("update Feedback set ");
			strSql.AppendFormat("cUserID='{0}'",model.cUserID);
			strSql.AppendFormat(",cMessage='{0}'",model.cMessage);
			strSql.AppendFormat(",dDateTime='{0}'",model.dDateTime);
			strSql.AppendFormat(",cStatus='{0}'",model.cStatus);
			strSql.AppendFormat(" where cID={0}",model.cID);
			
			return this.Execute(strSql.ToString());//调用执行SQL命令的函数并返回结果true or false
		}

		/// <summary>
		/// 执行SQL语句
		/// </summary>
		/// <param name="strSql">SQL语句</param>
		/// <returns></returns>
		public bool Execute(string strSql)
		{
			bool b=false;

			SqlCommand command=new SqlCommand(strSql.ToString(),con);

			try
			{
				con.Open();
				command.ExecuteNonQuery();
				con.Close();
				b=true;
			}
			catch(Exception e)
			{
			}
			finally
			{
				con.Close();
			}

			return b;
		}

		/// <summary>
		/// 获得特定要求的所有主键列表
		/// </summary>
		public ArrayList getPrimaryKeyList(string StatusValues)
		{
			con.Open();
			StringBuilder strSql=new StringBuilder();//实例化一个字符串容器

			strSql.AppendFormat("select cID from FeedBack where cStatus='{0}'",StatusValues);

			SqlCommand command=new SqlCommand(strSql.ToString(),con);
			SqlDataReader read=command.ExecuteReader();

			ArrayList list=new ArrayList();

			while(read.Read())
			{
				list.Add(read[0].ToString());//将数据加入数组列表里
			}

			con.Close();

			return list;
		}	

		/// <summary>
		/// 得到最大的反馈ID号
		/// </summary>
		/// <returns></returns>
		public int getMaxID()
		{
			con.Open();

			StringBuilder strSql=new StringBuilder();//实例化一个字符串容器
			strSql.Append("select cID=max(cID) from FeedBack");
			SqlCommand command=new SqlCommand(strSql.ToString(),con);
			SqlDataReader read=command.ExecuteReader();

			int Max=0;

			while(read.Read())
			{
				if(read.GetValue(0).ToString()=="null"||read.GetValue(0).ToString()=="")
				{
				}
				else
				{
					Max=int.Parse(read[0].ToString());
				}
			}

			con.Close();

			return Max;
		}
	}	
}