public Customer GetCustomerById(int customerId) { using (SqlConnection conn = new SqlConnection(DBHelper.GetConnection())) { SqlCommand cmd = new SqlCommand(); Customer customer = new Customer(); string employeeId = ""; int informationAssistantId = 0; cmd.Connection = conn; cmd.CommandText = @"select CompanyName,ContactPerson,ContactPersonNumber, ContactPerson2,ContactPerson2Number,ContactPerson3,ContactPerson3Number, City,UsableArea,Email,DecorationAddress,RidePath,AppointDateTime,ProviderType, CustomerType,Comments,InformationAssistantId,EmployeeId,WorkPlace from dbo.Customer where CustomerId = @CustomerId"; cmd.Parameters.AddWithValue("@CustomerId", customerId); try { conn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { customer.CustomerId = customerId; customer.CompanyName = reader.GetString(0); customer.ContactPerson = reader.GetString(1); customer.ContactPersonNumber = reader.GetString(2); customer.ContactPerson2 = reader.GetString(3); customer.ContactPerson2Number = reader.GetString(4); customer.ContactPerson3 = reader.GetString(5); customer.Contactperson3Number = reader.GetString(6); customer.City = reader.GetString(7); customer.UsableArea = reader.GetString(8); customer.Email = reader.GetString(9); customer.DecorationAddress = reader.GetString(10); customer.RidePath = reader.GetString(11); customer.AppointDateTime = reader.GetString(12); customer.ProviderType = reader.GetString(13); customer.CustomerType = reader.GetString(14); customer.Comments = reader.GetString(15); informationAssistantId = reader.IsDBNull(16) ? 0 : reader.GetInt32(16); employeeId = reader.IsDBNull(17) ? "" : reader.GetString(17); customer.InformationAssistants = editMessengerDao.GetInformationAssistantById(informationAssistantId); customer.Employees = empDao.GetEmployeeById(employeeId); customer.WorkPlace = reader.IsDBNull(18) ? "" : reader.GetString(18); } } catch (Exception ex) { throw ex; } finally { cmd.Dispose(); conn.Close(); } return customer; } }
public void SaveCustomer(Customer customer, Order order) { using (SqlConnection conn = new SqlConnection(DBHelper.GetConnection())) { SqlTransaction tran = null; SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; try { conn.Open(); tran = conn.BeginTransaction(); cmd.Transaction = tran; cmd.CommandText = @"insert into Customer values(@CustomerId, @CompanyName,@ContactPerson,@ContactPersonNumber, @ContactPerson2,@ContactPerson2Number,@ContactPerson3, @ContactPerson3Number,@City,@UsableArea,@Email,@DecorationAddress, @RidePath,@AppointDateTime,@ProviderType,@CustomerType,@Comments, @InformationAssistantId,@EmployeeId,@WorkPlace)"; cmd.Parameters.AddWithValue("@CustomerId", customer.CustomerId); cmd.Parameters.AddWithValue("@CompanyName", customer.CompanyName); cmd.Parameters.AddWithValue("@ContactPerson", customer.ContactPerson); cmd.Parameters.AddWithValue("@ContactPersonNumber", customer.ContactPersonNumber); cmd.Parameters.AddWithValue("@ContactPerson2", customer.ContactPerson2); cmd.Parameters.AddWithValue("@ContactPerson2Number", customer.ContactPerson2Number); cmd.Parameters.AddWithValue("@ContactPerson3", customer.ContactPerson3); cmd.Parameters.AddWithValue("@ContactPerson3Number", customer.Contactperson3Number); cmd.Parameters.AddWithValue("@City", customer.City); cmd.Parameters.AddWithValue("@UsableArea", customer.UsableArea); cmd.Parameters.AddWithValue("@Email", customer.Email); cmd.Parameters.AddWithValue("@DecorationAddress", customer.DecorationAddress); cmd.Parameters.AddWithValue("@RidePath", customer.RidePath); cmd.Parameters.AddWithValue("@AppointDateTime", customer.AppointDateTime); cmd.Parameters.AddWithValue("@ProviderType", customer.ProviderType); cmd.Parameters.AddWithValue("@CustomerType", customer.CustomerType); cmd.Parameters.AddWithValue("@Comments", customer.Comments); cmd.Parameters.AddWithValue("@InformationAssistantId", customer.InformationAssistants.InformationAssistantId); cmd.Parameters.AddWithValue("@EmployeeId",customer.Employees.EmployeeId); cmd.Parameters.AddWithValue("@WorkPlace", customer.WorkPlace); cmd.ExecuteNonQuery(); cmd.CommandText = @"Insert into CustomerOrder values( @OrderNumber,@RecordDate, null,@OrderStatus,@CustomerOrderId,null,null,null)"; cmd.Parameters.AddWithValue("@OrderNumber", order.OrderNumber); cmd.Parameters.AddWithValue("@RecordDate", order.RecordDate); //cmd.Parameters.AddWithValue("@InformationAssistantOrderId", order.InformationAssistant.InformationAssistantId); cmd.Parameters.AddWithValue("@OrderStatus", order.OrderStatus); cmd.Parameters.AddWithValue("@CustomerOrderId", order.Customers.CustomerId); cmd.ExecuteNonQuery(); tran.Commit(); } catch (Exception ex) { tran.Rollback(); throw ex; } finally { conn.Close(); cmd.Dispose(); tran.Dispose(); } } }
public void SaveCustomer(Customer customer,Order order) { addCustomerDao.SaveCustomer(customer, order); }
private void SaveCustomer() { Customer customer = new Customer(); customer.CustomerId = addcustomerManager.GetCustomId(); customer.CompanyName = txtCompany.Text; customer.AppointDateTime = decorateDate.Text; customer.City = city.Text; customer.Comments = txtComments.Text; customer.Contactperson3Number = txtContactPhone3.Text; customer.ContactPerson = txtContact.Text; customer.ContactPerson2 = txtContact2.Text; customer.ContactPerson2Number = txtContactPhone2.Text; customer.ContactPerson3 = txtContact3.Text; customer.ContactPersonNumber = txtContactPhone.Text; customer.UsableArea = txtAvaiableArea.Text; customer.RidePath = txtBusPath.Text; customer.WorkPlace = txtWorkPlace.Text; customer.Employees = employee; if (rbCustmoerTypeWork.Checked) { customer.CustomerType = "办公"; } else { customer.CustomerType = "商铺"; } customer.DecorationAddress = txtDecorateAddress.Text; customer.Email = txtEmail.Text; if (rbCooperator.Checked) { customer.ProviderType = "合作者"; } else { customer.ProviderType = "个人"; } customer.InformationAssistants = informationAssistant; Order order = new Order(); order.OrderNumber = customerTraceManager.GetOrderNumber(); order.OrderStatus = OrderStatus.Following; order.RecordDate = DateTime.Now; order.Customers = customer; addcustomerManager.SaveCustomer(customer, order); addcustomerManager.UpdateLevelToCopper(informationAssistant); }
public void ModifyOrderStatus(Order order,Customer customer,string orderStatus) { order.OrderStatus = orderStatus; order.Customers = customer; modifyCustomerManager.UpdateCustomer(order); LoadDetailInformation(order.OrderId); lblMsg.Text = "修改客户信息成功,当前订单状态为" + order.OrderStatus; lblMsg.Show(); if (radioButtonSubmit.Checked) { GlobalFormValue.SalesManager.Add(order); } }