public Model.Hos HosMes(string Hos_Name) { string str = "select Hos_name,Hos_detail,Hos_how,Hos_title from tb_Hos where Hos_name =@Hos_Name"; MySqlParameter[] parameters = { new MySqlParameter("@Hos_Name", MySqlDbType.VarChar, 100) }; parameters[0].Value = Hos_Name; Model.Hos model = new Model.Hos(); DataTable dt = SqlDbHelper.ExecuteDataTable(str, CommandType.Text, parameters); if (dt.Rows.Count > 0) { if (dt.Rows[0]["Hos_name"] != null && dt.Rows[0]["Hos_name"].ToString() != "") { model.Hos_Name = dt.Rows[0]["Hos_name"].ToString(); } if (dt.Rows[0]["Hos_detail"] != null && dt.Rows[0]["Hos_detail"].ToString() != "") { model.Hos_detail = dt.Rows[0]["Hos_detail"].ToString(); } if (dt.Rows[0]["Hos_how"] != null && dt.Rows[0]["Hos_how"].ToString() != "") { model.Hos_how = int.Parse(dt.Rows[0]["Hos_how"].ToString()); } if (dt.Rows[0]["Hos_title"] != null && dt.Rows[0]["Hos_title"].ToString() != "") { model.Hos_title = dt.Rows[0]["Hos_title"].ToString(); } } return(model); }
private void Hosmes_Load(object sender, EventArgs e) { BLL.Hos hos = new BLL.Hos(); //Model.Hos model = new Model.Hos();为新建model Model.Hos model = hos.HosMes(Hos_name); if (model == null) { MessageBox.Show("数据查询错误"); return; } else { label1.Text = model.Hos_Name; label2.Text = model.Hos_title; textBox1.Text = model.Hos_detail; label4.Text = model.Hos_how.ToString(); } }