/// <summary> /// 得到一个对象实体 /// </summary> public SHMetroTestSysModel.jc_EvaluateItem DataRowToModel(DataRow row) { SHMetroTestSysModel.jc_EvaluateItem model=new SHMetroTestSysModel.jc_EvaluateItem(); if (row != null) { if(row["evalItemId"]!=null && row["evalItemId"].ToString()!="") { model.evalItemId=int.Parse(row["evalItemId"].ToString()); } if(row["evalItemName"]!=null) { model.evalItemName=row["evalItemName"].ToString(); } if(row["evalParentItemId"]!=null && row["evalParentItemId"].ToString()!="") { model.evalParentItemId=int.Parse(row["evalParentItemId"].ToString()); } if(row["evalItemCode"]!=null) { model.evalItemCode=row["evalItemCode"].ToString(); } if(row["evalItemCategory"]!=null && row["evalItemCategory"].ToString()!="") { model.evalItemCategory=int.Parse(row["evalItemCategory"].ToString()); } if(row["evalItemDescription"]!=null) { model.evalItemDescription=row["evalItemDescription"].ToString(); } } return model; }
protected void ibnt_addok_Click(object sender, ImageClickEventArgs e) { var model = new SHMetroTestSysModel.jc_EvaluateItem(); model.evalItemName = txt_evaTypeName.Text; model.evalItemCategory = 0; if (jcEvaluateItemBF.Add(model) > 0) { this.pan_Add.Visible = false; this.Pan_OK.Visible = true; Page.ClientScript.RegisterStartupScript(GetType(), "startscript", "<script text=\"text/javascript\" defer=\"defer\">Dialog.alert('添加评价类别完成!');</script>"); } else { Page.ClientScript.RegisterStartupScript(GetType(), "startscript", "<script text=\"text/javascript\" defer=\"defer\">Dialog.alert('发生未知错误!');</script>"); } }
/// <summary> /// 得到一个对象实体 /// </summary> public SHMetroTestSysModel.jc_EvaluateItem GetModel(int evalItemId) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 evalItemId,evalItemName,evalParentItemId,evalItemCode,evalItemCategory,evalItemDescription from jc_EvaluateItem "); strSql.Append(" where evalItemId=@evalItemId"); SqlParameter[] parameters = { new SqlParameter("@evalItemId", SqlDbType.Int,4) }; parameters[0].Value = evalItemId; SHMetroTestSysModel.jc_EvaluateItem model=new SHMetroTestSysModel.jc_EvaluateItem(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }