protected override void OnLoad()
{
this.isAcross = true;
this.isSort = false;
this.Init();
base.OnLoad();
Neusoft.HISFC.BizProcess.Integrate.Manager manager = new Neusoft.HISFC.BizProcess.Integrate.Manager();
Neusoft.HISFC.Models.Base.Const cons = new Neusoft.HISFC.Models.Base.Const();
cons.ID = "ALL";
cons.Name = "È«²¿";
this.neuComboBox1.Items.Add(cons);
System.Collections.ArrayList arraylist = manager.GetConstantList("ITEMMINFEECODE");
foreach (Neusoft.HISFC.Models.Base.Const con in arraylist)
{
neuComboBox1.Items.Add(con);
}
if (neuComboBox1.Items.Count >= 0)
{
neuComboBox1.SelectedIndex = 0;
reportCode = ((Neusoft.HISFC.Models.Base.Const)neuComboBox1.Items[0]).ID;
reportName = ((Neusoft.HISFC.Models.Base.Const)neuComboBox1.Items[0]).Name;
}
}
/// <summary>
/// 科室初始化分解时间常数
/// </summary>
/// <returns></returns>
private int InitDic()
{
if ((manager.GetConstant("SETEXECTIME", deptCode)).ID == "")
{
Neusoft.HISFC.Models.Base.Const cons = new Neusoft.HISFC.Models.Base.Const();
if (deptCode != "")
{
cons.ID = deptCode;
cons.Name = deptName;
cons.Memo = "12";
try
{
return(manager.InsertConstant("SETEXECTIME", cons));
}
catch (Exception e)
{
MessageBox.Show("插入新常数失败！" + e.Message.ToString());
return(-1);
}
}
else
{
MessageBox.Show("请选择一个科室！");
return(-1);
}
}
else
{
MessageBox.Show("本科室的分解时间已经完成了初始化！无需再次初始化！");
return(-1);
}
}
public void FillTreeview()
{
Neusoft.HISFC.BizProcess.Integrate.Manager constant = new Neusoft.HISFC.BizProcess.Integrate.Manager();
System.Collections.ArrayList alConstant = constant.GetConstantList("CASE13");
TreeNode root = new TreeNode("所有分区");
this.neuTreeView1.Nodes.Add(root);
if (alConstant.Count == 0 || alConstant == null)
{
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("获取分区失败"));
return;
}
for (int i = 0; i < alConstant.Count; i++)
{
Neusoft.HISFC.Models.Base.Const cons = alConstant[i] as Neusoft.HISFC.Models.Base.Const;
if (cons == null)
{
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("填充分区失败"));
return;
}
TreeNode tn = new TreeNode(cons.Name);
tn.Tag = cons;
root.Nodes.Add(tn);
}
}
private void neuTreeView1_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e)
{
this.Clear();
if (e.Node.Parent == null)
{
return;
}
Neusoft.HISFC.Models.Base.Const subarea = e.Node.Tag as Neusoft.HISFC.Models.Base.Const;
if (subarea == null)
{
return;
}
List <Neusoft.HISFC.Models.HealthRecord.Case.CaseSubarea> listSubarea = this.cbManager.QueryBySubareaID(subarea.ID);
if (listSubarea == null || listSubarea.Count == 0)
{
return;
}
foreach (Neusoft.HISFC.Models.HealthRecord.Case.CaseSubarea area in listSubarea)
{
this.FillFP(area);
}
}
/// <summary>
/// ³õʼ»¯
/// </summary>
protected override void OnLoad()
{
Neusoft.HISFC.BizProcess.Integrate.Manager manager = new Neusoft.HISFC.BizProcess.Integrate.Manager();
ArrayList list = manager.GetConstantList(Neusoft.HISFC.Models.Base.EnumConstant.DRUGQUALITY);
Neusoft.HISFC.Models.Base.Const obj = new Neusoft.HISFC.Models.Base.Const();
obj.ID = "ALL";
obj.Name = "È«²¿";
obj.SpellCode = "QB";
obj.WBCode = "WU";
list.Add(obj);
this.neuComboBox1.Items.Add(obj);
foreach (Neusoft.HISFC.Models.Base.Const con in list)
{
neuComboBox1.Items.Add(con);
}
this.neuComboBox1.alItems.Add(obj);
this.neuComboBox1.alItems.AddRange(list);
if (neuComboBox1.Items.Count > 0)
{
neuComboBox1.SelectedIndex = 0;
drugqualcode = ((Neusoft.HISFC.Models.Base.Const)neuComboBox1.Items[0]).ID;
drugqualname = ((Neusoft.HISFC.Models.Base.Const)neuComboBox1.Items[0]).Name;
}
}
/// <summary>
/// 打印
/// </summary>
public virtual void Print( )
{
#region 增加核准的打印权限 wbo 2010-10-11
Neusoft.HISFC.BizLogic.Manager.Constant consMgr = new Neusoft.HISFC.BizLogic.Manager.Constant();
Neusoft.FrameWork.Models.NeuObject obj = consMgr.GetConstant("PhaPrintPriv", consMgr.Operator.ID);
Neusoft.HISFC.Models.Base.Const cons = obj as Neusoft.HISFC.Models.Base.Const;
if (cons == null || string.IsNullOrEmpty(cons.ID) || cons.IsValid == false)
{
MessageBox.Show("无摆药单补打权限，请联系药学部或信息科！");
return;
}
if (cons.IsValid == false)
{
MessageBox.Show("摆药单补打权限无效，请联系药学部或信息科！");
return;
}
#endregion
if (MessageBox.Show("是否打印?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
this.ucDrugDetail1.Print();
MessageBox.Show("打印完毕！");
}
}
protected override void OnLoad()
{
this.Init();
Neusoft.HISFC.BizProcess.Integrate.Manager manager = new Neusoft.HISFC.BizProcess.Integrate.Manager();
System.Collections.ArrayList consList = manager.GetConstantList("PACTUNIT");
Neusoft.HISFC.Models.Base.Const all = new Neusoft.HISFC.Models.Base.Const();
all.ID = "ALL";
all.Name = "È«²¿";
all.SpellCode = "QB";
metComboBox1.Items.Add(all);
foreach (Neusoft.HISFC.Models.Base.Const con in consList)
{
metComboBox1.Items.Add(con);
}
if (metComboBox1.Items.Count >= 0)
{
metComboBox1.SelectedIndex = 0;
metCode = ((Neusoft.HISFC.Models.Base.Const)metComboBox1.Items[0]).ID;
metName = ((Neusoft.HISFC.Models.Base.Const)metComboBox1.Items[0]).Name;
}
base.OnLoad();
}
/// <summary>
/// 获得未维护得最小费用列表
/// </summary>
/// <returns>未维护得最小费用列表</returns>
protected ArrayList QueryValidMinFee()
{
ArrayList minFeeList = this.managerIntegrate.GetConstantList(Neusoft.HISFC.Models.Base.EnumConstant.MINFEE);
if (minFeeList == null)
{
return(null);
}
if (this.fpSpread1_Sheet1.RowCount == 0)
{
return(minFeeList);
}
for (int i = 0; i < minFeeList.Count; i++)
{
Neusoft.HISFC.Models.Base.Const objCon = new Neusoft.HISFC.Models.Base.Const();
objCon = (Neusoft.HISFC.Models.Base.Const)minFeeList[i];
for (int j = 0; j < this.fpSpread1_Sheet1.RowCount; j++)
{
if (objCon.ID == this.fpSpread1_Sheet1.Cells[j, (int)EnumColumns.MinFeeName].Tag.ToString() && this.fpSpread1_Sheet1.Cells[j, (int)EnumColumns.ValidState].Tag.ToString() == "0")
{
minFeeList.RemoveAt(i);
i--;
break;
}
}
}
return(minFeeList);
}
/// <summary>
/// 查询统计大类
/// </summary>
/// <param name="report_code">统计类型编码</param>
/// <returns></returns>
//private ArrayList GetFeeStatByRepotCode(string report_code)
//{
// string strSql = string.Empty;
// strSql = string.Format("select distinct (f.fee_stat_name) from fin_com_feecodestat f where f.report_code ={0} ",report_code);
// Neusoft.HISFC.BizLogic.Manager.Report reportManager = new Neusoft.HISFC.BizLogic.Manager.Report();
// if (reportManager.ExecQuery(strSql) == -1)
// {
// MessageBox.Show("查找统计大类出错!");
// return null;
// }
// ArrayList arrList = new ArrayList();
// Neusoft.HISFC.Models.Base.Const constObj = new Neusoft.HISFC.Models.Base.Const();
// try
// {
// while (reportManager.Reader.Read())
// {
// constObj = new Neusoft.HISFC.Models.Base.Const();
// constObj.Name = reportManager.Reader[0].ToString();
// arrList.Add(constObj);
// }
// reportManager.Reader.Close();
// return arrList;
// }
// catch (Exception ex)
// {
// reportManager.Err = ex.Message;
// if (!reportManager.Reader.IsClosed)
// {
// reportManager.Reader.Close();
// }
// return null;
// }
//}
#region
/// <summary>
/// 设置统计大类
/// </summary>
/// <param name="reportCode">统计类型编码</param>
private void setFeeState(string reportCode)
{
ArrayList feeStateList = new ArrayList();
this.cmbFeeState.Items.Clear();
feeStateList = feeCodeStatMger.QueryFeeCodeStatByReportCode(reportCode);
ArrayList arryFeeStat = new ArrayList();
Hashtable feeStatHash = new Hashtable();
foreach (Neusoft.HISFC.Models.Fee.FeeCodeStat feeStatObj in feeStateList)
{
if (!feeStatHash.ContainsKey(feeStatObj.StatCate.ID))//将统计大类编码作为哈希表主键
{
feeStatHash.Add(feeStatObj.StatCate.ID, feeStatObj.StatCate.Name);
arryFeeStat.Add(feeStatObj);//将不重复的统计大类实体添加到ArrayList中
}
}
ArrayList feeCodeStatArry = new ArrayList();
Neusoft.HISFC.Models.Base.Const constObj = new Neusoft.HISFC.Models.Base.Const();
foreach (Neusoft.HISFC.Models.Fee.FeeCodeStat feeStatObj in arryFeeStat)
{
constObj = new Neusoft.HISFC.Models.Base.Const();
constObj.ID = feeStatObj.StatCate.ID;
constObj.Name = feeStatObj.StatCate.Name;
feeCodeStatArry.Add(constObj);
}
this.cmbFeeState.AddItems(feeCodeStatArry);//加载统计大类
}
/// <summary>
/// 初始化
/// </summary>
public void Init()
{
Neusoft.HISFC.BizLogic.Manager.Constant consManager = new Neusoft.HISFC.BizLogic.Manager.Constant();
System.Collections.ArrayList alTypelist = consManager.GetList(Neusoft.HISFC.Models.Base.EnumConstant.ITEMTYPE);
if (alTypelist == null)
{
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("加载药品列表失败") + consManager.Err);
return;
}
this.itemTypeHelper = new Neusoft.FrameWork.Public.ObjectHelper(alTypelist);
FarPoint.Win.Spread.CellType.ComboBoxCellType cmbCellType = new FarPoint.Win.Spread.CellType.ComboBoxCellType();
string[] strItemType = new string[alTypelist.Count];
for (int i = 0; i < strItemType.Length; i++)
{
Neusoft.HISFC.Models.Base.Const tempCons = alTypelist[i] as Neusoft.HISFC.Models.Base.Const;
strItemType[i] = "<" + tempCons.ID + ">" + tempCons.Name;
}
cmbCellType.Items = strItemType;
this.neuSpread1_Sheet1.Columns[0].CellType = cmbCellType;
Neusoft.HISFC.BizLogic.Manager.Person personManager = new Neusoft.HISFC.BizLogic.Manager.Person();
this.alPerson = personManager.GetEmployeeAll();
if (this.alPerson == null)
{
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("加载人员列表失败") + personManager.Err);
return;
}
}
/// <summary>
/// 初始化
/// </summary>
protected override void OnLoad()
{
#region 加载合同单位列表
//合同单位列表
ArrayList list = new ArrayList();
//全部
Neusoft.HISFC.Models.Base.Const all = new Neusoft.HISFC.Models.Base.Const();
all.ID = "ALL";
all.Name = "全部";
all.SpellCode = "QB";
all.WBCode = "WU";
//加入合同单位列表
list.Add(all);
//list.AddRange(manager.GetConstantList(Neusoft.HISFC.Models.Base.EnumConstant.PACTUNIT));
//{B71C3094-BDC8-4fe8-A6F1-7CEB2AEC55DD}
list.AddRange(manager.QueryPactUnitAll());
//加入下拉列表
this.neuComboBox1.alItems.AddRange(list);
this.neuComboBox1.Items.AddRange(list.ToArray());
//默认合同单位
if (this.neuComboBox1.Items.Count > 0)
{
this.neuComboBox1.SelectedIndex = 0;
this.pactUnit = this.neuComboBox1.SelectedItem.ID;
}
#endregion
base.OnLoad();
}
/// <summary>
/// 取某一条报表记录
/// </summary>
/// <param name="type"></param>
/// <param name="name"></param>
/// <returns></returns>
public ArrayList GetReportFromdictionary(string type, string name)
{
string strSql = "";
ArrayList al = new ArrayList();
//接口说明
//返回
if (this.Sql.GetSql("Manager.Report.GetReportFromdictionary", ref strSql) == -1)
{
return(null);
}
try
{
strSql = string.Format(strSql, type, name);
}
catch (Exception ex)
{
this.ErrCode = ex.Message;
this.Err = "接口错误！" + ex.Message;
this.WriteErr();
return(null);
}
if (this.ExecQuery(strSql) == -1)
{
return(null);
}
//Neusoft.FrameWork.Models.NeuObject NeuObject;
Neusoft.HISFC.Models.Base.Const cons;
while (this.Reader.Read())
{
//NeuObject=new NeuObject();
cons = new Neusoft.HISFC.Models.Base.Const();
//cons.Type = (Const.enuConstant)(Reader[0].ToString());
cons.ID = this.Reader[1].ToString();
cons.Name = this.Reader[2].ToString();
cons.Memo = this.Reader[3].ToString();
cons.SpellCode = this.Reader[4].ToString();
cons.WBCode = this.Reader[5].ToString();
cons.UserCode = this.Reader[6].ToString();
if (!Reader.IsDBNull(7))
{
cons.SortID = Convert.ToInt32(this.Reader[7]);
}
cons.IsValid = Neusoft.FrameWork.Function.NConvert.ToBoolean(this.Reader[8].ToString());
cons.OperEnvironment.ID = this.Reader[9].ToString();
if (!Reader.IsDBNull(10))
{
cons.OperEnvironment.OperTime = Convert.ToDateTime(this.Reader[10].ToString());
}
al.Add(cons);
}
this.Reader.Close();
return(al);
}
protected override void OnLoad()
{
base.OnLoad();
Neusoft.HISFC.BizProcess.Integrate.Manager manager = new Neusoft.HISFC.BizProcess.Integrate.Manager();
System.Collections.ArrayList constantList = manager.GetDepartment(Neusoft.HISFC.Models.Base.EnumDepartmentType.I);
Neusoft.HISFC.Models.Base.Department top = new Neusoft.HISFC.Models.Base.Department();
top.ID = "ALL";
top.Name = "全 部";
this.neuComboBox3.Items.Add(top);
foreach (Neusoft.HISFC.Models.Base.Department con in constantList)
{
neuComboBox3.Items.Add(con);
}
this.neuComboBox3.alItems.Add(top);
this.neuComboBox3.alItems.AddRange(constantList);
if (neuComboBox3.Items.Count > 0)
{
neuComboBox3.SelectedIndex = 0;
deptCode = ((Neusoft.HISFC.Models.Base.Department)neuComboBox3.Items[this.neuComboBox3.SelectedIndex]).ID;
deptName = ((Neusoft.HISFC.Models.Base.Department)neuComboBox3.Items[this.neuComboBox3.SelectedIndex]).Name;
}
Neusoft.HISFC.Models.Base.Const cons = new Neusoft.HISFC.Models.Base.Const();
cons.ID = "ALL";
cons.Name = "全 部";
this.neuComboBox2.Items.Add(cons);
constantList = manager.GetConstantList("ITEMMINFEECODE");
foreach (Neusoft.HISFC.Models.Base.Const con in constantList)
{
neuComboBox2.Items.Add(con);
}
if (neuComboBox2.Items.Count >= 0)
{
neuComboBox2.SelectedIndex = 0;
feeCode = ((Neusoft.HISFC.Models.Base.Const)neuComboBox2.Items[0]).ID;
feeName = ((Neusoft.HISFC.Models.Base.Const)neuComboBox2.Items[0]).Name;
}
System.Collections.ArrayList al = new System.Collections.ArrayList();
Neusoft.HISFC.Models.Base.Const conn = new Neusoft.HISFC.Models.Base.Const();
conn.ID = "1";
conn.Name = "门 诊";
this.neuComboBox1.Items.Add(conn);
conn.ID = "2";
conn.Name = "住 院";
this.neuComboBox1.Items.Add(conn);
conn.ID = "ALL";
conn.Name = "全 部";
this.neuComboBox1.Items.Add(conn);
if (neuComboBox1.Items.Count >= 0)
{
neuComboBox1.SelectedIndex = 0;
feeType = ((Neusoft.HISFC.Models.Base.Const)neuComboBox1.Items[0]).ID;
}
}
/// <summary>
/// 根据随访记录明细ID读取其所有的症状表现
/// </summary>
/// <param name="recordID">随访记录明细ID</param>
/// <returns>返回查询的数组、失败返回null</returns>
public ArrayList SelectSymptom(int recordID)
{
string strSQL = "";
//读取SQL语句
if (this.Sql.GetSql("HealthReacord.Visit.VisitRecord.SelectSymptom", ref strSQL) == -1)
{
this.Err = "没有找到HealthReacord.Visit.VisitRecord.SelectSymptom字段！";
return(null);
}
try
{
//传入参数
strSQL = string.Format(strSQL, recordID);
}
catch (Exception ex)
{
this.Err = "赋值时出错！" + ex.Message;
return(null);
}
//执行SQL语句
this.ExecQuery(strSQL);
ArrayList list = new ArrayList();
Neusoft.HISFC.Models.Base.Const symptom = null;
try
{
while (this.Reader.Read())
{
symptom = new Neusoft.HISFC.Models.Base.Const();
symptom.SortID = Neusoft.FrameWork.Function.NConvert.ToInt32(this.Reader[0].ToString());
symptom.ID = this.Reader[1].ToString();
symptom.Name = this.Reader[2].ToString();
list.Add(symptom);
}
}
catch (Exception ex)
{
this.Err = "读取症状表现出错" + ex.Message;
return(null);
}
finally
{
this.Reader.Close();
}
//返回数组
return(list);
}
public int Save()
{
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
Neusoft.HISFC.BizLogic.Manager.Constant consManager = new Neusoft.HISFC.BizLogic.Manager.Constant();
//Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance);
//t.BeginTransaction();
//consManager.SetTrans(t.Trans);
//{3F1D29EA-0A9D-4703-938E-AB3E51257672}
int returnValue = consManager.DelConstant("SpeDrugGrade");
if (returnValue < 0)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show("删除常数信息出错.\n 错误信息 :" + consManager.Err);
return(-1);
}
for (int i = 0; i < this.neuSpread1_Sheet1.Rows.Count; i++)
{
if (string.IsNullOrEmpty(this.neuSpread1_Sheet1.Cells[i, 0].Text) || string.IsNullOrEmpty(this.neuSpread1_Sheet1.Cells[i, 2].Text))
{
continue;
}
Neusoft.HISFC.Models.Base.Const cons = new Neusoft.HISFC.Models.Base.Const();
cons.ID = this.neuSpread1_Sheet1.Cells[i, 0].Text;
cons.Name = this.neuSpread1_Sheet1.Cells[i, 2].Text;
cons.IsValid = true;
//{3972BA6D-5CE4-4995-90AA-30DD281D1660}
//为了避免主键重复 对于医生职级与药品等级分开
cons.ID = cons.ID + "|" + cons.Name;
if (consManager.SetConstant("SpeDrugGrade", cons) == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("药品等级、医生职级对照更新失败"));
return(1);
}
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
MessageBox.Show(Neusoft.FrameWork.Management.Language.Msg("保存成功"));
this.Query();
return(1);
}
/// <summary>
/// 增加第三条件人员类别
/// </summary>
protected override void InitComboBox()
{
Neusoft.HISFC.BizProcess.Integrate.Manager interMgr = new Neusoft.HISFC.BizProcess.Integrate.Manager();
ArrayList alPact = interMgr.GetConstantList("PACTUNIT");
Neusoft.HISFC.Models.Base.Const c = new Neusoft.HISFC.Models.Base.Const();
c.ID = "ALL";
c.Name = "全部";
c.IsValid = true;
c.SortID = 0;
alPact.Insert(0, c);
base.cmbDept.AddItems(alPact);
base.cmbDept.SelectedIndex = 0;
}
/// <summary>
/// 由数据表内获取数据
/// </summary>
/// <param name="row"></param>
/// <param name="flag"></param>
/// <returns></returns>
private Neusoft.HISFC.Models.Base.Const GetConstFromFp(int iIndex)
{
Neusoft.HISFC.Models.Base.Const cons = new Neusoft.HISFC.Models.Base.Const();
cons.ID = this.neuSpread1_Sheet1.Cells[iIndex, (int)ColumnSet.ColID].Text;
cons.Name = this.neuSpread1_Sheet1.Cells[iIndex, (int)ColumnSet.ColName].Text;
cons.SpellCode = this.neuSpread1_Sheet1.Cells[iIndex, (int)ColumnSet.ColSpellCode].Text;
cons.Memo = this.neuSpread1_Sheet1.Cells[iIndex, (int)ColumnSet.ColMemo].Text;
cons.WBCode = this.neuSpread1_Sheet1.Cells[iIndex, (int)ColumnSet.ColWBCode].Text;
cons.IsValid = Neusoft.FrameWork.Function.NConvert.ToBoolean(this.neuSpread1_Sheet1.Cells[iIndex, (int)ColumnSet.ColValid].Value);
cons.SortID = Neusoft.FrameWork.Function.NConvert.ToInt32(this.neuSpread1_Sheet1.Cells[iIndex, (int)ColumnSet.ColSort].Text);
return(cons);
}
/// <summary>
/// 向随访明细症状表现表中插入一条新记录,将随访记录明细的ID存在常数实体的SortID中
/// </summary>
/// <returns>影响的行数、-1 失败</returns>
public int InsertSymptom(Neusoft.HISFC.Models.Base.Const symptom)
{
this.SetDB(visitRecordManager);
int intReturn = visitRecordManager.InsertSymptom(symptom);
if (intReturn <= 0)
{
this.Err = visitRecordManager.Err;
return(-1);
}
return(intReturn);
}
/// <summary>
/// 获取已经月结的操作时间列
/// </summary>
/// <returns></returns>
private ArrayList QueryDateList()
{
string strSql = string.Empty;
strSql = string.Format("select distinct(to_char(t.oper_date,'yyyymmdd')) from pha_com_ms_drug t ");
Neusoft.HISFC.BizLogic.Manager.Report reportManager = new Neusoft.HISFC.BizLogic.Manager.Report();
if (reportManager.ExecQuery(strSql) == -1)
{
MessageBox.Show("没有找到索引!");
return(null);
}
ArrayList arrdayList = new ArrayList();
string strday = string.Empty;
Neusoft.HISFC.Models.Base.Const constObj = new Neusoft.HISFC.Models.Base.Const();
try
{
while (reportManager.Reader.Read())
{
constObj = new Neusoft.HISFC.Models.Base.Const();
constObj.ID = reportManager.Reader[0].ToString();
constObj.Name = reportManager.Reader[0].ToString();
arrdayList.Add(constObj);
}
reportManager.Reader.Close();
return(arrdayList);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
if (!reportManager.Reader.IsClosed)
{
reportManager.Reader.Close();
}
return(null);
}
}
protected override void OnLoad()
{
this.isAcross = true;
this.isSort = false;
this.Init();
base.OnLoad();
Neusoft.HISFC.BizProcess.Integrate.Manager manager = new Neusoft.HISFC.BizProcess.Integrate.Manager();
System.Collections.ArrayList constantList = manager.GetDepartment(Neusoft.HISFC.Models.Base.EnumDepartmentType.I);
Neusoft.HISFC.Models.Base.Department top = new Neusoft.HISFC.Models.Base.Department();
top.ID = "ALL";
top.Name = "È« ²¿";
this.neuComboBox1.Items.Add(top);
foreach (Neusoft.HISFC.Models.Base.Department con in constantList)
{
neuComboBox1.Items.Add(con);
}
this.neuComboBox1.alItems.Add(top);
this.neuComboBox1.alItems.AddRange(constantList);
if (neuComboBox1.Items.Count > 0)
{
neuComboBox1.SelectedIndex = 0;
deptcode = ((Neusoft.HISFC.Models.Base.Department)neuComboBox1.Items[this.neuComboBox1.SelectedIndex]).ID;
deptname = ((Neusoft.HISFC.Models.Base.Department)neuComboBox1.Items[this.neuComboBox1.SelectedIndex]).Name;
}
Neusoft.HISFC.Models.Base.Const cons = new Neusoft.HISFC.Models.Base.Const();
cons.ID = "ALL";
cons.Name = "È«²¿";
this.neuComboBox2.Items.Add(cons);
constantList = manager.GetConstantList("ITEMMINFEECODE");
foreach (Neusoft.HISFC.Models.Base.Const con in constantList)
{
neuComboBox2.Items.Add(con);
}
if (neuComboBox2.Items.Count >= 0)
{
neuComboBox2.SelectedIndex = 0;
reportCode = ((Neusoft.HISFC.Models.Base.Const)neuComboBox2.Items[0]).ID;
reportName = ((Neusoft.HISFC.Models.Base.Const)neuComboBox2.Items[0]).Name;
}
}
/// <summary>
/// 科室更新分解时间常数
/// </summary>
/// <returns></returns>
private int Save()
{
Neusoft.HISFC.Models.Base.Const cons = new Neusoft.HISFC.Models.Base.Const();
string type = "SETEXECTIME";
string code = "";
string name = "";
string mark = "";
if (deptCode != "")
{
code = deptCode;
name = deptName;
if (this.cmbTime.SelectedIndex == 0)
{
mark = "12";
}
else if (this.cmbTime.SelectedIndex == 1)
{
mark = "0";
}
else
{
MessageBox.Show("请选择一个分解时间！");
return(-1);
}
}
else
{
MessageBox.Show("请选择一个科室！");
return(-1);
}
cons.ID = code;
cons.Name = name;
cons.Memo = mark;
try
{
return(manager.UpdateConstant(type, cons));
}
catch (Exception e)
{
MessageBox.Show("更新常数失败！" + e.Message.ToString());
return(-1);
}
}
/// <summary>
/// 初始化床位等级
/// </summary>
protected virtual int InitTree()
{
this.tvBedGrade.ImageList = new ImageList();
this.tvBedGrade.ImageList.Images.Add(Neusoft.FrameWork.WinForms.Classes.Function.GetImage(Neusoft.FrameWork.WinForms.Classes.EnumImageList.L楼房));
this.tvBedGrade.ImageList.Images.Add(Neusoft.FrameWork.WinForms.Classes.Function.GetImage(Neusoft.FrameWork.WinForms.Classes.EnumImageList.C床位维护));
this.tvBedGrade.ImageList.Images.Add(Neusoft.FrameWork.WinForms.Classes.Function.GetImage(Neusoft.FrameWork.WinForms.Classes.EnumImageList.Q全选));
this.tvBedGrade.Nodes.Clear();
this.tvBedGrade.Nodes.AddRange(
new TreeNode[] {
new TreeNode("床位等级")
});
//床位等级树
try
{
ArrayList reportTypes = new ArrayList();
reportTypes = this.managerIntegrate.GetConstantList(Neusoft.HISFC.Models.Base.EnumConstant.BEDGRADE);
for (int j = 0; j < reportTypes.Count; j++)
{
Neusoft.HISFC.Models.Base.Const obj = new Neusoft.HISFC.Models.Base.Const();
obj = (Neusoft.HISFC.Models.Base.Const)reportTypes[j];
TreeNode tnReportName = new TreeNode();
tnReportName = new TreeNode(obj.Name);
tnReportName.Tag = obj.ID;
tnReportName.Text = obj.Name;
tnReportName.ImageIndex = 1;
tvBedGrade.Nodes[0].Nodes.Add(tnReportName);
}
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(-1);
}
this.tvBedGrade.ExpandAll();
return(1);
}
protected override void OnLoad()
{
this.Init();
base.OnLoad();
//Ìî³äÊý¾Ý
Neusoft.HISFC.BizProcess.Integrate.Manager manager = new Neusoft.HISFC.BizProcess.Integrate.Manager();
constantList = manager.GetConstantList("PACTUNIT");
Neusoft.HISFC.Models.Base.Const con = new Neusoft.HISFC.Models.Base.Const();
con.ID = "ALL";
con.Name = "È«²¿";
con.SpellCode = "QB";
cboPactCode.Items.Insert(0, con);
constantList.Insert(0, con);
this.cboPactCode.AddItems(constantList);
cboPactCode.SelectedIndex = 0;
pactCode = ((Neusoft.HISFC.Models.Base.Const)constantList[0]).ID;
pactName = ((Neusoft.HISFC.Models.Base.Const)constantList[0]).Name;
}
protected override void OnLoad()
{
base.OnLoad();
Neusoft.HISFC.Models.Base.Const conn = new Neusoft.HISFC.Models.Base.Const();
conn.ID = "ALL";
conn.Name = "È«¡¡²¿";
this.neuComboBox1.Items.Add(conn);
Neusoft.HISFC.BizProcess.Integrate.Manager manager = new Neusoft.HISFC.BizProcess.Integrate.Manager();
System.Collections.ArrayList al = manager.GetConstantList("ITEMTYPE");
foreach (Neusoft.HISFC.Models.Base.Const con in al)
{
this.neuComboBox1.Items.Add(con);
}
if (neuComboBox1.Items.Count > -1)
{
neuComboBox1.SelectedIndex = 0;
drugType = ((Neusoft.HISFC.Models.Base.Const)neuComboBox1.Items[0]).ID;
drugName = ((Neusoft.HISFC.Models.Base.Const)neuComboBox1.Items[0]).Name;
}
}
/// <summary>
/// 提取所有医保诊断编码
/// </summary>
/// <returns>医保诊断编码</returns>
public ArrayList GetDiagnoseby()
{
string strSql = string.Empty;
int returnValue = this.Sql.GetSql("Siinterface.localManager.2", ref strSql);
{
if (returnValue == -1)
{
this.Err = "获得[Siinterface.localManager.2]对应sql语句出错";
return(null);
}
}
ArrayList al = new ArrayList();
Neusoft.HISFC.Models.Base.Const obj = null;
try
{
if (ExecQuery(strSql) == -1)
{
return(null);
}
}
catch (Exception ex)
{
this.Err = ex.Message;;
return(null);
}
while (Reader.Read())
{
obj = new Neusoft.HISFC.Models.Base.Const();
obj.ID = this.Reader[1].ToString();
obj.Name = this.Reader[2].ToString();
obj.SpellCode = this.Reader[3].ToString();
al.Add(obj);
}
return(al);
}
/// <summary>
/// 向随访明细症状表现表中插入一条新记录,将随访记录明细的ID存在常数实体的SortID中
/// </summary>
/// <returns>影响的行数、-1 失败</returns>
public int InsertSymptom(Neusoft.HISFC.Models.Base.Const symptomInfo)
{
string strSQL = "";
//读取SQL语句
if (this.Sql.GetSql("HealthReacord.Visit.VisitRecord.InsertSymptom", ref strSQL) == -1)
{
this.Err = "没有找到HealthReacord.Visit.VisitRecord.InsertSymptom字段!";
return(-1);
}
try
{
//传递参数
strSQL = string.Format(strSQL, Neusoft.FrameWork.Function.NConvert.ToInt32(symptomInfo.SortID), symptomInfo.ID, symptomInfo.Name);
}
catch (Exception ex)
{
this.Err = "赋值时候出错!" + ex.Message;
return(-1);
}
//执行SQL语句并返回
return(this.ExecNoQuery(strSQL));
}
protected override void OnLoad()
{
this.Init();
base.OnLoad();
//设置时间范围
DateTime now = DateTime.Now;
DateTime dt = new DateTime(DateTime.Now.Year, 1, 1);
this.dtpBeginTime.Value = dt;
//填充数据
Neusoft.HISFC.BizProcess.Integrate.Manager manager = new Neusoft.HISFC.BizProcess.Integrate.Manager();
alPersonconstantList = manager.QueryEmployeeAll();
Neusoft.HISFC.Models.Base.Employee allPerson = new Neusoft.HISFC.Models.Base.Employee();
allPerson.ID = "%%";
allPerson.Name = "全部";
allPerson.SpellCode = "QB";
//cboPersonCode.Items.Insert(0, allPerson);
alPersonconstantList.Insert(0, allPerson);
this.cboPersonCode.AddItems(alPersonconstantList);
cboPersonCode.SelectedIndex = 0;
alCancelFlagConstantList = new ArrayList();
#region 全部发票状态
//全部
Neusoft.HISFC.Models.Base.Const allCancelFlag0 = new Neusoft.HISFC.Models.Base.Const();
allCancelFlag0.ID = "QB";
allCancelFlag0.Name = "全部";
allCancelFlag0.SpellCode = "QB";
alCancelFlagConstantList.Add(allCancelFlag0);
//有效
Neusoft.HISFC.Models.Base.Const allCancelFlag1 = new Neusoft.HISFC.Models.Base.Const();
allCancelFlag1.ID = "YX";
allCancelFlag1.Name = "有效";
allCancelFlag1.SpellCode = "YX";
alCancelFlagConstantList.Add(allCancelFlag1);
//全部废票(退费,重打,注销)
Neusoft.HISFC.Models.Base.Const allCancelFlag2 = new Neusoft.HISFC.Models.Base.Const();
allCancelFlag2.ID = "QBFP";
allCancelFlag2.Name = "全部废票";
allCancelFlag2.SpellCode = "QBFP";
alCancelFlagConstantList.Add(allCancelFlag2);
//退费
Neusoft.HISFC.Models.Base.Const allCancelFlag3 = new Neusoft.HISFC.Models.Base.Const();
allCancelFlag3.ID = "TF";
allCancelFlag3.Name = "退费";
allCancelFlag3.SpellCode = "TF";
alCancelFlagConstantList.Add(allCancelFlag3);
//重打
Neusoft.HISFC.Models.Base.Const allCancelFlag4 = new Neusoft.HISFC.Models.Base.Const();
allCancelFlag4.ID = "CD";
allCancelFlag4.Name = "重打";
allCancelFlag4.SpellCode = "CD";
alCancelFlagConstantList.Add(allCancelFlag4);
//注销
Neusoft.HISFC.Models.Base.Const allCancelFlag5 = new Neusoft.HISFC.Models.Base.Const();
allCancelFlag5.ID = "ZX";
allCancelFlag5.Name = "注销";
allCancelFlag5.SpellCode = "ZX";
alCancelFlagConstantList.Add(allCancelFlag5);
#endregion
this.cboCancelFlag.AddItems(alCancelFlagConstantList);
cboCancelFlag.SelectedIndex = 0;
}
/// <summary>
/// 更新操作员发票号信息
/// </summary>
/// <param name="invoiceNO"></param>
/// <returns></returns>
public int UpdateInvoice(string invoiceNO)
{
//try
//{
// int temp = Convert.ToInt32(this.tbInvoiceNO1.Text.Trim());
//}
//catch (Exception ex)
//{
// MessageBox.Show("发票号请输入数字,并且不能超过50个字符!" + ex.Message);
// this.tbInvoiceNO1.Focus();
// return -1;
//}
Neusoft.FrameWork.Management.PublicTrans.BeginTransaction();
//Transaction t = new Transaction(Connection.Instance);
//t.BeginTransaction();
this.managerIntegrate.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
this.outpatientManager.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans);
#region 更新发票号,如果有重复,提示
if (this.invoiceType == "1")
{
string tmpCount = this.outpatientManager.QueryExistInvoiceCount(invoiceNO);
if (tmpCount == "1")
{
DialogResult result = MessageBox.Show("已经存在票据号为: " + invoiceNO +
" 的发票!,是否继续?", "提示!", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2);
if (result == DialogResult.No)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
this.tbRealInvoiceNO.Focus();
this.tbRealInvoiceNO.SelectAll();
return(2);
}
}
}
#endregion
Neusoft.HISFC.Models.Base.Const con = new Neusoft.HISFC.Models.Base.Const();
//try
//{
// int temp = Convert.ToInt32(invoiceNO);
//}
//catch (Exception ex)
//{
// Neusoft.FrameWork.Management.PublicTrans.RollBack();
// MessageBox.Show("发票号请输入数字,并且不能超过50个字符!" + ex.Message);
// this.tbInvoiceNO1.Focus();
// this.tbInvoiceNO1.SelectAll();
// return -1;
//}
NeuObject objInvoice = this.managerIntegrate.GetConstansObj("MZINVOICE", this.outpatientManager.Operator.ID);
if (objInvoice == null || objInvoice.ID == null || objInvoice.ID == "")//没有记录
{
con.ID = this.outpatientManager.Operator.ID;
con.Name = invoiceNO;
con.IsValid = true;
con.OperEnvironment.ID = this.outpatientManager.Operator.ID;
con.OperEnvironment.OperTime = this.outpatientManager.GetDateTimeFromSysDateTime();
int iReturn = this.managerIntegrate.InsertConstant("MZINVOICE", con);
if (iReturn <= 0)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show("插入操作员初试发票失败!" + managerIntegrate.Err);
return(-1);
}
}
else
{
con.ID = this.outpatientManager.Operator.ID;
con.Name = invoiceNO;
con.Memo = objInvoice.Memo;
con.IsValid = true;
con.OperEnvironment.ID = this.outpatientManager.Operator.ID;
con.OperEnvironment.OperTime = this.outpatientManager.GetDateTimeFromSysDateTime();
int iReturn = this.managerIntegrate.UpdateConstant("MZINVOICE", con);
if (iReturn == -1)
{
Neusoft.FrameWork.Management.PublicTrans.RollBack();
MessageBox.Show("更新操作员初试发票失败!" + managerIntegrate.Err);
return(-1);
}
}
Neusoft.FrameWork.Management.PublicTrans.Commit();
return(0);
}
/// <summary>
/// 初始化treeview
/// </summary>
protected virtual int InitTree()
{
this.tvFeeType.Nodes.Clear();
this.tvFeeType.Nodes.AddRange(
new TreeNode[] {
new TreeNode("发票"),
new TreeNode("统计"),
new TreeNode("病案"),
new TreeNode("知情权")
});
foreach (TreeNode node in this.tvFeeType.Nodes)
{
if (node.Text == "发票")
{
node.Tag = "FP";
}
if (node.Text == "统计")
{
node.Tag = "TJ";
}
if (node.Text == "病案")
{
node.Tag = "BA";
}
if (node.Text == "知情权")
{
node.Tag = "ZQ";
}
}
//报表类别
//统计规类列表
try
{
ArrayList reportTypes = new ArrayList();
reportTypes = this.managerIntegrate.GetConstantList(Neusoft.HISFC.Models.Base.EnumConstant.FEECODESTAT);
for (int j = 0; j < reportTypes.Count; j++)
{
Neusoft.HISFC.Models.Base.Const obj = new Neusoft.HISFC.Models.Base.Const();
obj = (Neusoft.HISFC.Models.Base.Const)reportTypes[j];
TreeNode tnReportName = new TreeNode();
tnReportName = new TreeNode(obj.Name);
tnReportName.Tag = obj.ID;
tnReportName.Text = obj.Name;
if (obj.Memo == "发票")
{
tvFeeType.Nodes[0].Nodes.Add(tnReportName);
}
if (obj.Memo == "统计")
{
tvFeeType.Nodes[1].Nodes.Add(tnReportName);
}
if (obj.Memo == "病案")
{
tvFeeType.Nodes[2].Nodes.Add(tnReportName);
}
if (obj.Memo == "知情权")
{
tvFeeType.Nodes[3].Nodes.Add(tnReportName);
}
}
// [2007/02/07] 新增加的代码,选择树控件
this.tvFeeType.Select();
// 新增加的代码结束
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(-1);
}
return(1);
}
protected override void OnLoad()
{
base.OnLoad();
// 部门下拉列表
System.Collections.ArrayList list_department = new System.Collections.ArrayList();
if (this.Department == "住院")
{
list_department.Add("住院");
}
else if (this.Department == "门诊")
{
list_department.Add("门诊");
}
else if (this.Department == "全院")
{
list_department.Add("全院");
list_department.Add("门诊");
list_department.Add("住院");
}
foreach (string str in list_department)
{
ncboDepartment.Items.Add(str);
}
ncboDepartment.alItems.AddRange(list_department);
if (ncboDepartment.Items.Count > 0)
{
ncboDepartment.SelectedIndex = 0;
department = ncboDepartment.Items[this.ncboDepartment.SelectedIndex].ToString();
}
// 统计大类下拉列表
Neusoft.HISFC.BizProcess.Integrate.Manager manager = new Neusoft.HISFC.BizProcess.Integrate.Manager();
System.Collections.ArrayList list_bigtype = manager.GetConstantList("FEECODESTAT");
Neusoft.HISFC.Models.Base.Const top_bigtype = new Neusoft.HISFC.Models.Base.Const();
top_bigtype.ID = "ALL";
top_bigtype.Name = "全部";
// 下拉列表加载第一个选项“全部”
this.ncboReportcode.Items.Add(top_bigtype);
foreach (Neusoft.HISFC.Models.Base.Const con in list_bigtype)
{
ncboReportcode.Items.Add(con);
}
// 下拉列表键盘选择框加载第一个选项“全部”以及加载列表
this.ncboReportcode.alItems.Add(top_bigtype);
this.ncboReportcode.alItems.AddRange(list_bigtype);
if (ncboReportcode.Items.Count > 0)
{
ncboReportcode.SelectedIndex = 0;
reportCode = ((Neusoft.HISFC.Models.Base.Const)ncboReportcode.Items[0]).ID;
reportName = ((Neusoft.HISFC.Models.Base.Const)ncboReportcode.Items[0]).Name;
}
// 科室下拉列表
//Neusoft.HISFC.BizProcess.Integrate.Manager manager = new Neusoft.HISFC.BizProcess.Integrate.Manager();
System.Collections.ArrayList list_dept = new System.Collections.ArrayList();
Neusoft.HISFC.Models.Base.Department top_dept = new Neusoft.HISFC.Models.Base.Department();
top_dept.ID = "ALL";
top_dept.Name = "全部";
this.ncboDept.Items.Add(top_dept);
if (ncboDepartment.Items[ncboDepartment.SelectedIndex].ToString() == "住院")
{
list_dept = manager.GetDepartment(Neusoft.HISFC.Models.Base.EnumDepartmentType.I);
}
else if (ncboDepartment.Items[ncboDepartment.SelectedIndex].ToString() == "门诊")
{
list_dept = manager.GetDepartment(Neusoft.HISFC.Models.Base.EnumDepartmentType.C);
}
else
{
System.Collections.ArrayList list_inhos = manager.GetDepartment(Neusoft.HISFC.Models.Base.EnumDepartmentType.I);
System.Collections.ArrayList list_clinic = manager.GetDepartment(Neusoft.HISFC.Models.Base.EnumDepartmentType.C);
foreach (Neusoft.HISFC.Models.Base.Department var_inhos in list_inhos)
{
list_dept.Add(var_inhos);
}
foreach (Neusoft.HISFC.Models.Base.Department var_clinic in list_clinic)
{
list_dept.Add(var_clinic);
}
}
foreach (Neusoft.HISFC.Models.Base.Department var_dept in list_dept)
{
this.ncboDept.Items.Add(var_dept);
}
this.ncboDept.alItems.Add(top_dept);
this.ncboDept.alItems.AddRange(list_dept);
if (ncboDept.Items.Count > 0)
{
ncboDept.SelectedIndex = 0;
deptCode = ((Neusoft.HISFC.Models.Base.Department)ncboDept.Items[0]).ID;
deptName = ((Neusoft.HISFC.Models.Base.Department)ncboDept.Items[0]).Name;
}
}
