Beispiel #1
0
        public bool GetProdDetailByProdOrdID(ProdHead model, ref ProdHead prod, ref string strError)
        {
            ReadAPI_DB DB = new ReadAPI_DB();

            try
            {
                string prodmgrID = string.Empty;
                using (SqlDataReader dr = DB.ReadData(ReadApiType.PRODBOOK_1, model.ProdOrdID))
                {
                    if (dr.Read())
                    {
                        prodmgrID = dr["ProdMgrID"].ToDBString();
                    }
                }
                if (string.IsNullOrEmpty(prodmgrID))
                {
                    strError = "该订单暂无制法数据";
                    return(false);
                }
                using (SqlDataReader dr = DB.ReadData(ReadApiType.PROD, model.ProdOrdID))
                {
                    while (dr.Read())
                    {
                        if (prod == null)
                        {
                            prod            = (GetHeadModelFromDataReader(dr, prodmgrID));
                            prod.lstDetails = new List <ProdDetails>();
                        }
                        prod.lstDetails.Add(GetModelFromDataReader(dr));
                    }
                    if (prod == null)
                    {
                        throw new Exception("未找到数据!");
                    }
                    return(true);
                }
            }
            catch (Exception ex)
            {
                strError = ex.Message;
                return(false);
            }
            finally
            {
            }
        }
Beispiel #2
0
        public string GetReceiptByPoNbr(string strPoNo, string strUserJson)
        {
            ReadAPI_DB  DB       = new ReadAPI_DB();
            ReceiptHead model    = null;
            bool        bSucc    = false;
            string      strError = string.Empty;

            try
            {
                UserInfo user = JSONUtil.JSONHelper.JsonToObject <UserInfo>(strUserJson);
                using (SqlDataReader dr = DB.ReadData(ReadApiType.RECEIPT, strPoNo))
                {
                    while (dr.Read())
                    {
                        if (model == null)
                        {
                            model            = (GetHeadModelFromDataReader(dr));
                            model.lstDetails = new List <ReceiptDetails>();
                        }
                        model.lstDetails.Add(GetModelFromDataReader(dr));
                    }
                    if (model == null)
                    {
                        throw new Exception("未找到数据!");
                    }
                    bSucc = true;
                    return(GetReturnJson(bSucc, model, strError));
                }
            }
            catch (Exception ex)
            {
                strError = ex.Message;
                bSucc    = false;
                model    = new ReceiptHead();
                return(GetReturnJson(bSucc, model, strError));
            }
            finally
            {
            }
        }
Beispiel #3
0
        public string GetTransferTo01(string strMaterialNo, string strBatchNo, string startDate, string endDate, string strUserJson)
        {
            ReadAPI_DB DB       = new ReadAPI_DB();
            Transfer   model    = null;
            bool       bSucc    = false;
            string     strError = string.Empty;

            try
            {
                UserInfo user = JSONUtil.JSONHelper.JsonToObject <UserInfo>(strUserJson);
                using (SqlDataReader dr = DB.ReadData(ReadApiType.TRANSFER_TO01, strMaterialNo, strBatchNo, startDate, endDate))
                {
                    while (dr.Read())
                    {
                        if (model == null)
                        {
                            model = (GetModelFromDataReader(dr));
                        }
                    }
                    if (model == null)
                    {
                        throw new Exception("未找到数据!");
                    }
                    bSucc = true;
                    return(GetReturnJson(bSucc, model, strError));
                }
            }
            catch (Exception ex)
            {
                strError = ex.Message;
                bSucc    = false;
                model    = new Transfer();
                return(GetReturnJson(bSucc, model, strError));
            }
            finally
            {
            }
        }
Beispiel #4
0
        public bool GetInventoryByInvtID(ref Inventory model, ref string strError)
        {
            ReadAPI_DB DB = new ReadAPI_DB();

            try
            {
                using (SqlDataReader dr = DB.ReadData(ReadApiType.INVENTORY, model.InvtID))
                {
                    if (dr.Read())
                    {
                        model = (GetModelFromDataReader(dr));
                    }
                    return(true);
                }
            }
            catch (Exception ex)
            {
                strError = ex.Message;
                return(false);
            }
            finally
            {
            }
        }