public void Main_Load(object sender, EventArgs e)//初始化加载
{
sql = new SqlHelp("data source=mydb.db");
sql.CreateTable("tongxunlu", new string[] { "Name", "Phone", "Groups", "Email", "QQ", "Weixin", "Info" }, new string[] { "TEXT", "TEXT", "TEXT", "TEXT", "TEXT", "TEXT", "TEXT" });
//读取整张表
SQLiteDataReader reader = sql.ReadFullTable("tongxunlu");
this.ListView.BeginUpdate(); //数据更新，UI暂时挂起，直到EndUpdate绘制控件，可以有效避免闪烁并大大提高加载速度
while (reader.Read())
{
ListViewItem lvi = new ListViewItem();
lvi.Text = reader.GetString(reader.GetOrdinal("Name"));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Phone")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Groups")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Email")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("QQ")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Weixin")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Info")));
this.ListView.Items.Add(lvi);
}
this.ListView.EndUpdate(); //结束数据处理，UI界面一次性绘制。 sql.CloseConnection();
sql.CloseConnection();
ImageList imgList = new ImageList();
imgList.ImageSize = new Size(1, 35);//分别是宽和高
ListView.SmallImageList = imgList;
}
private void XJButton_Click(object sender, EventArgs e)//新建通讯录
{
Add f2 = new Add();
f2.ShowDialog();
if (f2.DialogResult == DialogResult.OK)
{
ListView.Items.Clear();
sql = new SqlHelp("data source=mydb.db");
//读取整张表
SQLiteDataReader reader = sql.ReadFullTable("tongxunlu");
this.ListView.BeginUpdate(); //数据更新，UI暂时挂起，直到EndUpdate绘制控件，可以有效避免闪烁并大大提高加载速度
while (reader.Read())
{
ListViewItem lvi = new ListViewItem();
lvi.Text = reader.GetString(reader.GetOrdinal("Name"));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Phone")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Groups")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Email")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("QQ")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Weixin")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Info")));
this.ListView.Items.Add(lvi);
}
this.ListView.EndUpdate(); //结束数据处理，UI界面一次性绘制。 sql.CloseConnection();
sql.CloseConnection();
ImageList imgList = new ImageList();
imgList.ImageSize = new Size(1, 35);//分别是宽和高
ListView.SmallImageList = imgList;
}
}
private void SCButton_Click(object sender, EventArgs e)//删除通讯录
{
sql = new SqlHelp("data source=mydb.db");
if (ListView.SelectedItems.Count > 0)
{
string name = this.ListView.FocusedItem.SubItems[0].Text;
sql.DeleteValuesAND("tongxunlu", new string[] { "Name" }, new string[] { name }, new string[] { "=" });
ListView.Items.Clear();
//读取整张表
SQLiteDataReader reader = sql.ReadFullTable("tongxunlu");
this.ListView.BeginUpdate(); //数据更新，UI暂时挂起，直到EndUpdate绘制控件，可以有效避免闪烁并大大提高加载速度
while (reader.Read())
{
ListViewItem lvi = new ListViewItem();
lvi.Text = reader.GetString(reader.GetOrdinal("Name"));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Phone")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Groups")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Email")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("QQ")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Weixin")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Info")));
this.ListView.Items.Add(lvi);
}
this.ListView.EndUpdate(); //结束数据处理，UI界面一次性绘制。 sql.CloseConnection();
sql.CloseConnection();
ImageList imgList = new ImageList();
imgList.ImageSize = new Size(1, 35);//分别是宽和高
ListView.SmallImageList = imgList;
MessageBox.Show("删除成功");
}
}
private void Listfenzu_Click(object sender, EventArgs e)
{
if (this.Listfenzu.SelectedItems.Count > 0)
{
sql = new SqlHelp("data source=mydb.db");
ListView.Items.Clear();
SQLiteDataReader reader = sql.ReadFullTable("tongxunlu");
this.ListView.BeginUpdate(); //数据更新，UI暂时挂起，直到EndUpdate绘制控件，可以有效避免闪烁并大大提高加载速度
while (reader.Read())
{
if (reader.GetString(reader.GetOrdinal("Groups")) == Listfenzu.SelectedItem.ToString())
{
ListViewItem lvi = new ListViewItem();
lvi.Text = reader.GetString(reader.GetOrdinal("Name"));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Phone")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Groups")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Email")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("QQ")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Weixin")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Info")));
this.ListView.Items.Add(lvi);
}
}
this.ListView.EndUpdate(); //结束数据处理，UI界面一次性绘制。 sql.CloseConnection();
sql.CloseConnection();
ImageList imgList = new ImageList();
imgList.ImageSize = new Size(1, 35);//分别是宽和高
ListView.SmallImageList = imgList;
}
}
public Main()
{
InitializeComponent();
sql = new SqlHelp("data source=mydb.db");//初始化加分组
SQLiteDataReader reader = sql.ReadFullTable("fenzu");
while (reader.Read())
{
Listfenzu.Items.Add(reader.GetString(reader.GetOrdinal("Name")));
}
sql.CloseConnection();
}
private void Delfenlei_Click(object sender, EventArgs e)//删除分组
{
sql = new SqlHelp("data source=mydb.db");
sql.DeleteValuesAND("fenzu", new string[] { "Name" }, new string[] { Listfenzu.SelectedItem.ToString() }, new string[] { "=" });
Listfenzu.Items.Clear();
SQLiteDataReader reader = sql.ReadFullTable("fenzu");
while (reader.Read())
{
Listfenzu.Items.Add(reader.GetString(reader.GetOrdinal("Name")));
}
sql.CloseConnection();
MessageBox.Show("删除成功");
}
public Add()
{
InitializeComponent();
sql = new SqlHelp("data source=mydb.db");
SQLiteDataReader reader = sql.ReadFullTable("fenzu");
while (reader.Read())
{
int i = 0;
tfenlei.Items.Insert(i, reader.GetString(reader.GetOrdinal("Name")));
i++;
}
sql.CloseConnection();
}
private void SouOK_Click(object sender, EventArgs e)
{
if (SouContent.Text.Trim().Length == 0)
{
MessageBox.Show("请务必选择分组");
}
else
{
string SouFenzu = SouContent.SelectedItem.ToString();
if (SouFenzu == "姓名")
{
SouFenzu = "Name";
}
if (SouFenzu == "手机号")
{
SouFenzu = "Phone";
}
if (SouFenzu == "邮箱")
{
SouFenzu = "Email";
}
if (SouFenzu == "QQ")
{
SouFenzu = "QQ";
}
if (SouFenzu == "微信")
{
SouFenzu = "Weixin";
}
sql = new SqlHelp("data source=mydb.db");
//string strsql = "SELECT FROM tongxunlu WHERE " + SouFenzu + "=" + "'" + SuoContent.Text + "'";
//不会写，最后干脆线搜索全表，显示需要的信息，反正数据不多！
SQLiteDataReader reader = sql.ReadFullTable("tongxunlu");
bool tf = false;
while (reader.Read())
{
if (reader.GetString(reader.GetOrdinal(SouFenzu)) == SuoContent.Text)
{
MessageBox.Show("（姓名：" + reader.GetString(reader.GetOrdinal("Name")) + "）" + "（手机号：" + reader.GetString(reader.GetOrdinal("Phone")) + "）" + "（邮箱：" + reader.GetString(reader.GetOrdinal("Email")) + "）" + "（QQ：" + reader.GetString(reader.GetOrdinal("QQ")) + "）" + "（微信：" + reader.GetString(reader.GetOrdinal("Weixin")) + "）");
tf = true;
}
}
if (!tf)
{
MessageBox.Show("没有查询到内容！");
}
sql.CloseConnection();
}
}
private void Newfenlei_Click(object sender, EventArgs e)//添加分组
{
Newfenlei f = new Newfenlei();
f.ShowDialog();
if (f.DialogResult == DialogResult.OK)
{
Listfenzu.Items.Clear();
sql = new SqlHelp("data source=mydb.db");
SQLiteDataReader reader = sql.ReadFullTable("fenzu");
while (reader.Read())
{
Listfenzu.Items.Add(reader.GetString(reader.GetOrdinal("Name")));
}
sql.CloseConnection();
}
}
public XGview()
{
InitializeComponent();
tname.Text = InfoClass.TName;
tphone.Text = InfoClass.Phone;
temail.Text = InfoClass.Email;
tqq.Text = InfoClass.QQ;
tweixin.Text = InfoClass.Weixin;
tbeizhu.Text = InfoClass.Info;
sql = new SqlHelp("data source=mydb.db");
SQLiteDataReader reader = sql.ReadFullTable("fenzu");
while (reader.Read())
{
int i = 0;
tfenlei.Items.Insert(i, reader.GetString(reader.GetOrdinal("Name")));
i++;
}
sql.CloseConnection();
}
private void XGButton_Click(object sender, EventArgs e)
{
if (ListView.SelectedItems.Count > 0)
{
InfoClass.TName = ListView.FocusedItem.SubItems[0].Text;
InfoClass.Phone = ListView.FocusedItem.SubItems[1].Text;
InfoClass.Email = ListView.FocusedItem.SubItems[3].Text;
InfoClass.QQ = ListView.FocusedItem.SubItems[4].Text;
InfoClass.Weixin = ListView.FocusedItem.SubItems[5].Text;
InfoClass.Info = ListView.FocusedItem.SubItems[6].Text;
XGview f = new XGview();
f.ShowDialog();
if (f.DialogResult == DialogResult.OK)
{
sql = new SqlHelp("data source=mydb.db");
ListView.Items.Clear();
//读取整张表
SQLiteDataReader reader = sql.ReadFullTable("tongxunlu");
this.ListView.BeginUpdate(); //数据更新，UI暂时挂起，直到EndUpdate绘制控件，可以有效避免闪烁并大大提高加载速度
while (reader.Read())
{
ListViewItem lvi = new ListViewItem();
lvi.Text = reader.GetString(reader.GetOrdinal("Name"));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Phone")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Groups")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Email")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("QQ")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Weixin")));
lvi.SubItems.Add(reader.GetString(reader.GetOrdinal("Info")));
this.ListView.Items.Add(lvi);
}
this.ListView.EndUpdate(); //结束数据处理，UI界面一次性绘制。 sql.CloseConnection();
sql.CloseConnection();
ImageList imgList = new ImageList();
imgList.ImageSize = new Size(1, 35);//分别是宽和高
ListView.SmallImageList = imgList;
MessageBox.Show("修改成功");
}
}
}
