예제 #1
0
        /// <summary>
        /// 詳細情報変更チェック処理
        /// </summary>
        /// <param name="bindingData"></param>
        /// <param name="strKaisyaCode_old"></param>
        /// <returns></returns>
        private bool Chk_SyosaiChange(BindingData bindingData, string strKaisyaCode_old)
        {
            if (strKaisyaCode_old == "")
            {
                // 旧情報無し
                return(false);
            }

            // キー項目を確認
            if (!(bindingData.KaisyaCode.text.Equals(strKaisyaCode_old)))
            {
                return(true);
            }

            // キー項目以外でバインド元データと差異があるか確認
            DataRow dRows = bindingData.KaisyaInfo.Select("kaisya_code = '" + bindingData.KaisyaCode.text + "'")[0];

            if (!(dRows[Com02.struct_m_kaisya.idx_kaisya_name].ToString() == bindingData.KaisyaName.text))
            {
                return(true);
            }

            // 変更なし
            return(false);
        }
예제 #2
0
 private void Set_ProjectInit(BindingData clsBindData)
 {
     /*
      * // DB接続
      * SqlServer clsSqlServer = new SqlServer(Com01.clsSystemInfo.SystemDatabase);
      * clsSqlServer.Connect();
      */
 }
예제 #3
0
        /// <summary>
        /// 引数のデータテーブルからマテリアルコードが一致する値を詳細にセットする。
        /// </summary>
        /// <param name="bindingData"></param>
        /// <param name="kaisyaCode"></param>
        /// <param name="kaisyaCode_old"></param>
        private void Set_SyosaiInfo(BindingData bindingData, string kaisyaCode, ref string materialCode_old)
        {
            // Selectメソッドを使ってデータを抽出
            DataRow[] dRowsRecode = bindingData.KaisyaInfo.Select("kaisya_code = '" + kaisyaCode + "'");
            if (dRowsRecode == null || dRowsRecode.Length > 1)
            {
                // なぜこうなるのか
                return;
            }

            // 無効フラグ
            if (dRowsRecode[0].ItemArray[Com02.struct_m_kaisya.idx_invalid_flg].ToString() == "1")
            {
                bindingData.InvalidFlg = new CheckItem(true, "");
            }
            else
            {
                bindingData.InvalidFlg = new CheckItem(false, "");
            }

            string[] postal = dRowsRecode[0].ItemArray[Com02.struct_m_kaisya.idx_postal_code].ToString().Split('-');
            bindingData.PostalCode_1 = new TextItem(postal[0], "");
            bindingData.PostalCode_2 = new TextItem(postal[1], "");

            bindingData.KaisyaCode       = new TextItem(dRowsRecode[0].ItemArray[Com02.struct_m_kaisya.idx_kaisya_code].ToString(), "");
            bindingData.KaisyaName       = new TextItem(dRowsRecode[0].ItemArray[Com02.struct_m_kaisya.idx_kaisya_name].ToString(), "");
            bindingData.KaisyaName_Kana  = new TextItem(dRowsRecode[0].ItemArray[Com02.struct_m_kaisya.idx_kaisya_name_kana].ToString(), "");
            bindingData.KaisyaName_Ryaku = new TextItem(dRowsRecode[0].ItemArray[Com02.struct_m_kaisya.idx_kaisya_name_ryaku].ToString(), "");
            bindingData.Address          = new TextItem(dRowsRecode[0].ItemArray[Com02.struct_m_kaisya.idx_address].ToString(), "");
            bindingData.TelNo            = new TextItem(dRowsRecode[0].ItemArray[Com02.struct_m_kaisya.idx_tel_no].ToString(), "");
            bindingData.FaxNo            = new TextItem(dRowsRecode[0].ItemArray[Com02.struct_m_kaisya.idx_fax_no].ToString(), "");
            bindingData.MailAddress      = new TextItem(dRowsRecode[0].ItemArray[Com02.struct_m_kaisya.idx_mail_address].ToString(), "");

            // キーの旧情報として保持
            KaisyaCode_old = bindingData.KaisyaCode.text;
            return;
        }
예제 #4
0
        /// <summary>
        /// マスタ登録データ設定処理
        /// </summary>
        /// <param name="clsSqlServer"></param>
        /// <param name="bindingData"></param>
        /// <returns></returns>
        private Com02.struct_m_kaisya Set_EntryData(SqlServer clsSqlServer, BindingData bindingData)
        {
            // キーを条件に最新データを取得
            Com02.struct_m_kaisya m_kaisya = new Com02.struct_m_kaisya();
            m_kaisya.kigyo_code  = Com01.clsSystemInfo.ComLineArgs.kigyo_code;
            m_kaisya.kaisya_code = bindingData.KaisyaCode.text;
            m_kaisya.invalid_flg = 1; // 削除も含めて検索
            DataTable dTable = Com02.Get_m_kaisya(clsSqlServer, m_kaisya, 1);

            // システム日時を取得
            Com01.Set_DateTime(clsSqlServer);

            // 更新日時をセット
            m_kaisya.koshin_datetime = Com01.clsSystemInfo.dtNow.ToString();
            m_kaisya.koshin_user_id  = Com01.clsSystemInfo.ComLineArgs.user_id;
            m_kaisya.koshin_program  = Com01.clsSystemInfo.strExeName;

            // 検索結果
            if (dTable == null || dTable.Rows.Count == 0)
            {
                // 新規登録日時
                m_kaisya.toroku_datetime = m_kaisya.koshin_datetime;
                m_kaisya.toroku_user_id  = m_kaisya.koshin_user_id;
                m_kaisya.toroku_program  = m_kaisya.koshin_program;

                // 空の場合は規定値を
                m_kaisya.invalid_flg = 0;
            }
            else
            {
                DataRow dRow = dTable.Rows[0];

                // 取得内容を構造体へ
                m_kaisya.toroku_datetime = dRow[Com02.struct_m_kaisya.idx_toroku_datetime].ToString();
                m_kaisya.toroku_user_id  = dRow[Com02.struct_m_kaisya.idx_toroku_user_id].ToString();
                m_kaisya.toroku_program  = dRow[Com02.struct_m_kaisya.idx_toroku_program].ToString();

                m_kaisya.invalid_flg = int.Parse(dRow[Com02.struct_m_kaisya.idx_invalid_flg].ToString());

                m_kaisya.kaisya_code       = dRow[Com02.struct_m_kaisya.idx_kaisya_code].ToString();
                m_kaisya.kaisya_name       = dRow[Com02.struct_m_kaisya.idx_kaisya_name].ToString();
                m_kaisya.kaisya_name_kana  = dRow[Com02.struct_m_kaisya.idx_kaisya_name_kana].ToString();
                m_kaisya.kaisya_name_ryaku = dRow[Com02.struct_m_kaisya.idx_kaisya_name_ryaku].ToString();
                m_kaisya.address           = dRow[Com02.struct_m_kaisya.idx_address].ToString();
                m_kaisya.postal_code       = dRow[Com02.struct_m_kaisya.idx_postal_code].ToString();
                m_kaisya.tel_no            = dRow[Com02.struct_m_kaisya.idx_tel_no].ToString();
                m_kaisya.fax_no            = dRow[Com02.struct_m_kaisya.idx_fax_no].ToString();
                m_kaisya.mail_address      = dRow[Com02.struct_m_kaisya.idx_mail_address].ToString();
            }

            // これに対して画面内容を上書く
            if (bindingData.InvalidFlg.check == true)
            {
                m_kaisya.invalid_flg = 1;
            }
            else
            {
                m_kaisya.invalid_flg = 0;
            }
            m_kaisya.kaisya_code       = bindingData.KaisyaCode.text;
            m_kaisya.kaisya_name       = bindingData.KaisyaName.text;
            m_kaisya.kaisya_name_kana  = bindingData.KaisyaName_Kana.text;
            m_kaisya.kaisya_name_ryaku = bindingData.KaisyaName_Ryaku.text;
            m_kaisya.address           = bindingData.Address.text;
            m_kaisya.postal_code       = bindingData.PostalCode_1.text + "-" + bindingData.PostalCode_2.text;
            m_kaisya.tel_no            = bindingData.TelNo.text;
            m_kaisya.fax_no            = bindingData.FaxNo.text;
            m_kaisya.mail_address      = bindingData.MailAddress.text;

            return(m_kaisya);
        }