private bool chk_seisanbi1()
{
bool out_bl;
out_bl = true;
if (tb_seisanbi1.Text != "" && tb_seisanbi1.Text != null)
{
if (tss.Check_String_Escape(tb_seisanbi1.Text) == false)
{
out_bl = false;
}
else
{
if (tss.try_string_to_date(tb_seisanbi1.Text) == true)
{
tb_seisanbi1.Text = tss.out_datetime.ToShortDateString();
}
else
{
out_bl = false;
}
}
}
return(out_bl);
}
private bool chk_create_date1()
{
bool bl = true; //戻り値
if (tss.try_string_to_date(tb_create_date1.Text.ToString()) == false)
{
bl = false;
}
return(bl);
}
private void tb_hizuke_Validating(object sender, CancelEventArgs e)
{
if (tss.try_string_to_date(tb_hizuke.Text))
{
tb_hizuke.Text = tss.out_datetime.ToShortDateString();
kintai_disp();
w_hensyu_flg = 1;
}
else
{
tb_hizuke.Focus();
}
}
private string check_seisanbi()
{
string out_str = "**********";
if (tss.try_string_to_date(tb_seisanbi.Text.ToString()) == true)
{
out_str = tss.out_datetime.ToShortDateString();
}
else
{
out_str = "**********";
}
return(out_str);
}
private bool chk_sijibi(string in_str)
{
bool bl = true; //戻り値
//空白は許容する
if (in_str != "" && in_str != null)
{
if (tss.try_string_to_date(in_str) == false)
{
bl = false;
}
}
return(bl);
}
private void tb_create_datetime1_Validating(object sender, CancelEventArgs e)
{
if (tb_create_datetime1.Text != "")
{
if (tss.try_string_to_date(tb_create_datetime1.Text))
{
tb_create_datetime1.Text = tss.out_datetime.ToShortDateString();
}
else
{
MessageBox.Show("作成日に異常があります。");
e.Cancel = true;
}
}
}
private bool chk_seisan_yotei_date()
{
bool bl = true; //戻り値
if (tss.try_string_to_date(tb_seisan_yotei_date.Text.ToString()) == false)
{
bl = false;
}
return(bl);
}
private bool chk_uriage_date(string in_str)
{
bool bl = true; //戻り値
if (tss.try_string_to_date(in_str) == false)
{
bl = false;
}
return(bl);
}
private bool chk_siire_simebi(string in_str)
{
bool bl = true; //戻り値
if (tss.try_string_to_date(in_str) == false)
{
bl = false;
}
return(bl);
}
private bool chk_seikyu_simebi()
{
bool out_bl; //戻り値用
out_bl = true;
if (tss.try_string_to_date(tb_simebi.Text) == false)
{
out_bl = false;
}
return(out_bl);
}
private void tb_siire_simebi_Validating(object sender, CancelEventArgs e)
{
if (tb_siire_simebi.Text != "")
{
if (tss.try_string_to_date(tb_siire_simebi.Text.ToString()))
{
tb_siire_simebi.Text = tss.out_datetime.ToShortDateString();
}
else
{
MessageBox.Show("仕入締日の値が異常です。yyyymmddで入力してください。");
tb_siire_simebi.Focus();
}
}
dgv_siire_simebi.Rows.Clear();
tb_create_user_cd.Clear();
tb_create_datetime.Clear();
tb_update_user_cd.Clear();
tb_update_datetime.Clear();
}
private void tb_siharai_date_Leave(object sender, EventArgs e)
{
if (tb_siharai_date.Text != "")
{
if (tss.try_string_to_date(tb_siharai_date.Text.ToString()))
{
tb_siharai_date.Text = tss.out_datetime.ToShortDateString();
}
else
{
MessageBox.Show("支払日の値が異常です。yyyymmddで入力してください。");
tb_siharai_date.Focus();
}
}
}
private void kaikake_kousin() //買掛マスタの更新
{
////買掛マスタの更新
////支払マスタの支払額を、支払番号でまとめた支払金額（tb_siharai_soukeiの値）でアップデートする。
////買掛残高の再計算はしない
////支払マスタの取引先コード+仕入締日でまとめた支払額が、買掛マスタの仕入金額+消費税の値とイコールなら、買掛マスタに支払完了フラグを立てる
//DataTable dt_work = new DataTable();
//string siire_simebi = dgv_siharai.CurrentRow.Cells[0].Value.ToString();
//string siire_simebi2 = siire_simebi.Substring(0, 10);
//dt_work = tss.OracleSelect("select siharaigaku,tesuryou,sousai from tss_siharai_m where torihikisaki_cd = '" + tb_torihikisaki_cd.Text + "'and siire_simebi = '" + siire_simebi2.ToString() + "'");
//object obj = dt_work.Compute("Sum(siharaigaku)", null);
//object obj2 = dt_work.Compute("Sum(tesuryou)", null);
//object obj3 = dt_work.Compute("Sum(sousai)", null);
//decimal siharai_gaku = decimal.Parse(obj.ToString()) + decimal.Parse(obj2.ToString()) + decimal.Parse(obj3.ToString());
//bool bl2 = new bool();
//string str = dgv_siharai.Rows[0].Cells[0].Value.ToString();
//string str2 = str.Substring(0, 10);
//bl2 = tss.OracleUpdate("UPDATE TSS_kaikake_m SET siharaigaku = '"
// + siharai_gaku + "',siharai_kanryou_flg = '0',UPDATE_USER_CD = '" + tss.user_cd + "',UPDATE_DATETIME = SYSDATE WHERE torihikisaki_cd = '" + tb_torihikisaki_cd.Text.ToString() + "'and siire_simebi = '" + str2.ToString() + "'");
//if (bl2 != true)
//{
// tss.ErrorLogWrite(tss.user_cd, "買掛更新処理", "登録ボタン押下時のOracleInsert");
// MessageBox.Show("買掛更新処理でエラーが発生しました。" + Environment.NewLine + "処理を中止します。");
// this.Close();
//}
//else
//{
// //買掛マスタの支払完了フラグ更新
// dt_work = tss.OracleSelect("select * from tss_kaikake_m where torihikisaki_cd = '" + tb_torihikisaki_cd.Text + "'and siire_simebi = '" + str2.ToString() + "'");
// string siharaigaku = dt_work.Rows[0]["siharaigaku"].ToString();
// string siiregaku = dt_work.Rows[0]["siire_kingaku"].ToString();
// string syouhizeigaku = dt_work.Rows[0]["syouhizeigaku"].ToString();
// decimal keisan = decimal.Parse(siiregaku) + decimal.Parse(syouhizeigaku) - decimal.Parse(siharaigaku);
// if (keisan == 0)
// {
// tss.OracleUpdate("UPDATE TSS_kaikake_m SET siharai_kanryou_flg = '1',UPDATE_USER_CD = '" + tss.user_cd + "',UPDATE_DATETIME = SYSDATE WHERE torihikisaki_cd = '" + tb_torihikisaki_cd.Text.ToString() + "'and siire_simebi = '" + str2.ToString() + "'");
// }
// else
// {
// tss.OracleUpdate("UPDATE TSS_kaikake_m SET siharai_kanryou_flg = '0',UPDATE_USER_CD = '" + tss.user_cd + "',UPDATE_DATETIME = SYSDATE WHERE torihikisaki_cd = '" + tb_torihikisaki_cd.Text.ToString() + "'and siire_simebi = '" + str2.ToString() + "'");
// }
// MessageBox.Show("買掛処理登録しました。");
//}
//買掛マスタの更新
//支払マスタの支払額を、支払番号でまとめた支払金額（tb_siharai_soukeiの値）でアップデートする。
//支払マスタの取引先コード+仕入締日でまとめた支払額が、買掛マスタの仕入金額+消費税の値とイコールなら、買掛マスタに支払完了フラグを立てる。
//買掛マスタはフラグ立てるだけ
DataTable dt_work = new DataTable();
string siire_simebi = dgv_siharai.CurrentRow.Cells[0].Value.ToString();
string siire_simebi2 = siire_simebi.Substring(0, 10);
dt_work = tss.OracleSelect("select siharaigaku,tesuryou,sousai from tss_siharai_m where torihikisaki_cd = '" + tb_torihikisaki_cd.Text + "'and siire_simebi = '" + siire_simebi2.ToString() + "'");
object obj = dt_work.Compute("Sum(siharaigaku)", null);
object obj2 = dt_work.Compute("Sum(tesuryou)", null);
object obj3 = dt_work.Compute("Sum(sousai)", null);
decimal siharai_gaku = decimal.Parse(obj.ToString()) + decimal.Parse(obj2.ToString()) + decimal.Parse(obj3.ToString());
bool bl2 = new bool();
string str = dgv_siharai.Rows[0].Cells[0].Value.ToString();
string str2 = str.Substring(0, 10);
//前月の買掛マスタは更新しない。当月の買掛レコードを作成（支払額と繰越額のみ登録し、残りの項目はゼロで作成）
//当月の締日作成
DataTable w_dt = new DataTable();
//画面の仕入締日から1か月後の締日のレコードを作成する
DateTime w_datetime;
DataTable w_dt_simebi = new DataTable();
tss.try_string_to_date(dgv_mibarai.Rows[0].Cells[0].Value.ToString());
w_datetime = tss.out_datetime.AddMonths(1); //1か月後
w_dt_simebi = tss.OracleSelect("select * from tss_torihikisaki_m where torihikisaki_cd = '" + tb_torihikisaki_cd.Text + "'");
if (w_dt_simebi.Rows[0]["siharai_sime_date"].ToString() == "99")
{
w_datetime = new DateTime(w_datetime.Year, w_datetime.Month, DateTime.DaysInMonth(w_datetime.Year, w_datetime.Month)); //末日を求める
}
DataTable dt_2 = new DataTable();
dt_2 = tss.OracleSelect("select * from tss_kaikake_m where torihikisaki_cd = '" + tb_torihikisaki_cd.Text + "'and siire_simebi = '" + str2.ToString() + "'");
decimal kurikosigaku = decimal.Parse(dt_2.Rows[0][6].ToString());
bl2 = tss.OracleInsert("insert into tss_kaikake_m (torihikisaki_cd,siire_simebi,kurikosigaku,siharaigaku,siire_kingaku,syouhizeigaku,kaikake_zandaka,siharai_kanryou_flg,create_user_cd,create_datetime) values ('"
+ tb_torihikisaki_cd.Text.ToString() + "','"
+ w_datetime.ToShortDateString() + "','"
// + "to_date('" + dgv_mibarai.Rows[0].Cells[0].Value.ToString() + "','YYYY/MM/DD HH24:MI:SS'),'"
+ kurikosigaku + "','"
+ siharai_gaku + "','"
+ 0 + "','"
+ 0 + "','"
+ 0 + "','"
+ 0 + "','"
+ tss.user_cd + "',SYSDATE)");
if (bl2 != true)
{
tss.ErrorLogWrite(tss.user_cd, "買掛更新処理", "登録ボタン押下時のOracleInsert");
MessageBox.Show("買掛更新処理でエラーが発生しました。" + Environment.NewLine + "処理を中止します。");
this.Close();
}
else
{
//買掛マスタの支払完了フラグ更新
dt_work = tss.OracleSelect("select * from tss_kaikake_m where torihikisaki_cd = '" + tb_torihikisaki_cd.Text + "'and siire_simebi = '" + str2.ToString() + "'");
//string siharaigaku = dt_work.Rows[0]["siharaigaku"].ToString();
string siiregaku = dt_work.Rows[0]["siire_kingaku"].ToString();
string syouhizeigaku = dt_work.Rows[0]["syouhizeigaku"].ToString();
decimal keisan = decimal.Parse(siiregaku) + decimal.Parse(syouhizeigaku) - siharai_gaku; //decimal.Parse(siharaigaku);
if (keisan == 0)
{
tss.OracleUpdate("UPDATE TSS_kaikake_m SET siharai_kanryou_flg = '1',UPDATE_USER_CD = '" + tss.user_cd + "',UPDATE_DATETIME = SYSDATE WHERE torihikisaki_cd = '" + tb_torihikisaki_cd.Text.ToString() + "'and siire_simebi = '" + str2.ToString() + "'");
}
else
{
tss.OracleUpdate("UPDATE TSS_kaikake_m SET siharai_kanryou_flg = '0',UPDATE_USER_CD = '" + tss.user_cd + "',UPDATE_DATETIME = SYSDATE WHERE torihikisaki_cd = '" + tb_torihikisaki_cd.Text.ToString() + "'and siire_simebi = '" + str2.ToString() + "'");
}
//買掛マスタの支払完了フラグ更新（次月分）
DataTable dt_work2 = tss.OracleSelect("select * from tss_kaikake_m where torihikisaki_cd = '" + tb_torihikisaki_cd.Text + "'and siire_simebi = '" + w_datetime.ToShortDateString() + "'");
string kurikosigaku2 = dt_work2.Rows[0]["kurikosigaku"].ToString();
string siharaigaku2 = dt_work2.Rows[0]["siharaigaku"].ToString();
string siiregaku2 = dt_work2.Rows[0]["siire_kingaku"].ToString();
string syouhizeigaku2 = dt_work2.Rows[0]["syouhizeigaku"].ToString();
decimal keisan2 = decimal.Parse(kurikosigaku2) - decimal.Parse(siharaigaku2) + decimal.Parse(siiregaku2) + decimal.Parse(syouhizeigaku2);
if (keisan2 == 0)
{
tss.OracleUpdate("UPDATE TSS_kaikake_m SET siharai_kanryou_flg = '1',UPDATE_USER_CD = '" + tss.user_cd + "',UPDATE_DATETIME = SYSDATE WHERE torihikisaki_cd = '" + tb_torihikisaki_cd.Text.ToString() + "'and siire_simebi = '" + w_datetime.ToShortDateString() + "'");
}
else
{
tss.OracleUpdate("UPDATE TSS_kaikake_m SET siharai_kanryou_flg = '0',UPDATE_USER_CD = '" + tss.user_cd + "',UPDATE_DATETIME = SYSDATE WHERE torihikisaki_cd = '" + tb_torihikisaki_cd.Text.ToString() + "'and siire_simebi = '" + w_datetime.ToShortDateString() + "'");
}
MessageBox.Show("買掛処理登録しました。");
}
//フォームの初期化必要？
}
