private void btnSubmit_Click(object sender, System.EventArgs e) { try { AssignValueToData(); } catch (Exception e1) { MessageBox.Show(e1.Message); return; } if (this.number == -1 && this.monthCount == -1 && this.totalMoney == -1 && this.subscription == "汤" && this.client == "华" && this.startDate == DateTime.Parse("1000-1-1") && this.endDate == DateTime.Parse("1000-1-1") && this.giveDate == DateTime.Parse("1000-1-1")) { MessageBox.Show("请输入一个要批量修改的值!"); return; } if (MessageBox.Show("是否确认要批量修改?", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { BatchUpdateSelectedRows(); MainForm.Form.CurrentDataSet = SubscribeInfoManager.RetriveDataFromTempInfo(); this.DialogResult = DialogResult.OK; this.Close(); } }
bool DeleteSelectedRows() { if (TestSelectedRows() == false) { MessageBox.Show("请选中一行进行删除!"); return(false); } if (MessageBox.Show("删除后不能恢复,是否删除?", "警告", MessageBoxButtons.YesNo, MessageBoxIcon.Information, MessageBoxDefaultButton.Button2) == DialogResult.Yes) { for (int i = 0; i < this.currentDataSet.Tables[0].Rows.Count; i++) //通过循环删除所有被选中的行 { if (this.dataGrid1.IsSelected(i) == true) { string name = this.currentDataSet.Tables[0].Rows[i]["姓名"].ToString(); string company = this.currentDataSet.Tables[0].Rows[i]["公司"].ToString(); SubscribeInfoManager.DeleteSubscribeInfo(name, company); } } this.currentDataSet = SubscribeInfoManager.RetriveDataFromTempInfo(); return(true); } else { return(false); } }
private void btnSubmit_Click(object sender, System.EventArgs e) { try { if (this.cmbRegion.SelectedValue != null) { if (this.cmbRegion.SelectedValue.ToString().Trim() == "") { MessageBox.Show("地区不能为空!"); return; } } else { MessageBox.Show("地区不能为空!"); return; } GetValues(); int id = SubscribeInfoManager.CreateSubscribeInfo(name, post, company, address, region, postcode, telephone, mobilePhone, startDate, endDate, giveDate, number, monthCount, totalMoney, inscribe, source, payment, invoice, client, operator1, bonus, localAddress, subscription); if (id == 1) //添加成功 { MainForm.Form.CurrentDataSet = SubscribeInfoManager.RetriveDataFromTempInfo(); this.DialogResult = DialogResult.OK; this.Close(); } else //添加失败 { MessageBox.Show("已经存在该记录!"); } } catch (Exception e1) { MessageBox.Show(e1.Message); } }
bool ImportExcelData() { openFileDialog1.Filter = "Excel数据文件|*.xls"; openFileDialog1.RestoreDirectory = true; if (openFileDialog1.ShowDialog() == DialogResult.OK) { DataSet ds = null; DataTable tempTable = null; try { ds = GetData(openFileDialog1.FileName); CheckTableFormat(ds.Tables[0]); } catch (Exception e) { MessageBox.Show(e.Message); return(false); } //到这里为止,说明Excel表中字段的结构已经正确 //1.检查Excel中是否有重复的记录 tempTable = CheckDataReduplicateInExcel(ds.Tables[0]); if (tempTable.Rows.Count > 0) { DataSet tempDs = new DataSet(); tempDs.Tables.Add(tempTable); //跳出一个窗体,显示Excel表格中重复的记录 TempForm tempForm = new TempForm("以下" + tempDs.Tables[0].Rows.Count + "条记录在Excel表中有重复,请核对后再导入"); tempForm.CurrentDataSet = tempDs; tempForm.StartPosition = FormStartPosition.CenterParent; tempForm.ShowDialog(); return(false); } //2.检查Excel中是否有和数据库重复的记录 tempTable = CheckDataReduplicateWithDatabase(ds.Tables[0]); if (tempTable.Rows.Count > 0) { DataSet tempDs = new DataSet(); tempDs.Tables.Add(tempTable); //跳出一个窗体,显示与数据库中记录重复的记录 TempForm tempForm = new TempForm("以下" + tempDs.Tables[0].Rows.Count + "条记录在数据库中已存在,请核对后再导入"); tempForm.CurrentDataSet = tempDs; tempForm.StartPosition = FormStartPosition.CenterParent; tempForm.ShowDialog(); return(false); } //到这里可以安全的将数据导入到数据库 ImportDataToDatabase(ds.Tables[0]); this.currentDataSet = SubscribeInfoManager.RetriveDataFromTempInfo(); return(true); } return(false); }