goodssaveinfo.aspx.cs.txt

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

/*******************************************************************************
** File Name（文件名）：　                  GoodsSaveInfo.aspx.cs
** Storage Path（存储路径）：　             Manage\
** Author（作者）：                         Whale
** Create Time（建立日期及时间）：          2006-07-20 17:04
** Last Modify Time（最后修改日期及时间）： 2006-09-08 16: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_GoodsSaveInfo : System.Web.UI.Page
{
    #region 定义调用对象

    GoodsSave GoodsSave = new GoodsSave();
    protected string typename = ConfigurationManager.AppSettings["typename"];

    #endregion

    protected void Page_Load(object sender, EventArgs e)
    {
        if ((Session["ManagerID"] == null) || (Session["ManagerID"].ToString() == ""))
        {
            JScript.GotoParentWindow("Index.aspx");
        }
        else
        {
            if (!IsPostBack)
            {
                GetGoodsSaveInfo();
            }
        }
    }

    #region 方法

    /// <summary>
    /// 提取库存配置信息
    /// </summary>
    private void GetGoodsSaveInfo()
    {
        DataTable myDtb = new DataTable();
        myDtb = GoodsSave.GetGoodsSaveInfo().Tables[0];
        if (myDtb.DefaultView.Count > 0)
        {
            AllNum.Text = myDtb.DefaultView[0]["AllNum"].ToString();
            AlertNum.Text = myDtb.DefaultView[0]["AlertNum"].ToString();
            AddTime.Text = myDtb.DefaultView[0]["AddTime"].ToString();
            Session["GoodsSaveInfoID"] = myDtb.DefaultView[0]["GoodsSaveInfoID"].ToString();
        }
        else
        {
            AllNum.Text = "0";
            AlertNum.Text = "0";
            AddTime.Text = DateTime.Now.ToString();
            Session["GoodsSaveInfoID"] = "0";
        }
    }

    /// <summary>
    /// 修改库存配置信息
    /// </summary>
    protected void IsModify_Click(object sender, EventArgs e)
    {
        if ((AllNum.Text.Trim().Length == 0) || (AlertNum.Text.Trim().Length == 0))
        {
            JScript.Alert("商品满库数量和库存预警数量不能为空！");
            return;
        }
        else
        {
            int goodsSaveInfoID = 0;
            if ((Session["GoodsSaveInfoID"] != null) && (Session["GoodsSaveInfoID"].ToString() != ""))
            {
                goodsSaveInfoID = int.Parse(Session["GoodsSaveInfoID"].ToString());
            }
            int allNum = 0;
            if (StringUtil.IsNumeric(AllNum.Text.Trim()))
            {
                allNum = int.Parse(AllNum.Text.Trim().ToString());
            }
            int alertNum = 0;
            if (StringUtil.IsNumeric(AlertNum.Text.Trim()))
            {
                alertNum = int.Parse(AlertNum.Text.Trim().ToString());
            }
            int modifyOk = GoodsSave.ModifyGoodsSaveInfo(goodsSaveInfoID, allNum, alertNum);
            if (modifyOk == 1)
            {
                JScript.Alert("修改成功，欢迎使用！");
                JScript.JavaScriptLocationHref("Main.aspx");
            }
            else
            {
                JScript.Alert("修改失败，请稍后再来！");
                return;
            }
        }
    }

    #endregion
}