public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (!PageValidate.IsNumber(this.ddlTeacher.SelectedValue)) { strErr += "请选择一个老师!\\n"; } if (string.IsNullOrWhiteSpace(this.ddlTime.SelectedValue)) { strErr += "请选择时间!\\n"; } if (!PageValidate.IsNumber(txtTotal.Text)) { strErr += "开班人数格式错误!\\n"; } if (!PageValidate.IsNumber(txtCount.Text)) { strErr += "报名人数格式错误!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int ID = int.Parse(this.lblID.Text); int TeacherId = int.Parse(this.ddlTeacher.SelectedValue); int DayId = int.Parse(this.ddlTime.SelectedValue); int Total = int.Parse(this.txtTotal.Text); int Count = int.Parse(this.txtCount.Text); DateTime CreateTime = DateTime.Now; DateTime UpdateTime = DateTime.Now; JiaJiao.Model.ClassSetting model = new JiaJiao.Model.ClassSetting(); model.ID = ID; model.TeacherId = TeacherId; model.DayId = DayId; model.Total = Total; model.Count = Count; model.CreateTime = CreateTime; model.UpdateTime = UpdateTime; JiaJiao.BLL.ClassSetting bll = new JiaJiao.BLL.ClassSetting(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public JiaJiao.Model.ClassSetting DataRowToModel(DataRow row) { JiaJiao.Model.ClassSetting model=new JiaJiao.Model.ClassSetting(); if (row != null) { if(row["ID"]!=null && row["ID"].ToString()!="") { model.ID=int.Parse(row["ID"].ToString()); } if(row["TeacherId"]!=null && row["TeacherId"].ToString()!="") { model.TeacherId=int.Parse(row["TeacherId"].ToString()); } if(row["DayId"]!=null && row["DayId"].ToString()!="") { model.DayId=int.Parse(row["DayId"].ToString()); } if(row["Total"]!=null && row["Total"].ToString()!="") { model.Total=int.Parse(row["Total"].ToString()); } if(row["Count"]!=null && row["Count"].ToString()!="") { model.Count=int.Parse(row["Count"].ToString()); } if(row["CreateTime"]!=null && row["CreateTime"].ToString()!="") { model.CreateTime=DateTime.Parse(row["CreateTime"].ToString()); } if(row["UpdateTime"]!=null && row["UpdateTime"].ToString()!="") { model.UpdateTime=DateTime.Parse(row["UpdateTime"].ToString()); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public JiaJiao.Model.ClassSetting GetModel(int ID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 ID,TeacherId,DayId,Total,Count,CreateTime,UpdateTime from ClassSetting "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4) }; parameters[0].Value = ID; JiaJiao.Model.ClassSetting model=new JiaJiao.Model.ClassSetting(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }