Laola/WpfTest1/selectUser.xaml.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SQLite;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using WpfTest1.SQLite;

namespace WpfTest1
{
    /// <summary>
    /// selectUser.xaml 的交互逻辑
    /// </summary>
    public partial class selectUser : UserControl
    {
        DataSet ds;
        //SQLiteCommandBuilder cmdb;
        SQLiteDataAdapter da;
        //DataRow dr;
        MainWindow father;


        public selectUser()
        {
            InitializeComponent();
            SQLiteLogic.createDBAndTables();
            //dataGrid.LoadingRow += new EventHandler<DataGridRowEventArgs>(dataGrid_LoadingRow);
        }
        public selectUser(MainWindow father)
        {
            InitializeComponent();
            SQLiteLogic.createDBAndTables();
            this.father = father;
            //dataGrid.LoadingRow += new EventHandler<DataGridRowEventArgs>(dataGrid_LoadingRow);
        }

        public void setMainWindow(MainWindow father)
        {
            this.father = father;
        }

        public void dataGrid_LoadingRow(object sender, DataGridRowEventArgs e)
        {
            e.Row.Header = e.Row.GetIndex() + 1;
        }
        //筛选得到符合条件的用户数据
        private void dataGrid_Loaded(object sender, RoutedEventArgs e)
        {
            LoadDataGrid();
        }
        public void LoadDataGrid()
        {
            ////连接字符串
            //string Connstr = "Data Source=" + System.Environment.CurrentDirectory + "\\Junde.db3"; ;
            ////连接对象
            //SQLiteConnection con = new SQLiteConnection(Connstr);
            ////Sql语句
            string orderCondition = "p_last_filter_time desc";
            if (this.Name == "selectUserPatientManagent")
            {
                orderCondition = "p_id asc";
            }
            if (this.Name == "selectUserfilter")
            {
                orderCondition = "p_last_filter_time desc";
            }

            List<Patient> patientList = SQLiteModel.getAllNotLogicDeletePatient(orderCondition);
            //string selectCmd = "SELECT * FROM Patient WHERE p_delete_flag = 0 ORDER BY " + orderCondition + " LIMIT 100";
            //con.Open();
            //da = new SQLiteDataAdapter(selectCmd, con);
            //ds = new DataSet();
            //da.Fill(ds);
            //dataGrid.ItemsSource = ds.Tables[0].DefaultView;
            dataGrid.ItemsSource = patientList;
            //con.Close();
        }

        //点击重置的效果
        private void buttonReset_Click(object sender, RoutedEventArgs e)
        {
            textBoxName.Text = "姓名或者拼音首字母";
            textBoxCaseID.Text = "";
            textBoxPregnancyTime.Text = "";
            textBoxHeightStart.Text = "";
            textBoxHeightEnd.Text = "";
            textBoxWeightStart.Text = "";
            textBoxWeightEnd.Text = "";
            datePickerBirthTimeStart.Text = "";
            datePickerBirthTimeEnd.Text = "";
            LoadDataGrid();
        }

        private void textBoxName_GotFocus(object sender, RoutedEventArgs e)
        {
            if (sender != null)
            {
                TextBox tbx = sender as TextBox;
                tbx.SelectAll();
                tbx.PreviewMouseDown -= new MouseButtonEventHandler(textBoxName_PreviewMouseDown);

            }
        }

        private void textBoxName_PreviewMouseDown(object sender, MouseButtonEventArgs e)
        {
            TextBox tb = sender as TextBox;
            if (tb != null)
            {
                tb.Focus();
                e.Handled = true;
            }
        }

        private void textBoxName_LostFocus(object sender, RoutedEventArgs e)
        {
            TextBox tb = sender as TextBox;
            if (tb != null)
            {
                tb.PreviewMouseDown += new MouseButtonEventHandler(textBoxName_PreviewMouseDown);
            }
        }

        //点击筛选用户
        private void buttonQuery_Click(object sender, RoutedEventArgs e)
        {
            List<string> condition_list = new List<string>();

            //姓名或拼音
            string name_or_py = textBoxName.Text;
            if (name_or_py != "姓名或者拼音首字母" && name_or_py != "")
            {
                condition_list.Add(" and (p_name LIKE \'%"+ name_or_py +"%\' or p_name_py LIKE \'%"+ name_or_py +"%\') ");
            }

            //病例编号
            if(textBoxCaseID.Text != "")
            {
                condition_list.Add("  and p_record_id = '" + textBoxCaseID.Text + "' ");
            }

            //孕次
            if (textBoxPregnancyTime.Text != "")
            {
                string pt_temp = "";
                try
                {
                    pt_temp = Convert.ToString(Convert.ToInt32(textBoxPregnancyTime.Text));
                }
                catch(Exception err)
                {
                    MessageBox.Show("孕次信息格式不正确，请填写一个整数数字。\r\n调试信息："+err.Message,"警告");
                    return;
                }
                condition_list.Add("  and p_pregnancy_time = " + pt_temp + " ");
            }

            //出生日期
            if (datePickerBirthTimeStart.Text != "" && datePickerBirthTimeEnd.Text != "")
            {

                DateTime dt;
                System.Globalization.DateTimeFormatInfo dtFormat = new System.Globalization.DateTimeFormatInfo();
                //MessageBox.Show(pregnancydate);
                dtFormat.ShortDatePattern = "yyyy/M/d";
                string dateStart = datePickerBirthTimeStart.Text;
                string dateEnd = datePickerBirthTimeEnd.Text;
                try
                {
                    dt = Convert.ToDateTime(dateStart, dtFormat);
                    dateStart = dt.ToString("yyyy-MM-dd");
                    dt = Convert.ToDateTime(dateEnd, dtFormat);
                    dateEnd = dt.ToString("yyyy-MM-dd");
                }
                catch (Exception err)
                {
                    MessageBox.Show("孕妇出生日期格式不正确，请通过栏中日历的按钮选择日期。\r\n调试信息：" + err.Message, "警告");
                    return;
                }
                condition_list.Add("  and (p_birthdate between '" + dateStart + "' and '" + dateEnd + "') ");

            }

            //身高条件
            if (textBoxHeightStart.Text != "" && textBoxHeightEnd.Text != "")
            {
                string hs_temp = "";
                string he_temp = "";
                try
                {
                    hs_temp = Convert.ToString(Convert.ToDouble(textBoxHeightStart.Text));
                    he_temp = Convert.ToString(Convert.ToDouble(textBoxHeightEnd.Text));
                }
                catch (Exception err)
                {
                    MessageBox.Show("身高信息格式不正确，请填写一个整数数字。\r\n调试信息：" + err.Message, "警告");
                    return;
                }
                condition_list.Add("  and (p_height between " + hs_temp + " and "+ he_temp + ") ");
            }

            //体重条件
            if (textBoxWeightStart.Text != "" && textBoxWeightEnd.Text != "")
            {
                string ws_temp = "";
                string we_temp = "";
                try
                {
                    ws_temp = Convert.ToString(Convert.ToInt32(textBoxWeightStart.Text));
                    we_temp = Convert.ToString(Convert.ToInt32(textBoxWeightEnd.Text));
                }
                catch (Exception err)
                {
                    MessageBox.Show("体重信息格式不正确，请填写一个整数数字。\r\n调试信息：" + err.Message, "警告");
                    return;
                }
                condition_list.Add("  and (p_weight between " + ws_temp + " and " + we_temp + ") ");
            }

            //连接字符串
            string Connstr = "Data Source=" + System.Environment.CurrentDirectory + "\\Junde.db3"; ;
            //连接对象
            SQLiteConnection con = new SQLiteConnection(Connstr);
            //Sql语句
            string selectCmd = "SELECT * FROM Patient WHERE p_delete_flag = 0";
            foreach(string one_more_condition in condition_list)
            {
                selectCmd += one_more_condition;
            }
            selectCmd += " ORDER BY p_last_filter_time desc LIMIT 1000;";
            con.Open();
            da = new SQLiteDataAdapter(selectCmd, con);
            ds = new DataSet();
            da.Fill(ds);
            dataGrid.ItemsSource = ds.Tables[0].DefaultView;
            con.Close();
        }

        //双击某一行触发的事件
        private void dataGrid_MouseDoubleClick(object sender, MouseButtonEventArgs e)
        {
            if (father != null)
            {
                if (this.Name == "selectUserfilter")
                {
                    father.buttonFilterSelectTreatment_Click(this.father, e);
                }
                if (this.Name == "selectUserPatientManagent")
                {
                    father.buttonModifyPatient_Click(this.father, e);
                }
                if (this.Name == "selectUserevaluation")
                {
                    father.buttonEvaluationSelectPatient_Click(this.father, e);
                }
                if (this.Name == "selectUserHistory")
                {
                    father.buttonHistorySelectPatient_Click(this.father, e);
                }
            }
        }
    }
}