源代码/ST_FlowerPrearrange/App_Code/Classes/ST_Flower.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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

namespace ST_GROUP.FlowerPrearrange
{
	/// <summary>
	/// ST_Flower description for Flower。
	/// </summary>
	public class ST_Flower:ST_Base
	{
		public ST_Flower()
		{
			
		}
		//get all data of Flowers
		public DataView ST_GetFlower()
		{
			String ST_strsql;
			DataSet ST_myDs;
			ST_strsql="SELECT ST_Flower.*, ST_FlowerType.ST_Name AS ST_TypeName FROM ST_Flower INNER JOIN ST_FlowerType ON ST_Flower.ST_Type = ST_FlowerType.ST_Id";
			ST_myDs=ST_ExecuteSql4Ds(ST_strsql);
			return ST_myDs.Tables[0].DefaultView ;
		}

		//get top ten best salers
		public DataView ST_GetFlowerTop10()
		{
			String ST_strsql;
			DataSet ST_myDs;
			ST_strsql="select top 10 ST_id,ST_name from ST_Flower order by ST_sales DESC";
			ST_myDs=ST_ExecuteSql4Ds(ST_strsql);
			return ST_myDs.Tables[0].DefaultView ;
		}

		/// <summary>
		/// add Flower,Operator Storeprocedure "ST_AddFlower"
		/// </summary>
		/// <param name="tempary">Flower detail,Kind:ArrayList</param>
		/// <returns></returns>
		public void ST_AddFlower(ArrayList tempary)
		{
			SqlConnection ST_myCn=new SqlConnection(ST_strConn);
			SqlCommand ST_myCm=new SqlCommand("ST_AddFlower",ST_myCn);
			ST_myCm.CommandType =CommandType.StoredProcedure ;

			ST_myCm.Parameters.Add(new SqlParameter("@ST_name",SqlDbType.VarChar,100));
			ST_myCm.Parameters["@ST_name"].Value =tempary[0];

			ST_myCm.Parameters.Add(new SqlParameter("@ST_type",SqlDbType.Int));
			ST_myCm.Parameters["@ST_type"].Value =tempary[1];

			ST_myCm.Parameters.Add(new SqlParameter("@ST_price",SqlDbType.Decimal ));
			ST_myCm.Parameters["@ST_price"].Value =tempary[2];

			ST_myCm.Parameters.Add(new SqlParameter("@ST_discount",SqlDbType.Decimal ));
			ST_myCm.Parameters["@ST_discount"].Value =tempary[3];

			ST_myCm.Parameters.Add(new SqlParameter("@ST_cover",SqlDbType.Image ));