private void dataUser_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string action = dataUser.Columns[e.ColumnIndex].Name;//操作类型
if (action == "caozuo")
{
string id = dataUser.Rows[e.RowIndex].Cells[9].Value.ToString();
MainWindow.userID = id;
UserDetail detail = new UserDetail();
detail.Show();
}
if (action == "shanchu")
{
if (MessageBox.Show("确认删除？") == DialogResult.OK)
{
string id = dataUser.Rows[e.RowIndex].Cells[9].Value.ToString();
string sql = "delete [user] where id='" + id + "'";
MainConfig.Excute(sql);
DataSet ds = MainConfig.GetRecord("select * from [User]");
dataUser.AutoGenerateColumns = false;
dataUser.AllowUserToAddRows = false;
dataUser.DataSource = ds.Tables[0].DefaultView;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
string sql = "update [word] set word='" + word.Text + "',yinbiao='" + this.yinbiao.Text + "',Type='" + wordtype.Text + "',Translate='" + translate.Text + "',fenzu='" + fenzu.Text + "' where id='" + MainWindow.wordID + "'";
MainConfig.Excute(sql);
MessageBox.Show("保存成功！");
}
private void button1_Click(object sender, EventArgs e)
{
string sql = "insert into word(word,yinbiao,translate,type,fenzu,zhongwenyuyin,YingWenYuYan,SuoXie) values('" + word.Text + "','" + yinbiao.Text + "','" + translate.Text + "','" + wordtype.Text + "','" + fenzu.Text + "','" + textBox1.Text + "','" + textBox2.Text + "','" + txtSuoXie.Text + "')";
MainConfig.Excute(sql);
MessageBox.Show("添加成功！");
}
private void button1_Click(object sender, EventArgs e)
{
string type = UserType.Text == "管理员" ? "1" : "2";
string sql = "update [User] set IdCard='" + IdCard.Text + "',Birthday='" + this.Birthday.Text + "',Sex='" + Sex.Text + "',RealName='" + realName.Text + "',Email='" + Email.Text + "',Telephone='" + Telephone.Text + "',Remark='" + remark.Text + "',UserType='" + type + "' where id='" + MainWindow.userID + "'";
MainConfig.Excute(sql);
MessageBox.Show("保存成功！");
}
private void dataSC_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string action = dataSC.Columns[e.ColumnIndex].Name; //操作类型
if (action == "deleteStrage")
{
if (MessageBox.Show("确认删除？") == DialogResult.OK)
{
string id = dataSC.Rows[e.RowIndex].Cells[5].Value.ToString();
string sql = "delete Storage where id='" + id + "'";
MainConfig.Excute(sql);
DataSet ds = MainConfig.GetRecord("select Storage.ID as aid,word.* from Storage inner join Word on word.ID=Storage.wordID where Storage.UserID='" + MainConfig.Userds.Tables[0].Rows[0]["ID"].ToString() + "' and word.word like '%" + SCTXT.Text + "%'");
dataSC.AutoGenerateColumns = false;
dataSC.AllowUserToAddRows = false;
dataSC.DataSource = ds.Tables[0].DefaultView;
}
}
}
private void button1_Click(object sender, EventArgs e)
{
string exist = "select * from [User] where username='******'";
DataSet ds = MainConfig.GetRecord(exist);
if (ds.Tables[0].Rows.Count > 0)
{
MessageBox.Show("该用户名已注册！");
return;
}
if (pass.Text == string.Empty || pass.Text != confirm.Text)
{
MessageBox.Show("密码输入不正确！");
}
string sql = "insert into [User](UserName,PassWord,IdCard,Birthday,Sex,RealName,Email,Telephone,Remark,UserType) values('" + UserName.Text + "','" + pass.Text + "','" + IdCard.Text + "','" + this.Birthday.Text + "','" + Sex.Text + "','" + realName.Text + "','" + Email.Text + "','" + Telephone.Text + "','" + remark.Text + "',2)";
//string sql = "update [User] set IdCard='" + IdCard.Text + "',Birthday='" + this.Birthday.Text + "',Sex='" + Sex.Text + "',RealName='" + realName.Text + "',Email='" + Email.Text + "',Telephone='" + Telephone.Text + "',Remark='" + remark.Text + "',UserType='" + type + "' where id='" + MainWindow.userID + "'";
MainConfig.Excute(sql);
MessageBox.Show("注册成功！");
}
private void dataFenzu_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
string action = dataFenzu.Columns[e.ColumnIndex].Name;//操作类型
if (action == "StorageBtn")
{
string id = dataFenzu.Rows[e.RowIndex].Cells[4].Value.ToString();
string sql = "select * from Storage where UserId='" + MainConfig.Userds.Tables[0].Rows[0]["ID"].ToString() + "' and wordID='" + id + "'";
DataSet ds = MainConfig.GetRecord(sql);
if (ds.Tables[0].Rows.Count > 0)
{
MessageBox.Show("您已收藏过该单词！");
}
else
{
string sql1 = "insert into Storage(UserID,UserName,WordID,WordName) values('" + MainConfig.Userds.Tables[0].Rows[0]["ID"].ToString() + "','" + MainConfig.Userds.Tables[0].Rows[0]["UserName"].ToString() + "','" + id + "','" + dataFenzu.Rows[e.RowIndex].Cells[0].Value.ToString() + "')";
MainConfig.Excute(sql1);
MessageBox.Show("收藏成功！");
}
}
}
private void button14_Click(object sender, EventArgs e)
{
DataTable dt = ConvertCSVToTable(this.textBox3.Text);
foreach (DataRow dr in dt.Rows)
{
try
{
DataSet dsds = MainConfig.GetRecord("select * from Word where Word='" + dr[0].ToString() + "'");
if (dsds != null && dsds.Tables[0].Rows.Count > 0)
{
}
else
{
string sql = "insert into word(word,translate,type) values('" + dr[0].ToString() + "','" + dr[2].ToString() + "','" + dr[1].ToString() + "')";
MainConfig.Excute(sql);
}
}
catch
{
}
}
MessageBox.Show("数据导入完毕");
}