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"])); } }