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);
}
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);
}
/// <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);
}
/// <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);
}