/// <summary> /// 更新一条数据 /// </summary> public bool Update(WebDemo.Model.WebDemo.RatePeriod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update RatePeriod set "); strSql.Append("BeginTime=@BeginTime,"); strSql.Append("FareRateNo=@FareRateNo"); strSql.Append(" where SuiteNo=@SuiteNo and GroupPeriodNo=@GroupPeriodNo and PeriodNo=@PeriodNo "); SqlParameter[] parameters = { new SqlParameter("@BeginTime", SqlDbType.DateTime), new SqlParameter("@FareRateNo", SqlDbType.Int, 4), new SqlParameter("@SuiteNo", SqlDbType.Int, 4), new SqlParameter("@GroupPeriodNo", SqlDbType.Int, 4), new SqlParameter("@PeriodNo", SqlDbType.Int, 4) }; parameters[0].Value = model.BeginTime; parameters[1].Value = model.FareRateNo; parameters[2].Value = model.SuiteNo; parameters[3].Value = model.GroupPeriodNo; parameters[4].Value = model.PeriodNo; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(WebDemo.Model.WebDemo.RatePeriod model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into RatePeriod("); strSql.Append("SuiteNo,GroupPeriodNo,PeriodNo,BeginTime,FareRateNo)"); strSql.Append(" values ("); strSql.Append("@SuiteNo,@GroupPeriodNo,@PeriodNo,@BeginTime,@FareRateNo)"); SqlParameter[] parameters = { new SqlParameter("@SuiteNo", SqlDbType.Int, 4), new SqlParameter("@GroupPeriodNo", SqlDbType.Int, 4), new SqlParameter("@PeriodNo", SqlDbType.Int, 4), new SqlParameter("@BeginTime", SqlDbType.DateTime), new SqlParameter("@FareRateNo", SqlDbType.Int, 4) }; parameters[0].Value = model.SuiteNo; parameters[1].Value = model.GroupPeriodNo; parameters[2].Value = model.PeriodNo; parameters[3].Value = model.BeginTime; parameters[4].Value = model.FareRateNo; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.RatePeriod DataRowToModel(DataRow row) { WebDemo.Model.WebDemo.RatePeriod model = new WebDemo.Model.WebDemo.RatePeriod(); if (row != null) { if (row["SuiteNo"] != null && row["SuiteNo"].ToString() != "") { model.SuiteNo = int.Parse(row["SuiteNo"].ToString()); } if (row["GroupPeriodNo"] != null && row["GroupPeriodNo"].ToString() != "") { model.GroupPeriodNo = int.Parse(row["GroupPeriodNo"].ToString()); } if (row["PeriodNo"] != null && row["PeriodNo"].ToString() != "") { model.PeriodNo = int.Parse(row["PeriodNo"].ToString()); } if (row["BeginTime"] != null && row["BeginTime"].ToString() != "") { model.BeginTime = DateTime.Parse(row["BeginTime"].ToString()); } if (row["FareRateNo"] != null && row["FareRateNo"].ToString() != "") { model.FareRateNo = int.Parse(row["FareRateNo"].ToString()); } } return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public WebDemo.Model.WebDemo.RatePeriod GetModel(int SuiteNo, int GroupPeriodNo, int PeriodNo) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 SuiteNo,GroupPeriodNo,PeriodNo,BeginTime,FareRateNo from RatePeriod "); strSql.Append(" where SuiteNo=@SuiteNo and GroupPeriodNo=@GroupPeriodNo and PeriodNo=@PeriodNo "); SqlParameter[] parameters = { new SqlParameter("@SuiteNo", SqlDbType.Int, 4), new SqlParameter("@GroupPeriodNo", SqlDbType.Int, 4), new SqlParameter("@PeriodNo", SqlDbType.Int, 4) }; parameters[0].Value = SuiteNo; parameters[1].Value = GroupPeriodNo; parameters[2].Value = PeriodNo; WebDemo.Model.WebDemo.RatePeriod model = new WebDemo.Model.WebDemo.RatePeriod(); 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 GroupPeriodNo, int PeriodNo) { WebDemo.BLL.WebDemo.RatePeriod bll = new WebDemo.BLL.WebDemo.RatePeriod(); WebDemo.Model.WebDemo.RatePeriod model = bll.GetModel(SuiteNo, GroupPeriodNo, PeriodNo); this.lblSuiteNo.Text = model.SuiteNo.ToString(); this.lblGroupPeriodNo.Text = model.GroupPeriodNo.ToString(); this.lblPeriodNo.Text = model.PeriodNo.ToString(); this.txtBeginTime.Text = model.BeginTime.ToString(); this.txtFareRateNo.Text = model.FareRateNo.ToString(); }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(txtSuiteNo.Text)) { strErr += "SuiteNo格式错误!\\n"; } if (!PageValidate.IsNumber(txtGroupPeriodNo.Text)) { strErr += "GroupPeriodNo格式错误!\\n"; } if (!PageValidate.IsNumber(txtPeriodNo.Text)) { strErr += "PeriodNo格式错误!\\n"; } if (!PageValidate.IsDateTime(txtBeginTime.Text)) { strErr += "BeginTime格式错误!\\n"; } if (!PageValidate.IsNumber(txtFareRateNo.Text)) { strErr += "FareRateNo格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int SuiteNo = int.Parse(this.txtSuiteNo.Text); int GroupPeriodNo = int.Parse(this.txtGroupPeriodNo.Text); int PeriodNo = int.Parse(this.txtPeriodNo.Text); DateTime BeginTime = DateTime.Parse(this.txtBeginTime.Text); int FareRateNo = int.Parse(this.txtFareRateNo.Text); WebDemo.Model.WebDemo.RatePeriod model = new WebDemo.Model.WebDemo.RatePeriod(); model.SuiteNo = SuiteNo; model.GroupPeriodNo = GroupPeriodNo; model.PeriodNo = PeriodNo; model.BeginTime = BeginTime; model.FareRateNo = FareRateNo; WebDemo.BLL.WebDemo.RatePeriod bll = new WebDemo.BLL.WebDemo.RatePeriod(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }