private void Save_Click(object sender, EventArgs e) { var zjvalue = ZhanjieInput.Text; var goldvalue = GoldInput.Text; if (string.IsNullOrWhiteSpace(zjvalue) || string.IsNullOrWhiteSpace(goldvalue)) { MessageBox.Show("战阶、金不能为空!"); } else { var check = checkBoxJiesuan.Checked; var comValue = this.comboBoxUserList.SelectedItem as ComboBoxItem; int res = 0; //编辑 if (EditId != 0) { res = accessHelper.ExecuteNonQuery(string.Format("UPDATE YM_DETAIL SET [ZHANJIE] = {0}, [CREATETIME] = #{1}#, [YM_USER_ID] = {2}, [GOLD] = {3}, [BREAK] = '{4}', [JIESUAN] = {5} WHERE [ID] = {6};", zjvalue, dateTimePicker1.Value.ToString("yyyy/MM/dd"), comValue.Values, goldvalue, string.IsNullOrWhiteSpace(BreakInput.Text) ? "" : BreakInput.Text, check ? 1 : 0, EditId)); } //新增 else { res = accessHelper.ExecuteNonQuery(String.Format("INSERT INTO YM_DETAIL ([ZHANJIE], [CREATETIME], [YM_USER_ID], [GOLD], [BREAK], [JIESUAN]) VALUES ({0}, {1}, {2}, {3}, '{4}', {5});", zjvalue, dateTimePicker1.Value.ToString("yyyy/MM/dd"), comValue.Values, goldvalue, string.IsNullOrWhiteSpace(BreakInput.Text) ? "" : BreakInput.Text, check ? 1 : 0)); } if (res > 0) { MessageBox.Show("操作成功!"); form.SearchFunc(); Dispose(); } } }
private void Delete_Click(object sender, EventArgs e) { var selectListView = this.listView1.SelectedItems; if (selectListView.Count == 0) { MessageBox.Show(this, "请先选择一项!"); } else { try { if (MessageBox.Show(this, string.Format("是否要删除游戏昵称为【{0}】的这条数据?", selectListView[0].SubItems[selectListView[0].SubItems.Count - 3].Text), "警告", MessageBoxButtons.YesNo) == DialogResult.No) { return; } var id = selectListView[0].SubItems[selectListView[0].SubItems.Count - 1].Text; var res = accessHelper.ExecuteNonQuery(string.Format("DELETE FROM YM_USER WHERE [ID] = {0};", id)); if (res > 0) { SearchFunc(); //success } } catch (Exception ex) { Helper.ExMessage(ex); } } }