protected void ibnt_addok_Click(object sender, ImageClickEventArgs e)
{
try
{
SHMetroTestSysModel.jc_EvaluateSurvey jcEvaluateModel = new SHMetroTestSysModel.jc_EvaluateSurvey();
jcEvaluateModel.evalCreateTime = DateTime.Now;
jcEvaluateModel.evalSurveryName = txt_evalSurveyName.Text;
int evaluateSurveyId = jcEvaluateSurveyBF.Add(jcEvaluateModel);
SHMetroTestSysModel.jc_EvaluateSurveyItem jcEvaluateSurveyItemModel = new SHMetroTestSysModel.jc_EvaluateSurveyItem();
jcEvaluateSurveyItemModel.evalSurveryId = evaluateSurveyId;
for (int i = 0; i < this.chkbox_evalItem.Items.Count; i++)
{
if (this.chkbox_evalItem.Items[i].Selected == true)
{
jcEvaluateSurveyItemModel.evalItemId = int.Parse(chkbox_evalItem.Items[i].Value);
jcEvaluateSurveyItemBF.Add(jcEvaluateSurveyItemModel);
}
}
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript",
"<script text=\"text/javascript\" defer=\"defer\">Dialog.alert('添加成功！');</script>");
}
catch (Exception ex)
{
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript",
"<script text=\"text/javascript\" defer=\"defer\">Dialog.alert('发生未知错误！');</script>");
}
}
protected void ibnt_addok_Click(object sender, ImageClickEventArgs e)
{
try
{
var jcEvaluateModel = jcEvaluateSurveyBF.GetModel(int.Parse(Request.QueryString["evalSurveryId"]));
jcEvaluateModel.evalSurveryName = txt_evalSurveyName.Text;
if (jcEvaluateSurveyBF.Update(jcEvaluateModel))
{
jcEvaluateSurveyItemBF.DeleteBySurveryId(int.Parse((Request.QueryString["evalSurveryId"])));
SHMetroTestSysModel.jc_EvaluateSurveyItem jcEvaluateSurveyItemModel = new SHMetroTestSysModel.jc_EvaluateSurveyItem();
jcEvaluateSurveyItemModel.evalSurveryId = jcEvaluateModel.evalSurveryId;
for (int i = 0; i < this.chkbox_evalItem.Items.Count; i++)
{
if (this.chkbox_evalItem.Items[i].Selected == true)
{
jcEvaluateSurveyItemModel.evalItemId = int.Parse(chkbox_evalItem.Items[i].Value);
jcEvaluateSurveyItemBF.Add(jcEvaluateSurveyItemModel);
}
}
Pan_Modify_OK.Visible = true;
pan_Add.Visible = false;
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript", "<script type=\"text/javascript\" defer=\"defer\">Dialog.alert('添加成功！');</script>");
}
}
catch (Exception ex)
{
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript", "<script type=\"text/javascript\" defer=\"defer\">Dialog.alert('发生未知错误！');</script>");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SHMetroTestSysModel.jc_EvaluateSurveyItem DataRowToModel(DataRow row)
{
SHMetroTestSysModel.jc_EvaluateSurveyItem model=new SHMetroTestSysModel.jc_EvaluateSurveyItem();
if (row != null)
{
if(row["evalSurveryItemId"]!=null && row["evalSurveryItemId"].ToString()!="")
{
model.evalSurveryItemId=int.Parse(row["evalSurveryItemId"].ToString());
}
if(row["evalSurveryId"]!=null && row["evalSurveryId"].ToString()!="")
{
model.evalSurveryId=int.Parse(row["evalSurveryId"].ToString());
}
if(row["evalItemId"]!=null && row["evalItemId"].ToString()!="")
{
model.evalItemId=int.Parse(row["evalItemId"].ToString());
}
}
return model;
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SHMetroTestSysModel.jc_EvaluateSurveyItem GetModel(int evalSurveryItemId)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("select top 1 evalSurveryItemId,evalSurveryId,evalItemId from jc_EvaluateSurveyItem ");
strSql.Append(" where evalSurveryItemId=@evalSurveryItemId");
SqlParameter[] parameters = {
new SqlParameter("@evalSurveryItemId", SqlDbType.Int,4)
};
parameters[0].Value = evalSurveryItemId;
SHMetroTestSysModel.jc_EvaluateSurveyItem model=new SHMetroTestSysModel.jc_EvaluateSurveyItem();
DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters);
if(ds.Tables[0].Rows.Count>0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
