/// <summary> /// 得到一个对象实体 /// </summary> public SHMetroTestSysModel.jc_EvaluateCourseUser DataRowToModel(DataRow row) { SHMetroTestSysModel.jc_EvaluateCourseUser model=new SHMetroTestSysModel.jc_EvaluateCourseUser(); if (row != null) { if(row["evalCourseUserId"]!=null && row["evalCourseUserId"].ToString()!="") { model.evalCourseUserId=int.Parse(row["evalCourseUserId"].ToString()); } if(row["evalCourseId"]!=null && row["evalCourseId"].ToString()!="") { model.evalCourseId=int.Parse(row["evalCourseId"].ToString()); } if(row["evalUserId"]!=null && row["evalUserId"].ToString()!="") { model.evalUserId=int.Parse(row["evalUserId"].ToString()); } if(row["evalCreateTime"]!=null && row["evalCreateTime"].ToString()!="") { model.evalCreateTime=DateTime.Parse(row["evalCreateTime"].ToString()); } if(row["evalStatus"]!=null && row["evalStatus"].ToString()!="") { model.evalStatus=int.Parse(row["evalStatus"].ToString()); } if(row["evalNote"]!=null) { model.evalNote=row["evalNote"].ToString(); } } return model; }
protected void ibnt_addok_Click(object sender, ImageClickEventArgs e) { var jcEvaluateCourseModel = jcEvaluateCourseBF.GetModel(int.Parse(Request.QueryString["evalCourseId"])); jcEvaluateCourseModel.evalCourseName = txt_evalCourseName.Text; jcEvaluateCourseModel.evalCourseAddress = txt_evalCourseAddress.Text; jcEvaluateCourseModel.evalCourseNumber = txt_evalCourseNumber.Text; jcEvaluateCourseModel.evalCourseTeacher = txt_evalCourseTeacher.Text; jcEvaluateCourseModel.evalSurveryId = int.Parse(ddl_evalSurvey.SelectedValue); jcEvaluateCourseModel.evalCourseDate = DateTime.Parse(txt_evalCourseDate.Text); jcEvaluateCourseModel.evalCourseContent = txt_evalCourseContent.Text; if (jcEvaluateCourseBF.Update(jcEvaluateCourseModel)) { SHMetroTestSysModel.jc_EvaluateCourseUser jcEvaluateCourseUserModel = new SHMetroTestSysModel.jc_EvaluateCourseUser(); jcEvaluateCourseUserModel.evalCourseId = int.Parse(Request.QueryString["evalCourseId"]); jcEvaluateCourseUserModel.evalCreateTime = DateTime.Now; for (int i = 1; i < this.chkbox_evalUser.Items.Count; i++) { jcEvaluateCourseUserModel.evalUserId = int.Parse(chkbox_evalUser.Items[i].Value); if (this.chkbox_evalUser.Items[i].Selected == true && (!jcEvaluateCourseUserBF.IsSelectUser(int.Parse(Request.QueryString["evalCourseId"]), jcEvaluateCourseUserModel.evalUserId.Value))) { jcEvaluateCourseUserBF.Add(jcEvaluateCourseUserModel); } else if (this.chkbox_evalUser.Items[i].Selected == false) { jcEvaluateCourseUserBF.Delete(jcEvaluateCourseUserModel.evalCourseId.Value, jcEvaluateCourseUserModel.evalUserId.Value); } } this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript", "<script type=\"text/javascript\" defer=\"defer\">Dialog.alert('修改成功!');</script>"); this.pan_Add.Visible = false; this.Pan_OK.Visible = true; } else { this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript", "<script type=\"text/javascript\" defer=\"defer\">Dialog.alert('发生未知错误!');</script>"); } }
/// <summary> /// 得到一个对象实体 /// </summary> public SHMetroTestSysModel.jc_EvaluateCourseUser GetModel(int evalCourseUserId) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 evalCourseUserId,evalCourseId,evalUserId,evalCreateTime,evalStatus,evalNote from jc_EvaluateCourseUser "); strSql.Append(" where evalCourseUserId=@evalCourseUserId"); SqlParameter[] parameters = { new SqlParameter("@evalCourseUserId", SqlDbType.Int,4) }; parameters[0].Value = evalCourseUserId; SHMetroTestSysModel.jc_EvaluateCourseUser model=new SHMetroTestSysModel.jc_EvaluateCourseUser(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }