网上购物系统（Task009）——FormView插入删除商品详细信息

来源：岁月联盟编辑：exp 时间：2012-05-12

一、进入插入模板

1、protectedvoid fvwItemDetails_ModeChanging(object sender,FormViewModeEventArgs e)函数中添加代码：

case FormViewMode.Insert:

this.fvwItemDetails.ChangeMode(FormViewMode.Insert);

break;

2、此时，可进入插入模板，不过，不显示任何信息，也不能够获得下拉列表框的句柄，须添加PreRender()消息响应函数，在这个消息响应函数中添加填充下拉列表框的代码：

protected void fvwItemDetails_PreRender(object sender,EventArgs e)

{

if (fvwItemDetails.CurrentMode ==FormViewMode.Insert)

{

DropDownList ddl = (DropDownList)fvwItemDetails.FindControl("ddlCategories");

if (ddl != null)

{

BindDropDownList(ddl);

}

二、修改BindDropDownList()函数

[csharp] private void BindDropDownList(DropDownList ddl)
{
    ddl.DataSource = new Category().GetCategories();
    ddl.DataTextField = "Name";
    ddl.DataValueField = "CategoryId";
    ddl.DataBind();

    if (ViewState["SelectedCategoryId"] != null)
    {
        ListItem selectedItem = ddl.Items.FindByValue(ViewState["SelectedCategoryId"].ToString());
        if (selectedItem != null)
            selectedItem.Selected = true;
    }
    else
    {
        string selectcategory = Request.QueryString["categoryId"].ToString();
        ListItem selectedItem = ddl.Items.FindByValue(selectcategory);
        if (selectedItem != null)
            selectedItem.Selected = true;
    }
}
private void BindDropDownList(DropDownList ddl)
{
    ddl.DataSource = new Category().GetCategories();
    ddl.DataTextField = "Name";
    ddl.DataValueField = "CategoryId";
    ddl.DataBind();

    if (ViewState["SelectedCategoryId"] != null)
    {
        ListItem selectedItem = ddl.Items.FindByValue(ViewState["SelectedCategoryId"].ToString());
        if (selectedItem != null)
            selectedItem.Selected = true;
    }
    else
    {
        string selectcategory = Request.QueryString["categoryId"].ToString();
        ListItem selectedItem = ddl.Items.FindByValue(selectcategory);
        if (selectedItem != null)
            selectedItem.Selected = true;
    }
}

三、添加消息响应函数fvwItemDetails_ItemInserting()

[csharp] protected void fvwItemDetails_ItemInserting(object sender, FormViewInsertEventArgs e)
{
    ItemDetails itemdetails = new ItemDetails();
    if (ViewState["ImageUrl"] != null)
    {
        itemdetails.Image = ViewState["ImageUrl"].ToString();
    }

    if (ViewState["SelectedCategoryId"] != null)
    {

        DropDownList ddl = (DropDownList)fvwItemDetails.FindControl("ddlCategories");
        itemdetails.CategoryId = ViewState["SelectedCategoryId"].ToString();
    }

    TextBox txtname = (TextBox)fvwItemDetails.FindControl("txtName");
    itemdetails.Name = txtname.Text;

    TextBox txtPrice = (TextBox)fvwItemDetails.FindControl("txtPrice");
    itemdetails.Price = decimal.Parse(txtPrice.Text);

    TextBox txtDescn = (TextBox)fvwItemDetails.FindControl("txtDescn");
    itemdetails.Descn = txtDescn.Text;

    TextBox txtSupplyTime = (TextBox)fvwItemDetails.FindControl("txtSupplyTime");
    itemdetails.SupplyTime = txtSupplyTime.Text;

    TextBox txtSupplyDate = (TextBox)fvwItemDetails.FindControl("txtSupplyDate");
    itemdetails.SupplyDate = txtSupplyDate.Text;

    TextBox txtSupplyArea = (TextBox)fvwItemDetails.FindControl("txtSupplyArea");
    itemdetails.SupplyArea = txtSupplyArea.Text;

    Item item = new Item();
    item.InsertItem(itemdetails);

    fvwItemDetails.ChangeMode(FormViewMode.ReadOnly);

    BindFormView();
    ViewState["ImageUrl"] = null;
    ViewState["SelectedCategoryId"] = null;

}
protected void fvwItemDetails_ItemInserting(object sender, FormViewInsertEventArgs e)
{
    ItemDetails itemdetails = new ItemDetails();
    if (ViewState["ImageUrl"] != null)
    {
        itemdetails.Image = ViewState["ImageUrl"].ToString();
    }

if (ViewState["SelectedCategoryId"] != null)
{

        DropDownList ddl = (DropDownList)fvwItemDetails.FindControl("ddlCategories");
        itemdetails.CategoryId = ViewState["SelectedCategoryId"].ToString();
    }

TextBox txtname = (TextBox)fvwItemDetails.FindControl("txtName");
itemdetails.Name = txtname.Text;

TextBox txtPrice = (TextBox)fvwItemDetails.FindControl("txtPrice");
itemdetails.Price = decimal.Parse(txtPrice.Text);

TextBox txtDescn = (TextBox)fvwItemDetails.FindControl("txtDescn");
itemdetails.Descn = txtDescn.Text;

TextBox txtSupplyTime = (TextBox)fvwItemDetails.FindControl("txtSupplyTime");
itemdetails.SupplyTime = txtSupplyTime.Text;

TextBox txtSupplyDate = (TextBox)fvwItemDetails.FindControl("txtSupplyDate");
itemdetails.SupplyDate = txtSupplyDate.Text;

TextBox txtSupplyArea = (TextBox)fvwItemDetails.FindControl("txtSupplyArea");
itemdetails.SupplyArea = txtSupplyArea.Text;

Item item = new Item();
item.InsertItem(itemdetails);

fvwItemDetails.ChangeMode(FormViewMode.ReadOnly);

    BindFormView();
    ViewState["ImageUrl"] = null;
    ViewState["SelectedCategoryId"] = null;

}

四、在数据访问层DAL的Item.cs类中，添加InsertItem(ItemDetails item)函数

[csharp] public void InsertItem(ItemDetails item)
{
    SqlParameter[] parms;
    parms = new SqlParameter[]
    {
        new SqlParameter("@ItemId",SqlDbType.Int),
        new SqlParameter("@CategoryId",SqlDbType.VarChar,20),
        new SqlParameter("@Name",SqlDbType.VarChar,80),
        new SqlParameter("@Price",SqlDbType.Decimal,10),
        new SqlParameter("@Image",SqlDbType.VarChar,80),
        new SqlParameter("@Descn",SqlDbType.VarChar,80),
        new SqlParameter("@SupplyTime",SqlDbType.VarChar,80),
        new SqlParameter("@SupplyDate",SqlDbType.VarChar,80),
        new SqlParameter("@SupplyArea",SqlDbType.VarChar,80)
    };

    parms[0].Value = item.ItemId;
    parms[1].Value = item.CategoryId;
    parms[2].Value = item.Name;
    parms[3].Value = item.Price;
    parms[4].Value = item.Image;
    parms[5].Value = item.Descn;
    parms[6].Value = item.SupplyTime;
    parms[7].Value = item.SupplyDate;
    parms[8].Value = item.SupplyArea;

    SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_INSERT_ITEM, parms);
}
public void InsertItem(ItemDetails item)
{
    SqlParameter[] parms;
    parms = new SqlParameter[]
    {
        new SqlParameter("@ItemId",SqlDbType.Int),
        new SqlParameter("@CategoryId",SqlDbType.VarChar,20),
        new SqlParameter("@Name",SqlDbType.VarChar,80),
        new SqlParameter("@Price",SqlDbType.Decimal,10),
        new SqlParameter("@Image",SqlDbType.VarChar,80),
        new SqlParameter("@Descn",SqlDbType.VarChar,80),
        new SqlParameter("@SupplyTime",SqlDbType.VarChar,80),
        new SqlParameter("@SupplyDate",SqlDbType.VarChar,80),
        new SqlParameter("@SupplyArea",SqlDbType.VarChar,80)
    };

    parms[0].Value = item.ItemId;
    parms[1].Value = item.CategoryId;
    parms[2].Value = item.Name;
    parms[3].Value = item.Price;
    parms[4].Value = item.Image;
    parms[5].Value = item.Descn;
    parms[6].Value = item.SupplyTime;
    parms[7].Value = item.SupplyDate;
    parms[8].Value = item.SupplyArea;

SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_INSERT_ITEM, parms);
}

五、FormView删除详细信息比较简单，不过，步骤和前面是一样的。

1、添加消息响应函数

[csharp] protected void fvwItemDetails_ItemDeleting(object sender, FormViewDeleteEventArgs e)
{
    ItemDetails itemdetails = new ItemDetails();
    itemdetails.ItemId = int.Parse(Request.QueryString["itemId"]);
    Item item = new Item();
    item.DeleteItem(itemdetails);
    Image img = (Image)fvwItemDetails.FindControl("imgItem");
    File.Delete(Server.MapPath(img.ImageUrl));
    BindFormView();
}
protected void fvwItemDetails_ItemDeleting(object sender, FormViewDeleteEventArgs e)
{
    ItemDetails itemdetails = new ItemDetails();
    itemdetails.ItemId = int.Parse(Request.QueryString["itemId"]);
    Item item = new Item();
    item.DeleteItem(itemdetails);
    Image img = (Image)fvwItemDetails.FindControl("imgItem");
    File.Delete(Server.MapPath(img.ImageUrl));
    BindFormView();
}

在删除数据库数据的同时，删除了服务器端文件。

2、在数据访问层DAL的Item.cs类中，添加DeleteItem(ItemDetails item)函数

[csharp] public void DeleteItem(ItemDetails item)
{
    SqlParameter[] parms;
    parms = new SqlParameter[]
    {
         new SqlParameter("@ItemId",SqlDbType.Int)
    };

    parms[0].Value = item.ItemId;

    SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_DELETE_ITEM, parms);
}
public void DeleteItem(ItemDetails item)
{
    SqlParameter[] parms;
    parms = new SqlParameter[]
    {
         new SqlParameter("@ItemId",SqlDbType.Int)
    };