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; } } 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; } } //受注あり 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 { ////E101 //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(); } }
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") { //汎用マスター. 数字型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(); } }
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") { //汎用マスター. 数字型1=1なら、「処理実行中」として青色 lblEdiMode.Text = "処理実行中"; lblEdiMode.BackColor = Color.DeepSkyBlue; } else { //汎用マスター. 数字型1=0なら、「処理停止中」として黄色 lblEdiMode.Text = "処理停止中"; lblEdiMode.BackColor = Color.Yellow; } } else { //E101 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"); } }