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("買掛処理登録しました。"); } //フォームの初期化必要? }