/// <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;
}
}
