protected override void ExecDisp()
{
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
doe = GetSearchInfo();
DataTable dt = nnbl.D_Collect_SelectAll(doe);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
Btn_F10.Enabled = true;
}
else
{
nnbl.ShowMessage("E128");
}
}
protected override void ExecDisp()
{
dje = new D_DeliveryPlan_Entity
{
DeliveryPlanNO = DeliveryPlanNO,
};
DataTable dt = nnbl.D_DeliveryPlan_SelectData(dje);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
lblJyuchuNo.Text = JuchuNO;
lblDeliveryName.Text = dt.Rows[0]["DeliveryName"].ToString();
lblDeliveryAddress1.Text = dt.Rows[0]["DeliveryAddress1"].ToString();// + " " + dt.Rows[0]["DeliveryAddress2"].ToString();
lblDecidedDeliveryDate.Text = dt.Rows[0]["DecidedDeliveryDate"].ToString();
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
nnbl.ShowMessage("E128");
EndSec();
}
}
protected override void ExecDisp()
{
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
//更新処理
doe = GetEntity();
DataTable dt = mibl.D_CollectPlan_SelectAllForSyokai(doe);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
bbl.ShowMessage("E128");
}
}
protected override void ExecDisp()
{
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
//受注あり
if (!((CheckBox)detailControls[(int)EIndex.ChkJuchuAri]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkZaiko]).Checked)
{
bbl.ShowMessage("E111");
detailControls[(int)EIndex.ChkJuchuAri].Focus();
return;
}
//承認状況
if (!((CheckBox)detailControls[(int)EIndex.ChkSyoninzumi]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkMisyonin]).Checked)
{
bbl.ShowMessage("E111");
detailControls[(int)EIndex.ChkMisyonin].Focus();
return;
}
//納入先
if (!((CheckBox)detailControls[(int)EIndex.ChkChokuso]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkSouko]).Checked)
{
bbl.ShowMessage("E111");
detailControls[(int)EIndex.ChkChokuso].Focus();
return;
}
//発注方法
if (!((CheckBox)detailControls[(int)EIndex.ChkNet]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkFax]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkEdi]).Checked)
{
bbl.ShowMessage("E111");
detailControls[(int)EIndex.ChkNet].Focus();
return;
}
doe = GetSearchInfo();
DataTable dt = ssbl.D_Order_SelectAllForShoukai(doe, mse, InOperatorCD, InPcID);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
Btn_F10.Enabled = true;
}
else
{
ssbl.ShowMessage("E128");
}
}
protected override void ExecDisp()
{
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
//進捗状況
if (!((CheckBox)detailControls[(int)EIndex.ChkMihikiate]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkMiuriage]).Checked &&
!((CheckBox)detailControls[(int)EIndex.ChkMiseikyu]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkMinyukin]).Checked &&
!((CheckBox)detailControls[(int)EIndex.ChkAll]).Checked)
{
bbl.ShowMessage("E111");
detailControls[(int)EIndex.ChkMihikiate].Focus();
return;
}
//受注種別
if (!((CheckBox)detailControls[(int)EIndex.ChkTujo]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkHenpin]).Checked)
{
bbl.ShowMessage("E111");
detailControls[(int)EIndex.ChkTujo].Focus();
return;
}
//発注状況
if (!((CheckBox)detailControls[(int)EIndex.ChkMinyuka]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkMihachu]).Checked &&
!((CheckBox)detailControls[(int)EIndex.ChkNokiKaito]).Checked && !((CheckBox)detailControls[(int)EIndex.ChkMisiire]).Checked &&
!((CheckBox)detailControls[(int)EIndex.ChkHachuAll]).Checked)
{
bbl.ShowMessage("E111");
detailControls[(int)EIndex.ChkMihachu].Focus();
return;
}
dje = GetSearchInfo();
DataTable dt = ssbl.D_Juchu_SelectAll(dje, mse);
GvDetail.DataSource = null;
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
btnSubF10.Enabled = true;
}
else
{
btnSubF10.Enabled = false;
ssbl.ShowMessage("E128");
}
}
protected override void ExecDisp()
{
try
{
//【取込履歴】
M_MultiPorpose_Entity me = new M_MultiPorpose_Entity
{
ID = MultiPorpose_BL.ID_ShukkaUriageUpdate,
Key = "1"
};
MultiPorpose_BL mbl = new MultiPorpose_BL();
DataTable dt = mbl.M_MultiPorpose_Select(me);
if (dt.Rows.Count > 0)
{
string time = Convert.ToInt16(dt.Rows[0]["Num1"]).ToString("D4");
ckM_TextBox1.Text = time.Substring(0, 2) + ":" + time.Substring(2, 2);
}
else
{
////Ｅ１０１
//bbl.ShowMessage("E101");
//EndSec();
ckM_TextBox1.Text = "";
}
Scr_Clr(0);
//更新履歴情報データ取得処理
dt = sbl.D_Shipping_SelectAllForShoukai();
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
//bbl.ShowMessage("E128");
}
}
catch (Exception ex)
{
//エラー時共通処理
MessageBox.Show(ex.Message);
//EndSec();
}
}
private void GvDetail_CurrentCellDirtyStateChanged(object sender, EventArgs e)
{
try
{
if (GvDetail.CurrentCellAddress.X == 0 && GvDetail.IsCurrentCellDirty)
{
//コミットする
GvDetail.CommitEdit(DataGridViewDataErrorContexts.Commit);
}
}
catch (Exception ex)
{
//エラー時共通処理
MessageBox.Show(ex.Message);
//EndSec();
}
}
protected override void ExecDisp()
{
bool exists = false;
for (int i = 0; i < detailControls.Length; i++)
{
if (i != (int)EIndex.StoreCD && !string.IsNullOrWhiteSpace(detailControls[i].Text))
{
exists = true;
}
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
if (!exists)
{
tjbl.ShowMessage("E111");
detailControls[0].Focus();
return;
}
doe = GetSearchInfo();
DataTable dt = tjbl.D_Order_SelectData_SeachHacchuuShoriNO(doe.StoreCD, doe.OrderDateFrom, doe.OrderDateTo, doe.StaffCD);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
tjbl.ShowMessage("E128");
}
}
protected override void ExecDisp()
{
bool exists = false;
for (int i = 0; i < detailControls.Length; i++)
{
if (i != (int)EIndex.StoreCD && !string.IsNullOrWhiteSpace(detailControls[i].Text))
{
exists = true;
}
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
if (!exists)
{
snbl.ShowMessage("E111");
detailControls[0].Focus();
return;
}
dpe = GetSearchInfo();
DataTable dt = snbl.D_Purchase_SelectAll(dpe, mse);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
snbl.ShowMessage("E128");
}
}
protected override void ExecDisp()
{
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
//更新処理
doe = GetEntity();
DataTable dt = tabl.D_Inventory_SelectAll(doe);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.CellSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
GvDetail.CurrentCell = GvDetail[(int)EColNo.ActualQuantity, 0];
GvDetail.ReadOnly = false;
for (int i = 0; i < (int)EColNo.COUNT; i++)
{
if (i == (int)EColNo.ActualQuantity)
{
GvDetail.Columns[i].ReadOnly = false;
}
else
{
GvDetail.Columns[i].ReadOnly = true;
}
}
}
else
{
bbl.ShowMessage("E128");
}
}
protected override void ExecDisp()
{
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
D_Billing_Entity dbe = new D_Billing_Entity
{
StoreCD = CboStoreCD.SelectedValue.ToString(),
BillingCustomerCD = detailControls[(int)EIndex.CustomerCD].Text,
BillingCloseDate = detailControls[(int)EIndex.SeqSDT].Text,
};
M_Customer_Entity mce = new M_Customer_Entity
{
BillingCloseDate = detailControls[(int)EIndex.Simbi].Text
};
DataTable dt = ssbl.D_Billing_SelectAll(dbe, mce);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
lblSum.Text = bbl.Z_SetStr(dt.Rows[0]["SUM_BillingGaku"].ToString());
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
lblSum.Text = "";
ssbl.ShowMessage("E128");
}
}
protected override void ExecDisp()
{
dje = new D_Juchuu_Entity
{
JuchuuNO = JuchuuNO,
};
DataTable dt = nnbl.D_Juchuu_SelectData_ForNyuuka(dje);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
nnbl.ShowMessage("E128");
}
}
protected override void ExecDisp()
{
bool inputFlg = false;
for (int i = 0; i < detailControls.Length; i++)
{
if (!string.IsNullOrWhiteSpace(detailControls[i].Text))
{
inputFlg = true;
}
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
if (inputFlg == false)
{
//全てが空白(入力が無い)場合、エラーとする。
sbl.ShowMessage("E111");
return;
}
M_SKUInfo_Entity msie = new M_SKUInfo_Entity();
mse = GetSearchInfo(msie);
DataTable dt = sbl.M_SKU_SelectForSearchProduct(mse, msie);
if (dt.Rows.Count > 0)
{
//ストアドで実装するように変更
//if (!string.IsNullOrWhiteSpace(detailControls[(int)EIndex.ITemCD].Text))
//{
// string[] itemDt = detailControls[(int)EIndex.ITemCD].Text.Split(',');
// if (itemDt.Length > 0)
// {
// //foreach (DataRow dr in dt.Rows)
// for(int i=dt.Rows.Count-1; 0<=i; i--)
// {
// int index = Array.IndexOf(itemDt, dt.Rows[i]["ItemCD"].ToString());
// if (index < 0)
// {
// dt.Rows.Remove(dt.Rows[i]);
// }
// }
// }
//}
//if (!string.IsNullOrWhiteSpace(detailControls[(int)EIndex.MakerItem].Text))
//{
// string[] makerDt = detailControls[(int)EIndex.MakerItem].Text.Split(',');
// if (makerDt.Length > 0)
// {
// for (int i = dt.Rows.Count - 1; 0 <= i; i--)
// {
// int index = Array.IndexOf(makerDt, dt.Rows[i]["MakerItem"].ToString());
// if (index < 0)
// {
// dt.Rows.Remove(dt.Rows[i]);
// }
// }
// }
//}
if (ChkSearch.Checked)
{
string[] item = new string[dt.Rows.Count];
int itemCount = 0;
if (ckM_RadioButton3.Checked)
{
foreach (DataRow dr in dt.Rows)
{
int index = Array.IndexOf(item, dr["ItemCD"].ToString());
if (index < 0)
{
item[itemCount] = dr["ItemCD"].ToString();
itemCount++;
}
}
string val = "";
for (int i = 0; i < itemCount; i++)
{
if (i == 0)
{
val += item[i];
}
else
{
val += "," + item[i];
}
}
detailControls[(int)EIndex.ITemCD].Text = val;
}
else
{
foreach (DataRow dr in dt.Rows)
{
int index = Array.IndexOf(item, dr["MakerItem"].ToString());
if (index < 0)
{
item[itemCount] = dr["MakerItem"].ToString();
itemCount++;
}
}
string val = "";
for (int i = 0; i < itemCount; i++)
{
if (i == 0)
{
val += item[i];
}
else
{
val += "," + item[i];
}
}
detailControls[(int)EIndex.MakerItem].Text = val;
}
}
GvDetail.DataSource = dt;
GvDetail.ScrollBars = ScrollBars.Both;
GvDetail.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
GvDetail.CurrentRow.Selected = true;
if (Mode == "5")
{
GvDetail.ReadOnly = false;
for (int i = 0; i < GvDetail.ColumnCount; i++)
{
if (i.Equals(0))
{
GvDetail.Columns[i].ReadOnly = false;
}
else
{
GvDetail.Columns[i].ReadOnly = true;
}
}
}
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
sbl.ShowMessage("E128");
}
}
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();
}
}
protected void GvDetail_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
BindGrid(GvDetail);
GvDetail.PageIndex = e.NewPageIndex;
GvDetail.DataBind();
}
protected void btnForm_Click(object sender, EventArgs e)
{
GvDetail.DataSource = null;
GvDetail.DataBind();
Response.Redirect("Feedback_Form.aspx");
}
protected override void ExecSec()
{
try
{
//【取込履歴】
M_MultiPorpose_Entity me = new M_MultiPorpose_Entity
{
ID = MultiPorpose_BL.ID_EDI,
Key = "1"
};
MultiPorpose_BL mbl = new MultiPorpose_BL();
DataTable dt = mbl.M_MultiPorpose_Select(me);
if (dt.Rows.Count > 0)
{
//[999日間の履歴を保持しています]
lblRireki.Text = dt.Rows[0]["Num3"].ToString() + "日間の履歴を保持しています";
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();
}
Scr_Clr(0);
//履歴データ取得処理
dt = mibl.D_Edi_SelectAll();
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
GvDetail.Enabled = true;
GvDetail.ReadOnly = false;
for (int row = 0; row < GvDetail.RowCount; row++)
{
for (int col = (int)EColNo.Chk + 1; col < GvDetail.ColumnCount; col++)
{
GvDetail[col, row].ReadOnly = true;
}
}
GvDetail.Focus();
}
else
{
bbl.ShowMessage("E128");
}
}
catch (Exception ex)
{
//エラー時共通処理
MessageBox.Show(ex.Message);
//EndSec();
}
}
protected override void ExecDisp()
{
for (int i = 0; i < detailControls.Length; i++)
{
if (CheckDetail(i) == false)
{
detailControls[i].Focus();
return;
}
}
//更新処理
doe = GetEntity();
DataTable dt = mibl.D_MoveRequest_SelectAllForShoukai(doe);
GvDetail.DataSource = dt;
if (dt.Rows.Count > 0)
{
GvDetail.SelectionMode = DataGridViewSelectionMode.RowHeaderSelect;
GvDetail.CurrentRow.Selected = true;
for (int wRow = 0; wRow < GvDetail.RowCount; wRow++)
{
//AnswerKBN ＝ 1が1件以上の場合、明細行の色は淡い青色
if (bbl.Z_Set(GvDetail["AnswerKBN_CNT1", wRow].Value) >= 1)
{
for (int wCol = 0; wCol < GvDetail.ColumnCount; wCol++)
{
//セルスタイルを変更する
GvDetail[wCol, wRow].Style.BackColor = Color.DeepSkyBlue;
}
}
else
{
//AnswerKBN＝ 1が0件かつAnswerKBN＝ 9が1件以上の場合、明細は淡い赤色
if (bbl.Z_Set(GvDetail["AnswerKBN_CNT9", wRow].Value) >= 1)
{
for (int wCol = 0; wCol < GvDetail.ColumnCount; wCol++)
{
//セルスタイルを変更する
GvDetail[wCol, wRow].Style.BackColor = Color.LightSalmon;
}
}
else
{
//AnswerKBN＝ 1が0件かつAnswerKBN＝ 9が0件かつAnswerKBN＝ 0が1件以上の場合、灰色
for (int wCol = 0; wCol < GvDetail.ColumnCount; wCol++)
{
//セルスタイルを変更する
GvDetail[wCol, wRow].Style.BackColor = ClsGridBase.GrayColor;
}
}
}
}
GvDetail.Enabled = true;
GvDetail.Focus();
}
else
{
bbl.ShowMessage("E128");
}
}
