包括保存和加载
//查找业务类型
DataTable dtyewu = sb.SelectSyscode(0, true);
if (dtyewu.Rows.Count > 0)
{
flagcbb = false;
clb_yewu.DataSource = dtyewu;
clb_yewu.DisplayMember = "name";
clb_yewu.ValueMember = "id";
DataRowView dr = clb_yewu.Items[0] as DataRowView;
dtyewuleixingbind(dr["id"].ToString(), true);
flagcbb = true;
}
biz = rc.Bizid.Split(';');
pit = rc.Pid.Split(';');
selectcbb();
loadbing();
private void selectcbb()
{
int m = 0;
for (int j = 0; j < clb_yewu.Items.Count; j++)
{
DataRowView dr = clb_yewu.Items[j] as DataRowView;
for (int i = 0; i < biz.Length; i++)
{
if (dr["id"].ToString() == biz[i])
{
clb_yewu.SetItemChecked(j, true);
break;
}
}
}
}
/// <summary>
/// 所有平台信息
/// </summary>
private void selectPingtai()
{
string m;
string[] pt;
DataTable dtapt = sb.SelectAllPingTai();
dtallpt.Columns.Add("id", typeof(Int32));
dtallpt.Columns.Add("cd", typeof(string));
dtallpt.Columns.Add("name", typeof(string));
for (int i = 0; i < dtapt.Rows.Count; i++)
{
m = dtapt.Rows[i][0].ToString();
pt = m.Split(';');
foreach (string ptf in pt)
{
DataRow dr = dtallpt.NewRow();
dr["id"] = dtapt.Rows[i][1].ToString();
dr["cd"] = ptf;
dr["name"] = dtapt.Rows[i][2].ToString();
dtallpt.Rows.Add(dr);
}
}
}
private void clb_yewu_SelectedIndexChanged(object sender, EventArgs e) { if (flagcbb) { string cdd = ""; int m = clb_yewu.SelectedIndex; if (clb_yewu.CheckedItems.IndexOf(clb_yewu.Items[m]) >= 0) dtyewuleixingbind(clb_yewu.SelectedValue.ToString(), true); if (clb_yewu.CheckedItems.IndexOf(clb_yewu.Items[m]) <= 0) { dtyewuleixingbind(clb_yewu.SelectedValue.ToString(), false); } } } private void clb_SelectedIndexChanged(object sender, EventArgs e) { int m = ((CheckedListBox)sender).SelectedIndex; if (((CheckedListBox)sender).CheckedItems.IndexOf(((CheckedListBox)sender).Items[m]) >= 0) { for (int j = 0; j < clb_yewu.Items.Count; j++) { DataRowView dr = clb_yewu.Items[j] as DataRowView; if (dr["id"].ToString() == ((CheckedListBox)sender).Name) { clb_yewu.SetItemChecked(j, true); break; } } } } /// <summary> /// 筛选平台 /// </summary> /// <param name="id"></param> /// <returns></returns> private DataTable selectdypt(string id) { DataRow[] drArr = dtallpt.Select("cd ='" + id + "'"); DataTable dtNew = dtallpt.Clone(); for (int i = 0; i < drArr.Length; i++) { dtNew.ImportRow(drArr[i]); } return dtNew; } /// <summary> /// 绑定平台 /// </summary> /// <param name="id"></param> private void dtyewuleixingbind(string id, bool select) //xu { //DataTable dtpingtai = sb.SelectPingtai(cdd); DataTable dtpingtai = selectdypt(id); bool flag = false; foreach (Control con in panel2.Controls) { if (con.Name == id) { con.Visible = true; flag = true; if (!select) { for (int j = 0; j < ((CheckedListBox)con).Items.Count; j++) ((CheckedListBox)con).SetItemChecked(j, false); } } else { con.Visible = false; } } if (!flag) { CheckedListBox clb_yewu = new CheckedListBox(); clb_yewu.Name = id; clb_yewu.Visible = true; if (dtpingtai.Rows.Count > 0) { clb_yewu.DataSource = dtpingtai; clb_yewu.DisplayMember = "name"; clb_yewu.ValueMember = "id"; clb_yewu.SelectedIndexChanged += new EventHandler(clb_SelectedIndexChanged); } Size ss = new Size(200, 150); clb_yewu.Size = ss; clb_yewu.CheckOnClick = true; panel2.Controls.Add(clb_yewu); } } #region 修改个人信息平台加载 /// <summary> /// 平台数据加载 /// </summary> private void loadbing() { if (uid > 0) { for (int z = 0; z < biz.Length; z++) { DataTable dtpingtai = selectdypt(biz[z]); CheckedListBox clb_yewu = new CheckedListBox(); clb_yewu.Name = biz[z]; clb_yewu.Visible = true; if (dtpingtai.Rows.Count > 0) { clb_yewu.DataSource = dtpingtai; clb_yewu.DisplayMember = "name"; clb_yewu.ValueMember = "id"; } Size ss = new Size(200, 150); clb_yewu.Size = ss; panel2.Controls.Add(clb_yewu); } ptbinding(); } } /// <summary> /// 选中对应数据库项 /// </summary> private void ptbinding() { int i = 0; foreach (Control c in panel2.Controls) { i = 0; for (int j = 0; j < ((CheckedListBox)c).Items.Count; j++) { DataRowView dr = ((CheckedListBox)c).Items[j] as DataRowView; if (pit != null) foreach (string pt in pit) { string[] p = pt.Split('-'); if (dr["cd"].ToString() == p[0]) if (dr["id"].ToString() == p[1]) { ((CheckedListBox)c).SetItemChecked(i, true); break; } } i++; } } }