public DataTable D_Mail_SelectAll(D_Mail_Entity de) { string sp = "D_Mail_SelectAll"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@MailDateFrom", new ValuePair { value1 = SqlDbType.VarChar, value2 = de.MailDateFrom } }, { "@MailDateTo", new ValuePair { value1 = SqlDbType.VarChar, value2 = de.MailDateTo } }, { "@MailTimeFrom", new ValuePair { value1 = SqlDbType.VarChar, value2 = de.MailTimeFrom } }, { "@MailTimeTo", new ValuePair { value1 = SqlDbType.VarChar, value2 = de.MailTimeTo } }, { "@MailType", new ValuePair { value1 = SqlDbType.TinyInt, value2 = de.MailType } }, { "@MailKBN", new ValuePair { value1 = SqlDbType.TinyInt, value2 = de.MailKBN } }, { "@CustomerCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = de.CustomerCD } }, { "@VendorCD", new ValuePair { value1 = SqlDbType.VarChar, value2 = de.VendorCD } }, }; return(SelectData(dic, sp)); }
public DataTable D_MailAddress_SelectAll(D_Mail_Entity de) { string sp = "D_MailAddress_SelectAll"; Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair> { { "@MailCounter", new ValuePair { value1 = SqlDbType.Int, value2 = de.MailCounter } }, }; return(SelectData(dic, sp)); }
protected override void ExecSec() { try { //【取込履歴】 M_MultiPorpose_Entity me = new M_MultiPorpose_Entity { ID = MultiPorpose_BL.ID_Mail, Key = "1" }; MultiPorpose_BL mbl = new MultiPorpose_BL(); DataTable dt = mbl.M_MultiPorpose_Select(me); if (dt.Rows.Count > 0) { mEdiMode = dt.Rows[0]["Num1"].ToString(); if (mEdiMode == "1") { //汎用マスター. 数字型1=1なら、「処理実行中」として青色 lblEdiMode.Text = "処理実行中"; lblEdiMode.BackColor = Color.DeepSkyBlue; } else { //汎用マスター. 数字型1=0なら、「処理停止中」として黄色 lblEdiMode.Text = "処理停止中"; lblEdiMode.BackColor = Color.Yellow; } } else { //E101 bbl.ShowMessage("E101"); EndSec(); } for (int i = 0; i < detailControls.Length; i++) { if (CheckDetail(i) == false) { detailControls[i].Focus(); return; } } //履歴データ取得処理 D_Mail_Entity de = new D_Mail_Entity { MailDateFrom = detailControls[(int)EIndex.MailDateSt].Text, MailDateTo = detailControls[(int)EIndex.MailDateEd].Text, MailTimeFrom = detailControls[(int)EIndex.MailTimeSt].Text != "" ? detailControls[(int)EIndex.MailDateSt].Text + " " + detailControls[(int)EIndex.MailTimeSt].Text + ":00":"", MailTimeTo = detailControls[(int)EIndex.MailTimeEd].Text != "" ? detailControls[(int)EIndex.MailDateEd].Text + " " + detailControls[(int)EIndex.MailTimeEd].Text + ":00" : "", MailType = ckM_ComboBox1.SelectedIndex > 0 ? ckM_ComboBox1.SelectedValue.ToString(): "0", MailKBN = ckM_ComboBox2.SelectedIndex > 0 ? ckM_ComboBox2.SelectedValue.ToString() : "0", CustomerCD = detailControls[(int)EIndex.Customer].Text, VendorCD = detailControls[(int)EIndex.Customer].Text, }; dt = mibl.D_Mail_SelectAll(de); GvDetail.DataSource = dt; if (dt.Rows.Count > 0) { GvDetail.SelectionMode = DataGridViewSelectionMode.FullRowSelect; GvDetail.CurrentRow.Selected = true; GvDetail.Enabled = true; GvDetail.ReadOnly = true; GvDetail.Focus(); } else { bbl.ShowMessage("E128"); } } catch (Exception ex) { //エラー時共通処理 MessageBox.Show(ex.Message); //EndSec(); } }
private void SetData(int rowIndex) { if (rowIndex < 0) { return; } foreach (Control ctl in detailLabels) { ctl.Text = ""; } //画面転送表03 lblSendedDateTime.Text = GvDetail.Rows[rowIndex].Cells["coIMailDateTime"].Value.ToString(); string MailKBN = GvDetail.Rows[rowIndex].Cells["colMailKBN"].Value.ToString(); switch (MailKBN) { case "11": lblMailKBN.Text = "注文確認"; break; case "12": lblMailKBN.Text = "入荷予定"; break; case "13": lblMailKBN.Text = "出荷予定"; break; case "14": lblMailKBN.Text = "出荷案内"; break; case "15": lblMailKBN.Text = "入金御礼"; break; case "16": lblMailKBN.Text = "アフターフォロー"; break; case "31": lblMailKBN.Text = "督促1回目"; break; case "32": lblMailKBN.Text = "督促2回目"; break; case "33": lblMailKBN.Text = "督促3回目"; break; case "34": lblMailKBN.Text = "督促4回目"; break; case "51": lblMailKBN.Text = "移動依頼"; break; case "71": lblMailKBN.Text = "EDI発注"; break; case "99": lblMailKBN.Text = "その他"; break; } lblJuchuuNo.Text = GvDetail.Rows[rowIndex].Cells["colNumber"].Value.ToString(); D_Mail_Entity de = new D_Mail_Entity(); de.MailCounter = GvDetail.Rows[rowIndex].Cells["colMailCounter"].Value.ToString(); DataTable dt = mibl.D_MailAddress_SelectAll(de); foreach (DataRow row in dt.Rows) { switch (row["AddressKBN"].ToString()) { case "1": lblAddress1.Text += (lblAddress1.Text == "" ? "":",") + row["Address"].ToString(); break; case "2": lblAddress2.Text += (lblAddress2.Text == "" ? "" : ",") + row["Address"].ToString(); break; case "3": lblAddress3.Text += (lblAddress3.Text == "" ? "" : ",") + row["Address"].ToString(); break; } } lblMailSubject.Text = GvDetail.Rows[rowIndex].Cells["colMailSubject"].Value.ToString(); lblCustomer.Text = GvDetail.Rows[rowIndex].Cells["Customer"].Value.ToString(); lblMailContent.Text = GvDetail.Rows[rowIndex].Cells["MailContent"].Value.ToString(); }
public DataTable D_MailAddress_SelectAll(D_Mail_Entity de) { D_MailAddress_DL dl = new D_MailAddress_DL(); return(dl.D_MailAddress_SelectAll(de)); }
/// <summary> /// メール送信照会にて使用 /// </summary> /// <param name="ediNO"></param> /// <returns></returns> public DataTable D_Mail_SelectAll(D_Mail_Entity de) { return(mdl.D_Mail_SelectAll(de)); }