private void FormAgentRecord_Load(object sender, EventArgs e)
{
ControlBindDataSource cbds = new ControlBindDataSource();
cbds.DataGridViewComboBoxColumnBindDataSource(ProvinceCode, "ProvinceCode", "ProvinceName", "Select * From Province", "Province");
bsAgentRecord.DataSource = ar.GetDataTable("Customer", "Where CustomerType = '1' ");
dgvAgentRecord.DataSource = bsAgentRecord;
}
private void btnSave_Click(object sender, EventArgs e)
{
AgentRecord ar = new AgentRecord();
if (String.IsNullOrEmpty(txtCustomerName.Text.Trim()))
{
MessageBox.Show("代理商名称不许为空！", "软件提示");
txtCustomerName.Focus();
return;
}
if (String.IsNullOrEmpty(txtJuridicalPerson.Text.Trim()))
{
MessageBox.Show("法人不许为空！", "软件提示");
txtJuridicalPerson.Focus();
return;
}
if (String.IsNullOrEmpty(txtPhoneNumber.Text.Trim()))
{
MessageBox.Show("联系电话不许为空！", "软件提示");
txtPhoneNumber.Focus();
return;
}
if (cbxProvinceCode.SelectedValue == null)
{
MessageBox.Show("所在省市不许为空！", "软件提示");
cbxProvinceCode.Focus();
return;
}
if (String.IsNullOrEmpty(txtAddress.Text.Trim()))
{
MessageBox.Show("地址不许为空！", "软件提示");
txtAddress.Focus();
return;
}
if (this.Tag.ToString() == "Add")
{
DataGridViewRow dgvr = ar.AddDataGridViewRow(formAgentRecord.dgvAgentRecord, formAgentRecord.bsAgentRecord);
dgvr.Cells["CustomerName"].Value = txtCustomerName.Text.Trim();
dgvr.Cells["JuridicalPerson"].Value = txtJuridicalPerson.Text.Trim();
dgvr.Cells["PhoneNumber"].Value = txtPhoneNumber.Text.Trim();
dgvr.Cells["ProvinceCode"].Value = cbxProvinceCode.SelectedValue;
dgvr.Cells["Address"].Value = txtAddress.Text.Trim();
dgvr.Cells["PostalCode"].Value = txtPostalCode.Text.Trim();
dgvr.Cells["URL"].Value = txtURL.Text.Trim();
dgvr.Cells["OpenAccBankName"].Value = txtOpenAccBankName.Text.Trim();
dgvr.Cells["AccountNumber"].Value = txtAccountNumber.Text.Trim();
dgvr.Cells["CertificateNumber"].Value = txtCertificateNumber.Text.Trim();
dgvr.Cells["IsCancel"].Value = useful.GetFlagValue(cbIsCancel);
dgvr.Cells["CustomerType"].Value = "1";//代理商类型为1，默认值，不许修改的
dgvr.Cells["Remark"].Value = txtRemark.Text.Trim();
dgvr.Cells["OperatorCode"].Value = GlobalProperty.OperatorCode;
if (ar.Insert(formAgentRecord.dgvAgentRecord, formAgentRecord.bsAgentRecord))
{
formAgentRecord.bsAgentRecord.DataSource = ar.GetDataTable("Customer", " Where CustomerType = '1'");
formAgentRecord.dgvAgentRecord.DataSource = formAgentRecord.bsAgentRecord;
//formAgentRecord.bsAgentRecord.CancelEdit();//取消当前的编辑操作。
if (MessageBox.Show("保存成功，是否继续添加？", "软件提示", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation) == DialogResult.Yes)
{
txtCustomerName.Text = "";
txtJuridicalPerson.Text = "";
txtPhoneNumber.Text = "";
cbxProvinceCode.SelectedIndex = -1;
txtAddress.Text = "";
txtPostalCode.Text = "";
txtURL.Text = "";
txtOpenAccBankName.Text = "";
txtAccountNumber.Text = "";
txtCertificateNumber.Text = "";
cbIsCancel.Checked = false; //表示不取消代理
txtRemark.Text = "";
txtCustomerName.Focus();
}
else
{
this.Close();
}
}
else
{
MessageBox.Show("保存失败！", "软件提示");
}
}
if (this.Tag.ToString() == "Edit")
{
DataGridViewRow dgvr = formAgentRecord.dgvAgentRecord.CurrentRow;
dgvr.Cells["CustomerName"].Value = txtCustomerName.Text.Trim();
dgvr.Cells["JuridicalPerson"].Value = txtJuridicalPerson.Text.Trim();
dgvr.Cells["PhoneNumber"].Value = txtPhoneNumber.Text.Trim();
dgvr.Cells["ProvinceCode"].Value = cbxProvinceCode.SelectedValue;
dgvr.Cells["Address"].Value = txtAddress.Text.Trim();
dgvr.Cells["PostalCode"].Value = txtPostalCode.Text.Trim();
dgvr.Cells["URL"].Value = txtURL.Text.Trim();
dgvr.Cells["OpenAccBankName"].Value = txtOpenAccBankName.Text.Trim();
dgvr.Cells["AccountNumber"].Value = txtAccountNumber.Text.Trim();
dgvr.Cells["CertificateNumber"].Value = txtCertificateNumber.Text.Trim();
dgvr.Cells["IsCancel"].Value = useful.GetFlagValue(cbIsCancel);
//dgvr.Cells["CustomerType"].Value = "1";//代理商类型为1,默认值，不许修改
dgvr.Cells["Remark"].Value = txtRemark.Text.Trim();
//dgvr.Cells["OperatorCode"].Value = GlobalProperty.OperatorCode;
if (ar.Update(formAgentRecord.bsAgentRecord))
{
MessageBox.Show("保存成功！", "软件提示");
this.Close();
}
else
{
MessageBox.Show("保存失败！", "软件提示");
}
}
}