Ejemplo n.º 1
0
        public DataSet GettMatchPlateDtl()
        {
            ValidateUser();
            QueryObject query1 = GetQueryObject("RF_OldTrayNOGoods");

            if (query1 == null)
            {
                throw new RFException("查询对象[RF_OldTrayNOGoods]不存在");
            }
            DataSet ds = Bss_Helper.GetDataSet_SQL(query1.Sql, paras.Values.ToArray());

            ds.Tables[0].TableName = "Master";
            QueryObject query2 = GetQueryObject("RF_NewTrayGoods");

            if (query2 == null)
            {
                throw new RFException("查询对象[RF_NewTrayGoods]不存在");
            }
            DataSet   ds2 = Bss_Helper.GetDataSet_SQL(query2.Sql, paras.Values.ToArray());
            DataTable dt  = ds2.Tables[0];

            dt.TableName = "Detail";
            ds.Tables.Add(dt.Copy());
            return(ds);
        }
Ejemplo n.º 2
0
        public DataTable QueryStore()
        {
            QueryObject query = GetQueryObject("SelPostion1");

            if (query == null)
            {
                throw new RFException("查询对象[SelPostion1]不存在");
            }
            DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray());

            return(ds.Tables[0]);
        }
Ejemplo n.º 3
0
        public DataTable GetUserInvTask()
        {
            QueryObject query = GetQueryObject("RF_StockSearch");

            if (query == null)
            {
                throw new RFException("查询对象[RF_StockSearch]不存在");
            }
            DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray());

            return(ds.Tables[0]);
        }
Ejemplo n.º 4
0
        /// <summary>
        /// 查询模块列表
        /// </summary>
        /// <returns></returns>
        public DataTable GetModuleList()
        {
            QueryObject query = GetQueryObject("RF_Menu");

            if (query == null)
            {
                throw new RFException("查询对象[RF_Menu]不存在");
            }
            DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray());

            return(ds.Tables[0]);
        }
Ejemplo n.º 5
0
        public DataTable QueryGoods()
        {
            ValidateUser();
            QueryObject query = GetQueryObject("RF_LocationGoods");

            if (query == null)
            {
                throw new RFException("查询对象[RF_LocationGoods]不存在");
            }
            DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray());

            return(ds.Tables[0]);
        }
Ejemplo n.º 6
0
        public DataTable QueryCS2AcptQty2()
        {
            //ValidateUser();
            QueryObject query = GetQueryObject("RF_SelCS2AcptGoods2");

            if (query == null)
            {
                throw new RFException("查询对象[RF_SelCS2AcptGoods2]不存在");
            }
            DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray());

            return(ds.Tables[0]);
        }
Ejemplo n.º 7
0
        public DataTable RF_CS2TrayType()
        {
            //ValidateUser();
            QueryObject query = GetQueryObject("RF_CS2TrayType");

            if (query == null)
            {
                throw new RFException("查询对象[RF_CS2TrayType]不存在");
            }
            DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray());

            return(ds.Tables[0]);
        }
Ejemplo n.º 8
0
        public DataTable RFGoodsQuery(string RFGoodsQuery)
        {
            ValidateUser();
            QueryObject query = GetQueryObject(RFGoodsQuery);

            if (query == null)
            {
                throw new RFException("查询对象[" + RFGoodsQuery + "]不存在");
            }
            DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray());

            return(ds.Tables[0]);
        }
Ejemplo n.º 9
0
        public DataTable GetPaperInfo()
        {
            ValidateUser();
            QueryObject query = GetQueryObject("GetStorebyPaperNO");

            if (query == null)
            {
                throw new RFException("查询对象[GetStorebyPaperNO]不存在");
            }
            DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray());

            return(ds.Tables[0]);
        }
Ejemplo n.º 10
0
        public DataTable Execute(string StdQueryName)
        {
            ValidateUser();
            QueryObject query = GetQueryObject(StdQueryName);

            if (query == null)
            {
                throw new RFException("查询对象[" + StdQueryName + "]不存在");
            }
            DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray());

            return(ds.Tables[0]);
        }
Ejemplo n.º 11
0
        public DataTable ValidatPaperNO()
        {
            ValidateUser();
            QueryObject query = GetQueryObject("RF_TPShelvesVerify");

            if (query == null)
            {
                throw new RFException("查询对象[RF_TPShelvesVerify]不存在");
            }
            DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray());

            return(ds.Tables[0]);
        }
Ejemplo n.º 12
0
        public DataTable GetRF_Assignment()
        {
            ValidateUser();
            QueryObject query = GetQueryObject("RF_Assignment");

            if (query == null)
            {
                throw new RFException("查询对象[RF_Assignment]不存在");
            }
            DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray());

            if (ds != null && ds.Tables.Count > 0)
            {
                return(ds.Tables[0]);
            }
            else
            {
                return(null);
            }
        }
Ejemplo n.º 13
0
        public string GetBatchBuildTypeID()
        {
            //ValidateUser();
            QueryObject query = GetQueryObject("RF_GetBatchBuildType");

            if (query == null)
            {
                throw new RFException("查询对象[RF_GetBatchBuildType]不存在");
            }
            DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray());

            if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
            {
                return(ds.Tables[0].Rows[0][0].ToString());
            }
            else
            {
                return("1");
            }
        }
Ejemplo n.º 14
0
        /// <summary>
        /// 登录验证
        /// </summary>
        /// <param name="user_id"></param>
        /// <param name="password"></param>
        /// <param name="user_name"></param>
        /// <param name="token"></param>
        /// <returns></returns>
        public bool Login(string user_id, string password, ref string user_name, ref string token)
        {
            SetParameter("UserNO", user_id);
            //SetParameter("Password", EncryptPwd(password));
            SetParameter("Password", password);
            QueryObject query = GetQueryObject("RF_Login");

            if (query == null)
            {
                throw new RFException("查询对象[RF_Login]不存在");
            }
            paras.Remove("LocalStoreNO");
            DataSet ds = Bss_Helper.GetDataSet_SQL(query.Sql, paras.Values.ToArray());

            if (ds.Tables[0].Rows.Count == 0)
            {
                return(false);
            }

            user_name           = ds.Tables[0].Rows[0]["OperName"].ToString();
            RFBase.LocalStoreNO = ds.Tables[0].Rows[0]["LocalStoreNO"].ToString();
            token = RFService.Instance.UserRegist(user_id);
            return(true);
        }