using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
using System.Data.SqlClient;

namespace MedicalCheckInputTool
{
    public partial class Form2 : Form
    {
        private List<string> history = new List<string>();
        private const int historyMax = 10;
        private int historyPos = 0;

        public Form2(string serialNo = null)
        {
            InitializeComponent();

            if (serialNo != null)
            {
                initDsp(serialNo);
            }

            this.Text = "ロット：" + Global.lotNo + " " + Global.times + " " + "ユーザ：" + Global.inputUser;

            label3.Text = "ロット：" + Global.lotNo;
            label21.Text = "行政区番号：" + Global.adminCode + " " + Global.adminName;

            label20.Text = ""; //エラーメッセージなし

            if("１回目".Equals(Global.times))
            {
                button6.Enabled = false;
            }
            dspCount();
        }

        //修正から遷移
        private void initDsp(string serialNo)
        {
            MySqlConnection conn;
            string connstr = System.Configuration.ConfigurationManager.AppSettings["Conn"];
            conn = new MySqlConnection(connstr);
            conn.Open();
            string code = serialNo.PadLeft(10, '0');

            textBox1.Text = code;
            MySqlCommand cmd = new MySqlCommand("select * from `" + Global.times + "` where `ロット番号` = @lotNo and `整理番号` = @serialNo", conn);
            // パラメータ設定
            cmd.Parameters.Add(new MySqlParameter("lotNo", Global.lotNo));
            cmd.Parameters.Add(new MySqlParameter("serialNo", serialNo));

            try
            {
                MySqlDataReader reader = cmd.ExecuteReader();
                if (!reader.HasRows)
                {
                    //無かった
                    reader.Close();
                }
                else
                {
                    string[] row = new string[reader.FieldCount];
                    while (reader.Read())
                    {
                        textBox1.Text = isDBNull(reader, "整理番号");
                        textBox2.Text = isDBNull(reader, "世帯番号");
                        textBox4.Text = isDBNull(reader, "電話番号");
                        textBox5.Text = isDBNull(reader, "携帯番号");
                        textBox6.Text = isDBNull(reader, "健康診査");
                        textBox7.Text = isDBNull(reader, "結核肺がん");
                        textBox8.Text = isDBNull(reader, "胃がん");
                        textBox9.Text = isDBNull(reader, "大腸がん");
                        textBox10.Text = isDBNull(reader, "前立腺がん");
                        textBox11.Text = isDBNull(reader, "骨粗鬆症");
                        textBox12.Text = isDBNull(reader, "成人歯科");

                        string cervicalCancer = isDBNull(reader, "子宮頸がん");
                        specialInputTwo(cervicalCancer, textBox13, textBox31);

                        string breastCancer = isDBNull(reader, "乳がん");
                        specialInputTwo(breastCancer, textBox14, textBox32);

                        string place = isDBNull(reader, "希望場所");
                        specialInputThree(place, textBox15, textBox33, textBox34);

                        textBox16.Text = "".Equals(isDBNull(reader, "身体不自由")) ? "" : "0";

                        Global.adminCode = isDBNull(reader, "行政区コード");
                        Global.adminName = isDBNull(reader, "行政区名称");
                        Global.healthArea = isDBNull(reader, "保健区");
                    }
                    reader.Close();
                }
            }
            catch (SqlException )
            {
            }

            conn.Close();
        }



        private void dspCount()
        {
            MySqlConnection conn;
            string connstr = System.Configuration.ConfigurationManager.AppSettings["Conn"];
            conn = new MySqlConnection(connstr);
            conn.Open();

            int cnt = getCount(Global.times, Global.lotNo, Global.adminCode, conn);

            conn.Close();

            label19.Text = "入力済み  " + cnt + "件";
        }

        //保存
        private void button1_Click(object sender, EventArgs e)
        {
            bool match = false;
            //入力チェック
            if("".Equals(textBox1.Text)) //必須は整理番号のみ
            {
                MessageBox.Show("整理番号が入力されていません");
                return;
            }

            SaveData sv = makeSaveData(); //保存用データ生成（パディング済み）

            //マッチングチェック
            bool matchErr = matchInput(sv, Global.times);
            //一致しない場合、エラー表示はするが保存は実行してしまう
            if(matchErr)
            {
                //保存へ進む
            }
            else
            {
                //エラーなしは完了フラグを立てる
                match = true;
            }

            //保存処理
            if(match)
            {
                sv.done = "1";  //マッチングOKの場合、完了フラグを立てる
            }
            bool res = doSave(sv);

            historyAdd(sv.serialNo);  //履歴に積む

            dspCount();
            
        }

        private SaveData makeSaveData()
        {
            SaveData sv = new SaveData();

            sv.lotNo = int.Parse(Global.lotNo);            //ロット番号
            sv.adminCode = Global.adminCode;        //行政区コード
            sv.adminName = Global.adminName;        //行政区名称
            sv.healthArea = Global.healthArea;       //保健区
            sv.serialNo = textBox1.Text.PadLeft(10,'0');         //整理番号
            if ("".Equals(textBox2.Text))
            {
                sv.houseNo = "";
            }
            else
            {
                sv.houseNo = textBox2.Text.PadLeft(10, '0');          //世帯番号
            }
            sv.healthCheck = textBox6.Text;      //健康診査
            sv.lungCancer = textBox7.Text;       //結核肺がん
            sv.stomachCancer = textBox8.Text;    //胃がん
            sv.colorectalCancer = textBox9.Text; //大腸がん
            sv.prostateCancer = textBox10.Text;   //前立腺がん
            sv.osteoporosis = textBox11.Text;     //骨粗鬆症
            sv.dental = textBox12.Text;           //成人歯科
            sv.cervicalCancer = specialReadTwo(textBox13,textBox31);   //子宮頸がん
            sv.breastCancer = specialReadTwo(textBox14, textBox32);    //乳がん
            sv.place = specialReadThree(textBox15, textBox33,textBox34);            //希望場所
            sv.handicapped = "".Equals(textBox16.Text) ? "" : "8";      //身体不自由
            sv.phone = textBox4.Text;            //電話番号
            sv.mobilePhone = textBox5.Text;      //携帯番号
            sv.inputDate = null;        //入力日
            sv.inputUser = null;        //入力者
            sv.updateDate = null;       //修正日
            sv.updateUser = null;       //修正者
            sv.done = "";             //完了

            return sv;
        }

        private bool doSave(SaveData sv)
        {
            bool err = false;

            MySqlConnection conn;
            string connstr = System.Configuration.ConfigurationManager.AppSettings["Conn"];
            conn = new MySqlConnection(connstr);
            conn.Open();

            bool isExist = isExistData(sv, Global.times, conn);
            if (isExist)
            {
                sv.updateUser = Global.inputUser;
                err = updateData(sv, Global.times, conn);
            }
            else
            {
                sv.inputUser = Global.inputUser;
                err = insertData(sv, Global.times, conn);
            }

            SaveData sv1 = new SaveData();
            sv1.lotNo = int.Parse(Global.lotNo);
            sv1.serialNo = sv.serialNo;
            sv1.done = sv.done;
            string tableName = "１回目".Equals(Global.times) ? "２回目" : "１回目";
            updateDoneFlag(sv1, tableName, conn);//別の回の完了フラグも立てる

            conn.Close();
            return err;
        }

        private int getCount(string tableName, string lotNo, string adminCode, MySqlConnection conn)
        {
            int cnt = 0;
            MySqlCommand cmd = new MySqlCommand("select count(*) from `" + tableName + "` where `ロット番号` = @lotNo and `行政区コード` = @adminCode", conn);
            // パラメータ設定
            cmd.Parameters.Add(new MySqlParameter("lotNo", lotNo));
            cmd.Parameters.Add(new MySqlParameter("adminCode", adminCode));

            try
            {
                // 実行
                MySqlDataReader reader = cmd.ExecuteReader();
                reader.Read();
                cnt = reader.GetInt32(0);
                reader.Close();
            }
            catch (SqlException )
            {
            }

            return cnt;
        }

        private bool selectData(string tableName, string lotNo, string serialNo, MySqlConnection conn)
        {
            bool err = false;
            MySqlCommand cmd = new MySqlCommand("select * from `" + tableName + "` where `ロット番号` = @lotNo and `整理番号` = @serialNo", conn);
            // パラメータ設定
            cmd.Parameters.Add(new MySqlParameter("lotNo", lotNo));
            cmd.Parameters.Add(new MySqlParameter("serialNo", serialNo));

            try
            {
                MySqlDataReader reader = cmd.ExecuteReader();
                if (!reader.HasRows)
                {
                    //無かった
                    reader.Close();
                }
                else
                {
                    string[] row = new string[reader.FieldCount];
                    while (reader.Read())
                    {
                        textBox1.Text = isDBNull(reader,"整理番号");
                        textBox2.Text = isDBNull(reader, "世帯番号");
                        textBox4.Text = isDBNull(reader, "電話番号");
                        textBox5.Text = isDBNull(reader, "携帯番号");
                        textBox6.Text = isDBNull(reader, "健康診査");
                        textBox7.Text = isDBNull(reader, "結核肺がん");
                        textBox8.Text = isDBNull(reader, "胃がん");
                        textBox9.Text = isDBNull(reader, "大腸がん");
                        textBox10.Text = isDBNull(reader, "前立腺がん");
                        textBox11.Text = isDBNull(reader, "骨粗鬆症");
                        textBox12.Text = isDBNull(reader, "成人歯科");

                        string cervicalCancer = isDBNull(reader, "子宮頸がん");
                        specialInputTwo(cervicalCancer, textBox13, textBox31);

                        string breastCancer = isDBNull(reader, "乳がん");
                        specialInputTwo(breastCancer, textBox14, textBox32);

                        string place = isDBNull(reader, "希望場所");
                        specialInputThree(place, textBox15, textBox33, textBox34);

                        textBox16.Text = "".Equals(isDBNull(reader, "身体不自由")) ? "" : "0";
                    }
                    reader.Close();
                }
            }
            catch (SqlException )
            {
            }

            return err;
        }

        private string isDBNull(MySqlDataReader reader, string column)
        {
            int index = reader.GetOrdinal(column);
            if (reader.IsDBNull(index))
            {
                return "";
            }
            else
            {
                return reader.GetString(column);
            }
        }


        private bool isExistData(SaveData sv, string tableName, MySqlConnection conn)
        {
            bool isExist = false;
            MySqlCommand cmd = new MySqlCommand("select exists (select 1 from `" + tableName + "` where `整理番号` = @serialNo)", conn);
            // パラメータ設定
            cmd.Parameters.Add(new MySqlParameter("serialNo", sv.serialNo));

            try
            {
                // 実行
                MySqlDataReader reader = cmd.ExecuteReader();
                reader.Read();
                isExist = reader.GetBoolean(0);
                reader.Close();
            }
            catch (SqlException )
            {
            }

            return isExist;
        }

        private bool matchInput(SaveData sv, string times)
        {
            MySqlConnection conn;
            string connstr = System.Configuration.ConfigurationManager.AppSettings["Conn"];
            conn = new MySqlConnection(connstr);
            conn.Open();

            string tableName = "１回目".Equals(times) ? "２回目" : "１回目";
            MySqlCommand cmd = new MySqlCommand("select * from `" + tableName + "` where `ロット番号` = @lotNo and `整理番号` = @serialNo", conn);
            // パラメータ設定
            cmd.Parameters.Add(new MySqlParameter("lotNo", sv.lotNo));
            cmd.Parameters.Add(new MySqlParameter("serialNo", sv.serialNo));

            bool err = false;

            textBox1.BackColor = Color.Empty;
            textBox2.BackColor = Color.Empty;
            textBox4.BackColor = Color.Empty;
            textBox5.BackColor = Color.Empty;
            textBox6.BackColor = Color.Empty;
            textBox7.BackColor = Color.Empty;
            textBox8.BackColor = Color.Empty;
            textBox9.BackColor = Color.Empty;
            textBox10.BackColor = Color.Empty;
            textBox11.BackColor = Color.Empty;
            textBox12.BackColor = Color.Empty;
            textBox13.BackColor = Color.Empty;
            textBox31.BackColor = Color.Empty;
            textBox14.BackColor = Color.Empty;
            textBox32.BackColor = Color.Empty;
            textBox15.BackColor = Color.Empty;
            textBox33.BackColor = Color.Empty;
            textBox34.BackColor = Color.Empty;
            textBox16.BackColor = Color.Empty;

            try
            {
                MySqlDataReader reader = cmd.ExecuteReader();
                if (!reader.HasRows)
                {
                    //無かった
                    if("２回目".Equals(times))
                    {
                        textBox1.BackColor = Color.Pink;
                    }
                    err = true;
                    reader.Close();
                }
                else
                {
                    string[] row = new string[reader.FieldCount];
                    while (reader.Read())
                    {
                        if (!sv.houseNo.Equals(isDBNull(reader, "世帯番号")))
                        {
                            if("２回目".Equals(times))
                            {
                                textBox2.BackColor = Color.Pink;
                            }
                            err = true; 
                        }
                        if (!sv.phone.Equals(isDBNull(reader, "電話番号")))
                        {
                            if("２回目".Equals(times))
                            {
                                textBox4.BackColor = Color.Pink;
                            }
                            err = true;
                        }
                        if (!sv.mobilePhone.Equals(isDBNull(reader, "携帯番号")))
                        {
                            if("２回目".Equals(times))
                            {
                                textBox5.BackColor = Color.Pink;
                            }
                            err = true;
                        }
                        if (!sv.healthCheck.Equals(isDBNull(reader, "健康診査")))
                        {
                            if ("２回目".Equals(times))
                            {
                                textBox6.BackColor = Color.Pink;
                            }
                            err = true;
                        }
                        if (!sv.lungCancer.Equals(isDBNull(reader, "結核肺がん")))
                        {
                            if("２回目".Equals(times))
                            {
                                textBox7.BackColor = Color.Pink;
                            }
                            err = true;
                        }
                        if (!sv.stomachCancer.Equals(isDBNull(reader, "胃がん")))
                        {
                            if("２回目".Equals(times))
                            {
                                textBox8.BackColor = Color.Pink;
                            }
                            err = true;
                        }
                        if (!sv.colorectalCancer.Equals(isDBNull(reader, "大腸がん")))
                        {
                            if("２回目".Equals(times))
                            {
                                textBox9.BackColor = Color.Pink;
                            }
                            err = true;
                        }
                        if (!sv.prostateCancer.Equals(isDBNull(reader, "前立腺がん")))
                        {
                            if("２回目".Equals(times))
                            {
                                textBox10.BackColor = Color.Pink;
                            }
                            err = true;
                        }
                        if (!sv.osteoporosis.Equals(isDBNull(reader, "骨粗鬆症")))
                        {
                            if("２回目".Equals(times))
                            {
                                textBox11.BackColor = Color.Pink;
                            }
                            err = true;
                        }
                        if (!sv.dental.Equals(isDBNull(reader, "成人歯科")))
                        {
                            if("２回目".Equals(times))
                            {
                                textBox12.BackColor = Color.Pink;
                            }
                            err = true;
                        }
                        if (!sv.cervicalCancer.Equals(isDBNull(reader, "子宮頸がん")))
                        {
                            if("２回目".Equals(times))
                            {
                                textBox13.BackColor = Color.Pink;
                                textBox31.BackColor = Color.Pink;
                            }
                            err = true;
                        }
                        if (!sv.breastCancer.Equals(isDBNull(reader, "乳がん")))
                        {
                            if("２回目".Equals(times))
                            {
                                textBox14.BackColor = Color.Pink;
                                textBox32.BackColor = Color.Pink;
                            }
                            err = true;
                        }
                        if (!sv.place.Equals(isDBNull(reader, "希望場所")))
                        {
                            if("２回目".Equals(times))
                            {
                                textBox15.BackColor = Color.Pink;
                                textBox33.BackColor = Color.Pink;
                                textBox34.BackColor = Color.Pink;
                            }
                            err = true;
                        }
                        if (!sv.handicapped.Equals(isDBNull(reader, "身体不自由")))
                        {
                            if("２回目".Equals(times))
                            {
                                textBox16.BackColor = Color.Pink;
                            }
                            err = true;
                        }
                    }
                    reader.Close();
                }
            }
            catch (SqlException )
            {
            }

            conn.Close();

            return err;
        }


        private bool insertData(SaveData sv, string tableName, MySqlConnection conn)
        {
            bool err = false;
            // コマンドを作成
            MySqlCommand cmd =
                new MySqlCommand("insert into `" + tableName + "` (`ロット番号`,"
                                                                  + "`行政区コード`,"
                                                                  + "`行政区名称`,"
                                                                  + "`保健区`,"
                                                                  + "`整理番号`,"
                                                                  + "`世帯番号`,"
                                                                  + "`健康診査`,"
                                                                  + "`結核肺がん`,"
                                                                  + "`胃がん`,"
                                                                  + "`大腸がん`,"
                                                                  + "`前立腺がん`,"
                                                                  + "`骨粗鬆症`,"
                                                                  + "`成人歯科`,"
                                                                  + "`子宮頸がん`,"
                                                                  + "`乳がん`,"
                                                                  + "`希望場所`,"
                                                                  + "`身体不自由`,"
                                                                  + "`電話番号`,"
                                                                  + "`携帯番号`,"
                                                                  + "`入力日`,"
                                                                  + "`入力者`,"
                                                                  + "`修正日`,"
                                                                  + "`修正者`,"
                                                                  + "`完了`) "
                                                          + "values (@lotNo,"
                                                                  + "@adminCode, "
                                                                  + "@adminName, "
                                                                  + "@healthArea, "
                                                                  + "@serialNo, "
                                                                  + "@houseNo,"
                                                                  + "@healthCheck,"
                                                                  + "@lungCancer,"
                                                                  + "@stomachCancer,"
                                                                  + "@colorectalCancer,"
                                                                  + "@prostateCancer,"
                                                                  + "@osteoporosis,"
                                                                  + "@dental,"
                                                                  + "@cervicalCancer,"
                                                                  + "@breastCancer,"
                                                                  + "@place,"
                                                                  + "@handicapped,"
                                                                  + "@phone,"
                                                                  + "@mobilePhone,"
                                                                  + "@inputDate,"
                                                                  + "@inputUser,"
                                                                  + "@updateDate,"
                                                                  + "@updateUser,"
                                                                  + "@done)", conn);
            // パラメータ設定
            cmd.Parameters.Add(new MySqlParameter("lotNo", sv.lotNo));
            cmd.Parameters.Add(new MySqlParameter("adminCode", sv.adminCode));
            cmd.Parameters.Add(new MySqlParameter("adminName", sv.adminName));
            cmd.Parameters.Add(new MySqlParameter("healthArea", sv.healthArea));
            cmd.Parameters.Add(new MySqlParameter("serialNo", sv.serialNo));
            cmd.Parameters.Add(new MySqlParameter("houseNo", sv.houseNo));
            cmd.Parameters.Add(new MySqlParameter("healthCheck", sv.healthCheck));
            cmd.Parameters.Add(new MySqlParameter("lungCancer", sv.lungCancer));
            cmd.Parameters.Add(new MySqlParameter("stomachCancer", sv.stomachCancer));
            cmd.Parameters.Add(new MySqlParameter("colorectalCancer", sv.colorectalCancer));
            cmd.Parameters.Add(new MySqlParameter("prostateCancer", sv.prostateCancer));
            cmd.Parameters.Add(new MySqlParameter("osteoporosis", sv.osteoporosis));
            cmd.Parameters.Add(new MySqlParameter("dental", sv.dental));
            cmd.Parameters.Add(new MySqlParameter("cervicalCancer", sv.cervicalCancer));
            cmd.Parameters.Add(new MySqlParameter("breastCancer", sv.breastCancer));
            cmd.Parameters.Add(new MySqlParameter("place", sv.place));
            cmd.Parameters.Add(new MySqlParameter("handicapped", sv.handicapped));
            cmd.Parameters.Add(new MySqlParameter("phone", sv.phone));
            cmd.Parameters.Add(new MySqlParameter("mobilePhone", sv.mobilePhone));
            cmd.Parameters.Add(new MySqlParameter("inputDate", DateTime.Now));
            cmd.Parameters.Add(new MySqlParameter("inputUser", sv.inputUser));
            cmd.Parameters.Add(new MySqlParameter("updateDate", sv.updateDate));
            cmd.Parameters.Add(new MySqlParameter("updateUser", sv.updateUser));
            cmd.Parameters.Add(new MySqlParameter("done", sv.done));

            try
            {
                // 実行
                cmd.ExecuteNonQuery();
            }
            catch (SqlException ex)
            {
                // 例外処理
                MessageBox.Show("例外発生:" + ex.Message);
                return true;
            }

            return err;
        }

        private bool updateData(SaveData sv, string tableName, MySqlConnection conn)
        {
            bool err = false;
            string sql = "update `" + tableName + "` set `ロット番号` = @lotNo,"
                                                      + "`行政区コード` = @adminCode,"
                                                      + "`行政区名称` = @adminName,"
                                                      + "`保健区` = @healthArea,"
                                                      + "`整理番号` = @serialNo,"
                                                      + "`世帯番号` = @houseNo,"
                                                      + "`健康診査` = @healthCheck,"
                                                      + "`結核肺がん` = @lungCancer,"
                                                      + "`胃がん` = @stomachCancer,"
                                                      + "`大腸がん` = @colorectalCancer,"
                                                      + "`前立腺がん` = @prostateCancer,"
                                                      + "`骨粗鬆症` = @osteoporosis,"
                                                      + "`成人歯科` = @dental,"
                                                      + "`子宮頸がん` = @cervicalCancer,"
                                                      + "`乳がん` = @breastCancer,"
                                                      + "`希望場所` = @place,"
                                                      + "`身体不自由` = @handicapped,"
                                                      + "`電話番号` = @phone,"
                                                      + "`携帯番号` = @mobilePhone,"
                                                      + "`修正日` = @updateDate,"
                                                      + "`修正者` = @updateUser,"
                                                      + "`完了` = @done "
                                                      + "where `ロット番号` = @lotNo and `整理番号` = @serialNo";

            // コマンドを作成
            MySqlCommand cmd = new MySqlCommand(sql, conn);

            // パラメータ設定
            cmd.Parameters.Add(new MySqlParameter("lotNo", sv.lotNo));
            cmd.Parameters.Add(new MySqlParameter("adminCode", sv.adminCode));
            cmd.Parameters.Add(new MySqlParameter("adminName", sv.adminName));
            cmd.Parameters.Add(new MySqlParameter("healthArea", sv.healthArea));
            cmd.Parameters.Add(new MySqlParameter("serialNo", sv.serialNo));
            cmd.Parameters.Add(new MySqlParameter("houseNo", sv.houseNo));
            cmd.Parameters.Add(new MySqlParameter("healthCheck", sv.healthCheck));
            cmd.Parameters.Add(new MySqlParameter("lungCancer", sv.lungCancer));
            cmd.Parameters.Add(new MySqlParameter("stomachCancer", sv.stomachCancer));
            cmd.Parameters.Add(new MySqlParameter("colorectalCancer", sv.colorectalCancer));
            cmd.Parameters.Add(new MySqlParameter("prostateCancer", sv.prostateCancer));
            cmd.Parameters.Add(new MySqlParameter("osteoporosis", sv.osteoporosis));
            cmd.Parameters.Add(new MySqlParameter("dental", sv.dental));
            cmd.Parameters.Add(new MySqlParameter("cervicalCancer", sv.cervicalCancer));
            cmd.Parameters.Add(new MySqlParameter("breastCancer", sv.breastCancer));
            cmd.Parameters.Add(new MySqlParameter("place", sv.place));
            cmd.Parameters.Add(new MySqlParameter("handicapped", sv.handicapped));
            cmd.Parameters.Add(new MySqlParameter("phone", sv.phone));
            cmd.Parameters.Add(new MySqlParameter("mobilePhone", sv.mobilePhone));
            cmd.Parameters.Add(new MySqlParameter("updateDate", DateTime.Now));
            cmd.Parameters.Add(new MySqlParameter("updateUser", sv.updateUser));
            cmd.Parameters.Add(new MySqlParameter("done", sv.done));

            try
            {
                // 実行
                cmd.ExecuteNonQuery();
            }
            catch (SqlException ex)
            {
                // 例外処理
                MessageBox.Show("例外発生:" + ex.Message);
                return true;
            }

            return err;

        }

        private bool updateDoneFlag(SaveData sv, string tableName, MySqlConnection conn)
        {
            bool err = false;

            string sql = "update `" + tableName + "` set `完了` = @done "
                                          + "where `ロット番号` = @lotNo and `整理番号` = @serialNo";

            // コマンドを作成
            MySqlCommand cmd = new MySqlCommand(sql, conn);

            // パラメータ設定
            cmd.Parameters.Add(new MySqlParameter("lotNo", sv.lotNo));
            cmd.Parameters.Add(new MySqlParameter("serialNo", sv.serialNo));
            cmd.Parameters.Add(new MySqlParameter("done", sv.done));

            try
            {
                // 実行
                cmd.ExecuteNonQuery();
            }
            catch (SqlException ex)
            {
                // 例外処理
                MessageBox.Show("例外発生:" + ex.Message);
                return true;
            }

            return err;
        }

        private bool deleteData(SaveData sv, string tableName, MySqlConnection conn)
        {
            bool err = false;

            string sql = "delete from `" + tableName + "` where `ロット番号` = @lotNo and `整理番号` = @serialNo";

            // コマンドを作成
            MySqlCommand cmd = new MySqlCommand(sql, conn);

            // パラメータ設定
            cmd.Parameters.Add(new MySqlParameter("lotNo", sv.lotNo));
            cmd.Parameters.Add(new MySqlParameter("serialNo", sv.serialNo));

            try
            {
                // 実行
                cmd.ExecuteNonQuery();
            }
            catch (SqlException ex)
            {
                // 例外処理
                MessageBox.Show("例外発生:" + ex.Message);
                return true;
            }

            return err;
        }

        private void sendTabKey(TextBox textbox, int length)
        {
            if (textbox.Text.Length == length)
            {
                SendKeys.Send("{Tab}");
            }
        }

        private void clearForm()
        {
            textBox1.BackColor = Color.Empty;
            textBox2.BackColor = Color.Empty;
            textBox4.BackColor = Color.Empty;
            textBox5.BackColor = Color.Empty;
            textBox6.BackColor = Color.Empty;
            textBox7.BackColor = Color.Empty;
            textBox8.BackColor = Color.Empty;
            textBox9.BackColor = Color.Empty;
            textBox10.BackColor = Color.Empty;
            textBox11.BackColor = Color.Empty;
            textBox12.BackColor = Color.Empty;
            textBox13.BackColor = Color.Empty;
            textBox31.BackColor = Color.Empty;
            textBox14.BackColor = Color.Empty;
            textBox32.BackColor = Color.Empty;
            textBox15.BackColor = Color.Empty;
            textBox33.BackColor = Color.Empty;
            textBox34.BackColor = Color.Empty;
            textBox16.BackColor = Color.Empty;

            textBox1.Text = "";
            textBox2.Text = "";
            textBox4.Text = "";
            textBox5.Text = "";
            textBox6.Text = "";
            textBox7.Text = "";
            textBox8.Text = "";
            textBox9.Text = "";
            textBox10.Text = "";
            textBox11.Text = "";
            textBox12.Text = "";
            textBox13.Text = "";
            textBox31.Text = "";
            textBox14.Text = "";
            textBox32.Text = "";
            textBox15.Text = "";
            textBox33.Text = "";
            textBox34.Text = "";
            textBox16.Text = "";

            label20.Text = "";

            textBox1.Focus();

            panel1.Visible = false;
            button6.Text = "１回目の表示";
        }

        private void textBox1_TextChanged(object sender, EventArgs e) //整理番号
        {
            sendTabKey(textBox1, 10);
        }

        private void textBox2_TextChanged(object sender, EventArgs e) //世帯番号
        {
            sendTabKey(textBox2, 10);
        }

        private void textBox4_TextChanged(object sender, EventArgs e) //電話番号
        {
            sendTabKey(textBox4, 15);
        }

        private void textBox5_TextChanged(object sender, EventArgs e) //携帯番号
        {
            sendTabKey(textBox5, 15);
        }

        private void textBox6_TextChanged(object sender, EventArgs e) //健康診査
        {
            dspModify(textBox6, label7);
            sendTabKey(textBox6, 1);
        }

        private void textBox7_TextChanged(object sender, EventArgs e) //結核肺がん
        {
            dspModify(textBox7, label8);
            sendTabKey(textBox7, 1);
        }

        private void textBox8_TextChanged(object sender, EventArgs e) //胃がん
        {
            dspModify(textBox8, label9);
            sendTabKey(textBox8, 1);
        }

        private void textBox9_TextChanged(object sender, EventArgs e) //大腸がん
        {
            dspModify(textBox9, label10);
            sendTabKey(textBox9, 1);
        }

        private void textBox10_TextChanged(object sender, EventArgs e) //前立腺がん
        {
            dspModify(textBox10, label11);
            sendTabKey(textBox10, 1);
        }

        private void textBox11_TextChanged(object sender, EventArgs e) //骨粗鬆症
        {
            dspModify(textBox11, label12);
            sendTabKey(textBox11, 1);
        }

        private void textBox12_TextChanged(object sender, EventArgs e) //成人歯科
        {
            dspModify(textBox12, label13);
            sendTabKey(textBox12, 1);
        }

        private void textBox13_TextChanged(object sender, EventArgs e) //子宮頸がん
        {
            dspModify(textBox13, label14);
            sendTabKey(textBox13, 1);
        }

        private void textBox31_TextChanged(object sender, EventArgs e) //子宮頸がん（指定医療機関）
        {
            dspModify(textBox31, label22);
            sendTabKey(textBox31, 1);
        }

        private void textBox14_TextChanged(object sender, EventArgs e) //乳がん
        {
            dspModify(textBox14, label15);
            sendTabKey(textBox14, 1);
        }

        private void textBox32_TextChanged(object sender, EventArgs e) //石巻市医師会
        {
            dspModify(textBox32, label23);
            sendTabKey(textBox32, 1);

        }

        private void textBox15_TextChanged(object sender, EventArgs e) //希望場所
        {
            sendTabKey(textBox15, 1);
        }

        private void textBox33_TextChanged(object sender, EventArgs e) //希望場所（本庁個別）
        {
            sendTabKey(textBox15, 1);
        }

        private void textBox34_TextChanged(object sender, EventArgs e)//希望場所（石巻ロイヤル）
        {
            sendTabKey(textBox15, 1);
        }


        private void textBox16_TextChanged(object sender, EventArgs e) //身体不自由
        {
            sendTabKey(textBox16, 1);
        }

        //保存して次へ
        private void button2_Click(object sender, EventArgs e)
        {
            bool match = false;
            //入力チェック
            if ("".Equals(textBox1.Text)) //必須は整理番号のみ
            {
                MessageBox.Show("整理番号が入力されていません");
                return;
            }

            SaveData sv = makeSaveData(); //保存用データ作成（パディング済み）

            bool matchErr = matchInput(sv, Global.times);
            if (matchErr)
            {
                if ("２回目".Equals(Global.times))
                {
                    //一致しない場合、エラーダイアログ表示
                    DialogResult result = MessageBox.Show("入力内容が１回目と異なりますが保存しますか？",
                                                          "確認",
                                                          MessageBoxButtons.OKCancel,
                                                          MessageBoxIcon.Exclamation,
                                                          MessageBoxDefaultButton.Button2);
                    //何が選択されたか調べる
                    if (result == DialogResult.OK)
                    {
                        //「OK」が選択された時
                    }
                    else if (result == DialogResult.Cancel)
                    {
                        //「キャンセル」が選択された時
                        return;
                    }
                }
            }
            else
            {
                //エラーなしは完了フラグを立てる
                match = true;
            }

            //保存処理
            if (match)
            {
                sv.done = "1";  //マッチングOKの場合、完了フラグを立てる
            }
            bool res = doSave(sv);

            historyAdd(sv.serialNo);  //履歴に積む

            clearForm();
            dspCount();
        }

        //復元
        private void button3_Click(object sender, EventArgs e)
        {
            if("".Equals(textBox1.Text))
            {
                return;
            }


            MySqlConnection conn;
            string connstr = System.Configuration.ConfigurationManager.AppSettings["Conn"];
            conn = new MySqlConnection(connstr);
            conn.Open();
            string code = textBox1.Text.PadLeft(10, '0');

            clearForm(); //いったんクリア
            textBox1.Text = code; //整理番号だけ戻す
            selectData(Global.times, Global.lotNo, code, conn);

            conn.Close();
        }

        private void historyAdd(string serialNo)
        {
            if(history.Count > 0)  //要素がある
            {
                if (serialNo.Equals(history[historyPos]))  //最後と同じ要素はなにもしない
                {
                    return;
                }
            }

            if((history.Count - 1) > historyPos)  //現在地より多く入っているものは消す
            {
                int cnt = history.Count -1; //削除前最大位置
                for (int i = cnt; i > historyPos; i--)
                {
                    history.RemoveAt(i);
                }
            }
            if (history.Count >= historyMax)
            {
                //最大数入っている
                history.RemoveAt(0);//古いものを削除
            }
            history.Add(serialNo);
            historyPos = history.Count - 1;
        }

        private string historyGet()
        {
            string ret = "";

            if (history.Count > 0)
            {
                if (historyPos >= 0)
                {
                    ret = history[historyPos];
                    historyPos--;
                    if(historyPos < 0)
                    {
                        historyPos = 0;
                    }
                }
            }
            return ret;
        }

        //前の入力へ
        private void button4_Click(object sender, EventArgs e)
        {
            string serialNo = historyGet();
            if("".Equals(serialNo))
            {
                return;
            }

            MySqlConnection conn;
            string connstr = System.Configuration.ConfigurationManager.AppSettings["Conn"];
            conn = new MySqlConnection(connstr);
            conn.Open();

            clearForm(); //いったんクリア
            textBox1.Text = serialNo; //整理番号だけ戻す
            selectData(Global.times, Global.lotNo, serialNo, conn);

            conn.Close();
        }

        //整理番号のチェック
        private void textBox1_Validating(object sender, CancelEventArgs e)
        {
            if ("２回目".Equals(Global.times))
            {
                if ("".Equals(textBox1.Text))
                {
                    label20.Text = "";
                    label20.ForeColor = Color.Empty;
                    return;
                }

                bool isExist = false;

                MySqlConnection conn;
                string connstr = System.Configuration.ConfigurationManager.AppSettings["Conn"];
                conn = new MySqlConnection(connstr);
                conn.Open();
                SaveData sv = new SaveData();

                sv.serialNo = textBox1.Text.PadLeft(10, '0');
                isExist = isExistData(sv, "１回目", conn);

                conn.Close();

                if (isExist)
                {
                    label20.Text = "";
                    label20.ForeColor = Color.Empty;
                }
                else
                {
                    label20.Text = "１回目に存在しない整理番号です";
                    label20.ForeColor = Color.Red;
                }
            }
        }

        //入力可能(数字とハイフンとBS)
        private void inputAllNumber(object sender, KeyPressEventArgs e)
        {
            if ((e.KeyChar < '0' || e.KeyChar > '9') && (e.KeyChar != '\b') && (e.KeyChar != '-'))
            {
                e.Handled = true;
            }
        }

        //入力可能(0～5とBS)
        private void inputNumber(object sender, KeyPressEventArgs e)
        {
            if ((e.KeyChar < '0' || e.KeyChar > '5') && (e.KeyChar != '\b'))
            {
                e.Handled = true;
            }
        }

        //入力可能(0とBS)
        private void inputZero(object sender, KeyPressEventArgs e)
        {
            if ((e.KeyChar != '0') && (e.KeyChar != '\b'))
            {
                e.Handled = true;
            }
        }

        private void dspModify(TextBox tb, Label lb)
        {
            if ("".Equals(tb.Text))
            {
                lb.ForeColor = Color.Black;
                lb.Font = new Font(lb.Font, FontStyle.Regular);
            }
            else
            {
                if ("0".Equals(tb.Text))
                {
                    lb.ForeColor = Color.Red;
                    lb.Font = new Font(lb.Font, FontStyle.Bold);
                }
                else
                {
                    lb.ForeColor = Color.Blue;
                    lb.Font = new Font(lb.Font, FontStyle.Regular);
                }
            }
        }

        private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
        {
            inputAllNumber(sender, e);
        }

        private void textBox2_KeyPress(object sender, KeyPressEventArgs e)
        {
            inputAllNumber(sender, e);
        }

        private void textBox4_KeyPress(object sender, KeyPressEventArgs e)
        {
            inputAllNumber(sender, e);
        }

        private void textBox5_KeyPress(object sender, KeyPressEventArgs e)
        {
            inputAllNumber(sender, e);
        }

        private void textBox6_KeyPress(object sender, KeyPressEventArgs e)
        {
            inputNumber(sender, e);
        }

        private void textBox7_KeyPress(object sender, KeyPressEventArgs e)
        {
            inputNumber(sender, e);
        }

        private void textBox8_KeyPress(object sender, KeyPressEventArgs e)
        {
            inputNumber(sender, e);
        }

        private void textBox9_KeyPress(object sender, KeyPressEventArgs e)
        {
            inputNumber(sender, e);
        }

        private void textBox10_KeyPress(object sender, KeyPressEventArgs e)
        {
            inputNumber(sender, e);
        }

        private void textBox11_KeyPress(object sender, KeyPressEventArgs e)
        {
            inputNumber(sender, e);
        }

        private void textBox12_KeyPress(object sender, KeyPressEventArgs e)
        {
            inputNumber(sender, e);
        }

        private void textBox13_KeyPress(object sender, KeyPressEventArgs e)
        {
            if ("".Equals(textBox31.Text)) //どちらかにしか入れさせない
            {
                inputNumber(sender, e);
            }
            else
            {
                e.Handled = true;
            }
        }

        private void textBox31_KeyPress(object sender, KeyPressEventArgs e) //子宮頸がん（指定医療機関）
        {
            if ("".Equals(textBox13.Text)) //どちらかにしか入れさせない
            {
                inputNumber(sender, e);
            }
            else
            {
                e.Handled = true;
            }
        }

        private void textBox14_KeyPress(object sender, KeyPressEventArgs e)
        {
            if ("".Equals(textBox32.Text)) //どちらかにしか入れさせない
            {
                inputNumber(sender, e);
            }
            else
            {
                e.Handled = true;
            }
        }

        private void textBox32_KeyPress(object sender, KeyPressEventArgs e)//乳がん（石巻医師会）
        {
            if ("".Equals(textBox14.Text)) //どちらかにしか入れさせない
            {
                inputNumber(sender, e);
            }
            else
            {
                e.Handled = true;
            }
        }


        private void textBox15_KeyPress(object sender, KeyPressEventArgs e)
        {
            if ("".Equals(textBox33.Text) && "".Equals(textBox34.Text)) //どちらかにしか入れさせない
            {
                inputZero(sender, e);
            }
            else
            {
                e.Handled = true;
            }
        }

        private void textBox33_KeyPress(object sender, KeyPressEventArgs e)//本庁個別
        {
            if ("".Equals(textBox15.Text) && "".Equals(textBox34.Text)) //どちらかにしか入れさせない
            {
                inputZero(sender, e);
            }
            else
            {
                e.Handled = true;
            }
        }

        private void textBox34_KeyPress(object sender, KeyPressEventArgs e)//石巻ロイヤル
        {
            if ("".Equals(textBox15.Text) && "".Equals(textBox33.Text)) //どちらかにしか入れさせない
            {
                inputZero(sender, e);
            }
            else
            {
                e.Handled = true;
            }
        }

        private void textBox16_KeyPress(object sender, KeyPressEventArgs e)//身体不自由
        {
            inputZero(sender, e);
        }


        private void Form2_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                SendKeys.Send("{Tab}");
                e.Handled = true;
            }

            if(e.KeyCode == Keys.Escape)
            {
                button2.Focus();
                button2.PerformClick();
                e.Handled = true;
            }

        }

        //削除
        private void button5_Click(object sender, EventArgs e)
        {
            if("".Equals(textBox1.Text))
            {
                return;
            }

            MySqlConnection conn;
            string connstr = System.Configuration.ConfigurationManager.AppSettings["Conn"];
            conn = new MySqlConnection(connstr);
            conn.Open();

            SaveData sv1 = new SaveData();
            sv1.lotNo = int.Parse(Global.lotNo);
            sv1.serialNo = textBox1.Text.PadLeft(10,'0');
            string tableName = Global.times;
            deleteData(sv1, tableName, conn);//削除

            sv1.done = "";
            tableName = "１回目".Equals(Global.times) ? "２回目" : "１回目";
            updateDoneFlag(sv1, tableName, conn);//別の回の完了フラグはおろす

            conn.Close();

            clearForm();
            dspCount();
        }

        private void specialInputTwo(string inputChar, TextBox t1, TextBox t2) //２項目で特殊入力
        {
            if ("".Equals(inputChar))
            {
                t1.Text = "";
                t2.Text = "";
            }
            else if ("9".Equals(inputChar))
            {
                t1.Text = "0";
                t2.Text = "";
            }
            else if ("0".Equals(inputChar))
            {
                t1.Text = "";
                t2.Text = "0";
            }
            else
            {
                t1.Text = inputChar;
                t2.Text = "";
            }

        }

        private void specialInputThree(string inputChar, TextBox t1, TextBox t2, TextBox t3) //３項目で特殊入力
        {
            if ("".Equals(inputChar))
            {
                t1.Text = "";
                t2.Text = "";
                t3.Text = "";
            }
            else if ("1".Equals(inputChar))
            {
                t1.Text = "0";
                t2.Text = "";
                t3.Text = "";
            }
            if ("2".Equals(inputChar))
            {
                t1.Text = "";
                t2.Text = "0";
                t3.Text = "";
            }
            if ("3".Equals(inputChar))
            {
                t1.Text = "";
                t2.Text = "";
                t3.Text = "0";
            }
        }

        private string specialReadTwo(TextBox t1, TextBox t2) //２項目で特殊読み取り
        {
            string ret = "";
            if ("".Equals(t1.Text) && "".Equals(t2.Text))
            {
                ret = "";
            }
            else
            {
                if("0".Equals(t1.Text))
                {
                    ret = "9";
                }
                else if("0".Equals(t2.Text))
                {
                    ret = "0";
                }
                else
                {
                    ret = "".Equals(t2) ? t1.Text : t2.Text;   //子宮頸がん
                }
            }

            return ret;
        }

        private string specialReadThree(TextBox t1, TextBox t2, TextBox t3) //３項目で特殊読み取り
        {
            string ret = "";

            if ("".Equals(t1.Text) && "".Equals(t2.Text) && "".Equals(t3.Text))
            {
                ret = "";
            }
            else
            {
                if ("0".Equals(t1.Text))
                {
                    ret = "1";
                }
                else if ("0".Equals(t2.Text))
                {
                    ret = "2"; 
                }
                else if ("0".Equals(t3.Text))
                {
                    ret = "3";
                }
            }
            return ret;
        }

        /***************************************************************/
        /***************２回目時入力時の１回目修正用********************/
        /***************************************************************/

        private bool selectDataOnce(string tableName, string lotNo, string serialNo, MySqlConnection conn)
        {
            bool err = false;
            MySqlCommand cmd = new MySqlCommand("select * from `" + tableName + "` where `ロット番号` = @lotNo and `整理番号` = @serialNo", conn);
            // パラメータ設定
            cmd.Parameters.Add(new MySqlParameter("lotNo", lotNo));
            cmd.Parameters.Add(new MySqlParameter("serialNo", serialNo));

            try
            {
                MySqlDataReader reader = cmd.ExecuteReader();
                if (!reader.HasRows)
                {
                    //無かった
                    reader.Close();

                    textBox3.Text = "";
                    textBox17.Text = "";
                    textBox18.Text = "";
                    textBox19.Text = "";
                    textBox20.Text = "";
                    textBox21.Text = "";
                    textBox22.Text = "";
                    textBox23.Text = "";
                    textBox24.Text = "";
                    textBox25.Text = "";
                    textBox26.Text = "";
                    textBox27.Text = "";
                    textBox35.Text = "";
                    textBox28.Text = "";
                    textBox36.Text = "";
                    textBox29.Text = "";
                    textBox37.Text = "";
                    textBox38.Text = "";
                    textBox30.Text = "";
                }
                else
                {
                    string[] row = new string[reader.FieldCount];
                    while (reader.Read())
                    {
                        textBox3.Text = isDBNull(reader, "整理番号");
                        textBox17.Text = isDBNull(reader, "世帯番号");
                        textBox18.Text = isDBNull(reader, "電話番号");
                        textBox19.Text = isDBNull(reader, "携帯番号");
                        textBox20.Text = isDBNull(reader, "健康診査");
                        textBox21.Text = isDBNull(reader, "結核肺がん");
                        textBox22.Text = isDBNull(reader, "胃がん");
                        textBox23.Text = isDBNull(reader, "大腸がん");
                        textBox24.Text = isDBNull(reader, "前立腺がん");
                        textBox25.Text = isDBNull(reader, "骨粗鬆症");
                        textBox26.Text = isDBNull(reader, "成人歯科");

                        string cervicalCancer = isDBNull(reader, "子宮頸がん");
                        specialInputTwo(cervicalCancer, textBox27, textBox35);

                        string breastCancer = isDBNull(reader, "乳がん");
                        specialInputTwo(breastCancer, textBox28, textBox36);

                        string place = isDBNull(reader, "希望場所");
                        specialInputThree(place, textBox29, textBox37, textBox38);

                        textBox30.Text = "".Equals(isDBNull(reader, "身体不自由")) ? "" : "0";
                    }
                    reader.Close();
                }
            }
            catch (SqlException )
            {
            }

            return err;
        }

        //１回目の修正
        private void updateDataOnce(MySqlConnection conn)
        {
            bool match = false;
            //入力チェック
            if ("".Equals(textBox3.Text)) //必須は整理番号のみ
            {
                MessageBox.Show("整理番号が入力されていません");
                return;
            }

            SaveData sv = makeSaveDataOnce(); //保存用データ生成（パディング済み）

            //マッチングチェック
            bool matchErr = matchInput(sv, "１回目");
            //一致しない場合、エラー表示はするが保存は実行してしまう
            if (matchErr)
            {
                //保存へ進む
            }
            else
            {
                //エラーなしは完了フラグを立てる
                match = true;
            }

            //保存処理
            if (match)
            {
                sv.done = "1";  //マッチングOKの場合、完了フラグを立てる
            }

            sv.updateUser = Global.inputUser;
            bool err = updateData(sv, "１回目", conn);

            SaveData sv1 = new SaveData();
            sv1.lotNo = int.Parse(Global.lotNo);
            sv1.serialNo = sv.serialNo;
            sv1.done = sv.done;
            string tableName = "２回目";
            updateDoneFlag(sv1, tableName, conn);//別の回の完了フラグも立てる

        }

        private SaveData makeSaveDataOnce()
        {
            SaveData sv = new SaveData();

            sv.lotNo = int.Parse(Global.lotNo);      //ロット番号
            sv.adminCode = Global.adminCode;         //行政区コード
            sv.adminName = Global.adminName;         //行政区名称
            sv.healthArea = Global.healthArea;       //保健区
            sv.serialNo = textBox3.Text.PadLeft(10, '0');         //整理番号
            if ("".Equals(textBox17.Text))
            {
                sv.houseNo = "";
            }
            else
            {
                sv.houseNo = textBox17.Text.PadLeft(10, '0');          //世帯番号
            }
            sv.healthCheck = textBox20.Text;      //健康診査
            sv.lungCancer = textBox21.Text;       //結核肺がん
            sv.stomachCancer = textBox22.Text;    //胃がん
            sv.colorectalCancer = textBox23.Text; //大腸がん
            sv.prostateCancer = textBox24.Text;   //前立腺がん
            sv.osteoporosis = textBox25.Text;     //骨粗鬆症
            sv.dental = textBox26.Text;           //成人歯科
            sv.cervicalCancer = specialReadTwo(textBox27, textBox35);   //子宮頸がん
            sv.breastCancer = specialReadTwo(textBox28, textBox36);     //乳がん
            sv.place = specialReadThree(textBox29, textBox37, textBox38);            //希望場所
            sv.handicapped = "".Equals(textBox30.Text) ? "" : "8";      //身体不自由
            sv.phone = textBox18.Text;            //電話番号
            sv.mobilePhone = textBox19.Text;      //携帯番号
            sv.inputDate = null;        //入力日
            sv.inputUser = null;        //入力者
            sv.updateDate = null;       //修正日
            sv.updateUser = null;       //修正者
            sv.done = "";             //完了

            return sv;
        }

        private void setEditable(TextBox tb, bool editable)
        {
            if(editable)
            {
                tb.ReadOnly = false; //読み取り専用解除
                tb.TabStop = true; //タブ移動可
            }
            else
            {
                tb.ReadOnly = true; //読み取り専用
                tb.TabStop = false; //タブ移動負荷
            }
        }

        //編集可能に変更
        private void changeEdit(bool editable)
        {
            setEditable(textBox17, editable);
            setEditable(textBox18, editable);
            setEditable(textBox19, editable);
            setEditable(textBox20, editable);
            setEditable(textBox21, editable);
            setEditable(textBox22, editable);
            setEditable(textBox23, editable);
            setEditable(textBox24, editable);
            setEditable(textBox25, editable);
            setEditable(textBox26, editable);
            setEditable(textBox27, editable);
            setEditable(textBox35, editable);
            setEditable(textBox28, editable);
            setEditable(textBox36, editable);
            setEditable(textBox29, editable);
            setEditable(textBox37, editable);
            setEditable(textBox38, editable);
            setEditable(textBox30, editable);
        }

        //１回目の表示
        private void button6_Click(object sender, EventArgs e)
        {
            if("".Equals(textBox1.Text))
            {
                return;
            }

            MySqlConnection conn;
            string connstr = System.Configuration.ConfigurationManager.AppSettings["Conn"];
            conn = new MySqlConnection(connstr);
            conn.Open();

            string serialNo = textBox1.Text.PadLeft(10, '0');

            string btxt = button6.Text;
            if ("１回目の表示".Equals(btxt))
            {
                changeEdit(false);
                selectDataOnce("１回目", Global.lotNo, serialNo, conn);//表示
                button6.Text = "１回目の編集";
            }
            else if ("１回目の編集".Equals(btxt))
            {
                //編集可能に変更（整理番号だけ変えさせない）
                changeEdit(true);
                button6.Text = "１回目の保存";
            }
            else if ("１回目の保存".Equals(btxt))
            {
                //データ保存
                updateDataOnce(conn);
            }

            panel1.Visible = true;

            conn.Close();

        }

        //閉じる
        private void button7_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void textBox3_KeyPress(object sender, KeyPressEventArgs e) //整理番号
        {
            inputAllNumber(sender, e);
        }

        private void textBox17_KeyPress(object sender, KeyPressEventArgs e) //世帯番号
        {
            inputAllNumber(sender, e);
        }

        private void textBox18_KeyPress(object sender, KeyPressEventArgs e) //電話
        {
            inputAllNumber(sender, e);
        }

        private void textBox19_KeyPress(object sender, KeyPressEventArgs e) //携帯
        {
            inputAllNumber(sender, e);
        }

        private void textBox20_KeyPress(object sender, KeyPressEventArgs e) //健康診査
        {
            inputNumber(sender, e);
        }

        private void textBox21_KeyPress(object sender, KeyPressEventArgs e)//結核肺がん
        {
            inputNumber(sender, e);
        }

        private void textBox22_KeyPress(object sender, KeyPressEventArgs e) //胃がん
        {
            inputNumber(sender, e);
        }

        private void textBox23_KeyPress(object sender, KeyPressEventArgs e) //大腸がん
        {
            inputNumber(sender, e);
        }

        private void textBox24_KeyPress(object sender, KeyPressEventArgs e) //前立腺がん
        {
            inputNumber(sender, e);
        }

        private void textBox25_KeyPress(object sender, KeyPressEventArgs e) //骨粗鬆症
        {
            inputNumber(sender, e);
        }

        private void textBox26_KeyPress(object sender, KeyPressEventArgs e) //成人歯科
        {
            inputNumber(sender, e);
        }

        private void textBox27_KeyPress(object sender, KeyPressEventArgs e) //子宮頸がん
        {
            if ("".Equals(textBox35.Text)) //どちらかにしか入れさせない
            {
                inputNumber(sender, e);
            }
            else
            {
                e.Handled = true;
            }
        }

        private void textBox35_KeyPress(object sender, KeyPressEventArgs e) //子宮頸がん（指定医療機関）
        {
            if ("".Equals(textBox27.Text)) //どちらかにしか入れさせない
            {
                inputNumber(sender, e);
            }
            else
            {
                e.Handled = true;
            }
        }

        private void textBox28_KeyPress(object sender, KeyPressEventArgs e) //乳がん
        {
            if ("".Equals(textBox36.Text)) //どちらかにしか入れさせない
            {
                inputNumber(sender, e);
            }
            else
            {
                e.Handled = true;
            }
        }

        private void textBox36_KeyPress(object sender, KeyPressEventArgs e) //乳がん（石巻市医師会）
        {
            if ("".Equals(textBox28.Text)) //どちらかにしか入れさせない
            {
                inputNumber(sender, e);
            }
            else
            {
                e.Handled = true;
            }
        }

        private void textBox29_KeyPress(object sender, KeyPressEventArgs e) //希望場所
        {
            if ("".Equals(textBox37.Text) && "".Equals(textBox38.Text)) //どちらかにしか入れさせない
            {
                inputZero(sender, e);
            }
            else
            {
                e.Handled = true;
            }
        }

        private void textBox37_KeyPress(object sender, KeyPressEventArgs e) //希望場所（本庁個別）
        {
            if ("".Equals(textBox29.Text) && "".Equals(textBox38.Text)) //どちらかにしか入れさせない
            {
                inputZero(sender, e);
            }
            else
            {
                e.Handled = true;
            }
        }

        private void textBox38_KeyPress(object sender, KeyPressEventArgs e)//希望場所（石巻ロイヤル）
        {
            if ("".Equals(textBox29.Text) && "".Equals(textBox37.Text)) //どちらかにしか入れさせない
            {
                inputZero(sender, e);
            }
            else
            {
                e.Handled = true;
            }
        }

        private void textBox30_KeyPress(object sender, KeyPressEventArgs e) //身体不自由
        {
            inputZero(sender, e);
        }



    }
}