private void btnImportUser_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(this.txtFilePath.Text)) { MessageBox.Show("请选择要导入的名单文件"); return; } int iRecords = 0; iRecords = FastInsertUser(this.txtFilePath.Text); MessageBox.Show("本次共导入记录数:" + iRecords.ToString()); fm.InitData(); FormShowUser_Load(sender, e); }
private void btnSave_Click(object sender, EventArgs e) { string prizeName = txtName.Text; if (string.IsNullOrEmpty(txtTotalNum.Text.Trim()) || string.IsNullOrEmpty(txtEveryNum.Text)) { MessageBox.Show("请输入抽奖总数及每次抽奖数!!", "信息提示", MessageBoxButtons.OK); return; } int totalNum = Convert.ToInt32(txtTotalNum.Text); int everyNum = Convert.ToInt32(txtEveryNum.Text); if (totalNum % everyNum != 0) { MessageBox.Show("请输入两个能整除的数!!", "信息提示", MessageBoxButtons.OK); return; } if (btnSave.Text == "添加") { string sqlStr = "INSERT INTO PrizeInfo(PrizeName,TotalNum,EveryNum) values(@PrizeName,@TotalNum,@EveryNum)"; SQLiteParameter[] parms = { new SQLiteParameter("@PrizeName", prizeName), new SQLiteParameter("@TotalNum", totalNum), new SQLiteParameter("@EveryNum", everyNum), }; if (SQLiteHelper.ExecuteNoQuery(sqlStr, parms) > 0) { btnCancel_Click(sender, e); FormPrizeSetting_Load(sender, e); } else { MessageBox.Show("添加失败!!"); return; } } else { //如果是修改,则需要主键id int id = Convert.ToInt32(txtId.Text); string sqlStr = "UPDATE PrizeInfo SET PrizeName = @PrizeName,TotalNum = @TotalNum,EveryNum = @EveryNum WHERE ID=@ID"; SQLiteParameter[] parms = { new SQLiteParameter("@ID", id), new SQLiteParameter("@PrizeName", prizeName), new SQLiteParameter("@TotalNum", totalNum), new SQLiteParameter("@EveryNum", everyNum) }; if (SQLiteHelper.ExecuteNoQuery(sqlStr, parms) > 0) { btnCancel_Click(null, null); FormPrizeSetting_Load(sender, e); } else { MessageBox.Show("修改失败"); return; } } fm.InitData(); }