/// <summary> /// 填充字段数组 /// </summary> /// <param name="record">集体类</param> public void FillFields(NeuObject record) { // 集体类 Neusoft.HISFC.Models.PhysicalExamination.Collective.Collective collective = (Neusoft.HISFC.Models.PhysicalExamination.Collective.Collective)record; // 清空字段数组 this.ClearFields(); // 向字段数组赋值 this.fields[(int)EnumCollective.Hospital] = this.GetSequence("Neusoft.HISFC.BizLogic.PhysicalExamination.Table.GetHospital"); this.fields[(int)EnumCollective.CollectiveID] = collective.ID; this.fields[(int)EnumCollective.CollectiveCode] = collective.Code; this.fields[(int)EnumCollective.CollectiveName] = collective.Name; this.fields[(int)EnumCollective.CollectiveType] = collective.CollectiveType.ID; this.fields[(int)EnumCollective.Memo] = collective.Memo; this.fields[(int)EnumCollective.CreateOper] = collective.CreateEnvironment.ID; this.fields[(int)EnumCollective.CreateTime] = collective.CreateEnvironment.OperTime.ToString(); this.fields[(int)EnumCollective.InvalidOper] = collective.InvalidEnvironment.ID; this.fields[(int)EnumCollective.InvalidTime] = collective.InvalidEnvironment.OperTime.ToString(); if (collective.Validity.Equals(Neusoft.HISFC.Models.PhysicalExamination.Enum.EnumValidity.Valid)) { this.fields[(int)EnumCollective.IsValid] = "1"; } else { this.fields[(int)EnumCollective.IsValid] = "0"; } this.fields[(int)EnumCollective.Extend1] = collective.User01; this.fields[(int)EnumCollective.Extend2] = collective.User02; this.fields[(int)EnumCollective.Extend3] = collective.User03; }
/// <summary> /// 填充字段数组 /// </summary> /// <param name="record">体检执行类</param> public void FillFields(NeuObject record) { // 体检执行类 Neusoft.HISFC.Models.PhysicalExamination.Confirm.Confirm confirm = (Neusoft.HISFC.Models.PhysicalExamination.Confirm.Confirm)record; // 清空字段数组 this.ClearFields(); // 向字段数组赋值 this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumConfirm.ConfirmID] = confirm.ID; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumConfirm.RegItemID] = confirm.RegItem.ID; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumConfirm.ExecDept] = confirm.ExecDept.ID; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumConfirm.ConfirmDept] = confirm.ConfirmDept.ID; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumConfirm.ConfirmOper] = confirm.ConfirmOper.ID; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumConfirm.ConfirmTime] = confirm.ConfirmTime.ToString(); this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumConfirm.ItemResult] = confirm.ItemResult; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumConfirm.CreateOper] = confirm.CreateEnvironment.ID; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumConfirm.CreateTime] = confirm.CreateEnvironment.OperTime.ToString(); this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumConfirm.InvalidOper] = confirm.InvalidEnvironment.ID; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumConfirm.InvalidTime] = confirm.InvalidEnvironment.OperTime.ToString(); if (confirm.Validity.Equals(Neusoft.HISFC.Models.PhysicalExamination.Enum.EnumValidity.Valid)) { this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumConfirm.IsValid] = "1"; } else { this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumConfirm.IsValid] = "0"; } this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumConfirm.Extend1] = confirm.User01; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumConfirm.Extend2] = confirm.User02; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumConfirm.Extend3] = confirm.User03; }
/// <summary> /// 更新表 /// </summary> /// <param name="record">体检执行类</param> /// <returns>1-成功、0-失败</returns> public int Update(NeuObject record) { // 转换成体检执行类 Neusoft.HISFC.Models.PhysicalExamination.Confirm.Confirm confirm = (Neusoft.HISFC.Models.PhysicalExamination.Confirm.Confirm)record; this.SQL = ""; // 转换成字段数组 this.FillFields(confirm); // 获取SQL语句 if (this.Sql.GetSql("", ref this.SQL) == -1) { return(-1); } // 执行SQL语句 if (this.ExecNoQuery(this.SQL, this.fields) == -1) { return(-1); } // 成功返回 return(1); }
/// <summary> /// 填充字段数组 /// </summary> /// <param name="record">体检业务类</param> public void FillFields(NeuObject record) { // 体检业务类 Neusoft.HISFC.Models.PhysicalExamination.Management.Query query; query = (Neusoft.HISFC.Models.PhysicalExamination.Management.Query)record; // 清空数组 this.ClearFields(); // 填充数组 this.fields[(int)EnumQuery.Hospital] = this.GetSequence("Neusoft.HISFC.BizLogic.PhysicalExamination.Table.GetHospital"); this.fields[(int)EnumQuery.TableName] = query.Table; this.fields[(int)EnumQuery.Business] = query.Business.ID; this.fields[(int)EnumQuery.PrimaryKey] = query.ID; this.fields[(int)EnumQuery.SpellCode] = query.SpellCode; this.fields[(int)EnumQuery.WBCode] = query.WBCode; this.fields[(int)EnumQuery.UserCode] = query.UserCode; this.fields[(int)EnumQuery.CreateOper] = query.CreateEnvironment.ID; this.fields[(int)EnumQuery.CreateTime] = query.CreateEnvironment.OperTime.ToString(); this.fields[(int)EnumQuery.InvalidOper] = query.InvalidEnvironment.ID; this.fields[(int)EnumQuery.InvalidTime] = query.InvalidEnvironment.OperTime.ToString(); if (query.Validity.Equals(Neusoft.HISFC.Models.PhysicalExamination.Enum.EnumValidity.Valid)) { this.fields[(int)EnumQuery.IsValid] = "1"; } else { this.fields[(int)EnumQuery.IsValid] = "0"; } this.fields[(int)EnumQuery.Extend1] = query.User01; this.fields[(int)EnumQuery.Extend2] = query.User02; this.fields[(int)EnumQuery.Extend3] = query.User03; }
/// <summary> /// 插入表 /// </summary> /// <param name="record">集体类</param> /// <returns>1-成功、-1-失败</returns> public int Insert(NeuObject record) { // 转换成集体类 Neusoft.HISFC.Models.PhysicalExamination.Collective.Collective collective = (Neusoft.HISFC.Models.PhysicalExamination.Collective.Collective)record; this.SQL = ""; // 转换成字段数组 this.FillFields(collective); // 获取SQL语句 if (this.Sql.GetSql("Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Collective.Insert", ref this.SQL) == -1) { return(-1); } // 执行SQL语句 if (this.ExecNoQuery(this.SQL, this.fields) == -1) { return(-1); } // 成功返回 return(1); }
/// <summary> /// 更新表 /// <param name="record">检索码类</param> /// <returns>1-成功、-1-失败</returns> /// </summary> public int Update(NeuObject record) { // 转换成检索码类 Neusoft.HISFC.Models.PhysicalExamination.Management.Query query; query = (Neusoft.HISFC.Models.PhysicalExamination.Management.Query)record; this.SQL = ""; // 转换成字段数组 this.FillFields(query); // 获取SQL语句 if (this.Sql.GetSql("Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Query.Update", ref this.SQL) == -1) { return(-1); } // 执行SQL语句 if (this.ExecNoQuery(this.SQL, this.fields) <= 0) { return(-1); } // 成功返回 return(1); }
/// <summary> /// 更新表 /// </summary> /// <param name="record">健康档案类</param> /// <returns>1-成功、0-失败</returns> public int Update(NeuObject record) { // 转换成健康档案类 Neusoft.HISFC.Models.PhysicalExamination.HealthArchieve.HealthArchieve archieve = (Neusoft.HISFC.Models.PhysicalExamination.HealthArchieve.HealthArchieve)record; this.SQL = ""; // 转换成字段数组 this.FillFields(archieve); // 获取SQL语句 if (this.Sql.GetSql("Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Archieve.Update", ref this.SQL) == -1) { return(-1); } // 执行SQL语句 if (this.ExecNoQuery(this.SQL, this.fields) == -1) { return(-1); } // 成功返回 return(1); }
/// <summary> /// 更新表 /// <param name="record">体检业务类</param> /// <returns>1-成功、-1-失败</returns> /// </summary> public int Update(NeuObject record) { // 转换成健康档案类 Neusoft.HISFC.Models.PhysicalExamination.Management.Business business = (Neusoft.HISFC.Models.PhysicalExamination.Management.Business)record; this.SQL = ""; // 转换成字段数组 this.FillFields(business); // 获取SQL语句 if (this.Sql.GetSql("Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Business.Update", ref this.SQL) == -1) { return(-1); } // 执行SQL语句 if (this.ExecNoQuery(this.SQL, this.fields) == -1) { return(-1); } // 成功返回 return(1); }
/// <summary> /// 填充字段数组 /// </summary> /// <param name="record">体检科室类</param> public void FillFields(NeuObject record) { // 体检科室类 Neusoft.HISFC.Models.PhysicalExamination.Management.Department dept = (Neusoft.HISFC.Models.PhysicalExamination.Management.Department)record; // 清空字段数组 this.ClearFields(); // 填充字段数组 this.fields[(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDept.Hospital] = this.GetSequence("Neusoft.HISFC.BizLogic.PhysicalExamination.Table.GetHospital"); this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDept.Dept] = dept.ID; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDept.Memo] = dept.Memo; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDept.CreateOper] = dept.CreateEnvironment.ID; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDept.CreateTime] = dept.CreateEnvironment.OperTime.ToString(); this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDept.InvalidOper] = dept.InvalidEnvironment.ID; this.fields[(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDept.InvalidTime] = dept.InvalidEnvironment.OperTime.ToString(); if (dept.Validity.Equals(Neusoft.HISFC.Models.PhysicalExamination.Enum.EnumValidity.Valid)) { this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDept.IsValid] = "1"; } else { this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDept.IsValid] = "0"; } this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDept.Extend1] = dept.User01; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDept.Extend2] = dept.User02; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDept.Extend3] = dept.User03; }
/// <summary> /// 根据人员编码,部门编码,二级权限取人员所拥有的权限。 /// </summary> /// <param name="userCode">权限人员编码</param> /// <param name="class2Code">二级权限码</param> /// <param name="deptCode">科室编码</param> /// <returns>成功返回权限集合 失败返回null</returns> public List <Neusoft.FrameWork.Models.NeuObject> QueryUserPrivCollection(string userCode, string class2Code, string deptCode) { string sqlstring = PrepareSQL("Manager.UserPowerDetailManager.LoadUserPriv", userCode, class2Code, deptCode); if (sqlstring == null) { return(null); } List <Neusoft.FrameWork.Models.NeuObject> al = new List <NeuObject>(); try { Neusoft.FrameWork.Models.NeuObject info; this.ExecQuery(sqlstring); while (this.Reader.Read()) { info = new NeuObject(); info.ID = this.Reader[0].ToString(); //三级权限编码 info.Name = this.Reader[1].ToString(); //三级权限名称 info.User01 = this.Reader[2].ToString(); //是否可以授权 al.Add(info); } this.Reader.Close(); } catch (Exception ex) { this.ErrCode = ex.Message; this.Err = ex.Message; return(null); } return(al); }
/// <summary> /// 更新表 /// <param name="record">联系方式类</param> /// <returns>1-成功、-1-失败</returns> /// </summary> public int Update(NeuObject record) { // 转换成联系方式类 Neusoft.HISFC.Models.PhysicalExamination.Collective.Relation relation = new Relation(); relation = (Neusoft.HISFC.Models.PhysicalExamination.Collective.Relation)record; this.SQL = ""; // 转换成字段数组 this.FillFields(relation); // 获取SQL语句 if (this.Sql.GetSql("Neusoft.HISFC.BizLogic.PhysicalExamination.Table.LinkType.Update", ref this.SQL) == -1) { return(-1); } // 执行SQL语句 if (this.ExecNoQuery(this.SQL, this.fields) == -1) { return(-1); } // 成功返回 return(1); }
/// <summary> /// 填充字段数组 /// </summary> /// <param name="record">体检科室与项目的关系类</param> public void FillFields(NeuObject record) { // 体检科室与项目的关系 Neusoft.HISFC.Models.PhysicalExamination.Management.Relation.DeptItemRelation relation = (Neusoft.HISFC.Models.PhysicalExamination.Management.Relation.DeptItemRelation)record; // 清空字段数组 this.ClearFields(); // 填充字段数组 this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.Business] = relation.Business.ID; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.Department] = relation.ID; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.Item] = relation.Item.ID; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.Memo] = relation.Memo; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.CreateOper] = relation.CreateEnvironment.ID; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.CreateTime] = relation.CreateEnvironment.OperTime.ToString(); this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.InvalidOper] = relation.InvalidEnvironment.ID; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.InvalidTime] = relation.InvalidEnvironment.OperTime.ToString(); if (relation.Validity.Equals(Neusoft.HISFC.Models.PhysicalExamination.Enum.EnumValidity.Valid)) { this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.IsValid] = "1"; } else { this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.IsValid] = "0"; } this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.Extend1] = relation.User01; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.Extend2] = relation.User02; this.fields [(int)Neusoft.HISFC.BizLogic.PhysicalExamination.Table.Enum.EnumDeptItem.Extend3] = relation.User03; }
/// <summary> /// 插入表 /// </summary> /// <param name="record">体检科室与项目的关系类</param> /// <returns>1-成功、-1-失败</returns> public int Insert(NeuObject record) { // 转换成体检科室与项目的关系类 Neusoft.HISFC.Models.PhysicalExamination.Management.Relation.DeptItemRelation relation = (Neusoft.HISFC.Models.PhysicalExamination.Management.Relation.DeptItemRelation)record; this.SQL = ""; // 转换成字段数组 this.FillFields(relation); // 获取SQL语句 if (this.Sql.GetSql("", ref this.SQL) == -1) { return(-1); } // 执行SQL语句 if (this.ExecNoQuery(this.SQL, this.fields) == -1) { return(-1); } // 成功返回 return(1); }
/// <summary> /// 从com_dirctionary表里取得项目信息 /// </summary> /// <param name="itemType"></param> /// <returns></returns> public ArrayList GetItemInfo(string itemType) { string strSql = ""; ArrayList alItem = new ArrayList(); if (this.Sql.GetSql("Management.ExecBill.GetItemInfo", ref strSql) == -1) { this.Err = this.Sql.Err; return(null); } strSql = System.String.Format(strSql, itemType); if (this.ExecQuery(strSql) == -1) { return(null); } while (this.Reader.Read()) { Neusoft.FrameWork.Models.NeuObject obj = new NeuObject(); obj.ID = this.Reader[0].ToString(); //编码 obj.Name = this.Reader[1].ToString(); //名称 obj.User01 = this.Reader[2].ToString(); //备注 obj.User02 = this.Reader[3].ToString(); //有效标志 alItem.Add(obj); } this.Reader.Close(); return(alItem); }
/// <summary> /// 填充字段数组 /// </summary> /// <param name="record">类别类</param> public void FillFields(NeuObject record) { // 类别类 Neusoft.HISFC.Models.PhysicalExamination.Management.ClassType classType = (Neusoft.HISFC.Models.PhysicalExamination.Management.ClassType)record; // 清空数组 this.ClearFields(); // 填充数组 this.fields[(int)Table.Enum.EnumClassType.Sequence] = classType.ID; this.fields[(int)Table.Enum.EnumClassType.Hospital] = this.GetSequence("Neusoft.HISFC.BizLogic.PhysicalExamination.Table.GetHospital"); ; this.fields[(int)Table.Enum.EnumClassType.BelongType] = classType.BelongType; this.fields[(int)Table.Enum.EnumClassType.TypeName] = classType.Name; this.fields[(int)Table.Enum.EnumClassType.Memo] = classType.Memo; this.fields[(int)Table.Enum.EnumClassType.CreateOper] = classType.CreateEnvironment.ID; this.fields[(int)Table.Enum.EnumClassType.CreateTime] = classType.CreateEnvironment.OperTime.ToString(); this.fields[(int)Table.Enum.EnumClassType.InvalidOper] = classType.InvalidEnvironment.ID; this.fields[(int)Table.Enum.EnumClassType.InvalidTime] = classType.InvalidEnvironment.OperTime.ToString(); if (classType.Validity.Equals(Neusoft.HISFC.Models.PhysicalExamination.Enum.EnumValidity.Valid)) { this.fields[(int)Table.Enum.EnumClassType.IsValid] = "1"; } else { this.fields[(int)Table.Enum.EnumClassType.IsValid] = "0"; } this.fields[(int)Table.Enum.EnumClassType.Extend1] = classType.User01; this.fields[(int)Table.Enum.EnumClassType.Extend2] = classType.User02; this.fields[(int)Table.Enum.EnumClassType.Extend3] = classType.User03; }
/// <summary> /// 初始化ComBox /// </summary> private void InitCmb() { ArrayList al = new ArrayList(); NeuObject tempObj = null; tempObj = new NeuObject(); tempObj.ID = ((int)Neusoft.HISFC.Models.Account.OperTypes.StopAccount).ToString(); tempObj.Name = "停帐户"; al.Add(tempObj); tempObj = new NeuObject(); tempObj.ID = ((int)Neusoft.HISFC.Models.Account.OperTypes.AginAccount).ToString(); tempObj.Name = "重启帐户"; al.Add(tempObj); tempObj = new NeuObject(); tempObj.ID = ((int)Neusoft.HISFC.Models.Account.OperTypes.CancelAccount).ToString(); tempObj.Name = "注销帐户"; al.Add(tempObj); tempObj = new NeuObject(); tempObj.ID = ((int)Neusoft.HISFC.Models.Account.OperTypes.EditPassWord).ToString(); tempObj.Name = "修改密码"; al.Add(tempObj); tempObj = new NeuObject(); tempObj.ID = ((int)Neusoft.HISFC.Models.Account.OperTypes.BalanceVacancy).ToString(); tempObj.Name = "结清余额"; al.Add(tempObj); this.cmbOper.AddItems(al); }
/// <summary> /// 填充字段数组 /// </summary> /// <param name="record">健康档案类</param> public void FillFields(NeuObject record) { // 健康档案类 Neusoft.HISFC.Models.PhysicalExamination.HealthArchieve.HealthArchieve archieve = (Neusoft.HISFC.Models.PhysicalExamination.HealthArchieve.HealthArchieve)record; // 清空字段数组 this.ClearFields(); // 向字段数组赋值 this.fields[(int)EnumArchieve.Hospital] = this.GetSequence("Neusoft.HISFC.BizLogic.PhysicalExamination.Table.GetHospital"); this.fields [(int)EnumArchieve.ArchieveID] = archieve.ID; this.fields[(int)EnumArchieve.ArchieveCode] = archieve.Code; this.fields [(int)EnumArchieve.ArchieveType] = archieve.ArchieveType.ID; this.fields[(int)EnumArchieve.CardNO] = archieve.Guest.PID.CardNO; this.fields[(int)EnumArchieve.Collective] = archieve.Collective.ID; this.fields[(int)EnumArchieve.Name] = archieve.Name; this.fields[(int)EnumArchieve.Sex] = archieve.Sex.ToString(); this.fields[(int)EnumArchieve.Birthday] = archieve.Guest.Birthday.ToString(); this.fields[(int)EnumArchieve.IDCard] = archieve.Guest.IDCard; this.fields[(int)EnumArchieve.Height] = archieve.Guest.Height; this.fields[(int)EnumArchieve.Weight] = archieve.Guest.Weight; this.fields[(int)EnumArchieve.BloodType] = archieve.Guest.BloodType.ID.ToString(); this.fields[(int)EnumArchieve.TotalCost] = archieve.TotalCost.ToString(); this.fields[(int)EnumArchieve.TotalCount] = archieve.TotalCount.ToString(); this.fields[(int)EnumArchieve.CRMType] = archieve.CRMType.ID; this.fields[(int)EnumArchieve.Memo] = archieve.Memo; this.fields [(int)EnumArchieve.CreateOper] = archieve.CreateEnvironment.ID; this.fields [(int)EnumArchieve.CreateTime] = archieve.CreateEnvironment.OperTime.ToString(); this.fields[(int)EnumArchieve.InvalidOper] = archieve.InvalidEnvironment.ID; this.fields[(int)EnumArchieve.InvalidTime] = archieve.InvalidEnvironment.OperTime.ToString(); this.fields[(int)EnumArchieve.IsValid] = ((int)archieve.Validity).ToString(); this.fields [(int)EnumArchieve.Extend1] = archieve.User01; this.fields [(int)EnumArchieve.Extend2] = archieve.User02; this.fields [(int)EnumArchieve.Extend3] = archieve.User03; }
private void ucCollectDayBalance_Load(object sender, EventArgs e) { currentOperator = this.clinicDayBalance.Operator; //表示在汇总数据 this.ucClinicDayBalanceReportNew1.IsCollectData = true; this.ucClinicDayBalanceReportNew1.InitUC("门诊收费员日结汇总报表"); }
/// <summary> /// 返回科室核算 里全院底下第一级节点的所有部门的编码和名称 用于报表打印, 提供 何善衡楼和住院处 /// </summary> /// <returns></returns> /// [email protected] public ArrayList GetSubTreeNodeForFinance() { ArrayList al = new ArrayList(); try { string strSql = ""; //取SQL语句 if (this.Sql.GetSql("Manager.DepartmentStatManager.GetSubTreeNode", ref strSql) == -1) { return(null); } if (this.ExecQuery(strSql) < 0) { return(null); } Neusoft.FrameWork.Models.NeuObject obj = null; while (this.Reader.Read()) { obj = new NeuObject(); obj.ID = Reader[0].ToString(); // 科室编码 obj.Name = Reader[1].ToString(); // 科室名称 obj.User01 = Reader[2].ToString(); // 父科室编码 obj.User02 = Reader[3].ToString(); //父科室名称 al.Add(obj); obj = null; } } catch (Exception ee) { this.Err = ee.Message; al = null; } return(al); }
/// <summary> /// 释放资源 /// </summary> /// <param name="isDisposing"></param> protected override void Dispose(bool isDisposing) { if (this.alreadyDisposed) { return; } if (isDisposing) { if (this.applyOperator != null) { this.applyOperator.Dispose(); this.applyOperator = null; } if (this.employee != null) { this.employee.Dispose(); this.employee = null; } if (this.shiftType != null) { this.shiftType.Dispose(); this.shiftType = null; } } base.Dispose(isDisposing); this.alreadyDisposed = true; }
/// <summary> /// 保存 /// </summary> /// <returns></returns> protected virtual int Save() { if (patient == null) { MessageBox.Show("请选择患者!", "提示"); return(-1); } #region 获得患者所在位置 Neusoft.HISFC.Models.RADT.Location newlocation = new Neusoft.HISFC.Models.RADT.Location(); newdeptObj = this.lblDept.Tag as NeuObject; newlocation.Dept.ID = newdeptObj.ID; newlocation.Dept.Name = newdeptObj.Name; bed = this.lblBed.Tag as Neusoft.HISFC.Models.Base.Bed; newlocation.Bed = bed; newlocation.NurseCell = bed.NurseStation; #endregion //Neusoft.FrameWork.Management.Transaction tran = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance); Neusoft.FrameWork.Management.PublicTrans.BeginTransaction(); radtInteger.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans); mamagerInteger.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans); int resultValue = radtInteger.ChangeDept(patient, newlocation); if (resultValue < 0) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); MessageBox.Show(this.radtInteger.Err); return(-1); } Neusoft.FrameWork.Management.PublicTrans.Commit(); if (isFresh) { deptObj = this.txtdept.Tag as NeuObject; RefreshListPatient(deptObj); } GetBedByDeptCode(newdeptObj); #region addby xuewj 2010-3-15 Neusoft.HISFC.Models.RADT.PatientInfo p = patient.Clone(); p.PVisit.PatientLocation = newlocation; if (this.adt == null) { this.adt = Neusoft.FrameWork.WinForms.Classes.UtilInterface.CreateObject(this.GetType(), typeof(Neusoft.HISFC.BizProcess.Interface.IHE.IADT)) as Neusoft.HISFC.BizProcess.Interface.IHE.IADT; } if (this.adt != null) { adt.TransferPatient(p); } #endregion MessageBox.Show("转科、床成功!", "提示"); this.cmbDept.Tag = newdeptObj.ID; return(1); }
/// <summary> /// 执行单设置(批量导入用) /// 必须填写(objBill.Name 执行单名,objBill.Memo执行单类型,1药/2非药,objBill.user01 医嘱类型 /// objBill.user02非药系统类别、药品类别 objBill.user03 药品用法) /// </summary> /// <param name="al"></param> /// <param name="nurseCode"></param> /// <returns></returns> public int SetExecBillNew(ArrayList al, Neusoft.FrameWork.Models.NeuObject objExecBill, string nurseCode, ref string billID) { Neusoft.FrameWork.Models.NeuObject obj = new NeuObject(); Neusoft.FrameWork.Models.NeuObject objExecInfo = objExecBill.Clone(); if (al.Count == 0) { this.Err = Neusoft.FrameWork.Management.Language.Msg("没有维护详细项目!"); return(-1); } if (this.SetExecBill(objExecInfo, nurseCode) == -1) { this.Err = Neusoft.FrameWork.Management.Language.Msg("执行单设置失败!") + this.Err; return(-1); } if (objExecInfo.Memo == "1") { for (int i = 0; i < al.Count; i++) { Neusoft.HISFC.Models.Order.Inpatient.Order orderInfo = (Neusoft.HISFC.Models.Order.Inpatient.Order)al[i]; orderInfo.ID = objExecInfo.ID; if (orderInfo.ID == "-1" || orderInfo.ID == "") { return(-1); } if (this.InsertExecBillItem(nurseCode, objExecInfo.ID, orderInfo.OrderType.ID, orderInfo.Item.SysClass.ID.ToString(), orderInfo.Item.ID, orderInfo.Item.Name) < 0) { this.Err = Neusoft.FrameWork.Management.Language.Msg("执行单设置失败!") + this.Err; return(-1); } } } else { for (int i = 0; i < al.Count; i++) { Neusoft.HISFC.Models.Order.Inpatient.Order orderInfo = (Neusoft.HISFC.Models.Order.Inpatient.Order)al[i]; obj.ID = objExecInfo.ID; obj.User02 = orderInfo.Item.User01; obj.User01 = orderInfo.OrderType.ID; obj.User03 = orderInfo.Usage.ID; obj.Memo = "1"; if (obj.ID == "-1" || obj.ID == "") { return(-1); } if (InsertExecBill(obj, nurseCode) < 0) { this.Err = Neusoft.FrameWork.Management.Language.Msg("执行单设置失败!") + this.Err; return(-1); } } } billID = objExecInfo.ID; return(0); }
public ucApplication(PatientInfo patient, NeuObject item) : this() { this.ucQueryInpatientNo1.Text = patient.PID.PatientNO; this.ucApplicationForm1.PatientInfo = patient; this.ucApplicationForm1.MainOperation = item.Clone(); this.isSaveClose = true; }
/// <summary> /// 执行单设置 /// 必须填写(objBill.Name 执行单名,objBill.Memo执行单类型,1药/2非药,objBill.user01 医嘱类型 /// objBill.user02非药系统类别、药品类别 objBill.user03 药品用法) /// </summary> /// <param name="al"></param> /// <param name="nurseCode"></param> /// <returns></returns> public int SetExecBill(ArrayList al, Neusoft.FrameWork.Models.NeuObject objExecBill, string nurseCode, ref string billID) { string strSql = ""; string strBillNo = ""; Neusoft.FrameWork.Models.NeuObject obj = new NeuObject(); if (al.Count == 0) { this.Err = Neusoft.FrameWork.Management.Language.Msg("没有维护详细项目!"); return(-1); } strBillNo = GetNewExecBillID(); if (strBillNo == "-1" || strBillNo == "") { return(-1); } if (this.Sql.GetSql("Order.ExecBill.InsertItem", ref strSql) == -1) { this.Err = this.Sql.Err; return(-1); } try { strSql = string.Format(strSql, nurseCode, strBillNo, objExecBill.Name, this.Operator.ID, objExecBill.User02, objExecBill.User01); } catch (Exception ex) { this.Err = ex.Message; this.ErrCode = ex.Message; this.WriteErr(); return(-1); } if (this.ExecNoQuery(strSql) < 0) { return(-1); } for (int i = 0; i < al.Count; i++) { obj = (Neusoft.FrameWork.Models.NeuObject)al[i]; obj.ID = strBillNo; if (obj.ID == "-1" || obj.ID == "") { return(-1); } if (InsertExecBill(obj, nurseCode) < 0) { this.Err = Neusoft.FrameWork.Management.Language.Msg("执行单设置失败!") + this.Err; return(-1); } } billID = strBillNo; return(0); }
private void ucAlert_Load(object sender, EventArgs e) { try { NurseCode = (Patient.Operator as Neusoft.HISFC.Models.Base.Employee).Nurse; initControl(); RefreshList(NurseCode.ID); } catch { } }
/// <summary> /// 门诊发药保存 /// </summary> /// <param name="applyOutCollection">摆药申请信息</param> /// <param name="terminal">发药终端</param> /// <param name="sendDept">发药科室信息(扣库科室)</param> /// <param name="sendOper">发药人员信息</param> /// <param name="isDirectSave">是否直接保存 (无配药流程)</param> /// <param name="isUpdateAdjustParam">是否更新处方调剂参数</param> /// <returns>发药确认成功返回1 失败返回-1</returns> internal static int OutpatientSend(List <ApplyOut> applyOutCollection, NeuObject terminal, NeuObject sendDept, NeuObject sendOper, bool isDirectSave, bool isUpdateAdjustParam) { Neusoft.HISFC.BizProcess.Integrate.Pharmacy pharmacyIntegrate = new Neusoft.HISFC.BizProcess.Integrate.Pharmacy( ); if (pharmacyIntegrate.OutpatientSend(applyOutCollection, terminal, sendDept, sendOper, isDirectSave, isUpdateAdjustParam) != 1) { System.Windows.Forms.MessageBox.Show(pharmacyIntegrate.Err); return(-1); } return(1); }
/// <summary> /// 门诊还药操作 对已配药确认的数据 更新为未打印状态 /// </summary> /// <param name="applyOutCollection">摆药申请信息</param> /// <param name="backOper">还药人员信息</param> /// <returns>成功返回1 失败返回-1</returns> internal static int OutpatientBack(List <ApplyOut> applyOutCollection, NeuObject backOper) { Neusoft.HISFC.BizProcess.Integrate.Pharmacy pharmacyIntegrate = new Neusoft.HISFC.BizProcess.Integrate.Pharmacy( ); if (pharmacyIntegrate.OutpatientBack(applyOutCollection, backOper) != 1) { System.Windows.Forms.MessageBox.Show(pharmacyIntegrate.Err); return(-1); } return(1); }
/// <summary> /// 获取cmb的科室 /// </summary> /// <returns>选择的科室</returns> public Neusoft.FrameWork.Models.NeuObject GetDept() { Neusoft.FrameWork.Models.NeuObject tempDept = new NeuObject(); if (this.neuComboBoxDept.Tag != null && this.neuComboBoxDept.Tag.ToString() != "" && this.neuComboBoxDept.Text != "") { tempDept.ID = this.neuComboBoxDept.Tag.ToString(); tempDept.Name = this.neuComboBoxDept.Text.ToString(); } return(tempDept); }
/// <summary> /// 根据员工编码获取员工非默认密码的系统登陆信息 /// </summary> /// <param name="emplCode">用户编码</param> /// <returns>成功返回neuobject数组 失败返回null 未找到数据返回新建neuobject</returns> public ArrayList GetLoginInfoByEmplCode(string emplCode) { string strSql = ""; if (this.Sql.GetSql("Manager.UserManager.GetLoginInfo.EmplCode", ref strSql) == -1) { this.Err = "查找sql语句时出错 可能sql语句在xml内不存在"; return(null); } try { strSql = string.Format(strSql, emplCode); } catch (Exception ex) { this.Err = "格式化查询sql字符串时出错" + ex.Message; return(null); } ArrayList al = new ArrayList(); Neusoft.FrameWork.Models.NeuObject info; try { this.ExecQuery(strSql); while (this.Reader.Read()) { info = new NeuObject(); info.ID = this.Reader[0].ToString(); //用户编码 info.Name = this.Reader[1].ToString(); //用户姓名 info.Memo = this.Reader[2].ToString(); //管理员标记 info.User01 = this.Reader[3].ToString(); //登陆名 info.User02 = this.Reader[4].ToString(); //登陆密码 al.Add(info); } this.Reader.Close(); } catch (Exception ex) { this.Err = "执行sql语句出错" + ex.Message; return(null); } if (al.Count == 0) { info = new NeuObject(); al.Add(info); } return(al); }
/// <summary> /// 获取科室信息 /// [参数: ArrayList alDepartment - 返回的科室数组] /// [返回: int,1-成功,-1-失败] /// </summary> /// <param name="alDepartment">返回的科室数组</param> /// <returns>1-成功,-1-失败</returns> public int QueryDapartment(ArrayList alDepartment) { // // 初始化变量 // this.InitVar(); // // 获取SQL语句 // this.intReturn = this.Sql.GetSql("neusoft.HISFC.Management.MedTech.GetDapartment.Select", ref this.SELECT); if (this.intReturn == -1) { this.Err = "获取科室信息获取SQL语句失败!" + "\n" + this.Err + "\nneusoft.HISFC.Management.MedTech.GetDapartment.Select"; return(-1); } this.intReturn = this.Sql.GetSql("neusoft.HISFC.Management.MedTech.GetDapartment.Where", ref this.WHERE); if (this.intReturn == -1) { this.Err = "获取科室信息获取SQL语句失败!" + "\n" + this.Err + "\nneusoft.HISFC.Management.MedTech.GetDapartment.Where"; return(-1); } this.CreateSQL(); // // 执行SQL语句 // this.intReturn = this.ExecQuery(this.SQL); if (this.intReturn == -1) { this.Err = "获取科室信息执行SQL语句失败!" + "\n" + this.Err; return(-1); } // // 返回结果 // while (this.Reader.Read()) { // 科室对象 Neusoft.FrameWork.Models.NeuObject department = new NeuObject(); // 科室编码 department.ID = this.Reader[0].ToString(); // 科室名称 department.Name = this.Reader[1].ToString(); // 添加到科室数组 alDepartment.Add(department); } // // 成功返回 // return(1); }