/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { #region 验证 bool a = false; for (int i = 1; i <= 5; i++) { HtmlInputText tb =(HtmlInputText)this.FindControl("tb" + i.ToString()); HtmlInputText t = (HtmlInputText)this.FindControl("t"+i.ToString()); HtmlInputText tt = (HtmlInputText)this.FindControl("t"+i.ToString()+i.ToString()); if (!string.IsNullOrEmpty(tb.Value)&&!string.IsNullOrEmpty(t.Value)&&!string.IsNullOrEmpty(tt.Value)) { a = true; } else { a = false; break; } } if (!a) { Common.JShelper.JSAlert(this.Page, "", "请填写完整!"); } #endregion else { LabMS.Model.ScoreConversion MSC = new LabMS.Model.ScoreConversion(); for (int i = 1; i <= 5; i++) { HtmlInputText inputText = (HtmlInputText)this.FindControl("t" + i.ToString());//t1 HtmlInputText inputText2 = (HtmlInputText)this.FindControl("t" + i.ToString() + i.ToString());//t11 HtmlInputText inputText3 = (HtmlInputText)this.FindControl("tb" + i.ToString());//tb1 MSC.ID = i; if (!string.IsNullOrEmpty(inputText.Value)&&!string.IsNullOrEmpty(inputText2.Value)) { MSC.Percentile = decimal.Parse(inputText.Value); MSC.Percentile2 = decimal.Parse(inputText2.Value); MSC.Level = inputText3.Value; BSC.Update(MSC); } } Common.JShelper.JSAlert(this.Page, "", "保存成功!"); } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public LabMS.Model.ScoreConversion GetModel(int ID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 ID,Percentile,Percentile2,Level from ScoreConversion "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4)}; parameters[0].Value = ID; LabMS.Model.ScoreConversion model=new LabMS.Model.ScoreConversion(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["ID"].ToString()!="") { model.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if(ds.Tables[0].Rows[0]["Percentile"].ToString()!="") { model.Percentile=decimal.Parse(ds.Tables[0].Rows[0]["Percentile"].ToString()); } if(ds.Tables[0].Rows[0]["Percentile2"].ToString()!="") { model.Percentile2=decimal.Parse(ds.Tables[0].Rows[0]["Percentile2"].ToString()); } model.Level=ds.Tables[0].Rows[0]["Level"].ToString(); return model; } else { return null; } }