/// <summary>
/// 保存修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
string temp = GetXmlContent();
int message = 0;
try
{
string updateLable = "update T_Follow_TempPlate_Cont set Content=:divContent where tid=" + id;
MySqlDBParameter[] xmlPars = new MySqlDBParameter[1];
xmlPars[0] = new MySqlDBParameter();
xmlPars[0].ParameterName = "divContent";
xmlPars[0].Value = temp;//bodyNode.InnerXml;
xmlPars[0].DBType = MySqlDbType.Text;
xmlPars[0].Direction = ParameterDirection.Input;
message = App.ExecuteSQL(updateLable, xmlPars);
if (message > 0)
{
App.Msg("保存成功");
}
else
{
App.MsgErr("保存失败");
}
}
catch (Exception ex)
{
App.MsgErr("保存失败,错误原因:" + ex.Message);
}
}
/// <summary>
/// 保存注释文书
/// </summary>
private void save_doc()
{
Control[] controls = this.Controls.Find("tctlDoc", true);
if (controls != null && controls.Length > 0)
{
DevComponents.DotNetBar.TabControl tctlDoc = controls[0] as DevComponents.DotNetBar.TabControl;//tabControl1.Tabs[2].AttachedControl.Controls[0].Controls[0] as DevComponents.DotNetBar.TabControl;
if (tctlDoc != null && tctlDoc.Tabs.Count > 0)
{
frmText frm = tctlDoc.SelectedTab.AttachedControl.Controls[0] as frmText;
XmlDocument tempxmldoc = new XmlDocument();
tempxmldoc.PreserveWhitespace = true;
tempxmldoc.LoadXml("<emrtextdoc/>");
frm.MyDoc.ToXML(tempxmldoc.DocumentElement);
//App.UpLoadFtpPatientDoc(tempxmldoc.OuterXml, frm.MyDoc.Us.Tid.ToString() + ".xml", frm.MyDoc.Us.InpatientInfo.Id.ToString());
frm.MyDoc.Modified = false;
String sql_clob = string.Format("update T_PATIENT_DOC_COLB set CONTENT=:doc1 where TID = '{0}'", frm.MyDoc.Us.Tid.ToString());
MySqlDBParameter[] xmlPars = new MySqlDBParameter[1];
xmlPars[0] = new MySqlDBParameter();
xmlPars[0].ParameterName = "doc1";
xmlPars[0].Value = tempxmldoc.OuterXml;
xmlPars[0].DBType = MySqlDbType.Text;
App.ExecuteSQL(sql_clob, xmlPars);
}
}
//else
//{
// App.MsgWaring("没有打开的文书！");
//}
}
/// <summary>
/// 将模版插入数据库
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button2_Click(object sender, EventArgs e)
{
string temp = GetXmlContent();
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.PreserveWhitespace = true;
xmlDoc.LoadXml(temp);
if (current_id == "")
{
frmSmallTemplateSave tpSave = new frmSmallTemplateSave(xmlDoc, Template.fmS.MyDoc);
App.FormStytleSet(tpSave, false);
tpSave.ShowDialog();
}
else
{
XmlElement xmlElement = xmlDoc.DocumentElement;
int message = 0;
try
{
foreach (XmlNode bodyNode in xmlElement.ChildNodes)
{
if (bodyNode.Name == "body")
{
if (bodyNode.HasChildNodes)
{ //int i = 1;
string updateLable = "update T_TempPlate_Cont set Content=:divContent where tid=" + current_id;
MySqlDBParameter[] xmlPars = new MySqlDBParameter[1];
xmlPars[0] = new MySqlDBParameter();
xmlPars[0].ParameterName = "divContent";
//xmlPars[0].Value = divNode.OuterXml;
xmlPars[0].Value = bodyNode.InnerXml;
xmlPars[0].DBType = MySqlDbType.Text;
xmlPars[0].Direction = ParameterDirection.Input;
message = App.ExecuteSQL(updateLable, xmlPars);
if (message > 0)
{
App.Msg("保存成功");
btnSearch_Click(sender, e);
}
else
{
App.MsgErr("保存失败");
}
}
}
}
}
catch (Exception ex)
{
App.MsgErr("保存失败,错误原因:" + ex.Message);
}
}
}
/// <summary>
/// 插入标签模板
/// </summary>
/// <param name="doc">文书代码</param>
/// <param name="xmlDoc">标签模板</param>
/// <returns></returns>
public string InsertLableContent(int tid, string xmlDoc)
{
XmlDocument doc = new XmlDocument();
doc.PreserveWhitespace = true;
doc.LoadXml(xmlDoc);
XmlElement xmlElement = doc.DocumentElement;
string insertLable = "";
int message = 0;
try
{
//foreach (XmlNode bodyNode in xmlElement.ChildNodes)
//{
// if (bodyNode.Name == "body")
// {
// if (bodyNode.HasChildNodes)
// {
string divTitle = "test";
int id = App.GenId("T_TempPlate_Cont", "ID");
//插入标签模块
insertLable = "insert into T_TempPlate_Cont(ID,TID,LableName,Content)values(" + id + "," + tid + ",'" + divTitle + "',:divContent)";
MySqlDBParameter[] xmlPars = new MySqlDBParameter[1];
xmlPars[0] = new MySqlDBParameter();
xmlPars[0].ParameterName = "divContent";
//xmlPars[0].Value = divNode.OuterXml;
xmlPars[0].Value = xmlDoc;
xmlPars[0].DBType = MySqlDbType.Text;
xmlPars[0].Direction = ParameterDirection.Input;
message = App.ExecuteSQL(insertLable, xmlPars);
// }
//}
//}
if (message != 0)
{
return("成功！");
}
else
{
return("失败！");
}
}
catch (Exception ex)
{
return("数据库异常！----------------" + ex.ToString());
}
finally
{
//NClose();
}
}
private void button1_Click(object sender, EventArgs e)
{
try
{
string Sql = string.Empty;
string infection_name = this.textBox1.Text.Trim();
if (string.IsNullOrEmpty(infection_name))
{
App.Msg("名称不能为空！");
return;
}
string v_enabled = "0";
if (this.checkBox1.Checked)
{
v_enabled = "1";
}
if (this.infection_id > 0)
{
Sql = "update t_infection_index a set a.infection_name='" + infection_name + "',a.enabled='" + v_enabled + "'";
Sql += ",description=:description where a.infection_id=" + infection_id;
}
else
{
infection_id = App.GenId();
Sql = " insert into t_infection_index (infection_id, infection_name, enabled, description) values";
Sql += "(" + infection_id + ", '" + infection_name + "', '" + v_enabled + "', :description)";
}
string Content = this.richTextBox1.Text;
if (string.IsNullOrEmpty(Content))
{
Content = " ";
}
byte[] bs = System.Text.Encoding.Default.GetBytes(Content);
MySqlDBParameter[] ops = new MySqlDBParameter[1];
MySqlDBParameter op = new MySqlDBParameter();
op.DBType = MySqlDbType.Blob;
op.ParameterName = "description";
op.Value = bs;
ops[0] = op;
int count = App.ExecuteSQL(Sql, ops);
App.Msg(smg + "成功！");
this.DialogResult = DialogResult.OK;
this.Close();
}
catch { App.Msg(smg + "失败!"); }
}
/// <summary>
/// 将模版插入数据库
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSave_Click(object sender, EventArgs e)
{
string temp = GetXmlContent();
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.PreserveWhitespace = true;
xmlDoc.LoadXml(temp);
if (current_id == "")
{
Template.XmlClearInfo(ref xmlDoc);
frmFollowTemplateSave tpSave = new frmFollowTemplateSave(xmlDoc, trvModel, Template.fmT.MyDoc);
App.FormStytleSet(tpSave, false);
tpSave.ShowDialog();
}
else
{
int message = 0;
try
{
string updateLable = "update T_Follow_TempPlate_Cont set Content=:divContent where tid=" + current_id;
MySqlDBParameter[] xmlPars = new MySqlDBParameter[1];
xmlPars[0] = new MySqlDBParameter();
xmlPars[0].ParameterName = "divContent";
xmlPars[0].Value = temp;//bodyNode.InnerXml;
xmlPars[0].DBType = MySqlDbType.Text;
xmlPars[0].Direction = ParameterDirection.Input;
message = App.ExecuteSQL(updateLable, xmlPars);
if (message > 0)
{
App.Msg("保存成功");
}
else
{
App.MsgErr("保存失败");
}
// }
// }
//}
}
catch (Exception ex)
{
App.MsgErr("保存失败,错误原因:" + ex.Message);
}
}
}
/// <summary>
/// 将汇总记录添加到数据库
/// </summary>
private void addSum()
{
MySqlDBParameter[] parameters = new MySqlDBParameter[6];
parameters[0] = new MySqlDBParameter();
parameters[0].ParameterName = "pid";
parameters[0].DBType = MySqlDbType.VarChar;
parameters[0].Value = Pid;
parameters[0].Size = 20;
parameters[1] = new MySqlDBParameter();
parameters[1].ParameterName = "Total_time";
parameters[1].DBType = MySqlDbType.Timestamp;
parameters[1].Value = App.GetSystemTime();
parameters[2] = new MySqlDBParameter();
parameters[2].ParameterName = "begin_time";
parameters[2].DBType = MySqlDbType.Timestamp;
parameters[2].Value = dtpStart.Value;
parameters[3] = new MySqlDBParameter();
parameters[3].ParameterName = "end_time";
parameters[3].DBType = MySqlDbType.Timestamp;
parameters[3].Value = dtpEnd.Value;
parameters[4] = new MySqlDBParameter();
parameters[4].ParameterName = "recordByid";
parameters[4].DBType = MySqlDbType.VarChar;
if (App.UserAccount.UserInfo != null)
{
parameters[4].Value = App.UserAccount.UserInfo.User_id;
}
else
{
parameters[4].Value = "";
}
parameters[4].Size = 20;
parameters[5] = new MySqlDBParameter();
parameters[5].ParameterName = "sum_type";
parameters[5].DBType = MySqlDbType.Decimal;
parameters[5].Value = cbxTotal.SelectedIndex;
App.ExecuteSQL(Sql_sum, parameters);
}
/// <summary>
/// 提交保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSubmit_Click(object sender, EventArgs e)
{
if (tctlDoc.Tabs.Count != 0)
{
if (tctlDoc.SelectedTabIndex != -1)
{
try
{
TabItem CurrentItem = tctlDoc.SelectedTab;
//currentPatient = currentPage.Tag as InPatientInfo;
string Infomation = CurrentItem.Name;
//string[] ids = Infomation.Split(':');
string isSimple = "1"; //是否为单例文书
string text_name = ""; //文书名
bool isNewdoc = false; //是否新建文书
string text_type = ""; //文书类型号
string Key = ""; //主键
text_type = Infomation.Substring(0, Infomation.IndexOf(":"));
if (CurrentItem.Text.IndexOf(":") != -1)
{
isSimple = "1";
text_name = CurrentItem.Text.Substring(0, CurrentItem.Text.IndexOf(":"));
Key = CurrentItem.Text.Substring(CurrentItem.Text.IndexOf(":") + 1);
}
else
{
text_name = CurrentItem.Text;
isSimple = "0";
Key = text_name;
}
//新建文书保存
if (Infomation.Contains(":New:"))
{
isNewdoc = true;
}
string content = GetXmlContent();
int id = App.GenId("T_FOLLOW_RECORD_DOC", "ID");
XmlDocument doc = new XmlDocument();
doc.PreserveWhitespace = true;
doc.LoadXml(content);
XmlElement xmlElement = doc.DocumentElement;
//插入到统计数据表内
//StaticsToDB InsertXml = new StaticsToDB();
//InsertXml.xmlSpit(doc);
frmText Text = tctlDoc.SelectedPanel.Controls[0] as frmText;
if (!Text.MyDoc._InsertSignature())
{
return;
}
string docSql = "";
if (isNewdoc)
{
docSql = "insert into T_FOLLOW_RECORD_DOC(id,record_id,text_type,doc_name,text_name,doc_content,creator_id,issimpleinstance) values(" + id + "," + myRecord.Id + "," + text_type + ",'" + Key + "','" + text_name + "',:docContent," + App.UserAccount.UserInfo.User_id + ",'" + isSimple + "')";
}
else
{
if (CurrentItem.Text.IndexOf(":") == -1)
{
docSql = "update T_FOLLOW_RECORD_DOC set doc_content=:docContent where text_type=" + text_type + " and record_id=" + myRecord.Id + "";
}
else
{
docSql = "update T_FOLLOW_RECORD_DOC set doc_content=:docContent where record_id=" + myRecord.Id + " and doc_name='" + Key + "'";
}
}
MySqlDBParameter[] xmlPars = new MySqlDBParameter[1];
xmlPars[0] = new MySqlDBParameter();
xmlPars[0].ParameterName = "docContent";
xmlPars[0].Value = doc.OuterXml;
xmlPars[0].DBType = MySqlDbType.Text;
xmlPars[0].Direction = ParameterDirection.Input;
int message = App.ExecuteSQL(docSql, xmlPars);
if (message > 0)
{
App.Msg("保存成功!");
tctlDoc.Tabs.RemoveAt(tctlDoc.SelectedTabIndex);
IniFinishedDoc();
}
}
catch (Exception ex)
{
App.MsgErr(ex.Message);
}
if (App.ReadSqlVal("Select id from T_FOLLOW_DOC_ATTACH where record_id=" + myRecord.Id + "", 0, "id") == null)
{
int flag = 0;
for (int i = 0; i < tctlDoc.Tabs.Count; i++)
{
if (tctlDoc.Tabs[i].Name == "100:Custom")
{
tctlDoc.SelectedTab = tctlDoc.Tabs[i];
flag = 1;
break;
}
}
if (flag == 0)
{
if (!ExistTab("100"))
{
CreateCustomPage();
}
}
}
}
}
}
private void buttonX1_Click(object sender, EventArgs e)
{
try
{
string num = this.txtShengQinghao.Text; //申请病案号
string countnum = this.txtCount.Text; //申请病案住院次数
string remark = this.txtRemark.Text; //申请理由
string eName = this.labEnvelopName.Text; //申请人
string backDocdor = ""; //档案退回操作人
string shenqingName = App.UserAccount.UserInfo.User_id; //申请人的ID
string backID = ""; //退回操作人的ID
if (num == "")
{
App.Msg("申请病案号不能为空");
this.txtShengQinghao.Focus();
return;
}
if (countnum == "")
{
App.Msg("申请病案住院次数不能为空");
this.txtCount.Focus();
return;
}
if (remark == "")
{
App.Msg("申请理由不能为空");
this.txtRemark.Focus();
return;
}
if (eName == "")
{
App.Msg("申请人不能为空");
return;
}
if (lvDocdor2.Items.Count == 0)
{
App.Msg("档案退回操作人不能为空");
return;
}
for (int i = 0; i < lvDocdor2.Items.Count; i++)
{
backDocdor += lvDocdor2.Items[i].Text + ",";
}
if (backDocdor != "")
{
backDocdor = backDocdor.Substring(0, backDocdor.Length - 1);
}
string[] str = backDocdor.Split(','); //退回操作人的姓名
for (int i = 0; i < str.Length; i++) //根据每个人的姓名把他的ID号取出来
{
string selectSQL = "select USER_ID from t_userinfo where USER_NAME='" + str[i] + "'";
DataSet ds = App.GetDataSet(selectSQL);
string aa = ds.Tables[0].Rows[0][0].ToString();
backID += aa + ",";
}
backID = backID.Substring(0, backID.Length - 1);
string eTime = this.labEnveloptime.Text;//申请时间
MySqlDBParameter p_num = new MySqlDBParameter();
p_num.Value = num;
p_num.ParameterName = "num";
p_num.DBType = MySqlDbType.VarChar;
MySqlDBParameter p_count = new MySqlDBParameter();
p_count.Value = countnum;
p_count.ParameterName = "countnum";
p_count.DBType = MySqlDbType.Decimal;
MySqlDBParameter p_remark = new MySqlDBParameter();
p_remark.Value = remark;
p_remark.ParameterName = "remark";
p_remark.DBType = MySqlDbType.VarChar;
MySqlDBParameter p_eName = new MySqlDBParameter();
p_eName.Value = eName;
p_eName.ParameterName = "eName";
p_eName.DBType = MySqlDbType.VarChar;
MySqlDBParameter p_backDocdor = new MySqlDBParameter();
p_backDocdor.Value = backDocdor;
p_backDocdor.ParameterName = "backDocdor";
p_backDocdor.DBType = MySqlDbType.VarChar;
//申请人的ID
MySqlDBParameter p_shenqingName = new MySqlDBParameter();
p_shenqingName.Value = shenqingName;
p_shenqingName.ParameterName = "shenqingName";
p_shenqingName.DBType = MySqlDbType.VarChar;
//退回操作人ID
MySqlDBParameter p_backID = new MySqlDBParameter();
p_backID.Value = backID;
p_backID.ParameterName = "backID";
p_backID.DBType = MySqlDbType.VarChar;
////退回操作人姓名
//MySqlDBParameter p_backDocdo = new MySqlDBParameter();
//p_backDocdor.Value = backDocdor;
//p_backDocdor.ParameterName = "backDocdor";
//p_backDocdor.DBType = MySqlDbType.VarChar;
//if (App.UserAccount.CurrentSelectRole.Section_Id == "")
//{
// //退回状态
// MySqlDBParameter p_backDocd = new MySqlDBParameter();
// p_backDocdor.Value = backDocdor;
// p_backDocdor.ParameterName = "backDocdor";
// p_backDocdor.DBType = MySqlDbType.VarChar;
//}
//MySqlDBParameter p_eTime = new MySqlDBParameter();
//p_remark.Value = remak;
//p_remark.ParameterName = "eTime";
//p_remark.DBType = MySqlDbType.VarChar;
MySqlDBParameter[] parameters = new MySqlDBParameter[] {
p_num,
p_count,
p_remark,
p_eName,
p_backDocdor,
p_shenqingName,
p_backID
};
string insertSQL = "insert into T_DOC_REQ_RECORD(IN_HOSPITAL_ID,IN_COUNT,REQ_REMARK,REQ_BY_NAME,RECORD_BY_NAME,REQ_BY,RECORD_BY," +
" REQ_BY_TIME,REQ_STATE) values(:num, :countnum, :remark, :eName, :backDocdor,:shenqingName,:backID,to_TIMESTAMP('" + eTime + "','yyyy-MM-dd HH24:mi'),'0')";
if (App.ExecuteSQL(insertSQL, parameters) > 0)
{
App.Msg("增加成功");
_uccose.GetCoseData();
this.Close();
}
else
{
App.Msg("增加失败，请检查参数是否正确，网络是否正常");
}
}
catch (Exception exx)
{
App.Msg(exx.Message);
}
}
/// <summary>
/// 会诊单提交时，重新拼接Xml
/// </summary>
private void SetDoc()
{
#region 取出文书
string sql_Con_Content = "select patients_doc,textname,consultaion_record_id from t_patients_doc where textkind_id=821 " +
" and patient_id = (select patient_id from t_consultaion_apply where id = " + flgGrid[flgGrid.RowSel, "apply_id"] + ")";
DataTable dt_ConContent = App.GetDataSet(sql_Con_Content).Tables[0];
string xml_record = null;
foreach (DataRow row in dt_ConContent.Rows)
{
//if (row["textname"].ToString().Split(',').Length > 0)
//{
//会诊记录id
string Recordid = row["consultaion_record_id"].ToString();
if (Recordid == flgGrid[flgGrid.RowSel, "会诊记录序号"].ToString())
{
xml_record = row["patients_doc"].ToString();
break;
}
//}
}
#endregion
if (xml_record != null)
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(xml_record);
XmlNodeList nodeList = xmlDoc.GetElementsByTagName("input");
if (nodeList != null && nodeList.Count > 0)
{
foreach (XmlNode ChildNode in nodeList)
{
if (ChildNode.Attributes["name"] != null)
{
string inputName = ChildNode.Attributes["name"].Value.Trim();
switch (inputName)
{
case "接诊科":
ChildNode.InnerText = App.UserAccount.CurrentSelectRole.Section_name;
break;
case "接诊医师":
ChildNode.InnerXml = App.UserAccount.UserInfo.User_name;
break;
case "接诊日期":
ChildNode.InnerXml = App.GetSystemTime().ToString();
break;
case "会诊答复":
//ChildNode.InnerXml = this.text.MyDoc.GetContainer.ToZYString();
XmlDocument _xmlDoc = new XmlDocument();
_xmlDoc.LoadXml("<a/>");
this.text.MyDoc.GetContainer.ToXML(_xmlDoc.DocumentElement);
ChildNode.InnerXml = _xmlDoc.DocumentElement.InnerXml;
break;
}
}
}
}
MySqlDBParameter[] xmlPars = new MySqlDBParameter[1];
xmlPars[0] = new MySqlDBParameter();
xmlPars[0].ParameterName = "Patients_Doc";
xmlPars[0].Value = xmlDoc.OuterXml;
xmlPars[0].DBType = MySqlDbType.Text;
string update_content = "update t_patients_doc set Patients_Doc=:Patients_Doc where consultaion_record_id=" + Convert.ToInt32(flgGrid[flgGrid.RowSel, "会诊记录序号"]);
int num = App.ExecuteSQL(update_content, xmlPars);
if (num > 0)
{
}
}
}
/// <summary>
/// 添加或者 修改复杂元素
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void tspSave_Click(object sender, EventArgs e)
{
if (this.tvDirectory.SelectedNode != null)
{
if (this.tvDirectory.SelectedNode.ImageIndex == 2)
{
if (this.txtComplexName.Text.Trim() == "")
{
App.Msg("复杂元素名称不能为空！");
return;
}
if (complexAction == "ADD") //添加
{
try
{
foreach (TreeNode oldNode in this.tvList.Nodes)
{
if (oldNode.Text.Trim() == this.txtComplexName.Text.Trim())
{
App.Msg("你输入的值与当前目录下的值重复！");
return;
}
}
DataTable dt = App.GetDataSet("select max(objectid) from ET_DOCUMENT").Tables[0];
string evalueCode = "";
if (dt.Rows.Count > 0)
{
evalueCode = (Convert.ToInt32(dt.Rows[0][0].ToString()) + 1).ToString();
}
string id = App.GenId("TABLE_E", "ID").ToString();
string sql = string.Format("insert into TABLE_E(name,EVALUE,EVALUECODE,SIMPLEMETAID_F,ITEM_STYLE,NUM,ID)values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')"
, this.tvDirectory.SelectedNode.Text
, this.txtComplexName.Text.Trim()
, evalueCode
, this.tvDirectory.SelectedNode.Tag.ToString()
, "100"
, this.tvList.Nodes.Count, id);
XmlDocument tempxmldoc = new XmlDocument();
tempxmldoc.LoadXml("<emrtextdoc/>");
fmText.MyDoc.ToXML(tempxmldoc.DocumentElement);
string sql2 = string.Format("insert into ET_DOCUMENT(OBJECTID,OBJECTNAME,OBJECTTYPE,OBJECTDATA)values('{0}','{1}','{2}',:doc)"
, evalueCode
, this.txtComplexName.Text.Trim()
, "-1");
MySqlDBParameter[] op = new MySqlDBParameter[] { new MySqlDBParameter() };
op[0].ParameterName = "doc";
op[0].DBType = MySqlDbType.Text;
op[0].Value = tempxmldoc.OuterXml;
if (App.ExecuteSQL(sql) > 0 && App.ExecuteSQL(sql2, op) > 0)
{
App.Msg("复杂元素保存成功！");
TreeNode newTn = new TreeNode();
newTn.ImageIndex = 5;
newTn.SelectedImageIndex = 5;
newTn.Text = this.txtComplexName.Text.Trim();
newTn.Tag = evalueCode;
newTn.Name = id;
enable();
this.tvList.Nodes.Add(newTn);
this.tvDirectory_AfterSelect(null, null);
this.tvDirectory.Focus();
}
}
catch
{
App.Msg("网络不通");
}
}
else //修改
{
foreach (TreeNode oldNode in this.tvList.Nodes)
{
if (oldNode.Text.Trim() == this.txtComplexName.Text.Trim() && oldNode.Name != this.tvList.SelectedNode.Name)
{
App.ShowTip("知识库", "你输入的值与当前目录下的值重复！");
return;
}
}
try
{
string sql = string.Format("UPDATE TABLE_E SET EVALUE = '{0}' WHERE ID = '{1}'"
, this.txtComplexName.Text.Trim()
, this.tvList.SelectedNode.Name);
XmlDocument temxmldoc = new XmlDocument();
temxmldoc.LoadXml("<emrtextdoc/>");
fmText.MyDoc.ToXML(temxmldoc.DocumentElement);
string sql2 = string.Format("UPDATE ET_DOCUMENT SET OBJECTDATA=:doc,OBJECTNAME='{0}' where objectid='{1}'"
, this.txtComplexName.Text
, this.tvList.SelectedNode.Tag.ToString());
MySqlDBParameter[] op2 = new MySqlDBParameter[] { new MySqlDBParameter() };
op2[0].ParameterName = "doc";
op2[0].DBType = MySqlDbType.Text;
op2[0].Value = temxmldoc.OuterXml;
if (App.ExecuteSQL(sql) > 0 && App.ExecuteSQL(sql2, op2) > 0)
{
App.Msg("复杂元素保存成功！");
this.tvList.SelectedNode.Text = this.txtComplexName.Text.Trim();
enable();
this.tvList.Focus();
}
}
catch
{
App.Msg("复杂元素保存失败！");
}
}
}
}
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
foreach (TabItem var in tabControl1.Tabs)
{
if (var.IsSelected)
{
for (int i = 0; i < var.AttachedControl.Controls.Count; i++)
{
if (var.AttachedControl.Controls[i].GetType().ToString() == "TextEditor.frmText")
{
textCont = var.AttachedControl.Controls[i] as frmText;
}
}
}
}
Button btn = sender as Button;
int index = btn.Tag.ToString().IndexOf(",");
string btnTag = btn.Tag.ToString().Substring(0, index);
string id = btn.Tag.ToString().Substring(index + 1, btn.Tag.ToString().Length - index - 1);
int tid = 0;
string sql = "";
string ctsql = "update jjhz_cont_time set ";
//获取文书XMl
XmlDocument tempxmldoc = new XmlDocument();
tempxmldoc.PreserveWhitespace = true;
tempxmldoc.LoadXml("<emrtextdoc/>");
textCont.MyDoc.ToXML(tempxmldoc.DocumentElement);
XmlNodeList xnArrInput = tempxmldoc.GetElementsByTagName("input");
XmlNodeList xnArrCbo = tempxmldoc.GetElementsByTagName("checkbox");
switch (btnTag)
{
case "急救信息":
tid = 4946791;
break;
case "患者随访":
tid = 4990475;
break;
case "患者转归":
tid = 4950717;
break;
case "胸痛诊疗":
tid = 4946118;
break;
}
string cont = App.ReadSqlVal("select * from jjhz_cont where id='" + id + "' and tid='" + tid + "'", 0, "CONTENT");
if (cont == null)
{
sql = "insert into jjhz_cont(id,tid,content) values('" + id + "','" + tid + "',:doc1)";
}
else
{
sql = "update jjhz_cont set content=:doc1 where id='" + id + "' and tid='" + tid + "'";
}
MySqlDBParameter[] xmlPars = new MySqlDBParameter[1];
xmlPars[0] = new MySqlDBParameter();
xmlPars[0].ParameterName = "doc1";
xmlPars[0].Value = tempxmldoc.OuterXml;
xmlPars[0].DBType = MySqlDbType.Text;
int j = App.ExecuteSQL(sql, xmlPars);
if (j > 0)
{
string ctcont = App.ReadSqlVal("select * from jjhz_cont_time where id='" + id + "'", 0, "id");
if (ctcont == null)
{
ctsql = "insert into jjhz_cont_time(id) values('" + id + "')";
App.ExecuteSQL(ctsql);
}
int sw = 0;
foreach (XmlNode node in xnArrCbo)
{
if (node.Attributes["id"].Value == "死亡")
{
if (node.Attributes["check"].Value == "Y")
{
sw = 1;
}
}
}
ctsql = "update jjhz_cont_time set HZZG='" + sw + "'";
foreach (XmlNode node in xnArrInput)
{
if (node.Attributes["name"].Value == "时间")
{
try
{
DateTime dt = DateTime.ParseExact(node.InnerText, "yyyy-MM-dd HH:mm", null);
switch (node.Attributes["id"].Value)
{
case "首次医疗接触时间":
ctsql += ",scyljc=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "心电图诊断时间":
ctsql += ",SCXDT=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "传输时间":
ctsql += ",XDTCS=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "报告时间":
ctsql += ",FZJCBG=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
ctsql += ",SHBZWBG=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "溶栓时间":
ctsql += ",RSZL=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "到达本院大门时间":
ctsql += ",DDBYDM=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "启动导管室时间":
ctsql += ",QDDGS=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "决定介入手术时间":
ctsql += ",JDJRSS=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "患者到达导管室":
ctsql += ",HZDDGS=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "球囊扩张时间":
ctsql += ",QNKZ=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "发病时间":
ctsql += ",fb=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "呼救时间":
ctsql += ",hj=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "出车时间":
ctsql += ",cc=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "出诊医生到达现场时间":
ctsql += ",CZYSDDXC=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "院前首份心电图":
ctsql += ",YQSFXDT=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "到达急诊时间":
ctsql += ",HZDDJZK=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "院内接诊时间":
ctsql += ",YNJZ=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "院内首份心电图":
ctsql += ",YNSFXDT=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "初步诊断时间":
ctsql += ",CBZD=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "首次给药时间":
ctsql += ",SCGY=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "到达CCU时间":
ctsql += ",HZDDCCU=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "开始知情同意时间":
ctsql += ",KSZQTY=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "签署知情同意时间":
ctsql += ",QSZQTY=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "导管室激活时间":
ctsql += ",DGSJH=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "开始穿刺时间":
ctsql += ",KSCC=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "造影开始时间":
ctsql += ",ZYKS=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "造影结束时间":
ctsql += ",ZYJS=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "再次签署知情同意":
ctsql += ",ZCQSZQTY=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "手术结束时间":
ctsql += ",SSJS=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "D2B时间":
ctsql += ",DTOB=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "抽血时间":
ctsql += ",SHBZWCX=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "院内心内科医生首诊时间":
ctsql += ",YNXNKYSSZ=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
case "介入人员到达时间":
ctsql += ",JRRYDD=to_date('" + node.InnerText + "','yyyy-MM-dd hh24:mi')";
break;
}
}
catch { }
}
else
{
if (node.Attributes["id"].Value == "远程心电传输")
{
if (node.InnerText == "是")
{
ctsql += ",YCXDCS=1";
}
else
{
ctsql += ",YCXDCS=0";
}
}
}
}
ctsql += " where id='" + id + "'";
App.ExecuteSQL(ctsql);
textCont.MyDoc.Locked = true;
MessageBox.Show("文书保存成功!");
}
else
{
MessageBox.Show("文书保存失败!");
}
}
catch (Exception ex)
{
MessageBox.Show("文书保存失败!");
}
}
/// <summary>
/// 删除文书注释，保存文书
/// </summary>
private void save_doc(string tid, string mark_id)
{
try
{
//如已打开 刷新编辑器内容
for (int i = 0; i < tctlDoc.Tabs.Count; i++)
{
Patient_Doc doc = tctlDoc.Tabs[i].Tag as Patient_Doc;
if (doc.Id.ToString() == tid)
{
frmText frm = tctlDoc.Tabs[i].AttachedControl.Controls[0] as frmText;
foreach (var ele in frm.MyDoc.Elements)
{
if (ele is ZYTextBapfMark)
{
ZYTextBapfMark mark = (ZYTextBapfMark)ele;
if (mark.Value == mark_id)
{
mark.Parent.ChildElements.Remove(mark);
}
}
}
frm.MyDoc.ContentChanged();
}
}
//取出clob
string strSql_Doc = "select a.content from T_PATIENT_DOC_COLB a where a.tid='" + tid + "'";
DataSet ds_Doc = App.GetDataSet(strSql_Doc);
string content_source = "";
XmlDocument tmpxml_source = new XmlDocument();
tmpxml_source.PreserveWhitespace = true;
XmlNodeList list;
content_source = ds_Doc.Tables[0].Rows[0]["content"].ToString();
if (content_source == "" || content_source == null)
{
content_source = App.DownLoadFtpPatientDoc(tid + ".xml", inpat.Id.ToString());
}
tmpxml_source.LoadXml(content_source);
//修改clob
list = tmpxml_source.GetElementsByTagName("bapf");
if (list != null)
{
for (int i = 0; i < list.Count; i++)
{
string aa = list[i].Attributes["value"].Value.ToString();
if (aa == mark_id)
{
list[i].ParentNode.RemoveChild(list[i]);
}
}
}
//提交clob
//重新生成XML文件
//App.UpLoadFtpPatientDoc(tmpxml_source.OuterXml, tid + ".xml", inpat.Id.ToString());
// 更新数据库
String sql_clob = string.Format("update T_PATIENT_DOC_COLB set CONTENT=:doc1 where TID = '{0}'", tid);
MySqlDBParameter[] xmlPars = new MySqlDBParameter[1];
xmlPars[0] = new MySqlDBParameter();
xmlPars[0].ParameterName = "doc1";
xmlPars[0].Value = tmpxml_source.OuterXml;
xmlPars[0].DBType = MySqlDbType.Text;
App.ExecuteSQL(sql_clob, xmlPars);
}
catch { }
}
private void btnComplexSave_Click(object sender, EventArgs e)
{
string tempxml = GetXmlContent();
XmlDocument xmldoc = new XmlDocument();
xmldoc.PreserveWhitespace = true;
xmldoc.LoadXml(tempxml);
XmlElement xmlElement = xmldoc.DocumentElement;
int message = 0;
try
{
foreach (XmlNode bodyNode in xmlElement.ChildNodes)
{
if (bodyNode.Name == "body")
{
if (bodyNode.HasChildNodes)
{
if (complexAction == "ADD")
{
int id = App.GenId();
string sql_clob = "insert into kbs_tempplate_cont(id,tid,CONTENT)values(" + id + "," + advTreeSmallTemplate.SelectedNode.Tag + ",:doc1)";
MySqlDBParameter[] xmlPars = new MySqlDBParameter[1];
xmlPars[0] = new MySqlDBParameter();
xmlPars[0].ParameterName = "doc1";
xmlPars[0].Value = bodyNode.InnerXml;
xmlPars[0].DBType = MySqlDbType.Text;
message = App.ExecuteSQL(sql_clob, xmlPars);
if (message > 0)
{
App.Msg("保存成功！");
}
else
{
App.Msg("保存失败！");
}
}
else
{
String sql_clob = string.Format("update kbs_tempplate_cont set CONTENT=:doc1 where TID = '{0}'", advTreeSmallTemplate.SelectedNode.Tag);
MySqlDBParameter[] xmlPars = new MySqlDBParameter[1];
xmlPars[0] = new MySqlDBParameter();
xmlPars[0].ParameterName = "doc1";
xmlPars[0].Value = bodyNode.InnerXml;
xmlPars[0].DBType = MySqlDbType.Text;
message = App.ExecuteSQL(sql_clob, xmlPars);
if (message > 0)
{
App.Msg("保存成功！");
}
else
{
App.Msg("保存失败！");
}
}
}
}
}
}
catch (Exception ex)
{
App.MsgErr("保存失败,错误原因:" + ex.Message);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
t_handovers_recordInfo handovers = new t_handovers_recordInfo();
try
{
string projectID = "";//异动项目
if (this.cckbOutHospital.Checked)
{
projectID = "240";
}
if (this.cckbConvey.Checked)
{
projectID = "241";
}
if (this.cckbkill.Checked)
{
projectID = "242";
}
if (this.cckbInHospital.Checked)
{
projectID = "243";
}
if (this.cckbShiftTo.Checked)
{
projectID = "244";
}
if (this.cckbSymptom.Checked)
{
projectID = "245";
}
if (this.cckbterminally.Checked)
{
projectID = "246";
}
if (this.cckbOperation.Checked)
{
projectID = "247";
}
if (this.cckbchildbearing.Checked)
{
projectID = "248";
}
if (this.ccbkCaenozoic.Checked)
{
projectID = "249";
}
if (this.ccbkmornOPS.Checked)
{
projectID = "250";
}
string bed_no = this.ccbkbed_No.Text; //病床号
string userName = this.txtuserName.Text; //病人姓名
string illNessNO = this.txtIllNessNO.Text; //诊断号(病案号)
string diagnoseName = this.txtDiagnoseName.Text; //诊断名
string time = this.dateTimePicker1.Text; //时间
string datatime = App.GetSystemTime().ToString("yyyy-MM-dd HH:mm:ss");
string remak = this.txtRemak.Text; //备注(特殊说明)
string nurse_ID = App.UserAccount.UserInfo.User_id; //护士ID
bingquID = App.UserAccount.UserInfo.Sickarea_id; //病区ID
string dayWork = "";
if (work == "白班")
{
dayWork = "白班";
}
else
{
dayWork = "晚班";
}
//string innertSQL = string.Format("insert into t_handovers_record(bed_no, pid," +
// " diagnosis_id, actiontype, remark, set_yuanwai_datetime, sid, nurse_id," +
// " recodertime, daywork) values({0},'{1}',{2},{3},'{4}','{5}',{6},'{7}',to_TIMESTAMP('{8}','yyyy-MM-dd'),'{9}')" +
// " ", bed_no, illNessNO, diagnoseName, projectID, remak, datatime, bingquID, nurse_ID, time, dayWork);
MySqlDBParameter p_bed_no = new MySqlDBParameter();
p_bed_no.Value = bed_no;
p_bed_no.ParameterName = "bed_no";
p_bed_no.DBType = MySqlDbType.VarChar;
MySqlDBParameter p_pid = new MySqlDBParameter();
p_pid.Value = illNessNO;
p_pid.ParameterName = "pid";
p_pid.DBType = MySqlDbType.VarChar;
MySqlDBParameter p_diagnosis_id = new MySqlDBParameter();
p_diagnosis_id.Value = diagnoseName;
p_diagnosis_id.ParameterName = "diagnosis_id";
p_diagnosis_id.DBType = MySqlDbType.VarChar;
MySqlDBParameter p_actiontype = new MySqlDBParameter();
p_actiontype.Value = projectID;
p_actiontype.ParameterName = "actiontype";
p_actiontype.DBType = MySqlDbType.Decimal;
MySqlDBParameter p_remark = new MySqlDBParameter();
p_remark.Value = remak;
p_remark.ParameterName = "remark";
p_remark.DBType = MySqlDbType.VarChar;
MySqlDBParameter p_set_yuanwai_datetime = new MySqlDBParameter();
p_set_yuanwai_datetime.Value = datatime;
p_set_yuanwai_datetime.ParameterName = "set_yuanwai_datetime";
p_set_yuanwai_datetime.DBType = MySqlDbType.VarChar;
MySqlDBParameter p_sid = new MySqlDBParameter();
p_sid.Value = bingquID;
p_sid.ParameterName = "sid";
p_sid.DBType = MySqlDbType.Decimal;
MySqlDBParameter p_nurse_id = new MySqlDBParameter();
p_nurse_id.Value = nurse_ID;
p_nurse_id.ParameterName = "nurse_id";
p_nurse_id.DBType = MySqlDbType.Decimal;
//MySqlDBParameter p_recodertime = new MySqlDBParameter();
//p_recodertime.Value =time;
//p_recodertime.ParameterName = "recodertime";
//p_recodertime.DBType = MySqlDbType.Timestamp;
MySqlDBParameter p_daywork = new MySqlDBParameter();
p_daywork.Value = dayWork;
p_daywork.ParameterName = "daywork";
p_daywork.DBType = MySqlDbType.VarChar;
MySqlDBParameter[] parameters = new MySqlDBParameter[] {
p_bed_no,
p_pid,
p_diagnosis_id,
p_actiontype,
p_remark,
p_set_yuanwai_datetime,
p_sid,
p_nurse_id,
// p_recodertime,
p_daywork
};
string innertSQL = "INSERT INTO t_handovers_record(bed_no,pid,diagnoseName,actiontype, remark,set_yuanwai_datetime, sid, nurse_id,RECODERTIME, daywork)" +
" VALUES (:bed_no,:pid,:diagnosis_id,:actiontype, :remark,:set_yuanwai_datetime, :sid, :nurse_id,to_TIMESTAMP('" + time + "','yyyy-MM-dd HH24:mi:ss'), :daywork)";//;; SELECT @@IDENTITY;
if (App.ExecuteSQL(innertSQL, parameters) > 0)
{
App.Msg("增加成功");
//frmSickReport sick = new frmSickReport();
//sick.Show();
ucfsr.refreshLoad();
this.Close();
}
else
{
App.Msg("增加失败");
this.Close();
}
}
catch (Exception ex)
{
App.MsgErr(ex.Message);
}
}
private void btnSure_Click(object sender, EventArgs e)
{
string tempxml = GetXmlContent();
xmldoc = new XmlDocument();
xmldoc.PreserveWhitespace = true;
xmldoc.LoadXml(tempxml);
//if (xmldoc.GetElementsByTagName("input").Count > 0 || xmldoc.GetElementsByTagName("div").Count > 0 || xmldoc.GetElementsByTagName("table").Count > 0 || xmldoc.GetElementsByTagName("img").Count > 0)
//{
// App.Msg("提示:小模板中不能存在输入框,图片,表格,文本块等多结构化的元素！\r\n(注意:多结构化东西只能保存到大模板中！)");
// return;
//}
if (txtAutoTPName.Text.Trim() == "")
{
App.MsgWaring("小模板名称不能为空！");
txtAutoTPName.Focus();
return;
}
bool flag = false;
for (int i = 0; i < treeView1.Nodes[0].Nodes.Count; i++)
{
if (current_id == "")
{
if (treeView1.Nodes[0].Nodes[i].Text.Trim() == txtAutoTPName.Text.Trim())
{
flag = true;
break;
}
}
else
{
if (treeView1.Nodes[0].Nodes[i].Text.Trim() == txtAutoTPName.Text.Trim())
{
if (treeView1.Nodes[0].Nodes[i].Name.Trim() != current_id.Trim())
{
flag = true;
}
break;
}
}
}
if (flag)
{
App.MsgWaring("已经存在相同名称的小模板！");
txtAutoTPName.Focus();
return;
}
if (current_id == "")
{
if (cboModelType.Text == "请选择...")
{
App.Msg("请选择小模板类型！");
cboModelType.Focus();
return;
}
Class_Patients cpd = new Class_Patients();
string modeltype;
//string SectionId = "";
//模版Id
cpd.Tid = App.GenId("T_TempPlate", "TID");
modeltype = cboModelType.SelectedValue.ToString(); //病种Id
//使用范围
if (this.rdoPersonal.Checked == true)
{
cpd.TempPlate_Level = 'P'; //个人
if (!App.IsHigherMasterDoctor(App.UserAccount.UserInfo.User_id))
{
/*
* 主治一下级别的医生，创建个人模板的时候有创建数量的限制
*/
DataSet ds_get_count = App.GetDataSet("select t.max_count from t_small_template_count_set t where t.section_id=" + App.UserAccount.CurrentSelectRole.Section_Id + "");
if (ds_get_count != null)
{
if (ds_get_count.Tables[0].Rows.Count > 0)
{
DataSet ds_count = App.GetDataSet("select count(tid) from t_tempplate t where t.tempplate_level='P' and t.temptype='S' and t.section_id=" + App.UserAccount.CurrentSelectRole.Section_Id + " and t.Creator_Id=" + App.UserAccount.Account_id + "");
if (Convert.ToInt32(ds_count.Tables[0].Rows[0][0]) >= Convert.ToInt32(ds_get_count.Tables[0].Rows[0][0]))
{
App.MsgWaring("主治以下级别的医生，创建个人模板的时候有创建数量的限制,您的小模板数已经超过了上限" + ds_get_count.Tables[0].Rows[0][0].ToString() + "");
return;
}
}
}
}
}
if (this.rdoSection.Checked == true)
{
cpd.TempPlate_Level = 'S'; //科室
}
cpd.TName = txtAutoTPName.Text; //模板名称
cpd.Ages = -1;
//性别
if (rdoSexNull.Checked)
{
cpd.Sex = 'N';
}
else if (rdoMale.Checked)
{
cpd.Sex = '0';
}
else if (rdoFemale.Checked)
{
cpd.Sex = '1';
}
cpd.Section_ID = 0;
//科室ID
if (App.UserAccount.CurrentSelectRole.Role_name != "系统管理员")
{
cpd.Section_ID = Convert.ToInt32(App.UserAccount.CurrentSelectRole.Section_Id);
}
else
{
if (cmbSection.Visible)
{
cpd.Section_ID = Convert.ToInt32(cmbSection.SelectedValue);
}
}
//病区ID
if (App.UserAccount.CurrentSelectRole.Sickarea_Id != string.Empty)
{
cpd.SickArea_ID = Convert.ToInt32(App.UserAccount.CurrentSelectRole.Sickarea_Id);
}
//创建时间
cpd.Create_Time = this.dtpTime.Value.ToString("yyyy-MM-dd HH:mm");
//创建人ID
cpd.Creator_ID = Convert.ToInt32(App.UserAccount.Account_id);
ArrayList Sqls = new ArrayList();
//设置默认模板
string ISDEFAULT = "N";
//设置是更新或者新增
string temp = "";
//DataSet samedocs = App.GetDataSet("select tid from T_TempPlate where tname='" + cpd.TName + "' and TEMPTYPE='S'");
//if (samedocs.Tables[0] != null)
//{
// if (samedocs.Tables[0].Rows.Count > 0)
// {
// App.MsgWaring("已经存在相同名称的文书，请先修改名称");
// return;
// }
//}
string sick_Id = "0"; //病种Id
if (chkBzfl.Enabled)
{
//if (cboSicknessKind.Text != "请选择...")
if (cboSicknessKind.SelectedIndex >= 0)
{
sick_Id = cboSicknessKind.SelectedValue.ToString();
}
//else
//{
// App.MsgWaring("请选择病种类");
// return;
//}
}
//插入模版表
if (cpd.Section_ID != 0)
{
temp = "insert into T_TempPlate(tid, tname, shortcut, text_type, tempplate_level, sex, ages, sickarea_id, creator_id, create_time, updater_id, update_time, verify_id1, verify_time1, verify_id2, verify_time2, verify_sign, isdiag, enable_flag,ISDEFAULT,SECTION_ID,SMALLTEMPTYPE,TEMPTYPE,SICK_ID) values(" + cpd.Tid + ",'" + cpd.TName + "','" + cpd.Shortcut + "',"
+ "'" + cpd.TextKind + "','" + cpd.TempPlate_Level + "','" + cpd.Sex + "'," + cpd.Ages + ","
+ cpd.SickArea_ID + "," + cpd.Creator_ID + ",to_timestamp("
+ " '" + cpd.Create_Time + "','yyyy-MM-dd HH24:mi')," + cpd.Updater_ID + ",'" + cpd.Update_Time + "'," + cpd.Verify_ID1 + ","
+ "'" + cpd.Verify_Time1 + "'," + cpd.Verify_ID2 + ",'" + cpd.Verify_Time2 + "','" + cpd.Verify_Sign + "',"
+ "'N','N','" + ISDEFAULT + "'," + cpd.Section_ID + ",'" + modeltype + "','S'," + sick_Id + ")";
}
else
{
temp = "insert into T_TempPlate(tid, tname, shortcut, text_type, tempplate_level, sex, ages, sickarea_id, creator_id, create_time, updater_id, update_time, verify_id1, verify_time1, verify_id2, verify_time2, verify_sign, isdiag, enable_flag,ISDEFAULT,SECTION_ID,SMALLTEMPTYPE,TEMPTYPE,SICK_ID) values(" + cpd.Tid + ",'" + cpd.TName + "','" + cpd.Shortcut + "',"
+ "'" + cpd.TextKind + "','" + cpd.TempPlate_Level + "','" + cpd.Sex + "'," + cpd.Ages + ","
+ cpd.SickArea_ID + "," + cpd.Creator_ID + ",to_timestamp("
+ " '" + cpd.Create_Time + "','yyyy-MM-dd HH24:mi')," + cpd.Updater_ID + ",'" + cpd.Update_Time + "'," + cpd.Verify_ID1 + ","
+ "'" + cpd.Verify_Time1 + "'," + cpd.Verify_ID2 + ",'" + cpd.Verify_Time2 + "','" + cpd.Verify_Sign + "',"
+ "'N','N','" + ISDEFAULT + "'," + cpd.Section_ID + ",'" + modeltype + "','S'," + sick_Id + ")";
}
Sqls.Add(temp);
/*
* 移除含有timeTitle属性的div节点
*/
XmlNode root = xmldoc.FirstChild;
bool atrribue = false;
foreach (XmlNode firstNode in root.ChildNodes)
{
if (firstNode.Name == "body")
{
foreach (XmlNode secondNode in firstNode.ChildNodes)
{
if (secondNode.Name == "div")
{
if (secondNode != null)
{
for (int i = 0; i < secondNode.Attributes.Count; i++)
{
if (secondNode.Attributes[i].Name.Trim().ToLower() == "timetitle")
{
atrribue = true;
}
}
if (atrribue)
{
firstNode.RemoveChild(secondNode);
break;
}
}
}
}
}
if (atrribue)
{
break;
}
}
string temp3 = Template.fmS.MyDoc.InsertLableContent(cpd.Tid, xmldoc.OuterXml);
if (temp3.Trim() == "")
{
App.MsgErr("保存失败！");
Template.fmT.MyDoc.ClearContent();
this.Close();
return;
}
string[] AddSqls = new string[Sqls.Count];
for (int i = 0; i < Sqls.Count; i++)
{
AddSqls[i] = Sqls[i].ToString();
}
int x = App.ExecuteBatch(AddSqls);
if (x > 0)
{
App.Msg("模版保存成功!");
btnSearch_Click(sender, e);
}
else
{
App.MsgErr("保存失败！");
}
}
else
{
XmlElement xmlElement = xmldoc.DocumentElement;
int message = 0;
try
{
foreach (XmlNode bodyNode in xmlElement.ChildNodes)
{
if (bodyNode.Name == "body")
{
if (bodyNode.HasChildNodes)
{ //int i = 1;
string updateLable = "update T_TempPlate_Cont set Content=:divContent where tid=" + current_id;
MySqlDBParameter[] xmlPars = new MySqlDBParameter[1];
xmlPars[0] = new MySqlDBParameter();
xmlPars[0].ParameterName = "divContent";
//xmlPars[0].Value = divNode.OuterXml;
xmlPars[0].Value = bodyNode.InnerXml;
xmlPars[0].DBType = MySqlDbType.Text;
xmlPars[0].Direction = ParameterDirection.Input;
message = App.ExecuteSQL(updateLable, xmlPars);
if (message > 0)
{
string sick_Id = "0"; //病种Id
if (chkBzfl.Checked)
{
sick_Id = cboSicknessKind.SelectedValue.ToString();
}
string Sql = "update t_tempplate set tname='" + txtAutoTPName.Text + "',SICK_ID='" + sick_Id + "' where tid=" + current_id + "";
if (radp1.Checked)
{
char lever = 'P';
if (this.rdoSection.Checked)
{
lever = 'S'; //科室
}
Sql = "update t_tempplate set tname='" + txtAutoTPName.Text + "',tempplate_level='" + lever + "',SICK_ID='" + sick_Id + "' where tid=" + current_id + "";
}
App.ExecuteSQL(Sql);
App.Msg("保存成功");
btnSearch_Click(sender, e);
}
else
{
App.MsgErr("保存失败");
}
}
}
}
}
catch (Exception ex)
{
App.MsgErr("保存失败,错误原因:" + ex.Message);
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtName.Text == "")
{
App.Msg("模板标题不得为空");
txtName.Focus();
}
//检查是否重名
DataSet ds = App.GetDataSet("select * from T_FOLLOW_RECORD_DOC where doc_name='" + txtName.Text.Trim() + "'");
if (ds != null)
{
if (ds.Tables[0].Rows.Count != 0)
{
App.Msg("模板标题重复，请重新输入");
txtName.Text = "";
return;
}
}
string r_name = txtName.Text.Trim(); //标题
string f_time = App.GetSystemTime().ToShortDateString(); //创建时间
string creator = App.UserAccount.UserInfo.User_id;
string insertLable = "";
int message = 0;
try
{
XmlNode root = xmldoc.FirstChild;
bool atrribue = false;
foreach (XmlNode firstNode in root.ChildNodes)
{
if (firstNode.Name == "body")
{
foreach (XmlNode secondNode in firstNode.ChildNodes)
{
if (secondNode.Name == "div")
{
if (secondNode != null)
{
for (int i = 0; i < secondNode.Attributes.Count; i++)
{
if (secondNode.Attributes[i].Name.Trim().ToLower() == "timetitle")
{
atrribue = true;
}
}
if (atrribue)
{
firstNode.RemoveChild(secondNode);
break;
}
}
}
}
}
if (atrribue)
{
break;
}
}
//过滤模板文件
DataInit.filterInfo(xmldoc.DocumentElement, Convert.ToInt32(text_type));
int Id = App.GenId("T_FOLLOW_RECORD", "ID"); //T_FOLLOW_RECORD表主键
int Did = App.GenId("T_FOLLOW_RECORD_DOC", "ID"); //T_FOLLOW_RECORD_DOC表主键
string MaxTimes = "";
int Times = 0;
if (GetMaxTimes(patient_id, solution_id) != "")
{
MaxTimes = GetMaxTimes(patient_id, solution_id);
Times = Convert.ToInt32(MaxTimes) + 1;
}
string sql = "";
//插入标签模块
sql = "insert into T_FOLLOW_RECORD(id,patient_id,follow_times,solution_id,lasttime,creator_id) values(" + Id + "," + patient_id + ","
+ "" + Times + "," + solution_id + ",to_date('" + f_time + "','yyyy-MM-dd')," + creator + ")";
App.ExecuteSQL(sql);
insertLable = "insert into T_FOLLOW_RECORD_DOC(ID,RECORD_ID,DOC_NAME,TEXT_TYPE,DOC_CONTENT) VALUES(" + Did + "," + Id + ",'" + r_name + "'," + text_type + ",:divContent)";
MySqlDBParameter[] xmlPars = new MySqlDBParameter[1];
xmlPars[0] = new MySqlDBParameter();
xmlPars[0].ParameterName = "divContent";
//xmlPars[0].Value = divNode.OuterXml;
xmlPars[0].Value = xmldoc.OuterXml;
xmlPars[0].DBType = MySqlDbType.Text;
xmlPars[0].Direction = ParameterDirection.Input;
message = App.ExecuteSQL(insertLable, xmlPars);
if (message != 0)
{
UpdateTree(treeView1, text_type, Did, r_name);
Template.fmT.MyDoc.ClearContent();
treeView1.ExpandAll();
this.Close();
App.Msg("插入成功！");
}
else
{
App.Msg("失败！");
}
}
catch (Exception ex)
{
App.MsgErr("数据库异常！----------------" + ex.ToString());
}
finally
{
//NClose();
}
}
