ASP+SQL SERVER2000电子商城系统 第28页

相关代码：
private void searchAdvance_Click(object sender, System.EventArgs e)
              {
                productDB PDB =new productDB();
         
          SqlDataReader
result =PDB.ProductSearch(name.Text,
int.Parse(Session["CategoryID"].ToString())); 
      
                Repeater1.DataSource=result;
                    
                Repeater1.DataBind();
 
                //绑定数据到控件
 
                     }
6.10.4求购信息发布系统
a. 求购信息发布系统需求
 
需要获取发布求购信息者的身份，是商家还是客户。
需要有求购商品的基本信息：
商品的类别，名称，价格，要求，数量，新旧程度，样品图片等。
 
b. 求购信息发布系统模块设计
c. 求购信息发布系统部分相关代码
 
相关类库：
 
//添加求购信息。
 
public void RequirementAdd(int CompanyID,int ClientID,String ProductName,String Demand,int Amount,
                     String UnitPrice,DateTime EndDate,int CategoryID,byte[] ImageData,String NewGrade)
              {
             
             
                     // Create Instance of Connection and Command Object
                     SqlConnection myConnection = new SqlConnection(ConfigurationSettings.AppSettings["ESMS"]);
                     SqlCommand myCommand = new SqlCommand("RequirementAdd", myConnection);
 
                     // Mark the Command as a SPROC
                     myCommand.CommandType = CommandType.StoredProcedure;
 
                     // Add Parameters to SPROC
                     SqlParameter parameterCompanyID = new SqlParameter("@CompanyID", SqlDbType.Int );
                     parameterCompanyID.Value = CompanyID;
                     myCommand.Parameters.Add(parameterCompanyID);
 
                     SqlParameter parameterClientID = new SqlParameter("@ClientID", SqlDbType.Int );
                     parameterClientID.Value = ClientID;
                     myCommand.Parameters.Add(parameterClientID);
 
                     SqlParameter parameterProductName = new SqlParameter("@ProductName", SqlDbType.Char, 30);
                     parameterProductName.Value = ProductName;
                     myCommand.Parameters.Add(parameterProductName);
 
            SqlParameter parameterDemand = new SqlParameter("@Demand", SqlDbType.VarChar ,300);
                     parameterDemand.Value = Demand;
                     myCommand.Parameters.Add(parameterDemand);
 
                     SqlParameter parameterAmount = new SqlParameter("@Amount", SqlDbType.Int );
                     parameterAmount.Value = Amount;
                     myCommand.Parameters.Add(parameterAmount);
 
                     SqlParameter parameterUnitPrice = new SqlParameter("@UnitPrice", SqlDbType.Char,20);
                     parameterUnitPrice.Value = UnitPrice;
                     myCommand.Parameters.Add(parameterUnitPrice);
                    
                     SqlParameter parameterCreateDate = new SqlParameter("@CreateDate", SqlDbType.DateTime);
                     parameterCreateDate.Value =DateTime.Now;
                     myCommand.Parameters.Add(parameterCreateDate);
 
                     SqlParameter parameterEndDate = new SqlParameter("@EndDate", SqlDbType.DateTime);
                     parameterEndDate.Value =EndDate;
                     myCommand.Parameters.Add(parameterEndDate);
 
                     SqlParameter parameterCategoryID = new SqlParameter("@CategoryID", SqlDbType.Int);
                     parameterCategoryID.Value = CategoryID;

 << 上一页  [21] [22] [23] [24] [25] [26] [27] [28] [29] [30]  ... 下一页  >> 

ASP+SQL SERVER2000电子商城系统 第28页下载如图片无法显示或论文不完整，请联系qq752018766