Beispiel #1
0
        //出药
        private void btOut_Click(object sender, RoutedEventArgs e)
        {
            Cursor = Cursors.Wait;
            if (lvOut.Items.Count > 0)
            {
                PLC_Tcp_AP.MovePos type = PLC_Tcp_AP.MovePos.Top;
                switch (cbOutPosition.SelectedIndex)
                {
                case 1:
                    type = PLC_Tcp_AP.MovePos.Up;
                    break;

                case 2:
                    type = PLC_Tcp_AP.MovePos.Down;
                    break;
                }
                DataTable dtTemp = new DataTable();
                dtTemp.Columns.Add("PosCode");
                dtTemp.Columns.Add("Num");
                OutPos[] ops = lvOut.ItemsSource as OutPos[];
                foreach (OutPos op in ops)
                {
                    DataRow row = dtTemp.NewRow();
                    row[0] = op.PosCode;
                    row[1] = op.Num;
                    dtTemp.Rows.Add(row);
                }
                dtTemp.DefaultView.Sort = "PosCode";
                DataTable dtOut = dtTemp.DefaultView.ToTable();

                OutDrug_AP od = new OutDrug_AP(type, dtOut, false, "", 0, null);
                od.GoOut();

                Thread.Sleep(3000);
                while (OutDrug_AP.IsOut)
                {
                    Thread.Sleep(500);
                }
                //lvOut.ItemsSource = null;
                ShowDrug(tbCode.Text.Trim());
                Cursor = null;
            }
        }
Beispiel #2
0
        //出药
        private void GoOut()
        {
            if (!IsOut)
            {
                IsOut = true;

                string wins = GetWins(Config.Soft.MacCode);
                string sql  = "select top 1 prescno,windowno,patname from pat_prescinfo where windowno in ({0}) and doflag in('W','D') and paytime>=convert(varchar(100),getdate(),23) order by toptime desc,paytime";
                sql = string.Format(sql, wins);
                DataTable dtDoing;
                csSql.ExecuteSelect(sql, Config.Soft.ConnString, out dtDoing);
                if (dtDoing.Rows.Count > 0)
                {
                    string prescNo  = dtDoing.Rows[0]["prescno"].ToString();
                    string windowNo = dtDoing.Rows[0]["windowno"].ToString();
                    string patname  = dtDoing.Rows[0]["patname"].ToString();
                    //正在出药(D)
                    UpdatePrescStatus(prescNo, "D");
                    //快发内药品明细
                    sql = @"select pd.drugonlycode,sum(drugnum) as num,drugunit,drugpacknum,drugpackunit,drugsplitnum,drugsplitunit from pat_druginfo pd
left join drug_info di on di.drugonlycode=pd.drugonlycode
where prescno='{0}' and  pd.drugonlycode in
(
select drugonlycode from drug_pos where maccode='{1}' 
)
group by pd.drugonlycode,drugunit,drugpacknum,drugpackunit,drugsplitnum,drugsplitunit";
                    sql = string.Format(sql, prescNo, Config.Soft.MacCode);
                    DataTable dtDrug;
                    csSql.ExecuteSelect(sql, Config.Soft.ConnString, out dtDrug);
                    if (dtDrug != null && dtDrug.Rows.Count > 0)//分配批次
                    {
                        int pc    = 1;
                        int pcNum = Config.Mac_A.PCNum;
                        foreach (DataRow dr_Drug in dtDrug.Rows)
                        {
                            string drugonlycode = dr_Drug["drugonlycode"].ToString().Trim();
                            int    drugnum      = GetNumInt(int.Parse(dr_Drug["num"].ToString().Trim()), dr_Drug["drugunit"].ToString().Trim(), int.Parse(dr_Drug["drugpacknum"].ToString().Trim()), dr_Drug["drugpackunit"].ToString().Trim());
                            if (drugnum > 0)
                            {
                                if (drugnum > Config.Mac_A.MaxNum)//超出出药上限(B)
                                {
                                    UpdateDrugStatus(prescNo, drugonlycode, "B");
                                }
                                else
                                {
                                    sql = @"select sum(isnull(drugnum,0)-isnull(drugnummin,0)) num from drug_pos where maccode='{0}' and drugonlycode='{1}' and errorNum<3 group by drugonlycode";
                                    sql = string.Format(sql, Config.Soft.MacCode, drugonlycode);
                                    int    numSum = 0;
                                    string value;
                                    csSql.ExecuteScalar(sql, Config.Soft.ConnString, out value);
                                    if (!string.IsNullOrEmpty(value))
                                    {
                                        numSum = int.Parse(value);
                                    }
                                    if (numSum < drugnum)//缺药(S)
                                    {
                                        UpdateDrugStatus(prescNo, drugonlycode, "S");
                                    }
                                    else
                                    {
                                        if (drugnum > pcNum)
                                        {
                                            pc++;
                                            pcNum = Config.Mac_A.PCNum - drugnum;
                                        }
                                        else
                                        {
                                            pcNum -= drugnum;
                                        }
                                        //分配批次
                                        sql = "update pat_druginfo set outpc={0},pcflag='N' where prescno='{1}' and drugonlycode='{2}'";
                                        sql = string.Format(sql, pc, prescNo, drugonlycode);
                                        csSql.ExecuteSql(sql, Config.Soft.ConnString);
                                    }
                                }
                            }
                            else
                            {
                                //机外
                                UpdateDrugStatus(prescNo, drugonlycode, "E");
                            }
                        }
                        //判断出药口位置
                        PLC_Tcp_AP.MovePos type = PLC_Tcp_AP.MovePos.Down;
                        sql = "select outposition from sys_window_mac where windowno={0} and maccode='{1}'";
                        sql = string.Format(sql, windowNo, Config.Soft.MacCode);
                        string v;
                        csSql.ExecuteScalar(sql, Config.Soft.ConnString, out v);
                        switch (v)
                        {
                        case "T":
                            type = PLC_Tcp_AP.MovePos.Top;
                            break;

                        case "U":
                            type = PLC_Tcp_AP.MovePos.Up;
                            break;

                        case "D":
                            type = PLC_Tcp_AP.MovePos.Down;
                            break;
                        }
                        //逐个批次出药
                        for (int p = 1; p <= pc; p++)
                        {
                            while (OutDrug_AP.IsOut)
                            {
                                Thread.Sleep(500);
                            }
                            sql = @"select drugonlycode,sum(drugnum) as num from pat_druginfo
where prescno='{0}' and outpc='{1}' and drugonlycode in
(
select drugonlycode from drug_pos  
where maccode='{2}' 
)
group by drugonlycode";
                            sql = string.Format(sql, prescNo, p, Config.Soft.MacCode);
                            DataTable dtPC;
                            csSql.ExecuteSelect(sql, Config.Soft.ConnString, out dtPC);
                            if (dtPC != null && dtPC.Rows.Count > 0)
                            {
                                DataTable dtOut = GetOutPos(dtPC);

                                OutDrug_AP od = new OutDrug_AP(type, dtOut, true, prescNo, p, dtPC);
                                od.GoOut();

                                //批次出药开始
                                sql = "update pat_druginfo set pcflag='D',dotime=getdate() where prescno='{0}' and outpc='{1}'";
                                sql = string.Format(sql, prescNo, p);
                                csSql.ExecuteSql(sql, Config.Soft.ConnString);
                                Thread.Sleep(1000);
                            }

                            Thread.Sleep(1000);
                            while (OutDrug_AP.IsOut)
                            {
                                Thread.Sleep(500);
                            }
                            //批次出药完成
                            sql = "update pat_druginfo set pcflag='Y',dotime=getdate() where prescno='{0}' and outpc='{1}'";
                            sql = string.Format(sql, prescNo, p);
                            csSql.ExecuteSql(sql, Config.Soft.ConnString);
                            Thread.Sleep(1000);
                        }
                    }
                    //结束出药(4)
                    UpdatePrescStatus(prescNo, "O");
                    isWait = true;
                    wait   = Config.Mac_A.PrescWait;
                    timer_Wait.Start();
                    IsOut = false;
                }
                IsOut = false;
            }
        }