//リストダブルクリック private void m_addressslist_MouseDoubleClick_1(object sender, MouseEventArgs e) { ListView.SelectedIndexCollection item = m_addressslist.SelectedIndices; MailaddressDS mailDt = new MailaddressDS(); string kubun = this.m_addressslist.Items[item[0]].SubItems[0].Text; if (0 <= kubun.IndexOf("オペレータ")) { mailDt.kubun = "1"; } else { mailDt.kubun = "2"; } mailDt.opetantouno = this.m_addressslist.Items[item[0]].SubItems[1].Text; mailDt.addressNo = this.m_addressslist.Items[item[0]].SubItems[2].Text; mailDt.user_tantou_name = this.m_addressslist.Items[item[0]].SubItems[3].Text; mailDt.username = this.m_addressslist.Items[item[0]].SubItems[4].Text; mailDt.mailAddress = this.m_addressslist.Items[item[0]].SubItems[5].Text; mailDt.addressname = this.m_addressslist.Items[item[0]].SubItems[6].Text; mailDt.chk_date = this.m_addressslist.Items[item[0]].SubItems[7].Text; mailDt.chk_name_id = this.m_addressslist.Items[item[0]].SubItems[8].Text; add_Disp(mailDt); }
//オペレータの表示 private void add_Disp(MailaddressDS addressDt) { string kubunstr = ""; if (addressDt.kubun == "1") { kubunstr = "1:オペレータ"; } else if (addressDt.kubun == "2") { kubunstr = "2:カスタマ担当者"; } m_kubun.Text = kubunstr; m_userid.Text = addressDt.opetantouno; m_addressno.Text = addressDt.addressNo; m_username.Text = addressDt.user_tantou_name; m_Customername.Text = addressDt.username; m_address.Text = addressDt.mailAddress; m_addressname.Text = addressDt.addressname; m_update.Text = addressDt.chk_date; m_updateOpe.Text = addressDt.chk_name_id; }
private void mailtempleteInsert(ListView m_listviewobj) { this.return_address = new List <MailaddressDS>(); foreach (ListViewItem item in m_listviewobj.SelectedItems) { MailaddressDS mailDS = new MailaddressDS(); mailDS.kubun = item.Text; mailDS.opetantouno = item.SubItems[1].Text; mailDS.user_tantou_name = item.SubItems[2].Text; mailDS.addressNo = item.SubItems[4].Text; mailDS.mailAddress = item.SubItems[5].Text; mailDS.addressname = item.SubItems[6].Text; mailDS.chk_name_id = loginDS.opeid; this.return_address.Add(mailDS); } this.Close(); }
//メールアドレスのダブルクリック private void m_addressslist_DoubleClick(object sender, EventArgs e) { ListView.SelectedIndexCollection item = m_addressslist.SelectedIndices; Form_mailDetail addressDetail = new Form_mailDetail(); addressDetail.con = con; MailaddressDS mailDt = new MailaddressDS(); mailDt.kubun = "1"; mailDt.opetantouno = this.m_openo.Text; mailDt.addressNo = this.m_addressslist.Items[item[0]].SubItems[0].Text; //mailDt.userno = this.m_addressslist.Items[item[0]].SubItems[1].Text; mailDt.mailAddress = this.m_addressslist.Items[item[0]].SubItems[1].Text; mailDt.addressname = this.m_addressslist.Items[item[0]].SubItems[2].Text; mailDt.chk_date = this.m_addressslist.Items[item[0]].SubItems[3].Text; mailDt.chk_name_id = this.m_addressslist.Items[item[0]].SubItems[4].Text; addressDetail.addresssDS = mailDt; addressDetail.loginDS = loginDS; addressDetail.Show(); }
//送信メールを追加する。 private int insertSendAddress(int templeteno, MailaddressDS adds, String csv, string ToCcBcc) { //DB接続 NpgsqlCommand cmd; try { string addressno = adds.addressNo; string opetantouno = adds.opetantouno; string kubun = adds.kubun; if (con.FullState != ConnectionState.Open) { con.Open(); } Int32 rowsaffected; //データ登録 cmd = new NpgsqlCommand(@"insert into mail_send_address (kubun,opetantouno,toccbcc,addressno,templateno,chk_name_id) values ( :kubun,:opetantouno,:toccbcc,:addressno,:templateno,:chk_name_id)", con); cmd.Parameters.Add(new NpgsqlParameter("kubun", DbType.String) { Value = kubun }); cmd.Parameters.Add(new NpgsqlParameter("opetantouno", DbType.Int32) { Value = Int32.Parse(opetantouno) }); cmd.Parameters.Add(new NpgsqlParameter("toccbcc", DbType.String) { Value = ToCcBcc }); cmd.Parameters.Add(new NpgsqlParameter("addressno", DbType.Int32) { Value = Int32.Parse(addressno) }); cmd.Parameters.Add(new NpgsqlParameter("templateno", DbType.Int32) { Value = templeteno }); cmd.Parameters.Add(new NpgsqlParameter("chk_name_id", DbType.String) { Value = m_idlabel.Text }); rowsaffected = cmd.ExecuteNonQuery(); if (rowsaffected != 1) { MessageBox.Show("送信メールを登録できませんでした。", "メールテンプレート登録"); return(-1); } } catch (Exception ex) { string msg = ex.Message; if (0 <= msg.IndexOf("mail_send_address_pkc")) { msg = "To Cc Bccで同じ宛先を登録することはできません。"; } MessageBox.Show("メールテンプレート登録時エラー " + msg); return(-1); } return(1); }
//メール送信アドレス public int make_sendaddress(int tempno) { string csv; int ret = 1; MailaddressDS addressds = new MailaddressDS(); //Toのとき for (int i = 0; i < this.m_To_list.Items.Count; i++) { addressds.addressname = this.m_To_list.Items[i].SubItems[0].Text; addressds.mailAddress = this.m_To_list.Items[i].SubItems[1].Text; addressds.user_tantou_name = this.m_To_list.Items[i].SubItems[2].Text; csv = this.m_To_list.Items[i].Tag.ToString(); string[] stArray = csv.Split(','); addressds.addressNo = stArray[0]; string ss = ""; if (stArray[1] != "") { if (stArray[1] == "オペレータ") { ss = "1"; } else if (stArray[1] == "担当者") { ss = "2"; } } addressds.kubun = ss; addressds.opetantouno = stArray[2]; ret = insertSendAddress(tempno, addressds, csv, "To"); if (ret == -1) { return(-1); } } //Ccのとき for (int i = 0; i < this.m_Cc_list.Items.Count; i++) { addressds.addressname = this.m_Cc_list.Items[i].SubItems[0].Text; addressds.mailAddress = this.m_Cc_list.Items[i].SubItems[1].Text; addressds.user_tantou_name = this.m_Cc_list.Items[i].SubItems[2].Text; csv = this.m_Cc_list.Items[i].Tag.ToString(); string[] stArray = csv.Split(','); addressds.addressNo = stArray[0]; string ss = ""; if (stArray[1] != "") { if (stArray[1] == "オペレータ") { ss = "1"; } else if (stArray[1] == "担当者") { ss = "2"; } } addressds.kubun = ss; addressds.opetantouno = stArray[2]; ret = insertSendAddress(tempno, addressds, csv, "Cc"); if (ret == -1) { return(-1); } } //Bccのとき for (int i = 0; i < this.m_Bcc_list.Items.Count; i++) { addressds.addressname = this.m_Bcc_list.Items[i].SubItems[0].Text; addressds.mailAddress = this.m_Bcc_list.Items[i].SubItems[1].Text; addressds.user_tantou_name = this.m_Bcc_list.Items[i].SubItems[2].Text; csv = this.m_Bcc_list.Items[i].Tag.ToString(); string[] stArray = csv.Split(','); addressds.addressNo = stArray[0]; string ss = ""; if (stArray[1] != "") { if (stArray[1] == "オペレータ") { ss = "1"; } else if (stArray[1] == "担当者") { ss = "2"; } } addressds.kubun = ss; addressds.opetantouno = stArray[2]; ret = insertSendAddress(tempno, addressds, csv, "Cc"); if (ret == -1) { return(-1); } } return(ret); }
//メールアドレス情報を更新する private int updatemailaddress(string templete_no, NpgsqlConnection con, NpgsqlTransaction transaction) { string csv; int ret = 1; MailaddressDS addressds = new MailaddressDS(); //とりあえず今あるものは消す if (DeletedSendAddress(templete_no, con, transaction) != 1) { // MessageBox.Show("メールテンプレートの更新(送信先メールアドレス削除)に失敗しました。",""); // return -1; } //Toのとき for (int i = 0; i < this.m_To_list.Items.Count; i++) { addressds.addressname = this.m_To_list.Items[i].SubItems[0].Text; addressds.mailAddress = this.m_To_list.Items[i].SubItems[1].Text; string kubunstr = this.m_To_list.Items[i].SubItems[2].Text; csv = this.m_To_list.Items[i].Tag.ToString(); string[] stArray = csv.Split(','); addressds.addressNo = stArray[0]; string ss = ""; if (kubunstr != "") { if (kubunstr == "オペレータ") { ss = "1"; } else if (kubunstr == "担当者") { ss = "2"; } } addressds.kubun = ss; addressds.opetantouno = stArray[2]; ret = updateSendAddress(m_tempno.Text, addressds, csv, "To", transaction); if (ret == -1) { return(-1); } } //Ccのとき for (int i = 0; i < this.m_Cc_list.Items.Count; i++) { addressds.addressname = this.m_Cc_list.Items[i].SubItems[0].Text; addressds.mailAddress = this.m_Cc_list.Items[i].SubItems[1].Text; string kubunstr = this.m_Cc_list.Items[i].SubItems[2].Text; csv = this.m_Cc_list.Items[i].Tag.ToString(); string[] stArray = csv.Split(','); addressds.addressNo = stArray[0]; string ss = ""; if (kubunstr != "") { if (kubunstr == "オペレータ") { ss = "1"; } else if (kubunstr == "担当者") { ss = "2"; } } addressds.kubun = ss; addressds.opetantouno = stArray[2]; ret = updateSendAddress(m_tempno.Text, addressds, csv, "Cc", transaction); if (ret == -1) { return(-1); } } //Bccのとき for (int i = 0; i < this.m_Bcc_list.Items.Count; i++) { addressds.addressname = this.m_Bcc_list.Items[i].SubItems[0].Text; addressds.mailAddress = this.m_Bcc_list.Items[i].SubItems[1].Text; string kubunstr = this.m_Bcc_list.Items[i].SubItems[2].Text; csv = this.m_Bcc_list.Items[i].Tag.ToString(); string[] stArray = csv.Split(','); addressds.addressNo = stArray[0]; string ss = ""; if (kubunstr != "") { if (kubunstr == "オペレータ") { ss = "1"; } else if (kubunstr == "担当者") { ss = "2"; } } addressds.kubun = ss; addressds.opetantouno = stArray[2]; ret = updateSendAddress(m_tempno.Text, addressds, csv, "Bcc", transaction); if (ret == -1) { return(-1); } } return(ret); }
//表示 private void DispMailtemplete(mailTempleteDS maildt) { m_tempno.Text = maildt.templateno; m_templetename.Text = maildt.template_name; m_subject.Text = maildt.subject; m_body.Text = maildt.body; m_account.Text = maildt.account; m_update.Text = maildt.chk_date; m_updateOpe.Text = maildt.chk_name_id; m_temp1.Text = maildt.attach1; m_temp2.Text = maildt.attach2; m_temp3.Text = maildt.attach3; m_temp4.Text = maildt.attach4; m_temp5.Text = maildt.attach5; Dictionary <string, string> address = new Dictionary <string, string>(); List <String> toList = new List <String>(); List <String> CcList = new List <String>(); List <String> BccList = new List <String>(); //宛先の表示 foreach (mailsendaddressDS ms in mailsendaddressDSList) { MailaddressDS addressds = new MailaddressDS(); string tocc = ""; tocc = ms.toccbcc; if (tocc != "") { if (tocc == "To") { ListViewItem lvi; lvi = m_To_list.Items.Add(ms.addressname); lvi.SubItems.Add(ms.mailaddress); //1:オペレータ 2:カスタマ担当者 if (ms.kubun == "1") { lvi.SubItems.Add("オペレータ"); } //2:カスタマ担当者 else if (ms.kubun == "2") { lvi.SubItems.Add("担当者"); } //非表示項目 lvi.Tag = ms.addressno + "," + ms.kubun + "," + ms.opetantouno; } if (tocc == "Cc") { ListViewItem lvi; lvi = m_Cc_list.Items.Add(ms.addressname); lvi.SubItems.Add(ms.mailaddress); //1:オペレータ 2:カスタマ担当者 if (ms.kubun == "1") { lvi.SubItems.Add("オペレータ"); } //2:カスタマ担当者 else if (ms.kubun == "2") { lvi.SubItems.Add("担当者"); } //非表示項目 lvi.Tag = ms.addressno + "," + ms.kubun + "," + ms.opetantouno; } if (tocc == "Bcc") { ListViewItem lvi; lvi = m_Bcc_list.Items.Add(ms.addressname); lvi.SubItems.Add(ms.mailaddress); //1:オペレータ 2:カスタマ担当者 if (ms.kubun == "1") { lvi.SubItems.Add("オペレータ"); } //2:カスタマ担当者 else if (ms.kubun == "2") { lvi.SubItems.Add("担当者"); } //非表示項目 lvi.Tag = ms.addressno + "," + ms.kubun + "," + ms.opetantouno; } } } }