//确认提交新业主 private void TbtnUploadData_Click(object sender, RoutedEventArgs e) { if (TtxtCompanyName.Text == string.Empty || TtxtWindFieldName.Text == string.Empty || TtxtTableName.Text == string.Empty || TtxtProvince.Text == string.Empty || TtxtCity.Text == string.Empty) { MessageBox.Show("必填项不可为空,请填写完整后重试!", "提示", MessageBoxButton.OK, MessageBoxImage.Warning); return; } //检测该业主是否已在数据库存在 int isExistOfCompany = AllWindFieldDAL.IsExistOfCompany(TtxtCompanyName.Text); if (isExistOfCompany > 0) { MessageBox.Show("该业主已经在数据库里存在,无需再次添加!", "提示", MessageBoxButton.OK, MessageBoxImage.Warning); return; } //判断输入的数据表名是否在数据库里已经存在 int isExistOfTable = AllWindFieldDAL.IsExistOfTable(TtxtTableName.Text); if (isExistOfTable > 0) { MessageBox.Show("该数据表名已经在数据库里存在,请更改后重试!", "提示", MessageBoxButton.OK, MessageBoxImage.Error); return; } //创建风场对象 AllWindField newWindField = new AllWindField(); newWindField.BranchTableName = TtxtTableName.Text; newWindField.CompanyName = TtxtCompanyName.Text; newWindField.WindFieldName = TtxtWindFieldName.Text; newWindField.Province = TtxtProvince.Text; newWindField.City = TtxtCity.Text; newWindField.DetailAddress = TtxtDetailAddress.Text; newWindField.FanType = TtxtFanType.Text; newWindField.FanCount = 0; newWindField.FanModelNumber = TtxtFanModelNumber.Text; newWindField.FanHeight = TtxtFanHeight.Text; newWindField.AnemoscopeModelNumber = TtxtAnemoscopeModelNumber.Text; newWindField.SignalKind = TtxtSignalKind.Text; //上传数据 int insertResult = AllWindFieldDAL.InsertData(newWindField); if (insertResult <= 0) { MessageBox.Show("数据提交失败,请检查网络或数据库连接是否正常!", "提示", MessageBoxButton.OK, MessageBoxImage.Warning); return; } //创建对应公司的表格 AllWindFieldDAL.CreateTable(TtxtTableName.Text); MessageBox.Show("恭喜您,新业主添加成功!", "提示", MessageBoxButton.OK, MessageBoxImage.Warning); }
//确认提交新风场 private void btnUploadData_Click(object sender, RoutedEventArgs e) { if (cmbCompanyName.SelectedItem == null || txtWindFieldName.Text == string.Empty || txtProvince.Text == string.Empty || txtCity.Text == string.Empty) { MessageBox.Show("必填项不可为空,请填写完整后重试!", "提示", MessageBoxButton.OK, MessageBoxImage.Warning); return; } //检测该风场是否已在数据库存在 AllWindField awf = AllWindFieldDAL.GetWindFieldByName(cmbCompanyName.SelectedItem.ToString(), txtWindFieldName.Text); if (awf != null) { MessageBox.Show("该风场已经在数据库里存在,请检查风场名是否正确!", "提示", MessageBoxButton.OK, MessageBoxImage.Warning); return; } //根据选中的业主名获取公司数据库表名 string tableName = AllWindFieldDAL.GetTableName(cmbCompanyName.SelectedItem.ToString()); //创建风场对象 AllWindField newWindField = new AllWindField(); newWindField.BranchTableName = tableName; newWindField.CompanyName = cmbCompanyName.SelectedItem.ToString(); newWindField.WindFieldName = txtWindFieldName.Text; newWindField.Province = txtProvince.Text; newWindField.City = txtCity.Text; newWindField.DetailAddress = txtDetailAddress.Text; newWindField.FanType = txtFanType.Text; newWindField.FanCount = 0; newWindField.FanModelNumber = txtFanModelNumber.Text; newWindField.FanHeight = txtFanHeight.Text; newWindField.AnemoscopeModelNumber = txtAnemoscopeModelNumber.Text; newWindField.SignalKind = txtSignalKind.Text; //上传数据 int insertResult = AllWindFieldDAL.InsertData(newWindField); if (insertResult <= 0) { MessageBox.Show("数据提交失败,请检查网络或数据库连接是否正常!", "提示", MessageBoxButton.OK, MessageBoxImage.Warning); return; } else { MessageBox.Show("恭喜您,新风场添加成功!", "提示", MessageBoxButton.OK, MessageBoxImage.Warning); return; } }