private void dgCallList_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
// CALL LIST
// 고객 정보
DataGrid view = e.Source as DataGrid;
CallList item = view.SelectedItem as CallList;
if (item == null)
{
e.Handled = true;
return;
}
flycustomer = GetCustomerByIdx(item.Cust_Idx);
if (flycustomer.Idx == -1)
{
flycustomer = new Customer() { Group_Idx = 0, Idx = item.Cust_Idx, Cellular = item.Cust_Tel };
flyCustomer.Header = Application.Current.FindResource("PB_DATAGRID_CUST_TOP_LABEL_0").ToString();
CustState = CUSTOMER_STATE.ADD;
}
else
{
flyCustomer.Header = Application.Current.FindResource("PB_DATAGRID_CUST_TOP_LABEL_1").ToString();
CustState = CUSTOMER_STATE.MODIFY;
}
btnCustSave.Visibility = Visibility.Visible;
dgridCustCallList.ItemsSource = GetCallListByCustIdx(flycustomer.Idx, flycustomer.Cellular);
flyCustomer.DataContext = flycustomer;
flyCustomer.IsOpen = true;
}
private void MenuItem_Click_12(object sender, RoutedEventArgs e)
{
// CALL LIST
// 고객 정보
MenuItem menuitem = (MenuItem)e.Source;
ContextMenu cm = (ContextMenu)menuitem.Parent;
DataGrid view = (DataGrid)cm.PlacementTarget;
CallList item = (CallList)view.SelectedItem;
flycustomer = GetCustomerByIdx(item.Cust_Idx);
if (flycustomer == null)
{
flycustomer = new Customer() { Group_Idx = 0, Idx = item.Cust_Idx, Cellular = item.Cust_Tel };
flyCustomer.Header = Application.Current.FindResource("PB_DATAGRID_CUST_TOP_LABEL_0").ToString();
CustState = CUSTOMER_STATE.ADD;
}
else
{
flyCustomer.Header = Application.Current.FindResource("PB_DATAGRID_CUST_TOP_LABEL_1").ToString();
CustState = CUSTOMER_STATE.MODIFY;
}
btnCustSave.Visibility = Visibility.Visible;
flyCustomer.DataContext = flycustomer;
flyCustomer.IsOpen = true;
}
private void MenuItem_Click_4(object sender, RoutedEventArgs e)
{
CustState = CUSTOMER_STATE.ADD;
// 고객 추가
GroupList gselitem = tvGroup.SelectedItem as GroupList;
if (gselitem != null)
{
flycustomer = new Customer() { Group_Idx = gselitem.Idx };
}
else
{
flycustomer = new Customer();
}
flyCustomer.DataContext = flycustomer;
flyCustomer.Header = Application.Current.FindResource("PB_FLYOUT_TITLE_CUST_ADD").ToString();
flyCustomer.IsOpen = true;
}
private void MenuItem_Click_5(object sender, RoutedEventArgs e)
{
CustState = CUSTOMER_STATE.MODIFY;
// 고객 수정
MenuItem menuitem = (MenuItem)e.Source;
ContextMenu cm = (ContextMenu)menuitem.Parent;
DataGrid view = (DataGrid)cm.PlacementTarget;
Customer item = (Customer)view.SelectedItem;
flycustomer = new Customer() { Idx = item.Idx, Group_Idx = item.Group_Idx, Name = item.Name, Company = item.Company, Title = item.Title, Tel = item.Tel, Cellular = item.Cellular, Extension = item.Extension, Email = item.Email, Addr = item.Addr };
flyCustomer.DataContext = flycustomer;
// cmbGroup.SelectedValue = flycustomer.Group_Idx;
flyCustomer.Header = Application.Current.FindResource("PB_FLYOUT_TITLE_CUST_EDIT").ToString();
flyCustomer.IsOpen = true;
}
private void MenuItem_Click_4_1(object sender, RoutedEventArgs e)
{
// 고객 excel로 추가
System.Windows.Forms.OpenFileDialog openFileDialog = new System.Windows.Forms.OpenFileDialog();
openFileDialog.Multiselect = false;
openFileDialog.Filter = "Excel 97-2013|*.xls";
openFileDialog.FilterIndex = 1;
openFileDialog.ShowDialog();
string xlsfilename = openFileDialog.FileName;
if (string.IsNullOrEmpty(xlsfilename))
return;
openFileDialog.Dispose();
DataSet ds = ExcelHelper.OpenExcelDB(xlsfilename);
if (ds != null)
{
if (ds.Tables.Count == 1)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
Customer _customer = new Customer() {
Group_Name = row[0].ToString().Trim(),
Name = row[1].ToString().Trim(),
Company = row[2].ToString().Trim(),
Title = row[3].ToString().Trim(),
Tel = row[4].ToString().Trim(),
Cellular = row[5].ToString().Trim(),
Extension = row[6].ToString().Trim(),
Email = row[7].ToString().Trim(),
Addr = row[8].ToString().Trim()
};
customers.importExcel(_customer);
}
}
}
}
private void dgCustList_MouseDoubleClick(object sender, MouseButtonEventArgs e)
{
// 고객 수정
DataGrid view = e.Source as DataGrid;
Customer item = view.SelectedItem as Customer;
if (item == null)
{
e.Handled = true;
return;
}
flycustomer = new Customer() { Idx = item.Idx, Group_Idx = item.Group_Idx, Name = item.Name, Company = item.Company, Title = item.Title, Tel = item.Tel, Cellular = item.Cellular, Extension = item.Extension, Email = item.Email, Addr = item.Addr };
flyCustomer.DataContext = flycustomer;
// cmbGroup.SelectedValue = flycustomer.Group_Idx;
flyCustomer.Header = Application.Current.FindResource("PB_FLYOUT_TITLE_CUST_EDIT").ToString();
dgridCustCallList.ItemsSource = GetCallListByCustIdx(flycustomer.Idx, flycustomer.Cellular);
flyCustomer.IsOpen = true;
CustState = CUSTOMER_STATE.MODIFY;
}
private void MenuItem_Click_3(object sender, RoutedEventArgs e)
{
// 고객 추가
flycustomer = new Customer() { Group_Idx = ((GroupList)tvGroup.SelectedItem).Idx };
flyCustomer.DataContext = flycustomer;
flyCustomer.Header = Application.Current.FindResource("PB_FLYOUT_TITLE_CUST_ADD").ToString();
flyCustomer.IsOpen = true;
dgridCustCallList.ItemsSource = null;
CustState = CUSTOMER_STATE.ADD;
}
public Customer GetCustomerByTel(string tel)
{
DataTable dt;
Customer cust = null;
using (FirebirdDBHelper db = new FirebirdDBHelper(util.GetFbDbStrConn()))
{
try
{
db.SetParameters("@I_IDX", FbDbType.VarChar, tel);
dt = db.GetDataTableSP("GET_CUSTOMER_BY_TEL");
foreach (DataRow row in dt.Rows)
{
cust = new Customer()
{
IsChecked = false,
IsSelected = false,
Idx = string.IsNullOrEmpty(row[0].ToString()) == false ? int.Parse(row[0].ToString()) : -1,
Group_Idx = string.IsNullOrEmpty(row[1].ToString()) == false ? int.Parse(row[1].ToString()) : 0,
Name = row[2].ToString(),
Company = row[3].ToString(),
Title = row[4].ToString(),
Tel = row[5].ToString(),
Cellular = row[6].ToString(),
Extension = row[7].ToString(),
Email = row[8].ToString(),
Addr = row[9].ToString(),
Etc = row[10].ToString()
};
}
}
catch (FbException ex)
{
util.WriteLog(ex.ErrorCode, ex.Message);
}
}
return cust;
}
private void btnAddSms_Click(object sender, RoutedEventArgs e)
{
// SMS Flyout customer list add
if (string.IsNullOrEmpty(txtSmsReceiver.Text.Trim()))
{
// e.Handled = true;
return;
}
Customer cust = GetCustomerByTel(txtSmsReceiver.Text.Trim());
if (cust.Idx < 1)
{
cust = new Customer() { Cellular = txtSmsReceiver.Text.Trim() };
var items = dgSmsReceiverList.ItemsSource as Customers;
if (items == null)
{
Customers custs = new Customers();
custs.Add(cust);
dgSmsReceiverList.ItemsSource = custs;
}
else
{
var item = items.FirstOrDefault(x => x.Cellular.Equals(txtSmsReceiver.Text.Trim()));
if (item != null)
{
txtSmsReceiver.Text = string.Empty;
return;
}
items.Add(cust);
// dgSmsReceiverList.ItemsSource = items;
}
}
else
{
var items = dgSmsReceiverList.ItemsSource as Customers;
if (items == null)
{
Customers custs = new Customers();
custs.Add(cust);
dgSmsReceiverList.ItemsSource = custs;
}
else
{
var item = items.FirstOrDefault(x => x.Cellular.Equals(txtSmsReceiver.Text.Trim()));
if (item != null)
{
txtSmsReceiver.Text = string.Empty;
return;
}
items.Add(cust);
// dgSmsReceiverList.ItemsSource = items;
}
}
txtSmsReceiver.Text = string.Empty;
}
private void MenuItem_Click_16(object sender, RoutedEventArgs e)
{
// SMS 탭, SMS 보내기
MenuItem menuitem = (MenuItem)e.Source;
ContextMenu cm = (ContextMenu)menuitem.Parent;
DataGrid view = (DataGrid)cm.PlacementTarget;
Sms item = (Sms)view.SelectedItem;
Customer tmpitem = new Customer() { Group_Idx = item.Cust_Idx, Name = item.Cust_Name, Cellular = item.Cust_Tel };
Customers smscustlist = new Customers();
smscustlist.Add(tmpitem);
dgSmsReceiverList.ItemsSource = smscustlist;
flySms.IsOpen = true;
}
// Send Sms
public void SendSms(Customer customer, string smsmsg, string sender)
{
try
{
sms_msg msg = this.GetSmsMessage(USRSTRUCTS.SMS_SEND_REQ, smsmsg, sender, customer.Cellular, string.Empty, string.Empty);
byte[] bytes = util.GetBytes(msg);
client.Send(bytes, bytes.Length);
}
catch (SocketException ex)
{
util.WriteLog(ex.ErrorCode, ex.Message.ToString());
}
// Thread.Sleep(100);
}