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")
{
//汎用マスター. 数字型１＝１なら、「処理実行中」として青色
lblEdiMode.Text = "処理実行中";
lblEdiMode.BackColor = Color.DeepSkyBlue;
}
else
{
//汎用マスター. 数字型１＝０なら、「処理停止中」として黄色
lblEdiMode.Text = "処理停止中";
lblEdiMode.BackColor = Color.Yellow;
}
}
else
{
//Ｅ１０１
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 = "督促１回目"; break;
case "32": lblMailKBN.Text = "督促２回目"; break;
case "33": lblMailKBN.Text = "督促３回目"; break;
case "34": lblMailKBN.Text = "督促４回目"; 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));
}
