Exemple #1
0
        public Impr1 Get_Impr1_List(Impr request)
        {
            Impr1 Result = null;

            try
            {
                using (var db = DbConnectionFactory.OpenDbConnection())
                {
                    Result = null;                                                                                                                                            //db.QuerySingle<Impr1>(strSql);
                }
            }
            catch { throw; }
            return(Result);
        }
        public Impr1 Get_Impr1_Single(Impr request)
        {
            Impr1 Result = null;

            try
            {
                using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
                {
                    List <Impa1> impa1           = db.Select <Impa1>("Select * from Impa1");
                    string       strBarCodeFiled = impa1[0].BarCodeField;
                    string       strSql          = "Select * From Impr1 Where IsNull(ProductCode,'')<>'' And IsNull(StatusCode,'')<>'DEL' And " + strBarCodeFiled + "='" + request.BarCode + "'";
                    Result = db.QuerySingle <Impr1>(strSql);
                }
            }
            catch { throw; }
            return(Result);
        }
Exemple #3
0
        public Impr1 Get_Impr1_Single(Impr request)
        {
            Impr1 Result = null;

            try
            {
                using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
                {
                    List <Impa1> impa1           = db.Select <Impa1>("Select * from Impa1");
                    string       strBarCodeFiled = impa1[0].BarCodeField;
                    string[]     strBarCodeList  = strBarCodeFiled.Split(',');
                    if (strBarCodeList.Length <= 1)
                    {
                        string strSql = "Select * From Impr1 Where IsNull(ProductCode,'')<>'' And IsNull(StatusCode,'')<>'DEL' And " + strBarCodeFiled + "='" + Modfunction.SQLSafe(request.BarCode) + "'";
                        Result = db.QuerySingle <Impr1>(strSql);
                    }
                    else
                    {
                        string strBarCodeFilter = "";
                        for (int i = 0; i < strBarCodeList.Length; i++)
                        {
                            if (strBarCodeFilter == "")
                            {
                                strBarCodeFilter = strBarCodeList[i] + "='" + Modfunction.SQLSafe(request.BarCode) + "'";
                            }
                            else
                            {
                                strBarCodeFilter = strBarCodeFilter + " OR " + strBarCodeList[i] + "='" + Modfunction.SQLSafe(request.BarCode) + "'";
                            }
                        }
                        if (strBarCodeFilter != "")
                        {
                            string strSql = "Select * From Impr1 Where IsNull(ProductCode,'')<>'' And IsNull(StatusCode,'')<>'DEL' And (" + strBarCodeFilter + ")";
                            Result = db.QuerySingle <Impr1>(strSql);
                        }
                        else
                        {
                            string strSql = "Select top 0 * From Impr1 ";
                            Result = db.QuerySingle <Impr1>(strSql);
                        }
                    }
                }
            }
            catch { throw; }
            return(Result);
        }
        public object Get_Impr1(Impr request)
        {
            object Result = null;

            try
            {
                if (!string.IsNullOrEmpty(request.ProductCode))
                {
                    Result = Get_Impr1_List(request);
                }
                else
                {
                    Result = Get_Impr1_Single(request);
                }
            }
            catch { throw; }
            return(Result);
        }
        public List <Impr1> Get_Impr1_List(Impr request)
        {
            List <Impr1> Result = null;

            try
            {
                using (var db = DbConnectionFactory.OpenDbConnection("WMS"))
                {
                    string strSql = "Select Top 10 " +
                                    "Impr1.TrxNo, IsNull(Impr1.ProductCode,'') AS ProductCode," +
                                    "IsNull(Impr1.ProductName,'') AS ProductName, IsNull(Impr1.SerialNoFlag,'') AS SerialNoFlag," +
                                    "IsNull(Impr1.UserDefine01,'') AS UserDefine01, Impr1.StatusCode " +
                                    "From Impr1 Where IsNull(Impr1.StatusCode,'')='USE' And IsNull(Impr1.ProductCode,'') LIKE '" + request.ProductCode + "%' " +
                                    "Order By ProductCode ASC";
                    Result = db.Select <Impr1>(strSql);
                }
            }
            catch { throw; }
            return(Result);
        }