private void btn_buhin_kensaku_Click(object sender, EventArgs e)
{
//部品検索
if (tss.User_Kengen_Check(4, 3) == false)
{
MessageBox.Show("権限がありません");
return;
}
tss.search_buhin("1", "");
}
private void tb_buhin_cd1_DoubleClick(object sender, EventArgs e)
{
//選択画面へ
string w_buhin_cd;
w_buhin_cd = tss.search_buhin("2", tb_buhin_cd1.Text);
if (w_buhin_cd != "")
{
tb_buhin_cd1.Text = w_buhin_cd;
}
}
private void tb_buhin_cd_DoubleClick(object sender, EventArgs e)
{
//選択画面へ
string w_buhin_cd;
w_buhin_cd = tss.search_buhin("2", "");
if (w_buhin_cd != "")
{
tb_buhin_cd.Text = w_buhin_cd;
chk_buhin_cd(); //決算区分名の表示
}
}
private void tb_buhinn_cd_DoubleClick(object sender, EventArgs e)
{
//選択画面へ
string w_cd;
w_cd = tss.search_buhin("2", "");
if (w_cd != "")
{
tb_buhin_cd.Text = w_cd;
tb_buhin_name.Text = get_buhin_name(tb_buhin_cd.Text);
btn_kensaku.Focus();
}
}
private void tb_buhin_cd_DoubleClick(object sender, EventArgs e)
{
//選択画面へ
string w_buhin_cd;
w_buhin_cd = tss.search_buhin("2", tb_buhin_cd.Text);
if (w_buhin_cd == "")
{
return;
}
else
{
tb_buhin_cd.Text = w_buhin_cd;
tb_buhin_name.Text = tss.get_buhin_name(w_buhin_cd);
kensaku();
}
}
private void dgv_idou_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
int i = e.ColumnIndex;
if (i == 0)
{
//選択画面へ
string w_buhin_cd;
w_buhin_cd = tss.search_buhin("2", "");
if (w_buhin_cd != "")
{
dgv_idou.CurrentCell.Value = w_buhin_cd;
dgv_idou.Rows[e.RowIndex].Cells[i + 1].Value = tss.get_buhin_name(w_buhin_cd);
dgv_idou.EndEdit();
}
}
if (i == 3)
{
if (dgv_idou.CurrentRow.Cells[2].Value == null || dgv_idou.CurrentRow.Cells[2].Value.ToString() != "01")
{
//torihikisaki_dc_ck();
//選択画面へ
string w_cd;
w_cd = tss.search_torihikisaki("2", "");
if (w_cd != "")
{
dgv_idou.CurrentCell.Value = w_cd;
if (dgv_idou.Rows[e.RowIndex].Cells[0].Value != null)
{
//torihikisaki_ckメソッド
string str = dgv_idou.Rows[e.RowIndex].Cells[0].Value.ToString();
string str2 = w_cd;
DataTable dt_w2 = new DataTable();
dt_w2 = tss.OracleSelect("select torihikisaki_cd from tss_buhin_m where buhin_cd = '" + str + "'");
if (dt_w2.Rows.Count == 0)
{
MessageBox.Show("入力された移動先取引先コードが存在しません");
return;
}
else
{
string str3 = dt_w2.Rows[0][0].ToString();
if (str2 == str3)
{
}
else
{
DialogResult result = MessageBox.Show("移動する部品コードの取引先コードと部品マスタの取引先コードが異なりますがよろしいですか？",
"部品入移動登録",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
if (result == DialogResult.OK)
{
dgv_idou.EndEdit();
//dgv_seihin_kousei.EndEdit();
dgv_idou.Focus();
}
if (result == DialogResult.Cancel)
{
return;
}
}
}
}
}
dgv_idou.EndEdit();
}
else
{
return;
}
}
if (i == 7)
{
if (dgv_idou.CurrentRow.Cells[6].Value == null || dgv_idou.CurrentRow.Cells[6].Value.ToString() != "01")
{
//選択画面へ
string w_cd;
w_cd = tss.search_torihikisaki("2", "");
if (w_cd != "")
{
dgv_idou.CurrentCell.Value = w_cd;
if (dgv_idou.Rows[e.RowIndex].Cells[0].Value != null)
{
//torihikisaki_ckメソッド
string str = dgv_idou.Rows[e.RowIndex].Cells[0].Value.ToString();
string str2 = w_cd;
DataTable dt_w2 = new DataTable();
dt_w2 = tss.OracleSelect("select torihikisaki_cd from tss_buhin_m where buhin_cd = '" + str + "'");
if (dt_w2.Rows.Count == 0)
{
MessageBox.Show("入力された移動先取引先コードが存在しません");
return;
}
else
{
string str3 = dt_w2.Rows[0][0].ToString();
if (str2 == str3)
{
}
else
{
DialogResult result = MessageBox.Show("移動する部品コードの取引先コードと部品マスタの取引先コードが異なりますがよろしいですか？",
"部品入移動登録",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
if (result == DialogResult.OK)
{
dgv_idou.EndEdit();
//dgv_seihin_kousei.EndEdit();
dgv_idou.Focus();
}
if (result == DialogResult.Cancel)
{
return;
}
}
}
}
}
dgv_idou.EndEdit();
}
else
{
return;
}
}
if (i == 4)
{
if (dgv_idou.CurrentRow.Cells[2].Value == null)
{
MessageBox.Show("取引先コードを入力してください");
return;
}
if (dgv_idou.CurrentRow.Cells[3].Value == null && dgv_idou.CurrentRow.Cells[2].Value.ToString() != "01")
{
MessageBox.Show("取引先コードを入力してください");
return;
}
if (dgv_idou.CurrentRow.Cells[2].Value == null || dgv_idou.CurrentRow.Cells[2].Value.ToString() != "01")
{
//選択画面へ
string w_juchu_cd;
w_juchu_cd = tss.search_juchu("2", dgv_idou.CurrentRow.Cells[3].Value.ToString(), "", "", "");
if (w_juchu_cd.ToString() != "")
{
string str_w2 = w_juchu_cd.Substring(6, 16).TrimEnd();
string str_w3 = w_juchu_cd.Substring(22).TrimEnd();
dgv_idou.CurrentRow.Cells[i].Value = str_w2.ToString();
dgv_idou.CurrentRow.Cells[i + 1].Value = str_w3.ToString();
dgv_idou.EndEdit();
}
}
else
{
return;
}
}
if (i == 8)
{
if (dgv_idou.CurrentRow.Cells[6].Value == null)
{
MessageBox.Show("移動先取引先コードを入力してください");
return;
}
if (dgv_idou.CurrentRow.Cells[7].Value == null && dgv_idou.CurrentRow.Cells[6].Value.ToString() != "01")
{
MessageBox.Show("移動先取引先コードを入力してください");
return;
}
if (dgv_idou.CurrentRow.Cells[6].Value == null || dgv_idou.CurrentRow.Cells[6].Value.ToString() != "01")
{
//選択画面へ
string w_juchu_cd;
w_juchu_cd = tss.search_juchu("2", dgv_idou.CurrentRow.Cells[7].Value.ToString(), "", "", "");
if (w_juchu_cd.ToString() != "")
{
string str_w2 = w_juchu_cd.Substring(6, 16).TrimEnd();
string str_w3 = w_juchu_cd.Substring(22).TrimEnd();
dgv_idou.CurrentRow.Cells[i].Value = str_w2.ToString();
dgv_idou.CurrentRow.Cells[i + 1].Value = str_w3.ToString();
dgv_idou.EndEdit();
}
}
else
{
return;
}
}
}
private void btn_buhin_kensaku_Click(object sender, EventArgs e)
{
//検索画面へ
tss.search_buhin("1", "");
}
private void dgv_seihin_kousei_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
int i = e.ColumnIndex;
if (i == 1 || i == 4)
{
//選択画面へ
string w_buhin_cd;
dgv_seihin_kousei.EndEdit();
w_buhin_cd = tss.search_buhin("2", dgv_seihin_kousei.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString());
if (w_buhin_cd != "")
{
dgv_seihin_kousei.CurrentCell.Value = w_buhin_cd;
string str1;
string str2;
DataTable dt_w = new DataTable();
DataTable dt_w2 = new DataTable();
dt_w = tss.OracleSelect("select torihikisaki_cd from TSS_SEIHIN_M WHERE seihin_cd = '" + tb_seihin_cd.Text.ToString() + "'");
str1 = dt_w.Rows[0][0].ToString();
dt_w2 = tss.OracleSelect("select torihikisaki_cd from TSS_BUHIN_M WHERE buhin_cd = '" + w_buhin_cd.ToString() + "'");
if (dt_w2.Rows.Count == 0)
{
return;
}
//if (w_buhin_cd.ToString() == dgv_seihin_kousei.CurrentCell.Value.ToString())
//{
//}
else
{
str2 = dt_w2.Rows[0][0].ToString();
if (str1 != str2)
{
DialogResult result = MessageBox.Show("製品マスタの取引先コードと部品マスタの取引先コードが異なりますが登録しますか？",
"製品構成登録",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Exclamation,
MessageBoxDefaultButton.Button1);
if (result == DialogResult.OK)
{
dgv_seihin_kousei.EndEdit();
//dgv_seihin_kousei.EndEdit();
dgv_seihin_kousei.Focus();
}
if (result == DialogResult.Cancel)
{
dgv_seihin_kousei.Rows[e.RowIndex].Cells[i + 1].Value = "";
return;
}
}
}
dgv_seihin_kousei.Rows[e.RowIndex].Cells[i + 1].Value = tss.get_buhin_name(w_buhin_cd);
dgv_seihin_kousei.EndEdit();
}
}
}
