public int AddPacking(int DecoctingNum, string PackPer)
        {
            int end = 0;

            /// <summary>
            /// 添加包装信息
            /// </summary>
            /// <param name="einfo"></param>
            /// <returns></returns>
            ///
            #region 当没有收到煎药完成指令和开始排液指令,触发判断煎药是否完成未完成将煎药时间设置为开始煎药时间+25MIN+煎药方案时间
            try
            {
                //包装流程修改,若煎药流程结束,扫码开始包装,包装代数为实际代数+多包代数。
                //多包代数
                string        str11    = "select top 1 package_machine_nums from dbo.tb_sys_add_setting";
                SqlDataReader sr11     = db.get_Reader(str11);
                int           more_num = 0;
                if (sr11.Read())
                {
                    more_num = Convert.ToInt32(sr11["package_machine_nums"].ToString());
                    //  string sql12 = "update prescription set packagenum =packagenum+" + more_num.ToString() + " where id = '" + DecoctingNum.ToString().Trim() + "'";//+" and "+"'"++"'";
                    //  db.cmd_Execute(sql12);
                    string sql13 = "update  tisaneinfo  set tisanestatus ='1' where pid ='" + DecoctingNum.ToString().Trim() + "'";
                    db.cmd_Execute(sql13);
                }
                sr11.Close();
                db.sp_Execute_no_return("sp_auto_tisane", DecoctingNum);
            }
            catch
            {
                end = 0;
            }
            #endregion

            String sql = "";

            string        per        = PackPer.Substring(6);
            string        employeeid = "";
            string        str7       = "select id from employee where EmNumAName ='" + PackPer + "'";
            SqlDataReader sr7        = db.get_Reader(str7);

            if (sr7.Read())
            {
                employeeid = sr7["id"].ToString();
            }

            string str = "select pid from tisaneinfo where  tisanestatus = 1 and  pid = '" + DecoctingNum + "'";
            //and pid not in (select pid from InvalidPrescription)
            SqlDataReader   sr  = db.get_Reader(str);
            System.DateTime now = new System.DateTime();
            now = System.DateTime.Now;
            #region if 1
            if (sr.Read())
            {
                string result = sr["pid"].ToString();
                int    a      = Convert.ToInt32(result);

                string        str1 = "select * from Packing where DecoctingNum = '" + a + "'";
                SqlDataReader sr1  = db.get_Reader(str1);
                #region 是否包装判断
                if (sr1.Read())
                {
                    string        start     = "select Starttime from Packing where DecoctingNum = '" + a + "'";
                    SqlDataReader starttime = db.get_Reader(start);

                    string starttime2 = "";
                    if (starttime.Read())
                    {
                        string        tate  = "select Fpactate from Packing where DecoctingNum = '" + a + "'";
                        SqlDataReader tate1 = db.get_Reader(tate);

                        if (tate1.Read())
                        {
                            if (tate1["Fpactate"].ToString() == "0")
                            {
                                starttime2 = starttime["Starttime"].ToString();
                                //获取包装时间
                                DateTime starttime1 = Convert.ToDateTime(starttime2);                                                                                                 //开始时间
                                string   now1       = now.ToString("yyyy-MM-dd HH:mm:ss");
                                DateTime d3         = Convert.ToDateTime(now1);                                                                                                       //把当前时间转变为datetime
                                TimeSpan d4         = d3.Subtract(starttime1);                                                                                                        //开始时间-当前时间

                                int    fpack    = Convert.ToInt32(d4.Days.ToString()) * 24 * 60 + Convert.ToInt32(d4.Hours.ToString()) * 60 + Convert.ToInt32(d4.Minutes.ToString()); //差值转换为分钟数
                                string packtime = fpack.ToString();
                                //sql = "INSERT INTO [Packing](DecoctingNum,packtime,Fpactate) VALUES('" + a + "','" + fpack + "','" + 2 + "')";
                                sql = "Update Packing set PacTime='" + now + "',  Fpactate ='1' where  DecoctingNum =  '" + a + "'";
                                if (db.cmd_Execute(sql) == 1)
                                {
                                    string sql1 = "update prescription set curstate = '包装完成'  where id = '" + a + "'";
                                    if (db.cmd_Execute(sql1) == 1)
                                    {
                                        string sql2 = "INSERT INTO [Delivery](DecoctingNum,Sendstate) VALUES('" + a + "','0')";
                                        if (db.cmd_Execute(sql2) == 1)
                                        {
                                            string        str5 = "select machineid from tisaneunit where pid = '" + DecoctingNum + "'";
                                            SqlDataReader sr01 = db.get_Reader(str5);
                                            if (sr01.Read())
                                            {
                                                string machineid = sr01["machineid"].ToString();
                                                //更改包装机状态
                                                string        sq6 = "select unitnum from machine where id = '" + machineid + "'";
                                                SqlDataReader sr6 = db.get_Reader(sq6);
                                                if (sr6.Read())
                                                {
                                                    string unitnum = sr6["unitnum"].ToString();
                                                    string sq7     = "update machine set status ='空闲' where unitnum = '" + unitnum + "' and mark =1";
                                                    db.cmd_Execute(sq7);
                                                }
                                            }
                                        }
                                    }
                                }
                            }
                            else
                            {
                                sql = "";
                            }
                        }
                    }
                }
                #endregion

                #region 未开始包装判断
                else
                {
                    string sql2 = "INSERT INTO [Packing](DecoctingNum,Starttime,Fpactate,Pacpersonnel,employeeid) VALUES('" + a + "','" + now + "','" + 0 + "','" + per + "','" + employeeid + "')";
                    //开始包装
                    BaseInfo.Insert_PackCmd(now, db, DecoctingNum.ToString());
                    //SqlDataReader tate13 = db.get_Reader(sql2);
                    if (db.cmd_Execute(sql2) == 1)
                    {
                        sql = "update prescription set doperson ='" + per + "',curstate = '开始包装'  where id = '" + a + "'";
                        db.cmd_Execute(sql);
                        // sql = "update prescription set doperson ='" + per + "',curstate = '开始包装'  where id = '" + a + "'";
                        //db.cmd_Execute(sql2);


                        //把机组表里的包装状态设为1
                        string   now1 = now.ToString("yyyy-MM-dd HH:mm:ss");
                        DateTime d3   = Convert.ToDateTime(now1);//把当前时间转变为datetime

                        sql = "update tisaneunit set packstatus = 1,endDate ='" + d3 + "' where pid ='" + a + "'";
                        db.cmd_Execute(sql);


                        //更改煎药机状态为空闲
                        //string changetisanestatu = "update machine set status ='空闲' where id = (select machineid from tisaneunit where pid = '"+a+"')";
                        // db.cmd_Execute(changetisanestatu);

                        //更改包装机状态为忙碌
                        //  string changepackstatu = "update machine set status ='忙碌' where id = (select machineid from tisaneunit where pid = '" + a + "')";
                        // db.cmd_Execute(changepackstatu);



                        string        machineid = "";
                        string        unitnum   = "";
                        string        str5      = "select machineid from tisaneunit where pid = '" + DecoctingNum + "'";
                        SqlDataReader sr5       = db.get_Reader(str5);


                        if (sr5.Read())
                        {
                            machineid = sr5["machineid"].ToString();
                            //更改包装机状态
                            string        sq6 = "select unitnum from machine where id = '" + machineid + "'";
                            SqlDataReader sr6 = db.get_Reader(sq6);
                            if (sr6.Read())
                            {
                                unitnum = sr6["unitnum"].ToString();
                                string sq7 = "update machine set status ='忙碌' where unitnum = '" + unitnum + "'and mark =1";
                                db.cmd_Execute(sq7);
                            }
                        }

                        string sql9 = "update machine set status ='空闲' where id = '" + machineid + "'";
                        db.cmd_Execute(sql9);
                    }
                }
                #endregion
            }
            #endregion
            else
            {
                sql = "";
            }

            if (sql == "")
            {
                end = 0;
            }
            else
            {
                // end = db.cmd_Execute(sql);
                end = 1;
            }
            return(end);
        }