protected void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(this.txtName.Text.Trim().Length==0) { strErr+="Name不能为空!\\n"; } if(!PageValidate.IsNumber(txtMajorId.Text)) { strErr+="MajorId格式错误!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } string Name=this.txtName.Text; int MajorId=int.Parse(this.txtMajorId.Text); Eva.Model.Class model=new Eva.Model.Class(); model.Name=Name; model.MajorId=MajorId; Eva.BLL.Class bll=new Eva.BLL.Class(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","add.aspx"); }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (CollegeList.SelectedValue=="0") { strErr += "请选择学院!"; } if (MajorList.SelectedValue=="0") { strErr += "请选择专业"; } if (txtClass.Text.Trim().Length==0) { strErr += "班级不能为空!"; } if (strErr != "") { Maticsoft.Common.MessageBox.Show(this, strErr); return; } int id = int.Parse(Request["id"]); classes = bllClass.GetModel(id); classes.Name = txtClass.Text; classes.MajorId = int.Parse(MajorList.SelectedValue); if (bllClass.Update(classes)) { Maticsoft.Common.MessageBox.ShowAndRedirect(this, "修改成功!", "ClassList.aspx"); } else { Maticsoft.Common.MessageBox.Show(this, "修改失败!"); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Eva.Model.Class DataRowToModel(DataRow row) { Eva.Model.Class model=new Eva.Model.Class(); if (row != null) { if(row["Id"]!=null && row["Id"].ToString()!="") { model.Id=int.Parse(row["Id"].ToString()); } if(row["Name"]!=null) { model.Name=row["Name"].ToString(); } if(row["MajorId"]!=null && row["MajorId"].ToString()!="") { model.MajorId=int.Parse(row["MajorId"].ToString()); } } return model; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var CollegeDS = bllCollege.GetAllList(); int id = int.Parse(Request["id"]); classes = bllClass.GetModel(id); major = bllMajor.GetModel(Convert.ToInt16(classes.MajorId)); CollegeList.DataSource = CollegeDS.Tables["ds"].DefaultView; CollegeList.DataTextField = "Name"; CollegeList.DataValueField = "Id"; CollegeList.DataBind(); CollegeList.Items.FindByValue(major.CollegeId.ToString()).Selected = true; LoadMajor(); MajorList.Items.FindByValue(classes.MajorId.ToString()).Selected = true; txtClass.Text = classes.Name; } }
/// <summary> /// 得到一个对象实体 /// </summary> public Eva.Model.Class GetModel(int Id) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 Id,Name,MajorId from Class "); strSql.Append(" where Id=@Id"); SqlParameter[] parameters = { new SqlParameter("@Id", SqlDbType.Int,4) }; parameters[0].Value = Id; Eva.Model.Class model=new Eva.Model.Class(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }