两年之间相差的月份

    protected void ddlBind()
    {
        Month.Items.Clear();
        var Month1 = 0;
        var Month2 = 0;
        var Year1 = 0;
        var Year2 = 0;
        var Temp = 0;
        var sql = string.Format("SELECT BeginDate,EndDate FROM dbo.Tp_BatchConfig   WHERE ItemID='{0}'", ddlBatchName.SelectedValue);
        var tb = DbHelperSQL.Query(sql).Tables[0];
        foreach (DataRow dr in tb.Rows)
        {
            Month1 = Convert.ToDateTime(dr["BeginDate"]).Month;
            Month2 = Convert.ToDateTime(dr["EndDate"]).Month;
            Year1 = Convert.ToDateTime(dr["BeginDate"]).Year;
            Year2 = Convert.ToDateTime(dr["EndDate"]).Year;

            if (Year1 < Year2)
            {
                for (int i = Month1; i <= 12; i++)
                {
                    Month.Items.Insert(Temp, new ListItem(i.ToString() + "月", i.ToString()));
                    Temp++;

                }
                for (int i = 1; i <= Month2; i++)
                {
                    Month.Items.Insert(Temp, new ListItem(i.ToString() + "月", i.ToString()));
                }
            }
            else
            {

                for (int i = Month1; i <= Month2; i++)
                {
                    Month.Items.Insert(Temp, new ListItem(i.ToString() + "月", i.ToString()));

                }
            }

 

        }

    }