/// <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);
}
