Example #1
0
        /// <summary>
        /// 查询分拣线信息表上报
        /// </summary>
        public string FindIdpsSorting()
        {
            string tag = "上报分拣线信息表成功!";

            using (PersistentManager dbpm = new PersistentManager("ZYDB2Connection"))
            {
                UploadDao dao = new UploadDao();
                dao.SetPersistentManager(dbpm);
                DataTable sortingTable = this.QueryIdpsSorting();
                if (sortingTable.Rows.Count > 0)
                {
                    try
                    {
                        dbpm.BeginTransaction();
                        dao.InsertIdpsSorting(sortingTable);
                        this.UpdateSorting("");
                        dbpm.Commit();
                    }
                    catch (Exception exp)
                    {
                        dbpm.Rollback();
                        throw new Exception(exp.Message);
                    }
                }
                else
                {
                    tag = "没有新的分拣线信息表要上报!";
                }
            }
            return(tag);
        }