private object getInstance(Neusoft.FrameWork.Models.NeuObject obj)
{
if (obj.ID == "" || obj.Name == "")
{
return(null);
}
System.Reflection.Assembly assembly = null;
assembly = System.Reflection.Assembly.LoadFrom(obj.ID);
Type type = assembly.GetType(obj.Name);
if (type == null)
{
return(null);
}
System.Object objHandle = System.Activator.CreateInstance(type);
return(objHandle);
}
/// <summary>
/// 查询某日科室医生出诊情况
/// </summary>
/// <param name="seatDate"></param>
/// <param name="dept"></param>
/// <param name="noonID"></param>
/// <returns></returns>
public ArrayList Query(DateTime seatDate, Neusoft.FrameWork.Models.NeuObject dept, string noonID)
{
string sql = "", where = "";
if (this.Sql.GetSql("Registration.DoctSchema.Query.2", ref sql) == -1)
{
return(null);
}
if (this.Sql.GetSql("Registration.DoctSchema.Query.5", ref where) == -1)
{
return(null);
}
where = string.Format(where, seatDate.ToString(), dept.ID, noonID);
sql = sql + " " + where;
return(QuerySchema(sql));
}
/// <summary>
/// 初始化界面--必须一
/// </summary>
/// <param name="conditions"></param>
/// <returns></returns>
public int InitCondition(ArrayList conditions)
{
// TODO: 添加 ucQuery.InitCondition 实现
if (conditions.Count <= 0)
{
Neusoft.FrameWork.Models.NeuObject objTemp = new Neusoft.FrameWork.Models.NeuObject();
conditions.Add(objTemp);
}
Neusoft.FrameWork.Models.NeuObject o = conditions[0] as Neusoft.FrameWork.Models.NeuObject;
if (o == null)
{
MessageBox.Show("传入的条件必须继承于neuObject.");
return(-1);
}
alConditions = conditions;
return(this.RefreshList());
}
/// <summary>
/// 初始化
/// </summary>
protected void InitControlParm()
{
this.ucClinicTree1.OperDept = this.OperDept;
this.ucClinicTree1.OperInfo = this.OperInfo;
this.ucClinicTree1.ApproveDept = this.ApproveDept; //核准科室 实际扣库科室
this.ucClinicTree1.SetFunMode(this.funMode);
this.ucClinicTree1.SetTerminal(this.Terminal);
this.ucClinicTree1.IsFindToAdd = true;
this.ucClinicDrug1.IsShowDrugSendInfo = false; //不显示配/发药信息
this.ucClinicDrug1.OperDept = this.OperDept;
this.ucClinicDrug1.OperInfo = this.OperInfo;
this.ucClinicDrug1.ApproveDept = this.ApproveDept; //核准科室 实际扣库科室
this.ucClinicDrug1.SetFunMode(this.funMode);
this.ucClinicDrug1.SetTerminal(this.Terminal);
}
protected override void OnLoad(EventArgs e)
{
ArrayList list = new ArrayList();
Neusoft.FrameWork.Models.NeuObject obj = null;
obj = new Neusoft.FrameWork.Models.NeuObject();
obj.ID = "1";
obj.Name = "门诊";
list.Add(obj);
obj = new Neusoft.FrameWork.Models.NeuObject();
obj.ID = "2";
obj.Name = "住院";
list.Add(obj);
this.neuDept.AddItems(list);
this.beginTime = new DateTime(manger.GetDateTimeFromSysDateTime().Year, manger.GetDateTimeFromSysDateTime().Month, manger.GetDateTimeFromSysDateTime().Day, 0, 0, 0);
this.endTime = this.beginTime.AddDays(-1);
base.OnLoad(e);
}
protected override void OnLoad(EventArgs e)
{
//人员
Neusoft.FrameWork.Models.NeuObject obj = new Neusoft.FrameWork.Models.NeuObject();
obj.ID = "ALL";
obj.Name = "全部";
alOper.Add(obj);
ArrayList list = new ArrayList();
list = manager.QueryEmployeeAll();
alOper.AddRange(list);
cmbOper.AddItems(alOper);
cmbOper.SelectedIndex = 0;
base.OnLoad(e);
}
/// <summary>
/// 获得上级修改痕迹
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public Neusoft.FrameWork.Models.NeuObject GetSuperMark(Neusoft.FrameWork.Models.NeuObject obj)
{
string strSql = "";
if (this.Sql.GetSql("EPR.EMR.GetSuperMark", ref strSql) == -1)
{
return(null);
}
strSql = string.Format(strSql, obj.ID, obj.Name);
ArrayList al = this.myGetSuperMark(strSql);
if (al == null || al.Count == 0)
{
return(null);
}
return(al[0] as Neusoft.FrameWork.Models.NeuObject);
}
/// <summary>
/// 获取树结点
/// </summary>
/// <param name="sqlIndex">sql索引</param>
/// <param name="param">参数</param>
/// <returns>树结点数组</returns>
private List <TreeNode> getObject(string sqlIndex, params string[] param)
{
List <TreeNode> ls = new List <TreeNode>();
string SQL = "";
if (dbMgr.Sql.GetSql(sqlIndex, ref SQL) == -1)
{
this.ShowMessageBox("没有找到SQL：" + sqlIndex, "错误");
}
SQL = string.Format(SQL, param);
if (dbMgr.ExecQuery(SQL) == -1)
{
this.ShowMessageBox("执行SQL发生错误：" + dbMgr.Err, "错误");
}
try
{
while (dbMgr.Reader.Read())
{
Neusoft.FrameWork.Models.NeuObject obj = new Neusoft.FrameWork.Models.NeuObject();
TreeNode node = new TreeNode();
obj.ID = dbMgr.Reader[0].ToString(); //试图名称
obj.Name = dbMgr.Reader[1].ToString(); //自定义类型 试图说明
obj.Memo = dbMgr.Reader[2].ToString(); //备注
obj.User01 = dbMgr.Reader[3].ToString(); //强制条件 SQL索引
obj.User02 = dbMgr.Reader[4].ToString(); //二级权限
//sql 如果是用户定义,则从界面获取
//如果是预定则为空
obj.User03 = dbMgr.Reader[5].ToString();
node.Tag = obj;
node.Text = string.IsNullOrEmpty(obj.Memo) ? obj.Name : obj.Memo;
//node.ImageIndex = 3;
//node.SelectedImageIndex = 4;
ls.Add(node);
}
dbMgr.Reader.Close();
}
catch (Exception ex)
{
this.ShowMessageBox("执行SQL发生错误：" + ex.Message, "错误");
}
return(ls);
}
private void AddConstsToTable(ArrayList list, DataTable table)
{
table.Clear();
int i = 0;
foreach (Neusoft.HISFC.Models.Base.Bed myBed in list)
{
//string strTrue = "是", strFalse = "否";
string strOutDate = "";
Neusoft.FrameWork.Models.NeuObject obj = new Neusoft.FrameWork.Models.NeuObject();
try
{
myBed.BedGrade.Name = helper.GetName(myBed.BedGrade.ID);
}
catch { }
if (myBed.PrepayOutdate == DateTime.MinValue)
{
strOutDate = "";
}
else
{
strOutDate = myBed.PrepayOutdate.ToString();
}
table.Rows.Add(new Object[] { myBed.ID,
myBed.SickRoom,
myBed.BedGrade.Name,
myBed.BedRankEnumService.Name,
myBed.Status.Name,
myBed.InpatientNO,
myBed.Phone,
myBed.OwnerPc,
myBed.IsValid,
myBed.IsPrepay,
strOutDate });
this.fpSpread1_Sheet1.Rows[i].Tag = myBed;
i++;
}
for (int k = i; k <= 15; k++)
{
table.Rows.Add(new object[] { });
}
}
/// <summary>
/// 采购计划单据列表
/// </summary>
/// <param name="privDept">权限科室</param>
/// <param name="stockState">采购状态</param>
public void ShowStockPlanList(Neusoft.FrameWork.Models.NeuObject privDept, string stockState)
{
//清空列表
this.Nodes.Clear();
Neusoft.HISFC.BizLogic.Material.Plan planManger = new Neusoft.HISFC.BizLogic.Material.Plan();
//显示采购单列表 0 状态为入库计划单
ArrayList alList = planManger.QueryStockPLanCompanayList(privDept.ID, stockState);
if (alList == null)
{
System.Windows.Forms.MessageBox.Show("获取采购计划单列表发生错误" + planManger.Err);
return;
}
if (alList.Count == 0)
{
this.Nodes.Add(new System.Windows.Forms.TreeNode("没有采购计划单", 0, 0));
}
else
{
this.Nodes.Add(new System.Windows.Forms.TreeNode("采购计划单列表", 0, 0));
foreach (Neusoft.FrameWork.Models.NeuObject info in alList)
{
System.Windows.Forms.TreeNode node = new System.Windows.Forms.TreeNode();
node.Text = "【" + info.ID + "】" + info.User01;//【入库计划单号】+供货公司名称
node.SelectedImageIndex = node.ImageIndex;
//初始入库计划制定时指定供货公司编码为'0000000000'
if (info.Name == null || info.Name.Trim() == "")
{
info.Name = "0000000000";
}
node.Tag = info; //入库计划单号+供货公司ID
this.Nodes[0].Nodes.Add(node);
}
this.Nodes[0].ExpandAll();
this.SelectedNode = this.Nodes[0];
}
}
/// <summary>
/// 设置领送人
/// </summary>
/// <param name="isAllEmployee">所有人员 设置为True时 employeeType参数无意义</param>
/// <param name="personType">人员类别</param>
/// <returns>成功返回1 失败返回-1</returns>
public int SetTargetPerson(bool isAllEmployee, Neusoft.HISFC.Models.Base.EnumEmployeeType personType)
{
this.alTargetPerson.Clear();
this.lnbTargetPerson.Visible = true;
this.cmbTargetPerson.Visible = true;
Neusoft.HISFC.BizLogic.Manager.Person managerIntegrate = new Neusoft.HISFC.BizLogic.Manager.Person();
if (isAllEmployee)
{
this.alTargetPerson = managerIntegrate.GetEmployeeAll();
}
else
{
this.alTargetPerson = managerIntegrate.GetEmployee(personType);
}
if (this.alTargetPerson == null)
{
MessageBox.Show("根据人员类别获取人员列表发生错误" + managerIntegrate.Err);
return(-1);
}
if (this.isSetDefaultTargetPerson)
{
if (this.targetPerson.ID == "")
{
if (this.alTargetPerson.Count > 0)
{
if (this.localTargetPerson != null && this.localTargetPerson.ID != "")
{
this.TargetPerson = this.localTargetPerson;
this.localTargetPerson = null;
}
else
{
this.TargetPerson = this.alTargetPerson[0] as Neusoft.FrameWork.Models.NeuObject;
}
}
}
}
return(1);
}
//obj.id ,name,memo=bed,user01=dept,user02=status user03=sex
private void AddInfo(int Branch, Neusoft.FrameWork.Models.NeuObject neuObj, object obj)
{
string strText = neuObj.Name;
string strMemo = "";
switch (this.myShowType.GetHashCode())
{
case 1: //类型
strMemo = "【" + neuObj.Memo + "】";
break;
case 3: //属性
if (neuObj.User01 != null || neuObj.User01 != "")
{
strMemo = "【" + neuObj.User01 + "】";
}
break;
case 4: //类型+属性
strMemo = "【" + neuObj.User01 + "】" + "【" + neuObj.Memo + "】";
break;
default:
break;
}
try
{
if (strMemo.Trim() != "")
{
if (this.myDirection == enuShowDirection.Behind)
{
strText = strText + strMemo;
}
else
{
strText = strMemo + strText;
}
}
}
catch {}
int ImageIndex = DeptImageIndex;
this.AddTreeNode(Branch, strText, obj, ImageIndex);
}
/// <summary>
/// 分类选择
/// </summary>
/// <param name="iRow">行索引</param>
protected int PopMSCustomType(int iRow)
{
ArrayList al = Neusoft.HISFC.Models.Base.EnumMSCustomTypeService.List();
Neusoft.FrameWork.Models.NeuObject typeObj = new Neusoft.FrameWork.Models.NeuObject();
if (Neusoft.FrameWork.WinForms.Classes.Function.ChooseItem(al, ref typeObj) == 0)
{
return(-1);
}
else
{
this.neuSpread1_Sheet1.Cells[iRow, 2].Text = typeObj.Name;
this.neuSpread1_Sheet1.Cells[iRow, 3].Text = typeObj.ID;
this.SetTypeItem(iRow);
}
return(1);
}
/// <summary>
/// 刷新挂号科室
/// </summary>
/// <param name="person"></param>
private void refresh(Neusoft.FrameWork.Models.NeuObject person)
{
if (this.fpEnter1_Sheet1.RowCount > 0)
{
this.fpEnter1_Sheet1.Rows.Remove(0, this.fpEnter1_Sheet1.RowCount);
}
//检索操作员的挂号科室
al = this.perMgr.Query(person);
this.fpEnter1_Sheet1.Tag = person;
if (al != null)
{
int i = 0;
foreach (Neusoft.FrameWork.Models.NeuObject obj in al)
{
this.fpEnter1_Sheet1.Rows.Add(this.fpEnter1_Sheet1.RowCount, 1);
int row = this.fpEnter1_Sheet1.RowCount - 1;
this.fpEnter1_Sheet1.SetValue(row, 0, person.Name, false);
this.fpEnter1_Sheet1.SetValue(row, 1, this.getDeptNameByID(obj.User01), false);
this.fpEnter1_Sheet1.SetTag(row, 1, obj.User01);
this.fpEnter1_Sheet1.SetValue(row, 2, obj.User02, false);
this.fpEnter1_Sheet1.SetValue(row, 3, obj.User03, false);
this.fpEnter1_Sheet1.Rows[row].Tag = obj;
i++;
if (i == 1)
{
bool isContain = Neusoft.FrameWork.Function.NConvert.ToBoolean(obj.Memo);
if (isContain)
{
this.rdIn.Checked = true;
}
else
{
this.rdOut.Checked = true;
}
}
}
}
}
/// <summary>
/// 增加申请数据
/// </summary>
/// <param name="listCode">申请单号</param>
/// <param name="state">状态</param>
/// <returns>成功返回1 </失败返回-1returns>
protected virtual int AddApplyData(string listCode, string state)
{
Neusoft.HISFC.BizLogic.Pharmacy.Item itemManager = new Neusoft.HISFC.BizLogic.Pharmacy.Item();
ArrayList al = itemManager.QueryApplyIn(this.phaInManager.DeptInfo.ID, listCode, "0");
if (al == null)
{
System.Windows.Forms.MessageBox.Show(Language.Msg("未正确获取外部入库申请信息" + itemManager.Err));
return(-1);
}
this.Clear();
Neusoft.FrameWork.Models.NeuObject applyCompany = new Neusoft.FrameWork.Models.NeuObject();
foreach (Neusoft.HISFC.Models.Pharmacy.Input input in al)
{
Neusoft.HISFC.Models.Pharmacy.Item tempItem = itemManager.GetItem(input.Item.ID);
input.Item = tempItem; //药品实体信息
input.Quantity = input.Operation.ApplyQty;
if (this.AddDataToTable(input) == 1)
{
this.hsInputData.Add(input.Item.ID + input.BatchNO, input);
}
applyCompany = input.Company;
}
Neusoft.HISFC.BizLogic.Pharmacy.Constant consManager = new Neusoft.HISFC.BizLogic.Pharmacy.Constant();
Neusoft.HISFC.Models.Pharmacy.Company compay = consManager.QueryCompanyByCompanyID(applyCompany.ID);
applyCompany.Name = compay.Name;
applyCompany.Memo = "1";
this.phaInManager.TargetDept = applyCompany;
this.CompuateSum();
this.SetFormat();
return(1);
}
private void neuSpread1_ButtonClicked(object sender, FarPoint.Win.Spread.EditorNotifyEventArgs e)
{
Neusoft.FrameWork.Models.NeuObject obj = this.neuSpread1_Sheet1.ActiveCell.Tag as Neusoft.FrameWork.Models.NeuObject;
if (obj == null)
{
MessageBox.Show("选择的科室有误！");
return;
}
this.txtDept.Text = obj.Name;
this.txtDept.Tag = obj;
this.lblTip.Text = "请您点击[挂号]!";
this.btOk.Focus();
this.MouseMove(this.ptReg);
this.MouseLeave(this.ptDept);
this.MouseLeave(this.pbReadCard);
//this.FindForm().WindowState = FormWindowState.Maximized;
}
/// <summary>
/// 保存人员属性变动数据－－先执行更新操作，如果没有找到可以更新的数据，则插入一条新记录
/// </summary>
/// <param name="Permission">权限实体</param>
/// <returns>0没有更新 1成功 -1失败</returns>
public int SetSign(Neusoft.FrameWork.Models.NeuObject sign, byte[] img)
{
int param;
//执行更新操作
param = UpdateSign(sign);
//如果没有找到可以更新的数据，则插入一条新记录
if (param == 0 || param == -1)
{
param = InsertSign(sign);
}
if (param == -1)
{
return(-1);
}
param = UpdateSignBackGround(sign.ID, img);
return(param);
}
protected override void OnLoad(EventArgs e)
{
//药房名称
ArrayList list = new ArrayList();
Neusoft.FrameWork.Models.NeuObject obj = new Neusoft.FrameWork.Models.NeuObject();
obj.ID = "全院";
obj.Name = "全院";
alDept.Add(obj);
list = deptManager.GetDeptment(Neusoft.HISFC.Models.Base.EnumDepartmentType.P);
alDept.AddRange(list);
cmbDeptName.AddItems(alDept);
cmbDeptName.SelectedIndex = 0;
base.OnLoad(e);
}
/// <summary>
/// 刷新列表
/// </summary>
/// <param name="person"></param>
private void RefreshList(Neusoft.FrameWork.Models.NeuObject nurse)
{
if (this.fpEnter1_Sheet1.RowCount > 0)
{
this.fpEnter1_Sheet1.Rows.Remove(0, this.fpEnter1_Sheet1.RowCount);
}
try
{
//检索病区的维护信息
this.alNurse = this.nurseDept.GetDeptInfoByNurseNo(nurse.ID);
this.neuTabControl1.TabPages[0].Text = nurse.Name;
this.fpEnter1_Sheet1.Tag = nurse;
if (alNurse != null)
{
foreach (Neusoft.FrameWork.Models.NeuObject obj in alNurse)
{
this.fpEnter1_Sheet1.Rows.Add(this.fpEnter1_Sheet1.RowCount, 1);
int row = this.fpEnter1_Sheet1.RowCount - 1;
this.fpEnter1_Sheet1.Rows[row].Tag = obj;
//挂号科室代码
this.fpEnter1_Sheet1.SetText(row, 0, this.GetDeptNameByID(obj.Name));
this.fpEnter1_Sheet1.Cells[row, 0].Tag = obj.Name;
//显示顺序
this.fpEnter1_Sheet1.SetValue(row, 1, obj.User01, false);
//操作员
this.fpEnter1_Sheet1.SetValue(row, 2, obj.User02, false);
//操作时间
this.fpEnter1_Sheet1.SetValue(row, 3, this.nurseDept.GetSysDateTime(), false);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString() + this.nurseDept.Err);
}
}
/// <summary>
/// 比较运算符项目
/// </summary>
/// <returns></returns>
private void initCompareOperatorItems()
{
this.arrCompareOperator = new ArrayList();
Neusoft.FrameWork.Models.NeuObject obj = new Neusoft.FrameWork.Models.NeuObject();
obj.ID = "Like";
obj.Name = "包含";
this.arrCompareOperator.Add(obj);
obj = new Neusoft.FrameWork.Models.NeuObject();
obj.ID = "not Like";
obj.Name = "不包含";
this.arrCompareOperator.Add(obj);
obj = new Neusoft.FrameWork.Models.NeuObject();
obj.ID = "=";
obj.Name = "等于";
this.arrCompareOperator.Add(obj);
obj = new Neusoft.FrameWork.Models.NeuObject();
obj.ID = "<>";
obj.Name = "不等于";
this.arrCompareOperator.Add(obj);
obj = new Neusoft.FrameWork.Models.NeuObject();
obj.ID = ">";
obj.Name = "大于";
this.arrCompareOperator.Add(obj);
obj = new Neusoft.FrameWork.Models.NeuObject();
obj.ID = "<";
obj.Name = "小于";
this.arrCompareOperator.Add(obj);
obj = new Neusoft.FrameWork.Models.NeuObject();
obj.ID = ">=";
obj.Name = "大于或等于";
this.arrCompareOperator.Add(obj);
obj = new Neusoft.FrameWork.Models.NeuObject();
obj.ID = "<=";
obj.Name = "小于或等于";
this.arrCompareOperator.Add(obj);
}
public void AddType()
{
Neusoft.FrameWork.Models.NeuObject obj = new Neusoft.FrameWork.Models.NeuObject();
TreeNode newNode = new TreeNode();
obj.ID = string.Empty;
obj.Name = "新分类";
if (this.SaveType(obj) <= 0)
{
return;
}
resourceTypes.Add(obj);
newNode.Text = obj.Name;
newNode.Tag = obj;
tvContainType.Nodes[0].Nodes.Add(newNode);
tvContainType.SelectedNode = newNode;
newNode.BeginEdit();
}
/// <summary>
/// 插入组套
/// </summary>
/// <param name="info"></param>
/// <returns></returns>
public int InsertContral(Neusoft.FrameWork.Models.NeuObject info)
{
string strSql = "";
if (this.Sql.GetSql("Case.SearchManager.InsertContral", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql, info.ID, info.Name, info.User01, info.User02);
}
catch (Exception ee)
{
this.Err = ee.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
void miNewType_Click(object sender, EventArgs e)
{
try
{
Neusoft.FrameWork.Models.NeuObject obj = (this.SelectedNode.Tag as Neusoft.FrameWork.Models.NeuObject).Clone();
TreeNode node = new TreeNode();
node.Tag = obj;
node.Text = "新建文件夹" + (this.SelectedNode.Nodes.Count + 1).ToString();
node.ImageIndex = 2;
node.SelectedImageIndex = 3;
this.SelectedNode.Nodes.Add(node);
this.SelectedNode = node;
this.LabelEdit = true;
node.BeginEdit();
}
catch
{ }
}
/// <summary>
///
/// </summary>
/// <param name="neuObject"></param>
/// <param name="e"></param>
/// <returns></returns>
protected override int OnSetValue(object neuObject, TreeNode e)
{
Neusoft.FrameWork.Models.NeuObject obj = neuObject as Neusoft.FrameWork.Models.NeuObject;
if (obj == null)
{
return(-1);
}
if (e.Parent.Tag.ToString() == "ConsultationPatient")
{
this.bIsApply = false;
}
else
{
this.bIsApply = true;
}
this.InpatientNo = obj.ID;
return(0);
}
private void tvPatientList1_AfterSelect(object sender, TreeViewEventArgs e)
{
TreeNode currentNode = this.tvPatientList1.SelectedNode;
if (currentNode == null || currentNode.Parent == null)
{
if (this.fpEnter1_Sheet1.RowCount > 0)
{
this.fpEnter1_Sheet1.Rows.Remove(0, this.fpEnter1_Sheet1.RowCount);
}
this.fpEnter1_Sheet1.Tag = null;
}
else
{
Neusoft.FrameWork.Models.NeuObject nurse = (Neusoft.FrameWork.Models.NeuObject)currentNode.Tag;
this.RefreshList(nurse);
}
}
private void fpSpread1_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e)
{
if (e.ColumnHeader || e.RowHeader)
{
return;
}
if (this.SelecctListEvent != null)
{
string listCode = this.neuSpread1_Sheet1.Cells[e.Row, (int)ColumnSet.ColList].Text;
Neusoft.FrameWork.Models.NeuObject company = new Neusoft.FrameWork.Models.NeuObject();
company.ID = this.neuSpread1_Sheet1.Cells[e.Row, (int)ColumnSet.ColTargetID].Text;
company.Name = this.neuSpread1_Sheet1.Cells[e.Row, (int)ColumnSet.ColTargetName].Text;
this.SelecctListEvent(listCode, this.State, company);
}
this.ParentForm.Close();
}
/// <summary>
/// 更新一条宏
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int UpdateMacro(Neusoft.FrameWork.Models.NeuObject obj)
{
string strSql = "";
if (this.Sql.GetSql("EPR.Macro.UpdateMacro", ref strSql) == -1)
{
return(-1);
}
try
{
strSql = string.Format(strSql, obj.ID, obj.Name, obj.Memo, obj.User01);
}
catch (Exception ex)
{
this.Err = "错误的参数！\n" + ex.Message;
return(-1);
}
return(this.ExecNoQuery(strSql));
}
/// <summary>
/// ID:门诊护士站代码,Name:挂号科室,user01:显示顺序,02:操作员,03:时间
/// </summary>
/// <param name="strSql"></param>
/// <returns></returns>
private ArrayList GetDeptInfo(string strSql)
{
ArrayList al = new ArrayList();
Neusoft.FrameWork.Models.NeuObject obj;
this.ExecQuery(strSql);
while (this.Reader.Read())
{
#region
// NURSE_CELL_CODE,-- 0 VARCHAR2(4) N 门诊护士站代码
// DEPT_CODE 1 VARCHAR2(4) N 挂号科室
// SORT_ID 2 NUMBER(4) Y 显示顺序
// OPER_CODE 3 VARCHAR2(6) Y 操作员
// OPER_DATE 4 DATE Y 操作时间
#endregion
obj = new Neusoft.FrameWork.Models.NeuObject();
try
{
obj.ID = this.Reader[0].ToString(); //门诊护士站代码, -- 发票号
obj.Name = this.Reader[1].ToString(); //挂号科室
obj.User01 = this.Reader[2].ToString(); //显示顺序
obj.User02 = this.Reader[3].ToString(); //操作员
obj.User03 = this.Reader[4].ToString(); //操作时间
}
catch (Exception ex)
{
this.Err = "查询明细赋值错误" + ex.Message;
this.ErrCode = ex.Message;
this.WriteErr();
return(null);
}
al.Add(obj);
}
this.Reader.Close();
return(al);
}
/// <summary>
/// 明细查询
/// </summary>
/// <param name="operInfo">操作员</param>
/// <param name="class3MeaningCode">类型编码</param>
private void QueryDetail(Neusoft.FrameWork.Models.NeuObject operInfo, string class3MeaningCode)
{
try
{
Neusoft.FrameWork.WinForms.Classes.Function.ShowWaitForm(Language.Msg("正在查询，请稍候..."));
Application.DoEvents();
DataSet ds = new DataSet();
if (this.itemManager.ExecQuery("Pharmarcy.Report.Inpatient.DetailQuery", ref ds, this.cmbDept.SelectedValue.ToString(), operInfo.ID, this.BeginTime.ToString(), this.EndTime.ToString(), class3MeaningCode) == -1)
{
Function.ShowMsg("数据查询失败，请与管理员联系！" + this.itemManager.Err);
return;
}
if (ds.Tables.Count > 0)
{
//当记录有效时 此时有效日期存储医嘱用药日期 屏蔽此时的日期显示
if (ds.Tables[0].Columns.Contains("取消日期") && ds.Tables[0].Columns.Contains("有效标记"))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["有效标记"].ToString() == "有效")
{
dr["取消日期"] = "";
}
}
}
}
this.neuSpread1_Sheet2.DataSource = ds;
this.neuSpread1_Sheet2.SheetName = operInfo.Name + " 明细摆药信息";
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm();
}
}
/// <summary>
/// 刷新列表
/// </summary>
/// <param name="person"></param>
private void refresh(Neusoft.FrameWork.Models.NeuObject usage)
{
if (this.neuSpread1_Sheet1.RowCount > 0)
{
this.neuSpread1_Sheet1.Rows.Remove(0, this.neuSpread1_Sheet1.RowCount);
}
try
{
//this.tabPage1.Title = usage.Name;
this.tabPage1.Text = usage.Name;
this.neuSpread1_Sheet1.Tag = usage;
//检索病区的维护信息
//if (this.myOutPatient == null) this.myOutPatient = new Neusoft.HISFC.BizLogic.Fee.Outpatient();
alItem.Clear();
alItem = this.feeManager.GetInjectInfoByUsage(usage.ID);// this.myOutPatient.GetInjectInfoByUsage(usage.ID);
if (alItem != null && alItem.Count > 0)
{
//Neusoft.HISFC.Models.Base.Employee em = user.GetPerson( (alItem[0] as Neusoft.FrameWork.Models.NeuObject).User02);
//Neusoft.HISFC.Models.Base.Employee em = feeManager.GetPerson((alItem[0] as Neusoft.FrameWork.Models.NeuObject).User02);
Neusoft.HISFC.Models.Base.Employee em = managerIntegrate.GetEmployeeInfo((alItem[0] as Neusoft.FrameWork.Models.NeuObject).User02);
foreach (Neusoft.FrameWork.Models.NeuObject obj in alItem)
{
this.neuSpread1_Sheet1.Rows.Add(this.neuSpread1_Sheet1.RowCount, 1);
int row = this.neuSpread1_Sheet1.RowCount - 1;
this.neuSpread1_Sheet1.Rows[row].Tag = obj;
//项目编码
this.neuSpread1_Sheet1.Cells[row, 0].Text = obj.Name; //(row,0,obj.User01);
this.neuSpread1_Sheet1.Cells[row, 0].Tag = obj.ID; //(row,0,obj.Memo);
//操作员
this.neuSpread1_Sheet1.SetValue(row, 1, em.Name, false);
//操作时间
//this.neuSpread1_Sheet1.SetValue(row, 2, this.myOutPatient.GetSysDateTime(), false);
this.neuSpread1_Sheet1.SetValue(row, 2, obj.User03);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString() + this.feeManager.Err);
}
}
