/// <summary> /// 得到一个对象实体 /// </summary> public JiaJiao.Model.Teacher DataRowToModel(DataRow row) { JiaJiao.Model.Teacher model=new JiaJiao.Model.Teacher(); if (row != null) { if(row["ID"]!=null && row["ID"].ToString()!="") { model.ID=int.Parse(row["ID"].ToString()); } if(row["TeacherName"]!=null) { model.TeacherName=row["TeacherName"].ToString(); } if(row["TeacherTel"]!=null) { model.TeacherTel=row["TeacherTel"].ToString(); } if(row["TeacherEmail"]!=null) { model.TeacherEmail=row["TeacherEmail"].ToString(); } if(row["TeacherAddress"]!=null) { model.TeacherAddress=row["TeacherAddress"].ToString(); } if(row["TeacherDescribe"]!=null) { model.TeacherDescribe=row["TeacherDescribe"].ToString(); } if(row["RoleId"]!=null && row["RoleId"].ToString()!="") { model.RoleId=int.Parse(row["RoleId"].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()); } if(row["Image"]!=null) { model.Image=row["Image"].ToString(); } } return model; }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtTeacherName.Text.Trim().Length == 0) { strErr += "姓名不能为空!\\n"; } if (this.txtTeacherTel.Text.Trim().Length == 0) { strErr += "电话不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string fullFileName = this.fileUpLoad.PostedFile.FileName; string fileName = fullFileName.Substring(fullFileName.LastIndexOf(@"/") + 1); string typeName = (fullFileName.Substring(fullFileName.LastIndexOf(".") + 1)).ToLower(); if (string.IsNullOrWhiteSpace(fileName)) { MessageBox.Show(this, "请选择一张图片"); return; } string file = DateTime.Now.ToString("yyyyMMddHHmmss") + "." + typeName; if (typeName == "png" || typeName == "jpg" || typeName == "bmp" || typeName == "gif" || typeName == "jpeg") { this.fileUpLoad.PostedFile.SaveAs(Server.MapPath("~/Images/") + file); } else { MessageBox.Show(this, "你的图片格式错误"); return; } string TeacherName = this.txtTeacherName.Text; string TeacherTel = this.txtTeacherTel.Text; string TeacherEmail = this.txtTeacherEmail.Text; string TeacherAddress = this.txtTeacherAddress.Text; string TeacherDescribe = this.txtTeacherDescribe.Text; int RoleId = int.Parse(DropDownList1.SelectedValue); DateTime CreateTime = DateTime.Now; DateTime UpdateTime = DateTime.Now; JiaJiao.Model.Teacher model = new JiaJiao.Model.Teacher(); model.TeacherName = TeacherName; model.TeacherTel = TeacherTel; model.TeacherEmail = TeacherEmail; model.TeacherAddress = TeacherAddress; model.TeacherDescribe = TeacherDescribe; model.RoleId = RoleId; model.CreateTime = CreateTime; model.UpdateTime = UpdateTime; model.Image = "~/Images/" + file; JiaJiao.BLL.Teacher bll = new JiaJiao.BLL.Teacher(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public JiaJiao.Model.Teacher GetModel(int ID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 ID,TeacherName,TeacherTel,TeacherEmail,TeacherAddress,TeacherDescribe,RoleId,CreateTime,UpdateTime,Image from Teacher "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4) }; parameters[0].Value = ID; JiaJiao.Model.Teacher model=new JiaJiao.Model.Teacher(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtTeacherName.Text.Trim().Length == 0) { strErr += "TeacherName不能为空!\\n"; } if (this.txtTeacherTel.Text.Trim().Length == 0) { strErr += "TeacherTel不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string fullFileName = this.fileUpLoad.PostedFile.FileName; string fileName = fullFileName.Substring(fullFileName.LastIndexOf(@"/") + 1); string typeName = (fullFileName.Substring(fullFileName.LastIndexOf(".") + 1)).ToLower(); string file = DateTime.Now.ToString("yyyyMMddHHmmss") + "." + typeName; bool flag = false; if (!string.IsNullOrWhiteSpace(fileName)) { if (typeName == "png" || typeName == "jpg" || typeName == "bmp" || typeName == "gif" || typeName == "jpeg") { this.fileUpLoad.PostedFile.SaveAs(Server.MapPath("~/Images/") + file); flag = true; } else { MessageBox.Show(this, "你的图片格式错误"); return; } } int ID = int.Parse(this.lblID.Text); string TeacherName = this.txtTeacherName.Text; string TeacherTel = this.txtTeacherTel.Text; string TeacherEmail = this.txtTeacherEmail.Text; string TeacherAddress = this.txtTeacherAddress.Text; string TeacherDescribe = this.txtTeacherDescribe.Text; int RoleId = int.Parse(DropDownList1.SelectedValue); DateTime CreateTime = DateTime.Now; DateTime UpdateTime = DateTime.Now; JiaJiao.Model.Teacher model = new JiaJiao.Model.Teacher(); model.ID = ID; model.TeacherName = TeacherName; model.TeacherTel = TeacherTel; model.TeacherEmail = TeacherEmail; model.TeacherAddress = TeacherAddress; model.TeacherDescribe = TeacherDescribe; model.RoleId = RoleId; model.CreateTime = CreateTime; model.UpdateTime = UpdateTime; JiaJiao.BLL.Teacher bll = new JiaJiao.BLL.Teacher(); if (flag) { model.Image = "~/Images/" + file; } else { JiaJiao.Model.Teacher model1 = bll.GetModel(ID); model.Image = model1.Image; int id= int.Parse(Request.Params["id"]); } bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }