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