public void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(!PageValidate.IsDateTime(txtBeginDate.Text)) { strErr+="BeginDate格式错误!\\n"; } if(!PageValidate.IsNumber(txtGroupPeriodNo.Text)) { strErr+="GroupPeriodNo格式错误!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } int SuiteNo=int.Parse(this.lblSuiteNo.Text); int TimeZoneNo=int.Parse(this.lblTimeZoneNo.Text); DateTime BeginDate=DateTime.Parse(this.txtBeginDate.Text); int GroupPeriodNo=int.Parse(this.txtGroupPeriodNo.Text); WebDemo.Model.WebDemo.RateTimeZone model=new WebDemo.Model.WebDemo.RateTimeZone(); model.SuiteNo=SuiteNo; model.TimeZoneNo=TimeZoneNo; model.BeginDate=BeginDate; model.GroupPeriodNo=GroupPeriodNo; WebDemo.BLL.WebDemo.RateTimeZone bll=new WebDemo.BLL.WebDemo.RateTimeZone(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","list.aspx"); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.RateTimeZone model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update RateTimeZone set "); strSql.Append("BeginDate=@BeginDate,"); strSql.Append("GroupPeriodNo=@GroupPeriodNo"); strSql.Append(" where SuiteNo=@SuiteNo and TimeZoneNo=@TimeZoneNo "); SqlParameter[] parameters = { new SqlParameter("@BeginDate", SqlDbType.DateTime), new SqlParameter("@GroupPeriodNo", SqlDbType.Int, 4), new SqlParameter("@SuiteNo", SqlDbType.Int, 4), new SqlParameter("@TimeZoneNo", SqlDbType.Int, 4) }; parameters[0].Value = model.BeginDate; parameters[1].Value = model.GroupPeriodNo; parameters[2].Value = model.SuiteNo; parameters[3].Value = model.TimeZoneNo; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(WebDemo.Model.WebDemo.RateTimeZone model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RateTimeZone("); strSql.Append("SuiteNo,TimeZoneNo,BeginDate,GroupPeriodNo)"); strSql.Append(" values ("); strSql.Append("@SuiteNo,@TimeZoneNo,@BeginDate,@GroupPeriodNo)"); SqlParameter[] parameters = { new SqlParameter("@SuiteNo", SqlDbType.Int, 4), new SqlParameter("@TimeZoneNo", SqlDbType.Int, 4), new SqlParameter("@BeginDate", SqlDbType.DateTime), new SqlParameter("@GroupPeriodNo", SqlDbType.Int, 4) }; parameters[0].Value = model.SuiteNo; parameters[1].Value = model.TimeZoneNo; parameters[2].Value = model.BeginDate; parameters[3].Value = model.GroupPeriodNo; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.RateTimeZone GetModel(int SuiteNo, int TimeZoneNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SuiteNo,TimeZoneNo,BeginDate,GroupPeriodNo from RateTimeZone "); strSql.Append(" where SuiteNo=@SuiteNo and TimeZoneNo=@TimeZoneNo "); SqlParameter[] parameters = { new SqlParameter("@SuiteNo", SqlDbType.Int, 4), new SqlParameter("@TimeZoneNo", SqlDbType.Int, 4) }; parameters[0].Value = SuiteNo; parameters[1].Value = TimeZoneNo; WebDemo.Model.WebDemo.RateTimeZone model = new WebDemo.Model.WebDemo.RateTimeZone(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { return(DataRowToModel(ds.Tables[0].Rows[0])); } else { return(null); } }
private void ShowInfo(int SuiteNo, int TimeZoneNo) { WebDemo.BLL.WebDemo.RateTimeZone bll = new WebDemo.BLL.WebDemo.RateTimeZone(); WebDemo.Model.WebDemo.RateTimeZone model = bll.GetModel(SuiteNo, TimeZoneNo); this.lblSuiteNo.Text = model.SuiteNo.ToString(); this.lblTimeZoneNo.Text = model.TimeZoneNo.ToString(); this.lblBeginDate.Text = model.BeginDate.ToString(); this.lblGroupPeriodNo.Text = model.GroupPeriodNo.ToString(); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.RateTimeZone DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.RateTimeZone model = new WebDemo.Model.WebDemo.RateTimeZone(); if (row != null) { if (row["SuiteNo"] != null && row["SuiteNo"].ToString() != "") { model.SuiteNo = int.Parse(row["SuiteNo"].ToString()); } if (row["TimeZoneNo"] != null && row["TimeZoneNo"].ToString() != "") { model.TimeZoneNo = int.Parse(row["TimeZoneNo"].ToString()); } if (row["BeginDate"] != null && row["BeginDate"].ToString() != "") { model.BeginDate = DateTime.Parse(row["BeginDate"].ToString()); } if (row["GroupPeriodNo"] != null && row["GroupPeriodNo"].ToString() != "") { model.GroupPeriodNo = int.Parse(row["GroupPeriodNo"].ToString()); } } return(model); }