goodssavealert.aspx.cs.txt

本源码实现了对数据库的最基本的操作

/*******************************************************************************
** File Name（文件名）：　                  GoodsSaveAlert.aspx.cs
** Storage Path（存储路径）：　             Manage\
** Author（作者）：                         Whale
** Create Time（建立日期及时间）：          2006-07-20 17:04
** Last Modify Time（最后修改日期及时间）： 2006-09-11 11:53
** File Version（本文件版本号）：X.X.XXX    1.0.01
** File Action describe（文件功能描述）：　 后台管理--库存预警商品列表
** File Memo（备注）：
******************************************************************************/
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Kingvcn.WShop;

/// <summary>
/// 后台管理-库存预警商品列表
/// </summary>
public partial class Manage_GoodsSaveAlert : System.Web.UI.Page
{
    #region 定义调用对象

    GoodsSave GoodsSave = new GoodsSave();
    protected string typename = ConfigurationManager.AppSettings["typename"];
    int goodsID = 0;
    int alertNum = 0;

    #endregion

    protected void Page_Load(object sender, EventArgs e)
    {
        if ((Session["ManagerID"] == null)||(Session["ManagerID"].ToString() == ""))
        {
            JScript.GotoParentWindow("Index.aspx");
        }
        else
        {
            alertNum = GoodsSave.GetGoodsSaveInfoNum(0);
            if ((Request["GoodsID"] != null) && (Request["GoodsID"].ToString() != ""))
            {
                goodsID = int.Parse(Request["GoodsID"].ToString());
                if (!IsPostBack)
                {
                    GetGoodsSaveAlertByID(goodsID);
                    PalAllGoodsSaveAlert.Visible = false;
                    PalOneGoodsSaveAlert.Visible = true;
                }
            }
            else
            {
                if (!IsPostBack)
                {
                    PalAllGoodsSaveAlert.Visible = true;
                    PalOneGoodsSaveAlert.Visible = false;
                }
            }
        }
    }

    #region 方法

    /// <summary>
    /// 提取库存预警商品信息
    /// </summary>
    /// <param name="goodsID">商品ID</param>
    private void GetGoodsSaveAlertByID(int goodsID)
    {
        if (goodsID > 0)
        {
            DataTable myDtb = new DataTable();
            myDtb = GoodsSave.GetGoodsSaveAlertByID(goodsID);
            if (myDtb.DefaultView.Count > 0)
            {
                GoodsID.Text = myDtb.DefaultView[0]["GoodsID"].ToString();
                GoodsName.Text = myDtb.DefaultView[0]["GoodsName"].ToString();
                SaveNum.Text = myDtb.DefaultView[0]["SaveNum"].ToString();
                SaveAddNum.Text = myDtb.DefaultView[0]["SaveAddNum"].ToString();
                SaveTime.Text = myDtb.DefaultView[0]["SaveTime"].ToString();
                SaveAddTime.Text = myDtb.DefaultView[0]["SaveAddTime"].ToString();
            }
            else
            {
                JScript.Alert("没有找到该商品的库存信息！");
                JScript.GotoParentWindow("GoodsSaveAlert.aspx");
            }
        }
    }

    /// <summary>
    /// 修改库存预警商品的数量
    /// </summary>
    protected void IsAdd_Click(object sender, EventArgs e)
    {
        if (SaveNum.Text.Trim().Length == 0)
        {
            JScript.Alert("商品库存数量不能为空！");
        }
        else
        {
            int goodsID = 0;
            if (StringUtil.IsNumeric(GoodsID.Text.Trim()))
            {
                goodsID = int.Parse(GoodsID.Text.Trim().ToString());
            }
            int saveNum = 0;
            if (StringUtil.IsNumeric(SaveNum.Text.Trim()))
            {
                saveNum = int.Parse(SaveNum.Text.Trim().ToString());
            }
            string goodsName = GoodsName.Text.ToString();
            int modifyOk = GoodsSave.ModifyGoodsSaveAlert(goodsID, saveNum, goodsName);
            if (modifyOk == 1)
            {
                JScript.Alert("修改成功，欢迎使用！");
                JScript.JavaScriptLocationHref("GoodsSaveAlert.aspx");
            }
            else
            {
                JScript.Alert("修改失败，请稍后再来！");
                return;
            }
        }
    }

    /// <summary>
    /// 把预警商品全部满库
    /// </summary>
    protected void AddAll_Click(object sender, EventArgs e)
    {
        int allNum = GoodsSave.GetGoodsSaveInfoNum(1);
        int modifyOk = GoodsSave.SetGoodsSaveAll(allNum, alertNum);
        if (modifyOk == 1)
        {
            JScript.Alert("预警商品全部满库成功，欢迎使用！");
            JScript.JavaScriptLocationHref("GoodsSaveAlert.aspx");
        }
        else
        {
            JScript.Alert("预警商品全部满库失败，请稍后再来！");
            return;
        }
    }

    #endregion
}