向数据库添加连续日期（年和日期整体）

最新推荐文章于 2022-02-22 17:41:58 发布

p419228530

最新推荐文章于 2022-02-22 17:41:58 发布

阅读量751

点赞数

分类专栏： C#WinForm开发文章标签：数据库 string insert null sql object

本文链接：https://blog.csdn.net/p419228530/article/details/6075726

版权

C#WinForm开发专栏收录该内容

7 篇文章 0 订阅

订阅专栏

        private void btnAdd_Click(object sender, EventArgs e)
        {
            int year = int.Parse(this.cbxStartYear.SelectedItem.ToString());
            int last = int.Parse(this.txtYear.Text.ToString());

DateTime datatime = new DateTime(year,01,01);

SqlDataReader reader = null;
string sql = "select WorkDate from WorkDay";

            using (reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.Text, sql, null))
            {
                int i = 0;
                if (reader.Read())
                {
                    if(reader[i].ToString().StartsWith(year.ToString()))
                    {
                        MessageBox.Show("该年数数据已经存在！");
                        return;
                    }
                    i++;
                }
            }

string week = "";

            while (datatime.Year < year + last)
            {
                string restsql = "insert into DayOff(RestDate) values('" + datatime.ToShortDateString() + "')";
                string worksql = "insert into WorkDay(WorkDate) values('" + datatime.ToShortDateString() + "')";

                week = datatime.DayOfWeek.ToString();
                if (week.Equals("Saturday") || week.Equals("Sunday"))
                {
                    SqlHelper.ExecuteNonQuery(SqlHelper.DBConnectionString, CommandType.Text, restsql, null);
                }
                else
                {
                    SqlHelper.ExecuteNonQuery(SqlHelper.DBConnectionString, CommandType.Text, worksql, null);
                }

datatime = datatime.AddDays(1);
}

            if (datatime.Year >= year + last)
            {
                MessageBox.Show("添加成功！");
            }

}