年，月，日下拉(cs)

  1using System;
  2using System.Collections;
  3using System.ComponentModel;
  4using System.Data;
  5using System.Drawing;
  6using System.Web;
  7using System.Web.SessionState;
  8using System.Web.UI;
  9using System.Web.UI.WebControls;
 10using System.Web.UI.HtmlControls;
 11
 12namespace HNANet.Home.Status
 13{
 14    /**//// <summary>
 15    /// 添加网站动态栏目信息
 16    /// Author: zhou_min
 17    /// Date: 2002-8-30
 18    /// </summary>
 19    public class add : System.Web.UI.Page
 20    {
 21        protected System.Web.UI.WebControls.DropDownList DropMonth;
 22        protected System.Web.UI.WebControls.DropDownList DropDay;
 23        protected System.Web.UI.WebControls.DropDownList DropYear;
 24        protected System.Web.UI.WebControls.TextBox tbLink;
 25        protected System.Web.UI.WebControls.Button ButCheck;
 26        protected System.Web.UI.WebControls.Label LabResult;
 27        protected System.Web.UI.WebControls.TextBox tbName;
 28    
 29        private void Page_Load(object sender, System.EventArgs e)
 30        {
 31            if(Page.IsPostBack==false)
 32            {
 33                BindYear();
 34                BindMonth();
 35                BindDay();
 36            }
 37        }
 38
 39        //年下拉框绑定
 40        void BindYear()
 41        {
 42            DataSet dsRetu=new DataSet();
 43
 44            //添加年也表
 45            dsRetu.Tables.Add("Year");
 46            dsRetu.Tables["Year"].Columns.Add("intYear",typeof(int));
 47            dsRetu.Tables["Year"].Columns.Add("Year",typeof(string));
 48            DataRow myRow = dsRetu.Tables["Year"].NewRow();
 49            
 50            DataTable dt=dsRetu.Tables["Year"];
 51
 52            //其系统当前的时间的年份
 53            int intStartYear=Convert.ToInt32(DateTime.Today.Year)-1;
 54            //循环给年下拉单付值
 55            for(int intRoll=0;intRoll<3;intRoll++)
 56            {                
 57                DataRow dr=dt.NewRow();
 58                int intYear=intRoll+intStartYear;
 59                dr["intYear"]=intRoll+intStartYear;
 60                dr["Year"]=intYear.ToString();
 61                dt.Rows.Add(dr);
 62            }
 63
 64            //下拉框数据绑定
 65            DataView dv=dsRetu.Tables["Year"].DefaultView;
 66            DropYear.DataSource = dv;
 67            DropYear.DataTextField="intYear";
 68            DropYear.DataValueField="Year";
 69            DropYear.DataBind();
 70            DropYear.Items[1].Selected=true;
 71        }
 72
 73        //月下拉框绑定
 74        void BindMonth()
 75        {
 76            DataSet dsRetu=new DataSet();
 77
 78            //添加月也表
 79            dsRetu.Tables.Add("Month");
 80            dsRetu.Tables["Month"].Columns.Add("intMonth",typeof(int));
 81            dsRetu.Tables["Month"].Columns.Add("Month",typeof(string));
 82            DataRow myRow = dsRetu.Tables["Month"].NewRow();
 83            
 84            DataTable dt=dsRetu.Tables["Month"];
 85
 86            //其系统当前的时间的月份
 87            int intStartMonth=Convert.ToInt32(DateTime.Today.Month);
 88            //循环给月下拉单付值
 89            for(int intRoll=1;intRoll<=12;intRoll++)
 90            {                
 91                DataRow dr=dt.NewRow();
 92                dr["intMonth"]=intRoll;
 93                dr["Month"]=intRoll.ToString();
 94                dt.Rows.Add(dr);
 95            }
 96
 97            //下拉框数据绑定
 98            DataView dv=dsRetu.Tables["Month"].DefaultView;
 99            DropMonth.DataSource = dv;
100            DropMonth.DataTextField="intMonth";
101            DropMonth.DataValueField="Month";
102            DropMonth.DataBind();
103            DropMonth.Items[intStartMonth-1].Selected=true;
104        }
105
106        //日下拉框绑定
107        void BindDay()
108        {
109            DataSet dsRetu=new DataSet();
110
111            //添加日也表
112            dsRetu.Tables.Add("Day");
113            dsRetu.Tables["Day"].Columns.Add("intDay",typeof(int));
114            dsRetu.Tables["Day"].Columns.Add("Day",typeof(string));
115            DataRow myRow = dsRetu.Tables["Day"].NewRow();
116            
117            DataTable dt=dsRetu.Tables["Day"];
118
119            //其系统当前的时间的日期
120            int intStartDay=Convert.ToInt32(DateTime.Today.Day);
121            //循环给日下拉单付值
122            for(int intRoll=1;intRoll<=31;intRoll++)
123            {                
124                DataRow dr=dt.NewRow();
125                dr["intDay"]=intRoll;
126                dr["Day"]=intRoll.ToString();
127                dt.Rows.Add(dr);
128            }
129
130            //下拉框数据绑定
131            DataView dv=dsRetu.Tables["Day"].DefaultView;
132            DropDay.DataSource = dv;
133            DropDay.DataTextField="intDay";
134            DropDay.DataValueField="Day";
135            DropDay.DataBind();
136            DropDay.Items[intStartDay-1].Selected=true;
137        }
138
139        Web Form Designer generated code#region Web Form Designer generated code
140        override protected void OnInit(EventArgs e)
141        {
142            //
143            // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
144            //
145            InitializeComponent();
146            base.OnInit(e);
147        }
148        
149        /**//// <summary>
150        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
151        /// 此方法的内容。
152        /// </summary>
153        private void InitializeComponent()
154        {    
155            this.Load += new System.EventHandler(this.Page_Load);
156
157        }
158        #endregion
159
160        
161        protected void ButCheck_Click(object sender, System.EventArgs e)
162        {
163            //取得各种传递参数值
164            string strYear=DropYear.SelectedItem.Text.ToString();
165            string strMonth=DropMonth.SelectedItem.Text.ToString();
166            string strDay=DropDay.SelectedItem.Text.ToString();
167            string strName=tbName.Text.ToString();
168            string strLink=tbLink.Text.ToString();
169
170            //处理时间参数
171            string strTime=strYear+"-"+strMonth+"-"+strDay+" "+DateTime.Now.TimeOfDay.ToString();
172            int strLen=strTime.IndexOf(".");
173            strTime=strTime.Remove(strLen,strTime.Length-strLen);
174
175            string strCon=clsCommon.strCondbHome;
176            string strSql="insert into development(title,path,publish_time) values('"+strName+"','"+strLink+"','"+strTime+"')";
177
178            //新纪录插入数据库
179            clsCommon clsCom=new clsCommon();
180            bool result=clsCom.UpdateData(strCon,strSql);
181
182            //操作输出提示
183            if(result)
184            {
185                LabResult.Text="添加网站动态成功！";
186            }
187            else
188            {
189                LabResult.Text="添加网站动态失败！";
190            }
191        }
192        
193    }
194}
195