示例#1
0
 private void neuSpread1_Sheet1_CellChanged(object sender, FarPoint.Win.Spread.SheetViewEventArgs e)
 {
     try
     {
         if (e.Column == 0)
         {
             Neusoft.HISFC.Models.Order.Frequency f = new Neusoft.HISFC.Models.Order.Frequency();
             try
             {
                 f.ID = this.neuSpread1_Sheet1.Cells[e.Row, e.Column].Text;
                 if (f.Name != "")
                 {
                     this.neuSpread1_Sheet1.Cells[e.Row, 1].Text = f.Name;
                 }
             }
             catch { }
         }
         else if (e.Column == 3)
         {
             //更新用法ID
             this.neuSpread1_Sheet1.Cells[e.Row, e.Column - 1].Text = GetUsageCode(this.neuSpread1_Sheet1.Cells[e.Row, e.Column].Text);
         }
     }
     catch { }
 }
示例#2
0
        /// <summary>
        /// 根据传入行数返回对应实体
        /// </summary>
        /// <param name="i"></param>
        /// <returns></returns>
        private Neusoft.HISFC.Models.Order.Frequency GetObjFromRow(int i)
        {
            Neusoft.HISFC.Models.Order.Frequency f = new Neusoft.HISFC.Models.Order.Frequency();
            f.ID         = this.neuSpread1_Sheet1.Cells[i, 0].Text; //频次编码
            f.Name       = this.neuSpread1_Sheet1.Cells[i, 1].Text; //频次名称
            f.Usage.ID   = this.neuSpread1_Sheet1.Cells[i, 2].Text; //使用编码
            f.Usage.Name = this.neuSpread1_Sheet1.Cells[i, 3].Text; //使用名称
            f.Time       = this.neuSpread1_Sheet1.Cells[i, 4].Text; //使用时间
            f.Dept.ID    = this.DeptCode;

            /*
             * [2007/01/31] 原来没有检察.
             *
             * decimal a = Convert.ToDecimal(this.neuSpread1_Sheet1.Cells[i, 5].Text);
             * f.SortID = (int)a;
             *
             */
            //类型为文本型,所以如果输入的是非数字,那么按0处理
            try
            {
                decimal a = Convert.ToDecimal(this.neuSpread1_Sheet1.Cells[i, 5].Text);
                f.SortID = (int)a;
            }
            catch
            {
                f.SortID = 0;
            }

            return(f);
        }
示例#3
0
        /// <summary>
        ///已经使用的频次不能删除
        /// </summary>
        /// <param name="al"></param>
        /// <returns></returns>
        public int ExistFrequencyCounts(Neusoft.HISFC.Models.Order.Frequency frequency)
        {
            string strSql = "";

            if (this.Sql.GetSql("Manager.Frequency.DeleteCheck.1", ref strSql) == -1)
            {
                this.Err = "没有找到索引为: Manager.Frequency.DeleteCheck.1的SQL语句!";

                return(-1);
            }

            try
            {
                strSql = string.Format(strSql, frequency.ID);
            }
            catch (Exception ex)
            {
                this.Err = "赋值时候出错!" + ex.Message;
                this.WriteErr();

                return(-1);
            }

            return(Neusoft.FrameWork.Function.NConvert.ToInt32(this.ExecSqlReturnOne(strSql)));
        }
示例#4
0
        /// <summary>
        /// 删除方法
        /// </summary>
        /// <returns></returns>
        private int Del()
        {
            if (this.constantData.Tables[0].Rows.Count <= 0)
            {
                return(0);
            }
            int index = this.neuSpread1_Sheet1.ActiveRowIndex;

            if (index < 0)
            {
                return(0);
            }

            //将当前删除行转换成对象实体
            Neusoft.HISFC.Models.Order.Frequency frequency = GetObjFromRow(index);
            int returnvalue = manager.ExistFrequencyCounts(frequency);

            if (returnvalue >= 1)
            {
                MessageBox.Show("该频次已经使用,不能删除");
                return(-1);
            }


            if (MessageBox.Show("确认删除" + this.neuSpread1_Sheet1.Cells[index, 0].Text + "?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Yes)
            {
                ////将当前删除行转换成对象实体
                //Neusoft.HISFC.Models.Order.Frequency frequency = GetObjFromRow(index);
                //if (frequency.ID.Trim() != "" && frequency.ID != string.Empty)
                //{
                //    int returnvalue = manager.ExistFrequencyCounts(frequency);
                //if (returnvalue == 0)
                //{
                delAl.Add(frequency);
                this.neuSpread1_Sheet1.Rows[index].Remove();
                //}

                //if (returnvalue >= 1)
                //{
                //    MessageBox.Show("该频次已经使用,不能删除");
                //    return -1;
                //}


                //}
            }
            return(0);
        }
示例#5
0
        private ArrayList myList(string sql)
        {
            if (this.ExecQuery(sql) == -1)
            {
                return(null);
            }
            ArrayList al = new ArrayList();

            #region "接口"
            //接口名称 Manager.Frequency.GetList.1
            //<!--0 id频次id, 1 name频次名称, 2 deptcode, 3 执行时间点, 4 用法id, 5 用法name,6 SortID,
            //	 7 operator id, 8 operator name,9 operator time -->
            #endregion
            try
            {
                while (this.Reader.Read())
                {
                    Neusoft.HISFC.Models.Order.Frequency obj = new Neusoft.HISFC.Models.Order.Frequency();
                    obj.ID         = this.Reader[0].ToString();                                      //id频次id
                    obj.Name       = this.Reader[1].ToString();                                      //name频次名称
                    obj.Dept.ID    = this.Reader[2].ToString();                                      //deptcode
                    obj.Time       = this.Reader[3].ToString();                                      //执行时间点
                    obj.Usage.ID   = this.Reader[4].ToString();                                      //用法id
                    obj.Usage.Name = this.Reader[5].ToString();                                      //用法name
                    obj.SortID     = FrameWork.Function.NConvert.ToInt32(this.Reader[6].ToString()); //sortid
                    obj.User02     = this.Reader[7].ToString();                                      //operator id
                    //obj.User02 =this.Reader[8].ToString();//operator name
                    obj.User03 = this.Reader[9].ToString();                                          //operator time
                    al.Add(obj);
                }
                return(al);
            }
            catch (Exception ee)
            {
                this.Err = ee.Message;
                return(null);
            }
            finally
            {
                this.Reader.Close();
            }
        }
示例#6
0
        /// <summary>
        /// 获得特殊频次点和时间
        /// </summary>
        /// <param name="moOrder"></param>
        /// <param name="comNo"></param>
        /// <returns></returns>
        public Neusoft.HISFC.Models.Order.Frequency  GetDfqspecial(string moOrder, string comNo)
        {
            string strSql = "";

            Neusoft.HISFC.Models.Order.Frequency info = null;
            if (this.Sql.GetSql("Order.Dfqspecial.GetDfqspecial", ref strSql) == -1)
            {
                return(null);
            }

            try
            {
                strSql = string.Format(strSql, moOrder, comNo);
                if (this.ExecQuery(strSql) == -1)
                {
                    return(null);
                }
                if (this.Reader.Read())
                {
                    info        = new Neusoft.HISFC.Models.Order.Frequency();
                    info.ID     = Reader[0].ToString();
                    info.Name   = Reader[1].ToString();
                    info.Time   = Reader[2].ToString();
                    info.User01 = Reader[3].ToString();
                }
                else
                {
                    return(null);
                }
            }
            catch (Exception ee)
            {
                this.Err = ee.Message;
                info     = null;
            }
            finally
            {
                this.Reader.Close();
            }
            return(info);
        }
示例#7
0
        /// <summary>
        /// 获得当前所有行中对应的对象
        /// </summary>
        /// <returns></returns>
        private ArrayList AddRowDataToObj()
        {
            ArrayList al = new ArrayList();

            try
            {
                for (int i = 0; i < this.neuSpread1_Sheet1.Rows.Count; i++)
                {
                    Neusoft.HISFC.Models.Order.Frequency frequency = new Neusoft.HISFC.Models.Order.Frequency();
                    frequency.ID         = this.neuSpread1_Sheet1.Cells[i, 0].Text;
                    frequency.Name       = this.neuSpread1_Sheet1.Cells[i, 1].Text;
                    frequency.Usage.ID   = this.neuSpread1_Sheet1.Cells[i, 2].Text;
                    frequency.Usage.Name = this.neuSpread1_Sheet1.Cells[i, 3].Text;
                    frequency.Time       = this.neuSpread1_Sheet1.Cells[i, 4].Text;
                    frequency.Dept.ID    = this.DeptCode;

                    /* [2007/01/31] 没有类型检查
                     *
                     * decimal temp= Convert.ToDecimal(this.neuSpread1_Sheet1.Cells[i, 5].Text);
                     *
                     */
                    try
                    {
                        decimal temp = Convert.ToDecimal(this.neuSpread1_Sheet1.Cells[i, 5].Text);
                        frequency.SortID = (int)temp;
                    }
                    catch
                    {
                        frequency.SortID = 0;
                    }

                    al.Add(frequency);
                }
            }
            catch (Exception a)
            {
                MessageBox.Show(a.Message);
            }
            return(al);
        }
示例#8
0
        public int Del(object obj)
        {
            // TODO:  添加 Frequency.Del 实现
            #region "接口"
            //接口名称 Manager.Frequency.Update.1
            //<!--0 id频次id, 1 name频次名称, 2 deptcode, 3 执行时间点, 4 用法id, 5 用法name,6 SortID,
            //	 7 operator id, 8 operator name,9 operator time -->
            #endregion
            string strSql = "";
            if (this.Sql.GetSql("Manager.Frequency.Delete.1", ref strSql) == -1)
            {
                return(-1);
            }
            Neusoft.HISFC.Models.Order.Frequency o = obj as Neusoft.HISFC.Models.Order.Frequency;
            try
            {
                string[] s = new string[10];
                try
                {
                    s[0] = o.ID;                   //id频次id
                }
                catch {}
                try
                {
                    s[1] = o.Name;                   //name频次名称
                }
                catch {}
                try
                {
                    s[2] = o.Dept.ID;                  //deptcode
                }
                catch {}
                try
                {
                    s[3] = o.Time;                   //执行时间点
                }
                catch {}
                try
                {
                    s[4] = o.Usage.ID;                   //用法id
                }
                catch {}
                try
                {
                    s[5] = o.Usage.Name;                     //用法name
                }
                catch {}
                try
                {
                    s[6] = o.SortID.ToString();                     //SortID
                }
                catch {}
                try
                {
                    s[7] = this.Operator.ID;                     //operator id
                }
                catch {}
                try
                {
                    s[8] = this.Operator.Name;                   //operator name
                }
                catch {}
                try
                {
                    s[9] = this.GetSysDate();                  //operator time
                }
                catch {}
                strSql = string.Format(strSql, s);
            }
            catch (Exception ex)
            {
                this.Err = "赋值时候出错!" + ex.Message;
                this.WriteErr();
                return(-1);
            }
            if (this.ExecQuery(strSql) < 0)
            {
                return(-1);
            }

            return(0);
        }
示例#9
0
        public Neusoft.FrameWork.Models.NeuObject Get(object obj, string DeptCode)
        {
            //选择
            string sql = "";

            Neusoft.HISFC.Models.Order.Frequency f = null;
            try
            {
                f = (Neusoft.HISFC.Models.Order.Frequency)obj;
            }
            catch { this.Err = "参数类型不是频次!"; return(null); }

            if (this.Sql.GetSql("Manager.Frequency.Get.1", ref sql) == -1)
            {
                return(null);
            }
            try
            {
                sql = string.Format(sql, f.ID, f.Usage.ID, f.Dept.ID);
            }
            catch (Exception ex)
            {
                this.Err = ex.Message;
                this.WriteErr();
                return(null);
            }

            ArrayList al = new ArrayList();

            al = myList(sql);
            if (al == null || al.Count == 0)
            {
                this.Err = "没有找到频次" + f.ID + "的时间点设置!";
                this.WriteErr();
                return(null);
            }
            if (al.Count == 1)
            {
                return(al[0] as Neusoft.FrameWork.Models.NeuObject);               //一个返回当前
            }

            int fit = 0;

            for (int i = 0; i < al.Count; i++)
            {
                Neusoft.HISFC.Models.Order.Frequency tmpf = (Neusoft.HISFC.Models.Order.Frequency)al[i];
                if (tmpf.Dept.ID == DeptCode)
                {
                    fit = i;
                }
                if (tmpf.Usage.ID == f.Usage.ID)
                {
                    fit = i;
                }
                if (tmpf.Usage.ID == f.Usage.ID && tmpf.Dept.ID == DeptCode)
                {
                    fit = i;
                    break;
                }
            }

            // TODO:  添加 Frequency.Get 实现
            return(al[fit] as Neusoft.FrameWork.Models.NeuObject);            //一个返回当前;
        }
示例#10
0
        /// <summary>
        /// 判断组合医嘱
        /// </summary>
        /// <param name="fpSpread1"></param>
        /// <returns></returns>
        public int ValidComboOrder(Neusoft.HISFC.BizLogic.Order.Order orderManagement)
        {
            Neusoft.HISFC.Models.Order.Frequency frequency = null;
            Neusoft.FrameWork.Models.NeuObject   usage     = null;
            Neusoft.FrameWork.Models.NeuObject   exeDept   = null;
            string   sample     = "";
            decimal  amount     = 0;
            int      sysclass   = -1;
            string   sysClassID = string.Empty;
            DateTime dtBegin    = new DateTime();

            for (int i = 0; i < fpSpread1.ActiveSheet.Rows.Count; i++)
            {
                if (fpSpread1.ActiveSheet.IsSelected(i, 0))
                {
                    Neusoft.HISFC.Models.Order.Inpatient.Order o = this.GetObjectFromFarPoint(i, fpSpread1.ActiveSheetIndex, orderManagement);

                    if (o.Status != 0)
                    {
                        MessageBox.Show(string.Format("不符合组合条件,项目{0}状态不允许修改,请重新选择!", o.Item.Name));
                        return(-1);
                    }
                    if (frequency == null)
                    {
                        frequency  = o.Frequency.Clone();
                        usage      = o.Usage.Clone();
                        sysclass   = o.Item.SysClass.ID.GetHashCode();
                        sysClassID = o.Item.SysClass.ID.ToString();
                        exeDept    = o.ExeDept.Clone();
                        sample     = o.Sample.Name;
                        amount     = o.Qty;
                        dtBegin    = o.BeginTime;
                    }
                    else
                    {
                        o.BeginTime = dtBegin;
                        if (o.Frequency.ID != frequency.ID)
                        {
                            MessageBox.Show("频次不同,不可以组合用!");
                            return(-1);
                        }
                        //if (o.Item.IsPharmacy)		//只对药品判断用法是否相同
                        if (o.Item.ItemType == Neusoft.HISFC.Models.Base.EnumItemType.Drug)             //只对药品判断用法是否相同
                        {
                            if (o.Item.SysClass.ID.ToString() != "PCC" && o.Usage.ID != usage.ID)
                            {
                                MessageBox.Show("用法不同,不可以组合用!");
                                return(-1);
                            }
                            #region {B423CB4A-8E22-4aad-B847-76AAC7F9AD74}
                            if (sysClassID == "PCC")
                            {
                                if (o.Item.SysClass.ID.ToString() != sysClassID)
                                {
                                    MessageBox.Show("草药不可以和其他药品组合用!");
                                    return(-1);
                                }
                            }
                            else
                            {
                                if (o.Item.SysClass.ID.ToString() == "PCC")
                                {
                                    MessageBox.Show("草药不可以和其他药品组合用!");
                                    return(-1);
                                }
                            }
                            #endregion
                        }
                        else
                        {
                            if (o.Item.SysClass.ID.ToString() == "UL")//检验
                            {
                                if (o.Qty != amount)
                                {
                                    MessageBox.Show("检验数量不同,不可以组合用!");
                                    return(-1);
                                }
                                if (o.Sample.Name != sample)
                                {
                                    MessageBox.Show("检验样本不同,不可以组合用!");
                                    return(-1);
                                }
                            }
                        }


                        if (o.ExeDept.ID != exeDept.ID)
                        {
                            MessageBox.Show("执行科室不同,不能组合使用!", "提示");
                            return(-1);
                        }
                    }
                }
            }
            return(0);
        }