两年之间相差的月份

最新推荐文章于 2024-11-28 11:00:00 发布

侠仪

最新推荐文章于 2024-11-28 11:00:00 发布

阅读量346

点赞数

CC 4.0 BY-SA版权

文章标签： sql

本文链接：https://blog.youkuaiyun.com/lxl743p/article/details/4893051

    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()));

}
}

}