예제 #1
0
        public Class_T_CHILD_TEMPERATURE_INFO ExcuteTemperOther()
        {
            Class_T_CHILD_TEMPERATURE_INFO tti = new Class_T_CHILD_TEMPERATURE_INFO();

            //床号
            //tti.Bed_no = this.bed_no;
            //病人编号
            tti.Id         = App.GenId().ToString();
            tti.Pid        = this.pid;
            tti.Patient_ID = this.pid_ids;
            //大便次数
            tti.Stool_count = txtDBCS.Text;
            //大便性质
            tti.Stool_color = txtDBXZ.Text;
            //小便
            tti.Urine = txtXB.Text;
            //脐带
            tti.Umbilicalcord = txtQD.Text;
            //一般情况
            tti.Ybqk = txtYBQK.Text;
            //哺乳
            tti.Feed_style = cboBR.Text;
            //体重
            tti.Weight = txtTZ.Text;
            //签名
            tti.Qm = txtQM.Text;
            //时间
            tti.Record_time = dateTimePicker_Select.Value.ToString("yyyy-MM-dd HH:mm");

            //tti.Empty_name1 = txtEmptyItemName1.Text;
            //tti.Empty_value1 = txtEmptyItemValue1.Text;
            //tti.Empty_name2 = txtEmptyItemName2.Text;
            //tti.Empty_value2 = txtEmptyItemValue2.Text;
            return(tti);
        }
예제 #2
0
        public Class_T_CHILD_TEMPERATURE_INFO ExcuteTemperOther()
        {
            Class_T_CHILD_TEMPERATURE_INFO tti = new Class_T_CHILD_TEMPERATURE_INFO();

            //床号
            //tti.Bed_no = this.bed_no;
            //病人编号
            tti.Id         = App.GenId().ToString();
            tti.Pid        = this.pid;
            tti.Patient_ID = this.pid_ids;
            //大便
            tti.Shit = cmbShit.Text;
            //小便
            tti.Urine = cmbUrine.Text;

            //体重
            tti.Weight = cmbWeight.Text;

            //时间
            tti.Record_time = dateTimePicker_Select.Value.ToString("yyyy-MM-dd HH:mm");

            //入量-总量
            if (this.txtIn.Text != "")
            {
                tti.In_amount = this.txtIn.Text;
            }

            //出量-总量
            if (this.txtOut.Text != "")
            {
                tti.Out_amount = this.txtOut.Text;
            }
            //特殊治疗
            if (this.txtDragInfact.Text != "")
            {
                tti.Special = this.txtDragInfact.Text;
            }

            string blood = "";

            //血压 1
            blood = cmbBp.Text.Trim();
            if (cmbBp2.Text.Trim().Length > 0)
            {
                blood += "," + cmbBp2.Text.Trim();
            }
            tti.Bp_blood     = blood;
            tti.Empty_name1  = txtEmptyItemName1.Text;
            tti.Empty_value1 = txtEmptyItemValue1.Text;
            tti.Empty_name2  = txtEmptyItemName2.Text;
            tti.Empty_value2 = txtEmptyItemValue2.Text;
            return(tti);
        }
예제 #3
0
        /// <summary>
        /// 返回体温其他信息
        /// </summary>
        /// <returns></returns>
        public Class_T_CHILD_TEMPERATURE_INFO ExcuteTemperOther()
        {
            Class_T_CHILD_TEMPERATURE_INFO tti = new Class_T_CHILD_TEMPERATURE_INFO();

            //婴儿编号
            tti.Child_id = this.child_ID;
            //饮食
            //if (cboFood.Text == "--请选择--")
            //{
            //    cboFood.Text = "";
            //}
            tti.Feed_style = cboFood.Text;
            //黄疸Y--有 无--N
            string Mark = "";

            //if (!rdtnHave.Checked)
            //{
            //    Mark = "N";
            //}
            tti.Icterus     = Mark;
            tti.Stool_count = txtNumberTimes.Text;
            //大便性质
            //if (cboColour.Text == "--请选择--")
            //{
            //    cboColour.Text = "";
            //}
            tti.Stool_color  = cboColour.Text;
            tti.Nature_0ther = txtColor_other.Text;

            //脐带
            //if (cboFunicle.Text == "--请选择--")
            //{
            //    cboFunicle.Text = "";
            //}
            tti.Umbilicalcord = cboFunicle.Text;
            tti.Weight        = txtWeight.Text;

            //时间
            tti.Record_time = SelectTime.ToString("yyyy-MM-dd ");
            //面色
            //if (cboColor_Face.Text == "--请选择--")
            //{
            //    cboColor_Face.Text = "";
            //}
            tti.Color_face = cboColor_Face.Text;
            //呼吸
            //if (cboBreathe.Text == "--请选择--")
            //{
            //    cboBreathe.Text = "";
            //}
            tti.Breathe = cboBreathe.Text;
            //哭声
            //if (cboCry.Text == "--请选择--")
            //{
            //    cboCry.Text = "";
            //}
            tti.Cry = cboCry.Text;
            //反应
            //if (cboReaction.Text == "--请选择--")
            //{
            //    cboReaction.Text = "";
            //}
            tti.Reaction = cboReaction.Text;
            tti.Diaper   = txtCount.Text;

            return(tti);
        }
예제 #4
0
        /// <summary>
        /// 插入体温特征
        /// </summary>
        /// <param name="list"></param>
        /// <returns></returns>
        public static bool InsertTempers(List <Class_T_CHILD_VITAL_SIGNS> list, Class_T_CHILD_TEMPERATURE_INFO tti)
        {
            List <string> listSql  = new List <string>();
            List <string> listSql1 = new List <string>();

            for (int i = 0; i < list.Count; i++)
            {
                string sql            = "";
                string sql_operation  = "";
                string sql_operations = "";
                if (list[i] != null)
                {
                    //if (list[i].Describe.ToString() != "")
                    //{
                    //    if (list[i].Describe.ToString().Contains("手术"))
                    //    {

                    //    }
                    //}
                    //else
                    //{
                    sql = string.Format("insert into T_CHILD_VITAL_SIGNS ( " +
                                        "CHILD_ID," +
                                        "MEASURE_TIME," +
                                        "TEMPERATURE_VALUE," +
                                        "RE_MEASURE," +
                                        "DESCRIBE," +
                                        "TEMP_STATE," +
                                        "COOLING_VALUE" +
                                        ") values(" +
                                        "'{0}'," +
                                        "to_TIMESTAMP('{1}','yyyy-MM-dd hh24:mi')," +
                                        "'{2}'," +
                                        "'{3}'," +
                                        "'{4}'," +
                                        "'{5}'," +
                                        "'{6}'" +
                                        ")",
                                        list[i].Child_id,
                                        list[i].Measure_time,
                                        list[i].Temperature_value,
                                        list[i].Re_measure,
                                        list[i].Describe,
                                        list[i].Temp_state,
                                        list[i].Cooling_value
                                        );
                    // }

                    listSql.Add(sql);
                }
            }
            string sql2 = string.Format("insert into T_CHILD_TEMPERATURE_INFO( " +   //其他信息SQL 语句
                                        "CHILD_ID," +
                                        "FEED_STYLE," +
                                        "ICTERUS," +
                                        "STOOL_COUNT," +
                                        "STOOL_COLOR," +
                                        "UMBILICALCORD," +
                                        "WEIGHT," +
                                        "RECORD_TIME," +
                                        "COLOUR_FACE," +
                                        "BREATHE," +
                                        "CRY," +
                                        "REACTION," +
                                        "DIAPER," +
                                        "NUTRUE_OTHERNAME" +
                                        ") values(" +
                                        "'{0}'," +
                                        "'{1}'," +
                                        "'{2}'," +
                                        "'{3}'," +
                                        "'{4}'," +
                                        "'{5}'," +
                                        "'{6}'," +
                                        "to_TIMESTAMP('{7}','yyyy-MM-dd hh24:mi')," +
                                        "'{8}'," +
                                        "'{9}'," +
                                        "'{10}'," +
                                        "'{11}'," +
                                        "'{12}'," +
                                        "'{13}'" +
                                        ")", tti.Child_id,
                                        tti.Feed_style,
                                        tti.Icterus,
                                        tti.Stool_count,
                                        tti.Stool_color,
                                        tti.Umbilicalcord,
                                        tti.Weight,
                                        tti.Record_time,
                                        tti.Color_face,
                                        tti.Breathe,
                                        tti.Cry,
                                        tti.Reaction,
                                        tti.Diaper,
                                        tti.Nature_0ther);

            listSql1.Add(sql2);
            try
            {
                App.ExecuteBatch(listSql.ToArray());
                App.ExecuteBatch(listSql1.ToArray());
            }
            catch (Exception)
            {
                return(false);
            }
            listSql.Clear();
            return(true);
        }