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();
}
}
