private void FrmCate_Load(object sender, EventArgs e)
{
lcs.Add(new Cate()
{
id = 0,
name = "一级菜单",
password = "",
});
getCate();
foreach (Cate c in lcs)
{
dSkinComboBox1.AddItem(c.name);
}
if (id > 0)
{
Cate cs = LoadCate();
if (cs != null)
{
dSkinTextBox1.Text = cs.name;
for (int i = 0; i < lcs.Count(); i++)
{
if (lcs[i].id == cs.pid)
{
dSkinComboBox1.SelectedIndex = i;
break;
}
}
}
dSkinComboBox1.Enabled = false;
}
else
{
dSkinComboBox1.SelectedIndex = 0;
}
}
private Cate LoadCate()
{
Cate c = new Cate();
StringBuilder sql = new StringBuilder();
sql.Append("select id,pid,name,password from password_category where id=" + id + " limit 1");
DataSet ds = Common.SQLiteHelper.ExecuteDataSet(sql.ToString(), CommandType.Text);
foreach (DataRow mDr in ds.Tables[0].Rows)
{
c.id = Convert.ToInt32(mDr[0].ToString());
c.pid = Convert.ToInt32(mDr[1].ToString());
c.name = mDr[2].ToString();
c.password = mDr[3].ToString();
}
return(c);
}
