public void LoadDetailInformation(int informationAssistantId)
{
InformationAssistant informationAssistant = editMessenger.GetInformationAssistantById(informationAssistantId);
_informationAssistant = informationAssistant;
txtMessengerName.Text = informationAssistant.InformationAssistantName;
txtPhone.Text = informationAssistant.PhoneNumber;
txtCompany.Text = informationAssistant.Company;
txtAddress.Text = informationAssistant.Address;
txtHandSet.Text = informationAssistant.HandSet;
cbCity.Text = informationAssistant.City;
if (informationAssistant.IsVisit)
{
rbVisitYes.Checked = true;
}
else
{
rbVisitNo.Checked = true;
}
lblLevel.Text = informationAssistant.InformationLevel;
lblLeftRevisitDays.Text = informationAssistant.ReVisitTime;
dgInformList.AutoGenerateColumns = false;
dgInformList.DataSource = editMessenger.GetInformList(_informationAssistant.InformationAssistantId).Tables[0];
dgTracingInformList.AutoGenerateColumns = false;
dgTracingInformList.DataSource = editMessenger.GetTraceingInformList(_informationAssistant.InformationAssistantId).Tables[0];
}
public InformationAssistant GetInformationAssistantByOrderId(int orderId)
{
using (SqlConnection conn = new SqlConnection(DBHelper.GetConnection()))
{
SqlCommand cmd = new SqlCommand();
InformationAssistant informationAssistant = new InformationAssistant();
cmd.Connection = conn;
cmd.CommandText = @"select InformationAssistantName,i.PhoneNumber,i.Type,
i.Company,i.City,InformationLevel,ReVisitTime,i.OrderId,Address,
ReVisistPeriod,IsVisit,HandSet,i.RecordDate,i.InformationAssistantId
from InformationAssistant i,dbo.CustomerOrder o,dbo.Customer c
where i.InformationAssistantId = c.InformationAssistantId
and c.CustomerId = o.CustomerId
and o.OrderId = @OrderId";
cmd.Parameters.AddWithValue("@OrderId", orderId);
try
{
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
informationAssistant.InformationAssistantId = reader.GetInt32(13);
informationAssistant.InformationAssistantName = reader.GetString(0);
informationAssistant.PhoneNumber = reader.GetString(1);
informationAssistant.Type = reader.GetString(2);
informationAssistant.Company = reader.GetString(3);
informationAssistant.City = reader.GetString(4);
informationAssistant.InformationLevel = reader.GetString(5);
informationAssistant.ReVisitTime = reader.GetString(6);
informationAssistant.Address = reader.IsDBNull(8) ? "" : reader.GetString(8);
informationAssistant.IsVisit = reader.IsDBNull(10) ? false : reader.GetBoolean(10);
informationAssistant.HandSet = reader.IsDBNull(11) ? "" : reader.GetString(11);
informationAssistant.RecordDateTime = reader.GetDateTime(12);
}
reader.Close();
reader.Dispose();
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Dispose();
conn.Close();
}
return informationAssistant;
}
}
private void LoadEditUnSubordinateIA(InformationAssistant informationAssistant)
{
if (!ParentPanel.Controls.Contains(editUnsubOrdinateIA))
{
editUnsubOrdinateIA = new EditUnSubordinateIA();
editUnsubOrdinateIA.ParentPanel = this.ParentPanel;
editUnsubOrdinateIA.NavigationBar = this.NavigationBar;
editUnsubOrdinateIA.employee = this.employee;
editUnsubOrdinateIA._informationAssistant = informationAssistant;
ParentPanel.Controls.Add(editUnsubOrdinateIA);
}
else {
editUnsubOrdinateIA.Show();
editUnsubOrdinateIA.ClearContent();
}
}
public InformationAssistant GetInformationAssistantById(int informationAssistantId)
{
using (SqlConnection con = new SqlConnection(DBHelper.GetConnection()))
{
SqlCommand cmd = new SqlCommand();
InformationAssistant informationAssistant = new InformationAssistant();
try
{
con.Open();
cmd.Connection = con;
cmd.CommandText = @"select InformationAssistantName,PhoneNumber,Type,
Company,City,InformationLevel,ReVisitTime,OrderId,Address,
ReVisistPeriod,IsVisit,HandSet
from InformationAssistant
where InformationAssistantId = @InformationAssistantId";
cmd.Parameters.AddWithValue("@InformationAssistantId", informationAssistantId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
informationAssistant.InformationAssistantId = informationAssistantId;
informationAssistant.InformationAssistantName = reader.GetString(0);
informationAssistant.PhoneNumber = reader.GetString(1);
informationAssistant.Type = reader.GetString(2);
informationAssistant.Company = reader.GetString(3);
informationAssistant.City = reader.GetString(4);
informationAssistant.InformationLevel = reader.GetString(5);
informationAssistant.ReVisitTime = "10";
informationAssistant.Address = reader.IsDBNull(8) ? "" : reader.GetString(8);
informationAssistant.IsVisit = reader.IsDBNull(10) ? false : reader.GetBoolean(10);
informationAssistant.HandSet = reader.IsDBNull(11) ? "" : reader.GetString(11);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
con.Close();
cmd.Dispose();
}
return informationAssistant;
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
if (IsValidateInput())
{
InformationAssistant informationAssistant = new InformationAssistant();
informationAssistant.VisitDateTime = DateTime.Now;
informationAssistant.InformationAssistantName = txtName.Text;
informationAssistant.InformationLevel = InformationAssistantLevels.Iron;
informationAssistant.City = cbCity.Text;
informationAssistant.Company = txtCompany.Text;
informationAssistant.HandSet = txtHandSet.Text;
informationAssistant.Address = txtAddress.Text;
informationAssistant.RecordDateTime = DateTime.Now;
if (radioButtonYes.Checked)
{
informationAssistant.IsVisit = true;
}
else
{
informationAssistant.IsVisit = false;
}
informationAssistant.PhoneNumber = txtPhone.Text;
informationAssistant.ReVisistPeriod = cbRevisitPeriod.Text;
informationAssistant.ReVisitTime = "10";
informationAssistant.Type = radioButtonintermediary.Text;
informationAssistant.OrderId = null;
informationAssistant.Employees = employee;
addIAManager.AddMessenger(informationAssistant);
lblEmptyMsg.Text = "添加信息员成功";
lblEmptyMsg.Visible = true;
if (ParentPanel != null)
{
foreach (Control control in ParentPanel.Controls)
{
control.Visible = false;
}
if (allList != null)
{
allList.Show();
allList.LoadDataGrid(1, "InforAllList", SearchInput.NoContent);
}
}
}
}
public void AddMessenger(InformationAssistant informationAssistant)
{
using (SqlConnection conn = new SqlConnection(DBHelper.GetConnection()))
{
int informationAssistantId = GetMaxId() + 1;
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = @"insert into InformationAssistant
values(@InformationAssistantId,@InformationAssistantName,
@PhoneNumber,@Type,@Company,@City,@InformationLevel,@ReVisitTime,
null,@Address,@ReVisistPeriod,@IsVisit,@HandSet,
@EmployeeId,@VisitDateTime,@RecordDateTime)";
cmd.Parameters.AddWithValue("@InformationAssistantId", informationAssistantId);
cmd.Parameters.AddWithValue("@InformationAssistantName", informationAssistant.InformationAssistantName);
cmd.Parameters.AddWithValue("@PhoneNumber", informationAssistant.PhoneNumber);
cmd.Parameters.AddWithValue("@Type", informationAssistant.Type);
cmd.Parameters.AddWithValue("@Company", informationAssistant.Company);
cmd.Parameters.AddWithValue("@City", informationAssistant.City);
cmd.Parameters.AddWithValue("@InformationLevel", informationAssistant.InformationLevel);
cmd.Parameters.AddWithValue("@ReVisitTime", informationAssistant.ReVisitTime);
cmd.Parameters.AddWithValue("@Address", informationAssistant.Address);
cmd.Parameters.AddWithValue("@ReVisistPeriod", informationAssistant.ReVisistPeriod);
cmd.Parameters.AddWithValue("@IsVisit", informationAssistant.IsVisit);
cmd.Parameters.AddWithValue("@HandSet", informationAssistant.HandSet);
cmd.Parameters.AddWithValue("@EmployeeId", informationAssistant.Employees.EmployeeId);
cmd.Parameters.AddWithValue("@VisitDateTime", informationAssistant.VisitDateTime);
cmd.Parameters.AddWithValue("@RecordDateTime", informationAssistant.RecordDateTime);
try
{
conn.Open();
cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
cmd.Dispose();
}
}
}
public void UpdateLevelToCopper(InformationAssistant ia)
{
using (SqlConnection conn = new SqlConnection(DBHelper.GetConnection()))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = @"Update dbo.InformationAssistant
Set InformationLevel = @InformationLevel
Where InformationAssistantId = @InformationAssistantId";
cmd.Parameters.AddWithValue("@InformationLevel", InformationAssistantLevels.Copper);
cmd.Parameters.AddWithValue("@InformationAssistantId", ia.InformationAssistantId);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
conn.Close();
cmd.Dispose();
}
}
}
public void AddMessenger(InformationAssistant informationAssistant)
{
addInformationAssistantDAO.AddMessenger(informationAssistant);
}
public void UpdateLevelToCopper(InformationAssistant ia)
{
addCustomerDao.UpdateLevelToCopper(ia);
}
public void UpdateLevelToSilver(InformationAssistant ia)
{
informationAssistantDao.UpdateLevelToSilver(ia);
}
private void LoadEditMessenger(InformationAssistant informationAssistant)
{
if (!ParentPanel.Controls.Contains(editMessenger))
{
editMessenger = new EditMessenger();
editMessenger.Name = "EditMessenger";
editMessenger.ParentPanel = ParentPanel;
editMessenger.NavigationBar = NavigationBar;
editMessenger.Dock = DockStyle.Fill;
}
editMessenger.employee = employee;
editMessenger._informationAssistant = informationAssistant;
editMessenger.allList = this;
ParentPanel.Controls.Add(editMessenger);
editMessenger.Show();
editMessenger.ClearControlContent();
editMessenger.LoadDetailInformation(informationAssistant.InformationAssistantId);
editMessenger.LoadReVisit();
}
private void btnConfirm_Click(object sender, EventArgs e)
{
if (IsValidateInput())
{
InformationAssistant messenger = new InformationAssistant();
messenger.InformationAssistantId = _informationAssistant.InformationAssistantId;
messenger.InformationAssistantName = txtMessengerName.Text;
messenger.PhoneNumber = txtPhone.Text;
if (rbTypeInterMedia.Checked)
{
messenger.Type = "中介";
}
else
{
messenger.Type = "售楼";
}
if (rbVisitNo.Checked)
{
messenger.IsVisit = false;
}
else
{
messenger.IsVisit = true;
}
messenger.HandSet = txtHandSet.Text;
messenger.Company = txtCompany.Text;
messenger.Address = txtAddress.Text;
editMessenger.UpdateMessenger(messenger);
lblSuccessMsg.Text = "编辑成功";
lblSuccessMsg.Visible = true;
}
else
{
lblSuccessMsg.Visible = false;
}
}
private void LoadOrderDetail(int orderId)
{
Order order = orderManager.GetOrderById(orderId);
if (_informationAssistant == null)
{
_informationAssistant = customerTraceManager.GetInformationAssistantByOrderId(orderId);
}
if (!ParentPanel.Contains(modifyCustomer))
{
orderDetail = new OrderDetail();
orderDetail.Name = "orderDetail";
orderDetail.ParentPanel = ParentPanel;
orderDetail.NavigationBar = NavigationBar;
orderDetail.employee = employee;
orderDetail.Dock = DockStyle.Fill;
orderDetail.order = order;
ParentPanel.Controls.Add(orderDetail);
}
else
{
orderDetail.Show();
orderDetail.ClearContent();
}
orderDetail.LoadDetailInformation();
orderDetail.order = order;
orderDetail.LoadReVisit();
}
public void UpdateMessenger(InformationAssistant informationAssistant)
{
using (SqlConnection conn = new SqlConnection(DBHelper.GetConnection()))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = @"Update InformationAssistant
set InformationAssistantName =@InformationAssistantName,
PhoneNumber = @PhoneNumber,
Type = @Type,
Company = @Company,
Address = @Address,
IsVisit = @IsVisit,
HandSet = @HandSet
where InformationAssistantId = @InformationAssistantId";
cmd.Parameters.AddWithValue("@InformationAssistantName", informationAssistant.InformationAssistantName);
cmd.Parameters.AddWithValue("@PhoneNumber", informationAssistant.PhoneNumber);
cmd.Parameters.AddWithValue("@Type", informationAssistant.Type);
cmd.Parameters.AddWithValue("@Company", informationAssistant.Company);
cmd.Parameters.AddWithValue("@Address", informationAssistant.Address);
cmd.Parameters.AddWithValue("@IsVisit", informationAssistant.IsVisit);
cmd.Parameters.AddWithValue("@HandSet", informationAssistant.HandSet);
cmd.Parameters.AddWithValue("@InformationAssistantId", informationAssistant.InformationAssistantId);
try
{
conn.Open();
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
cmd.Dispose();
conn.Close();
}
}
}
public void UpdateLevelToGold(InformationAssistant ia)
{
informationAssistantDao.UpdateLevelToGold(ia);
}
private void LoadModifyCustomer(int orderId)
{
_informationAssistant = customerTraceManager.GetInformationAssistantByOrderId(orderId);
if (!ParentPanel.Contains(modifyCustomer))
{
modifyCustomer = new ModifyCustomer();
modifyCustomer.Name = "ModifyCustomer";
modifyCustomer.ParentPanel = ParentPanel;
modifyCustomer.NavigationBar = NavigationBar;
modifyCustomer.customerTrace = this;
modifyCustomer.employee = employee;
modifyCustomer.Dock = DockStyle.Fill;
modifyCustomer._informationAssistant = _informationAssistant;
ParentPanel.Controls.Add(modifyCustomer);
}
modifyCustomer.Show();
modifyCustomer.ClareContent();
modifyCustomer._informationAssistant = _informationAssistant;
modifyCustomer._customerOrderId = orderId;
modifyCustomer.employee = employee;
modifyCustomer.LoadDetailInformation(orderId);
modifyCustomer.LoadReVisit();
}
public void UpdateMessenger(InformationAssistant informationAssistant)
{
editMessengerDao.UpdateMessenger(informationAssistant);
}
