public virtual bool DeleteAnObjectInTran(object _obj)
{
bool result;
try
{
bool flag = true;
if (_obj == null)
{
throw new Exception("DeleteAnObjectInTran:实体对象为空");
}
DbParameter[] array = null;
string text = this.MakeDeleteSql(_obj, out array);
this.SetParameterValues(_obj, array);
if (DS_SqlHelper.AppDbTransaction == null)
{
throw new Exception("DeleteAnObjectInTran:DrectSoft.DSSqlHelper.DS_SqlHelper没有创建事务!");
}
DS_SqlHelper.ExecuteNonQueryInTran(text, array, CommandType.Text);
result = flag;
}
catch (Exception ex)
{
throw ex;
}
return(result);
}
/// <summary>
/// 初始化科室下拉框
/// Add by xlb 2013-04-08
/// </summary>
/// <param name="lookUpEditor"></param>
private void InitDataDept(LookUpEditor lookUpEditor)
{
try
{
LookUpWindow lookUpWindow = new LookUpWindow();
lookUpEditor.Kind = WordbookKind.Sql;
lookUpEditor.ListWindow = lookUpWindow;
DataTable dtDept = DS_SqlHelper.ExecuteDataTable(@"select ID,NAME,py,wb from department
where sort in('101','102') and valid='1' ", CommandType.Text);
if (dtDept == null || dtDept.Columns.Count <= 0)
{
return;
}
for (int i = 0; i > dtDept.Columns.Count; i++)
{
if (dtDept.Columns[i].ColumnName.ToUpper().Trim() == "ID")
{
dtDept.Columns[i].Caption = "编号";
}
else if (dtDept.Columns[i].ColumnName.ToUpper().Trim() == "NAME")
{
dtDept.Columns[i].Caption = "科室";
}
}
Dictionary <string, int> dictionary = new Dictionary <string, int>();
dictionary.Add("ID", 30);
dictionary.Add("NAME", 76);
SqlWordbook sqlWordBook = new SqlWordbook("deptMent", dtDept, "ID", "NAME", dictionary, "ID//NAME//PY//WB");
lookUpEditor.SqlWordbook = sqlWordBook;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 获取配置信息
/// <auth>Yanqiao.Cai</auth>
/// <date>2012-12-03</date>
/// <param name="key"></param>
/// <returns></returns>
private string GetConfigValueByKey(string key)
{
try
{
if (!string.IsNullOrEmpty(key))
{
string sqlStr = " select * from appcfg where configkey = @key ";
DbParameter[] sqlParams = new DbParameter[]
{
new SqlParameter("@key", SqlDbType.Char, 32)
};
sqlParams[0].Value = key;
DS_SqlHelper.DefaultDataAccess();
DataTable dt = DS_SqlHelper.ExecuteDataTable(sqlStr, sqlParams, CommandType.Text);
if (null != dt && dt.Rows.Count > 0)
{
return(null == dt.Rows[0]["value"] ? string.Empty : dt.Rows[0]["value"].ToString());
}
}
return(string.Empty);
}
catch (Exception ex)
{
io.WriteLog(ex.Message);
throw ex;
}
}
/// <summary>
/// 修改时限条件具体信息
/// by xlb 2013-01-07
/// </summary>
/// <param name="qcCondition"></param>
public static void UpdateCondition(QCCondition qcCondition)
{
try
{
string sqlUpdateCondition = @"update QCCondition set description=@description,"
+ "memo=@memo,tablename=@tablename,columnname=@columnname,"
+ "columnvalue=@columnvalue,timecolumnname=@timecolumn,timerange=@timerange,"
+ "patnocolumnname=@patnocolumnname,dblink=@dblink where code=@code";
SqlParameter[] sps =
{
new SqlParameter("@description", qcCondition.Description),
new SqlParameter("@memo", qcCondition.Memo),
new SqlParameter("@tablename", qcCondition.TableName),
new SqlParameter("@columnname", qcCondition.ColumnName),
new SqlParameter("@columnvalue", qcCondition.ColumnValue),
new SqlParameter("@timecolumn", qcCondition.TimeColumnName),
new SqlParameter("@timerange", qcCondition.TimeRange),
new SqlParameter("@patnocolumnname", qcCondition.PatNoColumnName),
new SqlParameter("@dblink", qcCondition.DBLink),
new SqlParameter("@code", qcCondition.Code)
};
DS_SqlHelper.ExecuteNonQuery(sqlUpdateCondition, sps, CommandType.Text);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 抓取所有数据元
/// Add by xlb 2013-04-12
/// </summary>
/// <returns></returns>
public List <DateElementEntity> GetAllDateElement()
{
try
{
SqlParameter p_result = new SqlParameter("@result", SqlDbType.Structured);
p_result.Direction = ParameterDirection.Output;
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("@ElementId", SqlDbType.VarChar, 50),
new SqlParameter("@ElementName", SqlDbType.VarChar, 50),
new SqlParameter("@ElementClass", SqlDbType.VarChar, 50),
new SqlParameter("@ElementPYM", SqlDbType.VarChar, 50),
p_result
};
sqlParams[0].Value = "";
sqlParams[1].Value = "";
sqlParams[2].Value = "";
sqlParams[3].Value = "";
DataTable dtDateTable = DS_SqlHelper.ExecuteDataTable("EMR_CommonNote.usp_GetDateElement", sqlParams, CommandType.StoredProcedure);
List <DateElementEntity> dataList = DataTableToList <DateElementEntity> .ConvertToModel(dtDateTable);
return(dataList);
}
catch (Exception ex)
{
throw ex;
}
}
public DiagGroupInfo()
{
InitializeComponent();
string sql = "select * from DIAGNOSIS_NEW";
this.gridControl1.DataSource = DS_SqlHelper.ExecuteDataTable(sql);
}
/// <summary>
/// 改用参数查询，避免特殊字符带来的问题
/// by xlb 2012-12-20
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void simpleButtonQueryDG_Click(object sender, EventArgs e)
{
try
{//add try catch 替换单引号，屏蔽基本引起问题的字符 XLB 2012-12-10
//string sql = "select * from DiseaseGroup";
//string name = this.textEditGroupNameQuery.Text.Trim().Replace("'","''");
//if (name != "")
//{
// if (name.Contains("["))
// {
// m_app.CustomMessageBox.MessageShow("请不要输入特殊字符");
// return;
// }
string name = this.textEditGroupNameQuery.Text.Trim();
string sql = "select * from DiseaseGroup where name like '%'||@name||'%'";
SqlParameter[] sps = { new SqlParameter("@name", name) };
// }
//DataTable dt = m_app.SqlHelper.ExecuteDataTable(sql);
DataTable dt = DS_SqlHelper.ExecuteDataTable(sql, sps, CommandType.Text);
if (dt != null && dt.Rows.Count > 0)
{
this.gridControlDiseaseGroup.DataSource = dt;
}
else
{
this.gridControlDiseaseGroup.DataSource = null;
}
}
catch (Exception ex)
{
//m_app.CustomMessageBox.MessageShow(ex.Message);
MyMessageBox.Show(1, ex);
}
}
/// <summary>
/// 多科会诊且会诊意见由受邀医师填写申请人初次打开默认值是否组合其他医师意见
/// Add xlb 2013-03-07
/// </summary>
private string SetComposeConsultSuggestion(ConsultRecordForWrite consultZDR)
{
try
{
//多科会诊且配置由受邀医师填写会诊意见 申请医师总结时根据配置是否组合其他医师意见
if (consultZDR == ConsultRecordForWrite.MultiEmployee)
{
string value = ConsultCommon.GetConfigKey("IsComposeSuggestion").Trim();
string ComposeInfo = string.Empty;
if (value != "0")
{
string sql = @"select s.consultsuggestion,u.name from consultsuggestion s join
users u on s.createuser=u.id where s.valid=1 and u.valid=1 and s.consultapplysn=@consultApplySn and s.state='20'";
SqlParameter[] sps = { new SqlParameter("@consultApplySn", mconsultApplySn) };
DataTable dt = DS_SqlHelper.ExecuteDataTable(sql, sps, CommandType.Text);
if (dt == null || dt.Rows.Count <= 0)
{
return("");
}
foreach (DataRow row in dt.Rows)
{
ComposeInfo += "[" + row["NAME"] + "]" + ":" + row["CONSULTSUGGESTION"];
ComposeInfo += "\r\n";
}
return(ComposeInfo);
}
}
return("");
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 更新会诊申请相关信息的方法
/// Add xlb 2013-03-01
/// </summary>
/// <param name="consultStatus"></param>
private void UpdateConsultApply(ConsultStatus consultStatus)
{
try
{
string sql = @"UPDATE consultapply set consultsuggestion = @consultsuggestion,
finishtime=@finishtime,stateid =@stateid,modifieduser=@modifiedUser,modifiedtime=@modifiedtime WHERE consultapplysn = @consultapplysn";
string consultSuggestion = memoEditSuggestion.Text.Trim();
string finishTime = dateEditConsultationDate.Text + " " + timeEditConsultationTime.Text;
string stateId = Convert.ToString((int)consultStatus);
SqlParameter[] sps =
{
new SqlParameter("@consultsuggestion", consultSuggestion),
new SqlParameter("@finishtime", finishTime),
new SqlParameter("@stateid", stateId),
new SqlParameter("@modifiedUser", m_app.User.Id),
new SqlParameter("@modifiedtime", DateTime.Now.ToString("yyyy-MM-dd HH;mm:ss")),
new SqlParameter("@consultapplysn", mconsultApplySn)
};
DS_SqlHelper.ExecuteNonQuery(sql, sps, CommandType.Text);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 查询方法
/// by XLB 2012-12-14 9:41
/// </summary>
private void Search()
{
try
{
string strSql = @"select ct.TempFlow,ct.TempName,ct.TempDesc,ct.CreateDateTime,ct.modifydatetime from CommonnotePrintTemp ct
where 1=1 and ct.Valide='1' and ct.TempName like '%'||@tname||'%' and ct.TempDesc like '%'||@desca||'%'order by createdatetime desc ";
SqlParameter[] sps = { new SqlParameter("@tname", txtFileName.Text.Trim()),
new SqlParameter("@desca", txtDescription.Text.Trim()) };
DataTable dt = DS_SqlHelper.ExecuteDataTable(strSql, sps, CommandType.Text);
// DataTable dt = m_app.SqlHelper.ExecuteDataTable(strSql, sps,CommandType.Text);
if (dt != null && dt.Rows.Count > 0)
{
gcCommonModel.DataSource = dt;
}
else
{
gcCommonModel.DataSource = null;
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("没有符合条件的数据");
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// .ctor
/// </summary>
public WaterMarkConfig()
{
try
{
DataTable dt = DS_SqlHelper.ExecuteDataTable("select value from appcfg where configkey = 'EmrPDFWaterMark'", CommandType.Text);
if (dt.Rows.Count == 0)
{
return;
}
string xml = dt.Rows[0][0].ToString();
XmlDocument doc = new XmlDocument();
doc.LoadXml(xml);
FontFamily = doc.GetElementsByTagName("font-family")[0].InnerText;
FontSize = int.Parse(doc.GetElementsByTagName("font-size")[0].InnerText);
Content = doc.GetElementsByTagName("content")[0].InnerText.Trim();
TranslateX = float.Parse(doc.GetElementsByTagName("translate-x")[0].InnerText);
TranslateY = float.Parse(doc.GetElementsByTagName("translate-y")[0].InnerText);
ShearX = float.Parse(doc.GetElementsByTagName("shear-x")[0].InnerText);
ShearY = float.Parse(doc.GetElementsByTagName("shear-y")[0].InnerText);
ColorAlpha = int.Parse(doc.GetElementsByTagName("alpha")[0].InnerText);
ColorRed = int.Parse(doc.GetElementsByTagName("red")[0].InnerText);
ColorGreen = int.Parse(doc.GetElementsByTagName("green")[0].InnerText);
ColorBlue = int.Parse(doc.GetElementsByTagName("blue")[0].InnerText);
}
catch (Exception ex)
{
throw new Exception("水印配置有误！ " + ex.Message);
}
}
/// <summary>
/// 受邀医师切换联动事件
/// Add by xlb 2013-03-11
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lookUpEditorEmployee_CodeValueChanged(object sender, EventArgs e)
{
try
{
string sql = "select grade from users where id=@userId";
SqlParameter[] sps = { new SqlParameter("@userId", lookUpEditorEmployee.CodeValue) };
DataTable dt = DS_SqlHelper.ExecuteDataTable(sql, sps, CommandType.Text);
if (dt == null || dt.Rows.Count <= 0)
{
return;
}
string valueLevel = dt.Rows[0][0].ToString();
if (string.IsNullOrEmpty(valueLevel))
{
return;
}
lookUpEditorDocLevel.CodeValueChanged -= new EventHandler(lookUpEditorDocLevel_CodeValueChanged);
lookUpEditorDocLevel.CodeValue = valueLevel;//赋编码前取消联动事件赋值后再注册
lookUpEditorDocLevel.CodeValueChanged += new EventHandler(lookUpEditorDocLevel_CodeValueChanged);
}
catch (Exception ex)
{
MyMessageBox.Show(1, ex);
}
}
/// <summary>
/// 绑定图片签名窗体
/// <auth>zyx</auth>
/// <date>2012-12-13</date>
/// </summary>
private void BindTable()
{
try
{
string sqlStr = "select a.name UserName,a.id UserId ,b.name DepartmentName,c.userpicflow, case when c.Valide=1 then '是' else '否' end as Valide from users a left join department b on a.deptid=b.id left join userpicsign c on a.id=c.userid where a.id=@userid";
SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@userid", SqlDbType.NVarChar) };
parms[0].Value = m_app.User.Id;
DataTable dt = DS_SqlHelper.ExecuteDataTable(sqlStr, parms, CommandType.Text);
DataRow dr = null;
if (dt != null && dt.Rows.Count > 0)
{
dr = dt.Rows[0];
}
PicSignForm picSignForm = new PicSignForm(m_app, dr);
picSignForm.FormClosed += new FormClosedEventHandler(picSignForm_FormClosed);
picSignForm.Dock = DockStyle.Fill;
picSignForm.TopLevel = false;
picSignForm.FormBorderStyle = FormBorderStyle.None;
picSignForm.Show();
xtraTabPagePicSign.Controls.Clear();
xtraTabPagePicSign.Controls.Add(picSignForm);
}
catch (Exception ex)
{
throw ex;
}
}
public DataTable SearchInpatientData(string hour, string date)
{
try
{
string departcode = CommonObjects.CurrentUser.CurrentDeptId;
string wardcode = CommonObjects.CurrentUser.CurrentWardId;
SqlParameter[] sqlParams = new SqlParameter[]
{
new SqlParameter("@departCode", SqlDbType.VarChar, 50),
new SqlParameter("@wardcode", SqlDbType.VarChar, 50),
new SqlParameter("@Timelot", SqlDbType.VarChar, 50),
new SqlParameter("@TimelotSave", SqlDbType.VarChar, 50),
new SqlParameter("@date", SqlDbType.NVarChar, 50),
new SqlParameter("@result", SqlDbType.Structured, int.MaxValue)
};
sqlParams[0].Value = departcode;
sqlParams[1].Value = wardcode;
sqlParams[2].Value = hour;
sqlParams[3].Value = timelotSave; //天数据存为2时段
string surveyDate = m_CurrDatetime; //dateEdit.Text.Replace('/', '-');
sqlParams[4].Value = surveyDate;
sqlParams[5].Direction = ParameterDirection.Output;
DataTable dtInpatient = DS_SqlHelper.ExecuteDataTable("EMR_NURSE_STATION.usp_GetPatientsOfDept", sqlParams, CommandType.StoredProcedure);
dtInpatient.DefaultView.Sort = "BED asc ";
return(dtInpatient);
}
catch (Exception ex)
{
MyMessageBox.Show(1, ex);
}
return(null);
}
/// <summary>
/// 初始化科室信息
/// <auth>张业兴</auth>
/// <date>2012-12-12</date>
/// </summary>
private void InitDepartment()
{
try
{
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@GetType", SqlDbType.VarChar),
new SqlParameter("@result", SqlDbType.Structured)
};
parms[0].Value = "1";
parms[1].Direction = ParameterDirection.Output;
DataTable Dept = DS_SqlHelper.ExecuteDataTable("emrproc.usp_GetMedicalRrecordViewFrm", parms, CommandType.StoredProcedure);
Dept.Columns["ID"].Caption = "科室代码";
Dept.Columns["NAME"].Caption = "科室名称";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("ID", 60);
cols.Add("NAME", 90);
SqlWordbook deptWordBook = new SqlWordbook("querydept", Dept, "ID", "NAME", cols, "ID//NAME//PY//WB");
lookUpEditorDepartment.SqlWordbook = deptWordBook;
lookUpEditorDepartment.CodeValue = "0000";
}
catch (Exception ex)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show(1, ex);
}
}
/// <summary>
/// 保存方法 用于删除受邀医生或修改新增记录
/// Add xlb 2013-03-08
/// </summary>
/// <param name="typeId"></param>
/// <param name="row"></param>
private void SaveConsultRecordDepartment(int typeId /*操作类型*/, DataRow row)
{
try
{
string departmentCode = string.Empty;
string departmentName = string.Empty;
string employeeCode = string.Empty;
string employeeName = string.Empty;
string employeeLevelID = string.Empty;
string createUser = m_app.User.Id; //创建人
string createTime = System.DateTime.Now.ToString();
string modifyuser = m_app.User.Id; //修改人
string canceluser = m_app.User.Id; //作废人
int ConsultID = 0;
int ordervalue = 1;
string sql = @"select id from hospitalinfo";
//医院代码
string hospitalCode = DS_SqlHelper.ExecuteDataTable(sql, CommandType.Text).Rows[0][0].ToString();
//行状态为删除则记录删除行ID
if (row.RowState == DataRowState.Deleted)
{
//获取删除前的ID值
ConsultID = int.Parse(row["ID", DataRowVersion.Original].ToString());
}
else
{//行状态为新增或修改状态则记录相应的值
departmentCode = row["DepartmentCode"].ToString();
departmentName = row["DepartmentName"].ToString();
employeeCode = row["EmployeeCode"].ToString();
employeeName = row["EmployeeName"].ToString();
employeeLevelID = row["EmployeeLevelID"].ToString();
if (!string.IsNullOrEmpty(row["ID"].ToString()))
{
ConsultID = int.Parse(row["ID"].ToString());//ID
}
}
SqlParameter[] sps =
{
new SqlParameter("@TypeID", typeId),
new SqlParameter("@ConsultId", ConsultID),
new SqlParameter("@consultapplysn", mconsultApplySn),
new SqlParameter("@ordervalue", ordervalue),
new SqlParameter("@hospitalcode", hospitalCode),
new SqlParameter("@departmentcode", departmentCode),
new SqlParameter("@departmentname", departmentName),
new SqlParameter("@employeecode", employeeCode),
new SqlParameter("@employeename", employeeName),
new SqlParameter("@employeelevelid", employeeLevelID),
new SqlParameter("@createuser", createUser),
new SqlParameter("@createtime", createTime),
new SqlParameter("@canceluser", canceluser),
new SqlParameter("@modifyuser", modifyuser)
};
DS_SqlHelper.ExecuteNonQuery("EMR_CONSULTATION.usp_SaveConsultRecord", sps, CommandType.StoredProcedure);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 保存所有病历
/// </summary>
/// <auth>Yanqiao.Cai</auth>
/// <date>2013-02-21</date>
/// <param name="list"></param>
private void SaveRecordsInTran(List <DataRow> list)
{
try
{
if (null == list || list.Count() == 0)
{
return;
}
DS_SqlHelper.CreateSqlHelper();
DS_SqlHelper.BeginTransaction();
foreach (DataRow dr in list)
{
if (dr["sortid"].ToString() == ContainerCatalog.BingChengJiLu && !m_IsNeedBatchInDailyEmr)//如果是病程记录，并且不需要导入病程，则暂时不做任何动作
{
//TODO
}
else
{
EmrModel model = new EmrModel(dr);
if (null != dr["content"] && !string.IsNullOrEmpty(dr["content"].ToString().Trim()))
{
model.ModelContent = NewXmlDocument(dr["content"].ToString());
}
m_RecordDal.InsertModelInstanceInTran(model, Convert.ToInt32(m_CurrentInpatient.NoOfFirstPage));
}
}
DS_SqlHelper.CommitTransaction();
}
catch (Exception ex)
{
DS_SqlHelper.AppDbTransaction.Rollback();
throw new Exception(ex.Message);
}
}
/// <summary>
/// <Auth>Add BY XLB</Auth>
/// <Date>2013-06-05</Date>
/// <Purpose>校验受邀医师是否已完成会诊意见</Purpose>
/// </summary>
/// <param name="employeeCode">受邀医师代码</param>
/// <return>是否不可删除false表示可删除true表示不可删除</return>
private bool GetEmployeeStatus(string employeeCode)
{
try
{
DataTable dtCount = DS_SqlHelper.ExecuteDataTable(@"select count(*) from consultsuggestion where
consultapplysn=@consultApplySn and valid='1'and createuser=@createUser and state='20'",
new SqlParameter[] { new SqlParameter("@consultApplySn", mconsultApplySn == null ? "" : mconsultApplySn),
new SqlParameter("@createUser", employeeCode == null ? "" : employeeCode) }, CommandType.Text);
if (dtCount == null || dtCount.Rows.Count <= 0)
{
return(false);
}
int result = int.Parse(dtCount.Rows[0][0].ToString());
if (result > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
throw ex;
}
}
public QCEmrItem(string formCaption)
{
try
{
InitializeComponent();
formName = formCaption.Substring(0, formCaption.IndexOf("("));
InitDataEMrQcItem();
SetEditState(false, true);
DS_SqlHelper.CreateSqlHelper();
#region 事件
btnSearch.Click += new EventHandler(btnSearch_Click);
btnReset.Click += new EventHandler(btnReset_Click);
btnAddEmrQcItem.Click += new EventHandler(btnAddEmrQcItem_Click);
btnEdit.Click += new EventHandler(btnEdit_Click);
btnDeleteEmrQcItem.Click += new EventHandler(btnDeleteEmrQcItem_Click);
btnSave.Click += new EventHandler(btnSave_Click);
btnCancel.Click += new EventHandler(btnCancel_Click);
btnClose.Click += new EventHandler(btnClose_Click);
gridViewEmrQcItem.DoubleClick += new EventHandler(gridViewEmrQcItem_DoubleClick);
#endregion
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
///根据传入的字符串查询结果绑定数据
///王冀 2012 10 24
///edit zyx 2012-12-17 系统参数配置中，当查询不到结果时给出提示框
///edit by xlb 2012-12-28 改用参数化查询
/// </summary>
/// <param name="key"></param>
private void BindData(string sql, string key)
{
try
{
//sql_helper = DataAccessFactory.DefaultDataAccess;
appdal = new AppConfigDalc();
//sourceTable = sql_helper.ExecuteDataTable(sql_str);
SqlParameter[] sps = { new SqlParameter("@conName", key) };
//DataTable sourceTable = sql_helper.ExecuteDataTable(key);
DataTable sourceTable = DS_SqlHelper.ExecuteDataTable(sql, sps, CommandType.Text);
if (sourceTable == null || sourceTable.Rows.Count <= 0)
{
MessageBox.Show("没有符合条件的数据");
}
gridControl1.DataSource = sourceTable;
//if (sourceTable == null || sourceTable.Rows.Count <= 0)
//{
// MessageBox.Show("没有符合您查询的系统参数配置的相关数据！");
//}
m_app.PublicMethod.ConvertGridDataSourceUpper(gridView1);
//绑定数据 查询结构加载时 changed事件获取不到句柄 不能自动绑定数据需要手动加载 2012-10-25
DataRow dataRow = gridView1.GetDataRow(gridView1.FocusedRowHandle);
if (dataRow == null)
{
return;
}
SetApp(dataRow);
AddControlToMyPanel(dataRow);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 新增时限条件
/// xlb 2013-01-06
/// </summary>
/// <param name="qcCondition"></param>
public static void InsertCondition(QCCondition qcCondition)
{
try
{
string sqlCondtiion = "insert into QCCondition(code,description,valid,memo,tablename,"
+ "columnname,columnvalue,timecolumnname,timerange,patnocolumnname,dblink) values(@code,"
+ "@description,@valid,@memo,@tablename,@columnname,@columnvalue,@timecolumnname,@timerange,"
+ "@patnocolumnname,@dblink)";
SqlParameter[] sps =
{
new SqlParameter("@code", qcCondition.Code),
new SqlParameter("@description", qcCondition.Description),
new SqlParameter("@valid", "1"),
new SqlParameter("@memo", qcCondition.Memo),
new SqlParameter("@tablename", qcCondition.TableName),
new SqlParameter("@columnname", qcCondition.ColumnName),
new SqlParameter("@columnvalue", qcCondition.ColumnValue),
new SqlParameter("@timecolumnname", qcCondition.TimeColumnName),
new SqlParameter("@timerange", qcCondition.TimeRange),
new SqlParameter("@patnocolumnname", qcCondition.PatNoColumnName),
new SqlParameter("@dblink", qcCondition.DBLink)
};
DS_SqlHelper.ExecuteNonQuery(sqlCondtiion, sps, CommandType.Text);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 右侧展示此病人的病案首页信息
/// add by ywk 2013年7月30日 11:45:56
/// </summary>
/// <param name="drInpatient"></param>
private void LoadIemMainPage(DataRow drInpatient)
{
try
{
if (string.IsNullOrEmpty(drInpatient["Noofinpat"].ToString()))
{
return;
}
string noofinpat = drInpatient["Noofinpat"].ToString();
string search = " select mname from dict_catalog where ccode='AA' ";
DataTable dt = DS_SqlHelper.ExecuteDataTable(search, CommandType.Text);
editor = (IEMREditor)Activator.CreateInstance(Type.GetType(dt.Rows[0]["mname"].ToString()), new object[] { noofinpat });
editor.DesignUI.Dock = DockStyle.Fill;
scrolInpIemInfo.Controls.Clear();
scrolInpIemInfo.Controls.Add(editor.DesignUI);
m_APP.CurrentPatientInfo = new DrectSoft.Common.Eop.Inpatient(Convert.ToDecimal(noofinpat));
m_APP.CurrentPatientInfo.ReInitializeAllProperties();
editor.Load(m_APP);
}
catch (Exception ex)
{
DrectSoft.Common.Ctrs.DLG.MyMessageBox.Show("错误信息！" + ex.Message);
return;
}
}
/// <summary>
/// 取得所有有效时限条件
/// xlb 2013-01-06
/// </summary>
/// <returns></returns>
public static DataTable GetAllQcCondition2(QCCondition _qcCondition)
{
try
{
if (_qcCondition == null)
{
return(null);
}
if (_qcCondition.Code == null)
{
_qcCondition.Code = "";
}
if (_qcCondition.Description == null)
{
_qcCondition.Description = "";
}
SqlParameter[] sps =
{
new SqlParameter("@code", _qcCondition.Code),
new SqlParameter("@description", _qcCondition.Description)
};
DataTable dtQCCondition = DS_SqlHelper.ExecuteDataTable(c_SqlQcCondition2, sps, CommandType.Text);
return(dtQCCondition);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 初始化科室
/// </summary>
private void InitDepartment()
{
try
{
lookUpEditorDepartment.Kind = WordbookKind.Sql;
lookUpEditorDepartment.ListWindow = lookUpWindowDepartment;
string sqlInitdepart = @"select * from department where valid='1'";
DataTable dtDepartment = DS_SqlHelper.ExecuteDataTable(sqlInitdepart, CommandType.Text);
for (int i = 0; i < dtDepartment.Columns.Count; i++)
{
if (dtDepartment.Columns[i].ColumnName.ToUpper().Trim() == "ID")
{
dtDepartment.Columns[i].Caption = "科室代码";
}
else if (dtDepartment.Columns[i].ColumnName.ToUpper().Trim() == "NAME")
{
dtDepartment.Columns[i].Caption = "科室名称";
}
}
Dictionary <string, int> colWidths = new Dictionary <string, int>();
colWidths.Add("ID", 60);
colWidths.Add("NAME", 70);
SqlWordbook wordBook = new SqlWordbook("Department", dtDepartment, "ID", "NAME", colWidths, "ID//NAME//PY//WB");
lookUpEditorDepartment.SqlWordbook = wordBook;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 查看维护数据元是否已被使用
/// Add by xlb 2013-04-12
/// </summary>
/// <param name="iemeXId">维护对象数据元对应流水号</param>
/// <returns>条数</returns>
public int GetIsBeenUse(string iemeXId /*维护对象属性流水号*/)
{
try
{
//通过维护对象数据元查看是否该数据元已被使用
//需串维护表确定该字段是否仍在使用
string sqlGetCount = @"select count(*) from iem_mainpage_except_use where
iemexid=@ieMexId and
exists(select 1 from iem_mainpage_except where iemexid=@ieMexId
and valide='1')";
SqlParameter[] sps = { new SqlParameter("@ieMexId", iemeXId) };
DataTable dtCount = DS_SqlHelper.ExecuteDataTable(sqlGetCount, sps, CommandType.Text);
if (dtCount == null || dtCount.Rows.Count <= 0)
{
return(0);
}
else
{
return(Int32.Parse(dtCount.Rows[0][0].ToString()));
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 完成病历后，结束该份病历对应的时限记录
/// </summary>
public void CompleteQCTimeLimit(string recordDetailID)
{
try
{
Action <string> CompleteQCTimeLimitAction = (id) =>
{
try
{
DS_SqlHelper.BeginTransaction();
DataTable dt = GetRecordDetailInfo(id);
if (dt != null && dt.Rows.Count > 0)
{
CompleteQCTimeLimitInner(dt);
}
DS_SqlHelper.CommitTransaction();
}
catch (Exception ex)
{
DS_SqlHelper.AppDbTransaction.Rollback();
throw ex;
}
};
CompleteQCTimeLimitAction.BeginInvoke(recordDetailID, null, null);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 通过存储过程来查找医嘱信息
/// </summary>
/// <param name="procedureName"></param>
private void GetDateTableByPrc(string procedureName)
{
try
{
SqlParameter p_result = new SqlParameter("@result", SqlDbType.Structured);
p_result.Direction = ParameterDirection.Output;
SqlParameter[] sps =
{
new SqlParameter("@InpatId", SqlDbType.VarChar),
new SqlParameter("@DeptId", SqlDbType.VarChar),
new SqlParameter("@Type", rdgOrderStyle.SelectedIndex),
new SqlParameter("@BeginDate", SqlDbType.VarChar),
new SqlParameter("@EndDate", SqlDbType.VarChar),
p_result
};
if (CurrentInpatient != null)
{
sps[0].Value = CurrentInpatient.NoOfHisFirstPage;
}
else
{
sps[0].Value = CurrentNoofinpat;
}
sps[1].Value = lookUpEditorDept.CodeValue;
sps[3].Value = dateEditBegin.Text;
sps[4].Value = dateEditEnd.Text;
dtOrder = DS_SqlHelper.ExecuteDataTable(procedureName, sps, CommandType.StoredProcedure);
}
catch (Exception ex)
{
throw ex;
}
}
public ActiveUser()
{
InitializeComponent();
string sql = "select * from ACTIVEUSER";
this.gridControl1.DataSource = DS_SqlHelper.ExecuteDataTable(sql);
}
/// <summary>
/// 刷新数据 --- 员工列表
/// </summary>
/// <auth>Yanqiao.Cai</auth>
/// <date>2012-12-28</date>
private void RefreashUsersData()
{
try
{
string sqlStr = " select u.id as userid,u.name as username,u.py,u.wb,u.sexy,u.deptID,d1.name as deptName from users u join department d1 on u.deptid=d1.id ";
List <DbParameter> listPars = new List <DbParameter>();
if (!string.IsNullOrEmpty(this.lookUpEditorDepartment.CodeValue.Trim()) && this.lookUpEditorDepartment.CodeValue.Trim() != "0000")
{
sqlStr += " and u.deptid = @deptid ";
SqlParameter param1 = new SqlParameter("@deptid", SqlDbType.Char, 12);
param1.Value = this.lookUpEditorDepartment.CodeValue.Trim();
listPars.Add(param1);
}
if (!string.IsNullOrEmpty(this.txt_userName.Text.Trim()))
{
sqlStr += " and (u.id like @userName or u.name like @userName or u.py like @userName or u.wb like @userName) ";
SqlParameter param2 = new SqlParameter("@userName", SqlDbType.Char, 32);
param2.Value = "%" + this.txt_userName.Text.Trim() + "%";
listPars.Add(param2);
}
sqlStr += " order by deptName,username ";
DS_SqlHelper.CreateSqlHelper();
DataTable dt = DS_SqlHelper.ExecuteDataTable(sqlStr, listPars, CommandType.Text);
this.gridControl_user.DataSource = dt;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 根据婴儿数量动态创建按钮
/// <auth>zyx</auth>
/// <date>2013-1-7</date>
/// </summary>
/// <param name="dateTable"></param>
private void CreateButton(DataTable dateTable)
{
try
{
gcBaby.Controls.Clear();
if (dateTable != null && dateTable.Rows.Count > 0)
{
int count = int.Parse(dateTable.Rows[0]["babycount"].ToString());
string sqlGetBaby = "select i.noofinpat,i.name from inpatient i where i.mother=@mother";
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@mother", SqlDbType.Decimal)
};
parms[0].Value = dateTable.Rows[0]["noofinpat"];
DataTable dtBaby = DS_SqlHelper.ExecuteDataTable(sqlGetBaby, parms, CommandType.Text);
for (int i = 0; i < count; i++)
{
SimpleButton btn = new SimpleButton();
Point pt = new Point(10 + i * 85, 26);
btn.Location = pt;
btn.Text = dtBaby.Rows[i]["name"].ToString();
btn.Name = dtBaby.Rows[i]["noofinpat"].ToString();
btn.Click += new EventHandler(btn_Click);
gcBaby.Controls.Add(btn);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
