企業(yè)網(wǎng)站建設(shè)畢業(yè)設(shè)計(jì)代碼06
時(shí)間：2023-08-16 06:45:02 | 來(lái)源：網(wǎng)站運(yùn)營(yíng)
時(shí)間：2023-08-16 06:45:02 來(lái)源：網(wǎng)站運(yùn)營(yíng)
企業(yè)網(wǎng)站建設(shè)畢業(yè)設(shè)計(jì)代碼06：企業(yè)網(wǎng)站建設(shè)畢業(yè)設(shè)計(jì)代碼06
社會(huì)計(jì)算
}
public float Outletsprice
{
get { return outletsprice; }
set { outletsprice = value; }
}
public float Uniprice
{
get { return uniprice; }
set { uniprice = value; }
}
public int Stock
{
get { return stock; }
set { stock = value; }
}
public int KindId
{
get { return kindId; }
set { kindId = value; }
}
public int SupId
{
get { return supId; }
set { supId = value; }
}
public int ResId
{
get { return resId; }
set { resId = value; }
}
public string ProDesc
{
get { return proDesc; }
set { proDesc = value; }
}
public string ProName
{
get { return proName; }
set { proName = value; }
}
public int ProId
{
get { return proId; }
set { proId = value; }
}
}
}
1．corpdal類(lèi)庫(kù)下dalproduct類(lèi)代碼如下：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using corpmodel;
namespace corpdal
{
public class dalproduct
{ SqlHelp SqlHelp = null;
DataSet ds = null;
public dalproduct()
{
SqlHelp = new SqlHelp();
}
public DataSet SellAll()
{
string sql = "select *from T_cropproduct";
DataSet ds = new DataSet();
using (ds = SqlHelp.sell(sql))
{
return ds;
}
}
public DataSet SellAllTime()
{
string sql = "select *from T_cropproduct order by Pubdate";
DataSet ds = new DataSet();
using (ds = SqlHelp.sell(sql))
{
return ds;
}
}
public DataSet SellAllStock()
{
string sql = "select *from T_cropproduct order by Stock";
DataSet ds = new DataSet();
using (ds = SqlHelp.sell(sql))
{
return ds;
}
}
public DataSet Single(product product1)
{
string sql = "select *from T_cropproduct where KindId=@KindId";
SqlParameter[] para = {
new SqlParameter ("@KindId",product1 .KindId )
};
DataSet ds = new DataSet();
using (ds = SqlHelp.sellsingle(sql, para))
{
return ds;
}
}
public DataSet Single_proname(product product1)
{
string sql = "select * from T_cropproduct where ProName=@ProName";
SqlParameter[] para = {
new SqlParameter ("@ProName",product1.ProName )
};
DataSet ds = new DataSet();
using (ds = SqlHelp.sellsingle(sql, para))
{
return ds;
}
}
public DataSet Single_SupId(product product1)
{
string sql = "select * from T_cropproduct where SupId=@SupId";
SqlParameter[] para = {
new SqlParameter ("@SupId",product1.SupId )
};
DataSet ds = new DataSet();
using (ds = SqlHelp.sellsingle(sql, para))
{
return ds;
}
}
public DataSet Single_KindIdTime(product product1)
{
string sql = "select * from T_cropproduct where KindId=@KindId order by Pubdate DESC";
SqlParameter[] para = {
new SqlParameter ("@KindId",product1.KindId )
};
DataSet ds = new DataSet();
using (ds = SqlHelp.sellsingle(sql, para))
{
return ds;
}
}
public DataSet Single_KindIdStock(product product1)
{
string sql = "select * from T_cropproduct where KindId=@KindId order by Stock";
SqlParameter[] para = {
new SqlParameter ("@KindId",product1.KindId )
};
DataSet ds = new DataSet();
using (ds = SqlHelp.sellsingle(sql, para))
{
return ds;
}
}
public bool insert(product product1)
{
string sql = "insert into T_cropproduct values(@ProName,@ProDesc,@ResId,@SupId,@KindId,@Stock,@Uniprice,@Outletsprice,@Pubdate,@Detail)";
SqlParameter[] para = {
new SqlParameter ("@ProName",product1.ProName ),
new SqlParameter("@ProDesc",product1.ProDesc ),
new SqlParameter ("@ResId",product1.ResId ),
new SqlParameter ("@SupId",product1.SupId ),
new SqlParameter ("@KindId",product1.KindId ),
new SqlParameter("@Stock",product1.Stock ),
new SqlParameter ("@Uniprice",product1.Uniprice ),
new SqlParameter ("@Outletsprice",product1.Outletsprice ),
new SqlParameter ("@Pubdate",product1.Pubdate ),
new SqlParameter ("@Detail",product1.Detail)
};
if (SqlHelp.ExecuteNonQuery(sql, para) > 0)
{
return true;
}
else
{
return false;
}
}
public bool update(product product1)
{
string sql = "update T_cropproduct set ProName=@ProName,ProDesc=@ProDesc,ResId=@ResId,SupId=@SupId,KindId=@KindId,Stock=@Stock,Uniprice=@Uniprice,Outletsprice=@Outletsprice,Pubdate=@Pubdate,Detail=@Detail where ProId=@ProId";
SqlParameter[] para = {
new SqlParameter ("@ProId",product1.ProId ),
new SqlParameter ("@ProName",product1.ProName ),
new SqlParameter("@ProDesc",product1.ProDesc ),
new SqlParameter ("@ResId",product1.ResId ),
new SqlParameter ("@SupId",product1.SupId ),
new SqlParameter ("@KindId",product1.KindId ),
new SqlParameter("@Stock",product1.Stock ),
new SqlParameter ("@Uniprice",product1.Uniprice ),
new SqlParameter ("@Outletsprice",product1.Outletsprice ),
new SqlParameter ("@Pubdate",product1.Pubdate ),
new SqlParameter ("@Detail",product1.Detail)
};
if (SqlHelp.ExecuteNonQuery(sql, para) > 0)
{
return true;
}
else
{
return false;
}
}
public bool delete(product product1)
{
string sql = "delete from T_cropproduct where ProId=@ProId";
SqlParameter[] para = {
new SqlParameter ("@ProId",product1.ProId )
};
if (SqlHelp.ExecuteNonQuery(sql, para) > 0)
{
return true;
}
else
{
return false;
}
}
}
}
2．corpbll類(lèi)庫(kù)下bllproduct類(lèi)代碼如下：
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using corpmodel;
using corpdal;
namespace corpbll
{
public class bllproduct
{
dalproduct dalproduct1 = new dalproduct();
public DataSet SellAll()
{
return dalproduct1.SellAll();
}
public DataSet SellAllTime()
{
return dalproduct1.SellAllTime();
}
public DataSet SellAllStock()
{
return dalproduct1.SellAllStock();
}
public DataSet Single(product product1)
{
return dalproduct1.Single(product1);
}
public DataSet Single_proname(product product1)
{
return dalproduct1.Single_proname(product1);
}
public DataSet Single_SupId(product product1)
{
return dalproduct1.Single_SupId(product1);
}
public DataSet Single_KindIdTime(product product1)
{
return dalproduct1.Single_KindIdTime(product1);
}
public DataSet Single_KindIdStock(product product1)
{
return dalproduct1.Single_KindIdStock(product1);
}
public bool insert(product product1)
{
return dalproduct1.insert(product1);
}
public bool update(product product1)
{
return dalproduct1.update(product1);
}
public bool delete(product product1)
{
return dalproduct1.delete(product1);
}
}
}
4.2 Web層下窗體
4.2.1普通用戶(hù)登錄界面
Web層下普通用戶(hù)登錄頁(yè)面：
圖4-1 普通用戶(hù)登錄頁(yè)面圖
只需要用戶(hù)名密碼便可以登錄，若還沒(méi)有注冊(cè)的用戶(hù)可以點(diǎn)擊注冊(cè)進(jìn)入Register.aspx注冊(cè)頁(yè)面進(jìn)行注冊(cè)。
4.2.2訂單頁(yè)面
Web層下order.aspx訂單頁(yè)面如下：
圖4-2訂單頁(yè)面
訂單頁(yè)面包括購(gòu)物基本情況（訂單號(hào)、數(shù)量、總的金額，訂貨人基本情況（姓名、地址、郵編）以及收貨人的基本情況（姓名、地址、郵編）。
4.2.3購(gòu)物車(chē)頁(yè)面
Web層下購(gòu)物車(chē)頁(yè)面如下：
圖4-3 購(gòu)物車(chē)頁(yè)面
購(gòu)物車(chē)讀取選擇的產(chǎn)品的基本信息，并把產(chǎn)品購(gòu)買(mǎi)數(shù)量默認(rèn)設(shè)置為1，在購(gòu)物車(chē)?yán)镌试S修改，可以刪除暫時(shí)不夠的產(chǎn)品。點(diǎn)擊進(jìn)入結(jié)算中心進(jìn)行結(jié)算。
關(guān)鍵詞：設(shè)計(jì),畢業(yè),建設(shè),企業(yè)
在線(xiàn)咨詢(xún)