コード例 #1
0
        /// <summary>
        /// Populate OH Reason with core attributes (ID, Code, & Description)
        /// Called by all Find overloads and from LoadJobFromWorkOrder in WIS
        /// </summary>
        /// <param name="dtResults"></param>
        /// <returns></returns>
        public static OnHoldReasonCollection Populate(DataTable dtResults, DataTable materialsRequested)
        {
            OnHoldReasonCollection colMembers = null;
            OnHoldReason onHoldReason = null;
            string filterExpression = string.Empty;

            if (dtResults != null && dtResults.Rows.Count > 0)
            {
                colMembers = new OnHoldReasonCollection();
                foreach (DataRow drMember in dtResults.Rows)
                {
                    onHoldReason = new OnHoldReason();
                    onHoldReason.ID = (int)drMember["OnHoldReasonID"];
                    onHoldReason.Code = drMember["OnHoldReasonCode"].ToString();
                    onHoldReason.Description = drMember["OnHoldReasonDesc"].ToString();
                    if (dtResults.Columns.Contains("WMSourceSystem") &&
                        !drMember["WMSourceSystem"].Equals(DBNull.Value))
                    {
                        onHoldReason.SourceSystem = (eWMSourceSystem)Enum.Parse(typeof(eWMSourceSystem), drMember["WMSourceSystem"].ToString());
                    }
                    if (dtResults.Columns.Contains("Comments") &&
                        !drMember["Comments"].Equals(DBNull.Value))
                    {
                        System.Xml.XmlDocument objDOM = new System.Xml.XmlDocument();
                        objDOM.LoadXml(drMember["Comments"].ToString());
                        onHoldReason.Comments = (CommentAuditRecordCollection)BusinessObjects.Base.Deserialize(typeof(CommentAuditRecordCollection), objDOM);
                    }

                    if (materialsRequested != null && onHoldReason.Code.ToUpper() == "MAT")
                    {
                        onHoldReason.MaterialsRequired = MaterialCollection.Populate(materialsRequested);
                    }
               
                    if (!drMember["DateResolved"].Equals(DBNull.Value))
                    {
                        DateTime dateResolved = (DateTime)drMember["DateResolved"];
                        if (dateResolved != DateTime.MinValue)
                        {
                            onHoldReason.DateResolved = dateResolved;
                        }
                    }

                    colMembers.Add(onHoldReason);
                }
            }

            return colMembers;
        }
コード例 #2
0
        public static OnHoldReasonCollection FindByJob(int jobID)
        {
            OnHoldReasonCollection colMembers = new OnHoldReasonCollection();
            OnHoldReason onHoldReason = null;

            DataAccess objADO = new DataAccess(); // TaskStore database
            DataTable dtResults = null;
            ArrayList colParameters = new ArrayList();
            string strStoredProcedure = "selJobOnHoldDetails";

            colParameters.Add(new SqlParameter("@WMSourceID", jobID));
            dtResults = objADO.GetDataTable(strStoredProcedure, "OnHoldReasons", (SqlParameter[])colParameters.ToArray(typeof(SqlParameter)));
            objADO = null;

            if (dtResults != null && dtResults.Rows.Count > 0)
            {
                foreach (DataRow drMember in dtResults.Rows)
                {
                    onHoldReason = new OnHoldReason();
                    onHoldReason.ID = (int)drMember["OnHoldReasonID"];
                    onHoldReason.Code = drMember["OnHoldReasonCode"].ToString();
                    onHoldReason.Description = drMember["OnHoldReasonDesc"].ToString();

                    // Note. Additional columns expected in this method to other Find methods
                    if (!drMember["DateResolved"].Equals(DBNull.Value))
                    {
                        onHoldReason.DateResolved = (DateTime)drMember["DateResolved"];
                    }
                    if (!drMember["ResolvingUser"].Equals(DBNull.Value))
                    {
                        onHoldReason.ResolvingUser = drMember["ResolvingUser"].ToString();
                    }
                    if (!drMember["Comments"].Equals(DBNull.Value))
                    {
                        System.Xml.XmlDocument objDOM = new System.Xml.XmlDocument();
                        objDOM.LoadXml(drMember["Comments"].ToString());
                        onHoldReason.Comments = (CommentAuditRecordCollection)BusinessObjects.Base.Deserialize(typeof(CommentAuditRecordCollection), objDOM);
                    }

                    colMembers.Add(onHoldReason);
                }
            }

            return colMembers;
        }