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);
}
}
}