///<summary>
///登録
///</summary>
private void addInput()
{
// 入力チェック
if (!this.chkInput())
{
return;
}
DBConnective con = new DBConnective();
A0110_KakohinTehaiInput_B bis = new A0110_KakohinTehaiInput_B();
try
{
bool bShukko = false;
int lineCnt = 1;
for (int i = 0; i < MAX_ROW_S; i++)
{
if (!string.IsNullOrWhiteSpace(InputLineSs[i].txtHinban.Text))
{
bShukko = true;
break;
}
}
string stDenNo = txtDenNo.Text;
if (bShukko && string.IsNullOrWhiteSpace(stDenNo))
{
stDenNo = bis.getDenpyoNo("出庫伝票");
}
con.BeginTrans();
// 出庫登録
#region
if (bShukko)
{
string[] stHead = new string[]
{ stDenNo,
txtYMD.Text,
lsTorihikisaki.CodeTxtText,
lsTorihikikbn.CodeTxtText,
lsTantosha.CodeTxtText,
txtEigyo.Text,
Environment.UserName,
lsTorihikisaki.ValueLabelText };
bis.addShukkoHead(con, stHead);
bis.delShukkoMeisai(con, stDenNo);
for (int i = 0; i < MAX_ROW_S; i++)
{
if (!string.IsNullOrWhiteSpace(InputLineSs[i].txtHinban.Text))
{
string stDai = InputLineSs[i].lsDaibun.CodeTxtText;
string stChu = InputLineSs[i].lsChubun.CodeTxtText;
string stMak = InputLineSs[i].lsMaker.CodeTxtText;
string stSho = InputLineSs[i].txtShohin.Text;
string stC1 = InputLineSs[i].txtC1.Text;
// 商品コードが無い場合、雑費扱い
if (string.IsNullOrWhiteSpace(stSho))
{
stDai = "00";
stChu = "00";
stMak = "0000";
stSho = "88888";
stC1 = InputLineSs[i].txtHinban.Text;
}
string[] stMeisai = new string[]
{ stDenNo, //0 num
lineCnt.ToString(), //1 num
stSho, //2
stMak, //3
stDai, //4
stChu, //5
stC1, //6
InputLineSs[i].txtC2.Text, //7
InputLineSs[i].txtC3.Text, //8
InputLineSs[i].txtC4.Text, //9
InputLineSs[i].txtC5.Text, //10
InputLineSs[i].txtC6.Text, //11
decimal.Parse(InputLineSs[i].txtSuryo.Text).ToString(), //12 num
decimal.Parse(InputLineSs[i].txtTanka.Text).ToString(), //13 num
InputLineSs[i].txtBiko.Text, //14
InputLineSs[i].lsSouko.CodeTxtText, //15
"0", //16 num
txtYMD.Text, //17
Environment.UserName //18
};
bis.addShukkoMeisai(con, stMeisai);
lineCnt++;
}
}
}
#endregion
// 発注登録
#region
string stHatchuNo = "";
if (string.IsNullOrWhiteSpace(stDenNo))
{
stDenNo = "0";
}
for (int i = 0; i < arr.Count; i++)
{
bis.delHaychu(con, arr[i], Environment.UserName);
}
lineCnt = 1;
for (int i = 0; i < MAX_ROW_K; i++)
{
stHatchuNo = InputLineKs[i].txtHNo.Text;
if (string.IsNullOrWhiteSpace(stHatchuNo))
{
stHatchuNo = bis.getDenpyoNo("発注番号");
}
if (!string.IsNullOrWhiteSpace(InputLineKs[i].txtHinban.Text))
{
string stDai = InputLineKs[i].lsDaibun.CodeTxtText;
string stChu = InputLineKs[i].lsChubun.CodeTxtText;
string stMak = InputLineKs[i].lsMaker.CodeTxtText;
string stSho = InputLineKs[i].txtShohin.Text;
string stC1 = InputLineKs[i].txtC1.Text;
// 商品コードが無い場合、雑費扱い
if (string.IsNullOrWhiteSpace(stSho))
{
stDai = "00";
stChu = "00";
stMak = "0000";
stSho = "88888";
stC1 = InputLineKs[i].txtHinban.Text;
}
string[] stHatchu = new string[]
{
lsTorihikisaki.CodeTxtText, //0
txtYMD.Text, //1
stHatchuNo, //2 num
lsTantosha.CodeTxtText, //3
txtEigyo.Text, //4
lsTantosha.CodeTxtText, //5
"0", //6 num
stDenNo, //7 num
lineCnt.ToString(), //8 num
stSho, //9
stMak, //10
stDai, //11
stChu, //12
stC1, //13
InputLineKs[i].txtC2.Text, //14
InputLineKs[i].txtC3.Text, //15
InputLineKs[i].txtC4.Text, //16
InputLineKs[i].txtC5.Text, //17
InputLineKs[i].txtC6.Text, //18
decimal.Parse(InputLineKs[i].txtSuryo.Text).ToString(), //19 num
decimal.Parse(InputLineKs[i].txtTanka.Text).ToString(), //20 num
"0", //21 num
InputLineKs[i].txtNoki.Text, //22
"0", //23 num
InputLineKs[i].txtBiko.Text, //24
"1", //25 num
lsTorihikisaki.ValueLabelText, //26
Environment.UserName //27
};
bis.addHatchu(con, stHatchu);
lineCnt++;
}
}
#endregion
con.Commit();
//メッセージボックスの処理、登録完了のウィンドウ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_TOUROKU, CommonTeisu.LABEL_TOUROKU, CommonTeisu.BTN_OK, CommonTeisu.DIAG_INFOMATION);
basemessagebox.ShowDialog();
clearInput();
}
catch (Exception ex)
{
con.Rollback();
// エラーロギング
new CommonException(ex);
// メッセージボックスの処理、削除失敗の場合のウィンドウ（OK）
BaseMessageBox basemessagebox = new BaseMessageBox(this, CommonTeisu.TEXT_VIEW, CommonTeisu.LABEL_ERROR_MESSAGE, CommonTeisu.BTN_OK, CommonTeisu.DIAG_ERROR);
basemessagebox.ShowDialog();
}
finally
{
con.DB_Disconnect();
}
}
