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