goodsum.ascx.cs

Asp.net物资流通管理系统源码 本系统主要针对物流供应链中的库存管理环节

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;

public partial class UserControl_GoodSum : System.Web.UI.UserControl
{
    private string _goodskeep;
    public string Goodskeep
    {
        get { return _goodskeep; }
        set { _goodskeep = value; }
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            int Math1 = Convert.ToInt32(DateTime.Today.Month.ToString());
            string Math2 = Convert.ToString(Math1 - 1);
            string Math3 = Convert.ToString(Math1 - 2);

            Month1.Text = GetM(Convert.ToString(Math1));
            Month1_1.Text = GetTypesNum(Convert.ToString(Math1),"M","1");
            Month1_2.Text = GetTypesNum(Convert.ToString(Math1), "M", "2");
            Month1_3.Text = GetTypesNum(Convert.ToString(Math1), "M", "3");
            Month1_4.Text = GetTypesNum(Convert.ToString(Math1), "M", "4");
            Month1_5.Text = GetTypesNum(Convert.ToString(Math1), "M", "5");
            Month1_6.Text = GetTypesNum(Convert.ToString(Math1), "M", "6");
            Month2.Text = GetM(Math2);
            Month2_1.Text = GetTypesNum(Convert.ToString(Math2), "M", "1");
            Month2_2.Text = GetTypesNum(Convert.ToString(Math2), "M", "2");
            Month2_3.Text = GetTypesNum(Convert.ToString(Math2), "M", "3");
            Month2_4.Text = GetTypesNum(Convert.ToString(Math2), "M", "4");
            Month2_5.Text = GetTypesNum(Convert.ToString(Math2), "M", "5");
            Month2_6.Text = GetTypesNum(Convert.ToString(Math2), "M", "6");
            Month3.Text = GetM(Math3);
            Month3_1.Text = GetTypesNum(Convert.ToString(Math3), "M", "1");
            Month3_2.Text = GetTypesNum(Convert.ToString(Math3), "M", "2");
            Month3_3.Text = GetTypesNum(Convert.ToString(Math3), "M", "3");
            Month3_4.Text = GetTypesNum(Convert.ToString(Math3), "M", "4");
            Month3_5.Text = GetTypesNum(Convert.ToString(Math3), "M", "5");
            Month3_6.Text = GetTypesNum(Convert.ToString(Math3), "M", "6");
            Years.Text = "本年度";
            string YearsNam = DateTime.Today.Year.ToString();
            Years_1.Text = GetTypesNum(YearsNam, "YYYY", "1");
            Years_2.Text = GetTypesNum(YearsNam, "YYYY", "2");
            Years_3.Text = GetTypesNum(YearsNam, "YYYY", "3");
            Years_4.Text = GetTypesNum(YearsNam, "YYYY", "4");
            Years_5.Text = GetTypesNum(YearsNam, "YYYY", "5");
            Years_6.Text = GetTypesNum(YearsNam, "YYYY", "6");
        }
    }

    #region //返回该库操作类型所对应的当月数量
    public string GetTypesNum(string Moths,string DateTypes,string Types) 
    {
        SqlDataBase MyDb = new SqlDataBase();
        return MyDb.ReturnSQL("Select Sum(GoodNum) AS GoodNumTotal From View_Sum where TypesID = '" + Types + "' and AlignGoodC = '" + _goodskeep + "' and DatePart(" + DateTypes + ",RecordTime)='" + Moths + "'");
    }
    #endregion

    #region//返回对应的中文月份
    public string GetM(string MontNum)
    {
        string ReturnString = "";
        switch (MontNum)
        {
            case "1":
                ReturnString = "一月";
                break;
            case "2":
                ReturnString = "二月";
                break;
            case "3":
                ReturnString = "三月";
                break;
            case "4":
                ReturnString = "四月";
                break;
            case "5":
                ReturnString = "五月";
                break;
            case "6":
                ReturnString = "六月";
                break;
            case "7":
                ReturnString = "七月";
                break;
            case "8":
                ReturnString = "八月";
                break;
            case "9":
                ReturnString = "九月";
                break;
            case "10":
                ReturnString = "十月";
                break;
            case "11":
                ReturnString = "十一月";
                break;
            case "12":
                ReturnString = "十二月";
                break;
        }
        return ReturnString;
    }
    #endregion
}