private void btnAddCustomer_Click(object sender, EventArgs e)
{
DialogResult res = CheckAllMessage();
if (res == DialogResult.OK)
{
try
{
DDCustomerInfo newCustomer = new DDCustomerInfo();
newCustomer.CustomerName = this.tbxName.Text;
newCustomer.PhoneNumber = this.tbxPhone.Text;
newCustomer.Address = this.tbxAddress.Text;
newCustomer.ContactPerson = this.tbxContactPerson.Text;
newCustomer.CertTypeID = Convert.ToInt32(this.cbxCertType.SelectedValue);
newCustomer.CertNumber = this.tbxCertNum.Text;
newCustomer.CreatDate = DianDangFunction.ChangeDateFormat(DateTime.Now.ToShortDateString());
newCustomer.Save();
MessageBox.Show("添加成功！", "添加客户");
}
catch
{
MessageBox.Show("添加失败，请检查数据库是否连接正确！", "添加客户");
}
}
}
//更新所选行数据
private void btnUpdate_Click(object sender, EventArgs e)
{
for (int i = 0; i < dataGridView1.RowCount; i++)
{
if (this.dataGridView1.Rows[i].Cells["DataSelect"].Value != null && this.dataGridView1.Rows[i].Cells["DataSelect"].Value.ToString() == "1")
{
dataGridView1.Rows[i].Selected = true;
}
else
{
dataGridView1.Rows[i].Selected = false;
}
}
if (dataGridView1.SelectedRows.Count > 0)
{
for (int i = dataGridView1.SelectedRows.Count - 1; i > -1; i--)
{
int intCustomerID = Convert.ToInt32(dataGridView1.SelectedRows[i].Cells["CustomerID"].Value);
DDCustomerInfo newCustomer = new DDCustomerInfo("CustomerID", intCustomerID);
newCustomer.CustomerName = dataGridView1.SelectedRows[i].Cells["CustomerName"].Value.ToString();
newCustomer.PhoneNumber = dataGridView1.SelectedRows[i].Cells["PhoneNumber"].Value.ToString();
newCustomer.Address = dataGridView1.SelectedRows[i].Cells["Address"].Value.ToString();
newCustomer.ContactPerson = dataGridView1.SelectedRows[i].Cells["ContactPerson"].Value.ToString();
newCustomer.CertTypeID = Convert.ToInt32(dataGridView1.SelectedRows[i].Cells["CertTypeID"].Value);
newCustomer.CertNumber = dataGridView1.SelectedRows[i].Cells["CertNumber"].Value.ToString();;
newCustomer.Save();
}
MessageBox.Show("数据更新成功！");
}
else
{
MessageBox.Show("请选择需要更新的数据！");
}
}
public void Insert(string CustomerName, string PhoneNumber, string Address, string ContactPerson, int?CertTypeID, string CertNumber)
{
DDCustomerInfo item = new DDCustomerInfo();
item.CustomerName = CustomerName;
item.PhoneNumber = PhoneNumber;
item.Address = Address;
item.ContactPerson = ContactPerson;
item.CertTypeID = CertTypeID;
item.CertNumber = CertNumber;
item.Save(UserName);
}
public void Update(int CustomerID, string CustomerName, string PhoneNumber, string Address, string ContactPerson, int?CertTypeID, string CertNumber)
{
DDCustomerInfo item = new DDCustomerInfo();
item.MarkOld();
item.IsLoaded = true;
item.CustomerID = CustomerID;
item.CustomerName = CustomerName;
item.PhoneNumber = PhoneNumber;
item.Address = Address;
item.ContactPerson = ContactPerson;
item.CertTypeID = CertTypeID;
item.CertNumber = CertNumber;
item.Save(UserName);
}
private int UpdateCustomerInfo()
{
Query query = new Query(DDCustomerInfo.Schema);
query.AddWhere("CertNUmber", this.tbxCertNum.Text);
DataTable dt = query.ExecuteDataSet().Tables[0];
if (dt.Rows.Count == 0)
{
DDCustomerInfo newCustomer = new DDCustomerInfo();
newCustomer.CustomerName = this.tbxCustomerName.Text;
newCustomer.PhoneNumber = this.tbxCustomerPhone.Text;
newCustomer.Address = this.tbxCustomerAdd.Text;
newCustomer.ContactPerson = this.tbxContactPerson.Text;
newCustomer.CertTypeID = Convert.ToInt32(this.cbxCertType.SelectedValue);
newCustomer.CertNumber = this.tbxCertNum.Text;
newCustomer.Save();
return(newCustomer.CustomerID);
}
else
{
return(Convert.ToInt32(dt.Rows[0]["CustomerID"]));
}
}
