110,539
社区成员
发帖
与我相关
我的任务
分享
switch (ds.Tables[0].Rows[0]["CakeName"].ToString())
{
case "水果蛋糕":
txt_kind.Text = ds.Tables[0].Rows[0]["CakeName"].ToString();
txt_Size.Text= ds.Tables[0].Rows[0]["CakeSize"].ToString();
break;
case "鲜奶油蛋糕":
txt_kind.Text = ds.Tables[0].Rows[0]["CakeName"].ToString();
txt_Size.Text = ds.Tables[0].Rows[0]["CakeSize"].ToString();
break;
case "巧克力蛋糕":
txt_kind.Text = ds.Tables[0].Rows[0]["CakeName"].ToString();
txt_Size.Text = ds.Tables[0].Rows[0]["CakeSize"].ToString();
break;
case "镜面蛋糕":
txt_kind.Text = ds.Tables[0].Rows[0]["CakeName"].ToString();
txt_Size.Text = ds.Tables[0].Rows[0]["CakeSize"].ToString();
break;
default:
break;
IDictionary<string, object> dic = new Dictionary<string, object>();
dic.Add("bh", bh);
Bitmap bitmap = cardHelper.GetZP(dic);
this.pictureBox1.Image = bitmap;
/// <summary>
/// 根据条件查询照片
/// </summary>
/// <param name="dic">查询条件封装的字典</param>
/// <returns>照片Bitmap</returns>
public Bitmap GetZP(IDictionary<string, object> dic)
{
string sql = "select * from xxb where 1=1 ";
if (dic.ContainsKey("bh"))
{
sql += " and id = " + Convert.ToInt32(dic["bh"]) + "";
}
if (dic.ContainsKey("xm"))
{
sql += " and 姓名 = '" + Convert.ToString(dic["xm"]) + "'";
}
if (dic.ContainsKey("sfzh"))
{
sql += " and 证件号码 = '" + Convert.ToString(dic["sfzh"]) + "'";
}
using (IDataReader odr = accessOp.ExecuteReader(sql))
{
if (odr.Read())
{
if (!string.IsNullOrEmpty(odr["照片信息"].ToString()))
{
byte[] bytes = (byte[])odr["照片信息"];
using (MemoryStream ms = new MemoryStream(bytes) { Position = 0 })
{
return new Bitmap(ms);
}
}
}
}
return null;
}