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); } }
void ImportDataToDatabase(DataTable sourceTable) { SubscribeInfoManager.ClearTempInfo(); foreach (DataRow row in sourceTable.Rows) { DateTime startDate = DateTime.Parse("1900-1-1"); DateTime endDate = DateTime.Parse("1900-1-1"); DateTime giveDate = DateTime.Parse("1900-1-1"); int number = -1; int monthCount = -1; int totalMoney = -1; string name; string localAddress; string company; string subscription; string post; string region; string address; string postcode; string mobilePhone; string telephone; string inscribe; string source; string payment; string invoice; string client; string operator1; string bonus; if (row["起始日期"] != DBNull.Value) { startDate = DateTime.Parse(row["起始日期"].ToString().Trim()); //注意:这里一定能够转换,因为如果格式不正确则它的值必定为DBNull.Value } if (row["结束日期"] != DBNull.Value) { endDate = DateTime.Parse(row["结束日期"].ToString().Trim()); //同上 } if (row["付款日期"] != DBNull.Value) { giveDate = DateTime.Parse(row["付款日期"].ToString().Trim()); //同上 } if (row["份数"] != DBNull.Value) { number = Int32.Parse(row["份数"].ToString()); //同上 } if (row["期数"] != DBNull.Value) { monthCount = Int32.Parse(row["期数"].ToString()); //同上 } if (row["金额"] != DBNull.Value) { totalMoney = Int32.Parse(row["金额"].ToString()); //同上 } name = row["姓名"].ToString().Trim() == String.Empty ? " " : row["姓名"].ToString().Trim(); localAddress = row["县级地区"].ToString().Trim() == String.Empty ? " " : row["县级地区"].ToString().Trim(); region = row["地区"].ToString().Trim() == String.Empty ? " " : row["地区"].ToString().Trim(); company = row["公司"].ToString().Trim() == String.Empty ? " " : row["公司"].ToString().Trim(); subscription = row["订阅形式"].ToString().Trim() == String.Empty ? " " : row["订阅形式"].ToString().Trim(); post = row["职位"].ToString().Trim() == String.Empty ? " " : row["职位"].ToString().Trim(); address = row["地址"].ToString().Trim() == String.Empty ? " " : row["地址"].ToString().Trim(); postcode = row["邮编"].ToString().Trim() == String.Empty ? " " : row["邮编"].ToString().Trim(); mobilePhone = row["手机"].ToString().Trim() == String.Empty ? " " : row["手机"].ToString().Trim(); telephone = row["电话"].ToString().Trim() == String.Empty ? " " : row["电话"].ToString().Trim(); inscribe = row["落款"].ToString().Trim() == String.Empty ? " " : row["落款"].ToString().Trim(); source = row["来源"].ToString().Trim() == String.Empty ? " " : row["来源"].ToString().Trim(); payment = row["支付方式"].ToString().Trim() == String.Empty ? " " : row["支付方式"].ToString().Trim(); invoice = row["发票号"].ToString().Trim() == String.Empty ? " " : row["发票号"].ToString().Trim(); client = row["客户类别"].ToString().Trim() == String.Empty ? " " : row["客户类别"].ToString().Trim(); operator1 = row["业务员"].ToString().Trim() == String.Empty ? " " : row["业务员"].ToString().Trim(); bonus = row["奖金提取"].ToString().Trim() == String.Empty ? " " : row["奖金提取"].ToString().Trim(); 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); } }