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