public static DisplayMessageModel getDisplay(int TypeBianHao)
{
DisplayMessageModel message = new DisplayMessageModel();
message.TypeBianHao = TypeBianHao;
try
{
initConnection();
}
catch (Exception e)
{
throw e;
}
com.CommandText = "select MiaoShu,TuPianBianHao,TuPianMiaoShu,GongNengBianHao,GongNengMiaoShu from 粮食种类描述表,粮食图片描述表,粮食功能描述表 where 粮食种类描述表.TypeBianHao = " + TypeBianHao + "and 粮食图片描述表.TypeBianHao = " + TypeBianHao + "and 粮食功能描述表.TypeBianHao =" + TypeBianHao;
dr = com.ExecuteReader();
while (dr.Read())
{
message.TypeMiaoShu = Convert.ToString(dr["miaoshu"]);
message.TuPianBianHao.Add(Convert.ToInt16(dr["TuPianBianHao"]));
message.TuPianMiaoShu.Add(Convert.ToString(dr["TuPianMiaoShu"]));
message.GongNengBianHao.Add(Convert.ToInt16(dr["GongNengBianHao"]));
message.GongNengMiaoShu.Add(Convert.ToString(dr["GongNengMiaoShu"]));
}
dr.Close(); //关闭执行
sqlCon.Close(); //关闭数据库
return(message);
}
public void getMiaoShu()
{
try
{
RiceMessage = SqlData.getDisplay(2);
CoreMessage = SqlData.getDisplay(1);
WheateMessage = SqlData.getDisplay(3);
}
catch (Exception e)
{
throw e;
}
}