예제 #1
0
        public static List <SelectListItem> GetUserId()
        {
            //
            List <SelectListItem> ListItem = new List <SelectListItem>();
            string    unitid    = GAccount.GetAccountInfo().UnitID;
            string    rolenames = GAccount.GetAccountInfo().RoleNames;
            DataTable dtDesc    = PpPro.GetUserId(" and Deptid='" + unitid + "' and RoleNames='" + rolenames + "'");

            if (dtDesc == null)
            {
                return(ListItem);
            }
            SelectListItem SelListItem = new SelectListItem();

            SelListItem.Value = "";
            SelListItem.Text  = "请选择";
            ListItem.Add(SelListItem);
            for (int i = 0; i < dtDesc.Rows.Count; i++)
            {
                SelListItem       = new SelectListItem();
                SelListItem.Value = dtDesc.Rows[i]["UserId"].ToString();
                SelListItem.Text  = dtDesc.Rows[i]["UserName"].ToString();
                ListItem.Add(SelListItem);
            }
            return(ListItem);
        }
예제 #2
0
        public static string GetSPid(string folderBack)
        {
            string[]    arr     = folderBack.Split('/');
            Acc_Account account = GAccount.GetAccountInfo();
            int         unitId  = Convert.ToInt16(account.UnitID);
            string      strPID  = "";
            string      strYMD  = DateTime.Now.ToString("yyMMdd");

            string    strSelPID = "select SPID, SPidNo from [" + arr[0] + "].." + arr[6] + " where DateRecord='" + strYMD + "'";
            DataTable dtPMaxID  = SQLBase.FillTable(strSelPID);
            int       intNewID  = 0;

            if (dtPMaxID == null)
            {
                return(strPID);
            }
            if (dtPMaxID.Rows.Count == 0)
            {
                string strInsertID = "insert into [" + arr[0] + "].." + arr[6] + " (SPID,SPidNo,DateRecord) values('P',0,'" + strYMD + "')";
                SQLBase.ExecuteNonQuery(strInsertID);
                intNewID = 0;
            }
            else
            {
                intNewID = Convert.ToInt32(dtPMaxID.Rows[0]["SPidNo"]);
            }

            intNewID++;
            string strUpdateID = "update [" + arr[0] + "].." + arr[6] + " set SPidNo='" + intNewID + "' where DateRecord ='" + strYMD + "'";

            SQLBase.ExecuteNonQuery(strUpdateID);

            strPID = dtPMaxID.Rows[0]["SPID"].ToString() + DateTime.Now.ToString("yyMMdd") + GFun.GetNum(unitId, 4) + GFun.GetNum(intNewID, 4);
            return(strPID);
        }
예제 #3
0
        //
        public static System.Data.DataTable GetBasicContent()
        {
            Acc_Account account = GAccount.GetAccountInfo();
            string      strSql  = "select distinct Type as SID,TypeDesc as Text from tk_ConfigContent where validate='v' ";
            DataTable   dt      = SQLBase.FillTable(strSql, "FlowMeterDBCnn");

            return(dt);
        }
예제 #4
0
        public static DataTable GetConfigCont(string Type)
        {
            Acc_Account account = GAccount.GetAccountInfo();
            string      strSql  = "select SID,Text from tk_ConfigContent where Type = '" + Type + "' and Validate = 'v' and UnitID = '" + account.UnitID + "'";
            DataTable   dt      = SQLBase.FillTable(strSql, "SupplyCnn");

            return(dt);
        }
예제 #5
0
        public static DataTable GetUser()
        {
            Acc_Account account = GAccount.GetAccountInfo();
            string      unitid  = account.UnitID;
            string      strSql  = "select UserId,UserName,ExJob from [BJOI_UM]..UM_UserNew where DeptId = '" + unitid + "' and ExJob != ''";
            DataTable   dt      = SQLBase.FillTable(strSql);

            return(dt);
        }
예제 #6
0
        public static int InsertApproval(string PID, string RelevanceID, string webkey, string folderBack, ref string a_strErr)
        {
            int         intInsertBas = 0;
            int         intUpdateBas = 0;
            int         intLog       = 0;
            Acc_Account account      = GAccount.GetAccountInfo();
            string      createUser   = account.UserID.ToString();
            SQLTrans    sqlTrans     = new SQLTrans();

            sqlTrans.Open();
            string[] arr = folderBack.Split('/');
            // BGOI_BasMan/tk_SApproval/tk_SupplierBas/SID/10/52/tk_PID/54/tk_UserLog
            string strInsertBas = "insert into [" + arr[0] + "].." + arr[1] + " (PID,RelevanceID,ApprovalContent,CreateUser,CreateTime,Validate,State,Job,ApprovalPersons,ApprovalLevel,AppType)"
                                  + " select '" + PID + "','" + RelevanceID + "','" + webkey + "','" + createUser + "','" + DateTime.Now + "','v','0',Duty,UserId,[Level],AppType from [BJOI_UM]..UM_Examine where BuType = '" + webkey + "'";

            string strUpdateBas = "";

            if (arr[2].IndexOf("..") > 0)
            {
                strUpdateBas = "update " + arr[2] + " set State = '" + arr[5] + "' where " + arr[3] + " = '" + RelevanceID + "'";
            }
            else
            {
                strUpdateBas = "update [" + arr[0] + "].." + arr[2] + " set State = '" + arr[5] + "' where " + arr[3] + " = '" + RelevanceID + "'";
            }

            string strInsertLog = "insert into [" + arr[0] + "].." + arr[8] + " values ('" + RelevanceID + "','提交" + webkey + "审批操作','提交" + webkey + "审批成功','" + DateTime.Now + "','" + account.UserName + "','" + webkey + "')";

            try
            {
                if (strInsertBas != "")
                {
                    intInsertBas = sqlTrans.ExecuteNonQuery(strInsertBas, CommandType.Text, null);
                }
                if (strUpdateBas != "")
                {
                    intUpdateBas = sqlTrans.ExecuteNonQuery(strUpdateBas, CommandType.Text, null);
                }
                if (strInsertLog != "")
                {
                    intLog = sqlTrans.ExecuteNonQuery(strInsertLog, CommandType.Text, null);
                }
                sqlTrans.Close(true);
            }
            catch (SqlException e)
            {
                sqlTrans.Close(false);
                a_strErr = e.Message;
                return(-1);
            }

            return(intInsertBas + intUpdateBas);
        }
예제 #7
0
        public static string GetTopJHID()
        {
            string    strID    = "";
            string    strD     = "JH" + "-" + DateTime.Now.ToString("yyyyMMdd");
            string    UnitID   = string.Format("{0:D4}", Convert.ToInt32(GAccount.GetAccountInfo().UnitID));
            string    strSqlID = "select max(JHID) from [BGOI_Produce].[dbo].[tk_Product_Plan]";
            DataTable dtID     = SQLBase.FillTable(strSqlID);

            if (dtID != null && dtID.Rows.Count > 0)
            {
                strID = dtID.Rows[0][0].ToString();
                if (strID == "" || strID == null)
                {
                    strD = strD + "-" + UnitID + "-" + "001";
                }
                else
                {
                    int num = Convert.ToInt32(strID.Substring(strID.Length - 3, 3));

                    string stryyyyMMdd = strID.Substring(3, 8);
                    if (DateTime.Now.ToString("yyyyMMdd") == stryyyyMMdd)
                    {
                        if (num < 9)
                        {
                            strD = strD + "-" + UnitID + "-" + "00" + (num + 1);
                        }
                        else if (num < 99 && num >= 9)
                        {
                            strD = strD + "-" + UnitID + "-" + "0" + (num + 1);
                        }

                        else
                        {
                            strD = strD + "-" + UnitID + "-" + (num + 1);
                        }
                    }
                    else
                    {
                        strD = strD + "-" + UnitID + "-" + "001";
                    }
                }
            }
            else
            {
                strD = strD + "-" + UnitID + "-" + "001";
            }
            return(strD);
        }
예제 #8
0
        // 确认新增小组
        public static int InsertGroup(string text, ref string a_strErr)
        {
            int      intInsert = 0;
            SQLTrans sqlTrans  = new SQLTrans();

            sqlTrans.Open("AccountCnn");
            string    strSql  = "select top 1 GroupID,DeptId from UM_Group  where Validate='v' order by GroupID desc ";
            DataTable dt      = SQLBase.FillTable(strSql, "AccountCnn");
            int       GroupID = 0;
            string    DeptID  = "";

            if (dt.Rows.Count > 0)
            {
                GroupID = Convert.ToInt32(dt.Rows[0]["GroupID"].ToString()) + 1;
                DeptID  = dt.Rows[0]["DeptId"].ToString();
            }
            else
            {
                GroupID = 1;
                Acc_Account acc = GAccount.GetAccountInfo();
                DeptID = acc.UnitID;
            }
            string strInsertOrder = "insert into UM_Group (GroupID,GroupName,DeptId,Validate) ";

            strInsertOrder += " values ('" + GroupID + "','" + text + "','" + DeptID + "','v') ";
            try
            {
                if (strInsertOrder != "")
                {
                    intInsert = sqlTrans.ExecuteNonQuery(strInsertOrder, CommandType.Text, null);
                }

                sqlTrans.Close(true);
            }
            catch (SqlException e)
            {
                sqlTrans.Close(false);
                a_strErr = e.Message;
                return(-1);
            }

            return(intInsert);
        }
예제 #9
0
        public static bool insertLog(string YYCode, string content)
        {
            tk_Log        log  = null;
            List <tk_Log> list = new List <tk_Log>();

            string[] YYCodes  = YYCode.Split(',');
            string[] Contents = content.Split(',');
            for (int i = 0; i < YYCodes.Length; i++)
            {
                log = new tk_Log()
                {
                    ID      = Convert.ToDecimal(DateTime.Now.ToString("yyyyMMddHHmmss")),
                    LogTime = DateTime.Now,
                    YYCode  = YYCodes[i],
                    Content = Contents[i],
                    Actor   = GAccount.GetAccountInfo().UserName,
                    Unit    = GAccount.GetAccountInfo().UnitName
                };
                list.Add(log);
            }
            string logSql = GSqlSentence.GetInsertByList <tk_Log>(list, "tk_Log");

            return(SQLBase.ExecuteNonQuery(logSql) > 0);
        }
예제 #10
0
        public static int InsertContent(string type, string text, ref string a_strErr)
        {
            int      intInsert  = 0;
            int      intContent = 0;
            SQLTrans sqlTrans   = new SQLTrans();

            sqlTrans.Open("SupplyCnn");
            string      XID      = PreGetTaskNo(type);
            string      strSql   = "select SID,TypeDesc from tk_ConfigContent where Type='" + type + "'";
            DataTable   dt       = SQLBase.FillTable(strSql, "SupplyCnn");
            string      SID      = "";
            string      TypeDesc = "";
            Acc_Account acc      = GAccount.GetAccountInfo();

            if (dt.Rows.Count > 0)
            {
                SID      = dt.Rows[0]["SID"].ToString();
                SID      = SID.Substring(0, SID.Length - 1);
                SID      = SID + (Convert.ToInt32(XID) - 1).ToString();
                TypeDesc = dt.Rows[0]["TypeDesc"].ToString();
            }
            string strInsertOrder = "";
            string strConte       = "";

            //在此处判断
            if (type == "BusinessDistribute")
            {
                strInsertOrder += "insert into tk_BusinessDistribute (XID,SID,Text,Type,TypeDesc,Validate,UnitID) values ('" + XID + "','" + SID + "','" + text + "','" + type + "','" + TypeDesc + "','v','" + acc.UnitID + "')";
                strConte       += "insert into tk_ConfigContent (XID,SID,Text,Type,TypeDesc,Validate,UnitID) values ('" + XID + "','" + SID + "','" + text + "','" + type + "','" + TypeDesc + "','v','" + acc.UnitID + "')";
            }
            else if (type == "BillingWay")
            {
                strInsertOrder += "insert into tk_ConfigBillWay (XID,SID,Text,Type,TypeDesc,Validate,UnitID) values ('" + XID + "','" + SID + "','" + text + "','" + type + "','" + TypeDesc + "','v','" + acc.UnitID + "')";
                strConte       += "insert into tk_ConfigContent (XID,SID,Text,Type,TypeDesc,Validate,UnitID) values ('" + XID + "','" + SID + "','" + text + "','" + type + "','" + TypeDesc + "','v','" + acc.UnitID + "')";
            }
            else if (type == "CPZLZXBZ")
            {
                strInsertOrder += "insert into tk_ConfigQualityStandard (XID,SID,Text,Type,TypeDesc,Validate,UnitID) values ('" + XID + "','" + SID + "','" + text + "','" + type + "','" + TypeDesc + "','v','" + acc.UnitID + "')";
                strConte       += "insert into tk_ConfigContent (XID,SID,Text,Type,TypeDesc,Validate,UnitID) values ('" + XID + "','" + SID + "','" + text + "','" + type + "','" + TypeDesc + "','v','" + acc.UnitID + "')";
            }
            else if (type == "Relation")
            {
                strInsertOrder += "insert into tk_ConfigReation (XID,SID,Text,Type,TypeDesc,Validate,UnitID) values ('" + XID + "','" + SID + "','" + text + "','" + type + "','" + TypeDesc + "','v','" + acc.UnitID + "')";
                strConte       += "insert into tk_ConfigContent (XID,SID,Text,Type,TypeDesc,Validate,UnitID) values ('" + XID + "','" + SID + "','" + text + "','" + type + "','" + TypeDesc + "','v','" + acc.UnitID + "')";
            }
            else if (type == "ScaleType")
            {
                strInsertOrder += "insert into tk_ConfigScalType (XID,SID,Text,Type,TypeDesc,Validate,UnitID) values ('" + XID + "','" + SID + "','" + text + "','" + type + "','" + TypeDesc + "','v','" + acc.UnitID + "')";
                strConte       += "insert into tk_ConfigContent (XID,SID,Text,Type,TypeDesc,Validate,UnitID) values ('" + XID + "','" + SID + "','" + text + "','" + type + "','" + TypeDesc + "','v','" + acc.UnitID + "')";
            }
            else
            {
                strInsertOrder += "insert into tk_ConfigContent (XID,SID,Text,Type,TypeDesc,Validate,UnitID) values ('" + XID + "','" + SID + "','" + text + "','" + type + "','" + TypeDesc + "','v','" + acc.UnitID + "')";
            }
            try
            {
                if (strInsertOrder != "")
                {
                    intInsert = sqlTrans.ExecuteNonQuery(strInsertOrder, CommandType.Text, null);
                }
                if (strConte != "")
                {
                    intContent = sqlTrans.ExecuteNonQuery(strConte, CommandType.Text, null);
                }
                sqlTrans.Close(true);
            }
            catch (SqlException e)
            {
                sqlTrans.Close(false);
                a_strErr = e.Message;
                return(-1);
            }

            return(intInsert + intContent);
        }
예제 #11
0
        public static bool SaveUpdatePlan(tk_Product_Plan record, List <tk_Product_PlanDetail> delist, ref string strErr)
        {
            //SqlTransaction sqltra = con.BeginTransaction();//开始事务

            try
            {
                string         strUpdate = "update BGOI_Produce.dbo.tk_Product_Plan set Specifieddate=@Specifieddate,Plannedmonth=@Plannedmonth," + "Remarks=@Remarks,Formulation=@Formulation where JHID=@JHID";
                SqlParameter[] param     =
                {
                    new SqlParameter("@Specifieddate", SqlDbType.DateTime),
                    new SqlParameter("@Plannedmonth",  SqlDbType.NVarChar),
                    new SqlParameter("@Remarks",       SqlDbType.NVarChar),
                    new SqlParameter("@Formulation",   SqlDbType.NVarChar),
                    new SqlParameter("@JHID",          SqlDbType.NVarChar)
                };
                param[0].Value = Convert.ToDateTime(record.Specifieddate);
                param[1].Value = record.Plannedmonth;
                param[2].Value = record.Remarks == null ? "" : record.Remarks;
                param[3].Value = record.Formulation;
                param[4].Value = record.JHID;


                string InserNewOrdersHIS = "insert into BGOI_Produce.dbo.tk_Product_Plan_HIS (JHID,UnitID,Plannedyear,Plannedmonth,Specifieddate,Formulation,Remarks,State,Approvalstatus,CreateUser,CreateTime,Validate,NCreateTime,NCreateUser)" +
                                           "select JHID,UnitID,Plannedyear,Plannedmonth,Specifieddate,Formulation,Remarks,State,Approvalstatus,CreateUser,CreateTime,Validate,'" + DateTime.Now + "','" + GAccount.GetAccountInfo().UserName + "' from BGOI_Produce.dbo.tk_Product_Plan where JHID ='" + record.JHID + "'";

                int count = 0;

                count = SQLBase.ExecuteNonQuery(InserNewOrdersHIS, "MainProduce");
                if (count <= 0)
                {
                    strErr = "历史记录更新失败";
                    return(false);
                }
                count = SQLBase.ExecuteNonQuery(strUpdate, param, "MainProduce");
                if (count <= 0)
                {
                    strErr = "计划信息更新失败";
                    return(false);
                }



                string strInsertDetailHIS = "insert into BGOI_Produce.dbo.tk_Product_PlanDetail_HIS(JHID,DID,PID,Name,Specifications,Finishedproduct,finishingproduct,Spareparts,notavailable,Total,plannumber,demandnumber,Remarks,CreateUser,CreateTime,Validate,NCreateUser,NCreateTime) select JHID,DID,PID,Name,Specifications,Finishedproduct,finishingproduct,Spareparts,notavailable,Total,plannumber,demandnumber,Remarks,CreateUser,CreateTime,Validate,'" + GAccount.GetAccountInfo().UserName + "','" + DateTime.Now + "'" +
                                            " from BGOI_Produce.dbo.tk_Product_PlanDetail where JHID='" + record.JHID + "'";
                count = SQLBase.ExecuteNonQuery(strInsertDetailHIS, "MainProduce");
                if (count < 0)
                {
                    strErr = "历史记录更新失败";
                    return(false);
                }
                string strDeleteDetail = "delete tk_Product_PlanDetail where JHID='" + record.JHID + "'";
                count = SQLBase.ExecuteNonQuery(strDeleteDetail, "MainProduce");
                if (count < 0)
                {
                    return(false);
                }

                if (delist.Count > 0)
                {
                    string strUpdateList = GSqlSentence.GetInsertByList <tk_Product_PlanDetail>(delist, "tk_Product_PlanDetail");
                    count = SQLBase.ExecuteNonQuery(strUpdateList, "MainProduce");
                    if (count <= 0)
                    {
                        return(false);
                    }
                }

                return(true);
            }
            catch (Exception ex)
            {
                strErr = ex.Message;
                //trans.Close(true);
                return(false);
            }
        }
예제 #12
0
        public static DataTable GetZD()
        {
            string    str = "select distinct a.ProductID,B.ProName,b.Spec,isnull(c.finishCount,0)finishCount,isnull(c.HalfCount,0)HalfCount,isnull(c.OnlineCount,0)OnlineCount,isnull(d.num,0) xdnum,isnull(e.lj,0) lj from tk_ProductionOfFinishedGoods aa left join tk_ProFinishDefine a on aa.PID = A.ProductID left join tk_ProductInfo b on a.ProductID = b.PID left join tk_StockRemain c on a.ProductID = c.ProductID LEFT JOIN (select ProductID ,sum(OrderNum-ShipmentNum)num from BGOI_Sales.dbo.Orders_DetailInfo group by ProductID) d on  a.ProductID = d.ProductID left join (select KSC.ProductID,min(FinishCount/Number)lj from tk_ProFinishDefine KSC LEFT JOIN tk_StockRemain KC ON KSC.PartPID = KC.ProductID  where Number>0  group by KSC.ProductID) e on a.ProductID = e.ProductID where a.ValiDate='v' AND aa.ValiDate ='v' and UnitID ='" + GAccount.GetAccountInfo().UnitID + "'";
            DataTable dt  = SQLBase.FillTable(str, "MainInventory");

            return(dt);
        }
예제 #13
0
        public static OperationAnalysis getOperationAnalysis(int month)
        {
            string            sql = "select top(1) OId, Year, Month, Overview, BusinesAnalysi, BusinesContent, PayableAnalysi, PayableContent, Experience, Other, Unit, CreateUser, CreateTime from OperationAnalysis where year=" + DateTime.Now.ToString("yyyy") + " and Month = " + month + " and unit='" + GAccount.GetAccountInfo().UnitName + "' order by CreateTime";
            OperationAnalysis oa  = new OperationAnalysis();

            GSqlSentence.SetTValueD <OperationAnalysis>(oa, SQLBase.FillTable(sql).Rows[0]);
            return(oa);
        }
예제 #14
0
        /// <summary>
        /// 获取经营任务
        /// </summary>
        /// <param name="month"></param>
        /// <returns></returns>
        public static DataTable GetOperationTask(int month, ref string istask)
        {
            DataTable dt  = null;
            string    sql = "select count(*) from OperationAnalysis where year=" + DateTime.Now.ToString("yyyy") + " and Month = " + month + " and unit='" + GAccount.GetAccountInfo().UnitName + "'";

            if ((int)SQLBase.ExecuteScalar(sql) > 0)
            {
                sql    = "select a.OId,YearTarget, MonthTarget, MonthComplete, Problem, NextMonthTarget, Type, Remark from OperationAnalysis a left join OperationTask b on a.OId=b.OId where year=" + DateTime.Now.ToString("yyyy") + " and Month = " + month + " and unit='" + GAccount.GetAccountInfo().UnitName + "'";
                dt     = SQLBase.FillTable(sql);
                istask = "y";
            }
            else
            {
                sql    = "select YearTarget, MonthTarget,NextMonthTarget, Type from OperationAnalysis a left join OperationTask b on a.OId=b.OId where year=" + DateTime.Now.ToString("yyyy") + " and Month = " + (month - 1) + " and unit='" + GAccount.GetAccountInfo().UnitName + "'";
                dt     = SQLBase.FillTable(sql);
                istask = "n";
            }

            return(dt);
        }
예제 #15
0
        public static bool SaveAccept(string YYCode, string MCode, string AcceptPeople, string type, ref string err)
        {
            string sql = "update  MandateInfo set MCode='" + MCode + "',AcceptPeople='" + AcceptPeople + "',AcceptTime='" + DateTime.Now.ToString() + "',state=1 where YYCode='" + YYCode + "'";

            if (SQLBase.ExecuteNonQuery(sql) > 0)
            {
                if (!UpdateMcode(type, MCode))
                {
                    err = "委托单号更新失败";
                    return(false);
                }
                //sql = "update sampleInfo set sampleCode='" + MCode + ".'+right('00',2-len(convert(varchar(2),serialNumber)))+convert(varchar(2),serialNumber) where YYCode='" + YYCode + "'";
                sql = "select YYCode,Number,serialNumber from SampleInfo where YYCode ='" + YYCode + "' order by serialNumber";
                DataTable dt = SQLBase.FillTable(sql);
                //未完
                int number = 0;
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    string sampleCode = "";
                    if ((int)dt.Rows[i]["Number"] > 1)
                    {
                        string strartStr = (number + 1).ToString();
                        string endStr    = (number + (int)dt.Rows[i]["Number"]).ToString();
                        if (strartStr.Length < 2)
                        {
                            strartStr = "0" + strartStr;
                        }
                        if (endStr.Length < 2)
                        {
                            endStr = "0" + endStr;
                        }
                        sampleCode = MCode + "-" + strartStr + "-" + endStr;
                        number     = Convert.ToInt32(endStr);
                    }
                    else
                    {
                        if ((number + 1).ToString().Length > 2)
                        {
                            sampleCode = MCode + "-" + (number + 1);
                        }
                        else
                        {
                            string result = "00" + (number + 1);
                            sampleCode = MCode + "-" + result.Substring(result.Length - 2, 2);
                        }
                        number += 1;
                    }
                    sql = "update sampleInfo set sampleCode='" + sampleCode + "' where YYCode='" + YYCode + "' and serialNumber=" + dt.Rows[i]["serialNumber"];
                    if (SQLBase.ExecuteNonQuery(sql) <= 0)
                    {
                        err = "样品编号更新失败";
                        return(false);
                    }
                }

                sql = "insert into TaskOrder(MId,CreateTime,CreateUser,state) values('" + MCode + "','" + DateTime.Now.ToString() + "','" + GAccount.GetAccountInfo().UserName + "',9)";
                if (SQLBase.ExecuteNonQuery(sql) > 0)
                {
                    string content = "受理委托单并创建任务单";
                    if (!insertLog(YYCode, content))
                    {
                        err = "日志更新失败";
                        return(false);
                    }
                    return(true);
                }
                else
                {
                    err = "任务单创建失败";
                    return(false);
                }
            }
            err = "受理失败";
            return(false);
        }
예제 #16
0
        public static int UpdatezhunchuApproval(string IsPass, string Opinion, string Remark, string PID, string webkey, string folderBack, string RelevanceID, ref string a_strErr)
        {
            int intInsertBas = 0;
            int intUpdateBas = 0;
            int intLog       = 0;
            int intAllBas    = 0;
            //string strstate = "";
            //int intstate = 0;
            Acc_Account account = GAccount.GetAccountInfo();
            string      UserId  = account.UserID.ToString();

            string[] arr   = folderBack.Split('/');
            int      state = 0;

            if (IsPass == "是")
            {
                state = 1;
            }
            else
            {
                state = -1;
            }
            //BGOI_BasMan/tk_SApproval/tk_SupplierBas/SID/51/55/tk_PID/54/tk_UserLog
            //BGOI_BasMan/tk_SApproval/tk_SupplierBas/SID/23/22/tk_PID/10/tk_UserLog
            //BGOI_BasMan/tk_SApproval/tk_SupplierBas/SID/62/61/tk_PID/29/tk_UserLog 年度
            //BGOI_BasMan/tk_SApproval/tk_SupplierBas/SID/10/73/tk_PID/75/tk_UserLog 恢复供货
            string strInsertBas = "update [" + arr[0] + "].." + arr[1] + " set ApprovalMan = '" + UserId + "',ApprovalTime = '" + DateTime.Now + "',IsPass = '******',Opinion = '" + Opinion + "',"
                                  + "Remark = '" + Remark + "',State = '" + state + "' where PID = '" + PID + "' and ApprovalPersons = '" + UserId + "'";
            string strUpdateBas = "";

            if (state == -1)
            {
                if (arr[2].IndexOf("..") > 0)
                {
                    strUpdateBas = "update " + arr[2] + " set State = '" + arr[7] + "',wstate='1' where " + arr[3] + " = '" + RelevanceID + "'";
                }
                else if (arr[2].IndexOf("..") > 0 && arr[7] == "29")
                {
                    strUpdateBas = "update " + arr[2] + " set nState = '" + arr[7] + "',wstate='1' where " + arr[3] + " = '" + RelevanceID + "'";
                }
                else if (arr[7] == "29")
                {
                    strUpdateBas = "update " + arr[2] + " set nState = '" + arr[7] + "',wstate='1' where " + arr[3] + " = '" + RelevanceID + "'";
                }
                else
                {
                    strUpdateBas = "update [" + arr[0] + "].." + arr[2] + " set State = '" + arr[7] + "',wstate='1' where " + arr[3] + " = '" + RelevanceID + "'";
                }
            }
            string strInsertLog = "insert into [" + arr[0] + "].." + arr[8] + " values ('" + RelevanceID + "','" + webkey + "审批操作','" + webkey + "审批操作成功','" + DateTime.Now + "','" + account.UserName + "','" + webkey + "审批')";

            if (strInsertBas != "")
            {
                intInsertBas = SQLBase.ExecuteNonQuery(strInsertBas, CommandType.Text, null);
            }
            if (strUpdateBas != "")
            {
                intUpdateBas = SQLBase.ExecuteNonQuery(strUpdateBas, CommandType.Text, null);
            }
            if (strInsertLog != "")
            {
                intLog = SQLBase.ExecuteNonQuery(strInsertLog, "SupplyCnn");
            }

            string    str    = "select ApprovalLevel,SUBSTRING(AppType,1,1) as Type,SUBSTRING(AppType,3,1) as num  from [" + arr[0] + "].." + arr[1] + " where PID = '" + PID + "' and state = '0'";
            DataTable dt     = SQLBase.FillTable(str);
            string    Type   = "";
            int       num    = 0;
            int       bol    = 0;
            int       Hcount = 0;

            for (int i = 0; i < dt.Rows.Count; i++)
            {
                Type = dt.Rows[i]["Type"].ToString();
                if (Type == "1")
                {
                    bol = 1;
                    break;
                }
                if (Type == "2")
                {
                    bol = 1;
                    break;
                }
                if (Type == "3")
                {
                    num = Convert.ToInt16(dt.Rows[i]["num"]);
                    string    level = dt.Rows[i]["ApprovalLevel"].ToString();
                    string    str1  = "select count(*) from [" + arr[0] + "].." + arr[1] + " where PID = '" + PID + "' and state = '1' and AppType = '3-" + num + "'";
                    DataTable dt2   = SQLBase.FillTable(str1);
                    if (dt2.Rows.Count > 0)
                    {
                        Hcount = Convert.ToInt16(dt2.Rows[0][0]);
                    }
                    if (Hcount < num)
                    {
                        bol = 1;
                        break;
                    }
                }
            }
            //BGOI_BasMan/tk_SApproval/tk_SupplierBas/SID/23/22/tk_PID/10/tk_UserLog 准出停止
            //BGOI_BasMan/tk_SApproval/tk_SupplierBas/SID/26/25/tk_PID/10/tk_UserLog 准出暂停
            //BGOI_BasMan/tk_SApproval/tk_SupplierBas/SID/29/28/tk_PID/10/tk_UserLog 准出淘汰
            //BGOI_BasMan/tk_SApproval/tk_SupplierBas/SID/62/61/tk_PID/29/tk_UserLog 年度
            //BGOI_BasMan/tk_SApproval/tk_SupplierBas/SID/10/73/tk_PID/75/tk_UserLog 恢复供货
            string strAllBas = "";

            if (bol == 0 && state != -1)
            {
                if (arr[2].IndexOf("..") > 0 && arr[4] == "23")
                {
                    strAllBas = "update " + arr[2] + " set State = '" + arr[4] + "',wstate='3' where " + arr[3] + " = '" + RelevanceID + "'";
                }
                else if (arr[2].IndexOf("..") > 0 && arr[4] == "26")
                {
                    strAllBas = "update " + arr[2] + " set State = '" + arr[4] + "',wstate='2' where " + arr[3] + " = '" + RelevanceID + "'";
                }
                else if (arr[2].IndexOf("..") > 0 && arr[4] == "29")
                {
                    strAllBas = "update " + arr[2] + " set State = '" + arr[4] + "',wstate='4' where " + arr[3] + " = '" + RelevanceID + "'";
                }
                else if (arr[2].IndexOf("..") > 0 && arr[4] == "10")
                {
                    strAllBas = "update " + arr[2] + " set State = '" + arr[4] + "',wstate='1' where " + arr[3] + " = '" + RelevanceID + "'";
                }
                else if (arr[2].IndexOf("..") > 0 && arr[4] == "4")
                {
                    strAllBas = "update " + arr[2] + " set State = '" + arr[4] + "',wstate='0' where " + arr[3] + " = '" + RelevanceID + "'";
                }
                else if (arr[2].IndexOf("..") > 0 && arr[4] == "62")
                {
                    strAllBas = "update " + arr[2] + " set nState = '" + arr[4] + "',wstate='1' where " + arr[3] + " = '" + RelevanceID + "'";
                }
                else if (arr[4] == "23")
                {
                    strAllBas = "update [" + arr[0] + "].." + arr[2] + " set State = '" + arr[4] + "',wstate='3' where " + arr[3] + " = '" + RelevanceID + "'";
                }
                else if (arr[4] == "26")
                {
                    strAllBas = "update [" + arr[0] + "].." + arr[2] + " set State = '" + arr[4] + "',wstate='2' where " + arr[3] + " = '" + RelevanceID + "'";
                }
                else if (arr[4] == "29")
                {
                    strAllBas = "update [" + arr[0] + "].." + arr[2] + " set State = '" + arr[4] + "',wstate='4' where " + arr[3] + " = '" + RelevanceID + "'";
                }
                else if (arr[4] == "10")
                {
                    strAllBas = "update [" + arr[0] + "].." + arr[2] + " set State = '" + arr[4] + "',wstate='1' where " + arr[3] + " = '" + RelevanceID + "'";
                }
                else if (arr[4] == "4")
                {
                    strAllBas = "update [" + arr[0] + "].." + arr[2] + " set State = '" + arr[4] + "',wstate='0' where " + arr[3] + " = '" + RelevanceID + "'";
                }
                else
                {
                    strAllBas = "update [" + arr[0] + "].." + arr[2] + " set nState = '" + arr[4] + "',wstate='1' where " + arr[3] + " = '" + RelevanceID + "'";
                }
            }
            else
            {
                strAllBas = "";
            }
            if (strAllBas != "")
            {
                intAllBas = SQLBase.ExecuteNonQuery(strAllBas, "SupplyCnn");
            }
            return(intInsertBas + intUpdateBas);
        }