protected override void ExecDisp()
{
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
dee = GetSearchInfo();
DataTable dt = ehbl.D_EDIOrder_SelectAll(dee);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
ehbl.ShowMessage("E128");
}
}
private D_EDIOrder_Entity GetEntityForEDIOrder()
{
dee = new D_EDIOrder_Entity
{
EDIOrderNO = detailControls[(int)EIndex.SyoriNO].Text
};
return(dee);
}
private D_EDIOrder_Entity GetSearchInfo()
{
dee = new D_EDIOrder_Entity
{
OrderDateFrom = detailControls[(int)EIndex.DayStart].Text,
OrderDateTo = detailControls[(int)EIndex.DayEnd].Text,
VendorCD = ScVendor.TxtCode.Text,
StoreCD = CboStoreCD.SelectedValue.ToString().Equals("-1") ? string.Empty : CboStoreCD.SelectedValue.ToString(),
};
return(dee);
}
public DataTable D_EDIOrder_SelectForCSV(D_EDIOrder_Entity de)
{
string sp = "D_EDIOrder_SelectForCSV";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@EDIOrderNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.EDIOrderNO
} },
};
return(SelectData(dic, sp));
}
public DataTable D_EDIOrder_SelectAll(D_EDIOrder_Entity de)
{
string sp = "D_EDIOrder_SelectAll";
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.StoreCD
} },
{ "@OrderDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.OrderDateFrom
} },
{ "@OrderDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.OrderDateTo
} },
{ "@VendorCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = de.VendorCD
} },
};
return(SelectData(dic, sp));
}
protected override void ExecSec()
{
bool ret = CheckData();
if (ret == false)
{
return;
}
if (RdoNotOutput.Checked)
{
doe.Operator = this.InOperatorCD;
doe.PC = this.InPcID;
dee = new D_EDIOrder_Entity();
ret = mibl.PRC_EDIOrder_Insert(doe, dee);
}
else
{
dee.Operator = this.InOperatorCD;
dee.PC = this.InPcID;
ret = mibl.PRC_EDIOrder_MailInsert(dee);
}
this.Cursor = Cursors.Default;
if (ret == false)
{
bbl.ShowMessage("S002");
}
else
{
bbl.ShowMessage("I002");
}
//更新後画面そのまま
detailControls[0].Focus();
}
/// <summary>
/// EDI発注メール追加処理
/// </summary>
public bool PRC_EDIOrder_MailInsert(D_EDIOrder_Entity dee)
{
return(edl.PRC_EDIOrder_MailInsert(dee));
}
public bool PRC_EDIOrder_Insert(D_Order_Entity doe, D_EDIOrder_Entity dee)
{
return(edl.PRC_EDIOrder_Insert(doe, dee));
}
/// <summary>
/// EDI発注CSV出力用データ取得処理
/// </summary>
public DataTable D_EDIOrder_SelectForCSV(D_EDIOrder_Entity dee)
{
return(edl.D_EDIOrder_SelectForCSV(dee));
}
/// <summary>
/// EDI発注取得処理
/// EDI処理番号検索時に使用
/// </summary>
public DataTable D_EDIOrder_SelectAll(D_EDIOrder_Entity dee)
{
DataTable dt = edl.D_EDIOrder_SelectAll(dee);
return(dt);
}
/// <summary>
/// 未出力分の処理
/// </summary>
/// <param name="doe"></param>
/// <param name="dee"></param>
/// <returns></returns>
public bool PRC_EDIOrder_Insert(D_Order_Entity doe, D_EDIOrder_Entity dee)
{
DateTime dtNow = DateTime.Now;
try
{
StartTransaction();
//EDI発注追加
Dictionary <string, ValuePair> dic = new Dictionary <string, ValuePair>
{
{ "@StoreCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.StoreCD
} },
{ "@OrderDateFrom", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderDateFrom
} },
{ "@OrderDateTo", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderDateTo
} },
{ "@StaffCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.StaffCD
} },
{ "@OrderCD", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderCD
} },
{ "@OrderNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.OrderNO
} },
{ "@ChkMisyonin", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.ChkMisyonin.ToString()
} },
{ "@Operator", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.Operator
} },
{ "@PC", new ValuePair {
value1 = SqlDbType.VarChar, value2 = doe.PC
} },
{ "@SYSDATETIME", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dtNow.ToString("yyyy/MM/dd HH:mm:ss")
} },
};
command = new SqlCommand("PRC_EDIOrder_Insert", GetConnection(), transaction);
command.CommandType = CommandType.StoredProcedure;
foreach (KeyValuePair <string, ValuePair> pair in dic)
{
ValuePair vp = pair.Value;
AddParam(command, pair.Key, vp.value1, vp.value2);
}
command.ExecuteNonQuery();
//CSV出力
dic = new Dictionary <string, ValuePair>
{
{ "@EDIOrderNO", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dee.EDIOrderNO
} },
};
DataTable dt = new DataTable();
command = new SqlCommand("D_EDIOrder_SelectForCSV", GetConnection(), transaction);
command.CommandType = CommandType.StoredProcedure;
foreach (KeyValuePair <string, ValuePair> pair in dic)
{
ValuePair vp = pair.Value;
AddParam(command, pair.Key, vp.value1, vp.value2);
}
adapter = new SqlDataAdapter(command);
adapter.Fill(dt);
ExportCsv(dt, dtNow);
//CSV出力日時更新
if (dee.EDIOrderNO == null)
{
dic = new Dictionary <string, ValuePair>
{
{ "@SYSDATETIME", new ValuePair {
value1 = SqlDbType.VarChar, value2 = dtNow.ToString("yyyy/MM/dd HH:mm:ss")
} },
};
command = new SqlCommand("D_EDIOrder_UpdateOutputDateTime", GetConnection(), transaction);
command.CommandType = CommandType.StoredProcedure;
foreach (KeyValuePair <string, ValuePair> pair in dic)
{
ValuePair vp = pair.Value;
AddParam(command, pair.Key, vp.value1, vp.value2);
}
command.ExecuteNonQuery();
}
CommitTransaction();
return(true);
}
catch (Exception e)
{
RollBackTransaction();
throw e;
}
finally
{
command.Connection.Close();
}
}
/// <summary>
/// HEAD部のコードチェック
/// </summary>
/// <param name="index"></param>
/// <param name="set">画面展開なしの場合:falesに設定する</param>
/// <returns></returns>
private bool CheckDetail(int index, bool set = true)
{
bool ret;
DataTable dt;
EDIHacchuu_BL ble = new EDIHacchuu_BL();
switch (index)
{
case (int)EIndex.StoreCD:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
bbl.ShowMessage("E102");
CboStoreCD.Focus();
return(false);
}
else
{
if (!base.CheckAvailableStores(CboStoreCD.SelectedValue.ToString()))
{
bbl.ShowMessage("E141");
CboStoreCD.Focus();
return(false);
}
}
break;
case (int)EIndex.SyoriNO:
//入力不可の場合チェックなし
if (!detailControls[index].Enabled)
{
return(true);
}
//必須入力
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
bbl.ShowMessage("E102");
return(false);
}
//EDI発注(D_EDIOrder)に存在すること
//[D_EDIOrder]
dee = GetEntityForEDIOrder();
dt = ble.D_EDIOrder_Select(dee);
if (dt.Rows.Count == 0)
{
bbl.ShowMessage("E138", "EDI処理番号");
return(false);
}
else
{
//権限がない場合（以下のSelectができない場合）Error 「権限のないEDI発注番号」
if (!base.CheckAvailableStores(dt.Rows[0]["StoreCD"].ToString()))
{
bbl.ShowMessage("E139", "EDI処理番号");
return(false);
}
break;
}
case (int)EIndex.OrderDateFrom:
case (int)EIndex.OrderDateTo:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
return(true);
}
string strYmd = "";
switch (index)
{
default:
strYmd = bbl.FormatDate(detailControls[index].Text);
break;
}
//日付として正しいこと(Be on the correct date)Ｅ１０３
if (!bbl.CheckDate(strYmd))
{
//Ｅ１０３
bbl.ShowMessage("E103");
return(false);
}
switch (index)
{
default:
detailControls[index].Text = strYmd;
break;
}
//発注日(From) ≧ 発注日(To)である場合Error
if (index == (int)EIndex.OrderDateTo)
{
if (!string.IsNullOrWhiteSpace(detailControls[index - 1].Text) && !string.IsNullOrWhiteSpace(detailControls[index].Text))
{
int result = detailControls[index].Text.CompareTo(detailControls[index - 1].Text);
if (result < 0)
{
bbl.ShowMessage("E104");
detailControls[index].Focus();
return(false);
}
}
}
break;
case (int)EIndex.Vendor:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
//情報ALLクリア
ClearCustomerInfo();
return(true);
}
//[M_Vendor_Select]
M_Vendor_Entity mve = new M_Vendor_Entity
{
VendorCD = detailControls[index].Text,
ChangeDate = bbl.GetDate()
};
Vendor_BL sbl = new Vendor_BL();
ret = sbl.M_Vendor_SelectTop1(mve);
if (ret)
{
ScVendor.LabelText = mve.VendorName;
}
else
{
bbl.ShowMessage("E101");
//顧客情報ALLクリア
ClearCustomerInfo();
return(false);
}
break;
case (int)EIndex.Staff:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
//情報ALLクリア
ClearStaffInfo();
return(true);
}
//スタッフマスター(M_Staff)に存在すること
//[M_Staff]
M_Staff_Entity mse = new M_Staff_Entity
{
StaffCD = detailControls[index].Text,
ChangeDate = bbl.GetDate()
};
Staff_BL bl = new Staff_BL();
ret = bl.M_Staff_Select(mse);
if (ret)
{
if (mse.DeleteFlg == "1")
{
bbl.ShowMessage("E119");
//顧客情報ALLクリア
ClearStaffInfo();
return(false);
}
ScStaff.LabelText = mse.StaffName;
}
else
{
bbl.ShowMessage("E101");
//情報ALLクリア
ClearStaffInfo();
return(false);
}
break;
case (int)EIndex.OrderNO:
if (string.IsNullOrWhiteSpace(detailControls[index].Text))
{
return(true);
}
//発注(D_Order)に存在すること
//[D_Order]
string orderNo = detailControls[index].Text;
dt = ble.D_Order_SelectForEDIHacchuu(orderNo);
if (dt.Rows.Count == 0)
{
bbl.ShowMessage("E138", "発注番号");
return(false);
}
else
{
//DeleteDateTime 「削除された発注番号」
if (!string.IsNullOrWhiteSpace(dt.Rows[0]["DeleteDateTime"].ToString()))
{
bbl.ShowMessage("E140", "発注番号");
return(false);
}
//権限がない場合（以下のSelectができない場合）Error 「権限のないEDI発注番号」
if (!base.CheckAvailableStores(dt.Rows[0]["StoreCD"].ToString()))
{
bbl.ShowMessage("E139", "発注番号");
return(false);
}
break;
}
}
return(true);
}
