private void btnSure_Click(object sender, EventArgs e)
{
if (dateTimePicker_Select.Value.Date > Convert.ToDateTime(endDate) ||
dateTimePicker_Select.Value.Date < Convert.ToDateTime(startDate))
{
App.MsgWaring("选择的时间不正确，必选择给定的时间段范围之内的时间！");
return;
}
string time = SelectTime.ToString("yyyy-MM-dd");
DBControl.IsClear_ChildTemperasure(time, this.pid_ids); //根据时间清除数据
string title = string.Format("查询时间[{0}]-病人主键[{1}]-病人编号[{2}]-病人姓名[{3}]-床号[{4}]-科室[{5}]-", time, pid_ids, pid, userName, bed_no, section);
if (Excute() && DBControl.InsertTempers_Others(ExcuteTemperOther())) //重新插入数据Remove
{
if (Erm != "")
{
DBControl.ErrorLog("体温单保存成功: 操作用户:" + App.UserAccount.UserInfo.User_name, title + Erm);
}
App.Msg("数据保存成功");
list.Clear();
}
else
{
if (Erm != "")
{
DBControl.ErrorLog("体温单保存失败: 操作用户:" + App.UserAccount.UserInfo.User_name, title + Erm);
}
App.Msg("数据保存失败");
list.Clear();
}
//保存页眉信息
if (this.txtBedNo.Text.Trim().Length > 0)
{
string bedno = this.txtBedNo.Text.Trim();
string diagnose = string.Empty;
string diagnosecount = string.Empty;
List <string> HeadInfo = new List <string>();
string sql = string.Empty;
sql = "delete from t_temperature_pageinfo a where a.patient_id='" + this.pid_ids + "' and pageindex='" + pageindex + "'";
HeadInfo.Add(sql);
sql = " insert into t_temperature_pageinfo(id,pageindex,bedno,diagnose,diagnose_count,patient_id)values('" + App.GenId().ToString() + "','" + pageindex + "','" + bedno + "','" + diagnose + "','" + diagnosecount + "','" + pid_ids + "')";
HeadInfo.Add(sql);
int count = 0;
App.ExecuteBatch(HeadInfo.ToArray());
}
this.Close();
}
private void btnSave_Click(object sender, EventArgs e)
{
/*
* 相关的操作代码 和 愿体温单录入的操作差不多
*/
if (dateTimePicker_Select.Value.Date > Convert.ToDateTime(endDate) ||
dateTimePicker_Select.Value.Date < Convert.ToDateTime(startDate))
{
App.MsgWaring("选择的时间不正确，必选择给定的时间段范围之内的时间！");
return;
}
//if (rbEnema.Checked)
//{
// if (txtEnemaCount.Text.Trim() == "")
// {
// App.Msg("选择灌肠，灌肠次数不能为空!");
// return;
// }
// if (txtEnemaCount.Text.Trim() == "0")
// {
// App.Msg("选择灌肠，灌肠次数不能为0!");
// return;
// }
// if (txtAfterEnemaShitCount.Text.Trim().Length == 0)
// {
// App.Msg("选择灌肠，大便次数不能为空!");
// return;
// }
//}
if (rbEnema2.Checked)
{
int iEnema = 0;
int.TryParse(this.cmbEnema.Text.Trim(), out iEnema);
if (iEnema < 1)
{
App.Msg("选择灌肠，灌肠次数不能小于1");
return;
}
}
string time = dateTimePicker_Select.Value.ToString("yyyy-MM-dd");
DBControl.IsClear_Others(time, this.pid_ids); //根据时间清除数据
string title = string.Format("查询时间[{0}]-病人主键[{1}]-病人编号[{2}]-病人姓名[{3}]-床号[{4}]-科室[{5}]-", time, pid_ids, pid, "", bed_no, "");
//list.Add(this.GetTempers(this.pid, this.bed_no, dateTimePicker_Select.Value.ToString("yyyy-MM-dd"), this.pid_ids));
if (DBControl.InsertTempers_Others(ExcuteTemperOther())) //重新插入数据Remove
{
if (Erm != "")
{
DBControl.ErrorLog("体温单保存成功: 操作用户:" + App.UserAccount.UserInfo.User_name, title + Erm);
}
App.Msg("数据保存成功");
}
else
{
if (Erm != "")
{
DBControl.ErrorLog("体温单保存失败: 操作用户:" + App.UserAccount.UserInfo.User_name, title + Erm);
}
App.Msg("数据保存失败");
}
this.Close();
}
public PacketException(string msg, string e)
{
DBControl dbc = new DBControl();
dbc.ErrorLog(msg, e.ToString());
}
public PacketException(Packet packet, string msg, System.Exception e)
{
DBControl dbc = new DBControl();
dbc.ErrorLog(packet.CustomerID, msg, e.ToString(), packet.PhoneNum);
}
private void btnSure_Click(object sender, EventArgs e)
{
if (dateTimePicker_Select.Value.Date > sysTime.Date || dateTimePicker_Select.Value.Date > Convert.ToDateTime(endDate) ||
dateTimePicker_Select.Value.Date < Convert.ToDateTime(startDate))
{
App.MsgWaring("选择的日期不正确，只能选择当前页七天的日期范围，并且不能超过当前日期，否则无法保存!");
return;
}
string time = SelectTime.ToString("yyyy-MM-dd");
DateTime dtTime = SelectTime;
//体温根据时间点段 前2小时,后1小时59分 清除数据
DBControl.IsClear_Temperasure_Time(SelectTime, this.pid_ids);
DBControl.IsClear_Others(time, this.pid_ids);
string title = string.Format("查询时间[{0}]-病人主键[{1}]-病人编号[{2}]-病人姓名[{3}]-床号[{4}]-科室[{5}]-", time, pid_ids, pid, userName, bed_no, section);
if (Excute() && DBControl.InsertTempers_Others(ExcuteTemperOther()) && PageInfoRefresh()) //重新插入数据Remove
{
if (Erm != "")
{
DBControl.ErrorLog("体温单保存成功: 操作用户:" + App.UserAccount.UserInfo.User_name, title + Erm);
}
App.Msg("数据保存成功");
list.Clear();
}
else
{
if (Erm != "")
{
DBControl.ErrorLog("体温单保存失败: 操作用户:" + App.UserAccount.UserInfo.User_name, title + Erm);
}
App.Msg("数据保存失败");
list.Clear();
}
//刷新体温单
if (A_RefleshTemprature != null)
{
A_RefleshTemprature(sender, e);
setOldDateTime(dtTime);
}
//保存页眉信息
//if (this.txtbedno.Text.Trim().Length > 0 || txtDiagnose.Text.Trim().Length > 0)
//{
// string bedno = this.txtbedno.Text.Trim();
// string section_name = string.Empty;
// //section_name = cmbSection.SelectedValue.ToString();
// //section_name = txtSection.Text;
// string diag = txtDiagnose.Text.Trim();
// List<string> HeadInfo = new List<string>();
// string sql = string.Empty;
// sql = "delete from t_temperature_pageinfo a where a.patient_id='" + this.pid_ids + "' and pageindex='" + pageindex + "'";
// HeadInfo.Add(sql);
// sql = " insert into t_temperature_pageinfo(id,pageindex,bedno,diagnose,diagnose_count,section_name,patient_id)values('" + App.GenId().ToString() + "','" + pageindex + "','" + bedno + "','" + diag + "','" + DiagnoseCount + "','" + section_name + "','" + pid_ids + "')";
// HeadInfo.Add(sql);
// int count = 0;
// if (App.ExecuteBatch(HeadInfo.ToArray()) > 0)
// {
// ucTempratureEdit.RefreshHeader(this.pid_ids, pageindex,Convert.ToDateTime(startDate), Convert.ToDateTime(endDate));
// }
//}
#region 手术质控信息
List <string> Operations = new List <string>();
if (this.oldOperations.Count > 0 || this.newOperations.Count > 0)
{
string beforeOperation = "";
string afterOperation = "";
if (string.IsNullOrEmpty(age))
{
age = App.ReadSqlVal("select age from t_in_patient where id='" + pid_ids + "'", 0, "age");
}
foreach (string var in this.oldOperations)
{
if (newOperations.Exists(delegate(string s) { return(s == var); }))
{
continue;
}
else
{
beforeOperation = "insert into t_job_temp(PID,OPERATE_TYPE,OPERATE_TIME,PATIENT_ID,age,EVENT_TYPE,ywcstate) values('" + pid + "','术前',to_timestamp('" + var.Split(',')[0] + "','syyyy-mm-dd hh24:mi:ss')," + pid_ids + ",'" + age + "','-','1')";
afterOperation = "insert into t_job_temp(PID,OPERATE_TYPE,OPERATE_TIME,PATIENT_ID,age,EVENT_TYPE,ywcstate) values('" + pid + "','术后',to_timestamp('" + var.Split(',')[1] + "','syyyy-mm-dd hh24:mi:ss')," + pid_ids + ",'" + age + "','-','1')";
Operations.Add(beforeOperation);
Operations.Add(afterOperation);
}
}
foreach (string var in newOperations)
{
if (oldOperations.Exists(delegate(string s) { return(s == var); }))
{
continue;
}
else
{
beforeOperation = "insert into t_job_temp(PID,OPERATE_TYPE,OPERATE_TIME,PATIENT_ID,age,EVENT_TYPE,ywcstate) values('" + pid + "','术前',to_timestamp('" + var.Split(',')[0] + "','syyyy-mm-dd hh24:mi:ss')," + pid_ids + ",'" + age + "','','1')";
afterOperation = "insert into t_job_temp(PID,OPERATE_TYPE,OPERATE_TIME,PATIENT_ID,age,EVENT_TYPE,ywcstate) values('" + pid + "','术后',to_timestamp('" + var.Split(',')[1] + "','syyyy-mm-dd hh24:mi:ss')," + pid_ids + ",'" + age + "','','1')";
Operations.Add(beforeOperation);
Operations.Add(afterOperation);
}
}
if (Operations.Count > 0)
{
App.ExecuteBatch(Operations.ToArray());
}
}
#endregion
}