/// <summary> /// 获取月结记录 /// </summary> private void QueryStoreInterval() { Neusoft.FrameWork.Management.DataBaseManger dataManager = new Neusoft.FrameWork.Management.DataBaseManger(); if (this.OperDept.ID == "") { return; } DataSet ds = new DataSet(); string exeInterval = string.Format(this.sqlInterval, this.OperDept.ID); if (dataManager.ExecQuery(exeInterval, ref ds) == -1) { MessageBox.Show(Language.Msg("获取月结记录发生错误")); return; } if (ds != null && ds.Tables.Count > 0) { this.cmbMonthStoreInterval.Items.Clear(); foreach (DataRow dr in ds.Tables[0].Rows) { string strInterval = NConvert.ToDateTime(dr[0]).ToString() + "--" + NConvert.ToDateTime(dr[1]).ToString(); this.cmbMonthStoreInterval.Items.Add(strInterval); } } }
/// <summary> /// 汇总查询 /// </summary> /// <returns></returns> protected int QueryTotal() { Neusoft.FrameWork.Management.DataBaseManger dataManager = new Neusoft.FrameWork.Management.DataBaseManger(); if (this.OperDept.ID == "") { return(-1); } this.Clear(); DataSet ds = new DataSet(); this.lbDept.Text = "库存科室:" + this.OperDept.Name; this.lbDate.Text = "统计周期:" + this.BeginTime.ToString() + "至" + this.EndTime.ToString(); string exeTotal = string.Format(this.sqlTotal, this.OperDept.ID, this.BeginTime.ToString(), this.EndTime.ToString()); if (dataManager.ExecQuery(exeTotal, ref ds) == -1) { MessageBox.Show(Language.Msg("获取年结汇总记录发生错误")); return(-1); } if (ds != null && ds.Tables.Count > 0) { this.fpHead.DataSource = ds; this.Sum(); } return(1); }
private void GetRecipeLabelItem(string drugDept, string drugCode, ref Neusoft.HISFC.Models.Pharmacy.Item item) { Neusoft.FrameWork.Management.DataBaseManger dataBaseMgr = new Neusoft.FrameWork.Management.DataBaseManger(); string strSql = @"select t.trade_name,t.regular_name,t.formal_name,t.other_name, t.english_regular,t.english_other,t.english_name,t.caution,t.store_condition,t.base_dose,s.place_code, t.custom_code from pha_com_baseinfo t,pha_com_stockinfo s where t.drug_code = s.drug_code and s.drug_dept_code = '{0}' and s.drug_code = '{1}'"; strSql = string.Format(strSql, drugDept, drugCode); if (dataBaseMgr.ExecQuery(strSql) != -1) { if (dataBaseMgr.Reader.Read()) { item.Name = dataBaseMgr.Reader[0].ToString(); item.NameCollection.RegularName = dataBaseMgr.Reader[1].ToString(); item.NameCollection.FormalName = dataBaseMgr.Reader[2].ToString(); item.NameCollection.OtherName = dataBaseMgr.Reader[3].ToString(); item.NameCollection.EnglishRegularName = dataBaseMgr.Reader[4].ToString(); item.NameCollection.EnglishOtherName = dataBaseMgr.Reader[5].ToString(); item.NameCollection.EnglishName = dataBaseMgr.Reader[6].ToString(); item.Product.Caution = dataBaseMgr.Reader[7].ToString(); item.Product.StoreCondition = dataBaseMgr.Reader[8].ToString(); item.BaseDose = Neusoft.FrameWork.Function.NConvert.ToDecimal(dataBaseMgr.Reader[9].ToString()); item.User01 = dataBaseMgr.Reader[10].ToString(); item.NameCollection.UserCode = dataBaseMgr.Reader[11].ToString(); } } }
/// <summary> /// 初始化 /// </summary> public void Init() { Neusoft.FrameWork.Management.DataBaseManger dataManager = new Neusoft.FrameWork.Management.DataBaseManger(); Neusoft.FrameWork.Models.NeuObject class2Priv = new Neusoft.FrameWork.Models.NeuObject(); class2Priv.ID = "0320"; class2Priv.Name = "出库"; this.Class2Priv = class2Priv; //出库 //权限科室通过权限获取 //this.DeptInfo = ((Neusoft.HISFC.Models.Base.Employee)dataManager.Operator).Dept; this.OperInfo = dataManager.Operator; Neusoft.HISFC.BizProcess.Integrate.Manager managerIntegrate = new Neusoft.HISFC.BizProcess.Integrate.Manager(); Neusoft.HISFC.Models.Base.Department dept = managerIntegrate.GetDepartment(this.DeptInfo.ID); if (dept != null) { this.DeptInfo.Memo = dept.DeptType.ID.ToString(); } this.isStockArk = this.ArkJudge(this.DeptInfo.ID); if (this.FilePath == "") { this.FilePath = @"\Setting\PhaOutSetting.xml"; } if (this.SetPrivType(true) == -1) { return; } this.GetInterface(); }
/// <summary> /// 设置信息 /// </summary> public void SetData(Neusoft.FrameWork.Models.NeuObject dept, Neusoft.FrameWork.Models.NeuObject item, int intervalDays) { Neusoft.FrameWork.Management.DataBaseManger databaseMgr = new Neusoft.FrameWork.Management.DataBaseManger(); DateTime sysTime = databaseMgr.GetDateTimeFromSysDateTime().Date; this.dtpEnd.Value = sysTime; this.dtpEnd.Text = sysTime.ToString(); this.dtpBegin.Value = sysTime.AddDays(-intervalDays); this.dtpBegin.Text = sysTime.AddDays(-intervalDays).ToString(); if (dept != null && dept.ID != "") { this.Dept = dept; this.cmbDept.Text = dept.Name; this.cmbDept.Tag = dept.ID; } if (item != null && item.ID != "") { this.item = item; this.cmbItem.Text = item.Name; this.cmbItem.Tag = item.ID; } this.lbItemInfo.Text = string.Format("物品编码:{0} 规格:{1} 单位:{2}", item.Name, item.Memo, item.User01); this.Query(); }
/// <summary> /// 数据初始化 /// </summary> protected void Init() { ArrayList al = new ArrayList(); #region 银行 Neusoft.HISFC.BizLogic.Manager.Constant constantManager = new Neusoft.HISFC.BizLogic.Manager.Constant(); al = constantManager.GetList("BANK"); if (al == null) { MessageBox.Show(Language.Msg("获取银行列表失败" + constantManager.Err)); return; } bankHelper.ArrayObject = al; #endregion #region 人员 Neusoft.HISFC.BizLogic.Manager.Person personManager = new Neusoft.HISFC.BizLogic.Manager.Person(); al = personManager.GetEmployeeAll(); if (al == null) { MessageBox.Show(Language.Msg("获取所有人员列表" + personManager.Err)); return; } this.personHelper.ArrayObject = al; #endregion #region 供货单位 Neusoft.HISFC.BizLogic.Pharmacy.Constant constant = new Neusoft.HISFC.BizLogic.Pharmacy.Constant(); this.alCompany = constant.QueryCompany("1"); if (this.alCompany == null) { MessageBox.Show(constant.Err); return; } //{49390DE5-B54F-4b15-A012-208CDF288FF5} 可选择全部供货公司 增加银行列表选择功能 Neusoft.HISFC.Models.Pharmacy.Company rootCompany = new Neusoft.HISFC.Models.Pharmacy.Company(); rootCompany.ID = "AAAA"; rootCompany.Name = "全部供货公司"; this.alCompany.Insert(0, rootCompany); this.companyHelper = new Neusoft.FrameWork.Public.ObjectHelper(this.alCompany); #endregion Neusoft.FrameWork.Management.DataBaseManger dataBaseManager = new Neusoft.FrameWork.Management.DataBaseManger(); DateTime sysTime = dataBaseManager.GetDateTimeFromSysDateTime().Date.AddDays(1); this.dtBegin = sysTime.AddDays(-30); this.dtEnd = sysTime; this.privOper = dataBaseManager.Operator; this.payFlag = "'0','1'"; }
private void fpStorage_EditChange(object sender, EditorNotifyEventArgs e) { Neusoft.FrameWork.Management.DataBaseManger data = new Neusoft.FrameWork.Management.DataBaseManger(); DateTime date = this.basesetManager.GetDateTimeFromSysDateTime(); this.fpStorage_Sheet1.Cells[e.Row, 14].Text = ((Neusoft.HISFC.Models.Base.Employee)data.Operator).ID; this.fpStorage_Sheet1.Cells[e.Row, 15].Text = date.ToString(); }
/// <summary> /// 直接退费 /// </summary> public override int Save() { if (this.patientInfo == null || string.IsNullOrEmpty(patientInfo.ID)) { MessageBox.Show("请输入患者住院号并回车确认!"); this.ucQueryPatientInfo.Focus(); return(-1); } List <FeeItemList> quitItem = this.GetConfirmDrugItem(); if (quitItem.Count == 0) { MessageBox.Show("没有可退的费用!"); return(-1); } Neusoft.FrameWork.Management.DataBaseManger dataManager = new Neusoft.FrameWork.Management.DataBaseManger(); DateTime sysTime = dataManager.GetDateTimeFromSysDateTime(); //Neusoft.FrameWork.Management.Transaction t = new Neusoft.FrameWork.Management.Transaction(Neusoft.FrameWork.Management.Connection.Instance); Neusoft.FrameWork.Management.PublicTrans.BeginTransaction(); this.feeIntegrate.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans); this.phamarcyIntegrate.SetTrans(Neusoft.FrameWork.Management.PublicTrans.Trans); foreach (Neusoft.HISFC.Models.Fee.Inpatient.FeeItemList info in quitItem) { //{26757C60-3E01-47a2-963F-93B0E26565A6} 更改了函数调用顺序 //需要先取消申请,再进行退费 if (info.PayType == Neusoft.HISFC.Models.Base.PayTypes.Balanced) { //取消出库申请 if (this.phamarcyIntegrate.CancelApplyOut(info.Clone()) == -1) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); MessageBox.Show(Language.Msg("取消药品申请失败!") + this.phamarcyIntegrate.Err); return(-1); } } //退费操作 if (this.feeIntegrate.QuitItem(this.patientInfo, info.Clone()) == -1) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); MessageBox.Show(Language.Msg("退费失败!") + this.feeIntegrate.Err); return(-1); } //退库操作 if (this.phamarcyIntegrate.OutputReturn(info, dataManager.Operator.ID, sysTime) == -1) { Neusoft.FrameWork.Management.PublicTrans.RollBack(); MessageBox.Show(Language.Msg("退费时退库失败!") + this.phamarcyIntegrate.Err); return(-1); } } Neusoft.FrameWork.Management.PublicTrans.Commit(); MessageBox.Show(Language.Msg("退费成功!")); return(1); }
/// <summary> /// 数据查询 /// </summary> private void QueryData() { if (this.cmbMonthStoreInterval.Text == "") { return; } if (this.OperDept.ID == "") { return; } Neusoft.FrameWork.Management.DataBaseManger dataManager = new Neusoft.FrameWork.Management.DataBaseManger(); string strInterval = this.cmbMonthStoreInterval.Text; string strBegin = strInterval.Substring(0, strInterval.IndexOf("--")); string strEnd = strInterval.Substring(strInterval.IndexOf("--") + 2); string exeDetail = string.Format(this.sqlTotal, this.OperDept.ID, strBegin, strEnd); DataSet ds = new DataSet(); this.lbDept.Text = "库存科室:" + this.OperDept.Name; this.lbDate.Text = "统计区间:" + this.cmbMonthStoreInterval.Text; if (dataManager.ExecQuery(exeDetail, ref ds) == -1) { MessageBox.Show(Language.Msg("获取月结明细发生错误")); return; } if (ds != null && ds.Tables.Count > 0) { this.fpDetail.Rows.Count = 0; this.fpHead.DataSource = ds; int iTotIndex = this.fpHead.Rows.Count; this.fpHead.Rows.Add(iTotIndex, 1); this.fpHead.Cells[iTotIndex, 0].Text = "合计:"; if (iTotIndex == 0) { for (int i = 1; i < this.fpHead.Columns.Count; i++) { this.fpHead.Cells[iTotIndex, i].Text = "0"; } } else { for (int i = 1; i < this.fpHead.Columns.Count; i++) { this.fpHead.Cells[iTotIndex, i].Formula = "SUM(" + (char)(65 + i) + "1:" + (char)(65 + i) + iTotIndex.ToString() + ")"; } } this.fpHead.Rows[iTotIndex].Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134))); } }
/// <summary> /// 数据检索 /// </summary> protected void QueryData() { if (!this.IsValid()) { return; } this.neuSpread1.ActiveSheet = this.neuSpread1_Sheet1; if (this.neuSpread1.Sheets.Contains(this.neuSpread1_Sheet2)) { this.neuSpread1.Sheets.Remove(this.neuSpread1_Sheet2); } Neusoft.FrameWork.Management.DataBaseManger dataManager = new Neusoft.FrameWork.Management.DataBaseManger(); string sqlIndex = this.GetSqlIndex(); string sql = ""; dataManager.Sql.GetSql(sqlIndex, ref sql); sql = string.Format(sql, this.cmbData.Tag.ToString(), Neusoft.FrameWork.Function.NConvert.ToDateTime(this.dtBegin.Text).ToString(), Neusoft.FrameWork.Function.NConvert.ToDateTime(this.dtEnd.Text).ToString()); DataSet ds = new DataSet(); if (dataManager.ExecQuery(sql, ref ds) == -1) { MessageBox.Show(Language.Msg("工作量查询出错 \n" + dataManager.Err)); return; } this.neuSpread1_Sheet1.Rows.Count = 0; if (ds.Tables[0].Rows.Count > 0) { this.neuSpread1_Sheet1.DataSource = ds; } try { if (this.rbPerson.Checked) { this.Sum(2, 3, 4, 5); } else { if (this.rbTerminalShow.Checked) { this.Sum(1, 2, 3, 4); } else { this.Sum(2, 3, 4, 5); } } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 初始化 /// </summary> protected void Init() { ArrayList al = new ArrayList(); #region 银行信息 Neusoft.HISFC.BizLogic.Manager.Constant constantManager = new Neusoft.HISFC.BizLogic.Manager.Constant(); al = constantManager.GetList("BANK"); if (al == null) { MessageBox.Show(Language.Msg("获取银行列表失败" + constantManager.Err)); return; } bankHelper.ArrayObject = al; #endregion #region 人员 Neusoft.HISFC.BizLogic.Manager.Person personManager = new Neusoft.HISFC.BizLogic.Manager.Person(); al = personManager.GetEmployeeAll(); if (al == null) { MessageBox.Show(Language.Msg("获取所有人员列表" + personManager.Err)); return; } this.personHelper.ArrayObject = al; #endregion #region 供应商 Neusoft.HISFC.BizLogic.Material.ComCompany companyManager = new Neusoft.HISFC.BizLogic.Material.ComCompany(); this.alCompany = companyManager.QueryCompany("1", "A"); if (this.alCompany == null) { MessageBox.Show(constantManager.Err); return; } #endregion #region 时间 Neusoft.FrameWork.Management.DataBaseManger databaseManager = new Neusoft.FrameWork.Management.DataBaseManger(); DateTime sysTime = databaseManager.GetDateTimeFromSysDateTime().Date.AddDays(1); this.dtBegin = sysTime.AddDays(-30); this.dtEnd = sysTime; this.privOper = databaseManager.Operator; this.payFlag = "'0','1'"; #endregion }
/// <summary> /// /// </summary> public void Query() { Neusoft.FrameWork.WinForms.Classes.Function.ShowWaitForm("ÕýÔÚ½øÐвéѯ...ÇëÉÔºò"); Application.DoEvents(); string exeSql = ""; if (this.ckAll.Checked) //È«²¿Ò©Æ· { exeSql = this.sql1; } else { if (this.cmbDrug.Tag != null && this.cmbDrug.Tag.ToString() != "") { exeSql = string.Format(this.sql2, this.cmbDrug.Tag.ToString()); } } Neusoft.FrameWork.Management.DataBaseManger dataManager = new Neusoft.FrameWork.Management.DataBaseManger(); DataSet ds = new DataSet(); if (dataManager.ExecQuery(exeSql, ref ds) == -1) { Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm(); MessageBox.Show(Language.Msg("Ö´ÐÐSqlÓï¾ä·¢Éú´íÎó" + dataManager.Err)); return; } //if (ds != null && ds.Tables.Count > 0) //{ // foreach (System.Data.DataRow dr in ds.Tables[0].Rows) // { // if (ds.Tables[0].Columns.Contains("¿â´æ¿ÆÊÒ")) // dr["¿â´æ¿ÆÊÒ"] = this.deptHelper.GetName(dr["¿â´æ¿ÆÊÒ"].ToString()); // } //} this.dv = new DataView(ds.Tables[0]); this.neuSpread1_Sheet1.DataSource = dv; this.SetFormat(); if (this.neuSpread1.ActiveSheet != this.neuSpread1_Sheet1) { this.neuSpread1.ActiveSheet = this.neuSpread1_Sheet1; } Neusoft.FrameWork.WinForms.Classes.Function.HideWaitForm(); }
/// <summary> /// 初始化 /// </summary> public virtual void InitDeptList() { try { Neusoft.FrameWork.Management.DataBaseManger dataManager = new Neusoft.FrameWork.Management.DataBaseManger(); this.ShowControlList(((Neusoft.HISFC.Models.Base.Employee)dataManager.Operator).Dept.ID); this.tvDeptTree1.IsShowPI = false; } catch (Exception ex) { MessageBox.Show("初始化配药台列表发生错误" + ex.Message); } }
/// <summary> /// 明细查询 /// </summary> /// <param name="iRowIndex">索引行</param> /// <returns>成功返回1 失败返回-1</returns> protected int QueryDetail(int iRowIndex) { if (this.neuSpread1.ActiveSheet == this.fpDetail) { return(-1); } if (iRowIndex == this.fpHead.Rows.Count - 1) { return(-1); } if (this.OperDept.ID == "") { return(-1); } if (this.fpHead.Rows.Count <= 0) { return(-1); } Neusoft.FrameWork.Management.DataBaseManger dataManager = new Neusoft.FrameWork.Management.DataBaseManger(); DateTime dtBegin = NConvert.ToDateTime(this.fpHead.Cells[iRowIndex, 0].Text); DateTime dtEnd = NConvert.ToDateTime(this.fpHead.Cells[iRowIndex, 1].Text); string exeDetail = string.Format(this.sqlDetail, this.OperDept.ID, dtBegin.ToString(), dtEnd.ToString()); DataSet ds = new DataSet(); if (dataManager.ExecQuery(exeDetail, ref ds) == -1) { MessageBox.Show(Language.Msg("获取月结明细发生错误")); return(-1); } if (ds != null && ds.Tables.Count > 0) { this.fpDetail.DataSource = ds; this.neuSpread1.ActiveSheet = this.fpDetail; } return(1); }
/// <summary> /// 初始化 /// </summary> public int Init() { Neusoft.FrameWork.Management.DataBaseManger dataBaseManager = new Neusoft.FrameWork.Management.DataBaseManger(); this.OperDept = ((Neusoft.HISFC.Models.Base.Employee)dataBaseManager.Operator).Dept; if (this.isOtherDrugDept) { Neusoft.HISFC.BizProcess.Integrate.Manager integrateManager = new Neusoft.HISFC.BizProcess.Integrate.Manager(); System.Collections.ArrayList al = integrateManager.GetDepartment(Neusoft.HISFC.Models.Base.EnumDepartmentType.P); foreach (Neusoft.HISFC.Models.Base.Department tempDept in al) { if (tempDept.ID == this.OperDept.ID) { al.Remove(tempDept); break; } } Neusoft.FrameWork.Models.NeuObject info = new Neusoft.FrameWork.Models.NeuObject(); if (Neusoft.FrameWork.WinForms.Classes.Function.ChooseItem(al, ref info) == 0) { return(-1); } else { this.OperDept = info; } } this.OperInfo = dataBaseManager.Operator; this.ApproveDept = ((Neusoft.HISFC.Models.Base.Employee)dataBaseManager.Operator).Dept; if (this.InitTerminal() == -1) { return(-1); } this.InitControlParm(); return(1); }
private void fpSpread1_CellDoubleClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e) { if (this.cmbMonthStoreInterval.Text == "") { return; } if (this.OperDept.ID == "") { return; } if (this.fpHead.Rows.Count <= 0) { return; } Neusoft.FrameWork.Management.DataBaseManger dataManager = new Neusoft.FrameWork.Management.DataBaseManger(); string strInterval = this.cmbMonthStoreInterval.Text; string strBegin = strInterval.Substring(0, strInterval.IndexOf("--")); string strEnd = strInterval.Substring(strInterval.IndexOf("--") + 2); string exeDetail = string.Format(this.sqlDetail, this.OperDept.ID, strBegin, strEnd); DataSet ds = new DataSet(); if (dataManager.ExecQuery(exeDetail, ref ds) == -1) { MessageBox.Show(Language.Msg("获取月结明细发生错误")); return; } if (ds != null && ds.Tables.Count > 0) { this.fpDetail.DataSource = ds; this.neuSpread1.ActiveSheet = this.fpDetail; } }
/// <summary> /// 初始化 /// </summary> public virtual void Init() { Neusoft.FrameWork.Management.DataBaseManger dataManager = new Neusoft.FrameWork.Management.DataBaseManger(); DateTime sysTime = dataManager.GetDateTimeFromSysDateTime(); if (this.rbOut.Checked) { this.dtpBegin.Value = sysTime.AddDays(-this.outIntervalDays); } if (this.rbIn.Checked) { this.dtpBegin.Value = sysTime.AddDays(-this.inIntervalDays); } if (this.rbStock.Checked) { this.dtpBegin.Value = sysTime.AddDays(-this.stockIntervalDays); } this.dtpEnd.Value = sysTime; #region 加载入出库/采购状态集 this.hsInOutState = new System.Collections.Hashtable(); this.hsInOutState.Add("0", "申请"); this.hsInOutState.Add("1", "审批"); this.hsInOutState.Add("2", "核准"); this.hsStockState = new System.Collections.Hashtable(); this.hsStockState.Add("0", "计划"); this.hsStockState.Add("1", "采购"); this.hsStockState.Add("2", "审核"); this.hsStockState.Add("3", "入库"); #endregion this.IsShowTypeCheck = false; this.Clear(); }
/// <summary> /// 获取床位日报信息 /// </summary> /// <param name="deptCode">科室编码 如科室编码为空则统计全院床位日报信息</param> /// <returns></returns> protected int QueryHosDayReport() { this.lbDate.Text = "日期:" + this.BeginDate.ToString("yyyy-MM-dd") + " 至 " + this.EndDate.ToString("yyyy-MM-dd"); this.lbDept.Text = "统计范围:全院"; #region 床位明细 转入、转出 string execDetailSql = @"select t.dept_code,t.stat_type,t.extend,count(*) --select * from met_cas_dayreport_detail t where t.stat_date >= to_date('{0}','yyyy-mm-dd') and t.stat_date <= to_date('{1}','yyyy-mm-dd') and t.valid_state = '0' group by t.dept_code,t.stat_type,t.extend order by t.dept_code"; execDetailSql = string.Format(execDetailSql, this.BeginDate.ToString("yyyy-MM-dd"), this.EndDate.ToString("yyyy-MM-dd")); DataSet ds = new DataSet(); Neusoft.FrameWork.Management.DataBaseManger dataManager = new Neusoft.FrameWork.Management.DataBaseManger(); if (dataManager.ExecQuery(execDetailSql, ref ds) == -1) { MessageBox.Show("床位日报查询发生错误" + dataManager.Err); return(-1); } this.neuSpread1_Sheet1.Rows.Count = 0; if (ds != null && ds.Tables[0].Rows.Count > 0) { #region 床位日报信息处理 string privDept = ""; int rowIndex = -1; foreach (DataRow dr in ds.Tables[0].Rows) { if (privDept != dr[0].ToString()) { rowIndex++; this.neuSpread1_Sheet1.Rows.Add(rowIndex, 1); this.neuSpread1_Sheet1.Cells[rowIndex, (int)ColumnEnum.ColDeptCode].Text = dr[0].ToString(); this.neuSpread1_Sheet1.Cells[rowIndex, 0].Text = this.deptHelper.GetName(dr[0].ToString()); privDept = dr[0].ToString(); } switch (dr[1].ToString()) { case "K": //接诊 case "C": //召回 decimal originalNum = NConvert.ToDecimal(this.neuSpread1_Sheet1.Cells[rowIndex, (int)ColumnEnum.ColInNum].Text); this.neuSpread1_Sheet1.Cells[rowIndex, (int)ColumnEnum.ColInNum].Text = (originalNum + NConvert.ToDecimal(dr[3])).ToString(); break; case "O": //出院 switch (dr[2].ToString()) { case "1": this.neuSpread1_Sheet1.Cells[rowIndex, (int)ColumnEnum.ColOut1].Text = NConvert.ToDecimal(dr[3]).ToString(); break; case "2": this.neuSpread1_Sheet1.Cells[rowIndex, (int)ColumnEnum.ColOut2].Text = NConvert.ToDecimal(dr[3]).ToString(); break; case "3": this.neuSpread1_Sheet1.Cells[rowIndex, (int)ColumnEnum.ColOut3].Text = NConvert.ToDecimal(dr[3]).ToString(); break; case "4": this.neuSpread1_Sheet1.Cells[rowIndex, (int)ColumnEnum.ColOut4].Text = NConvert.ToDecimal(dr[3]).ToString(); break; } decimal totNum = NConvert.ToDecimal(this.neuSpread1_Sheet1.Cells[rowIndex, (int)ColumnEnum.ColTot].Text); this.neuSpread1_Sheet1.Cells[rowIndex, (int)ColumnEnum.ColTot].Text = (totNum + NConvert.ToDecimal(dr[3])).ToString(); break; case "RI": //转入 this.neuSpread1_Sheet1.Cells[rowIndex, (int)ColumnEnum.ColTransferIn].Text = NConvert.ToDecimal(dr[3]).ToString(); break; case "RO": //转出 this.neuSpread1_Sheet1.Cells[rowIndex, (int)ColumnEnum.ColTransferOut].Text = NConvert.ToDecimal(dr[3]).ToString(); break; case "OF": //无费退院 decimal totOFNum = NConvert.ToDecimal(this.neuSpread1_Sheet1.Cells[rowIndex, (int)ColumnEnum.ColTot].Text); this.neuSpread1_Sheet1.Cells[rowIndex, (int)ColumnEnum.ColTot].Text = (totOFNum + NConvert.ToDecimal(dr[3])).ToString(); break; } } #endregion } #endregion #region 期初、期末人数 string execTotSql = @"select s.dept_code,sum(s.in_normal + s.in_return),sum(s.out_normal + s.out_withdrawal),sum(s.in_transfer), sum(s.out_transfer),sum(s.bed_stand), (select t.beginning_num from met_cas_inpatientdayreport t where t.dept_code=s.dept_code and t.date_stat=to_date('{0}','yyyy-mm-dd' )) as beginning_num, (select t.end_num from met_cas_inpatientdayreport t where t.dept_code=s.dept_code and t.date_stat=to_date('{1}','yyyy-mm-dd'))as end_num from met_cas_inpatientdayreport s where s.date_stat >= to_date('{0}','yyyy-mm-dd') and s.date_stat <= to_date('{1}','yyyy-mm-dd') group by s.dept_code order by s.dept_code"; execTotSql = string.Format(execTotSql, this.BeginDate.ToString("yyyy-MM-dd"), this.EndDate.ToString("yyyy-MM-dd")); DataSet dsTot = new DataSet(); if (dataManager.ExecQuery(execTotSql, ref dsTot) == -1) { MessageBox.Show("床位日报查询发生错误" + dataManager.Err); return(-1); } if (dsTot != null && dsTot.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsTot.Tables[0].Rows) { for (int i = 0; i < this.neuSpread1_Sheet1.Rows.Count; i++) { if (this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColDeptCode].Text == dr[0].ToString()) { //入院人数 this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColInNum].Text = NConvert.ToDecimal(dr[1]).ToString(); //出院人数 this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColTot].Text = NConvert.ToDecimal(dr[2]).ToString(); //转入人数 this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColTransferIn].Text = NConvert.ToDecimal(dr[3]).ToString(); //转出人数 this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColTransferOut].Text = NConvert.ToDecimal(dr[4]).ToString(); //实开床位 this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColStandardNum].Text = NConvert.ToDecimal(dr[5]).ToString(); //期初人数 this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColBeginNum].Text = NConvert.ToDecimal(dr[6]).ToString(); //期末人数 this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColEndNum].Text = NConvert.ToDecimal(dr[7]).ToString(); if (this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColInNum].Text == "0") { this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColInNum].Text = ""; } if (this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColTot].Text == "0") { this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColTot].Text = ""; } if (this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColTransferIn].Text == "0") { this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColTransferIn].Text = ""; } if (this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColTransferOut].Text == "0") { this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColTransferOut].Text = ""; } if (this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColStandardNum].Text == "0") { this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColStandardNum].Text = ""; } if (this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColBeginNum].Text == "0") { this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColBeginNum].Text = ""; } if (this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColEndNum].Text == "0") { this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColEndNum].Text = ""; } //if (this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColOutStat].Text == "0") // this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColOutStat].Text = ""; //if (this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColOutTot].Text == "0") // this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColOutTot].Text = ""; } } } } #endregion #region 出院总床日数 string execOutStatSql = @"select t.dept_code,sum(trunc(decode(s.IN_STATE,'N',s.oper_date,s.out_date)) - trunc(s.in_date)) from met_cas_dayreport_detail t,fin_ipr_inmaininfo s where t.stat_date >= to_date('{0}','yyyy-mm-dd') and t.stat_date <= to_date('{1}','yyyy-mm-dd') and t.valid_state = '0' and t.stat_type in ('O','OF') and t.inpatient_no = s.inpatient_no group by t.dept_code"; execOutStatSql = string.Format(execOutStatSql, this.BeginDate.ToString("yyyy-MM-dd"), this.EndDate.ToString("yyyy-MM-dd")); DataSet dsOutStat = new DataSet(); if (dataManager.ExecQuery(execOutStatSql, ref dsOutStat) == -1) { MessageBox.Show("床位日报查询发生错误" + dataManager.Err); return(-1); } if (dsOutStat != null && dsOutStat.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsOutStat.Tables[0].Rows) { for (int i = 0; i < this.neuSpread1_Sheet1.Rows.Count; i++) { if (this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColDeptCode].Text == dr[0].ToString()) { this.neuSpread1_Sheet1.Cells[i, (int)ColumnEnum.ColOutStat].Text = NConvert.ToDecimal(dr[1]).ToString(); } } } } #endregion #region 合计统计 this.SetSum((int)ColumnEnum.ColDept, (int)ColumnEnum.ColStandardNum, (int)ColumnEnum.ColBeginNum, (int)ColumnEnum.ColInNum, (int)ColumnEnum.ColTransferIn, (int)ColumnEnum.ColTransferOut, (int)ColumnEnum.ColTot, (int)ColumnEnum.ColOutTot, (int)ColumnEnum.ColOut1, (int)ColumnEnum.ColOut2, (int)ColumnEnum.ColOut3, (int)ColumnEnum.ColOut4, (int)ColumnEnum.ColEndNum, (int)ColumnEnum.ColOutStat); #endregion return(1); }
/// <summary> /// 明细查询 /// </summary> /// <param name="operCode">欲查询人员编码</param> protected void QueryDetail(string operCode) { this.neuSpread1_Sheet2.Rows.Count = 0; DateTime beginTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.dtBegin.Text); DateTime endTime = Neusoft.FrameWork.Function.NConvert.ToDateTime(this.dtEnd.Text); DateTime queryBeginDate = beginTime; DateTime queryEndDate = System.DateTime.MinValue; Neusoft.FrameWork.Management.DataBaseManger dataManager = new Neusoft.FrameWork.Management.DataBaseManger(); string sqlIndex = ""; if (this.isDrugTerminalQuery) { sqlIndex = "Pharmacy.Item.ClinicQuery.Druged.Oper.Detail"; } else { sqlIndex = "Pharmacy.Item.ClinicQuery.Send.Oper.Detail"; } string sql = ""; if (dataManager.Sql.GetSql(sqlIndex, ref sql) == -1) { MessageBox.Show(Language.Msg("根据索引获取Sql语句出错 \n" + dataManager.Err)); return; } DataSet dsDetail = null; string formatSql = ""; while (queryEndDate < endTime) { queryEndDate = queryBeginDate.Date.AddDays(1); if (queryEndDate > endTime) { queryEndDate = endTime; } formatSql = string.Format(sql, operCode, queryBeginDate, queryEndDate, this.cmbData.Tag.ToString()); DataSet ds = new DataSet(); if (dataManager.ExecQuery(formatSql, ref ds) == -1) { MessageBox.Show(Language.Msg("工作量查询出错 \n" + dataManager.Err)); return; } if (ds.Tables[0].Rows.Count > 0) { if (dsDetail == null) { dsDetail = ds.Clone(); } foreach (DataRow dr in ds.Tables[0].Rows) { dsDetail.Tables[0].Rows.Add(new object[] { dr[0], dr[1], dr[2], dr[3], dr[4], dr[5], dr[6] }); } } queryBeginDate = queryEndDate; } if (dsDetail != null && dsDetail.Tables.Count > 0 && dsDetail.Tables[0].Rows.Count > 0) { this.neuSpread1_Sheet2.DataSource = dsDetail; } if (this.neuSpread1.Sheets.Contains(this.neuSpread1_Sheet2)) { this.neuSpread1.ActiveSheet = this.neuSpread1_Sheet2; } }
/// <summary> /// 从company实体中取数据,赋予控件 /// </summary> private void SetCompany() { Neusoft.FrameWork.Management.DataBaseManger data = new Neusoft.FrameWork.Management.DataBaseManger(); if (this.company == null) { this.company = new Neusoft.HISFC.Models.Material.MaterialCompany(); } this.txtId.Text = this.company.ID; if (this.inputType == "I") { try { this.company.ID = comCompany.GetMaxCompanyID(((int)kind).ToString()); this.txtId.Text = this.company.ID; } catch { } } this.txtName.Text = company.Name; //公司名称 this.txtCoporation.Text = company.Coporation; //公司法人 this.txtAddress.Text = company.Address; //公司地址 this.txtTelCode.Text = company.TelCode; //公司电话 this.txtFaxCode.Text = company.FaxCode; //公司传真 this.txtNetAddress.Text = company.NetAddress; //公司网址 this.txtEMail.Text = company.EMail; //公司邮箱 this.txtLinkMan.Text = company.LinkMan; //联系人 this.txtLinkMail.Text = company.LinkMail; //联系人邮箱 this.txtLinkTel.Text = company.LinkTel; //联系人电话 this.txtGMPInfo.Text = company.GMPInfo; //GMP信息 this.txtGSPInfo.Text = company.GSPInfo; //GSP信息 this.txtISOInfo.Text = company.ISOInfo; //ISO信息 this.txtSpellCode.Text = company.SpellCode; //拼音码 this.txtWbCode.Text = company.WBCode; //五笔码 this.txtUserCode.Text = company.UserCode; //自定义码 this.txtOpenBank.Text = company.OpenBank; //开户银行 this.txtOpenAccounts.Text = company.OpenAccounts; //开户帐号 this.txtActualRate.Text = company.ActualRate.ToString(); //加价率 this.txtMemo.Text = company.Memo; //备注 if (company.BusinessDate == DateTime.MinValue) { this.dtBusinessDate.Value = DateTime.Now; } else { this.dtBusinessDate.Value = company.BusinessDate; } if (company.ManageDate == DateTime.MinValue) { this.dtManageDate.Value = DateTime.Now; } else { this.dtManageDate.Value = company.ManageDate; } if (company.DutyDate == DateTime.MinValue) { this.dtDutyDate.Value = DateTime.Now; } else { this.dtDutyDate.Value = company.DutyDate; } if (company.OrgDate == DateTime.MinValue) { this.dtOrgDate.Value = DateTime.Now; } else { this.dtOrgDate.Value = company.OrgDate; } if (company.IsValid) { this.chbIsValid.Checked = true; } else { this.chbIsValid.Checked = false; } }
/// <summary> /// 从控件中取数据,赋予company实体 /// </summary> private void GetCompany() { Neusoft.FrameWork.Management.DataBaseManger data = new Neusoft.FrameWork.Management.DataBaseManger(); string operCode = ((Neusoft.HISFC.Models.Base.Employee)data.Operator).ID; if (this.company == null) { this.company = new Neusoft.HISFC.Models.Material.MaterialCompany(); } this.company.ID = this.txtId.Text; if (this.inputType == "I") { try { this.company.ID = comCompany.GetMaxCompanyID(((int)kind).ToString()); this.txtId.Text = this.company.ID; } catch { } } company.Kind = ((int)this.kind).ToString(); company.Name = this.txtName.Text; //公司名称 company.Coporation = this.txtCoporation.Text; //公司法人 company.Address = this.txtAddress.Text; //公司地址 company.TelCode = this.txtTelCode.Text; //公司电话 company.FaxCode = this.txtFaxCode.Text; //公司传真 company.NetAddress = this.txtNetAddress.Text; //公司网址 company.EMail = this.txtEMail.Text; //公司邮箱 company.LinkMan = this.txtLinkMan.Text; //联系人 company.LinkMail = this.txtLinkMail.Text; //联系人邮箱 company.LinkTel = this.txtLinkTel.Text; //联系人电话 company.GMPInfo = this.txtGMPInfo.Text; //GMP信息 company.GSPInfo = this.txtGSPInfo.Text; //GSP信息 company.ISOInfo = this.txtISOInfo.Text; //ISO信息 company.SpellCode = this.txtSpellCode.Text; //拼音码 company.WBCode = this.txtWbCode.Text; //五笔码 company.UserCode = this.txtUserCode.Text; //自定义码 company.Type = ((int)this.type).ToString(); //公司类型 company.OpenBank = this.txtOpenBank.Text; //开户银行 company.OpenAccounts = this.txtOpenAccounts.Text; //开户帐号 company.ActualRate = Convert.ToDecimal(this.txtActualRate.Text); //加价率 if (this.chbIsValid.Checked) { company.IsValid = true; //有效 } else { company.IsValid = false; } company.Memo = this.txtMemo.Text; //备注 company.Oper.ID = operCode; company.OperTime = comCompany.GetDateTimeFromSysDateTime(); //{9E7FB328-89B3-4f43-A417-2EC3ACFC7093} //不用判断是否是最小的 //if (company.BusinessDate == DateTime.MinValue) //{ // company.BusinessDate = DateTime.Now; //} //else //{ company.BusinessDate = NConvert.ToDateTime(this.dtBusinessDate.Value); //} //if (company.ManageDate == DateTime.MinValue) //{ // company.ManageDate = DateTime.Now; //} //else //{ company.ManageDate = NConvert.ToDateTime(this.dtManageDate.Value); //} //if (company.DutyDate == DateTime.MinValue) //{ // company.DutyDate = DateTime.Now; //} //else //{ company.DutyDate = NConvert.ToDateTime(this.dtDutyDate.Value); //} //if (company.OrgDate == DateTime.MinValue) //{ // company.OrgDate = DateTime.Now; //} //else //{ company.OrgDate = NConvert.ToDateTime(this.dtOrgDate.Value); //} }