private void SKlV_SelectedIndexChanged(object sender, EventArgs e)
{
ListView lv = (ListView)sender;
int cnt = lv.SelectedItems.Count;
if (cnt >= 1)
{
ListViewItem item = lv.SelectedItems[0];
Access SKDB = new Access();
DataSet TableDS = new DataSet();
string SQLStr = string.Format(lawyersql, item.SubItems[0].Text);
SKDB.AddTableInDataSet(TableDS, "LawyersInfo", SQLStr);
//this.Photo. = TableDS.Tables[0].Rows["photourl"].ToString();
ShowPhoto(this.Photo, TableDS.Tables[0].Rows[0]["photourl"].ToString());
this.LawyerCredit.Text = TableDS.Tables[0].Rows[0]["lawcreditno"].ToString();
this.LawyerName.Text = TableDS.Tables[0].Rows[0]["xm"].ToString();
this.SWSName.Text = TableDS.Tables[0].Rows[0]["swsname"].ToString();
this.huiyuanbh.Text = TableDS.Tables[0].Rows[0]["mobile"].ToString();
//int subcnt = item.SubItems.Count;
//StringBuilder sb = new StringBuilder();
//for (int i = 0; i < subcnt; i++)
//{
// System.Windows.Forms.ListViewItem.ListViewSubItem subitem=item.SubItems[i];
// sb.Append(subitem.Name + "=" + subitem.Text);
// sb.Append("|||");
//}
//MessageBox.Show(sb.ToString());
}
//string text = lv.SelectedItems[0].Text;
//this.LawyerCredit.Text = text;
}
private void SchBtn_Click(object sender, EventArgs e)
{
Access SKDB = new Access();
DataSet TableDS = new DataSet();
string SQLStr = string.Format("select SWSName,XM,LawCreditNO,KH,bh,mobile from Lawyers where SWSName like '%{0}%'and XM like '%{1}%' and mobile like '%{2}%'order by SWSName,XM",
SWSNameTB.Text.Trim(), XMTB.Text.Trim(), lsbh.Text.Trim());
SKDB.AddTableInDataSet(TableDS, "LawyersInfo", SQLStr);
DGLawInfo.SetDataBinding(TableDS, "LawyersInfo");
DGLawInfo.TableStyles.Clear();
DGLawInfo.TableStyles.Add(LawInfoTableStyle);
}
